sql/Person.sql

diff --git a/sql/Person.sql b/sql/Person.sql
index 5f5dbc1..28c6cd0 100644 (file)
--- 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