Mercurial > hg > dbutils / file comparison

comparison: testdata.sql

testdata.sql

changeset 33
106ff84c18ed
parent 26
dc36aa437249
equal deleted inserted replaced
32:6bd927c1cb11 33:106ff84c18ed
7 iscustomer integer, 7 iscustomer integer,
8 hash integer, 8 hash integer,
9 address_id integer 9 address_id integer
10 ); 10 );
11 11
12 create table Country(
13 country_id integer primary key autoincrement,
14 name text
15 );
16
12 create table Address( 17 create table Address(
13 address_id integer primary key autoincrement, 18 address_id integer primary key autoincrement,
14 street text, 19 street text,
15 zip text, 20 zip text,
16 city text 21 city text,
22 country_id integer references Country(country_id)
17 ); 23 );
18 24
19 create table Role( 25 create table Role(
20 role_id integer primary key autoincrement, 26 role_id integer primary key autoincrement,
21 person_id integer, 27 person_id integer,
22 name text 28 name text
23 ); 29 );
24 30
25 insert into address (street, zip, city) 31 insert into country (name) values ('Germany');
32
33 insert into address (street, zip, city, country_id)
26 values 34 values
27 ('street 1', '12343', 'city 17'), 35 ('street 1', '12343', 'city 17', 1),
28 ('street 2', '23456', 'city 18'); 36 ('street 2', '23456', 'city 18', 1);
29 37
30 insert into person (name, email, age, iscustomer, hash, address_id) values 38 insert into person (name, email, age, iscustomer, hash, address_id) values
31 ('alice', 'alice@example.com', 30, 0, 123456789, (select address_id from address where street = 'street 1')), 39 ('alice', 'alice@example.com', 30, 0, 123456789, (select address_id from address where street = 'street 1')),
32 ('bob', 'bob@example.com', 25, 1, 987654321, (select address_id from address where street = 'street 2')); 40 ('bob', 'bob@example.com', 25, 1, 987654321, (select address_id from address where street = 'street 2'));
33 41

Mercurial Repository: dbutils

mercurial