Create Uploads table.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE TABLE `uploads` (
`id` int(11) NOT NULL,
`category` varchar(45) DEFAULT NULL,
`excelFile` varchar(255) DEFAULT NULL,
`path` varchar(45) DEFAULT NULL,
`dateUploaded` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
ALTER TABLE `uploads`
ADD PRIMARY KEY (`id`);
 
ALTER TABLE `uploads`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;
 
<span style="background-color:#f3f6f8;font-family:Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', 'Courier 10 Pitch', Courier, monospace;">