diff options
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
-rw-r--r-- | phpBB/db/postgres_schema.sql | 53 |
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) ); |