database

A database of information used by Manna

Instructions to remove duplicates

sqlite3 manna_temp.db
CREATE TABLE IF NOT EXISTS cross_references (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    from_book       TEXT NOT NULL,
    from_chapter    INTEGER NOT NULL,
    from_verse      INTEGER NOT NULL,
    to_book         TEXT NOT NULL,
    to_chapter      INTEGER NOT NULL,
    to_verse_start  INTEGER,
    to_verse_end    INTEGER,
    votes           INTEGER NOT NULL DEFAULT 0,
    UNIQUE(from_book, from_chapter, from_verse, to_book, to_chapter, to_verse_start, to_verse_end) ON CONFLICT IGNORE
);
.mode insert cross_references
.read cross_references_with_duplicates.sql

.output cross_references.sql
SELECT * FROM cross_references;
.exit