1-- MySQL dump 10.9
2--
3-- Host: localhost    Database: refdb
4-- ------------------------------------------------------
5-- Server version	4.1.9
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;
14
15--
16-- Table structure for table `CITSTYLE`
17--
18
19DROP TABLE IF EXISTS `CITSTYLE`;
20CREATE TABLE `CITSTYLE` (
21  `ID` int(11) NOT NULL auto_increment,
22  `JOURNAL` tinytext,
23  `AUTHOR` tinytext,
24  `COMMENT` tinytext,
25  `URL` tinytext,
26  `CITSEPARATOR` tinytext,
27  `FOLLOWING` tinytext,
28  `PRECEEDING` tinytext,
29  `RANGESEPARATOR` tinytext,
30  `BIBLIOTITLE` tinytext,
31  `INTEXTSEQUENCE` varchar(10) default NULL,
32  `BIBLIOSEQUENCE` varchar(11) default NULL,
33  `BIBLIOFIRSTINDENT` varchar(16) default NULL,
34  `BIBLIOBLOCKINDENT` varchar(16) default NULL,
35  `FONTSIZE` varchar(16) default NULL,
36  `STYLE` varchar(12) default NULL,
37  `JANABBREV` varchar(16) default NULL,
38  `FEBABBREV` varchar(16) default NULL,
39  `MARABBREV` varchar(16) default NULL,
40  `APRABBREV` varchar(16) default NULL,
41  `MAYABBREV` varchar(16) default NULL,
42  `JUNABBREV` varchar(16) default NULL,
43  `JULABBREV` varchar(16) default NULL,
44  `AUGABBREV` varchar(16) default NULL,
45  `SEPABBREV` varchar(16) default NULL,
46  `OCTABBREV` varchar(16) default NULL,
47  `NOVABBREV` varchar(16) default NULL,
48  `DECABBREV` varchar(16) default NULL,
49  `JANFULL` varchar(255) default NULL,
50  `FEBFULL` varchar(255) default NULL,
51  `MARFULL` varchar(255) default NULL,
52  `APRFULL` varchar(255) default NULL,
53  `MAYFULL` varchar(255) default NULL,
54  `JUNFULL` varchar(255) default NULL,
55  `JULFULL` varchar(255) default NULL,
56  `AUGFULL` varchar(255) default NULL,
57  `SEPFULL` varchar(255) default NULL,
58  `OCTFULL` varchar(255) default NULL,
59  `NOVFULL` varchar(255) default NULL,
60  `DECFULL` varchar(255) default NULL,
61  `JANTHREELET` varchar(16) default NULL,
62  `FEBTHREELET` varchar(16) default NULL,
63  `MARTHREELET` varchar(16) default NULL,
64  `APRTHREELET` varchar(16) default NULL,
65  `MAYTHREELET` varchar(16) default NULL,
66  `JUNTHREELET` varchar(16) default NULL,
67  `JULTHREELET` varchar(16) default NULL,
68  `AUGTHREELET` varchar(16) default NULL,
69  `SEPTHREELET` varchar(16) default NULL,
70  `OCTTHREELET` varchar(16) default NULL,
71  `NOVTHREELET` varchar(16) default NULL,
72  `DECTHREELET` varchar(16) default NULL,
73  PRIMARY KEY  (`ID`)
74) ENGINE=MyISAM DEFAULT CHARSET=utf8;
75
76--
77-- Dumping data for table `CITSTYLE`
78--
79
80
81/*!40000 ALTER TABLE `CITSTYLE` DISABLE KEYS */;
82LOCK TABLES `CITSTYLE` WRITE;
83UNLOCK TABLES;
84/*!40000 ALTER TABLE `CITSTYLE` ENABLE KEYS */;
85
86--
87-- Table structure for table `POSITIONS`
88--
89
90DROP TABLE IF EXISTS `POSITIONS`;
91CREATE TABLE `POSITIONS` (
92  `ID` int(11) NOT NULL auto_increment,
93  `REFSTYLEID` int(11) default NULL,
94  `POS` int(11) default NULL,
95  `SEPARATORID` int(11) default NULL,
96  `TYPE` varchar(64) default NULL,
97  PRIMARY KEY  (`ID`)
98) ENGINE=MyISAM DEFAULT CHARSET=utf8;
99
100--
101-- Dumping data for table `POSITIONS`
102--
103
104
105/*!40000 ALTER TABLE `POSITIONS` DISABLE KEYS */;
106LOCK TABLES `POSITIONS` WRITE;
107UNLOCK TABLES;
108/*!40000 ALTER TABLE `POSITIONS` ENABLE KEYS */;
109
110--
111-- Table structure for table `REFSTYLE`
112--
113
114DROP TABLE IF EXISTS `REFSTYLE`;
115CREATE TABLE `REFSTYLE` (
116  `ID` int(11) NOT NULL auto_increment,
117  `CITSTYLEID` int(11) default NULL,
118  `PUBTYPE` varchar(10) default NULL,
119  `QSTYLE` varchar(12) default NULL,
120  `XSTYLE` varchar(12) default NULL,
121  `YSTYLE` varchar(12) default NULL,
122  `ZSTYLE` varchar(12) default NULL,
123  `QALTERNATESTYLE` varchar(12) default NULL,
124  `XALTERNATESTYLE` varchar(12) default NULL,
125  `YALTERNATESTYLE` varchar(12) default NULL,
126  `ZALTERNATESTYLE` varchar(12) default NULL,
127  `QALTERNATETEXT` varchar(15) default NULL,
128  `XALTERNATETEXT` varchar(15) default NULL,
129  `YALTERNATETEXT` varchar(15) default NULL,
130  `ZALTERNATETEXT` varchar(15) default NULL,
131  `QABBREVIATEFIRST` tinytext,
132  `XABBREVIATEFIRST` tinytext,
133  `YABBREVIATEFIRST` tinytext,
134  `ZABBREVIATEFIRST` tinytext,
135  `QABBREVIATESUBSEQ` tinytext,
136  `XABBREVIATESUBSEQ` tinytext,
137  `YABBREVIATESUBSEQ` tinytext,
138  `ZABBREVIATESUBSEQ` tinytext,
139  `QABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL,
140  `XABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL,
141  `YABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL,
142  `ZABBREVIATEFIRSTMAXAUTHOR` varchar(5) default NULL,
143  `QABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL,
144  `XABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL,
145  `YABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL,
146  `ZABBREVIATESUBSEQMAXAUTHOR` varchar(5) default NULL,
147  `QABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL,
148  `XABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL,
149  `YABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL,
150  `ZABBREVIATEFIRSTDISPLAYAUTHOR` varchar(5) default NULL,
151  `QABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL,
152  `XABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL,
153  `YABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL,
154  `ZABBREVIATESUBSEQDISPLAYAUTHOR` varchar(5) default NULL,
155  `QAEMPTY` tinytext,
156  `XAEMPTY` tinytext,
157  `YAEMPTY` tinytext,
158  `ZAEMPTY` tinytext,
159  `QASAME` tinytext,
160  `XASAME` tinytext,
161  `YASAME` tinytext,
162  `ZASAME` tinytext,
163  `QPRECEEDING` tinytext,
164  `XPRECEEDING` tinytext,
165  `YPRECEEDING` tinytext,
166  `ZPRECEEDING` tinytext,
167  `QFOLLOWING` tinytext,
168  `XFOLLOWING` tinytext,
169  `YFOLLOWING` tinytext,
170  `ZFOLLOWING` tinytext,
171  `QAUTHORSEPSTWOSEPS` tinytext,
172  `XAUTHORSEPSTWOSEPS` tinytext,
173  `YAUTHORSEPSTWOSEPS` tinytext,
174  `ZAUTHORSEPSTWOSEPS` tinytext,
175  `QAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext,
176  `XAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext,
177  `YAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext,
178  `ZAUTHORSEPSTHREESEPSTHREESEPSEACH` tinytext,
179  `QAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext,
180  `XAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext,
181  `YAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext,
182  `ZAUTHORSEPSTHREESEPSTHREESEPSLAST` tinytext,
183  `QAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(24) default NULL,
184  `XAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(24) default NULL,
185  `YAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(24) default NULL,
186  `ZAUTHORNAMESNAMEFIRSTNAMEORDER` varchar(24) default NULL,
187  `QAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL,
188  `XAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL,
189  `YAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL,
190  `ZAUTHORNAMESNAMEFIRSTINITIALSTYLE` varchar(14) default NULL,
191  `QAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL,
192  `XAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL,
193  `YAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL,
194  `ZAUTHORNAMESNAMEFIRSTUPPERCASE` varchar(8) default NULL,
195  `QAUTHORNAMESNAMEOTHERNAMEORDER` varchar(24) default NULL,
196  `XAUTHORNAMESNAMEOTHERNAMEORDER` varchar(24) default NULL,
197  `YAUTHORNAMESNAMEOTHERNAMEORDER` varchar(24) default NULL,
198  `ZAUTHORNAMESNAMEOTHERNAMEORDER` varchar(24) default NULL,
199  `QAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL,
200  `XAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL,
201  `YAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL,
202  `ZAUTHORNAMESNAMEOTHERINITIALSTYLE` varchar(14) default NULL,
203  `QAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL,
204  `XAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL,
205  `YAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL,
206  `ZAUTHORNAMESNAMEOTHERUPPERCASE` varchar(8) default NULL,
207  `QTEXTTEXTSINGLEPRECEEDING` tinytext,
208  `XTEXTTEXTSINGLEPRECEEDING` tinytext,
209  `YTEXTTEXTSINGLEPRECEEDING` tinytext,
210  `ZTEXTTEXTSINGLEPRECEEDING` tinytext,
211  `QTEXTTEXTSINGLEFOLLOWING` tinytext,
212  `XTEXTTEXTSINGLEFOLLOWING` tinytext,
213  `YTEXTTEXTSINGLEFOLLOWING` tinytext,
214  `ZTEXTTEXTSINGLEFOLLOWING` tinytext,
215  `QTEXTTEXTMULTIPLEPRECEEDING` tinytext,
216  `XTEXTTEXTMULTIPLEPRECEEDING` tinytext,
217  `YTEXTTEXTMULTIPLEPRECEEDING` tinytext,
218  `ZTEXTTEXTMULTIPLEPRECEEDING` tinytext,
219  `QTEXTTEXTMULTIPLEFOLLOWING` tinytext,
220  `XTEXTTEXTMULTIPLEFOLLOWING` tinytext,
221  `YTEXTTEXTMULTIPLEFOLLOWING` tinytext,
222  `ZTEXTTEXTMULTIPLEFOLLOWING` tinytext,
223  `QTEXTEDTEXTSINGLEPRECEEDING` tinytext,
224  `XTEXTEDTEXTSINGLEPRECEEDING` tinytext,
225  `YTEXTEDTEXTSINGLEPRECEEDING` tinytext,
226  `ZTEXTEDTEXTSINGLEPRECEEDING` tinytext,
227  `QTEXTEDTEXTSINGLEFOLLOWING` tinytext,
228  `XTEXTEDTEXTSINGLEFOLLOWING` tinytext,
229  `YTEXTEDTEXTSINGLEFOLLOWING` tinytext,
230  `ZTEXTEDTEXTSINGLEFOLLOWING` tinytext,
231  `QTEXTEDTEXTMULTIPLEPRECEEDING` tinytext,
232  `XTEXTEDTEXTMULTIPLEPRECEEDING` tinytext,
233  `YTEXTEDTEXTMULTIPLEPRECEEDING` tinytext,
234  `ZTEXTEDTEXTMULTIPLEPRECEEDING` tinytext,
235  `QTEXTEDTEXTMULTIPLEFOLLOWING` tinytext,
236  `XTEXTEDTEXTMULTIPLEFOLLOWING` tinytext,
237  `YTEXTEDTEXTMULTIPLEFOLLOWING` tinytext,
238  `ZTEXTEDTEXTMULTIPLEFOLLOWING` tinytext,
239  `PUBDATEPRECEEDING` tinytext,
240  `PUBDATEFOLLOWING` tinytext,
241  `PUBDATEFIRSTSEP` tinytext,
242  `PUBDATESECONDSEP` tinytext,
243  `PUBDATEFORMAT` varchar(3) default NULL,
244  `PUBDATESEQUENCE` varchar(3) default NULL,
245  `PUBDATEMONTHFORMAT` varchar(11) default NULL,
246  `PUBDATEDAYFORMAT` varchar(9) default NULL,
247  `PUBDATEYEARFORMAT` varchar(9) default NULL,
248  `PUBDATEPADLEADINGZERO` varchar(2) default NULL,
249  `PUBDATESTYLE` varchar(12) default NULL,
250  `PUBDATESECPRECEEDING` tinytext,
251  `PUBDATESECFOLLOWING` tinytext,
252  `PUBDATESECFIRSTSEP` tinytext,
253  `PUBDATESECSECONDSEP` tinytext,
254  `PUBDATESECFORMAT` varchar(3) default NULL,
255  `PUBDATESECSEQUENCE` varchar(3) default NULL,
256  `PUBDATESECMONTHFORMAT` varchar(11) default NULL,
257  `PUBDATESECDAYFORMAT` varchar(9) default NULL,
258  `PUBDATESECYEARFORMAT` varchar(9) default NULL,
259  `PUBDATESECPADLEADINGZERO` varchar(2) default NULL,
260  `PUBDATESECSTYLE` varchar(12) default NULL,
261  `PUBDATEALLPRECEEDING` tinytext,
262  `PUBDATEALLFOLLOWING` tinytext,
263  `PUBDATEALLFIRSTSEP` tinytext,
264  `PUBDATEALLSECONDSEP` tinytext,
265  `PUBDATEALLFORMAT` varchar(3) default NULL,
266  `PUBDATEALLSEQUENCE` varchar(3) default NULL,
267  `PUBDATEALLMONTHFORMAT` varchar(11) default NULL,
268  `PUBDATEALLDAYFORMAT` varchar(9) default NULL,
269  `PUBDATEALLYEARFORMAT` varchar(9) default NULL,
270  `PUBDATEALLPADLEADINGZERO` varchar(2) default NULL,
271  `PUBDATEALLSTYLE` varchar(12) default NULL,
272  `TITLEPRECEEDING` tinytext,
273  `TITLEFOLLOWING` tinytext,
274  `TITLECASE` varchar(5) default NULL,
275  `TITLESTYLE` varchar(12) default NULL,
276  `BOOKTITLEPRECEEDING` tinytext,
277  `BOOKTITLEFOLLOWING` tinytext,
278  `BOOKTITLECASE` varchar(5) default NULL,
279  `BOOKTITLESTYLE` varchar(12) default NULL,
280  `SERIESTITLEPRECEEDING` tinytext,
281  `SERIESTITLEFOLLOWING` tinytext,
282  `SERIESTITLECASE` varchar(5) default NULL,
283  `SERIESTITLESTYLE` varchar(12) default NULL,
284  `ALLTITLEPRECEEDING` tinytext,
285  `ALLTITLEFOLLOWING` tinytext,
286  `ALLTITLECASE` varchar(5) default NULL,
287  `ALLTITLESTYLE` varchar(12) default NULL,
288  `JOURNALNAMEPRECEEDING` tinytext,
289  `JOURNALNAMEFOLLOWING` tinytext,
290  `JOURNALNAMECASE` varchar(5) default NULL,
291  `JOURNALNAMEDEFAULTTEXT` varchar(7) default NULL,
292  `JOURNALNAMEALTERNATETEXT` varchar(8) default NULL,
293  `JOURNALNAMEPUNCTUATION` varchar(11) default NULL,
294  `JOURNALNAMESTYLE` varchar(12) default NULL,
295  `VOLUMEPRECEEDING` tinytext,
296  `VOLUMEFOLLOWING` tinytext,
297  `VOLUMESTYLE` varchar(12) default NULL,
298  `ISSUEPRECEEDING` tinytext,
299  `ISSUEFOLLOWING` tinytext,
300  `ISSUESTYLE` varchar(12) default NULL,
301  `PAGESSTYLE` varchar(255) default NULL,
302  `PAGESSINGLEPAGEPRECEEDING` tinytext,
303  `PAGESSINGLEPAGEFOLLOWING` tinytext,
304  `PAGESPAGERANGEPRECEEDING` tinytext,
305  `PAGESPAGERANGEFOLLOWING` tinytext,
306  `PAGESPAGERANGETYPE` varchar(9) default NULL,
307  `PUBLISHERPRECEEDING` tinytext,
308  `PUBLISHERFOLLOWING` tinytext,
309  `PUBLISHERSTYLE` varchar(12) default NULL,
310  `PUBPLACEPRECEEDING` tinytext,
311  `PUBPLACEFOLLOWING` tinytext,
312  `PUBPLACESTYLE` varchar(12) default NULL,
313  `SERIALPRECEEDING` tinytext,
314  `SERIALFOLLOWING` tinytext,
315  `SERIALSTYLE` varchar(12) default NULL,
316  `ADDRESSPRECEEDING` tinytext,
317  `ADDRESSFOLLOWING` tinytext,
318  `ADDRESSSTYLE` varchar(12) default NULL,
319  `USERDEF1PRECEEDING` tinytext,
320  `USERDEF1FOLLOWING` tinytext,
321  `USERDEF1STYLE` varchar(12) default NULL,
322  `USERDEF2PRECEEDING` tinytext,
323  `USERDEF2FOLLOWING` tinytext,
324  `USERDEF2STYLE` varchar(12) default NULL,
325  `USERDEF3PRECEEDING` tinytext,
326  `USERDEF3FOLLOWING` tinytext,
327  `USERDEF3STYLE` varchar(12) default NULL,
328  `USERDEF4PRECEEDING` tinytext,
329  `USERDEF4FOLLOWING` tinytext,
330  `USERDEF4STYLE` varchar(12) default NULL,
331  `USERDEF5PRECEEDING` tinytext,
332  `USERDEF5FOLLOWING` tinytext,
333  `USERDEF5STYLE` varchar(12) default NULL,
334  `NOTESPRECEEDING` tinytext,
335  `NOTESFOLLOWING` tinytext,
336  `NOTESSTYLE` varchar(12) default NULL,
337  `ABSTRACTPRECEEDING` tinytext,
338  `ABSTRACTFOLLOWING` tinytext,
339  `ABSTRACTSTYLE` varchar(12) default NULL,
340  `TYPEOFWORKPRECEEDING` tinytext,
341  `TYPEOFWORKFOLLOWING` tinytext,
342  `TYPEOFWORKSTYLE` varchar(12) default NULL,
343  `AREAPRECEEDING` tinytext,
344  `AREAFOLLOWING` tinytext,
345  `AREASTYLE` varchar(12) default NULL,
346  `OSTYPEPRECEEDING` tinytext,
347  `OSTYPEFOLLOWING` tinytext,
348  `OSTYPESTYLE` varchar(12) default NULL,
349  `DEGREEPRECEEDING` tinytext,
350  `DEGREEFOLLOWING` tinytext,
351  `DEGREESTYLE` varchar(12) default NULL,
352  `RUNNINGTIMEPRECEEDING` tinytext,
353  `RUNNINGTIMEFOLLOWING` tinytext,
354  `RUNNINGTIMESTYLE` varchar(12) default NULL,
355  `CLASSCODEINTLPRECEEDING` tinytext,
356  `CLASSCODEINTLFOLLOWING` tinytext,
357  `CLASSCODEINTLSTYLE` varchar(12) default NULL,
358  `CLASSCODEUSPRECEEDING` tinytext,
359  `CLASSCODEUSFOLLOWING` tinytext,
360  `CLASSCODEUSSTYLE` varchar(12) default NULL,
361  `SENDEREMAILPRECEEDING` tinytext,
362  `SENDEREMAILFOLLOWING` tinytext,
363  `SENDEREMAILSTYLE` varchar(12) default NULL,
364  `RECIPIENTEMAILPRECEEDING` tinytext,
365  `RECIPIENTEMAILFOLLOWING` tinytext,
366  `RECIPIENTEMAILSTYLE` varchar(12) default NULL,
367  `MEDIATYPEPRECEEDING` tinytext,
368  `MEDIATYPEFOLLOWING` tinytext,
369  `MEDIATYPESTYLE` varchar(12) default NULL,
370  `NUMVOLUMESPRECEEDING` tinytext,
371  `NUMVOLUMESFOLLOWING` tinytext,
372  `NUMVOLUMESSTYLE` varchar(12) default NULL,
373  `EDITIONPRECEEDING` tinytext,
374  `EDITIONFOLLOWING` tinytext,
375  `EDITIONSTYLE` varchar(12) default NULL,
376  `COMPUTERPRECEEDING` tinytext,
377  `COMPUTERFOLLOWING` tinytext,
378  `COMPUTERSTYLE` varchar(12) default NULL,
379  `CONFERENCELOCATIONPRECEEDING` tinytext,
380  `CONFERENCELOCATIONFOLLOWING` tinytext,
381  `CONFERENCELOCATIONSTYLE` varchar(12) default NULL,
382  `REGISTRYNUMPRECEEDING` tinytext,
383  `REGISTRYNUMFOLLOWING` tinytext,
384  `REGISTRYNUMSTYLE` varchar(12) default NULL,
385  `CLASSIFICATIONPRECEEDING` tinytext,
386  `CLASSIFICATIONFOLLOWING` tinytext,
387  `CLASSIFICATIONSTYLE` varchar(12) default NULL,
388  `SECTIONPRECEEDING` tinytext,
389  `SECTIONFOLLOWING` tinytext,
390  `SECTIONSTYLE` varchar(12) default NULL,
391  `PAMPHLETNUMPRECEEDING` tinytext,
392  `PAMPHLETNUMFOLLOWING` tinytext,
393  `PAMPHLETNUMSTYLE` varchar(12) default NULL,
394  `CHAPTERNUMPRECEEDING` tinytext,
395  `CHAPTERNUMFOLLOWING` tinytext,
396  `CHAPTERNUMSTYLE` varchar(12) default NULL,
397  `LINK0PRECEEDING` tinytext,
398  `LINK0FOLLOWING` tinytext,
399  `LINK0STYLE` varchar(12) default NULL,
400  `LINK1PRECEEDING` tinytext,
401  `LINK1FOLLOWING` tinytext,
402  `LINK1STYLE` varchar(12) default NULL,
403  `LINK2PRECEEDING` tinytext,
404  `LINK2FOLLOWING` tinytext,
405  `LINK2STYLE` varchar(12) default NULL,
406  `LINK3PRECEEDING` tinytext,
407  `LINK3FOLLOWING` tinytext,
408  `LINK3STYLE` varchar(12) default NULL,
409  `LINK4PRECEEDING` tinytext,
410  `LINK4FOLLOWING` tinytext,
411  `LINK4STYLE` varchar(12) default NULL,
412  `PAGESPRECEEDING` tinytext,
413  `PAGESFOLLOWING` tinytext,
414  `REFNUMBERPRECEEDING` tinytext,
415  `REFNUMBERFOLLOWING` tinytext,
416  `REFNUMBERSTYLE` varchar(12) default NULL,
417  `CITEKEYPRECEEDING` tinytext,
418  `CITEKEYFOLLOWING` tinytext,
419  `CITEKEYSTYLE` varchar(12) default NULL,
420  `REFNUMBERUSE` varchar(3) default NULL,
421  `PAGESPAGERANGERANGESEPARATOR` varchar(16) default NULL,
422  `QABBREVIATEFIRSTSTYLE` varchar(12) default NULL,
423  `QABBREVIATESUBSEQSTYLE` varchar(12) default NULL,
424  `PAGESPAGERANGESTYLE` varchar(10) default NULL,
425  `XABBREVIATEFIRSTSTYLE` varchar(12) default NULL,
426  `YABBREVIATEFIRSTSTYLE` varchar(12) default NULL,
427  `ZABBREVIATEFIRSTSTYLE` varchar(12) default NULL,
428  `XABBREVIATESUBSEQSTYLE` varchar(12) default NULL,
429  `YABBREVIATESUBSEQSTYLE` varchar(12) default NULL,
430  `ZABBREVIATESUBSEQSTYLE` varchar(12) default NULL,
431  PRIMARY KEY  (`ID`)
432) ENGINE=MyISAM DEFAULT CHARSET=utf8;
433
434--
435-- Dumping data for table `REFSTYLE`
436--
437
438
439/*!40000 ALTER TABLE `REFSTYLE` DISABLE KEYS */;
440LOCK TABLES `REFSTYLE` WRITE;
441UNLOCK TABLES;
442/*!40000 ALTER TABLE `REFSTYLE` ENABLE KEYS */;
443
444--
445-- Table structure for table `SEPARATORS`
446--
447
448DROP TABLE IF EXISTS `SEPARATORS`;
449CREATE TABLE `SEPARATORS` (
450  `ID` int(11) NOT NULL auto_increment,
451  `STYLEID` int(11) default NULL,
452  `VALUE` tinytext default NULL,
453  PRIMARY KEY  (`ID`)
454) ENGINE=MyISAM DEFAULT CHARSET=utf8;
455
456--
457-- Dumping data for table `SEPARATORS`
458--
459
460
461/*!40000 ALTER TABLE `SEPARATORS` DISABLE KEYS */;
462LOCK TABLES `SEPARATORS` WRITE;
463UNLOCK TABLES;
464/*!40000 ALTER TABLE `SEPARATORS` ENABLE KEYS */;
465
466--
467-- Table structure for table `t_journal_words`
468--
469
470DROP TABLE IF EXISTS `t_journal_words`;
471CREATE TABLE `t_journal_words` (
472  `name` varchar(255) NOT NULL default '',
473  PRIMARY KEY  (`name`)
474) ENGINE=MyISAM DEFAULT CHARSET=utf8;
475
476--
477-- Dumping data for table `t_journal_words`
478--
479
480
481/*!40000 ALTER TABLE `t_journal_words` DISABLE KEYS */;
482LOCK TABLES `t_journal_words` WRITE;
483INSERT 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');
484UNLOCK TABLES;
485/*!40000 ALTER TABLE `t_journal_words` ENABLE KEYS */;
486
487--
488-- Table structure for table `t_meta`
489--
490
491DROP TABLE IF EXISTS `t_meta`;
492CREATE TABLE `t_meta` (
493  `meta_app` varchar(20) default NULL,
494  `meta_type` varchar(20) default NULL,
495  `meta_version` varchar(20) default NULL,
496  `meta_dbversion` smallint(6) default NULL,
497  `meta_create_date` datetime default NULL,
498  `meta_modify_date` datetime default NULL
499) ENGINE=MyISAM DEFAULT CHARSET=utf8;
500
501--
502-- Dumping data for table `t_meta`
503--
504
505
506/*!40000 ALTER TABLE `t_meta` DISABLE KEYS */;
507LOCK TABLES `t_meta` WRITE;
508INSERT INTO `t_meta` VALUES ('<package>','refdb','<version>',3,UTC_TIMESTAMP,UTC_TIMESTAMP);
509UNLOCK TABLES;
510/*!40000 ALTER TABLE `t_meta` ENABLE KEYS */;
511
512/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
513/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
514/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
515/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
516/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
517/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
518
519