From dfbb13f85eb894100a1cd888d07a9768c8130999 Mon Sep 17 00:00:00 2001 From: Edward Date: Tue, 20 May 2014 17:33:13 +0800 Subject: [PATCH] sql/Person.sql --- sql/Person.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/Person.sql b/sql/Person.sql index 5f5dbc12..28c6cd0b 100644 --- a/sql/Person.sql +++ b/sql/Person.sql @@ -51,9 +51,11 @@ ALTER TABLE Person ADD COLUMN addr_state TEXT NOT NULL DEFAULT ''; ALTER TABLE Person DROP COLUMN country; ALTER TABLE Person DROP COLUMN city; +ALTER TABLE Person DROP COLUMN addr_state; 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; +ALTER TABLE Person ADD COLUMN division INT(11) NOT NULL DEFAULT 0; # old mysql -- 2.39.2