From cf2a4a79eb8344ab1c3303d4bdbb80c91d94925b Mon Sep 17 00:00:00 2001 From: Kevin Chabowski Date: Tue, 27 Dec 2011 01:36:09 +0100 Subject: Section's Styles are nowonlyavailable by a getter. Also fixed many MySQL Queries. These SELECT ... WHERE foo = (SELECT...) have not worked as expected, so now there are many ugly joins... --- ratatoeskr/setup/create_tables.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'ratatoeskr/setup') diff --git a/ratatoeskr/setup/create_tables.php b/ratatoeskr/setup/create_tables.php index dd37d5a..0f2f6b5 100644 --- a/ratatoeskr/setup/create_tables.php +++ b/ratatoeskr/setup/create_tables.php @@ -92,7 +92,6 @@ CREATE TABLE `PREFIX_sections` ( `name` text COLLATE utf8_unicode_ci NOT NULL, `title` int(11) NOT NULL, `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; @@ -108,6 +107,11 @@ CREATE TABLE `PREFIX_styles` ( PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +CREATE TABLE `PREFIX_section_style_relations` ( + `section` int(11) NOT NULL, + `style` int(11) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + CREATE TABLE `PREFIX_tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci NOT NULL, -- cgit v1.2.3-70-g09d2