Contributed Logic / file comparison
comparison: opensips/scripts/oracle/lcr-create.sql
opensips/scripts/oracle/lcr-create.sql
- changeset 16
- c5c55937e44c
- child 17
- 733187d496d0
equal
deleted
inserted
replaced
| -1:000000000000 | 0:98ffe2422d1b |
|---|---|
| 1 INSERT INTO version (table_name, table_version) values ('gw','8'); | |
| 2 CREATE TABLE gw ( | |
| 3 id NUMBER(10) PRIMARY KEY, | |
| 4 gw_name VARCHAR2(128), | |
| 5 grp_id NUMBER(10), | |
| 6 ip_addr VARCHAR2(15), | |
| 7 port NUMBER(5), | |
| 8 uri_scheme NUMBER(5), | |
| 9 transport NUMBER(5), | |
| 10 strip NUMBER(5), | |
| 11 tag VARCHAR2(16) DEFAULT NULL, | |
| 12 flags NUMBER(10) DEFAULT 0 NOT NULL, | |
| 13 CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) | |
| 14 ); | |
| 15 | |
| 16 CREATE OR REPLACE TRIGGER gw_tr | |
| 17 before insert on gw FOR EACH ROW | |
| 18 BEGIN | |
| 19 auto_id(:NEW.id); | |
| 20 END gw_tr; | |
| 21 / | |
| 22 BEGIN map2users('gw'); END; | |
| 23 / | |
| 24 CREATE INDEX gw_grp_id_idx ON gw (grp_id); | |
| 25 | |
| 26 INSERT INTO version (table_name, table_version) values ('lcr','3'); | |
| 27 CREATE TABLE lcr ( | |
| 28 id NUMBER(10) PRIMARY KEY, | |
| 29 prefix VARCHAR2(16) DEFAULT NULL, | |
| 30 from_uri VARCHAR2(64) DEFAULT NULL, | |
| 31 grp_id NUMBER(10), | |
| 32 priority NUMBER(10) | |
| 33 ); | |
| 34 | |
| 35 CREATE OR REPLACE TRIGGER lcr_tr | |
| 36 before insert on lcr FOR EACH ROW | |
| 37 BEGIN | |
| 38 auto_id(:NEW.id); | |
| 39 END lcr_tr; | |
| 40 / | |
| 41 BEGIN map2users('lcr'); END; | |
| 42 / | |
| 43 CREATE INDEX lcr_prefix_idx ON lcr (prefix); | |
| 44 CREATE INDEX lcr_from_uri_idx ON lcr (from_uri); | |
| 45 CREATE INDEX lcr_grp_id_idx ON lcr (grp_id); | |
| 46 |
