diff options
Diffstat (limited to 'phpBB/db/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 41ddce0a67..e657fdfb51 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -238,7 +238,7 @@ CREATE TABLE phpbb_posts ( poster_id int4 DEFAULT '0' NOT NULL, post_time int4 DEFAULT '0' NOT NULL, post_username varchar(30), - poster_ip varchar(8) DEFAULT '' NOT NULL, + poster_ip char(8) DEFAULT '' NOT NULL, bbcode_uid varchar(10) DEFAULT '' NOT NULL, CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id) ); @@ -269,8 +269,8 @@ CREATE TABLE phpbb_privmsgs ( privmsgs_from_userid int4 DEFAULT '0' NOT NULL, privmsgs_to_userid int4 DEFAULT '0' NOT NULL, privmsgs_date int4 DEFAULT '0' NOT NULL, - privmsgs_ip varchar(8) NOT NULL, - privmsgs_bbcode_uid int4 DEFAULT '0' NOT NULL, + privmsgs_ip char(8) NOT NULL, + privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL, CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id) ); CREATE INDEX privmsgs_from_userid_index ON phpbb_privmsgs (privmsgs_from_userid); @@ -326,7 +326,7 @@ CREATE INDEX session_id_ip_user_id ON phpbb_session (session_id, session_ip, ses -------------------------------------------------------- */ CREATE TABLE phpbb_session_keys ( key_user_id int4 DEFAULT '0' NOT NULL, - key_ip varchar(8) DEFAULT '' NOT NULL, + key_ip char(8) DEFAULT '' NOT NULL, key_login varchar(32) DEFAULT '' NOT NULL, CONSTRAINT phpbb_session_keys_pkey PRIMARY KEY (key_user_id) ); |