23 lines
600 B
SQL
23 lines
600 B
SQL
START TRANSACTION;
|
|
|
|
ALTER TABLE `exercise_plan_template_detail`
|
|
ADD COLUMN `sort` TINYINT(2) NULL DEFAULT NULL AFTER `resting_time`;
|
|
|
|
CREATE TABLE `customer_activity` (
|
|
`activity_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`customer_id` INT(14) NOT NULL DEFAULT '0',
|
|
`type` CHAR(50) NOT NULL COLLATE 'utf8_hungarian_ci',
|
|
`date_add` DATETIME NOT NULL,
|
|
`skipped` TINYINT(1) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`activity_id`) USING BTREE
|
|
)
|
|
COLLATE='utf8_hungarian_ci'
|
|
ENGINE=InnoDB
|
|
;
|
|
|
|
|
|
UPDATE configuration set config_value = "1.0.30", date_change=CURRENT_DATE WHERE config_key = "db_version";
|
|
|
|
COMMIT;
|
|
|