· 7 years ago · Dec 02, 2018, 06:42 AM
1DROP TABLE IF EXISTS `files`;
2
3CREATE TABLE `files` (
4 `id` int(10) unsigned NOT NULL,
5 `extension` varchar(255) NOT NULL,
6 `filename` varchar(255) NOT NULL,
7 `byteSize` int(10) unsigned NOT NULL,
8 `mimeType` varchar(255) NOT NULL,
9 `created` timestamp NULL DEFAULT NULL,
10 PRIMARY KEY (),
11 INDEX (`id`)
12);