SQL 30
Verses.sql By cbettis on 9th April 2022 01:07:08 PM
  1. CREATE TABLE vline(rwid INTEGER PRIMARY KEY AUTOINCREMENT, sourceid INTEGER, verseline text);
  2. CREATE TABLE SOURCE(rwid INTEGER PRIMARY KEY AUTOINCREMENT, sourcename text, byline text);
  3. CREATE INDEX line_srcid ON vline(sourceid);
  4. CREATE INDEX source_srcname ON SOURCE(sourcename);
  5. CREATE INDEX source_by ON SOURCE(byline);
  6. CREATE VIEW line (vid, verse, src, byline) AS SELECT v.rwid AS vid, v.verseline AS verse, s.sourcename AS src, s.byline FROM vline AS v LEFT JOIN SOURCE AS s ON v.sourceid = s.rwid;

Caracabe Heap is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.