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