Mercurial > hg > dbutils / file diff

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/testdata.sql	Tue Dec 09 18:24:48 2025 +0100
@@ -0,0 +1,40 @@
+
+create table Person(
+	person_id integer primary key autoincrement,
+	name text,
+	email text,
+	age integer,
+	iscustomer integer,
+	hash integer,
+	address_id integer
+);
+
+create table Address(
+	address_id integer primary key autoincrement,
+	street text,
+	zip text,
+	city text
+);
+
+create table Role(
+	role_id integer primary key autoincrement,
+	person_id integer,
+	name text
+);
+
+insert into address (street, zip, city) 
+values 
+('street 1', '12343', 'city 17'), 
+('street 2', '23456', 'city 18');
+
+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')),
+('bob', 'bob@example.com', 25, 1, 987654321,  (select address_id from address where street = 'street 2'));
+
+insert into role (person_id, name) 
+values 
+(1, 'finance'), 
+(1, 'dev'), 
+(1, 'manager'), 
+(2, 'extern');
+