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

Reply via email to