From 2d7bfa5c61dd98300b8e57d73e46c7df0470d48e Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Wed, 8 May 2002 23:34:36 +0000
Subject: IP size to 40 chars

git-svn-id: file:///svn/phpbb/trunk@2557 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/db/schemas/postgres_schema.sql | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'phpBB/db/schemas/postgres_schema.sql')

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);
-- 
cgit v1.2.1

