9 lines
453 B
SQL
9 lines
453 B
SQL
ALTER TABLE `exercise_plan`
|
|
ADD COLUMN `customer_id` INT(11) NOT NULL DEFAULT '0' AFTER `exercise_plan_id`,
|
|
ADD COLUMN `private` TINYINT(4) NULL DEFAULT '0' AFTER `description`,
|
|
ADD COLUMN `date_add` DATETIME NULL AFTER `private`;
|
|
|
|
ALTER TABLE `exercise_plan_detail`
|
|
CHANGE COLUMN `repeat` `repeats` INT(11) NULL DEFAULT NULL AFTER `serie`;
|
|
|
|
UPDATE configuration set config_value = "1.0.7", date_change=CURRENT_DATE WHERE config_key = "db_version"; |