14 lines
350 B
SQL
14 lines
350 B
SQL
START TRANSACTION;
|
|
|
|
ALTER TABLE `tutorial_steps`
|
|
CHANGE COLUMN `parent` `parent_id` INT(3) NOT NULL DEFAULT '0' AFTER `condition`;
|
|
|
|
ALTER TABLE `tutorial_steps`
|
|
ADD COLUMN `action` TINYINT NULL DEFAULT '0' AFTER `parent_id`;
|
|
|
|
|
|
UPDATE configuration set config_value = "1.0.34", date_change=CURRENT_DATE WHERE config_key = "db_version";
|
|
|
|
COMMIT;
|
|
|