Changeset 427 for trunk/db

Timestamp:

2011-04-22 08:23:54 (1 year ago)

Author:

hannes

Message:

redundant storage of number of posts per topic for better performance

Files:

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

trunk/db/mysql.sql

@@ -59 +59 @@
-  pinned INTEGER NOT NULL DEFAULT 0,
-  poll INTEGER NOT NULL DEFAULT 0,
-
+
+
-) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-

trunk/db/postgresql.sql

@@ -59 +59 @@
-  pinned INTEGER NOT NULL DEFAULT 0,
-  poll INTEGER NOT NULL DEFAULT 0,
-
+
+
-);
-

trunk/db/sqlite.sql

@@ -59 +59 @@
-  pinned INTEGER NOT NULL DEFAULT 0,
-  poll INTEGER NOT NULL DEFAULT 0,
-
+
+
-);
-