File: BibleDatabase.sql

package info (click to toggle)
widemargin 1.1.13-3.1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye
  • size: 10,032 kB
  • sloc: cs: 4,582; xml: 41; sql: 10; makefile: 6; sh: 3
file content (6 lines) | stat: -rw-r--r-- 319 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
 
BEGIN TRANSACTION;
CREATE VIRTUAL TABLE Verse USING fts4(Book TEXT, Chapter NUMERIC, VerseNumber NUMERIC, Contents TEXT);
CREATE TABLE ReadingPlanner (Day NUMERIC, Month NUMERIC, FirstPortion TEXT, SecondPortion Text, ThirdPortion Text);
CREATE TABLE Settings (Version NUMERIC);
INSERT INTO Settings VALUES (1);
COMMIT;