-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE TABLE p (
    id INTEGER NOT NULL,
    typ INTEGER NOT NULL,
    PRIMARY KEY(id)
);
CREATE TABLE c1 (
    id INETGER NOT NULL,
    ival INTEGER,
    PRIMARY KEY(id)
);
CREATE TABLE c2 (
    id INETGER NOT NULL,
    sval VARCHAR(50),
    PRIMARY KEY(id)
);
INSERT INTO p VALUES(1, 1);
INSERT INTO c1 VALUES(1, 123);
INSERT INTO p VALUES(2, 2);
INSERT INTO c2 VALUES(2, 'ABC');
