tools/oracle/rls-create.sql
4a81660c
 INSERT INTO version (table_name, table_version) values ('rls_presentity','0');
 CREATE TABLE rls_presentity (
     id NUMBER(10) PRIMARY KEY,
b7c84392
     rlsubs_did VARCHAR2(255),
4a81660c
     resource_uri VARCHAR2(128),
     content_type VARCHAR2(64),
     presence_state BLOB,
     expires NUMBER(10),
     updated NUMBER(10),
     auth_state NUMBER(10),
     reason VARCHAR2(64),
     CONSTRAINT ORA_rls_presentity_idx  UNIQUE (rlsubs_did, resource_uri)
38fac614
 );
4a81660c
 
 CREATE OR REPLACE TRIGGER rls_presentity_tr
38fac614
 before insert on rls_presentity FOR EACH ROW
 BEGIN
   auto_id(:NEW.id);
 END rls_presentity_tr;
 /
4a81660c
 BEGIN map2users('rls_presentity'); END;
38fac614
 /
4a81660c
 CREATE INDEX rls_presentity_updated_idx  ON rls_presentity (updated);
38fac614
 
4a81660c
 INSERT INTO version (table_name, table_version) values ('rls_watchers','1');
 CREATE TABLE rls_watchers (
     id NUMBER(10) PRIMARY KEY,
     presentity_uri VARCHAR2(128),
     to_user VARCHAR2(64),
     to_domain VARCHAR2(64),
     watcher_username VARCHAR2(64),
     watcher_domain VARCHAR2(64),
     event VARCHAR2(64) DEFAULT 'presence',
     event_id VARCHAR2(64),
     to_tag VARCHAR2(64),
     from_tag VARCHAR2(64),
     callid VARCHAR2(64),
     local_cseq NUMBER(10),
     remote_cseq NUMBER(10),
     contact VARCHAR2(64),
     record_route CLOB,
     expires NUMBER(10),
     status NUMBER(10) DEFAULT 2 NOT NULL,
     reason VARCHAR2(64),
     version NUMBER(10) DEFAULT 0 NOT NULL,
     socket_info VARCHAR2(64),
     local_contact VARCHAR2(128),
     CONSTRAINT rls_watchers_rls_watcher_idx  UNIQUE (presentity_uri, callid, to_tag, from_tag)
38fac614
 );
4a81660c
 
 CREATE OR REPLACE TRIGGER rls_watchers_tr
38fac614
 before insert on rls_watchers FOR EACH ROW
 BEGIN
   auto_id(:NEW.id);
 END rls_watchers_tr;
 /
4a81660c
 BEGIN map2users('rls_watchers'); END;
38fac614
 /