sql/Person.sql

diff --git a/sql/Person.sql b/sql/Person.sql
index b88477e..47fe141 100644 (file)
--- a/sql/Person.sql
+++ b/sql/Person.sql
@@ -38,7 +38,8 @@ ALTER TABLE Person ADD COLUMN   alt_email VARCHAR(256) NULL ;
 
 ALTER TABLE Person ADD COLUMN   office_id int(11) NOT NULL  default '0';
 ALTER TABLE Person ADD COLUMN   company_id int(11) NOT NULL  default '0';
-
+ALTER TABLE Person CHANGE COLUMN   office_id office_id int(11) NOT NULL  default '0';
+ALTER TABLE Person CHANGE COLUMN   company_id company_id int(11) NOT NULL  default '0';