refdb-cvs Mailing List for RefDB (Page 57)
Status: Beta
Brought to you by:
mhoenicka
Menu
▾
▴
refdb-cvs — All cvs checkins go to this list
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(47) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(88) |
Feb
(50) |
Mar
(36) |
Apr
(9) |
May
(30) |
Jun
(30) |
Jul
(22) |
Aug
(16) |
Sep
(42) |
Oct
(18) |
Nov
(29) |
Dec
(23) |
| 2005 |
Jan
(18) |
Feb
(28) |
Mar
(21) |
Apr
(35) |
May
(62) |
Jun
(22) |
Jul
(5) |
Aug
(40) |
Sep
(98) |
Oct
(81) |
Nov
(51) |
Dec
(62) |
| 2006 |
Jan
(46) |
Feb
(36) |
Mar
(8) |
Apr
(16) |
May
(14) |
Jun
(16) |
Jul
(47) |
Aug
(60) |
Sep
(34) |
Oct
(16) |
Nov
(46) |
Dec
(11) |
| 2007 |
Jan
(16) |
Feb
(13) |
Mar
(58) |
Apr
(32) |
May
(4) |
Jun
(8) |
Jul
(31) |
Aug
(46) |
Sep
(22) |
Oct
(30) |
Nov
(58) |
Dec
(15) |
| 2008 |
Jan
(8) |
Feb
(8) |
Mar
(2) |
Apr
(6) |
May
(3) |
Jun
(2) |
Jul
(1) |
Aug
|
Sep
|
Oct
(6) |
Nov
(3) |
Dec
(5) |
| 2009 |
Jan
(1) |
Feb
(20) |
Mar
(8) |
Apr
(5) |
May
(8) |
Jun
(3) |
Jul
(6) |
Aug
(4) |
Sep
(7) |
Oct
(8) |
Nov
(2) |
Dec
(1) |
| 2010 |
Jan
(1) |
Feb
(4) |
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2011 |
Jan
(5) |
Feb
(5) |
Mar
(13) |
Apr
(3) |
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
(1) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
(5) |
Nov
|
Dec
(3) |
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
(13) |
| 2014 |
Jan
(2) |
Feb
(2) |
Mar
(2) |
Apr
(4) |
May
(1) |
Jun
(1) |
Jul
|
Aug
(6) |
Sep
(3) |
Oct
|
Nov
(2) |
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(3) |
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2022 |
Jan
(9) |
Feb
(16) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Markus H. <mho...@us...> - 2005-03-29 19:44:23
|
Update of /cvsroot/refdb/homepage In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28306 Modified Files: download.html Log Message: added .deb Index: download.html =================================================================== RCS file: /cvsroot/refdb/homepage/download.html,v retrieving revision 1.2 retrieving revision 1.3 diff -u -U2 -r1.2 -r1.3 --- download.html 1 Feb 2005 20:39:15 -0000 1.2 +++ download.html 29 Mar 2005 19:44:13 -0000 1.3 @@ -158,5 +158,5 @@ <h2 id="prereleases">Prereleases</h2> - <p>If you don't want to fiddle with CVS (see the next section) but would like to help testing, consider using the latest prerelease. These archives can be installed just like regular releases, but they may not be as well-tested as these. However, you'll get bugfixes and new features that are otherwise only in the CVS version. The latest prerelease, if any, is always right <a href="pre/refdb-latest.tar.gz">here</a>.</p> + <p>If you don't want to fiddle with CVS (see the next section) but would like to help testing, consider using the latest prerelease. These archives can be installed just like regular releases, but they may not be as well-tested as these. However, you'll get bugfixes and new features that are otherwise only in the CVS version. The latest prerelease, if any, is always right <a href="pre/refdb-latest.tar.gz">here</a>. There is also a new and shiny <a href="http://www.debian.org">Debian</a> package of <a href="pre/refdb_0.9.6-pre1-1_i386.deb">refdb-0.9.6-pre1</a>. Please be aware that this package is still <em>experimental</em>.</p> <h2 id="cvseasy">CVS made easy</h2> |
|
From: Markus H. <mho...@us...> - 2005-03-23 10:39:29
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20970 Modified Files: Tag: Release_0_9_5_stable marc2ris.pl.in Log Message: fixed marcprint check Index: marc2ris.pl.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/marc2ris.pl.in,v retrieving revision 1.2 retrieving revision 1.2.2.1 diff -u -U2 -r1.2 -r1.2.2.1 --- marc2ris.pl.in 25 Apr 2003 22:35:25 -0000 1.2 +++ marc2ris.pl.in 23 Mar 2005 10:39:18 -0000 1.2.2.1 @@ -178,4 +178,5 @@ } +$marcprint = ($marcprint eq "t") ? $marcprint : undef; ## if we're supposed to write to an output file, try to open it |
|
From: Markus H. <mho...@us...> - 2005-03-16 20:35:34
|
Update of /cvsroot/refdb/homepage In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17945 Modified Files: features.html Log Message: added comments about character encodings and about concurrent access Index: features.html =================================================================== RCS file: /cvsroot/refdb/homepage/features.html,v retrieving revision 1.2 retrieving revision 1.3 diff -u -U2 -r1.2 -r1.3 --- features.html 24 Dec 2004 15:27:18 -0000 1.2 +++ features.html 16 Mar 2005 20:35:20 -0000 1.3 @@ -165,5 +165,5 @@ <li>Import filters are provided for Medline (tagged and XML), BibTeX, MARC, and DocBook.</li> <li>The data can be retrieved as simple text, formatted as HTML, formatted as a DocBook <code>bibliography</code> element (SGML or XML), formatted as a TEI <code>listBibl</code> element (XML), formatted as BibTeX reference list, or formatted as RIS or risx files.</li> - <li>All character encodings supported by your platform can be used both for data input and for data export.</li> + <li>All character encodings supported by your platform can be used both for data input and for data export. This includes European character sets like Latin-1 and of course Unicode.</li> <li>Extended notes can be linked to one or more references, authors, periodicals, or keywords to create topics or material collections. These are more powerful and flexible than folder systems and the like.</li> <li>The query language is fairly simple yet powerful. You can use booleans to combine queries on any combination of fields. You can use brackets to group queries. You can use Unix-style regular expressions to formulate advanced queries.</li> @@ -187,4 +187,5 @@ <li>Due to the client/server design, RefDB is very well suited as a shared reference database for a workgroup or a department. However, it runs just fine on a single standalone workstation.</li> <li>Users can share databases and still have their personal reference lists.</li> + <li>Concurrent read and write access of several users is supported. There is no need to restrict access of other users to read-only. However, if your database engine supports access control (MySQL and PostgreSQL), you <em>can</em> restrict access of some users to read-only.</li> <li>A simple method to access electronic offprints (e.g. in PDF or PostScript format) is provided in the HTML output and in the web interface. This also works across networks using mounted shares.</li> </ul> |
|
From: Markus H. <mho...@us...> - 2005-03-16 20:34:42
|
Update of /cvsroot/refdb/homepage In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17757 Modified Files: sysreq.html Log Message: added links to OSes Index: sysreq.html =================================================================== RCS file: /cvsroot/refdb/homepage/sysreq.html,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -U2 -r1.1.1.1 -r1.2 --- sysreq.html 13 Dec 2004 21:19:39 -0000 1.1.1.1 +++ sysreq.html 16 Mar 2005 20:34:29 -0000 1.2 @@ -107,5 +107,5 @@ <div id="main"> <h1>RefDB System Requirements</h1> - <p>RefDB is designed to run on Unix-like operating systems. Linux, FreeBSD, NetBSD, SunOS/Solaris, OSX/Darwin, and Windows/<a href="http://www.cygwin.com">Cygwin</a> are supported out of the tarball, and other BSD or SysV-derived systems may work just fine. It relies on a few external programs and libraries. The following list explains what else you'll need and where to get it from. Please refer to the <a href="doc.html#manual">manual</a> for specific installation and setup instructions.</p> + <p>RefDB is designed to run on Unix-like operating systems. <a href="http://www.linux.org">Linux</a>, <a href="http://www.freebsd.org">FreeBSD</a>, <a href="http://www.netbsd.org">NetBSD</a>, <a href="http://www.sun.com/software/solaris/">SunOS/Solaris</a>, <a href="http://www.apple.com/macosx/">OSX</a>/<a href="http://developer.apple.com/darwin/">Darwin</a>, and <a href="http://www.microsoft.com/windows/default.mspx">Windows</a>/<a href="http://www.cygwin.com">Cygwin</a> are supported out of the tarball, and other BSD or SysV-derived systems may work just fine. It relies on a few external programs and libraries. The following list explains what else you'll need and where to get it from. Please refer to the <a href="doc.html#manual">manual</a> for specific installation and setup instructions.</p> <div class="localnav"> |
|
From: Markus H. <mho...@us...> - 2005-03-01 12:25:52
|
Update of /cvsroot/refdb/refdb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1901 Modified Files: configure.in Log Message: fixed automake version issue Index: configure.in =================================================================== RCS file: /cvsroot/refdb/refdb/configure.in,v retrieving revision 1.49 retrieving revision 1.50 diff -u -U2 -r1.49 -r1.50 --- configure.in 1 May 2004 23:41:31 -0000 1.49 +++ configure.in 1 Mar 2005 12:25:33 -0000 1.50 @@ -5,11 +5,11 @@ AC_INIT(src/backend-bibtex.c) -dnl Use automake -AM_INIT_AUTOMAKE(refdb, 0.9.5-pre1) - dnl Find out host type AC_CONFIG_AUX_DIR(./conf) AC_CANONICAL_HOST +dnl Use automake +AM_INIT_AUTOMAKE(refdb, 0.9.5-pre1) + dnl see where the libdbi lib is AC_ARG_WITH(libdbi-lib, |
|
From: David N. <dav...@us...> - 2005-02-19 11:46:42
|
Update of /cvsroot/refdb/makestyle In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23776 Modified Files: refdb-ms.pl Log Message: Now compliant with version 1.3 of citestylex dtd. Index: refdb-ms.pl =================================================================== RCS file: /cvsroot/refdb/makestyle/refdb-ms.pl,v retrieving revision 1.3 retrieving revision 1.4 diff -u -U2 -r1.3 -r1.4 --- refdb-ms.pl 30 Sep 2004 14:36:32 -0000 1.3 +++ refdb-ms.pl 19 Feb 2005 11:46:31 -0000 1.4 @@ -218,5 +218,5 @@ . " If no default editor is specified, vi(m) is used.\n" . " To exit this screen, exit the editor as you normally would" - . " - 'ZZ' for vi(m).]" + . " - 'ZQ' for vi(m).]" . "\n\n" . $body; @@ -597,4 +597,18 @@ } +package AlternateStyle; + use base qw/ _Attribute /; + + sub new { + my $proto = shift; + my $class = ref($proto) || $proto; + my $self = $class->SUPER::new(@_); + $self->set_name ( "ALTERNATESTYLE" ); + $self->add_enumeration( qw/ ABOLD ABOLDITALIC ABOLDITULINE ABOLDULINE AITALIC AITULINE ASUB ASUPER AULINE NONE / ); + $self->set_default ( "NONE" ); + $self->set_prompt ( "Warning: Not currently implemented.\nSome author-date bibliographic styles use title instead of author when there is no author specified. This attribute determines the style of the title when it is used this way. Options -- ABOLD = bold, ABOLDITALIC = bold italic, ABOLDITULINE = bold italic underlined, ABOLDULINE = bold underlined, AITALIC = italic, AITULINE = italic underlined, ASUB = subscript, ASUPER = superscript, AULINE = underlined and ANONE = no special formatting." ); + return $self; + } + package Role_AuthorList; use base qw/ _Attribute /; @@ -986,5 +1000,19 @@ } -package AlternateText; +package AlternateText_AuthorList; + use base qw/ _Attribute /; + + sub new { + my $proto = shift; + my $class = ref($proto) || $proto; + my $self = $class->SUPER::new(@_); + $self->set_name ( "ALTERNATETEXT" ); + $self->add_enumeration( qw/ AEMPTY NONE TITLEPRIMARY TITLESECONDARY TITLETERTIARY / ); + $self->set_default ( "AEMPTY" ); + $self->set_prompt ( "Warning: Not currently implemented.\nDefault = \"AEMPTY\".\nSome author-year styles use title instead of author when the author is not specified. This attribute determines what value to use instead of author when there is no author. Options -- AEMPTY = use value specified by element AEMPTY, NONE = author left blank, TITLEPRIMARY = use primary title, TITLESECONDARY = use secondary title and TITLETERTIARY = use tertiary title." ); + return $self; + } + +package AlternateText_JournalName; use base qw/ _Attribute /; @@ -1060,5 +1088,5 @@ $self->set_name ( "BIBLIOSEQUENCE" ); $self->add_enumeration( qw/ BASIS BAUTHORDATE BDATEASC BDATEDESC / ); - $self->set_default ( "BAUTHORDAT" ); + $self->set_default ( "BAUTHORDATE" ); $self->set_prompt ( "Default = \"BAUTHORDATE\".\nDetermines the order of references in bibliography. The options are: BASIS = same order as citations appear in document, BAUTHORDATE = sort on author then date, BDATEASC = sort on date ascending and BDATEDESC = sort on date descending." ); return $self; @@ -3959,5 +3987,5 @@ $self->{attributes}->{selected}[$_]->get_value() ); - } + } } else { $output .= "<i>No styling changes specified</i></div>\n<div>"; @@ -4360,5 +4388,5 @@ $self->set_attributes( { mandatory => [ "Role_AuthorList" ] , - optional => [ "Style" ] , + optional => [ "AlternateStyle" , "AlternateText_AuthorList" , "Style" ] , } ); $self->set_order( [ @@ -4761,5 +4789,5 @@ $self->set_attributes( { mandatory => undef , - optional => [ "AlternateText" , "DefaultText" , "DefaultText" , "Punctuation" , "Case" , "Style" ] , + optional => [ "AlternateText_JournalName" , "DefaultText" , "DefaultText" , "Punctuation" , "Case" , "Style" ] , } ); $self->set_order( [ @@ -5207,5 +5235,5 @@ $self->set_attributes( { mandatory => undef , - optional => [ "BiblioFirstIndent" , "BiblioSequence" , "BiblioBlockIndent" , "FontSize" ] , + optional => [ "BiblioSequence" , "BiblioFirstIndent" , "BiblioBlockIndent" , "FontSize" ] , } ); $self->set_order( [ |
|
From: Markus H. <mho...@us...> - 2005-02-13 23:09:17
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11149/src Modified Files: Tag: Release_0_9_5_stable refdbd.c Log Message: changed two leftover strdup calls to strcpy Index: refdbd.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbd.c,v retrieving revision 1.74.2.8 retrieving revision 1.74.2.9 diff -u -U2 -r1.74.2.8 -r1.74.2.9 --- refdbd.c 11 Feb 2005 22:22:46 -0000 1.74.2.8 +++ refdbd.c 13 Feb 2005 23:09:07 -0000 1.74.2.9 @@ -1120,8 +1120,8 @@ LOG_PRINT(LOG_INFO, "command line error"); if (ptr_child_clrequest->n_cgi) { - child_returnmsg = strdup("Content-type: text/plain\n\ncommand line error"); + strcpy(child_returnmsg, "Content-type: text/plain\n\ncommand line error"); } else { - child_returnmsg = strdup("command line error"); + strcpy(child_returnmsg, "command line error"); } retval = 1; |
|
From: Markus H. <mho...@us...> - 2005-02-13 22:57:16
|
Update of /cvsroot/refdb/refdb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6636 Modified Files: Tag: Release_0_9_5_stable UPGRADING Log Message: added upgrade instructions for 0.9.6-pre1 Index: UPGRADING =================================================================== RCS file: /cvsroot/refdb/refdb/UPGRADING,v retrieving revision 1.7.2.1 retrieving revision 1.7.2.2 diff -u -U2 -r1.7.2.1 -r1.7.2.2 --- UPGRADING 13 Dec 2004 20:24:06 -0000 1.7.2.1 +++ UPGRADING 13 Feb 2005 22:57:06 -0000 1.7.2.2 @@ -9,4 +9,5 @@ databases: +0.9.5 -> 0.9.6-preX 0.9.4 -> 0.9.5 0.9.3 -> 0.9.4 @@ -19,4 +20,54 @@ +Migrating your existing RefDB installation from 0.9.5 to 0.9.6-preX +=================================================================== + +__________ +Background + +As of 0.9.6-pre1, both reference and the main database are +versioned. The version numbers can be used by the server to avoid +compatibility problems instead of getting stuck in obscure +errors. Needless to say, this change once again requires updating your +databases. + +_________ +Procedure + +- While still running your existing installation, use the refdba + command getstyle to retrieve existing styles: + "getstyle -o stylename.xml stylename" + (you may skip this step if you have the XML files for all your + styles) + +- back up your reference data. Run these commands for each of your + reference databases: + getref -t risx -o dbname.xml :ID:>0 + getnote -o dbname.notes.xml :NID:>0 + +- stop refdbd + +- use the command-line client of your database engine to make backups + of your system and reference databases. + +- Use the command-line client of your database engine to remove your + existing system database "refdb". + +- Follow the instructions to generate the system database + "refdb". Please be aware that there are two different dump files for + MySQL: refdb.dump.mysql replaces the previous refdb.dump and is + meant for MySQL versions prior to 4.1. For versions 4.1 and later, + please use refdb.dump.mysql41. + +- Now install 0.9.6-preX. Make sure to restart refdbd. + +- Add your styles using the refdba command addstyle: + "addstyle stylename.xml" + +- reload your reference and notes data: + addref -t risx dbname.xml + addnote dbname.notes.xml + + Migrating your existing RefDB installation from 0.9.4 to 0.9.5 ============================================================== |
|
From: Markus H. <mho...@us...> - 2005-02-13 16:35:25
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25573 Modified Files: Tag: Release_0_9_5_stable refdbda.c Log Message: added CREATE TEMP TABLES privilege for MySQL users, added FLUSH PRIVILEGES query to fix MySQL access problems, fixed string sizes Index: refdbda.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbda.c,v retrieving revision 1.41.2.6 retrieving revision 1.41.2.7 diff -u -U2 -r1.41.2.6 -r1.41.2.7 --- refdbda.c 12 Feb 2005 13:21:25 -0000 1.41.2.6 +++ refdbda.c 13 Feb 2005 16:35:11 -0000 1.41.2.7 @@ -471,5 +471,5 @@ char* outbuffer; /* ptr to a buffer for output */ const char* versioninfo = NULL; - char sql_command[32]; + char sql_command[64]; /* get a buffer to hold output data */ @@ -503,5 +503,5 @@ } } - + sprintf(outbuffer, "You are served by: %s %s\nClient IP: %s\nConnected via %s driver (%s)\nto: %s\ndb version: %d\nserverip: %s\ntimeout: %s\ndbs_port: %s\nlogfile: %s\nlogdest: %s\nloglevel: %s\nremoteadmin: %s\npidfile: %s\n", PACKAGE, @@ -1218,5 +1218,5 @@ if (!strcmp(drivername, "mysql")) { int create_new = 0; - char lockstring[13]; + char lockstring[64]; struct VERSIONINFO ver; @@ -1229,11 +1229,11 @@ } - /* MySQL 4.0.2 introduced a new privilege "LOCK TABLES". As older - versions will barf at it, add it only if we use a newer - version */ + /* MySQL 4.0.2 introduced new privileges "LOCK TABLES" and + "CREATE TEMPORARY TABLES". As older versions will barf at it, + add them only if we use a newer version */ if ((ver.major == 4 && ver.minor == 0 && ver.minuscule >=2) || (ver.major == 4 && ver.minor > 0) || ver.major > 4) { - strcpy(lockstring, ",LOCK TABLES "); + strcpy(lockstring, ",LOCK TABLES, CREATE TEMPORARY TABLES"); } else { @@ -1389,6 +1389,10 @@ /* reloading permission tables is not necessary when using - the GRANT/REVOKE syntax */ + the GRANT/REVOKE syntax. Thus quoth the manual, but seeing + is believing */ + strcpy(sql_command, "FLUSH PRIVILEGES"); + LOG_PRINT(LOG_DEBUG, sql_command); + dbires = dbi_conn_query(conn, sql_command); } |
|
From: Markus H. <mho...@us...> - 2005-02-13 16:32:39
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24395 Modified Files: Tag: Release_0_9_5_stable dbfncs.c Log Message: added transaction support for MySQL Index: dbfncs.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/dbfncs.c,v retrieving revision 1.15.2.5 retrieving revision 1.15.2.6 diff -u -U2 -r1.15.2.5 -r1.15.2.6 --- dbfncs.c 12 Feb 2005 13:19:46 -0000 1.15.2.5 +++ dbfncs.c 13 Feb 2005 16:32:29 -0000 1.15.2.6 @@ -55,12 +55,14 @@ if (!strcmp(ptr_clrequest->dbserver, "mysql")) { - /* these settings should work for 3.23 and later. We'll check the + /* these settings should work for 3.23.19 and later. We'll check the database engine version at runtime and fill in more appropriate - values if we're using a newer version */ + values if we're using a newer version. Some settings (like + transactions) are not supported by older versions, but do not cause + an error */ strcpy(ptr_caps->multiple_db, "t"); strcpy(ptr_caps->sql_enum, "t"); strcpy(ptr_caps->rlike, "RLIKE"); strcpy(ptr_caps->not_rlike, "NOT RLIKE"); - strcpy(ptr_caps->transaction, "f"); + strcpy(ptr_caps->transaction, "t"); strcpy(ptr_caps->localhost, "localhost"); strcpy(ptr_caps->encoding, ""); @@ -1379,5 +1381,12 @@ dbi_result_free(dbires); } - else if (!strcmp(drivername, "sqlite")) { + else { /* SQLite and MySQL */ + /* MySQL supports transactions only in transaction-safe tables + (InnoDB, BDB) but the transaction-related commands do not cause + errors in the other table types. Therefore it safe to use them + anyway, even if they don't have the desired effect. The + non-transaction-safe tables work in auto-commit mode, i.e. each + command is committed immediately. Rollbacks do not have any + effect in this case */ dbires = dbi_conn_query(conn, sql_command[1][trans_type]); LOG_PRINT(LOG_DEBUG, sql_command[1][trans_type]); @@ -1387,7 +1396,5 @@ dbi_result_free(dbires); } - /* else: transactions not supported by other drivers */ - /* ToDo: MySQL > 4.0 knows transactions, but how do we know the server - version? And the table type? */ + return 0; } |
|
From: Markus H. <mho...@us...> - 2005-02-12 13:21:35
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20403/src Modified Files: Tag: Release_0_9_5_stable refdbda.c Log Message: added log warnings if db does not support encodings Index: refdbda.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbda.c,v retrieving revision 1.41.2.5 retrieving revision 1.41.2.6 diff -u -U2 -r1.41.2.5 -r1.41.2.6 --- refdbda.c 12 Feb 2005 01:50:01 -0000 1.41.2.5 +++ refdbda.c 12 Feb 2005 13:21:25 -0000 1.41.2.6 @@ -906,4 +906,8 @@ } else { + if (db_encoding && *db_encoding) { + LOG_PRINT(LOG_WARNING, "database engine does not support per-database character encodings, used default encoding instead"); + } + /* db engine does not support database-based encodings */ sprintf(sql_command, "CREATE DATABASE %s", dbname); @@ -922,4 +926,7 @@ dbi_result_free(dbires); + } + else if (db_encoding && *db_encoding) { /* if sqlite */ + LOG_PRINT(LOG_WARNING, "database engine does not support per-database character encodings, used default encoding instead"); } /* end if not sqlite */ |
|
From: Markus H. <mho...@us...> - 2005-02-12 13:20:06
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19427/src Modified Files: Tag: Release_0_9_5_stable dbfncs.c Log Message: added version check for encoding stuff Index: dbfncs.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/dbfncs.c,v retrieving revision 1.15.2.4 retrieving revision 1.15.2.5 diff -u -U2 -r1.15.2.4 -r1.15.2.5 --- dbfncs.c 12 Feb 2005 01:50:01 -0000 1.15.2.4 +++ dbfncs.c 12 Feb 2005 13:19:46 -0000 1.15.2.5 @@ -55,4 +55,7 @@ if (!strcmp(ptr_clrequest->dbserver, "mysql")) { + /* these settings should work for 3.23 and later. We'll check the + database engine version at runtime and fill in more appropriate + values if we're using a newer version */ strcpy(ptr_caps->multiple_db, "t"); strcpy(ptr_caps->sql_enum, "t"); @@ -61,5 +64,5 @@ strcpy(ptr_caps->transaction, "f"); strcpy(ptr_caps->localhost, "localhost"); - strcpy(ptr_caps->encoding, "CHARACTER SET"); + strcpy(ptr_caps->encoding, ""); strcpy(ptr_caps->groups, "f"); strcpy(ptr_caps->admin_systable, "mysql.user"); @@ -1774,7 +1777,11 @@ if (!strcmp(drivername, "mysql")) { - if (ver.major >= 4) { + if (ver.major >= 4) { /* 4.0 and later */ strcpy(ptr_dbcaps->sql_union, "t"); } + if ((ver.major == 4 && ver.minor > 0) + || ver.major > 4) { /* 4.1 and later */ + strcpy(ptr_dbcaps->encoding, "CHARACTER SET"); + } } /* else: nothing to do */ |
|
From: Markus H. <mho...@us...> - 2005-02-12 13:18:44
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18848/scripts Modified Files: Tag: Release_0_9_5_stable med2ris.pl.in Log Message: fixed collective name handling Index: med2ris.pl.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/med2ris.pl.in,v retrieving revision 1.3.2.2 retrieving revision 1.3.2.3 diff -u -U2 -r1.3.2.2 -r1.3.2.3 --- med2ris.pl.in 7 Oct 2004 21:46:01 -0000 1.3.2.2 +++ med2ris.pl.in 12 Feb 2005 13:18:32 -0000 1.3.2.3 @@ -508,5 +508,8 @@ my $rawname; - if (defined ($forename)) { + if (defined ($collectivename)) { + $rawname = $collectivename; + } + elsif (defined ($forename)) { ## append a period if the last char is an initial $forename =~ s%([A-Z])$%$1.%g; @@ -653,12 +656,12 @@ || $elname eq "CollectiveName" || $elname eq "Initials") { - $currauthor{$elname} = $currel->{ELVALUE}; + $currauthor{$elname} .= $currel->{ELVALUE}; } elsif ($elname eq "RegistryNumber" || $elname eq "NameOfSubstance") { - $currchemical{$elname} = $currel->{ELVALUE}; + $currchemical{$elname} .= $currel->{ELVALUE}; } elsif ($elname eq "DescriptorName") { - $currmesh{$elname} = $currel->{ELVALUE}; + $currmesh{$elname} .= $currel->{ELVALUE}; } elsif ($elname eq "QualifierName") { |
|
From: Markus H. <mho...@us...> - 2005-02-12 01:50:10
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10081 Modified Files: Tag: Release_0_9_5_stable dbfncs.c dbfncs.h refdbda.c Log Message: added support for MySQL char encodings Index: dbfncs.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/dbfncs.c,v retrieving revision 1.15.2.3 retrieving revision 1.15.2.4 diff -u -U2 -r1.15.2.3 -r1.15.2.4 --- dbfncs.c 10 Feb 2005 20:38:14 -0000 1.15.2.3 +++ dbfncs.c 12 Feb 2005 01:50:01 -0000 1.15.2.4 @@ -61,5 +61,5 @@ strcpy(ptr_caps->transaction, "f"); strcpy(ptr_caps->localhost, "localhost"); - strcpy(ptr_caps->encoding, "f"); + strcpy(ptr_caps->encoding, "CHARACTER SET"); strcpy(ptr_caps->groups, "f"); strcpy(ptr_caps->admin_systable, "mysql.user"); @@ -76,5 +76,5 @@ strcpy(ptr_caps->transaction, "t"); strcpy(ptr_caps->localhost, ""); - strcpy(ptr_caps->encoding, "t"); + strcpy(ptr_caps->encoding, "WITH ENCODING ="); strcpy(ptr_caps->groups, "t"); strcpy(ptr_caps->admin_systable, "pg_shadow"); @@ -91,5 +91,5 @@ strcpy(ptr_caps->transaction, "t"); strcpy(ptr_caps->localhost, "NA"); - strcpy(ptr_caps->encoding, "f"); + strcpy(ptr_caps->encoding, ""); strcpy(ptr_caps->groups, "NA"); strcpy(ptr_caps->admin_systable, "NA"); Index: dbfncs.h =================================================================== RCS file: /cvsroot/refdb/refdb/src/dbfncs.h,v retrieving revision 1.6 retrieving revision 1.6.2.1 diff -u -U2 -r1.6 -r1.6.2.1 --- dbfncs.h 25 Oct 2003 23:50:51 -0000 1.6 +++ dbfncs.h 12 Feb 2005 01:50:01 -0000 1.6.2.1 @@ -29,5 +29,5 @@ char localhost[10]; /* the string used to access the db engine on localhost */ - char encoding[2]; /* if t, db engine supports different char encodings */ + char encoding[16]; /* command fragment to request char encodings */ char groups[3]; /* if t, db engine uses groups to manage users */ char admin_systable[11]; /* a table that only the admin may access */ Index: refdbda.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbda.c,v retrieving revision 1.41.2.4 retrieving revision 1.41.2.5 diff -u -U2 -r1.41.2.4 -r1.41.2.5 --- refdbda.c 11 Feb 2005 22:25:24 -0000 1.41.2.4 +++ refdbda.c 12 Feb 2005 01:50:01 -0000 1.41.2.5 @@ -892,8 +892,12 @@ if (strcmp(drivername, "sqlite")) { + const char* encoding_string; + + encoding_string = my_dbi_conn_get_cap(conn, "encoding"); + /* assemble sql command */ - if (!strcmp(my_dbi_conn_get_cap(conn, "encoding"), "t")) { + if (*encoding_string) { if (db_encoding && *db_encoding) { - sprintf(sql_command, "CREATE DATABASE %s WITH ENCODING = '%s'", dbname, db_encoding); + sprintf(sql_command, "CREATE DATABASE %s %s '%s'", dbname, encoding_string, db_encoding); } else { /* use default encoding of db server */ @@ -902,5 +906,5 @@ } else { - /* mysql does not support database-based encodings (yet) */ + /* db engine does not support database-based encodings */ sprintf(sql_command, "CREATE DATABASE %s", dbname); } @@ -1082,5 +1086,5 @@ dbires = dbi_conn_query(conn, sql_command); - if (error) { + if (dbi_conn_error_flag(conn)) { tiwrite(ptr_clrequest->fd, "DROP GROUP failed\n", TERM_NO); dbi_conn_close(conn); |
|
From: Markus H. <mho...@us...> - 2005-02-11 22:25:43
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28963/src Modified Files: Tag: Release_0_9_5_stable refdbda.c Log Message: added db version to viewstat output Index: refdbda.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbda.c,v retrieving revision 1.41.2.3 retrieving revision 1.41.2.4 diff -u -U2 -r1.41.2.3 -r1.41.2.4 --- refdbda.c 10 Feb 2005 20:38:21 -0000 1.41.2.3 +++ refdbda.c 11 Feb 2005 22:25:24 -0000 1.41.2.4 @@ -467,4 +467,5 @@ dbi_driver driver; /* libdbi driver structure */ dbi_result dbires; /* libdbi result structure */ + short int dbversioninfo = 0; char* outstring; /* ptr to a buffer for output */ char* outbuffer; /* ptr to a buffer for output */ @@ -482,4 +483,15 @@ driver = dbi_conn_get_driver(conn); + sprintf(sql_command, "SELECT meta_dbversion from t_meta"); + dbires = dbi_conn_query(conn, sql_command); + LOG_PRINT(LOG_DEBUG, sql_command); + if (dbires) { + if (dbi_result_next_row(dbires)) { + dbversioninfo = dbi_result_get_short_idx(dbires, 1); /* 1-base index */ + } + + dbi_result_free(dbires); + } + /* obtain database server version info */ sprintf(sql_command, "SELECT VERSION()"); @@ -492,5 +504,5 @@ } - sprintf(outbuffer, "You are served by: %s %s\nClient IP: %s\nConnected via %s driver (%s)\nto: %s\nserverip: %s\ntimeout: %s\ndbs_port: %s\nlogfile: %s\nlogdest: %s\nloglevel: %s\nremoteadmin: %s\npidfile: %s\n", + sprintf(outbuffer, "You are served by: %s %s\nClient IP: %s\nConnected via %s driver (%s)\nto: %s\ndb version: %d\nserverip: %s\ntimeout: %s\ndbs_port: %s\nlogfile: %s\nlogdest: %s\nloglevel: %s\nremoteadmin: %s\npidfile: %s\n", PACKAGE, VERSION, @@ -499,4 +511,5 @@ dbi_driver_get_version(driver), (versioninfo) ? versioninfo : "unknown", + dbversioninfo, ptr_clrequest->server_ip, refdb_timeout, |
|
From: Markus H. <mho...@us...> - 2005-02-11 22:23:15
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27872/src Modified Files: Tag: Release_0_9_5_stable refdbd.c Log Message: moved main database check to child code Index: refdbd.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbd.c,v retrieving revision 1.74.2.7 retrieving revision 1.74.2.8 diff -u -U2 -r1.74.2.7 -r1.74.2.8 --- refdbd.c 10 Feb 2005 20:38:17 -0000 1.74.2.7 +++ refdbd.c 11 Feb 2005 22:22:46 -0000 1.74.2.8 @@ -490,52 +490,6 @@ exit(1); } - else { - dbi_conn conn; /* libdbi connection structure */ - dbi_result dbires; /* libdbi result structure */ - char sql_command[] = "SELECT meta_dbversion from t_meta"; - short int main_dbversion; - - LOG_PRINT(LOG_ERR, "Requested libdbi driver found"); - - /* check presence of main database */ - if ((conn = connect_to_db(ptr_clrequest, MAIN_DB, 0)) != NULL) { - /* check version tag of main database */ - dbires = dbi_conn_query(conn, sql_command); - if (!dbires || !dbi_result_next_row(dbires)) { - LOG_PRINT(LOG_WARNING, "Reading main database meta information failed. Main database may be corrupt or too old."); - dbi_shutdown(); - free(ptr_clrequest); - exit(1); - } - - main_dbversion = dbi_result_get_short(dbires, "meta_dbversion"); - if (dbi_conn_error_flag(conn)) { - LOG_PRINT(LOG_WARNING, "Reading main database version information failed. Main database may be corrupt or too old."); - dbi_result_free(dbires); - dbi_shutdown(); - free(ptr_clrequest); - exit(1); - } - dbi_result_free(dbires); - - if (main_dbversion < MIN_MAIN_DB_VERSION) { - LOG_PRINT(LOG_WARNING, "Main database version is not supported."); - dbi_result_free(dbires); - dbi_shutdown(); - free(ptr_clrequest); - exit(1); - } - } - else { - LOG_PRINT(LOG_ERR, "Cannot connect to the main database:"); - LOG_PRINT(LOG_ERR, MAIN_DB); - dbi_shutdown(); - free(ptr_clrequest); - exit(1); - } - LOG_PRINT(LOG_DEBUG, "Main database looks ok:"); - LOG_PRINT(LOG_DEBUG, MAIN_DB); - } + LOG_PRINT(LOG_ERR, "Requested libdbi driver found"); /* shutdown for the time being. Each child will initialize libdbi again */ @@ -1223,4 +1177,51 @@ n_dbi_is_up++; + /* check presence of main database */ + { + dbi_conn conn; /* libdbi connection structure */ + dbi_result dbires; /* libdbi result structure */ + char sql_command[] = "SELECT meta_dbversion from t_meta"; + short int main_dbversion; + + if ((conn = connect_to_db(ptr_child_clrequest, MAIN_DB, 0)) != NULL) { + /* check version tag of main database */ + dbires = dbi_conn_query(conn, sql_command); + if (!dbires || !dbi_result_next_row(dbires)) { + strcpy(child_returnmsg, "Reading main database meta information failed. Main database may be corrupt or too old."); + LOG_PRINT(LOG_WARNING, child_returnmsg); + retval = 1; + goto finish; + } + + main_dbversion = dbi_result_get_short(dbires, "meta_dbversion"); + + if (dbi_conn_error_flag(conn)) { + strcpy(child_returnmsg, "Reading main database version information failed. Main database may be corrupt or too old."); + LOG_PRINT(LOG_WARNING, child_returnmsg); + dbi_result_free(dbires); + retval = 1; + goto finish; + } + dbi_result_free(dbires); + + if (main_dbversion < MIN_MAIN_DB_VERSION) { + strcpy(child_returnmsg, "Main database version is not supported."); + LOG_PRINT(LOG_WARNING, child_returnmsg); + dbi_result_free(dbires); + retval = 1; + goto finish; + } + } + else { + strcpy(child_returnmsg, "Cannot connect to the main database: "); + strcat(child_returnmsg, MAIN_DB); + LOG_PRINT(LOG_ERR, child_returnmsg); + retval = 1; + goto finish; + } + LOG_PRINT(LOG_DEBUG, "Main database looks ok:"); + LOG_PRINT(LOG_DEBUG, MAIN_DB); + } + /* get and initialize structure with database engine capabilities */ |
|
From: Markus H. <mho...@us...> - 2005-02-11 22:19:21
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26432/scripts Modified Files: Tag: Release_0_9_5_stable refdb.dump.pgsql.in Log Message: added t_meta to access stuff Index: refdb.dump.pgsql.in =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Attic/refdb.dump.pgsql.in,v retrieving revision 1.1.2.1 retrieving revision 1.1.2.2 diff -u -U2 -r1.1.2.1 -r1.1.2.2 --- refdb.dump.pgsql.in 10 Feb 2005 20:29:59 -0000 1.1.2.1 +++ refdb.dump.pgsql.in 11 Feb 2005 22:19:05 -0000 1.1.2.2 @@ -722,3 +722,3 @@ CREATE GROUP refdbuser; -GRANT SELECT ON CITSTYLE, POSITIONS, REFSTYLE, SEPARATORS, t_journal_words TO GROUP refdbuser; +GRANT SELECT ON CITSTYLE, POSITIONS, REFSTYLE, SEPARATORS, t_journal_words, t_meta TO GROUP refdbuser; |
|
From: Markus H. <mho...@us...> - 2005-02-11 20:26:46
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12384 Modified Files: Tag: Release_0_9_5_stable refdbd.h.in Log Message: added definitions Index: refdbd.h.in =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbd.h.in,v retrieving revision 1.7.2.4 retrieving revision 1.7.2.5 diff -u -U2 -r1.7.2.4 -r1.7.2.5 --- refdbd.h.in 25 Oct 2004 21:17:34 -0000 1.7.2.4 +++ refdbd.h.in 11 Feb 2005 20:26:32 -0000 1.7.2.5 @@ -65,4 +65,7 @@ #define FIFO_NAME "/tmp/refdbd_fifo" /* base name of a fifo */ #define MAIN_DB "<main_db>" /* name of the main database */ +#define MIN_MAIN_DB_VERSION 1 /* minimum version tag of the main database */ +#define DB_VERSION 1 /* version tag of reference databases created with this version */ +#define MIN_DB_VERSION 1 /* minimum version tag of reference databases readable */ #define CITEKEY_BASE_LENGTH 240 /* maximum length of authorname+year */ |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:38:48
|
Update of /cvsroot/refdb/refdb/src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4024 Modified Files: Tag: Release_0_9_5_stable dbfncs.c refdbd.c refdbda.c refdbdref.c Log Message: added support for database versioning Index: dbfncs.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/dbfncs.c,v retrieving revision 1.15.2.2 retrieving revision 1.15.2.3 diff -u -U2 -r1.15.2.2 -r1.15.2.3 --- dbfncs.c 25 Nov 2004 21:34:16 -0000 1.15.2.2 +++ dbfncs.c 10 Feb 2005 20:38:14 -0000 1.15.2.3 @@ -134,5 +134,5 @@ /* create the metadata table */ - dbires = dbi_conn_query(conn, "CREATE TABLE t_meta (meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_create_date DATETIME, meta_modify_date DATETIME)"); + dbires = dbi_conn_query(conn, "CREATE TABLE t_meta (meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_dbversion SMALLINT, meta_create_date DATETIME, meta_modify_date DATETIME)"); if (!dbires) { @@ -387,5 +387,5 @@ /* create the metadata table */ - dbires = dbi_conn_query(conn, "CREATE TABLE t_meta (meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_create_date TIMESTAMP, meta_modify_date TIMESTAMP)"); + dbires = dbi_conn_query(conn, "CREATE TABLE t_meta (meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_dbversion SMALLINT, meta_create_date TIMESTAMP, meta_modify_date TIMESTAMP)"); if (!dbires) { @@ -865,5 +865,5 @@ /* create the metadata table */ - dbires = dbi_conn_query(conn, "CREATE TABLE t_meta (meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_create_date DATETIME, meta_modify_date DATETIME)"); + dbires = dbi_conn_query(conn, "CREATE TABLE t_meta (meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_dbversion SMALLINT, meta_create_date DATETIME, meta_modify_date DATETIME)"); if (!dbires) { Index: refdbd.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbd.c,v retrieving revision 1.74.2.6 retrieving revision 1.74.2.7 diff -u -U2 -r1.74.2.6 -r1.74.2.7 --- refdbd.c 10 Dec 2004 10:32:14 -0000 1.74.2.6 +++ refdbd.c 10 Feb 2005 20:38:17 -0000 1.74.2.7 @@ -162,4 +162,5 @@ int n_pipe_buf = 512; /* maximum size of atomic write to fifo. 512 is the posix value. if the OS defines a larger value, this will be used below */ int num_drivers = 0; /* number of libdbi drivers */ + int n_have_requested_driver = 0; /* used to check the libdbi drivers */ struct sockaddr_in server_address; struct sockaddr_in client_address; @@ -476,7 +477,65 @@ LOG_PRINT(LOG_INFO, "Available libdbi database drivers:"); while ((driver = dbi_driver_list(driver)) != NULL) { - /* ToDo: check whether requested driver is available */ + /* check whether requested driver is available */ + if (!strcmp(ptr_clrequest->dbserver, dbi_driver_get_name(driver))) { + n_have_requested_driver++; + } LOG_PRINT(LOG_INFO, dbi_driver_get_name(driver)); } + + if (!n_have_requested_driver) { + LOG_PRINT(LOG_ERR, "Requested libdbi driver is not present"); + dbi_shutdown(); + free(ptr_clrequest); + exit(1); + } + else { + dbi_conn conn; /* libdbi connection structure */ + dbi_result dbires; /* libdbi result structure */ + char sql_command[] = "SELECT meta_dbversion from t_meta"; + short int main_dbversion; + + LOG_PRINT(LOG_ERR, "Requested libdbi driver found"); + + /* check presence of main database */ + if ((conn = connect_to_db(ptr_clrequest, MAIN_DB, 0)) != NULL) { + /* check version tag of main database */ + dbires = dbi_conn_query(conn, sql_command); + if (!dbires || !dbi_result_next_row(dbires)) { + LOG_PRINT(LOG_WARNING, "Reading main database meta information failed. Main database may be corrupt or too old."); + dbi_shutdown(); + free(ptr_clrequest); + exit(1); + } + + main_dbversion = dbi_result_get_short(dbires, "meta_dbversion"); + + if (dbi_conn_error_flag(conn)) { + LOG_PRINT(LOG_WARNING, "Reading main database version information failed. Main database may be corrupt or too old."); + dbi_result_free(dbires); + dbi_shutdown(); + free(ptr_clrequest); + exit(1); + } + dbi_result_free(dbires); + + if (main_dbversion < MIN_MAIN_DB_VERSION) { + LOG_PRINT(LOG_WARNING, "Main database version is not supported."); + dbi_result_free(dbires); + dbi_shutdown(); + free(ptr_clrequest); + exit(1); + } + } + else { + LOG_PRINT(LOG_ERR, "Cannot connect to the main database:"); + LOG_PRINT(LOG_ERR, MAIN_DB); + dbi_shutdown(); + free(ptr_clrequest); + exit(1); + } + LOG_PRINT(LOG_DEBUG, "Main database looks ok:"); + LOG_PRINT(LOG_DEBUG, MAIN_DB); + } /* shutdown for the time being. Each child will initialize libdbi again */ Index: refdbda.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbda.c,v retrieving revision 1.41.2.2 retrieving revision 1.41.2.3 diff -u -U2 -r1.41.2.2 -r1.41.2.3 --- refdbda.c 12 Oct 2004 00:18:46 -0000 1.41.2.2 +++ refdbda.c 10 Feb 2005 20:38:21 -0000 1.41.2.3 @@ -663,4 +663,5 @@ int retval = 0; int close_conn_ref = 0; + short int dbversion; if (conn) { @@ -675,5 +676,5 @@ } - sprintf(sql_command, "SELECT meta_app,meta_type from t_meta"); + sprintf(sql_command, "SELECT meta_app,meta_type,meta_dbversion from t_meta"); LOG_PRINT(LOG_DEBUG, sql_command); @@ -690,6 +691,9 @@ app = dbi_result_get_string(dbires, "meta_app"); type = dbi_result_get_string(dbires, "meta_type"); + dbversion = dbi_result_get_short(dbires, "meta_dbversion"); - if (!strcmp(app, "refdb")) { + if (!strcmp(app, "refdb") + && (!strcmp(type, "ris") || !strcmp(type, "risx")) + && dbversion >= MIN_DB_VERSION) { retval = 1; } @@ -957,5 +961,5 @@ time(&the_time); strftime(date_buffer, 24, "%Y-%m-%d %H:%M:%S", gmtime(&the_time)); - sprintf(sql_command, "INSERT INTO t_meta (meta_app,meta_type,meta_version,meta_create_date,meta_modify_date) VALUES (\'%s\', \'risx\', \'%s\', \'%s\', \'%s\')", PACKAGE, VERSION, date_buffer, date_buffer); + sprintf(sql_command, "INSERT INTO t_meta (meta_app,meta_type,meta_version,meta_dbversion,meta_create_date,meta_modify_date) VALUES (\'%s\', \'risx\', \'%s\', \'%d\', \'%s\', \'%s\')", PACKAGE, VERSION, DB_VERSION, date_buffer, date_buffer); LOG_PRINT(LOG_DEBUG, sql_command); Index: refdbdref.c =================================================================== RCS file: /cvsroot/refdb/refdb/src/refdbdref.c,v retrieving revision 1.65.2.4 retrieving revision 1.65.2.5 diff -u -U2 -r1.65.2.4 -r1.65.2.5 --- refdbdref.c 14 Nov 2004 16:25:09 -0000 1.65.2.4 +++ refdbdref.c 10 Feb 2005 20:38:22 -0000 1.65.2.5 @@ -146,4 +146,5 @@ unsigned long long maxnid; unsigned short fieldtype; + short int db_version; int numbyte; int error; @@ -212,5 +213,5 @@ dbi_result_free(dbires); - dbires = dbi_conn_query(conn, "SELECT meta_app,meta_type,meta_version,meta_create_date,meta_modify_date FROM t_meta"); + dbires = dbi_conn_query(conn, "SELECT meta_app,meta_type,meta_version,meta_dbversion,meta_create_date,meta_modify_date FROM t_meta"); if (!dbires) { tiwrite(ptr_clrequest->fd, "cannot get meta info\n", TERM_NO); @@ -257,5 +258,5 @@ /* The returned integers are quads (8byte) */ - sprintf(return_msg, "Current database: %s\nNumber of references: "ULLSPEC"\nHighest reference ID: "ULLSPEC"\nNumber of notes: "ULLSPEC"\nHighest note ID: "ULLSPEC"\nEncoding: %s\nDatabase type: %s\nDatabase server: %s\nCreated: %s UTC\nUsing %s version: %s\nLast modified: %s UTC\n", ptr_clrequest->current_db, (unsigned long long)numrefs, (unsigned long long)maxid, (unsigned long long)numnotes, (unsigned long long)maxnid, db_encoding, dbi_result_get_string(dbires, "meta_type"), dbi_driver_get_name(driver), create_date, dbi_result_get_string(dbires, "meta_app"), dbi_result_get_string(dbires, "meta_version"), modify_date); + sprintf(return_msg, "Current database: %s\nNumber of references: "ULLSPEC"\nHighest reference ID: "ULLSPEC"\nNumber of notes: "ULLSPEC"\nHighest note ID: "ULLSPEC"\nEncoding: %s\nDatabase type: %s\nDatabase version: %d\nDatabase server: %s\nCreated: %s UTC\nUsing %s version: %s\nLast modified: %s UTC\n", ptr_clrequest->current_db, (unsigned long long)numrefs, (unsigned long long)maxid, (unsigned long long)numnotes, (unsigned long long)maxnid, db_encoding, dbi_result_get_string(dbires, "meta_type"),dbi_result_get_short(dbires, "meta_dbversion"), dbi_driver_get_name(driver), create_date, dbi_result_get_string(dbires, "meta_app"), dbi_result_get_string(dbires, "meta_version"), modify_date); dbi_result_free(dbires); |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:34:03
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2917 Removed Files: Tag: Release_0_9_5_stable refdb.dump.sqlite Log Message: replaced by refdb.dump.sqlite.in --- refdb.dump.sqlite DELETED --- |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:33:33
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2645 Removed Files: Tag: Release_0_9_5_stable refdb.dump.pgsql Log Message: replaced by refdb.dump.pgsql.in --- refdb.dump.pgsql DELETED --- |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:31:35
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1840 Removed Files: Tag: Release_0_9_5_stable refdb.dump Log Message: replaced by refdb.dump.mysql.in --- refdb.dump DELETED --- |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:30:16
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv986 Added Files: Tag: Release_0_9_5_stable refdb.dump.mysql.in refdb.dump.mysql41.in refdb.dump.pgsql.in refdb.dump.sqlite.in Log Message: initial version --- NEW FILE --- # MySQL dump 7.1 # # Host: localhost Database: refdb #-------------------------------------------------------- # Server version 3.22.32-log CREATE TABLE t_meta ( meta_app VARCHAR(20), meta_type VARCHAR(20), meta_version VARCHAR(20), meta_dbversion SMALLINT, meta_create_date DATETIME, meta_modify_date DATETIME ); INSERT INTO t_meta (meta_app,meta_type,meta_version,meta_dbversion,meta_create_date,meta_modify_date) VALUES ('<package>','refdb','<version>','1',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP); # # Table structure for table 'CITSTYLE' # CREATE TABLE CITSTYLE ( ID int(11) NOT NULL auto_increment, JOURNAL tinytext, CITSEPARATOR tinytext, FOLLOWING tinytext, PRECEEDING tinytext, RANGESEPARATOR tinytext, BIBLIOTITLE tinytext, INTEXTSEQUENCE varchar(10), BIBLIOSEQUENCE varchar(11), BIBLIOFIRSTINDENT varchar(16), BIBLIOBLOCKINDENT varchar(16), FONTSIZE varchar(16), STYLE varchar(12), JANABBREV varchar(16), FEBABBREV varchar(16), MARABBREV varchar(16), APRABBREV varchar(16), MAYABBREV varchar(16), JUNABBREV varchar(16), JULABBREV varchar(16), AUGABBREV varchar(16), SEPABBREV varchar(16), OCTABBREV varchar(16), NOVABBREV varchar(16), DECABBREV varchar(16), JANFULL varchar(255), FEBFULL varchar(255), MARFULL varchar(255), APRFULL varchar(255), MAYFULL varchar(255), JUNFULL varchar(255), JULFULL varchar(255), AUGFULL varchar(255), SEPFULL varchar(255), OCTFULL varchar(255), NOVFULL varchar(255), DECFULL varchar(255), JANTHREELET varchar(16), FEBTHREELET varchar(16), MARTHREELET varchar(16), APRTHREELET varchar(16), MAYTHREELET varchar(16), JUNTHREELET varchar(16), JULTHREELET varchar(16), AUGTHREELET varchar(16), SEPTHREELET varchar(16), OCTTHREELET varchar(16), NOVTHREELET varchar(16), DECTHREELET varchar(16), PRIMARY KEY (ID) ); # # Dumping data for table 'CITSTYLE' # # # Table structure for table 'POSITIONS' # CREATE TABLE POSITIONS ( ID int(11) NOT NULL auto_increment, REFSTYLEID int(11), POS int(11), SEPARATORID int(11), TYPE varchar(64), PRIMARY KEY (ID) ); # # Dumping data for table 'POSITIONS' # # # Table structure for table 'REFSTYLE' # CREATE TABLE REFSTYLE ( ID int(11) NOT NULL auto_increment, CITSTYLEID int(11), PUBTYPE varchar(10), QSTYLE varchar(12), XSTYLE varchar(12), YSTYLE varchar(12), ZSTYLE varchar(12), QALTERNATESTYLE varchar(12), XALTERNATESTYLE varchar(12), YALTERNATESTYLE varchar(12), ZALTERNATESTYLE varchar(12), QALTERNATETEXT varchar(15), XALTERNATETEXT varchar(15), YALTERNATETEXT varchar(15), ZALTERNATETEXT varchar(15), QABBREVIATEFIRST tinytext, XABBREVIATEFIRST tinytext, YABBREVIATEFIRST tinytext, ZABBREVIATEFIRST tinytext, QABBREVIATESUBSEQ tinytext, XABBREVIATESUBSEQ tinytext, YABBREVIATESUBSEQ tinytext, ZABBREVIATESUBSEQ tinytext, QABBREVIATEFIRSTMAXAUTHOR varchar(5), XABBREVIATEFIRSTMAXAUTHOR varchar(5), YABBREVIATEFIRSTMAXAUTHOR varchar(5), ZABBREVIATEFIRSTMAXAUTHOR varchar(5), QABBREVIATESUBSEQMAXAUTHOR varchar(5), XABBREVIATESUBSEQMAXAUTHOR varchar(5), YABBREVIATESUBSEQMAXAUTHOR varchar(5), ZABBREVIATESUBSEQMAXAUTHOR varchar(5), QABBREVIATEFIRSTDISPLAYAUTHOR varchar(5), XABBREVIATEFIRSTDISPLAYAUTHOR varchar(5), YABBREVIATEFIRSTDISPLAYAUTHOR varchar(5), ZABBREVIATEFIRSTDISPLAYAUTHOR varchar(5), QABBREVIATESUBSEQDISPLAYAUTHOR varchar(5), XABBREVIATESUBSEQDISPLAYAUTHOR varchar(5), YABBREVIATESUBSEQDISPLAYAUTHOR varchar(5), ZABBREVIATESUBSEQDISPLAYAUTHOR varchar(5), QAEMPTY tinytext, XAEMPTY tinytext, YAEMPTY tinytext, ZAEMPTY tinytext, QASAME tinytext, XASAME tinytext, YASAME tinytext, ZASAME tinytext, QPRECEEDING tinytext, XPRECEEDING tinytext, YPRECEEDING tinytext, ZPRECEEDING tinytext, QFOLLOWING tinytext, XFOLLOWING tinytext, YFOLLOWING tinytext, ZFOLLOWING tinytext, QAUTHORSEPSTWOSEPS tinytext, XAUTHORSEPSTWOSEPS tinytext, YAUTHORSEPSTWOSEPS tinytext, ZAUTHORSEPSTWOSEPS tinytext, QAUTHORSEPSTHREESEPSTHREESEPSEACH tinytext, XAUTHORSEPSTHREESEPSTHREESEPSEACH tinytext, YAUTHORSEPSTHREESEPSTHREESEPSEACH tinytext, ZAUTHORSEPSTHREESEPSTHREESEPSEACH tinytext, QAUTHORSEPSTHREESEPSTHREESEPSLAST tinytext, XAUTHORSEPSTHREESEPSTHREESEPSLAST tinytext, YAUTHORSEPSTHREESEPSTHREESEPSLAST tinytext, ZAUTHORSEPSTHREESEPSTHREESEPSLAST tinytext, QAUTHORNAMESNAMEFIRSTNAMEORDER varchar(20), XAUTHORNAMESNAMEFIRSTNAMEORDER varchar(20), YAUTHORNAMESNAMEFIRSTNAMEORDER varchar(20), ZAUTHORNAMESNAMEFIRSTNAMEORDER varchar(20), QAUTHORNAMESNAMEFIRSTINITIALSTYLE varchar(14), XAUTHORNAMESNAMEFIRSTINITIALSTYLE varchar(14), YAUTHORNAMESNAMEFIRSTINITIALSTYLE varchar(14), ZAUTHORNAMESNAMEFIRSTINITIALSTYLE varchar(14), QAUTHORNAMESNAMEFIRSTUPPERCASE varchar(8), XAUTHORNAMESNAMEFIRSTUPPERCASE varchar(8), YAUTHORNAMESNAMEFIRSTUPPERCASE varchar(8), ZAUTHORNAMESNAMEFIRSTUPPERCASE varchar(8), QAUTHORNAMESNAMEOTHERNAMEORDER varchar(20), XAUTHORNAMESNAMEOTHERNAMEORDER varchar(20), YAUTHORNAMESNAMEOTHERNAMEORDER varchar(20), ZAUTHORNAMESNAMEOTHERNAMEORDER varchar(20), QAUTHORNAMESNAMEOTHERINITIALSTYLE varchar(14), XAUTHORNAMESNAMEOTHERINITIALSTYLE varchar(14), YAUTHORNAMESNAMEOTHERINITIALSTYLE varchar(14), ZAUTHORNAMESNAMEOTHERINITIALSTYLE varchar(14), QAUTHORNAMESNAMEOTHERUPPERCASE varchar(8), XAUTHORNAMESNAMEOTHERUPPERCASE varchar(8), YAUTHORNAMESNAMEOTHERUPPERCASE varchar(8), ZAUTHORNAMESNAMEOTHERUPPERCASE varchar(8), QTEXTTEXTSINGLEPRECEEDING tinytext, XTEXTTEXTSINGLEPRECEEDING tinytext, YTEXTTEXTSINGLEPRECEEDING tinytext, ZTEXTTEXTSINGLEPRECEEDING tinytext, QTEXTTEXTSINGLEFOLLOWING tinytext, XTEXTTEXTSINGLEFOLLOWING tinytext, YTEXTTEXTSINGLEFOLLOWING tinytext, ZTEXTTEXTSINGLEFOLLOWING tinytext, QTEXTTEXTMULTIPLEPRECEEDING tinytext, XTEXTTEXTMULTIPLEPRECEEDING tinytext, YTEXTTEXTMULTIPLEPRECEEDING tinytext, ZTEXTTEXTMULTIPLEPRECEEDING tinytext, QTEXTTEXTMULTIPLEFOLLOWING tinytext, XTEXTTEXTMULTIPLEFOLLOWING tinytext, YTEXTTEXTMULTIPLEFOLLOWING tinytext, ZTEXTTEXTMULTIPLEFOLLOWING tinytext, PUBDATEPRECEEDING tinytext, PUBDATEFOLLOWING tinytext, PUBDATEFIRSTSEP tinytext, PUBDATESECONDSEP tinytext, PUBDATEFORMAT char(3), PUBDATESEQUENCE char(3), PUBDATEMONTHFORMAT varchar(11), PUBDATEDAYFORMAT varchar(9), PUBDATEYEARFORMAT varchar(9), PUBDATEPADLEADINGZERO char(2), PUBDATESTYLE varchar(12), PUBDATESECPRECEEDING tinytext, PUBDATESECFOLLOWING tinytext, PUBDATESECFIRSTSEP tinytext, PUBDATESECSECONDSEP tinytext, PUBDATESECFORMAT char(3), PUBDATESECSEQUENCE char(3), PUBDATESECMONTHFORMAT varchar(11), PUBDATESECDAYFORMAT varchar(9), PUBDATESECYEARFORMAT varchar(9), PUBDATESECPADLEADINGZERO char(2), PUBDATESECSTYLE varchar(12), PUBDATEALLPRECEEDING tinytext, PUBDATEALLFOLLOWING tinytext, PUBDATEALLFIRSTSEP tinytext, PUBDATEALLSECONDSEP tinytext, PUBDATEALLFORMAT char(3), PUBDATEALLSEQUENCE char(3), PUBDATEALLMONTHFORMAT varchar(11), PUBDATEALLDAYFORMAT varchar(9), PUBDATEALLYEARFORMAT varchar(9), PUBDATEALLPADLEADINGZERO char(2), PUBDATEALLSTYLE varchar(12), TITLEPRECEEDING tinytext, TITLEFOLLOWING tinytext, TITLECASE varchar(5), TITLESTYLE varchar(12), BOOKTITLEPRECEEDING tinytext, BOOKTITLEFOLLOWING tinytext, BOOKTITLECASE varchar(5), BOOKTITLESTYLE varchar(12), SERIESTITLEPRECEEDING tinytext, SERIESTITLEFOLLOWING tinytext, SERIESTITLECASE varchar(5), SERIESTITLESTYLE varchar(12), ALLTITLEPRECEEDING tinytext, ALLTITLEFOLLOWING tinytext, ALLTITLECASE varchar(5), ALLTITLESTYLE varchar(12), JOURNALNAMEPRECEEDING tinytext, JOURNALNAMEFOLLOWING tinytext, JOURNALNAMECASE varchar(5), JOURNALNAMEDEFAULTTEXT varchar(7), JOURNALNAMEALTERNATETEXT varchar(8), JOURNALNAMEPUNCTUATION varchar(11), JOURNALNAMESTYLE varchar(12), VOLUMEPRECEEDING tinytext, VOLUMEFOLLOWING tinytext, VOLUMESTYLE varchar(12), ISSUEPRECEEDING tinytext, ISSUEFOLLOWING tinytext, ISSUESTYLE varchar(12), PAGESSTYLE varchar(255), PAGESSINGLEPAGEPRECEEDING tinytext, PAGESSINGLEPAGEFOLLOWING tinytext, PAGESPAGERANGEPRECEEDING tinytext, PAGESPAGERANGEFOLLOWING tinytext, PAGESPAGERANGETYPE varchar(9), PUBLISHERPRECEEDING tinytext, PUBLISHERFOLLOWING tinytext, PUBLISHERSTYLE varchar(12), PUBPLACEPRECEEDING tinytext, PUBPLACEFOLLOWING tinytext, PUBPLACESTYLE varchar(12), SERIALPRECEEDING tinytext, SERIALFOLLOWING tinytext, SERIALSTYLE varchar(12), ADDRESSPRECEEDING tinytext, ADDRESSFOLLOWING tinytext, ADDRESSSTYLE varchar(12), URLPRECEEDING tinytext, URLFOLLOWING tinytext, URLSTYLE varchar(12), USERDEF1PRECEEDING tinytext, USERDEF1FOLLOWING tinytext, USERDEF1STYLE varchar(12), USERDEF2PRECEEDING tinytext, USERDEF2FOLLOWING tinytext, USERDEF2STYLE varchar(12), USERDEF3PRECEEDING tinytext, USERDEF3FOLLOWING tinytext, USERDEF3STYLE varchar(12), USERDEF4PRECEEDING tinytext, USERDEF4FOLLOWING tinytext, USERDEF4STYLE varchar(12), USERDEF5PRECEEDING tinytext, USERDEF5FOLLOWING tinytext, USERDEF5STYLE varchar(12), MISC1PRECEEDING tinytext, MISC1FOLLOWING tinytext, MISC1STYLE varchar(12), MISC2PRECEEDING tinytext, MISC2FOLLOWING tinytext, MISC2STYLE varchar(12), MISC3PRECEEDING tinytext, MISC3FOLLOWING tinytext, MISC3STYLE varchar(12), NOTESPRECEEDING tinytext, NOTESFOLLOWING tinytext, NOTESSTYLE varchar(12), ABSTRACTPRECEEDING tinytext, ABSTRACTFOLLOWING tinytext, ABSTRACTSTYLE varchar(12), LINK1PRECEEDING tinytext, LINK1FOLLOWING tinytext, LINK1STYLE varchar(12), LINK2PRECEEDING tinytext, LINK2FOLLOWING tinytext, LINK2STYLE varchar(12), LINK3PRECEEDING tinytext, LINK3FOLLOWING tinytext, LINK3STYLE varchar(12), LINK4PRECEEDING tinytext, LINK4FOLLOWING tinytext, LINK4STYLE varchar(12), PAGESPRECEEDING tinytext, PAGESFOLLOWING tinytext, REFNUMBERPRECEEDING tinytext, REFNUMBERFOLLOWING tinytext, REFNUMBERSTYLE varchar(12), REFNUMBERUSE char(3), PAGESPAGERANGERANGESEPARATOR varchar(16), QABBREVIATEFIRSTSTYLE varchar(12), QABBREVIATESUBSEQSTYLE varchar(12), PAGESPAGERANGESTYLE varchar(10), XABBREVIATEFIRSTSTYLE varchar(12), YABBREVIATEFIRSTSTYLE varchar(12), ZABBREVIATEFIRSTSTYLE varchar(12), XABBREVIATESUBSEQSTYLE varchar(12), YABBREVIATESUBSEQSTYLE varchar(12), ZABBREVIATESUBSEQSTYLE varchar(12), PRIMARY KEY (ID) ); # # Dumping data for table 'REFSTYLE' # # # Table structure for table 'SEPARATORS' # CREATE TABLE SEPARATORS ( ID int(11) NOT NULL auto_increment, STYLEID int(11), VALUE varchar(255), PRIMARY KEY (ID) ); # # Dumping data for table 'SEPARATORS' # # # Table structure for table 't_journal_words' # CREATE TABLE t_journal_words ( name varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (name) ); # # Dumping data for table 't_journal_words' # LOCK TABLES t_journal_words WRITE; INSERT INTO t_journal_words (name) VALUES ('(BALTIMORE)'); INSERT INTO t_journal_words (name) VALUES ('(BASEL)'); INSERT INTO t_journal_words (name) VALUES ('(BERL)'); INSERT INTO t_journal_words (name) VALUES ('(COPENH)'); INSERT INTO t_journal_words (name) VALUES ('(GANN)'); INSERT INTO t_journal_words (name) VALUES ('(JENA)'); INSERT INTO t_journal_words (name) VALUES ('(LEIDEN)'); INSERT INTO t_journal_words (name) VALUES ('(LOND)'); INSERT INTO t_journal_words (name) VALUES ('(NY)'); INSERT INTO t_journal_words (name) VALUES ('(PARIS)'); INSERT INTO t_journal_words (name) VALUES ('(PAVIA)'); INSERT INTO t_journal_words (name) VALUES ('(PRAHA)'); INSERT INTO t_journal_words (name) VALUES ('(STOCKH)'); INSERT INTO t_journal_words (name) VALUES ('(TOKYO)'); INSERT INTO t_journal_words (name) VALUES ('ABUSE'); INSERT INTO t_journal_words (name) VALUES ('ACCOUNTS'); INSERT INTO t_journal_words (name) VALUES ('ACP'); INSERT INTO t_journal_words (name) VALUES ('ACTA'); INSERT INTO t_journal_words (name) VALUES ('ACTIONS'); INSERT INTO t_journal_words (name) VALUES ('AFFAIRS'); INSERT INTO t_journal_words (name) VALUES ('AFFECTIVE'); INSERT INTO t_journal_words (name) VALUES ('AGEING'); INSERT INTO t_journal_words (name) VALUES ('AGENTS'); INSERT INTO t_journal_words (name) VALUES ('AGGRESSIVE'); INSERT INTO t_journal_words (name) VALUES ('AGING'); INSERT INTO t_journal_words (name) VALUES ('AIDS'); INSERT INTO t_journal_words (name) VALUES ('ALCOHOL'); INSERT INTO t_journal_words (name) VALUES ('ALCOHOLISM'); INSERT INTO t_journal_words (name) VALUES ('ALLERGY'); INSERT INTO t_journal_words (name) VALUES ('AMINES'); INSERT INTO t_journal_words (name) VALUES ('ANAESTHESIA'); INSERT INTO t_journal_words (name) VALUES ('ANALYST'); INSERT INTO t_journal_words (name) VALUES ('ANESTHESIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('ANTICANCER'); INSERT INTO t_journal_words (name) VALUES ('ANTIVIRAL'); INSERT INTO t_journal_words (name) VALUES ('ANTONIE'); INSERT INTO t_journal_words (name) VALUES ('APMIS'); INSERT INTO t_journal_words (name) VALUES ('ARTERIOSCLEROSIS'); INSERT INTO t_journal_words (name) VALUES ('ARTHRITIS'); INSERT INTO t_journal_words (name) VALUES ('ARTHROPLASTY'); INSERT INTO t_journal_words (name) VALUES ('ASTHMA'); INSERT INTO t_journal_words (name) VALUES ('ASYMMETRY'); INSERT INTO t_journal_words (name) VALUES ('ATHEROSCLEROSIS'); INSERT INTO t_journal_words (name) VALUES ('AUDIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('B'); INSERT INTO t_journal_words (name) VALUES ('BEHAVIOUR'); INSERT INTO t_journal_words (name) VALUES ('BIO-ENERGETICS'); INSERT INTO t_journal_words (name) VALUES ('BIOCHEMISTRY'); INSERT INTO t_journal_words (name) VALUES ('BIOCHIMIE'); INSERT INTO t_journal_words (name) VALUES ('BIOCHROMATOGRAPHY'); INSERT INTO t_journal_words (name) VALUES ('BIOELECTROMAGNETICS'); INSERT INTO t_journal_words (name) VALUES ('BIOESSAYS'); INSERT INTO t_journal_words (name) VALUES ('BIOFACTORS'); INSERT INTO t_journal_words (name) VALUES ('BIOGENIC'); INSERT INTO t_journal_words (name) VALUES ('BIOLOGIST'); INSERT INTO t_journal_words (name) VALUES ('BIOMATERIALS'); INSERT INTO t_journal_words (name) VALUES ('BIOORGANIC'); INSERT INTO t_journal_words (name) VALUES ('BIOPOLYMERS'); INSERT INTO t_journal_words (name) VALUES ('BIOSYSTEMS'); INSERT INTO t_journal_words (name) VALUES ('BIOTECHNIQUES'); INSERT INTO t_journal_words (name) VALUES ('BIOTECHNOLOGY'); INSERT INTO t_journal_words (name) VALUES ('BIOTHERAPY'); INSERT INTO t_journal_words (name) VALUES ('BIRTH'); INSERT INTO t_journal_words (name) VALUES ('BLOOD'); INSERT INTO t_journal_words (name) VALUES ('BLUT'); INSERT INTO t_journal_words (name) VALUES ('BONE'); INSERT INTO t_journal_words (name) VALUES ('BRAIN'); INSERT INTO t_journal_words (name) VALUES ('BREAST'); INSERT INTO t_journal_words (name) VALUES ('CALCIUM'); INSERT INTO t_journal_words (name) VALUES ('CAMBRIDGE'); INSERT INTO t_journal_words (name) VALUES ('CANCER'); INSERT INTO t_journal_words (name) VALUES ('CARCINOGENESIS'); INSERT INTO t_journal_words (name) VALUES ('CARDIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('CARE'); INSERT INTO t_journal_words (name) VALUES ('CELL'); INSERT INTO t_journal_words (name) VALUES ('CELLS'); INSERT INTO t_journal_words (name) VALUES ('CHEMOTHERAPY'); INSERT INTO t_journal_words (name) VALUES ('CHEST'); INSERT INTO t_journal_words (name) VALUES ('CHILD'); INSERT INTO t_journal_words (name) VALUES ('CHROMATOGRAPHY'); INSERT INTO t_journal_words (name) VALUES ('CHROMOSOMA'); INSERT INTO t_journal_words (name) VALUES ('CIRCULATION'); INSERT INTO t_journal_words (name) VALUES ('COLD'); INSERT INTO t_journal_words (name) VALUES ('COLLOID'); INSERT INTO t_journal_words (name) VALUES ('COLON'); INSERT INTO t_journal_words (name) VALUES ('COMPLEMENT'); INSERT INTO t_journal_words (name) VALUES ('CONTRACEPTION'); INSERT INTO t_journal_words (name) VALUES ('CONTROLLED'); INSERT INTO t_journal_words (name) VALUES ('CRC'); INSERT INTO t_journal_words (name) VALUES ('CROP'); INSERT INTO t_journal_words (name) VALUES ('CULTURE'); INSERT INTO t_journal_words (name) VALUES ('CYCLE'); INSERT INTO t_journal_words (name) VALUES ('CYTOBIOS'); INSERT INTO t_journal_words (name) VALUES ('CYTOMETRY'); INSERT INTO t_journal_words (name) VALUES ('CYTOSKELETON'); INSERT INTO t_journal_words (name) VALUES ('CYTOTECHNOLOGY'); INSERT INTO t_journal_words (name) VALUES ('DEFECTS'); INSERT INTO t_journal_words (name) VALUES ('DERMATOLOGICA'); INSERT INTO t_journal_words (name) VALUES ('DEVELOPMENT'); INSERT INTO t_journal_words (name) VALUES ('DIABETES'); INSERT INTO t_journal_words (name) VALUES ('DIABETOLOGIA'); INSERT INTO t_journal_words (name) VALUES ('DIGESTION'); INSERT INTO t_journal_words (name) VALUES ('DNA'); INSERT INTO t_journal_words (name) VALUES ('DNAGING'); INSERT INTO t_journal_words (name) VALUES ('DRUG'); INSERT INTO t_journal_words (name) VALUES ('DRUGS'); INSERT INTO t_journal_words (name) VALUES ('DT'); INSERT INTO t_journal_words (name) VALUES ('EARLY'); INSERT INTO t_journal_words (name) VALUES ('EICOSANOIDS'); INSERT INTO t_journal_words (name) VALUES ('ELECTROLYTE'); INSERT INTO t_journal_words (name) VALUES ('ELECTRON'); INSERT INTO t_journal_words (name) VALUES ('ELECTROPHORESIS'); INSERT INTO t_journal_words (name) VALUES ('EMBO'); INSERT INTO t_journal_words (name) VALUES ('ENDOCRINOLOGY'); INSERT INTO t_journal_words (name) VALUES ('ENDOTHELIUM'); INSERT INTO t_journal_words (name) VALUES ('ENVIRONMENT'); INSERT INTO t_journal_words (name) VALUES ('ENZYME'); INSERT INTO t_journal_words (name) VALUES ('EPILEPSIA'); INSERT INTO t_journal_words (name) VALUES ('EPILEPSY'); INSERT INTO t_journal_words (name) VALUES ('EUPHYTICA'); INSERT INTO t_journal_words (name) VALUES ('EVOKED'); INSERT INTO t_journal_words (name) VALUES ('EVOLUTION'); INSERT INTO t_journal_words (name) VALUES ('EXPERIENTIA'); INSERT INTO t_journal_words (name) VALUES ('EXPRESSION'); INSERT INTO t_journal_words (name) VALUES ('EYE'); INSERT INTO t_journal_words (name) VALUES ('FASEB'); INSERT INTO t_journal_words (name) VALUES ('FATTY'); INSERT INTO t_journal_words (name) VALUES ('FEBS'); INSERT INTO t_journal_words (name) VALUES ('FEMS'); INSERT INTO t_journal_words (name) VALUES ('FETAL'); INSERT INTO t_journal_words (name) VALUES ('FIBRINOLYSIS'); INSERT INTO t_journal_words (name) VALUES ('FLOW'); INSERT INTO t_journal_words (name) VALUES ('FLUID'); INSERT INTO t_journal_words (name) VALUES ('FOLIA'); INSERT INTO t_journal_words (name) VALUES ('FOOD'); INSERT INTO t_journal_words (name) VALUES ('FORENSIC'); INSERT INTO t_journal_words (name) VALUES ('FREE'); INSERT INTO t_journal_words (name) VALUES ('GAMETE'); INSERT INTO t_journal_words (name) VALUES ('GASTROENTEROLOGY'); INSERT INTO t_journal_words (name) VALUES ('GENE'); INSERT INTO t_journal_words (name) VALUES ('GENES'); INSERT INTO t_journal_words (name) VALUES ('GENETICA'); INSERT INTO t_journal_words (name) VALUES ('GENETICS'); INSERT INTO t_journal_words (name) VALUES ('GENOME'); INSERT INTO t_journal_words (name) VALUES ('GENOMICS'); INSERT INTO t_journal_words (name) VALUES ('GERONTOLOGY'); INSERT INTO t_journal_words (name) VALUES ('GLIA'); INSERT INTO t_journal_words (name) VALUES ('GLYCOCONJUGATE'); INSERT INTO t_journal_words (name) VALUES ('GROWTH'); INSERT INTO t_journal_words (name) VALUES ('GUT'); INSERT INTO t_journal_words (name) VALUES ('HAEMATOLOGICA'); INSERT INTO t_journal_words (name) VALUES ('HAEMOSTASIS'); INSERT INTO t_journal_words (name) VALUES ('HAND'); INSERT INTO t_journal_words (name) VALUES ('HARBOR'); INSERT INTO t_journal_words (name) VALUES ('HEALTH'); INSERT INTO t_journal_words (name) VALUES ('HEART'); INSERT INTO t_journal_words (name) VALUES ('HEMOGLOBIN'); INSERT INTO t_journal_words (name) VALUES ('HEPATOLOGY'); INSERT INTO t_journal_words (name) VALUES ('HEREDITY'); INSERT INTO t_journal_words (name) VALUES ('HISTOCHEMISTRY'); INSERT INTO t_journal_words (name) VALUES ('HISTOPATHOLOGY'); INSERT INTO t_journal_words (name) VALUES ('HOPPE'); INSERT INTO t_journal_words (name) VALUES ('HYBRIDOMA'); INSERT INTO t_journal_words (name) VALUES ('HYPERTENSION'); INSERT INTO t_journal_words (name) VALUES ('IEEE'); INSERT INTO t_journal_words (name) VALUES ('IMAGING'); INSERT INTO t_journal_words (name) VALUES ('IMMUNOASSAY'); INSERT INTO t_journal_words (name) VALUES ('IMMUNOBIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('IMMUNOGENETICS'); INSERT INTO t_journal_words (name) VALUES ('IMMUNOLOGY'); INSERT INTO t_journal_words (name) VALUES ('IMMUNOPHARMACOLOGY'); INSERT INTO t_journal_words (name) VALUES ('IN'); INSERT INTO t_journal_words (name) VALUES ('INDIAN'); INSERT INTO t_journal_words (name) VALUES ('INFECTION'); INSERT INTO t_journal_words (name) VALUES ('INFLAMMATION'); INSERT INTO t_journal_words (name) VALUES ('INHERITED'); INSERT INTO t_journal_words (name) VALUES ('INSECT'); INSERT INTO t_journal_words (name) VALUES ('INSTABILITY'); INSERT INTO t_journal_words (name) VALUES ('INTERFACE'); INSERT INTO t_journal_words (name) VALUES ('INTERVIROLOGY'); INSERT INTO t_journal_words (name) VALUES ('INVASION'); INSERT INTO t_journal_words (name) VALUES ('JAMA'); INSERT INTO t_journal_words (name) VALUES ('JCU'); INSERT INTO t_journal_words (name) VALUES ('JNCI'); INSERT INTO t_journal_words (name) VALUES ('JOINT'); INSERT INTO t_journal_words (name) VALUES ('JOURNAL'); INSERT INTO t_journal_words (name) VALUES ('KIDNEY'); INSERT INTO t_journal_words (name) VALUES ('LAEGER'); INSERT INTO t_journal_words (name) VALUES ('LANCET'); INSERT INTO t_journal_words (name) VALUES ('LARYNGOSCOPE'); INSERT INTO t_journal_words (name) VALUES ('LEEUWENHOEK'); INSERT INTO t_journal_words (name) VALUES ('LENS'); INSERT INTO t_journal_words (name) VALUES ('LEUKEMIA'); INSERT INTO t_journal_words (name) VALUES ('LEUKOCYTE'); INSERT INTO t_journal_words (name) VALUES ('LEUKOTRIENES'); INSERT INTO t_journal_words (name) VALUES ('LIFE'); INSERT INTO t_journal_words (name) VALUES ('LIPID'); INSERT INTO t_journal_words (name) VALUES ('LIPIDS'); INSERT INTO t_journal_words (name) VALUES ('LIPOSOME'); INSERT INTO t_journal_words (name) VALUES ('LIQUID'); INSERT INTO t_journal_words (name) VALUES ('LIVER'); INSERT INTO t_journal_words (name) VALUES ('LUNG'); INSERT INTO t_journal_words (name) VALUES ('LYMPHATICS'); INSERT INTO t_journal_words (name) VALUES ('LYMPHOKINE'); INSERT INTO t_journal_words (name) VALUES ('LYMPHOLOGY'); INSERT INTO t_journal_words (name) VALUES ('MAGNESIUM'); INSERT INTO t_journal_words (name) VALUES ('MARKERS'); INSERT INTO t_journal_words (name) VALUES ('MARROW'); INSERT INTO t_journal_words (name) VALUES ('MATRIX'); INSERT INTO t_journal_words (name) VALUES ('MATURITAS'); INSERT INTO t_journal_words (name) VALUES ('MAYO'); INSERT INTO t_journal_words (name) VALUES ('MEDICINE'); INSERT INTO t_journal_words (name) VALUES ('MESSENGER'); INSERT INTO t_journal_words (name) VALUES ('MESSENGERS'); INSERT INTO t_journal_words (name) VALUES ('METABOLISM'); INSERT INTO t_journal_words (name) VALUES ('METASTASIS'); INSERT INTO t_journal_words (name) VALUES ('METHODS'); INSERT INTO t_journal_words (name) VALUES ('MGG'); INSERT INTO t_journal_words (name) VALUES ('MICROBIOLOGICA'); INSERT INTO t_journal_words (name) VALUES ('MICROBIOS'); INSERT INTO t_journal_words (name) VALUES ('MINERAL'); INSERT INTO t_journal_words (name) VALUES ('MOTOR'); INSERT INTO t_journal_words (name) VALUES ('MUSCLE'); INSERT INTO t_journal_words (name) VALUES ('MUTAGENESIS'); INSERT INTO t_journal_words (name) VALUES ('MYCOPATHOLOGIA'); INSERT INTO t_journal_words (name) VALUES ('MYCOTAXON'); INSERT INTO t_journal_words (name) VALUES ('NATURE'); INSERT INTO t_journal_words (name) VALUES ('NAUNYN'); INSERT INTO t_journal_words (name) VALUES ('NECK'); INSERT INTO t_journal_words (name) VALUES ('NEPHRON'); INSERT INTO t_journal_words (name) VALUES ('NERVE'); INSERT INTO t_journal_words (name) VALUES ('NETHERLANDS'); INSERT INTO t_journal_words (name) VALUES ('NEURAL'); INSERT INTO t_journal_words (name) VALUES ('NEUROLOGY'); INSERT INTO t_journal_words (name) VALUES ('NEURON'); INSERT INTO t_journal_words (name) VALUES ('NEUROPEPTIDES'); INSERT INTO t_journal_words (name) VALUES ('NEUROPHARMACOLOGY'); INSERT INTO t_journal_words (name) VALUES ('NEUROPSYCHOBIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('NEUROSCIENCE'); INSERT INTO t_journal_words (name) VALUES ('NEUROSURGERY'); INSERT INTO t_journal_words (name) VALUES ('NEW'); INSERT INTO t_journal_words (name) VALUES ('NEWS'); INSERT INTO t_journal_words (name) VALUES ('NITRIC'); INSERT INTO t_journal_words (name) VALUES ('NORTH'); INSERT INTO t_journal_words (name) VALUES ('NUCLEIC ACIDS'); INSERT INTO t_journal_words (name) VALUES ('NUCLEOSIDES'); INSERT INTO t_journal_words (name) VALUES ('NY'); INSERT INTO t_journal_words (name) VALUES ('OF'); INSERT INTO t_journal_words (name) VALUES ('OIL'); INSERT INTO t_journal_words (name) VALUES ('ONCOGENE'); INSERT INTO t_journal_words (name) VALUES ('ONCOLOGY'); INSERT INTO t_journal_words (name) VALUES ('OPHTHALMIC'); INSERT INTO t_journal_words (name) VALUES ('OPHTHALMOLOGICA'); INSERT INTO t_journal_words (name) VALUES ('ORAL'); INSERT INTO t_journal_words (name) VALUES ('ORGANS'); INSERT INTO t_journal_words (name) VALUES ('ORL'); INSERT INTO t_journal_words (name) VALUES ('OTHER'); INSERT INTO t_journal_words (name) VALUES ('OXIDE'); INSERT INTO t_journal_words (name) VALUES ('PAIN'); INSERT INTO t_journal_words (name) VALUES ('PANCREAS'); INSERT INTO t_journal_words (name) VALUES ('PARASITE'); INSERT INTO t_journal_words (name) VALUES ('PARASITOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PASTEUR'); INSERT INTO t_journal_words (name) VALUES ('PATHOBIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PEDIATRICS'); INSERT INTO t_journal_words (name) VALUES ('PEPTIDE'); INSERT INTO t_journal_words (name) VALUES ('PEPTIDES'); INSERT INTO t_journal_words (name) VALUES ('PERKIN'); INSERT INTO t_journal_words (name) VALUES ('PFLUGERS'); INSERT INTO t_journal_words (name) VALUES ('PHARMACOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PHOSPHOPROTEIN'); INSERT INTO t_journal_words (name) VALUES ('PHOSPHOPROTEINS'); INSERT INTO t_journal_words (name) VALUES ('PHYTOCHEMISTRY'); INSERT INTO t_journal_words (name) VALUES ('PHYTOPATHOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PIGMENT'); INSERT INTO t_journal_words (name) VALUES ('PINEAL'); INSERT INTO t_journal_words (name) VALUES ('PLANT'); INSERT INTO t_journal_words (name) VALUES ('PLANTA'); INSERT INTO t_journal_words (name) VALUES ('PLASMID'); INSERT INTO t_journal_words (name) VALUES ('POTENTIALS'); INSERT INTO t_journal_words (name) VALUES ('PRESSE'); INSERT INTO t_journal_words (name) VALUES ('PROCESSES'); INSERT INTO t_journal_words (name) VALUES ('PROGRAMS'); INSERT INTO t_journal_words (name) VALUES ('PROSTAGLANDINS'); INSERT INTO t_journal_words (name) VALUES ('PROSTATE'); INSERT INTO t_journal_words (name) VALUES ('PROTEIN'); INSERT INTO t_journal_words (name) VALUES ('PROTEINS'); INSERT INTO t_journal_words (name) VALUES ('PROTOPLASMA'); INSERT INTO t_journal_words (name) VALUES ('PSYCHIATRY'); INSERT INTO t_journal_words (name) VALUES ('PSYCHOBIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PSYCHOPATHOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PSYCHOPHARMACOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PSYCHOPHYSIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('PUBLIC'); INSERT INTO t_journal_words (name) VALUES ('RADIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('RECTUM'); INSERT INTO t_journal_words (name) VALUES ('RENAL'); INSERT INTO t_journal_words (name) VALUES ('REPAIR'); INSERT INTO t_journal_words (name) VALUES ('RESPIRATION'); INSERT INTO t_journal_words (name) VALUES ('RESPONSE'); INSERT INTO t_journal_words (name) VALUES ('RETROVIRUSES'); INSERT INTO t_journal_words (name) VALUES ('RHYTHMS'); INSERT INTO t_journal_words (name) VALUES ('SCHMIEDEBERGS'); INSERT INTO t_journal_words (name) VALUES ('SCIENCE'); INSERT INTO t_journal_words (name) VALUES ('SECOND'); INSERT INTO t_journal_words (name) VALUES ('SENSES'); INSERT INTO t_journal_words (name) VALUES ('SEYLER'); INSERT INTO t_journal_words (name) VALUES ('SHOCK'); INSERT INTO t_journal_words (name) VALUES ('SKIN'); INSERT INTO t_journal_words (name) VALUES ('SOIL'); INSERT INTO t_journal_words (name) VALUES ('SPORTS'); INSERT INTO t_journal_words (name) VALUES ('SPRING'); INSERT INTO t_journal_words (name) VALUES ('SPRINGER'); INSERT INTO t_journal_words (name) VALUES ('STAIN'); INSERT INTO t_journal_words (name) VALUES ('STEROID'); INSERT INTO t_journal_words (name) VALUES ('STEROIDS'); INSERT INTO t_journal_words (name) VALUES ('STROKE'); INSERT INTO t_journal_words (name) VALUES ('SURGERY'); INSERT INTO t_journal_words (name) VALUES ('SYNAPSE'); INSERT INTO t_journal_words (name) VALUES ('SYNTHESIS'); INSERT INTO t_journal_words (name) VALUES ('TERATOGENESIS'); INSERT INTO t_journal_words (name) VALUES ('TERATOLOGY'); INSERT INTO t_journal_words (name) VALUES ('TETRAHEDRON'); INSERT INTO t_journal_words (name) VALUES ('THERAPIE'); INSERT INTO t_journal_words (name) VALUES ('THERIOGENOLOGY'); INSERT INTO t_journal_words (name) VALUES ('THORAX'); INSERT INTO t_journal_words (name) VALUES ('THYMUS'); INSERT INTO t_journal_words (name) VALUES ('TIBS'); INSERT INTO t_journal_words (name) VALUES ('TIBTECH'); INSERT INTO t_journal_words (name) VALUES ('TIG'); INSERT INTO t_journal_words (name) VALUES ('TINS'); INSERT INTO t_journal_words (name) VALUES ('TIPS'); INSERT INTO t_journal_words (name) VALUES ('TISSUE'); INSERT INTO t_journal_words (name) VALUES ('TODAY'); INSERT INTO t_journal_words (name) VALUES ('TOXICOLOGY'); INSERT INTO t_journal_words (name) VALUES ('TOXICON'); INSERT INTO t_journal_words (name) VALUES ('TOXIN'); INSERT INTO t_journal_words (name) VALUES ('TRACE'); INSERT INTO t_journal_words (name) VALUES ('TRANSFUSION'); INSERT INTO t_journal_words (name) VALUES ('TRANSPLANTATION'); INSERT INTO t_journal_words (name) VALUES ('TREE'); INSERT INTO t_journal_words (name) VALUES ('TRENDS'); INSERT INTO t_journal_words (name) VALUES ('TUMOR'); INSERT INTO t_journal_words (name) VALUES ('ULTRAMICROSCOPY'); INSERT INTO t_journal_words (name) VALUES ('USA'); INSERT INTO t_journal_words (name) VALUES ('VACCINE'); INSERT INTO t_journal_words (name) VALUES ('VAN'); INSERT INTO t_journal_words (name) VALUES ('VESSELS'); INSERT INTO t_journal_words (name) VALUES ('VIRCHOWS'); INSERT INTO t_journal_words (name) VALUES ('VIROLOGY'); INSERT INTO t_journal_words (name) VALUES ('VIRUS'); INSERT INTO t_journal_words (name) VALUES ('VISION'); INSERT INTO t_journal_words (name) VALUES ('VISUAL'); INSERT INTO t_journal_words (name) VALUES ('VITRO'); INSERT INTO t_journal_words (name) VALUES ('VOX'); INSERT INTO t_journal_words (name) VALUES ('WHO'); INSERT INTO t_journal_words (name) VALUES ('WORLD'); INSERT INTO t_journal_words (name) VALUES ('XENOBIOTICA'); INSERT INTO t_journal_words (name) VALUES ('YALE'); INSERT INTO t_journal_words (name) VALUES ('ÄRZTEBL'); INSERT INTO t_journal_words (name) VALUES ('BJOG'); INSERT INTO t_journal_words (name) VALUES ('CRYOBIOLOGY'); INSERT INTO t_journal_words (name) VALUES ('BMC'); INSERT INTO t_journal_words (name) VALUES ('ASAIO'); UNLOCK TABLES; --- NEW FILE --- -- MySQL dump 10.9 -- -- Host: localhost Database: refdb -- ------------------------------------------------------ -- Server version 4.1.9 /*!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 utf8 */; /*!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" */; -- -- Table structure for table `CITSTYLE` -- DROP TABLE IF EXISTS `CITSTYLE`; CREATE TABLE `CITSTYLE` ( `ID` int(11) NOT NULL auto_increment, `JOURNAL` tinytext, `CITSEPARATOR` tinytext, `FOLLOWING` tinytext, `PRECEEDING` tinytext, `RANGESEPARATOR` tinytext, `BIBLIOTITLE` tinytext, `INTEXTSEQUENCE` varchar(10) default NULL, `BIBLIOSEQUENCE` varchar(11) default NULL, `BIBLIOFIRSTINDENT` varchar(16) default NULL, `BIBLIOBLOCKINDENT` varchar(16) default NULL, `FONTSIZE` varchar(16) default NULL, `STYLE` varchar(12) default NULL, `JANABBREV` varchar(16) default NULL, `FEBABBREV` varchar(16) default NULL, `MARABBREV` varchar(16) default NULL, `APRABBREV` varchar(16) default NULL, `MAYABBREV` varchar(16) default NULL, `JUNABBREV` varchar(16) default NULL, `JULABBREV` varchar(16) default NULL, `AUGABBREV` varchar(16) default NULL, `SEPABBREV` varchar(16) default NULL, `OCTABBREV` varchar(16) default NULL, `NOVABBREV` varchar(16) default NULL, `DECABBREV` varchar(16) default NULL, `JANFULL` varchar(255) default NULL, `FEBFULL` varchar(255) default NULL, `MARFULL` varchar(255) default NULL, `APRFULL` varchar(255) default NULL, `MAYFULL` varchar(255) default NULL, `JUNFULL` varchar(255) default NULL, `JULFULL` varchar(255) default NULL, `AUGFULL` varchar(255) default NULL, `SEPFULL` varchar(255) default NULL, `OCTFULL` varchar(255) default NULL, `NOVFULL` varchar(255) default NULL, `DECFULL` varchar(255) default NULL, `JANTHREELET` varchar(16) default NULL, `FEBTHREELET` varchar(16) default NULL, `MARTHREELET` varchar(16) default NULL, `APRTHREELET` varchar(16) default NULL, `MAYTHREELET` varchar(16) default NULL, `JUNTHREELET` varchar(16) default NULL, `JULTHREELET` varchar(16) default NULL, `AUGTHREELET` varchar(16) default NULL, `SEPTHREELET` varchar(16) default NULL, `OCTTHREELET` varchar(16) default NULL, `NOVTHREELET` varchar(16) default NULL, `DECTHREELET` varchar(16) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `CITSTYLE` -- /*!40000 ALTER TABLE `CITSTYLE` DISABLE KEYS */; LOCK TABLES `CITSTYLE` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `CITSTYLE` ENABLE KEYS */; -- -- Table structure for table `POSITIONS` -- DROP TABLE IF EXISTS `POSITIONS`; CREATE TABLE `POSITIONS` ( `ID` int(11) NOT NULL auto_increment, `REFSTYLEID` int(11) default NULL, `POS` int(11) default NULL, `SEPARATORID` int(11) default NULL, `TYPE` varchar(64) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `POSITIONS` -- /*!40000 ALTER TABLE `POSITIONS` DISABLE KEYS */; LOCK TABLES `POSITIONS` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `POSITIONS` ENABLE KEYS */; -- -- Table structure for table `REFSTYLE` -- DROP TABLE IF EXISTS `REFSTYLE`; CREATE TABLE `REFSTYLE` ( `ID` int(11) NOT NULL auto_increment, `CITSTYLEID` int(11) default NULL, `PUBTYPE` varchar(10) default NULL, `QSTYLE` varchar(12) default NULL, `XSTYLE` varchar(12) default NULL, `YSTYLE` varchar(12) default NULL, `ZSTYLE` varchar(12) default NULL, `QALTERNATESTYLE` varchar(12) default NULL, `XALTERNATESTYLE` varchar(12) default NULL, `YALTERNATESTYLE` varchar(12) default NULL, `ZALTERNATESTYLE` varchar(12) default NULL, `QALTERNATETEXT` varchar(15) default NULL, `XALTERNATETEXT` varchar(15) default NULL, `YALTERNATETEXT` varchar(15) default NULL, `ZALTERNATETEXT` varchar(15) default NULL, `QABBREVIATEFIRST` tinytext, `XABBREVIATEFIRST` tinytext, `YABBREVIATEFIRST` tinytext, `ZABBREVIATEFIRST` tinytext, `QABBREVIATESUBSEQ` tinytext, `XABBREVIATESUBSEQ` tinytext, `YABBREVIATESUBSEQ` tinytext, `ZABBREVIATESUBSEQ` tinytext, `QABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL, `XABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL, `YABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL, `ZABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL, `QABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL, `XABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL, `YABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL, `ZABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL, `QABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL, `XABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL, `YABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL, `ZABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL, `QABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL, `XABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL, `YABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL, `ZABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL, `QAEMPTY` tinytext, `XAEMPTY` tinytext, `YAEMPTY` tinytext, `ZAEMPTY` tinytext, `QASAME` tinytext, `XASAME` tinytext, `YASAME` tinytext, `ZASAME` tinytext, `QPRECEEDING` tinytext, `XPRECEEDING` tinytext, `YPRECEEDING` tinytext, `ZPRECEEDING` tinytext, `QFOLLOWING` tinytext, `XFOLLOWING` tinytext, `YFOLLOWING` tinytext, `ZFOLLOWING` tinytext, `QAUTHORSEPSTWOSEPS` tinytext, `XAUTHORSEPSTWOSEPS` tinytext, `YAUTHORSEPSTWOSEPS` tinytext, `ZAUTHORSEPSTWOSEPS` tinytext, `QAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext, `XAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext, `YAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext, `ZAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext, `QAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext, `XAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext, `YAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext, `ZAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext, `QAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(20) default NULL, `XAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(20) default NULL, `YAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(20) default NULL, `ZAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(20) default NULL, `QAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL, `XAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL, `YAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL, `ZAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL, `QAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL, `XAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL, `YAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL, `ZAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL, `QAUTHORNAMESNAMEOTHERNAMEORDER` varchar(20) default NULL, `XAUTHORNAMESNAMEOTHERNAMEORDER` varchar(20) default NULL, `YAUTHORNAMESNAMEOTHERNAMEORDER` varchar(20) default NULL, `ZAUTHORNAMESNAMEOTHERNAMEORDER` varchar(20) default NULL, `QAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL, `XAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL, `YAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL, `ZAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL, `QAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL, `XAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL, `YAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL, `ZAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL, `QTEXTTEXTSINGLEPRECEEDING` tinytext, `XTEXTTEXTSINGLEPRECEEDING` tinytext, `YTEXTTEXTSINGLEPRECEEDING` tinytext, `ZTEXTTEXTSINGLEPRECEEDING` tinytext, `QTEXTTEXTSINGLEFOLLOWING` tinytext, `XTEXTTEXTSINGLEFOLLOWING` tinytext, `YTEXTTEXTSINGLEFOLLOWING` tinytext, `ZTEXTTEXTSINGLEFOLLOWING` tinytext, `QTEXTTEXTMULTIPLEPRECEEDING` tinytext, `XTEXTTEXTMULTIPLEPRECEEDING` tinytext, `YTEXTTEXTMULTIPLEPRECEEDING` tinytext, `ZTEXTTEXTMULTIPLEPRECEEDING` tinytext, `QTEXTTEXTMULTIPLEFOLLOWING` tinytext, `XTEXTTEXTMULTIPLEFOLLOWING` tinytext, `YTEXTTEXTMULTIPLEFOLLOWING` tinytext, `ZTEXTTEXTMULTIPLEFOLLOWING` tinytext, `PUBDATEPRECEEDING` tinytext, `PUBDATEFOLLOWING` tinytext, `PUBDATEFIRSTSEP` tinytext, `PUBDATESECONDSEP` tinytext, `PUBDATEFORMAT` varchar(3) default NULL, `PUBDATESEQUENCE` varchar(3) default NULL, `PUBDATEMONTHFORMAT` varchar(11) default NULL, `PUBDATEDAYFORMAT` varchar(9) default NULL, `PUBDATEYEARFORMAT` varchar(9) default NULL, `PUBDATEPADLEADINGZERO` varchar(2) default NULL, `PUBDATESTYLE` varchar(12) default NULL, `PUBDATESECPRECEEDING` tinytext, `PUBDATESECFOLLOWING` tinytext, `PUBDATESECFIRSTSEP` tinytext, `PUBDATESECSECONDSEP` tinytext, `PUBDATESECFORMAT` varchar(3) default NULL, `PUBDATESECSEQUENCE` varchar(3) default NULL, `PUBDATESECMONTHFORMAT` varchar(11) default NULL, `PUBDATESECDAYFORMAT` varchar(9) default NULL, `PUBDATESECYEARFORMAT` varchar(9) default NULL, `PUBDATESECPADLEADINGZERO` varchar(2) default NULL, `PUBDATESECSTYLE` varchar(12) default NULL, `PUBDATEALLPRECEEDING` tinytext, `PUBDATEALLFOLLOWING` tinytext, `PUBDATEALLFIRSTSEP` tinytext, `PUBDATEALLSECONDSEP` tinytext, `PUBDATEALLFORMAT` varchar(3) default NULL, `PUBDATEALLSEQUENCE` varchar(3) default NULL, `PUBDATEALLMONTHFORMAT` varchar(11) default NULL, `PUBDATEALLDAYFORMAT` varchar(9) default NULL, `PUBDATEALLYEARFORMAT` varchar(9) default NULL, `PUBDATEALLPADLEADINGZERO` varchar(2) default NULL, `PUBDATEALLSTYLE` varchar(12) default NULL, `TITLEPRECEEDING` tinytext, `TITLEFOLLOWING` tinytext, `TITLECASE` varchar(5) default NULL, `TITLESTYLE` varchar(12) default NULL, `BOOKTITLEPRECEEDING` tinytext, `BOOKTITLEFOLLOWING` tinytext, `BOOKTITLECASE` varchar(5) default NULL, `BOOKTITLESTYLE` varchar(12) default NULL, `SERIESTITLEPRECEEDING` tinytext, `SERIESTITLEFOLLOWING` tinytext, `SERIESTITLECASE` varchar(5) default NULL, `SERIESTITLESTYLE` varchar(12) default NULL, `ALLTITLEPRECEEDING` tinytext, `ALLTITLEFOLLOWING` tinytext, `ALLTITLECASE` varchar(5) default NULL, `ALLTITLESTYLE` varchar(12) default NULL, `JOURNALNAMEPRECEEDING` tinytext, `JOURNALNAMEFOLLOWING` tinytext, `JOURNALNAMECASE` varchar(5) default NULL, `JOURNALNAMEDEFAULTTEXT` varchar(7) default NULL, `JOURNALNAMEALTERNATETEXT` varchar(8) default NULL, `JOURNALNAMEPUNCTUATION` varchar(11) default NULL, `JOURNALNAMESTYLE` varchar(12) default NULL, `VOLUMEPRECEEDING` tinytext, `VOLUMEFOLLOWING` tinytext, `VOLUMESTYLE` varchar(12) default NULL, `ISSUEPRECEEDING` tinytext, `ISSUEFOLLOWING` tinytext, `ISSUESTYLE` varchar(12) default NULL, `PAGESSTYLE` varchar(255) default NULL, `PAGESSINGLEPAGEPRECEEDING` tinytext, `PAGESSINGLEPAGEFOLLOWING` tinytext, `PAGESPAGERANGEPRECEEDING` tinytext, `PAGESPAGERANGEFOLLOWING` tinytext, `PAGESPAGERANGETYPE` varchar(9) default NULL, `PUBLISHERPRECEEDING` tinytext, `PUBLISHERFOLLOWING` tinytext, `PUBLISHERSTYLE` varchar(12) default NULL, `PUBPLACEPRECEEDING` tinytext, `PUBPLACEFOLLOWING` tinytext, `PUBPLACESTYLE` varchar(12) default NULL, `SERIALPRECEEDING` tinytext, `SERIALFOLLOWING` tinytext, `SERIALSTYLE` varchar(12) default NULL, `ADDRESSPRECEEDING` tinytext, `ADDRESSFOLLOWING` tinytext, `ADDRESSSTYLE` varchar(12) default NULL, `URLPRECEEDING` tinytext, `URLFOLLOWING` tinytext, `URLSTYLE` varchar(12) default NULL, `USERDEF1PRECEEDING` tinytext, `USERDEF1FOLLOWING` tinytext, `USERDEF1STYLE` varchar(12) default NULL, `USERDEF2PRECEEDING` tinytext, `USERDEF2FOLLOWING` tinytext, `USERDEF2STYLE` varchar(12) default NULL, `USERDEF3PRECEEDING` tinytext, `USERDEF3FOLLOWING` tinytext, `USERDEF3STYLE` varchar(12) default NULL, `USERDEF4PRECEEDING` tinytext, `USERDEF4FOLLOWING` tinytext, `USERDEF4STYLE` varchar(12) default NULL, `USERDEF5PRECEEDING` tinytext, `USERDEF5FOLLOWING` tinytext, `USERDEF5STYLE` varchar(12) default NULL, `MISC1PRECEEDING` tinytext, `MISC1FOLLOWING` tinytext, `MISC1STYLE` varchar(12) default NULL, `MISC2PRECEEDING` tinytext, `MISC2FOLLOWING` tinytext, `MISC2STYLE` varchar(12) default NULL, `MISC3PRECEEDING` tinytext, `MISC3FOLLOWING` tinytext, `MISC3STYLE` varchar(12) default NULL, `NOTESPRECEEDING` tinytext, `NOTESFOLLOWING` tinytext, `NOTESSTYLE` varchar(12) default NULL, `ABSTRACTPRECEEDING` tinytext, `ABSTRACTFOLLOWING` tinytext, `ABSTRACTSTYLE` varchar(12) default NULL, `LINK1PRECEEDING` tinytext, `LINK1FOLLOWING` tinytext, `LINK1STYLE` varchar(12) default NULL, `LINK2PRECEEDING` tinytext, `LINK2FOLLOWING` tinytext, `LINK2STYLE` varchar(12) default NULL, `LINK3PRECEEDING` tinytext, `LINK3FOLLOWING` tinytext, `LINK3STYLE` varchar(12) default NULL, `LINK4PRECEEDING` tinytext, `LINK4FOLLOWING` tinytext, `LINK4STYLE` varchar(12) default NULL, `PAGESPRECEEDING` tinytext, `PAGESFOLLOWING` tinytext, `REFNUMBERPRECEEDING` tinytext, `REFNUMBERFOLLOWING` tinytext, `REFNUMBERSTYLE` varchar(12) default NULL, `REFNUMBERUSE` varchar(3) default NULL, `PAGESPAGERANGERANGESEPARATOR` varchar(16) default NULL, `QABBREVIATEFIRSTSTYLE` varchar(12) default NULL, `QABBREVIATESUBSEQSTYLE` varchar(12) default NULL, `PAGESPAGERANGESTYLE` varchar(10) default NULL, `XABBREVIATEFIRSTSTYLE` varchar(12) default NULL, `YABBREVIATEFIRSTSTYLE` varchar(12) default NULL, `ZABBREVIATEFIRSTSTYLE` varchar(12) default NULL, `XABBREVIATESUBSEQSTYLE` varchar(12) default NULL, `YABBREVIATESUBSEQSTYLE` varchar(12) default NULL, `ZABBREVIATESUBSEQSTYLE` varchar(12) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `REFSTYLE` -- /*!40000 ALTER TABLE `REFSTYLE` DISABLE KEYS */; LOCK TABLES `REFSTYLE` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `REFSTYLE` ENABLE KEYS */; -- -- Table structure for table `SEPARATORS` -- DROP TABLE IF EXISTS `SEPARATORS`; CREATE TABLE `SEPARATORS` ( `ID` int(11) NOT NULL auto_increment, `STYLEID` int(11) default NULL, `VALUE` varchar(255) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `SEPARATORS` -- /*!40000 ALTER TABLE `SEPARATORS` DISABLE KEYS */; LOCK TABLES `SEPARATORS` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `SEPARATORS` ENABLE KEYS */; -- -- Table structure for table `t_journal_words` -- DROP TABLE IF EXISTS `t_journal_words`; CREATE TABLE `t_journal_words` ( `name` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `t_journal_words` -- /*!40000 ALTER TABLE `t_journal_words` DISABLE KEYS */; LOCK TABLES `t_journal_words` WRITE; INSERT INTO `t_journal_words` VALUES ('(BALTIMORE)'),('(BASEL)'),('(BERL)'),('(COPENH)'),('(GANN)'),('(JENA)'),('(LEIDEN)'),('(LOND)'),('(NY)'),('(PARIS)'),('(PAVIA)'),('(PRAHA)'),('(STOCKH)'),('(TOKYO)'),('ABUSE'),('ACCOUNTS'),('ACP'),('ACTA'),('ACTIONS'),('AFFAIRS'),('AFFECTIVE'),('AGEING'),('AGENTS'),('AGGRESSIVE'),('AGING'),('AIDS'),('ALCOHOL'),('ALCOHOLISM'),('ALLERGY'),('AMINES'),('ANAESTHESIA'),('ANALYST'),('ANESTHESIOLOGY'),('ANTICANCER'),('ANTIVIRAL'),('ANTONIE'),('APMIS'),('ARTERIOSCLEROSIS'),('ARTHRITIS'),('ARTHROPLASTY'),('ÃRZTEBL'),('ASAIO'),('ASTHMA'),('ASYMMETRY'),('ATHEROSCLEROSIS'),('AUDIOLOGY'),('B'),('BEHAVIOUR'),('BIO-ENERGETICS'),('BIOCHEMISTRY'),('BIOCHIMIE'),('BIOCHROMATOGRAPHY'),('BIOELECTROMAGNETICS'),('BIOESSAYS'),('BIOFACTORS'),('BIOGENIC'),('BIOLOGIST'),('BIOMATERIALS'),('BIOORGANIC'),('BIOPOLYMERS'),('BIOSYSTEMS'),('BIOTECHNIQUES'),('BIOTECHNOLOGY'),('BIOTHERAPY'),('BIRTH'),('BJOG'),('BLOOD'),('BLUT'),('BMC'),('BONE'),('BRAIN'),('BREAST'),('CALCIUM'),('CAMBRIDGE'),('CANCER'),('CARCINOGENESIS'),('CARDIOLOGY'),('CARE'),('CELL'),('CELLS'),('CHEMOTHERAPY'),('CHEST'),('CHILD'),('CHROMATOGRAPHY'),('CHROMOSOMA'),('CIRCULATION'),('COLD'),('COLLOID'),('COLON'),('COMPLEMENT'),('CONTRACEPTION'),('CONTROLLED'),('CRC'),('CROP'),('CRYOBIOLOGY'),('CULTURE'),('CYCLE'),('CYTOBIOS'),('CYTOMETRY'),('CYTOSKELETON'),('CYTOTECHNOLOGY'),('DEFECTS'),('DERMATOLOGICA'),('DEVELOPMENT'),('DIABETES'),('DIABETOLOGIA'),('DIGESTION'),('DNA'),('DNAGING'),('DRUG'),('DRUGS'),('DT'),('EARLY'),('EICOSANOIDS'),('ELECTROLYTE'),('ELECTRON'),('ELECTROPHORESIS'),('EMBO'),('ENDOCRINOLOGY'),('ENDOTHELIUM'),('ENVIRONMENT'),('ENZYME'),('EPILEPSIA'),('EPILEPSY'),('EUPHYTICA'),('EVOKED'),('EVOLUTION'),('EXPERIENTIA'),('EXPRESSION'),('EYE'),('FASEB'),('FATTY'),('FEBS'),('FEMS'),('FETAL'),('FIBRINOLYSIS'),('FLOW'),('FLUID'),('FOLIA'),('FOOD'),('FORENSIC'),('FREE'),('GAMETE'),('GASTROENTEROLOGY'),('GENE'),('GENES'),('GENETICA'),('GENETICS'),('GENOME'),('GENOMICS'),('GERONTOLOGY'),('GLIA'),('GLYCOCONJUGATE'),('GROWTH'),('GUT'),('HAEMATOLOGICA'),('HAEMOSTASIS'),('HAND'),('HARBOR'),('HEALTH'),('HEART'),('HEMOGLOBIN'),('HEPATOLOGY'),('HEREDITY'),('HISTOCHEMISTRY'),('HISTOPATHOLOGY'),('HOPPE'),('HYBRIDOMA'),('HYPERTENSION'),('IEEE'),('IMAGING'),('IMMUNOASSAY'),('IMMUNOBIOLOGY'),('IMMUNOGENETICS'),('IMMUNOLOGY'),('IMMUNOPHARMACOLOGY'),('IN'),('INDIAN'),('INFECTION'),('INFLAMMATION'),('INHERITED'),('INSECT'),('INSTABILITY'),('INTERFACE'),('INTERVIROLOGY'),('INVASION'),('JAMA'),('JCU'),('JNCI'),('JOINT'),('JOURNAL'),('KIDNEY'),('LAEGER'),('LANCET'),('LARYNGOSCOPE'),('LEEUWENHOEK'),('LENS'),('LEUKEMIA'),('LEUKOCYTE'),('LEUKOTRIENES'),('LIFE'),('LIPID'),('LIPIDS'),('LIPOSOME'),('LIQUID'),('LIVER'),('LUNG'),('LYMPHATICS'),('LYMPHOKINE'),('LYMPHOLOGY'),('MAGNESIUM'),('MARKERS'),('MARROW'),('MATRIX'),('MATURITAS'),('MAYO'),('MEDICINE'),('MESSENGER'),('MESSENGERS'),('METABOLISM'),('METASTASIS'),('METHODS'),('MGG'),('MICROBIOLOGICA'),('MICROBIOS'),('MINERAL'),('MOTOR'),('MUSCLE'),('MUTAGENESIS'),('MYCOPATHOLOGIA'),('MYCOTAXON'),('NATURE'),('NAUNYN'),('NECK'),('NEPHRON'),('NERVE'),('NETHERLANDS'),('NEURAL'),('NEUROLOGY'),('NEURON'),('NEUROPEPTIDES'),('NEUROPHARMACOLOGY'),('NEUROPSYCHOBIOLOGY'),('NEUROSCIENCE'),('NEUROSURGERY'),('NEW'),('NEWS'),('NITRIC'),('NORTH'),('NUCLEIC ACIDS'),('NUCLEOSIDES'),('NY'),('OF'),('OIL'),('ONCOGENE'),('ONCOLOGY'),('OPHTHALMIC'),('OPHTHALMOLOGICA'),('ORAL'),('ORGANS'),('ORL'),('OTHER'),('OXIDE'),('PAIN'),('PANCREAS'),('PARASITE'),('PARASITOLOGY'),('PASTEUR'),('PATHOBIOLOGY'),('PEDIATRICS'),('PEPTIDE'),('PEPTIDES'),('PERKIN'),('PFLUGERS'),('PHARMACOLOGY'),('PHOSPHOPROTEIN'),('PHOSPHOPROTEINS'),('PHYTOCHEMISTRY'),('PHYTOPATHOLOGY'),('PIGMENT'),('PINEAL'),('PLANT'),('PLANTA'),('PLASMID'),('POTENTIALS'),('PRESSE'),('PROCESSES'),('PROGRAMS'),('PROSTAGLANDINS'),('PROSTATE'),('PROTEIN'),('PROTEINS'),('PROTOPLASMA'),('PSYCHIATRY'),('PSYCHOBIOLOGY'),('PSYCHOPATHOLOGY'),('PSYCHOPHARMACOLOGY'),('PSYCHOPHYSIOLOGY'),('PUBLIC'),('RADIOLOGY'),('RECTUM'),('RENAL'),('REPAIR'),('RESPIRATION'),('RESPONSE'),('RETROVIRUSES'),('RHYTHMS'),('SCHMIEDEBERGS'),('SCIENCE'),('SECOND'),('SENSES'),('SEYLER'),('SHOCK'),('SKIN'),('SOIL'),('SPORTS'),('SPRING'),('SPRINGER'),('STAIN'),('STEROID'),('STEROIDS'),('STROKE'),('SURGERY'),('SYNAPSE'),('SYNTHESIS'),('TERATOGENESIS'),('TERATOLOGY'),('TETRAHEDRON'),('THERAPIE'),('THERIOGENOLOGY'),('THORAX'),('THYMUS'),('TIBS'),('TIBTECH'),('TIG'),('TINS'),('TIPS'),('TISSUE'),('TODAY'),('TOXICOLOGY'),('TOXICON'),('TOXIN'),('TRACE'),('TRANSFUSION'),('TRANSPLANTATION'),('TREE'),('TRENDS'),('TUMOR'),('ULTRAMICROSCOPY'),('USA'),('VACCINE'),('VAN'),('VESSELS'),('VIRCHOWS'),('VIROLOGY'),('VIRUS'),('VISION'),('VISUAL'),('VITRO'),('VOX'),('WHO'),('WORLD'),('XENOBIOTICA'),('YALE'); UNLOCK TABLES; /*!40000 ALTER TABLE `t_journal_words` ENABLE KEYS */; -- -- Table structure for table `t_meta` -- DROP TABLE IF EXISTS `t_meta`; CREATE TABLE `t_meta` ( `meta_app` varchar(20) default NULL, `meta_type` varchar(20) default NULL, `meta_version` varchar(20) default NULL, `meta_dbversion` smallint(6) default NULL, `meta_create_date` datetime default NULL, `meta_modify_date` datetime default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `t_meta` -- /*!40000 ALTER TABLE `t_meta` DISABLE KEYS */; LOCK TABLES `t_meta` WRITE; INSERT INTO `t_meta` VALUES ('<package>','refdb','<version>',1,UTC_TIMESTAMP,UTC_TIMESTAMP); UNLOCK TABLES; /*!40000 ALTER TABLE `t_meta` ENABLE KEYS */; /*!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 */; --- NEW FILE --- CREATE TABLE CITSTYLE ( ID SERIAL, JOURNAL TEXT, CITSEPARATOR TEXT, FOLLOWING TEXT, PRECEEDING TEXT, RANGESEPARATOR TEXT, BIBLIOTITLE TEXT, INTEXTSEQUENCE TEXT, BIBLIOSEQUENCE TEXT, BIBLIOFIRSTINDENT TEXT, BIBLIOBLOCKINDENT TEXT, FONTSIZE TEXT, STYLE TEXT, JANABBREV TEXT, FEBABBREV TEXT, MARABBREV TEXT, APRABBREV TEXT, MAYABBREV TEXT, JUNABBREV TEXT, JULABBREV TEXT, AUGABBREV TEXT, SEPABBREV TEXT, OCTABBREV TEXT, NOVABBREV TEXT, DECABBREV TEXT, JANFULL TEXT, FEBFULL TEXT, MARFULL TEXT, APRFULL TEXT, MAYFULL TEXT, JUNFULL TEXT, JULFULL TEXT, AUGFULL TEXT, SEPFULL TEXT, OCTFULL TEXT, NOVFULL TEXT, DECFULL TEXT, JANTHREELET TEXT, FEBTHREELET TEXT, MARTHREELET TEXT, APRTHREELET TEXT, MAYTHREELET TEXT, JUNTHREELET TEXT, JULTHREELET TEXT, AUGTHREELET TEXT, SEPTHREELET TEXT, OCTTHREELET TEXT, NOVTHREELET TEXT, DECTHREELET TEXT, PRIMARY KEY (ID) ); CREATE TABLE POSITIONS ( ID SERIAL, REFSTYLEID INTEGER, POS INTEGER, SEPARATORID INTEGER, TYPE TEXT, PRIMARY KEY (ID) ); CREATE TABLE REFSTYLE ( ID SERIAL, CITSTYLEID INTEGER, PUBTYPE TEXT, QSTYLE TEXT, XSTYLE TEXT, YSTYLE TEXT, ZSTYLE TEXT, QALTERNATESTYLE TEXT, XALTERNATESTYLE TEXT, YALTERNATESTYLE TEXT, ZALTERNATESTYLE TEXT, QALTERNATETEXT TEXT, XALTERNATETEXT TEXT, YALTERNATETEXT TEXT, ZALTERNATETEXT TEXT, QABBREVIATEFIRST TEXT, XABBREVIATEFIRST TEXT, YABBREVIATEFIRST TEXT, ZABBREVIATEFIRST TEXT, QABBREVIATESUBSEQ TEXT, XABBREVIATESUBSEQ TEXT, YABBREVIATESUBSEQ TEXT, ZABBREVIATESUBSEQ TEXT, QABBREVIATEFIRSTMAXAUTHOR TEXT, XABBREVIATEFIRSTMAXAUTHOR TEXT, YABBREVIATEFIRSTMAXAUTHOR TEXT, ZABBREVIATEFIRSTMAXAUTHOR TEXT, QABBREVIATESUBSEQMAXAUTHOR TEXT, XABBREVIATESUBSEQMAXAUTHOR TEXT, YABBREVIATESUBSEQMAXAUTHOR TEXT, ZABBREVIATESUBSEQMAXAUTHOR TEXT, QABBREVIATEFIRSTDISPLAYAUTHOR TEXT, XABBREVIATEFIRSTDISPLAYAUTHOR TEXT, YABBREVIATEFIRSTDISPLAYAUTHOR TEXT, ZABBREVIATEFIRSTDISPLAYAUTHOR TEXT, QABBREVIATESUBSEQDISPLAYAUTHOR TEXT, XABBREVIATESUBSEQDISPLAYAUTHOR TEXT, YABBREVIATESUBSEQDISPLAYAUTHOR TEXT, ZABBREVIATESUBSEQDISPLAYAUTHOR TEXT, QAEMPTY TEXT, XAEMPTY TEXT, YAEMPTY TEXT, ZAEMPTY TEXT, QASAME TEXT, XASAME TEXT, YASAME TEXT, ZASAME TEXT, QPRECEEDING TEXT, XPRECEEDING TEXT, YPRECEEDING TEXT, ZPRECEEDING TEXT, QFOLLOWING TEXT, XFOLLOWING TEXT, YFOLLOWING TEXT, ZFOLLOWING TEXT, QAUTHORSEPSTWOSEPS TEXT, XAUTHORSEPSTWOSEPS TEXT, YAUTHORSEPSTWOSEPS TEXT, ZAUTHORSEPSTWOSEPS TEXT, QAUTHORSEPSTHREESEPSTHREESEPSEACH TEXT, XAUTHORSEPSTHREESEPSTHREESEPSEACH TEXT, YAUTHORSEPSTHREESEPSTHREESEPSEACH TEXT, ZAUTHORSEPSTHREESEPSTHREESEPSEACH TEXT, QAUTHORSEPSTHREESEPSTHREESEPSLAST TEXT, XAUTHORSEPSTHREESEPSTHREESEPSLAST TEXT, YAUTHORSEPSTHREESEPSTHREESEPSLAST TEXT, ZAUTHORSEPSTHREESEPSTHREESEPSLAST TEXT, QAUTHORNAMESNAMEFIRSTNAMEORDER TEXT, XAUTHORNAMESNAMEFIRSTNAMEORDER TEXT, YAUTHORNAMESNAMEFIRSTNAMEORDER TEXT, ZAUTHORNAMESNAMEFIRSTNAMEORDER TEXT, QAUTHORNAMESNAMEFIRSTINITIALSTYLE TEXT, XAUTHORNAMESNAMEFIRSTINITIALSTYLE TEXT, YAUTHORNAMESNAMEFIRSTINITIALSTYLE TEXT, ZAUTHORNAMESNAMEFIRSTINITIALSTYLE TEXT, QAUTHORNAMESNAMEFIRSTUPPERCASE TEXT, XAUTHORNAMESNAMEFIRSTUPPERCASE TEXT, YAUTHORNAMESNAMEFIRSTUPPERCASE TEXT, ZAUTHORNAMESNAMEFIRSTUPPERCASE TEXT, QAUTHORNAMESNAMEOTHERNAMEORDER TEXT, XAUTHORNAMESNAMEOTHERNAMEORDER TEXT, YAUTHORNAMESNAMEOTHERNAMEORDER TEXT, ZAUTHORNAMESNAMEOTHERNAMEORDER TEXT, QAUTHORNAMESNAMEOTHERINITIALSTYLE TEXT, XAUTHORNAMESNAMEOTHERINITIALSTYLE TEXT, YAUTHORNAMESNAMEOTHERINITIALSTYLE TEXT, ZAUTHORNAMESNAMEOTHERINITIALSTYLE TEXT, QAUTHORNAMESNAMEOTHERUPPERCASE TEXT, XAUTHORNAMESNAMEOTHERUPPERCASE TEXT, YAUTHORNAMESNAMEOTHERUPPERCASE TEXT, ZAUTHORNAMESNAMEOTHERUPPERCASE TEXT, QTEXTTEXTSINGLEPRECEEDING TEXT, XTEXTTEXTSINGLEPRECEEDING TEXT, YTEXTTEXTSINGLEPRECEEDING TEXT, ZTEXTTEXTSINGLEPRECEEDING TEXT, QTEXTTEXTSINGLEFOLLOWING TEXT, XTEXTTEXTSINGLEFOLLOWING TEXT, YTEXTTEXTSINGLEFOLLOWING TEXT, ZTEXTTEXTSINGLEFOLLOWING TEXT, QTEXTTEXTMULTIPLEPRECEEDING TEXT, XTEXTTEXTMULTIPLEPRECEEDING TEXT, YTEXTTEXTMULTIPLEPRECEEDING TEXT, ZTEXTTEXTMULTIPLEPRECEEDING TEXT, QTEXTTEXTMULTIPLEFOLLOWING TEXT, XTEXTTEXTMULTIPLEFOLLOWING TEXT, YTEXTTEXTMULTIPLEFOLLOWING TEXT, ZTEXTTEXTMULTIPLEFOLLOWING TEXT, PUBDATEPRECEEDING TEXT, PUBDATEFOLLOWING TEXT, PUBDATEFIRSTSEP TEXT, PUBDATESECONDSEP TEXT, PUBDATEFORMAT TEXT, PUBDATESEQUENCE TEXT, PUBDATEMONTHFORMAT TEXT, PUBDATEDAYFORMAT TEXT, PUBDATEYEARFORMAT TEXT, PUBDATEPADLEADINGZERO TEXT, PUBDATESTYLE TEXT, PUBDATESECPRECEEDING TEXT, PUBDATESECFOLLOWING TEXT, PUBDATESECFIRSTSEP TEXT, PUBDATESECSECONDSEP TEXT, PUBDATESECFORMAT TEXT, PUBDATESECSEQUENCE TEXT, PUBDATESECMONTHFORMAT TEXT, PUBDATESECDAYFORMAT TEXT, PUBDATESECYEARFORMAT TEXT, PUBDATESECPADLEADINGZERO TEXT, PUBDATESECSTYLE TEXT, PUBDATEALLPRECEEDING TEXT, PUBDATEALLFOLLOWING TEXT, PUBDATEALLFIRSTSEP TEXT, PUBDATEALLSECONDSEP TEXT, PUBDATEALLFORMAT TEXT, PUBDATEALLSEQUENCE TEXT, PUBDATEALLMONTHFORMAT TEXT, PUBDATEALLDAYFORMAT TEXT, PUBDATEALLYEARFORMAT TEXT, PUBDATEALLPADLEADINGZERO TEXT, PUBDATEALLSTYLE TEXT, TITLEPRECEEDING TEXT, TITLEFOLLOWING TEXT, TITLECASE TEXT, TITLESTYLE TEXT, BOOKTITLEPRECEEDING TEXT, BOOKTITLEFOLLOWING TEXT, BOOKTITLECASE TEXT, BOOKTITLESTYLE TEXT, SERIESTITLEPRECEEDING TEXT, SERIESTITLEFOLLOWING TEXT, SERIESTITLECASE TEXT, SERIESTITLESTYLE TEXT, ALLTITLEPRECEEDING TEXT, ALLTITLEFOLLOWING TEXT, ALLTITLECASE TEXT, ALLTITLESTYLE TEXT, JOURNALNAMEPRECEEDING TEXT, JOURNALNAMEFOLLOWING TEXT, JOURNALNAMECASE TEXT, JOURNALNAMEDEFAULTTEXT TEXT, JOURNALNAMEALTERNATETEXT TEXT, JOURNALNAMEPUNCTUATION TEXT, JOURNALNAMESTYLE TEXT, VOLUMEPRECEEDING TEXT, VOLUMEFOLLOWING TEXT, VOLUMESTYLE TEXT, ISSUEPRECEEDING TEXT, ISSUEFOLLOWING TEXT, ISSUESTYLE TEXT, PAGESSTYLE TEXT, PAGESSINGLEPAGEPRECEEDING TEXT, PAGESSINGLEPAGEFOLLOWING TEXT, PAGESPAGERANGEPRECEEDING TEXT, PAGESPAGERANGEFOLLOWING TEXT, PAGESPAGERANGETYPE TEXT, PUBLISHERPRECEEDING TEXT, PUBLISHERFOLLOWING TEXT, PUBLISHERSTYLE TEXT, PUBPLACEPRECEEDING TEXT, PUBPLACEFOLLOWING TEXT, PUBPLACESTYLE TEXT, SERIALPRECEEDING TEXT, SERIALFOLLOWING TEXT, SERIALSTYLE TEXT, ADDRESSPRECEEDING TEXT, ADDRESSFOLLOWING TEXT, ADDRESSSTYLE TEXT, URLPRECEEDING TEXT, URLFOLLOWING TEXT, URLSTYLE TEXT, USERDEF1PRECEEDING TEXT, USERDEF1FOLLOWING TEXT, USERDEF1STYLE TEXT, USERDEF2PRECEEDING TEXT, USERDEF2FOLLOWING TEXT, USERDEF2STYLE TEXT, USERDEF3PRECEEDING TEXT, USERDEF3FOLLOWING TEXT, USERDEF3STYLE TEXT, USERDEF4PRECEEDING TEXT, USERDEF4FOLLOWING TEXT, USERDEF4STYLE TEXT, USERDEF5PRECEEDING TEXT, USERDEF5FOLLOWING TEXT, USERDEF5STYLE TEXT, MISC1PRECEEDING TEXT, MISC1FOLLOWING TEXT, MISC1STYLE TEXT, MISC2PRECEEDING TEXT, MISC2FOLLOWING TEXT, MISC2STYLE TEXT, MISC3PRECEEDING TEXT, MISC3FOLLOWING TEXT, MISC3STYLE TEXT, NOTESPRECEEDING TEXT, NOTESFOLLOWING TEXT, NOTESSTYLE TEXT, ABSTRACTPRECEEDING TEXT, ABSTRACTFOLLOWING TEXT, ABSTRACTSTYLE TEXT, LINK1PRECEEDING TEXT, LINK1FOLLOWING TEXT, LINK1STYLE TEXT, LINK2PRECEEDING TEXT, LINK2FOLLOWING TEXT, LINK2STYLE TEXT, LINK3PRECEEDING TEXT, LINK3FOLLOWING TEXT, LINK3STYLE TEXT, LINK4PRECEEDING TEXT, LINK4FOLLOWING TEXT, LINK4STYLE TEXT, PAGESPRECEEDING TEXT, PAGESFOLLOWING TEXT, REFNUMBERPRECEEDING TEXT, REFNUMBERFOLLOWING TEXT, REFNUMBERSTYLE TEXT, REFNUMBERUSE TEXT, PAGESPAGERANGERANGESEPARATOR TEXT, QABBREVIATEFIRSTSTYLE TEXT, QABBREVIATESUBSEQSTYLE TEXT, PAGESPAGERANGESTYLE TEXT, XABBREVIATEFIRSTSTYLE TEXT, YABBREVIATEFIRSTSTYLE TEXT, ZABBREVIATEFIRSTSTYLE TEXT, XABBREVIATESUBSEQSTYLE TEXT, YABBREVIATESUBSEQSTYLE TEXT, ZABBREVIATESUBSEQSTYLE TEXT, PRIMARY KEY (ID) ); CREATE TABLE SEPARATORS ( ID SERIAL, STYLEID INTEGER, VALUE TEXT, PRIMARY KEY (ID) ); CREATE TABLE t_meta ( meta_app TEXT, meta_type TEXT, meta_version TEXT, meta_dbversion SMALLINT, meta_cr... [truncated message content] |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:27:40
|
Update of /cvsroot/refdb/refdb/scripts In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32513/scripts Modified Files: Tag: Release_0_9_5_stable Makefile.am Log Message: dump files are now built from sources;added dump files for MySQL and MySQL4.1 Index: Makefile.am =================================================================== RCS file: /cvsroot/refdb/refdb/scripts/Makefile.am,v retrieving revision 1.23.2.2 retrieving revision 1.23.2.3 diff -u -U2 -r1.23.2.2 -r1.23.2.3 --- Makefile.am 10 Dec 2004 22:08:01 -0000 1.23.2.2 +++ Makefile.am 10 Feb 2005 20:27:19 -0000 1.23.2.3 @@ -3,9 +3,13 @@ bin_SCRIPTS = @server_scripts@ @client_scripts@ -EXTRA_DIST=refdbjade.in runbib.in tex2mail db2ris.in refdb-bug.in refdbxml.in refdb.dump refdb.dump.pgsql refdb.dump.sqlite refdb refdbctl.in empty.mysql.dump empty.pgsql.dump.in refdb-upgrade.sql marc2ris.pl.in med2ris.pl.in en2ris.pl.in refdbnd.in vargen.pl libgen.pl dos2unix.in migrate_mysql_0.9.5 +EXTRA_DIST=refdbjade.in runbib.in tex2mail db2ris.in refdb-bug.in refdbxml.in refdb refdbctl.in empty.mysql.dump empty.pgsql.dump.in refdb-upgrade.sql marc2ris.pl.in med2ris.pl.in en2ris.pl.in refdbnd.in vargen.pl libgen.pl dos2unix.in migrate_mysql_0.9.5 refdb.dump.mysql.in refdb.dump.mysql41.in refdb.dump.pgsql.in refdb.dump.sqlite.in -MOSTLYCLEANFILES=refdbjade runbib db2ris refdbxml refdbctl refdb-bug refdbnd marc2ris.pl med2ris.pl en2ris.pl dos2unix +MOSTLYCLEANFILES=refdbjade runbib db2ris refdbxml refdbctl refdb-bug refdbnd marc2ris.pl med2ris.pl en2ris.pl dos2unix refdb.dump.mysql refdb.dump.mysql41 refdb.dump.pgsql refdb.dump.sqlite -sqlscripts=refdb.dump refdb.dump.pgsql refdb.dump.sqlite empty.mysql.dump empty.pgsql.dump.in refdb-upgrade.sql +sqlscripts=refdb.dump.mysql refdb.dump.pgsql refdb.dump.sqlite empty.mysql.dump empty.pgsql.dump.in refdb-upgrade.sql refdb.dump.mysql41 + +utctimestamp=$(shell date -u "+%Y-%m-%d %H:%M:%S") + +all: refdb.dump.mysql41 refdb.dump.mysql refdb.dump.pgsql refdb.dump.sqlite refdbjade: refdbjade.in @@ -75,4 +79,21 @@ chmod a+x en2ris.pl +refdb.dump.mysql: refdb.dump.mysql.in + sed 's%<package>%@PACKAGE@%' < $(srcdir)/refdb.dump.mysql.in |\ + sed 's%<version>%@VERSION@%' > refdb.dump.mysql + +refdb.dump.mysql41: refdb.dump.mysql41.in + sed 's%<package>%@PACKAGE@%' < $(srcdir)/refdb.dump.mysql41.in |\ + sed 's%<version>%@VERSION@%' > refdb.dump.mysql41 + +refdb.dump.pgsql: refdb.dump.pgsql.in + sed 's%<package>%@PACKAGE@%' < $(srcdir)/refdb.dump.pgsql.in |\ + sed 's%<version>%@VERSION@%' > refdb.dump.pgsql + +refdb.dump.sqlite: refdb.dump.sqlite.in + sed 's%<package>%@PACKAGE@%' < $(srcdir)/refdb.dump.sqlite.in |\ + sed 's%<version>%@VERSION@%' |\ + sed 's%CURRENT_TIMESTAMP%$(utctimestamp)%g' > refdb.dump.sqlite + install-data-local: $(mkinstalldirs) $(DESTDIR)$(pkgdatadir)/sql |
|
From: Markus H. <mho...@us...> - 2005-02-10 20:18:46
|
Update of /cvsroot/refdb/refdb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29026 Modified Files: Tag: Release_0_9_5_stable configure.in Log Message: sqlite is now the default database engine Index: configure.in =================================================================== RCS file: /cvsroot/refdb/refdb/configure.in,v retrieving revision 1.49.2.10 retrieving revision 1.49.2.11 diff -u -U2 -r1.49.2.10 -r1.49.2.11 --- configure.in 4 Feb 2005 00:22:49 -0000 1.49.2.10 +++ configure.in 10 Feb 2005 20:18:29 -0000 1.49.2.11 @@ -83,18 +83,17 @@ dnl which database server are we supposed to use? AC_ARG_WITH(db_server, - [ --with-db-server=DBS Preconfigure for mysql (default), pgsql, or sqlite], + [ --with-db-server=DBS Preconfigure for sqlite (default), pgsql, or mysql], [if test $withval = "pgsql" || test $withval = "PGSQL"; then db_server=pgsql dbs_port=5432 -elif test $withval = "sqlite" || test $withval = "SQLITE"; then -db_server=sqlite -else +elif test $withval = "mysql" || test $withval = "MYSQL"; then db_server=mysql dbs_port=3306 +else +db_server=sqlite fi echo "Configuration files will assume "$withval" as database engine"], - [db_server="mysql" -dbs_port=3306 -echo "Configuration files will assume mysql as database engine"], + [db_server="sqlite" +echo "Configuration files will assume sqlite as database engine"], ]) |
1 message has been excluded from this view by a project administrator.
