DB Script.txt

CREATE TABLE GameCopy (ID INTEGER PRIMARY KEY NOT NULL, GameID INTEGER REFERENCES Game (ID) NOT NULL,
		       PlatformID INTEGER REFERENCES Platform (ID) NOT NULL, PurchasePrice REAL NOT NULL,
		       PurchaseDate CHAR (10) NOT NULL, IsAvailable INTEGER NOT NULL DEFAULT (1));

CREATE TABLE RentalHistory (ID INTEGER PRIMARY KEY AUTOINCREMENT, GameCopyID INT NOT NULL REFERENCES GameCopy (ID),
			    RentalDate CHAR (10) NOT NULL, ReturnDate CHAR (10), CustomerID INT NOT NULL);

CREATE TABLE Game (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Title TEXT CONSTRAINT UNQ_Title UNIQUE NOT NULL,
		   Genre CHAR (50) NOT NULL, Photo BLOB);

CREATE TABLE Platform (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
			Name CHAR (50) CONSTRAINT UNQ_Name UNIQUE NOT NULL);

CREATE INDEX IDX_GameID ON GameCopy (GameID);
CREATE INDEX IDX_GameCopyID ON RentalHistory (GameCopyID ASC);
CREATE INDEX IDX_RentalDate ON RentalHistory (RentalDate ASC);