diff options
| -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 |