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

-- Игра v50.3 event/ring/achievement schema patch.
-- Import into the
already selected hosting database. No CREATE DATABASE statement is
used.
SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS
`achievement_v50_bonus` (
  `user` int NOT NULL,
  `grades` int NOT NULL
DEFAULT 0,
  PRIMARY KEY (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `automation_log` (

 `code` varchar(64) NOT NULL,
  `period_key` varchar(32) NOT NULL,
 
`created_at` int NOT NULL,
  PRIMARY KEY (`code`,`period_key`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE
TABLE IF NOT EXISTS `bonus_kit_offer` (
  `user` int NOT NULL,
 
`expires_at` int NOT NULL,
  `claimed` tinyint NOT NULL DEFAULT 0,
 
PRIMARY KEY (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `ring_catalog` (
 
`id` tinyint NOT NULL,
  `name` varchar(80) NOT NULL,
  `description`
varchar(255) NOT NULL,
  `price` int NOT NULL DEFAULT 250,
  `kind`
varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS
`user_rings` (
  `user` int NOT NULL,
  `ring_id` tinyint NOT NULL,
 
`slot` tinyint NOT NULL DEFAULT 0,
  `level` smallint NOT NULL DEFAULT 1,
 
`rune` tinyint NOT NULL DEFAULT 0,
  `bonus` smallint NOT NULL DEFAULT 0,
 
`stars` tinyint NOT NULL DEFAULT 0,
  `smith` smallint NOT NULL DEFAULT 0,

 PRIMARY KEY (`user`,`ring_id`),
  KEY `slot` (`user`,`slot`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT
IGNORE INTO `ring_catalog` (`id`,`name`,`description`,`price`,`kind`)
VALUES
(1,'Кольцо Ярости','Увеличивает силу
критического удара в зависимости от
потерянного здоровья',250,'rage'),
(2,'Кольцо
Защиты','Увеличивает броню при отражении
критического удара в зависимости от
потерянного здоровья',250,'guard'),
(3,'Кольцо
Воскрешения','Воскрешает владельца в
момент получения смертельного
удара',250,'revive');

CREATE TABLE IF NOT EXISTS `undying_v51_event`
(
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `state`
enum('waiting','running','finished') NOT NULL DEFAULT 'waiting',
 
`signup_end` int unsigned NOT NULL,
  `battle_end` int unsigned NOT NULL
DEFAULT 0,
  `last_tick` int unsigned NOT NULL DEFAULT 0,
  `winner`
tinyint NOT NULL DEFAULT -1,
  `created_at` int unsigned NOT NULL,
 
`finished_at` int unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`), KEY
`state_time` (`state`,`signup_end`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS
`undying_v51_member` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
 
`event_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL DEFAULT
0,
  `team` tinyint unsigned NOT NULL DEFAULT 0,
  `is_bot` tinyint(1) NOT
NULL DEFAULT 0,
  `name` varchar(80) NOT NULL,
  `clan_id` int unsigned NOT
NULL DEFAULT 0,
  `hp` bigint unsigned NOT NULL DEFAULT 1,
  `max_hp`
bigint unsigned NOT NULL DEFAULT 1,
  `power` bigint unsigned NOT NULL
DEFAULT 1,
  `defense` bigint unsigned NOT NULL DEFAULT 0,
  `damage`
bigint unsigned NOT NULL DEFAULT 0,
  `kills` int unsigned NOT NULL DEFAULT
0,
  `dead` tinyint(1) NOT NULL DEFAULT 0,
  `target_id` int unsigned NOT
NULL DEFAULT 0,
  `joined_at` int unsigned NOT NULL,
  `last_action` int
unsigned NOT NULL DEFAULT 0,
  `stone_cd` int unsigned NOT NULL DEFAULT 0,

 `grass_cd` int unsigned NOT NULL DEFAULT 0,
  `stone_until` int unsigned
NOT NULL DEFAULT 0,
  `reward_claimed` tinyint(1) NOT NULL DEFAULT 0,
 
PRIMARY KEY (`id`), KEY `event_team` (`event_id`,`team`,`dead`), KEY
`event_user` (`event_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `undying_v51_log`
(
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int unsigned
NOT NULL,
  `created_at` int unsigned NOT NULL,
  `text` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`), KEY `event_id` (`event_id`,`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE
TABLE IF NOT EXISTS `undying_v51_bonus` (
  `event_id` int unsigned NOT
NULL,
  `user_id` int unsigned NOT NULL,
  `power` int unsigned NOT NULL
DEFAULT 0,
  PRIMARY KEY (`event_id`,`user_id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS
`altar_v51_event` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `state`
enum('waiting','running','finished') NOT NULL DEFAULT 'waiting',
 
`signup_end` int unsigned NOT NULL,
  `battle_end` int unsigned NOT NULL
DEFAULT 0,
  `last_tick` int unsigned NOT NULL DEFAULT 0,
  `altar_unit`
bigint unsigned NOT NULL DEFAULT 5000,
  `created_at` int unsigned NOT
NULL,
  `finished_at` int unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY
(`id`), KEY `state_time` (`state`,`signup_end`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS
`altar_v51_member` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
 
`event_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL DEFAULT
0,
  `is_bot` tinyint(1) NOT NULL DEFAULT 0,
  `clan_id` int unsigned NOT
NULL DEFAULT 0,
  `name` varchar(80) NOT NULL,
  `hp` bigint unsigned NOT
NULL DEFAULT 1,
  `max_hp` bigint unsigned NOT NULL DEFAULT 1,
  `power`
bigint unsigned NOT NULL DEFAULT 1,
  `defense` bigint unsigned NOT NULL
DEFAULT 0,
  `damage` bigint unsigned NOT NULL DEFAULT 0,
  `kills` int
unsigned NOT NULL DEFAULT 0,
  `dead` tinyint(1) NOT NULL DEFAULT 0,
 
`target_id` int unsigned NOT NULL DEFAULT 0,
  `joined_at` int unsigned NOT
NULL,
  `last_action` int unsigned NOT NULL DEFAULT 0,
  `stone_cd` int
unsigned NOT NULL DEFAULT 0,
  `grass_cd` int unsigned NOT NULL DEFAULT 0,

 `stone_until` int unsigned NOT NULL DEFAULT 0,
  `reward_claimed`
tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`), KEY `event_alive`
(`event_id`,`dead`), KEY `event_user` (`event_id`,`user_id`), KEY
`event_clan` (`event_id`,`clan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `altar_v51_log` (
 
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int unsigned NOT
NULL,
  `created_at` int unsigned NOT NULL,
  `text` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`), KEY `event_id` (`event_id`,`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE
TABLE IF NOT EXISTS `altar_v51_bonus` (
  `event_id` int unsigned NOT
NULL,
  `user_id` int unsigned NOT NULL,
  `power` int unsigned NOT NULL
DEFAULT 0,
  PRIMARY KEY (`event_id`,`user_id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS
`altar_v51_clan_result` (
  `event_id` int unsigned NOT NULL,
  `clan_id`
int unsigned NOT NULL,
  `place` smallint unsigned NOT NULL DEFAULT 0,
 
`altars` tinyint unsigned NOT NULL DEFAULT 0,
  `damage` bigint unsigned
NOT NULL DEFAULT 0,
  `reward_gold` int unsigned NOT NULL DEFAULT 0,
 
`reward_silver` int unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY
(`event_id`,`clan_id`), KEY `event_place` (`event_id`,`place`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE
TABLE IF NOT EXISTS `aid_v53_player` (
  `user_id` int unsigned NOT NULL,
 
`damage` bigint unsigned NOT NULL DEFAULT 0,
  `attacks` int unsigned NOT
NULL DEFAULT 0,
  `last_attack` int unsigned NOT NULL DEFAULT 0,
  `kills`
int unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;