<?xml version="1.0" encoding="utf-8"?>
<root>
  <!-- 
    Microsoft ResX Schema 
    
    Version 2.0
    
    The primary goals of this format is to allow a simple XML format 
    that is mostly human readable. The generation and parsing of the 
    various data types are done through the TypeConverter classes 
    associated with the data types.
    
    Example:
    
    ... ado.net/XML headers & schema ...
    <resheader name="resmimetype">text/microsoft-resx</resheader>
    <resheader name="version">2.0</resheader>
    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
        <value>[base64 mime encoded serialized .NET Framework object]</value>
    </data>
    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
        <comment>This is a comment</comment>
    </data>
                
    There are any number of "resheader" rows that contain simple 
    name/value pairs.
    
    Each data row contains a name, and value. The row also contains a 
    type or mimetype. Type corresponds to a .NET class that support 
    text/value conversion through the TypeConverter architecture. 
    Classes that don't support this are serialized and stored with the 
    mimetype set.
    
    The mimetype is used for serialized objects, and tells the 
    ResXResourceReader how to depersist the object. This is currently not 
    extensible. For a given mimetype the value must be set accordingly:
    
    Note - application/x-microsoft.net.object.binary.base64 is the format 
    that the ResXResourceWriter will generate, however the reader can 
    read any of the formats listed below.
    
    mimetype: application/x-microsoft.net.object.binary.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
            : and then encoded with base64 encoding.
    
    mimetype: application/x-microsoft.net.object.soap.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64
    value   : The object must be serialized into a byte array 
            : using a System.ComponentModel.TypeConverter
            : and then encoded with base64 encoding.
    -->
  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
    <xsd:element name="root" msdata:IsDataSet="true">
      <xsd:complexType>
        <xsd:choice maxOccurs="unbounded">
          <xsd:element name="metadata">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" />
              </xsd:sequence>
              <xsd:attribute name="name" use="required" type="xsd:string" />
              <xsd:attribute name="type" type="xsd:string" />
              <xsd:attribute name="mimetype" type="xsd:string" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="assembly">
            <xsd:complexType>
              <xsd:attribute name="alias" type="xsd:string" />
              <xsd:attribute name="name" type="xsd:string" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="data">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="resheader">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" />
            </xsd:complexType>
          </xsd:element>
        </xsd:choice>
      </xsd:complexType>
    </xsd:element>
  </xsd:schema>
  <resheader name="resmimetype">
    <value>text/microsoft-resx</value>
  </resheader>
  <resheader name="version">
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <data name="CreateIndexSegmentsStatement1" xml:space="preserve">
    <value>CREATE INDEX segment_start_char_index ON segments (start_char)</value>
  </data>
  <data name="CreateIndexCFormsCTypesStatement" xml:space="preserve">
    <value>CREATE INDEX cforms_ctypes_index ON cforms_ctypes (cform_id, ctype_id)</value>
  </data>
  <data name="CreateIndexCFormsStatement" xml:space="preserve">
    <value>CREATE INDEX cforms_index ON cforms (cform)</value>
  </data>
  <data name="CreateIndexCorpusAttributesStatement" xml:space="preserve">
    <value />
  </data>
  <data name="CreateIndexCTypesStatement" xml:space="preserve">
    <value>CREATE INDEX ctypes_index ON ctypes (ctype)</value>
  </data>
  <data name="CreateIndexLexemesStatement1" xml:space="preserve">
    <value>CREATE INDEX lexemes_surface_index ON lexemes (surface)</value>
  </data>
  <data name="CreateIndexPartsOfSpeechStatement" xml:space="preserve">
    <value>CREATE INDEX parts_of_speech_index ON parts_of_speech (part_of_speech)</value>
  </data>
  <data name="CreateIndexSentencesStatement1" xml:space="preserve">
    <value>CREATE INDEX sentences_start_char_index ON sentences (start_char)</value>
  </data>
  <data name="CreateIndexWordsStatement1" xml:space="preserve">
    <value>CREATE INDEX words_sentence_id_index ON words (sentence_id ASC)</value>
  </data>
  <data name="CreateTableSegmentsStatement" xml:space="preserve">
    <value>CREATE TABLE segments (
 id bigint primary key,
 tag_definition_id int not null,
 document_id int not null,
 start_char int not null,
 end_char int not null,
 project_id int not null,
 user_id int,
 createtime timestamp,
 comment text,
 sentence_id int
)</value>
  </data>
  <data name="CreateTableCFormsCTypesStatement" xml:space="preserve">
    <value>CREATE TABLE cforms_ctypes (
 cform_id int,
 ctype_id int)</value>
  </data>
  <data name="CreateTableCFormsStatement" xml:space="preserve">
    <value>CREATE TABLE cforms (
 id int primary key,
 cform varchar(255)
 )</value>
  </data>
  <data name="CreateTableCorpusAttributesStatement" xml:space="preserve">
    <value>CREATE TABLE corpus_attributes (
 id int primary key,
 name varchar(255),
 value varchar(255)
)</value>
  </data>
  <data name="CreateTableCTypesStatement" xml:space="preserve">
    <value>CREATE TABLE ctypes (
 id int primary key,
 name1 varchar(255),
 name2 varchar(255),
 ctype varchar(255)
 )</value>
  </data>
  <data name="CreateTableLexemesStatement" xml:space="preserve">
    <value>CREATE TABLE lexemes (
  id                 int primary key,
  surface         varchar(255),
  reading         varchar(255) default '',
  pronunciation  varchar(255) default '',
  base_lexeme_ref   int not null,
  part_of_speech_id  int not null,
  ctype_id       int not null,
  cform_id       int not null,
  updated_at    timestamp,
  frequency      int default 0
)</value>
  </data>
  <data name="CreateTablePartsOfSpeechStatement" xml:space="preserve">
    <value>CREATE TABLE parts_of_speech (
 id int primary key,
 name1 varchar(255),
 name2 varchar(255),
 name3 varchar(255),
 name4 varchar(255),
 part_of_speech varchar(255)
 )</value>
  </data>
  <data name="CreateTableSentencesStatement" xml:space="preserve">
    <value>CREATE TABLE sentences (
  id             int primary key,
  start_char    int not null,
  end_char     int not null,
  document_id int not null
)</value>
  </data>
  <data name="CreateTableWordsStatement" xml:space="preserve">
    <value>CREATE TABLE words (
  id             int primary key,
  sentence_id  int not null,
  start_char int not null,
  end_char     int not null,
  lexeme_id     int not null,
  bunsetsu_id  int not null,
  updated_at   timestamp,
  position       int
)</value>
  </data>
  <data name="DropTableSegmentsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS segments</value>
  </data>
  <data name="DropTableCFormsCTypesStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS cforms_ctypes</value>
  </data>
  <data name="DropTableCFormsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS cforms</value>
  </data>
  <data name="DropTableCorpusAttributesStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS corpus_attributes</value>
  </data>
  <data name="DropTableCTypesStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS ctypes</value>
  </data>
  <data name="DropTableLexemesStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS lexemes</value>
  </data>
  <data name="DropTablePartsOfSpeechStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS parts_of_speech</value>
  </data>
  <data name="DropTableSentencesStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS sentences</value>
  </data>
  <data name="DropTableWordsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS words</value>
  </data>
  <data name="CreateIndexWordsStatement2" xml:space="preserve">
    <value>CREATE INDEX words_lexeme_id_index ON words (lexeme_id ASC)</value>
  </data>
  <data name="CreateIndexLinksStatement1" xml:space="preserve">
    <value>CREATE INDEX link_from_segment_index ON links (from_segment_id)</value>
  </data>
  <data name="CreateTableLinksStatement" xml:space="preserve">
    <value>CREATE TABLE links (
 id bigint primary key,
 tag_definition_id int not null,
 from_segment_id int not null,
 to_segment_id int not null,
 is_directed bool not null default true,
 is_transitive bool not null default false,
 project_id int not null,
 user_id int,
 createtime timestamp,
 comment text,
 from_sentence_id int,
 to_sentence_id int
 )</value>
  </data>
  <data name="DropTableLinksStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS links</value>
  </data>
  <data name="CreateIndexGroupsStatement" xml:space="preserve">
    <value />
  </data>
  <data name="CreateIndexSegmentsGroupsStatement1" xml:space="preserve">
    <value>CREATE INDEX segments_groups_group_index ON segments_groups ( group_id )</value>
  </data>
  <data name="CreateIndexSegmentsGroupsStatement2" xml:space="preserve">
    <value>CREATE INDEX segments_groups_segment_index ON segments_groups ( segment_id )</value>
  </data>
  <data name="CreateTableGroupsStatement" xml:space="preserve">
    <value>CREATE TABLE groups (
 id bigint primary key,
 tag_definition_id int not null,
 project_id int not null,
 user_id int,
 createtime timestamp,
 comment text
)</value>
  </data>
  <data name="CreateTableSegmentsGroupsStatement" xml:space="preserve">
    <value>CREATE TABLE segments_groups (
 group_id int not null,
 segment_id int not null
)</value>
  </data>
  <data name="DropTableGroupsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS groups</value>
  </data>
  <data name="DropTableSegmentsGroupsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS segments_groups</value>
  </data>
  <data name="CreateIndexBunsetsusStatement" xml:space="preserve">
    <value>CREATE INDEX bunsetsu_index ON bunsetsus (sentence_id)</value>
  </data>
  <data name="CreateTableBunsetsusStatement" xml:space="preserve">
    <value>CREATE TABLE bunsetsus (
 id int primary key,
 position int,
 sentence_id int,
 dep_bunsetsu_id int,
 dep_relation varchar(16)
)</value>
  </data>
  <data name="DropTableBunsetsusStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS bunsetsus</value>
  </data>
  <data name="CreateIndexLexemesStatement2" xml:space="preserve">
    <value>CREATE INDEX lexemes_reading_index ON lexemes (reading)</value>
  </data>
  <data name="CreateIndexLexemesStatement3" xml:space="preserve">
    <value>CREATE INDEX lexemes_pronunciation_index ON lexemes (pronunciation)</value>
  </data>
  <data name="CreateIndexLexemesStatement4" xml:space="preserve">
    <value>CREATE INDEX lexemes_base_lexeme_index ON lexemes (base_lexeme_ref)</value>
  </data>
  <data name="CreateIndexLexemesStatement5" xml:space="preserve">
    <value>CREATE INDEX lexemes_part_of_speech_index ON lexemes (part_of_speech_id)</value>
  </data>
  <data name="CreateIndexLexemesStatement6" xml:space="preserve">
    <value>CREATE INDEX lexemes_ctype_index ON lexemes (ctype_id)</value>
  </data>
  <data name="CreateIndexLexemesStatement7" xml:space="preserve">
    <value>CREATE INDEX lexemes_cform_index ON lexemes (cform_id)</value>
  </data>
  <data name="CreateIndexLinksStatement2" xml:space="preserve">
    <value>CREATE INDEX link_to_segment_index ON links (to_segment_id )</value>
  </data>
  <data name="CreateIndexSegmentsStatement2" xml:space="preserve">
    <value>CREATE INDEX segment_end_char_index ON segments (end_char)</value>
  </data>
  <data name="CreateIndexSentencesStatement2" xml:space="preserve">
    <value>CREATE INDEX sentences_end_char_index ON sentences (end_char)</value>
  </data>
  <data name="CreateIndexLinksStatement3" xml:space="preserve">
    <value>CREATE INDEX link_from_sentence_index ON links (from_sentence_id )</value>
  </data>
  <data name="CreateIndexLinksStatement4" xml:space="preserve">
    <value>CREATE INDEX link_to_sentence_index ON links (to_sentence_id )</value>
  </data>
  <data name="CreateIndexSegmentsStatement3" xml:space="preserve">
    <value>CREATE INDEX segment_sentence_index ON segments (sentence_id)</value>
  </data>
  <data name="CreateTableDocumentTagsStatement" xml:space="preserve">
    <value>CREATE TABLE documenttags (
  id             int primary key,
  tag           varchar(255),
  description text,
  updated_at timestamp
)</value>
  </data>
  <data name="CreateTableSentencesDocumentTagsStatement" xml:space="preserve">
    <value>CREATE TABLE sentences_documenttags (
  sentence_id int not null,
  documenttag_id int not null
)</value>
  </data>
  <data name="DropTableDocumentTagsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS documenttags</value>
  </data>
  <data name="DropTableSentencesDocumentTagsStatement" xml:space="preserve">
    <value>DROP TABLE IF EXISTS sentences_documenttags</value>
  </data>
  <data name="CreateIndexSentencesDocumenttagsStatement1" xml:space="preserve">
    <value>CREATE INDEX sentences_documenttags_index ON sentences_documenttags(sentence_id);</value>
  </data>
  <data name="CreateTableDocuments" xml:space="preserve">
    <value>CREATE TABLE documents (
  document_id  int primary key,
  documentset_id int not null,
  document_order int,
  filename varchar(255),
  document_text longtext
)</value>
  </data>
  <data name="CreateTableDocumentsets" xml:space="preserve">
    <value>CREATE TABLE document_sets (
  documentset_id  int primary key,
  documentset_name varchar(255)
)</value>
  </data>
  <data name="CreateTableProjects" xml:space="preserve">
    <value>CREATE TABLE projects (
  project_id  int primary key,
  documentset_id int not null,
  document_privilege smallint,
  tagset_privilege smallint
)
</value>
  </data>
  <data name="CreateTableProjectsTagsets" xml:space="preserve">
    <value>CREATE TABLE projects_tagsets (
  project_id  int not null,
  tagset_id int not null
)</value>
  </data>
  <data name="CreateTableTagDefinitions" xml:space="preserve">
    <value>CREATE TABLE tag_definition (
  id             int primary key,
  tagset_id int not null,
  type varchar(8) not null,
  tag_name varchar(255) not null,
  description text,
  version_id int not null
)</value>
  </data>
  <data name="CreateTableTagsetDefinitions" xml:space="preserve">
    <value>CREATE TABLE tagset_definitions (
  id             int primary key,
  tagset_name varchar(255) not null,
  version_id int not null
)</value>
  </data>
  <data name="CreateTableTagsetVersions" xml:space="preserve">
    <value>CREATE TABLE tagset_versions (
  version_id  int primary key,
  version varchar(255) not null,
  revision int not null,
  current bool not null
)</value>
  </data>
  <data name="DropTableDocuments" xml:space="preserve">
    <value>DROP TABLE IF EXISTS documents</value>
  </data>
  <data name="DropTableDocumentsets" xml:space="preserve">
    <value>DROP TABLE IF EXISTS documentsets</value>
  </data>
  <data name="DropTableProjects" xml:space="preserve">
    <value>DROP TABLE IF EXISTS projects</value>
  </data>
  <data name="DropTableProjectsTagsets" xml:space="preserve">
    <value>DROP TABLE IF EXISTS projects</value>
  </data>
  <data name="DropTableTagDefinitions" xml:space="preserve">
    <value>DROP TABLE IF EXISTS tag_definitions</value>
  </data>
  <data name="DropTableTagsetDefinitions" xml:space="preserve">
    <value>DROP TABLE IF EXISTS tagset_definitions</value>
  </data>
  <data name="DropTableTagsetVersions" xml:space="preserve">
    <value>DROP TABLE IF EXISTS tagset_versions</value>
  </data>
</root>