osu-wayback/database_structs.sql

17 lines
452 B
MySQL
Raw Permalink Normal View History

2019-03-11 07:06:31 +01:00
CREATE TABLE `updates` (
`file_version` int(11) NOT NULL,
`filename` varchar(32) NOT NULL,
`file_hash` varchar(32) NOT NULL,
`filesize` int(11) NOT NULL,
`timestamp` int(11) NOT NULL,
`patch_id` int(11) DEFAULT NULL,
`url_full` varchar(128) NOT NULL,
`url_patch` varchar(128) DEFAULT NULL,
PRIMARY KEY (`file_version`)
);
CREATE TABLE `osu_builds` (
`id` int(11) NOT NULL,
`version` varchar(128) NOT NULL,
PRIMARY KEY (`id`)
);