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.sql53
1 files changed, 27 insertions, 26 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql
index fa39fde506..df5462f776 100644
--- a/phpBB/db/postgres_schema.sql
+++ b/phpBB/db/postgres_schema.sql
@@ -233,7 +233,8 @@ CREATE TABLE phpbb_posts (
topic_id int4 DEFAULT '0' NOT NULL,
forum_id int4 DEFAULT '0' NOT NULL,
poster_id int4 DEFAULT '0' NOT NULL,
- post_time int4 DEFAULT '0' NOT NULL,
+ post_time int4 DEFAULT '0' NOT NULL,
+ post_username varchar(30),
poster_ip varchar(8) DEFAULT '' NOT NULL,
bbcode_uid varchar(10) DEFAULT '' NOT NULL,
CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id)
@@ -364,9 +365,9 @@ CREATE TABLE phpbb_themes (
td_color1 char(6),
td_color2 char(6),
td_color3 char(6),
- fontface1 varchar(30),
- fontface2 varchar(30),
- fontface3 varchar(30),
+ fontface1 varchar(50),
+ fontface2 varchar(50),
+ fontface3 varchar(50),
fontsize1 int2,
fontsize2 int2,
fontsize3 int2,
@@ -387,28 +388,28 @@ 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(25),
- tr_color2_name varchar(25),
- tr_color3_name varchar(25),
- th_color1_name varchar(25),
- th_color2_name varchar(25),
- th_color3_name varchar(25),
- td_color1_name varchar(25),
- td_color2_name varchar(25),
- td_color3_name varchar(25),
- fontface1_name varchar(25),
- fontface2_name varchar(25),
- fontface3_name varchar(25),
- fontsize1_name varchar(25),
- fontsize2_name varchar(25),
- fontsize3_name varchar(25),
- fontcolor1_name varchar(25),
- fontcolor2_name varchar(25),
- fontcolor3_name varchar(25),
- img1_name varchar(25),
- img2_name varchar(25),
- img3_name varchar(25),
- img4_name varchar(25),
+ 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),
+ 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),
CONSTRAINT phpbb_themes_name_pkey PRIMARY KEY (themes_id)
);