-------------------------------------------------------------
-- cs3200 Database design
-- v180121
-------------------------------------------------------------



-------------------------
-- Drop tables if they already exist
-------------------------


DO $$
BEGIN
IF EXISTS (SELECT * FROM information_schema.tables 
	WHERE table_name = 'english') THEN
   DROP Table English;
END IF;
IF EXISTS (SELECT * FROM information_schema.tables 
	WHERE table_name = 'french') THEN
   DROP Table French;
END IF;


-------------------------
-- Create the tables
-------------------------

create table English ( 
	etext varchar(20), 
	eid int PRIMARY KEY); 

create table French ( 
	fid int PRIMARY KEY, 
	ftext varchar(20)); 



---------------------------
-- Populate the tables
---------------------------


insert into English values ('One', 1); 
insert into English values ('Two', 2);
insert into English values ('Three', 3);
insert into English values ('Four', 4);
insert into English values ('Five', 5);
insert into English values ('Six', 6);

insert into French values (1, 'Un'); 
insert into French values (3, 'Trois'); 
insert into French values (4, 'Quatre'); 
insert into French values (5, 'Cinq'); 
insert into French values (6, 'Siz'); 
insert into French values (7, 'Sept'); 
insert into French values (8, 'Huit'); 
END $$