openidm.pgsql revision 7148faec4ad7bf860bf3610a4e32e5c2e22de890
842ae4bd224140319ae7feec1872b93dfd491143fielding--DROP SCHEMA IF EXISTS openidm CASCADE;
842ae4bd224140319ae7feec1872b93dfd491143fieldingCREATE SCHEMA openidm AUTHORIZATION openidm;
842ae4bd224140319ae7feec1872b93dfd491143fielding-- -----------------------------------------------------
842ae4bd224140319ae7feec1872b93dfd491143fielding-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz id BIGSERIAL NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objecttype VARCHAR(255) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT idx_objecttypes_objecttype UNIQUE (objecttype)
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
ae73782bebf25c971b539a5c132779c211cd8467wrowe id BIGSERIAL NOT NULL,
ae73782bebf25c971b539a5c132779c211cd8467wrowe objecttypes_id BIGINT NOT NULL,
ae73782bebf25c971b539a5c132779c211cd8467wrowe objectid VARCHAR(255) NOT NULL,
ae73782bebf25c971b539a5c132779c211cd8467wrowe rev VARCHAR(38) NOT NULL,
ae73782bebf25c971b539a5c132779c211cd8467wrowe fullobject JSON,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_genericobjects_objecttypes FOREIGN KEY (objecttypes_id) REFERENCES openidm.objecttypes (id) ON DELETE CASCADE ON UPDATE NO ACTION,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT idx_genericobjects_object UNIQUE (objecttypes_id, objectid)
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz genericobjects_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propkey VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz proptype VARCHAR(32) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propvalue TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_genericobjectproperties_genericobjects FOREIGN KEY (genericobjects_id) REFERENCES openidm.genericobjects (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_genericobjectproperties_genericobjects ON openidm.genericobjectproperties (genericobjects_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_genericobjectproperties_prop ON openidm.genericobjectproperties (propkey,propvalue);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz id BIGSERIAL NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(30) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz firstid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz firstpropname VARCHAR(32) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz secondid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz properties JSON,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id)
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE UNIQUE INDEX idx_relationships_uniq ON openidm.relationships (firstid, firstpropname, secondid);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE UNIQUE INDEX idx_relationships_objectid ON openidm.relationships (objectid);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_relationships_first ON openidm.relationships (firstId,firstpropname);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz id BIGSERIAL NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objecttypes_id BIGINT NOT NULL,
c99fcc66277151ac71c3a58f45933b0963355728sf objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz fullobject JSON,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_managedobjects_objectypes FOREIGN KEY (objecttypes_id) REFERENCES openidm.objecttypes (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE UNIQUE INDEX idx_managedobjects_object ON openidm.managedobjects (objecttypes_id,objectid);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_managedobjects_objectypes ON openidm.managedobjects (objecttypes_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz managedobjects_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propkey VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz proptype VARCHAR(32) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propvalue TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_managedobjectproperties_managedobjects FOREIGN KEY (managedobjects_id) REFERENCES openidm.managedobjects (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_managedobjectproperties_managedobjects ON openidm.managedobjectproperties (managedobjects_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_managedobjectproperties_prop ON openidm.managedobjectproperties (propkey,propvalue);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz id BIGSERIAL NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objecttypes_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz fullobject JSON,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_configobjects_objecttypes FOREIGN KEY (objecttypes_id) REFERENCES openidm.objecttypes (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE UNIQUE INDEX idx_configobjects_object ON openidm.configobjects (objecttypes_id,objectid);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_configobjects_objecttypes ON openidm.configobjects (objecttypes_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz configobjects_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propkey VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz proptype VARCHAR(255) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propvalue TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_configobjectproperties_configobjects FOREIGN KEY (configobjects_id) REFERENCES openidm.configobjects (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_configobjectproperties_configobjects ON openidm.configobjectproperties (configobjects_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_configobjectproperties_prop ON openidm.configobjectproperties (propkey,propvalue);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(38) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim rev VARCHAR(38) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim linktype VARCHAR(510) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim linkqualifier VARCHAR(255) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim firstid VARCHAR(255) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim secondid VARCHAR(255) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim PRIMARY KEY (objectid)
5318010ac72baab27afc1e13fea16488a2a2f595jimCREATE UNIQUE INDEX idx_links_first ON openidm.links (linktype, linkqualifier, firstid);
5318010ac72baab27afc1e13fea16488a2a2f595jimCREATE UNIQUE INDEX idx_links_second ON openidm.links (linktype, linkqualifier, secondid);
182f8df682f128ab5115a75f3aa7f33dc64b2284jim-- -----------------------------------------------------
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem-- -----------------------------------------------------
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem objectid VARCHAR(38) NOT NULL,
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem rev VARCHAR(38) NOT NULL,
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem storestring TEXT,
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem PRIMARY KEY (objectid)
8afe73ac06480b4cc8af89ca0b7299b5c76f3898jim-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
182f8df682f128ab5115a75f3aa7f33dc64b2284jim objectid VARCHAR(38) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim rev VARCHAR(38) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim keypair TEXT,
182f8df682f128ab5115a75f3aa7f33dc64b2284jim PRIMARY KEY (objectid)
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
182f8df682f128ab5115a75f3aa7f33dc64b2284jim-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim objectid VARCHAR(38) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim transactionid VARCHAR(56) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim activitydate VARCHAR(29) NOT NULL,
182f8df682f128ab5115a75f3aa7f33dc64b2284jim userid VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim eventname VARCHAR(50) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim result VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim principals TEXT,
5318010ac72baab27afc1e13fea16488a2a2f595jim context TEXT,
5318010ac72baab27afc1e13fea16488a2a2f595jim sessionid VARCHAR(255),
497ae11eabc186d6c901435ca252824608419417jim entries TEXT,
5318010ac72baab27afc1e13fea16488a2a2f595jim PRIMARY KEY (objectid)
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
497ae11eabc186d6c901435ca252824608419417jim-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim objectid VARCHAR(38) NOT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim activity VARCHAR(24) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim activitydate VARCHAR(29) NOT NULL,
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem transactionid VARCHAR(56) NOT NULL,
182f8df682f128ab5115a75f3aa7f33dc64b2284jim eventname VARCHAR(255),
5318010ac72baab27afc1e13fea16488a2a2f595jim server_ip VARCHAR(40),
5318010ac72baab27afc1e13fea16488a2a2f595jim server_port VARCHAR(5),
497ae11eabc186d6c901435ca252824608419417jim client_host VARCHAR(255),
497ae11eabc186d6c901435ca252824608419417jim client_ip VARCHAR(40),
497ae11eabc186d6c901435ca252824608419417jim client_port VARCHAR(5),
497ae11eabc186d6c901435ca252824608419417jim userid VARCHAR(255) DEFAULT NULL,
182f8df682f128ab5115a75f3aa7f33dc64b2284jim principal TEXT NULL,
497ae11eabc186d6c901435ca252824608419417jim roles VARCHAR(1024) DEFAULT NULL,
497ae11eabc186d6c901435ca252824608419417jim auth_component VARCHAR(255) DEFAULT NULL,
497ae11eabc186d6c901435ca252824608419417jim resource_uri VARCHAR(255) DEFAULT NULL,
497ae11eabc186d6c901435ca252824608419417jim resource_protocol VARCHAR(10) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim resource_method VARCHAR(10) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim resource_detail VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim http_method VARCHAR(10) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim http_path VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim http_querystring VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim http_headers TEXT,
5318010ac72baab27afc1e13fea16488a2a2f595jim status VARCHAR(20) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim elapsedtime VARCHAR(13) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim PRIMARY KEY (objectid)
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim objectid VARCHAR(38) NOT NULL,
18a801437cd6b572689b011a5e6b69aeb9f540cdrpluem activitydate VARCHAR(29) NOT NULL,
182f8df682f128ab5115a75f3aa7f33dc64b2284jim transactionid VARCHAR(56) NOT NULL,
497ae11eabc186d6c901435ca252824608419417jim eventname VARCHAR(255) DEFAULT NULL,
497ae11eabc186d6c901435ca252824608419417jim userid VARCHAR(255) DEFAULT NULL,
497ae11eabc186d6c901435ca252824608419417jim runas VARCHAR(255) DEFAULT NULL,
497ae11eabc186d6c901435ca252824608419417jim resource_uri VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim resource_protocol VARCHAR(10) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim resource_method VARCHAR(10) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim resource_detail VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim before TEXT,
5318010ac72baab27afc1e13fea16488a2a2f595jim after TEXT,
5318010ac72baab27afc1e13fea16488a2a2f595jim changedfields VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim rev VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim PRIMARY KEY (objectid)
000021c686647fa9c502b8f6a6656aad2fdac816jimCREATE INDEX idx_auditconfig_transactionid ON openidm.auditconfig (transactionid);
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz activity VARCHAR(24) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz activitydate VARCHAR(29) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz transactionid VARCHAR(56) NOT NULL,
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton eventname VARCHAR(255) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz userid VARCHAR(255) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz runas VARCHAR(255) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim resource_uri VARCHAR(255) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz resource_protocol VARCHAR(10) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz resource_method VARCHAR(10) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz resource_detail VARCHAR(255) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz subjectbefore TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz subjectafter TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz changedfields VARCHAR(255) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton passwordchanged VARCHAR(5) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz subjectrev VARCHAR(255) DEFAULT NULL,
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton message TEXT,
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton activityobjectid VARCHAR(255),
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton status VARCHAR(20),
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton PRIMARY KEY (objectid)
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jortonCREATE INDEX idx_auditactivity_transactionid ON openidm.auditactivity (transactionid);
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton-- -----------------------------------------------------
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton-- -----------------------------------------------------
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton objectid VARCHAR(38) NOT NULL,
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton transactionid VARCHAR(56) NOT NULL,
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton activitydate VARCHAR(29) NOT NULL,
d9f3f1245dae67e67e0f8d9a760c39c8cfb49f58jorton eventname VARCHAR(50) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton userid VARCHAR(255) DEFAULT NULL,
e8f95a682820a599fe41b22977010636be5c2717jim activity VARCHAR(24) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton exceptiondetail TEXT,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton linkqualifier VARCHAR(255) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton mapping VARCHAR(511) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton message TEXT,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton messagedetail TEXT,
e8f95a682820a599fe41b22977010636be5c2717jim situation VARCHAR(24) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton sourceobjectid VARCHAR(511) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton status VARCHAR(20) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton targetobjectid VARCHAR(511) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton reconciling VARCHAR(12) DEFAULT NULL,
e8f95a682820a599fe41b22977010636be5c2717jim ambiguoustargetobjectids TEXT,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton reconaction VARCHAR(36) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton entrytype VARCHAR(7) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton reconid VARCHAR(56) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton PRIMARY KEY (objectid)
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton-- -----------------------------------------------------
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton-- -----------------------------------------------------
a403dbf53e544291022bcc166ac8823d60fb1ee5niq objectid VARCHAR(38) NOT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq transactionid VARCHAR(56) NOT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq activitydate VARCHAR(29) NOT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq eventname VARCHAR(50) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq userid VARCHAR(255) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq activity VARCHAR(24) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq exceptiondetail TEXT,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq linkqualifier VARCHAR(255) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq mapping VARCHAR(511) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq message TEXT,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq messagedetail TEXT,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq situation VARCHAR(24) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq sourceobjectid VARCHAR(511) DEFAULT NULL,
a403dbf53e544291022bcc166ac8823d60fb1ee5niq status VARCHAR(20) DEFAULT NULL,
9dd930345a7ca0843f6660ee6a76d82147947fcdjorton targetobjectid VARCHAR(511) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (objectid)
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz pwd VARCHAR(510) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz roles VARCHAR(1024) DEFAULT NULL,
5318010ac72baab27afc1e13fea16488a2a2f595jim PRIMARY KEY (objectid)
182f8df682f128ab5115a75f3aa7f33dc64b2284jim-- -----------------------------------------------------
5318010ac72baab27afc1e13fea16488a2a2f595jim-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz description VARCHAR(510) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (objectid)
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz id BIGSERIAL NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objecttypes_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz fullobject JSON,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_schedulerobjects_objectypes FOREIGN KEY (objecttypes_id) REFERENCES openidm.objecttypes (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE UNIQUE INDEX idx_schedulerobjects_object ON openidm.schedulerobjects (objecttypes_id,objectid);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_schedulerobjects_objectypes ON openidm.schedulerobjects (objecttypes_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz schedulerobjects_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propkey VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz proptype VARCHAR(32) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propvalue TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_schedulerobjectproperties_schedulerobjects FOREIGN KEY (schedulerobjects_id) REFERENCES openidm.schedulerobjects (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_schedulerobjectproperties_schedulerobjects ON openidm.schedulerobjectproperties (schedulerobjects_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_schedulerobjectproperties_prop ON openidm.schedulerobjectproperties (propkey,propvalue);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz notificationType VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz createDate VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz message TEXT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz requester VARCHAR(255) NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz receiverId VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz requesterId VARCHAR(38) NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz notificationSubtype VARCHAR(255) NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (objectid)
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz id BIGSERIAL NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objecttypes_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz objectid VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz rev VARCHAR(38) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz fullobject JSON,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz PRIMARY KEY (id),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_clusterobjects_objectypes FOREIGN KEY (objecttypes_id) REFERENCES openidm.objecttypes (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE UNIQUE INDEX idx_clusterobjects_object ON openidm.clusterobjects (objecttypes_id,objectid);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_clusterobjects_objectypes ON openidm.clusterobjects (objecttypes_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz clusterobjects_id BIGINT NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propkey VARCHAR(255) NOT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz proptype VARCHAR(32) DEFAULT NULL,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz propvalue TEXT,
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz CONSTRAINT fk_clusterobjectproperties_clusterobjects FOREIGN KEY (clusterobjects_id) REFERENCES openidm.clusterobjects (id) ON DELETE CASCADE ON UPDATE NO ACTION
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX fk_clusterobjectproperties_clusterobjects ON openidm.clusterobjectproperties (clusterobjects_id);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_clusterobjectproperties_prop ON openidm.clusterobjectproperties (propkey,propvalue);
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- Data for table openidm.internaluser
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz-- -----------------------------------------------------
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzSTART TRANSACTION;
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzINSERT INTO openidm.internaluser (objectid, rev, pwd, roles) VALUES ('openidm-admin', '0', 'openidm-admin', '["openidm-admin","openidm-authorized"]');
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzINSERT INTO openidm.internaluser (objectid, rev, pwd, roles) VALUES ('anonymous', '0', 'anonymous', '["openidm-reg"]');
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzINSERT INTO openidm.internalrole (objectid, rev, description)
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz('openidm-authorized', '0', 'Basic minimum user'),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz('openidm-admin', '0', 'Administrative access'),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz('openidm-cert', '0', 'Authenticated via certificate'),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz('openidm-tasks-manager', '0', 'Allowed to reassign workflow tasks'),
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantz('openidm-reg', '0', 'Anonymous access');
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_json_clusterobjects_timestamp ON openidm.clusterobjects ( json_extract_path_text(fullobject, 'timestamp') );
56ab8639aed4d3b2f031d9c1160c5f40af01bdebjerenkrantzCREATE INDEX idx_json_clusterobjects_state ON openidm.clusterobjects ( json_extract_path_text(fullobject, 'state') );