-- Collection of code snippets by Arne Vajhøj 
-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) 
CREATE TABLE myorder (
    id INTEGER NOT NULL,
    customer VARCHAR(32),
    PRIMARY KEY(id)
);
CREATE TABLE orderline (
    id INTEGER NOT NULL,
    orderid INTEGER NOT NULL,
    item VARCHAR(32),
    qty INTEGER,
    PRIMARY KEY(id)
);
