X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.upgrade_v4_v5.sql;h=3aee1824b784641474faea48d3347bc9afc2b65e;hp=9280f2f0e90bbfb8fbd5285504ef649f11552b07;hb=HEAD;hpb=c172c80ca937bb4a2eb30b86c56c4019bb469c29 diff --git a/database.upgrade_v4_v5.sql b/database.upgrade_v4_v5.sql index 9280f2f..3aee182 100644 --- a/database.upgrade_v4_v5.sql +++ b/database.upgrade_v4_v5.sql @@ -41,7 +41,7 @@ ALTER TABLE `bots` ADD `max_channels` INT( 5 ) NOT NULL ; ALTER TABLE `bot_binds` CHANGE `botid` `botclass` INT( 11 ) NOT NULL; ALTER TABLE `bots` DROP `whoisbot` ; ALTER TABLE `bots` DROP `bindFrom` ; -ALTER TABLE `bots` ADD `register_order` INT( 2 ) NOT NULL; +ALTER TABLE `bots` ADD `register_priority` INT( 2 ) NOT NULL; CREATE TABLE IF NOT EXISTS `help` ( `id` int(11) NOT NULL AUTO_INCREMENT, @@ -70,4 +70,7 @@ CREATE TABLE IF NOT EXISTS `version` ( PRIMARY KEY (`database_version`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -INSERT INTO `version` (`database_version`) VALUES (1); \ No newline at end of file +INSERT INTO `version` (`database_version`) VALUES (1); + +INSERT INTO `channels` (`channel_name`, `channel_key`, `channel_maxusers`, `channel_lastvisit`, `channel_lastgiveowner`, `channel_pubcmd`, `channel_nodelete`, `channel_nogaccess`, `channel_canadd`, `channel_candel`, `channel_canclvl`, `channel_cankick`, `channel_canban`, `channel_staticban`, `channel_protect`, `channel_canop`, `channel_canvoice`, `channel_getop`, `channel_getvoice`, `channel_greeting`, `channel_usergreeting`, `channel_userinfo`, `channel_scanstate`, `channel_scanexcept`, `channel_maxrepeat`, `channel_repeatreaction`, `channel_maxflood`, `channel_floodtime`, `channel_floodreaction`, `channel_maxjoin`, `channel_jointime`, `channel_joinreaction`, `channel_dynlimit`, `channel_getinvite`, `channel_topicmask`, `channel_exttopic`, `channel_exttopic_topic`, `channel_defaulttopic`, `channel_wipeinfo`, `channel_modes`, `channel_enfmodes`, `channel_enftopic`, `channel_topicsnarf`, `channel_changetopic`, `channel_setters`, `channel_canresync`, `channel_cansuspend`, `channel_notice`, `channel_noticereaction`, `channel_ctcp`, `channel_ctcpreaction`, `channel_registered`, `channel_registrator`, `channel_toys`) VALUES +('defaults', '', 0, 0, 0, 0, 0, 0, 300, 300, 300, 200, 200, 250, 0, 200, 200, 200, 100, '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, '', '', 300, '+', 400, 400, 501, 200, 400, 200, 300, 0, 0, 0, 0, 0, 0, 0);