3 lines
794 B
SQL
3 lines
794 B
SQL
ALTER TABLE `devices_locations` CHANGE `device_id` `device_id` INT(11) NOT NULL, CHANGE `location` `location` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
|
|
ALTER TABLE `devices_locations` CHANGE `location_country` `location_country` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `location_state` `location_state` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `location_county` `location_county` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `location_city` `location_city` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `location_geoapi` `location_geoapi` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL;
|