https://www.gsbelarus.com/gs/wiki/index.php?action=history&feed=atom&title=AC_AUTOENTRY 2026-05-14T09:52:08Z История изменений этой страницы в вики MediaWiki 1.19.16 https://www.gsbelarus.com/gs/wiki/index.php?title=AC_AUTOENTRY&diff=5658&oldid=prev 2013-06-08T13:13:23Z

<p>Новая страница: «&lt;syntaxhighlight lang=&quot;SQL&quot;&gt; CREATE TABLE AC_AUTOENTRY ( ID DINTKEY NOT NULL, ENTRYKEY DINTKEY NOT NULL, TRRECORDKEY DINTKEY NOT NUL…»</p> <p><b>Новая страница</b></p><div>&lt;syntaxhighlight lang=&quot;SQL&quot;&gt;<br /> CREATE TABLE AC_AUTOENTRY (<br /> ID DINTKEY NOT NULL,<br /> ENTRYKEY DINTKEY NOT NULL,<br /> TRRECORDKEY DINTKEY NOT NULL,<br /> BEGINDATE DDATE_NOTNULL NOT NULL,<br /> ENDDATE DDATE_NOTNULL NOT NULL,<br /> CREDITACCOUNT DINTKEY NOT NULL,<br /> DEBITACCOUNT DINTKEY NOT NULL,<br /> EDITIONDATE DEDITIONDATE<br /> );<br /> <br /> ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT PK_AC_AUTOENTRY<br /> PRIMARY KEY (ID);<br /> ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_CREDIT<br /> FOREIGN KEY (CREDITACCOUNT) REFERENCES AC_ACCOUNT (ID);<br /> ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_DEBIT<br /> FOREIGN KEY (DEBITACCOUNT) REFERENCES AC_ACCOUNT (ID);<br /> ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_ENTRYKEY<br /> FOREIGN KEY (ENTRYKEY) REFERENCES AC_ENTRY (ID) ON DELETE CASCADE;<br /> ALTER TABLE AC_AUTOENTRY ADD CONSTRAINT FK_AC_AUTOENTRY_TRRECORDKEY<br /> FOREIGN KEY (TRRECORDKEY) REFERENCES AC_TRRECORD (ID) ON DELETE CASCADE;<br /> &lt;/syntaxhighlight&gt;<br /> <br /> [[Category:База данных]]</div>

SYSDBA