2
0

mtree-create.sql 271 B

12345678
  1. INSERT INTO version (table_name, table_version) values ('mtree','1');
  2. CREATE TABLE mtree (
  3. id SERIAL PRIMARY KEY NOT NULL,
  4. tprefix VARCHAR(32) DEFAULT '' NOT NULL,
  5. tvalue VARCHAR(128) DEFAULT '' NOT NULL,
  6. CONSTRAINT mtree_tprefix_idx UNIQUE (tprefix)
  7. );