-- Database of NeonServ V4 modifications for NeonServ V5 ALTER TABLE `bots` CHANGE `botclass` `botclass` INT( 10 ) NOT NULL; ALTER TABLE `users` CHANGE `user_lang` `user_lang` VARCHAR( 6 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE `users` ADD `user_reply_privmsg` TINYINT( 1 ) NOT NULL ; CREATE TABLE IF NOT EXISTS `godlog` ( `godlog_id` int(11) NOT NULL AUTO_INCREMENT, `godlog_uid` int(11) NOT NULL, `godlog_cid` int(15) NOT NULL, `godlog_time` int(15) NOT NULL, `godlog_cmd` varchar(512) NOT NULL, PRIMARY KEY (`godlog_id`) ) ENGINE=MyISAM; ALTER TABLE `channels` ADD `channel_lastgiveowner` INT( 11 ) NOT NULL AFTER `channel_lastvisit`; CREATE TABLE IF NOT EXISTS `owner_history` ( `owner_history_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `owner_history_cid` INT( 11 ) NOT NULL , `owner_history_uid` INT( 11 ) NOT NULL , `owner_history_time` INT( 11 ) NOT NULL , INDEX ( `owner_history_cid` ) ) ENGINE = MYISAM ; ALTER TABLE `chanusers` ADD INDEX ( `chanuser_cid` ) ; ALTER TABLE `chanusers` ADD INDEX ( `chanuser_uid` ) ; ALTER TABLE `bot_binds` ADD `chan_access` VARCHAR( 256 ) NULL DEFAULT NULL AFTER `parameters`; ALTER TABLE `bot_binds` CHANGE `global_access` `global_access` INT( 3 ) NULL; ALTER TABLE `bans` CHANGE `ban_owner` `ban_owner` INT( 11 ) NOT NULL; ALTER TABLE `channels` ADD `channel_exttopic` TINYINT( 1 ) NOT NULL AFTER `channel_topicmask` , ADD `channel_exttopic_topic` VARCHAR( 512 ) NOT NULL AFTER `channel_exttopic`; 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` ; CREATE TABLE IF NOT EXISTS `help` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lang` varchar(6) NOT NULL, `ident` varchar(64) NOT NULL, `text` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `language` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lang` varchar(5) NOT NULL, `ident` varchar(64) NOT NULL, `text` varchar(256) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ALTER TABLE `bot_channels` ADD `suspended` TINYINT( 1 ) NOT NULL; ALTER TABLE `users` ADD UNIQUE (`user_user`); ALTER TABLE `noinvite` ADD INDEX ( `cid`, `uid` );