https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=USR%24BRD_AGEDOC
USR$BRD AGEDOC - История изменений
2026-07-17T02:31:10Z
История изменений этой страницы в вики
MediaWiki 1.19.16
https://gsbelarus.com:80/gs/wiki/index.php?title=USR$BRD_AGEDOC&diff=4160&oldid=prev
Flake: Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_AGEDOC ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, USR$DEPTKEY USR$BRD_DEPTKEY, /* под…»
2011-02-07T14:45:31Z
<p>Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE USR$BRD_AGEDOC ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, USR$DEPTKEY USR$BRD_DEPTKEY, /* под…»</p>
<p><b>Новая страница</b></p><div><syntaxhighlight lang="SQL"><br />
CREATE TABLE USR$BRD_AGEDOC <br />
(<br />
DOCUMENTKEY DINTKEY NOT NULL,<br />
RESERVED DINTEGER,<br />
USR$DEPTKEY USR$BRD_DEPTKEY, /* подразделение */<br />
USR$PRICEKEY USR$BRD_D_PRICEKEY, /* прайс-лист */<br />
PRIMARY KEY (DOCUMENTKEY)<br />
);<br />
<br />
ALTER TABLE USR$BRD_AGEDOC ADD CONSTRAINT USR$FKBRD_AGEDOC1505 <br />
FOREIGN KEY (USR$DEPTKEY) REFERENCES GD_CONTACT (ID) <br />
ON UPDATE CASCADE;<br />
<br />
ALTER TABLE USR$BRD_AGEDOC ADD CONSTRAINT USR$FKBRD_AGEDOC1511 <br />
FOREIGN KEY (USR$PRICEKEY) REFERENCES INV_PRICE (DOCUMENTKEY) <br />
ON UPDATE CASCADE;<br />
<br />
ALTER TABLE USR$BRD_AGEDOC ADD CONSTRAINT USR$FKUSR$BRD_AGEDOC_DK <br />
FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) <br />
ON UPDATE CASCADE <br />
ON DELETE CASCADE;<br />
<br />
</syntaxhighlight><br />
<br />
[[Category:База данных]]</div>
Flake