-------------------------------------------------------------
-- Example SQLite commands for 45881/70455 Modern Data Management
-- Wolfgang Gatterbauer
-- v151102
-------------------------------------------------------------

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

drop table if exists R;
drop table if exists S;
drop table if exists T;
drop table if exists T2;
drop table if exists U;


-------------------------
-- Create tables
-------------------------

create table R (a int PRIMARY KEY); 
create table S (a int PRIMARY KEY); 
create table T (a int PRIMARY KEY); 
create table T2 (a int PRIMARY KEY); 
create table U (a int PRIMARY KEY); 


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

insert into R values (1);
insert into R values (2);
insert into S values (1);
insert into T values (2);
insert into U values (2);
insert into U values (3);
insert into U values (4);