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


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

drop table if exists T; 


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

create table T (
	gid int,
	val varchar(10));


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

insert into T values (1, Null);
insert into T values (1, Null);
insert into T values (2, 'a');
insert into T values (2, 'B');
insert into T values (2, 'z');
insert into T values (2, 'z');
insert into T values (2, Null);
insert into T values (3, 'A');
insert into T values (3, 'A');
insert into T values (3, 'Z');