AT STYLE
Материал из GedeminWiki
(Различия между версиями)
SYSDBA (обсуждение | вклад) (Новая страница: « <syntaxhighlight lang="SQL"> CREATE TABLE at_style ( objtype dinteger_notnull -- тип объекта. 0 -- тип данных, 1 -- домен, 2 -…») |
SYSDBA (обсуждение | вклад) |
||
| (не показана 1 промежуточная версия 1 участника) | |||
| Строка 2: | Строка 2: | ||
<syntaxhighlight lang="SQL"> | <syntaxhighlight lang="SQL"> | ||
CREATE TABLE at_style ( | CREATE TABLE at_style ( | ||
| − | + | id dintkey, | |
| − | + | objectkey dintkey, | |
| − | + | propid dinteger_notnull, | |
| − | intvalue | + | intvalue dinteger, |
| − | strvalue | + | strvalue dtext60, |
| − | userkey dforeignkey | + | userkey dforeignkey, |
| − | themekey dforeignkey | + | themekey dforeignkey, |
| + | |||
| + | CONSTRAINT at_pk_style PRIMARY KEY (id), | ||
| + | CONSTRAINT at_fk_style_uk FOREIGN KEY (userkey) | ||
| + | REFERENCES gd_user (id) | ||
| + | ON UPDATE CASCADE | ||
| + | ON DELETE CASCADE, | ||
| + | CONSTRAINT at_fk_style_tk FOREIGN KEY (themekey) | ||
| + | REFERENCES at_theme (id) | ||
| + | ON UPDATE CASCADE | ||
| + | ON DELETE CASCADE, | ||
| + | CONSTRAINT at_fk_style_ok FOREIGN KEY (objectkey) | ||
| + | REFERENCES at_style_object (id) | ||
| + | ON UPDATE CASCADE | ||
| + | ON DELETE CASCADE | ||
) | ) | ||
</syntaxhighlight> | </syntaxhighlight> | ||
[[Category:База данных]] | [[Category:База данных]] | ||
Текущая версия на 11:47, 22 февраля 2016
CREATE TABLE at_style ( id dintkey, objectkey dintkey, propid dinteger_notnull, intvalue dinteger, strvalue dtext60, userkey dforeignkey, themekey dforeignkey, CONSTRAINT at_pk_style PRIMARY KEY (id), CONSTRAINT at_fk_style_uk FOREIGN KEY (userkey) REFERENCES gd_user (id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT at_fk_style_tk FOREIGN KEY (themekey) REFERENCES at_theme (id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT at_fk_style_ok FOREIGN KEY (objectkey) REFERENCES at_style_object (id) ON UPDATE CASCADE ON DELETE CASCADE )