From: Alan Knowles <alan@akbkhome.com>
Date: Fri, 13 Jan 2012 09:49:23 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5764d8db50feba6b8e81069a83e717aaa353e229

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 68571e07..af70b762 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -157,7 +157,7 @@ ALTER TABLE Person ADD COLUMN   phone varchar(32)  NOT NULL  DEFAULT '';
 ALTER TABLE Person ADD COLUMN   fax varchar(32)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   email varchar(128)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   company_id int(11) default '0';
-ALTER TABLE Person ADD COLUMN   role varchar(32)  NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN   role varchar(254)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   active int(11) NOT NULL  default 1;
 ALTER TABLE Person ADD COLUMN   remarks text;
 ALTER TABLE Person ADD COLUMN   passwd varchar(64) NOT NULL  DEFAULT '';
@@ -172,6 +172,7 @@ ALTER TABLE Person ADD COLUMN deleted_dt DATETIME ;
 
 # old mysql
 alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;
+alter table Person change role role varchar(254);
 
 
 
@@ -327,7 +328,7 @@ alter table  core_watch ADD COLUMN    ontable varchar(128) NOT NULL DEFAULT '';
 alter table  core_watch ADD COLUMN   onid int(11) NOT NULL DEFAULT 0;
 alter table  core_watch ADD COLUMN   person_id int(11) NOT NULL DEFAULT 0;
 alter table  core_watch ADD COLUMN   event varchar(128) NOT NULL DEFAULT '';
-alter table  core_watch ADD COLUMN   medium varchar(128) NOT NULL DEFAULT '';
+alter table  core_watch ADD COLUMN   medium varchar(64) NOT NULL DEFAULT '';
 alter table  core_watch ADD COLUMN  active int(11) NOT NULL DEFAULT '1';
 
 ALTER TABLE core_watch ADD INDEX qlookup (ontable,onid,person_id,event,medium);