X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=database.upgrade.sql;h=84e9aeb7c37421edf64f0a375be98db4a7dc2f0b;hb=f80fa658483884289cf2585790b1cf64ef722197;hp=4d4a9e4c9638b403f1c2e14b3948fcff4042e918;hpb=c254e7d9a1622b19aae9b4ebecb4082657288f4a;p=NeonServV5.git diff --git a/database.upgrade.sql b/database.upgrade.sql index 4d4a9e4..84e9aeb 100644 --- a/database.upgrade.sql +++ b/database.upgrade.sql @@ -63,3 +63,28 @@ ALTER TABLE `channels` ALTER TABLE `bots` ADD `queue` TINYINT( 1 ) NOT NULL AFTER `textbot` -- version: 5 + +CREATE TABLE `donotregister` ( +`dnr_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , +`dnr_target` VARCHAR( 256 ) NOT NULL , +`dnr_user` INT( 11 ) NOT NULL , +`dnr_timeout` INT( 20 ) NOT NULL , +`dnr_reason` TEXT NOT NULL , +UNIQUE ( +`dnr_target` +) +) 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 + +ALTER TABLE `bot_binds` ADD `botid` INT( 11 ) NOT NULL AFTER `botclass`; +ALTER TABLE `bot_binds` ADD INDEX ( `botclass` ); + +-- version: 8 \ No newline at end of file