projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
ace9c1c
)
DataObjects/core.sql
author
Alan Knowles
<alan@akbkhome.com>
Fri, 13 Jan 2012 09:49:23 +0000
(17:49 +0800)
committer
Alan Knowles
<alan@akbkhome.com>
Fri, 13 Jan 2012 09:49:23 +0000
(17:49 +0800)
DataObjects/core.sql
patch
|
blob
|
history
diff --git
a/DataObjects/core.sql
b/DataObjects/core.sql
index
68571e0
..
af70b76
100644
(file)
--- 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 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 '';
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 ;
# 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 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);
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);