Files
spot/config/db/update_v20_to_v21.sql
2023-11-07 19:41:28 +01:00

3 lines
180 B
SQL

ALTER TABLE medias ADD latitude DECIMAL(7,5) AFTER timezone;
ALTER TABLE medias ADD longitude DECIMAL(8,5) AFTER latitude;
ALTER TABLE medias ADD altitude SMALLINT AFTER longitude;