diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-03-09 20:37:44 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-03-09 20:37:44 +0000 |
| commit | 6be03b553d19c0598ea4101f1257bdcc2f81ab94 (patch) | |
| tree | 6a0f68712263b1a17ac6c6727f17b813d624b517 /phpBB/db | |
| parent | 0642a9f062c788a4801bb010ed455aac719f0455 (diff) | |
| download | forums-6be03b553d19c0598ea4101f1257bdcc2f81ab94.tar forums-6be03b553d19c0598ea4101f1257bdcc2f81ab94.tar.gz forums-6be03b553d19c0598ea4101f1257bdcc2f81ab94.tar.bz2 forums-6be03b553d19c0598ea4101f1257bdcc2f81ab94.tar.xz forums-6be03b553d19c0598ea4101f1257bdcc2f81ab94.zip | |
Current (perhaps) MySQL schema for phpBB2
git-svn-id: file:///svn/phpbb/trunk@93 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 15 |
1 files changed, 10 insertions, 5 deletions
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) ); + |