Просмотр архива БитваТушканов php84



-- v22 progression systems: by Метриум (Стэлп)
CREATE TABLE
IF NOT EXISTS `game_meta` (`meta_key` varchar(64) NOT NULL,`meta_value`
text NOT NULL,PRIMARY KEY (`meta_key`)) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS
`trophy_user` (`user` int NOT NULL,`qualified_week` varchar(10) NOT NULL
DEFAULT '',`divine_until` int NOT NULL DEFAULT 0,`last_award_week`
varchar(10) NOT NULL DEFAULT '',PRIMARY KEY (`user`),KEY `divine_until`
(`divine_until`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `collector_heads`
(`user` int NOT NULL,`collection` tinyint NOT NULL,`head` tinyint NOT
NULL,`qty` int NOT NULL DEFAULT 0,PRIMARY KEY (`user`,`collection`,`head`))
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE
TABLE IF NOT EXISTS `relic_claims` (`user` int NOT NULL,`set_no` tinyint
NOT NULL,`week_key` varchar(10) NOT NULL,PRIMARY KEY
(`user`,`set_no`,`week_key`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `relic_daily`
(`user` int NOT NULL,`day_key` varchar(10) NOT NULL,PRIMARY KEY
(`user`,`day_key`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `tournament_archive`
(`id` bigint NOT NULL AUTO_INCREMENT,`week_key` varchar(10) NOT NULL,`kind`
varchar(24) NOT NULL,`position` tinyint NOT NULL,`entity_id` int NOT
NULL,`score` bigint NOT NULL DEFAULT 0,`reward_gold` bigint NOT NULL
DEFAULT 0,`reward_silver` bigint NOT NULL DEFAULT 0,PRIMARY KEY
(`id`),UNIQUE KEY `uq_week_kind_pos` (`week_key`,`kind`,`position`),KEY
`entity` (`kind`,`entity_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
INSERT INTO `game_meta`
(`meta_key`,`meta_value`) VALUES ('schema_version','22') ON DUPLICATE KEY
UPDATE `meta_value`='22';

ALTER TABLE `stars_dust_users` ADD COLUMN `dust`
int NOT NULL DEFAULT 0 AFTER `sunduk`;
ALTER TABLE `stars_dust_users` ADD
COLUMN `cycle_key` varchar(24) NOT NULL DEFAULT '' AFTER `time`;
ALTER
TABLE `inv` ADD COLUMN `stars` tinyint NOT NULL DEFAULT 0 AFTER `smith`;