3.1 jp cvs version

[nucleus-jp/nucleus-jp-ancient.git] / euc / nucleus / upgrades / upgrade1.0.php

diff --git a/euc/nucleus/upgrades/upgrade1.0.php b/euc/nucleus/upgrades/upgrade1.0.php
new file mode 100755 (executable)
index 0000000..435889e
--- /dev/null
+++ b/euc/nucleus/upgrades/upgrade1.0.php
@@ -0,0 +1,41 @@
+<?php\r
+function upgrade_do10() {\r
+       \r
+if (upgrade_checkinstall(10))\r
+       return "already installed";\r
+\r
+// 1. add mcookiekey to nucleus_member\r
+$query =  'ALTER TABLE '.sql_table('member')\r
+       . " ADD mcookiekey varchar(40) ";\r
+$res = upgrade_query("Adding cookiekey attribute to members",$query);       \r
+\r
+// only do this when the previous query succeeds\r
+if ($res) {\r
+       // 2. for all members: hash their password and also copy it to mcookiekey\r
+       $query = 'SELECT * FROM '.sql_table('member');\r
+       $res = mysql_query($query);\r
+       while ($current = mysql_fetch_object($res)) {\r
+               $hashedpw = md5($current->mpassword);\r
+               $updquery = 'UPDATE '.sql_table('member')." SET mpassword='$hashedpw' WHERE mnumber=" . $current->mnumber;\r
+               upgrade_query("Encrypting password for member " . $current->mnumber,$updquery);\r
+       }\r
+}\r
+\r
+// 3. add extra indices to tables\r
+$query = 'ALTER TABLE '.sql_table('item').' ADD INDEX(iblog, itime);';\r
+upgrade_query("Adding extra index to nucleus_item",$query);\r
+$query = 'ALTER TABLE '.sql_table('comment').' ADD INDEX(citem);';\r
+upgrade_query("Adding extra index to nucleus_comment",$query);\r
+\r
+// 4. add DisableJsTools to config\r
+$query = 'INSERT INTO '.sql_table('config')." VALUES ('DisableJsTools', '0');";\r
+upgrade_query("Adding setting DisableJsTools",$query);\r
+\r
+// 5. Drop primary key in nucleus_actionlog\r
+$query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY;';\r
+upgrade_query("Dropping primary key for actionlog table",$query);\r
+\r
+}\r
+\r
+\r
+?>
\ No newline at end of file