CREATE TABLE solgte (
id INT(10) NOT NULL,
bilmerkeID SMALLINT(6) NOT NULL,
modell VARCHAR(50),
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),
opprinneligID INT(4),
solgt_dato DATE,
salgspris MEDIUMINT(9)
kundeID INT(10));

ALTER TABLE solgte 
ADD PRIMARY KEY (id);

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