domainpolicy-create.sql 412 B

12345678910111213
  1. INSERT INTO version (table_name, table_version) values ('domainpolicy','2');
  2. CREATE TABLE domainpolicy (
  3. id SERIAL PRIMARY KEY NOT NULL,
  4. rule VARCHAR(255) NOT NULL,
  5. type VARCHAR(255) NOT NULL,
  6. att VARCHAR(255),
  7. val VARCHAR(128),
  8. description VARCHAR(255) NOT NULL,
  9. CONSTRAINT domainpolicy_rav_idx UNIQUE (rule, att, val)
  10. );
  11. CREATE INDEX domainpolicy_rule_idx ON domainpolicy (rule);