domainpolicy-create.sql 411 B

12345678910111213
  1. INSERT INTO version (table_name, table_version) values ('domainpolicy','2');
  2. CREATE TABLE domainpolicy (
  3. id INT(10) UNSIGNED AUTO_INCREMENT 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 rav_idx UNIQUE (rule, att, val)
  10. );
  11. CREATE INDEX rule_idx ON domainpolicy (rule);