CREATE TABLE Photo ( pictureNo VARCHAR(20) NOT NULL, image MEDIUMBLOB NOT NULL, title VARCHAR(20) NOT NULL, text VARCHAR(20) NOT NULL, year VARCHAR(20) NOT NULL, externalLink VARCHAR(50) NOT NULL, datetadded DATE NOT NULL, contributor INTEGER REFERENCES Contributor ( Contributor_id) , country INTEGER REFERENCES Country ( Country_id) , manufacturer INTEGER REFERENCES Manufacturer ( Manufacturer_id) , seeAlso VARCHAR(20) REFERENCES Photo ( pictureNo) , PRIMARY KEY ( pictureNo ) ); CREATE TABLE Comment ( Comment_id INTEGER NOT NULL AUTO_INCREMENT, pictureNo VARCHAR(20) REFERENCES Photo ( pictureNo) , text VARCHAR(20) NOT NULL, name VARCHAR(20) NOT NULL, email VARCHAR(50), PRIMARY KEY ( pictureNo, Comment_id ) ); CREATE TABLE Manufacturer ( Manufacturer_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, description VARCHAR(20) NOT NULL, PRIMARY KEY ( Manufacturer_id ) ); CREATE TABLE Country ( Country_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, PRIMARY KEY ( Country_id ) ); CREATE TABLE Contributor ( Contributor_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, PRIMARY KEY ( Contributor_id ) ); CREATE TABLE Album ( Album_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, private VARCHAR(20) NOT NULL, owner INTEGER REFERENCES Visitor ( Visitor_id) , PRIMARY KEY ( Album_id ) ); CREATE TABLE Visitor ( Visitor_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, login VARCHAR(20) NOT NULL, password VARCHAR(20) NOT NULL, description VARCHAR(20) NOT NULL, PRIMARY KEY ( Visitor_id ) ); CREATE TABLE album ( pictureNo VARCHAR(20) NOT NULL REFERENCES Photo ( pictureNo) , Album_id INTEGER NOT NULL REFERENCES Album ( Album_id) , PRIMARY KEY ( Album_id, pictureNo ) );