18 lines
603 B
SQL
18 lines
603 B
SQL
CREATE TABLE `exercise_result` (
|
|
`exercise_result_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`customer_id` INT(11) NOT NULL DEFAULT '0',
|
|
`exercise_id` INT(11) NULL DEFAULT '0',
|
|
`exercise_plan_id` INT(11) NULL DEFAULT '0',
|
|
`result_type` CHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_hungarian_ci',
|
|
`value` DOUBLE NOT NULL,
|
|
`date_from` DATETIME NULL DEFAULT NULL,
|
|
`date_to` DATETIME NULL DEFAULT NULL,
|
|
PRIMARY KEY (`exercise_result_id`) USING BTREE
|
|
)
|
|
COLLATE='utf8_hungarian_ci'
|
|
ENGINE=InnoDB
|
|
;
|
|
|
|
|
|
|
|
UPDATE configuration set config_value = "1.0.19", date_change=CURRENT_DATE WHERE config_key = "db_version"; |