· 7 years ago · Oct 17, 2018, 09:00 PM
1CREATE TABLE IF NOT EXISTS `mdc_anpr` (
2`id` int(11) NOT NULL,
3 `vehicle_plate` varchar(255) NOT NULL,
4 `description` text NOT NULL,
5 `doneby` int(11) NOT NULL,
6 `time` int(11) NOT NULL,
7 `organization` varchar(10) NOT NULL
8) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
9
10ALTER TABLE `mdc_anpr`
11 ADD PRIMARY KEY (`id`);