flowable / flowable-examples

Repository with example Flowable projects
Apache License 2.0
245 stars 235 forks source link

Does not support mysql 8 #33

Open iqolome opened 3 years ago

iqolome commented 3 years ago

Need to convert and verify sql


 UPDATE FLW_EV_DATABASECHANGELOG SET '8:1b0c48c9cf7945be799d868a2626d687' WHERE MD5SUM='7:0aaa7b01343f4cdaf1019cd2de3f98f3';

 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:c8701f1c71018b55029f450b2e9a10a1' WHERE MD5SUM='7:d878c2672ead57b5801578fd39c423af';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:47f94b27feb7df8a30d4e338c7bd5fb8' WHERE MD5SUM='7:15a6bda1fce898a58e04fe6ac2d89f54';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:ac17eae89fbdccb6e08daf3c7797b579' WHERE MD5SUM='7:eed5dec2f94778b62d0b0b4beebc191d';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:f73aabc4529e7292c2942073d1cff6f9' WHERE MD5SUM='7:b8d3d5a3efb71aef7578e1130a38fde2';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:3e03528582dd4eeb4eb41f9b9539140d' WHERE MD5SUM='7:ae890f8d7f13a83bebd35c0749fd0a58';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:646c6a061e0b6e8a62e69844ff96abb0' WHERE MD5SUM='7:c44cb06af8977c776a4e93aebe96c568';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:215a499ff7ae77685b55355245b8b708' WHERE MD5SUM='7:4b6469565b1b00b428ffca7eab1ef253';
 UPDATE ACT_DMN_DATABASECHANGELOG SET '8:5355bee389318afed91a11702f2df032' WHERE MD5SUM='7:f83b7b3228be2c4bbb554d6de45307d7';

UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:033ebf9380889aed7c453927ecc3250d' WHERE MD5SUM='7:252bd5cb28cf86685ed67eb15d910118'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:986365ceb40445ce3b27a8e6b40f159b' WHERE MD5SUM='7:4850f9311e7503d7ea30a372e79b4ea2'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:abf482518ceb09830ef674e52c06bf15' WHERE MD5SUM='7:6d80a1fd28201ae354e73bd7c5cf8595'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:2087829f22a4b2298dbf530681c74854' WHERE MD5SUM='7:fe396622b05965c516c1bedb14789be8'; 
UPDATE ACT_FO_DATABASECHANGELOG SET MD5SUM='8:b4be732b89e5ca028bdd520c6ad4d446' WHERE MD5SUM='7:80b47424c1d564a692fc8923633f78e4'; 

UPDATE ACT_CO_DATABASECHANGELOG SET MD5SUM='8:7644d7165cfe799200a2abdd3419e8b6' WHERE MD5SUM='7:a17df43ed0c96adfef5271e1781aaed2'; 
UPDATE ACT_CO_DATABASECHANGELOG SET MD5SUM='8:fe7b11ac7dbbf9c43006b23bbab60bab' WHERE MD5SUM='7:5aa445d140a638ee432a00c23134dd98'; 

UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:8b4b922d90b05ff27483abefc9597aa6' WHERE MD5SUM='7:1ed01100eeb9bb6054c28320b6c5fb22'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:65e39b3d385706bb261cbeffe7533cbe' WHERE MD5SUM='7:72a1f3f4767524ec0e22288a1621ebb9'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:c01f6e802b49436b4489040da3012359' WHERE MD5SUM='7:1c0c14847bb4a891aaf91668d14240c1'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:e40d29cb79345b7fb5afd38a7f0ba8fc' WHERE MD5SUM='7:894e6e444f72422bf34e4ade89dc8451'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:70349de472f87368dcdec971a10311a0' WHERE MD5SUM='7:08d50990ca7c5669a8dfb6cdc0bbb7e0'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:10e82e26a7fee94c32a92099c059c18c' WHERE MD5SUM='7:2b33c819a1ef81d793f7ef82bed8b1ac'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:530bc81a1e30618ccf4a2da1f7c6c043' WHERE MD5SUM='7:ff6d918908599427d849c1f3b109cf1c'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:e8c2eb1ce28bc301efe07e0e29757781' WHERE MD5SUM='7:d168de628476556968549f4a355baacb'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:4cb4782b9bdec5ced2a64c525aa7b3a0' WHERE MD5SUM='7:20048a5d52039eaabb32dbb30240fc08'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:341c16be247f5d17badc9809da8691f9' WHERE MD5SUM='7:e20ea59573dc2a33bbf72043ea09ea4d'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:d7c4da9276bcfffbfb0ebfb25e3f7b05' WHERE MD5SUM='7:21c7a61ad7fb26abc675dff7ac54e43e'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:adf4ecc45f2aa9a44a5626b02e1d6f98' WHERE MD5SUM='7:e77f0eb21b221f823d6a0e198144cefc'; 
UPDATE ACT_CMMN_DATABASECHANGELOG SET MD5SUM='8:7550626f964ab5518464709408333ec1' WHERE MD5SUM='7:c5ddabeb0c9fb8db6371c249097d78a3'; 

UPDATE ACT_APP_DATABASECHANGELOG SET MD5SUM='8:496fc778bdf2ab13f2e1926d0e63e0a2' WHERE MD5SUM='7:ec9776f6c57a3953c7d27499108df3d1'; 
UPDATE ACT_APP_DATABASECHANGELOG SET MD5SUM='8:ccea9ebfb6c1f8367ca4dd473fcbb7db' WHERE MD5SUM='7:f6ea483119569f0fe50aae8d64ba392d'; 
UPDATE ACT_APP_DATABASECHANGELOG SET MD5SUM='8:f1f8aff320aade831944ebad24355f3d' WHERE MD5SUM='7:4ef4a0a9e9cfb636c22126d540cdd38e'; 
filiphr commented 3 years ago

Can you be more precise about what isn't working?

iqolome commented 3 years ago

Can you be more precise about what isn't working?

When starting, verify the scheme information of the database. The value of the scheme MD5SUM used in SQL is mysql7. When mysql8 is used, the verification fails.