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