comparison: testdata.sql
testdata.sql
- changeset 52
- 8503be5eea49
- parent 33
- 106ff84c18ed
equal
deleted
inserted
replaced
| 51:e3163dc41a80 | 52:8503be5eea49 |
|---|---|
| 26 role_id integer primary key autoincrement, | 26 role_id integer primary key autoincrement, |
| 27 person_id integer, | 27 person_id integer, |
| 28 name text | 28 name text |
| 29 ); | 29 ); |
| 30 | 30 |
| 31 create table Resource( | |
| 32 resource_id integer primary key autoincrement, | |
| 33 parent_id integer references Resource(resource_id), | |
| 34 nodename text, | |
| 35 content text, | |
| 36 iscollection integer default 0 | |
| 37 ); | |
| 38 | |
| 39 create table Note( | |
| 40 note_id integer primary key autoincrement, | |
| 41 resource_id integer references Resource(resource_id), | |
| 42 tags text, | |
| 43 type int | |
| 44 ); | |
| 45 | |
| 31 insert into country (name) values ('Germany'); | 46 insert into country (name) values ('Germany'); |
| 32 | 47 |
| 33 insert into address (street, zip, city, country_id) | 48 insert into address (street, zip, city, country_id) |
| 34 values | 49 values |
| 35 ('street 1', '12343', 'city 17', 1), | 50 ('street 1', '12343', 'city 17', 1), |
| 44 (1, 'finance'), | 59 (1, 'finance'), |
| 45 (1, 'dev'), | 60 (1, 'dev'), |
| 46 (1, 'manager'), | 61 (1, 'manager'), |
| 47 (2, 'extern'); | 62 (2, 'extern'); |
| 48 | 63 |
| 64 insert into Resource(nodename, iscollection) | |
| 65 values | |
| 66 ('root', 1); | |
| 67 | |
| 68 insert into Resource(parent_id, nodename, iscollection) | |
| 69 values | |
| 70 ((select resource_id from Resource where nodename = 'root'), 'Collection1', 1); | |
| 71 | |
| 72 insert into Resource(parent_id, nodename, iscollection) | |
| 73 values | |
| 74 ((select resource_id from Resource where nodename = 'root'), 'Collection2', 1); | |
| 75 | |
| 76 insert into Resource(parent_id, nodename, content) | |
| 77 values | |
| 78 ((select resource_id from Resource where nodename = 'Collection1'), 'note1', 'Hello World!'); | |
| 79 | |
| 80 insert into Resource(parent_id, nodename, content) | |
| 81 values | |
| 82 ((select resource_id from Resource where nodename = 'Collection1'), 'note2', 'Test String'); | |
| 83 | |
| 84 insert into Resource(parent_id, nodename, content) | |
| 85 values | |
| 86 ((select resource_id from Resource where nodename = 'Collection2'), 'note3', 'Content Text'); | |
| 87 | |
| 88 insert into Note(resource_id, tags, type) | |
| 89 values | |
| 90 ((select resource_id from Resource where nodename = 'note1'), 'todo, test', 1); | |
| 91 | |
| 92 insert into Note(resource_id, tags, type) | |
| 93 values | |
| 94 ((select resource_id from Resource where nodename = 'note2'), 'work, project2501, ai', 2); | |
| 95 | |
| 96 insert into Note(resource_id, tags, type) | |
| 97 values | |
| 98 ((select resource_id from Resource where nodename = 'note3'), 'finance', 3); | |
| 99 |
