diff options
| author | Kevin Chabowski <kevin@kch42.de> | 2011-12-27 01:36:09 +0100 |
|---|---|---|
| committer | Kevin Chabowski <kevin@kch42.de> | 2011-12-27 01:36:09 +0100 |
| commit | cf2a4a79eb8344ab1c3303d4bdbb80c91d94925b (patch) | |
| tree | 3ff7e96d9ce85686e1a365a40dbcb684d2e0a93d /ratatoeskr/setup/create_tables.php | |
| parent | cb172742c78517baf6a79b52f980b0b9dcb81274 (diff) | |
| download | ratatoeskr-cms-cf2a4a79eb8344ab1c3303d4bdbb80c91d94925b.tar.gz ratatoeskr-cms-cf2a4a79eb8344ab1c3303d4bdbb80c91d94925b.tar.bz2 ratatoeskr-cms-cf2a4a79eb8344ab1c3303d4bdbb80c91d94925b.zip | |
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...
Diffstat (limited to 'ratatoeskr/setup/create_tables.php')
| -rw-r--r-- | ratatoeskr/setup/create_tables.php | 6 |
1 files changed, 5 insertions, 1 deletions
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, |