<?php //0046a
if(!extension_loaded('ionCube Loader')){$__oc=strtolower(substr(php_uname(),0,3));$__ln='ioncube_loader_'.$__oc.'_'.substr(phpversion(),0,3).(($__oc=='win')?'.dll':'.so');if(function_exists('dl')){@dl($__ln);}if(function_exists('_il_exec')){return _il_exec();}$__ln='/ioncube/'.$__ln;$__oid=$__id=realpath(ini_get('extension_dir'));$__here=dirname(__FILE__);if(strlen($__id)>1&&$__id[1]==':'){$__id=str_replace('\\','/',substr($__id,2));$__here=str_replace('\\','/',substr($__here,2));}$__rd=str_repeat('/..',substr_count($__id,'/')).$__here.'/';$__i=strlen($__rd);while($__i--){if($__rd[$__i]=='/'){$__lp=substr($__rd,0,$__i).$__ln;if(file_exists($__oid.$__lp)){$__ln=$__lp;break;}}}if(function_exists('dl')){@dl($__ln);}}else{die('The file '.__FILE__." is corrupted.\n");}if(function_exists('_il_exec')){return _il_exec();}echo('Site error: the file <b>'.__FILE__.'</b> requires the ionCube PHP Loader '.basename($__ln).' to be installed by the website operator. If you are the website operator please use the <a href="http://www.ioncube.com/lw/">ionCube Loader Wizard</a> to assist with installation.');exit(199);
?>
HR+cPsyqXzJVg7iRilOIzxVhgYFxLLbOtkXQjPoiTD2piaHgGAMr+UdIt+/gYASuXxTYb894zMXR
zLcQrbMNx4cHimcEqsqXGOb6/+0od1Y5VTfhaK65vt8zyHfBRfjyDj8twHxdnmjmZEXxrnp27mbG
ihmZlQDbP8jUQknsVH11LClGqHjoDs7TetMb1Y89nIGAPQQRXnvzVDXcwib/u9MlA+xueuq9P6o4
p7zZ00H26Rug45FRjeo0eDwdT4ozaO/iN8avgyQ3aGPeCGd7KsL0oqeGYTKckluVLv2mbEBVaovo
+d6jki/YcMyvAemPqBEg6r4hScRMG1ewUXr4KaoulDw+GrewCHy3MQXNDm1OxMXBqU74SXPgNiWO
hqB4EK/wK8RLx+b/oTlWtWNKRRidnfzcQgVmT7ccTPjaKOcUSdVfMlGJ9c2HpzbO2o2fyTJIHdGl
0cJkDKF52UYg6MJaimTcDZPgRxKPnDQ/j6M9I6/R2H1tsLIYbTdfbkOt2YBETAAxhhTXb2AJV3zJ
hnHz6/qizrZUTCtf6FWjfXwClZVaGaYF3LtYJ52DEf6G7ofzvsHL+BusxkugfHnZat9Ye/eTssQ/
1Ke4vLYd3Ny0LXcGKj8pvfCF9/T+YsV/kY1OJZ+xQmomlOT6Mb+nBfCGI57sXmh4WgOCFXFfgmCK
jGK5SS1fnIXf/e8YzGT+lGvG4C27rlqfygxXphgIKrxNDSfZIdQpaVhRPss8Xo+Hlyds4JGsuIzC
3o5xowDx6uwWXsgIw+ZvH4S6hTnutOZKdPLe1BgJbD8YPjd9XVWo08gUyz0mSCN8D6eD+h21rC39
aA8Vl9pQjjLwKYhc6vwKc1QhUQIF9ac7id2CdwdcmARv/ddQFcpqVsm24M9lL0iZ0TGg/P+qGWQL
C3OnsQul8M+h7E0J/Y0xnfdJYErD9NNQZ0xTtifWfWqw6wPfns+4E6gaooYQHdaUqtYz80zgFjnO
zJkgIUoZ1F/aeKY0E4Nl4wLGmfSFuf1LOJzZ4BL+7rFV7//cSxDf28kI2D8MGwC++nD8KKpBIawc
r7DIkTSLdRq+TYh4ADLlBMIaJB0wVdbGGvBZYxEKSLpmKkO/VBa2M5YDPgr/0DltlDIAJBsATg0s
WUsrYoi0FQfRP0O3GX+ZQoDBgw4bNFX7vYp2dCKUbys3lBBTUeK2TB2Qnf6DLn2YdWex4sbdyyhj
v7w8kvUFQl9uB08EM6tUY3XbA0PTq53WVr7c0rJ3HFEL3S+EHyBZhg+31wNc/HJTwcF91YgfSB/y
MnyGcgVr5bQfk9xVC1LwVgu0CxpjOKWAIiSH6GZgRG755/VVoqwNfXkLf5zTZUQjrSo/pPUHvG0x
4nas2+Lv8j8/6twYhg6eGDS6hCBW1L9LPH6/7mqYrhdn9OmldHRjseEu2v+K0f0cK22q7Q1nB+9e
V+U0hMkffSQmHYUnNsgD1bC4kUwe5IRsT0jZxJLKcM+ciUt82laH9O1otr1g066l1vw3YpHTzCiF
W5eBRrJoNiY0CIMl/FwNs04/XsA2qEOu+jR4A+RbxrVu75IAv8XlGl8BOZEq47nzWwYs1qTDNoP5
tQKommAToEq0SjH4MyggvJxfdNFkwDNX+UzHNgqGx55MuyG8ZxkYemPO+b65nM6vw7m1OkWKGx+g
DYPJtoGNKgENf3aUHIkA1yShwNKp0yKDCWKqlY24tGfkoMO4YdpgBr2faU40uYZKWTfl5wXDivmT
+PIgzjfOPmo9v5ZuMhyuuqMsXVlLHgfJr69fPp83s2XYPiTGrJOZA5Y+ZPlDvBLLA8RXKJ8a94F0
jFTQ18BZhzejPpDqdUNzb5bxAIXmNwL+eAkgBpsAHHPuPhmOCvb7tRqU11LijxxkOyVlhlO5fcOK
g1YYD75n45TuMz53Gl+P092bx+5qGh6HB+LxD7z2Vd0Eil/LZ2Ho28krRvj3qnRRBvJ6YJ9Zyi02
1x011SmkuMmBPKoQjT+ofXftVVLk5xbJKPpkbvK/XDWN0XnG0nChPQ10WHt944jTi6WjBz8BCZR0
txDT0QajSi163qwYQqsTcQlkRb6Ow3ilGGPjKdpxxfSWjr8TNPCpTEnKZiqMS6rpJ6Y7oY6AIk2L
7X58zUT49sy3naYAIA1iCQiC+b1BgvkqhDJcBNQY6xDNAsgzrcWrZKtnME/5gSQR9+D2JcNLoZtP
birQPyy4jLKAvy6vmt/awSb17jeu1Ge4XfsJ52n1XNSW2f9K0TwVvKojLFE0N0jJ6wvSxlRi95wR
ZrISuSFIA0VhHeTC+ec/ZZltE2/Jddhjg/o08Dsvw17A1IfzJHRL7pURxL3lRkOtwtUPACGbYv72
bZhI02esJUd9O7uKuzFzERe/PAX1fvMmytyrp4u6HpjpAkhrHahcINDFAktV1+T7Iw95xuTRIiyD
O3fXqu5pUEFLzwlfuHkXyYUIIkAXioRDmZsZt6lu520P3C1ZZLuL3xLLCH9nq8RPE/X0fnqky+4I
e9Uw4rQVn3IQ09wgCeBZz1c69HYD2qLXfaSw5bBMrz11WoLtB+UHkgg67jodKjz+CwtLLJ72ZQ9D
Zkndxn1nmCzzC6+SibC6wPjglY5rgyQ3k2r0s/pp8ZlLlTcVO+EJJ0E9D9Vr34bvRSNQO6KTUR/H
ogfEBKMz8qUyw7MDBYBo7fFs/0gqZoQlaADaQgIghWYUwALtql+BrSH8Z+DOG5XGT4d52CojNe02
c+7sQI9rLCSAOzlKRvEoNZZIaTpXduFa47VNIe0WD5lzyOi2jDFXw6pD+iIKkCzc5fP2l1O4VJqw
N9mV4BNMvMulJIWANCDrzFHGsBHxkt7c17sxwKq44qIG5bXxCBKXh/UexRDeibmQ8sL5nf2Z7mE/
2bap2zNmlkvGuR1qmDxozOLHuMvFMzAq1IW4njXsUkcxZ3aVmExCeRuLQhRQTsInkYdnCNTAECgw
cBFSKikxnjBGOtSIU78puMQDCPY9Bsmvynr4Z+9qszSdPdJcijin/UdnDS3Zw0jZM4FQUCxId+wk
Vw4eb0177kMOQqkMNZ0IRyWrbNScMzsmFjHwgJTIxd6STjqSTi4zEgn0cL7PGUKHtBddvKSxVwK8
8bp2ybiIXA72QGEI0lfpPxeQrnQwdDnj2e9KYcIgcq3yKOUm4Qh+a0opvgp3zaevW6kTTdK9IAMc
ivbaPVOiXoFVFTsDTG/UuPfIVlXyBd1DXweWRgCp495dbxBrx8pd49CedYHVEdf8Qwa18uYIjMeM
dyhd/NBsm3RWrrCsjlIBlV/+bmkO823lur+V06ApX09LsTv/K35Tb1SCyhCPtS5R2YpEXPRMdFx9
tBGas1iEafMgEPu/QIVSVImBux/iGoGnZbWQyt0Ox1d/SX9MpHc5fqk4MnFqh7tQCA2kpFs9+MG2
hXb+/tESTb/q3B+xqQczHInZ3KcphyLVN6tDczFeoRkTKzv5hjmMFYXQ99XSKsY9oJezUvlqQRAy
ZD2CxR1xdDTb8CUJtLqgOPmA8Bxa7gxUBSCADnzQcGykMGKcMgd6o5UAjqZxKZvJmbh0JMIJcFnu
FUr8k2vLrsg2bVHfYZEOK28YuJ18FThAshCSYBOIc61/+hO491h6blcKfnu+tK61y6rRfCX65vGe
WHK3EGdkjkE7lvCabtoCr8p78nVuW2IXt9dQpiNyydAcnEr4ma8bZii7MaIz7JWIMeDjgrK9EZYf
TeGObqLnRgbq/Dw1D6gKOrr2CXKN2sF1CrdJykYCDnaKTdezIuzPE1znkZbcq3DMvtVs/f+P/GQy
8rSNT7yfrt/nUA+17/tqAYEYWyk48EKF1F9Z8Gfta1ZTOOERKmVmWupz/lhyPQuMMsalfe1smHbw
EbUP2oHZ9SuwBPqlCGSZ9F5bzimR9vR4TQJmL6u6eCHIFt7MCANdrdl34fBMBe/cYag2C+XhV5K2
w42NvYwIgg13ol507uQgNDENUCNvrdRK3zQawEK9pEit8pjOlDw7G/sIon2aZhAIeFyloubUKSLs
2oVXB4noV2TnZ+Evn2zv0o+6D5OjHB3AP84IoXj9quvxihOrKOkN1/IIB9WFlpcKgmnG61RLSuO2
ULwkIeSntcPbDUgE42MWrpc9auklZ6fyLhwnxdGOW3A4s+9q0tIq3mvdO4BMfIUmyrocxmPQ5bib
gfZsnnYPS+pNMvt7SpKNghnUaQjGOj0/IwLeFU+6jUtx7KvVy9UOzreYO2O396W5yozUNNAPz4Ep
YOh3cOAxd2rQM4wpJui6vEPhX9d15CK9N6NiwZBTaWyYlw7PdLSm3BgkWI6D5NfgP8xzcipxYsCq
mrBh3VHfWnvDqQoAT3JyR+svwaF0RCxYwfCvSeDoZv2hPSxBcexdS2yJqYCcdAdhP3/mJtL/obRF
wMDhUL0tnupAQCEpe8jAeD+LH78KN44EPQk8iL8e/8ecnNWUAXUSh+yBgOdM6dLZDZWbh9uRNhnE
7rPcHhB1+mqARxIzj4VJT2qz49h8xvQqV20L10khs/UG8pPM9889CgWKLdyK1QkCoNhREsrF3RZu
YKeV4HfN+uZ+rmJamuodWX4lcD+snbczHq5DnpAC4oTQTZCaGGUWzptzb5dpTjCU/9wDbmj2dfSp
og3d8Ey2ACtwvBwxVcxRtnfckfKFEkosEYrEN6e/fdBskf/MisbuLi2Bd2HLKrjTWNO3zMZxw1KF
FXsR1lAfDB53anxO5c3EKUC3NG/DuzmCnK5yoDiJlDP15e5IvZOh0tvpIhkWnsksoMmisZIde1nt
y7ev1NkCc0hd/mbPHHf8HIrZKKzYXZsmkwRDKXnOlI97+ddLPNc4dPbKmQO4n+OgrQSl+pHP0cIP
wwN5AVLl6D3u1tLIATbXM8D0Akgp8lXZeW6ylb7EJu8q5CnV4SgLBm55SoGgG3Ny32d9FzyPG3l2
rhjXZUfMFKOiPtRDaRCF3Kid6lrgXMunxnP/Zu9jj0nUKSFI8/qL9i00ortTzsvACLBLb6VxmClx
SGLRbKaejsE0qL6MqWLTcr3na1aLYTisX3w+5r72ymZWJ6xldbfc/MyeGtLtbSyDF+lTtDYbJWyt
cqrKtP0oqLK0eSp37/PDimS03kaXbwjmvySBYK0/6kitz2G6MqYTPEIoZBArzUO9kgzuBl+g9Zqa
NYYJZs/7dNdAXR7zIuJcBY8ezAggtVr0j0HKpDhFEGjG8kcSyj1oQjEHba/784oBjr/6fk+Sw4yO
yIR4Up7khaXVE94UxkUpywKXMc8ltbUXd+jCOi/s/bODpUx7Edmk4veqnu0rx8OKGqNWbULy+rQO
QRT7/kVvKY/VljSoxDpcvRhHgEJq0niOcUBYdOJ9xqGONdnsEZC21u0Aj74TA/CGzrFfAjOeGLzk
pslqqPs7OsYOQamCn6OHw7faUTRaN3VbKZE6P06TCisvybAZw0SnfmWTeVT7bh2kVxNdvZlsZof9
wmwCgLgIk1f8hXOutvdNuT1mEUGdYnKb/zXOfnbPNPSoueCMgSJ3WRBEWkaVFkcTYk5QrUmob5by
Cj28QbmZyi3chy//78VVC4vFDt51CjBcVi1OKFItRayZaaCDmmBvfrMV4cfWIYRd9YFwWMfg1XjM
0m1r9VCpAhtNNDpBbnDLyjRG91q1fiKDe2kBuvWf2meqtz0bjzwIdBWwauZHzOVu1KB2Jsbdd8hD
aBCV2g7FnSGnZSrm6Mc0DVKVISSLpLSlmsLdikzDoq5o2ssNqfPCDlLXisA8z1nRy4O4EcwtT5xZ
sx4CXqAe8x3JC+Rj+Qd0LI/RoXpL0Y0Zk6JrU7a4phB77Ak2ncMYaYTYY6anT/GN/OEOVHvoemx1
GiaRuo1KymTi/8/8zQ7Xhs2soHKWZ6zTFTcuZUNDJApgl6++Y+DvQptviH75ArzcwC10QJDHgp/c
pmVeSgGWa53ql0VxhQBV2lPNotFG1doGT1lgtrRkIyCXfLqKGxR+chbbcRTro5SDaILYVcW2dgyL
ZAXmt5z/6DlM9HnyN6QJMA1pMBaOSCDzX9YZobTEXsZCkFwuOKAp5wStAoZLSQO6w9tgVL7CTp+v
8V8ZvRnmvwAUHy+D+eVipzSRoQSXXjN4yB0Mrmnm4CbiKLwU+LZda6Nol9/fEkzkITBxhiUT1DUw
kubI1AfHR/4ZcloflNErr9XjA6Ci1oIiy7JqHbHxkwTFD0ezy6c7AXo91zi7s6a0e4FkKln0ww3n
gJI0xT3JppUGN3jM50L5gfnX3qj8vu17XfhKT/XSoCxeqnbWm42atyuvmL6pyLt1tWWO7ZYdv/E6
XpuqZjjfXNb5uvhwAwVOGv2htB9ZzS1CWTczAg2U/8eg9stV1FxRraiI8m5YvUFxoGVs86LZufw/
CNNOq64hSodEeC9I62Wf9qvyLWJW1KueUqBVEPybYRACNTNC+yvHPM1YELRXAmXVZkv0j6nxLucO
d49M094A6xLUfnFVLKgLp+haA05AGGmqGG2SvjvBtOfqoGsY+XEeUHNipL77yyMoDKeo9REeApjV
wbLV54r6FIdM+JOOwrSGrIQKkEuJCcgUYjDEYmSJgaD/v/gfYLVkji25Iejas2l5dWswPPI2PnFF
RGLvJzgWf6UBWOY60rDohicJVMV/FufldV4sEqPjwR/m2x+UR/UYmdF+ZY2HVylRBUJAvL54UchT
McBl8BOVZ5Z5OgA5IcluWgOZ7ckhOXibT1p+mCxQGRfNTHS5EhncUHFZN2zNSPlECWHUMWVeKEGG
Tlu5wKn59LMHwknNKnzMa+1KJl9fQ5UioMtMEfLJ8Jx7VHhG9cXXMF/1pEG9exYvLnYNifDNys9V
Bxu2JPC2OR3XDtI6b4dWmONbEXNygoCmxc8UJZbaNWfkSUTFP+500YzOj6HsNNLwT30r2v2HWWMJ
YkE3hwSp32oj/WJRD+7ey6X2yM5HISRth8lXjf/26ode+EsZHPgAiu6AWkOUObHlJd6oyglHp35l
hjen3Li80Tqthqcr8YUXiu/cBAOef+UakUkh77w7s/9bYz9+JXA0x7Rb/DWk7mre88yR1fNsv1z7
/bfbDhge6K9aadlMKuNJqLgC9oe/mkbzl7m2DZN360p3UiVPOkswUjr7SwNA26RtrPr7MiBiqI4R
esDdIjs+L/UvHZwOCQ2FZ0DE0+3T4NQzf+S6ppTDEtcPvwXUDUG3KkOJK9A3pPrLweKarda2u7c9
WxXE9TgTS+50fB3B0b+J7l/pQgvMfZgAuKF3gqrHwjlW8aiNUMLyXKw2tdpJqizuNftK90CvtX68
5XYvLFwCV/ufCMGHqx+EsJEi3eFyGr0U8U93zPOFxBbPUo9LjbEwlZUWUhcbxjfP5qCvX7Bz8p9w
WA66m1sYMuZwp2mfCb9wNd7Bofa3DDQGN2XU2VST0gebwf1PMhTM+Kf9RDqT+f+AHKGTsDudM/Rp
UTgr3oXgJ69/5eyT6KWuwKLRxe6FAjptbilsyTwYn2YwadXYR9uxSTx0q5IFjLiE4loA8eqKWY2g
CGJYTJ8sH60a8joW8V2abGkk12ZWCwjBiobY340tDR+J/Q66ttkv1SkU/fyk3F0+IFp2QRHGrrXm
7evJFyH2t3t1ptjVwPHyDWA/7VcCbhxmmOwLq4ovzhg6BK00Fm7QdMoQaXR2YGuPFIed+V7GQaE4
AByTuHqHP3BeiJ/a07IvbBPbD2ALIAiBnXUtYYu10/I9Aos0TiF1sF9tbULX1bx4lRSbZ0STt2Gf
jL9brTZgLoGFpFLXFomuRkNovtm/ZgCplxIEFgaKqOb+Fpyx/8Go8rAEX1jf2cQnyKE3EaVLXVs1
z1adBWAcIDgdJhqboJXq/SV85zpojim5+OfDjg3OdnvW6VNERdVk+Rx2JEzFt9DGsVMCOyf7nsFm
Er60018JXjlityGj5qb6irbBs1nZWRztdJl/5A2QuPhyqrcNbZIgDIhwdDaQ1aVPE1FJQ9/CM1Ls
eDsvAX9H8WhDZXO4vAbN73tRIaG5+NLkZkTgXOKByeTPNLH95eFQ4OQXsJFCyJJczBX0HOcio6Af
7TQ0ATLV+9zuYkcrg0kNkHr1Z4gT/w5W2ULmWFPDMzU1USn5HozYA63ut+9+hw6TyfCt1/qwDUj1
fqsK73UbJmYVnQ6afixatp/hYW6tYsWz37Me0tEaSlVrnyZokSmcEUxJ65yHuFUsTVPZ/kYY2nML
oqFAeGDYo1y9XBCSHCYpITpmtRNO9GxufLN35iYtA7LOuw14ffchRQ5hXj0J78UssmkNFYIPGBQf
MAVixDlLHGTHjsgy4An1Zgh8Gj6+G8+OddVAp04Lj06lwZIx1Gu69FtkiWHSTd0vcRB4iTKWG0+T
9iQQYWkMuCCbtbSQ6v/5OnhSviokjJ88vjQGZmEVZq0h++LbyTz1dCjtLsiZ1wTH1r27S+pucAb4
BKJrGYZTYH9kHMKr6+aYrNaWHFf3gDNEo9lcdNhAEc8Tnp5OlhXznGvIRSU0Q5wuQfvLX+IvkvX9
9uzOpdMupMPxo80BLqY21F8/ycb/1yUGP7OEVYdWqntzA+RzZQw8x1GCm0fWn+OKfra5PjUrHCuq
6tphlUJn4hmuBDOqLDGuCBGNA5eC71RMe6emxyGS9lBZLQUfDjpFrke3QwP4nFkLs0BX8NV/MEp4
GsqMUUl0uylUTIn3hu3/gzEgSET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ojs3501`
--


-- --------------------------------------------------------

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `announcement_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `assoc_type` smallint(6) DEFAULT NULL,
  `assoc_id` bigint(20) DEFAULT NULL,
  `type_id` bigint(20) DEFAULT NULL,
  `date_expire` date DEFAULT NULL,
  `date_posted` datetime NOT NULL,
  PRIMARY KEY (`announcement_id`),
  KEY `announcements_type_id` (`type_id`),
  KEY `announcements_assoc` (`assoc_type`,`assoc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Announcements are messages that can be presented to users e.g. on the homepage.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `announcement_settings`
--

CREATE TABLE `announcement_settings` (
  `announcement_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `announcement_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  PRIMARY KEY (`announcement_setting_id`),
  UNIQUE KEY `announcement_settings_unique` (`announcement_id`,`locale`,`setting_name`),
  KEY `announcement_settings_announcement_id` (`announcement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about announcements, including localized properties like names and contents.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `announcement_types`
--

CREATE TABLE `announcement_types` (
  `type_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `context_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`type_id`),
  KEY `announcement_types_context_id` (`context_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Announcement types allow for announcements to optionally be categorized.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `announcement_type_settings`
--

CREATE TABLE `announcement_type_settings` (
  `announcement_type_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  `setting_type` varchar(6) NOT NULL,
  PRIMARY KEY (`announcement_type_setting_id`),
  UNIQUE KEY `announcement_type_settings_unique` (`type_id`,`locale`,`setting_name`),
  KEY `announcement_type_settings_type_id` (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about announcement types, including localized properties like their names.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `authors`
--

CREATE TABLE `authors` (
  `author_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(90) NOT NULL,
  `include_in_browse` smallint(6) NOT NULL DEFAULT '1',
  `publication_id` bigint(20) NOT NULL,
  `seq` double NOT NULL DEFAULT '0',
  `user_group_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`author_id`),
  KEY `authors_user_group_id` (`user_group_id`),
  KEY `authors_publication_id` (`publication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The authors of a publication.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `author_affiliations`
--

CREATE TABLE `author_affiliations` (
  `author_affiliation_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `author_id` bigint(20) NOT NULL,
  `ror` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`author_affiliation_id`),
  KEY `author_affiliations_ror` (`ror`),
  KEY `author_affiliations_author_id_foreign` (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Author affiliations' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `author_affiliation_settings`
--

CREATE TABLE `author_affiliation_settings` (
  `author_affiliation_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `author_affiliation_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  PRIMARY KEY (`author_affiliation_setting_id`),
  UNIQUE KEY `author_affiliation_settings_unique` (`author_affiliation_id`,`locale`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about author affiliations' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `author_settings`
--

CREATE TABLE `author_settings` (
  `author_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `author_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  PRIMARY KEY (`author_setting_id`),
  UNIQUE KEY `author_settings_unique` (`author_id`,`locale`,`setting_name`),
  KEY `author_settings_author_id` (`author_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about authors, including localized properties such as their name and affiliation.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `context_id` bigint(20) NOT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `seq` bigint(20) DEFAULT NULL,
  `path` varchar(255) NOT NULL,
  `image` text,
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `category_path` (`context_id`,`path`),
  KEY `category_context_id` (`context_id`),
  KEY `category_context_parent_id` (`context_id`,`parent_id`),
  KEY `category_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Categories permit the organization of submissions into a heirarchical structure.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `category_settings`
--

CREATE TABLE `category_settings` (
  `category_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  PRIMARY KEY (`category_setting_id`),
  UNIQUE KEY `category_settings_unique` (`category_id`,`locale`,`setting_name`),
  KEY `category_settings_category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about categories, including localized properties such as names.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `citations`
--

CREATE TABLE `citations` (
  `citation_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `publication_id` bigint(20) NOT NULL,
  `raw_citation` text NOT NULL,
  `seq` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`citation_id`),
  UNIQUE KEY `citations_publication_seq` (`publication_id`,`seq`),
  KEY `citations_publication` (`publication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A citation made by an associated publication.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `citation_settings`
--

CREATE TABLE `citation_settings` (
  `citation_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `citation_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  `setting_type` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`citation_setting_id`),
  UNIQUE KEY `citation_settings_unique` (`citation_id`,`locale`,`setting_name`),
  KEY `citation_settings_citation_id` (`citation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Additional data about citations, including localized content.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `completed_payments`
--

CREATE TABLE `completed_payments` (
  `completed_payment_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `payment_type` bigint(20) NOT NULL,
  `context_id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `assoc_id` bigint(20) DEFAULT NULL,
  `amount` decimal(8,2) unsigned NOT NULL,
  `currency_code_alpha` varchar(3) DEFAULT NULL,
  `payment_method_plugin_name` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`completed_payment_id`),
  KEY `completed_payments_context_id` (`context_id`),
  KEY `completed_payments_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A list of completed (fulfilled) payments relating to a payment type such as a subscription payment.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `controlled_vocabs`
--

CREATE TABLE `controlled_vocabs` (
  `controlled_vocab_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `symbolic` varchar(64) NOT NULL,
  `assoc_type` bigint(20) NOT NULL DEFAULT '0',
  `assoc_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`controlled_vocab_id`),
  UNIQUE KEY `controlled_vocab_symbolic` (`symbolic`,`assoc_type`,`assoc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Every word or phrase used in a controlled vocabulary. Controlled vocabularies are used for submission metadata like keywords and subjects, reviewer interests, and wherever a similar dictionary of words or phrases is required. Each entry corresponds to a word or phrase like "cellular reproduction" and a type like "submissionKeyword".' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `controlled_vocab_entries`
--

CREATE TABLE `controlled_vocab_entries` (
  `controlled_vocab_entry_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `controlled_vocab_id` bigint(20) NOT NULL,
  `seq` double DEFAULT NULL,
  PRIMARY KEY (`controlled_vocab_entry_id`),
  KEY `controlled_vocab_entries_controlled_vocab_id` (`controlled_vocab_id`),
  KEY `controlled_vocab_entries_cv_id` (`controlled_vocab_id`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The order that a word or phrase used in a controlled vocabulary should appear. For example, the order of keywords in a publication.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `controlled_vocab_entry_settings`
--

CREATE TABLE `controlled_vocab_entry_settings` (
  `controlled_vocab_entry_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `controlled_vocab_entry_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  PRIMARY KEY (`controlled_vocab_entry_setting_id`),
  UNIQUE KEY `c_v_e_s_pkey` (`controlled_vocab_entry_id`,`locale`,`setting_name`),
  KEY `c_v_e_s_entry_id` (`controlled_vocab_entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about a controlled vocabulary entry, including localized properties such as the actual word or phrase.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `custom_issue_orders`
--

CREATE TABLE `custom_issue_orders` (
  `custom_issue_order_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `issue_id` bigint(20) NOT NULL,
  `journal_id` bigint(20) NOT NULL,
  `seq` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`custom_issue_order_id`),
  UNIQUE KEY `custom_issue_orders_unique` (`issue_id`),
  KEY `custom_issue_orders_issue_id` (`issue_id`),
  KEY `custom_issue_orders_journal_id` (`journal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ordering information for the issue list, when custom issue ordering is specified.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `custom_section_orders`
--

CREATE TABLE `custom_section_orders` (
  `custom_section_order_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `issue_id` bigint(20) NOT NULL,
  `section_id` bigint(20) NOT NULL,
  `seq` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`custom_section_order_id`),
  UNIQUE KEY `custom_section_orders_unique` (`issue_id`,`section_id`),
  KEY `custom_section_orders_issue_id` (`issue_id`),
  KEY `custom_section_orders_section_id` (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ordering information for sections within issues, when issue-specific section ordering is specified.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `data_object_tombstones`
--

CREATE TABLE `data_object_tombstones` (
  `tombstone_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `data_object_id` bigint(20) NOT NULL,
  `date_deleted` datetime NOT NULL,
  `set_spec` varchar(255) NOT NULL,
  `set_name` varchar(255) NOT NULL,
  `oai_identifier` varchar(255) NOT NULL,
  PRIMARY KEY (`tombstone_id`),
  KEY `data_object_tombstones_data_object_id` (`data_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Entries for published data that has been removed. Usually used in the OAI endpoint.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `data_object_tombstone_oai_set_objects`
--

CREATE TABLE `data_object_tombstone_oai_set_objects` (
  `object_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tombstone_id` bigint(20) NOT NULL,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  PRIMARY KEY (`object_id`),
  KEY `data_object_tombstone_oai_set_objects_tombstone_id` (`tombstone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relationships between tombstones and other data that can be collected in OAI sets, e.g. sections.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `data_object_tombstone_settings`
--

CREATE TABLE `data_object_tombstone_settings` (
  `tombstone_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tombstone_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  `setting_type` varchar(6) NOT NULL COMMENT '(bool|int|float|string|object)',
  PRIMARY KEY (`tombstone_setting_id`),
  UNIQUE KEY `data_object_tombstone_settings_unique` (`tombstone_id`,`locale`,`setting_name`),
  KEY `data_object_tombstone_settings_tombstone_id` (`tombstone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about data object tombstones, including localized content.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `dois`
--

CREATE TABLE `dois` (
  `doi_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `context_id` bigint(20) NOT NULL,
  `doi` varchar(255) NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '1',
  PRIMARY KEY (`doi_id`),
  KEY `dois_context_id` (`context_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores all DOIs used in the system.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `doi_settings`
--

CREATE TABLE `doi_settings` (
  `doi_setting_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `doi_id` bigint(20) NOT NULL,
  `locale` varchar(28) NOT NULL DEFAULT '',
  `setting_name` varchar(255) NOT NULL,
  `setting_value` mediumtext,
  PRIMARY KEY (`doi_setting_id`),
  UNIQUE KEY `doi_settings_unique` (`doi_id`,`locale`,`setting_name`),
  KEY `doi_settings_doi_id` (`doi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='More data about DOIs, including the registration agency.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `edit_decisions`
--

CREATE TABLE `edit_decisions` (
  `edit_decision_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `submission_id` bigint(20) NOT NULL,
  `review_round_id` bigint(20) DEFAULT NULL,
  `stage_id` bigint(20) DEFAULT NULL,
  `round` smallint(6) DEFAULT NULL,
  `editor_id` bigint(20) NOT NULL,
  `decision` smallint(6) NOT NULL COMMENT 'A numeric constant indicating the decision that was taken. Possible values are listed in the Decision class.',
  `date_decided` datetime NOT NULL,
  PRIMARY KEY (`edit_decision_id`),
  KEY `edit_decisions_submission_id` (`submission_id`),
  KEY `edit_decisions_editor_id` (`editor_id`),
  KEY `edit_decisions_review_round_id` (`review_round_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Editorial decisions recorded on a submission, such as decisions to accept or decline the submission, as well as decisions to send for review, send to copyediting, request revisions, and more.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `email_log`
--

CREATE TABLE `email_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `assoc_type` bigint(20) NOT NULL,
  `assoc_id` bigint(20) NOT NULL,
  `sender_id` bigint(20) DEFAULT NULL,
  `date_sent` datetime NOT NULL,
  `event_type` bigint(20) DEFAULT NULL,
  `from_address` varchar(255) DEFAULT NULL,
  `recipients` text,
  `cc_recipients` text,
  `bcc_recipients` text,
  `subject` varchar(255) DEFAULT NULL,
  `body` text,
  PRIMARY KEY (`log_id`),
  KEY `email_log_sender_id` (`sender_id`),
  KEY `email_log_assoc` (`assoc_type`,`assoc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A record of email messages that are sent in relation to an associated entity, such as a submission.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `email_log_users`
--

CREATE TABLE `email_log_users` (
  `email_log_user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email_log_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`email_log_user_id`),
  UNIQUE KEY `email_log_user_id` (`email_log_id`,`user_id`),
  KEY `email_log_users_email_log_id` (`email_log_id`),
  KEY `email_log_users_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A record of users associated with an email log entry.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `email_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email_key` varchar(255) NOT NULL COMMENT 'Unique identifier for this email.',
  `context_id` bigint(20) NOT NULL,
  `alternate_to` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`email_id`),
  UNIQUE KEY `email_templates_email_key` (`email_key`,`context_id`),
  KEY `email_templates_context_id` (`context_id`),
  KEY `email_templates_alternate_to` (`alternate_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Custom email templates created by each context, and overrides of the default templates.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `email_templates_default_data`
--

CREATE TABLE `email_templates_default_data` (
  `email_templates_default_data_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email_key` varchar(255) NOT NULL COMMENT 'Unique identifier for this email.',
  `locale` varchar(28) NOT NULL DEFAULT 'en',
  `name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text,
  PRIMARY KEY (`email_templates_default_data_id`),
  UNIQUE KEY `email_templates_default_data_unique` (`email_key`,`locale`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Default email templates created for every installed locale.' AUTO_INCREMENT=512 ;

--
-- Dumping data for table `email_templates_default_data`
--

INSERT INTO `email_templates_default_data` VALUES
(1, 'PASSWORD_RESET_CONFIRM', 'de', 'Bestätigung der Passwortzurücksetzung', 'Bestätigung der Passwortzurücksetzung', 'Wir wurden aufgefordert, Ihr Passwort für die Webseite {$siteTitle} neu zu setzen.<br />\n<br />\nFalls die Aufforderung nicht von Ihnen stammt, ignorieren Sie bitte diese E-Mail und Ihr Passwort bleibt unverändert. Falls Sie Ihr Passwort neu setzen möchten, klicken Sie bitte auf die folgende URL:<br />\n<br />\nMein Passwort neu setzen: {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(2, 'PASSWORD_RESET_CONFIRM', 'es', 'Confirmación de restablecimiento de contraseña', 'Confirmación de cambio de contraseña', 'Hemos recibido una petición para cambiar su contraseña en {$siteTitle}.<br />\n<br />\nSi no hizo usted esta petición ignore este correo-e y su contraseña no cambiará. Si desea cambiar su contraseña pinche en el enlace que le mostramos a continuación.<br />\n<br />\nCambiar mi contraseña: {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(3, 'PASSWORD_RESET_CONFIRM', 'fr_CA', 'Confirmation de la réinitialisation du mot de passe', 'Confirmation de la réinitialisation du mot de passe', 'Nous avons reçu une demande concernant la réinitialisation de votre mot de passe pour le site Web {$siteTitle}.<br />\n<br />\nSi vous n''avez pas fait cette demande, veuillez ne pas tenir compte du présent message, votre mot de passe restera le même. Si vous souhaitez réinitialiser votre mot de passe, cliquer sur l''URL ci-dessous.<br />\n<br />\nRéinitialisation de mon mot de passe : {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(4, 'PASSWORD_RESET_CONFIRM', 'it', '', 'Conferma di modifica della password', 'Abbiamo ricevuto una richiesta di modifica della password per {$siteTitle}.<br />\n<br />\nSe non ha inviato Lei la richiesta, ignori semplicemente questo messaggio e la password non sarà modificata. Se invece desidera generare una nuova password, clicchi sul link sottostante:<br />\n<br />\nReset della password: {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(5, 'PASSWORD_RESET_CONFIRM', 'nl', 'Bevestiging wachtwoord herstellen', 'Bevestiging wachtwoord herstellen', 'We hebben een verzoek van u ontvangen om uw wachtwoord voor de website {$siteTitle} te herstellen.<br />\n<br />\nAls u dat verzoek niet gedaan hebt, negeer dan deze e-mail en uw wachtwoord wordt niet veranderd. Als u uw wachtwoord wilt herstellen , klik dan op de url hieronder.<br />\n<br />\nHerstel mijn wachtwoord: {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(6, 'PASSWORD_RESET_CONFIRM', 'ru', 'Подтверждение сброса пароля', 'Подтверждение сброса пароля', 'Мы получили запрос на сброс Вашего пароля на сайте «{$siteTitle}».<br />\n<br />\nЕсли Вы не отправляли этот запрос, пожалуйста, проигнорируйте это письмо и Ваш пароль не будет изменен. Если Вы хотите сбросить свой пароль, то щелкните по ссылке ниже.<br />\n<br />\nСбросить мой пароль: {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(7, 'PASSWORD_RESET_CONFIRM', 'en', 'Password Reset Confirm', 'Password Reset Confirmation', 'We have received a request to reset your password for the {$siteTitle} web site.<br />\n<br />\nIf you did not make this request, please ignore this email and your password will not be changed. If you wish to reset your password, click on the below URL.<br />\n<br />\nReset my password: {$passwordResetUrl}<br />\n<br />\n{$siteContactName}'),
(8, 'USER_REGISTER', 'de', 'Benutzer/in angelegt', 'Registrierung bei der Zeitschrift', '{$recipientName}<br />\n<br />\nSie sind nun als neue/r Benutzer/in von {$journalName} registriert. Wir haben Ihren Benutzer/innennamen und Ihr Passwort in dieser Mail aufgeführt, beides wird für alle Arbeiten mit dieser Zeitschrift gebraucht. Sie können sich zu jedem Zeitpunkt als Benutzer/in der Zeitschrift austragen lassen, indem Sie mich kontaktieren.<br />\n<br />\nBenutzer/innenname: {$recipientUsername}<br />\nPasswort: {$password}<br />\n<br />\nVielen Dank <br />\n{$signature}'),
(9, 'USER_REGISTER', 'es', 'Usuario/a creado', 'Nuevo registro de usuaria/o', '{$recipientName}<br />\n<br />\nSe ha registrado con éxito como usuario/a en {$journalName}. En este correo se incluyen su nombre de usuario/a y contraseña, datos necesarios para realizar cualquier tarea relacionada con la revista a través de la página web. En cualquier momento puede solicitar que se le elimine de la lista de usuarios/as de la revista contactándome.<br />\n<br />\nNombre de usuario/a: {$recipientUsername}<br />\nContraseña: {$password}<br />\n<br />\nGracias,<br />\n{$signature}'),
(10, 'USER_REGISTER', 'fr_CA', 'Création de l''utilisateur-trice', 'Inscription à la revue', '{$recipientName},<br />\n<br />\nVous êtes désormais inscrit-e en tant qu''utilisateur-trice pour la revue {$journalName}. Votre nom d''utilisateur-trice et votre mot de passe figurent dans ce courriel, lesquels sont requis pour toute interaction avec la revue via son site Web. À n''importe quel moment, vous pouvez demander à être retiré-e de la liste des utilisateurs-trices de la revue en nous contactant.<br />\n<br />\nNom d''utilisateur-trice : {$recipientUsername}<br />\nMot de passe : {$password}<br />\n<br />\nMerci,<br />\n{$signature}'),
(11, 'USER_REGISTER', 'it', '', 'Registrazione nuovo utente', 'Gentile {$recipientName}<br />\n<br />\nGrazie per aver effettuato la registrazione a {$journalName}. Riportiamo qui di seguito le Sue credenziali, necessarie per l''accesso all''area riservata del sito web della rivista. Potrà richiedere in qualsiasi momento di essere rimosso dall''elenco degli utenti della rivista contattandoci via e-mail.<br />\n<br />\nNome utente: {$recipientUsername}<br />\nPassword: {$password}<br />\n<br />\nGrazie,<br />\n{$signature}'),
(12, 'USER_REGISTER', 'nl', 'Tijdschriftregistratie', 'Tijdschriftregistratie', '{$recipientName}<br />\n<br />\nU bent nu geregistreerd als gebruiker bij {$journalName}. We hebben uw gebruikersnaam en wachtwoord in deze e-mail opgenomen. U heeft die nodig om met het tijdschrift te werken. U kunt op ieder gewenst moment verwijderd worden van de lijst gebruikers van dit tijdschrift door contact met mij op te nemen<br />\n<br />\nGebruikersnaam: {$recipientUsername}<br />\nWachtwoord: {$password}<br />\n<br />\nDank u,<br />\n{$signature}'),
(13, 'USER_REGISTER', 'ru', 'Пользователь создан', 'Регистрация в журнале', 'Здравствуйте, {$recipientName}!<br />\n<br />\nТеперь Вы зарегистрированы как пользователь в журнале «{$journalName}». В этом письме мы указали Ваши имя пользователя и пароль, которые потребуются для работы с этим журналом через сайт. Вы в любой момент можете попросить, чтобы Вас удалили из списка пользователей журнала, для этого просто свяжитесь со мной.<br />\n<br />\nИмя пользователя: {$recipientUsername}<br />\nПароль: {$password}<br />\n<br />\nС уважением,<br />\n{$signature}'),
(14, 'USER_REGISTER', 'en', 'User Created', 'Journal Registration', '{$recipientName}<br />\n<br />\nYou have now been registered as a user with {$journalName}. We have included your username and password in this email, which are needed for all work with this journal through its website. At any point, you can ask to be removed from the journal''s list of users by contacting me.<br />\n<br />\nUsername: {$recipientUsername}<br />\nPassword: {$password}<br />\n<br />\nThank you,<br />\n{$signature}'),
(15, 'USER_VALIDATE_CONTEXT', 'de', 'E-Mail überprüfen (Zeitschrift Registrierung)', 'Account validieren', '{$recipientName}<br />\n<br />\nSie haben ein Benutzer/innenkonto bei {$journalName} angelegt, aber bevor Sie es benutzen können, müssen Sie Ihre E-Mail-Adresse bestätigen. Dazu folgen Sie bitte einfach dem folgenden Link:<br />\n<br />\n{$activateUrl}<br />\n<br />\nVielen Dank<br />\n{$journalSignature}'),
(16, 'USER_VALIDATE_CONTEXT', 'es', 'Validar correo electrónico (registro en la revista)', 'Valide su cuenta', 'Estimado/a {$recipientName}<br />\n<br />\nHa creado una cuenta de usuario/a en {$journalName}, pero antes de poder utilizarla debe validar su correo electrónico. Para ello, simplemente haga clic en el siguiente enlace:<br />\n<br />\n{$activateUrl}<br />\n<br />\nGracias,<br />\n{$journalSignature}'),
(17, 'USER_VALIDATE_CONTEXT', 'fr_CA', 'Validez l''adresse courriel (enregistrement de la revue)', 'Valider votre compte', '{$recipientName},<br />\n<br />\nVous avez créé un compte pour la revue {$journalName}. Pour pouvoir commencer à l''utiliser il nous faut d''abord valider votre adresse de courriel. Pour ce faire, vous n''avez qu''à suivre le lien ci-dessous :<br />\n<br />\n{$activateUrl}<br />\n<br />\nMerci,<br />\n{$journalSignature}'),
(18, 'USER_VALIDATE_CONTEXT', 'it', 'Confermare e-mail (registrazione di una rivista)', 'Convalida dell''account', 'Gentile {$recipientName}<br />\n<br />\nÈ stato creato un account per {$journalName}, ma prima di poter interagire sul sito web, è necessario validare il Suo indirizzo e-mail. Per fare ciò, clicchi semplicemente sul link sottostante:<br />\n<br />\n{$activateUrl}<br />\n<br />\nGrazie,<br />\n{$journalSignature}'),
(19, 'USER_VALIDATE_CONTEXT', 'nl', 'Valideer Email (tijdschriftregistratie)', 'Valideer uw account', '{$recipientName}<br />\n<br />\nU hebt een account aangemaakt bij {$journalName}. Voordat u dat kunt gebruiken moet u uw account valideren. U doet dat door de link hieronder te volgen:<br />\n<br />\n{$activateUrl}<br />\n<br />\nDank u,<br />\n{$journalSignature}'),
(20, 'USER_VALIDATE_CONTEXT', 'ru', 'Проверка адреса почты (регистрация в журнале)', 'Подтвердите свою учетную запись', 'Здравствуйте, {$recipientName}!<br />\n<br />\nВы создали учетную запись в журнале «{$journalName}», но перед тем как начать ее использовать, Вам нужно подтвердить свой адрес электронной почты. Чтобы сделать это, просто пройдите по ссылке ниже:<br />\n<br />\n{$activateUrl}<br />\n<br />\nС уважением,<br />\n{$journalSignature}'),
(21, 'USER_VALIDATE_CONTEXT', 'en', 'Validate Email (Journal Registration)', 'Validate Your Account', '{$recipientName}<br />\n<br />\nYou have created an account with {$journalName}, but before you can start using it, you need to validate your email account. To do this, simply follow the link below:<br />\n<br />\n{$activateUrl}<br />\n<br />\nThank you,<br />\n{$journalSignature}'),
(22, 'USER_VALIDATE_SITE', 'de', 'E-Mail überprüfen (Seite)', 'Account validieren', '{$recipientName}<br />\n<br />\nSie haben ein Benutzer/innenkonto bei {$siteTitle} angelegt, aber bevor Sie es benutzen können, müssen Sie Ihre E-Mail-Adresse bestätigen. Dazu folgen Sie bitte einfach dem folgenden Link:<br />\n<br />\n{$activateUrl}<br />\n<br />\nVielen Dank<br />\n{$siteSignature}'),
(23, 'USER_VALIDATE_SITE', 'es', 'Validar correo electrónico (Sitio)', 'Valide su cuenta', '{$recipientName}<br />\n<br />\nHa creado una cuenta en {$siteTitle}, pero antes de poder utilizarla, debe validar su email. Para hacerlo, simplemente haga clic en el siguiente enlace:<br />\n<br />\n{$activateUrl}<br />\n<br />\nGracias,<br />\n{$siteSignature}'),
(24, 'USER_VALIDATE_SITE', 'fr_CA', 'Valider le courriel (site)', 'Valider votre compte', '{$recipientName},<br />\n<br />\nVous avez créé un compte dans {$siteTitle}. Avant de pouvoir commencer à l''utiliser, il nous faut d''abord valider votre adresse de courriel. Pour ce faire, vous n''avez qu''à suivre le lien ci-dessous :<br />\n<br />\n{$activateUrl}<br />\n<br />\nMerci,<br />\n{$siteSignature}'),
(25, 'USER_VALIDATE_SITE', 'it', 'Convalidare l''e-mail (sito)', 'Conferma dell''account', 'Gentile {$recipientName}<br />\n<br />\nÈ necessario confermare l''indirizzo email associato al Suo nuovo account per la rivista {$siteTitle} cliccando sul link sottostante:<br />\n<br />\n{$activateUrl}<br />\n<br />\nGrazie e cordiali saluti,<br />\n{$siteSignature}'),
(26, 'USER_VALIDATE_SITE', 'nl', 'Valideer E-mail (Website)', 'Valideer uw account', '<p>Beste {$recipientName},</p>U heeft een