· 5 years ago · Apr 09, 2020, 11:30 PM
1CREATE TABLE IF NOT EXISTS `downloads` (
2 `uid` int(6) unsigned NOT NULL,
3 `tstamp` int(3) unsigned NOT NULL,
4 `fid` int(3) unsigned NOT NULL,
5 `notes` varchar(200) NOT NULL,
6 PRIMARY KEY (`uid`,`fid`)
7) DEFAULT CHARSET=utf8;
8INSERT INTO `downloads` (`uid`, `tstamp`, `fid`, `notes`) VALUES
9(1, 1352001731, 14, ''),
10(1, 1357403888, 20, ''),
11(2, 1357432414, 9, ''),
12(2, 1357544813, 4, ''),
13(1, 1357653803, 12, '');
14
15CREATE TABLE IF NOT EXISTS `files` (
16 `id` int(6) unsigned NOT NULL,
17 `guid` int(3) unsigned NOT NULL,
18 `uid` int(3) unsigned NOT NULL,
19 `size` int(16) NOT NULL,
20 PRIMARY KEY (`id`,`size`)
21) DEFAULT CHARSET=utf8;
22INSERT INTO `files` (`id`, `guid`, `uid`, `size`) VALUES
23(12, 35, 57, 10910074),
24(20, 47, 42, 9348993),
25(11, 35, 57, 76510074),
26(47, 47, 52, 45548993),
27(9, 35, 37, 1560074),
28(4, 47, 22, 6788993),
29(15, 51, 12, 323450993);