aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_schema.sql
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2003-11-16 21:53:56 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2003-11-16 21:53:56 +0000
commit306d36f03dadde4ed99410ea907ec82cef1848b6 (patch)
tree3828d33092e95fcfd30659997a65ffc5e5e01e04 /phpBB/install/schemas/mysql_schema.sql
parente80f40d5bb754aaa720c9e240e6310bff76cea70 (diff)
downloadforums-306d36f03dadde4ed99410ea907ec82cef1848b6.tar
forums-306d36f03dadde4ed99410ea907ec82cef1848b6.tar.gz
forums-306d36f03dadde4ed99410ea907ec82cef1848b6.tar.bz2
forums-306d36f03dadde4ed99410ea907ec82cef1848b6.tar.xz
forums-306d36f03dadde4ed99410ea907ec82cef1848b6.zip
Finished drafts, one bit is remaining though.
added file and disk space statistics. some minor changes here and there. git-svn-id: file:///svn/phpbb/trunk@4668 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 288e2ab5ab..64af877777 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -4,7 +4,7 @@
# $Id$
#
-# Table: phpbb_attachments_desc
+# Table: phpbb_attachments
CREATE TABLE phpbb_attachments (
attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -146,12 +146,12 @@ CREATE TABLE phpbb_drafts (
draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,
user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- title varchar(60) DEFAULT '' NOT NULL,
- post_subject varchar(60),
- post_message text DEFAULT '' NOT NULL,
+ draft_subject varchar(60),
+ draft_message text DEFAULT '' NOT NULL,
PRIMARY KEY (draft_id),
- KEY user_id (user_id,save_time)
+ KEY save_time (save_time)
);
# Table: 'phpbb_extensions'