|
add files
|
1 |
create table book ( |
| 2 |
row_id integer primary key autoincrement, |
|
| 3 |
id not null unique, |
|
| 4 |
name not null |
|
| 5 |
); |
|
| 6 | ||
| 7 |
create table section( |
|
| 8 |
row_id integer primary key autoincrement, |
|
| 9 |
book_id not null, |
|
| 10 |
chapter integer not null, |
|
| 11 |
section integer not null, |
|
| 12 |
content not null, |
|
| 13 |
unique(book_id, chapter, section) |
|
| 14 |
); |