USE sofia;
DROP TABLE IF EXISTS sofia.SeptuagintinAmericanEnglish_2012__lemma;
CREATE TABLE SeptuagintinAmericanEnglish_2012__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 SeptuagintinAmericanEnglish_2012__lemma WRITE;
ALTER TABLE SeptuagintinAmericanEnglish_2012__lemma ADD FULLTEXT(verseText);
UNLOCK TABLES;
