-- Collection of code snippets by Arne Vajhøj 
-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) 
CREATE TABLE asset (
    id INTEGER NOT NULL,
    description VARCHAR(32),
    assettype INTEGER,
    PRIMARY KEY(id)
);
CREATE TABLE truckasset (
    id INTEGER NOT NULL,
    model VARCHAR(16),
    license VARCHAR(8),
    towcapacity INTEGER,
    PRIMARY KEY(id)
);
CREATE TABLE trailerasset (
    id INTEGER NOT NULL,
    ownweight INTEGER,
    maxcargo INTEGER,
    roof INTEGER,
    PRIMARY KEY(id)
);
CREATE TABLE toolasset (
    id INTEGER NOT NULL,
    tooltype VARCHAR(16),
    name VARCHAR(16),
    weight INTEGER,
    PRIMARY KEY(id)
);
