SET client_encoding = 'UTF8';

CREATE TABLE con_cpd
(
    id           VARCHAR(50) NOT NULL,
    sid          VARCHAR(50),
    chebi        VARCHAR(50),
    pubmed_query TEXT,
    pubmed_docs  INT,
    pubmed_block BOOLEAN,
    pmc_query    TEXT,
    pmc_docs     INT,
    pmc_block    BOOLEAN,
    reactions    INT,
    name         VARCHAR(200),

    PRIMARY KEY (id)
);


CREATE TABLE con_ec
(
    id           VARCHAR(50) NOT NULL,
    pubmed_query TEXT,
    pubmed_docs  INT,
    pubmed_block BOOLEAN,
    pmc_query    TEXT,
    pmc_docs     INT,
    pmc_block    BOOLEAN,
    cpd_total    INT,
    sce_total    INT,

    PRIMARY KEY (id)
);


CREATE TABLE con_go
(
    id           VARCHAR(50) NOT NULL,
    pubmed_query TEXT,
    pubmed_docs  INT,
    pubmed_block BOOLEAN,
    pmc_query    TEXT,
    pmc_docs     INT,
    pmc_block    BOOLEAN,

    PRIMARY KEY (id)
);


CREATE TABLE con_sbo
(
    id           VARCHAR(50) NOT NULL,
    pubmed_query TEXT,
    pubmed_docs  INT,
    pubmed_block BOOLEAN,
    pmc_query    TEXT,
    pmc_docs     INT,
    pmc_block    BOOLEAN,

    PRIMARY KEY (id)
);


CREATE TABLE con_sce
(
    id           VARCHAR(50) NOT NULL,
    sgd          VARCHAR(50),
    mips         VARCHAR(50),
    pubmed_query TEXT,
    pubmed_docs  INT,
    pubmed_block BOOLEAN,
    pmc_query    TEXT,
    pmc_docs     INT,
    pmc_block    BOOLEAN,

    PRIMARY KEY (id)
);


CREATE TABLE concepts
(
    concept VARCHAR(50) NOT NULL,
    weight  FLOAT,

    PRIMARY KEY (concept)
);


CREATE TABLE html
(
    id   INT NOT NULL,
    code TEXT,

    PRIMARY KEY (id)
);


CREATE TABLE pmc_citation
(
    pmcid         VARCHAR(50) NOT NULL,
    ref           TEXT,
    authors       TEXT,
    title         TEXT,
    abstract      TEXT,
    pmid          VARCHAR(50),
    HTML_abstract TEXT,
    HTML_paper    TEXT,

    PRIMARY KEY (pmcid)
);


CREATE TABLE pmc_general_hits
(
    pmcid    VARCHAR(50) NOT NULL,
    go_hits  FLOAT NOT NULL,
    sbo_hits FLOAT NOT NULL,
    score    FLOAT,

    PRIMARY KEY (pmcid)
);


CREATE TABLE pmc_index
(
    concept VARCHAR(50) NOT NULL,
    id      VARCHAR(50) NOT NULL,
    pmcid   VARCHAR(50) NOT NULL,

    PRIMARY KEY (concept, id, pmcid),

    FOREIGN KEY (concept) REFERENCES concepts(concept) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE pmc_specific_hits
(
    pmcid    VARCHAR(50) NOT NULL,
    ec       VARCHAR(50) NOT NULL,
    cpd_hits FLOAT NOT NULL,
    sce_hits FLOAT NOT NULL,
    ec_hit   INT,

    PRIMARY KEY (pmcid, ec)
);


CREATE TABLE pmc_user
(
    pmcid VARCHAR(50) NOT NULL,

    PRIMARY KEY (pmcid)
);


CREATE TABLE pubmed_citation
(
    pmid          VARCHAR(50) NOT NULL,
    ref           TEXT,
    authors       TEXT,
    title         TEXT,
    abstract      TEXT,
    HTML_abstract TEXT,

    PRIMARY KEY (pmid)
);


CREATE TABLE pubmed_general_hits
(
    pmid     VARCHAR(50) NOT NULL,
    go_hits  FLOAT NOT NULL,
    sbo_hits FLOAT NOT NULL,
    score    FLOAT,

    PRIMARY KEY (pmid)
);


CREATE TABLE pubmed_index
(
    concept VARCHAR(50) NOT NULL,
    id      VARCHAR(50) NOT NULL,
    pmid    VARCHAR(50) NOT NULL,

    PRIMARY KEY (concept, id, pmid),

    FOREIGN KEY (concept) REFERENCES concepts(concept) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE pubmed_specific_hits
(
    pmid     VARCHAR(50) NOT NULL,
    ec       VARCHAR(50) NOT NULL,
    cpd_hits FLOAT NOT NULL,
    sce_hits FLOAT NOT NULL,
    ec_hit   INT,

    PRIMARY KEY (pmid, ec)
);


CREATE TABLE pubmed_user
(
    pmid VARCHAR(50) NOT NULL,

    PRIMARY KEY (pmid)
);


CREATE TABLE rel_ec_cpd
(
    ec  VARCHAR(50) NOT NULL,
    cpd VARCHAR(50) NOT NULL,

    PRIMARY KEY (ec, cpd),

    FOREIGN KEY (cpd) REFERENCES con_cpd(id) ON UPDATE CASCADE ON DELETE CASCADE,

    FOREIGN KEY (ec) REFERENCES con_ec(id) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE rel_ec_sce
(
    ec  VARCHAR(50) NOT NULL,
    sce VARCHAR(50) NOT NULL,

    PRIMARY KEY (ec, sce),

    FOREIGN KEY (sce) REFERENCES con_sce(id) ON UPDATE CASCADE ON DELETE CASCADE,

    FOREIGN KEY (ec) REFERENCES con_ec(id) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE stop_list
(
    token VARCHAR(50) NOT NULL,

    PRIMARY KEY (token)
);


CREATE TABLE term_cpd
(
    id   VARCHAR(50) NOT NULL,
    term VARCHAR(200) NOT NULL,

    PRIMARY KEY (id, term),

    FOREIGN KEY (id) REFERENCES con_cpd(id) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE term_ec
(
    id   VARCHAR(50) NOT NULL,
    term VARCHAR(200) NOT NULL,

    PRIMARY KEY (id, term),

    FOREIGN KEY (id) REFERENCES con_ec(id) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE term_go
(
    id   VARCHAR(50) NOT NULL,
    term VARCHAR(200) NOT NULL,

    PRIMARY KEY (id, term)
);


CREATE TABLE term_sbo
(
    id   VARCHAR(50) NOT NULL,
    term VARCHAR(200) NOT NULL,

    PRIMARY KEY (id, term)
);


CREATE TABLE term_sce
(
    id   VARCHAR(50) NOT NULL,
    term VARCHAR(200) NOT NULL,

    PRIMARY KEY (id, term),

    FOREIGN KEY (id) REFERENCES con_sce(id) ON UPDATE CASCADE ON DELETE CASCADE
);


CREATE TABLE tmp
(
    id VARCHAR(12),
    sc FLOAT
);


CREATE TABLE tmp2
(
    id   VARCHAR(50) NOT NULL,
    term VARCHAR(200) NOT NULL
);


CREATE TABLE tmp3
(
    id    VARCHAR(50) NOT NULL,
    link1 VARCHAR(50),
    link2 VARCHAR(50)
);


INSERT INTO stop_list VALUES ('a');
INSERT INTO stop_list VALUES ('about');
INSERT INTO stop_list VALUES ('above');
INSERT INTO stop_list VALUES ('across');
INSERT INTO stop_list VALUES ('after');
INSERT INTO stop_list VALUES ('afterwards');
INSERT INTO stop_list VALUES ('again');
INSERT INTO stop_list VALUES ('against');
INSERT INTO stop_list VALUES ('all');
INSERT INTO stop_list VALUES ('almost');
INSERT INTO stop_list VALUES ('alone');
INSERT INTO stop_list VALUES ('along');
INSERT INTO stop_list VALUES ('already');
INSERT INTO stop_list VALUES ('also');
INSERT INTO stop_list VALUES ('although');
INSERT INTO stop_list VALUES ('always');
INSERT INTO stop_list VALUES ('am');
INSERT INTO stop_list VALUES ('among');
INSERT INTO stop_list VALUES ('amongst');
INSERT INTO stop_list VALUES ('amoungst');
INSERT INTO stop_list VALUES ('amount');
INSERT INTO stop_list VALUES ('an');
INSERT INTO stop_list VALUES ('and');
INSERT INTO stop_list VALUES ('another');
INSERT INTO stop_list VALUES ('any');
INSERT INTO stop_list VALUES ('anyhow');
INSERT INTO stop_list VALUES ('anyone');
INSERT INTO stop_list VALUES ('anything');
INSERT INTO stop_list VALUES ('anyway');
INSERT INTO stop_list VALUES ('anywhere');
INSERT INTO stop_list VALUES ('are');
INSERT INTO stop_list VALUES ('around');
INSERT INTO stop_list VALUES ('as');
INSERT INTO stop_list VALUES ('at');
INSERT INTO stop_list VALUES ('back');
INSERT INTO stop_list VALUES ('be');
INSERT INTO stop_list VALUES ('became');
INSERT INTO stop_list VALUES ('because');
INSERT INTO stop_list VALUES ('become');
INSERT INTO stop_list VALUES ('becomes');
INSERT INTO stop_list VALUES ('becoming');
INSERT INTO stop_list VALUES ('been');
INSERT INTO stop_list VALUES ('before');
INSERT INTO stop_list VALUES ('beforehand');
INSERT INTO stop_list VALUES ('behind');
INSERT INTO stop_list VALUES ('being');
INSERT INTO stop_list VALUES ('below');
INSERT INTO stop_list VALUES ('beside');
INSERT INTO stop_list VALUES ('besides');
INSERT INTO stop_list VALUES ('between');
INSERT INTO stop_list VALUES ('beyond');
INSERT INTO stop_list VALUES ('bill');
INSERT INTO stop_list VALUES ('both');
INSERT INTO stop_list VALUES ('bottom');
INSERT INTO stop_list VALUES ('but');
INSERT INTO stop_list VALUES ('by');
INSERT INTO stop_list VALUES ('call');
INSERT INTO stop_list VALUES ('can');
INSERT INTO stop_list VALUES ('cannot');
INSERT INTO stop_list VALUES ('cant');
INSERT INTO stop_list VALUES ('co');
INSERT INTO stop_list VALUES ('computer');
INSERT INTO stop_list VALUES ('con');
INSERT INTO stop_list VALUES ('could');
INSERT INTO stop_list VALUES ('couldnt');
INSERT INTO stop_list VALUES ('cry');
INSERT INTO stop_list VALUES ('de');
INSERT INTO stop_list VALUES ('describe');
INSERT INTO stop_list VALUES ('detail');
INSERT INTO stop_list VALUES ('do');
INSERT INTO stop_list VALUES ('done');
INSERT INTO stop_list VALUES ('down');
INSERT INTO stop_list VALUES ('due');
INSERT INTO stop_list VALUES ('during');
INSERT INTO stop_list VALUES ('each');
INSERT INTO stop_list VALUES ('eg');
INSERT INTO stop_list VALUES ('eight');
INSERT INTO stop_list VALUES ('either');
INSERT INTO stop_list VALUES ('eleven');
INSERT INTO stop_list VALUES ('else');
INSERT INTO stop_list VALUES ('elsewhere');
INSERT INTO stop_list VALUES ('empty');
INSERT INTO stop_list VALUES ('enough');
INSERT INTO stop_list VALUES ('etc');
INSERT INTO stop_list VALUES ('even');
INSERT INTO stop_list VALUES ('ever');
INSERT INTO stop_list VALUES ('every');
INSERT INTO stop_list VALUES ('everyone');
INSERT INTO stop_list VALUES ('everything');
INSERT INTO stop_list VALUES ('everywhere');
INSERT INTO stop_list VALUES ('except');
INSERT INTO stop_list VALUES ('few');
INSERT INTO stop_list VALUES ('fifteen');
INSERT INTO stop_list VALUES ('fify');
INSERT INTO stop_list VALUES ('fill');
INSERT INTO stop_list VALUES ('find');
INSERT INTO stop_list VALUES ('fire');
INSERT INTO stop_list VALUES ('first');
INSERT INTO stop_list VALUES ('five');
INSERT INTO stop_list VALUES ('for');
INSERT INTO stop_list VALUES ('former');
INSERT INTO stop_list VALUES ('formerly');
INSERT INTO stop_list VALUES ('forty');
INSERT INTO stop_list VALUES ('found');
INSERT INTO stop_list VALUES ('four');
INSERT INTO stop_list VALUES ('from');
INSERT INTO stop_list VALUES ('front');
INSERT INTO stop_list VALUES ('full');
INSERT INTO stop_list VALUES ('further');
INSERT INTO stop_list VALUES ('get');
INSERT INTO stop_list VALUES ('give');
INSERT INTO stop_list VALUES ('go');
INSERT INTO stop_list VALUES ('had');
INSERT INTO stop_list VALUES ('has');
INSERT INTO stop_list VALUES ('hasnt');
INSERT INTO stop_list VALUES ('have');
INSERT INTO stop_list VALUES ('he');
INSERT INTO stop_list VALUES ('hence');
INSERT INTO stop_list VALUES ('her');
INSERT INTO stop_list VALUES ('here');
INSERT INTO stop_list VALUES ('hereafter');
INSERT INTO stop_list VALUES ('hereby');
INSERT INTO stop_list VALUES ('herein');
INSERT INTO stop_list VALUES ('hereupon');
INSERT INTO stop_list VALUES ('hers');
INSERT INTO stop_list VALUES ('herself');
INSERT INTO stop_list VALUES ('him');
INSERT INTO stop_list VALUES ('himself');
INSERT INTO stop_list VALUES ('his');
INSERT INTO stop_list VALUES ('how');
INSERT INTO stop_list VALUES ('however');
INSERT INTO stop_list VALUES ('hundred');
INSERT INTO stop_list VALUES ('i');
INSERT INTO stop_list VALUES ('ie');
INSERT INTO stop_list VALUES ('if');
INSERT INTO stop_list VALUES ('in');
INSERT INTO stop_list VALUES ('inc');
INSERT INTO stop_list VALUES ('indeed');
INSERT INTO stop_list VALUES ('interest');
INSERT INTO stop_list VALUES ('into');
INSERT INTO stop_list VALUES ('is');
INSERT INTO stop_list VALUES ('it');
INSERT INTO stop_list VALUES ('its');
INSERT INTO stop_list VALUES ('itself');
INSERT INTO stop_list VALUES ('keep');
INSERT INTO stop_list VALUES ('last');
INSERT INTO stop_list VALUES ('latter');
INSERT INTO stop_list VALUES ('latterly');
INSERT INTO stop_list VALUES ('least');
INSERT INTO stop_list VALUES ('less');
INSERT INTO stop_list VALUES ('ltd');
INSERT INTO stop_list VALUES ('made');
INSERT INTO stop_list VALUES ('many');
INSERT INTO stop_list VALUES ('may');
INSERT INTO stop_list VALUES ('me');
INSERT INTO stop_list VALUES ('meanwhile');
INSERT INTO stop_list VALUES ('might');
INSERT INTO stop_list VALUES ('mill');
INSERT INTO stop_list VALUES ('mine');
INSERT INTO stop_list VALUES ('more');
INSERT INTO stop_list VALUES ('moreover');
INSERT INTO stop_list VALUES ('most');
INSERT INTO stop_list VALUES ('mostly');
INSERT INTO stop_list VALUES ('move');
INSERT INTO stop_list VALUES ('much');
INSERT INTO stop_list VALUES ('must');
INSERT INTO stop_list VALUES ('my');
INSERT INTO stop_list VALUES ('myself');
INSERT INTO stop_list VALUES ('name');
INSERT INTO stop_list VALUES ('namely');
INSERT INTO stop_list VALUES ('neither');
INSERT INTO stop_list VALUES ('never');
INSERT INTO stop_list VALUES ('nevertheless');
INSERT INTO stop_list VALUES ('next');
INSERT INTO stop_list VALUES ('nine');
INSERT INTO stop_list VALUES ('no');
INSERT INTO stop_list VALUES ('nobody');
INSERT INTO stop_list VALUES ('none');
INSERT INTO stop_list VALUES ('noone');
INSERT INTO stop_list VALUES ('nor');
INSERT INTO stop_list VALUES ('not');
INSERT INTO stop_list VALUES ('nothing');
INSERT INTO stop_list VALUES ('now');
INSERT INTO stop_list VALUES ('nowhere');
INSERT INTO stop_list VALUES ('of');
INSERT INTO stop_list VALUES ('off');
INSERT INTO stop_list VALUES ('often');
INSERT INTO stop_list VALUES ('on');
INSERT INTO stop_list VALUES ('once');
INSERT INTO stop_list VALUES ('one');
INSERT INTO stop_list VALUES ('only');
INSERT INTO stop_list VALUES ('onto');
INSERT INTO stop_list VALUES ('or');
INSERT INTO stop_list VALUES ('other');
INSERT INTO stop_list VALUES ('others');
INSERT INTO stop_list VALUES ('otherwise');
INSERT INTO stop_list VALUES ('our');
INSERT INTO stop_list VALUES ('ours');
INSERT INTO stop_list VALUES ('ourselves');
INSERT INTO stop_list VALUES ('out');
INSERT INTO stop_list VALUES ('over');
INSERT INTO stop_list VALUES ('own');
INSERT INTO stop_list VALUES ('part');
INSERT INTO stop_list VALUES ('per');
INSERT INTO stop_list VALUES ('perhaps');
INSERT INTO stop_list VALUES ('please');
INSERT INTO stop_list VALUES ('put');
INSERT INTO stop_list VALUES ('rather');
INSERT INTO stop_list VALUES ('re');
INSERT INTO stop_list VALUES ('same');
INSERT INTO stop_list VALUES ('see');
INSERT INTO stop_list VALUES ('seem');
INSERT INTO stop_list VALUES ('seemed');
INSERT INTO stop_list VALUES ('seeming');
INSERT INTO stop_list VALUES ('seems');
INSERT INTO stop_list VALUES ('serious');
INSERT INTO stop_list VALUES ('several');
INSERT INTO stop_list VALUES ('she');
INSERT INTO stop_list VALUES ('should');
INSERT INTO stop_list VALUES ('show');
INSERT INTO stop_list VALUES ('side');
INSERT INTO stop_list VALUES ('since');
INSERT INTO stop_list VALUES ('sincere');
INSERT INTO stop_list VALUES ('six');
INSERT INTO stop_list VALUES ('sixty');
INSERT INTO stop_list VALUES ('so');
INSERT INTO stop_list VALUES ('some');
INSERT INTO stop_list VALUES ('somehow');
INSERT INTO stop_list VALUES ('someone');
INSERT INTO stop_list VALUES ('something');
INSERT INTO stop_list VALUES ('sometime');
INSERT INTO stop_list VALUES ('sometimes');
INSERT INTO stop_list VALUES ('somewhere');
INSERT INTO stop_list VALUES ('still');
INSERT INTO stop_list VALUES ('such');
INSERT INTO stop_list VALUES ('system');
INSERT INTO stop_list VALUES ('take');
INSERT INTO stop_list VALUES ('ten');
INSERT INTO stop_list VALUES ('than');
INSERT INTO stop_list VALUES ('that');
INSERT INTO stop_list VALUES ('the');
INSERT INTO stop_list VALUES ('their');
INSERT INTO stop_list VALUES ('them');
INSERT INTO stop_list VALUES ('themselves');
INSERT INTO stop_list VALUES ('then');
INSERT INTO stop_list VALUES ('thence');
INSERT INTO stop_list VALUES ('there');
INSERT INTO stop_list VALUES ('thereafter');
INSERT INTO stop_list VALUES ('thereby');
INSERT INTO stop_list VALUES ('therefore');
INSERT INTO stop_list VALUES ('therein');
INSERT INTO stop_list VALUES ('thereupon');
INSERT INTO stop_list VALUES ('these');
INSERT INTO stop_list VALUES ('they');
INSERT INTO stop_list VALUES ('thick');
INSERT INTO stop_list VALUES ('thin');
INSERT INTO stop_list VALUES ('third');
INSERT INTO stop_list VALUES ('this');
INSERT INTO stop_list VALUES ('those');
INSERT INTO stop_list VALUES ('though');
INSERT INTO stop_list VALUES ('three');
INSERT INTO stop_list VALUES ('through');
INSERT INTO stop_list VALUES ('throughout');
INSERT INTO stop_list VALUES ('thru');
INSERT INTO stop_list VALUES ('thus');
INSERT INTO stop_list VALUES ('to');
INSERT INTO stop_list VALUES ('together');
INSERT INTO stop_list VALUES ('too');
INSERT INTO stop_list VALUES ('top');
INSERT INTO stop_list VALUES ('toward');
INSERT INTO stop_list VALUES ('towards');
INSERT INTO stop_list VALUES ('twelve');
INSERT INTO stop_list VALUES ('twenty');
INSERT INTO stop_list VALUES ('two');
INSERT INTO stop_list VALUES ('un');
INSERT INTO stop_list VALUES ('under');
INSERT INTO stop_list VALUES ('until');
INSERT INTO stop_list VALUES ('up');
INSERT INTO stop_list VALUES ('upon');
INSERT INTO stop_list VALUES ('us');
INSERT INTO stop_list VALUES ('very');
INSERT INTO stop_list VALUES ('via');
INSERT INTO stop_list VALUES ('was');
INSERT INTO stop_list VALUES ('we');
INSERT INTO stop_list VALUES ('well');
INSERT INTO stop_list VALUES ('were');
INSERT INTO stop_list VALUES ('what');
INSERT INTO stop_list VALUES ('whatever');
INSERT INTO stop_list VALUES ('when');
INSERT INTO stop_list VALUES ('whence');
INSERT INTO stop_list VALUES ('whenever');
INSERT INTO stop_list VALUES ('where');
INSERT INTO stop_list VALUES ('whereafter');
INSERT INTO stop_list VALUES ('whereas');
INSERT INTO stop_list VALUES ('whereby');
INSERT INTO stop_list VALUES ('wherein');
INSERT INTO stop_list VALUES ('whereupon');
INSERT INTO stop_list VALUES ('wherever');
INSERT INTO stop_list VALUES ('whether');
INSERT INTO stop_list VALUES ('which');
INSERT INTO stop_list VALUES ('while');
INSERT INTO stop_list VALUES ('whither');
INSERT INTO stop_list VALUES ('who');
INSERT INTO stop_list VALUES ('whoever');
INSERT INTO stop_list VALUES ('whole');
INSERT INTO stop_list VALUES ('whom');
INSERT INTO stop_list VALUES ('whose');
INSERT INTO stop_list VALUES ('why');
INSERT INTO stop_list VALUES ('will');
INSERT INTO stop_list VALUES ('with');
INSERT INTO stop_list VALUES ('within');
INSERT INTO stop_list VALUES ('without');
INSERT INTO stop_list VALUES ('would');
INSERT INTO stop_list VALUES ('yet');
INSERT INTO stop_list VALUES ('you');
INSERT INTO stop_list VALUES ('your');
INSERT INTO stop_list VALUES ('yours');
INSERT INTO stop_list VALUES ('yourself');
INSERT INTO stop_list VALUES ('yourselves');
INSERT INTO stop_list VALUES ('atomic');
INSERT INTO stop_list VALUES ('blood');
INSERT INTO stop_list VALUES ('bound');
INSERT INTO stop_list VALUES ('disordered');
INSERT INTO stop_list VALUES ('distilled');
INSERT INTO stop_list VALUES ('maxim');
INSERT INTO stop_list VALUES ('monobasic');
INSERT INTO stop_list VALUES ('natural');
INSERT INTO stop_list VALUES ('primary');
INSERT INTO stop_list VALUES ('purified');
INSERT INTO stop_list VALUES ('sterile');
INSERT INTO stop_list VALUES ('unknown');
INSERT INTO stop_list VALUES ('victor');
INSERT INTO stop_list VALUES ('deionized');
INSERT INTO stop_list VALUES ('deuterated');
INSERT INTO stop_list VALUES ('white');


INSERT INTO html VALUES (0, '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>

<title>KiPar: information retrieval for kinetic parameters</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="KiPar.css" />


<script language="JavaScript" type="text/javascript">

(document.getElementById) ? dom = true : dom = false;

function typeStart()
{
  if (dom) { document.write(''<div id="topMenu" style="position:absolute; left:0; visibility:show; solid #000000">'') }
}

function typeEnd() { if (dom) { document.write(''</div>'') } }

function placeIt()
{
  if (dom && !document.all) {document.getElementById("topMenu").style.top = window.pageYOffset + 0;}
  if (document.all) {document.all.topMenu.style.pixelTop = document.body.scrollTop + 0}
  window.setTimeout("placeIt()", 10);
}
');
INSERT INTO html VALUES (3, '</div>
</td></tr></table>
</ul>	

</TD></TR>
</TABLE>
</div>

</body>
</html>');
INSERT INTO html VALUES (2, '</div>
<script>typeEnd()</script>


<div align="Center">

<TABLE WIDTH="80%">
<TR><TD>

<ul>');
INSERT INTO html VALUES (1, 'var B_SFIX = "_button";

function init()
{
  placeIt();
  collapseAll(abBoxes);
  viewControlButtons(abBoxes);
  collapseAll(hiBoxes);
  viewControlButtons(hiBoxes);
}

function getElementObject(elementID)
{
  var elemObj = null;

  if (document.getElementById)
  {
    elemObj = document.getElementById(elementID);
  }

  return elemObj;
}            

function closeBox(boxObj, buttonObj)
{
  if (boxObj == null || buttonObj == null) {} 
  else
  {
    boxObj.style.display="none";
    if (boxObj.style.display=="none") {buttonObj.value=" + ";}
  }
}

function openBox(boxObj, buttonObj)
{
  if (boxObj == null || buttonObj == null) {} 
  else
  {
    boxObj.style.display="block";
    if (boxObj.style.display=="block") {buttonObj.value=" - ";}
  }
}

function switchState(boxID)
{
  var boxObj = getElementObject(boxID);
  var buttonObj = getElementObject(boxID+B_SFIX);

  if (boxObj == null || buttonObj == null) {} 
  else if (boxObj.style.display=="none")   { openBox(boxObj, buttonObj);} 
  else if (boxObj.style.display=="block")  {closeBox(boxObj, buttonObj);}
}

function collapseAll(boxList)
{
  var idx;

  for (idx = 0; idx < boxList.length; idx++)
  {
    var boxObj = getElementObject(boxList[idx]);
    var buttonObj = getElementObject(boxList[idx]+B_SFIX);
    closeBox(boxObj, buttonObj);
  }
}

function expandAll(boxList)
{
  var idx;
  for (idx = 0; idx < boxList.length; idx++)
  {
    var boxObj = getElementObject(boxList[idx]);
    var buttonObj = getElementObject(boxList[idx]+B_SFIX);
    openBox(boxObj, buttonObj);
  }
}

function viewControlButtons(boxList)
{
  var idx;
  for (idx = 0; idx < boxList.length; idx++)
  {
    buttonObj = getElementObject(boxList[idx]+B_SFIX);
    if (buttonObj != null) {buttonObj.style.display = "inline";}
  }
}

function hideControlButtons(boxList)
{
  var idx;
  for (idx = 0; idx < boxList.length; idx++)
  {
    buttonObj = getElementObject(boxList[idx]+B_SFIX);
    if (buttonObj != null) {buttonObj.style.display = "none";}
  }
}

</script>



</head>

<body onload="init();">


<script>typeStart()</script>
<div class="vague" style="width:100%; background-color:white">
&ensp;For all documents: 
&emsp;&bull; ( <a href="javascript:void(0)" onclick="expandAll(abBoxes)">expand</a> | <a href="javascript:void(0)" onclick="collapseAll(abBoxes)">collapse</a> ) abstract ');