summaryrefslogtreecommitdiff
path: root/database/updates.inc
diff options
context:
space:
mode:
Diffstat (limited to 'database/updates.inc')
-rw-r--r--database/updates.inc11
1 files changed, 10 insertions, 1 deletions
diff --git a/database/updates.inc b/database/updates.inc
index 084036657..2ee4acf70 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -111,7 +111,8 @@ $sql_updates = array(
"2005-04-14" => "update_132",
"2005-04-24" => "update_133",
"2005-04-30" => "update_134",
- "2005-05-06" => "update_135"
+ "2005-05-06" => "update_135",
+ "2005-05-08" => "update_136"
);
function update_32() {
@@ -2447,6 +2448,14 @@ function update_135() {
return array();
}
+function update_136() {
+ $ret = array();
+ $ret[] = update_sql("ALTER TABLE {users} CHANGE COLUMN changed access int(11) NOT NULL default '0'");
+ $ret[] = update_sql('UPDATE {users} SET access = login WHERE login > created');
+ $ret[] = update_sql('UPDATE {users} SET access = created WHERE access = 0');
+ return $ret;
+}
+
function update_sql($sql) {
$edit = $_POST["edit"];
$result = db_query($sql);