CREATE TABLE paa_lager (
id INT(10) NOT NULL,
bilmerkeID SMALLINT(6) NOT NULL,
modell VARCHAR(50),
km INT(6),
aarsmodell YEAR(4),
farge VARCHAR(40),
pris MEDIUMINT(9),
lagt_inn_dato DATE,
kommentarer VARCHAR(250),
automatgir TINYINT(1),
klimaanlegg TINYINT(1),
airc TINYINT(1),
takluke TINYINT(1),
sentral TINYINT(1),
radio_k TINYINT(1),
radio_cd TINYINT(1),
navi TINYINT(1),
comp TINYINT(1),
cruise TINYINT(1),
multiratt TINYINT(1),
skinn TINYINT(1),
elvindu TINYINT(1),
elspeil TINYINT(1),
hfeste TINYINT(1),
tlys TINYINT(1),
xenon TINYINT(1),
rails TINYINT(1),
rollo TINYINT(1),
metallic TINYINT(1),
alufelger TINYINT(1),
vhjul TINYINT(1),
4x4 TINYINT(1));

ALTER TABLE paa_lager 
ADD PRIMARY KEY (id);

ALTER TABLE paa_lager 
MODIFY id INT(10) NOT NULL AUTO_INCREMENT;