From 96bbc85d31daa03bea2e017c590329977411c1c5 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 15 May 2014 16:07:10 +0800 Subject: [PATCH] sql/Person.sql --- sql/Person.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/sql/Person.sql b/sql/Person.sql index 14bb95d7..5f5dbc12 100644 --- a/sql/Person.sql +++ b/sql/Person.sql @@ -49,8 +49,11 @@ ALTER TABLE Person ADD COLUMN country TEXT NOT NULL DEFAULT ''; ALTER TABLE Person ADD COLUMN city TEXT NOT NULL DEFAULT ''; ALTER TABLE Person ADD COLUMN addr_state TEXT NOT NULL DEFAULT ''; -ALTER TABLE Person MODIFY COLUMN country INT(11) NOT NULL DEFAULT 0; -ALTER TABLE Person MODIFY COLUMN city INT(11) NOT NULL DEFAULT 0; +ALTER TABLE Person DROP COLUMN country; +ALTER TABLE Person DROP COLUMN city; + +ALTER TABLE Person ADD COLUMN country_id INT(11) NOT NULL DEFAULT 0; +ALTER TABLE Person ADD COLUMN city_id INT(11) NOT NULL DEFAULT 0; # old mysql -- 2.39.2