AC ACCT CONFIG
Материал из GedeminWiki
CREATE TABLE AC_ACCT_CONFIG ( ID DINTKEY, NAME DTEXT32 NOT NULL, CLASSNAME DTEXT60 NOT NULL, CONFIG DBLOB, SHOWINEXPLORER DBOOLEAN, FOLDER DFOREIGNKEY, IMAGEINDEX DINTEGER, EDITIONDATE DEDITIONDATE ); ALTER TABLE AC_ACCT_CONFIG ADD CONSTRAINT PK_AC_ACCT_CONFIG_ID PRIMARY KEY (ID); ALTER TABLE AC_ACCT_CONFIG ADD CONSTRAINT FK_AC_ACCT_CONFIG_FOLDER FOREIGN KEY (FOLDER) REFERENCES GD_COMMAND (ID) ON DELETE SET NULL ON UPDATE CASCADE;