Difference between revisions of "Database Table: logproplist"
From Dreamwidth Notes
(Created page with 'logproplist =Definition= <source lang="sql"> CREATE TABLE logproplist ( propid tinyint(3) unsigned NOT NULL auto_increment, name varchar(50) defa...') |
m |
||
| Line 1: | Line 1: | ||
| − | + | ||
| − | =Definition= | + | = Definition = |
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE logproplist ( | CREATE TABLE logproplist ( | ||
| Line 16: | Line 17: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
| + | = Location = | ||
| − | |||
[[Global database]] | [[Global database]] | ||
| + | |||
| + | [[Category: Database Tables|logproplist]] | ||
Revision as of 20:22, 31 March 2009
Definition
CREATE TABLE logproplist ( propid tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(50) DEFAULT NULL, prettyname VARCHAR(60) DEFAULT NULL, sortorder mediumint(8) UNSIGNED DEFAULT NULL, datatype enum('char','num','bool') NOT NULL DEFAULT 'char', scope enum('general', 'local') NOT NULL DEFAULT 'general', ownership ENUM('system', 'user') NOT NULL DEFAULT 'user', des VARCHAR(255) DEFAULT NULL, PRIMARY KEY (propid), UNIQUE KEY name (name) )
