Create Table Customer (
Code INTEGER NOT NULL AUTO_INCREMENT,
Name CHAR(50),
Surname CHAR(50),
Display_Name CHAR(30),
Phone_Number CHAR(10),
ID_Number CHAR(30),
Address CHAR(50),
City CHAR(50),
Loan INTEGER,
Special CHAR(10),
PRIMARY KEY (Code)
)charset utf8;

Create Table Company(
CID INTEGER NOT NULL AUTO_INCREMENT,
Company CHAR(50),
PRIMARY KEY(cID)
)charset utf8;

Create Table Category(
GID INTEGER NOT NULL AUTO_INCREMENT,
Category CHAR(50),
PRIMARY KEY(GID)
)charset utf8;

CREATE TABLE images ( 
  image_id INTEGER NOT NULL AUTO_INCREMENT,
  filename CHAR(50) NOT NULL,
  caption CHAR(100) NOT NULL,
  PRIMARY KEY  (image_id)
) charset utf8;

CREATE TABLE images_game ( 
  image_id INTEGER NOT NULL AUTO_INCREMENT,
  filename CHAR(50) NOT NULL,
  caption CHAR(100) NOT NULL,
  PRIMARY KEY  (image_id)
) charset utf8;

Create Table Tainia (
ID  INTEGER NOT NULL,
images_id INTEGER,
Title CHAR(50),
Copies INTEGER,
Director CHAR(50),
Actor CHAR(50),
Company CHAR(50),
Category CHAR(50),
Type CHAR(10),
Product Date,
Value DOUBLE,
Loan_Value DOUBLE,
Loans INTEGER,
PRIMARY KEY(ID,images_id),
FOREIGN KEY (images_id) REFERENCES images(image_id)
)charset utf8;

Create Table Games (
ID  INTEGER NOT NULL,
images_id INTEGER,
Title CHAR(50),
Category CHAR(50),
Console CHAR(50),
Buy_Value DOUBLE,
Loan_Value DOUBLE,
Copies INTEGER,
Loans INTEGER,
PRIMARY KEY(ID,images_id),
FOREIGN KEY (images_id) REFERENCES images_game(image_id)
)charset utf8;

Create Table LoanGames (
ID INTEGER NOT NULL AUTO_INCREMENT,
Game_ID INTEGER,
Game_Title CHAR(50),
Customer_Code INTEGER,
Display_Name CHAR(50),
Day Date,
PRIMARY KEY(ID,Game_ID,Customer_Code),
FOREIGN KEY (Game_ID) REFERENCES Games(ID),
FOREIGN KEY (Customer_code) REFERENCES Customer(Code)

)charset utf8;

Create Table ReturnsGames (
ID INTEGER NOT NULL AUTO_INCREMENT,
Game_ID INTEGER,
Game_Title CHAR(50),
Customer_Code INTEGER,
Display_Name CHAR(50),
Day Date,
Duration LONG,
Cost DOUBLE,
PRIMARY KEY(ID,Game_ID,Customer_Code),
FOREIGN KEY (Game_ID) REFERENCES Games(ID),
FOREIGN KEY (Customer_code) REFERENCES Customer(Code)
)charset utf8;

Create Table BuyGames (
ID INTEGER NOT NULL AUTO_INCREMENT,
Game_ID INTEGER,
Game_Title CHAR(50),
Customer_Code INTEGER,
Display_Name CHAR(50),
Day CHAR(50),
Cost DOUBLE,
PRIMARY KEY(ID,Game_ID,Customer_Code),
FOREIGN KEY (Game_ID) REFERENCES Games(ID),
FOREIGN KEY (Customer_code) REFERENCES Customer(Code)
)charset utf8;


Create Table Loan (
Count INTEGER NOT NULL AUTO_INCREMENT,
Movie_ID INTEGER,
Title CHAR(50),
Customer_code INTEGER,
Display_Names CHAR(30),
Location CHAR(15),
Day Date,
PRIMARY KEY(Count,Movie_ID,Customer_code),
FOREIGN KEY (Movie_ID) REFERENCES Tainia(ID),
FOREIGN KEY (Customer_code) REFERENCES Customer(Code)
)charset utf8;

Create Table Reservation (
Count INTEGER NOT NULL AUTO_INCREMENT,
Movie_ID INTEGER,
Title CHAR(50),
Customer_code INTEGER,
Display_Names CHAR(30),
Location CHAR(15),
Day Date,
PRIMARY KEY(Count,Movie_ID,Customer_code),
FOREIGN KEY (Movie_ID) REFERENCES Tainia(ID),
FOREIGN KEY (Customer_code) REFERENCES Customer(Code)
)charset utf8;

Create Table ReservationGames (
Count INTEGER NOT NULL AUTO_INCREMENT,
Movie_ID INTEGER,
Title CHAR(50),
Customer_code INTEGER,
Display_Names CHAR(30),
Location CHAR(15),
Day Date,
PRIMARY KEY(Count,Movie_ID,Customer_code),
FOREIGN KEY (Movie_ID) REFERENCES Games(ID),
FOREIGN KEY (Customer_code) REFERENCES Customer(Code)
)charset utf8;

Create Table Holiday
(
ID INTEGER NOT NULL AUTO_INCREMENT,
Holiday Date,
Description Text,
Primary Key(ID)
)charset utf8;



Create Table Users (
NUM INTEGER NOT NULL AUTO_INCREMENT,
Code INTEGER,
Password Char(20),
Username Char(20),
Primary Key(NUM,Code),
FOREIGN KEY (Code) REFERENCES Customer(Code)
)charset utf8;


Create Table Returns (
Count INTEGER NOT NULL AUTO_INCREMENT,
ID INTEGER,
Title CHAR(50),
Code INTEGER,
Display_Names CHAR(30),
Day Date,
Duration LONG,
Cost DOUBLE,
PRIMARY KEY(Count,ID,Code),
FOREIGN KEY (ID) REFERENCES Tainia(ID),
FOREIGN KEY (Code) REFERENCES Customer(Code)
)charset utf8;

Create Table Buy (
Count INTEGER NOT NULL AUTO_INCREMENT,
ID INTEGER,
Title CHAR(50),
Code INTEGER,
Customer CHAR(30),
Value DOUBLE,
Day CHAR(30),
PRIMARY KEY(Count,ID,Code),
FOREIGN KEY (ID) REFERENCES Tainia(ID),
FOREIGN KEY (Code) REFERENCES Customer(Code)
)charset utf8;

Create Table Moves(
Count INTEGER NOT NULL AUTO_INCREMENT,
Code INTEGER,
Display_Name CHAR(30),
Returns INTEGER,
PRIMARY KEY(Count,Code),
FOREIGN KEY (Code) REFERENCES Customer(Code)
)charset utf8;

Create Table Administrator (
Code_AD INTEGER NOT NULL AUTO_INCREMENT,
Name_AD CHAR(50),
Surname_AD CHAR(50),
Display_Name_AD CHAR(30),
Phone_Number_AD CHAR(10),
ID_Number_AD CHAR(30),
Address_AD CHAR(50),
City_AD CHAR(50),
PRIMARY KEY (Code_AD)
)charset utf8;

Create table basket(
Customer_Code integer,
Day date NOT NULL,
Movie_ID integer,
Title char(30),
PRIMARY KEY(Day,Customer_Code,Movie_ID),
FOREIGN KEY (Customer_Code) REFERENCES Customer(Code),
FOREIGN KEY (Movie_ID) REFERENCES tainia(ID)
)charset utf8;

Create table basket_games(
Customer_Code integer,
Day date NOT NULL,
Movie_ID integer,
Title char(30),
PRIMARY KEY(Day,Customer_Code,Movie_ID),
FOREIGN KEY (Customer_Code) REFERENCES Customer(Code),
FOREIGN KEY (Movie_ID) REFERENCES Games(ID)
)charset utf8;

Create Table AD_User (
NUM INTEGER NOT NULL AUTO_INCREMENT,
Code_AD INTEGER,
Password_AD Char(20),
Username_AD Char(20),
Primary Key(NUM,Code_AD),
FOREIGN KEY (Code_AD) REFERENCES Administrator(Code_AD)
)charset utf8;


INSERT INTO Administrator(Name_AD,Surname_AD,Display_Name_AD,Phone_Number_AD,ID_Number_AD,Address_AD,City_AD)
VALUES
('PARASKEUH','PAPPA','PAPPA PAR','2456023456','K34598563','MIAOULI 32','KARPENISI');
INSERT INTO Administrator(Name_AD,Surname_AD,Display_Name_AD,Phone_Number_AD,ID_Number_AD,Address_AD,City_AD)
VALUES
('PANAGIOTIS','DORIS','DORIS PAN','2310264745','I4643455','STADIOU 21','ARGOS');


Insert Into AD_User(Code_AD,Password_AD,Username_AD)
Values
(1,'pappa','vivi');
INSERT INTO AD_User(Code_AD,Password_AD,Username_AD)
VALUES
(2,'doris','panos');


INSERT INTO Company
VALUES
(1,'PARAMOUNT');
INSERT INTO Company
VALUES
(2,'NEW LINE');
INSERT INTO Company
VALUES
(3,'FOX');
INSERT INTO Company
VALUES
(4,'COLUMBIA');
INSERT INTO Company
VALUES
(5,'MIRAMAX');
INSERT INTO Company
VALUES
(6,'FINOS FILM');
INSERT INTO Company
VALUES
(7,'TRISTAR');
INSERT INTO Company
VALUES
(8,'POLYGRAM');


INSERT INTO Category
VALUES
(1,'ADVENTURE');
INSERT INTO Category
VALUES
(2,'ACTION');
INSERT INTO Category
VALUES
(3,'ROMANTIC');
INSERT INTO Category
VALUES
(4,'FANTASY');
INSERT INTO Category
VALUES
(5,'HORROR');
INSERT INTO Category
VALUES
(6,'SOCIAL');
INSERT INTO Category
VALUES
(7,'MYSTERY');
INSERT INTO Category
VALUES
(8,'DRAMA');
INSERT INTO Category
VALUES
(9,'POLICE');
INSERT INTO Category
VALUES
(10,'COMEDY');

INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('PARASKEUH','PAPPA','PAPPA PARASKEUH','2456023456','K34598563','MIAOULH 32','KARPENHSI',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('PANAGIOTIS','DORIS','DORIS PANAGIOTIS','2310264745','I4643455','STADIOU 21','ARGOS',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('STEFANOS','NTENTES','NTENTES STEFANOS','245602874','K34598563','THIVWN 38','AKRATA',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('DIMITRIS','GIAKOUMAKIS','GIAKOUMAKIS DIMITRIS','2456029556','K34598563','KANARH 2','THESSALONIKI',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('NIKOS','DORIS','DORIS NIKOS','24560237','K354596113','BYZANTIOU 3','KKOZANI',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('KWSTAS','KOTSIFAS','KOTSIFAS KWSTAS','2456021456','K34543563','SOFIAS 67','ATHENS',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('BILL','THANASIAS','THANASIAS BILL','2478088456','I99543563','RODOPIS 7','ATHENS',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('GEORGE','KARAMOUZOS','KARAMOUZOS GEORGE','2456221456','I34543953','HRODOTOU 13','PATRA',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('AXILEAS','KARIPIDHS','ΚΑΡΙΠΙΔΗΣ ΑΧΙΛΕΑΣ','2756029916','I34543442','SKALAS 67','NAFPLIO',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('ANNA','YATHA','YATHA ANNA','2456029936','K34000563','ARMENOPOULOU 76','PTOLEMAIDA',0,'NOT');
INSERT INTO Customer(Name,Surname,Display_Name,Phone_Number,ID_Number,Address,City,Loan,Special)
VALUES
('APOSTOLOS','PAXARAKIS','PAXARAKIS APOSTOLOS','231021456','K34443563','SPARTIS 21','THESSALONIKI',0,'NOT');



INSERT INTO Users(Code,Password,Username)
VALUES
(2,'B32303','panos');

INSERT INTO images (image_id, filename, caption) VALUES
(1, 'movie1.jpg', 'Water basin at Ryoanji temple, Kyoto'),
(2, 'movie2.jpg', 'Fountains in central Tokyo'),
(3, 'movie3.jpg', 'The Golden Pavilion in Kyoto'),
(4, 'movie4.jpg', 'Maiko—trainee geishas in Kyoto'),
(5, 'movie5.jpg', 'Every maiko should have one—a mobile, of course'),
(6, 'movie6.jpg', 'Menu outside restaurant in Pontocho, Kyoto'),
(7, 'movie7.jpg', 'Monk begging for alms in Kyoto'),
(8, 'movie8.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(9, 'movie9.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(10, 'movie10.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(11, 'movie11.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(12, 'movie12.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(13, 'movie13.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(14, 'movie14.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(15, 'movie15.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(16, 'movie16.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(17, 'movie17.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(18, 'movie18.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(19, 'movie19.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(20, 'movie20.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(21, 'movie21.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(22, 'movie22.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(23, 'movie23.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(24, 'movie24.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(25, 'movie25.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(26, 'movie26.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(27, 'movie27.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(28, 'movie28.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(29, 'movie29.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(30, 'movie30.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(31, 'movie31.jpg', 'Autumn leaves at Ryoanji temple, Kyoto');

INSERT INTO images_game (image_id, filename, caption) VALUES
(1, 'movie1.jpg', 'Water basin at Ryoanji temple, Kyoto'),
(2, 'movie2.jpg', 'Fountains in central Tokyo'),
(3, 'movie3.jpg', 'The Golden Pavilion in Kyoto'),
(4, 'movie4.jpg', 'Maiko—trainee geishas in Kyoto'),
(5, 'movie5.jpg', 'Every maiko should have one—a mobile, of course'),
(6, 'movie6.jpg', 'Menu outside restaurant in Pontocho, Kyoto'),
(7, 'movie7.jpg', 'Monk begging for alms in Kyoto'),
(8, 'movie8.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(9, 'movie9.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(10, 'movie10.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(11, 'movie11.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(12, 'movie12.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(13, 'movie13.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(14, 'movie14.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(15, 'movie15.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(16, 'movie16.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(17, 'movie17.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(18, 'movie18.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(19, 'movie19.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(20, 'movie20.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(21, 'movie21.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(22, 'movie22.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(23, 'movie23.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(24, 'movie24.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(25, 'movie25.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(26, 'movie26.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(27, 'movie27.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(28, 'movie28.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(29, 'movie29.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(30, 'movie30.jpg', 'Autumn leaves at Ryoanji temple, Kyoto'),
(31, 'movie31.jpg', 'Autumn leaves at Ryoanji temple, Kyoto');


INSERT INTO Tainia
VALUES
(4401,1,'ALEXANDER THE GREAT',3,'SPEELBERG','MONICA' ,'PARAMOUNT','ADVENTURE','DVD','2003-11-28',12.5,2,0);
INSERT INTO Tainia
VALUES
(4402,2,'NOTTING HILL',2,'Tokin','Xiou Grant','PARAMOUNT','ADVENTURE','DVD','2001-6-23',15,2,0);
INSERT INTO Tainia
VALUES
(4403,3,'FAST AND FURIOUS',2,'TREVOR','JONES' ,'PARAMOUNT','ADVENTURE','DVD','2002-2-14',14.6,2,0);
INSERT INTO Tainia
VALUES
(4404,4,'TITANIC',2,'CURTIS','RICHARD','PARAMOUNT','ADVENTURE','DVD','2000-9-28',13.8,2,0);
INSERT INTO Tainia
VALUES
(4405,5,'SPIDERMAN',5,'DUNCAN ','KENWORTH','PARAMOUNT','ADVENTURE','DVD','2004-5-28',15,2,0);
INSERT INTO Tainia
VALUES
(4406,6,'BATTLE OF BRITAIN',4,'ROGER','MICHEL','NEW LINE','ADVENTURE','DVD','1991-4-5',14.5,2,0);
INSERT INTO Tainia
VALUES
(4407,7,'SCARY MOVIE',2,'TIM','BEVAN','NEW LINE','ADVENTURE','DVD','2002-11-28',10.9,2,0);
INSERT INTO Tainia
VALUES
(4408,8,'TRANSFORMERS',1,'MARY','SELWAY','NEW LINE','ADVENTURE','DVD','2005-6-17',25,2,0);
INSERT INTO Tainia
VALUES
(4409,9,'WHITE CHICKS',2,'STUART','CRAIG','FOX','ACTION','DVD','2002-8-19',28,2,0);
INSERT INTO Tainia
VALUES
(4410,10,'BRAVEHEART',2,'NICK','MOORE','FOX','ACTION','DVD','1996-9-18',30,2,0);
INSERT INTO Tainia
VALUES
(4411,11,'RESIDENT EVIL',1,'SHUNA','HARWOOD','FOX','ACTION','DVD','2004-7-28',15,2,0);
INSERT INTO Tainia
VALUES
(4412,12,'DIE HARD',2,'TOMY','JEEN','COLUMBIA','ACTION','DVD','2001-4-15',12.7,2,0);
INSERT INTO Tainia
VALUES
(4413,13,'ALAMO',3,'TOMY','JEEN','COLUMBIA','ACTION','VHS','2004-6-15',11,2,0);
INSERT INTO Tainia
VALUES
(4414,14,'BATMAN',2,'ALEX','NICK','COLUMBIA','ACTION','VHS','2003-6-11',13,2,0);
INSERT INTO Tainia
VALUES
(4415,15,'NEXT DOOR GIRL',3,'GEORGE','TOD','COLUMBIA','ROMANTIC','VHS','2003-5-12',13,2,0);
INSERT INTO Tainia
VALUES
(4416,16,'LORD OF THE RINGS',4,'NICOLAS','CLOONEY','COLUMBIA','ROMANTIC','VHS','2003-5-21',22,2,0);
INSERT INTO Tainia
VALUES
(4417,17,'PRETADOR',2,'ALFONSO','MERDOC','MIRAMAX','ROMANTIC','VHS','2003-6-22',21,2,0);
INSERT INTO Tainia
VALUES
(4418,18,'ANACONDA',3,'PETROSA','CROUSE','MIRAMAX','ROMANTIC','VHS','2003-6-29',20,2,0);
INSERT INTO Tainia
VALUES
(4419,19,'ALIEN VS PRETADOR',2,'ELIAS','KIDMAN','MIRAMAX','FANTASY','VHS','2003-2-28',18,2,0);
INSERT INTO Tainia
VALUES
(4420,20,'RAMBO 1',2,'SMITH','WHASHINGTON','MIRAMAX','FANTASY','VHS','2002-4-19',16,2,0);
INSERT INTO Tainia
VALUES
(4421,21,'RAMBO 2',4,'FRANK','STALONE','TRISTAR','HORROR','VHS','2001-1-22',15,2,0);
INSERT INTO Tainia
VALUES
(4422,22,'ROCKY',4,'CHRIS','SWANCHENEGER','TRISTAR','HORROR','VHS','2001-2-21',15,2,0);
INSERT INTO Tainia
VALUES
(4423,23,'STAR WARS',2,'TOMY','LEE','TRISTAR','SOCIAL','VHS','2001-5-23',14,2,0);
INSERT INTO Tainia
VALUES
(4424,24,'NARNIA',2,'TOMY','PADERAS','TRISTAR','SOCIAL','VHS','2001-6-22',14,2,0);
INSERT INTO Tainia
VALUES
(4425,25,'APOCALYPSE',3,'TOMY','DENIRO','TRISTAR','MYSTERY','DVD','2001-7-16',13,2,0);
INSERT INTO Tainia
VALUES
(4426,26,'ARMAGEDON',3,'TOMY','PADERAS','POLYGRAM','MYSTERY','DVD','2001-7-17',14,2,0);
INSERT INTO Tainia
VALUES
(4427,27,'FUNNY VIDEOS',3,'TOMY','JEEN','POLYGRAM','DRAMA','DVD','2004-3-16',16,2,0);
INSERT INTO Tainia
VALUES
(4428,28,'BEVERLY HILLS CUP',4,'TOMY','JEEN','POLYGRAM','DRAMA','DVD','2002-3-13',15,2,0);
INSERT INTO Tainia
VALUES
(4429,29,'MATRIX',4,'TOMY','JEEN','POLYGRAM','POLICE','DVD','2002-9-15',15,2,0);

INSERT INTO Tainia
VALUES
(4430,30,'THE THIRD EYE',2,'TOMY','JEEN','POLYGRAM','POLICE','DVD','2002-9-15',15,2,0);
INSERT INTO Tainia
VALUES
(4431,31,'DANIKA',2,'SPEELBERG','CHAN','TRISTAR','ADVENTURE','DVD','2003-5-15',15,2,0);
INSERT INTO Tainia
VALUES
(4432,8,'ON THE EDGE',5,'SPEELBERG','CHAN','TRISTAR','ADVENTURE','DVD','2003-6-15',15,2,0);
INSERT INTO Tainia
VALUES
(4433,1,'PER FLY',4,'SPEELBERG','CHAN','TRISTAR','ADVENTURE','DVD','2004-7-15',15,2,0);
INSERT INTO Tainia
VALUES
(4434,2,'HAIRSPRAY',3,'SPEELBERG','KIOUTAK','MIRAMAX','ACTION','VHS','2004-8-19',15,2,0);
INSERT INTO Tainia
VALUES
(4435,3,'HALLOWEEN',2,'SPEELBERG','KIOUTAK','MIRAMAX','ACTION','DVD','2003-8-16',15,2,0);
INSERT INTO Tainia
VALUES
(4436,4,'SUPERBAD',2,'ALFRED','KIOUTAK','MIRAMAX','ACTION','VHS','2002-7-12',15,2,0);
INSERT INTO Tainia
VALUES
(4437,5,'DRAGORN WARS',1,'ALFRED','FRIMAN','MIRAMAX','DOCUMENTARY','DVD','2001-6-11',15,2,0);
INSERT INTO Tainia
VALUES
(4438,6,'FOUR MINUTES',2,'ALFRED','FRIMAN','POLYGRAM','HORROR','DVD','2001-6-26',15,2,0);
INSERT INTO Tainia
VALUES
(4439,7,'CROCS',2,'ALFRED','FRIMAN','FOX','DOCUMENTARY','DVD','2003-5-21',15,2,0);
INSERT INTO Tainia
VALUES
(4440,8,'DISTINCT SITUATION',5,'ALFRED','FRIMAN','FOX','HORROR','DVD','2005-4-25',15,2,0);
INSERT INTO Tainia
VALUES
(4441,1,'LOVE BOUNDS',5,'IVAN','VANDAM','FOX','ROMANTIC','DVD','2003-3-22',15,2,0);
INSERT INTO Tainia
VALUES
(4442,2,'THE INSULT',4,'IVAN','VANDAM','FOX','ACTION','DVD','2002-2-13',12,2,0);
INSERT INTO Tainia
VALUES
(4443,3,'A ZOMPY',4,'IVAN','VANDAM','POLYGRAM','COMEDY','VHS','2004-1-15',14,2,0);
INSERT INTO Tainia
VALUES
(4444,4,'AMERICAN NINJA',4,'TOKIN','VANDAM','COLUMBIA','ACTION','VHS','2003-2-21',15,2,0);
INSERT INTO Tainia
VALUES
(4445,5,'ARMOUR OF GOD',2,'TOKIN','VANDAM','POLYGRAM','ACTION','DVD','2003-3-12',15,2,0);
INSERT INTO Tainia
VALUES
(4446,6,'RARE TZO',3,'TOKIN','JEEN','POLYGRAM','DRAMA','DVD','2002-4-22',15,2,0);

INSERT INTO Tainia
VALUES
(4447,11,'THE OTHER BOLEYN GIRL',3,'TSANGWUIK','PORTMAN','POLYGRAM','ROMANTIC','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4448,14,'10000BC',3,'EMERIH','SARIF','COLUMBIA','ADVENTURE','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4449,28,'THE SPIDERWICK CHRONICLES',3,'WATERS','NOLTE','COLUMBIA','FANTASY','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4450,25,'NO COUNTRY FOR OLD MEN',3,'KOEN','BROLIN','POLYGRAM','DRAMA','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4451,18,'JUMBER',3,'LAIMAN','BILSON','COLUMBIA','ACTION','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4452,17,'BROKE UP',3,'MIRIANTHOPOULOS','MAKRIPOYLIA','COLUMBIA','COMEDY','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4453,3,'27 DRESSES',3,'FLETSER','MARSTEN','COLUMBIA','ROMANTIC','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4454,4,'THE CHIPMUNKS',3,'HILL','KOYRLAMBA','COLUMBIA','CARTOONS','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4455,11,'BEE MOVIE',3,'HICNER','KAPSAMPELI','COLUMBIA','ADVENTURE','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4456,12,'STEP UP 2',3,'TSOU','HOFMAN','COLUMBIA','DRAMA','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4457,21,'ASTERIX AUX JEUX OLYMPIQUES',3,'FORESTIE','DEPARTRIE','COLUMBIA','COMEDY','DVD','2002-4-22',15,2,0);

INSERT INTO Tainia
VALUES
(4458,13,'BE KIND REWIND',3,'GONTRI','GLOVER','MIRAMAX','SOCIAL','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4459,9,'DOOMSDAY',3,'MARSHAL','HOSINS','FOX','FANTASY','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4460,8,'FUNNY GAMES',3,'XANEKE','CORBET','MIRAMAX','COMEDY','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4461,6,'METT THE SPARTANS',3,'SELTSER','HLECTRA','COLUMBIA','COMEDY','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4462,5,'VANTAGE POINT',3,'TREIVIS','KOUEINT','MIRAMAX','SOCIAL','DVD','2002-4-22',15,2,0);
INSERT INTO Tainia
VALUES
(4463,7,'OVER THE HEDGE',4,'TREIVIS','KOUEINT','MIRAMAX','SOCIAL','DVD','2002-4-22',15,2,0);

INSERT INTO Games
VALUES
(10501,2,'world of conflict','STRATEGY','PC',59.99,2.5,3,0);

INSERT INTO Games
VALUES
(10502,1,'COMPANY OF HEROES GOLD','STRATEGY','PC',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10503,2,'ULTIMATE STRTEGY PACK','STRATEGY','PC',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10504,3,'OPPOSING FONTS','STRATEGY','PC',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10505,4,'TIBERIUM WARS','STRATEGY','PC',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10506,5,'COMMAND N CONQUER','STRATEGY','PC',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10507,6,'SUPREME COMMANDER','STRATEGY','PC',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10508,7,'HEROES OF MNM','STRATEGY','PC',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10509,8,'LOTR BATLLE FOR MIDDLE EARTH','STRATEGY','PC',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10510,9,'LOTR THE RISE OF THE WITCH-KING','STRATEGY','PC',24.99,2.5,3,0);

INSERT INTO Games
VALUES
(10511,10,'MEDIEVAL TOTAL WAR','STRATEGY','WII',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10512,11,'EMPIRE EARTH','STRATEGY','WII',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10513,12,'THE SETTLERS','STRATEGY','WII',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10514,13,'WARCRAFT III','STRATEGY','WII',24.99,2.5,2,0);

INSERT INTO Games
VALUES
(10515,14,'CIVILIZATION','STRATEGY','WII',59.99,2.5,2,0);

INSERT INTO Games
VALUES
(10516,15,'GREAT BATTLES OF ROME','STRATEGY','WII',44.99,2.5,2,0);

INSERT INTO Games
VALUES
(10517,16,'STAR WARS','STRATEGY','XBOX 360',14.99,2.5,2,0);

INSERT INTO Games
VALUES
(10518,17,'ACT OF WAR','STRATEGY','XBOX 360',29.99,2.5,2,0);

INSERT INTO Games
VALUES
(10519,18,'STARCRAFT','STRATEGY','XBOX 360',14.99,2.5,2,0);

INSERT INTO Games
VALUES
(10520,19,'RISE OF NATIONS','STRATEGY','XBOX 360',14.99,2.5,2,0);

INSERT INTO Games
VALUES
(10521,20,'CAESAR IV','STRATEGY','XBOX 360',14.99,2.5,2,0);

INSERT INTO Games
VALUES
(10522,21,'ROME TOTAL WAR','STRATEGY','PLAYSTATION 3',9.99,2.5,2,0);

INSERT INTO Games
VALUES
(10523,22,'ENEMY TRRITORY','ACTION','PLAYSTATION 2',29.99,2.5,4,0);

INSERT INTO Games
VALUES
(10524,23,'JERICHO','ACTION','PLAYSTATION 2',49.99,2.5,4,0);

INSERT INTO Games
VALUES
(10525,24,'BIOISHOCK','ACTION','PLAYSTATION 3',39.99,2.5,4,0);

INSERT INTO Games
VALUES
(10526,25,'SOLDIER OF FORTUNE','ACTION','PLAYSTATION 3',29.99,2.5,4,0);

INSERT INTO Games
VALUES
(10527,26,'UNREAL TOURNAMENT','ACTION','PLAYSTATION 3',39.99,2.5,4,0);

INSERT INTO Games
VALUES
(10528,27,'MEDAL OF HONOR','ACTION','PLAYSTATION 3',39.99,2.5,4,0);

INSERT INTO Games
VALUES
(10529,28,'STRANGEHOLD','ACTION','PLAYSTATION 3',29.99,2.5,4,0);

INSERT INTO Games
VALUES
(10530,29,'HALO 2','ACTION','PLAYSTATION 3',29.99,2.5,4,0);

INSERT INTO Games
VALUES
(10531,30,'BEOWULF','ACTION','PLAYSTATION 3',19.99,2.5,4,0);

INSERT INTO Games
VALUES
(10532,31,'HALF LIFE','ACTION','PLAYSTATION 3',49.99,2.5,4,0);

INSERT INTO Games
VALUES
(10533,1,'CRYSIS','ACTION','PLAYSTATION 2',49.99,2.5,2,0);

INSERT INTO Games
VALUES
(10534,2,'NEED FOR SPEED','SIMULATION','PLAYSTATION 2',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10535,3,'JUICED 2','SIMULATION','PLAYSTATION 2',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10536,4,'SEGA RALLY 2007','SIMULATION','PLAYSTATION 2',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10537,5,'COLIN MCRAE DIRT','SIMULATION','PLAYSTATION 2',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10538,6,'THE SIMS','SIMULATION','PLAYSTATION 2',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10539,7,'NBA LIVE','SPORTS','PLAYSTATION 2',29.99,2.5,2,0);

INSERT INTO Games
VALUES
(10540,8,'FIFA MANAGER','SPORTS','SONY PSP',39.99,2.5,2,0);

INSERT INTO Games
VALUES
(10541,9,'PRO EVOLUTION 6','SPORTS','SONY PSP',19.99,2.5,2,0);

INSERT INTO Games
VALUES
(10542,10,'WORLD BASKETBALL','SPORTS','SONY PSP',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10543,11,'FIFA 2007','SPORTS','SONY PSP',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10544,12,'PRO EVOLUTION 2008','SPORTS','SONY PSP',19.99,2.5,3,0);

INSERT INTO Games
VALUES
(10545,13,'HELLGATE','RPG','SONY PSP',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10546,14,'THE WITCHER','RPG','SONY PSP',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10547,15,'NEVERWINTER','RPG','NINTENDO GBA',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10548,16,'TWO WORLDS','RPG','NINTENDO GBA',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10549,17,'GOTHIC 3','RPG','NINTENDO GBA',19.99,2.5,3,0);

INSERT INTO Games
VALUES
(10550,18,'LOKI','RPG','NINTENDO GBA',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10551,19,'DUNGEON SIEGE 2','RPG','NINTENDO GBA',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10552,20,'SHIVERING ISLES','RPG','NINTENDO GBA',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10553,21,'DIABLO','RPG','NINTENDO GBA',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10554,22,'WOW','MASSIVE ON LINE','NINTENDO GBA',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10555,23,'TABULA RASA','MASSIVE ON LINE','NINTENDO GBA',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10556,'LINEAGE 2','MASSIVE ON LINE','NINTENDO GBA',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10557,24,'BLACK MIRROR','ADVENTURE','NINTENDO DS',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10558,25,'SINKING ISLANDS','ADVENTURE','NINTENDO DS',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10559,26,'CSI','ADVENTURE','NINTENDO DS',19.99,2.5,3,0);

INSERT INTO Games
VALUES
(10560,27,'UNDERCOVER','ADVENTURE','NINTENDO DS',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10561,28,'MYSTFANDANGO','ADVENTURE','NINTENDO DS',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10562,29,'SURFS UP','ADVENTURE','NINTENDO DS',39.99,2.5,3,0);

INSERT INTO Games
VALUES
(10563,30,'ICE AGE','ADVENTURE','NINTENDO DS',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10564,31,'CROC','ADVENTURE','NINTENDO DS',49.99,2.5,3,0);

INSERT INTO Games
VALUES
(10565,1,'DEAD REEFS','ADVENTURE','NINTENDO DS',29.99,2.5,3,0);

INSERT INTO Games
VALUES
(10566,2,'MONKEY ISLAND','ADVENTURE','NINTENDO DS',49.99,2.5,3,0);


INSERT INTO Holiday
VALUES
(1,'2008-3-2','SUNDAY');
INSERT INTO Holiday
VALUES
(2,'2008-3-16','SUNDAY');
INSERT INTO Holiday
VALUES
(3,'2008-3-23','SUNDAY');
INSERT INTO Holiday
VALUES
(4,'2008-3-30','SUNDAY');
INSERT INTO Holiday
VALUES
(5,'2008-4-6','SUNDAY');
INSERT INTO Holiday
VALUES
(6,'2008-4-13','SUNDAY');
INSERT INTO Holiday
VALUES
(7,'2008-4-20','SUNDAY');
INSERT INTO Holiday
VALUES
(8,'2008-4-27','SUNDAY');
INSERT INTO Holiday
VALUES
(9,'2008-5-4','SUNDAY');
INSERT INTO Holiday
VALUES
(10,'2008-5-11','SUNDAY');
INSERT INTO Holiday
VALUES
(11,'2008-5-18','SUNDAY');
INSERT INTO Holiday
VALUES
(12,'2008-5-25','SUNDAY');
INSERT INTO Holiday
VALUES
(13,'2008-6-1','SUNDAY');
INSERT INTO Holiday
VALUES
(14,'2008-6-8','SUNDAY');
INSERT INTO Holiday
VALUES
(15,'2008-6-15','SUNDAY');
INSERT INTO Holiday
VALUES
(16,'2008-6-22','SUNDAY');
INSERT INTO Holiday
VALUES
(17,'2008-6-29','SUNDAY');
INSERT INTO Holiday
VALUES
(18,'2008-7-6','SUNDAY');
INSERT INTO Holiday
VALUES
(19,'2008-7-13','SUNDAY');
INSERT INTO Holiday
VALUES
(20,'2008-7-20','SUNDAY');
INSERT INTO Holiday
VALUES
(21,'2008-7-27','SUNDAY');
INSERT INTO Holiday
VALUES
(22,'2008-8-3','SUNDAY');
INSERT INTO Holiday
VALUES
(23,'2008-8-10','SUNDAY');
INSERT INTO Holiday
VALUES
(24,'2008-8-17','SUNDAY');
INSERT INTO Holiday
VALUES
(25,'2008-8-24','SUNDAY');
INSERT INTO Holiday
VALUES
(26,'2008-8-31','SUNDAY');

Drop Table Reservation;
Drop Table Loan;
Drop Table Moves;
Drop Table Returns;
Drop Table ReturnsGames;
Drop Table LoanGames;
Drop Table BuyGames;
Drop Table basket;
Drop Table AD_User;
Drop Table Administrator;
Drop Table Users;
Drop Table Buy;
Drop Table holiday;
Drop Table company;
Drop Table category;
Drop Table customer;
Drop Table tainia;
Drop Table Games;
Drop Table images;
Drop Table images_game;


delimeter//
Create Function reserve_trig() Returns integer
begin

Select B.Movie_ID From basket B, Tainia T Where T.ID=B.Movie_ID and T.Copies>0;
end
//