USE sofia;
DROP TABLE IF EXISTS sofia.हिन्दी_Hindi__lemma;
CREATE TABLE हिन्दी_Hindi__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 हिन्दी_Hindi__lemma WRITE;
ALTER TABLE हिन्दी_Hindi__lemma ADD FULLTEXT(verseText);
UNLOCK TABLES;
