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