summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMarius Peter <marius.peter@tutanota.com>2025-04-01 14:39:46 +0200
committerMarius Peter <marius.peter@tutanota.com>2025-04-01 14:39:46 +0200
commitd9e46b7f32eaf354bc246f23d732bc9d2d8877a7 (patch)
tree8a2c5a103b9c638f258cc635ed3e30068ae741aa
parent004068102be1ae4787f7e0deeebfb60c2c7deee7 (diff)
Indent SQL statements.HEADmaster
-rw-r--r--bible.sql24
1 files 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
Copyright 2019--2025 Marius PETER