mirror of
https://github.com/smogon/pokemon-showdown-client.git
synced 2026-03-21 17:50:29 -05:00
7a2b323eaf
The idea is to eventually move all client parts to their domain name subdirectory, for clarity and better organization. New Replays is just first. Anyway, yeah, minor updates to New Replays, but otherwise it's just getting deployed as-is, straight to https://replay.pokemonshowdown.com/ The old URLs are getting taken down; they were only used for development anyway.
27 lines
845 B
SQL
27 lines
845 B
SQL
--
|
|
-- Table structure for table `ps_replays`
|
|
--
|
|
|
|
CREATE TABLE `ps_replays` (
|
|
`id` varbinary(255) NOT NULL DEFAULT '',
|
|
`p1` varchar(45) NOT NULL,
|
|
`p2` varchar(45) NOT NULL,
|
|
`format` varchar(45) NOT NULL,
|
|
`log` mediumtext NOT NULL,
|
|
`inputlog` mediumtext,
|
|
`uploadtime` bigint(20) NOT NULL,
|
|
`views` int(11) NOT NULL DEFAULT '0',
|
|
`p1id` varbinary(45) NOT NULL,
|
|
`p2id` varbinary(45) NOT NULL,
|
|
`formatid` varbinary(45) NOT NULL,
|
|
`rating` int(11) NOT NULL DEFAULT '0',
|
|
`private` tinyint(1) NOT NULL,
|
|
`password` varchar(31) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `p1` (`private`,`p1id`,`uploadtime`),
|
|
KEY `p2` (`private`,`p2id`,`uploadtime`),
|
|
KEY `top` (`private`,`formatid`,`rating`),
|
|
KEY `format` (`private`,`formatid`,`uploadtime`),
|
|
KEY `recent` (`private`,`uploadtime`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|