diff options
author | Marius Peter <marius.peter@tutanota.com> | 2025-04-01 14:39:46 +0200 |
---|---|---|
committer | Marius Peter <marius.peter@tutanota.com> | 2025-04-01 14:39:46 +0200 |
commit | d9e46b7f32eaf354bc246f23d732bc9d2d8877a7 (patch) | |
tree | 8a2c5a103b9c638f258cc635ed3e30068ae741aa | |
parent | 004068102be1ae4787f7e0deeebfb60c2c7deee7 (diff) |
-rw-r--r-- | bible.sql | 24 |
1 files changed, 12 insertions, 12 deletions
@@ -1,6 +1,6 @@ CREATE TABLE parts ( - id INTEGER PRIMARY KEY, - name TEXT NOT NULL + id INTEGER PRIMARY KEY, + name TEXT NOT NULL ); INSERT INTO parts ("id", "name") VALUES @@ -14,10 +14,10 @@ INSERT INTO parts ("id", "name") VALUES (8, 'Apocalypse'); CREATE TABLE books ( - id INTEGER PRIMARY KEY, - name TEXT NOT NULL, - part_id INTEGER NOT NULL, - FOREIGN KEY (part_id) REFERENCES parts(id) + id INTEGER PRIMARY KEY, + name TEXT NOT NULL, + part_id INTEGER NOT NULL, + FOREIGN KEY (part_id) REFERENCES parts(id) ); INSERT INTO books ("id", "name", "part_id") VALUES @@ -89,12 +89,12 @@ INSERT INTO books ("id", "name", "part_id") VALUES (66, 'Apocalypse', 8); CREATE TABLE verses ( - id INTEGER PRIMARY KEY, - book_id INTEGER NOT NULL, - chapter INTEGER NOT NULL, - verse_number INTEGER NOT NULL, - text TEXT NOT NULL, - FOREIGN KEY (book_id) REFERENCES books(id) + id INTEGER PRIMARY KEY, + book_id INTEGER NOT NULL, + chapter INTEGER NOT NULL, + verse_number INTEGER NOT NULL, + text TEXT NOT NULL, + FOREIGN KEY (book_id) REFERENCES books(id) ); INSERT INTO verses ("id", "book_id", "chapter", "verse_number", "text") VALUES |