------------------------------------------------------------
revno: 272
fixes bug(s): https://launchpad.net/bugs/815076
committer: Siegfried-Angel Gevatter Pujals <siegfr...@gevatter.com>
branch nick: bluebird
timestamp: Wed 2011-09-21 19:14:36 +0200
message:
Add actor_uri field to event_view.
modified:
src/sql-schema.vala
--
lp:~zeitgeist/zeitgeist/bluebird
https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird
Your team Zeitgeist Framework Team is subscribed to branch
lp:~zeitgeist/zeitgeist/bluebird.
To unsubscribe from this branch go to
https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird/+edit-subscription
=== modified file 'src/sql-schema.vala'
--- src/sql-schema.vala 2011-09-19 14:12:03 +0000
+++ src/sql-schema.vala 2011-09-21 17:14:36 +0000
@@ -338,7 +338,10 @@
AS subj_current_uri,
event.subj_id_current,
event.subj_text AS subj_text_id,
- event.subj_storage AS subj_storage_id
+ event.subj_storage AS subj_storage_id,
+ (SELECT value FROM actor
+ WHERE actor.id=event.actor)
+ AS actor_uri
FROM event
""");
}
_______________________________________________
Mailing list: https://launchpad.net/~zeitgeist
Post to : zeitgeist@lists.launchpad.net
Unsubscribe : https://launchpad.net/~zeitgeist
More help : https://help.launchpad.net/ListHelp
