Changeset 1075

Timestamp:

10/27/07 18:38:38 (11 months ago)

Author:

Neal

Message:

Added the unique index online_user_id_ident_idx to the online table for PostgreSQL and SQLite (MySQL has had this index already). The index ensures that a user can not have multiple rows with the same ident.
Changed instances of $db_prefix to $db->prefix in extras/db_update.php.

Files:

• branches/punbb-1.3-dev/extras/db_update.php (modified) (10 diffs)
• branches/punbb-1.3-dev/upload/install.php (modified) (1 diff)

branches/punbb-1.3-dev/extras/db_update.php

@@ -339 +339 @@
-        case 'start':
-                // Add the extensions table if it doesn't already exist
-_
+->
-                {
-                        switch ($db_type)
@@ -345 +345 @@
-                                case 'mysql':
-                                case 'mysqli':
-_
+->
-                                                        id VARCHAR(50) NOT NULL DEFAULT '',
-                                                        title VARCHAR(255) NOT NULL DEFAULT '',
@@ -357 +357 @@
-
-                                case 'pgsql':
-_
+->
-                                                        id VARCHAR(50) NOT NULL DEFAULT '',
-                                                        title VARCHAR(255) NOT NULL DEFAULT '',
@@ -369 +369 @@
-
-                                case 'sqlite':
-_
+->
-                                                        id VARCHAR(50) NOT NULL DEFAULT '',
-                                                        title VARCHAR(255) NOT NULL DEFAULT '',
@@ -385 +385 @@
-
-                // Add the extension_hooks table if it doesn't already exist
-_
+->
-                {
-                        switch ($db_type)
@@ -391 +391 @@
-                                case 'mysql':
-                                case 'mysqli':
-_
+->
-                                                        id VARCHAR(50) NOT NULL DEFAULT '',
-                                                        extension_id VARCHAR(50) NOT NULL DEFAULT '',
@@ -401 +401 @@
-
-                                case 'pgsql':
-_
+->
-                                                        id VARCHAR(50) NOT NULL DEFAULT '',
-                                                        extension_id VARCHAR(50) NOT NULL DEFAULT '',
@@ -411 +411 @@
-
-                                case 'sqlite':
-_
+->
-                                                        id VARCHAR(50) NOT NULL DEFAULT '',
-                                                        extension_id VARCHAR(50) NOT NULL DEFAULT '',
@@ -523 +523 @@
-
-                // We need to add a unique index to avoid users having multiple rows in the online table
-($db_type == 'mysql' || $db_type == 'mysqli') && 
+
-                {
-                        $db->query('DELETE FROM '.$db->prefix.'online') or error(__FILE__, __LINE__);
-
+
+
+
+
+
+
+
+
+
+
+
+
-                }
-
-                // Get rid of the old search tables for mysql/mysqli
-_prefix.'search_cache') && $db->table_exists($db_prefix.'search_matches') && $db->table_exists($db_
+->prefix.'search_cache') && $db->table_exists($db->prefix.'search_matches') && $db->table_exists($db->
-                        $db->query('DROP TABLE '.$db->prefix.'search_cache, '.$db->prefix.'search_matches, '.$db->prefix.'search_words') or error(__FILE__, __LINE__);
-
-                // Add fulltext indexes for mysql/mysqli
-                if (($db_type == 'mysql' || $db_type == 'mysqli') && !$db->index_exists($db->prefix.'posts', $db->prefix.'posts_message_idx'))
-_prefix.'posts ADD FULLTEXT '.$db_
+->prefix.'posts ADD FULLTEXT '.$db->
-                if (($db_type == 'mysql' || $db_type == 'mysqli') && !$db->index_exists($db->prefix.'topics', $db->prefix.'topics_subject_idx'))
-_prefix.'topics ADD FULLTEXT '.$db_
+->prefix.'topics ADD FULLTEXT '.$db->
-
-                // Add an index on last_post in the topics table
@@ -546 +557 @@
-                                case 'mysql':
-                                case 'mysqli':
-_prefix.'topics ADD INDEX '.$db_
+->prefix.'topics ADD INDEX '.$db->
-                                        break;
-
-                                default:
-_prefix.'topics_last_post_idx ON '.$db_
+->prefix.'topics_last_post_idx ON '.$db->
-                                        break;
-                        }

branches/punbb-1.3-dev/upload/install.php

@@ -1339 +1339 @@
-
-                default:
+                        $queries[] = 'CREATE UNIQUE INDEX '.$db_prefix.'online_user_id_ident_idx ON '.$db_prefix.'online(user_id,ident)';
-                        $queries[] = 'CREATE INDEX '.$db_prefix.'online_user_id_idx ON '.$db_prefix.'online(user_id)';
-                        $queries[] = 'CREATE INDEX '.$db_prefix.'posts_topic_id_idx ON '.$db_prefix.'posts(topic_id)';