diff options
| author | Patrick Seeger <pseeger@ccwn.org> | 2012-06-25 23:31:16 +0200 |
|---|---|---|
| committer | Patrick Seeger <pseeger@ccwn.org> | 2012-06-25 23:31:16 +0200 |
| commit | d58f7cf02dc0c5ce2df2f0db00361fe673074be8 (patch) | |
| tree | de5b7064e43255a471de4cb469a7db71bce3d328 /protected/modules/cms/docs/schema_mysql.sql | |
| parent | 82f5b7dc1890c03ebec349225e76ea0b22ec6c1d (diff) | |
Änderungen das alles tut, editor, cms
Diffstat (limited to 'protected/modules/cms/docs/schema_mysql.sql')
| -rw-r--r-- | protected/modules/cms/docs/schema_mysql.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/protected/modules/cms/docs/schema_mysql.sql b/protected/modules/cms/docs/schema_mysql.sql new file mode 100644 index 0000000..372f837 --- /dev/null +++ b/protected/modules/cms/docs/schema_mysql.sql @@ -0,0 +1,17 @@ +CREATE TABLE IF NOT EXISTS `sitecontent` ( + `id` int(11) unsigned NOT NULL AUTO_INCREMENT, + `parent` int(11) NOT NULL, + `authorid` varchar(255) DEFAULT NULL, + `language` varchar(5) NOT NULL, + `position` int(10) unsigned NOT NULL, + `keywords` varchar(255) NULL, + `description` varchar(255) NULL, + `title_url` varchar(80) NOT NULL, + `title_browser` varchar(80) NOT NULL, + `title` varchar(255) NOT NULL, + `content` text NOT NULL, + `createtime` int(11) DEFAULT NULL, + `updatetime` int(11) DEFAULT NULL, + PRIMARY KEY (`id`, `language`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + |