X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fdb%2FTemplateAccount.java;h=8651e3fee09ba66ac857788e30a62e0e04894e84;hb=32ad05360ecf167803ef0bf9c7938c52b348123e;hp=c662ff1c18092121ebf6f6b74bbffe1ec98be595;hpb=3ab99e1679326277d6ba7f8ce28f17a96dfa07aa;p=mobile-ledger.git

diff --git a/app/src/main/java/net/ktnx/mobileledger/db/TemplateAccount.java b/app/src/main/java/net/ktnx/mobileledger/db/TemplateAccount.java
index c662ff1c..8651e3fe 100644
--- a/app/src/main/java/net/ktnx/mobileledger/db/TemplateAccount.java
+++ b/app/src/main/java/net/ktnx/mobileledger/db/TemplateAccount.java
@@ -30,9 +30,11 @@ import org.jetbrains.annotations.NotNull;
         indices = {@Index(name = "fk_template_accounts_template", value = "template_id"),
                    @Index(name = "fk_template_accounts_currency", value = "currency")
         }, foreignKeys = {@ForeignKey(childColumns = "template_id", parentColumns = "id",
-                                      entity = TemplateHeader.class),
+                                      entity = TemplateHeader.class, onDelete = ForeignKey.CASCADE,
+                                      onUpdate = ForeignKey.RESTRICT),
                           @ForeignKey(childColumns = "currency", parentColumns = "id",
-                                      entity = Currency.class)
+                                      entity = Currency.class, onDelete = ForeignKey.RESTRICT,
+                                      onUpdate = ForeignKey.RESTRICT)
 })
 public class TemplateAccount extends TemplateBase {
     @PrimaryKey(autoGenerate = true)