AT STYLE
Материал из GedeminWiki
(Различия между версиями)
SYSDBA (обсуждение | вклад) |
SYSDBA (обсуждение | вклад) |
||
| Строка 4: | Строка 4: | ||
id dintkey, | id dintkey, | ||
objectkey dintkey, | objectkey dintkey, | ||
| − | + | propid dinteger_notnull, | |
intvalue dinteger, | intvalue dinteger, | ||
strvalue dtext60, | 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 )