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