opensips/scripts/oracle/lcr-create.sql@d783b433388d (annotated)
opensips/scripts/oracle/lcr-create.sql
Mon, 16 Jan 2012 23:08:14 +0100
- author
- Michael Schloh von Bennewitz <michael@schloh.com>
- date
- Mon, 16 Jan 2012 23:08:14 +0100
- changeset 23
- d783b433388d
- parent 16
- c5c55937e44c
- permissions
- -rw-r--r--
Inconclusively complete possibly missing fields. This change introduces
inconsistencies difficult to correct given incomplete documentation of
IPKG and OPKG packaging standards.
| michael@16 | 1 | INSERT INTO version (table_name, table_version) values ('gw','8'); |
| michael@16 | 2 | CREATE TABLE gw ( |
| michael@16 | 3 | id NUMBER(10) PRIMARY KEY, |
| michael@16 | 4 | gw_name VARCHAR2(128), |
| michael@16 | 5 | grp_id NUMBER(10), |
| michael@16 | 6 | ip_addr VARCHAR2(15), |
| michael@16 | 7 | port NUMBER(5), |
| michael@16 | 8 | uri_scheme NUMBER(5), |
| michael@16 | 9 | transport NUMBER(5), |
| michael@16 | 10 | strip NUMBER(5), |
| michael@16 | 11 | tag VARCHAR2(16) DEFAULT NULL, |
| michael@16 | 12 | flags NUMBER(10) DEFAULT 0 NOT NULL, |
| michael@17 | 13 | user VARCHAR2(16) DEFAULT NULL, |
| michael@17 | 14 | realm VARCHAR2(16) DEFAULT NULL, |
| michael@17 | 15 | passwd VARCHAR2(16) DEFAULT NULL, |
| michael@16 | 16 | CONSTRAINT gw_gw_name_idx UNIQUE (gw_name) |
| michael@16 | 17 | ); |
| michael@16 | 18 | |
| michael@16 | 19 | CREATE OR REPLACE TRIGGER gw_tr |
| michael@16 | 20 | before insert on gw FOR EACH ROW |
| michael@16 | 21 | BEGIN |
| michael@16 | 22 | auto_id(:NEW.id); |
| michael@16 | 23 | END gw_tr; |
| michael@16 | 24 | / |
| michael@16 | 25 | BEGIN map2users('gw'); END; |
| michael@16 | 26 | / |
| michael@16 | 27 | CREATE INDEX gw_grp_id_idx ON gw (grp_id); |
| michael@16 | 28 | |
| michael@16 | 29 | INSERT INTO version (table_name, table_version) values ('lcr','3'); |
| michael@16 | 30 | CREATE TABLE lcr ( |
| michael@16 | 31 | id NUMBER(10) PRIMARY KEY, |
| michael@16 | 32 | prefix VARCHAR2(16) DEFAULT NULL, |
| michael@16 | 33 | from_uri VARCHAR2(64) DEFAULT NULL, |
| michael@16 | 34 | grp_id NUMBER(10), |
| michael@16 | 35 | priority NUMBER(10) |
| michael@16 | 36 | ); |
| michael@16 | 37 | |
| michael@16 | 38 | CREATE OR REPLACE TRIGGER lcr_tr |
| michael@16 | 39 | before insert on lcr FOR EACH ROW |
| michael@16 | 40 | BEGIN |
| michael@16 | 41 | auto_id(:NEW.id); |
| michael@16 | 42 | END lcr_tr; |
| michael@16 | 43 | / |
| michael@16 | 44 | BEGIN map2users('lcr'); END; |
| michael@16 | 45 | / |
| michael@16 | 46 | CREATE INDEX lcr_prefix_idx ON lcr (prefix); |
| michael@16 | 47 | CREATE INDEX lcr_from_uri_idx ON lcr (from_uri); |
| michael@16 | 48 | CREATE INDEX lcr_grp_id_idx ON lcr (grp_id); |
| michael@16 | 49 |
