comparison: testdata.sql
testdata.sql
- changeset 26
- dc36aa437249
equal
deleted
inserted
replaced
| 25:0bb91d1f9bba | 26:dc36aa437249 |
|---|---|
| 1 | |
| 2 create table Person( | |
| 3 person_id integer primary key autoincrement, | |
| 4 name text, | |
| 5 email text, | |
| 6 age integer, | |
| 7 iscustomer integer, | |
| 8 hash integer, | |
| 9 address_id integer | |
| 10 ); | |
| 11 | |
| 12 create table Address( | |
| 13 address_id integer primary key autoincrement, | |
| 14 street text, | |
| 15 zip text, | |
| 16 city text | |
| 17 ); | |
| 18 | |
| 19 create table Role( | |
| 20 role_id integer primary key autoincrement, | |
| 21 person_id integer, | |
| 22 name text | |
| 23 ); | |
| 24 | |
| 25 insert into address (street, zip, city) | |
| 26 values | |
| 27 ('street 1', '12343', 'city 17'), | |
| 28 ('street 2', '23456', 'city 18'); | |
| 29 | |
| 30 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')), | |
| 32 ('bob', 'bob@example.com', 25, 1, 987654321, (select address_id from address where street = 'street 2')); | |
| 33 | |
| 34 insert into role (person_id, name) | |
| 35 values | |
| 36 (1, 'finance'), | |
| 37 (1, 'dev'), | |
| 38 (1, 'manager'), | |
| 39 (2, 'extern'); | |
| 40 |
