-- John Wilkinson (MS50)
-- Databases (COMS 30103) - Dr. J.Gallagher
-- Video Shop - Assignment 2
------------------------------------------------------------------------
-- video_tuples.sql - Video shop tuples
------------------------------------------------------------------------


-- Video table - tuples.
------------------------ 

insert into Video
	values
	('Antz', 'U', 'y');
insert into Video
	values
	('Bean', 'U', 'y');
insert into Video
	values
	('Emmanuel', '18', 'y');
insert into Video
	values
	('Deliverance', '18', 'y');
insert into Video
	values
	('Cartoons', 'U', 'y');
insert into Video
	values
	('Friends', 'U', 'y');
insert into Video
	values
	('Halloween II', '18', 'y');
insert into Video
	values
	('Independance Day', 'U', 'y');
insert into Video
	values
	('Godfather II', '18', 'y');
insert into Video
	values
	('Jungle Book', 'U', 'y');
insert into Video
	values
	('Kiss in Concert', '18', 'y');
insert into Video
	values
	('Living with the Enemy', '18', 'y');
insert into Video
	values
	('Mars Attacks', 'U', 'y');
insert into Video
	values
	('Nuclear Meltdown', '18', 'y');
insert into Video
	values
	('Oscar', '18', 'y');
insert into Video
	values
	('Pitstop', 'U', 'y');
insert into Video
	values
	('Quest', 'U', 'y');
insert into Video
	values
	('Rambo', '18', 'y');
insert into Video
	values
	('V The Movie', '18', 'y');
insert into Video
	values
	('Still Smoking', '18', 'y');
insert into Video
	values
	('Uncensored Action', '18', 'y');
insert into Video
	values
	('Titanic', 'U', 'y');
insert into Video
	values
	('Young Guns', 'U', 'y');
insert into Video
	values
	('Wizard of Oz', 'U', 'y');
insert into Video
	values
	('X-Men from Mars', '18', 'y');
insert into Video
	values
	('Zulu', 'U', 'y');


-- Shop table - tuples.
-------------------------

insert into Shop 
	values
	('CyberFilms', 'John P Wilkinson');


-- Member table - tuples.
-------------------------

insert into Member 
	values
	('000001', 'Adam Ant', '01-JAN-70', 0);
insert into Member 
	values
	('000002', 'Cameron Deaz', '03-MAR-73', 0);
insert into Member 
	values
	('000003', 'Boris Yeltzin', '02-FEB-72', 0);
insert into Member 
	values
	('000004', 'Elvis Presley', '05-MAY-75', 0);
insert into Member 
	values
	('000005', 'Dean Martin', '04-APR-74', 0);
insert into Member 
	values
	('000006', 'Kelly OBrian', '26-MAY-76', 0);
insert into Member 
	values
	('000007', 'Stuart Bagshaw', '13-DEC-66', 0);
insert into Member 
	values
	('000008', 'Corinne Rivers', '15-NOV-52', 0);
insert into Member 
	values
	('000009', 'Andre De La Rue', '23-MAY-79', 0);
insert into Member 
	values
	('000010', 'Clint Eastwood', '11-AUG-40', 0);
insert into Member
        values
        ('000011', 'Young Jenny', '14-JAN-85', 0);