workouttest_server/data/db/update_1_0_10.sql
2020-10-25 12:13:30 +01:00

7 lines
279 B
SQL

ALTER TABLE `customer`
ADD COLUMN `firebase_uid` CHAR(50) NULL DEFAULT NULL AFTER `body_type`;
ALTER TABLE `customer`
ADD UNIQUE INDEX `firebase_uid` (`firebase_uid`);
UPDATE configuration set config_value = "1.0.10", date_change=CURRENT_DATE WHERE config_key = "db_version";