X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=b542d75ba50462b8a86747638b056fe6ede8d8b5;hb=77962aa79df5671e206635cc6980e4b1ac969bf9;hp=e1a554533ca4fab3d2314b922c4e181d644f7d55;hpb=c0af6dbb1a5507dcf0fffaf13b42cfd71b0d0c50;p=friendica.git diff --git a/update.php b/update.php index e1a554533c..b542d75ba5 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` ALTER `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