diff options
| author | Zach Prezkuta <fermion@gmx.com> | 2012-06-01 09:07:51 -0600 |
|---|---|---|
| committer | Zach Prezkuta <fermion@gmx.com> | 2012-06-03 14:53:30 -0600 |
| commit | b000088ded0d0f677114da0af1c5ea6436a97560 (patch) | |
| tree | c1987935d7ffe99ddc115e9748b7e5c1f23e2f4c | |
| parent | c0af6dbb1a5507dcf0fffaf13b42cfd71b0d0c50 (diff) | |
| download | volse-hubzilla-b000088ded0d0f677114da0af1c5ea6436a97560.tar.gz volse-hubzilla-b000088ded0d0f677114da0af1c5ea6436a97560.tar.bz2 volse-hubzilla-b000088ded0d0f677114da0af1c5ea6436a97560.zip | |
prepare to implement database update
| -rw-r--r-- | update.php | 12 |
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 |