From 1f0632f5fa72652c8cc9d6c96d4d52c809f49017 Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Thu, 3 May 2001 23:34:21 +0000
Subject: Latest update
git-svn-id: file:///svn/phpbb/trunk@241 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/mysql_schema.sql | 165 +++++++++++++++++++++++++---------------------
1 file changed, 89 insertions(+), 76 deletions(-)
(limited to 'phpBB/db/mysql_schema.sql')
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index f2010707d8..c4a54cc25e 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -11,12 +11,12 @@
#
CREATE TABLE phpbb_banlist (
- ban_id int(11) NOT NULL auto_increment,
- ban_userid int(11),
+ ban_id int(10) NOT NULL auto_increment,
+ ban_userid int(10),
ban_ip char(8),
- ban_start char(8),
- ban_end char(8),
- ban_time_type tinyint(4),
+ ban_start int(10),
+ ban_end int(10),
+ ban_time_type int(10),
PRIMARY KEY (ban_id)
);
@@ -27,7 +27,7 @@ CREATE TABLE phpbb_banlist (
#
CREATE TABLE phpbb_categories (
- cat_id int(11) NOT NULL auto_increment,
+ cat_id int(10) NOT NULL auto_increment,
cat_title varchar(100),
cat_order varchar(10),
PRIMARY KEY (cat_id)
@@ -40,23 +40,23 @@ CREATE TABLE phpbb_categories (
#
CREATE TABLE phpbb_config (
- config_id int(11) NOT NULL auto_increment,
- sitename varchar(100),
- allow_html tinyint(3),
- allow_bbcode tinyint(3),
- allow_sig tinyint(3),
- allow_namechange tinyint(3),
+ config_id int(10) NOT NULL auto_increment,
selected int(2) DEFAULT '0' NOT NULL,
- posts_per_page int(11),
- hot_threshold int(11),
- topics_per_page int(11),
- allow_theme_create int(11),
+ sitename varchar(100),
+ allow_html tinyint(1),
+ allow_bbcode tinyint(1),
+ allow_sig tinyint(1),
+ allow_namechange tinyint(1),
+ allow_theme_create int(10),
override_themes tinyint(3),
+ posts_per_page int(10),
+ topics_per_page int(10),
+ hot_threshold int(10),
email_sig varchar(255),
email_from varchar(100),
default_theme int(11) DEFAULT '1' NOT NULL,
default_lang varchar(255),
- default_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
+ default_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
system_timezone int(11) DEFAULT '0' NOT NULL,
sys_template varchar(100) DEFAULT 'Default' NOT NULL,
PRIMARY KEY (config_id),
@@ -70,7 +70,7 @@ CREATE TABLE phpbb_config (
#
CREATE TABLE phpbb_disallow (
- disallow_id int(11) NOT NULL auto_increment,
+ disallow_id int(10) NOT NULL auto_increment,
disallow_username varchar(50),
PRIMARY KEY (disallow_id)
);
@@ -82,9 +82,9 @@ CREATE TABLE phpbb_disallow (
#
CREATE TABLE phpbb_forum_access (
- forum_id int(11) NOT NULL,
- user_id int(11) NOT NULL,
- can_post tinyint(1) NOT NULL,
+ forum_id int(10) DEFAULT '0' NOT NULL,
+ user_id int(10) DEFAULT '0' NOT NULL,
+ can_post tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (forum_id, user_id)
);
@@ -95,8 +95,8 @@ CREATE TABLE phpbb_forum_access (
#
CREATE TABLE phpbb_forum_mods (
- forum_id int(11) NOT NULL,
- user_id int(11) NOT NULL,
+ forum_id int(10) DEFAULT '0' NOT NULL,
+ user_id int(10) DEFAULT '0' NOT NULL,
mod_notify tinyint(3)
);
@@ -107,16 +107,16 @@ CREATE TABLE phpbb_forum_mods (
#
CREATE TABLE phpbb_forums (
- forum_id int(11) NOT NULL auto_increment,
+ forum_id int(10) NOT NULL auto_increment,
+ cat_id int(10),
forum_name varchar(150),
forum_desc text,
forum_access tinyint(3),
- cat_id int(11),
forum_order int(11) DEFAULT '1' NOT NULL,
forum_type tinyint(4),
- forum_posts int(11) NOT NULL,
- forum_topics tinyint(4) NOT NULL,
- forum_last_post_id int(11) NOT NULL,
+ forum_posts int(11) DEFAULT '0' NOT NULL,
+ forum_topics tinyint(4) DEFAULT '0' NOT NULL,
+ forum_last_post_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (forum_id),
KEY forum_id (forum_id),
KEY forums_order (forum_order),
@@ -124,18 +124,19 @@ CREATE TABLE phpbb_forums (
);
+
# --------------------------------------------------------
#
# Table structure for table 'phpbb_posts'
#
CREATE TABLE phpbb_posts (
- post_id int(11) NOT NULL auto_increment,
- topic_id int(11) NOT NULL,
- forum_id int(11) NOT NULL,
- poster_id int(11) NOT NULL,
- post_time int(11) NOT NULL,
- poster_ip char(8) NOT NULL,
+ post_id int(10) NOT NULL auto_increment,
+ topic_id int(10) DEFAULT '0' NOT NULL,
+ forum_id int(10) DEFAULT '0' NOT NULL,
+ poster_id int(10) DEFAULT '0' NOT NULL,
+ post_time int(10) DEFAULT '0' NOT NULL,
+ poster_ip varchar(8) NOT NULL,
bbcode_uid varchar(10) NOT NULL,
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
@@ -150,7 +151,7 @@ CREATE TABLE phpbb_posts (
#
CREATE TABLE phpbb_posts_text (
- post_id int(11) NOT NULL,
+ post_id int(10) DEFAULT '0' NOT NULL,
post_text text,
PRIMARY KEY (post_id)
);
@@ -162,14 +163,14 @@ CREATE TABLE phpbb_posts_text (
#
CREATE TABLE phpbb_privmsgs (
- msg_id int(11) NOT NULL auto_increment,
- from_userid int(11) NOT NULL,
- to_userid int(11) NOT NULL,
- msg_time int(11) NOT NULL,
- poster_ip char(8) NOT NULL,
- msg_status int(11) NOT NULL,
+ msg_id int(10) NOT NULL auto_increment,
+ from_userid int(10) DEFAULT '0' NOT NULL,
+ to_userid int(10) DEFAULT '0' NOT NULL,
+ msg_time int(10) DEFAULT '0' NOT NULL,
+ poster_ip varchar(8),
+ msg_status int(10) DEFAULT '0' NOT NULL,
msg_text text NOT NULL,
- newmsg tinyint(4) NOT NULL,
+ newmsg tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (msg_id),
KEY to_userid (to_userid)
);
@@ -183,9 +184,9 @@ CREATE TABLE phpbb_privmsgs (
CREATE TABLE phpbb_ranks (
rank_id int(11) NOT NULL auto_increment,
rank_title varchar(50) NOT NULL,
- rank_min int(11) NOT NULL,
- rank_max int(11) NOT NULL,
- rank_special tinyint(1),
+ rank_min int(11) DEFAULT '0' NOT NULL,
+ rank_max int(11) DEFAULT '0' NOT NULL,
+ rank_special tinyint(1) DEFAULT '0',
rank_image varchar(255),
PRIMARY KEY (rank_id),
KEY rank_min (rank_min),
@@ -200,16 +201,30 @@ CREATE TABLE phpbb_ranks (
#
CREATE TABLE phpbb_session (
- session_id int(11) NOT NULL,
- session_user_id int(11) NOT NULL,
- session_start int(11) NOT NULL,
- session_time int(11) NOT NULL,
- session_ip char(8) NOT NULL,
- session_page int(11),
- session_logged_in tinyint(1) NOT NULL,
+ session_id int(11) DEFAULT '0' NOT NULL,
+ session_user_id int(11) DEFAULT '0' NOT NULL,
+ session_start int(11) DEFAULT '0' NOT NULL,
+ session_time int(11) DEFAULT '0' NOT NULL,
+ session_ip char(8) DEFAULT '0' NOT NULL,
+ session_page int(11) DEFAULT '0' NOT NULL,
+ session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
- KEY session_ip (session_ip),
- KEY session_user_id (session_user_id)
+ KEY session_user_id (session_user_id),
+ KEY session_ip (session_ip)
+);
+
+
+# --------------------------------------------------------
+#
+# Table structure for table 'phpbb_session_keys'
+#
+
+CREATE TABLE phpbb_session_keys (
+ key_user_id int(11) DEFAULT '0' NOT NULL,
+ key_ip varchar(8) NOT NULL,
+ key_login varchar(32) NOT NULL,
+ PRIMARY KEY (key_user_id),
+ KEY key_ip (key_ip)
);
@@ -276,7 +291,7 @@ CREATE TABLE phpbb_themes (
#
CREATE TABLE phpbb_themes_name (
- themes_id int(11) NOT NULL,
+ themes_id int(11) DEFAULT '0' NOT NULL,
tr_color1_name varchar(25),
tr_color2_name varchar(25),
tr_color3_name varchar(25),
@@ -309,16 +324,16 @@ CREATE TABLE phpbb_themes_name (
#
CREATE TABLE phpbb_topics (
- topic_id int(11) NOT NULL auto_increment,
+ topic_id int(10) NOT NULL auto_increment,
+ forum_id int(10) DEFAULT '0' NOT NULL,
topic_title varchar(100) NOT NULL,
- topic_poster int(11) NOT NULL,
- topic_time int(11) NOT NULL,
- topic_views int(11) NOT NULL,
- topic_replies int(11) NOT NULL,
- forum_id int(11) NOT NULL,
- topic_status tinyint(3) NOT NULL,
- topic_notify tinyint(3),
- topic_last_post_id int(11) NOT NULL,
+ topic_poster int(10) DEFAULT '0' NOT NULL,
+ topic_time int(10) DEFAULT '0' NOT NULL,
+ topic_views int(10) DEFAULT '0' NOT NULL,
+ topic_replies int(11) DEFAULT '0' NOT NULL,
+ topic_status tinyint(3) DEFAULT '0' NOT NULL,
+ topic_notify tinyint(3) DEFAULT '0',
+ topic_last_post_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (topic_id),
KEY forum_id (forum_id),
KEY topic_id (topic_id)
@@ -332,11 +347,18 @@ CREATE TABLE phpbb_topics (
CREATE TABLE phpbb_users (
user_id int(11) NOT NULL auto_increment,
+ user_active tinyint(4),
username varchar(40) NOT NULL,
- user_regdate varchar(20) NOT NULL,
+ user_regdate int(11) DEFAULT '0' NOT NULL,
user_password varchar(32) NOT NULL,
user_autologin_key varchar(32),
- user_hint varchar(25) NOT NULL,
+ user_template varchar(50),
+ user_lang varchar(255),
+ user_timezone int(11) DEFAULT '0' NOT NULL,
+ user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
+ user_rank int(11) DEFAULT '0',
+ user_avatar varchar(100),
+ user_level int(11) DEFAULT '1',
user_email varchar(255),
user_icq varchar(15),
user_website varchar(100),
@@ -354,17 +376,9 @@ CREATE TABLE phpbb_users (
user_desmile tinyint(3),
user_html tinyint(3),
user_bbcode tinyint(3),
- user_rank int(11) DEFAULT '0',
- user_avatar varchar(100),
- user_level int(11) DEFAULT '1',
- user_lang varchar(255),
- user_timezone int(11) DEFAULT '0' NOT NULL,
- user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
user_actkey varchar(32),
user_newpasswd varchar(32),
user_notify tinyint(3),
- user_active tinyint(4),
- user_template varchar(50),
PRIMARY KEY (user_id),
KEY user_id (user_id)
);
@@ -376,9 +390,8 @@ CREATE TABLE phpbb_users (
#
CREATE TABLE phpbb_words (
- word_id int(11) NOT NULL auto_increment,
+ word_id int(10) NOT NULL auto_increment,
word varchar(100) NOT NULL,
replacement varchar(100) NOT NULL,
PRIMARY KEY (word_id)
);
-
--
cgit v1.2.1