------------------------------------------------------------ revno: 268 committer: Seif Lotfy <s...@lotfy.com> 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 : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp