CREATE TABLE BIBLICALCONTENT (
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT NOT NULL,
  VERSE BIGINT NOT NULL,
  INSTITUTIONID BIGINT DEFAULT NULL,
  USERID varchar(60) DEFAULT NULL,
  CREATEDATE timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
  PRIMARY KEY (DOCUMENTID,PAGEID,VERSE)
);
CREATE INDEX BIBLICALCONTENTVERSE ON BIBLICALCONTENT(VERSE,DOCUMENTID,PAGEID);
CREATE INDEX BIBLICALCONTENTCREATEDATE ON BIBLICALCONTENT(CREATEDATE);

CREATE TABLE DOCUMENT (
  DOCUMENTID BIGINT NOT NULL,
  GANUMBER varchar(20) NOT NULL,
  GAPOST varchar(20) DEFAULT NULL,
  ORIGINYEARDESCRIPTION varchar(40) DEFAULT NULL,
  ORIGINYEAREARLY BIGINT DEFAULT NULL,
  ORIGINYEARLATE BIGINT DEFAULT NULL,
  LEAVESDESCRIPTION varchar(80) DEFAULT NULL,
  LEAVES BIGINT DEFAULT NULL,
  DUBIOUS BIGINT DEFAULT NULL,
  CONTENTOVERVIEW varchar(500) DEFAULT NULL,
  LANGUAGE varchar(20) DEFAULT NULL,
  COLUMNS BIGINT DEFAULT NULL,
  COLUMNSMAX BIGINT DEFAULT NULL,
  LINECOUNTDESCRIPTION varchar(50) DEFAULT NULL,
  LINECOUNT BIGINT DEFAULT NULL,
  LINECOUNTMAX BIGINT DEFAULT NULL,
  HEIGHTDESCRIPTION varchar(50) DEFAULT NULL,
  HEIGHT BIGINT DEFAULT NULL,
  HEIGHTMAX BIGINT DEFAULT NULL,
  WIDTHDESCRIPTION varchar(50) DEFAULT NULL,
  WIDTH BIGINT DEFAULT NULL,
  WIDTHMAX BIGINT DEFAULT NULL,
  USERID varchar(60) DEFAULT NULL,
  GROUPID varchar(60) DEFAULT NULL,
  V11N varchar(60) DEFAULT NULL,
  PRIMARY KEY (DOCUMENTID)
);
CREATE INDEX DOCGANUMBER ON DOCUMENT(GANUMBER);

CREATE TABLE DOCUMENTGROUP (
  DOCUMENTGROUPID BIGINT 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)
);
CREATE INDEX DOCUMENTGROUPUSERID ON DOCUMENTGROUP(USERID);
CREATE INDEX DOCUMENTGROUPGROUP ON DOCUMENTGROUP(GROUPID);

CREATE TABLE DOCUMENTGROUPDOCUMENT (
  DOCUMENTGROUPID BIGINT NOT NULL,
  DOCUMENTID BIGINT NOT NULL,
  PRIMARY KEY (DOCUMENTGROUPID,DOCUMENTID)
);
CREATE INDEX DOCUMENTGROUPDOC ON DOCUMENTGROUPDOCUMENT(DOCUMENTID);

CREATE TABLE FEATURE (
  FEATUREID BIGINT NOT NULL AUTO_INCREMENT,
  FEATURECODE varchar(30) NOT NULL,
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT DEFAULT NULL,
  SURROGATEINSTITUTIONID BIGINT DEFAULT NULL,
  SURROGATEID BIGINT DEFAULT NULL,
  USERINSTITUTIONID BIGINT DEFAULT NULL,
  USERID varchar(60) DEFAULT NULL,
  CREATEDATE timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  STRINGVAL1 varchar(500) DEFAULT NULL,
  STRINGVAL2 varchar(500) DEFAULT NULL,
  INTVAL1 BIGINT DEFAULT NULL,
  INTVAL2 BIGINT DEFAULT NULL,
  DATEVAL1 timestamp DEFAULT NULL,
  DATEVAL2 timestamp DEFAULT NULL,
  REGIONAREAUPPER BIGINT DEFAULT NULL,
  REGIONAREALEFT BIGINT DEFAULT NULL,
  REGIONAREALOWER BIGINT DEFAULT NULL,
  REGIONAREARIGHT BIGINT DEFAULT NULL,
  PROSE varchar(255) DEFAULT NULL,
  CLIPCACHEURL varchar(200) DEFAULT NULL,
  CLIPCACHETHUMBURL varchar(200) DEFAULT NULL,
  CLIPCACHEREGIONAREACHECK varchar(50) DEFAULT NULL,
  PRIMARY KEY (FEATUREID)
);
CREATE INDEX DOCFEATURE ON FEATURE(DOCUMENTID,PAGEID,FEATURECODE);
CREATE INDEX DOCFEATURESV1 ON FEATURE(DOCUMENTID,FEATURECODE,STRINGVAL1);
CREATE INDEX FEATURECREATEDATE ON FEATURE(CREATEDATE);
CREATE INDEX FEATUREINTVAL ON FEATURE(FEATURECODE,INTVAL1,DOCUMENTID,PAGEID);

CREATE TABLE FEATUREDEFINITION (
  FEATURECODE varchar(30) NOT NULL DEFAULT '',
  CATEGORY varchar(30) DEFAULT NULL,
  DESCRIPTION varchar(200) DEFAULT NULL,
  FEATURECONSTRAINTS varchar(500) DEFAULT NULL,
  SURROGATEFEATURE TINYINT DEFAULT '0',
  NOTES varchar(500) DEFAULT NULL,
  MANUSCRIPTFEATURE TINYINT DEFAULT '0',
  LABELS varchar(250) DEFAULT NULL,
  PAGEFEATURE TINYINT DEFAULT '0',
  USERID varchar(60) DEFAULT NULL,
  PRIMARY KEY (FEATURECODE)
);

CREATE TABLE INSTITUTION (
  INSTITUTIONID BIGINT NOT NULL AUTO_INCREMENT,
  NAME varchar(200) NOT NULL,
  KLNAME varchar(200) DEFAULT NULL,
  KLNAMEABBREV varchar(200) DEFAULT NULL,
  ADDRESS1 varchar(120) DEFAULT NULL,
  ADDRESS2 varchar(80) DEFAULT NULL,
  PLACE varchar(200) DEFAULT NULL,
  COUNTRY varchar(200) DEFAULT NULL,
  COUNTRY_DE varchar(200) DEFAULT NULL,
  POSTCODE varchar(30) DEFAULT NULL,
  INSTITUTIONURL varchar(500) DEFAULT NULL,
  COLLECTIONURL1 varchar(500) DEFAULT NULL,
  COLLECTIONURL2 varchar(500) DEFAULT NULL,
  LOGOURL1 varchar(500) DEFAULT NULL,
  LOGOURL2 varchar(500) DEFAULT NULL,
  CONTACTNAME varchar(100) DEFAULT NULL,
  CONTACTEMAIL varchar(100) DEFAULT NULL,
  CONTACTPHONE varchar(65) DEFAULT NULL,
  CONTACTFAX varchar(65) DEFAULT NULL,
  CUSTOMINSTNAME varchar(120) DEFAULT NULL,
  GEONAME varchar(150) DEFAULT NULL,
  PRIMARY KEY (INSTITUTIONID)
);
CREATE INDEX INSTITUTIONCOPLNM ON INSTITUTION(COUNTRY,PLACE,NAME);
CREATE INDEX INSTITUTIONPLNM ON INSTITUTION(PLACE,NAME);
CREATE INDEX INSTITUTIONNM ON INSTITUTION(NAME);

CREATE TABLE PAGE (
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT NOT NULL,
  SORTORDER varchar(10) DEFAULT NULL,
  FOLIONUMBER varchar(20) DEFAULT NULL,
  PAGECOLUMNS BIGINT DEFAULT NULL,
  PAGELINES BIGINT DEFAULT NULL,
  PAGEHEIGHT BIGINT DEFAULT NULL,
  PAGEWIDTH BIGINT DEFAULT NULL,
  INDEXSTRINGORIG varchar(100) DEFAULT NULL,
  PRIMARY KEY (DOCUMENTID,PAGEID),
);
CREATE INDEX PAGEDOCSORTORDER ON PAGE(DOCUMENTID,SORTORDER,PAGEID);

CREATE TABLE PROJECT (
  PROJECTID BIGINT NOT NULL AUTO_INCREMENT,
  NAME varchar(200) NOT NULL,
  USERGROUP varchar(80) DEFAULT NULL,
  OBJECTPART varchar(80) DEFAULT NULL,
  DOCUMENTGROUPID BIGINT DEFAULT NULL,
  DOCUMENTGROUPIDSECONDARY BIGINT DEFAULT NULL,
  TASKTYPEID BIGINT DEFAULT NULL,
  CONFIGURATION varchar(4096) DEFAULT NULL,
  TRANSCRIPTIONATTRIBUTION varchar(254) DEFAULT NULL,
  TASKSTAGEDEFINITIONS varchar(100) DEFAULT NULL,
  PRIMARY KEY (PROJECTID)
);

CREATE TABLE REGULARIZATIONRULE (
  REGULARIZATIONRULEID BIGINT NOT NULL AUTO_INCREMENT,
  USERID varchar(200) DEFAULT NULL,
  GROUPNAME varchar(40) NOT NULL DEFAULT 'Unassigned',
  CONTEXTVERSE BIGINT DEFAULT NULL,
  SCOPE BIGINT DEFAULT NULL,
  VISIBILITY BIGINT DEFAULT NULL,
  TYPE BIGINT 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,
  PRIMARY KEY (REGULARIZATIONRULEID)
);
CREATE INDEX CONTEXTVERSEIDX ON REGULARIZATIONRULE(CONTEXTVERSE,USERID);

CREATE TABLE SEGMENT (
  SEGMENTID BIGINT NOT NULL AUTO_INCREMENT,
  VERSE BIGINT NOT NULL,
  SEGMENTNAME varchar(30) DEFAULT NULL,
  CONTEXTDESCRIPTION varchar(250) DEFAULT NULL,
  WORDSTART BIGINT NOT NULL,
  WORDEND BIGINT NOT NULL,
  PRIMARY KEY (SEGMENTID)
);
CREATE INDEX SEGMENTVERSE ON SEGMENT(VERSE);

CREATE TABLE SEGMENTGROUPSEGMENT (
  SEGMENTGROUPID BIGINT NOT NULL,
  SEGMENTID BIGINT NOT NULL,
  PRIMARY KEY (SEGMENTGROUPID,SEGMENTID)
);

CREATE TABLE SEGMENTREADING (
  SEGMENTREADINGID BIGINT NOT NULL AUTO_INCREMENT,
  SEGMENTID BIGINT NOT NULL,
  READINGNAME varchar(30) DEFAULT NULL,
  READING varchar(250) DEFAULT NULL,
  PRIMARY KEY (SEGMENTREADINGID)
);
CREATE INDEX SEGMENTREADINGSEGMENTID ON SEGMENTREADING(SEGMENTID);

CREATE TABLE SEGMENTREADINGWITNESS (
  SEGMENTID BIGINT NOT NULL,
  SEGMENTREADINGID BIGINT NOT NULL,
  DOCUMENTID BIGINT NOT NULL,
  VERSEINSTANCE varchar(20) NOT NULL DEFAULT '',
  COMMENT text,
  TRANSCRIPTION varchar(250) DEFAULT NULL,
  HAND varchar(10) NOT NULL DEFAULT '',
  UNSURE TINYINT NOT NULL DEFAULT '0',
  PROJECTID BIGINT NOT NULL DEFAULT '0',
  PRIMARY KEY (DOCUMENTID,VERSEINSTANCE,HAND,SEGMENTID,PROJECTID)
);
CREATE INDEX SEGMENTREADINGWITNESSSRID ON SEGMENTREADINGWITNESS(SEGMENTREADINGID);



CREATE TABLE SHELFINSTANCE (
  SHELFID BIGINT NOT NULL AUTO_INCREMENT,
  INSTITUTIONID BIGINT DEFAULT NULL,
  SHELFNUMBER varchar(200) DEFAULT NULL,
  FORMERGANUMBER varchar(20) DEFAULT NULL,
  CONTENTOVERVIEW varchar(500) DEFAULT NULL,
  LEAVESDESCRIPTION varchar(80) DEFAULT NULL,
  LEAVES BIGINT DEFAULT NULL,
  ORIGINYEARDESCRIPTION varchar(40) DEFAULT NULL,
  USERDATA varchar(20) DEFAULT NULL,
  PRIMARY KEY (SHELFID)
);
CREATE UNIQUE INDEX USERDATA ON SHELFINSTANCE(USERDATA);
CREATE INDEX SHELFINSTANCEINSTITUTION ON SHELFINSTANCE(INSTITUTIONID,SHELFID);
CREATE INDEX SHELFINSTANCEUSERDATA ON SHELFINSTANCE(USERDATA);

CREATE TABLE SHELFINSTANCEPAGES (
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT NOT NULL,
  SHELFID BIGINT NOT NULL,
  SORTORDER varchar(10) DEFAULT NULL,
  FOLIONUMBER varchar(20) DEFAULT NULL,
  PRIMARY KEY (DOCUMENTID,PAGEID,SHELFID)
);
CREATE INDEX SHELFINSTANCEPAGESSHELFINST ON SHELFINSTANCEPAGES(SHELFID,DOCUMENTID,PAGEID);

CREATE TABLE SURROGATEIMAGE (
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT NOT NULL,
  INSTITUTIONID BIGINT NOT NULL,
  SURROGATEID varchar(10) NOT NULL,
  SURROGATEDATE datetime DEFAULT NULL,
  SURROGATEPRODUCERID BIGINT DEFAULT NULL,
  SURROGATEURI varchar(200) DEFAULT NULL,
  THUMBNAILURI varchar(200) DEFAULT NULL,
  DISTRIBUTIONLICENSEID BIGINT DEFAULT NULL,
  PAGESTARTX BIGINT DEFAULT NULL,
  PAGESTARTY BIGINT DEFAULT NULL,
  PAGEENDX BIGINT DEFAULT NULL,
  PAGEENDY BIGINT DEFAULT NULL,
  ATTRIBUTION varchar(400) DEFAULT NULL,
  CREATEDATE timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  USERID varchar(60) DEFAULT NULL,
  ACCESSROLE varchar(80) DEFAULT NULL,
  WEBFRIENDLYURL varchar(200) DEFAULT NULL,
  PROTECTLEVEL BIGINT DEFAULT '0',
  SHELFID BIGINT DEFAULT NULL,
  PRIMARY KEY (DOCUMENTID,PAGEID,INSTITUTIONID,SURROGATEID)
);
CREATE INDEX SURROGATEIMAGECREATEDATE ON SURROGATEIMAGE(CREATEDATE);

CREATE TABLE SURROGATETRANSCRIPTION (
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT NOT NULL,
  INSTITUTIONID BIGINT NOT NULL,
  SURROGATEID varchar(10) NOT NULL,
  SURROGATEDATE datetime DEFAULT NULL,
  SURROGATEPRODUCERID BIGINT DEFAULT NULL,
  SURROGATEURI varchar(200) DEFAULT NULL,
  PRIMARY KEY (DOCUMENTID,PAGEID,INSTITUTIONID,SURROGATEID)
);

CREATE TABLE TASK (
  TASKID BIGINT NOT NULL AUTO_INCREMENT,
  TASKTYPEID BIGINT NOT NULL,
  OBJECTID BIGINT NOT NULL,
  OBJECTPART varchar(80) NOT NULL DEFAULT '',
  CREATEDBY varchar(80) DEFAULT NULL,
  ASSIGNEDTO varchar(80) NOT NULL DEFAULT '',
  PROJECTID BIGINT NOT NULL DEFAULT '0',
  STAGE BIGINT DEFAULT 0,
  PRIMARY KEY (TASKID)
);
CREATE INDEX TASKASSIGNEDTO ON TASK(ASSIGNEDTO,TASKTYPEID,OBJECTID);
CREATE UNIQUE INDEX TASKPROJECTASSIGNMENTS on TASK(TASKTYPEID,OBJECTID,ASSIGNEDTO,PROJECTID,OBJECTPART);

CREATE TABLE TASKTYPE (
  TASKTYPEID BIGINT NOT NULL,
  DESCRIPTION varchar(80) DEFAULT NULL,
  PRIMARY KEY (TASKTYPEID)
);

CREATE TABLE TRANSCRIPTIONPAGE (
  DOCUMENTID BIGINT NOT NULL,
  PAGEID BIGINT NOT NULL,
  TRANSCRIPTION text,
  USERID varchar(60) NOT NULL DEFAULT '',
  LINECOUNT BIGINT DEFAULT NULL,
  WORDCOUNT BIGINT DEFAULT NULL,
  PRIMARY KEY (DOCUMENTID,PAGEID,USERID)
);

CREATE TABLE TRANSCRIPTIONVERSE (
  DOCUMENTID BIGINT NOT NULL,
  VERSE BIGINT NOT NULL,
  TRANSCRIPTION text,
  USERID varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (DOCUMENTID,VERSE,USERID)
);

INSERT INTO `FEATUREDEFINITION` VALUES ('-Extant','Physical Attributes','Current Preserved Extant','stringVal1[Incomplete,Partial]',0,'asdf',1,'Extant',0,'');
INSERT INTO `FEATUREDEFINITION` VALUES ('Bibliography','Dossier','Bibliography Data from Dossier','stringVal1',0,NULL,1,'Bibliography',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Binding','Surrogate','Image of the manuscript binding','bool',1,NULL,0,'Binding',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('BlackScan','Surrogate','An all black image','bool',1,NULL,0,'Black Scan',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Blank','Physical Attributes','Blank page in the manuscript','bool',0,NULL,0,'Blank',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('CanonTables','ParaTextual','','bool',0,NULL,0,'Canon Tables',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('CanvasMaterial','Physical Attributes','Material used for writing surface','stringVal1[Paper,Parchment,Papyrus]',0,NULL,1,'Canvas Material',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Colophone','ParaTextual','Scribal Colophone','bool',0,NULL,0,'Colophone',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Comment',NULL,'General Comment','stringVal1',1,NULL,1,'General Comment',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('DiktyonNumber','Alternate Identification','Diktyon Number','intVal1;intVal2',0,'',1,'Diktyon Number;Shelf ID',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('drubschmid-Poem','ParaTextual','','bool',0,'',0,'Poem',1,'drubschmid');
INSERT INTO `FEATUREDEFINITION` VALUES ('Edition','Dossier','Edition, Publication','stringVal1',0,NULL,1,'Edition',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Ekthesis','Paratextual','','',0,'',0,'',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Evangelienleben','ParatexBib','ParatexBib - Evangelienleben, Von Soden Nr. 106','stringVal1[Βιοι των τεσσαρων ευαγγελιστων εκ της του Δωροθεου μαρτυρος και Τυριων επισκοπου συνοψεως, Βιος του Μαρκου εκ της του Δωροθεου μαρτυρος και Τυριων επισκοπου συνοψεως, Βιος Λουκα του ευαγγελιστου εκ της του Δωροθεου μαρτυρος και Τυριων επισκοπου συνοψεως, Βιος Ιωαννου του ευαγγελιστου εκ της του Δωροθεου μαρτυρος και Τυριων επισκοπου συνοψεως];[Start, End, Complete]',0,'',0,'Evangelienleben Überschrift;Marker',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Exemplar','Other','Exemplar Known','intVal1;stringVal1',0,'DOC ID of Exemplar; Notes',1,'Exemplar ID; Notes',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Extant','Physical Attributes','Current Preserved Extant (From Liste Content, \'P\' - Partial; \'✝\' - Incomplete)','stringVal1[Incomplete,Partial]',0,'',1,'Extant',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ExternalCatalogRepo','External','Catalog Repository, External','stringVal1;stringVal2',0,'Description; URL',1,'External Catalog Repo Name; URL',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ExternalImageRepo','External','Image Repository, External','stringVal1;stringVal2',0,'Description; URL',1,'External Image Repo Name; URL',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('GeneralManuscriptObservation','Other','Any description or other comments typically provided by an observer of the artifact.','stringVal1',0,NULL,1,'General Manuscript Observation',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Grapheme','Grapheme','Glyph annotation with grapheme resolution','stringVal1',0,NULL,0,'Grapheme',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Headpieces','Decoration','Decorated Book Titles','bool',0,NULL,0,'Headpieces',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('hhaber-Vers','ParaTextual','','stringVal1[Tetraevangelium,Evangelien,Praxapostolos];stringVal2[vonSoden01,vonSoden02,vonSoden03,vonSoden04]',0,'',0,'Vers',1,'hhaber');
INSERT INTO `FEATUREDEFINITION` VALUES ('Hypothesis','ParaTextual','','bool',0,NULL,0,'Hypothesis',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('IlluminatedLetters','Decoration',NULL,'bool',0,NULL,0,'Illuminated Letters',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Illuminations','Decoration','','bool',0,'',0,'Illuminations',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('IndexingComment','Other','Any page description or other comments provided during indexing.  Use IndexingIssue feature for comments which need review.','stringVal1',0,NULL,0,'Comment from Indexer',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('IndexingIssue','Other','Indexing issues with this page. Need review.','bool',0,NULL,0,'Indexing Issue',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Inscriptio','ParaTextual','Inscriptio','bool',1,'',0,'Inscriptio',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('INTFFilmCount','Surrogate','Number of films on file at the INTF','intVal1',0,'',1,'INTF Film Count',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Katene','ParaTextual','Commentary Interleaved With Biblical Text','bool',0,NULL,0,'Katene',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('KephalaiaList','ParaTextual','','bool',0,NULL,0,'Kephalaia List',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('LDAB','Alternate Identification','LDAB ID','stringVal1;stringVal2',0,'LDAB ID; LDAB URL',1,'LDAB ID; URL',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('LectionBookType','Liturgical','Type of Liturgical Book','stringVal1[Weekdays,Sat+Sun,Weekdays+Sun,Sat+Sun+Easter-Pent Weekdays,Selected,Psalms+Odes,Other]',0,'',1,'Liturgical Book Type',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('LectionContent','Liturgical','Biblical Content','stringVal1[Gospels,Apostolos,Gospels+Apostolos]',0,'',1,'Biblical Content',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('LectionIndex','ParaTextual','','bool',0,NULL,0,'Lection Index',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('LectionTradition','Liturgical','Local Lection Tradition','stringVal1[Jerusalem]',0,NULL,1,'Lection Tradition',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('LibraryShelfNumber','Surrogate','When an image is not of a manuscript, but of the library shelf information','bool',1,NULL,0,'Library Shelf Number',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('MicrofilmTitle','Surrogate','When an image is not of a manuscript, but of the institution title page for the scan set','bool',1,NULL,0,'Microfilm Title',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ModernPageNumberMarking','ParaTextual','Mark in the manuscript which designates a page identifier placed in the manuscript after 1700','stringVal1',0,NULL,0,'Page ID - Modern',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('NoIdx','Other','No Index Content','bool',0,'Include if page has no indexible content',0,'No Index Content',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('NonBiblicalContentDescription','Other','Non-Biblical Content Description','stringVal1',0,NULL,0,'Non-Biblical Content Description',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('NoteSurrogate','Surrogate','Comments found on the surrogate representation of this manuscript','bool',1,NULL,0,'Note about Surrogate',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Oxy','Alternate Identification','Oxy ID','stringVal1',0,NULL,1,'Oxy ID',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ParagraphBreak','ParaTextual','An ekthesis or other scribal indication of a paragraph break','bool',0,NULL,0,'Paragraph Break',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('PericopeMarker','Decoration','Scribal markers indicating start of pericope.','stringVal1',0,NULL,0,'Pericope Marker',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('PurpleParchment','Physical Attributes','Purple Dye Added to Parchment Writing Canvas','bool',0,'',1,'Purple Parchment',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Randkatene','ParaTextual','Commentary Surrounding Biblical Text','bool',0,NULL,0,'Randkatene',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Scale','Surrogate','Ruler, or other to show dimensions of manuscript','bool',1,NULL,0,'Scale / Ruler',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ScanStatusInfo','Surrogate','When an image is not of a manuscript, but of the metadata for the scan set','bool',1,NULL,0,'Scan Status Info',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ScribalPageNumberMarking','ParaTextual','Mark in the manuscript which designates a page identifier placed in the manuscript by the original scribe or scriptorium','stringVal1',0,NULL,0,'Page ID - Ancient',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ScribalQuireNumberMarking','ParaTextual','Mark in the manuscript which designates a quire identifier placed in the manuscript by the original scribe or scriptorium','stringVal1',0,NULL,0,'Quire ID - Ancient',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Script','Physical Attributes','Writing style.','stringVal1[Majuscule,Minuscule]',0,NULL,1,'Script',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('ShapedText','Textual','','stringVal1[Chi]',0,'',0,'Shaped Text',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Subscriptio','ParaTextual','Subscriptio','bool',1,'',0,'Subscriptio',1,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('SyriacVersion','Tradition','Syriac Version','stringVal1[Harklean,Old Syriac,Peshitto,Philoxenian]',0,'',1,'Syriac Version',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('Tischendorf','Alternate Identification','Tischendorf ID','stringVal1',0,NULL,1,'Tischendorf ID',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('VonSoden','Alternate Identification','von Soden ID','stringVal1',0,NULL,1,'Von Soden ID',0,NULL);
INSERT INTO `FEATUREDEFINITION` VALUES ('WritingMaterial','Physical Attributes','Ink Material Used for the Main Text','stringVal1[Gold,Silver]',0,NULL,1,'Writing Material',0,NULL);
