sql/Person.sql

[Pman.Core] / sql / Person.sql

diff --git a/sql/Person.sql b/sql/Person.sql
index 83232fc..5f5dbc1 100644 (file)
--- a/sql/Person.sql
+++ b/sql/Person.sql
@@ -47,6 +47,13 @@ ALTER TABLE Person ADD COLUMN countries VARCHAR(128) NOT NULL DEFAULT '';
 # this is store the person location
 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
@@ -58,4 +65,9 @@ alter table Person change email email varchar(254) NOT NULL DEFAULT '';
 
 ALTER TABLE Person ADD INDEX lookup_a(email, active);
 ALTER TABLE Person ADD INDEX lookup_b(email, active, company_id);
-ALTER TABLE Person add index lookup_owner(owner_id);
\ No newline at end of file
+ALTER TABLE Person add index lookup_owner(owner_id);
+
+ALTER TABLE Person ADD COLUMN chosen_title TEXT NOT NULL DEFAULT ''; 
+ALTER TABLE Person ADD COLUMN url_google_plus TEXT NOT NULL DEFAULT ''; 
+ALTER TABLE Person ADD COLUMN url_blog2 TEXT NOT NULL DEFAULT ''; 
+ALTER TABLE Person ADD COLUMN url_blog3 TEXT NOT NULL DEFAULT '';