-- remove all tables

-- create all tables
CREATE TABLE Comics (
  Series TEXT,
  Titel TEXT,
  Number INTEGER,
  Year INTEGER,
  Author TEXT
);

CREATE TABLE Friends (
  Name TEXT,
  EMail TEXT
);

CREATE TABLE Rentals (
  Who TEXT,
  What TEXT,
  Back TEXT
);


-- insert all values
INSERT INTO Rentals VALUES ("Struppi", "Logicomix", "Nein");
INSERT INTO Rentals VALUES ("Ed", "Sleeper-1", "Ja");
INSERT INTO Rentals VALUES ("Apostolos", "Tim&Struppi-2", "Ja");

INSERT INTO Friends VALUES ("Tim", "tim@gmx.de"); 
INSERT INTO Friends VALUES ("Struppi", "struppi@google.com"); 
INSERT INTO Friends VALUES ("Apostolos", "apostolos.doxiadis@whereever.gr");

INSERT INTO Comics VALUES ("Tim & Struppi", "Der blaue Lotos", 4, 1934, "Herge");
INSERT INTO Comics VALUES ("Tim & Struppi", "Tim im Kongo", 1, 1930, "Herge");
INSERT INTO Comics VALUES ("Sleeper", "Out in the Cold", 1, 2003, "Ed Brubaker");
INSERT INTO Comics VALUES ("Sleeper", "All False Moves", 2, 2004, "Ed Brubaker");
INSERT INTO Comics VALUES (NULL, "Logicomix", NULL, 2010, "Doxiadis, Papadimitriou");
