X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.upgrade.sql;h=bb26d92bdfcddccd2a0cfb79869e5db3be1eda5b;hp=c8f34f3cd15c902ccf4fde86b0dc692032442e7e;hb=HEAD;hpb=3e82313bfb3eaf4f2b59dfc165372e3174be838b diff --git a/database.upgrade.sql b/database.upgrade.sql index c8f34f3..bb26d92 100644 --- a/database.upgrade.sql +++ b/database.upgrade.sql @@ -172,4 +172,17 @@ UPDATE `channels` SET `channel_badword_reaction` = '0', `channel_badword_reaction_duration` = '60', `channel_badword_except` = '400' WHERE `channel_name` = 'defaults'; ---version: 17 +-- version: 17 + +ALTER TABLE `bots` ADD `oper_user` VARCHAR( 50 ) NULL AFTER `automodes` , +ADD `oper_pass` VARCHAR( 50 ) NULL AFTER `oper_user`; + +-- version: 18 + +ALTER TABLE `users` ADD `user_block_invites` TINYINT NOT NULL AFTER `user_reply_privmsg`; + +-- version: 19 + +ALTER TABLE `bots` ADD `secret` TINYINT( 1 ) NOT NULL AFTER `queue`; + +-- version: 20