Difference between revisions of "Database Table: s2stylelayers2"
From Dreamwidth Notes
(Created page with 's2stylelayers =Definition= <source lang="sql"> CREATE TABLE s2stylelayers ( styleid INT UNSIGNED NOT NULL, type ENUM('core','i18nc','layout',...') |
|||
Line 1: | Line 1: | ||
− | [[Category: Database Table| | + | [[Category: Database Table|s2stylelayers2]] |
=Definition= | =Definition= | ||
<source lang="sql"> | <source lang="sql"> | ||
− | CREATE TABLE | + | CREATE TABLE s2stylelayers2 |
( | ( | ||
+ | userid INT UNSIGNED NOT NULL, | ||
styleid INT UNSIGNED NOT NULL, | styleid INT UNSIGNED NOT NULL, | ||
type ENUM('core','i18nc','layout','theme','i18n','user') NOT NULL, | type ENUM('core','i18nc','layout','theme','i18n','user') NOT NULL, | ||
− | + | PRIMARY KEY (userid, styleid, type), | |
s2lid INT UNSIGNED NOT NULL | s2lid INT UNSIGNED NOT NULL | ||
) | ) | ||
Line 14: | Line 15: | ||
=Location= | =Location= | ||
− | [[ | + | [[Clustered database]] |
Revision as of 17:54, 22 March 2009
Definition
CREATE TABLE s2stylelayers2 ( userid INT UNSIGNED NOT NULL, styleid INT UNSIGNED NOT NULL, TYPE ENUM('core','i18nc','layout','theme','i18n','user') NOT NULL, PRIMARY KEY (userid, styleid, TYPE), s2lid INT UNSIGNED NOT NULL )