BEGIN TRANSACTION;

DROP TABLE IF EXISTS 'triggers';

CREATE TABLE `types` (
	`uuid`	TEXT NOT NULL DEFAULT (lower(hex(randomblob(4))||'-'||hex(randomblob(2))||'-'||hex(randomblob(2))||'-'||hex(randomblob(2))||'-'||hex(randomblob(6)))) CHECK(uuid regexp '^[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}$'),
	`description`	TEXT NOT NULL,
	PRIMARY KEY(`uuid`)
);

INSERT INTO `types` (uuid,description) VALUES ('615a5615-0001-43ff-b4f2-762b0dbfb4e6x', 'Substitution');
INSERT INTO `types` (uuid,description) VALUES ('615a5615-0002-43ff-b4f2-762b0dbfb4e6', 'URL');
INSERT INTO `types` (uuid,description) VALUES ('615a5615-0003-43ff-b4f2-762b0dbfb4e6', 'Date');

COMMIT;