/*
Navicat Premium Data Transfer
Source Server : mysql
Source Server Type : MySQL
Source Server Version : 80030
Source Host : localhost:3306
Source Schema : activiti2
Target Server Type : MySQL
Target Server Version : 80030
File Encoding : 65001
Date: 26/12/2023 20:36:07
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for act_evt_log
-- ----------------------------
DROP TABLE IF EXISTS `act_evt_log`;
CREATE TABLE `act_evt_log` (
`LOG_NR_` bigint(0) NOT NULL AUTO_INCREMENT,
`TYPE_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`PROC_INST_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`EXECUTION_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`TASK_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`TIME_STAMP_` timestamp(3) NOT NULL,
`USER_ID_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`DATA_` longblob NULL,
`LOCK_OWNER_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
`IS_PROCESSED_` tinyint(0) NULL DEFAULT 0,
PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_evt_log
-- ----------------------------
-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
`ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
`REV_` int(0) NULL DEFAULT NULL,
`NAME_` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`BYTES_` longblob NULL,
`GENERATED_` tinyint(0) NULL DEFAULT NULL,
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `ACT_FK_BYTEARR_DEPL`(`DEPLOYMENT_ID_`) USING BTREE,
CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
INSERT INTO `act_ge_bytearray` VALUES ('2', 1, 'diagram/holiday.png', '1', 0x89504E470D0A1A0A0000000D494844520000009E000001730802000000404A27C400001E404944415478DAED9D8B57147796C7EBDFD857666727671F7302C852D5934C36C964368F4D6647F089D24C03E3AEB3E73891616430BA1A401A71C88E264C8C27E6B81A145BB082A383129D8E4669A0DBD6064411E415E817DDD074832286C1B8B7EAD75D5D5D55DD014336DDD5F79EEFE973EBFEEEBDBFDFAF3E5D5D051E1BEA119A4A8DC2538068D1102D1AA24543B46888160DD1225A34448B8668D1102D1AA24543B488160DD1A2215A34448B8668D1102DA24543B48F6B9FA1894C6D681F3D9A4181E054949595A90AEDC387D328900AD1CECFFB512015A29D9BF3A1402A44FBC5032F0AA442B4B3B36E14488568EFCF38512015A2BD776F5451BFDCBE67C79EDF471B559F5488F6EEF4B0A29E2FCFFEC5F0CAD77EBDB1E9FCB9A9A9A16869AA910AD14E4D0D28EAB577D797DECFF977E3BF65EC7DAEF0ADDDD1D2C40A040EE55341CB67FB175212B39BB14A43892C9B0D7CDD9E31A442B401FF1D45BDFACEFAB7E77FFED3C1575EBFF8D2CB7FF8F18BBFD61A3E3E39E9EB8D96EF9FFC10B8E69FECE3FD0BBB356BD9C93EDE0906172271FE626B17D55C2E15A29DF4DD56D4ABFBB2DFFDF2E7E577D7BDFE69E62BC657977FF6EAB3FFFB625ED17F47CBF759B732CC56EB444F4470A2B992A1F2EA7BA255499B88F2175BBBA8E672A910AD6FE2A6A25ED9975DFD451EA07DF18F2F3EDBF8FC8B4D2FFFC4F4DA2B9FBCF083A2CC83B51F793DDD92FC89F10379149CB86E4924684C8975BC7BE26A09130A90CC89F1B37AEE74F399F4EA2C51FE556F133F246EC82533FAB3E4D0AA4F0BB6154D4446F9489A5EBF5A08CA172359BF0AD18E7BBB14056877CFFCAC742AFB3F3AB37FD0F0CCD3277FF8ECC7CFBDD8F4D24FAEBCF4C3F79F5FF98BCDF212AF61157FE6569DF07406239E33150CA53374067D5DB1851FE233B93492209448F319D1AD56B73F58C8704D844CAF67BF8E4AAB304794F3C15089B998E113C4CDE552215AAFA74351AFEC5D5B3AB5EECDF195BF72FDF45F6E32CFDDD2BC70EBE91FDD7AE6C5AEE75EEF7CEEE5A6677EB543AF5868DE95CA91C87D0F7CCFD8E90A9AD21DB74947395B6918B34912C487F25A3EF89E8E4AAD68B779DAB730A4C3F19554A431BB4E0B69A13E7C895243412A443BE6BEA62840BB6D7CF56FDC59AF7DF2C25FECFEABBFACFAEBEFD47CF7EFDE7FF27B1F7E8FDEFFCC8A5FBC11AD10E476D5E402DC3AABDBD5584E730E176C2DA2E143B7BC31E4AFA8734524F085A2FCC82141755AAE495B796AB055DD0A8A2E6A7359650B482D6F15FA707EB486442A44EB765914F5F2DE35BF195BF15FA3AF3FF1CE779ED8F7B77FF3EE77BEFBFE93CFD4A76A8A7FF2FEE1830EBB5992EF3215D2DA7D41DFB94F4BA5949BCC2E270B67537B8C4B761DCBA2E8C25627E7B796A55054569D3322812F14E5470E454C44676969AE7F68AE705A9D96B40D2E20D447BA18B95488D6E96857D4CBBF5B53E4FC2987F6BDEF7EEF837F5876FCFB4F7FF8B46EF39BD1F241A6D214E153515BDB1611CC286C19AD2FCB088ED23999349579D4DEE6B0374050488E96CF5B4A590B97464AA89CBD4289A3A5908E9CD761DFAB8DC80FFA427393BD4DB27815A275D84D8A02B43F1F79E589B627FEBEF6C9671AFEF9F9CDEB0E1F3F343AD2122D3FD1A542B4A3239715051FC85983CFFED3A1279F3DF8E34DDB4BA3A5A9462A443B327C49513FD2AF612E7DFFE5A2FC13EC47C34397A2A5A9462A443B3C6454D47F6ED9515CAA8F36AA3EA910EDD0C0791448856807FACFA1402A44DBDFD78402A9106D5FEF69144885687B7B1A512015A245134C5568C1CAD044A62AB4F1602CCB26CF66930BEDFAF5EB112DA245B48816D1225A448B68112DA245B48816D1225A448B68112DA245B48816D1225A448B68112DA245B48816D1225A448B68112DA245B48816D1225A448B68112DA245B48816D1225A448B68112DA245B48816D1225A448B68112DF71F6AFD7EBF1CEDD8D858535313A24D60037E1B366C686E6E9E9F9F2768E7E6E61A1A1A743A9DC56241B4096C333333401188969494F4F6F682B379F36678DDB46913818D6813D80E1E3CB85E66A74E9DC27B6DC2DBE0E0A0846B6E6EAEF8068C6813D876EEDC29465B5353834FC82A3193C924460B375D44AB1283A7E28D1B3712AEF03C853FD7AACA0C0603416B341A11ADAACCEBF5C2D313FC8C3B3B3B8B68D566D5D5D5870F1F4E9EFD2611DAAEAE2EA7D38968D1921E2D7E03EE3767DF3EDA478F66504BAEAFFFB5C94B80F6E1C369D4922B2ED0CECFFB514BAEB8403B37E7432DB9E202ED170FBCA825575CA09D9D75A3965C7181F6FE8C13B5E48A0BB4F7EE8DC695EEDEAD2D28A88D8C5CDEF383F58D77471268AEB8407B777A58AECCFD9F7EA5E455D31D3B349A1D9D534342E4E302AA800D1F4EB3EBA89846923BAB32345517E155310786B8565317F768320A0A849C087F4FC790646DA4A77CCD0B992BB8F28223E242C9D6248A0BB45353037201B9CF6E75C71024C8AB02B6ED1ACD765BC058A5513A4FF987026CB6A6CAA8382388CDA7F2D97EAE0F74C8873EFDC1B65CC36C3674289E8BAD4A87123E21BDCA16AA0DF962D9AAD215A75EC85CC2F2600B821F6323A0B8401BF0DF918B437BB32B8620415EE5B76ED368B65D9FEC13226C1E957FB24F9276BD325D1E54EEA6F80EE16BA189A6F20269E59FBCB05B93BEDBCAC5059F77A27F3E44AEF32BE78ADA27EF43C5C5C705DA49DF6DB980DCC51B1D3104099292863C61BBCB2AEBB7329253C06CB54EF4C8322353F4CDBE89E64A26E80B9DF9E09A8650391FF9208FCFB1EA9729755A5669EDE1AB38879440A6D0D367DDCA305BAF8E9F5BC85CA436AF5EA94FFD1A2AEF03C5131817687D1337E502729FDEB81E439020AF9AB85AC23025D6F16ECED11D90C7397FFCAC9E49D35FED569C37985FBF9AD11FD033512E14A684AD48E3919CB5EAD3F2EABBC53D055F32116442BEC27ABE6A2E4883DAA857AD689B62C505DA716F975C40CED8698D2148905779CDC50C536CF174728EF41C71712EC773A622DA79D4ED0FF631AC622ACE80734247E90C9DE1FE9EFD3ABECF898AE21315699063A9481327442C26C644E2F57CD55CE08B67B1F0F30AEB14D62C515CA0F57A3AE402727FEAB4C41024C8AB3CED5B187A8B79CCC639B9EFC9E38A73857342259EE32B995DA7C131E4CA9084FA9877A5420EBC86E22B75B490945AD16EF38C9DAEA03987F424F9F2F52C70AEA86F11D136C58A0BB463EE6B7201B90BB6F61882047995BBB588A68BCAB5A9E57545B4F43415B53AD9723ADA195A5157B7822E6F0CF609F9755A2AB7CE1AEEEFAAC9A58BDA5C5CA4AD3C1572E05548A883795BAD6E576339BDA2CE451C2E424649BE789DA4CF42E6124BDC2786E202ADDB65910BC89DB7B5C61024C8ABE0EC80698F995DA6425ABB4F8873877461ABD3AC385730E758165DC68AFC422D95A5D5CAAFA4609FD6B214C887D7D040561DCC42A5D03445FAB862BD93C27D62CF65729C8CD524B295587181D6E968970BC87D72CD1443902029399A43D1A50DE0386A33954F4146A1C9DEA6381DC8549AA2AD6D137C8ACA3C6A6F839E4290EB6CDFAB0D35811C984E5CC58D72D37085FC614359464A594BB827591E37D452488BFA7CE55C92750A7D62282ED03AEC26B9805CB3F54A0C41826221C85EBB1C4E70