X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fmake_dbictest_db_with_unique.pm;h=a0b47bfaf14ac632f214a48f23bc0b0718bfb293;hb=667f1a0b6967917848f772066253dc4404fa9d32;hp=87c7316be43830b524e55907d0e46ea66cea29f3;hpb=40914006707afe9088ccd94cc7bcc1c2723c658d;p=dbsrgits%2FDBIx-Class-Schema-Loader.git

diff --git a/t/lib/make_dbictest_db_with_unique.pm b/t/lib/make_dbictest_db_with_unique.pm
index 87c7316..a0b47bf 100644
--- a/t/lib/make_dbictest_db_with_unique.pm
+++ b/t/lib/make_dbictest_db_with_unique.pm
@@ -3,15 +3,18 @@ package make_dbictest_db_with_unique;
 use strict;
 use warnings;
 use DBI;
+use dbixcsl_test_dir qw/$tdir/;
+
 
 eval { require DBD::SQLite };
 my $class = $@ ? 'SQLite2' : 'SQLite';
 
-my $fn = './t/dbictest_with_unique.db';
+my $fn = "$tdir/dbictest_with_unique.db";
 
 unlink($fn);
 our $dsn = "dbi:$class:dbname=$fn";
 my $dbh = DBI->connect($dsn);
+$dbh->do('PRAGMA SYNCHRONOUS = OFF');
 
 $dbh->do($_) for (
     q|CREATE TABLE foos (
@@ -36,6 +39,11 @@ $dbh->do($_) for (
         id INTEGER PRIMARY KEY,
         quuxs_id INTEGER REFERENCES quuxs (quuxid)
       )|,
+    q|CREATE TABLE RouteChange (
+        id INTEGER PRIMARY KEY,
+        QuuxsId INTEGER REFERENCES quuxs (quuxid),
+        Foo2Bar INTEGER
+      )|,
     q|CREATE TABLE email (
         id INTEGER PRIMARY KEY,
         to_id INTEGER REFERENCES foos (fooid),
@@ -54,6 +62,7 @@ $dbh->do($_) for (
     q|INSERT INTO quuxs VALUES (1,20)|,
     q|INSERT INTO quuxs VALUES (2,19)|,
     q|INSERT INTO stations_visited VALUES (1,1)|,
+    q|INSERT INTO RouteChange VALUES (1,1,3)|,
 );
 
 END { unlink($fn); }