lcr-create.sql 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. CREATE TABLE lcr_gw (
  2. id INTEGER PRIMARY KEY NOT NULL,
  3. lcr_id SMALLINT NOT NULL,
  4. gw_name VARCHAR(128),
  5. ip_addr VARCHAR(50),
  6. hostname VARCHAR(64),
  7. port SMALLINT,
  8. params VARCHAR(64),
  9. uri_scheme SMALLINT,
  10. transport SMALLINT,
  11. strip SMALLINT,
  12. prefix VARCHAR(16) DEFAULT NULL,
  13. tag VARCHAR(64) DEFAULT NULL,
  14. flags INTEGER DEFAULT 0 NOT NULL,
  15. defunct INTEGER DEFAULT NULL
  16. );
  17. CREATE INDEX lcr_gw_lcr_id_idx ON lcr_gw (lcr_id);
  18. INSERT INTO version (table_name, table_version) values ('lcr_gw','3');
  19. CREATE TABLE lcr_rule_target (
  20. id INTEGER PRIMARY KEY NOT NULL,
  21. lcr_id SMALLINT NOT NULL,
  22. rule_id INTEGER NOT NULL,
  23. gw_id INTEGER NOT NULL,
  24. priority SMALLINT NOT NULL,
  25. weight INTEGER DEFAULT 1 NOT NULL,
  26. CONSTRAINT lcr_rule_target_rule_id_gw_id_idx UNIQUE (rule_id, gw_id)
  27. );
  28. CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id);
  29. INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1');
  30. CREATE TABLE lcr_rule (
  31. id INTEGER PRIMARY KEY NOT NULL,
  32. lcr_id SMALLINT NOT NULL,
  33. prefix VARCHAR(16) DEFAULT NULL,
  34. from_uri VARCHAR(64) DEFAULT NULL,
  35. request_uri VARCHAR(64) DEFAULT NULL,
  36. mt_tvalue VARCHAR(128) DEFAULT NULL,
  37. stopper INTEGER DEFAULT 0 NOT NULL,
  38. enabled INTEGER DEFAULT 1 NOT NULL,
  39. CONSTRAINT lcr_rule_lcr_id_prefix_from_uri_idx UNIQUE (lcr_id, prefix, from_uri)
  40. );
  41. INSERT INTO version (table_name, table_version) values ('lcr_rule','3');