{"success":true,"data":[{"ID":"changelog-4.0-clean","AUTHOR":"author","FILENAME":"changelog-4.0-clean","DATEEXECUTED":"2025-03-10T16:18:07.000Z","ORDEREXECUTED":1,"EXECTYPE":"EXECUTED","MD5SUM":"9:29260b7c580835a4006cb8c8303f753e","DESCRIPTION":"createTable tableName=tc_attributes; createTable tableName=tc_calendars; createTable tableName=tc_commands; createTable tableName=tc_device_attribute; createTable tableName=tc_device_command; createTable tableName=tc_device_driver; createTable tab...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.0-clean-common","AUTHOR":"author","FILENAME":"changelog-4.0-clean","DATEEXECUTED":"2025-03-10T16:18:07.000Z","ORDEREXECUTED":2,"EXECTYPE":"EXECUTED","MD5SUM":"9:9106689cc508433f83e5bf7885bfc276","DESCRIPTION":"addForeignKeyConstraint baseTableName=tc_groups, constraintName=fk_groups_groupid, referencedTableName=tc_groups; addForeignKeyConstraint baseTableName=tc_user_user, constraintName=fk_user_user_manageduserid, referencedTableName=tc_users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.3","AUTHOR":"author","FILENAME":"changelog-3.3","DATEEXECUTED":"2025-03-10T16:18:07.000Z","ORDEREXECUTED":3,"EXECTYPE":"MARK_RAN","MD5SUM":"9:bb6fa4c9a558aab1c22ff673e73a2df7","DESCRIPTION":"createTable tableName=users; addUniqueConstraint constraintName=uk_user_email, tableName=users; createTable tableName=devices; addUniqueConstraint constraintName=uk_device_uniqueid, tableName=devices; createTable tableName=user_device; addForeignK...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.5","AUTHOR":"author","FILENAME":"changelog-3.5","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":4,"EXECTYPE":"MARK_RAN","MD5SUM":"9:b8197a0f7dcedcda83f17ee28b866c12","DESCRIPTION":"createTable tableName=groups; createTable tableName=user_group; addForeignKeyConstraint baseTableName=user_group, constraintName=fk_user_group_userid, referencedTableName=users; addForeignKeyConstraint baseTableName=user_group, constraintName=fk_u...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.6","AUTHOR":"author","FILENAME":"changelog-3.6","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":5,"EXECTYPE":"MARK_RAN","MD5SUM":"9:3d062403b1f4e179f39abe9823dc8778","DESCRIPTION":"createTable tableName=events; addForeignKeyConstraint baseTableName=events, constraintName=fk_event_deviceid, referencedTableName=devices; addColumn tableName=devices; createTable tableName=geofences; createTable tableName=user_geofence; addForeig...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.7","AUTHOR":"author","FILENAME":"changelog-3.7","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":6,"EXECTYPE":"MARK_RAN","MD5SUM":"9:921bc1885dbecd66ad680c05cd788f1d","DESCRIPTION":"update tableName=devices; addForeignKeyConstraint baseTableName=devices, constraintName=fk_device_group_groupid, referencedTableName=groups; update tableName=groups; addColumn tableName=devices; dropColumn columnName=motion, tableName=devices; dro...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.7-notmssql","AUTHOR":"author","FILENAME":"changelog-3.7","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":7,"EXECTYPE":"MARK_RAN","MD5SUM":"9:24714339932615af4edc04c5b1fef3f5","DESCRIPTION":"addForeignKeyConstraint baseTableName=groups, constraintName=fk_group_group_groupid, referencedTableName=groups","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.8","AUTHOR":"author","FILENAME":"changelog-3.8","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":8,"EXECTYPE":"MARK_RAN","MD5SUM":"9:64bcb39340c067a96dab11bf92c6992e","DESCRIPTION":"createTable tableName=attribute_aliases; addForeignKeyConstraint baseTableName=attribute_aliases, constraintName=fk_attribute_aliases_deviceid, referencedTableName=devices; addUniqueConstraint constraintName=uk_deviceid_attribute, tableName=attrib...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.9","AUTHOR":"author","FILENAME":"changelog-3.9","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":9,"EXECTYPE":"MARK_RAN","MD5SUM":"9:bdafab236dec1eb35711f3389037d9af","DESCRIPTION":"addColumn tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.10","AUTHOR":"author","FILENAME":"changelog-3.10","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":10,"EXECTYPE":"MARK_RAN","MD5SUM":"9:9c4224af73f728709435296f77c7ef43","DESCRIPTION":"createTable tableName=calendars; createTable tableName=user_calendar; addForeignKeyConstraint baseTableName=user_calendar, constraintName=fk_user_calendar_userid, referencedTableName=users; addForeignKeyConstraint baseTableName=user_calendar, cons...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.10-notmssql","AUTHOR":"author","FILENAME":"changelog-3.10","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":11,"EXECTYPE":"MARK_RAN","MD5SUM":"9:929670374dee7d507efb1a9e48de33f1","DESCRIPTION":"addForeignKeyConstraint baseTableName=user_user, constraintName=fk_user_user_manageduserid, referencedTableName=users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.10-mssql","AUTHOR":"author","FILENAME":"changelog-3.10","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":12,"EXECTYPE":"MARK_RAN","MD5SUM":"9:7cf543f3642b34b0721e028f7b707ded","DESCRIPTION":"sql","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.7-mssql","AUTHOR":"author","FILENAME":"changelog-3.10","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":13,"EXECTYPE":"MARK_RAN","MD5SUM":"9:8161fe3a60d8f09de3b8e66c0d13df12","DESCRIPTION":"sql","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.11","AUTHOR":"author","FILENAME":"changelog-3.11","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":14,"EXECTYPE":"MARK_RAN","MD5SUM":"9:acb21929570584649f579269f1fefd46","DESCRIPTION":"addColumn tableName=users; addColumn tableName=notifications; addColumn tableName=server; addColumn tableName=server; addColumn tableName=users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.12","AUTHOR":"author","FILENAME":"changelog-3.12","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":15,"EXECTYPE":"MARK_RAN","MD5SUM":"9:ac21f242f3a412cd5195538dd3301acb","DESCRIPTION":"addColumn tableName=statistics; createTable tableName=attributes; createTable tableName=user_attribute; addForeignKeyConstraint baseTableName=user_attribute, constraintName=fk_user_attribute_userid, referencedTableName=users; addForeignKeyConstrai...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.12-notmssql","AUTHOR":"author","FILENAME":"changelog-3.12","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":16,"EXECTYPE":"MARK_RAN","MD5SUM":"9:aa13c3285a22ddd5fa5181e70c9eed4a","DESCRIPTION":"dropForeignKeyConstraint baseTableName=groups, constraintName=fk_group_group_groupid; addForeignKeyConstraint baseTableName=groups, constraintName=fk_groups_groupid, referencedTableName=groups","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.12-pgsql","AUTHOR":"author","FILENAME":"changelog-3.12","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":17,"EXECTYPE":"MARK_RAN","MD5SUM":"9:c82f089f061203d278f3fa7e3eee357c","DESCRIPTION":"dropColumn columnName=data, tableName=calendars; addColumn tableName=calendars","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.14","AUTHOR":"author","FILENAME":"changelog-3.14","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":18,"EXECTYPE":"MARK_RAN","MD5SUM":"9:99f06473e278cb4bac143355370dbb5f","DESCRIPTION":"createTable tableName=drivers; addUniqueConstraint constraintName=uk_driver_uniqueid, tableName=drivers; createTable tableName=user_driver; addForeignKeyConstraint baseTableName=user_driver, constraintName=fk_user_driver_userid, referencedTableNam...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.15","AUTHOR":"author","FILENAME":"changelog-3.15","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":19,"EXECTYPE":"MARK_RAN","MD5SUM":"9:df24f9c7ea28977c8b7605330ab00c79","DESCRIPTION":"dropForeignKeyConstraint baseTableName=attribute_aliases, constraintName=fk_attribute_aliases_deviceid; dropUniqueConstraint constraintName=uk_deviceid_attribute, tableName=attribute_aliases; dropTable tableName=attribute_aliases; dropColumn colum...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.16","AUTHOR":"author","FILENAME":"changelog-3.16","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":20,"EXECTYPE":"MARK_RAN","MD5SUM":"9:56c004387993bc290cafab00700a2e0d","DESCRIPTION":"addColumn tableName=devices; addColumn tableName=users; addColumn tableName=servers; addColumn tableName=notifications; addForeignKeyConstraint baseTableName=notifications, constraintName=fk_notification_calendar_calendarid, referencedTableName=ca...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.3-admin","AUTHOR":"author","FILENAME":"changelog-3.17","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":21,"EXECTYPE":"MARK_RAN","MD5SUM":"9:a0a63100bfe3711c3063fb8946218697","DESCRIPTION":"renameColumn newColumnName=administrator, oldColumnName=admin, tableName=users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-3.17","AUTHOR":"author","FILENAME":"changelog-3.17","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":22,"EXECTYPE":"MARK_RAN","MD5SUM":"9:27de05645cf3aeb7886a92e30f4a9e29","DESCRIPTION":"addColumn tableName=events; createTable tableName=maintenances; createTable tableName=user_maintenance; addForeignKeyConstraint baseTableName=user_maintenance, constraintName=fk_user_maintenance_userid, referencedTableName=users; addForeignKeyCons...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.0-pre","AUTHOR":"author","FILENAME":"changelog-4.0","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":23,"EXECTYPE":"MARK_RAN","MD5SUM":"9:a211f8f9310477e68b78aad3b8df31ab","DESCRIPTION":"addColumn tableName=notifications","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.0-common","AUTHOR":"author","FILENAME":"changelog-4.0","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":24,"EXECTYPE":"MARK_RAN","MD5SUM":"9:3af985512945bd0654f0a2354de7706a","DESCRIPTION":"update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.0-pg","AUTHOR":"author","FILENAME":"changelog-4.0","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":25,"EXECTYPE":"MARK_RAN","MD5SUM":"9:1c341fc1d4fd9cfa31d01f217f3d762a","DESCRIPTION":"update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications; update tableName=notifications","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.0","AUTHOR":"author","FILENAME":"changelog-4.0","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":26,"EXECTYPE":"MARK_RAN","MD5SUM":"9:5a01fa7b7073ce47885e27000842d2c7","DESCRIPTION":"dropDefaultValue columnName=web, tableName=notifications; dropColumn columnName=web, tableName=notifications; dropDefaultValue columnName=mail, tableName=notifications; dropColumn columnName=mail, tableName=notifications; dropDefaultValue columnNa...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.0-renaming","AUTHOR":"author","FILENAME":"changelog-4.0","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":27,"EXECTYPE":"MARK_RAN","MD5SUM":"9:bbf19e8434a012975637564e6f6de096","DESCRIPTION":"renameTable newTableName=tc_attributes, oldTableName=attributes; renameTable newTableName=tc_calendars, oldTableName=calendars; renameTable newTableName=tc_commands, oldTableName=commands; renameTable newTableName=tc_device_attribute, oldTableName...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.1-mssql","AUTHOR":"author","FILENAME":"changelog-4.1","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":28,"EXECTYPE":"MARK_RAN","MD5SUM":"9:0b4cd69b7025008e34cc0b8439f1d905","DESCRIPTION":"sql; sql; sql; sql","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.7","AUTHOR":"author","FILENAME":"changelog-4.7","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":29,"EXECTYPE":"EXECUTED","MD5SUM":"9:828c072f51d04a38470dd96399de6233","DESCRIPTION":"createIndex indexName=user_device_user_id, tableName=tc_user_device; createIndex indexName=position_deviceid_fixtime, tableName=tc_positions","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.9","AUTHOR":"author","FILENAME":"changelog-4.9","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":30,"EXECTYPE":"EXECUTED","MD5SUM":"9:62f4b0b8b3ec5c8746ed1ac842107e79","DESCRIPTION":"createIndex indexName=event_deviceid_servertime, tableName=tc_events","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.10","AUTHOR":"author","FILENAME":"changelog-4.10","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":31,"EXECTYPE":"EXECUTED","MD5SUM":"9:3602f5246bfb9c2323e0ca67cfdab70a","DESCRIPTION":"addColumn tableName=tc_statistics","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.11","AUTHOR":"author","FILENAME":"changelog-4.11","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":32,"EXECTYPE":"EXECUTED","MD5SUM":"9:e9052c48b7d99aa9738ab35ba314929f","DESCRIPTION":"addColumn tableName=tc_servers","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.13","AUTHOR":"author","FILENAME":"changelog-4.13","DATEEXECUTED":"2025-03-10T16:18:08.000Z","ORDEREXECUTED":33,"EXECTYPE":"EXECUTED","MD5SUM":"9:6feeb695221e4b844967cec335fb6aea","DESCRIPTION":"renameColumn newColumnName=eventtime, oldColumnName=servertime, tableName=tc_events","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-4.15","AUTHOR":"author","FILENAME":"changelog-4.15","DATEEXECUTED":"2025-03-10T16:18:09.000Z","ORDEREXECUTED":34,"EXECTYPE":"EXECUTED","MD5SUM":"9:c7e7a54391ed2e16ef5a90fd68c0f9d7","DESCRIPTION":"createTable tableName=tc_orders; createTable tableName=tc_user_order; addForeignKeyConstraint baseTableName=tc_user_order, constraintName=fk_user_order_userid, referencedTableName=tc_users; addForeignKeyConstraint baseTableName=tc_user_order, cons...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.0","AUTHOR":"author","FILENAME":"changelog-5.0","DATEEXECUTED":"2025-03-10T16:18:09.000Z","ORDEREXECUTED":35,"EXECTYPE":"EXECUTED","MD5SUM":"9:ac3942110503f904188c67b63fc7c072","DESCRIPTION":"addColumn tableName=tc_servers; addColumn tableName=tc_users; renameColumn newColumnName=toaddresstmp, oldColumnName=toAddress, tableName=tc_orders; renameColumn newColumnName=fromaddresstmp, oldColumnName=fromAddress, tableName=tc_orders; renameC...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.1","AUTHOR":"author","FILENAME":"changelog-5.1","DATEEXECUTED":"2025-03-10T16:18:09.000Z","ORDEREXECUTED":36,"EXECTYPE":"EXECUTED","MD5SUM":"9:82263460dd8dd7e71eba9c368bf5a74b","DESCRIPTION":"createIndex indexName=idx_drivers_uniqueid, tableName=tc_drivers; createIndex indexName=idx_devices_uniqueid, tableName=tc_devices; createIndex indexName=idx_users_email, tableName=tc_users; createIndex indexName=idx_users_login, tableName=tc_user...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.2","AUTHOR":"author","FILENAME":"changelog-5.2","DATEEXECUTED":"2025-03-10T16:18:10.000Z","ORDEREXECUTED":37,"EXECTYPE":"EXECUTED","MD5SUM":"9:c1c7f476b08ce0a19801431add8446fd","DESCRIPTION":"addColumn tableName=tc_devices; addColumn tableName=tc_devices","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.3","AUTHOR":"author","FILENAME":"changelog-5.3","DATEEXECUTED":"2025-03-10T16:18:10.000Z","ORDEREXECUTED":38,"EXECTYPE":"EXECUTED","MD5SUM":"9:1a574cf5780301ad3488b68d7e457e27","DESCRIPTION":"addColumn tableName=tc_servers; addColumn tableName=tc_users; addColumn tableName=tc_devices; createTable tableName=tc_keystore; dropIndex indexName=idx_users_token, tableName=tc_users; dropColumn columnName=token, tableName=tc_users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.4","AUTHOR":"author","FILENAME":"changelog-5.4","DATEEXECUTED":"2025-03-10T16:18:10.000Z","ORDEREXECUTED":39,"EXECTYPE":"EXECUTED","MD5SUM":"9:f3048803607da81d070ff76022d1020a","DESCRIPTION":"addColumn tableName=tc_devices; createTable tableName=tc_commands_queue; addForeignKeyConstraint baseTableName=tc_commands_queue, constraintName=fk_commands_queue_deviceid, referencedTableName=tc_devices; createIndex indexName=idx_commands_queue_d...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.5","AUTHOR":"author","FILENAME":"changelog-5.5","DATEEXECUTED":"2025-03-10T16:18:10.000Z","ORDEREXECUTED":40,"EXECTYPE":"EXECUTED","MD5SUM":"9:23b37a6f82fd32497af31f093b855dc9","DESCRIPTION":"dropColumn columnName=description, tableName=tc_commands_queue","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.6","AUTHOR":"author","FILENAME":"changelog-5.6","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":41,"EXECTYPE":"EXECUTED","MD5SUM":"9:99240a2ac8883cb74c5cba38ef5c1686","DESCRIPTION":"addColumn tableName=tc_devices; createTable tableName=tc_reports; addForeignKeyConstraint baseTableName=tc_reports, constraintName=fk_reports_calendarid, referencedTableName=tc_calendars; createTable tableName=tc_user_report; addForeignKeyConstrai...","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.7","AUTHOR":"author","FILENAME":"changelog-5.7","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":42,"EXECTYPE":"EXECUTED","MD5SUM":"9:f2425b5cceff33f0abbe4c1ea0c18a28","DESCRIPTION":"addColumn tableName=tc_notifications; addForeignKeyConstraint baseTableName=tc_notifications, constraintName=fk_notifications_commandid, referencedTableName=tc_commands","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.8","AUTHOR":"author","FILENAME":"changelog-5.8","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":43,"EXECTYPE":"EXECUTED","MD5SUM":"9:6700eee6204986c4db1134cf30a188d6","DESCRIPTION":"dropColumn columnName=geofenceids, tableName=tc_devices; addColumn tableName=tc_positions","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.9","AUTHOR":"author","FILENAME":"changelog-5.9","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":44,"EXECTYPE":"EXECUTED","MD5SUM":"9:f516b72a9e6c82f09e8bbf7802884768","DESCRIPTION":"addColumn tableName=tc_devices; addForeignKeyConstraint baseTableName=tc_devices, constraintName=fk_devices_calendarid, referencedTableName=tc_calendars","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.10","AUTHOR":"author","FILENAME":"changelog-5.10","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":45,"EXECTYPE":"EXECUTED","MD5SUM":"9:2de9e66d1f8219a42b14390dd5a5b218","DESCRIPTION":"addColumn tableName=tc_users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-5.11","AUTHOR":"author","FILENAME":"changelog-5.11","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":46,"EXECTYPE":"EXECUTED","MD5SUM":"9:f30849022d894f99ea42f93e69c00ed8","DESCRIPTION":"addColumn tableName=tc_users","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-6.2","AUTHOR":"author","FILENAME":"changelog-6.2","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":47,"EXECTYPE":"EXECUTED","MD5SUM":"9:4afc10f18622be53ad650af7d23ca1e0","DESCRIPTION":"dropColumn columnName=twelvehourformat, tableName=tc_servers; dropColumn columnName=twelvehourformat, tableName=tc_users; addColumn tableName=tc_attributes","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-6.3-old","AUTHOR":"author","FILENAME":"changelog-6.3","DATEEXECUTED":"2025-03-10T16:18:11.000Z","ORDEREXECUTED":48,"EXECTYPE":"MARK_RAN","MD5SUM":"9:4e1d3dc09c7c412a7637461af4f40931","DESCRIPTION":"dropForeignKeyConstraint baseTableName=tc_events, constraintName=fk_event_deviceid; dropForeignKeyConstraint baseTableName=tc_positions, constraintName=fk_position_deviceid","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-6.3-new","AUTHOR":"author","FILENAME":"changelog-6.3","DATEEXECUTED":"2025-03-10T16:18:12.000Z","ORDEREXECUTED":49,"EXECTYPE":"EXECUTED","MD5SUM":"9:1ecbc64d93f7dcb304d5f482b04b9b56","DESCRIPTION":"dropForeignKeyConstraint baseTableName=tc_events, constraintName=fk_events_deviceid; dropForeignKeyConstraint baseTableName=tc_positions, constraintName=fk_positions_deviceid","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"},{"ID":"changelog-6.6","AUTHOR":"author","FILENAME":"changelog-6.6","DATEEXECUTED":"2025-03-10T16:18:12.000Z","ORDEREXECUTED":50,"EXECTYPE":"EXECUTED","MD5SUM":"9:9de8626a90708711843aab4560a33515","DESCRIPTION":"addColumn tableName=tc_notifications","COMMENTS":"","TAG":null,"LIQUIBASE":"4.23.2","CONTEXTS":null,"LABELS":null,"DEPLOYMENT_ID":"1623480324"}],"count":50,"table":"DATABASECHANGELOG","limit":100,"query":"SELECT * FROM DATABASECHANGELOG LIMIT ?","message":"50 registros encontrados na tabela DATABASECHANGELOG"}