aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db/postgres_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
-rw-r--r--phpBB/db/postgres_schema.sql63
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)
);