· 6 years ago · Nov 17, 2019, 06:41 PM
1CREATE TABLE IF NOT EXISTS `truck_inventory` (
2`id` int(11) NOT NULL,
3 `item` varchar(100) NOT NULL,
4 `count` int(11) NOT NULL,
5 `plate` varchar(8) NOT NULL,
6 `name` varchar(255) NOT NULL,
7 `owned` varchar(255) NOT NULL
8) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9
10ALTER TABLE `truck_inventory`
11 ADD PRIMARY KEY (`id`);
12
13ALTER TABLE `truck_inventory`
14MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
15
16ALTER TABLE `truck_inventory` ADD UNIQUE( `item`, `plate`);