From d9e46b7f32eaf354bc246f23d732bc9d2d8877a7 Mon Sep 17 00:00:00 2001 From: Marius Peter Date: Tue, 1 Apr 2025 14:39:46 +0200 Subject: Indent SQL statements. --- bible.sql | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) diff --git a/bible.sql b/bible.sql index cca22b5..4892c61 100644 --- a/bible.sql +++ b/bible.sql @@ -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 -- cgit v1.2.3