domain-create.sql 763 B

1234567891011121314151617181920212223
  1. CREATE TABLE domain (
  2. id INTEGER PRIMARY KEY NOT NULL,
  3. domain VARCHAR(64) NOT NULL,
  4. did VARCHAR(64) DEFAULT NULL,
  5. last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:01' NOT NULL,
  6. CONSTRAINT domain_domain_idx UNIQUE (domain)
  7. );
  8. INSERT INTO version (table_name, table_version) values ('domain','2');
  9. CREATE TABLE domain_attrs (
  10. id INTEGER PRIMARY KEY NOT NULL,
  11. did VARCHAR(64) NOT NULL,
  12. name VARCHAR(32) NOT NULL,
  13. type INTEGER NOT NULL,
  14. value VARCHAR(255) NOT NULL,
  15. last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:01' NOT NULL
  16. );
  17. CREATE INDEX domain_attrs_domain_attrs_idx ON domain_attrs (did, name);
  18. INSERT INTO version (table_name, table_version) values ('domain_attrs','1');