7,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