GD LASTNUMBER
Материал из GedeminWiki
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;