#!/bin/sh
sqlite3 blubb.db <<EOD
CREATE TABLE items(id INTEGER, level INTEGER, PRIMARY KEY(id));
INSERT INTO items VALUES(1, 1);
INSERT INTO items VALUES(2, 1);
INSERT INTO items VALUES(3, 2);
INSERT INTO items VALUES(4, 3);
INSERT INTO items VALUES(5, 3);
INSERT INTO items VALUES(6, 3);

CREATE TABLE translations(id INTEGER, lang TEXT, name TEXT, UNIQUE(id, lang));
INSERT INTO translations VALUES(1, 'en', 'buy');
INSERT INTO translations VALUES(1, 'de', 'kaufen');
INSERT INTO translations VALUES(1, 'is', 'kaupa');
INSERT INTO translations VALUES(1, 'fr', 'acheter');
INSERT INTO translations VALUES(2, 'en', 'sell');
INSERT INTO translations VALUES(2, 'is', 'selja');
INSERT INTO translations VALUES(3, 'is', 'laera');
INSERT INTO translations VALUES(3, 'fr', 'apprendre');
INSERT INTO translations VALUES(4, 'de', 'trinken');
INSERT INTO translations VALUES(4, 'en', 'drink');
INSERT INTO translations VALUES(4, 'is', 'drekka');
INSERT INTO translations VALUES(5, 'en', 'quit');
INSERT INTO translations VALUES(6, 'fr', 'annuler');
EOD