From cd448c43cbc882567c647893f8fa7f666a84427a Mon Sep 17 00:00:00 2001 From: Kevin Chabowski Date: Thu, 22 Sep 2011 00:25:44 +0200 Subject: Fixed models.php and the database layout. --- ratatoeskr/setup/create_tables.php | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'ratatoeskr/setup/create_tables.php') diff --git a/ratatoeskr/setup/create_tables.php b/ratatoeskr/setup/create_tables.php index b024d51..aea5fcb 100644 --- a/ratatoeskr/setup/create_tables.php +++ b/ratatoeskr/setup/create_tables.php @@ -8,7 +8,7 @@ CREATE TABLE `PREFIX_acl` ( `id` int(11) NOT NULL AUTO_INCREMENT, `acl_json` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `PREFIX_articles` ( `id` int(11) NOT NULL AUTO_INCREMENT, @@ -19,13 +19,13 @@ CREATE TABLE `PREFIX_articles` ( `meta` text COLLATE utf8_unicode_ci NOT NULL, `custom` text COLLATE utf8_unicode_ci NOT NULL, `acl` int(11) NOT NULL, - `article_img` int(11) NOT NULL, + `article_image` int(11) NOT NULL, `status` int(11) NOT NULL, `section` int(11) NOT NULL, `timestamp` bigint(20) NOT NULL, `allow_comments` int(11) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `PREFIX_article_tag_relations` ( `tag` int(11) NOT NULL, @@ -45,12 +45,12 @@ CREATE TABLE `PREFIX_comments` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `PREFIX_groups` ( - `int` int(11) NOT NULL AUTO_INCREMENT, + `id` int(11) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, - PRIMARY KEY (`int`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -CREATE TABLE `PREFIX_group_memers` ( +CREATE TABLE `PREFIX_group_members` ( `user` int(11) NOT NULL, `group` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; @@ -96,7 +96,7 @@ CREATE TABLE `PREFIX_sections` ( `template` text COLLATE utf8_unicode_ci NOT NULL, `styles` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `PREFIX_settings_kvstorage` ( `key` text COLLATE utf8_unicode_ci NOT NULL, @@ -133,7 +133,7 @@ CREATE TABLE `PREFIX_users` ( `fullname` text COLLATE utf8_unicode_ci NOT NULL, `language` varchar(10) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SQL; ?> -- cgit v1.2.3-54-g00ecf