diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-05-08 23:34:36 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-05-08 23:34:36 +0000 |
| commit | 2d7bfa5c61dd98300b8e57d73e46c7df0470d48e (patch) | |
| tree | f711215f2c402e393bc4f076ad203fb83eed097a /phpBB/db/schemas/postgres_schema.sql | |
| parent | 52c0d86c95aaacd3e57866a5d57fce82b599236f (diff) | |
| download | forums-2d7bfa5c61dd98300b8e57d73e46c7df0470d48e.tar forums-2d7bfa5c61dd98300b8e57d73e46c7df0470d48e.tar.gz forums-2d7bfa5c61dd98300b8e57d73e46c7df0470d48e.tar.bz2 forums-2d7bfa5c61dd98300b8e57d73e46c7df0470d48e.tar.xz forums-2d7bfa5c61dd98300b8e57d73e46c7df0470d48e.zip | |
IP size to 40 chars
git-svn-id: file:///svn/phpbb/trunk@2557 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 981cfb07a4..ae236c9d94 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -63,7 +63,7 @@ CREATE TABLE phpbb_groups ( CREATE TABLE phpbb_banlist ( ban_id int4 DEFAULT nextval('phpbb_banlist_id_seq'::text) NOT NULL, ban_userid int4, - ban_ip char(8), + ban_ip char(40), ban_email varchar(255), CONSTRAINT phpbb_banlist_pkey PRIMARY KEY (ban_id) ); @@ -171,7 +171,7 @@ CREATE TABLE phpbb_posts ( poster_id int4 DEFAULT '0' NOT NULL, post_time int4 DEFAULT '0' NOT NULL, post_username varchar(25), - poster_ip char(8) DEFAULT '' NOT NULL, + poster_ip char(40) DEFAULT '' NOT NULL, enable_bbcode int2 DEFAULT '1' NOT NULL, enable_html int2 DEFAULT '0' NOT NULL, enable_smilies int2 DEFAULT '1' NOT NULL, @@ -208,7 +208,7 @@ 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 char(8) NOT NULL, + privmsgs_ip char(40) NOT NULL, privmsgs_enable_bbcode int2 DEFAULT '1' NOT NULL, privmsgs_enable_html int2 DEFAULT '0' NOT NULL, privmsgs_enable_smilies int2 DEFAULT '1' NOT NULL, @@ -286,7 +286,7 @@ CREATE TABLE phpbb_sessions ( session_user_id int4 DEFAULT '0' NOT NULL, session_start int4 DEFAULT '0' NOT NULL, session_time int4 DEFAULT '0' NOT NULL, - session_ip char(8) DEFAULT '0' NOT NULL, + session_ip char(40) DEFAULT '0' NOT NULL, session_page int4 DEFAULT '0' NOT NULL, session_logged_in int2 DEFAULT '0' NOT NULL, CONSTRAINT phpbb_session_pkey PRIMARY KEY (session_id) @@ -532,7 +532,7 @@ CREATE INDEX option_id_phpbb_vote_results_index ON phpbb_vote_results (vote_opti CREATE TABLE phpbb_vote_voters ( vote_id int4 NOT NULL DEFAULT '0', vote_user_id int4 NOT NULL DEFAULT '0', - vote_user_ip char(8) NOT NULL + vote_user_ip char(40) NOT NULL ); CREATE INDEX vote_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_id); CREATE INDEX vote_user_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_user_id); |