X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.upgrade.sql;h=cb710fdc55e9a4a6ea12c77d0bbe2c26a65cbcbd;hp=36c8b0faf7b761855bdb4c89d44b450bb06862dd;hb=de4e38ad80dc9365a31e0226635e3cdf26b21577;hpb=29181b1682d291ff9cf535b6d43a9660df93a73d diff --git a/database.upgrade.sql b/database.upgrade.sql index 36c8b0f..cb710fd 100644 --- a/database.upgrade.sql +++ b/database.upgrade.sql @@ -76,3 +76,10 @@ UNIQUE ( ) ENGINE = MYISAM ; -- version: 6 + +ALTER TABLE `fundata` CHANGE `uid` `user` VARCHAR( 50 ) NOT NULL; +ALTER TABLE `fundata` ADD INDEX ( `cid` ); +ALTER TABLE `fundata` ADD INDEX ( `user` ); +ALTER TABLE `fundata` ADD INDEX ( `name` ); + +-- version: 7