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
8c5ed4b
..
161593b
100644
(file)
--- a/
DataObjects/core.sql
+++ b/
DataObjects/core.sql
@@
-97,7
+97,7
@@
ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_
ALTER TABLE Events ADD INDEX lookuppt ( person_table);
--# speeding up lookups.
ALTER TABLE Events ADD INDEX lookuppt ( person_table);
--# speeding up lookups.
-ALTER TABLE Events ADD INDEX lookup_when( person_id, event_
id
);
+ALTER TABLE Events ADD INDEX lookup_when( person_id, event_
when
);
ALTER TABLE Events add index lookup_event_when (event_when);
ALTER TABLE Events add index lookup_action (action);
ALTER TABLE Events add index lookup_event_when (event_when);
ALTER TABLE Events add index lookup_action (action);
@@
-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,
@@
-292,13
+293,14
@@
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 ALTER COLUMN mimetype mimetype varchar(128) NOT NULL default '';
+ALTER TABLE Images CHANGE COLUMN mimetype mimetype varchar(128) NOT NULL default '';
+ALTER TABLE Images ALTER COLUMN 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.
+
--
// old core image type - merged into enum.
DROP TABLE core_image_type;
DROP TABLE core_image_type;