CREATE TABLE categories (
    catName text NOT NULL,
    sortOrder integer,
    parent text DEFAULT 'TOPLEVEL' NOT NULL,
    category_template text,
    category_template_timestamp timestamp,
    primary key (catName),
    foreign key (catName) references categorie_names(catName),
    foreign key (parent) references categorie_names(catName)
);


CREATE OR REPLACE FUNCTION categories_template_timstamp() RETURNS trigger AS '
    BEGIN
        NEW.category_template_timestamp := \'now\';
        RETURN NEW;
    END;
' LANGUAGE plpgsql;

CREATE TRIGGER categories_template_timstamp AFTER INSERT OR UPDATE ON categories
    FOR EACH ROW EXECUTE PROCEDURE categories_template_timstamp();