aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--update.php12
1 files changed, 11 insertions, 1 deletions
diff --git a/update.php b/update.php
index e1a554533..9d534a127 100644
--- a/update.php
+++ b/update.php
@@ -1274,5 +1274,15 @@ function update_1146() {
return UPDATE_SUCCESS ;
}
-//ALTER TABLE `sign` MODIFY column int Default '10';
+/*
+function update_xxxx() {
+ $r1 = q("ALTER TABLE `sign` MODIFY `iid` SET DEFAULT '0'");
+ $r2 = q("ALTER TABLE `sign` ADD `retract_iid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `iid`");
+ $r3 = q("ALTER TABLE `sign` ADD INDEX ( `retract_iid` )");
+ if((! $r1) || (! $r2) || (! $r3))
+ return UPDATE_FAILED ;
+ return UPDATE_SUCCESS ;
+}
+*/
+// dump DB schema: mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql