Файл: database/migrations/database_v24_clan_emblems.sql
Строк: 18
-- v24 clan emblems — by Метриум (Стэлп)
CREATE TABLE IF NOT
EXISTS `clan_emblems` (
`clan` int(11) NOT NULL,
`emblem_id` tinyint
unsigned NOT NULL,
`purchased_at` int(11) NOT NULL DEFAULT 0,
`purchased_by` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY
(`clan`,`emblem_id`), KEY `idx_emblem` (`emblem_id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT IGNORE INTO
`clan_emblems` (`clan`,`emblem_id`,`purchased_at`,`purchased_by`) SELECT
`id`,IF(`gerb` BETWEEN 1 AND 17,`gerb`,1),UNIX_TIMESTAMP(),0 FROM `clans`;