------------------------------------------------------------
revno: 268
committer: Seif Lotfy <[email protected]>
branch nick: bluebird
timestamp: Sun 2011-09-18 15:29:05 +0200
message:
added new extensions_conf table for extensions to store their data into
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-17 19:38:43 +0000
+++ src/sql-schema.vala 2011-09-18 13:29:05 +0000
@@ -281,6 +281,20 @@
""");
*/
+ // Extensions
+ exec_query (database, """
+ CREATE TABLE IF NOT EXISTS extensions_conf (
+ extension VARCHAR,
+ key VARCHAR,
+ value BLOB,
+ CONSTRAINT unique_extension UNIQUE (extension, key)
+ )
+ """);
+ exec_query (database, """
+ CREATE UNIQUE INDEX IF NOT EXISTS extensions_conf_key
+ ON extensions_conf (extension, key)
+ """);
+
exec_query (database, "DROP VIEW IF EXISTS event_view");
exec_query (database, """
CREATE VIEW IF NOT EXISTS event_view AS
_______________________________________________
Mailing list: https://launchpad.net/~zeitgeist
Post to : [email protected]
Unsubscribe : https://launchpad.net/~zeitgeist
More help : https://help.launchpad.net/ListHelp