diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2003-11-16 21:53:56 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2003-11-16 21:53:56 +0000 |
| commit | 306d36f03dadde4ed99410ea907ec82cef1848b6 (patch) | |
| tree | 3828d33092e95fcfd30659997a65ffc5e5e01e04 /phpBB/install/schemas | |
| parent | e80f40d5bb754aaa720c9e240e6310bff76cea70 (diff) | |
| download | forums-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')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 10 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 2 |
2 files changed, 7 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' diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index 705ecb799a..fa48031312 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -157,6 +157,8 @@ INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('newest INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_users', '1', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_posts', '1', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_topics', '1', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('num_files', '0', 1); +INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('upload_dir_size', '0', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('session_last_gc', '0', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('search_last_gc', '0', 1); INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('last_queue_run', '0', 1); |