Support for SET NULL, SET DEFAULT and NO ACTION in foreign key clauses for SQLite.

[dbsrgits/SQL-Translator.git] / t / data / sqlite / named.sql

diff --git a/t/data/sqlite/named.sql b/t/data/sqlite/named.sql
index 7e93878..3654690 100644 (file)
--- a/t/data/sqlite/named.sql
+++ b/t/data/sqlite/named.sql
@@ -1,7 +1,11 @@
 create table pet (
   "pet_id" int,
   "person_id" int
-    constraint fk_person_id references person(person_id),
+    constraint fk_person_id references person(person_id) on update CASCADE on delete RESTRICT,
+  "person_id_2" int
+    constraint fk_person_id_2 references person(person_id) on update SET NULL on delete SET DEFAULT,
+  "person_id_3" int
+    constraint fk_person_id_3 references person(person_id) on update NO ACTION,
   "name" varchar(30),
   "age" int,
   constraint age_under_100 check ( age < 100 ),