AC AUTOTRRECORD
Материал из GedeminWiki
CREATE TABLE AC_AUTOTRRECORD ( ID DINTKEY, SHOWINEXPLORER DBOOLEAN, IMAGEINDEX DINTEGER, FOLDERKEY DFOREIGNKEY ); ALTER TABLE AC_AUTOTRRECORD ADD PRIMARY KEY (ID); ALTER TABLE AC_AUTOTRRECORD ADD CONSTRAINT FK_AC_AUTOTRRECORD_FOLDER FOREIGN KEY (FOLDERKEY) REFERENCES GD_COMMAND (ID) ON DELETE SET NULL ON UPDATE SET NULL; ALTER TABLE AC_AUTOTRRECORD ADD CONSTRAINT FK_AC_AUTOTRRECORD_ID FOREIGN KEY (ID) REFERENCES AC_TRRECORD (ID) ON DELETE CASCADE ON UPDATE CASCADE;