13 lines
383 B
SQL
13 lines
383 B
SQL
START TRANSACTION;
|
|
|
|
ALTER TABLE `tracking`
|
|
CHANGE COLUMN `event_value` `event_value` TEXT NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci' AFTER `event`;
|
|
|
|
ALTER TABLE `exercise_tree_parents`
|
|
ADD COLUMN `sort` INT(3) NULL DEFAULT '0' AFTER `exercise_tree_child_id`;
|
|
|
|
UPDATE configuration set config_value = "1.0.27", date_change=CURRENT_DATE WHERE config_key = "db_version";
|
|
|
|
COMMIT;
|
|
|