29 lines
1.0 KiB
SQL
29 lines
1.0 KiB
SQL
-- integrating scores, modify connections object to:
|
|
-- drop ip_address (text field)
|
|
-- add addr, locidispid, latitude, longitude, countrycode, region, city
|
|
-- note, this will force logout of everyone so that the new not null columns will be populated.
|
|
|
|
DELETE FROM connections;
|
|
|
|
-- ALTER TABLE connections DROP COLUMN ip_address;
|
|
|
|
ALTER TABLE connections ADD COLUMN addr BIGINT;
|
|
ALTER TABLE connections ALTER COLUMN addr SET NOT NULL;
|
|
|
|
ALTER TABLE connections ADD COLUMN locidispid INT;
|
|
ALTER TABLE connections ALTER COLUMN locidispid SET NOT NULL;
|
|
|
|
ALTER TABLE connections ADD COLUMN latitude DOUBLE PRECISION;
|
|
ALTER TABLE connections ALTER COLUMN latitude SET NOT NULL;
|
|
|
|
ALTER TABLE connections ADD COLUMN longitude DOUBLE PRECISION;
|
|
ALTER TABLE connections ALTER COLUMN longitude SET NOT NULL;
|
|
|
|
ALTER TABLE connections ADD COLUMN countrycode CHARACTER VARYING(2);
|
|
|
|
ALTER TABLE connections ADD COLUMN region CHARACTER VARYING(2);
|
|
|
|
ALTER TABLE connections ADD COLUMN city CHARACTER VARYING(255);
|
|
|
|
CREATE INDEX connections_locidispid_ndx ON connections (locidispid);
|