You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@syncope.apache.org by il...@apache.org on 2018/07/05 10:44:06 UTC
[3/9] syncope git commit: [SYNCOPE-1024] New 'upgrade' module ready
with tests, old 'migration' removed
http://git-wip-us.apache.org/repos/asf/syncope/blob/027b6bdf/core/upgrade/src/test/resources/syncopedb20.sql
----------------------------------------------------------------------
diff --git a/core/upgrade/src/test/resources/syncopedb20.sql b/core/upgrade/src/test/resources/syncopedb20.sql
new file mode 100644
index 0000000..314669b
--- /dev/null
+++ b/core/upgrade/src/test/resources/syncopedb20.sql
@@ -0,0 +1,2867 @@
+-- Licensed to the Apache Software Foundation (ASF) under one
+-- or more contributor license agreements. See the NOTICE file
+-- distributed with this work for additional information
+-- regarding copyright ownership. The ASF licenses this file
+-- to you under the Apache License, Version 2.0 (the
+-- "License"); you may not use this file except in compliance
+-- with the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing,
+-- software distributed under the License is distributed on an
+-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+-- KIND, either express or implied. See the License for the
+-- specific language governing permissions and limitations
+-- under the License.
+
+CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_59F7B0CC_7480_4829_9E5B_C3B02CB5126B START WITH 1 BELONGS_TO_TABLE;
+CREATE MEMORY TABLE PUBLIC.QRTZ_CALENDARS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ CALENDAR_NAME VARCHAR(200) NOT NULL,
+ CALENDAR IMAGE NOT NULL
+);
+ALTER TABLE PUBLIC.QRTZ_CALENDARS ADD CONSTRAINT PUBLIC.PK_QRTZ_CALENDARS PRIMARY KEY(SCHED_NAME, CALENDAR_NAME);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_CALENDARS;
+CREATE MEMORY TABLE PUBLIC.QRTZ_CRON_TRIGGERS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ TRIGGER_NAME VARCHAR(200) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL,
+ CRON_EXPRESSION VARCHAR(120) NOT NULL,
+ TIME_ZONE_ID VARCHAR(80)
+);
+ALTER TABLE PUBLIC.QRTZ_CRON_TRIGGERS ADD CONSTRAINT PUBLIC.PK_QRTZ_CRON_TRIGGERS PRIMARY KEY(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP);
+-- 4 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_CRON_TRIGGERS;
+INSERT INTO PUBLIC.QRTZ_CRON_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, CRON_EXPRESSION, TIME_ZONE_ID) VALUES
+('scheduler', 'Trigger_taskJobe95555d2-1b09-42c8-b25b-f4c4ec597979', 'DEFAULT', '0 0 0 1 * ?', 'Europe/Rome'),
+('scheduler', 'Trigger_notificationJob', 'DEFAULT', '0/20 * * * * ?', 'Europe/Rome'),
+('scheduler', 'Trigger_systemLoadReporterJob', 'DEFAULT', '0 * * * * ?', 'Europe/Rome'),
+('scheduler', 'Trigger_taskJob89de5014-e3f5-4462-84d8-d97575740baf', 'DEFAULT', '0 0/5 * * * ?', 'Europe/Rome');
+CREATE MEMORY TABLE PUBLIC.QRTZ_FIRED_TRIGGERS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ ENTRY_ID VARCHAR(95) NOT NULL,
+ TRIGGER_NAME VARCHAR(200) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL,
+ INSTANCE_NAME VARCHAR(200) NOT NULL,
+ FIRED_TIME BIGINT NOT NULL,
+ SCHED_TIME BIGINT NOT NULL,
+ PRIORITY INTEGER NOT NULL,
+ STATE VARCHAR(16) NOT NULL,
+ JOB_NAME VARCHAR(200),
+ JOB_GROUP VARCHAR(200),
+ IS_NONCONCURRENT BOOLEAN,
+ REQUESTS_RECOVERY BOOLEAN
+);
+ALTER TABLE PUBLIC.QRTZ_FIRED_TRIGGERS ADD CONSTRAINT PUBLIC.PK_QRTZ_FIRED_TRIGGERS PRIMARY KEY(SCHED_NAME, ENTRY_ID);
+-- 1 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_FIRED_TRIGGERS;
+INSERT INTO PUBLIC.QRTZ_FIRED_TRIGGERS(SCHED_NAME, ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, INSTANCE_NAME, FIRED_TIME, SCHED_TIME, PRIORITY, STATE, JOB_NAME, JOB_GROUP, IS_NONCONCURRENT, REQUESTS_RECOVERY) VALUES
+('scheduler', 'bambooo15306986457271530698645716', 'Trigger_notificationJob', 'DEFAULT', 'bambooo1530698645727', 1530698700189, 1530698720000, 5, 'ACQUIRED', NULL, NULL, FALSE, FALSE);
+CREATE MEMORY TABLE PUBLIC.QRTZ_PAUSED_TRIGGER_GRPS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL
+);
+ALTER TABLE PUBLIC.QRTZ_PAUSED_TRIGGER_GRPS ADD CONSTRAINT PUBLIC.PK_QRTZ_PAUSED_TRIGGER_GRPS PRIMARY KEY(SCHED_NAME, TRIGGER_GROUP);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_PAUSED_TRIGGER_GRPS;
+CREATE MEMORY TABLE PUBLIC.QRTZ_SCHEDULER_STATE(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ INSTANCE_NAME VARCHAR(200) NOT NULL,
+ LAST_CHECKIN_TIME BIGINT NOT NULL,
+ CHECKIN_INTERVAL BIGINT NOT NULL
+);
+ALTER TABLE PUBLIC.QRTZ_SCHEDULER_STATE ADD CONSTRAINT PUBLIC.PK_QRTZ_SCHEDULER_STATE PRIMARY KEY(SCHED_NAME, INSTANCE_NAME);
+-- 1 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_SCHEDULER_STATE;
+INSERT INTO PUBLIC.QRTZ_SCHEDULER_STATE(SCHED_NAME, INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES
+('scheduler', 'bambooo1530698645727', 1530698701866, 20000);
+CREATE MEMORY TABLE PUBLIC.QRTZ_LOCKS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ LOCK_NAME VARCHAR(40) NOT NULL
+);
+ALTER TABLE PUBLIC.QRTZ_LOCKS ADD CONSTRAINT PUBLIC.PK_QRTZ_LOCKS PRIMARY KEY(SCHED_NAME, LOCK_NAME);
+-- 2 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_LOCKS;
+INSERT INTO PUBLIC.QRTZ_LOCKS(SCHED_NAME, LOCK_NAME) VALUES
+('scheduler', 'TRIGGER_ACCESS'),
+('scheduler', 'STATE_ACCESS');
+CREATE MEMORY TABLE PUBLIC.QRTZ_JOB_DETAILS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ JOB_NAME VARCHAR(200) NOT NULL,
+ JOB_GROUP VARCHAR(200) NOT NULL,
+ DESCRIPTION VARCHAR(250),
+ JOB_CLASS_NAME VARCHAR(250) NOT NULL,
+ IS_DURABLE BOOLEAN NOT NULL,
+ IS_NONCONCURRENT BOOLEAN NOT NULL,
+ IS_UPDATE_DATA BOOLEAN NOT NULL,
+ REQUESTS_RECOVERY BOOLEAN NOT NULL,
+ JOB_DATA IMAGE
+);
+ALTER TABLE PUBLIC.QRTZ_JOB_DETAILS ADD CONSTRAINT PUBLIC.PK_QRTZ_JOB_DETAILS PRIMARY KEY(SCHED_NAME, JOB_NAME, JOB_GROUP);
+-- 28 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_JOB_DETAILS;
+INSERT INTO PUBLIC.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES
+('scheduler', 'taskJob89de5014-e3f5-4462-84d8-d97575740baf', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', FALSE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400476f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e6a6f622e45787069726564416363657373546f6b656e436c65616e7570740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob30cfd653-257b-495f-8665-281281dbcb3d', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobec674143-480a-4816-98ad-b61fa090821e', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob97f327b6-2eff-4d35-85e8-d581baaab855', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob81d88f73-d474-4450-9031-605daa4e313f', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800');
+INSERT INTO PUBLIC.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES
+('scheduler', 'taskJob38abbf9e-a1a3-40a1-a15f-7d0ac02f47f1', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobfeae4e57-15ca-40d9-b973-8b9015efca49', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob7c2242f4-14af-4ab5-af31-cdae23783655', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob83f7e85d-9774-43fe-adba-ccd856312994', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobe95555d2-1b09-42c8-b25b-f4c4ec597979', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', FALSE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c61737374003b6f72672e6170616368652e73796e636f70652e6669742e636f72652e7265666572656e63652e5465737453616d706c654a6f6244656c6567617465740006646f6d61696e7400064d61737465727800');
+INSERT INTO PUBLIC.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES
+('scheduler', 'taskJob24b1be9c-7e3b-443a-86c9-798ebce5eaf2', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob375c7b7f-9e3a-4833-88c9-b7787b0a69f2', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobfd905ba5-9d56-4f51-83e2-859096a67b75', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobe95555d2-1b09-42c8-b25b-f4c4ec598989', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400456f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e6a6f622e4964656e74697479526563657274696669636174696f6e740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob986867e2-993b-430e-8feb-aa9abb4c1dcd', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800');
+INSERT INTO PUBLIC.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES
+('scheduler', 'taskJob1e419ca4-ea81-4493-a14f-28b90113686d', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobc41b9b71-9bfa-4f90-89f2-84787def4c5c', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobaf558be4-9d2f-4359-bf85-a554e6e90be1', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob5e5f7c7e-9de7-4c6a-99f1-4df1af959807', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJobc46edc3a-a18b-4af2-b707-f4a415507496', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800');
+INSERT INTO PUBLIC.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES
+('scheduler', 'taskJob0bc11a19-6454-45c2-a4e3-ceef84e5d79b', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob51318433-cce4-4f71-8f45-9534b6c9c819', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob55d5e74b-497e-4bc0-9156-73abef4b9adc', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e50756c6c4a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'taskJob03aa2a04-4881-4573-9117-753f81b04865', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.TaskJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000274000d64656c6567617465436c6173737400426f72672e6170616368652e73796e636f70652e636f72652e70726f766973696f6e696e672e6a6176612e7075736870756c6c2e507573684a6f6244656c6567617465740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'reportJob0062ea9c-924d-4ecf-9961-4492a8cc6d1b', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.report.ReportJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000001740006646f6d61696e7400064d61737465727800');
+INSERT INTO PUBLIC.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES
+('scheduler', 'reportJobc3520ad9-179f-49e7-b315-d684d216dd97', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.report.ReportJob', TRUE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000001740006646f6d61696e7400064d61737465727800'),
+('scheduler', 'notificationJob', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.notification.NotificationJob', FALSE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000001740006646f6d61696e74000354776f7800'),
+('scheduler', 'systemLoadReporterJob', 'DEFAULT', NULL, 'org.apache.syncope.core.provisioning.java.job.SystemLoadReporterJob', FALSE, TRUE, FALSE, FALSE, X'aced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000001740006646f6d61696e74000354776f7800');
+CREATE MEMORY TABLE PUBLIC.QRTZ_SIMPLE_TRIGGERS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ TRIGGER_NAME VARCHAR(200) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL,
+ REPEAT_COUNT BIGINT NOT NULL,
+ REPEAT_INTERVAL BIGINT NOT NULL,
+ TIMES_TRIGGERED BIGINT NOT NULL
+);
+ALTER TABLE PUBLIC.QRTZ_SIMPLE_TRIGGERS ADD CONSTRAINT PUBLIC.PK_QRTZ_SIMPLE_TRIGGERS PRIMARY KEY(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_SIMPLE_TRIGGERS;
+CREATE MEMORY TABLE PUBLIC.QRTZ_SIMPROP_TRIGGERS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ TRIGGER_NAME VARCHAR(200) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL,
+ STR_PROP_1 VARCHAR(512),
+ STR_PROP_2 VARCHAR(512),
+ STR_PROP_3 VARCHAR(512),
+ INT_PROP_1 INTEGER,
+ INT_PROP_2 INTEGER,
+ LONG_PROP_1 BIGINT,
+ LONG_PROP_2 BIGINT,
+ DEC_PROP_1 NUMERIC(13, 4),
+ DEC_PROP_2 NUMERIC(13, 4),
+ BOOL_PROP_1 BOOLEAN,
+ BOOL_PROP_2 BOOLEAN
+);
+ALTER TABLE PUBLIC.QRTZ_SIMPROP_TRIGGERS ADD CONSTRAINT PUBLIC.PK_QRTZ_SIMPROP_TRIGGERS PRIMARY KEY(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_SIMPROP_TRIGGERS;
+CREATE MEMORY TABLE PUBLIC.QRTZ_BLOB_TRIGGERS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ TRIGGER_NAME VARCHAR(200) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL,
+ BLOB_DATA IMAGE
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_BLOB_TRIGGERS;
+CREATE MEMORY TABLE PUBLIC.QRTZ_TRIGGERS(
+ SCHED_NAME VARCHAR(120) NOT NULL,
+ TRIGGER_NAME VARCHAR(200) NOT NULL,
+ TRIGGER_GROUP VARCHAR(200) NOT NULL,
+ JOB_NAME VARCHAR(200) NOT NULL,
+ JOB_GROUP VARCHAR(200) NOT NULL,
+ DESCRIPTION VARCHAR(250),
+ NEXT_FIRE_TIME BIGINT,
+ PREV_FIRE_TIME BIGINT,
+ PRIORITY INTEGER,
+ TRIGGER_STATE VARCHAR(16) NOT NULL,
+ TRIGGER_TYPE VARCHAR(8) NOT NULL,
+ START_TIME BIGINT NOT NULL,
+ END_TIME BIGINT,
+ CALENDAR_NAME VARCHAR(200),
+ MISFIRE_INSTR SMALLINT,
+ JOB_DATA IMAGE
+);
+ALTER TABLE PUBLIC.QRTZ_TRIGGERS ADD CONSTRAINT PUBLIC.PK_QRTZ_TRIGGERS PRIMARY KEY(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP);
+-- 4 +/- SELECT COUNT(*) FROM PUBLIC.QRTZ_TRIGGERS;
+INSERT INTO PUBLIC.QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, JOB_NAME, JOB_GROUP, DESCRIPTION, NEXT_FIRE_TIME, PREV_FIRE_TIME, PRIORITY, TRIGGER_STATE, TRIGGER_TYPE, START_TIME, END_TIME, CALENDAR_NAME, MISFIRE_INSTR, JOB_DATA) VALUES
+('scheduler', 'Trigger_taskJobe95555d2-1b09-42c8-b25b-f4c4ec597979', 'DEFAULT', 'taskJobe95555d2-1b09-42c8-b25b-f4c4ec597979', 'DEFAULT', NULL, 1533074400000, -1, 5, 'WAITING', 'CRON', 1530698657000, 0, NULL, 0, X''),
+('scheduler', 'Trigger_taskJob89de5014-e3f5-4462-84d8-d97575740baf', 'DEFAULT', 'taskJob89de5014-e3f5-4462-84d8-d97575740baf', 'DEFAULT', NULL, 1530699000000, 1530698700000, 5, 'WAITING', 'CRON', 1530698657000, 0, NULL, 0, X''),
+('scheduler', 'Trigger_systemLoadReporterJob', 'DEFAULT', 'systemLoadReporterJob', 'DEFAULT', NULL, 1530698760000, 1530698700000, 5, 'WAITING', 'CRON', 1530698657000, 0, NULL, 0, X''),
+('scheduler', 'Trigger_notificationJob', 'DEFAULT', 'notificationJob', 'DEFAULT', NULL, 1530698720000, 1530698700000, 5, 'ACQUIRED', 'CRON', 1530698657000, 0, NULL, 0, X'');
+CREATE MEMORY TABLE PUBLIC.ACCESSTOKEN(
+ ID VARCHAR(255) NOT NULL,
+ AUTHORITIES BLOB,
+ BODY CLOB,
+ EXPIRYTIME TIMESTAMP,
+ OWNER VARCHAR(255)
+);
+ALTER TABLE PUBLIC.ACCESSTOKEN ADD CONSTRAINT PUBLIC.CONSTRAINT_4 PRIMARY KEY(ID);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ACCESSTOKEN;
+CREATE MEMORY TABLE PUBLIC.ACCOUNTPOLICY(
+ ID VARCHAR(36) NOT NULL,
+ DESCRIPTION VARCHAR(255),
+ MAXAUTHENTICATIONATTEMPTS INTEGER,
+ PROPAGATESUSPENSION INTEGER
+);
+ALTER TABLE PUBLIC.ACCOUNTPOLICY ADD CONSTRAINT PUBLIC.CONSTRAINT_B PRIMARY KEY(ID);
+-- 2 +/- SELECT COUNT(*) FROM PUBLIC.ACCOUNTPOLICY;
+INSERT INTO PUBLIC.ACCOUNTPOLICY(ID, DESCRIPTION, MAXAUTHENTICATIONATTEMPTS, PROPAGATESUSPENSION) VALUES
+('20ab5a8c-4b0c-432c-b957-f7fb9784d9f7', 'an account policy', 0, 0),
+('06e2ed52-6966-44aa-a177-a0ca7434201f', 'sample account policy', 3, 0);
+CREATE MEMORY TABLE PUBLIC.ACCOUNTPOLICY_EXTERNALRESOURCE(
+ ACCOUNTPOLICY_ID VARCHAR(36),
+ RESOURCE_ID VARCHAR(255)
+);
+-- 1 +/- SELECT COUNT(*) FROM PUBLIC.ACCOUNTPOLICY_EXTERNALRESOURCE;
+INSERT INTO PUBLIC.ACCOUNTPOLICY_EXTERNALRESOURCE(ACCOUNTPOLICY_ID, RESOURCE_ID) VALUES
+('20ab5a8c-4b0c-432c-b957-f7fb9784d9f7', 'resource-testdb');
+CREATE MEMORY TABLE PUBLIC.ACCOUNTRULECONFINSTANCE(
+ ID VARCHAR(36) NOT NULL,
+ SERIALIZEDINSTANCE CLOB,
+ ACCOUNTPOLICY_ID VARCHAR(36)
+);
+ALTER TABLE PUBLIC.ACCOUNTRULECONFINSTANCE ADD CONSTRAINT PUBLIC.CONSTRAINT_2 PRIMARY KEY(ID);
+-- 2 +/- SELECT COUNT(*) FROM PUBLIC.ACCOUNTRULECONFINSTANCE;
+INSERT INTO PUBLIC.ACCOUNTRULECONFINSTANCE(ID, SERIALIZEDINSTANCE, ACCOUNTPOLICY_ID) VALUES
+('5', '{"@class":"org.apache.syncope.common.lib.policy.DefaultAccountRuleConf","maxLength":0,"minLength":0,"pattern":null,"allUpperCase":false,"allLowerCase":false,"wordsNotPermitted":[],"schemasNotPermitted":[],"prefixesNotPermitted":[],"suffixesNotPermitted":[]}', '20ab5a8c-4b0c-432c-b957-f7fb9784d9f7'),
+('6', '{"@class":"org.apache.syncope.common.lib.policy.DefaultAccountRuleConf","maxLength":0,"minLength":4,"pattern":null,"allUpperCase":false,"allLowerCase":false,"wordsNotPermitted":[],"schemasNotPermitted":[],"prefixesNotPermitted":["notpermitted1","notpermitted2"],"suffixesNotPermitted":[]}', '06e2ed52-6966-44aa-a177-a0ca7434201f');
+CREATE MEMORY TABLE PUBLIC.ADYNGROUPMEMBERSHIP(
+ ID VARCHAR(36) NOT NULL,
+ FIQL VARCHAR(255),
+ GROUP_ID VARCHAR(36),
+ ANYTYPE_ID VARCHAR(255)
+);
+ALTER TABLE PUBLIC.ADYNGROUPMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_F PRIMARY KEY(ID);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADYNGROUPMEMBERSHIP;
+CREATE MEMORY TABLE PUBLIC.AMEMBERSHIP(
+ ID VARCHAR(36) NOT NULL,
+ ANYOBJECT_ID VARCHAR(36),
+ GROUP_ID VARCHAR(36)
+);
+ALTER TABLE PUBLIC.AMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_9 PRIMARY KEY(ID);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AMEMBERSHIP;
+CREATE INDEX PUBLIC.AMEMBERSHIP_ANYOBJECTINDEX ON PUBLIC.AMEMBERSHIP(ANYOBJECT_ID);
+CREATE INDEX PUBLIC.AMEMBERSHIP_GROUPINDEX ON PUBLIC.AMEMBERSHIP(GROUP_ID);
+CREATE MEMORY TABLE PUBLIC.ANYABOUT(
+ ID VARCHAR(36) NOT NULL,
+ FILTER CLOB,
+ NOTIFICATION_ID VARCHAR(36),
+ ANYTYPE_ID VARCHAR(255)
+);
+ALTER TABLE PUBLIC.ANYABOUT ADD CONSTRAINT PUBLIC.CONSTRAINT_1 PRIMARY KEY(ID);
+-- 2 +/- SELECT COUNT(*) FROM PUBLIC.ANYABOUT;
+INSERT INTO PUBLIC.ANYABOUT(ID, FILTER, NOTIFICATION_ID, ANYTYPE_ID) VALUES
+('a328f2e6-25e9-4cc1-badf-7425d7be4b39', 'token!=$null', 'e00945b5-1184-4d43-8e45-4318a8dcdfd4', 'USER'),
+('2e2ee845-2abf-43c6-b543-49243a84e2f1', 'fullname==*o*;fullname==*i*', '9e2b911c-25de-4c77-bcea-b86ed9451050', 'USER');
+CREATE MEMORY TABLE PUBLIC.ANYOBJECT(
+ ID VARCHAR(36) NOT NULL,
+ CREATIONDATE TIMESTAMP,
+ CREATOR VARCHAR(255),
+ LASTCHANGEDATE TIMESTAMP,
+ LASTMODIFIER VARCHAR(255),
+ STATUS VARCHAR(255),
+ WORKFLOWID VARCHAR(255),
+ NAME VARCHAR(255),
+ REALM_ID VARCHAR(36),
+ TYPE_ID VARCHAR(255)
+);
+ALTER TABLE PUBLIC.ANYOBJECT ADD CONSTRAINT PUBLIC.CONSTRAINT_3 PRIMARY KEY(ID);
+-- 3 +/- SELECT COUNT(*) FROM PUBLIC.ANYOBJECT;
+INSERT INTO PUBLIC.ANYOBJECT(ID, CREATIONDATE, CREATOR, LASTCHANGEDATE, LASTMODIFIER, STATUS, WORKFLOWID, NAME, REALM_ID, TYPE_ID) VALUES
+('fc6dbc3a-6c07-4965-8781-921e7401a4a5', TIMESTAMP '2010-10-20 11:00:00', 'admin', TIMESTAMP '2010-10-20 11:00:00', 'admin', NULL, NULL, 'HP LJ 1300n', 'e4c28e7a-9dbf-4ee7-9441-93812a0d4a28', 'PRINTER'),
+('8559d14d-58c2-46eb-a2d4-a7d35161e8f8', TIMESTAMP '2010-10-20 11:00:00', 'admin', TIMESTAMP '2010-10-20 11:00:00', 'admin', NULL, NULL, 'Canon MF 8030cn', 'e4c28e7a-9dbf-4ee7-9441-93812a0d4a28', 'PRINTER'),
+('9e1d130c-d6a3-48b1-98b3-182477ed0688', TIMESTAMP '2010-10-20 11:00:00', 'admin', TIMESTAMP '2010-10-20 11:00:00', 'admin', NULL, NULL, 'Epson Stylus Color', '0679e069-7355-4b20-bd11-a5a0a5453c7c', 'PRINTER');
+CREATE MEMORY TABLE PUBLIC.ANYOBJECT_ANYTYPECLASS(
+ ANYOBJECT_ID VARCHAR(36),
+ ANYTYPECLASS_ID VARCHAR(255)
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANYOBJECT_ANYTYPECLASS;
+CREATE MEMORY TABLE PUBLIC.ANYOBJECT_EXTERNALRESOURCE(
+ ANYOBJECT_ID VARCHAR(36),
+ RESOURCE_ID VARCHAR(255)
+);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANYOBJECT_EXTERNALRESOURCE;
+CREATE MEMORY TABLE PUBLIC.ANYTEMPLATEPULLTASK(
+ ID VARCHAR(36) NOT NULL,
+ TEMPLATE CLOB,
+ ANYTYPE_ID VARCHAR(255),
+ PULLTASK_ID VARCHAR(36)
+);
+ALTER TABLE PUBLIC.ANYTEMPLATEPULLTASK ADD CONSTRAINT PUBLIC.CONSTRAINT_9E PRIMARY KEY(ID);
+-- 8 +/- SELECT COUNT(*) FROM PUBLIC.ANYTEMPLATEPULLTASK;
+INSERT INTO PUBLIC.ANYTEMPLATEPULLTASK(ID, TEMPLATE, ANYTYPE_ID, PULLTASK_ID) VALUES
+('3a6173a9-8c34-4e37-b3b1-0c2ea385fac0', '{"@class":"org.apache.syncope.common.lib.to.UserTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"USER","realm":null,"status":null,"password":null,"token":null,"tokenExpireTime":null,"username":null,"lastLoginDate":null,"changePwdDate":null,"failedLogins":null,"securityQuestion":null,"securityAnswer":null,"auxClasses":["csv"],"derAttrs":[{"schema":"cn","values":[""]}],"virAttrs":[],"resources":["resource-testdb"],"relationships":[],"memberships":[{"groupKey":"f779c0d4-633b-4be5-8f57-32eb478a3ca5","groupName":null}],"dynMemberships":[],"roles":[],"dynRoles":[],"plainAttrs":[{"schema":"ctype","values":["email == ''test8@syncope.apache.org''? ''TYPE_8'': ''TYPE_OTHER''"]}]}', 'USER', 'c41b9b71-9bfa-4f90-89f2-84787def4c5c'),
+('b3772d66-ec06-4133-bf38-b3273845ac5b', '{"@class":"org.apache.syncope.common.lib.to.GroupTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"GROUP","realm":null,"status":null,"name":null,"userOwner":null,"groupOwner":null,"udynMembershipCond":null,"auxClasses":[],"derAttrs":[],"virAttrs":[],"resources":[],"plainAttrs":[]}', 'GROUP', 'c41b9b71-9bfa-4f90-89f2-84787def4c5c'),
+('6c3f578d-327b-4a7c-8037-6f5ba24eb770', '{"@class":"org.apache.syncope.common.lib.to.UserTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"USER","realm":null,"status":null,"password":null,"token":null,"tokenExpireTime":null,"username":null,"lastLoginDate":null,"changePwdDate":null,"failedLogins":null,"securityQuestion":null,"securityAnswer":null,"auxClasses":[],"derAttrs":[],"virAttrs":[],"resources":[],"relationships":[],"memberships":[],"dynMemberships":[],"roles":[],"dynRoles":[],"plainAttrs":[{"schema":"ctype","values":["''type a''"]},{"schema":"userId","values":["''reconciled@syncope.apache.org''"]},{"schema":"fullname","values":["''reconciled fullname''"]},{"schema":"surname","values":["''surname''"]}]}', 'USER', '83f7e85d-9774-43fe-adba-ccd856312994'),
+('45b61137-c7c3-49ee-86e0-9efffa75ae68', '{"@class":"org.apache.syncope.common.lib.to.GroupTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"GROUP","realm":null,"status":null,"name":null,"userOwner":null,"groupOwner":null,"udynMembershipCond":null,"auxClasses":[],"derAttrs":[],"virAttrs":[],"resources":[],"plainAttrs":[]}', 'GROUP', '83f7e85d-9774-43fe-adba-ccd856312994'),
+('df655a2a-40c0-43b1-a157-3f4988802f58', '{"@class":"org.apache.syncope.common.lib.to.UserTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"USER","realm":"''/'' + title","status":null,"password":null,"token":null,"tokenExpireTime":null,"username":null,"lastLoginDate":null,"changePwdDate":null,"failedLogins":null,"securityQuestion":null,"securityAnswer":null,"auxClasses":["minimal group"],"derAttrs":[],"virAttrs":[{"schema":"virtualReadOnly","values":[""]}],"resources":["resource-ldap"],"roles":[],"dynRoles":[],"relationships":[],"memberships":[],"dynMemberships":[],"plainAttrs":[]}', 'USER', '1e419ca4-ea81-4493-a14f-28b90113686d'),
+('fda22ff3-98f3-42e4-a2ae-cd9a28282d57', '{"@class":"org.apache.syncope.common.lib.to.GroupTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"GROUP","realm":null,"status":null,"name":null,"userOwner":null,"groupOwner":null,"udynMembershipCond":null,"auxClasses":[],"derAttrs":[],"virAttrs":[],"resources":[],"plainAttrs":[{"schema":"show","values":["true"]}]}', 'GROUP', '1e419ca4-ea81-4493-a14f-28b90113686d'),
+('8bc41ba1-cc1d-4ee0-bb43-61cd148b414f', '{"@class":"org.apache.syncope.common.lib.to.UserTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"USER","realm":null,"status":null,"password":null,"token":null,"tokenExpireTime":null,"username":null,"lastLoginDate":null,"changePwdDate":null,"failedLogins":null,"securityQuestion":null,"securityAnswer":null,"auxClasses":[],"derAttrs":[],"virAttrs":[],"resources":["resource-testdb"],"roles":[],"dynRoles":[],"relationships":[],"memberships":[],"dynMemberships":[],"plainAttrs":[{"schema":"firstname","values":[""]},{"schema":"userId","values":["''test''"]},{"schema":"fullname","values":["''test''"]},{"schema":"surname","values":["''test''"]}]}', 'USER', '986867e2-993b-430e-8feb-aa9abb4c1dcd');
+INSERT INTO PUBLIC.ANYTEMPLATEPULLTASK(ID, TEMPLATE, ANYTYPE_ID, PULLTASK_ID) VALUES
+('9af0e343-8a37-42d2-9bc7-6e2e3b103219', '{"@class":"org.apache.syncope.common.lib.to.GroupTO","creator":null,"creationDate":null,"lastModifier":null,"lastChangeDate":null,"key":null,"type":"GROUP","realm":null,"status":null,"name":null,"userOwner":null,"groupOwner":null,"udynMembershipCond":null,"auxClasses":[],"derAttrs":[],"virAttrs":[],"resources":[],"plainAttrs":[]}', 'GROUP', '986867e2-993b-430e-8feb-aa9abb4c1dcd');
+CREATE MEMORY TABLE PUBLIC.ANYTEMPLATEREALM(
+ ID VARCHAR(36) NOT NULL,
+ TEMPLATE CLOB,
+ REALM_ID VARCHAR(36),
+ ANYTYPE_ID VARCHAR(255)
+);
+ALTER TABLE PUBLIC.ANYTEMPLATEREALM ADD CONSTRAINT PUBLIC.CONSTRAINT_D PRIMARY KEY(ID);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANYTEMPLATEREALM;
+CREATE MEMORY TABLE PUBLIC.ANYTYPE(
+ ID VARCHAR(255) NOT NULL,
+ KIND VARCHAR(20)
+);
+ALTER TABLE PUBLIC.ANYTYPE ADD CONSTRAINT PUBLIC.CONSTRAINT_F8 PRIMARY KEY(ID);
+-- 3 +/- SELECT COUNT(*) FROM PUBLIC.ANYTYPE;
+INSERT INTO PUBLIC.ANYTYPE(ID, KIND) VALUES
+('USER', 'USER'),
+('GROUP', 'GROUP'),
+('PRINTER', 'ANY_OBJECT');
+CREATE MEMORY TABLE PUBLIC.ANYTYPECLASS(
+ ID VARCHAR(255) NOT NULL
+);
+ALTER TABLE PUBLIC.ANYTYPECLASS ADD CONSTRAINT PUBLIC.CONSTRAINT_49 PRIMARY KEY(ID);
+-- 6 +/- SELECT COUNT(*) FROM PUBLIC.ANYTYPECLASS;
+INSERT INTO PUBLIC.ANYTYPECLASS(ID) VALUES
+('generic membership'),
+('minimal user'),
+('other'),
+('minimal group'),
+('minimal printer'),
+('csv');
+CREATE MEMORY TABLE PUBLIC.ANYTYPE_ANYTYPECLASS(
+ ANYTYPE_ID VARCHAR(255),
+ ANYTYPECLASS_ID VARCHAR(255)
+);
+-- 4 +/- SELECT COUNT(*) FROM PUBLIC.ANYTYPE_ANYTYPECLASS;
+INSERT INTO PUBLIC.ANYTYPE_ANYTYPECLASS(ANYTYPE_ID, ANYTYPECLASS_ID) VALUES
+('USER', 'minimal user'),
+('USER', 'other'),
+('GROUP', 'minimal group'),
+('PRINTER', 'minimal printer');
+CREATE MEMORY TABLE PUBLIC.APLAINATTR(
+ ID VARCHAR(36) NOT NULL,
+ OWNER_ID VARCHAR(36),
+ SCHEMA_ID VARCHAR(255),
+ MEMBERSHIP_ID VARCHAR(36)
+);
+ALTER TABLE PUBLIC.APLAINATTR ADD CONSTRAINT PUBLIC.CONSTRAINT_22 PRIMARY KEY(ID);
+-- 4 +/- SELECT COUNT(*) FROM PUBLIC.APLAINATTR;
+INSERT INTO PUBLIC.APLAINATTR(ID, OWNER_ID, SCHEMA_ID, MEMBERSHIP_ID) VALUES
+('956a8440-1df7-4ed6-b156-04173ca47528', 'fc6dbc3a-6c07-4965-8781-921e7401a4a5', 'model', NULL),
+('1fa796fd-c7e2-414e-8ad3-ac86b729d62c', 'fc6dbc3a-6c07-4965-8781-921e7401a4a5', 'location', NULL),
+('b8342732-81bd-440b-91ac-b8cdad288ed5', '8559d14d-58c2-46eb-a2d4-a7d35161e8f8', 'model', NULL),
+('c4cb0684-a033-425c-8b1b-d283597f999b', '8559d14d-58c2-46eb-a2d4-a7d35161e8f8', 'location', NULL);
+CREATE INDEX PUBLIC.APLAINATTR_SCHEMA_INDEX ON PUBLIC.APLAINATTR(SCHEMA_ID);
+CREATE INDEX PUBLIC.APLAINATTR_OWNER_INDEX ON PUBLIC.APLAINATTR(OWNER_ID);
+CREATE INDEX PUBLIC.APLAINATTR_MEMBERSHIP_INDEX ON PUBLIC.APLAINATTR(MEMBERSHIP_ID);
+CREATE MEMORY TABLE PUBLIC.APLAINATTRUNIQUEVALUE(
+ ID VARCHAR(36) NOT NULL,
+ BINARYVALUE BLOB,
+ BOOLEANVALUE INTEGER,
+ DATEVALUE TIMESTAMP,
+ DOUBLEVALUE DOUBLE,
+ LONGVALUE BIGINT,
+ STRINGVALUE VARCHAR(255),
+ ATTRIBUTE_ID VARCHAR(36),
+ SCHEMA_ID VARCHAR(255)
+);
+ALTER TABLE PUBLIC.APLAINATTRUNIQUEVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_FE PRIMARY KEY(ID);
+-- 0 +/- SELECT COUNT(*) FROM PUBLIC.APLAINATTRUNIQUEVALUE;
+CREATE INDEX PUBLIC.APATTRUNIQUEVALUE_ATTRINDEX ON PUBLIC.APLAINATTRUNIQUEVALUE(ATTRIBUTE_ID);
+CREATE MEMORY TABLE PUBLIC.APLAINATTRVALUE(
+ ID VARCHAR(36) NOT NULL,
+ BINARYVALUE BLOB,
+ BOOLEANVALUE INTEGER,
+ DATEVALUE TIMESTAMP,
+ DOUBLEVALUE DOUBLE,
+ LONGVALUE BIGINT,
+ STRINGVALUE VARCHAR(255),
+ ATTRIBUTE_ID VARCHAR(36)
+);
+ALTER TABLE PUBLIC.APLAINATTRVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_B4 PRIMARY KEY(ID);
+-- 4 +/- SELECT COUNT(*) FROM PUBLIC.APLAINATTRVALUE;
+INSERT INTO PUBLIC.APLAINATTRVALUE(ID, BINARYVALUE, BOOLEANVALUE, DATEVALUE, DOUBLEVALUE, LONGVALUE, STRINGVALUE, ATTRIBUTE_ID) VALUES
+('15f64e99-20cc-42ec-a77a-3396dea4248f', NULL, NULL, NULL, NULL, NULL, 'Canon MFC8030', '956a8440-1df7-4ed6-b156-04173ca47528'),
+('ad0452c9-93b9-4248-b2ca-48ef8a1cf5b5', NULL, NULL, NULL, NULL, NULL, '1st floor', '1fa796fd-c7e2-414e-8ad3-ac86b729d62c'),
+('50e852ac-68ba-4b12-85ca-e366987fd855', NULL, NULL, NULL, NULL, NULL, 'HP Laserjet 1300n', 'b8342732-81bd-440b-91ac-b8cdad288ed5'),
+('7b954dee-8a14-4fa1-a433-cff0d1f888f8', NULL, NULL, NULL, NULL, NULL, '2nd floor', 'c4cb0684-a033-425c-8b1b-d283597f999b');
+CREATE INDEX PUBLIC.AATTRVALUE_DATEVALUEINDEX ON PUBLIC.APLAINATTRVALUE(DATEVALUE);
+CREATE INDEX PUBLIC.AATTRVALUE_LONGVALUEINDEX ON PUBLIC.APLAINATTRVALUE(LONGVALUE);
+CREATE INDEX PUBLIC.AATTRVALUE_BOOLEANVALUEINDEX ON PUBLIC.APLAINATTRVALUE(BOOLEANVALUE);
+CREATE INDEX PUBLIC.AATTRVALUE_DOUBLEVALUEINDEX ON PUBLIC.APLAINATTRVALUE(DOUBLEVALUE);
+CREATE INDEX PUBLIC.AATTRVALUE_STRINGVALUEINDEX ON PUBLIC.APLAINATTRVALUE(STRINGVALUE);
+CREATE INDEX PUBLIC.APLAINATTRVALUE_ATTRINDEX ON PUBLIC.APLAINATTRVALUE(ATTRIBUTE_ID);
+CREATE MEMORY TABLE PUBLIC.ARELATIONSHIP(
+ ID VARCHAR(36) NOT NULL,
+ LEFT_ANYOBJECT_ID VARCHAR(36),
+ RIGHT_ANYOBJECT_ID VARCHAR(36),
+ TYPE_ID VARCHAR(255)
+);
+ALTER TABLE PUBLIC.ARELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_9C PRIMARY KEY(ID);
+-- 1 +/- SELECT COUNT(*) FROM PUBLIC.ARELATIONSHIP;
+INSERT INTO PUBLIC.ARELATIONSHIP(ID, LEFT_ANYOBJECT_ID, RIGHT_ANYOBJECT_ID, TYPE_ID) VALUES
+('11a0ec66-b59b-428a-af3d-f856950ff1c5', 'fc6dbc3a-6c07-4965-8781-921e7401a4a5', '8559d14d-58c2-46eb-a2d4-a7d35161e8f8', 'neighborhood');
+CREATE INDEX PUBLIC.ARELATIONSHIP_ANYOBJECTINDEX ON PUBLIC.ARELATIONSHIP(LEFT_ANYOBJECT_ID);
+CREATE INDEX PUBLIC.ARELATIONSHIP_RIGHTINDEX ON PUBLIC.ARELATIONSHIP(RIGHT_ANYOBJECT_ID);
+CREATE MEMORY TABLE PUBLIC.CAMELROUTE(
+ ID VARCHAR(255) NOT NULL,
+ ANYTYPEKIND VARCHAR(20),
+ CONTENT CLOB
+);
+ALTER TABLE PUBLIC.CAMELROUTE ADD CONSTRAINT PUBLIC.CONSTRAINT_9B PRIMARY KEY(ID);
+-- 31 +/- SELECT COUNT(*) FROM PUBLIC.CAMELROUTE;
+INSERT INTO PUBLIC.CAMELROUTE(ID, ANYTYPEKIND, CONTENT) VALUES
+('createUser', 'USER', STRINGDECODE('<route id=\"createUser\">\n <from uri=\"direct:createUser\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"create(${body},${property.disablePwdPolicyCheck},${property.enabled},${property.storePassword})\" ref=\"uwfAdapter\"/>\n <to uri=\"propagate:create?anyTypeKind=USER\"/>\n <to uri=\"direct:createPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:createPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('updateUser', 'USER', STRINGDECODE('<route id=\"updateUser\">\n <from uri=\"direct:updateUser\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"update(${body})\" ref=\"uwfAdapter\"/>\n <to uri=\"propagate:update?anyTypeKind=USER\"/>\n <to uri=\"direct:updatePort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:updatePort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('updateUserInPull', 'USER', STRINGDECODE('<route id=\"updateUserInPull\">\n <from uri=\"direct:updateUserInPull\"/> \n <doTry>\n <bean method=\"update(${body})\" ref=\"uwfAdapter\"/>\n <to uri=\"direct:userInPull\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:updateInPullPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('userInPull', 'USER', STRINGDECODE('<route id=\"userInPull\">\n <from uri=\"direct:userInPull\"/>\n <to uri=\"propagate:status?anyTypeKind=USER&pull=true\"/>\n <to uri=\"propagate:update?anyTypeKind=USER&pull=true\"/>\n <to uri=\"direct:updateInPullPort\"/>\n </route>')),
+('deleteUser', 'USER', STRINGDECODE('<route id=\"deleteUser\">\n <from uri=\"direct:deleteUser\"/>\n <doTry>\n <to uri=\"propagate:delete?anyTypeKind=USER\"/>\n <bean method=\"delete(${body})\" ref=\"uwfAdapter\"/>\n <setBody>\n <simple>${property.statuses}</simple>\n </setBody>\n <to uri=\"direct:deletePort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:deletePort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('unlinkUser', 'USER', STRINGDECODE('<route id=\"unlinkUser\">\n <from uri=\"direct:unlinkUser\"/>\n <doTry>\n <bean method=\"update(${body})\" ref=\"uwfAdapter\"/>\n <setBody>\n <simple>${body.getResult.getKey}</simple>\n </setBody>\n <to uri=\"direct:unlinkPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:unlinkPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('linkUser', 'USER', STRINGDECODE('<route id=\"linkUser\">\n <from uri=\"direct:linkUser\"/>\n <doTry>\n <bean method=\"update(${body})\" ref=\"uwfAdapter\"/>\n <setBody>\n <simple>${body.getResult.getKey}</simple>\n </setBody>\n <to uri=\"direct:linkPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:linkPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('activateUser', 'USER', STRINGDECODE('<route id=\"activateUser\">\n <from uri=\"direct:activateUser\"/>\n <doTry>\n <bean method=\"activate(${body}, ${property.token})\" ref=\"uwfAdapter\"/>\n <to uri=\"direct:userStatusPropagation\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:statusPort\"/>\n </doCatch>\n </doTry> \n </route>'));
+INSERT INTO PUBLIC.CAMELROUTE(ID, ANYTYPEKIND, CONTENT) VALUES
+('reactivateUser', 'USER', STRINGDECODE('<route id=\"reactivateUser\">\n <from uri=\"direct:reactivateUser\"/>\n <doTry>\n <bean method=\"reactivate(${body})\" ref=\"uwfAdapter\"/>\n <to uri=\"direct:userStatusPropagation\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:statusPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('suspendUser', 'USER', STRINGDECODE('<route id=\"suspendUser\">\n <from uri=\"direct:suspendUser\"/>\n <doTry>\n <bean method=\"suspend(${body})\" ref=\"uwfAdapter\"/>\n <to uri=\"direct:userStatusPropagation\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:statusPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('userStatusPropagation', 'USER', STRINGDECODE('<route id=\"userStatusPropagation\">\n <from uri=\"direct:userStatusPropagation\"/> \n <to uri=\"propagate:status?anyTypeKind=USER\"/>\n <to uri=\"direct:statusPort\"/> \n </route>')),
+('provisionUser', 'USER', STRINGDECODE('<route id=\"provisionUser\">\n <from uri=\"direct:provisionUser\"/> \n <to uri=\"propagate:provision?anyTypeKind=USER\"/>\n <to uri=\"direct:provisionPort\"/> \n </route>')),
+('deprovisionUser', 'USER', STRINGDECODE('<route id=\"deprovisionUser\">\n <from uri=\"direct:deprovisionUser\"/> \n <to uri=\"propagate:deprovision?anyTypeKind=USER\"/>\n <to uri=\"direct:deprovisionPort\"/> \n </route>')),
+('internalSuspendUser', 'USER', STRINGDECODE('<route id=\"internalSuspendUser\">\n <from uri=\"direct:internalSuspendUser\"/>\n <doTry>\n <bean method=\"internalSuspend(${body})\" ref=\"uwfAdapter\"/>\n <to uri=\"propagate:suspend?anyTypeKind=USER\"/>\n <to uri=\"direct:internalSuspendUserPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:internalSuspendUserPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('requestPwdReset', 'USER', STRINGDECODE('<route id=\"requestPwdReset\">\n <from uri=\"direct:requestPwdReset\"/>\n <doTry>\n <bean method=\"requestPasswordReset(${body})\" ref=\"uwfAdapter\"/>\n <to uri=\"direct:requestPwdResetPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:requestPwdResetPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('confirmPwdReset', 'USER', STRINGDECODE('<route id=\"confirmPwdReset\">\n <from uri=\"direct:confirmPwdReset\"/>\n <doTry>\n <bean method=\"confirmPasswordReset(${property.key},${property.token},${property.password})\" ref=\"uwfAdapter\"/>\n <to uri=\"propagate:confirmPasswordReset?anyTypeKind=USER\"/>\n <to uri=\"direct:confirmPwdResetPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:confirmPwdResetPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('createGroup', 'GROUP', STRINGDECODE('<route id=\"createGroup\">\n <from uri=\"direct:createGroup\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"create(${body})\" ref=\"gwfAdapter\"/>\n <to uri=\"propagate:create?anyTypeKind=GROUP\"/>\n <to uri=\"direct:createGroupPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:createGroupPort\"/>\n </doCatch>\n </doTry>\n </route>'));
+INSERT INTO PUBLIC.CAMELROUTE(ID, ANYTYPEKIND, CONTENT) VALUES
+('createGroupPull', 'GROUP', STRINGDECODE('<route id=\"createGroupPull\">\n <from uri=\"direct:createGroupInPull\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"create(${body})\" ref=\"gwfAdapter\"/>\n <to uri=\"propagate:create?anyTypeKind=GROUP&pull=true\"/>\n <to uri=\"direct:createGroupInPullPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:createGroupInPullPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('updateGroup', 'GROUP', STRINGDECODE('<route id=\"updateGroup\">\n <from uri=\"direct:updateGroup\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"update(${body})\" ref=\"gwfAdapter\"/>\n <to uri=\"propagate:update?anyTypeKind=GROUP\"/>\n <to uri=\"direct:updateGroupPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:updateGroupPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('deleteGroup', 'GROUP', STRINGDECODE('<route id=\"deleteGroup\">\n <from uri=\"direct:deleteGroup\"/>\n <doTry>\n <to uri=\"propagate:delete?anyTypeKind=GROUP\"/>\n <bean method=\"delete(${body})\" ref=\"gwfAdapter\"/>\n <setBody>\n <simple>${property.statuses}</simple>\n </setBody>\n <to uri=\"direct:deleteGroupPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:deleteGroupPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('unlinkGroup', 'GROUP', STRINGDECODE('<route id=\"unlinkGroup\">\n <from uri=\"direct:unlinkGroup\"/>\n <doTry>\n <bean method=\"update(${body})\" ref=\"gwfAdapter\"/>\n <setBody>\n <simple>${body.getResult}</simple>\n </setBody>\n <to uri=\"direct:unlinkGroupPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:unlinkGroupPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('linkGroup', 'GROUP', STRINGDECODE('<route id=\"linkGroup\">\n <from uri=\"direct:linkGroup\"/>\n <doTry>\n <bean method=\"update(${body})\" ref=\"gwfAdapter\"/>\n <setBody>\n <simple>${body.getResult}</simple>\n </setBody>\n <to uri=\"direct:linkGroupPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:linkGroupPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('provisionGroup', 'GROUP', STRINGDECODE('<route id=\"provisionGroup\">\n <from uri=\"direct:provisionGroup\"/> \n <to uri=\"propagate:provision?anyTypeKind=GROUP\"/>\n <to uri=\"direct:provisionGroupPort\"/> \n </route>')),
+('deprovisionGroup', 'GROUP', STRINGDECODE('<route id=\"deprovisionGroup\">\n <from uri=\"direct:deprovisionGroup\"/> \n <to uri=\"propagate:deprovision?anyTypeKind=GROUP\"/>\n <to uri=\"direct:deprovisionGroupPort\"/> \n </route>')),
+('createAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"createAnyObject\">\n <from uri=\"direct:createAnyObject\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"create(${body})\" ref=\"awfAdapter\"/>\n <to uri=\"propagate:create?anyTypeKind=ANY_OBJECT\"/>\n <to uri=\"direct:createAnyObjectPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:createAnyObjectPort\"/>\n </doCatch>\n </doTry>\n </route>'));
+INSERT INTO PUBLIC.CAMELROUTE(ID, ANYTYPEKIND, CONTENT) VALUES
+('updateAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"updateAnyObject\">\n <from uri=\"direct:updateAnyObject\"/>\n <setProperty propertyName=\"actual\">\n <simple>${body}</simple>\n </setProperty>\n <doTry>\n <bean method=\"update(${body})\" ref=\"awfAdapter\"/>\n <to uri=\"propagate:update?anyTypeKind=ANY_OBJECT\"/>\n <to uri=\"direct:updateAnyObjectPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:updateAnyObjectPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('deleteAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"deleteAnyObject\">\n <from uri=\"direct:deleteAnyObject\"/>\n <doTry>\n <to uri=\"propagate:delete?anyTypeKind=ANY_OBJECT\"/>\n <bean method=\"delete(${body})\" ref=\"awfAdapter\"/>\n <setBody>\n <simple>${property.statuses}</simple>\n </setBody>\n <to uri=\"direct:deleteAnyObjectPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:deleteAnyObjectPort\"/>\n </doCatch>\n </doTry>\n </route>')),
+('unlinkAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"unlinkAnyObject\">\n <from uri=\"direct:unlinkAnyObject\"/>\n <doTry>\n <bean method=\"update(${body})\" ref=\"awfAdapter\"/>\n <setBody>\n <simple>${body.getResult}</simple>\n </setBody>\n <to uri=\"direct:unlinkAnyObjectPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:unlinkAnyObjectPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('linkAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"linkAnyObject\">\n <from uri=\"direct:linkAnyObject\"/>\n <doTry>\n <bean method=\"update(${body})\" ref=\"awfAdapter\"/>\n <setBody>\n <simple>${body.getResult}</simple>\n </setBody>\n <to uri=\"direct:linkAnyObjectPort\"/>\n <doCatch> \n <exception>java.lang.RuntimeException</exception>\n <handled>\n <constant>false</constant>\n </handled>\n <to uri=\"direct:linkAnyObjectPort\"/>\n </doCatch>\n </doTry> \n </route>')),
+('provisionAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"provisionAnyObject\">\n <from uri=\"direct:provisionAnyObject\"/> \n <to uri=\"propagate:provision?anyTypeKind=ANY_OBJECT\"/>\n <to uri=\"direct:provisionAnyObjectPort\"/> \n </route>')),
+('deprovisionAnyObject', 'ANY_OBJECT', STRINGDECODE('<route id=\"deprovisionAnyObject\">\n <from uri=\"direct:deprovisionAnyObject\"/> \n <to uri=\"propagate:deprovision?anyTypeKind=ANY_OBJECT\"/>\n <to uri=\"direct:deprovisionAnyObjectPort\"/> \n </route>'));
+CREATE MEMORY TABLE PUBLIC.CONNINSTANCE(
+ ID VARCHAR(36) NOT NULL,
+ BUNDLENAME VARCHAR(255),
+ CONNREQUESTTIMEOUT INTEGER,
+ CONNECTORNAME VARCHAR(255),
+ DISPLAYNAME VARCHAR(255),
+ JSONCONF CLOB,
+ LOCATION VARCHAR(255),
+ VERSION VARCHAR(255),
+ ADMINREALM_ID VARCHAR(36),
+ MAXIDLE INTEGER,
+ MAXOBJECTS INTEGER,
+ MAXWAIT BIGINT,
+ MINEVICTABLEIDLETIMEMILLIS BIGINT,
+ MINIDLE INTEGER
+);
+ALTER TABLE PUBLIC.CONNINSTANCE ADD CONSTRAINT PUBLIC.CONSTRAINT_E PRIMARY KEY(ID);
+-- 10 +/- SELECT COUNT(*) FROM PUBLIC.CONNINSTANCE;
+INSERT INTO PUBLIC.CONNINSTANCE(ID, BUNDLENAME, CONNREQUESTTIMEOUT, CONNECTORNAME, DISPLAYNAME, JSONCONF, LOCATION, VERSION, ADMINREALM_ID, MAXIDLE, MAXOBJECTS, MAXWAIT, MINEVICTABLEIDLETIMEMILLIS, MINIDLE) VALUES
+('88a7a819-dab5-46b4-9b90-0b9769eabdb8', 'net.tirasa.connid.bundles.soap', NULL, 'net.tirasa.connid.bundles.soap.WebServiceConnector', 'ConnInstance100', '[{"schema":{"name":"endpoint","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["http://localhost:9080/syncope-fit-build-tools/cxf/soap/provisioning"]},{"schema":{"name":"servicename","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["net.tirasa.connid.bundles.soap.provisioning.interfaces.Provisioning"]}]', 'file:/home/ilgrosso/work/syncope/syncope2/fit/core-reference/target/bundles/', '1.4.1', 'e4c28e7a-9dbf-4ee7-9441-93812a0d4a28', NULL, NULL, NULL, NULL, NULL),
+('5aa5b8be-7521-481a-9651-c557aea078c1', 'net.tirasa.connid.bundles.db.table', NULL, 'net.tirasa.connid.bundles.db.table.DatabaseTableConnector', 'H2', '[{"schema":{"name":"disabledStatusValue","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["false"]},{"schema":{"name":"user","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["sa"]},{"schema":{"name":"keyColumn","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["id"]},{"schema":{"name":"retrievePassword","displayName":null,"helpMessage":null,"type":"boolean","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["true"]},{"schema":{"name":"cipherAlgorit
hm","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["SHA1"]},{"schema":{"name":"enabledStatusValue","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["true"]},{"schema":{"name":"passwordColumn","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["password"]},{"schema":{"name":"jdbcDriver","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["org.h2.Driver"]},{"schema":{"name":"defaultStatusValue","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridabl
e":false,"values":["true"]},{"schema":{"name":"table","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["test"]},{"schema":{"name":"password","displayName":null,"helpMessage":null,"type":"org.identityconnectors.common.security.GuardedString","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["sa"]},{"schema":{"name":"statusColumn","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["status"]},{"schema":{"name":"jdbcUrlTemplate","displayName":null,"helpMessage":null,"type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["jdbc:h2:tcp://localhost:9092/mem:testdb;DB_CLOSE_DELAY=-1"]}]', 'connid://testconnectorserver@localhost:4554', '2.2.5', 'e4c28
e7a-9dbf-4ee7-9441-93812a0d4a28', NULL, NULL, NULL, NULL, NULL);
+INSERT INTO PUBLIC.CONNINSTANCE(ID, BUNDLENAME, CONNREQUESTTIMEOUT, CONNECTORNAME, DISPLAYNAME, JSONCONF, LOCATION, VERSION, ADMINREALM_ID, MAXIDLE, MAXOBJECTS, MAXWAIT, MINEVICTABLEIDLETIMEMILLIS, MINIDLE) VALUES
+('5ffbb4ac-a8c3-4b44-b699-11b398a1ba08', 'net.tirasa.connid.bundles.soap', 10, 'net.tirasa.connid.bundles.soap.WebServiceConnector', 'ConnInstance102', '[{"schema":{"name":"servicename","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["net.tirasa.connid.bundles.soap.provisioning.interfaces.Provisioning"]},{"schema":{"name":"endpoint","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":true,"values":["http://localhost:9080/syncope-fit-build-tools/cxf/soap/provisioning"]}]', 'file:/home/ilgrosso/work/syncope/syncope2/fit/core-reference/target/bundles/', '1.4.1', 'e4c28e7a-9dbf-4ee7-9441-93812a0d4a28', NULL, NULL, NULL, NULL, NULL),
+('fcf9f2b0-f7d6-42c9-84a6-61b28255a42b', 'net.tirasa.connid.bundles.soap', NULL, 'net.tirasa.connid.bundles.soap.WebServiceConnector', 'ConnInstance103', '[{"schema":{"name":"endpoint","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["http://localhost:9080/syncope-fit-build-tools/cxf/soap/provisioning"]},{"schema":{"name":"servicename","displayName":null,"helpMessage":null,"type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["net.tirasa.connid.bundles.soap.provisioning.interfaces.Provisioning"]}]', 'file:/home/ilgrosso/work/syncope/syncope2/fit/core-reference/target/bundles/', '1.4.1', 'e4c28e7a-9dbf-4ee7-9441-93812a0d4a28', NULL, NULL, NULL, NULL, NULL),
+('6c2acf1b-b052-46f0-8c56-7a8ad6905edf', 'net.tirasa.connid.bundles.csvdir', NULL, 'net.tirasa.connid.bundles.csvdir.CSVDirConnector', 'CSVDir', '[{"schema":{"name":"fields","displayName":"fields","helpMessage":"Column names separated by comma","type":"[Ljava.lang.String;","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["id","name","surname","email","password","theirgroup","membership","status","deleted"]},{"schema":{"name":"keyColumnNames","displayName":"Key column name","helpMessage":"Name of the column used to identify user uniquely","type":"[Ljava.lang.String;","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["name","surname"]},{"schema":{"name":"deleteColumnName","displayName":"Delete column name","helpMessage":"Name of the column used to specify users to be deleted","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":fal
se,"values":["deleted"]},{"schema":{"name":"passwordColumnName","displayName":"Password column name","helpMessage":"Name of the column used to specify user password","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["password"]},{"schema":{"name":"keyseparator","displayName":"Key separator","helpMessage":"Character used to separate keys in a multi-key scenario","type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[","]},{"schema":{"name":"ignoreHeader","displayName":"Ignore header","helpMessage":"Specify it first line file must be ignored","type":"java.lang.Boolean","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[false]},{"schema":{"name":"fieldDelimiter","displayName":"fieldDelimiter","helpMessage":"fieldDelimiter","type":"char","required":true,"order":0,"confidential":false,"defaultValu
es":null},"overridable":false,"values":[","]},{"schema":{"name":"quotationRequired","displayName":"Value quotation required","helpMessage":"Specify if value quotation is required","type":"java.lang.Boolean","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[false]},{"schema":{"name":"statusColumn","displayName":"statusColumn","helpMessage":"Status column","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["status"]},{"schema":{"name":"sourcePath","displayName":"Source path","helpMessage":"Absolute path of a directory where are located CSV files to be processed","type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["/home/ilgrosso/work/syncope/syncope2/fit/core-reference/target/test-csvdir"]},{"schema":{"name":"fileMask","displayName":"File mask","helpMessage":"Regular expression describing fi
les to be processed","type":"java.lang.String","required":true,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["test.csv"]}]', 'file:/home/ilgrosso/work/syncope/syncope2/fit/core-reference/target/bundles/', '0.8.7', 'e4c28e7a-9dbf-4ee7-9441-93812a0d4a28', NULL, NULL, NULL, NULL, NULL);
+CREATE TABLE IF NOT EXISTS SYSTEM_LOB_STREAM(ID INT NOT NULL, PART INT NOT NULL, CDATA VARCHAR, BDATA BINARY);
+CREATE PRIMARY KEY SYSTEM_LOB_STREAM_PRIMARY_KEY ON SYSTEM_LOB_STREAM(ID, PART);
+CREATE ALIAS IF NOT EXISTS SYSTEM_COMBINE_CLOB FOR "org.h2.command.dml.ScriptCommand.combineClob";
+CREATE ALIAS IF NOT EXISTS SYSTEM_COMBINE_BLOB FOR "org.h2.command.dml.ScriptCommand.combineBlob";
+INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 0, '[{"schema":{"name":"synchronizePasswords","displayName":"Enable Password Synchronization","helpMessage":"If true, the connector will synchronize passwords. The Password Capture Plugin needs to be installed for password synchronization to work.","type":"boolean","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["false"]},{"schema":{"name":"maintainLdapGroupMembership","displayName":"Maintain LDAP Group Membership","helpMessage":"When enabled and a user is renamed or deleted, update any LDAP groups to which the user belongs to reflect the new name. Otherwise, the LDAP resource must maintain referential integrity with respect to group membership.","type":"boolean","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["true"]},{"schema":{"name":"host","displayName":"Host","helpMessage":"The name or IP address of the host where the LDAP server is run
ning.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["localhost"]},{"schema":{"name":"passwordHashAlgorithm","displayName":"Password Hash Algorithm","helpMessage":"Indicates the algorithm that the Identity system should use to hash the password. Currently supported values are SSHA, SHA, SSHA1, and SHA1. A blank value indicates that the system will not hash passwords. This will cause cleartext passwords to be stored in LDAP unless the LDAP server performs the hash (Netscape Directory Server and iPlanet Directory Server do).","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["SHA"]},{"schema":{"name":"port","displayName":"TCP Port","helpMessage":"TCP/IP port number used to communicate with the LDAP server.","type":"int","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[1389]},{"sche
ma":{"name":"vlvSortAttribute","displayName":"VLV Sort Attribute","helpMessage":"Specify the sort attribute to use for VLV indexes on the resource.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"statusManagementClass","displayName":"Status management class ","helpMessage":"Class to be used to manage enabled/disabled status. If no class is specified then identity status management wont be possible.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["net.tirasa.connid.bundles.ldap.commons.AttributeStatusManagement"]},{"schema":{"name":"accountObjectClasses","displayName":"Account Object Classes","helpMessage":"The object class or classes that will be used when creating new user objects in the LDAP tree. When entering more than one object class, each entry should be on its own line; do not use commas or semi-co
lons to separate multiple object classes. Some object classes may require that you specify all object classes in the class hierarchy.","type":"[Ljava.lang.String;","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["inetOrgPerson"]},{"schema":{"name":"accountUserNameAttributes","displayName":"Account User Name Attributes","helpMessage":"Attribute or attributes which holds the account user name. They will be used when authenticating to find the LDAP entry for the user name to authenticate.","type":"[Ljava.lang.String;","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["uid"]},{"schema":{"name":"baseContextsToSynchronize","displayName":"Base Contexts to Synchronize","helpMessage":"One or more starting points in the LDAP tree that will be used to determine if a change should be synchronized. The base contexts attribute will be used to synchronize a change if this property is not set.","ty
pe":"[Ljava.lang.String;","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["ou=people,o=isp","ou=grou', NULL);
+INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 1, 'ps,o=isp"]},{"schema":{"name":"accountSynchronizationFilter","displayName":"LDAP Filter for Accounts to Synchronize","helpMessage":"An optional LDAP filter for the objects to synchronize. Because the change log is for all objects, this filter updates only objects that match the specified filter. If you specify a filter, an object will be synchronized only if it matches the filter and includes a synchronized object class.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"removeLogEntryObjectClassFromFilter","displayName":"Remove Log Entry Object Class from Filter","helpMessage":"If this property is set (the default), the filter used to fetch change log entries does not contain the \"changeLogEntry\" object class, expecting that there are no entries of other object types in the change log.","type":"boolean","required":false,"order":0,"confident
ial":false,"defaultValues":null},"overridable":false,"values":["false"]},{"schema":{"name":"passwordDecryptionKey","displayName":"Password Decryption Key","helpMessage":"The key to decrypt passwords with when performing password synchronization.","type":"org.identityconnectors.common.security.GuardedByteArray","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"readSchema","displayName":"Read Schema","helpMessage":"If true, the connector will read the schema from the server. If false, the connector will provide a default schema based on the object classes in the configuration. This property must be true in order to use extended object classes.","type":"boolean","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["true"]},{"schema":{"name":"ssl","displayName":"SSL","helpMessage":"Select the check box to connect to the LDAP server using SSL.","type":"boolean","required
":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["false"]},{"schema":{"name":"passwordAttributeToSynchronize","displayName":"Password Attribute to Synchronize","helpMessage":"The name of the password attribute to synchronize when performing password synchronization.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"accountSearchFilter","displayName":"LDAP Filter for Retrieving Accounts","helpMessage":"An optional LDAP filter to control which accounts are returned from the LDAP resource. If no filter is specified, only accounts that include all specified object classes are returned.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["uid=*"]},{"schema":{"name":"passwordDecryptionInitializationVector","displayName":"Password Decryption Initialization Vector","helpMessage"
:"The initialization vector to decrypt passwords with when performing password synchronization.","type":"org.identityconnectors.common.security.GuardedByteArray","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"groupMemberAttribute","displayName":"Group Member Attribute","helpMessage":"The name of the group attribute that will be updated with the distinguished name of the user when the user is added to the group.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"failover","displayName":"Failover Servers","helpMessage":"List all servers that should be used for failover in case the preferred server fails. If the preferred server fails, JNDI will connect to the next available server in the list. List all servers in the form of \"ldap://ldap.example.com:389/\", which follows the standard LDAP v3 URLs described in RFC
2255. Only the host and port parts of the URL are relevant in this setting.","type":"[Ljava.lang.String;","required":false,"order":0,"confidential":fals', NULL);
+INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 2, 'e,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"modifiersNamesToFilterOut","displayName":"Filter Out Changes By","helpMessage":"The names (DNs) of directory administrators to filter from the changes. Changes with the attribute \"modifiersName\" that match entries in this list will be filtered out. The standard value is the administrator name used by this adapter, to prevent loops. Entries should be of the format \"cn=Directory Manager\".","type":"[Ljava.lang.String;","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":[]},{"schema":{"name":"groupNameAttributes","displayName":"Group Name Attributes","helpMessage":"Attribute or attributes which holds the group name.","type":"[Ljava.lang.String;","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["cn"]},{"schema":{"name":"uidAttribute","displayName":"Uid Attribute","help
Message":"The name of the LDAP attribute which is mapped to the Uid attribute.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":true,"values":["cn"]},{"schema":{"name":"gidAttribute","displayName":"Uid Attribute for groups","helpMessage":"The name of the LDAP attribute which is mapped to the Uid attribute for groups.","type":"java.lang.String","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":true,"values":["cn"]},{"schema":{"name":"respectResourcePasswordPolicyChangeAfterReset","displayName":"Respect Resource Password Policy Change-After-Reset","helpMessage":"When this resource is specified in a Login Module (i.e., this resource is a pass-through authentication target) and the resource password policy is configured for change-after-reset, a user whose resource account password has been administratively reset will be required to change that password after successfully authenticating.","ty
pe":"boolean","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["false"]},{"schema":{"name":"filterWithOrInsteadOfAnd","displayName":"Filter with Or Instead of And","helpMessage":"Normally the the filter used to fetch change log entries is an and-based filter retrieving an interval of change entries. If this property is set, the filter will or together the required change numbers instead.","type":"boolean","required":false,"order":0,"confidential":false,"defaultValues":null},"overridable":false,"values":["false"]},{"schema":{"name":"principal","displayName":"Principal","helpMessage":"The distinguished name with which to authenticate to the LDA
<TRUNCATED>