CREATE TABLE Photo ( Photo_id INTEGER NOT NULL AUTO_INCREMENT, image MEDIUMBLOB NOT NULL, title VARCHAR(20) NOT NULL, remark TEXT NOT NULL, dateTaken DATE NOT NULL, views INTEGER NOT NULL, photographer INTEGER REFERENCES Photographer ( Photographer_id) , aircraft INTEGER REFERENCES Aircraft ( Aircraft_id) , carrier INTEGER REFERENCES Carrier ( Carrier_id) , location INTEGER REFERENCES Location ( Location_id) , PRIMARY KEY ( Photo_id ) ); CREATE TABLE Comment ( Comment_id INTEGER NOT NULL AUTO_INCREMENT, Photo_id INTEGER REFERENCES Photo ( Photo_id) , text VARCHAR(20) NOT NULL, Member_id INTEGER REFERENCES Member ( Member_id) , PRIMARY KEY ( Photo_id, Comment_id ) ); CREATE TABLE Location ( Location_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, IATACode VARCHAR(20) NOT NULL, ICAOCode VARCHAR(20) NOT NULL, country INTEGER REFERENCES Country ( Country_id) , PRIMARY KEY ( Location_id ) ); CREATE TABLE Country ( Country_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, PRIMARY KEY ( Country_id ) ); CREATE TABLE Photographer ( Photographer_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, email VARCHAR(50) NOT NULL, PRIMARY KEY ( Photographer_id ) ); CREATE TABLE Album ( Album_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, description TEXT NOT NULL, owner INTEGER REFERENCES Member ( Member_id) , PRIMARY KEY ( Album_id ) ); CREATE TABLE Member ( Member_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 ( Member_id ) ); CREATE TABLE Aircraft ( Aircraft_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, PRIMARY KEY ( Aircraft_id ) ); CREATE TABLE Carrier ( Carrier_id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, PRIMARY KEY ( Carrier_id ) ); CREATE TABLE album ( Photo_id INTEGER NOT NULL REFERENCES Photo ( Photo_id) , Album_id INTEGER NOT NULL REFERENCES Album ( Album_id) , PRIMARY KEY ( Album_id, Photo_id ) );