All pastes #624289 Raw Edit

Stuff

public diff v1 · immutable
·published 2007-07-18 05:07 UTC
rendered paste body
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