Changeset 32

Timestamp:

2007-11-25 21:38:20 (4 years ago)

Author:

hannes

Message:

creating table indexes for better performance

Files:

• trunk/db/mysql.sql (modified) (1 diff)
• trunk/db/spamboard.sql (modified) (1 diff)
• trunk/db/sqlite.sql (added)

trunk/db/mysql.sql

@@ -9 +9 @@
-ALTER TABLE %prefix%members MODIFY memberid INTEGER AUTO_INCREMENT;
-ALTER TABLE %prefix%mails MODIFY id INTEGER AUTO_INCREMENT;
+
+CREATE INDEX idx_forums ON %prefix%forums (forum_category ASC);
+CREATE INDEX idx_topics ON %prefix%topics (forum ASC);
+CREATE INDEX idx_posts ON %prefix%posts (topic DESC, posttime ASC);

trunk/db/spamboard.sql

@@ -1 +1 @@
-CREATE TABLE %prefix%categories (
- 
+
-  category_name VARCHAR(255) NOT NULL,
-  category_order INTEGER NOT NULL,