From 064712d1c7d4bdda946270c0899b6774b186e40f Mon Sep 17 00:00:00 2001 From: pk910 Date: Wed, 5 Oct 2011 22:53:39 +0200 Subject: [PATCH] add defaults to the channels table on database.upgrade_v4_v5.sql --- database.upgrade_v4_v5.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/database.upgrade_v4_v5.sql b/database.upgrade_v4_v5.sql index 9280f2f..089c6bb 100644 --- a/database.upgrade_v4_v5.sql +++ b/database.upgrade_v4_v5.sql @@ -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); -- 2.20.1