(PRIMARY KEY) ............................................................... 118 Ограничение уникальности (UNIQUE) ........................................................ 118 Внешний ключ (FOREIGN KEY) . NOT NULL, CONTACT_FIRST VARCHAR(15), CONTACT_LAST VARCHAR(20), ... Типы данных 31 PRIMARY KEY (CUST_NO) ); BIGINT BIGINT — это SQL-99-совместимый 64 битный Пример 2.1. Использование типа BIGINT CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); Шестнадцатеричный формат для целых чисел Начиная с Firebird 2.5

CUSTOMER VARCHAR(25) NOT NULL, CONTACT_FIRST VARCHAR(15), CONTACT_LAST VARCHAR(20), ... PRIMARY KEY (CUST_NO) ) 3.1.3. BIGINT BIGINT is an SQL:99-compliant 64-bit integer data type, available only Elements. Examples Using Integer Types CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832, collations (“_CI”), one character in the index will occupy not 4, but 6 (six) bytes, so the maximum key length for a page of — for example — 4,096 bytes, will be 169 characters. See also CREATE DATABASE

CUSTOMER VARCHAR(25) NOT NULL, CONTACT_FIRST VARCHAR(15), CONTACT_LAST VARCHAR(20), ... PRIMARY KEY (CUST_NO) ) 3.1.3. BIGINT BIGINT ist ein SQL:99-kompatibler 64-Bit-Integer-Datentyp, der nur in Dialect beschrieben. Beispiele mit Integer-Typen CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832, Datentyp außer BLOB und ARRAY haben. Beispiel CREATE TABLE SAMPLE_ARR ( ID INTEGER NOT NULL PRIMARY KEY, ARR_INT INTEGER [4] ); In diesem Beispiel wird eine Tabelle mit einem Feld vom Typ Array erstellt

335544338 from_no_match No match for first value expression 100 335544354 no_record Invalid database key 100 335544367 segstr_eof Attempted retrieval of more segments than exist 100 335544374 stream_eof page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small Log partition size too small -243 335544500 no_wal Database does not use Write-ahead Log -257 335544566 log_redef Log redefined Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -261 335544695 partition_not_supp Partitions not supported in series of log file specification -261 335544696 log_length_spec

335544338 from_no_match No match for first value expression 100 335544354 no_record Invalid database key 100 335544367 segstr_eof Attempted retrieval of more segments than exist 100 335544374 stream_eof page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small Log partition size too small -243 335544500 no_wal Database does not use Write-ahead Log -257 335544566 -260 335544690 cache_redef Cache redefined -260 335544692 log_redef Log redefined -261 335544695 partition_not_supp Partitions not supported in series of log file specification -261 335544696 log_length_spec

at the end of this chapter. Registry Key A Registry key is added and all Firebird 2.1-compliant applications should use this key if they need to read a Registry key to locate the correct version of Firebird that they wish to use. The new key is: HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird Server\Instances Firebird will guarantee that one entry under this key always exists. It will be known uninstall routine (run from Add/Remove Programs in the Control Panel) preserves and renames the following key files: preserves security2.fdb or renames it to security2.fbnnnn preserves firebird.log

файловой системы. Имейте в виду, что Вы не сможете исполь- зовать «чистые» разделы диска (raw disk partition, разделы без файловой системы) для хранения Ваших баз данных. Важное замечание: СУБД MS SQL использует нескольких записей в подчиненную таблицу). CREATE TABLE my_table ( my_number integer not null primary key ) CREATE GENERATOR my_generator CREATE TRIGGER my_before_trigger FOR my_table BEFORE INSERT AS BEGIN хранимых процедур и триггеров, и вместе с тем исключается явная декларация ссылочной целостности (foreign key). В свою очередь, такое поведение делает ссылочную целостность неявной вместо наличия явно декларируемой

Types and Subtypes 25 CONTACT_FIRST VARCHAR(15), CONTACT_LAST VARCHAR(20), ... PRIMARY KEY (CUST_NO) ) 3.1.3. BIGINT BIGINT is an SQL:99-compliant 64-bit integer data type, available only Elements. Examples Using Integer Types CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832, collations (“_CI”), one character in the index will occupy not 4, but 6 (six) bytes, so the maximum key length for a page of — for example — 4,096 bytes, will be 169 characters. See also CREATE DATABASE

the backups are stored in a separate location to the server they are required on. • Backup to a partition or disc that has encryption enabled. • Make sure that only authorised staff have access to areas password for the remote firebird user on server tuxrep, assuming that you don’t have a proper SSH key-pair already set up and active. The command will replace the local database according to the alias

affects all Firebird versions up to and including 2.0.3. The only known workaround is to mount the partition in question with the sync option — or upgrade to Firebird 2.0.4 or higher. Other Unices don't seem