CREATE TABLE IKTGE22A (
    studid int NOT NULL AUTO_INCREMENT,
    firstname varchar(255),
    lastname varchar(255),
    brithdate date,
    phone int,
    PRIMARY KEY (studid)
);

------------------------------------------------2

CREATE TABLE Blogg (
    blogid int NOT NULL AUTO_INCREMENT,
    name varchar(255),
    caption varchar(255),
    comments varchar(255),
    `date` date,
    PRIMARY KEY (blogid)
);

------------------------------------------------3

CREATE TABLE Genre (
    GenreID int NOT NULL AUTO_INCREMENT,
    Genre varchar(255),
    PRIMARY KEY (GenreID)
);
CREATE TABLE Filmer (
    filmid int NOT NULL AUTO_INCREMENT,
    genreid int,
    filmnamn varchar (255),
    utgivningsdatum date,
    langd int,
    PRIMARY KEY (filmid)
);
ALTER TABLE Genre
ADD FOREIGN KEY(genreid)
REFERENCES Filmer(genreid) ON DELETE RESTRICT;