9 lines
350 B
MySQL
9 lines
350 B
MySQL
|
ALTER TABLE connections ALTER COLUMN user_id SET NOT NULL;
|
||
|
|
ALTER TABLE connections ALTER COLUMN ip_address SET NOT NULL;
|
||
|
|
|
||
|
|
ALTER TABLE connections DROP COLUMN latitude;
|
||
|
|
ALTER TABLE connections DROP COLUMN longitude;
|
||
|
|
ALTER TABLE connections DROP COLUMN countrycode;
|
||
|
|
ALTER TABLE connections DROP COLUMN region;
|
||
|
|
ALTER TABLE connections DROP COLUMN city;
|