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