· 8 years ago · Apr 07, 2018, 02:26 PM
1CREATE TABLE IF NOT EXISTS `dock` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
4 `model` varchar(60) COLLATE utf8mb4_bin NOT NULL,
5 `price` int(11) NOT NULL,
6 `category` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;