BEGIN TRANSACTION;
CREATE TABLE Product(Streepjescode INTEGER(13), naam TEXT(50), PRIMARY KEY(Streepjescode));
INSERT INTO Product VALUES(54491472, 'Coca Cola Regular');
INSERT INTO Product VALUES(8711741314494, 'Fair Trade Pindakaas');
INSERT INTO Product VALUES(8711741006429, 'Fair Trade Hagelslag Puur');
CREATE TABLE Ingredient(ID INTEGER(8), naam TEXT(50), PRIMARY KEY(ID));
INSERT INTO Ingredient VALUES(1, 'sprankelend water');
INSERT INTO Ingredient VALUES(2, 'suiker');
INSERT INTO Ingredient VALUES(3, 'E150d');
INSERT INTO Ingredient VALUES(4, 'E338');
INSERT INTO Ingredient VALUES(5, 'cafeïne');
INSERT INTO Ingredient VALUES(6, 'pinda');
INSERT INTO Ingredient VALUES(7, 'plantaardige olie');
INSERT INTO Ingredient VALUES(8, 'plantaardig vet');
INSERT INTO Ingredient VALUES(9, 'zout');
INSERT INTO Ingredient VALUES(10, 'cacaomassa');
INSERT INTO Ingredient VALUES(11, 'magere cacaopoeder');
INSERT INTO Ingredient VALUES(12, 'raapzaadlecithine');
CREATE TABLE Koppel(IngredID INTEGER(8), Streepjescode INTEGER(13), PRIMARY KEY(IngredID, Streepjescode));
INSERT INTO Koppel VALUES(1, 54491472);
INSERT INTO Koppel VALUES(2, 54491472);
INSERT INTO Koppel VALUES(3, 54491472);
INSERT INTO Koppel VALUES(4, 54491472);
INSERT INTO Koppel VALUES(5, 54491472);
INSERT INTO Koppel VALUES(6, 8711741314494);
INSERT INTO Koppel VALUES(7, 8711741314494);
INSERT INTO Koppel VALUES(8, 8711741314494);
INSERT INTO Koppel VALUES(9, 8711741314494);
INSERT INTO Koppel VALUES(2, 8711741006429);
INSERT INTO Koppel VALUES(10, 8711741006429);
INSERT INTO Koppel VALUES(11, 8711741006429);
INSERT INTO Koppel VALUES(12, 8711741006429);
COMMIT;