-- MySQL dump 10.13 Distrib 5.6.28, for osx10.8 (x86_64) -- -- Host: localhost Database: jwdb -- ------------------------------------------------------ -- Server version 5.6.28 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `SHKActivities` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKActivities` ( `Id` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ActivitySetDefinitionId` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `Process` decimal(19,0) NOT NULL, `TheResource` decimal(19,0) DEFAULT NULL, `PDefName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ProcessId` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ResourceId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `State` decimal(19,0) NOT NULL, `BlockActivityId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Performer` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `IsPerformerAsynchronous` smallint(6) DEFAULT NULL, `Priority` int(11) DEFAULT NULL, `Name` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `Activated` bigint(20) NOT NULL, `ActivatedTZO` bigint(20) NOT NULL, `Accepted` bigint(20) DEFAULT NULL, `AcceptedTZO` bigint(20) DEFAULT NULL, `LastStateTime` bigint(20) NOT NULL, `LastStateTimeTZO` bigint(20) NOT NULL, `LimitTime` bigint(20) NOT NULL, `LimitTimeTZO` bigint(20) NOT NULL, `Description` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKActivities` (`Id`), KEY `SHKActivities_TheResource` (`TheResource`), KEY `SHKActivities_State` (`State`), KEY `I2_SHKActivities` (`Process`,`ActivitySetDefinitionId`,`ActivityDefinitionId`), KEY `I3_SHKActivities` (`Process`,`State`), CONSTRAINT `SHKActivities_Process` FOREIGN KEY (`Process`) REFERENCES `SHKProcesses` (`oid`), CONSTRAINT `SHKActivities_State` FOREIGN KEY (`State`) REFERENCES `SHKActivityStates` (`oid`), CONSTRAINT `SHKActivities_TheResource` FOREIGN KEY (`TheResource`) REFERENCES `SHKResourcesTable` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKActivities` -- /*!40000 ALTER TABLE `SHKActivities` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKActivities` ENABLE KEYS */; -- -- Table structure for table `SHKActivityData` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKActivityData` ( `Activity` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValue` mediumblob, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` double DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `IsResult` smallint(6) NOT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKActivityData` (`CNT`), UNIQUE KEY `I2_SHKActivityData` (`Activity`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKActivityData_Activity` FOREIGN KEY (`Activity`) REFERENCES `SHKActivities` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKActivityData` -- /*!40000 ALTER TABLE `SHKActivityData` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKActivityData` ENABLE KEYS */; -- -- Table structure for table `SHKActivityDataBLOBs` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKActivityDataBLOBs` ( `ActivityDataWOB` decimal(19,0) NOT NULL, `VariableValue` mediumblob, `OrdNo` int(11) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKActivityDataBLOBs` (`ActivityDataWOB`,`OrdNo`), CONSTRAINT `SHKActivityDataBLOBs_ActivityDataWOB` FOREIGN KEY (`ActivityDataWOB`) REFERENCES `SHKActivityDataWOB` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKActivityDataBLOBs` -- /*!40000 ALTER TABLE `SHKActivityDataBLOBs` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKActivityDataBLOBs` ENABLE KEYS */; -- -- Table structure for table `SHKActivityDataWOB` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKActivityDataWOB` ( `Activity` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` double DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `IsResult` smallint(6) NOT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKActivityDataWOB` (`CNT`), UNIQUE KEY `I2_SHKActivityDataWOB` (`Activity`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKActivityDataWOB_Activity` FOREIGN KEY (`Activity`) REFERENCES `SHKActivities` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKActivityDataWOB` -- /*!40000 ALTER TABLE `SHKActivityDataWOB` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKActivityDataWOB` ENABLE KEYS */; -- -- Table structure for table `SHKActivityStateEventAudits` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKActivityStateEventAudits` ( `KeyValue` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKActivityStateEventAudits` (`KeyValue`), UNIQUE KEY `I2_SHKActivityStateEventAudits` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKActivityStateEventAudits` -- /*!40000 ALTER TABLE `SHKActivityStateEventAudits` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKActivityStateEventAudits` ENABLE KEYS */; -- -- Table structure for table `SHKActivityStates` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKActivityStates` ( `KeyValue` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKActivityStates` (`KeyValue`), UNIQUE KEY `I2_SHKActivityStates` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKActivityStates` -- /*!40000 ALTER TABLE `SHKActivityStates` DISABLE KEYS */; INSERT INTO `SHKActivityStates` VALUES ('open.running','open.running',1000001,0),('open.not_running.not_started','open.not_running.not_started',1000003,0),('open.not_running.suspended','open.not_running.suspended',1000005,0),('closed.completed','closed.completed',1000007,0),('closed.terminated','closed.terminated',1000009,0),('closed.aborted','closed.aborted',1000011,0); /*!40000 ALTER TABLE `SHKActivityStates` ENABLE KEYS */; -- -- Table structure for table `SHKAndJoinTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKAndJoinTable` ( `Process` decimal(19,0) NOT NULL, `BlockActivity` decimal(19,0) DEFAULT NULL, `ActivityDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `Activity` decimal(19,0) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKAndJoinTable` (`CNT`), KEY `SHKAndJoinTable_BlockActivity` (`BlockActivity`), KEY `I2_SHKAndJoinTable` (`Process`,`BlockActivity`,`ActivityDefinitionId`), KEY `I3_SHKAndJoinTable` (`Activity`), CONSTRAINT `SHKAndJoinTable_Activity` FOREIGN KEY (`Activity`) REFERENCES `SHKActivities` (`oid`), CONSTRAINT `SHKAndJoinTable_BlockActivity` FOREIGN KEY (`BlockActivity`) REFERENCES `SHKActivities` (`oid`), CONSTRAINT `SHKAndJoinTable_Process` FOREIGN KEY (`Process`) REFERENCES `SHKProcesses` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKAndJoinTable` -- /*!40000 ALTER TABLE `SHKAndJoinTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKAndJoinTable` ENABLE KEYS */; -- -- Table structure for table `SHKAssignmentEventAudits` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKAssignmentEventAudits` ( `RecordedTime` bigint(20) NOT NULL, `RecordedTimeTZO` bigint(20) NOT NULL, `TheUsername` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `TheType` decimal(19,0) NOT NULL, `ActivityId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ActivityName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ProcessName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessFactoryName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ProcessFactoryVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `ActivityDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ActivityDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityDefinitionType` int(11) NOT NULL, `ProcessDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PackageId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `OldResourceUsername` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `OldResourceName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `NewResourceUsername` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `NewResourceName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `IsAccepted` smallint(6) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKAssignmentEventAudits` (`CNT`), KEY `SHKAssignmentEventAudits_TheType` (`TheType`), CONSTRAINT `SHKAssignmentEventAudits_TheType` FOREIGN KEY (`TheType`) REFERENCES `SHKEventTypes` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKAssignmentEventAudits` -- /*!40000 ALTER TABLE `SHKAssignmentEventAudits` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKAssignmentEventAudits` ENABLE KEYS */; -- -- Table structure for table `SHKAssignmentsTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKAssignmentsTable` ( `Activity` decimal(19,0) NOT NULL, `TheResource` decimal(19,0) NOT NULL, `ActivityId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ActivityProcessId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ActivityProcessDefName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ResourceId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `IsAccepted` smallint(6) NOT NULL, `IsValid` smallint(6) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKAssignmentsTable` (`CNT`), UNIQUE KEY `I2_SHKAssignmentsTable` (`Activity`,`TheResource`), KEY `I3_SHKAssignmentsTable` (`TheResource`,`IsValid`), KEY `I4_SHKAssignmentsTable` (`ActivityId`), KEY `I5_SHKAssignmentsTable` (`ResourceId`), KEY `FK_rnb6mhntls567xpifcfvygkuu` (`ActivityProcessId`), CONSTRAINT `FK_183e6adufsi558hl5p4dqkqsx` FOREIGN KEY (`ActivityId`) REFERENCES `SHKActivities` (`Id`), CONSTRAINT `FK_rnb6mhntls567xpifcfvygkuu` FOREIGN KEY (`ActivityProcessId`) REFERENCES `SHKProcesses` (`Id`), CONSTRAINT `SHKAssignmentsTable_Activity` FOREIGN KEY (`Activity`) REFERENCES `SHKActivities` (`oid`), CONSTRAINT `SHKAssignmentsTable_TheResource` FOREIGN KEY (`TheResource`) REFERENCES `SHKResourcesTable` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKAssignmentsTable` -- /*!40000 ALTER TABLE `SHKAssignmentsTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKAssignmentsTable` ENABLE KEYS */; -- -- Table structure for table `SHKCounters` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKCounters` ( `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `the_number` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKCounters` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKCounters` -- /*!40000 ALTER TABLE `SHKCounters` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKCounters` ENABLE KEYS */; -- -- Table structure for table `SHKCreateProcessEventAudits` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKCreateProcessEventAudits` ( `RecordedTime` bigint(20) NOT NULL, `RecordedTimeTZO` bigint(20) NOT NULL, `TheUsername` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `TheType` decimal(19,0) NOT NULL, `ProcessId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ProcessName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessFactoryName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ProcessFactoryVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PackageId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PActivityId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `PProcessId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `PProcessName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `PProcessFactoryName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `PProcessFactoryVersion` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `PActivityDefinitionId` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PActivityDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PProcessDefinitionId` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PProcessDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PPackageId` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKCreateProcessEventAudits` (`CNT`), KEY `SHKCreateProcessEventAudits_TheType` (`TheType`), CONSTRAINT `SHKCreateProcessEventAudits_TheType` FOREIGN KEY (`TheType`) REFERENCES `SHKEventTypes` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKCreateProcessEventAudits` -- /*!40000 ALTER TABLE `SHKCreateProcessEventAudits` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKCreateProcessEventAudits` ENABLE KEYS */; -- -- Table structure for table `SHKDataEventAudits` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKDataEventAudits` ( `RecordedTime` bigint(20) NOT NULL, `RecordedTimeTZO` bigint(20) NOT NULL, `TheUsername` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `TheType` decimal(19,0) NOT NULL, `ActivityId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ProcessName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessFactoryName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ProcessFactoryVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `ActivityDefinitionId` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityDefinitionType` int(11) DEFAULT NULL, `ProcessDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PackageId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKDataEventAudits` (`CNT`), KEY `SHKDataEventAudits_TheType` (`TheType`), CONSTRAINT `SHKDataEventAudits_TheType` FOREIGN KEY (`TheType`) REFERENCES `SHKEventTypes` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKDataEventAudits` -- /*!40000 ALTER TABLE `SHKDataEventAudits` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKDataEventAudits` ENABLE KEYS */; -- -- Table structure for table `SHKDeadlines` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKDeadlines` ( `Process` decimal(19,0) NOT NULL, `Activity` decimal(19,0) NOT NULL, `CNT` decimal(19,0) NOT NULL, `TimeLimit` bigint(20) NOT NULL, `TimeLimitTZO` bigint(20) NOT NULL, `ExceptionName` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `IsSynchronous` smallint(6) NOT NULL, `IsExecuted` smallint(6) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKDeadlines` (`CNT`), KEY `I2_SHKDeadlines` (`Process`,`TimeLimit`), KEY `I3_SHKDeadlines` (`Activity`,`TimeLimit`), CONSTRAINT `SHKDeadlines_Activity` FOREIGN KEY (`Activity`) REFERENCES `SHKActivities` (`oid`), CONSTRAINT `SHKDeadlines_Process` FOREIGN KEY (`Process`) REFERENCES `SHKProcesses` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKDeadlines` -- /*!40000 ALTER TABLE `SHKDeadlines` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKDeadlines` ENABLE KEYS */; -- -- Table structure for table `SHKEventTypes` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKEventTypes` ( `KeyValue` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKEventTypes` (`KeyValue`), UNIQUE KEY `I2_SHKEventTypes` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKEventTypes` -- /*!40000 ALTER TABLE `SHKEventTypes` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKEventTypes` ENABLE KEYS */; -- -- Table structure for table `SHKGroupGroupTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKGroupGroupTable` ( `sub_gid` decimal(19,0) NOT NULL, `groupid` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKGroupGroupTable` (`sub_gid`,`groupid`), KEY `I2_SHKGroupGroupTable` (`groupid`), CONSTRAINT `SHKGroupGroupTable_groupid` FOREIGN KEY (`groupid`) REFERENCES `SHKGroupTable` (`oid`), CONSTRAINT `SHKGroupGroupTable_sub_gid` FOREIGN KEY (`sub_gid`) REFERENCES `SHKGroupTable` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKGroupGroupTable` -- /*!40000 ALTER TABLE `SHKGroupGroupTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKGroupGroupTable` ENABLE KEYS */; -- -- Table structure for table `SHKGroupTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKGroupTable` ( `groupid` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKGroupTable` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKGroupTable` -- /*!40000 ALTER TABLE `SHKGroupTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKGroupTable` ENABLE KEYS */; -- -- Table structure for table `SHKGroupUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKGroupUser` ( `USERNAME` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKGroupUser` (`USERNAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKGroupUser` -- /*!40000 ALTER TABLE `SHKGroupUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKGroupUser` ENABLE KEYS */; -- -- Table structure for table `SHKGroupUserPackLevelPart` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKGroupUserPackLevelPart` ( `PARTICIPANTOID` decimal(19,0) NOT NULL, `USEROID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKGroupUserPackLevelPart` (`PARTICIPANTOID`,`USEROID`), KEY `SHKGroupUserPackLevelPart_USEROID` (`USEROID`), CONSTRAINT `SHKGroupUserPackLevelPart_PARTICIPANTOID` FOREIGN KEY (`PARTICIPANTOID`) REFERENCES `SHKPackLevelParticipant` (`oid`), CONSTRAINT `SHKGroupUserPackLevelPart_USEROID` FOREIGN KEY (`USEROID`) REFERENCES `SHKGroupUser` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKGroupUserPackLevelPart` -- /*!40000 ALTER TABLE `SHKGroupUserPackLevelPart` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKGroupUserPackLevelPart` ENABLE KEYS */; -- -- Table structure for table `SHKGroupUserProcLevelPart` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKGroupUserProcLevelPart` ( `PARTICIPANTOID` decimal(19,0) NOT NULL, `USEROID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKGroupUserProcLevelPart` (`PARTICIPANTOID`,`USEROID`), KEY `SHKGroupUserProcLevelPart_USEROID` (`USEROID`), CONSTRAINT `SHKGroupUserProcLevelPart_PARTICIPANTOID` FOREIGN KEY (`PARTICIPANTOID`) REFERENCES `SHKProcLevelParticipant` (`oid`), CONSTRAINT `SHKGroupUserProcLevelPart_USEROID` FOREIGN KEY (`USEROID`) REFERENCES `SHKGroupUser` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKGroupUserProcLevelPart` -- /*!40000 ALTER TABLE `SHKGroupUserProcLevelPart` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKGroupUserProcLevelPart` ENABLE KEYS */; -- -- Table structure for table `SHKNewEventAuditData` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKNewEventAuditData` ( `DataEventAudit` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValue` mediumblob, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` float DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKNewEventAuditData` (`CNT`), UNIQUE KEY `I2_SHKNewEventAuditData` (`DataEventAudit`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKNewEventAuditData_DataEventAudit` FOREIGN KEY (`DataEventAudit`) REFERENCES `SHKDataEventAudits` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKNewEventAuditData` -- /*!40000 ALTER TABLE `SHKNewEventAuditData` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKNewEventAuditData` ENABLE KEYS */; -- -- Table structure for table `SHKNewEventAuditDataBLOBs` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKNewEventAuditDataBLOBs` ( `NewEventAuditDataWOB` decimal(19,0) NOT NULL, `VariableValue` mediumblob, `OrdNo` int(11) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKNewEventAuditDataBLOBs` (`NewEventAuditDataWOB`,`OrdNo`), CONSTRAINT `SHKNewEventAuditDataBLOBs_NewEventAuditDataWOB` FOREIGN KEY (`NewEventAuditDataWOB`) REFERENCES `SHKNewEventAuditDataWOB` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKNewEventAuditDataBLOBs` -- /*!40000 ALTER TABLE `SHKNewEventAuditDataBLOBs` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKNewEventAuditDataBLOBs` ENABLE KEYS */; -- -- Table structure for table `SHKNewEventAuditDataWOB` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKNewEventAuditDataWOB` ( `DataEventAudit` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` float DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKNewEventAuditDataWOB` (`CNT`), UNIQUE KEY `I2_SHKNewEventAuditDataWOB` (`DataEventAudit`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKNewEventAuditDataWOB_DataEventAudit` FOREIGN KEY (`DataEventAudit`) REFERENCES `SHKDataEventAudits` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKNewEventAuditDataWOB` -- /*!40000 ALTER TABLE `SHKNewEventAuditDataWOB` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKNewEventAuditDataWOB` ENABLE KEYS */; -- -- Table structure for table `SHKNextXPDLVersions` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKNextXPDLVersions` ( `XPDLId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `NextVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKNextXPDLVersions` (`XPDLId`,`NextVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKNextXPDLVersions` -- /*!40000 ALTER TABLE `SHKNextXPDLVersions` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKNextXPDLVersions` ENABLE KEYS */; -- -- Table structure for table `SHKNormalUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKNormalUser` ( `USERNAME` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKNormalUser` (`USERNAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKNormalUser` -- /*!40000 ALTER TABLE `SHKNormalUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKNormalUser` ENABLE KEYS */; -- -- Table structure for table `SHKOldEventAuditData` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKOldEventAuditData` ( `DataEventAudit` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValue` mediumblob, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` float DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKOldEventAuditData` (`CNT`), UNIQUE KEY `I2_SHKOldEventAuditData` (`DataEventAudit`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKOldEventAuditData_DataEventAudit` FOREIGN KEY (`DataEventAudit`) REFERENCES `SHKDataEventAudits` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKOldEventAuditData` -- /*!40000 ALTER TABLE `SHKOldEventAuditData` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKOldEventAuditData` ENABLE KEYS */; -- -- Table structure for table `SHKOldEventAuditDataBLOBs` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKOldEventAuditDataBLOBs` ( `OldEventAuditDataWOB` decimal(19,0) NOT NULL, `VariableValue` mediumblob, `OrdNo` int(11) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKOldEventAuditDataBLOBs` (`OldEventAuditDataWOB`,`OrdNo`), CONSTRAINT `SHKOldEventAuditDataBLOBs_OldEventAuditDataWOB` FOREIGN KEY (`OldEventAuditDataWOB`) REFERENCES `SHKOldEventAuditDataWOB` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKOldEventAuditDataBLOBs` -- /*!40000 ALTER TABLE `SHKOldEventAuditDataBLOBs` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKOldEventAuditDataBLOBs` ENABLE KEYS */; -- -- Table structure for table `SHKOldEventAuditDataWOB` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKOldEventAuditDataWOB` ( `DataEventAudit` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` float DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKOldEventAuditDataWOB` (`CNT`), UNIQUE KEY `I2_SHKOldEventAuditDataWOB` (`DataEventAudit`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKOldEventAuditDataWOB_DataEventAudit` FOREIGN KEY (`DataEventAudit`) REFERENCES `SHKDataEventAudits` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKOldEventAuditDataWOB` -- /*!40000 ALTER TABLE `SHKOldEventAuditDataWOB` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKOldEventAuditDataWOB` ENABLE KEYS */; -- -- Table structure for table `SHKPackLevelParticipant` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKPackLevelParticipant` ( `PARTICIPANT_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PACKAGEOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKPackLevelParticipant` (`PARTICIPANT_ID`,`PACKAGEOID`), KEY `SHKPackLevelParticipant_PACKAGEOID` (`PACKAGEOID`), CONSTRAINT `SHKPackLevelParticipant_PACKAGEOID` FOREIGN KEY (`PACKAGEOID`) REFERENCES `SHKXPDLParticipantPackage` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKPackLevelParticipant` -- /*!40000 ALTER TABLE `SHKPackLevelParticipant` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKPackLevelParticipant` ENABLE KEYS */; -- -- Table structure for table `SHKPackLevelXPDLApp` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKPackLevelXPDLApp` ( `APPLICATION_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PACKAGEOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKPackLevelXPDLApp` (`APPLICATION_ID`,`PACKAGEOID`), KEY `SHKPackLevelXPDLApp_PACKAGEOID` (`PACKAGEOID`), CONSTRAINT `SHKPackLevelXPDLApp_PACKAGEOID` FOREIGN KEY (`PACKAGEOID`) REFERENCES `SHKXPDLApplicationPackage` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKPackLevelXPDLApp` -- /*!40000 ALTER TABLE `SHKPackLevelXPDLApp` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKPackLevelXPDLApp` ENABLE KEYS */; -- -- Table structure for table `SHKPackLevelXPDLAppTAAppDetUsr` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKPackLevelXPDLAppTAAppDetUsr` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKPackLevelXPDLAppTAAppDetUsr` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKPackLevelXPDLAppTAAppDetUsr_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKPackLevelXPDLAppTAAppDetUsr_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentAppDetailUser` (`oid`), CONSTRAINT `SHKPackLevelXPDLAppTAAppDetUsr_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKPackLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKPackLevelXPDLAppTAAppDetUsr` -- /*!40000 ALTER TABLE `SHKPackLevelXPDLAppTAAppDetUsr` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKPackLevelXPDLAppTAAppDetUsr` ENABLE KEYS */; -- -- Table structure for table `SHKPackLevelXPDLAppTAAppDetail` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKPackLevelXPDLAppTAAppDetail` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKPackLevelXPDLAppTAAppDetail` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKPackLevelXPDLAppTAAppDetail_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKPackLevelXPDLAppTAAppDetail_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentAppDetail` (`oid`), CONSTRAINT `SHKPackLevelXPDLAppTAAppDetail_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKPackLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKPackLevelXPDLAppTAAppDetail` -- /*!40000 ALTER TABLE `SHKPackLevelXPDLAppTAAppDetail` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKPackLevelXPDLAppTAAppDetail` ENABLE KEYS */; -- -- Table structure for table `SHKPackLevelXPDLAppTAAppUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKPackLevelXPDLAppTAAppUser` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKPackLevelXPDLAppTAAppUser` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKPackLevelXPDLAppTAAppUser_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKPackLevelXPDLAppTAAppUser_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentAppUser` (`oid`), CONSTRAINT `SHKPackLevelXPDLAppTAAppUser_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKPackLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKPackLevelXPDLAppTAAppUser` -- /*!40000 ALTER TABLE `SHKPackLevelXPDLAppTAAppUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKPackLevelXPDLAppTAAppUser` ENABLE KEYS */; -- -- Table structure for table `SHKPackLevelXPDLAppToolAgntApp` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKPackLevelXPDLAppToolAgntApp` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKPackLevelXPDLAppToolAgntApp` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKPackLevelXPDLAppToolAgntApp_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKPackLevelXPDLAppToolAgntApp_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentApp` (`oid`), CONSTRAINT `SHKPackLevelXPDLAppToolAgntApp_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKPackLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKPackLevelXPDLAppToolAgntApp` -- /*!40000 ALTER TABLE `SHKPackLevelXPDLAppToolAgntApp` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKPackLevelXPDLAppToolAgntApp` ENABLE KEYS */; -- -- Table structure for table `SHKProcLevelParticipant` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcLevelParticipant` ( `PARTICIPANT_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PROCESSOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcLevelParticipant` (`PARTICIPANT_ID`,`PROCESSOID`), KEY `SHKProcLevelParticipant_PROCESSOID` (`PROCESSOID`), CONSTRAINT `SHKProcLevelParticipant_PROCESSOID` FOREIGN KEY (`PROCESSOID`) REFERENCES `SHKXPDLParticipantProcess` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcLevelParticipant` -- /*!40000 ALTER TABLE `SHKProcLevelParticipant` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcLevelParticipant` ENABLE KEYS */; -- -- Table structure for table `SHKProcLevelXPDLApp` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcLevelXPDLApp` ( `APPLICATION_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PROCESSOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcLevelXPDLApp` (`APPLICATION_ID`,`PROCESSOID`), KEY `SHKProcLevelXPDLApp_PROCESSOID` (`PROCESSOID`), CONSTRAINT `SHKProcLevelXPDLApp_PROCESSOID` FOREIGN KEY (`PROCESSOID`) REFERENCES `SHKXPDLApplicationProcess` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcLevelXPDLApp` -- /*!40000 ALTER TABLE `SHKProcLevelXPDLApp` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcLevelXPDLApp` ENABLE KEYS */; -- -- Table structure for table `SHKProcLevelXPDLAppTAAppDetUsr` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcLevelXPDLAppTAAppDetUsr` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcLevelXPDLAppTAAppDetUsr` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKProcLevelXPDLAppTAAppDetUsr_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKProcLevelXPDLAppTAAppDetUsr_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentAppDetailUser` (`oid`), CONSTRAINT `SHKProcLevelXPDLAppTAAppDetUsr_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKProcLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcLevelXPDLAppTAAppDetUsr` -- /*!40000 ALTER TABLE `SHKProcLevelXPDLAppTAAppDetUsr` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcLevelXPDLAppTAAppDetUsr` ENABLE KEYS */; -- -- Table structure for table `SHKProcLevelXPDLAppTAAppDetail` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcLevelXPDLAppTAAppDetail` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcLevelXPDLAppTAAppDetail` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKProcLevelXPDLAppTAAppDetail_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKProcLevelXPDLAppTAAppDetail_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentAppDetail` (`oid`), CONSTRAINT `SHKProcLevelXPDLAppTAAppDetail_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKProcLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcLevelXPDLAppTAAppDetail` -- /*!40000 ALTER TABLE `SHKProcLevelXPDLAppTAAppDetail` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcLevelXPDLAppTAAppDetail` ENABLE KEYS */; -- -- Table structure for table `SHKProcLevelXPDLAppTAAppUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcLevelXPDLAppTAAppUser` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcLevelXPDLAppTAAppUser` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKProcLevelXPDLAppTAAppUser_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKProcLevelXPDLAppTAAppUser_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentAppUser` (`oid`), CONSTRAINT `SHKProcLevelXPDLAppTAAppUser_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKProcLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcLevelXPDLAppTAAppUser` -- /*!40000 ALTER TABLE `SHKProcLevelXPDLAppTAAppUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcLevelXPDLAppTAAppUser` ENABLE KEYS */; -- -- Table structure for table `SHKProcLevelXPDLAppToolAgntApp` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcLevelXPDLAppToolAgntApp` ( `XPDL_APPOID` decimal(19,0) NOT NULL, `TOOLAGENTOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcLevelXPDLAppToolAgntApp` (`XPDL_APPOID`,`TOOLAGENTOID`), KEY `SHKProcLevelXPDLAppToolAgntApp_TOOLAGENTOID` (`TOOLAGENTOID`), CONSTRAINT `SHKProcLevelXPDLAppToolAgntApp_TOOLAGENTOID` FOREIGN KEY (`TOOLAGENTOID`) REFERENCES `SHKToolAgentApp` (`oid`), CONSTRAINT `SHKProcLevelXPDLAppToolAgntApp_XPDL_APPOID` FOREIGN KEY (`XPDL_APPOID`) REFERENCES `SHKProcLevelXPDLApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcLevelXPDLAppToolAgntApp` -- /*!40000 ALTER TABLE `SHKProcLevelXPDLAppToolAgntApp` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcLevelXPDLAppToolAgntApp` ENABLE KEYS */; -- -- Table structure for table `SHKProcessData` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessData` ( `Process` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValue` mediumblob, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` double DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessData` (`CNT`), UNIQUE KEY `I2_SHKProcessData` (`Process`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKProcessData_Process` FOREIGN KEY (`Process`) REFERENCES `SHKProcesses` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessData` -- /*!40000 ALTER TABLE `SHKProcessData` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcessData` ENABLE KEYS */; -- -- Table structure for table `SHKProcessDataBLOBs` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessDataBLOBs` ( `ProcessDataWOB` decimal(19,0) NOT NULL, `VariableValue` mediumblob, `OrdNo` int(11) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessDataBLOBs` (`ProcessDataWOB`,`OrdNo`), CONSTRAINT `SHKProcessDataBLOBs_ProcessDataWOB` FOREIGN KEY (`ProcessDataWOB`) REFERENCES `SHKProcessDataWOB` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessDataBLOBs` -- /*!40000 ALTER TABLE `SHKProcessDataBLOBs` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcessDataBLOBs` ENABLE KEYS */; -- -- Table structure for table `SHKProcessDataWOB` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessDataWOB` ( `Process` decimal(19,0) NOT NULL, `VariableDefinitionId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `VariableType` int(11) NOT NULL, `VariableValueXML` text COLLATE utf8_unicode_ci, `VariableValueVCHAR` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL, `VariableValueDBL` double DEFAULT NULL, `VariableValueLONG` bigint(20) DEFAULT NULL, `VariableValueDATE` datetime DEFAULT NULL, `VariableValueBOOL` smallint(6) DEFAULT NULL, `OrdNo` int(11) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessDataWOB` (`CNT`), UNIQUE KEY `I2_SHKProcessDataWOB` (`Process`,`VariableDefinitionId`,`OrdNo`), CONSTRAINT `SHKProcessDataWOB_Process` FOREIGN KEY (`Process`) REFERENCES `SHKProcesses` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessDataWOB` -- /*!40000 ALTER TABLE `SHKProcessDataWOB` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcessDataWOB` ENABLE KEYS */; -- -- Table structure for table `SHKProcessDefinitions` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessDefinitions` ( `Name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `PackageId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionCreated` bigint(20) NOT NULL, `ProcessDefinitionVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `State` int(11) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessDefinitions` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessDefinitions` -- /*!40000 ALTER TABLE `SHKProcessDefinitions` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcessDefinitions` ENABLE KEYS */; -- -- Table structure for table `SHKProcessRequesters` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessRequesters` ( `Id` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ActivityRequester` decimal(19,0) DEFAULT NULL, `ResourceRequester` decimal(19,0) DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessRequesters` (`Id`), KEY `I2_SHKProcessRequesters` (`ActivityRequester`), KEY `I3_SHKProcessRequesters` (`ResourceRequester`), CONSTRAINT `SHKProcessRequesters_ActivityRequester` FOREIGN KEY (`ActivityRequester`) REFERENCES `SHKActivities` (`oid`), CONSTRAINT `SHKProcessRequesters_ResourceRequester` FOREIGN KEY (`ResourceRequester`) REFERENCES `SHKResourcesTable` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessRequesters` -- /*!40000 ALTER TABLE `SHKProcessRequesters` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcessRequesters` ENABLE KEYS */; -- -- Table structure for table `SHKProcessStateEventAudits` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessStateEventAudits` ( `KeyValue` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessStateEventAudits` (`KeyValue`), UNIQUE KEY `I2_SHKProcessStateEventAudits` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessStateEventAudits` -- /*!40000 ALTER TABLE `SHKProcessStateEventAudits` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcessStateEventAudits` ENABLE KEYS */; -- -- Table structure for table `SHKProcessStates` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcessStates` ( `KeyValue` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcessStates` (`KeyValue`), UNIQUE KEY `I2_SHKProcessStates` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcessStates` -- /*!40000 ALTER TABLE `SHKProcessStates` DISABLE KEYS */; INSERT INTO `SHKProcessStates` VALUES ('open.running','open.running',1000000,0),('open.not_running.not_started','open.not_running.not_started',1000002,0),('open.not_running.suspended','open.not_running.suspended',1000004,0),('closed.completed','closed.completed',1000006,0),('closed.terminated','closed.terminated',1000008,0),('closed.aborted','closed.aborted',1000010,0); /*!40000 ALTER TABLE `SHKProcessStates` ENABLE KEYS */; -- -- Table structure for table `SHKProcesses` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKProcesses` ( `SyncVersion` bigint(20) NOT NULL, `Id` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinition` decimal(19,0) NOT NULL, `PDefName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ActivityRequesterId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityRequesterProcessId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `ResourceRequesterId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ExternalRequesterClassName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `State` decimal(19,0) NOT NULL, `Priority` int(11) DEFAULT NULL, `Name` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `Created` bigint(20) NOT NULL, `CreatedTZO` bigint(20) NOT NULL, `Started` bigint(20) DEFAULT NULL, `StartedTZO` bigint(20) DEFAULT NULL, `LastStateTime` bigint(20) NOT NULL, `LastStateTimeTZO` bigint(20) NOT NULL, `LimitTime` bigint(20) NOT NULL, `LimitTimeTZO` bigint(20) NOT NULL, `Description` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKProcesses` (`Id`), KEY `I2_SHKProcesses` (`ProcessDefinition`), KEY `I3_SHKProcesses` (`State`), KEY `I4_SHKProcesses` (`ActivityRequesterId`), KEY `I5_SHKProcesses` (`ResourceRequesterId`), CONSTRAINT `SHKProcesses_ProcessDefinition` FOREIGN KEY (`ProcessDefinition`) REFERENCES `SHKProcessDefinitions` (`oid`), CONSTRAINT `SHKProcesses_State` FOREIGN KEY (`State`) REFERENCES `SHKProcessStates` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKProcesses` -- /*!40000 ALTER TABLE `SHKProcesses` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKProcesses` ENABLE KEYS */; -- -- Table structure for table `SHKResourcesTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKResourcesTable` ( `Username` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKResourcesTable` (`Username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKResourcesTable` -- /*!40000 ALTER TABLE `SHKResourcesTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKResourcesTable` ENABLE KEYS */; -- -- Table structure for table `SHKStateEventAudits` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKStateEventAudits` ( `RecordedTime` bigint(20) NOT NULL, `RecordedTimeTZO` bigint(20) NOT NULL, `TheUsername` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `TheType` decimal(19,0) NOT NULL, `ActivityId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessId` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ProcessName` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `ProcessFactoryName` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ProcessFactoryVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `ActivityDefinitionId` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `ActivityDefinitionType` int(11) DEFAULT NULL, `ProcessDefinitionId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ProcessDefinitionName` varchar(90) COLLATE utf8_unicode_ci DEFAULT NULL, `PackageId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `OldProcessState` decimal(19,0) DEFAULT NULL, `NewProcessState` decimal(19,0) DEFAULT NULL, `OldActivityState` decimal(19,0) DEFAULT NULL, `NewActivityState` decimal(19,0) DEFAULT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKStateEventAudits` (`CNT`), KEY `SHKStateEventAudits_TheType` (`TheType`), KEY `SHKStateEventAudits_OldProcessState` (`OldProcessState`), KEY `SHKStateEventAudits_NewProcessState` (`NewProcessState`), KEY `SHKStateEventAudits_OldActivityState` (`OldActivityState`), KEY `SHKStateEventAudits_NewActivityState` (`NewActivityState`), CONSTRAINT `SHKStateEventAudits_NewActivityState` FOREIGN KEY (`NewActivityState`) REFERENCES `SHKActivityStateEventAudits` (`oid`), CONSTRAINT `SHKStateEventAudits_NewProcessState` FOREIGN KEY (`NewProcessState`) REFERENCES `SHKProcessStateEventAudits` (`oid`), CONSTRAINT `SHKStateEventAudits_OldActivityState` FOREIGN KEY (`OldActivityState`) REFERENCES `SHKActivityStateEventAudits` (`oid`), CONSTRAINT `SHKStateEventAudits_OldProcessState` FOREIGN KEY (`OldProcessState`) REFERENCES `SHKProcessStateEventAudits` (`oid`), CONSTRAINT `SHKStateEventAudits_TheType` FOREIGN KEY (`TheType`) REFERENCES `SHKEventTypes` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKStateEventAudits` -- /*!40000 ALTER TABLE `SHKStateEventAudits` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKStateEventAudits` ENABLE KEYS */; -- -- Table structure for table `SHKToolAgentApp` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKToolAgentApp` ( `TOOL_AGENT_NAME` varchar(250) COLLATE utf8_unicode_ci NOT NULL, `APP_NAME` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKToolAgentApp` (`TOOL_AGENT_NAME`,`APP_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKToolAgentApp` -- /*!40000 ALTER TABLE `SHKToolAgentApp` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKToolAgentApp` ENABLE KEYS */; -- -- Table structure for table `SHKToolAgentAppDetail` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKToolAgentAppDetail` ( `APP_MODE` decimal(10,0) NOT NULL, `TOOLAGENT_APPOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKToolAgentAppDetail` (`APP_MODE`,`TOOLAGENT_APPOID`), KEY `SHKToolAgentAppDetail_TOOLAGENT_APPOID` (`TOOLAGENT_APPOID`), CONSTRAINT `SHKToolAgentAppDetail_TOOLAGENT_APPOID` FOREIGN KEY (`TOOLAGENT_APPOID`) REFERENCES `SHKToolAgentApp` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKToolAgentAppDetail` -- /*!40000 ALTER TABLE `SHKToolAgentAppDetail` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKToolAgentAppDetail` ENABLE KEYS */; -- -- Table structure for table `SHKToolAgentAppDetailUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKToolAgentAppDetailUser` ( `TOOLAGENT_APPOID` decimal(19,0) NOT NULL, `USEROID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKToolAgentAppDetailUser` (`TOOLAGENT_APPOID`,`USEROID`), KEY `SHKToolAgentAppDetailUser_USEROID` (`USEROID`), CONSTRAINT `SHKToolAgentAppDetailUser_TOOLAGENT_APPOID` FOREIGN KEY (`TOOLAGENT_APPOID`) REFERENCES `SHKToolAgentAppDetail` (`oid`), CONSTRAINT `SHKToolAgentAppDetailUser_USEROID` FOREIGN KEY (`USEROID`) REFERENCES `SHKToolAgentUser` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKToolAgentAppDetailUser` -- /*!40000 ALTER TABLE `SHKToolAgentAppDetailUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKToolAgentAppDetailUser` ENABLE KEYS */; -- -- Table structure for table `SHKToolAgentAppUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKToolAgentAppUser` ( `TOOLAGENT_APPOID` decimal(19,0) NOT NULL, `USEROID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKToolAgentAppUser` (`TOOLAGENT_APPOID`,`USEROID`), KEY `SHKToolAgentAppUser_USEROID` (`USEROID`), CONSTRAINT `SHKToolAgentAppUser_TOOLAGENT_APPOID` FOREIGN KEY (`TOOLAGENT_APPOID`) REFERENCES `SHKToolAgentApp` (`oid`), CONSTRAINT `SHKToolAgentAppUser_USEROID` FOREIGN KEY (`USEROID`) REFERENCES `SHKToolAgentUser` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKToolAgentAppUser` -- /*!40000 ALTER TABLE `SHKToolAgentAppUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKToolAgentAppUser` ENABLE KEYS */; -- -- Table structure for table `SHKToolAgentUser` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKToolAgentUser` ( `USERNAME` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `PWD` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKToolAgentUser` (`USERNAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKToolAgentUser` -- /*!40000 ALTER TABLE `SHKToolAgentUser` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKToolAgentUser` ENABLE KEYS */; -- -- Table structure for table `SHKUserGroupTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKUserGroupTable` ( `userid` decimal(19,0) NOT NULL, `groupid` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKUserGroupTable` (`userid`,`groupid`), KEY `SHKUserGroupTable_groupid` (`groupid`), CONSTRAINT `SHKUserGroupTable_groupid` FOREIGN KEY (`groupid`) REFERENCES `SHKGroupTable` (`oid`), CONSTRAINT `SHKUserGroupTable_userid` FOREIGN KEY (`userid`) REFERENCES `SHKUserTable` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKUserGroupTable` -- /*!40000 ALTER TABLE `SHKUserGroupTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKUserGroupTable` ENABLE KEYS */; -- -- Table structure for table `SHKUserPackLevelPart` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKUserPackLevelPart` ( `PARTICIPANTOID` decimal(19,0) NOT NULL, `USEROID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKUserPackLevelPart` (`PARTICIPANTOID`,`USEROID`), KEY `SHKUserPackLevelPart_USEROID` (`USEROID`), CONSTRAINT `SHKUserPackLevelPart_PARTICIPANTOID` FOREIGN KEY (`PARTICIPANTOID`) REFERENCES `SHKPackLevelParticipant` (`oid`), CONSTRAINT `SHKUserPackLevelPart_USEROID` FOREIGN KEY (`USEROID`) REFERENCES `SHKNormalUser` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKUserPackLevelPart` -- /*!40000 ALTER TABLE `SHKUserPackLevelPart` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKUserPackLevelPart` ENABLE KEYS */; -- -- Table structure for table `SHKUserProcLevelParticipant` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKUserProcLevelParticipant` ( `PARTICIPANTOID` decimal(19,0) NOT NULL, `USEROID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKUserProcLevelParticipant` (`PARTICIPANTOID`,`USEROID`), KEY `SHKUserProcLevelParticipant_USEROID` (`USEROID`), CONSTRAINT `SHKUserProcLevelParticipant_PARTICIPANTOID` FOREIGN KEY (`PARTICIPANTOID`) REFERENCES `SHKProcLevelParticipant` (`oid`), CONSTRAINT `SHKUserProcLevelParticipant_USEROID` FOREIGN KEY (`USEROID`) REFERENCES `SHKNormalUser` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKUserProcLevelParticipant` -- /*!40000 ALTER TABLE `SHKUserProcLevelParticipant` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKUserProcLevelParticipant` ENABLE KEYS */; -- -- Table structure for table `SHKUserTable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKUserTable` ( `userid` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `firstname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `lastname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `passwd` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKUserTable` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKUserTable` -- /*!40000 ALTER TABLE `SHKUserTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKUserTable` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLApplicationPackage` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLApplicationPackage` ( `PACKAGE_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLApplicationPackage` (`PACKAGE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLApplicationPackage` -- /*!40000 ALTER TABLE `SHKXPDLApplicationPackage` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLApplicationPackage` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLApplicationProcess` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLApplicationProcess` ( `PROCESS_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PACKAGEOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLApplicationProcess` (`PROCESS_ID`,`PACKAGEOID`), KEY `SHKXPDLApplicationProcess_PACKAGEOID` (`PACKAGEOID`), CONSTRAINT `SHKXPDLApplicationProcess_PACKAGEOID` FOREIGN KEY (`PACKAGEOID`) REFERENCES `SHKXPDLApplicationPackage` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLApplicationProcess` -- /*!40000 ALTER TABLE `SHKXPDLApplicationProcess` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLApplicationProcess` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLData` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLData` ( `XPDLContent` longblob, `XPDLClassContent` longblob, `XPDL` decimal(19,0) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLData` (`CNT`), UNIQUE KEY `I2_SHKXPDLData` (`XPDL`), CONSTRAINT `SHKXPDLData_XPDL` FOREIGN KEY (`XPDL`) REFERENCES `SHKXPDLS` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLData` -- /*!40000 ALTER TABLE `SHKXPDLData` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLData` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLHistory` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLHistory` ( `XPDLId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `XPDLVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `XPDLClassVersion` bigint(20) NOT NULL, `XPDLUploadTime` datetime NOT NULL, `XPDLHistoryUploadTime` datetime NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLHistory` (`XPDLId`,`XPDLVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLHistory` -- /*!40000 ALTER TABLE `SHKXPDLHistory` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLHistory` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLHistoryData` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLHistoryData` ( `XPDLContent` mediumblob NOT NULL, `XPDLClassContent` mediumblob NOT NULL, `XPDLHistory` decimal(19,0) NOT NULL, `CNT` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLHistoryData` (`CNT`), KEY `SHKXPDLHistoryData_XPDLHistory` (`XPDLHistory`), CONSTRAINT `SHKXPDLHistoryData_XPDLHistory` FOREIGN KEY (`XPDLHistory`) REFERENCES `SHKXPDLHistory` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLHistoryData` -- /*!40000 ALTER TABLE `SHKXPDLHistoryData` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLHistoryData` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLParticipantPackage` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLParticipantPackage` ( `PACKAGE_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLParticipantPackage` (`PACKAGE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLParticipantPackage` -- /*!40000 ALTER TABLE `SHKXPDLParticipantPackage` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLParticipantPackage` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLParticipantProcess` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLParticipantProcess` ( `PROCESS_ID` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `PACKAGEOID` decimal(19,0) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLParticipantProcess` (`PROCESS_ID`,`PACKAGEOID`), KEY `SHKXPDLParticipantProcess_PACKAGEOID` (`PACKAGEOID`), CONSTRAINT `SHKXPDLParticipantProcess_PACKAGEOID` FOREIGN KEY (`PACKAGEOID`) REFERENCES `SHKXPDLParticipantPackage` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLParticipantProcess` -- /*!40000 ALTER TABLE `SHKXPDLParticipantProcess` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLParticipantProcess` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLReferences` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLReferences` ( `ReferredXPDLId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `ReferringXPDL` decimal(19,0) NOT NULL, `ReferredXPDLNumber` int(11) NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLReferences` (`ReferredXPDLId`,`ReferringXPDL`), KEY `SHKXPDLReferences_ReferringXPDL` (`ReferringXPDL`), CONSTRAINT `SHKXPDLReferences_ReferringXPDL` FOREIGN KEY (`ReferringXPDL`) REFERENCES `SHKXPDLS` (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLReferences` -- /*!40000 ALTER TABLE `SHKXPDLReferences` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLReferences` ENABLE KEYS */; -- -- Table structure for table `SHKXPDLS` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SHKXPDLS` ( `XPDLId` varchar(90) COLLATE utf8_unicode_ci NOT NULL, `XPDLVersion` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `XPDLClassVersion` bigint(20) NOT NULL, `XPDLUploadTime` datetime NOT NULL, `oid` decimal(19,0) NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `I1_SHKXPDLS` (`XPDLId`,`XPDLVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `SHKXPDLS` -- /*!40000 ALTER TABLE `SHKXPDLS` DISABLE KEYS */; /*!40000 ALTER TABLE `SHKXPDLS` ENABLE KEYS */; -- -- Table structure for table `app_app` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_app` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `published` bit(1) DEFAULT NULL, `dateCreated` datetime DEFAULT NULL, `dateModified` datetime DEFAULT NULL, `license` text COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `meta` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`appId`,`appVersion`), KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_app` -- /*!40000 ALTER TABLE `app_app` DISABLE KEYS */; /*!40000 ALTER TABLE `app_app` ENABLE KEYS */; -- -- Table structure for table `app_datalist` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_datalist` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `json` longtext COLLATE utf8_unicode_ci, `dateCreated` datetime DEFAULT NULL, `dateModified` datetime DEFAULT NULL, PRIMARY KEY (`appId`,`appVersion`,`id`), KEY `FK5E9247A6462EF4C7` (`appId`,`appVersion`), KEY `idx_name` (`name`), CONSTRAINT `FK5E9247A6462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_datalist` -- /*!40000 ALTER TABLE `app_datalist` DISABLE KEYS */; /*!40000 ALTER TABLE `app_datalist` ENABLE KEYS */; -- -- Table structure for table `app_env_variable` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_env_variable` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `value` text COLLATE utf8_unicode_ci, `remarks` text COLLATE utf8_unicode_ci, PRIMARY KEY (`appId`,`appVersion`,`id`), KEY `FK740A62EC462EF4C7` (`appId`,`appVersion`), CONSTRAINT `FK740A62EC462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_env_variable` -- /*!40000 ALTER TABLE `app_env_variable` DISABLE KEYS */; /*!40000 ALTER TABLE `app_env_variable` ENABLE KEYS */; -- -- Table structure for table `app_fd` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_fd` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `dateCreated` datetime DEFAULT NULL, `dateModified` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_fd` -- /*!40000 ALTER TABLE `app_fd` DISABLE KEYS */; /*!40000 ALTER TABLE `app_fd` ENABLE KEYS */; -- -- Table structure for table `app_form` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_form` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `formId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `dateCreated` datetime DEFAULT NULL, `dateModified` datetime DEFAULT NULL, `tableName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `json` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`appId`,`appVersion`,`formId`), KEY `FK45957822462EF4C7` (`appId`,`appVersion`), KEY `idx_name` (`name`), CONSTRAINT `FK45957822462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_form` -- /*!40000 ALTER TABLE `app_form` DISABLE KEYS */; /*!40000 ALTER TABLE `app_form` ENABLE KEYS */; -- -- Table structure for table `app_form_data_audit_trail` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_form_data_audit_trail` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appVersion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `formId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `tableName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `data` longtext COLLATE utf8_unicode_ci, `datetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_form_data_audit_trail` -- /*!40000 ALTER TABLE `app_form_data_audit_trail` DISABLE KEYS */; /*!40000 ALTER TABLE `app_form_data_audit_trail` ENABLE KEYS */; -- -- Table structure for table `app_message` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_message` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `ouid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `messageKey` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `message` text COLLATE utf8_unicode_ci, PRIMARY KEY (`appId`,`appVersion`,`ouid`), KEY `FKEE346FE9462EF4C7` (`appId`,`appVersion`), CONSTRAINT `FKEE346FE9462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_message` -- /*!40000 ALTER TABLE `app_message` DISABLE KEYS */; /*!40000 ALTER TABLE `app_message` ENABLE KEYS */; -- -- Table structure for table `app_package` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_package` ( `packageId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageVersion` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `dateCreated` datetime DEFAULT NULL, `dateModified` datetime DEFAULT NULL, `appId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appVersion` bigint(20) DEFAULT NULL, PRIMARY KEY (`packageId`,`packageVersion`), KEY `FK852EA428462EF4C7` (`appId`,`appVersion`), CONSTRAINT `FK852EA428462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_package` -- /*!40000 ALTER TABLE `app_package` DISABLE KEYS */; /*!40000 ALTER TABLE `app_package` ENABLE KEYS */; -- -- Table structure for table `app_package_activity_form` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_package_activity_form` ( `processDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `activityDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageVersion` bigint(20) NOT NULL, `ouid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `formId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `formUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `formIFrameStyle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `autoContinue` bit(1) DEFAULT NULL, `disableSaveAsDraft` bit(1) DEFAULT NULL, PRIMARY KEY (`processDefId`,`activityDefId`,`packageId`,`packageVersion`), KEY `FKA8D741D5F255BCC` (`packageId`,`packageVersion`), CONSTRAINT `FKA8D741D5F255BCC` FOREIGN KEY (`packageId`, `packageVersion`) REFERENCES `app_package` (`packageId`, `packageVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_package_activity_form` -- /*!40000 ALTER TABLE `app_package_activity_form` DISABLE KEYS */; /*!40000 ALTER TABLE `app_package_activity_form` ENABLE KEYS */; -- -- Table structure for table `app_package_activity_plugin` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_package_activity_plugin` ( `processDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `activityDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageVersion` bigint(20) NOT NULL, `ouid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `pluginName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `pluginProperties` text COLLATE utf8_unicode_ci, PRIMARY KEY (`processDefId`,`activityDefId`,`packageId`,`packageVersion`), KEY `FKADE8644C5F255BCC` (`packageId`,`packageVersion`), CONSTRAINT `FKADE8644C5F255BCC` FOREIGN KEY (`packageId`, `packageVersion`) REFERENCES `app_package` (`packageId`, `packageVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_package_activity_plugin` -- /*!40000 ALTER TABLE `app_package_activity_plugin` DISABLE KEYS */; /*!40000 ALTER TABLE `app_package_activity_plugin` ENABLE KEYS */; -- -- Table structure for table `app_package_participant` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_package_participant` ( `processDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `participantId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageVersion` bigint(20) NOT NULL, `ouid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` text COLLATE utf8_unicode_ci, `pluginProperties` text COLLATE utf8_unicode_ci, PRIMARY KEY (`processDefId`,`participantId`,`packageId`,`packageVersion`), KEY `FK6D7BF59C5F255BCC` (`packageId`,`packageVersion`), CONSTRAINT `FK6D7BF59C5F255BCC` FOREIGN KEY (`packageId`, `packageVersion`) REFERENCES `app_package` (`packageId`, `packageVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_package_participant` -- /*!40000 ALTER TABLE `app_package_participant` DISABLE KEYS */; /*!40000 ALTER TABLE `app_package_participant` ENABLE KEYS */; -- -- Table structure for table `app_plugin_default` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_plugin_default` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `pluginName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `pluginDescription` text COLLATE utf8_unicode_ci, `pluginProperties` text COLLATE utf8_unicode_ci, PRIMARY KEY (`appId`,`appVersion`,`id`), KEY `FK7A835713462EF4C7` (`appId`,`appVersion`), CONSTRAINT `FK7A835713462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_plugin_default` -- /*!40000 ALTER TABLE `app_plugin_default` DISABLE KEYS */; /*!40000 ALTER TABLE `app_plugin_default` ENABLE KEYS */; -- -- Table structure for table `app_report_activity` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_report_activity` ( `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `activityDefId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `activityName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `processUid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `FK5E33D79C918F93D` (`processUid`), CONSTRAINT `FK5E33D79C918F93D` FOREIGN KEY (`processUid`) REFERENCES `app_report_process` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_report_activity` -- /*!40000 ALTER TABLE `app_report_activity` DISABLE KEYS */; /*!40000 ALTER TABLE `app_report_activity` ENABLE KEYS */; -- -- Table structure for table `app_report_activity_instance` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_report_activity_instance` ( `instanceId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `performer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `nameOfAcceptedUser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `assignmentUsers` text COLLATE utf8_unicode_ci, `due` datetime DEFAULT NULL, `createdTime` datetime DEFAULT NULL, `startedTime` datetime DEFAULT NULL, `finishTime` datetime DEFAULT NULL, `delay` bigint(20) DEFAULT NULL, `timeConsumingFromCreatedTime` bigint(20) DEFAULT NULL, `timeConsumingFromStartedTime` bigint(20) DEFAULT NULL, `activityUid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `processInstanceId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`instanceId`), KEY `FK9C6ABDD8B06E2043` (`activityUid`), KEY `FK9C6ABDD8D4610A90` (`processInstanceId`), CONSTRAINT `FK9C6ABDD8B06E2043` FOREIGN KEY (`activityUid`) REFERENCES `app_report_activity` (`uuid`), CONSTRAINT `FK9C6ABDD8D4610A90` FOREIGN KEY (`processInstanceId`) REFERENCES `app_report_process_instance` (`instanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_report_activity_instance` -- /*!40000 ALTER TABLE `app_report_activity_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `app_report_activity_instance` ENABLE KEYS */; -- -- Table structure for table `app_report_app` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_report_app` ( `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appVersion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_report_app` -- /*!40000 ALTER TABLE `app_report_app` DISABLE KEYS */; /*!40000 ALTER TABLE `app_report_app` ENABLE KEYS */; -- -- Table structure for table `app_report_package` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_report_package` ( `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `packageName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `packageVersion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appUid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `FKBD580A19E475ABC` (`appUid`), CONSTRAINT `FKBD580A19E475ABC` FOREIGN KEY (`appUid`) REFERENCES `app_report_app` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_report_package` -- /*!40000 ALTER TABLE `app_report_package` DISABLE KEYS */; /*!40000 ALTER TABLE `app_report_package` ENABLE KEYS */; -- -- Table structure for table `app_report_process` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_report_process` ( `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `processDefId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `processName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `packageUid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `FKDAFFF442D40695DD` (`packageUid`), CONSTRAINT `FKDAFFF442D40695DD` FOREIGN KEY (`packageUid`) REFERENCES `app_report_package` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_report_process` -- /*!40000 ALTER TABLE `app_report_process` DISABLE KEYS */; /*!40000 ALTER TABLE `app_report_process` ENABLE KEYS */; -- -- Table structure for table `app_report_process_instance` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_report_process_instance` ( `instanceId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `requester` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `due` datetime DEFAULT NULL, `startedTime` datetime DEFAULT NULL, `finishTime` datetime DEFAULT NULL, `delay` bigint(20) DEFAULT NULL, `timeConsumingFromStartedTime` bigint(20) DEFAULT NULL, `processUid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`instanceId`), KEY `FK351D7BF2918F93D` (`processUid`), CONSTRAINT `FK351D7BF2918F93D` FOREIGN KEY (`processUid`) REFERENCES `app_report_process` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_report_process_instance` -- /*!40000 ALTER TABLE `app_report_process_instance` DISABLE KEYS */; /*!40000 ALTER TABLE `app_report_process_instance` ENABLE KEYS */; -- -- Table structure for table `app_resource` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_resource` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `filesize` bigint(20) DEFAULT NULL, `permissionClass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `permissionProperties` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`appId`,`appVersion`,`id`), CONSTRAINT `FK_nnvkg0h6yy8o3f4yjhd20ury0` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_resource` -- /*!40000 ALTER TABLE `app_resource` DISABLE KEYS */; /*!40000 ALTER TABLE `app_resource` ENABLE KEYS */; -- -- Table structure for table `app_userview` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app_userview` ( `appId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `appVersion` bigint(20) NOT NULL, `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `json` longtext COLLATE utf8_unicode_ci, `dateCreated` datetime DEFAULT NULL, `dateModified` datetime DEFAULT NULL, PRIMARY KEY (`appId`,`appVersion`,`id`), KEY `FKE411D54E462EF4C7` (`appId`,`appVersion`), KEY `idx_name` (`name`), CONSTRAINT `FKE411D54E462EF4C7` FOREIGN KEY (`appId`, `appVersion`) REFERENCES `app_app` (`appId`, `appVersion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app_userview` -- /*!40000 ALTER TABLE `app_userview` DISABLE KEYS */; /*!40000 ALTER TABLE `app_userview` ENABLE KEYS */; -- -- Table structure for table `dir_department` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_department` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `organizationId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `hod` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `parentId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKEEE8AA4418CEBAE1` (`organizationId`), KEY `FKEEE8AA44EF6BB2B7` (`parentId`), KEY `FKEEE8AA4480DB1449` (`hod`), CONSTRAINT `FKEEE8AA4418CEBAE1` FOREIGN KEY (`organizationId`) REFERENCES `dir_organization` (`id`), CONSTRAINT `FKEEE8AA4480DB1449` FOREIGN KEY (`hod`) REFERENCES `dir_employment` (`id`), CONSTRAINT `FKEEE8AA44EF6BB2B7` FOREIGN KEY (`parentId`) REFERENCES `dir_department` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_department` -- /*!40000 ALTER TABLE `dir_department` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_department` ENABLE KEYS */; -- -- Table structure for table `dir_employment` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_employment` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `userId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `employeeCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `role` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `gradeId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `departmentId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `organizationId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKC6620ADE716AE35F` (`departmentId`), KEY `FKC6620ADE14CE02E9` (`gradeId`), KEY `FKC6620ADECE539211` (`userId`), KEY `FKC6620ADE18CEBAE1` (`organizationId`), CONSTRAINT `FKC6620ADE14CE02E9` FOREIGN KEY (`gradeId`) REFERENCES `dir_grade` (`id`), CONSTRAINT `FKC6620ADE18CEBAE1` FOREIGN KEY (`organizationId`) REFERENCES `dir_organization` (`id`), CONSTRAINT `FKC6620ADE716AE35F` FOREIGN KEY (`departmentId`) REFERENCES `dir_department` (`id`), CONSTRAINT `FKC6620ADECE539211` FOREIGN KEY (`userId`) REFERENCES `dir_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_employment` -- /*!40000 ALTER TABLE `dir_employment` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_employment` ENABLE KEYS */; -- -- Table structure for table `dir_employment_report_to` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_employment_report_to` ( `employmentId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `reportToId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`employmentId`,`reportToId`), KEY `FK53622945F4068416` (`reportToId`), KEY `FK536229452787E613` (`employmentId`), CONSTRAINT `FK536229452787E613` FOREIGN KEY (`employmentId`) REFERENCES `dir_employment` (`id`), CONSTRAINT `FK53622945F4068416` FOREIGN KEY (`reportToId`) REFERENCES `dir_employment` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_employment_report_to` -- /*!40000 ALTER TABLE `dir_employment_report_to` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_employment_report_to` ENABLE KEYS */; -- -- Table structure for table `dir_grade` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_grade` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `organizationId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKBC9A49A518CEBAE1` (`organizationId`), CONSTRAINT `FKBC9A49A518CEBAE1` FOREIGN KEY (`organizationId`) REFERENCES `dir_organization` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_grade` -- /*!40000 ALTER TABLE `dir_grade` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_grade` ENABLE KEYS */; -- -- Table structure for table `dir_group` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_group` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `organizationId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKBC9A804D18CEBAE1` (`organizationId`), CONSTRAINT `FKBC9A804D18CEBAE1` FOREIGN KEY (`organizationId`) REFERENCES `dir_organization` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_group` -- /*!40000 ALTER TABLE `dir_group` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_group` ENABLE KEYS */; -- -- Table structure for table `dir_organization` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_organization` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `parentId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK55A15FA5961BD498` (`parentId`), CONSTRAINT `FK55A15FA5961BD498` FOREIGN KEY (`parentId`) REFERENCES `dir_organization` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_organization` -- /*!40000 ALTER TABLE `dir_organization` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_organization` ENABLE KEYS */; -- -- Table structure for table `dir_role` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_role` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_role` -- /*!40000 ALTER TABLE `dir_role` DISABLE KEYS */; INSERT INTO `dir_role` VALUES ('ROLE_ADMIN','Admin','Administrator'),('ROLE_USER','User','Normal User'); /*!40000 ALTER TABLE `dir_role` ENABLE KEYS */; -- -- Table structure for table `dir_user` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `firstName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `lastName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `active` int(11) DEFAULT NULL, `timeZone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user` -- /*!40000 ALTER TABLE `dir_user` DISABLE KEYS */; INSERT INTO `dir_user` VALUES ('admin','admin','21232f297a57a5a743894a0e4a801fc3','Admin','Admin',NULL,1,'0',NULL); /*!40000 ALTER TABLE `dir_user` ENABLE KEYS */; -- -- Table structure for table `dir_user_extra` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user_extra` ( `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `algorithm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `loginAttempt` int(11) DEFAULT NULL, `failedloginAttempt` int(11) DEFAULT NULL, `lastLogedInDate` datetime DEFAULT NULL, `lockOutDate` datetime DEFAULT NULL, `lastPasswordChangeDate` datetime DEFAULT NULL, `requiredPasswordChange` bit(1) DEFAULT NULL, `noPasswordExpiration` bit(1) DEFAULT NULL, PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user_extra` -- /*!40000 ALTER TABLE `dir_user_extra` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_user_extra` ENABLE KEYS */; -- -- Table structure for table `dir_user_group` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user_group` ( `groupId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `userId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`userId`,`groupId`), KEY `FK2F0367FD159B6639` (`groupId`), KEY `FK2F0367FDCE539211` (`userId`), CONSTRAINT `FK2F0367FD159B6639` FOREIGN KEY (`groupId`) REFERENCES `dir_group` (`id`), CONSTRAINT `FK2F0367FDCE539211` FOREIGN KEY (`userId`) REFERENCES `dir_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user_group` -- /*!40000 ALTER TABLE `dir_user_group` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_user_group` ENABLE KEYS */; -- -- Table structure for table `dir_user_meta` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user_meta` ( `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `meta_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `meta_value` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`username`,`meta_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user_meta` -- /*!40000 ALTER TABLE `dir_user_meta` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_user_meta` ENABLE KEYS */; -- -- Table structure for table `dir_user_password_history` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user_password_history` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `updatedDate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user_password_history` -- /*!40000 ALTER TABLE `dir_user_password_history` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_user_password_history` ENABLE KEYS */; -- -- Table structure for table `dir_user_replacement` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user_replacement` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `replacementUser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `processIds` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `startDate` datetime DEFAULT NULL, `endDate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user_replacement` -- /*!40000 ALTER TABLE `dir_user_replacement` DISABLE KEYS */; /*!40000 ALTER TABLE `dir_user_replacement` ENABLE KEYS */; -- -- Table structure for table `dir_user_role` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dir_user_role` ( `roleId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `userId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`userId`,`roleId`), KEY `FK5C5FE738C8FE3CA7` (`roleId`), KEY `FK5C5FE738CE539211` (`userId`), CONSTRAINT `FK5C5FE738C8FE3CA7` FOREIGN KEY (`roleId`) REFERENCES `dir_role` (`id`), CONSTRAINT `FK5C5FE738CE539211` FOREIGN KEY (`userId`) REFERENCES `dir_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dir_user_role` -- /*!40000 ALTER TABLE `dir_user_role` DISABLE KEYS */; INSERT INTO `dir_user_role` VALUES ('ROLE_ADMIN','admin'); /*!40000 ALTER TABLE `dir_user_role` ENABLE KEYS */; -- -- Table structure for table `objectid` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `objectid` ( `nextoid` decimal(19,0) NOT NULL, PRIMARY KEY (`nextoid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `objectid` -- /*!40000 ALTER TABLE `objectid` DISABLE KEYS */; INSERT INTO `objectid` VALUES (1000200); /*!40000 ALTER TABLE `objectid` ENABLE KEYS */; -- -- Table structure for table `wf_audit_trail` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_audit_trail` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `clazz` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `message` text COLLATE utf8_unicode_ci, `timestamp` datetime DEFAULT NULL, `appId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appVersion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_audit_trail` -- /*!40000 ALTER TABLE `wf_audit_trail` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_audit_trail` ENABLE KEYS */; -- -- Table structure for table `wf_process_link` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_process_link` ( `processId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `parentProcessId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `originProcessId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`processId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_process_link` -- /*!40000 ALTER TABLE `wf_process_link` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_process_link` ENABLE KEYS */; -- -- Table structure for table `wf_report` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_report` ( `activityInstanceId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `processInstanceId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `priority` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `createdTime` datetime DEFAULT NULL, `startedTime` datetime DEFAULT NULL, `dateLimit` bigint(20) DEFAULT NULL, `due` datetime DEFAULT NULL, `delay` bigint(20) DEFAULT NULL, `finishTime` datetime DEFAULT NULL, `timeConsumingFromDateCreated` bigint(20) DEFAULT NULL, `timeConsumingFromDateStarted` bigint(20) DEFAULT NULL, `performer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `nameOfAcceptedUser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `packageId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `processDefId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `activityDefId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `assignmentUsers` text COLLATE utf8_unicode_ci, `appId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `appVersion` bigint(20) DEFAULT NULL, PRIMARY KEY (`activityInstanceId`), KEY `FKB943CCA47A4E8F48` (`packageId`), KEY `FKB943CCA4A39D6461` (`processDefId`), KEY `FKB943CCA4CB863F` (`activityDefId`), CONSTRAINT `FKB943CCA47A4E8F48` FOREIGN KEY (`packageId`) REFERENCES `wf_report_package` (`packageId`), CONSTRAINT `FKB943CCA4A39D6461` FOREIGN KEY (`processDefId`) REFERENCES `wf_report_process` (`processDefId`), CONSTRAINT `FKB943CCA4CB863F` FOREIGN KEY (`activityDefId`) REFERENCES `wf_report_activity` (`activityDefId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_report` -- /*!40000 ALTER TABLE `wf_report` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_report` ENABLE KEYS */; -- -- Table structure for table `wf_report_activity` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_report_activity` ( `activityDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `activityName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `priority` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`activityDefId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_report_activity` -- /*!40000 ALTER TABLE `wf_report_activity` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_report_activity` ENABLE KEYS */; -- -- Table structure for table `wf_report_package` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_report_package` ( `packageId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `packageName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`packageId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_report_package` -- /*!40000 ALTER TABLE `wf_report_package` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_report_package` ENABLE KEYS */; -- -- Table structure for table `wf_report_process` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_report_process` ( `processDefId` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `processName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`processDefId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_report_process` -- /*!40000 ALTER TABLE `wf_report_process` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_report_process` ENABLE KEYS */; -- -- Table structure for table `wf_resource_bundle_message` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_resource_bundle_message` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `messageKey` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `message` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_resource_bundle_message` -- /*!40000 ALTER TABLE `wf_resource_bundle_message` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_resource_bundle_message` ENABLE KEYS */; -- -- Table structure for table `wf_setup` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wf_setup` ( `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `property` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` text COLLATE utf8_unicode_ci, `ordering` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wf_setup` -- /*!40000 ALTER TABLE `wf_setup` DISABLE KEYS */; /*!40000 ALTER TABLE `wf_setup` ENABLE KEYS */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2018-02-22 16:03:40