Sunbelt Computer Software

PL/B Language Development and Support

sdow/sql/createPagesTable.sql at main · jwngr/sdow · GitHub

12 lines (10 loc) · 235 Bytes

CREATE TABLE IF NOT EXISTS pages
  id INTEGER PRIMARY KEY,
  title TEXT NOT NULL,
  is_redirect INTEGER NOT NULL 
.separator "\t"
.import /dev/stdin pages
CREATE INDEX pages_title_index ON pages(title COLLATE NOCASE);