{ "name": "Delete Database Conso", "isActive": "1", "group": "", "mode": "provoke", "schedule": "", "trigger": [ "" ], "timeout": "0", "object_id": null, "isVisible": "0", "display": { "name": "", "icon": "" }, "order": "9999", "description": "", "configuration": { "timeDependency": 0, "has_return": 0, "logmode": "realtime", "allowMultiInstance": "0", "syncmode": "0", "timeline::enable": "0", "timeline::folder": "" }, "state": "stop", "elements": [ { "name": null, "type": "code", "options": [], "order": "0", "subElements": [ { "name": null, "type": "code", "subtype": "action", "options": { "collapse": "0", "enable": "1" }, "order": "0", "expressions": [ { "type": "code", "subtype": null, "expression": "$scenario->setLog(\"Debut Delete DB Conso\");\n\n$sql = \"\nDROP TABLE IF EXISTS `conso_jour`;\nDROP TABLE IF EXISTS `conso_periode`;\nDROP TABLE IF EXISTS `conso_price`;\nDROP TABLE IF EXISTS `conso_taxe`;\nDROP TABLE IF EXISTS `conso_abo`;\nDROP TABLE IF EXISTS `conso_tva`;\nDROP TABLE IF EXISTS `conso_periode_groupe`;\nDROP TABLE IF EXISTS `conso_groupe`;\nDROP TABLE IF EXISTS `conso_teleinfo`;\nDROP TABLE IF EXISTS `conso_tmp`;\nDROP TABLE IF EXISTS `conso_tva`;\nDROP TABLE IF EXISTS `conso_tva`;\nDROP VIEW IF EXISTS `conso_current`;\n\";\n\n\/\/Execute SQL\nDB::Prepare($sql, array(), DB::FETCH_TYPE_ALL);\n$scenario->setLog(\"Fin Delete DB Conso\");", "options": [], "order": "0" } ] } ] } ] }