From fec9073f3a21818fa3bcfe89f0a73e861a3ad229 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Thu, 4 Sep 2003 18:30:20 +0000 Subject: initial draft functionality, loading (and a bunch of other stuff) is not implemented yet + bugfixes. git-svn-id: file:///svn/phpbb/trunk@4467 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/mysql_schema.sql | 13 +++++++++++++ phpBB/install/schemas/schema_data.sql | 1 + 2 files changed, 14 insertions(+) (limited to 'phpBB/install') diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index fd5d08eef1..b7fabcaf5b 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -133,6 +133,19 @@ CREATE TABLE phpbb_disallow ( PRIMARY KEY (disallow_id) ); +# Table: 'phpbb_drafts' +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, + 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, + PRIMARY KEY (draft_id), + KEY user_id (user_id,save_time) +); + # Table: 'phpbb_extensions' CREATE TABLE phpbb_extensions ( extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index a122c844f9..f2debab77c 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -235,6 +235,7 @@ INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgname', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgpasswd', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_chgcensors', 1); INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_search', 1); +INSERT INTO phpbb_auth_options (auth_option, is_global) VALUES ('u_savedrafts', 1); # MSSQL IDENTITY phpbb_styles ON # -- cgit v1.2.1