zeitgeist team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 272
fixes bug(s): https://launchpad.net/bugs/815076
committer: Siegfried-Angel Gevatter Pujals <siegfried@xxxxxxxxxxxx>
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
                 """);
         }