diff --git a/documentation/database/patches/patch-11.sql b/documentation/database/patches/patch-11.sql new file mode 100644 index 0000000..03d5c88 --- /dev/null +++ b/documentation/database/patches/patch-11.sql @@ -0,0 +1,4 @@ +-- allow NULL on these Location columns to support online Room(s) that has not an address +ALTER TABLE `{$prefix}location` MODIFY COLUMN `location_address` VARCHAR(100); +ALTER TABLE `{$prefix}location` MODIFY COLUMN `location_lat` FLOAT; +ALTER TABLE `{$prefix}location` MODIFY COLUMN `location_lng` FLOAT;