sql/Person.sql

[Pman.Core] / sql / Person.sql

diff --git a/sql/Person.sql b/sql/Person.sql
index 51329ee..5f5dbc1 100644 (file)
--- a/sql/Person.sql
+++ b/sql/Person.sql
@@ -49,6 +49,12 @@ 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 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
 alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;