X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;ds=sidebyside;f=database.upgrade.sql;h=cb710fdc55e9a4a6ea12c77d0bbe2c26a65cbcbd;hb=de4e38ad80dc9365a31e0226635e3cdf26b21577;hp=36c8b0faf7b761855bdb4c89d44b450bb06862dd;hpb=29181b1682d291ff9cf535b6d43a9660df93a73d;p=NeonServV5.git 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