Merge branch 'development'

[NeonServV5.git] / database.upgrade_v4_v5.sql

diff --git a/database.upgrade_v4_v5.sql b/database.upgrade_v4_v5.sql
index 9280f2f0e90bbfb8fbd5285504ef649f11552b07..3aee1824b784641474faea48d3347bc9afc2b65e 100644 (file)
--- 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);