mWxkJmVy

1mysql> DROP TABLE IF EXISTS vehicles;
2CREATE TABLE vehicles (
3id int(12) NOT NULL AUTO_INCREMENT,
4side varchar(15) NOT NULL,
5classname varchar(32) NOT NULL,
6type varchar(12) NOT NULL,
7pid varchar(32) NOT NULL,
8alive tinyint(1) NOT NULL DEFAULT ‘1’,
9active tinyint(1) NOT NULL DEFAULT ‘0’,
10plate int(20) NOT NULL,
11color int(20) NOT NULL,
12inventory varchar(500) NOT NULL,
13insure int(1) NOT NULL DEFAULT ‘0’,
14PRIMARY KEY (id),
15KEY side (side),
16KEY pid (pid),
17KEY type (type)
18) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=latin1;
19Query OK, 0 rows affected
20
211064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘1’,
22active tinyint(1) NOT NULL DEFAULT ‘0’,
23plate i' at line 7
24mysql>