-- MySQL dump 10.14  Distrib 5.5.50-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: ntvmr
-- ------------------------------------------------------
-- Server version	5.5.50-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `BIBLICALCONTENT`
--

DROP TABLE IF EXISTS `BIBLICALCONTENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `BIBLICALCONTENT` (
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) NOT NULL,
  `VERSE` int(11) NOT NULL,
  `INSTITUTIONID` int(11) DEFAULT NULL,
  `USERID` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CREATEDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`DOCUMENTID`,`PAGEID`,`VERSE`),
  KEY `BIBLICALCONTENTVERSE` (`VERSE`,`DOCUMENTID`,`PAGEID`),
  KEY `BIBLICALCONTENTCREATEDATE` (`CREATEDATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DOCUMENT`
--

DROP TABLE IF EXISTS `DOCUMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOCUMENT` (
  `DOCUMENTID` int(11) NOT NULL,
  `GANUMBER` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `GAPOST` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ORIGINYEARDESCRIPTION` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ORIGINYEAREARLY` int(11) DEFAULT NULL,
  `ORIGINYEARLATE` int(11) DEFAULT NULL,
  `LEAVESDESCRIPTION` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LEAVES` int(11) DEFAULT NULL,
  `DUBIOUS` int(11) DEFAULT NULL,
  `FORMERGANUMBER` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTENTOVERVIEW` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `LANGUAGE` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUPPLEMENTOF` int(11) DEFAULT NULL,
  `PALEMPSESTUNDER` tinyint(1) DEFAULT NULL,
  `PALEMPSESTOTHER` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FORMATSCROLL` tinyint(1) DEFAULT NULL,
  `COLUMNS` int(11) DEFAULT NULL,
  `COLUMNSMAX` int(11) DEFAULT NULL,
  `LINECOUNTDESCRIPTION` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LINECOUNT` int(11) DEFAULT NULL,
  `LINECOUNTMAX` int(11) DEFAULT NULL,
  `HEIGHTDESCRIPTION` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HEIGHT` int(11) DEFAULT NULL,
  `HEIGHTMAX` int(11) DEFAULT NULL,
  `WIDTHDESCRIPTION` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WIDTH` int(11) DEFAULT NULL,
  `WIDTHMAX` int(11) DEFAULT NULL,
  `KLFOOTNOTES` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COMMENT` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESTROYED` tinyint(1) DEFAULT NULL,
  `USERID` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `GROUPID` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `V11N` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DOCUMENTID`),
  KEY `DOCGANUMBER` (`GANUMBER`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DOCUMENTGROUP`
--

DROP TABLE IF EXISTS `DOCUMENTGROUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOCUMENTGROUP` (
  `DOCUMENTGROUPID` int(11) NOT NULL AUTO_INCREMENT,
  `USERID` varchar(60) DEFAULT NULL,
  `NAME` varchar(80) DEFAULT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `GROUPID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`DOCUMENTGROUPID`),
  KEY `DOCUMENTGROUPUSERID` (`USERID`),
  KEY `DOCUMENTGROUPGROUP` (`GROUPID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DOCUMENTGROUPDOCUMENT`
--

DROP TABLE IF EXISTS `DOCUMENTGROUPDOCUMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOCUMENTGROUPDOCUMENT` (
  `DOCUMENTGROUPID` int(11) NOT NULL,
  `DOCUMENTID` int(11) NOT NULL,
  PRIMARY KEY (`DOCUMENTGROUPID`,`DOCUMENTID`),
  KEY `DOCUMENTGROUPDOC` (`DOCUMENTID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FEATURE`
--

DROP TABLE IF EXISTS `FEATURE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `FEATURE` (
  `FEATUREID` int(11) NOT NULL AUTO_INCREMENT,
  `FEATURECODE` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) DEFAULT NULL,
  `SURROGATEINSTITUTIONID` int(11) DEFAULT NULL,
  `SURROGATEID` int(11) DEFAULT NULL,
  `USERINSTITUTIONID` int(11) DEFAULT NULL,
  `USERID` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CREATEDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `STRINGVAL1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `STRINGVAL2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTVAL1` int(11) DEFAULT NULL,
  `INTVAL2` int(11) DEFAULT NULL,
  `DATEVAL1` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DATEVAL2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `REGIONAREAUPPER` int(11) DEFAULT NULL,
  `REGIONAREALEFT` int(11) DEFAULT NULL,
  `REGIONAREALOWER` int(11) DEFAULT NULL,
  `REGIONAREARIGHT` int(11) DEFAULT NULL,
  `PROSE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CLIPCACHEURL` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CLIPCACHETHUMBURL` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CLIPCACHEREGIONAREACHECK` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`FEATUREID`),
  KEY `DOCFEATURE` (`DOCUMENTID`,`PAGEID`,`FEATURECODE`),
  KEY `DOCFEATURESV1` (`DOCUMENTID`,`FEATURECODE`,`STRINGVAL1`),
  KEY `FEATURECREATEDATE` (`CREATEDATE`),
  KEY `FEATUREINTVAL` (`FEATURECODE`,`INTVAL1`,`DOCUMENTID`,`PAGEID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FEATUREDEFINITION`
--

DROP TABLE IF EXISTS `FEATUREDEFINITION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `FEATUREDEFINITION` (
  `FEATURECODE` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `CATEGORY` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESCRIPTION` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FEATURECONSTRAINTS` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SURROGATEFEATURE` tinyint(1) DEFAULT '0',
  `NOTES` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MANUSCRIPTFEATURE` tinyint(1) DEFAULT '0',
  `LABELS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PAGEFEATURE` tinyint(1) DEFAULT '0',
  `USERID` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DIALOGJAVASCRIPT` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`FEATURECODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `INSTITUTION`
--

DROP TABLE IF EXISTS `INSTITUTION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `INSTITUTION` (
  `INSTITUTIONID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `KLNAME` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `KLNAMEABBREV` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ADDRESS1` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ADDRESS2` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PLACE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COUNTRY` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COUNTRY_DE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `POSTCODE` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INSTITUTIONURL` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COLLECTIONURL1` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COLLECTIONURL2` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LOGOURL1` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LOGOURL2` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTACTNAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTACTEMAIL` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTACTPHONE` varchar(65) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTACTFAX` varchar(65) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`INSTITUTIONID`),
  KEY `INSTITUTIONCOPLNM` (`COUNTRY`,`PLACE`,`NAME`),
  KEY `INSTITUTIONPLNM` (`PLACE`,`NAME`),
  KEY `INSTITUTIONNM` (`NAME`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PAGE`
--

DROP TABLE IF EXISTS `PAGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PAGE` (
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) NOT NULL,
  `SORTORDER` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FOLIONUMBER` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PAGECOLUMNS` int(11) DEFAULT NULL,
  `PAGELINES` int(11) DEFAULT NULL,
  `PAGEHEIGHT` int(11) DEFAULT NULL,
  `PAGEWIDTH` int(11) DEFAULT NULL,
  PRIMARY KEY (`DOCUMENTID`,`PAGEID`),
  KEY `PAGEDOCSORTORDER` (`DOCUMENTID`,`SORTORDER`,`PAGEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PROJECT`
--

DROP TABLE IF EXISTS `PROJECT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PROJECT` (
  `PROJECTID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(200) NOT NULL,
  `USERGROUP` varchar(80) DEFAULT NULL,
  `OBJECTPART` varchar(200) DEFAULT NULL,
  `DOCUMENTGROUPID` int(11) DEFAULT NULL,
  `TASKTYPEID` int(11) DEFAULT NULL,
  `CONFIGURATION` varchar(4096) DEFAULT NULL,
  `TRANSCRIPTIONATTRIBUTION` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`PROJECTID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `REGULARIZATIONRULE`
--

DROP TABLE IF EXISTS `REGULARIZATIONRULE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `REGULARIZATIONRULE` (
  `REGULARIZATIONRULEID` int(11) NOT NULL AUTO_INCREMENT,
  `USERID` varchar(200) DEFAULT NULL,
  `GROUPNAME` varchar(40) NOT NULL DEFAULT 'Unassigned',
  `CONTEXTVERSE` int(11) DEFAULT NULL,
  `SCOPE` int(11) DEFAULT NULL,
  `VISIBILITY` int(11) DEFAULT NULL,
  `TYPE` int(11) DEFAULT NULL,
  `SOURCEWORD` varchar(128) DEFAULT NULL,
  `TARGETWORD` varchar(128) DEFAULT NULL,
  `CONTEXTPRE` varchar(4096) DEFAULT NULL,
  `CONTEXTPOST` varchar(4096) DEFAULT NULL,
  `COMMENT` varchar(500) DEFAULT NULL,
  `RULEOPTIONS` int(11) DEFAULT '0',
  `CREATEDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`REGULARIZATIONRULEID`),
  KEY `CONTEXTVERSEIDX` (`CONTEXTVERSE`,`USERID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `REGULARIZATIONRULEEXCEPTION`
--

DROP TABLE IF EXISTS `REGULARIZATIONRULEEXCEPTION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `REGULARIZATIONRULEEXCEPTION` (
  `REGULARIZATIONRULEID` int(11) NOT NULL,
  `VERSE` int(11) NOT NULL,
  `GROUPNAME` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Unassigned',
  `USERID` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `CREATEDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`REGULARIZATIONRULEID`,`VERSE`,`GROUPNAME`,`USERID`),
  KEY `BIBLICALCONTENTVERSE` (`VERSE`,`GROUPNAME`,`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SEGMENT`
--

DROP TABLE IF EXISTS `SEGMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SEGMENT` (
  `SEGMENTID` int(11) NOT NULL AUTO_INCREMENT,
  `VERSE` int(11) NOT NULL,
  `SEGMENTNAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTEXTDESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORDSTART` int(11) NOT NULL,
  `WORDEND` int(11) NOT NULL,
  PRIMARY KEY (`SEGMENTID`),
  KEY `SEGMENTVERSE` (`VERSE`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SEGMENTGROUPSEGMENT`
--

DROP TABLE IF EXISTS `SEGMENTGROUPSEGMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SEGMENTGROUPSEGMENT` (
  `SEGMENTGROUPID` int(11) NOT NULL,
  `SEGMENTID` int(11) NOT NULL,
  PRIMARY KEY (`SEGMENTGROUPID`,`SEGMENTID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SEGMENTREADING`
--

DROP TABLE IF EXISTS `SEGMENTREADING`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SEGMENTREADING` (
  `SEGMENTREADINGID` int(11) NOT NULL AUTO_INCREMENT,
  `SEGMENTID` int(11) NOT NULL,
  `READINGNAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `READING` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`SEGMENTREADINGID`),
  KEY `SEGMENTREADINGSEGMENTID` (`SEGMENTID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SEGMENTREADINGWITNESS`
--

DROP TABLE IF EXISTS `SEGMENTREADINGWITNESS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SEGMENTREADINGWITNESS` (
  `SEGMENTID` int(11) NOT NULL,
  `SEGMENTREADINGID` int(11) NOT NULL,
  `DOCUMENTID` int(11) NOT NULL,
  `COMMENT` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `TRANSCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `HAND` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `UNSURE` tinyint(1) NOT NULL DEFAULT '0',
  `PROJECTID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`SEGMENTID`,`DOCUMENTID`,`HAND`,`PROJECTID`),
  KEY `SEGMENTREADINGWITNESSSRID` (`SEGMENTREADINGID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SHELFINSTANCE`
--

DROP TABLE IF EXISTS `SHELFINSTANCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SHELFINSTANCE` (
  `SHELFID` int(11) NOT NULL AUTO_INCREMENT,
  `INSTITUTIONID` int(11) DEFAULT NULL,
  `SHELFNUMBER` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FORMERGANUMBER` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CONTENTOVERVIEW` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LEAVESDESCRIPTION` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LEAVES` int(11) DEFAULT NULL,
  `ORIGINYEARDESCRIPTION` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `USERDATA` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`SHELFID`),
  UNIQUE KEY `USERDATA` (`USERDATA`),
  KEY `SHELFINSTANCEINSTITUTION` (`INSTITUTIONID`,`SHELFID`),
  KEY `SHELFINSTANCEUSERDATA` (`USERDATA`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SHELFINSTANCEPAGES`
--

DROP TABLE IF EXISTS `SHELFINSTANCEPAGES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SHELFINSTANCEPAGES` (
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) NOT NULL,
  `SHELFID` int(11) NOT NULL,
  `SORTORDER` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FOLIONUMBER` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DOCUMENTID`,`PAGEID`,`SHELFID`),
  KEY `SHELFINSTANCEPAGESSHELFINST` (`SHELFID`,`DOCUMENTID`,`PAGEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SURROGATEIMAGE`
--

DROP TABLE IF EXISTS `SURROGATEIMAGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SURROGATEIMAGE` (
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) NOT NULL,
  `INSTITUTIONID` int(11) NOT NULL,
  `SURROGATEID` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `SURROGATEDATE` datetime DEFAULT NULL,
  `SURROGATEPRODUCERID` int(11) DEFAULT NULL,
  `SURROGATEURI` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `THUMBNAILURI` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DISTRIBUTIONLICENSEID` int(11) DEFAULT NULL,
  `PAGESTARTX` int(11) DEFAULT NULL,
  `PAGESTARTY` int(11) DEFAULT NULL,
  `PAGEENDX` int(11) DEFAULT NULL,
  `PAGEENDY` int(11) DEFAULT NULL,
  `ATTRIBUTION` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CREATEDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `USERID` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACCESSROLE` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WEBFRIENDLYURL` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PROTECTLEVEL` int(11) DEFAULT '0',
  PRIMARY KEY (`DOCUMENTID`,`PAGEID`,`INSTITUTIONID`,`SURROGATEID`),
  KEY `SURROGATEIMAGECREATEDATE` (`CREATEDATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SURROGATETRANSCRIPTION`
--

DROP TABLE IF EXISTS `SURROGATETRANSCRIPTION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SURROGATETRANSCRIPTION` (
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) NOT NULL,
  `INSTITUTIONID` int(11) NOT NULL,
  `SURROGATEID` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `SURROGATEDATE` datetime DEFAULT NULL,
  `SURROGATEPRODUCERID` int(11) DEFAULT NULL,
  `SURROGATEURI` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DOCUMENTID`,`PAGEID`,`INSTITUTIONID`,`SURROGATEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TASK`
--

DROP TABLE IF EXISTS `TASK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TASK` (
  `TASKTYPEID` int(11) NOT NULL,
  `OBJECTID` int(11) NOT NULL,
  `OBJECTPART` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `CREATEDBY` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ASSIGNEDTO` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `PROJECTID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`TASKTYPEID`,`OBJECTID`,`ASSIGNEDTO`,`PROJECTID`,`OBJECTPART`),
  KEY `TASKASSIGNEDTO` (`ASSIGNEDTO`,`TASKTYPEID`,`OBJECTID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TASKTYPE`
--

DROP TABLE IF EXISTS `TASKTYPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TASKTYPE` (
  `TASKTYPEID` int(11) NOT NULL,
  `DESCRIPTION` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`TASKTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TRANSCRIPTIONPAGE`
--

DROP TABLE IF EXISTS `TRANSCRIPTIONPAGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TRANSCRIPTIONPAGE` (
  `DOCUMENTID` int(11) NOT NULL,
  `PAGEID` int(11) NOT NULL,
  `TRANSCRIPTION` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `USERID` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`DOCUMENTID`,`PAGEID`,`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TRANSCRIPTIONVERSE`
--

DROP TABLE IF EXISTS `TRANSCRIPTIONVERSE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TRANSCRIPTIONVERSE` (
  `DOCUMENTID` int(11) NOT NULL,
  `VERSE` int(11) NOT NULL,
  `TRANSCRIPTION` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `USERID` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`DOCUMENTID`,`VERSE`,`USERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-10-27  0:58:21
