Mercurial > hg > dbutils / file diff

--- a/testdata.sql	Mon Dec 29 18:09:43 2025 +0100
+++ b/testdata.sql	Tue Dec 30 21:05:46 2025 +0100
@@ -9,11 +9,17 @@
 	address_id integer
 );
 
+create table Country(
+	country_id integer primary key autoincrement,
+	name text
+);
+
 create table Address(
 	address_id integer primary key autoincrement,
 	street text,
 	zip text,
-	city text
+	city text,
+	country_id integer references Country(country_id)
 );
 
 create table Role(
@@ -22,10 +28,12 @@
 	name text
 );
 
-insert into address (street, zip, city) 
+insert into country (name) values ('Germany');
+
+insert into address (street, zip, city, country_id) 
 values 
-('street 1', '12343', 'city 17'), 
-('street 2', '23456', 'city 18');
+('street 1', '12343', 'city 17', 1), 
+('street 2', '23456', 'city 18', 1);
 
 insert into person (name, email, age, iscustomer, hash, address_id) values
 ('alice', 'alice@example.com', 30, 0, 123456789, (select address_id from address where street = 'street 1')),