diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-06-23 14:00:57 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-06-23 14:00:57 +0000 |
| commit | 7661a5d040a3827e9ab39b825b47a8f036cda21b (patch) | |
| tree | 8201c04116534dea228aa05d6f8e0f6a01943ffb /phpBB/install | |
| parent | 36685677dd8a7a607629394c3f6d238efe689139 (diff) | |
| download | forums-7661a5d040a3827e9ab39b825b47a8f036cda21b.tar forums-7661a5d040a3827e9ab39b825b47a8f036cda21b.tar.gz forums-7661a5d040a3827e9ab39b825b47a8f036cda21b.tar.bz2 forums-7661a5d040a3827e9ab39b825b47a8f036cda21b.tar.xz forums-7661a5d040a3827e9ab39b825b47a8f036cda21b.zip | |
Global announcements ... sort of work ... well they seem to, need to look at possbility of splitting topics table in two
git-svn-id: file:///svn/phpbb/trunk@4167 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 4 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 1 |
2 files changed, 1 insertions, 4 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 2b6cc777bd..2202db9a35 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -585,10 +585,8 @@ CREATE TABLE phpbb_topics ( poll_last_vote int(11), PRIMARY KEY (topic_id), KEY forum_id (forum_id), - KEY topic_moved_id (topic_moved_id), + KEY forum_id_type (forum_id, topic_type), KEY topic_last_post_time (topic_last_post_time), - KEY poll_last_vote (poll_last_vote), - KEY topic_type (topic_type) ); # Table: 'phpbb_topic_marking' diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index da9c0b3750..ceee25cb86 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -157,7 +157,6 @@ INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_delete', 1); INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_poll', 1); INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_vote', 1); INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_votechg', 1); -INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_global', 1); INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_announce', 1); INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_sticky', 1); INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_attach', 1); |