Sql Auto_increment

Hi,
What am i doing wroung here!!! i got Error msg 156, !!! i can belive that.
1)
CREATE TABLE Butik (ButikID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Namn VARCHAR(30),
Gatuadress VARCHAR(30),
Postnummer VARCHAR(6),
Postadress VARCHAR(20),
Oppnar TIME,
Stanger TIME,
Helgoppen ENUM(’Y’, ’N’));
2)
CREATE TABLE Telefon (TelefonID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Nummer VARCHAR(20),
ButikID INT);
3)
CREATE TABLE Kunder (Kundnummer INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Fornamn VARCHAR(20),
Efternamn VARCHAR(20),
Gatuadress VARCHAR(20),
Postnummer VARCHAR(6),
Postadress VARCHAR(20));
4)
CREATE TABLE Filmer (FilmID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Namn VARCHAR(40),
Kategori ENUM (’Drama’, ’Rysare’, ’Action’, ’Thriller’, ’Komedi’),
Regissor VARCHAR(40),
Huvudroll VARCHAR(40),
Ar YEAR,
Land VARCHAR(20),
Pris INT);
5)
CREATE TABLE Uthyrning(FilmID INT NOT NULL,
ButikID INT NOT NULL,
Kundnummer INT NOT NULL,
Uthyrning DATE,
Aterlamning DATE);

All this make me sick, i dont know where and what i did wroung. THNX DEV
asap
thnx

If you're using MS SQL (are you in the right forum?), then AUTOINCREMENT doesn't work. Instead, use IDENTITY(<start number>, <increment by>) as in "IDENTITY(5,1)" would start assigning ids at 5 and increment by one.

So one of your tables would something like:


As far as the enumerations, I don't think MS SQL allows for enumeration types but I don't know for sure (I am new to sql in general and MS SQL especially).

Good luck. I hope this helps.