diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-02-26 00:36:48 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-02-26 00:36:48 +0000 |
| commit | dca34f5db988b18507a87974e93d416c0c372bda (patch) | |
| tree | cd327697ca3d51af95d5d553863fc7af5f2c1377 /phpBB/install | |
| parent | 108dbfe382cef0669125c93b9598e9c0b5d2d59a (diff) | |
| download | forums-dca34f5db988b18507a87974e93d416c0c372bda.tar forums-dca34f5db988b18507a87974e93d416c0c372bda.tar.gz forums-dca34f5db988b18507a87974e93d416c0c372bda.tar.bz2 forums-dca34f5db988b18507a87974e93d416c0c372bda.tar.xz forums-dca34f5db988b18507a87974e93d416c0c372bda.zip | |
Merge post and post_text tables ... denormalising of topics and forums should result in minimal fx on speed in 2.2
git-svn-id: file:///svn/phpbb/trunk@3537 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 30 |
1 files changed, 9 insertions, 21 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index ab67729743..40417f45f5 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -332,35 +332,23 @@ CREATE TABLE phpbb_posts ( poster_ip varchar(40) NOT NULL, post_time int(11) DEFAULT '0' NOT NULL, post_approved tinyint(1) DEFAULT '1' NOT NULL, - post_username varchar(30), enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, enable_html tinyint(1) DEFAULT '0' NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_magic_url tinyint(1) DEFAULT '1' NOT NULL, enable_sig tinyint(1) DEFAULT '1' NOT NULL, + post_username varchar(30), + post_subject varchar(60), + post_text text, + post_checksum varchar(32) NOT NULL, + post_encoding varchar(11) DEFAULT 'iso-8859-15' NOT NULL, + bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + bbcode_uid varchar(10) NOT NULL, post_edit_time int(11), post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), - KEY forum_id (forum_id), - KEY topic_id (topic_id), - KEY poster_id (poster_id), - KEY post_time (post_time) -); - - -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_posts_text' -# -CREATE TABLE phpbb_posts_text ( - post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - bbcode_uid varchar(10) NOT NULL, - bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, - post_checksum varchar(32) NOT NULL, - post_subject varchar(60), - post_text text, - post_encoding varchar(11) DEFAULT 'iso-8859-1' NOT NULL, - PRIMARY KEY (post_id) + KEY topic_id (topic_id), + KEY poster_ip (poster_ip) ); |