From 5764d8db50feba6b8e81069a83e717aaa353e229 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 13 Jan 2012 17:49:23 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) 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); -- 2.39.2