mapguesser/database/migrations/structure/20200602_2331_geo_digits.sql

18 lines
328 B
MySQL
Raw Permalink Normal View History

2020-06-02 23:38:25 +02:00
ALTER TABLE
`maps`
MODIFY
`bound_south_lat` decimal(9, 7) NOT NULL,
MODIFY
`bound_west_lng` decimal(10, 7) NOT NULL,
MODIFY
`bound_north_lat` decimal(9, 7) NOT NULL,
MODIFY
`bound_east_lng` decimal(10, 7) NOT NULL;
ALTER TABLE
`places`
MODIFY
`lat` decimal(9, 7) NOT NULL,
MODIFY
`lng` decimal(10, 7) NOT NULL;