diff options
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) |