rendered paste body7,8d6< USE `irssi`';< 27a26> `network` CHAR(16) NOT NULL COMMENT 'Name of the network',29c28< UNIQUE KEY `idx_channel` (`channel`)---> UNIQUE KEY `idx_channel` (`channel`, `network`)100c99< `kicked_nick_id` int(10) unsigned NOT NULL COMMENT 'REF nicks table - Nick id only',---> `kicked_user_id` int(10) unsigned NOT NULL COMMENT 'REF user_id - Full Id of the kicked',105,106c104,105< KEY `FK_kicks_nick_id` (`kicked_nick_id`),< KEY `FK_kicks_user_id` (`kicker_user_id`),---> KEY `FK_kicks_kicked_id` (`kicked_user_id`),> KEY `FK_kicks_kicker_id` (`kicker_user_id`),108a108,109> CONSTRAINT `FK_kicks_kicked_id` FOREIGN KEY (`kicked_user_id`) REFERENCES `user_id` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,> CONSTRAINT `FK_kicks_kicker_id` FOREIGN KEY (`kicker_user_id`) REFERENCES `user_id` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,110,112c111< CONSTRAINT `FK_kicks_nick_id` FOREIGN KEY (`kicked_nick_id`) REFERENCES `nicks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,< CONSTRAINT `FK_kicks_reason_id` FOREIGN KEY (`reason_id`) REFERENCES `quit_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,< CONSTRAINT `FK_kicks_user_id` FOREIGN KEY (`kicker_user_id`) REFERENCES `user_id` (`id`) ON DELETE CASCADE ON UPDATE CASCADE---> CONSTRAINT `FK_kicks_reason_id` FOREIGN KEY (`reason_id`) REFERENCES `quit_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE