zeitgeist team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 268
committer: Seif Lotfy <seif@xxxxxxxxx>
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