1 files changed, 44 insertions, 37 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index 10d23f8f7e..1439032195 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -327,43 +327,50 @@ CREATE TABLE phpbb_smilies (
 # Table structure for table 'phpbb_themes'
 #
 DROP TABLE IF EXISTS phpbb_themes;
-
-CREATE TABLE phpbb_themes (
-   themes_id int(11) NOT NULL auto_increment,
-   themes_name varchar(30) NOT NULL,
-   head_stylesheet varchar(100),
-   body_background varchar(100),
-   body_bgcolor char(6),
-   body_text char(6),
-   body_link char(6),
-   body_vlink char(6),
-   body_alink char(6),
-   body_hlink char(6),
-   tr_color1 char(6),
-   tr_color2 char(6),
-   tr_color3 char(6),
-   th_color1 char(6),
-   th_color2 char(6),
-   th_color3 char(6),
-   td_color1 char(6),
-   td_color2 char(6),
-   td_color3 char(6),
-   fontface1 varchar(50),
-   fontface2 varchar(50),
-   fontface3 varchar(50),
-   fontsize1 tinyint(4),
-   fontsize2 tinyint(4),
-   fontsize3 tinyint(4),
-   fontcolor1 char(6),
-   fontcolor2 char(6),
-   fontcolor3 char(6),
-   img1 varchar(100),
-   img2 varchar(100),
-   img3 varchar(100),
-   img4 varchar(100),
-   PRIMARY KEY (themes_id),
-   KEY themes_name (themes_name)
-);
+CREATE TABLE `phpbb_themes` (
+  `themes_id` int(11) NOT NULL auto_increment,
+  `themes_name` varchar(30) NOT NULL default '',
+  `head_stylesheet` varchar(100) default NULL,
+  `body_background` varchar(100) default NULL,
+  `body_bgcolor` varchar(6) default NULL,
+  `body_text` varchar(6) default NULL,
+  `body_link` varchar(6) default NULL,
+  `body_vlink` varchar(6) default NULL,
+  `body_alink` varchar(6) default NULL,
+  `body_hlink` varchar(6) default NULL,
+  `tr_color1` varchar(6) default NULL,
+  `tr_color2` varchar(6) default NULL,
+  `tr_color3` varchar(6) default NULL,
+  `tr_class1` varchar(20) default NULL,
+  `tr_class2` varchar(20) default NULL,
+  `tr_class3` varchar(25) default NULL,
+  `th_color1` varchar(6) default NULL,
+  `th_color2` varchar(6) default NULL,
+  `th_color3` varchar(6) default NULL,
+  `th_class1` varchar(25) default NULL,
+  `th_class2` varchar(25) default NULL,
+  `th_class3` varchar(6) default NULL,
+  `td_color1` varchar(6) default NULL,
+  `td_color2` varchar(6) default NULL,
+  `td_color3` varchar(6) default NULL,
+  `td_class1` varchar(25) default NULL,
+  `td_class2` varchar(25) default NULL,
+  `td_class3` varchar(25) default NULL,
+  `fontface1` varchar(50) default NULL,
+  `fontface2` varchar(50) default NULL,
+  `fontface3` varchar(50) default NULL,
+  `fontsize1` tinyint(4) default NULL,
+  `fontsize2` tinyint(4) default NULL,
+  `fontsize3` tinyint(4) default NULL,
+  `fontcolor1` varchar(6) default NULL,
+  `fontcolor2` varchar(6) default NULL,
+  `fontcolor3` varchar(6) default NULL,
+  `span_class1` varchar(25) default NULL,
+  `span_class2` varchar(25) default NULL,
+  `span_class3` varchar(25) default NULL,
+  PRIMARY KEY  (`themes_id`),
+  KEY `themes_name` (`themes_name`)
+)
 
 
 # --------------------------------------------------------