DROP TABLE IF EXISTS ntconjectures.CONJECTURE;
CREATE TABLE ntconjectures.CONJECTURE (
  CONJID int(11) NOT NULL,
  INDEXSTART int(11) NOT NULL,
  INDEXEND int(11) NOT NULL,
  WORDSTART int(11) DEFAULT NULL,
  WORDEND int(11) DEFAULT NULL,
  OPERATION varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  MCTREADING varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  MCTCONTEXT varchar(8191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  CONJREADING varchar(1023) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  ATTESTED tinyint(1) DEFAULT NULL,
  EDALT tinyint(1) DEFAULT NULL,
  MISUNDERSTOOD tinyint(1) DEFAULT NULL,
  NESTLEPRESENT tinyint(1) DEFAULT NULL,
  PRIMARY KEY (CONJID),
  KEY VSTART (INDEXSTART),
  KEY VEND (INDEXEND),
  KEY CONJATTRS(ATTESTED,EDALT,MISUNDERSTOOD)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
