KoenHofman
Member
Garage met werkende Database (is voor veel mensen een probleem blijkbaar!!)
CREATE TABLE IF NOT EXISTS owned_vehicles ( owner varchar(40) NOT NULL, plate varchar(12) NOT NULL, vehicle longtext DEFAULT NULL, type varchar(20) NOT NULL DEFAULT 'car', job varchar(20) NOT NULL DEFAULT 'civ', stored tinyint(1) NOT NULL DEFAULT 0, lasthouse int(11) DEFAULT 0, PRIMARY KEY (plate) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS owned_vehicles ( owner varchar(40) NOT NULL, plate varchar(12) NOT NULL, vehicle longtext DEFAULT NULL, type varchar(20) NOT NULL DEFAULT 'car', job varchar(20) NOT NULL DEFAULT 'civ', stored tinyint(1) NOT NULL DEFAULT 0, lasthouse int(11) DEFAULT 0, PRIMARY KEY (plate) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;