diff options
| author | Dominik <dominik@dominikschuermann.de> | 2012-10-31 18:00:40 +0100 |
|---|---|---|
| committer | Dominik <dominik@dominikschuermann.de> | 2012-10-31 18:00:40 +0100 |
| commit | 46e9b507f199bbc03da76bc9a810bfbdb2bae671 (patch) | |
| tree | af87331fd554f0f0c79dda85f26900cdf3193654 | |
| parent | 1e96cf8fe9b97b9ddea2339cdffc3b4b00bf6484 (diff) | |
| download | open-keychain-46e9b507f199bbc03da76bc9a810bfbdb2bae671.tar.gz open-keychain-46e9b507f199bbc03da76bc9a810bfbdb2bae671.tar.bz2 open-keychain-46e9b507f199bbc03da76bc9a810bfbdb2bae671.zip | |
fix foreign key definition in create statement
| -rw-r--r-- | org_apg/src/org/thialfihar/android/apg/provider/ApgDatabase.java | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/org_apg/src/org/thialfihar/android/apg/provider/ApgDatabase.java b/org_apg/src/org/thialfihar/android/apg/provider/ApgDatabase.java index 050320cb6..e25fce3f0 100644 --- a/org_apg/src/org/thialfihar/android/apg/provider/ApgDatabase.java +++ b/org_apg/src/org/thialfihar/android/apg/provider/ApgDatabase.java @@ -50,15 +50,17 @@ public class ApgDatabase extends SQLiteOpenHelper { + " INTEGER, " + KeysColumns.ALGORITHM + " INTEGER, " + KeysColumns.KEY_SIZE + " INTEGER, " + KeysColumns.CAN_SIGN + " INTEGER, " + KeysColumns.CAN_ENCRYPT + " INTEGER, " + KeysColumns.IS_REVOKED + " INTEGER, " + KeysColumns.CREATION - + " INTEGER, " + KeysColumns.EXPIRY + " INTEGER, " + KeysColumns.KEY_RING_ROW_ID - + " INTEGER REFERENCES " + Tables.KEY_RINGS + " ON DELETE CASCADE, " - + KeysColumns.KEY_DATA + " BLOB," + KeysColumns.RANK + " INTEGER)"; + + " INTEGER, " + KeysColumns.EXPIRY + " INTEGER, " + KeysColumns.KEY_DATA + " BLOB," + + KeysColumns.RANK + " INTEGER, " + KeysColumns.KEY_RING_ROW_ID + + " INTEGER NOT NULL, FOREIGN KEY(" + KeysColumns.KEY_RING_ROW_ID + ") REFERENCES " + + Tables.KEY_RINGS + "(" + BaseColumns._ID + ") ON DELETE CASCADE)"; private static final String CREATE_USER_IDS = "CREATE TABLE IF NOT EXISTS " + Tables.USER_IDS + " (" + BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " - + UserIdsColumns.KEY_RING_ROW_ID + " INTEGER REFERENCES " + Tables.KEY_RINGS - + " ON DELETE CASCADE, " + UserIdsColumns.USER_ID + " TEXT, " + UserIdsColumns.RANK - + " INTEGER)"; + + UserIdsColumns.USER_ID + " TEXT, " + UserIdsColumns.RANK + " INTEGER, " + + UserIdsColumns.KEY_RING_ROW_ID + " INTEGER NOT NULL, FOREIGN KEY(" + + UserIdsColumns.KEY_RING_ROW_ID + ") REFERENCES " + Tables.KEY_RINGS + "(" + + BaseColumns._ID + ") ON DELETE CASCADE)"; ApgDatabase(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); |