summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2003-09-18 09:13:59 +0000
committerDries Buytaert <dries@buytaert.net>2003-09-18 09:13:59 +0000
commit18312ed8e7e1e025ddf50340740421e00478150e (patch)
treeffd740f2705c4d91f4d5e0a4850fc2da13a55edd
parenta4a8381557928ffea119cfb59fc0109900fcda77 (diff)
downloadbrdo-18312ed8e7e1e025ddf50340740421e00478150e.tar.gz
brdo-18312ed8e7e1e025ddf50340740421e00478150e.tar.bz2
- Wrapped the table names in brackets. Patch by Bart.
-rw-r--r--update.php29
1 files changed, 14 insertions, 15 deletions
diff --git a/update.php b/update.php
index d4fef9ffc..ffd78dabf 100644
--- a/update.php
+++ b/update.php
@@ -353,18 +353,17 @@ function update_61() {
}
function update_62() {
- update_sql("ALTER TABLE accesslog ADD INDEX accesslog_timestamp (timestamp)");
+ update_sql("ALTER TABLE {accesslog} ADD INDEX accesslog_timestamp (timestamp)");
- update_sql("ALTER TABLE node DROP INDEX type");
- update_sql("ALTER TABLE node DROP INDEX title");
- update_sql("ALTER TABLE node DROP INDEX promote");
- update_sql("ALTER TABLE node DROP INDEX type");
+ update_sql("ALTER TABLE {node} DROP INDEX type");
+ update_sql("ALTER TABLE {node} DROP INDEX title");
+ update_sql("ALTER TABLE {node} DROP INDEX promote");
- update_sql("ALTER TABLE node ADD INDEX node_type (type(4))");
- update_sql("ALTER TABLE node ADD INDEX node_title_type (title,type(4))");
- update_sql("ALTER TABLE node ADD INDEX node_moderate (moderate)");
- update_sql("ALTER TABLE node ADD INDEX node_path (path(5))");
- update_sql("ALTER TABLE node ADD INDEX node_promote_status (promote, status)");
+ update_sql("ALTER TABLE {node} ADD INDEX node_type (type(4))");
+ update_sql("ALTER TABLE {node} ADD INDEX node_title_type (title,type(4))");
+ update_sql("ALTER TABLE {node} ADD INDEX node_moderate (moderate)");
+ update_sql("ALTER TABLE {node} ADD INDEX node_path (path(5))");
+ update_sql("ALTER TABLE {node} ADD INDEX node_promote_status (promote, status)");
}
function _update_next_thread($structure, $parent) {
@@ -383,14 +382,14 @@ function _update_next_thread($structure, $parent) {
}
function update_63() {
- update_sql("ALTER TABLE users CHANGE uid uid int(10) unsigned NOT NULL default '0'");
- update_sql("INSERT INTO users (uid, name, mail, timestamp) VALUES ('0', 'Anonymous', 'root@localhost', '". time() ."')");
- $users = db_result(db_query("SELECT MAX(uid) FROM users;"));
- update_sql("INSERT INTO sequences (name, id) VALUES ('users_uid', '$users')");
+ update_sql("ALTER TABLE {users} CHANGE uid uid int(10) unsigned NOT NULL default '0'");
+ update_sql("INSERT INTO {users} (uid, name, mail, timestamp) VALUES ('0', 'Anonymous', 'root@localhost', '". time() ."')");
+ $users = db_result(db_query("SELECT MAX(uid) FROM {users};"));
+ update_sql("INSERT INTO {sequences} (name, id) VALUES ('users_uid', '$users')");
}
function update_64() {
- update_sql("UPDATE users SET rid = 1 WHERE uid = 0");
+ update_sql("UPDATE {users} SET rid = 1 WHERE uid = 0");
}
/*