projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
2151d51
)
DataObjects/core.sql
author
Chris
<chris@roojs.com>
Tue, 11 Dec 2012 11:43:28 +0000
(19:43 +0800)
committer
Chris
<chris@roojs.com>
Tue, 11 Dec 2012 11:43:28 +0000
(19:43 +0800)
DataObjects/core.sql
patch
|
blob
|
history
diff --git
a/DataObjects/core.sql
b/DataObjects/core.sql
index
707a507
..
5a54b8d
100644
(file)
--- a/
DataObjects/core.sql
+++ b/
DataObjects/core.sql
@@
-193,6
+193,8
@@
ALTER TABLE Person ADD COLUMN deleted_dt DATETIME ;
ALTER TABLE Person ADD COLUMN firstname varchar(128) NOT NULL DEFAULT '';
ALTER TABLE Person ADD COLUMN lastname varchar(128) NOT NULL DEFAULT '';
ALTER TABLE Person ADD COLUMN firstname varchar(128) NOT NULL DEFAULT '';
ALTER TABLE Person ADD COLUMN lastname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE `clipping_dev`.`Person` ADD COLUMN `name_facebook` VARCHAR(128) NULL AFTER `crm_type_id` , ADD COLUMN `url_blog` VARCHAR(256) NULL AFTER `name_facebook` , ADD COLUMN `url_twitter` VARCHAR(256) NULL AFTER `url_blog` , ADD COLUMN `url_linkedin` VARCHAR(256) NULL AFTER `url_twitter` ;
+
# old mysql
# old mysql