From 6be03b553d19c0598ea4101f1257bdcc2f81ab94 Mon Sep 17 00:00:00 2001
From: "Paul S. Owen" <psotfx@users.sourceforge.net>
Date: Fri, 9 Mar 2001 20:37:44 +0000
Subject: Current (perhaps) MySQL schema for phpBB2
git-svn-id: file:///svn/phpbb/trunk@93 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/mysql_schema.sql | 15 ++++++++++-----
1 file changed, 10 insertions(+), 5 deletions(-)
(limited to 'phpBB/db/mysql_schema.sql')
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql
index 05df1dcf76..289dbfb01c 100644
--- a/phpBB/db/mysql_schema.sql
+++ b/phpBB/db/mysql_schema.sql
@@ -1,7 +1,8 @@
#
-# Structure of phpBB2 DB as at
+# phpBB2 mysql DB schema - phpBB team 2001
#
-# 24 Feb 2001 22.18 GMT
+#
+# $Id$
#
# --------------------------------------------------------
@@ -103,16 +104,19 @@ CREATE TABLE phpbb_forum_mods (
CREATE TABLE phpbb_forums (
forum_id int(10) NOT NULL auto_increment,
- forum_order int(10) NOT NULL,
forum_name varchar(150),
forum_desc text,
forum_access tinyint(3),
cat_id int(10),
+ forum_order int(11) DEFAULT '1' NOT NULL,
forum_type tinyint(3),
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)
+ PRIMARY KEY (forum_id),
+ KEY forum_id (forum_id),
+ KEY forums_order (forum_order),
+ KEY cat_id (cat_id)
);
@@ -254,7 +258,7 @@ CREATE TABLE phpbb_topics (
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(10) DEFAULT '0' NOT NULL,
+ topic_replies int(11) DEFAULT '0' NOT NULL,
forum_id int(10) DEFAULT '0' NOT NULL,
topic_status tinyint(3) DEFAULT '0' NOT NULL,
topic_notify tinyint(3) DEFAULT '0',
@@ -329,3 +333,4 @@ CREATE TABLE phpbb_words (
replacement varchar(100) NOT NULL,
PRIMARY KEY (word_id)
);
+
--
cgit v1.2.1