class SiSU_DbCreate::Comment

Public Class Methods

new(conn,sql_type=:pg) click to toggle source
# File lib/sisu/db_create.rb, line 421
def initialize(conn,sql_type=:pg)
  @conn=conn
  if sql_type == :pg then psql
  end
end

Public Instance Methods

conn_execute_array(sql_arr) click to toggle source
# File lib/sisu/db_create.rb, line 427
def conn_execute_array(sql_arr)
  @conn.transaction do |conn|
    sql_arr.each do |sql|
      conn.exec_params(sql)
    end
  end
end
doc_objects() click to toggle source
# File lib/sisu/db_create.rb, line 520
def doc_objects
  sql_arr=[
    %{COMMENT ON Table doc_objects
      IS 'contains searchable text of SiSU document objects';},
    %{COMMENT ON COLUMN doc_objects.lid
      IS 'unique';},
    %{COMMENT ON COLUMN doc_objects.metadata_tid
      IS 'tie to title in metadata_and_text';},
    %{COMMENT ON COLUMN doc_objects.lev_an
      IS 'doc level A-D 1-4';},
    %{COMMENT ON COLUMN doc_objects.lev
      IS 'doc level 0-7 \d\~';},
    %{COMMENT ON COLUMN doc_objects.seg
      IS 'segment name from level number 4 (lv 1)';},
    %{COMMENT ON COLUMN doc_objects.ocn
      IS 'object citation number';},
    %{COMMENT ON COLUMN doc_objects.en_a
      IS 'first endnote number in text object (eg. NULL or 34) (used with en_z to create range)';},
    %{COMMENT ON COLUMN doc_objects.en_z
      IS 'last endnote number within text object (eg. NULL, 34 or say 47) (used with en_a to create range)';},
    %{COMMENT ON COLUMN doc_objects.en_a_asterisk
      IS 'first endnote number in text object (eg. NULL or 34) (used with en_z_asterisk to create range)';},
    %{COMMENT ON COLUMN doc_objects.en_z_asterisk
      IS 'last endnote number within text object (eg. NULL, 34 or say 47) (used with en_a_asterisk to create range)';},
    %{COMMENT ON COLUMN doc_objects.en_a_plus
      IS 'first endnote number in text object (eg. NULL or 34) (used with en_z_plus to create range)';},
    %{COMMENT ON COLUMN doc_objects.en_z_plus
      IS 'last endnote number within text object (eg. NULL, 34 or say 47) (used with en_a_plus to create range)';},
    %{COMMENT ON COLUMN doc_objects.types
      IS 'document types seg scroll';},
    %{COMMENT ON COLUMN doc_objects.clean
      IS 'text object - substantive text: clean, stripped of markup';},
    %{COMMENT ON COLUMN doc_objects.body
      IS 'text object - substantive text: light html markup';},
    %{COMMENT ON COLUMN doc_objects.book_idx
      IS 'book index creation information for paragraph, if provided';},
    %{COMMENT ON COLUMN doc_objects.lev0
      IS 'document structure, level number 0';},
    %{COMMENT ON COLUMN doc_objects.lev1
      IS 'document structure, level number 1';},
    %{COMMENT ON COLUMN doc_objects.lev2
      IS 'document structure, level number 2';},
    %{COMMENT ON COLUMN doc_objects.lev3
      IS 'document structure, level number 3';},
    %{COMMENT ON COLUMN doc_objects.lev4
      IS 'document structure, level number 4';},
    %{COMMENT ON COLUMN doc_objects.lev5
      IS 'document structure, level number 5';},
    %{COMMENT ON COLUMN doc_objects.lev6
      IS 'document structure, level number 6';},
    %{COMMENT ON COLUMN doc_objects.lev7
      IS 'document structure, level number 7';},
    %{COMMENT ON COLUMN doc_objects.t_of
      IS 'document structure, type of object (object is of)';},
    %{COMMENT ON COLUMN doc_objects.t_is
      IS 'document structure, object is';},
    %{COMMENT ON COLUMN doc_objects.node
      IS 'document structure, object node if heading';},
    %{COMMENT ON COLUMN doc_objects.parent
      IS 'document structure, object parent (is a heading)';}
  ]
  conn_execute_array(sql_arr)
end
endnotes() click to toggle source
# File lib/sisu/db_create.rb, line 583
def endnotes
  sql_arr=[
    %{COMMENT ON Table endnotes
      IS 'contains searchable text of SiSU documents endnotes';},
    %{COMMENT ON COLUMN endnotes.nid
      IS 'unique';},
    %{COMMENT ON COLUMN endnotes.document_lid
      IS 'ties to text block from which referenced';},
    %{COMMENT ON COLUMN endnotes.nr
      IS 'endnote number <!e_(\d+)!>';},
    %{COMMENT ON COLUMN endnotes.clean
      IS 'endnote substantive content, stripped of markup';},
    %{COMMENT ON COLUMN endnotes.body
      IS 'endnote substantive content';},
    %{COMMENT ON COLUMN endnotes.ocn
      IS 'object citation no# <\~(\d+)> from which endnote is referenced';},
    %{COMMENT ON COLUMN doc_objects.metadata_tid
      IS 'tie to title in metadata_and_text - unique for each document';}
  ]
  conn_execute_array(sql_arr)
end
endnotes_asterisk() click to toggle source
# File lib/sisu/db_create.rb, line 604
def endnotes_asterisk
  sql_arr=[
    %{COMMENT ON Table endnotes_asterisk
      IS 'contains searchable text of SiSU documents endnotes marked with asterisk';},
    %{COMMENT ON COLUMN endnotes_asterisk.nid
      IS 'unique';},
    %{COMMENT ON COLUMN endnotes_asterisk.document_lid
      IS 'ties to text block from which referenced';},
    %{COMMENT ON COLUMN endnotes_asterisk.nr
      IS 'endnote number <!e_(\d+)!>';},
    %{COMMENT ON COLUMN endnotes_asterisk.clean
      IS 'endnote substantive content, stripped of markup';},
    %{COMMENT ON COLUMN endnotes_asterisk.body
      IS 'endnote substantive content';},
    %{COMMENT ON COLUMN endnotes_asterisk.ocn
      IS 'object citation no# <\~(\d+)> from which endnote is referenced';},
    %{COMMENT ON COLUMN doc_objects.metadata_tid
      IS 'tie to title in metadata_and_text - unique for each document';}
  ]
  conn_execute_array(sql_arr)
end
endnotes_plus() click to toggle source
# File lib/sisu/db_create.rb, line 625
def endnotes_plus
  sql_arr=[
    %{COMMENT ON Table endnotes_plus
      IS 'contains searchable text of SiSU documents endnotes marked with plus';},
    %{COMMENT ON COLUMN endnotes_plus.nid
      IS 'unique';},
    %{COMMENT ON COLUMN endnotes_plus.document_lid
      IS 'ties to text block from which referenced';},
    %{COMMENT ON COLUMN endnotes_plus.nr
      IS 'endnote number <!e_(\d+)!>';},
    %{COMMENT ON COLUMN endnotes_plus.clean
      IS 'endnote substantive content, stripped of markup';},
    %{COMMENT ON COLUMN endnotes_plus.body
      IS 'endnote substantive content';},
    %{COMMENT ON COLUMN endnotes_plus.ocn
      IS 'object citation no# <\~(\d+)> from which endnote is referenced';},
    %{COMMENT ON COLUMN doc_objects.metadata_tid
      IS 'tie to title in metadata_and_text - unique for each document';},
  ]
  conn_execute_array(sql_arr)
end
metadata_and_text() click to toggle source
# File lib/sisu/db_create.rb, line 434
def metadata_and_text
  sql_arr=[
    %{COMMENT ON Table metadata_and_text
      IS 'contains SiSU metadata and fulltext for search (including source .sst if shared)';},
    %{COMMENT ON COLUMN metadata_and_text.tid
      IS 'unique';},
    %{#{column.title.column_comment}},
    %{#{column.title_main.column_comment}},
    %{#{column.title_sub.column_comment}},
    %{#{column.title_short.column_comment}},
    %{#{column.title_edition.column_comment}},
    %{#{column.title_note.column_comment}},
    %{#{column.title_language.column_comment}},
    %{#{column.title_language_char.column_comment}},
    %{#{column.creator_author.column_comment}},
    %{#{column.creator_author_honorific.column_comment}},
    %{#{column.creator_author_nationality.column_comment}},
    %{#{column.creator_editor.column_comment}},
    %{#{column.creator_contributor.column_comment}},
    %{#{column.creator_illustrator.column_comment}},
    %{#{column.creator_photographer.column_comment}},
    %{#{column.creator_translator.column_comment}},
    %{#{column.creator_prepared_by.column_comment}},
    %{#{column.creator_digitized_by.column_comment}},
    %{#{column.creator_audio.column_comment}},
    %{#{column.creator_video.column_comment}},
    %{#{column.language_document.column_comment}},
    %{#{column.language_document_char.column_comment}},
    %{#{column.language_original.column_comment}},
    %{#{column.language_original_char.column_comment}},
    %{#{column.date_added_to_site.column_comment}},
    %{#{column.date_available.column_comment}},
    %{#{column.date_created.column_comment}},
    %{#{column.date_issued.column_comment}},
    %{#{column.date_modified.column_comment}},
    %{#{column.date_published.column_comment}},
    %{#{column.date_valid.column_comment}},
    %{#{column.date_translated.column_comment}},
    %{#{column.date_original_publication.column_comment}},
    %{#{column.date_generated.column_comment}},
    %{#{column.publisher.column_comment}},
    %{#{column.original_publisher.column_comment}},
    %{#{column.original_language.column_comment}},
    %{#{column.original_language_char.column_comment}},
    %{#{column.original_source.column_comment}},
    %{#{column.original_institution.column_comment}},
    %{#{column.original_nationality.column_comment}},
    %{#{column.rights_all.column_comment}},
    %{#{column.rights_copyright_text.column_comment}},
    %{#{column.rights_copyright_translation.column_comment}},
    %{#{column.rights_copyright_illustrations.column_comment}},
    %{#{column.rights_copyright_photographs.column_comment}},
    %{#{column.rights_copyright_preparation.column_comment}},
    %{#{column.rights_copyright_digitization.column_comment}},
    %{#{column.rights_copyright_audio.column_comment}},
    %{#{column.rights_copyright_video.column_comment}},
    %{#{column.rights_license.column_comment}},
    %{#{column.classify_topic_register.column_comment}},
    %{#{column.classify_subject.column_comment}},
    %{#{column.classify_loc.column_comment}},
    %{#{column.classify_dewey.column_comment}},
    %{#{column.classify_keywords.column_comment}},
    %{#{column.identifier_oclc.column_comment}},
    %{#{column.identifier_isbn.column_comment}},
    %{#{column.notes_abstract.column_comment}},
    %{#{column.notes_comment.column_comment}},
    %{#{column.notes_description.column_comment}},
    %{#{column.notes_history.column_comment}},
    %{#{column.notes_coverage.column_comment}},
    %{#{column.notes_relation.column_comment}},
    %{#{column.notes_type.column_comment}},
    %{#{column.notes_format.column_comment}},
    %{#{column.notes_prefix.column_comment}},
    %{#{column.notes_prefix_a.column_comment}},
    %{#{column.notes_prefix_b.column_comment}},
    %{#{column.notes_suffix.column_comment}},
    %{#{column.src_filename.column_comment}},
    %{#{column.src_fingerprint.column_comment}},
    %{#{column.src_filesize.column_comment}},
    %{#{column.src_word_count.column_comment}},
    %{#{column.src_txt.column_comment}},
    %{#{column.fulltext.column_comment}},
    %{#{column.links.column_comment}},
  ]
  conn_execute_array(sql_arr)
end
psql() click to toggle source
# File lib/sisu/db_create.rb, line 426
def psql
  def conn_execute_array(sql_arr)
    @conn.transaction do |conn|
      sql_arr.each do |sql|
        conn.exec_params(sql)
      end
    end
  end
  def metadata_and_text
    sql_arr=[
      %{COMMENT ON Table metadata_and_text
        IS 'contains SiSU metadata and fulltext for search (including source .sst if shared)';},
      %{COMMENT ON COLUMN metadata_and_text.tid
        IS 'unique';},
      %{#{column.title.column_comment}},
      %{#{column.title_main.column_comment}},
      %{#{column.title_sub.column_comment}},
      %{#{column.title_short.column_comment}},
      %{#{column.title_edition.column_comment}},
      %{#{column.title_note.column_comment}},
      %{#{column.title_language.column_comment}},
      %{#{column.title_language_char.column_comment}},
      %{#{column.creator_author.column_comment}},
      %{#{column.creator_author_honorific.column_comment}},
      %{#{column.creator_author_nationality.column_comment}},
      %{#{column.creator_editor.column_comment}},
      %{#{column.creator_contributor.column_comment}},
      %{#{column.creator_illustrator.column_comment}},
      %{#{column.creator_photographer.column_comment}},
      %{#{column.creator_translator.column_comment}},
      %{#{column.creator_prepared_by.column_comment}},
      %{#{column.creator_digitized_by.column_comment}},
      %{#{column.creator_audio.column_comment}},
      %{#{column.creator_video.column_comment}},
      %{#{column.language_document.column_comment}},
      %{#{column.language_document_char.column_comment}},
      %{#{column.language_original.column_comment}},
      %{#{column.language_original_char.column_comment}},
      %{#{column.date_added_to_site.column_comment}},
      %{#{column.date_available.column_comment}},
      %{#{column.date_created.column_comment}},
      %{#{column.date_issued.column_comment}},
      %{#{column.date_modified.column_comment}},
      %{#{column.date_published.column_comment}},
      %{#{column.date_valid.column_comment}},
      %{#{column.date_translated.column_comment}},
      %{#{column.date_original_publication.column_comment}},
      %{#{column.date_generated.column_comment}},
      %{#{column.publisher.column_comment}},
      %{#{column.original_publisher.column_comment}},
      %{#{column.original_language.column_comment}},
      %{#{column.original_language_char.column_comment}},
      %{#{column.original_source.column_comment}},
      %{#{column.original_institution.column_comment}},
      %{#{column.original_nationality.column_comment}},
      %{#{column.rights_all.column_comment}},
      %{#{column.rights_copyright_text.column_comment}},
      %{#{column.rights_copyright_translation.column_comment}},
      %{#{column.rights_copyright_illustrations.column_comment}},
      %{#{column.rights_copyright_photographs.column_comment}},
      %{#{column.rights_copyright_preparation.column_comment}},
      %{#{column.rights_copyright_digitization.column_comment}},
      %{#{column.rights_copyright_audio.column_comment}},
      %{#{column.rights_copyright_video.column_comment}},
      %{#{column.rights_license.column_comment}},
      %{#{column.classify_topic_register.column_comment}},
      %{#{column.classify_subject.column_comment}},
      %{#{column.classify_loc.column_comment}},
      %{#{column.classify_dewey.column_comment}},
      %{#{column.classify_keywords.column_comment}},
      %{#{column.identifier_oclc.column_comment}},
      %{#{column.identifier_isbn.column_comment}},
      %{#{column.notes_abstract.column_comment}},
      %{#{column.notes_comment.column_comment}},
      %{#{column.notes_description.column_comment}},
      %{#{column.notes_history.column_comment}},
      %{#{column.notes_coverage.column_comment}},
      %{#{column.notes_relation.column_comment}},
      %{#{column.notes_type.column_comment}},
      %{#{column.notes_format.column_comment}},
      %{#{column.notes_prefix.column_comment}},
      %{#{column.notes_prefix_a.column_comment}},
      %{#{column.notes_prefix_b.column_comment}},
      %{#{column.notes_suffix.column_comment}},
      %{#{column.src_filename.column_comment}},
      %{#{column.src_fingerprint.column_comment}},
      %{#{column.src_filesize.column_comment}},
      %{#{column.src_word_count.column_comment}},
      %{#{column.src_txt.column_comment}},
      %{#{column.fulltext.column_comment}},
      %{#{column.links.column_comment}},
    ]
    conn_execute_array(sql_arr)
  end
  def doc_objects
    sql_arr=[
      %{COMMENT ON Table doc_objects
        IS 'contains searchable text of SiSU document objects';},
      %{COMMENT ON COLUMN doc_objects.lid
        IS 'unique';},
      %{COMMENT ON COLUMN doc_objects.metadata_tid
        IS 'tie to title in metadata_and_text';},
      %{COMMENT ON COLUMN doc_objects.lev_an
        IS 'doc level A-D 1-4';},
      %{COMMENT ON COLUMN doc_objects.lev
        IS 'doc level 0-7 \d\~';},
      %{COMMENT ON COLUMN doc_objects.seg
        IS 'segment name from level number 4 (lv 1)';},
      %{COMMENT ON COLUMN doc_objects.ocn
        IS 'object citation number';},
      %{COMMENT ON COLUMN doc_objects.en_a
        IS 'first endnote number in text object (eg. NULL or 34) (used with en_z to create range)';},
      %{COMMENT ON COLUMN doc_objects.en_z
        IS 'last endnote number within text object (eg. NULL, 34 or say 47) (used with en_a to create range)';},
      %{COMMENT ON COLUMN doc_objects.en_a_asterisk
        IS 'first endnote number in text object (eg. NULL or 34) (used with en_z_asterisk to create range)';},
      %{COMMENT ON COLUMN doc_objects.en_z_asterisk
        IS 'last endnote number within text object (eg. NULL, 34 or say 47) (used with en_a_asterisk to create range)';},
      %{COMMENT ON COLUMN doc_objects.en_a_plus
        IS 'first endnote number in text object (eg. NULL or 34) (used with en_z_plus to create range)';},
      %{COMMENT ON COLUMN doc_objects.en_z_plus
        IS 'last endnote number within text object (eg. NULL, 34 or say 47) (used with en_a_plus to create range)';},
      %{COMMENT ON COLUMN doc_objects.types
        IS 'document types seg scroll';},
      %{COMMENT ON COLUMN doc_objects.clean
        IS 'text object - substantive text: clean, stripped of markup';},
      %{COMMENT ON COLUMN doc_objects.body
        IS 'text object - substantive text: light html markup';},
      %{COMMENT ON COLUMN doc_objects.book_idx
        IS 'book index creation information for paragraph, if provided';},
      %{COMMENT ON COLUMN doc_objects.lev0
        IS 'document structure, level number 0';},
      %{COMMENT ON COLUMN doc_objects.lev1
        IS 'document structure, level number 1';},
      %{COMMENT ON COLUMN doc_objects.lev2
        IS 'document structure, level number 2';},
      %{COMMENT ON COLUMN doc_objects.lev3
        IS 'document structure, level number 3';},
      %{COMMENT ON COLUMN doc_objects.lev4
        IS 'document structure, level number 4';},
      %{COMMENT ON COLUMN doc_objects.lev5
        IS 'document structure, level number 5';},
      %{COMMENT ON COLUMN doc_objects.lev6
        IS 'document structure, level number 6';},
      %{COMMENT ON COLUMN doc_objects.lev7
        IS 'document structure, level number 7';},
      %{COMMENT ON COLUMN doc_objects.t_of
        IS 'document structure, type of object (object is of)';},
      %{COMMENT ON COLUMN doc_objects.t_is
        IS 'document structure, object is';},
      %{COMMENT ON COLUMN doc_objects.node
        IS 'document structure, object node if heading';},
      %{COMMENT ON COLUMN doc_objects.parent
        IS 'document structure, object parent (is a heading)';}
    ]
    conn_execute_array(sql_arr)
  end
  def endnotes
    sql_arr=[
      %{COMMENT ON Table endnotes
        IS 'contains searchable text of SiSU documents endnotes';},
      %{COMMENT ON COLUMN endnotes.nid
        IS 'unique';},
      %{COMMENT ON COLUMN endnotes.document_lid
        IS 'ties to text block from which referenced';},
      %{COMMENT ON COLUMN endnotes.nr
        IS 'endnote number <!e_(\d+)!>';},
      %{COMMENT ON COLUMN endnotes.clean
        IS 'endnote substantive content, stripped of markup';},
      %{COMMENT ON COLUMN endnotes.body
        IS 'endnote substantive content';},
      %{COMMENT ON COLUMN endnotes.ocn
        IS 'object citation no# <\~(\d+)> from which endnote is referenced';},
      %{COMMENT ON COLUMN doc_objects.metadata_tid
        IS 'tie to title in metadata_and_text - unique for each document';}
    ]
    conn_execute_array(sql_arr)
  end
  def endnotes_asterisk
    sql_arr=[
      %{COMMENT ON Table endnotes_asterisk
        IS 'contains searchable text of SiSU documents endnotes marked with asterisk';},
      %{COMMENT ON COLUMN endnotes_asterisk.nid
        IS 'unique';},
      %{COMMENT ON COLUMN endnotes_asterisk.document_lid
        IS 'ties to text block from which referenced';},
      %{COMMENT ON COLUMN endnotes_asterisk.nr
        IS 'endnote number <!e_(\d+)!>';},
      %{COMMENT ON COLUMN endnotes_asterisk.clean
        IS 'endnote substantive content, stripped of markup';},
      %{COMMENT ON COLUMN endnotes_asterisk.body
        IS 'endnote substantive content';},
      %{COMMENT ON COLUMN endnotes_asterisk.ocn
        IS 'object citation no# <\~(\d+)> from which endnote is referenced';},
      %{COMMENT ON COLUMN doc_objects.metadata_tid
        IS 'tie to title in metadata_and_text - unique for each document';}
    ]
    conn_execute_array(sql_arr)
  end
  def endnotes_plus
    sql_arr=[
      %{COMMENT ON Table endnotes_plus
        IS 'contains searchable text of SiSU documents endnotes marked with plus';},
      %{COMMENT ON COLUMN endnotes_plus.nid
        IS 'unique';},
      %{COMMENT ON COLUMN endnotes_plus.document_lid
        IS 'ties to text block from which referenced';},
      %{COMMENT ON COLUMN endnotes_plus.nr
        IS 'endnote number <!e_(\d+)!>';},
      %{COMMENT ON COLUMN endnotes_plus.clean
        IS 'endnote substantive content, stripped of markup';},
      %{COMMENT ON COLUMN endnotes_plus.body
        IS 'endnote substantive content';},
      %{COMMENT ON COLUMN endnotes_plus.ocn
        IS 'object citation no# <\~(\d+)> from which endnote is referenced';},
      %{COMMENT ON COLUMN doc_objects.metadata_tid
        IS 'tie to title in metadata_and_text - unique for each document';},
    ]
    conn_execute_array(sql_arr)
  end
  def urls
    sql_arr=[
      %{COMMENT ON Table urls
        IS 'contains base url links to different SiSU output';},
      %{COMMENT ON COLUMN doc_objects.metadata_tid
        IS 'tie to title in metadata_and_text - unique for each document, the mapping of rows is one to one';},
      %{COMMENT ON COLUMN urls.plaintext
        IS 'plaintext utf-8';},
      %{COMMENT ON COLUMN urls.html_toc
        IS 'table of contents for segmented html document';},
      %{COMMENT ON COLUMN urls.html_doc
        IS 'html document (scroll)';},
      %{COMMENT ON COLUMN urls.xhtml
        IS 'xhtml document (scroll)';},
      %{COMMENT ON COLUMN urls.xml_sax
        IS 'xml sax oriented document (scroll)';},
      %{COMMENT ON COLUMN urls.xml_dom
        IS 'xml dom oriented document (scroll)';},
      %{COMMENT ON COLUMN urls.odf
        IS 'opendocument format text';},
      %{COMMENT ON COLUMN urls.pdf_p
        IS 'pdf portrait';},
      %{COMMENT ON COLUMN urls.pdf_l
        IS 'pdf landscape';},
      %{COMMENT ON COLUMN urls.concordance
        IS 'rudimentary document index linked to html';},
      %{COMMENT ON COLUMN urls.latex_p
        IS 'latex portrait';},
      %{COMMENT ON COLUMN urls.latex_l
        IS 'latex_landscape';},
      %{COMMENT ON COLUMN urls.markup
        IS 'markup';},
      %{COMMENT ON COLUMN urls.sisupod
        IS 'SiSU document format .tgz (all SiSU information on document)';},
    ]
    conn_execute_array(sql_arr)
  end
  self
end
urls() click to toggle source
# File lib/sisu/db_create.rb, line 646
def urls
  sql_arr=[
    %{COMMENT ON Table urls
      IS 'contains base url links to different SiSU output';},
    %{COMMENT ON COLUMN doc_objects.metadata_tid
      IS 'tie to title in metadata_and_text - unique for each document, the mapping of rows is one to one';},
    %{COMMENT ON COLUMN urls.plaintext
      IS 'plaintext utf-8';},
    %{COMMENT ON COLUMN urls.html_toc
      IS 'table of contents for segmented html document';},
    %{COMMENT ON COLUMN urls.html_doc
      IS 'html document (scroll)';},
    %{COMMENT ON COLUMN urls.xhtml
      IS 'xhtml document (scroll)';},
    %{COMMENT ON COLUMN urls.xml_sax
      IS 'xml sax oriented document (scroll)';},
    %{COMMENT ON COLUMN urls.xml_dom
      IS 'xml dom oriented document (scroll)';},
    %{COMMENT ON COLUMN urls.odf
      IS 'opendocument format text';},
    %{COMMENT ON COLUMN urls.pdf_p
      IS 'pdf portrait';},
    %{COMMENT ON COLUMN urls.pdf_l
      IS 'pdf landscape';},
    %{COMMENT ON COLUMN urls.concordance
      IS 'rudimentary document index linked to html';},
    %{COMMENT ON COLUMN urls.latex_p
      IS 'latex portrait';},
    %{COMMENT ON COLUMN urls.latex_l
      IS 'latex_landscape';},
    %{COMMENT ON COLUMN urls.markup
      IS 'markup';},
    %{COMMENT ON COLUMN urls.sisupod
      IS 'SiSU document format .tgz (all SiSU information on document)';},
  ]
  conn_execute_array(sql_arr)
end