[chronojump/optional_foreign_keys] Adds UNIQUE constraint: needed because it's referenced by FOREIGN KEYs.



commit 00c65a4c1529efec4f1e8b16473ef5d032f4c3ab
Author: Carles Pina i Estany <carles pina cat>
Date:   Thu Sep 1 15:50:50 2016 +0100

    Adds UNIQUE constraint: needed because it's referenced by FOREIGN KEYs.

 src/sqlite/jump.cs   |    2 +-
 src/sqlite/jumpRj.cs |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/src/sqlite/jump.cs b/src/sqlite/jump.cs
index 4154bc7..fb91986 100644
--- a/src/sqlite/jump.cs
+++ b/src/sqlite/jump.cs
@@ -45,7 +45,7 @@ class SqliteJump : Sqlite
                        "uniqueID INTEGER PRIMARY KEY, " +
                        "personID INT, " +
                        "sessionID INT, " +
-                       "type TEXT, " +
+                       "type TEXT UNIQUE, " +
                        "tv FLOAT, " +
                        "tc FLOAT, " +
                        "fall FLOAT, " +  
diff --git a/src/sqlite/jumpRj.cs b/src/sqlite/jumpRj.cs
index 33ec354..c351c95 100644
--- a/src/sqlite/jumpRj.cs
+++ b/src/sqlite/jumpRj.cs
@@ -40,7 +40,7 @@ class SqliteJumpRj : SqliteJump
                        "uniqueID INTEGER PRIMARY KEY, " +
                        "personID INT, " +
                        "sessionID INT, " +
-                       "type TEXT, " + 
+                       "type TEXT UNIQUE, " +
                        "tvMax FLOAT, " +
                        "tcMax FLOAT, " +
                        "fall FLOAT, " +  


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]