------------------------------------------------------------ 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