Файл: database/migrations/v50_9_economy_quests_collections.sql
Строк: 42
-- Игра v50.9: collections, daily quests, payment receipts and
bonus-kit eligibility.
-- Import into the already selected hosting
database. No CREATE DATABASE statement.
SET NAMES utf8mb4;
CREATE TABLE IF
NOT EXISTS `daily_quest_assignment` (
`user` int unsigned NOT
NULL,`day_key` char(10) NOT NULL,`quest_id` int unsigned NOT NULL,`slot`
tinyint unsigned NOT NULL,
PRIMARY KEY(`user`,`day_key`,`quest_id`),UNIQUE
KEY `uq_daily_slot`(`user`,`day_key`,`slot`),KEY
`day_quest`(`day_key`,`quest_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `economy_gold_daily`
(
`user` int unsigned NOT NULL,`day_key` char(10) NOT NULL,`source`
varchar(32) NOT NULL,`earned` int unsigned NOT NULL DEFAULT 0,
PRIMARY
KEY(`user`,`day_key`,`source`),KEY `user_day`(`user`,`day_key`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE
TABLE IF NOT EXISTS `payment_receipts` (
`receipt_hash` char(64) NOT
NULL,`user` int NOT NULL,`gold` int NOT NULL DEFAULT 0,`amount`
decimal(12,2) NOT NULL DEFAULT 0,`created_at` int NOT NULL,
PRIMARY
KEY(`receipt_hash`),KEY `user_time`(`user`,`created_at`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;