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