USE sofia;
DROP TABLE IF EXISTS sofia.GeorgeNoyesBible_1869__lemma;
CREATE TABLE GeorgeNoyesBible_1869__lemma (
  verseID VARCHAR(16) NOT NULL PRIMARY KEY,
  canon_order VARCHAR(12) NOT NULL,
  book VARCHAR(3) NOT NULL,
  chapter VARCHAR(3) NOT NULL,
  startVerse VARCHAR(3) NOT NULL,
  endVerse VARCHAR(3) NOT NULL,
  verseText TEXT CHARACTER SET UTF8 NOT NULL) ENGINE=MyISAM;
LOCK TABLES GeorgeNoyesBible_1869__lemma WRITE;
ALTER TABLE GeorgeNoyesBible_1869__lemma ADD FULLTEXT(verseText);
UNLOCK TABLES;
