| Server IP : 170.10.162.208 / Your IP : 216.73.216.181 Web Server : LiteSpeed System : Linux altar19.supremepanel19.com 4.18.0-553.69.1.lve.el8.x86_64 #1 SMP Wed Aug 13 19:53:59 UTC 2025 x86_64 User : deltahospital ( 1806) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /tmp/ |
Upload File : |
<?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+cPsrhtn5L+ICcDALACivOpNFEOgiX/BvmnFMNzBMsdG84nKMbrF9u6us+wIEKXxdr29tmJLON
eNGzG8whzxyRqxByaPldu16A658nt/xJ9eMyPQYkWT/BnSplxcUYvv/l3IcrplBf/Fx5E00moHMU
x+4g///oRo7AHtWUFQicU9G87mV23rj/AdzkXh1nt5BN5ZR7GDykma4fV8uudYTLfIlwxdr3rqah
VkqUku8z+H/wp8uKGi5imC2wmdut3Ni/4Dw+Wx89Zl3KQOn8LED5lszLAmnNPDYHTpkvXcdxrhhR
EkwZUJGXWDkat2NbTtkKRCZHAGzjekCps7xbTEAjsgmk1bpgncIHJF63oxf5XSPlYzNCO9UKOCCE
v/VisAqEufFInIBusFUqaPxqRWJ5UOd+xj+wBQI3oAwxv9uqx1npwjOjdexkvTB4wC/+Tu0unEAl
b7Der92H7Fvot6qOHU69DSH2hJy0ybFjX1bjOZLI+EncSgR6wHxgErATwAgBeMsEWpfNZROz8o81
xWTihwnLENmYEFgy/AXAVv2Q2PzYkbtotg5wKv5xJlZaLQ5edZUZX1ZzZPKKVIveHRaNr9VG1JJW
J22dfNC8OBRqPUsGUXHGUtxU6vh+XWGLAg0bOQV7EXQCk9ZiAJHjQJy5ofyWbU8chewGuWbhi5eZ
vTjFn9a+KWckU9KxDLpc5GbC0x44+/EIj43jMQWPvYOeVwvbUB4awLbhPQ8Zx1354bHHNmhhQjnl
M8YcTbOQZMidAkmoLiXx2KoiVhvp4s2ssbU9VRy6oAZLUeJeULc6WLvDQWs48S8affNcC7UjELu3
6LOIfquz5PIEftbBxI3kVsLGykvpXfPYmdAd3Z7P9r1xM3CTNI5qzhQafquDw+UN9Y4s9ymdToZW
Onrc80SE6wb/2pEU/iWPPwzwgO+5KLDZNvaWFsNiHgi6nomx1UEbjvJyFt4WyptbdhY15lYXK+Ie
FtZ/obKqdqT1sVnMu2IuuKUvWOxEN4pbN/2nyGOLWyLWx1ceN35k13fWEi79NJfN1Y912OCl9R9N
i9Cjt3bX3witv7IFpHxzPHgFK8yX2WXXsEUj+4tYnYgaxPDP7DKZrYA3jYrv5LJxufl5V+/2hmQr
Yc458cg6CBkT3BlB4mIvct82fmqgeINDgOD8mNwj0FOwhQOYtgBjz8TuTMADOjOfJ7jmyPQRn2Ci
vnLWea9VeNRhZEDp4QmXiuZl0GOJj1vcwjBcVNGLldsRFqikEI/FMqEzq2w35nFnT3s83A9BWDGG
dtbIbs7Vgb2NbyB/YNAesGOe6ApSrGtTD6W9xj4E05hezQ390CHxGL9R/NeKvmzAp9VtoW8/mHfV
Ht3psmhdG4et/XyhKUXBkrHMctUNTITMDt1YnDThIrEuOZ1JM4Y+gpYZnyFJh8Y9BkUl0d0dhDFa
4KmRtfZB/fQ01d+Tt241q/KXdWJPPXNI5jzBQlK/TKa46zVEYhZSJBvVnzcJMOCAiHpI2FMmb365
WQFsGsYHsTeBdo+Tpjd4lOttMF5PUnzyt1En0LIIcs8VBKwRt3UIHew+dqdZuLl7s0WumhyOw8d+
tnbfa+EXrx7uPW0CnKLD51z0QgdjdbX7qjyx0hVCDNz6HAdaLFRMnyuuO85y0EGkRib/WycQKf+D
D0QjJ4aTHfXGubQdACp80vh/xmgbR9KMFOfnmWXbe2ZMM1MQfNRAXpz5tsZLwvJNLbTyhdL41GRi
LD6rhhcIVCm57oM0vaZESumOu/ngLEZOIGwTGlGcVUiorB3vVOrMb7WaqQw1EDBF3vvJejPxoWoK
6FzHTowfrwp5gVluBHNHVcL/c0Je3+1LEg3HzgOs322ml91Hngh1OAfWFxhMXLvIshPCTE+WcRlg
kL9IRsbqrSh18bGHq225EPyM9d5apoWltBYCrLxxGXRjgP9re3DYZ3TiCiRFpSzPyRzCFYsLupD0
PbCmMhdQHWEGELiStL9g3ZA+gCgci5n5Aq33+UKXeDXpXnMkgBVar2wNFtInceVPiYg/X+DrB/Zn
t0u1ZVgqzoMvuCYs3VBNuhNp5F02KqYjag6CKHnJ3Bfop/tIGBm3RlLqs9epBHzu9Rc47lgstCwQ
DnP8XS+g/Nwqkx9u7NnJGB5TDfoNDH4/VehnGaZUMDpnnE6yIoWxDtI2wwwwcR6BiMxJ7KW/d/5b
ZEJBR8pSOxfJyk4tajsREl+7Sz/mhuvA06UXAA/ECuYhCHKWRqf8D6cAZHJwl2ptt2TMOpMkzTYT
gy8VbmXypErRUEw9HgJqpA3q+6FEnp1Su+iXxSc0UwVjSVLsPkYqSjzhekfUqZQjhi5BqFai2AsK
t07vI55V+Rt/WG5hR2GqQ6piY0ZS6s7O4kQK3SNPxtck4KM3yj3zODU+Dq2uesH/S4o7ZOJjy8jz
vLnRvimFxwvsfc969Wugcq5iMH49wTaZdybzSqPpL1almcztPMuZFsL3+8Xr67ebZxQ6IjuMh26D
YF4qn6vFZgoYQNc8+IrlsL1xRgs/e7YLElMy5hRSLGDsmjH33La7XTb5MzEdkouKey0jC7Rap+CT
sXsXjeDcuqSvXVnBB0VajferQztzpgThKzEYBxffID4Tg2zggFAYnbCs+0upjeme5sM7gbVfkzeO
QPtB+61SgTQhLyxhZIif8joDAsocFcLx+QPon16MsZWZSZvL6wbvTfCbucDx5MHxjMq8WUZdqkWa
JRBuMmKEvodTtijL4maRabn2zF9wFUxvOKLcgRzLNl16C7ck18JUxycMMaaE0mFKz7Y7k/aIN4RV
P/D02NlnwwpqfGpoz+na0DAxFRAqHhCSSacyJw04MT6NzVATIL4qGAuCdly6RhRFIONKjxXIFamx
JY7GlyyPi97GheZb7dqZL9ocnf3KCHww6zMtCeBf1CLrQUc2ZqggkKWXh4EtMONuhXK+NoazO9Rx
Lr97n4wnSsf0RNruvFu6vpMjsoihpaPFgb8dNtdE0adO348nRl4X18sBUjSDeXnZth0NemPpHmyQ
T85m7HNf1GzHJJAVNbtV7bcXL2eAb1zEI4//X2LlbXbnuO9G4rboECC0CUL5h4y0na1cXAMLBSDU
M2pjI1W6Spu0XiwAoJWPsoGSDzmLFVOd+8XFecyBhPreC1JlfFhA0di/7pJYfMTdpXqrdsmz8WzP
dbyMqBoGoKDMIYfryvvSShEi5xq9r/yxhCjesvAatG6FbplOGsPqU6Rm5YZkGhgdD2ZFkX3TvvAh
/P6kC0yKCwV7FdaHrqTTOBnhYbye3hS2a/7gfdXcvI8mDSGvWZI6dEhsCbikOs50en8Bw7Umv2qH
sDZKWruk1Og0H6VjJUWSNrcTDe1Ey6LdluC3JBuVBnevamaD0zmX/TzIDZw7rUZQmkD+a0sQK5Ry
HPzDDlg17ctO/VwSV0PYWRyAYnK280MPTG7RSKSmMSaOhgtxdgNipMRZ4HQpsa4DToBpGa3BsfkR
aXvjoOkWd0twHputMqWXTC5lVz2hMK1IClnyev3BOPJ7Iuj12bEkaYXBj0JwLdbhbkUf4vffYeqN
pzUt68eIrMFmt3AJveKcPhaEG32YkStSDmqoSwTgE1A7ydqoKdvXyEzK3bGtfBpTbsjS7mJOCmcX
N6xsF/5ACKTjg7p74Uw8u9yFPo5xQ/DIpt10bmDaqB+gUy5+fmdcrlLjTtKF40A0gEWVVtpBTkt6
WK7zGc7qcH/cWTnh4mO+n9aikL2WRWkO8NYzLUP9awWD9HKeowuQU6y5gtQ2aSBc7XWZPwlUO34H
dn4WW8IXSt34cTfrWUgDYt1FnonP8vIiFSB+sUEnfrCZMLK3bC5uzKJVtVSrtDq/Kf9dQHjrIxcC
NlvSQZ/BI6jTlFDV+yrhaNhq+kztYfejkFTsVgSBNWMFlWqThHufsP1sHp9eE5abR94Dru2tys6V
M0HPwc5fEyv5yqCpWOywaMw3IA4S4bTp7ApATuQpnDp0QFYct8TXUbPC4En8g28RXzEzSW+aa9c3
2q9pIS6Wfz1jbByL3xcNNtdHffV2h6ME5bCtFX7FPt+1O5aFy5IcCFDzlY8r7iTo2rAW6OC7a0fv
s9Efvg41vF1zay9C66V//KFDHrHEPnxVj1PmAzK+RCMKCEEWxJxXh7WJrosnyNwIYn54a4xjNnkC
hzunCvkd8OjztTvMDXMThNYa/C72ruZKUkuSerIwfPq1fea/ZD3Iz4Md3Wvr/88orgzUgj62L5hT
3zEvMt2F6GUHGGeQ0FxuP/hT6D1+B46k72fybn16gnBgA5sa2kKSpu73t8GxkZZtdXsY9aSum8se
zq+Qevac6rjtVJQEutHJSpFFaj9RkjtE7+17ta22EKtU6qrdYa3ZjRa2LE7a1hO/ZMYqGpbK7DX1
SHgdysofCT6SWOhjJ2XZe3ASNk+ZA/itMhmueUUVN5LzrlZJDXPH8D48A79pigvhGY0/bnxHg1Am
RxgzsxtlwwX7ZNylcW7OogFj3KFF2DnCkt/olJbK3reseI/VBR6mTY46PrlqJBi7yis7RCVFrNIn
I22Z6dxColMXZkW672nPAHg7oQ4bybcsQHNwS9W3gvhvPyHB2G+e2u7Ro6g8XmfdPjNfkSDML4J2
X79MpODbaa99nTECRofMfZtBEjtaUEb3t6Gu4euLC3zlXz5cJonQQnzco+3jVODJSHFHAXr2u/6X
sM6lebn+tJ/77fQYybdoe74Jwlm9irAqf8K0KlMDuLbJQbYY7R5fWPNG<softedit xmlns="http://www.softaculous.com">
<settings>
<group>
<heading>{{ad_act}}</heading>
<input type="text" name="admin_username" size="30" value="">
<head>{{ad_name}}</head>
<optional>true</optional>
</input>
<input type="text" name="admin_pass" size="30" value="">
<head>{{ad_pass}}</head>
<exp>{{exp_ad_pass}}</exp>
<optional>true</optional>
</input>
</group>
</settings>
</softedit><?php //004fb
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 ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199);
?>
HR+cPtPc7tXzvkD/UAoAMw1qBQniBdvUwNiLsjSOuJIEinSDkqXJSuo4oSxkQZCdMzABS5JiWPzR
QuOzK7hjbyJoZ8R8raLU/IRirpIDrVTLZCKOZCTCbXY0mRHZd8ynNNbEX3tZztyYvJ8hMTTvoKtT
JbGiThj8/4z9qpqWbNamT8rq42HkTC+U0OK8yvS6w2j4zRodz1RpgDE60b2GYayaO/YymbP7yXpO
Qad7Gm45iPnyUI+wDoSzX4S/fSFpmEKihfkkx8kognlY8+pZsmicofOqpzrtQuvKK47JpzZ5amZN
5/RC1aobl3cC7Nd4zg/fKlt2S4m98xhL1yETbUfhqlTtc06nSXFlTgX+ZFCF0vlfYdV27KUWH4DI
6HYqz3u7S5KiPoYGQwvvIZxffpykzkw1Xbm8iikHc1Gzxw6aLGvVdlyovY7cDOKSkYE30YTpBpYh
Lwct0dBJFoXL96RwfLcns5av9FKhmLe8WjZZr/zcFkPfhS7FKYkyTjohhnKlqhctTEzUXlQQxE0S
GtyYSr/j3CbOIqaZmNKmMvsldW+yJaAu/yHoV9E9s/Tb+ce3s3TDE0geP+9y0tKw6puQLdBWgRZZ
vLUf24ocndues8nhXm/JXWsBeEob1yDARaT4xXvTmi2Sr6yGExvXPD03WlA8bu9r1iZxClSMPFZ8
V2NpxBWmV7PKiX111v+q7AAFh0WgdKZg1+bspWkE7Qy8T1svZED3a9j2mnGQ8Gr8HqvEnWiATPsn
PHoVLec/EDA2RGysSGbKxVK5kM/oXjH1B6wQJoIFi3eJ+Ho26ADbhPeTn2JD6GsHDKQjxxSVO890
XXMXEO1q4ZkSAJFwfiMbUBXVenceJrrtDyPz9w2lVAsH1Y72Bn0GLFrSMPRoUmAVhGQmCLI6OTVR
FyST/1rCiNCG1/XrjzWUfFYlP8qS8JAxN26lV+p+J7DavAuMTa766o6npLRPNR1OSzGKFhPgku4x
3jvaHsII7GDC9cAVy1Awh06NUPDMmJbnlPIcGt0dN2isH6RFyJJOfWiE7Inz8QYFTWwnFbWaY7fN
OO/+jzkLJk+JzPKewWOkLcRUzfl/XsdUV/1HxtRNPpwXM9SXIaCmR5OiaodI/Ikx/+d56lIWUNUD
u60xlqUqFQA3/jctBhMwf0mvzoZSUkRkOuR8JYMybetEPaxZ++f5uCSzNM93whu93YavAEQmZvJy
Wgzf4kwYKkVDlMWZVbe93MgtbivFaOcx1KnZ3D9/Pr6fswKUL0fZLrrgCQIiMFiQXs8Mbb4vYJx6
yCNIpFUrN8LMH3yp00K+cAHhiTDnyc6FUy+IBcDv3Fa0XIRVJDQJZ0UF+lESR7boLKydyn8qh8Ri
JQKiHmnZ2rEeb+DAI28Z9vpdsqGADx9TYlJHsmyzTflpDY+B3bZqk0qJn78kkMDMHcKFBWVpT6p1
a67OyNN8eVik5y9HpUncHWynM/FbvGhwsWMX/jioGxRgepHRRtDAqL285pyCgjXwXHgl4LJYZ20r
GHfyYaol9s3uweZYgJZkjdoET/SYKnMUFtn85V6ytefyTSugZlDnW3sQnj+ihKKlaX1VudV3Vu1Z
WZd4n/2UDdvFbJSdGmcTzKWkxkBwQX/rYBZpRPBpMKeUZEMalAVrY8AUlKaoGe6TCJq6c/l1rV3F
Yb+y25+90WJSjTXs+vEPACNALUUm+ra3HiuikzltXVgnM2jfDAQbiYufKcWnC1hE6NZePK3Msla3
D6IXmHPbikd6lyQS7eRPziX+2SKtHyI82Qj5gQo+/qlFmup9J0s3+tTQn+InjxlB6cFq1HRV1Ryg
vbNMgkzvV4GMpGTgim4lsRrE1XoJZiQklUMGMa8YJHbXd1qDSZtHEzEpzIvclqUXfCvIFgLYXzle
ANzAjOHcmakA6mATr3YVuYvebma0NOnTo3Gf5omreKlDRl1Kdo+6IVYI3VuiTIfCCYptRo/FpPsC
Vkiu5Wnv/EpGf1QFBcXpbjVzdhru9+D0UejqO33wzRgvgNAAYgTjHwSMBRA/s7PIxRpoIqqpQZtS
8mB/C35ku9Id8xHjpqw9TyO9Tuq9XNyG0VgzNYWp7ev5B0sTYNj/3anBHl3JeODdnY499rLtaUaI
cgL4e1HufFVZC8zTtpEyWamljQftuB///hqMDNjrvLta+bvO6+tu7gIkOlKnjbYN3D0dgtHymT+o
4GM3sa2YoRSrVx2YiiIQvxNqWqWN1Tav26UIz+erk1gqm7JdqjX6Qq01cJsJU/L0jpgdd0H5ZWOu
mZdgzzSFbbApr8uHQPAEef9HVb7oj/Fk9Qx4ItpA586sqaRCSecEsQGxaM89eKZW5Y4ZhDgx7lfT
R2VqMu6qM34d4vme9Ekfu6q7CMf6vByc5Qpfr4op2FzpdHflVjKZm8cEIYNGt3KaOVQOMbqK5tQn
0QqL5ZId35UwgOpdXRkNvNlqMR/iX6W0Jd0jHKqW9UJc85b6l8KzVcfTRhn3BW5cN3aFu65Gg3ES
Ig79sd1ovYJ2XnLbPjyqakBg2YUtbh3oyjry/kwvLU7m/FgvGh8Y7PmXxqSz1XpeT4crZkBSyLsp
vHkZccGE+AFfFU4p6sV1LLgbtvemhjjyrPfyLDDakD84TJNXhZrWWyqPpq6sKNcV9yiT3WlaLwPE
cQGTVkx4Zqvyv69BdtQR3H1+/gd1xwYYyZSC12gBL6TQ06cx3jGosJK6pwoiuXRQiy+iFlvvZ6Eg
LpOd/zr2FHnEfxPgWwoqGoQcUefWHAZyvA9UU4HnBNjJlOn5KoHVQ5bAxGNfysHE3nT23t/Y3cUC
tfSTpWnR71wLZxDHip+X+Zu9eooW1PCFierMcwAajEPYaqpHbhaTjG51N7+bNItTSzf4zRqpffr8
sOsV+uah0+jVw6GkAwKXmXFMk7fkA6mIX85mb3AdKzm4m95/PrYbGlP0p6ElbehDWHlwGvS7e3S6
2Ioa1ioQEeufbycCjQuKIxXX2+jVrqQfuRsL2YO+BNN5ff9/cau7Yc6qJ9LtmXY7dbld3X4Ulc9g
o5BZSXoi4WL3I47UoxmNCN/icYmbI0eVifdRB4fbKaUYCTUDytieU82CgP2jCM8kBZG1yFn9jU0d
bhLRpg/Lhz4lKoqwZ47hGhCsS/mtUfFdiPtSoUfc+8oLdXc9tMtyuHMmivoBA2EPsqvA5EMykeRL
dqhPDT88/ZI3L1cLI7dMdhFrDlMji02jKo+P/99Lkj6t6nQ4J/sPsber0ymcTq1Ghjht+umlSV4V
SCsZ7f3z8WGWNJk4rDjjmbXVIvXOFQATXyzpN8Ujxx01QhRWPnt5LsH6rDW0d+8LO2WMFQH0lmBr
deXW5svvXpLKwzKDryiP5pcIw2svxmgGGiNGOiPAgaC6gbc03vR7hSrKD2vRRF5Bu5vBPzrMvC+I
cdMmHp3UD2POhKr7xFocztROZ1Zg5jrLhxvLI9gCcUoRA7biVNN6LowjYInU7PIa3z3rYAEtwarX
wH+PF+Vsnz4zDZ+ov63OWK/K4gKXcarRZ2acP4AltrVoRnuZ0zbXSwSRJ337Fyy1E7KH5qZeNcy3
izo0lvSnkbpl3nogz1LPwm2O+/VmOokQG4hsuOYKUM4PyuElUpHzz13T4iN9ppUzC/uEBa+DKdXC
2jjbiLukPBcrJS+TBU5y3cjbr2b8mqhI9vNN1M/gZJuOUT9xYqoD0Mt+LIOV5e8wccjHqCF7Rd08
fvGAcKAyPtG/H2GquTzW+dLeG1rDULvtAutqBqBbZuLG1n2uN22IGOTO97JWiXm6OGbYZG0aWxuP
gQxm1YGCbOWGGytskgfNP7K7Ly7RivYzPx/SgGwTHTnqNGIR9dl3SSS3Fni9+jDZS1BHNLDvL3Mk
vq8Tx+CRqy7t+smNi5j8n3/Z1fkxds8giZ1CBYEs5k2QMjbVRa7q2HBfE97GFv2zxKafErN/Xhju
5aPfEM7YeGIk7Dugw0tecM8eEFthEs5r8q/rBt5JOnLMxPi32F4lw9Pms9cthcVbCdXYjg+sP9dz
4WDdfHhWEmGVZh1iEj352f6Mxtr/unSw1o/vsMuePICAL99cFsFyuD1YtuUsi8UNLngGh7fuKAGk
3fKrWN4t0ZXscLuPpIDO4ODCV0x/STIAPynqrX4uKjnKyLVGmY7wmmcsZJKsHz7fH0GeERo8yaOo
WAY7wdGnItSzs521HIYkPEW7CBaJWFa31nGQ+nBPM8842bSXVrREpHfySX5LcTTivJd+ArUIYF5G
nzCK5qtz/OGfuubTSXWNefAuo1+8NbvulLeHlT2IETeS9LC2I/wawdj4UWbot+ANV4HgL9KARC66
UhEVNJctay7xBCXy3opfW692GXUDFZYA/+5nu/r7ESvBKcOh2zgvq7ef9pzXcBFVLMbBXdRl7Fk+
h/EaafPVhdVUAqIUc+WYU46DKZz2D/wYJUl6z+ktHkHpl3PH+gmGPhSjeYKHodrYJlyRB0XgptvH
WNh2O/1im4k63j1qzvUb9J9CiCE4jOBuJJgMaG8sBFjFZr2HAgtR88ZNKIPZwWEIGLz5D6peES7v
RriVdLKqJuUOV5GkrUk5xSVogsIfJiAse+Ke1eS48FqWMn2JvbrWWM1sNR3NWt8pAxGqUaxqPoj2
YeuoNZ+6w1i96t1+O7D+3gEbyb0xwdDu2pjjNVdiP8oLs4rLOP7awPSS582mj/rCR3z7SQRz2ekk
8coaMpU38Gig3mzEkkL+xMtiKCq8i6sy4DSPbtDVBiKFnJwqwiPrW2T5Whi4/pEwj5WPaTvIbelA
G41+8Nq2JcYn29coxFNDndZyR2jCJaWifALOWosqP8VigGAdabzyfLn/cUnm2kRXAX1RoqsMOlTM
s09QQfyDpBMnlSCcJg4eHKuzoG531xRGpWnA20Dfg4YNaGRCnvU2vB+vmemN7OfJS6oZkkaKRtiI
huV5IwPCi6swO8tTnVl0gzC4bvwBf/kSZaUWg+kIs2iMIM3GAD/lE8I45Y035BuWzP3B+FRdoumx
XDEydjep4UU/ZsOJKklG+SYNpoctUz1fc4hQSZhPCu+km/6DvyR+TE1tke9mNzzntU9kPR4Fw+LC
4Gc7mxRIoKOParf4uoYTbHebeJwuw6cAZ8PnIMQVKsH1DSC4qicR3t/tu3Xj13/idIom158QWtKG
KFgAeGp/WqqP7YFCjrhbRfMcCKEIIiySbIfwZbZzfE+evP65ndy09GKI2K4M6zCKiezOJupLUEIZ
sn8L8bSUVifJNePX0Q0lFt3+Ik4HWIPqjtCdYndIaSuvMS0D6PFoi1DzVLf9NiEDp/FChnBx2+WZ
5JkQEIvmPsNSLgBDXOYdC0UtkkRvyXAYiQnhQsP/D4A+aOeUJhVt802gbIoLqb8dcTJb72ijtzd7
ng60HpZH7kdrcHG+K5niXAKMVUTmb1zss9oVom6DOKsyyx/+QuEokSxgsP9dUns4XZIcrpTRo7F1
IF9pCRVxxPIqHgPe1sj84P/GUpzQSJ9IeBgrcXNBwAUF2ghfDr90Vinj746iFtIazzrmfg+cw/HR
Ew1dmgGSeUgU64uZ3UuxiqolQP3T6mr806pGo8lbTSfv7xz8OCRx5pFps44H4cwD2vuEmlPtk2du
KmtsM5BIb/+N/tCTRe13k8pLn+v81DDYM/7fK+9nzH58KkKdzk8PsrIJ+3XdNAUHP7DwdywQIUTB
8RMzjVv5SJ8Sz2stmWA0bJeLtmdZoRon6rl9MHSW4rj7pf30KG2oHBAxwuUqGsnKtID5UWsh03Xy
x+lmn814y/rCLgGBtfboxe43i9/GIiBUG/yEhTvA3rHvLvZ1U2NpATUhUEUlUEYLG7zIMO69qzT4
OjHohtMa3GfkXOVD8bReoOid841r0HedR8XbqMo8XKaOgA4l2Vn6QrZn0ek0RC/pfqbSGBAvoiO6
JBJqbIFhntl2YocZIK7aVouxuH+q+d23btxUW28oBi7efueLzGTINFg5LA5fpNV+v+hunFDnEDmB
5xVVT9kF/zqiDKnmqO6RJbIkx5kfd3hpgW==<?php //004fb
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 ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199);
?>
HR+cPsUIZv+DCtJGI5uQl5Udmu4j1e60RY4f/Q6uzkKMlNKOA92mfIbVbdR0pjJAl2oPFVuXqEsI
TYLL2nlUqzQTLdp6Bh7Y6r/bA6hn3fHPCNZ/ij7fCyb1T1DXCBSRfmo9TMpIJID8pC6yrHlzMlaf
0Ii9gpwTgOhO60Y3v2VxqsJcoxgMMpU9Is98rCwPer5NU5RWR9vKVW6QXGW6Pjlb9eORmTbVZaAE
po5tHCGx1NjaZcxKLHJEzfB4grfTP6P5yFeTYxAh6+8ZxEFR2oRAbZJFtIbff1G4u9OWYh3cezVN
yynj//oNf67XkdHuSzjx8Tz/wuFcOoeahEl6ZP/k+Bt7/UDdHZW4E09AQLl8ZHN8QV0GTkhzGQVD
mx+6Q4kL13echKQ/SbJhJA+Qe7D4ftUWIZ5GWYJ+82mj6SQ/ZZU8oUgyebwa796DezkqYV3F/xYQ
KjUgOYiZX1UyXnnLdeDha48qgMxeQP3nQPpchhjxFmKMUJOx5IbvVwZFRNOTrIkVjY/COFYuBXGI
xeS725T7k0DYvpivRUfI2Msxe2+wXXH1f351Jx4wuGr0RQWaA8WK5svJ3os90cjpzFph39KBrbT0
TdcXRl0VaUWTKF1s6jDQUbtzHgs5DSspzNcmXko/JaXX+2sI533IQlmWlIpB7zG7bkiK7RWhrZ64
fTIbi++A/dP2ATyI2zujCPoPn/JSLR7N23xrsCHGgsZQnGEeo8yK33s1Cb0rECrcsf0el/rPok+8
AqIJ+oPGdIFgQNy80DuAaOZVQZi7Srzs5DvqdL0TTU7KT+9m1xmExs2Di8x4KP9aBG6/lO2l+GLG
fccdV6RryRHeJlsCjG5hOPy/cEaZ0481zOAEI60llwdzScrmcQgoupBSradpL9HrhXPqwlyR9J/e
AFueC91ZZp5sDYNVDq4n62yDXVZ20ImLKUnZdGk53z20N4ILVYlc0quZcOjLr8x9nAm/yEW0BrhR
aa6ahbntBEWMkpKU0TwU0mTWBPySqKYIJSfxyEPMn2j8yPVOMCQA5pHGY9q8370f3SxfgAQkDBsS
ikMiZYv9wvumE/R9Ks6vRpHhDhwT4HeiIfN/SqG3ogvbTMpF1NrwoelzBC57MqVtUVWz+EeSsWX/
XzT3SmGklA4Cn69cIeD8WjDObZfGkLn6B24wLCygXpf6mnXDDEzyJFqg8qjUrobon7SrtFNsm/XX
GW/wTdV7ZUJmhlrcNOuMgwgMaiUDMgoom4zK6t2Pa9U2jgYR8stzeRj7bHkro+lopLWCZ2AuDKKp
CTsAOKg3/qSIULgUeSi3bA2yL9DGZSXPn3kMXr4S5NM42PkRk/461PtGPPO29B4f+q4lDZN9XyEG
KSbzGrjeqPaxccy7zFYt0SHzAQpR1AMRTxJYjFeeLkU5JEF0ybP7UzGUquF3mRafG2d5MglZNIKs
j1fZiDVUhLBSlgyja+6bKgtDeOiw9dVNyXbEewwmi1Q8oFbIZL5d1GaptK5GICNRdwC1J2M6JRD9
7lNaGAu914bI5AS6UsNLPmU+o2aDDQtccPDiXSRT85Id0EBSHHq3pZAVkL1KQAh1Ap62e8SL8S6V
YiXtmoZKHFgOUX1fEkgi9reSanDO1UqERzWmbS1DDVANsp9pJ5RfVWuGhJd5LTncv2v0eNdDEQP/
Qb9MiD5MAzfM8G0T9uijcXSouT+McnjbxjK6JggHrU1O8gEq/04wvpqNjErBMTbUbM6c587t6XHa
DBj28BamC4U10l+085tbz+Tx1Iwy2ijIcRLpT3biFYYCPGBdbcA0Dl9hnDvcWpc2TZCkIs0e44q7
SOjn8+jnKDNd1vke822r4jiCAhQCG5uZOhhc5wFpeFa/jy1zXxTCRFgp4aR1R0gRv8eJHd81N4PT
WKpU09Q3kV3ojVRl93yHOW87d1fc2/6ycE7d+eveQ5Hi/I8SAhKex4mrkOfCnzIxnFzix64OgxAa
LZ1ECBqfSbZUB+v0H/TosukHDOo2Nls8KCuoS6xuDGMB5IEpJHeOwSYMX3A70Y+/5aWP9xIuDSr3
t1Ww/r214AXP+qxFJjChrbaWxKc9u4kqIyXwI5UcekTHhWsRQkW2WOeMCG+elccyCWMUSB+ViyWN
VMNpPPneGVXMGFENEWK/T4ydkK3VGB3plmAGY9qFJej01gmIk7sIdumvLsVGN86YnuklFmlSUCe4
wyPLO3NTB5Sr+f6iEKWSNOiANj3enPRC/tCV+2n6e60skLfOWnEKnCSjaaTjFUoyElLLYhF/LBM/
roKVGRCC0duBl0Swi0V8D/KrC4cxqJgvKKkT+e5F79HuFZqkDT84qIFkTnu7MUPTvPdH5YRtQhwl
S3LMm8Fbn1i2eQNoXFznvFhaB8iFysBHbp1QyOgPH1J/c42CCbvLf1haYHEREIlcM2nlAe0fndrW
XCLNDb1rjIkvJESOOpjo9+/gMRm0dftfIAvwL4ZgPSJG1A4Q2zMflhC0AOLT0LJK1d858hMAzUw5
rn+GCKYKXgHnJ10QdEIjPuZO3gxoxNIJDcrrt0PMeTk90ELpvz6JbSyUwPR1YJw/FvawJ+i4psMF
wVNHCraPsOpmZ+bq8DZKNFopNnZBB8eChM7zBYU7h5d1LuAPNARLRB6hxg527twkYVjixcHWaLiY
otYQj+4IdlUEhgStxRuELtyu6zZdvoktiksVCYFuK0nRbbV71bj5s8vZg0JgDRaR042cnUtO6Gs2
0iqAJ//Si/taMa9qud0zDhosAcGUkR8n0lh89i7evlHndyUdqmvhRekj2rF4+ckxofOkQbWIoY5T
AZybFXA3TQqmyNZ4PfiV6TJ58+Km0uEB2fTV+i9x1if2sgCBzWHi9cyknRHQAPTjV1Ee00r4TWy2
b5owowGYgkEK1/Og6M/e+hjoOu3C3/y/KHMyPbRCCWeAqdcmvRRwcyLll0ygJbWaUTu3XNBkpmhA
m/pcjBWMQbj3FX3r0v8pCEKQtd1J2UkSRj/egHOC3bepzc/m4XTwQm/Fam5Udq1bKpkjeBN4BWSl
gKdgvB/gpRk4lgaha3dJ024kOnxU1Ci5pbb+ifBEftaP/r7csO6lUV2uRD5Z8Y4ee2EUHCYU9gW7
Z53lVTldpdTLhFPTVTpizuPXskz+3SdRo+hT31Zhnf6bozYPRgWUtCZlq4rnOxDDmoFJEZl+fFcR
GuurjwI43JJujw9IXAIv+wH4PhRDvQPXbTJLgDs8s0LtX8DWDQlf/EyMPYu+lh4JTy2EmxYnVtIJ
roytVG3rtrkTxgituCCIrH8kmt4dfg3hro3c2dF9bqtK+aSm3xdqANNF0PZ58ZPAvqHEm0nazBhQ
diO6WnaGRMIf2g75UpBasGG61hRaKTPmNSr8IYQYyBTPReOfJaOMSdjlNbrje86HAiOu1Jj3FiXa
LsfoOomVZNCQfm/EZtcugNW2mtkD41YTOQ+ZxRAOO1ymokMnCOp0MD/IqLBdf5eofwI4Adn8T/HP
1rB37OlSC8NFBmQYHRo79GEgOiREcalwobr2Llh1aV8XdEAjizI0iZrg9wBmXsfWTtmmq03uDUrh
0Uf1feRS/JUCAn0AZDZD89dJkiub7OBxzNA1h8ZIRzQQ80V09B3D+HIWaScvwbLjfAG7RiWg9Z8b
qED+SSQvjbzwr2TjRxZakWTYIFcJuIWCwu/LSG/Cs/UwHyGFJFqb33T8rSucRvWreJKnpYrUowSZ
zyoXvaBhZ5HmRZWMoKPCkiQKyroW2ntEmj61wqQfP2lyDew6ARNGiTCTx4TYYG11yvbe6gbfoamQ
lJcwZBC9sdgUd2G9VQkpWfq0axowOY4Ss1acZdvlu7wi5iA+oMwm7Z0S1fgsGrGsjF+5zRTo7RlT
IB35SwuP59KXsFi2K/QKKP4gMtOMOsykLhwBop1Q3DLVK3I8SdbvZDtwo+00aUB9EYgcovkSOjlw
TOb240od8bJ2R34vxZgNIK3yVBIy5ItfSUdFT7a3ineS1hnIl2S1xSRgpFGHAlPRYJ0w12X60pQe
yLawaG==<?php //004fb
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 ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199);
?>
HR+cPm6JeixEJnVXbrCtxSm6rnt4l3KXXqTQ0Eyom+0N7NCL22k6FsvyFMWZ+n2dxS7/e9pXpNg3
eMCO8eMSd67dg/vW7vGthFjEL8i84IgXXHyZD8ka2kQb2JrYpxukd8lqfqR2fDt2TAPT4QXETwpD
LcJJLvtTHHfTeflHYlHtaP8HOLgGQj7M0Ee6HuI1P0AnwmEVG8UFcrWoRhT8oYqMZa3Yxtq2ZTim
14TAvxO+89kygG642cn9n+7x78cuZSu1qgW2tukognlY8+pZsmicofOqpztTPZdFLr7lGQLfhhZN
b/JCEVTfXTAzDDOgJ+xcpq/ETT/MTvzVgzp9e0G4o5vUaBe81A0MveyX7DcWAUhBlL6VO8Ah4H2r
qHfVydCOWMeXsxB0vzcOMMxBvg2t2DTcSviISBzBC6j/VhmSDUtVCeGOHzsxN1lGE0sXcQt1PyZv
lLUr02yrpiBZNimWidUK/fcHLACe66w9RtdMVF6j81e/i+ks6IYfO6vMq3bANk6C2eklFY5Y2Sl7
Hfj9h2vSDIwJAkXlEUpwb47TbAq/xsBFaUKUcuvVVE/95NFTGHnRD66j3NUMgXAesU7TUlfu/L2m
VHxSVCOMuei75elGJY3VS8ylCkAzMuJhcUqH1rAd93fUHJKobws1mvnWgXI7ijRxQICdJzhl21L4
sjYfJBZLMoWnMUbeF+imFoh5wkiqyuVTSwpqFz3ODd+NmZKu8AS0Wh7BWmMV4TpD9k9BygBCt5p7
lSqKRLXgX8ZH7Z5Wh7MzaFWN+5l5yKJPVH4/R5yXCiO/ofAUT3NMbM1dpvxmS3H0WqgfVjfhr2z4
w0xoQRFHJebgS4kvXNr/ko6IgbWaxnHKgTKdtRXnNcvnechuK38JpBZINfg1DTFiUEu5Yqc8SclQ
cDrmGWLKAZ4Op7R4TsgaTbYnY9XkGENqmiwAGnL/E3Q77OMwvV44UF0xI3jtur2sgdRBMcwCjTIv
9V7b+L/I/zZiYDifa50OlqeOnbJHKGklVa796v7bODZIdIKFUqvaa1SmvaFXoTL9nzYEFKSRL2oF
0u8pIok95e1V0W8gGwhqL3yS8CQ93axAEbo39Z4EB/Rdu/kI6SKxRjAhugtjV9f1FeXj0g6Rf6Ii
t7O8p0++o/kusk1e8BuiCm0jRpXDwzJdxrQRL8bFvpfHZdwL4ITWQwElrXs3Dk5f0O3GHDE7QGws
jUHuiIWV/SmdpH2nqxtMMtEChdd5KGoUfQHOcSnoayqoDXUZqlIG6hm1Xkkmr5JQ4FUZiktiacPW
nVCdqQfUmaFRufQPBg4QEgyrezN3f8nTPzzygf802vFl6+f0TCHtQ0Lz6rIb2N/TWXOVVTjSxk5m
LPBPVcln93gYRhK4fGMfAwssRtUpHFGF+euRFvUo4gi2BvBUrWT4j80fAIYBZzPywNH17LyfbxR5
wDgiaaoU+AO9HpZdV9CFEdUXC/fH1lTfgYTTtabXM7h/4I6zOt5r4QFRRh58wFPld491/a63xIzK
MopLYOrcVxg1EiI2WYLRsQtOW/0kkqpvi782RiapqhdKXID5IWJMJsNy+5shy9coCzcyrMORQ4Xt
WKv5b94hXK0jNnDY7lM0s31FNorsiGLHZQqrzY1snteDSBV1t+I2dc1Uco/HQXLRfZ8XmnlEJzVS
Yf5PNEumu94dnPKWD3w0Hysj0qfJMYNbRiezqnBMx6WQX9cH8YhUFU8j5yNXtSkWzKTlyNp4MThE
Xvah26vbkNbmc5KhI2XAZWTTLzisT4QxPvOZYcztTCM67N2rPpxNsqLJp4AlmTSbkdbT0n6gdfD3
OMkQSvyT48Iw9jy5N1b0VIuceXJKpJwcrkFbHoULcYhP7jsyzQW1M4HPGtGQw9j5kpPj7YJkPZND
fpicr12GjDcljHajd4aivXNoIXmiY7+UnFXkUHMy1pZdszu4LJlg7z3KDd/E4gvSn7nL/866QJWB
CskDR2K7NghPkcq1xgm0M4FGZ8z1Djp16cmVrGD63OTLSqbBEAiW711ObU6d2mwmkSXeDqEbJrK6
8M4d6GTbbG4C+7YhbTJc/vIkClDLBfqCUlK38KUoQTsbsuS0XGwBb/3oyu4BuF/nYMUaMSESny5P
elGCWbnKmTcJ3O0OjEmXEdgG2M/2kAfN99p2VRmTikfriezmVYXGklBdgrwu3ibb2tX0Be1kkGWS
7WqaYk7H1g3GZtIGrqnsUU0fbO/pD0Maasdv/Ssse0CmW/gUxUkmcFyMcI02GYDgLa9QHIjJPSZ8
TeJDzmlqJgmXSVXw63JJV2Lm4AinNfrW/IHbcvThI/kDn8Kj6PQcQwPdgassfzAosGlWT4wPsKYI
u5GBGXO7zme/oz98CZ7lg+OzL5nTdMnAz2f5kG2F7F+5IcPLi3KThGw5xvuXlStmiWvl5dwxLzjI
0+txInIaRpTfm//zZ5PV8GL/n+9DdpKSS6BlG+GMhitRRGMzBwAjAvYoFTl5LvUxptLZiZdbe7Eg
IhqKHNTMzcm/5mYRPFfBtB1R0PH5oydYmH7RiH8+J5X+FbtYrPqE5IuzjRaPI72958egPDG5D1Re
jcQaWneqDEOvWEK8fQZmMIcTiI7pACgRconhfPpzVm+TZLVqqZ3mnFIhjKHfpVahpQkapR4EeYZr
z0sO0MYbNix262h70KtbkcMk38FSPSgqM6Gryw+IPnxoGoVmBvTIvvwYIaEXTIJugaQ61HTT0ASU
D5H7/u01iPsTQYIdgm9oviuinAbsZfyw/nlJhOnot8XnFJPOVj7VgZjJHdjHgreXbzSWFGIyLoHg
dvGj3dxwHJl1BLwjH0kOTuqrtnunrk1lzkOFCSKmVjTUvehLCKbhSaicrhe0sPgWFIJl/TOpEurn
GwHlhiGnQ14UYX91azuugLsYeZFL6NLHkROBIwrV5S8tGfP70iDmxj2x0rPHWNLpN+RH4/N352oH
uc6nUjuFPyyZVDU8TYJkVUG6J0b0uZ9V9kZqLvJOhALe00zBjYr6cNMH8KiYGlJqUsxtrxoRrC0P
PwEyyYo0fqa4ubThrevierEX7GYOWjo6Cg8s4WfJRnZ/jB59bxjqhslbt/8ioZSpG4pv9NNQqqqE
W4HJAnp7UmMwDzRbls8kH4tm1HYblYEMJfTHSsKvU6xQ3QgUC6ZdRjqWEao1mEcLDX905MkWMNq6
tEQ3r0IySn/KlcuGU03hIp08mX50YFxQXlJI56JIlOSzUkk3XL/m9U2w0rUERMchyWiQp0XeVpGx
L4+PZQtHQPsL8xAEexCOAXoOOnHy+YdKh8j7m9J8E5/6hdSIErekBVhiq0ygziRE+bFHmA+9QqqA
KkvuQLW0a3PwagJmQTGK/5SUixrNdrMiEL24tDeDqvUTa/G9cl9V0KWQS6njiNgLoUI2MfBCM962
m5BhJO3o23fPPfgaxnJ5f6jhW5R2HngC5b9F+aPSS+7KSegezoIokk3IiO5xAwT97gQIENeYHfvr
TY4zWtqeDQHQOKBwpuF6WnmedENbWoyDACLaviKKwc7py0tELp+6iFSCeGRztt0Av0NtizMRoVww
ACty/H5jzF91aqjWW5qXbGt6QOrf8txnbGjy4M5s9vBq98MQ0zeYEN7aH1ux3a2GROQj20jraeJd
+2YN0EINx2zWalyknI6394QdNj8UUDi+A5Ch+rH9UsyQAHPW4eCAZs9tl/tns6MYPBhJqMjW4oPR
4NYxBS1DKCYwpYcuK0ap0ONQIrP5YkS8lTdbP5VNo6W3pSGL/uUh2Bf8iaOUuRiLyuEDyVq0X9HQ
AEZA366B45jRIjSJE5EVPbakV72VZSvNL08XFI650AaZLnaiBBWNm42qZa+KN7Jd4Ks9ua/fCyno
uZlhIpBuxFeHyCsPX7JhoMSpVRC9ZKRXn9DA3GWoZ7LoBO2098WSANfaXgzAfbmuDEblAo1Gr+El
wVrsmqfRcfi7ChYOMUIgt1U2lWVsLrEVSaFNGZldDgi+ctDJfTixqPpzLCCL5aiSjH4unuAjffoN
bBDOyiUEvev7POXkfgoVZ7kTjiEtaNuG2zTIdVEQkhNOb3dxA9dG4g0k9X2yRlLe3GVlEJQLorY2
NWkJiuPFtLM44QZYLLofxR6zDtCu5w1oSB9CFhXNSTkRRxaBLFBcXDSfRxLY5U6Rd5o9O15VpuIp
UwwmFLKEAR8Blezk5PcYC2bDhelKyaS6FiwKv4o/aZIFC0wPK1O9PSnZ3j6XcUPRb4stO3l7RSyM
r5NCLiwiQlsF+H55KryOQqAuwOTq/0y87JLFbS0rUX+288kKuu0Ipx2VQUP0jQgwiNhURiYWvoMr
xjW9kpz6irdcrV7mnFcA5A+YHMibXFOK8JEGP1c4dmvOTtB3MTosDXm0DByR3rBY5ohodiFtRkEz
w2hATwV170BgoJsC3KV1xOvgRZdkjHl6Vji/h7Eb9ux378mmMa548//Q/adnhPz/LxfUcT8W9Xc3
GvllpkKOrf/4q9pVhfXK8HqOt6yOCEcRhTsRQfq+MP0Ff5kyqxaXMpGkbTcR0yGN6ifJZYJeB5yr
i+zVCShfGmwbFgL5DuNEgdIT5+R+H/vJKu6m0gtvb+8R7T1gpZW0Gw50KM8Q+H69stjNKvr4D8Op
c2nNtsRhdpznyEt7bGTcYY4UH9ZncfHXaUldLp19yoluAfzi6k91AhykRCjTrmLk3bKpSoykLvIM
LThYaJT1Jry+BE8M1EimrXrywZHH/HwR1n+dRlDEmSU5vWeR26udzrkUPJrqH41zRdbQ+fqBCUzd
FspLYohrzeYoUXCw/tr2ALpAzS7B2oT+oxNwlCyKD0vaze3FA2uzAuHnPgGW8vn9vZLcq6kYhVAq
THvU7t6i26Z8qADr9ftTO+TleCdphyKofs7zMDP0mwC1tDzriMROEeI3g2kbKhWIwgYj91rXrDTs
916kb1CGPmbNpH5CV66weYyQ28UC7UnUjoAH8JJC4f0Gmandf6iqTOauNL1rcvr4VYZs383fNsOZ
J9+nDaoV9Th5zEVLbIcuiDi+tjXUXH0VIFfQX8MDXapArIs6ToKRihUuabA9QikbaxAR93Vd56NG
srLpLsSAtjePGSjvnFWQlgigTHAwFRMyENnukkAzqV6fU6mDXRMLP3raxfcUSkvgic1uPsZOppgj
JT+GljhrbJHb6Mq3ru7JH6lLqHE26H8h9HkJ4XriAuun3JkTivzVuu4Cl8pgunypq1XF+jBAyxua
tBXIlosg7QmUv+kl3B+wC7ikMLnTBNdYu576+PsU3MYk7NdX7t+jGI6+i0jyxaa0r/umokCnlsiH
cB/G4dbfOOGXGbFO6Ji8gSnt2U2CqjFbunPnVYgDpcQhQndmUdn/zRZZ5N10+RrQ8jQhSpb5H6NE
TEYDhTGf9/WsOaum2pNZvsWSBcemrOsU536rpyI5z067l/IGPCquon84skNxwSU0ur7L9i+BepJT
2mUgFJ4HhyGrUJfn99OLXPjbM/z81crA8ENSiE5yBE4MIblSGlv8+aHU2tT7/ufoOLmXOSPH8vw4
AMZbQPoAqlOgRVreLXT89JUWqFDy1TrGhpYp0ukxdrZFjhfHMYh491O42BGUiYfu8eqSqSh6Uqp/
5SRWnn/j7+aC0zaT1GFKg/Fk6cuA9fxeqA12JoM6xwGCFntlSMd1mJ9DqXaJ7q0FAHEDw9yj+9ZS
WvzSEm6AQUuW0dFrCa5gKvvnTbKZUV6ENAgavFdJnZg5V4vXjDfqZzT8QyJmccERQSph2/zV9mzk
vSg56BtL2FgpqZ+WgMOAgGRCKhO+6c4qMI+46MenDuhGHviWZzufMJI+MAGTrIq3OMCCi5nvlc+z
zi3hIHQG+hpFpPgLdW73dst33YB8UtMMKXfzAMEi9TwWZ5UHnwZzjj1+k70FvRapf7o+3NmhgDlB
naOlKf1IWWildaYcTSXUIcinAFMgm2KE7CJ7nSbiIZw332r5Fvp71Paw2anUeH54bgCrR4q2lwaC
QTYNrYA0q7yXY+hT4+uEnTuDMJ1EiSc/GmZgko3QHaqrrVyXaeUB1Cz4/xVFP9ojZL4NLrUvw9lj
Nzf6IOPUQ52yHPpR1XEC5Ato8voH1KEqAJx7VLIdGqXG5b/be0j48lr5eLuQ/8mB8zy8271JrVFz
do7D0uCKh08s8mD6UdV2bZuk2jqcSnP5tpKNkP6s6qSftIlwh/dHMOpTrgXrppkENvYLBrVdXoWR
aoGx3xvT7fB6z9u91aJjPfP4hKxCZ6I5ki7GzKgPZPqRVoe0fTNRf/B/iqruwp7jccUzbcusWwK8
NBJyB8jpsDXrL1+yN8A3OuKU307TVq11SFqnJHnc4vN4lP3kq4F8m6McbSX/3Ts647e26IezXKMU
LfZDbgL+fHheVBBm87FNChiujQkCaqR7bVVzvZ5CtVyGVtWDTKjJdm9U8uKmluUJ+cewhC5D6jI/
ulp7xqaA4cXpgpDYjH/VkYY3NavHElzolqNhBShfLeOdI5wawOeWVJN5bgCtLY2Ypm/00Aexv6if
7lyl5j7sLvwsEYL/CdzfBc8D6528Tl2pnh0tQg4FYJ6SyJ2Zx9lpaNrJ01p2KffIDTj1wCvcsP0t
b6CJpBwe7FDEJyaUG54prdZFPeNS/QVwl6Y0p0PbSI29pTV2qIzeSwapKcmLaRql6yKnX7C8at6i
H0o18tTU0tHybZ5E2ZCePaiQDwz0K+ctsFGeBJ8izmwllwUKOyOVm+vIoXDPjATOCv8jp+ekThtt
rszFZ1D1w+IhcDBRlDa412D9h0By/1lxsVb35WfgLrY6dK01oKW1NquZGu4qsU1pTOf7Hob3SYwH
T1VGV3voEVZi5TgcmdcMnMaM2LzohcNFbFG6Cri3z7lVR2KJYvhLycUwe0UyGomEUIxo4obu+XMf
pYxX5yUrJf/S+xG0LldRXJWze9uYNFpQ7CwtzXW7vOffMZY4a9L7hg9kEoaMCsEY6uy01lkJHb4z
SW9MsKrGqyvwVetROa4tr33l7gabS7AR6SUdxHWXQJfcmH/FCQEP8b0hSsBJyucZUlh2LNN3wDnR
MTUpjUpIDWvjHxV4GleN3g8ZLrtI7ucnLhvIR3v8bibg9XnlLYksx1wuZyQV6CgIufs/6qlYBrir
R/QSqo2cmTp8ZI6Z2XZhftvq/58GHxVb5Y2M7ieLe3bXEr7R+0OujxFYNmsq08U3VnuAZtO3Uliv
LV6dZaJ/hyM1wnv1T5i/0B0Kc0bSaze7tWTaRo4QxNQ+G6nDz0BAMmgd/zRyujKPV9e7OAXM+oUj
Iz/TbJTCd599lMKnd8I75aNrvyj5BPijLJxyPSf6UNDn9AopL/3LuNcnYSxf4uIMpLom07EfJ9Kq
TvIvRNFT7hRMPBY1d71YYjOR56azUkqc5cBh7+0smnVILU1I8quDQzk/iJaCrw+oV2cz9cLLDRvv
tVp5VowLZQW0x8BxdSYlmn1kFTKcDm0cLgMehhKnMgCD/o7oAJbD+tCt4pUieZ1vq96zG6653L86
0BNWihohGc5KAmuPtaM9iJxBEbnHykWk2qHGH5Nel5oa0mzsbiyfzZHVHcYicJs4Vt+3ZcjK9ssP
B2RsFxz1P8rH7CwA3vGvP0IDJo2o9UC6JaMO1NrG/3P/rzWqVlJboVC3L1r1uvVviGJDHxoxIFee
JDmXYVwlC54Tu/mhEDlk/chPDSwRfbnLYu9oCa9Vu7a18TG15jCeTzYuUQYKz08oOCdOXu97/VQ6
ayUs/lLBuCWbDQtt+WxkyPhzvUKzaW5EL8lF51K2G1J3ZEJWNe4k5THkhCrE3ghT5KCIPwYtcJdq
F/T6ZKzL7GwDW+3/5duNlCOSOrX3fUraZ4eTipCvCn5rPRwS5YehWVVIMFCHoeVu5KBcMhQLqycv
<?php //004fb
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 ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199);
?>
HR+cPy7XJGhFPBOjbYhOAN3/iJc0F+9UNshDIwMuiOxFwN0ZHhkiMUnEIoB0Am42aFSW+Bxs9+7L
nYzQVUAkTHFMxFldOGcxcrH5yDKcBaCrdt6P8fUHwsGF0TVyJbDHAksqCGKhgAuPzd9hnwETW0zw
8jmVJzDyKOeBgcFa2QeQlAVrghtgu8nfwByGCAvx8KEym7q8uMssYQtSHnqV2fWe8FVrtBfDcL+W
1Y+sg7uqTkb709cYKZ8C2ZJO93D2PL6t4P8rYxAh6+8ZxEFR2oRAbZJFtTndOTSgz7tQVdxQfTUN
zCnogogFdSv++cXFGMCOp33RDbyITNF5gTj/beAFqBrFpcTOQYsxv+kIVms3Uog357Wiv92Zfmb8
3MvJvQ1/dDIuqPlSmmAlBnOAwJ5+34YQpBJG3IiAefanLNJWDJwQQUo4zN/yvC3SIi0+RMgkItC1
nM2gq2nrpqRdIuDiAyuNwHQk9ikLPFXTbnRmCy2X/dbvLHxHYMfWhMQIvsjDPd1puuu1fj5Zk0Q0
zOAxR995CGf6wK1KpDtOfwhsaMq68XYV+YDst9+TpVBdYWCYeZjHOkCLzGwY1GrsRwOd6KGxhn26
B3829psI/duYhWZIUHszElqaKfesucmaJd6fT4bHlaOnsbi0z5AgvEHTx7fkITDEyr/TtUMz5Zlb
VXhYvn6l+QfJMmKGdqJuIEiS0FQ3b43FJEhsDTibQ7pSePP6CwSarX44Wlw1fMl3M+Ugu30SdxB+
Gu1rByZkq21Tn+6PUZVh8frtmKswFYBogoc+wbsidRBFJFfowPOn7FAQJ3wGMvIVv6sZzy0B071H
AGFZI3ZYuOFWh/3XHn3oTlCRIYFEd2Zl5Nz1XRIx/MQOPPBfs/UYNptaKZROAYxU84G3kJfHGSF9
+8c0kGerqAUw16VHrczKmJLBsWxM4CNoJWGBsyA03TVb+Xai/SrOIugZ3ChZXZXjbUQuLYv0e6Ta
4V1Aed/tk5M1CChXyi5DPlTuMiUKEhYhIs+kWjFGnPAg3+dWjJZ+r1OIxQMz9Dcs2AW4RtRmwneu
0eZWB+WO4avcTwpmLPzt8SAkOq4r6tk74ZSjRAq3jSyiGMirNwtng6shDBSd/0/PynOtf/PLGjV9
/spNlwIkhUpxlNkasMu4Hhj/IPvFORcusNeh98ueajpJW/FDJ1Txdj/vZNXKQ6CvwDfurfAbZEaH
WqvU/74bNRIlMbAeVquOtOqla+q7fMYVYOneFqIEokMdpYBHyFnVlmO/OvzNRK4Ncc0v5U+b6GoH
tSjQuhGnFh3y4lzGNch3qPa0Vo4zyfO3JDrc/AnngTb2HFa+oFKwSmDOt4owc9DiCV0clGWz89ph
HdxHFLXhXvlVYaukYyN1pLecWYmhu1XYN1Dk4mvedHPgE52SYVBO9bg3ErSBYwcubfwmTLlZpa9s
8JSm7s83RaPQERdYqyANjzfPCrT1jQzPHpVK/FVHShBhYkPQA68rNc8s1ZL0Y7tXk4nOdSHBXKjC
iEasNB9JWtfRji1ldkzx/DOesKoQaLryj25STec6JU6yh/s10QFg/ZeHauWA+Kn15QdtKOMPMhDT
6piBPq6gSyZtPIpG5nQ6w157bmt20rjDByxE871hlbLfoKsY/y3VoQ/3iHrFYg5xmbiKJU7tcu/5
8rlBwiukvbfP9UzoC9aJHHNcW3JS5QBYCWpnZTN7G8eakXt/V00HFOvhyyyhK/YAK79AY/iZaABm
73ev1Y5ST4HBkFLesC57+mbfpjMluKqpTnIewNwEp09kHIOez/p55pKCg+LJ1XX87mi2q5nhjn9P
hvybsE5HaHzjZNwK/+0kR4cOB98TS5s6FI913cOc2Yk1fznIPFz9NQLMnWgUBwzGmg7MObo8dnYC
wMQvgnZbbi/7+sS0RJ7NQ9xhZED3+ZtRu9/oH2G1xJiPfc0hcD3ZZfln+JC84NgfajUcu8IwoUT5
ffZWD8l8toKKkfLb7QPlrtkZcTIAWU7mj1PDroXRWipvSkCaXt9yVZB6YGovI8lpb70qHCsauUIg
+XS5WzRpHBHaj4tqdamgsE+QN8xkj9SDaPsDvX+HLrWkwDSt5TUwbkZauINNxtocrvcZ2I5hgoAF
2SscW0PSjVXaT55y+EeSMK5YV7CGvgLL0Yrf/35iBZbLq0xDtNOc0jLBC8BE019qaP0zDmtq8zsv
14i5vsC+f3/FaF9YbZBhSA0wgTOZGWpUE2jjgrgWXrGS2KhthOlo0WzW/yPxcHsvDYRiLTtHVfqR
N2GKRsHI4rYuT+PcbM1s35s4e5yqJD/ZZEDwQYlKVx7D1P4euKRxZL7OPgLnTUcnyQOrQ5FcNlUM
L1fJZ/+b1sj8ogctxYvV1v+1FnNCYOs6zenLo5f/QlOPpMbMDVKU7QualCkvl7fIRN6hR1jxrTfZ
TUc1wE2GSecFitzE4y8arzcSdumf8+RvowztNSU/0WEmloUefHfZw9L2YD9yH5/jkyktcZH6YUbC
2CQg/owt8RGzYb4dtiLroNgBgM2fT2ZqSH1XnFVDz55CRZMY+hjTZo/4bjxgLzSO8sk+QkdYEyjX
1WIuPJJoqnYw5yYBb7/SRW9sN2p+FVUzzOQ4kxb8G45pQCrmQ5jKAviTwkyDYcvTQ2Ned9GgC4Nk
GilFX60kBnauE3kBJeV4xjUCszxDvVKeDPQLASigRffn1cu/HeduH8IxcTXd1l2dzt0FGKNtZWz+
4XXsJ7kEtSi/FuJb8w3VfZejWGd/dXBkLjKjaGiZaFLLAOsAH3rNQ4J3UvWdRjxhkHGu68j4KqhE
xJWnBhF8UF/4Y8s52EPd50FvdHXJ9XyTqtj927EJxL/6dsV8L/Ox6J3Qjaggz4L1s7jZsJ7tm+l3
Ixnoqa2vGBjvxJGR86OrRHV+tfQDhcmVQiTuUdvjqEF61vdqElbawUi07E71bjqqPEEj/AUZFmGq
SMZtFhEYPEK0Vsckh0rZlEj0o8kwtZhuOhZayyyMD31DL+60zJ6DCAggZmqfeJO5/nRczD6MyEFV
BCRP7tHYUfAT42xjIcxjd6BR734OxujYyJMnjRUjMH/9AMwiDcAEjCMND+mR+wxEUThynz6rguio
hYGzPri8f8t/GmIl1Gb1Pt2LwBczl3YqDFuGIuucESRKNhQhwg6tDNpVP3C6tGLMDvALypxkbSe0
Ul858kB4f1EH4lLNEulpcGEa8eO6dIkjJwkVh3TA2PuPDUrBabdKwpc+xmbxWavj2kZxnJzwLR55
IktoqpeDBduGKfROW5qWJoHf7IjQWCe5Wck39pO99czgth9jhHLX/HBzGTPZ/z6qpJbrCn+iLJds
5NNcC8nkusPGi3dDNQBzcI3oybmRiVbuUHpMY3Y+CD8kA/drFoZ17PcNQIG0vM9Vs4bgON01gb1o
J7z3zcADdPwE716u0I1DBoG3cVmEDdzCp6ZGf2HYs91i/JkCiggc+n2dhZumEXj1c6chkpqomPMV
urb8fOVNrcnWXXnob66LAuONyemDLdLdaCqN7W6s32OD8zg6iL+BoN/N249VSwFoGuUByd6xnKMd
NqfCHCj86Fos0yu/pL2Xfrwz2/d2glWRvdcJ7ChDZiMdOEHypYL7gg/LPfs52fWUC0yQg5lL1w1S
MtmmQs6UUcjStd1Lx8TPJW8Wq9mMakNc0ZzgvYaJECLQxiUYMdj++Ne+bLIKxqVHYQG618aty+Es
QepuAJBwnOiWJU8fiCrQUlL+KDtuPKqOYkc4oi+y5b8RrZxZuU3tvM85J6pJoxhvBa2KQw1EqWe2
b4IAZm3ys1Y7N039VY6OxSqPJ/jeIPyCMayeS2QbifmPKZqTYgfCy6rH7QmXFlNNnNFgPlKth4Pb
EgqwjrY5GOuYC5qNvYOLPp7Pe8bO6we76a23FiMisymGTbZr5ASLj+JqOZkhDkWg1i7t3NoaDNPM
LWvLTMSo+CpThkS7ieElH0VQGB6Er63Ki+AT0/k8/SVnOLtR8PfC8pyPrwUTrP/s4pQQ1ehpNZgS
ds8FVTnrtiLuTJ2tjX9dLtQyjdWJiqZ5E2B228zBMYyRlIZmJomCxXsLu4SOHN+IE2k/foUiruQU
MPvSHKHZ1FQsy0QgsLqWB9E+0ZDEsjGV8Ci4DZcXEl+rePzjrngYybj5L9Pzll9JSyLFyCfceiJM
szxkXSUkqz4iJJ0QZ8bY9t1oB6PBTQUzIoAcA+62edgH1KiUArICVvum0TyxcAu7AsVKEYz0t8y1
r27L7vgFagB8VyEDKONDEBXNV9lL/HDHGGQjM50CSZhC49wy0AFjcDbU8GmwDDY6n+dsRVwiM71f
Ifkq346XnPHO2HfMwTUAPSTQJFVKmhc8bUwdcLCHP8nMIsCMiUOKBCosoCtlllWpAhpFjNkGVYin
2xzrEkjX4zmnff1vvKAn7XyMDZz/Hj2cjtsfwFLS5UFgMwEs0ZRXA92rG10Y1AwdO9JJrsNOVt9T
nzKQSI7/sHwo/hHuARrUqUsCVV8H3YZDcB9ye1JP35z5bwbnicHKu8pzlSWBZvQ+C/OxvOLc+LPB
Ip73XTYc3r9mqh9FzDm3icIRcGhGIzjbNS9pgQtm5M37V6pvw/fhT9Hd9XA1BeEWxx8406rgS0i8
XcXAcdjoTpVzACjZG3fVqp8um2jEKMFdlhbMC6K/cCZqYo6mE687K2WOr200E9RV4ZHRQfvXEiVc
1RKkzKlP17sHeBqTpxAQZiRGk2dQnQCFj3KbwUA533u6kIabGyKe1J85MB7dr/sqDtvpbkMfDB5G
SkXJXNf0GE5LqkhbadSA5HbxAlvsh45ovlxgLMRyLfsJ+W5aEpByPRlVz0RYhV4ZFyfJEx4+9ZQ8
dceW8k8tYEygKs5bFLbDbP5/RIWnOTJAo5oocF7y8SVbKtLTAQT7RDKUJLcS6UhtM5W3Eg36rdO5
aS9AmxzoGnLB98T1NNKAKiIu0n3NrQ+WgXJI2NzXQmlgCkU99pYEZ/uxoETIm5LPVne5T8gNqRrN
uni40cjIOsU6wRzFa26VgZZXzc0C0YGW7qZWVGEnmLfGjMxc10g11ZV9/TfJRAtm7hBVJhYp8Nr6
317GAx1vPWCQrb8JQzHHZg5Tfu6HyS/LBEjopWmlvP3uRYCRnjt61WuxZhzA9RSiboX8fUjgEn+h
N0+OMrBXagOS0kOcKF/zYUiPug/EY9Jp3OHZ8Vv8hH8csRS6XdeMfwNa4bfvI7wgI02IHZze6sAl
dlp7tRn/YjSjpm4e722MCV2JMDtkaCqSDJbAfz63H26uzzTB4q5ceuIFEnHiswEa9yvc9Alc1PUr
yVyfvKZFCgBU9Nn10l9Ritn5xkC5ApjJxIjpxjYmYHklovyxFiT0cB2Dx9pN37Mp977i9QGOT63J
1wlodt7rbDTHmtvtpRUgA2qPdIAeQXJogADFt62Q4Y5baL0WrqhAyhOY3DKJ1+DKYeAF6Sd2j5Bn
f3kI8kmHOYGzUXjkUO1etWxe+9b9rsngQUiaxXNJfslESYXa3R+wzWXJ/pgKt8CGv0hgO3SXEe7d
+H6EZ6PkZt6GivzL/TQeUt/eVGs5EboNJwyQfpNtqtt8MkFa2CViWF9E+JyGHImtpqP+mLiZ3C1S
hLi9ePSObS5xNqC7SE/uMWcLqQuihmk5NNTBveAmvmcYLeCZL6nc1canQutRhWNcwnIjHFCX+qX8
6Y++6boEWRwWzpHQXuisUBNX/gV8pT4zGEWvvZOIRgnch5T7E866Kgu4NApcQ6agG+mdYVv4xC1N
83hK6R/BDARUbci8ZfmkGBXZ5zfDUusdrka80csmE8GwNg2OCr5t21PnbwXWiGazt91Q5ST6jz5i
ktb2UaNSshvKuGBut2dwwMZ5E6mcD06OPrBL7+84qLiqR6ZS89C7O6JjJbzY0+rN4LHr20Uv2CLS
1DBBmen0z+bUKyx+XefbY+MXHxjswX4nyQm6EDTISsXYPLUVwR+sEl6yqrmOEGsGIU+CI2W6H5vi
U28wltt6Nr3NMkWQk3OQMb0b7Oc3SI8a0Mg/CEaOYiYk5EGGdMs9CHkeEbuFkwGtzsFCBKQOIDCY
gbBJr4Q1UF2abS4xJVpQwxT2QQOZzt8mie1L3V2EduOCmH1Uc9nMw7lv9ybnR7dhz8mOxbilxYRj
EHih0cGHVr+WBupMhrPMP7PGmAf7GnuinHyGUJQinrv2Oo9IM8d3TmGl4DJvLYnw4RVKx056g5IL
92t1Yc3jV4Fz+IVnGp6TMvgjEwJVPkza+WOkpZfXDhEIYQ5leZsY<?php //004fb
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 ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199);
?>
HR+cPtkJW5V3C7cOcbuLTBWNxe2myi+IcBG8ZEXf9yBI7h/CncGKIO2/MYvPm9G8WxID/eFQqdDl
Urr69WmojO57osqZE7rYvo0raO36FpQH2XJu7fsQOGlydqBCLvZa22J5foV10mCmJMZm0A8JQKyY
QkTTeAouJQ6bbfegJYtvd5uzIV7FfKxxQWPyOC7mIx8G7i8Npa1FCIyPSTNPWVC+J8cDK+gkAPPO
uJTHvHSw6yq/ktEpg1VX13yeOxi41XGO9yuPYekognlY8+pZsmicofOqpztxOhckyFjOZecmbqZN
5/FCH/+y4aoutvplCwp1BetPocAFMo82hRlBBL9P793JasRIg1VM+evwcZsx1RcCE5fml5HlbrZq
IJzvEF+cfCgDhogeKEoP2BRCY93TlXdIWhjUGseW8VzQnR/qVabTWiLqOaqZOzR7mU9Jowb4RaMk
hAcCHFb6KCDXw49UJO5zv/PoODfvmUOeA1+ifgaGnUf6YYsxESti3m9JSePiGudXFhBlXJP+yqe4
+rsxx25c42bV93NEo7PcgBQVmLQabDyOmN1Sw8aHcWXi5sumf6ZmdQ35nii3FGGDx/XW8M8pnF/e
BSnw8gGwtTX+ko2ZwXIiM2VZkU0MyoLUPdtyN68wOQG2XFjStga7mrBVto9OHjlNVn0xTIDXyp6E
9nhxeVvUDKTd5zhrIbuF9R08AeUGu8xsKGwY/BTNZ2TwTOC+YyH9CH6V9KOL097xqBpaGUlbbt6c
Ni6U44FjxIxBCZFOWvuBQ6WQEr87/d2D+g6KPpitdspHLUqajoP2tBjlSwPgukQUCf6RHeAV3tgD
IReqTRYvtvGxrFahPrsSoYc+Ln6CzQy89INnI1373JDFPYwE9iXDBwHGPlqTCBFIJIoEcfrH9OAA
Cbaas0HavE5JC2zVGjI/hqSbPgxCwYHnBuc/QKs9sURTa6ubhV7UjACkf0vr6rqeQvDhHu/xFr5f
H39O4VisG1F/26V/wRtfafuhoC8kI2yl0HlydSaQACi128994rTr4UVi9Z1SJa4Qxa5USyMgUykf
6Nun0YZ/5wvsi0urLhHdgynBaaeSo4Ivw9qFV/d2ShMblj0JzzpfGXqN+nLISws+AYnMvWs7VX8f
XYbYVso5RSgIQEc6HMdKhk1rMquuVJc09k2kQooBM6rkwA/bzxdCg98rU6JYOW1gte7+nGcah3/8
V10aTFRozymRR8C7QNPDQTa9wgymRBTjrZ6sYBpdI+JS9+xqbl14XEL+qBVPjYCJrOHSEmZ5KzZh
RJM4XpqTo3zqoZ64OBWN9drxQeO/gBeNOD63U7k5r+Y97L6UUl/NIyv8T+d8bjT352jy7QQj1tyn
reLcmPSGZhn1Pnjl81WKV1lt2BigQQcG6xgas043mmR0ujiwIwIZ7AEUE7nVLksCj3jWodeWlCKP
yDlFrLDEjnUxWAFpYSJaMz3Do/+tDcNAvvxjmpC4yeJS5Ecv/jvGH1bqYDzr8tBesjgMeWzZ3hOc
TSoQpB2Tvh7xh/c3i5GS9Fqk7Qhdi3Wi19UrHSTNUjH7HuYQXMeXXjMkfSQulYuqlfVezq5E2z05
b/zN8w9YyGiE9zkMFLMExA8x9Z5S/gqGdBtzfcS6666WiQuMUoWY9RCTOfskNyara1EWph9d70/4
kveKlkqRAfSc/ufkaObjVOJLa0ql2/xlNZ5RMqH9XIqqp3bZDsE2YWVUnb6u26wW5pd1SaBdJWcv
Pt5GWof9emDV7c7cUv9FdvrQ4zLfWRIlrCSdLMdFLKBEfKqQXzty8cPGM/a7PWN5qwldRCqOzjrn
mD6B472vkpd1Qn/mlgQQmdLf8Hshu3kLrzrWl8OmP2i4/A71ymxEBNZMfdO7Twaf51R2k0TAXcaf
w/NEk/Fe8sui8lo/tZQxzERplgAXR9+rx+Qzl/u3vZe6yXagPXRqUymmMhYjgExBnEcYPhwLfFs5
SHeG6S1l8XQ4jZvjX3fvK+Uo/p1tmhFGleoLceLlH55xxbFlK4iZGL3LM88PeDRp9j12mk0UXTVd
LbdBa1O9/Ud/DoYOymlLDrwBDaCDrSPRvTLKYdGRXH3b8uEPR1hdPc3rkjTTvmuRZ62AG3O/Soav
5MQtYIZQbemVBh8eC362t8r8/niuAXupUu5McUfblGAix+q04syMNQQtAjPooBosKnCTM1SnC1c5
Rqzpq6evhePaOcWHXHnuXioVR24cD1boITaOeSgb+oT3RoqUwgT9PUtwaMEHquMZrzs7A9t0d0ie
oG4drLyqYX6EbK37L6DP1Lx3xCb6v9UIDZJbscG3ctAcge01pHGAJludddWa/KE2zdKIsESxxfFs
gM54mII66kKNiJJDeG1NvICp23tJhLNxBR2vFyLQGRA2XK+Gn/OMct/WjEabrxswD6dFA8hUnrIH
S93c6cXsbrXoVBF+f6kBmxDkzZ8DxRZeY81lbc8B8Gi6UKGYIqLueRXP7WAfLt0t6OYZ1tlL4dWP
rA1jmmiQePY6OH10Mj49FLgevO2Q7CcS2GTpwDiix1IvTwKwu5AeUHeUNrLgpoMHPmQTlGYvb4ut
9SfEBhdvmPUu3QFjKwrjKoXvSSsKOwJuz1dDuW56KBdhE9r4xw7eH0YV7iLojpWUuEcl/1sk6iIo
iIwfS7GuUuyWVogpvHuVZE36p189YiCNaGt2cbKUcuTEREun82sp3KJMVR/l139hy1VHkbmtNThr
cjWceMCdtvgtTtt0EyVd6Td/3Gn0TybOQOyhRmum0X/ZgTgSUbBdPab3RMqKdw0+7cJhQTZzZvDq
yOOHiAgbV7AQ5NDChr5SEeShMDA04+xgsEjaUIeLVJ17B9VbKscvGA2bM8GdVPNnUTnzDGgglMnD
Hi4qn38ZySbhx5Q3UJdIRc6UNouc2DiWXDFLVLN/4MlCRwtVVI7e8uytAkcQQk8c2P1Xez2h5Liv
UZQwYnBDZHLB0+7Xgd6TI9Og/LWumkIxqJxiQLwJBs8tnVeINCZdX6UrsoOH7cgs/MwBSHIa+gBt
GE9RLLl+jMByTy4hUvJDdNbH8GHYsE25OieLcc7VKrwRjA5Tlw0poMH0xpYTcT5cAbowQxuqGZbu
2ONbDTNwOxsDicJfR5dJTgYrHyNwcS6e8kpthDRQ92VjCfjpGuPQ5PO51MCiL5S3wNsmxIunKHZM
tqwE/Ez3A801NkLG09aWyuBWqWcKYZJHX4VW19MqPFHJgYx+RsQlwsXHK/OS0s+WCFWzqREx+iK0
ELP4Ayx4GBN3cezfO0f94RsU9qCvWTc2OMzojhxsvaGl0jQSK49pqdrqt7s31hNGNnNE6IGbXDjH
7mrs4oTaDVhUsYWYv/5STd/X4XFlWuaU79/+p0CWKfZEPv2vB2Xo+AA2AfO4uV6y8b/GDuQUf6OC
QY4A2VbD1lttBFqC9PN3tAzotpO3UUwAYAv3J4me94sDFsYYAbwz4aPSNZIviHRSJ0Q0ksoknHdB
5r8uZMqYtkdeVPw0vUHpUxBCm3Z3+PCrVMO28XNYj3LPvClkoNLrz+Pf7yco4jhR2pfIX5fz/vWE
sZxBfT6SdxwEjOts3PFoKBS1ihSN6AOG5ARIUTntIHgxcBbpYs/6NfKXfCGKV1dE08K/OZH6WAt5
k9yPeTal4rlIHPl8zLgj2g6iPcvTTA0/MMYWC4A1aYmp8FT/ns7GAmBYlBbu0y1NWXu6DFt8+hJg
EiZSGnK+FIj1oF72FemQ2N6qLyS7lzB3I8gghUZBhfBiaGFknb4Lhhc0zCLXXxer6Bo0IgFez1J/
8f3HtWgWOkHOpEeeUA5gTvMlGRg6tTbNqDi+bVamGaNpL2djE5x6RLNk4Mb+FaqmYDS8oXlN0YU0
SEaGWhBvFwQOQqNzRf3KPVbwIMPFKlBB2+UuV8Fe+SmNn3Kmlt/+NNIr7MpjcWX4AfMv7pshfFAz
B4bfIadSGGsrlDshpySpu5d5tcOGJDQxf9ItULSWr1q0DHRgNlLUyMeQb5FburdCTdfBdGsgOyEM
3cfgwE5tc+L6OEUJvFj1HKCYK5UTPh6eruaY8BwzYJrsTPc14MCc6NX4eSryE1dIG/IhluFPK1d7
lrMRVKg9o+yO7363q3GPAVCwW82/fukUgG==
SET 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: `zenario10163398`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]action_admin_link`
--
CREATE TABLE `[[dbprefix]]action_admin_link` (
`action_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`admin_id` int(10) unsigned NOT NULL,
UNIQUE KEY `action_name` (`action_name`,`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]action_admin_link`
--
INSERT INTO `[[dbprefix]]action_admin_link` VALUES
('_ALL', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admins`
--
CREATE TABLE `[[dbprefix]]admins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authtype` enum('local','super') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
`global_id` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`password` varchar(50) CHARACTER SET ascii NOT NULL DEFAULT '',
`password_salt` varchar(8) CHARACTER SET ascii DEFAULT NULL,
`password_needs_changing` tinyint(1) NOT NULL DEFAULT '0',
`reset_password` varchar(50) CHARACTER SET ascii DEFAULT NULL,
`reset_password_salt` varchar(8) CHARACTER SET ascii DEFAULT NULL,
`reset_password_time` datetime DEFAULT NULL,
`status` enum('active','deleted') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'deleted',
`permissions` enum('all_permissions','specific_actions','specific_areas') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'specific_actions',
`specific_content_items` text CHARACTER SET ascii,
`specific_content_types` varchar(255) CHARACTER SET ascii DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_login_ip` varchar(80) CHARACTER SET ascii NOT NULL DEFAULT '',
`failed_login_count_since_last_successful_login` int(10) unsigned NOT NULL DEFAULT '0',
`first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`last_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`created_date` datetime DEFAULT NULL,
`modified_date` datetime DEFAULT NULL,
`image_id` int(10) unsigned NOT NULL DEFAULT '0',
`last_browser` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`last_browser_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`last_platform` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`is_client_account` tinyint(1) NOT NULL DEFAULT '1',
`session_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`hash` varchar(28) CHARACTER SET ascii NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `authtype` (`authtype`),
KEY `global_id` (`global_id`),
KEY `username` (`username`),
KEY `first_name` (`first_name`),
KEY `last_name` (`last_name`),
KEY `email` (`email`),
KEY `last_login` (`last_login`),
KEY `last_login_ip` (`last_login_ip`),
KEY `image_id` (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]admins`
--
INSERT INTO `[[dbprefix]]admins` VALUES
(1, 'local', 0, '[[admin_username]]', '[[admin_pass]]', '[[salt]]', 0, NULL, NULL, NULL, 'active', 'all_permissions', NULL, NULL, '[[regtime]]', '[[clientip]]', 0, '[[admin_fname]]', '[[admin_lname]]', '[[admin_email]]', '[[regtime]]', '[[regtime]]', 0, '', '', '', 1, NULL, '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admin_organizer_prefs`
--
CREATE TABLE `[[dbprefix]]admin_organizer_prefs` (
`admin_id` int(10) unsigned NOT NULL,
`checksum` varchar(22) CHARACTER SET ascii NOT NULL DEFAULT '{}',
`prefs` mediumtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admin_settings`
--
CREATE TABLE `[[dbprefix]]admin_settings` (
`admin_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`value` mediumtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`admin_id`,`name`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]admin_setting_defaults`
--
CREATE TABLE `[[dbprefix]]admin_setting_defaults` (
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`default_value` mediumtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]admin_setting_defaults`
--
INSERT INTO `[[dbprefix]]admin_setting_defaults` VALUES
('cli_sftp_connection', ''),
('show_dev_tools', ''),
('show_help_tour_next_time', '0');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]categories`
--
CREATE TABLE `[[dbprefix]]categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`code_name` varchar(255) CHARACTER SET ascii DEFAULT NULL,
`public` tinyint(1) NOT NULL DEFAULT '0',
`landing_page_equiv_id` int(10) unsigned NOT NULL DEFAULT '0',
`landing_page_content_type` varchar(20) CHARACTER SET ascii NOT NULL,
`created` datetime DEFAULT NULL,
`created_admin_id` int(10) unsigned DEFAULT NULL,
`last_edited` datetime DEFAULT NULL,
`last_edited_admin_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code_name` (`code_name`),
KEY `name` (`name`,`parent_id`),
KEY `public` (`public`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category_item_link`
--
CREATE TABLE `[[dbprefix]]category_item_link` (
`category_id` int(10) unsigned NOT NULL DEFAULT '0',
`equiv_id` int(10) unsigned NOT NULL DEFAULT '0',
`content_type` char(20) CHARACTER SET ascii NOT NULL,
PRIMARY KEY (`category_id`,`content_type`,`equiv_id`),
KEY `equiv_id` (`equiv_id`,`content_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]centralised_lists`
--
CREATE TABLE `[[dbprefix]]centralised_lists` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module_class_name` varchar(200) CHARACTER SET ascii NOT NULL,
`method_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`label` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `[[dbprefix]]centralised_lists`
--
INSERT INTO `[[dbprefix]]centralised_lists` VALUES
(1, 'zenario_country_manager', 'getActiveCountries', 'Countries (active)'),
(2, 'zenario_country_manager', 'getRegionsByCountry', 'Regions'),
(3, 'zenario_country_manager', 'getCountryDialingCodes', 'Dialing codes'),
(4, 'zenario_country_manager', 'getCountryShortDialingCodes', 'Dialing codes (short)'),
(5, 'zenario_timezones', 'getTimezones', 'Timezones'),
(6, 'zenario_common_features', 'getSalutations', 'Salutations');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]consents`
--
CREATE TABLE `[[dbprefix]]consents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`source_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`source_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`datetime` datetime DEFAULT NULL,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`ip_address` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`label` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]content_cache`
--
CREATE TABLE `[[dbprefix]]content_cache` (
`content_id` int(10) unsigned NOT NULL DEFAULT '0',
`content_type` varchar(20) CHARACTER SET ascii NOT NULL,
`content_version` int(10) unsigned NOT NULL DEFAULT '0',
`text` mediumtext COLLATE utf8mb4_unicode_ci,
`text_wordcount` int(10) unsigned NOT NULL DEFAULT '0',
`extract` mediumtext COLLATE utf8mb4_unicode_ci,
`extract_wordcount` int(10) unsigned NOT NULL DEFAULT '0',
`extract_pagecount` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`content_id`,`content_type`,`content_version`),
KEY `extract_wordcount` (`extract_wordcount`),
FULLTEXT KEY `text` (`text`),
FULLTEXT KEY `extract` (`extract`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]content_cache`
--
INSERT INTO `[[dbprefix]]content_cache` VALUES
(1, 'html', 1, 'Welcome to your new Zenario site!\n\nCongratulations, you have just installed your new Zenario site.\n\nYou may add another page by clicking "New..." on the Admin Toolbar, then selecting what kind of content to create.\n\nInitially you may just see HTML pages but you can enable more content types in Organizer.\n\nPages (called "content items" in Zenario) will be created as drafts and visible to administrators only.\n\nClick on the "Publish" button to make them visible to regular site visitors.\n\nView tutorials, and get support, at https://zenar.io.\n\nWe hope you enjoy using Zenario.', 95, NULL, 0, NULL),
(2, 'html', 1, 'Second page. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur euismod ullamcorper nibh sit amet congue.\n\nNullam rutrum orci vitae lacus luctus, eu facilisis urna varius. Morbi nec orci sed lacus tincidunt tincidunt sit amet et justo.\n\nNunc gravida convallis leo, vitae mattis massa tempor quis. Ut quis nisl imperdiet, semper lacus ac, lobortis urna.\n\nInteger bibendum pretium tortor, non sodales turpis feugiat sed. Nullam molestie nulla leo, non vestibulum quam porttitor nec.\n\nIn hac habitasse platea dictumst. Morbi aliquam malesuada hendrerit. Ut quis elit lorem. Praesent ut elit consequat, mattis est sed, dictum ligula.\n\nDuis ut mi orci. Integer urna lacus, hendrerit nec arcu sit amet, bibendum pretium nulla. Nam consequat dignissim tellus sit amet aliquam.\n\nVestibulum sed ornare felis, ut blandit ipsum.\n\nOrci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.\n\nVivamus dapibus, ipsum eu consectetur accumsan, purus ipsum laoreet mi, vel sollicitudin est ex vitae turpis. Proin in mauris ante.\n\nPellentesque pretium mollis ligula. Duis sed tincidunt lacus. Nunc rutrum ornare arcu, vel vestibulum ante aliquet nec.\n\nAliquam euismod ante leo, et lacinia nulla vulputate scelerisque. Duis efficitur, nibh in sagittis egestas, ipsum orci interdum sem,.\n\nsed aliquet tellus nulla vel metus. Duis semper purus vel turpis elementum, id accumsan velit sollicitudin.', 209, NULL, 0, NULL),
(3, 'html', 1, 'Sorry! You cannot see that page.\n\nYou are trying to access a page that requires a higher level of permissions than you have.', 23, NULL, 0, NULL),
(4, 'html', 1, 'Oops! There is no such page.\n\nThe page you requested was not found.', 13, NULL, 0, NULL),
(5, 'html', 1, 'Privacy policy. This page is auto-created. Its purpose is that you can state organisation''s privacy policy here.\n\nWe recommend you include information about any cookies you may use, how you process confidential data, or any other relevant information.', 38, NULL, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]content_items`
--
CREATE TABLE `[[dbprefix]]content_items` (
`id` int(10) unsigned NOT NULL,
`type` varchar(20) CHARACTER SET ascii NOT NULL,
`tag_id` varchar(32) CHARACTER SET ascii NOT NULL,
`equiv_id` int(10) unsigned NOT NULL,
`language_id` varchar(15) CHARACTER SET ascii NOT NULL,
`alias` varchar(75) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`lang_code_in_url` enum('show','hide','default') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
`first_created_datetime` datetime DEFAULT NULL,
`visitor_version` int(10) unsigned NOT NULL DEFAULT '0',
`admin_version` int(10) unsigned NOT NULL DEFAULT '1',
`status` enum('first_draft','published_with_draft','hidden_with_draft','trashed_with_draft','published','hidden','trashed','deleted','unlisted','unlisted_with_draft') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'first_draft',
`lock_owner_id` int(10) unsigned NOT NULL DEFAULT '0',
`locked_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`,`type`),
UNIQUE KEY `tag_id` (`tag_id`),
UNIQUE KEY `equiv_id` (`equiv_id`,`type`,`language_id`),
KEY `type` (`type`),
KEY `language_id` (`language_id`),
KEY `alias` (`alias`),
KEY `first_created_datetime` (`first_created_datetime`),
KEY `visitor_version` (`visitor_version`),
KEY `admin_version` (`admin_version`),
KEY `status` (`status`),
KEY `lock_owner_id` (`lock_owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]content_items`
--
INSERT INTO `[[dbprefix]]content_items` VALUES
(1, 'html', 'html_1', 1, 'en', 'home', 'default', '[[regtime]]', 1, 1, 'published', 0, NULL),
(2, 'html', 'html_2', 2, 'en', 'second-page', 'default', '[[regtime]]', 0, 1, 'first_draft', 0, NULL),
(3, 'html', 'html_3', 3, 'en', 'no-access', 'default', '[[regtime]]', 1, 1, 'unlisted', 0, NULL),
(4, 'html', 'html_4', 4, 'en', 'not-found', 'default', '[[regtime]]', 1, 1, 'unlisted', 0, NULL),
(5, 'html', 'html_5', 5, 'en', 'privacy-policy', 'default', '[[regtime]]', 0, 1, 'first_draft', 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]content_item_versions`
--
CREATE TABLE `[[dbprefix]]content_item_versions` (
`id` int(10) unsigned NOT NULL,
`type` varchar(20) CHARACTER SET ascii NOT NULL,
`tag_id` varchar(32) CHARACTER SET ascii NOT NULL,
`version` int(10) unsigned NOT NULL,
`title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`description` mediumtext COLLATE utf8mb4_unicode_ci,
`keywords` text COLLATE utf8mb4_unicode_ci,
`content_summary` mediumtext COLLATE utf8mb4_unicode_ci,
`lock_summary` tinyint(1) unsigned NOT NULL DEFAULT '0',
`file_id` int(10) unsigned NOT NULL DEFAULT '0',
`s3_file_id` int(10) unsigned NOT NULL DEFAULT '0',
`filename` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`s3_filename` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`feature_image_id` int(10) unsigned NOT NULL DEFAULT '0',
`layout_id` int(10) unsigned NOT NULL DEFAULT '0',
`skin_id` int(10) unsigned NOT NULL DEFAULT '0',
`css_class` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`bg_image_id` int(10) unsigned NOT NULL DEFAULT '0',
`bg_color` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '',
`bg_position` enum('left top','center top','right top','left center','center center','right center','left bottom','center bottom','right bottom') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`bg_repeat` enum('repeat','repeat-x','repeat-y','no-repeat') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`head_html` mediumtext COLLATE utf8mb4_unicode_ci,
`head_cc` enum('not_needed','needed','specific_types') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'not_needed',
`head_cc_specific_cookie_types` enum('functionality','analytics','social_media') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`head_visitor_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
`head_overwrite` tinyint(1) unsigned NOT NULL DEFAULT '0',
`foot_html` mediumtext COLLATE utf8mb4_unicode_ci,
`foot_cc` enum('not_needed','needed','specific_types') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'not_needed',
`foot_cc_specific_cookie_types` enum('functionality','analytics','social_media') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`foot_visitor_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
`foot_overwrite` tinyint(1) unsigned NOT NULL DEFAULT '0',
`created_datetime` datetime DEFAULT NULL,
`creating_author_id` int(10) unsigned NOT NULL DEFAULT '0',
`last_author_id` int(10) unsigned NOT NULL DEFAULT '0',
`last_modified_datetime` datetime DEFAULT NULL,
`version_changed` enum('not_checked','no_changes_made','changes_made') COLLATE utf8mb4_unicode_ci DEFAULT 'not_checked',
`publisher_id` int(10) unsigned NOT NULL DEFAULT '0',
`published_datetime` datetime DEFAULT NULL,
`concealer_id` int(10) unsigned NOT NULL DEFAULT '0',
`concealed_datetime` datetime DEFAULT NULL,
`release_date` datetime DEFAULT NULL,
`rss_slot_name` varchar(100) CHARACTER SET ascii NOT NULL DEFAULT '',
`rss_nest` int(10) unsigned NOT NULL DEFAULT '0',
`writer_id` int(10) unsigned NOT NULL DEFAULT '0',
`writer_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`scheduled_publish_datetime` datetime DEFAULT NULL,
`in_sitemap` tinyint(1) NOT NULL DEFAULT '1',
`apply_noindex_meta_tag` tinyint(1) NOT NULL DEFAULT '0',
`sensitive_content_message` tinyint(1) NOT NULL DEFAULT '0',
`pinned` tinyint(1) NOT NULL DEFAULT '0',
`pinned_duration` enum('fixed_date','fixed_duration','until_unpinned') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pinned_fixed_duration_value` tinyint(2) NOT NULL DEFAULT '0',
`pinned_fixed_duration_unit` enum('days','weeks') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`unpin_date` datetime DEFAULT NULL,
`access_code` varchar(6) CHARACTER SET ascii DEFAULT NULL,
PRIMARY KEY (`id`,`type`,`version`),
UNIQUE KEY `tag_id` (`tag_id`,`version`),
KEY `type` (`type`),
KEY `version` (`version`),
KEY `created_datetime` (`created_datetime`),
KEY `published_datetime` (`published_datetime`),
KEY `publication_date` (`release_date`),
KEY `file_id` (`file_id`),
KEY `filename` (`filename`),
KEY `last_modified_datetime` (`last_modified_datetime`),
KEY `title_2` (`title`),
KEY `layout_id` (`layout_id`),
KEY `feature_image_id` (`feature_image_id`),
KEY `in_sitemap` (`in_sitemap`),
KEY `access_code` (`access_code`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `description` (`description`),
FULLTEXT KEY `keywords` (`keywords`),
FULLTEXT KEY `content_summary` (`content_summary`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]content_item_versions`
--
INSERT INTO `[[dbprefix]]content_item_versions` VALUES
(1, 'html', 'html_1', 1, 'Home', NULL, NULL, NULL, 0, 0, 0, '', '', 0, 2, 0, '', 0, '', NULL, NULL, NULL, 'not_needed', NULL, 0, 0, NULL, 'not_needed', NULL, 0, 0, '[[regtime]]', 1, 0, NULL, 'not_checked', 1, '[[regtime]]', 0, NULL, NULL, '', 0, 0, '', NULL, 1, 0, 0, 0, NULL, 0, NULL, NULL, NULL),
(2, 'html', 'html_2', 1, 'Second page', NULL, NULL, NULL, 0, 0, 0, '', '', 0, 1, 0, '', 0, '', NULL, NULL, NULL, 'not_needed', NULL, 0, 0, NULL, 'not_needed', NULL, 0, 0, '[[regtime]]', 1, 0, NULL, 'not_checked', 0, NULL, 0, NULL, NULL, '', 0, 0, '', NULL, 1, 0, 0, 0, NULL, 0, NULL, NULL, NULL),
(3, 'html', 'html_3', 1, 'No access', NULL, NULL, NULL, 0, 0, 0, '', '', 0, 1, 0, '', 0, '', NULL, NULL, NULL, 'not_needed', NULL, 0, 0, NULL, 'not_needed', NULL, 0, 0, '[[regtime]]', 1, 0, NULL, 'not_checked', 1, '[[regtime]]', 0, NULL, NULL, '', 0, 0, '', NULL, 1, 0, 0, 0, NULL, 0, NULL, NULL, NULL),
(4, 'html', 'html_4', 1, 'Not found', NULL, NULL, NULL, 0, 0, 0, '', '', 0, 1, 0, '', 0, '', NULL, NULL, NULL, 'not_needed', NULL, 0, 0, NULL, 'not_needed', NULL, 0, 0, '[[regtime]]', 1, 0, NULL, 'not_checked', 1, '[[regtime]]', 0, NULL, NULL, '', 0, 0, '', NULL, 1, 0, 0, 0, NULL, 0, NULL, NULL, NULL),
(5, 'html', 'html_5', 1, 'Privacy policy', NULL, NULL, NULL, 0, 0, 0, '', '', 0, 1, 0, '', 0, '', NULL, NULL, NULL, 'not_needed', NULL, 0, 0, NULL, 'not_needed', NULL, 0, 0, '[[regtime]]', 1, 0, NULL, 'not_checked', 0, NULL, 0, NULL, NULL, '', 0, 0, '', NULL, 1, 0, 0, 0, NULL, 0, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]content_types`
--
CREATE TABLE `[[dbprefix]]content_types` (
`content_type_id` varchar(20) CHARACTER SET ascii NOT NULL,
`content_type_name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`content_type_plural_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`writer_field` enum('optional','mandatory','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'optional',
`description_field` enum('optional','mandatory','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'optional',
`tooltip_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`keywords_field` enum('optional','mandatory','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'optional',
`summary_field` enum('optional','mandatory','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'optional',
`release_date_field` enum('optional','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'optional',
`auto_flag_feature_image` tinyint(1) NOT NULL DEFAULT '1',
`enable_categories` tinyint(1) NOT NULL DEFAULT '0',
`is_creatable` tinyint(1) NOT NULL DEFAULT '1',
`default_layout_id` int(10) unsigned NOT NULL DEFAULT '0',
`module_id` int(10) unsigned NOT NULL,
`prompt_to_create_a_menu_node` tinyint(1) NOT NULL DEFAULT '1',
`menu_node_position_edit` enum('force','suggest') COLLATE utf8mb4_unicode_ci NOT NULL,
`hide_menu_node` tinyint(1) NOT NULL DEFAULT '0',
`default_permissions` enum('public','logged_in') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
`hide_private_item` tinyint(1) NOT NULL DEFAULT '0',
`allow_pinned_content` tinyint(1) NOT NULL DEFAULT '0',
`when_creating_put_title_in_body` tinyint(1) NOT NULL DEFAULT '0',
`auto_set_release_date` tinyint(1) NOT NULL DEFAULT '0',
`enable_css_tab` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`content_type_id`),
KEY `content_type_id` (`content_type_id`),
KEY `plugin_id` (`module_id`),
KEY `default_layout_id` (`default_layout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]content_types`
--
INSERT INTO `[[dbprefix]]content_types` VALUES
('html', 'HTML page', 'HTML pages', 'hidden', 'optional', 'Flat view of all HTML page content items', 'hidden', 'hidden', 'hidden', 1, 0, 1, 1, 1, 1, 'force', 0, 'public', 1, 0, 0, 1, 0),
('news', 'News article', 'News articles', 'hidden', 'optional', 'News content items, to show latest news on your site, and keep an archive of older articles', 'hidden', 'optional', 'optional', 1, 1, 1, 3, 19, 1, 'force', 0, 'public', 1, 0, 0, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cropped_images`
--
CREATE TABLE `[[dbprefix]]cropped_images` (
`image_id` int(10) unsigned NOT NULL,
`aspect_ratio_width` mediumint(6) NOT NULL,
`aspect_ratio_height` mediumint(6) NOT NULL,
`aspect_ratio_angle` float NOT NULL,
`ui_crop_x` mediumint(6) NOT NULL,
`ui_crop_y` mediumint(6) NOT NULL,
`ui_crop_width` mediumint(6) NOT NULL,
`ui_crop_height` mediumint(6) NOT NULL,
`ui_image_width` mediumint(6) NOT NULL,
`ui_image_height` mediumint(6) NOT NULL,
`crop_x` mediumint(6) NOT NULL,
`crop_y` mediumint(6) NOT NULL,
`crop_width` mediumint(6) NOT NULL,
`crop_height` mediumint(6) NOT NULL,
PRIMARY KEY (`image_id`,`aspect_ratio_width`,`aspect_ratio_height`),
KEY `image_id` (`image_id`,`aspect_ratio_angle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_datasets`
--
CREATE TABLE `[[dbprefix]]custom_datasets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`system_table` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`table` varchar(255) CHARACTER SET ascii NOT NULL,
`extends_admin_box` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`extends_organizer_panel` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`view_priv` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`edit_priv` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`label_field_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `table` (`table`),
KEY `label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]custom_datasets`
--
INSERT INTO `[[dbprefix]]custom_datasets` VALUES
(1, 'Users', 'users', 'users_custom_data', 'zenario_user__details', 'zenario__users/panels/users', '_PRIV_VIEW_USER', '_PRIV_EDIT_USER', 1),
(2, 'Hierarchical documents', 'documents', 'documents_custom_data', 'zenario_document_properties', 'zenario__library/panels/documents', '', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_dataset_fields`
--
CREATE TABLE `[[dbprefix]]custom_dataset_fields` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`dataset_id` int(10) unsigned NOT NULL,
`tab_name` varchar(64) CHARACTER SET ascii NOT NULL,
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_system_field` tinyint(1) NOT NULL DEFAULT '0',
`protected` tinyint(1) NOT NULL DEFAULT '0',
`fundamental` tinyint(1) NOT NULL DEFAULT '0',
`field_name` varchar(64) CHARACTER SET ascii NOT NULL DEFAULT '',
`ord` int(10) unsigned NOT NULL DEFAULT '0',
`label` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`default_label` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`type` enum('group','checkbox','consent','checkboxes','date','editor','radios','centralised_radios','select','centralised_select','text','textarea','url','other_system_field','dataset_select','dataset_picker','file_picker') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'other_system_field',
`width` smallint(5) unsigned NOT NULL DEFAULT '0',
`height` smallint(5) unsigned NOT NULL DEFAULT '0',
`values_source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`values_source_filter` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`dataset_foreign_key_id` int(10) unsigned NOT NULL DEFAULT '0',
`multiple_select` tinyint(1) NOT NULL DEFAULT '0',
`store_file` enum('in_docstore','in_database') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`extensions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`required` tinyint(1) NOT NULL DEFAULT '0',
`mandatory_if_visible` tinyint(1) NOT NULL DEFAULT '0',
`mandatory_condition_field_id` int(10) unsigned DEFAULT '0',
`mandatory_condition_invert` tinyint(1) NOT NULL DEFAULT '0',
`mandatory_condition_checkboxes_operator` enum('AND','OR') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'AND',
`mandatory_condition_field_value` longtext COLLATE utf8mb4_unicode_ci,
`required_message` text COLLATE utf8mb4_unicode_ci,
`validation` enum('none','email','emails','no_spaces','numeric','screen_name') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none',
`validation_message` text COLLATE utf8mb4_unicode_ci,
`note_below` text COLLATE utf8mb4_unicode_ci,
`side_note` text COLLATE utf8mb4_unicode_ci,
`db_column` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`admin_box_visibility` enum('show','show_on_condition','hide') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'show',
`organizer_visibility` enum('none','hide','show_by_default','always_show') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none',
`create_index` tinyint(1) NOT NULL DEFAULT '0',
`searchable` tinyint(1) NOT NULL DEFAULT '0',
`filterable` tinyint(1) NOT NULL DEFAULT '0',
`sortable` tinyint(1) NOT NULL DEFAULT '0',
`readonly` tinyint(1) NOT NULL DEFAULT '0',
`include_in_export` tinyint(1) NOT NULL DEFAULT '0',
`autocomplete` tinyint(1) NOT NULL DEFAULT '0',
`indent` int(10) unsigned NOT NULL DEFAULT '0',
`allow_admin_to_change_visibility` tinyint(1) NOT NULL DEFAULT '0',
`allow_admin_to_change_export` tinyint(1) NOT NULL DEFAULT '0',
`visible_condition_field_id` int(10) unsigned DEFAULT '0',
`visible_condition_invert` tinyint(1) NOT NULL DEFAULT '0',
`visible_condition_field_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dataset_id` (`dataset_id`,`tab_name`,`id`),
KEY `dataset_id_2` (`dataset_id`,`tab_name`,`ord`),
KEY `is_system_field` (`is_system_field`),
KEY `parent_id` (`parent_id`),
KEY `field_name` (`field_name`),
KEY `protected` (`protected`),
KEY `organizer_visibility` (`organizer_visibility`),
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=52 ;
--
-- Dumping data for table `[[dbprefix]]custom_dataset_fields`
--
INSERT INTO `[[dbprefix]]custom_dataset_fields` VALUES
(1, 1, '', 0, 1, 0, 0, 'identifier', 0, '', '', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'identifier', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(2, 1, 'details', 0, 1, 0, 0, 'email', 2, '', 'Email:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'email', NULL, NULL, NULL, 'email', 'show', 'none', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, NULL),
(3, 1, 'details', 0, 1, 0, 0, 'email_verified', 3, '', 'Email address verified', 'checkbox', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'email_verified', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(4, 1, 'details', 0, 1, 0, 0, 'salutation', 4, '', 'Salutation:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'salutation', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, NULL),
(5, 1, 'details', 0, 1, 0, 0, 'first_name', 5, '', 'First name:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'first_name', 'show', 'none', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, NULL),
(6, 1, 'details', 0, 1, 0, 0, 'last_name', 6, '', 'Last name:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'last_name', 'show', 'none', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, NULL),
(7, 1, 'details', 0, 1, 0, 0, 'screen_name', 10, '', 'Screen name:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'screen_name', NULL, NULL, NULL, 'screen_name', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(8, 1, 'details', 0, 1, 0, 1, 'status', 7, '', 'Status:', 'centralised_radios', 0, 0, 'zenario_common_features::userStatus', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'status', 'show', 'none', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, NULL),
(9, 1, 'details', 0, 1, 0, 0, 'password', 16, '', 'Password:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'password', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(10, 1, 'details', 0, 1, 0, 0, 'password_needs_changing', 20, '', 'Must change password on next login', 'checkbox', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'password_needs_changing', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(11, 1, 'details', 0, 1, 0, 0, 'terms_and_conditions_accepted', 21, '', 'Has accepted terms and conditions', 'consent', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'terms_and_conditions_accepted', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(12, 1, 'details', 0, 1, 0, 0, 'screen_name_confirmed', 12, '', 'Screen Name chosen/accepted by user', 'checkbox', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'screen_name_confirmed', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(13, 1, 'details', 0, 1, 0, 0, 'send_activation_email_to_user', 22, '', 'Send "account created" email to user', 'checkbox', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(14, 1, 'dates', 0, 1, 0, 0, 'created_date', 0, '', '', 'date', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'created_date', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(15, 1, 'dates', 0, 1, 0, 0, 'modified_date', 0, '', '', 'date', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'modified_date', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(16, 1, 'dates', 0, 1, 0, 0, 'last_login', 1, '', 'Last login:', 'date', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'last_login', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(18, 1, 'dates', 0, 1, 0, 0, 'last_profile_update_in_frontend', 2, '', 'Profile last updated:', 'date', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'last_profile_update_in_frontend', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(19, 1, 'dates', 0, 1, 0, 0, 'suspended_date', 3, '', 'Date suspended:', 'date', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'suspended_date', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(24, 1, 'details', 0, 1, 0, 0, 'linked_countries', 8, '', 'Country-based permissions:', 'dataset_picker', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(25, 2, 'details', 0, 1, 0, 0, 'document_title', 2, '', 'Title:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'title', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(26, 2, 'details', 0, 1, 0, 0, 'date_uploaded', 5, '', 'Date uploaded:', 'date', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'file_datetime', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(27, 2, 'details', 0, 1, 0, 0, 'document_name', 3, '', 'Filename:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(28, 2, 'details', 0, 1, 0, 0, 'tags', 7, '', 'Document tags:', 'checkboxes', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(29, 2, 'details', 0, 1, 0, 0, 'privacy', 6, '', 'Privacy', 'radios', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, 'privacy', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(30, 2, 'extract', 0, 1, 0, 0, 'extract', 1, '', 'Extract text:', 'textarea', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(31, 2, 'extract', 0, 1, 0, 0, 'extract_wordcount', 2, '', 'Extract wordcount:', 'text', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(32, 2, 'details', 0, 1, 0, 0, 'document_extension', 1, '', 'Extension:', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(33, 2, 'details', 0, 1, 0, 0, 'checksum', 4, '', 'Checksum:', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(34, 2, 'details', 0, 1, 0, 0, 'link_to_add_tags', 8, '', 'Link to add document tags', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(35, 2, 'upload_image', 0, 1, 0, 0, 'thumbnail_grouping', 1, '', '', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(36, 2, 'upload_image', 0, 1, 0, 0, 'title', 2, '', 'Current thumbnail image (public):', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(37, 2, 'upload_image', 0, 1, 0, 0, 'thumbnail_image', 3, '', '[Thumbnail image]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(38, 2, 'upload_image', 0, 1, 0, 0, 'delete_thumbnail_image', 4, '', '[Delete thumbnail image button]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(39, 2, 'upload_image', 0, 1, 0, 0, 'zenario_common_feature__upload', 5, '', 'Upload new thumbnail image (public):', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(40, 1, 'details', 0, 1, 0, 0, 'email_grouping', 1, '', '[Email grouping]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(41, 1, 'details', 0, 1, 0, 0, 'screen_name_grouping', 9, '', '[Screen name grouping]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(42, 1, 'details', 0, 1, 0, 0, 'suggest_screen_name', 11, '', '[Suggest screen name button]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(43, 1, 'details', 0, 1, 0, 0, 'password_grouping', 13, '', '[Password grouping]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(44, 1, 'details', 0, 1, 0, 0, 'activation_grouping', 14, '', '[Account creation grouping]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(45, 1, 'details', 0, 1, 0, 0, 'password_when_editing', 15, '', 'Password:', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(46, 1, 'details', 0, 1, 0, 0, 'reveal_password', 17, '', '[Reveal password button]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(47, 1, 'details', 0, 1, 0, 0, 'suggest_password', 18, '', '[Suggest password button]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(48, 1, 'details', 0, 1, 0, 0, 'password_message', 19, '', '[Password validation message]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(49, 1, 'details', 0, 1, 0, 0, 'email_to_send', 23, '', 'Activation email template:', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(50, 1, 'groups', 0, 1, 0, 0, 'no_groups_created', 1, '', '[Warning message about groups]', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL),
(51, 1, 'dates', 0, 1, 0, 0, 'consents_log', 4, '', 'Consents log:', 'other_system_field', 0, 0, '', '', 0, 0, NULL, '', 0, 0, 0, 0, 'AND', NULL, NULL, 'none', NULL, NULL, NULL, '', 'show', 'none', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_dataset_field_values`
--
CREATE TABLE `[[dbprefix]]custom_dataset_field_values` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`field_id` int(10) NOT NULL,
`ord` int(10) NOT NULL DEFAULT '0',
`label` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`note_below` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `field_id` (`field_id`,`id`),
KEY `field_id_2` (`field_id`,`ord`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_dataset_files_link`
--
CREATE TABLE `[[dbprefix]]custom_dataset_files_link` (
`dataset_id` int(10) NOT NULL,
`field_id` int(10) NOT NULL,
`linking_id` int(10) NOT NULL,
`file_id` int(10) NOT NULL,
PRIMARY KEY (`field_id`,`linking_id`,`file_id`),
KEY `dataset_id` (`dataset_id`),
KEY `linking_id` (`linking_id`),
KEY `file_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_dataset_tabs`
--
CREATE TABLE `[[dbprefix]]custom_dataset_tabs` (
`dataset_id` int(10) unsigned NOT NULL,
`name` varchar(64) CHARACTER SET ascii NOT NULL,
`ord` int(10) unsigned NOT NULL DEFAULT '0',
`label` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`default_label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`parent_field_id` int(10) NOT NULL DEFAULT '0',
`is_system_field` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`dataset_id`,`name`),
KEY `ord` (`ord`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]custom_dataset_tabs`
--
INSERT INTO `[[dbprefix]]custom_dataset_tabs` VALUES
(1, 'dates', 999999, '', 'Dates/History', 0, 1),
(1, 'details', 1, '', 'Details', 0, 1),
(1, 'groups', 2, '', 'Groups', 0, 1),
(2, 'details', 1, '', 'Document metadata', 0, 1),
(2, 'extract', 3, '', 'Extract', 0, 1),
(2, 'upload_image', 2, '', 'Thumbnail image', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]custom_dataset_values_link`
--
CREATE TABLE `[[dbprefix]]custom_dataset_values_link` (
`dataset_id` int(10) NOT NULL,
`value_id` int(10) NOT NULL,
`linking_id` int(10) NOT NULL,
PRIMARY KEY (`value_id`,`linking_id`),
UNIQUE KEY `linking_id` (`linking_id`,`value_id`),
KEY `dataset_id` (`dataset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]documents`
--
CREATE TABLE `[[dbprefix]]documents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ordinal` int(10) NOT NULL,
`type` enum('file','folder') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'file',
`file_id` int(10) unsigned DEFAULT NULL,
`folder_id` int(10) NOT NULL DEFAULT '0',
`folder_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`privacy` enum('public','private','offline') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'offline',
`document_datetime` datetime DEFAULT NULL,
`thumbnail_id` int(10) DEFAULT NULL,
`extract` mediumtext COLLATE utf8mb4_unicode_ci,
`extract_wordcount` int(10) unsigned NOT NULL DEFAULT '0',
`dont_autoset_metadata` tinyint(1) unsigned NOT NULL DEFAULT '0',
`filename` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`file_datetime` datetime DEFAULT NULL,
`title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ordinal` (`ordinal`),
KEY `type` (`type`),
KEY `folder_id` (`folder_id`),
FULLTEXT KEY `extract` (`extract`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]documents_custom_data`
--
CREATE TABLE `[[dbprefix]]documents_custom_data` (
`document_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]document_public_redirects`
--
CREATE TABLE `[[dbprefix]]document_public_redirects` (
`document_id` int(10) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`document_id`,`path`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]document_rules`
--
CREATE TABLE `[[dbprefix]]document_rules` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ordinal` int(10) unsigned NOT NULL DEFAULT '0',
`use` enum('filename_without_extension','filename_and_extension','extension') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'filename_without_extension',
`pattern` mediumtext COLLATE utf8mb4_unicode_ci,
`action` enum('move_to_folder','set_field') COLLATE utf8mb4_unicode_ci NOT NULL,
`folder_id` int(10) unsigned NOT NULL DEFAULT '0',
`field_id` int(10) unsigned NOT NULL DEFAULT '0',
`replacement` mediumtext COLLATE utf8mb4_unicode_ci,
`replacement_is_regexp` tinyint(1) unsigned NOT NULL,
`apply_second_pass` tinyint(1) unsigned NOT NULL DEFAULT '0',
`second_pattern` mediumtext COLLATE utf8mb4_unicode_ci,
`second_replacement` mediumtext COLLATE utf8mb4_unicode_ci,
`stop_processing_rules` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `ordinal` (`ordinal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]document_tags`
--
CREATE TABLE `[[dbprefix]]document_tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tag_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `tag_name` (`tag_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]document_tag_link`
--
CREATE TABLE `[[dbprefix]]document_tag_link` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`document_id` int(10) NOT NULL,
`tag_id` int(10) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `document_tag_link` (`document_id`,`tag_id`),
KEY `type` (`document_id`),
KEY `folder_id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]document_types`
--
CREATE TABLE `[[dbprefix]]document_types` (
`type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`mime_type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`custom` tinyint(1) NOT NULL DEFAULT '1',
`is_allowed` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`type`),
KEY `custom` (`custom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]document_types`
--
INSERT INTO `[[dbprefix]]document_types` VALUES
('323', 'text/h323', 0, 1),
('7z', 'application/x-7z-compressed', 0, 1),
('acx', 'application/internet-property-stream', 0, 1),
('ai', 'application/postscript', 0, 1),
('aif', 'audio/x-aiff', 0, 1),
('aifc', 'audio/x-aiff', 0, 1),
('aiff', 'audio/x-aiff', 0, 1),
('asc', 'text/plain', 0, 1),
('asf', 'video/x-ms-asf', 0, 1),
('asr', 'video/x-ms-asf', 0, 1),
('asx', 'video/x-ms-asf', 0, 1),
('au', 'audio/basic', 0, 1),
('avi', 'video/x-msvideo', 0, 1),
('axs', 'application/olescript', 0, 1),
('bas', 'text/plain', 0, 1),
('bcpio', 'application/x-bcpio', 0, 1),
('bmp', 'image/bmp', 0, 1),
('c', 'text/plain', 0, 1),
('cat', 'application/vnd.ms-pkiseccat', 0, 1),
('cdf', 'application/x-cdf', 0, 1),
('cer', 'application/x-x509-ca-cert', 0, 1),
('class', 'application/octet-stream', 0, 1),
('clp', 'application/x-msclip', 0, 1),
('cmx', 'image/x-cmx', 0, 1),
('cod', 'image/cis-cod', 0, 1),
('cpio', 'application/x-cpio', 0, 1),
('crd', 'application/x-mscardfile', 0, 1),
('crl', 'application/pkix-crl', 0, 1),
('crt', 'application/x-x509-ca-cert', 0, 1),
('csh', 'application/x-csh', 0, 1),
('css', 'text/css', 0, 1),
('csv', 'text/csv', 0, 1),
('dcr', 'application/x-director', 0, 1),
('der', 'application/x-x509-ca-cert', 0, 1),
('dir', 'application/x-director', 0, 1),
('dll', 'application/x-msdownload', 0, 1),
('dms', 'application/octet-stream', 0, 1),
('doc', 'application/msword', 0, 1),
('docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 0, 1),
('dot', 'application/msword', 0, 1),
('dotx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.template', 0, 1),
('dvi', 'application/x-dvi', 0, 1),
('dwg', 'application/acad', 0, 1),
('dxr', 'application/x-director', 0, 1),
('eps', 'application/postscript', 0, 1),
('etx', 'text/x-setext', 0, 1),
('evy', 'application/envoy', 0, 1),
('fif', 'application/fractals', 0, 1),
('flr', 'x-world/x-vrml', 0, 1),
('flv', 'video/x-flv', 0, 1),
('gif', 'image/gif', 0, 1),
('gtar', 'application/x-gtar', 0, 1),
('gz', 'application/x-gzip', 0, 1),
('h', 'text/plain', 0, 1),
('hdf', 'application/x-hdf', 0, 1),
('hlp', 'application/winhlp', 0, 1),
('hqx', 'application/mac-binhex40', 0, 1),
('hta', 'application/hta', 0, 1),
('htc', 'text/x-component', 0, 1),
('ico', 'image/x-icon', 0, 1),
('ics', 'text/calendar', 0, 1),
('ief', 'image/ief', 0, 1),
('iii', 'application/x-iphone', 0, 1),
('ins', 'application/x-internet-signup', 0, 1),
('isp', 'application/x-internet-signup', 0, 1),
('jfif', 'image/pipeg', 0, 1),
('jpe', 'image/jpeg', 0, 1),
('jpeg', 'image/jpeg', 0, 1),
('jpg', 'image/jpeg', 0, 1),
('json', 'application/json', 0, 1),
('latex', 'application/x-latex', 0, 1),
('lha', 'application/octet-stream', 0, 1),
('lsf', 'video/x-la-asf', 0, 1),
('lsx', 'video/x-la-asf', 0, 1),
('lzh', 'application/octet-stream', 0, 1),
('m13', 'application/x-msmediaview', 0, 1),
('m14', 'application/x-msmediaview', 0, 1),
('m3u', 'audio/x-mpegurl', 0, 1),
('m4v', 'video/x-m4v', 0, 1),
('man', 'application/x-troff-man', 0, 1),
('md', 'text/markdown', 0, 1),
('mdb', 'application/x-msaccess', 0, 1),
('me', 'application/x-troff-me', 0, 1),
('mht', 'message/rfc822', 0, 1),
('mid', 'audio/mid', 0, 1),
('midi', 'audio/mid', 0, 1),
('mny', 'application/x-msmoney', 0, 1),
('mov', 'video/quicktime', 0, 1),
('movie', 'video/x-sgi-movie', 0, 1),
('mp2', 'video/mpeg', 0, 1),
('mp3', 'audio/mpeg', 0, 1),
('mp4', 'video/mp4', 0, 1),
('mpa', 'video/mpeg', 0, 1),
('mpe', 'video/mpeg', 0, 1),
('mpeg', 'video/mpeg', 0, 1),
('mpg', 'video/mpeg', 0, 1),
('mpp', 'application/vnd.ms-project', 0, 1),
('mpv2', 'video/mpeg', 0, 1),
('ms', 'application/x-troff-ms', 0, 1),
('msg', 'application/vnd.ms-outlook', 0, 1),
('mvb', 'application/x-msmediaview', 0, 1),
('nc', 'application/x-netcdf', 0, 1),
('nws', 'message/rfc822', 0, 1),
('oda', 'application/oda', 0, 1),
('ods', 'application/vnd.oasis.opendocument.spreadsheet', 0, 1),
('odt', 'application/vnd.oasis.opendocument.text', 0, 1),
('oga', 'application/ogg', 0, 1),
('ogg', 'audio/ogg', 0, 1),
('ogv', 'video/ogg', 0, 1),
('p10', 'application/pkcs10', 0, 1),
('p12', 'application/x-pkcs12', 0, 1),
('p7b', 'application/x-pkcs7-certificates', 0, 1),
('p7c', 'application/x-pkcs7-mime', 0, 1),
('p7m', 'application/x-pkcs7-mime', 0, 1),
('p7r', 'application/x-pkcs7-certreqresp', 0, 1),
('p7s', 'application/x-pkcs7-signature', 0, 1),
('pbm', 'image/x-portable-bitmap', 0, 1),
('pdf', 'application/pdf', 0, 1),
('pfx', 'application/x-pkcs12', 0, 1),
('pgm', 'image/x-portable-graymap', 0, 1),
('pko', 'application/ynd.ms-pkipko', 0, 1),
('pma', 'application/x-perfmon', 0, 1),
('pmc', 'application/x-perfmon', 0, 1),
('pml', 'application/x-perfmon', 0, 1),
('pmr', 'application/x-perfmon', 0, 1),
('pmw', 'application/x-perfmon', 0, 1),
('png', 'image/png', 0, 1),
('pnm', 'image/x-portable-anymap', 0, 1),
('pot', 'application/vnd.ms-powerpoint', 0, 1),
('potx', 'application/vnd.openxmlformats-officedocument.presentationml.template', 0, 1),
('ppm', 'image/x-portable-pixmap', 0, 1),
('pps', 'application/vnd.ms-powerpoint', 0, 1),
('ppsx', 'application/vnd.openxmlformats-officedocument.presentationml.slideshow', 0, 1),
('ppt', 'application/vnd.ms-powerpoint', 0, 1),
('pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 0, 1),
('prf', 'application/pics-rules', 0, 1),
('ps', 'application/postscript', 0, 1),
('psd', 'application/octet-stream', 0, 1),
('pub', 'application/x-mspublisher', 0, 1),
('qt', 'video/quicktime', 0, 1),
('ra', 'audio/vnd.rn-realaudio', 0, 1),
('ram', 'audio/vnd.rn-realaudio', 0, 1),
('ras', 'image/x-cmu-raster', 0, 1),
('rgb', 'image/x-rgb', 0, 1),
('rm', 'application/vnd.rn-realmedia', 0, 1),
('rmi', 'audio/mid', 0, 1),
('roff', 'application/x-troff', 0, 1),
('rpm', 'audio/x-pn-realaudio-plugin', 0, 1),
('rtf', 'application/rtf', 0, 1),
('rtx', 'text/richtext', 0, 1),
('rv', 'video/vnd.rn-realvideo', 0, 1),
('rvt', 'application/octet-stream', 0, 1),
('scd', 'application/x-msschedule', 0, 1),
('sct', 'text/scriptlet', 0, 1),
('setpay', 'application/set-payment-initiation', 0, 1),
('setreg', 'application/set-registration-initiation', 0, 1),
('shar', 'application/x-shar', 0, 1),
('sit', 'application/x-stuffit', 0, 1),
('sldx', 'application/vnd.openxmlformats-officedocument.presentationml.slide', 0, 1),
('snd', 'audio/basic', 0, 1),
('spc', 'application/x-pkcs7-certificates', 0, 1),
('spl', 'application/futuresplash', 0, 1),
('src', 'application/x-wais-source', 0, 1),
('sst', 'application/vnd.ms-pkicertstore', 0, 1),
('stl', 'application/vnd.ms-pkistl', 0, 1),
('sv4cpio', 'application/x-sv4cpio', 0, 1),
('sv4crc', 'application/x-sv4crc', 0, 1),
('svg', 'image/svg+xml', 0, 1),
('swf', 'application/x-shockwave-flash', 0, 1),
('t', 'application/x-troff', 0, 1),
('tar', 'application/x-tar', 0, 1),
('tcl', 'application/x-tcl', 0, 1),
('tex', 'application/x-tex', 0, 1),
('texi', 'application/x-texinfo', 0, 1),
('texinfo', 'application/x-texinfo', 0, 1),
('tgz', 'application/x-compressed', 0, 1),
('tif', 'image/tiff', 0, 1),
('tiff', 'image/tiff', 0, 1),
('tr', 'application/x-troff', 0, 1),
('trm', 'application/x-msterminal', 0, 1),
('tsv', 'text/tab-separated-values', 0, 1),
('txt', 'text/plain', 0, 1),
('uls', 'text/iuls', 0, 1),
('unknown', 'application/octet-stream', 0, 1),
('ustar', 'application/x-ustar', 0, 1),
('vcf', 'text/x-vcard', 0, 1),
('vrml', 'x-world/x-vrml', 0, 1),
('vsd', 'application/x-visio', 0, 1),
('wav', 'audio/x-wav', 0, 1),
('wcm', 'application/vnd.ms-works', 0, 1),
('wdb', 'application/vnd.ms-works', 0, 1),
('webp', 'image/webp', 0, 1),
('wks', 'application/vnd.ms-works', 0, 1),
('wmf', 'application/x-msmetafile', 0, 1),
('wmv', 'audio/x-ms-wmv', 0, 1),
('wps', 'application/vnd.ms-works', 0, 1),
('wri', 'application/x-mswrite', 0, 1),
('wrl', 'x-world/x-vrml', 0, 1),
('wrz', 'x-world/x-vrml', 0, 1),
('xaf', 'x-world/x-vrml', 0, 1),
('xbm', 'image/x-xbitmap', 0, 1),
('xla', 'application/vnd.ms-excel', 0, 1),
('xlam', 'application/vnd.ms-excel.addin.macroEnabled.12', 0, 1),
('xlc', 'application/vnd.ms-excel', 0, 1),
('xlm', 'application/vnd.ms-excel', 0, 1),
('xls', 'application/vnd.ms-excel', 0, 1),
('xlsb', 'application/vnd.ms-excel.sheet.binary.macroEnabled.12', 0, 1),
('xlsm', 'application/vnd.ms-excel.sheet.macroEnabled.12', 0, 1),
('xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 0, 1),
('xlt', 'application/vnd.ms-excel', 0, 1),
('xltx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.template', 0, 1),
('xlw', 'application/vnd.ms-excel', 0, 1),
('xml', 'text/xml', 0, 1),
('xof', 'x-world/x-vrml', 0, 1),
('xpm', 'image/x-xpixmap', 0, 1),
('xwd', 'image/x-xwindowdump', 0, 1),
('z', 'application/x-compress', 0, 1),
('zip', 'application/zip', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]email_templates`
--
CREATE TABLE `[[dbprefix]]email_templates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module_class_name` varchar(200) CHARACTER SET ascii DEFAULT NULL,
`code` varchar(255) CHARACTER SET ascii NOT NULL,
`template_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`subject` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`body` text COLLATE utf8mb4_unicode_ci,
`send_cc` tinyint(1) NOT NULL DEFAULT '0',
`cc_email_address` text COLLATE utf8mb4_unicode_ci,
`send_bcc` tinyint(1) NOT NULL DEFAULT '0',
`bcc_email_address` text COLLATE utf8mb4_unicode_ci,
`debug_override` tinyint(1) NOT NULL DEFAULT '0',
`debug_email_address` text COLLATE utf8mb4_unicode_ci,
`date_created` datetime NOT NULL,
`created_by_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_modified` datetime DEFAULT NULL,
`modified_by_id` int(10) unsigned NOT NULL DEFAULT '0',
`last_sent` datetime DEFAULT NULL,
`allow_attachments` tinyint(1) DEFAULT '0',
`use_standard_email_template` tinyint(1) NOT NULL DEFAULT '0',
`period_to_delete_log_headers` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`period_to_delete_log_content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`include_a_fixed_attachment` tinyint(1) NOT NULL DEFAULT '0',
`selected_attachment` int(10) unsigned DEFAULT NULL,
`allow_visitor_uploaded_attachments` tinyint(1) NOT NULL DEFAULT '0',
`when_sending_attachments` enum('send_organizer_link','send_actual_file') COLLATE utf8mb4_unicode_ci DEFAULT 'send_organizer_link',
`apply_css_rules` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `template_name` (`template_name`),
UNIQUE KEY `code` (`code`),
KEY `date_modified` (`date_modified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]email_template_sending_log`
--
CREATE TABLE `[[dbprefix]]email_template_sending_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module_id` int(10) unsigned DEFAULT NULL,
`instance_id` int(10) unsigned DEFAULT NULL,
`content_id` int(10) DEFAULT NULL,
`content_type` varchar(20) CHARACTER SET ascii DEFAULT NULL,
`content_version` int(10) DEFAULT NULL,
`email_template_id` int(10) DEFAULT NULL,
`email_template_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_subject` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_address_to` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_address_to_overridden_by` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_address_from` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_address_replyto` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_name_from` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_body` mediumtext COLLATE utf8mb4_unicode_ci,
`attachment_present` tinyint(4) DEFAULT NULL,
`sent_datetime` datetime NOT NULL,
`status` enum('success','failure') COLLATE utf8mb4_unicode_ci DEFAULT 'success',
`debug_mode` tinyint(4) DEFAULT '0',
`email_name_replyto` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_ccs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`form_response_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]error_404_log`
--
CREATE TABLE `[[dbprefix]]error_404_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`logged` datetime NOT NULL,
`referrer_url` text COLLATE utf8mb4_unicode_ci,
`page_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]files`
--
CREATE TABLE `[[dbprefix]]files` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`checksum` varchar(32) CHARACTER SET ascii NOT NULL,
`short_checksum` varchar(24) CHARACTER SET ascii DEFAULT NULL,
`usage` varchar(64) CHARACTER SET ascii NOT NULL,
`privacy` enum('auto','public','private') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'auto',
`archived` tinyint(1) NOT NULL DEFAULT '0',
`created_datetime` datetime DEFAULT NULL,
`filename` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`mime_type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`width` smallint(5) unsigned DEFAULT NULL,
`height` smallint(5) unsigned DEFAULT NULL,
`alt_tag` text COLLATE utf8mb4_unicode_ci,
`title` text COLLATE utf8mb4_unicode_ci,
`floating_box_title` text COLLATE utf8mb4_unicode_ci,
`size` int(10) unsigned NOT NULL,
`location` enum('db','docstore','s3') COLLATE utf8mb4_unicode_ci NOT NULL,
`data` longblob,
`path` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`thumbnail_180x130_width` tinyint(3) unsigned NOT NULL DEFAULT '0',
`thumbnail_180x130_height` tinyint(3) unsigned NOT NULL DEFAULT '0',
`thumbnail_180x130_data` mediumblob,
`custom_thumbnail_1_width` smallint(5) unsigned DEFAULT NULL,
`custom_thumbnail_1_height` smallint(5) unsigned DEFAULT NULL,
`custom_thumbnail_1_data` mediumblob,
`custom_thumbnail_2_width` smallint(5) unsigned DEFAULT NULL,
`custom_thumbnail_2_height` smallint(5) unsigned DEFAULT NULL,
`custom_thumbnail_2_data` mediumblob,
`image_credit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `checksum` (`checksum`,`usage`),
UNIQUE KEY `short_checksum` (`short_checksum`,`usage`),
KEY `usage` (`usage`),
KEY `created_datetime` (`created_datetime`),
KEY `filename` (`filename`),
KEY `mime_type` (`mime_type`),
KEY `location` (`location`),
KEY `width` (`width`),
KEY `height` (`height`),
KEY `archived` (`archived`),
KEY `thumbnail_180x130_width` (`thumbnail_180x130_width`),
KEY `thumbnail_180x130_height` (`thumbnail_180x130_height`),
KEY `custom_thumbnail_1_width` (`custom_thumbnail_1_width`),
KEY `custom_thumbnail_1_height` (`custom_thumbnail_1_height`),
KEY `custom_thumbnail_2_width` (`custom_thumbnail_2_width`),
KEY `custom_thumbnail_2_height` (`custom_thumbnail_2_height`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;
--
-- Dumping data for table `[[dbprefix]]files`
--
INSERT INTO `[[dbprefix]]files` VALUES
(1, 'H36sO1YPBEEdrjIRu6im8w', 'H36sO', 'image', 'public', 0, '[[regtime]]', 'logo-zebra-designs.svg', 'image/svg+xml', 176, 44, 'Zebra Designs logo', NULL, NULL, 10635, 'db', '<?xml version="1.0" encoding="UTF-8" standalone="no"?>\n<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">\n<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:serif="http://www.serif.com/" width="176px" height="44px" xml:space="preserve" style="fill-rule:evenodd;clip-rule:evenodd;stroke-linejoin:round;stroke-miterlimit:2;">\n <g transform="matrix(1.67785,0,0,1.67785,-5.07807,-9.76701)">\n <g transform="matrix(0.293333,0,0,0.293333,-6.36014,4.26647)">\n <g>\n <g>\n <g>\n <path d="M49.6,55.5L50,56.5L50.4,55.5L51.9,49.6L53.5,46.2L52.7,38.7L50.9,33.1L50,32.2L49.1,33.1L47.3,38.7L46.5,46.2L48.1,49.6L49.6,55.5Z" style="fill-rule:nonzero;"/>\n <path d="M42.3,54.2L46.1,59.4L46.5,62.9L43.2,58.2L39.2,56.7L36.1,54.57L36.4,59.7L38.3,58.9L41.4,58.9L43.1,62.1L43.6,65.1L43.6,66.9L41.4,63.7L39.4,63.1L37.1,63.8L36.9,63.8L40.7,78.3L41.9,76.6L44.7,67L48.2,68.3L50,70L51.8,68.3L55