GD LASTNUMBER

 CREATE TABLE gd_lastnumber
 (
   documenttypekey       dintkey,
   ourcompanykey         dintkey,

   lastnumber            dinteger, /* Ïîñëåäíèé íîìåð */
   addnumber             dinteger, /* Óâåëèâàòü íà */
   mask                  dtext80,  /* ìàñêà */
   fixlength             dfixlength, /* ôèêñèðîâàííàÿ äëèíà íîìåðà */

   disabled              dboolean DEFAULT 0
 );

 ALTER TABLE gd_lastnumber ADD CONSTRAINT gd_pk_lastnumber
   PRIMARY KEY (documenttypekey, ourcompanykey);

 ALTER TABLE gd_lastnumber ADD CONSTRAINT gd_fk_ln_documenttypekey
   FOREIGN KEY (documenttypekey) REFERENCES gd_documenttype(id)
   ON DELETE CASCADE
   ON UPDATE CASCADE;

 ALTER TABLE gd_lastnumber ADD CONSTRAINT gd_fk_ln_ourcompanykey
   FOREIGN KEY (ourcompanykey) REFERENCES gd_ourcompany(companykey)
   ON DELETE CASCADE
   ON UPDATE CASCADE;