diff options
| author | astaf <astaf@proxy.ccwn.org.ccwn.org> | 2012-06-26 17:11:26 +0200 |
|---|---|---|
| committer | astaf <astaf@proxy.ccwn.org.ccwn.org> | 2012-06-26 17:11:26 +0200 |
| commit | f0e90d88a5766e67ff69339b27711ffb5f41e1ca (patch) | |
| tree | 387f30bc7cd39114f6db71a7deb7d5f16442c03c /protected/modules/cms/docs/schema_mysql.sql | |
| parent | 1a52e642b8bb388fd4c4b29798fa3809a2114c9f (diff) | |
| parent | d58f7cf02dc0c5ce2df2f0db00361fe673074be8 (diff) | |
Merge branch 'master' of ssh://proxy:9044/home/ccwn/git-repos/admin.astaf.de
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 ; + |