projects
/
Pman.Core
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
DataObjects/core.sql
[Pman.Core]
/
DataObjects
/
core.sql
diff --git
a/DataObjects/core.sql
b/DataObjects/core.sql
index
e9caeb4
..
310b77f
100644
(file)
--- a/
DataObjects/core.sql
+++ b/
DataObjects/core.sql
@@
-178,6
+178,7
@@
ALTER TABLE Office ADD COLUMN email varchar(128) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN country VARCHAR(4) NULL;
ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN country VARCHAR(4) NULL;
+ALTER TABLE Office ADD COLUMN display_name VARCHAR(4) NULL;
CREATE TABLE Person (
id int(11) NOT NULL auto_increment,
CREATE TABLE Person (
id int(11) NOT NULL auto_increment,
@@
-211,6
+212,8
@@
ALTER TABLE Person ADD COLUMN url_blog VARCHAR(256) NULL ;
ALTER TABLE Person ADD COLUMN url_twitter VARCHAR(256) NULL ;
ALTER TABLE Person ADD COLUMN url_linkedin VARCHAR(256) NULL ;
ALTER TABLE Person ADD COLUMN url_twitter VARCHAR(256) NULL ;
ALTER TABLE Person ADD COLUMN url_linkedin VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN phone_mobile varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN phone_direct varchar(32) NOT NULL DEFAULT '';
# old mysql
# old mysql
@@
-290,10
+293,11
@@
ALTER TABLE Images ADD COLUMN linkurl VARCHAR(254) DEFAULT '' NOT NULL;
ALTER TABLE Images ADD COLUMN descript TEXT DEFAULT '' NOT NULL;
ALTER TABLE Images ADD COLUMN title VARCHAR(128) DEFAULT '' NOT NULL;
ALTER TABLE Images ADD COLUMN descript TEXT DEFAULT '' NOT NULL;
ALTER TABLE Images ADD COLUMN title VARCHAR(128) DEFAULT '' NOT NULL;
+ALTER TABLE Images CHANGE COLUMN mimetype mimetype varchar(128) NOT NULL default '';
ALTER TABLE Images ADD INDEX lookup(ontable, onid);
ALTER TABLE Images ADD INDEX lookup(ontable, onid);
-
+ALTER TABLE Images ADD INDEX lookupc(created, ontable, onid);
#// old core image type - merged into enum.
DROP TABLE core_image_type;
#// old core image type - merged into enum.
DROP TABLE core_image_type;