1CREATE TABLE mtree (
2    id INTEGER PRIMARY KEY NOT NULL,
3    tprefix VARCHAR(32) DEFAULT '' NOT NULL,
4    tvalue VARCHAR(128) DEFAULT '' NOT NULL,
5    CONSTRAINT mtree_tprefix_idx UNIQUE (tprefix)
6);
7
8INSERT INTO version (table_name, table_version) values ('mtree','1');
9
10CREATE TABLE mtrees (
11    id INTEGER PRIMARY KEY NOT NULL,
12    tname VARCHAR(128) DEFAULT '' NOT NULL,
13    tprefix VARCHAR(32) DEFAULT '' NOT NULL,
14    tvalue VARCHAR(128) DEFAULT '' NOT NULL,
15    CONSTRAINT mtrees_tname_tprefix_tvalue_idx UNIQUE (tname, tprefix, tvalue)
16);
17
18INSERT INTO version (table_name, table_version) values ('mtrees','2');
19
20