diff options
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
-rw-r--r-- | phpBB/db/postgres_schema.sql | 63 |
1 files changed, 40 insertions, 23 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 54564671b0..cf49def9b3 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -87,6 +87,7 @@ CREATE TABLE phpbb_categories ( CREATE TABLE phpbb_config ( config_id int2 NOT NULL, board_disable int2 DEFAULT '0' NOT NULL, + board_startdate int4, sitename varchar(100) NOT NULL, cookie_name char(20), cookie_path char(25), @@ -320,25 +321,33 @@ CREATE TABLE phpbb_themes ( tr_color1 char(6), tr_color2 char(6), tr_color3 char(6), + tr_class1 varchar(25), + tr_class2 varchar(25), + tr_class3 varchar(25), th_color1 char(6), th_color2 char(6), th_color3 char(6), + th_class1 varchar(25), + th_class2 varchar(25), + th_class3 varchar(25), td_color1 char(6), td_color2 char(6), td_color3 char(6), - fontface1 varchar(50), - fontface2 varchar(50), - fontface3 varchar(50), + td_class1 varchar(25), + td_class2 varchar(25), + td_class3 varchar(25), + fontface1 varchar(25), + fontface2 varchar(25), + fontface3 varchar(25), fontsize1 int2, fontsize2 int2, fontsize3 int2, fontcolor1 char(6), fontcolor2 char(6), fontcolor3 char(6), - img1 varchar(100), - img2 varchar(100), - img3 varchar(100), - img4 varchar(100), + span_class1 varchar(25), + span_class2 varchar(25), + span_class3 varchar(25), CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id) ); CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); @@ -349,28 +358,36 @@ CREATE INDEX themes_name_phpbb_themes_index ON phpbb_themes (themes_name); -------------------------------------------------------- */ CREATE TABLE phpbb_themes_name ( themes_id int4 DEFAULT '0' NOT NULL, - tr_color1_name varchar(50), - tr_color2_name varchar(50), - tr_color3_name varchar(50), - th_color1_name varchar(50), - th_color2_name varchar(50), - th_color3_name varchar(50), - td_color1_name varchar(50), - td_color2_name varchar(50), - td_color3_name varchar(50), + tr_color1_name char(50), + tr_color2_name char(50), + tr_color3_name char(50), + tr_class1_name varchar(50), + tr_class2_name varchar(50), + tr_class3_name varchar(50), + th_color1_name char(50), + th_color2_name char(50), + th_color3_name char(50), + th_class1_name varchar(50), + th_class2_name varchar(50), + th_class3_name varchar(50), + td_color1_name char(50), + td_color2_name char(50), + td_color3_name char(50), + td_class1_name varchar(50), + td_class2_name varchar(50), + td_class3_name varchar(50), fontface1_name varchar(50), fontface2_name varchar(50), fontface3_name varchar(50), fontsize1_name varchar(50), fontsize2_name varchar(50), fontsize3_name varchar(50), - fontcolor1_name varchar(50), - fontcolor2_name varchar(50), - fontcolor3_name varchar(50), - img1_name varchar(50), - img2_name varchar(50), - img3_name varchar(50), - img4_name varchar(50), + fontcolor1_name char(50), + fontcolor2_name char(50), + fontcolor3_name char(50), + span_class1_name varchar(50), + span_class2_name varchar(50), + span_class3_name varchar(50), CONSTRAINT phpbb_themes_name_pkey PRIMARY KEY (themes_id) ); |