-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
USE test;
CREATE TABLE prefs (
    tree VARCHAR(32) NOT NULL,
    app VARCHAR(32) NOT NULL,
    pkey VARCHAR(32) NOT NULL,
    pvalue VARCHAR(255),
    PRIMARY KEY(tree,app,pkey)
);
INSERT INTO prefs VALUES('ARNE','demo','a','123');
INSERT INTO prefs VALUES('ARNE','demo','b','ABC');
INSERT INTO prefs VALUES('ARNE','demo','src','Database');
