diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-04-19 13:38:06 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-04-19 13:38:06 +0000 |
| commit | 8870e21858f327edb4e8ed154a52426d22ca2ee5 (patch) | |
| tree | abac385e0f18dc0c038d19599f1d742c7210e420 /phpBB/db | |
| parent | 28cb3849947f08b9322150f97a85b475ee94c0f5 (diff) | |
| download | forums-8870e21858f327edb4e8ed154a52426d22ca2ee5.tar forums-8870e21858f327edb4e8ed154a52426d22ca2ee5.tar.gz forums-8870e21858f327edb4e8ed154a52426d22ca2ee5.tar.bz2 forums-8870e21858f327edb4e8ed154a52426d22ca2ee5.tar.xz forums-8870e21858f327edb4e8ed154a52426d22ca2ee5.zip | |
Changed IP types to char 8 for time being
git-svn-id: file:///svn/phpbb/trunk@185 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 35 |
1 files changed, 26 insertions, 9 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index d75ff9a274..8c62291bd8 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -1,9 +1,26 @@ -# MySQL dump 8.13 +# *************************************************************************** +# * mysql_schema.sql +# * ------------------- +# * begin : Thursday, Apr 19, 2001 +# * copyright : (C) 2001 The phpBB Group +# * email : support@phpbb.com +# * +# * $Id$ +# * +# * +# *************************************************************************** +# +# +# *************************************************************************** +# * +# * This program is free software; you can redistribute it and/or modify +# * it under the terms of the GNU General Public License as published by +# * the Free Software Foundation; either version 2 of the License, or +# * (at your option) any later version. +# * +# * +# *************************************************************************** # -# Host: localhost Database: phpBBtest -#-------------------------------------------------------- -# Server version 3.23.35 - # # Table structure for table 'phpbb_banlist' # @@ -11,7 +28,7 @@ CREATE TABLE phpbb_banlist ( ban_id int(10) NOT NULL auto_increment, ban_userid int(10) default NULL, - ban_ip int(11) default NULL, + ban_ip char(8) default NULL, ban_start int(10) default NULL, ban_end int(10) default NULL, ban_time_type int(10) default NULL, @@ -127,7 +144,7 @@ CREATE TABLE phpbb_posts ( forum_id int(10) NOT NULL default '0', poster_id int(10) NOT NULL default '0', post_time int(10) NOT NULL default '0', - poster_ip int(10) NOT NULL default '0', + poster_ip char(8) NOT NULL default '0', bbcode_uid varchar(10) NOT NULL default '', PRIMARY KEY (post_id), KEY forum_id (forum_id), @@ -154,7 +171,7 @@ CREATE TABLE phpbb_priv_msgs ( from_userid int(10) NOT NULL default '0', to_userid int(10) NOT NULL default '0', msg_time int(10) NOT NULL default '0', - poster_ip int(10) NOT NULL default '0', + poster_ip char(8) NOT NULL default '0', msg_status int(10) NOT NULL default '0', msg_text text NOT NULL, PRIMARY KEY (msg_id), @@ -186,7 +203,7 @@ CREATE TABLE phpbb_session ( session_id int(10) unsigned NOT NULL default '0', session_user_id int(10) NOT NULL default '0', session_time int(10) unsigned NOT NULL default '0', - session_ip int(10) default NULL, + session_ip char(8) default NULL, session_page int(10) NOT NULL default '0', session_logged_in tinyint(1) NOT NULL default '0', PRIMARY KEY (session_id) |