Файл: new_top/sql/migrate_stats.sql
Строк: 21
CREATE TABLE IF NOT EXISTS `rank_snap` (
`pf` int UNSIGNED NOT NULL,
`day` date NOT NULL,
`rank` int UNSIGNED NOT NULL DEFAULT 0,
`hs` int
UNSIGNED NOT NULL DEFAULT 0,
`ht` int UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`pf`, `day`),
KEY `day_rank` (`day`, `rank`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT
EXISTS `news` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`title`
varchar(150) NOT NULL DEFAULT '',
`text` text NOT NULL,
`time_add` int
UNSIGNED NOT NULL DEFAULT 0,
`active` tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `active_time` (`active`, `time_add`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;