workouttest_server/data/db/update_1_0_25.sql
2021-02-15 18:04:22 +01:00

11 lines
255 B
SQL

START TRANSACTION;
ALTER TABLE `customer_property`
ADD INDEX `property_id` (`property_id`),
ADD INDEX `customer_id` (`customer_id`);
UPDATE configuration set config_value = "1.0.25", date_change=CURRENT_DATE WHERE config_key = "db_version";
COMMIT;