aboutsummaryrefslogtreecommitdiff
path: root/ratatoeskr/setup
diff options
context:
space:
mode:
authorKevin Chabowski <kevin@kch42.de>2011-12-27 01:36:09 +0100
committerKevin Chabowski <kevin@kch42.de>2011-12-27 01:36:09 +0100
commitcf2a4a79eb8344ab1c3303d4bdbb80c91d94925b (patch)
tree3ff7e96d9ce85686e1a365a40dbcb684d2e0a93d /ratatoeskr/setup
parentcb172742c78517baf6a79b52f980b0b9dcb81274 (diff)
downloadratatoeskr-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')
-rw-r--r--ratatoeskr/setup/create_tables.php6
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,