* INFO  2015-09-25 16:44:20,928 Using 4 organisation unit levels for org unit structure table (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 16:44:22,131 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 16:44:23,757 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 16:44:23,975 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 16:44:24,179 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 16:44:24,929 Create category option group set table SQL: CREATE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NULL, PRIMARY KEY ( categoryoptioncomboid ) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 16:44:25,319 Category option group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 16:50:58,590 Using 4 organisation unit levels for org unit structure table (DefaultResourceTableService.java [taskScheduler-2])
* INFO  2015-09-25 16:50:58,699 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2015-09-25 16:51:00,606 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  2015-09-25 16:51:00,731 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2015-09-25 16:51:00,809 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  2015-09-25 16:51:00,809 Create category option group set table SQL: CREATE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NULL, PRIMARY KEY ( categoryoptioncomboid ) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2015-09-25 16:51:00,887 Category option group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  2015-09-25 17:30:46,296 Using 4 organisation unit levels for org unit structure table (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:30:46,515 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 17:30:47,609 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:30:47,828 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 17:30:47,921 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:30:48,000 Create category option group set table SQL: CREATE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NULL, PRIMARY KEY ( categoryoptioncomboid ) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 17:30:48,046 Category option group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,328 Using 4 organisation unit levels for org unit structure table (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,343 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,703 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,734 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,765 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,781 Create category option group set table SQL: CREATE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NULL, PRIMARY KEY ( categoryoptioncomboid ) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2015-09-25 17:34:17,812 Category option group set table generated (DefaultResourceTableService.java [taskScheduler-1])