openidm.sql revision ece129ea346a2c66eb6241f1c39735a582698cda
-- DROP SEQUENCE genericobjects_id_SEQ;
CREATE SEQUENCE genericobjects_id_SEQ
-- DROP SEQUENCE configobjects_id_SEQ;
CREATE SEQUENCE configobjects_id_SEQ
-- DROP SEQUENCE relationships_id_SEQ;
CREATE SEQUENCE relationships_id_SEQ
-- DROP SEQUENCE managedobjects_id_SEQ;
CREATE SEQUENCE managedobjects_id_SEQ
-- DROP SEQUENCE schedulerobjects_id_SEQ;
CREATE SEQUENCE schedulerobjects_id_SEQ
-- DROP SEQUENCE clusterobjects_id_SEQ;
CREATE SEQUENCE clusterobjects_id_SEQ
-- DROP SEQUENCE objecttypes_id_SEQ;
CREATE SEQUENCE objecttypes_id_SEQ
-- DROP SEQUENCE updateobjects_id_SEQ;
CREATE SEQUENCE updateobjects_id_SEQ
-- DROP TABLE uinotification CASCADE CONSTRAINTS;
CREATE TABLE uinotification (
);
ALTER TABLE uinotification
(
)
;
-- DROP TABLE auditaccess CASCADE CONSTRAINTS;
-- -----------------------------------------------------
-- Table openidm.auditaccess
-- -----------------------------------------------------
CREATE TABLE auditaccess (
trackingids CLOB,
request_detail CLOB NULL ,
http_request_queryparameters CLOB NULL ,
http_request_headers CLOB NULL ,
http_request_cookies CLOB NULL ,
http_response_headers CLOB NULL ,
roles CLOB NULL
);
;
ALTER TABLE auditaccess
(
)
;
-- DROP TABLE auditauthentication CASCADE CONSTRAINTS;
-- -----------------------------------------------------
-- Table openidm.auditauthentication
-- -----------------------------------------------------
CREATE TABLE auditauthentication (
result VARCHAR2(255 CHAR),
principals CLOB,
context CLOB,
entries CLOB,
trackingids CLOB
);
;
ALTER TABLE auditauthentication
(
)
;
-- DROP TABLE auditconfig CASCADE CONSTRAINTS;
-- -----------------------------------------------------
-- Table openidm.auditconfig
-- -----------------------------------------------------
CREATE TABLE auditconfig (
trackingids CLOB,
beforeObject CLOB,
afterObject CLOB,
);
;
ALTER TABLE auditconfig
(
)
;
(
)
;
-- DROP TABLE auditactivity CASCADE CONSTRAINTS;
-- -----------------------------------------------------
-- Table openidm.auditactivity
-- -----------------------------------------------------
CREATE TABLE auditactivity (
trackingids CLOB,
subjectbefore CLOB,
subjectafter CLOB,
message CLOB,
);
;
ALTER TABLE auditactivity
(
)
;
(
)
;
-- DROP TABLE auditrecon CASCADE CONSTRAINTS;
-- -----------------------------------------------------
-- Table openidm.auditrecon
-- -----------------------------------------------------
CREATE TABLE auditrecon (
trackingids CLOB,
exceptiondetail CLOB,
message CLOB,
messagedetail CLOB,
ambiguoustargetobjectids CLOB,
);
;
ALTER TABLE auditrecon
(
)
;
-- DROP TABLE auditsync CASCADE CONSTRAINTS;
-- -----------------------------------------------------
-- Table openidm.auditsync
-- -----------------------------------------------------
CREATE TABLE auditsync (
trackingids CLOB,
exceptiondetail CLOB,
message CLOB,
messagedetail CLOB,
);
;
ALTER TABLE auditsync
(
)
;
-- DROP TABLE configobjectproperties CASCADE CONSTRAINTS;
CREATE TABLE configobjectproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE configobjects CASCADE CONSTRAINTS;
CREATE TABLE configobjects (
fullobject CLOB
);
ALTER TABLE configobjects
(
)
;
(
)
;
(
)
;
-- DROP TABLE relationshipproperties CASCADE CONSTRAINTS;
CREATE TABLE relationshipproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE relationships CASCADE CONSTRAINTS;
CREATE TABLE relationships (
fullobject CLOB
);
ALTER TABLE relationships
(
)
;
(
)
;
(
)
;
-- DROP TABLE genericobjectproperties CASCADE CONSTRAINTS;
CREATE TABLE genericobjectproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE genericobjects CASCADE CONSTRAINTS;
CREATE TABLE genericobjects (
fullobject CLOB
);
ALTER TABLE genericobjects
(
)
;
(
)
;
(
)
;
-- DROP TABLE internaluser CASCADE CONSTRAINTS;
CREATE TABLE internaluser (
);
-- DROP TABLE internalrole CASCADE CONSTRAINTS;
CREATE TABLE internalrole (
);
ALTER TABLE internaluser
(
)
;
-- DROP TABLE links CASCADE CONSTRAINTS;
CREATE TABLE links (
);
ALTER TABLE links
(
)
;
(
)
;
(
)
;
-- DROP TABLE security CASCADE CONSTRAINTS;
CREATE TABLE security (
storestring CLOB
);
ALTER TABLE security
(
)
;
-- DROP TABLE securitykeys CASCADE CONSTRAINTS;
CREATE TABLE securitykeys (
keypair CLOB
);
ALTER TABLE securitykeys
(
)
;
-- DROP TABLE managedobjectproperties CASCADE CONSTRAINTS;
CREATE TABLE managedobjectproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE managedobjects CASCADE CONSTRAINTS;
CREATE TABLE managedobjects (
fullobject CLOB
);
ALTER TABLE managedobjects
(
)
;
(
)
;
(
)
;
-- DROP TABLE schedobjectproperties CASCADE CONSTRAINTS;
CREATE TABLE schedobjectproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE schedulerobjects CASCADE CONSTRAINTS;
CREATE TABLE schedulerobjects (
fullobject CLOB
);
ALTER TABLE schedulerobjects
(
)
;
(
)
;
(
)
;
-- DROP TABLE clusterobjectproperties CASCADE CONSTRAINTS;
CREATE TABLE clusterobjectproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE clusterobjects CASCADE CONSTRAINTS;
CREATE TABLE clusterobjects (
fullobject CLOB
);
ALTER TABLE clusterobjects
(
)
;
(
)
;
(
)
;
-- DROP TABLE updateobjectproperties CASCADE CONSTRAINTS;
CREATE TABLE updateobjectproperties (
);
(
)
;
(
)
;
(
)
;
-- DROP TABLE updateobjects CASCADE CONSTRAINTS;
CREATE TABLE updateobjects (
fullobject CLOB
);
ALTER TABLE updateobjects
(
)
;
(
)
;
(
)
;
-- DROP TABLE objecttypes CASCADE CONSTRAINTS;
CREATE TABLE objecttypes (
);
ALTER TABLE objecttypes
(
)
;
(
)
;
ALTER TABLE configobjectproperties
(
)
REFERENCES configobjects
(
)
ON DELETE CASCADE
;
ALTER TABLE configobjects
(
)
REFERENCES objecttypes
(
)
ON DELETE CASCADE
;
ALTER TABLE genericobjects
(
)
REFERENCES objecttypes
(
)
ON DELETE CASCADE
;
ALTER TABLE managedobjectproperties
(
)
REFERENCES managedobjects
(
)
ON DELETE CASCADE
;
ALTER TABLE managedobjects
(
)
REFERENCES objecttypes
(
)
ON DELETE CASCADE
;
ALTER TABLE genericobjectproperties
(
)
REFERENCES genericobjects
(
)
ON DELETE CASCADE
;
PROMPT Creating Foreign Key Constraint fk_updateobjectproperties_man on table updateobjectproperties...
ALTER TABLE updateobjectproperties
(
)
REFERENCES updateobjects
(
)
ON DELETE CASCADE
;
ALTER TABLE updateobjects
(
)
REFERENCES objecttypes
(
)
ON DELETE CASCADE
;
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
FOR EACH ROW
DECLARE
BEGIN
-- If this is the first time this table have been inserted into (sequence == 1)
--get the max indentity value from the table
--set the sequence to that value
END LOOP;
END IF;
--used to emulate LAST_INSERT_ID()
--mysql_utilities.identity := v_newVal;
-- assign the value from the sequence to emulate the identity column
END IF;
END;
/
INSERT INTO internaluser (objectid, rev, pwd, roles) VALUES ('openidm-admin', '0', 'openidm-admin', '[ { "_ref" : "repo/internal/role/openidm-admin" }, { "_ref" : "repo/internal/role/openidm-authorized" } ]');
INSERT INTO internaluser (objectid, rev, pwd, roles) VALUES ('anonymous', '0', 'anonymous', '[ { "_ref" : "repo/internal/role/openidm-reg" } ]');
INSERT ALL
VALUES ('openidm-admin', 0, 'Administrative access')
VALUES ('openidm-authorized', 0, 'Basic minimum user')
VALUES ('openidm-cert', 0, 'Authenticated via certificate')
VALUES ('openidm-reg', 0, 'Anonymous access')
VALUES ('openidm-tasks-manager', 0, 'Allowed to reassign workflow tasks')
SELECT * FROM dual;
COMMIT;