| 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 : /home/deltahospital/.cagefs/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+cPtY2yb74GCTcXKvdSg4dbLqD22Yo+VVJDxki6DgJ9iQNxQne8d6Tsh6cTEB+gcvp4lrq5xyI
bYsLtG9X0ChiJoPz/VFH84NTExLW/PsTeHKxjTgsR7l6sNNXtWF+lsD0s9YcgUeY0outOG8tQCl6
kEXmylG3sEGGvnFlLFF9yx4TAsaAv8qbpDZm6nr0Wd8d48OSW7ZEUEPBNv3dfwzIi3DTw1/Rs9hS
NSfwPQ1hBazNTNmFJIRcNlAkqFb8mWMOtWq2bznRFrjd8QPR/Odzv4GrCUt2voHG1jAXFOnpAf0L
TcFkOP66iJxysZjkARsZiMQ4sZGZeKyQ3pG6F+AatsGpNs1S3z7SmoJrDG2pfjN2qQE5UVJrqJCO
yWzOynY5vVduIK0v2tANTXWDHVa/Y1sxUkvFZmTWcwnCBZbVVeaujjNe9XsMAWIKCU5c0b9dRUdG
LfUijENpXlgk7KWjO/YYNXu1FxOp2X9jn4yqUU7HBaQQv3uqXri+K8R4aQdTz4q2VFaPNiHqUsuL
7vKv8+eoueSF07lodaEtCuuMy6ulWgby7OsH78o2MBspiQqE9wejlyeFyYlInHVAalmhR+/sZI1M
m3xaIIobmbDrZSa1sJ1cd4HDDXdH9xPfZ1UbsbPDKk5LuaTi1gL/NErlNaUwhVKWPl7H9wbyWq6u
rkQGnnyQrA9d7eM+tz7+B317e0pnepZtb+bL4GdLqbrvE+zskJTX8m0hT0fi7NtQNQzK6l6ma+V9
i9ymW3RsqAawwL3ozKVoJaEmqGplVahJ1v7cq55scGdzPMPNNc1/IiFz3DHoiuVeCXn4vJF8NeO2
VMbM5aDQzWtE+9n3Bc5JeyHMdX4nbrjQMM7LbKnTuRLi5ct9KXrPHFU3i0n3u6QTTDrU61EEKGtz
ZXtYbk4VRDYIuoHXtVNfp3LLr0lKs5fWqAWBKLtk1AQU1f8hrwXL57m6IjjNX/cHVnnMxDIbjpvr
1//MjaZm9GslEhmDlvkNE3K2j6q7Bbz/p8g9zQK3ZqhFwmLB1OsQT2IbAp7okznUyc/jiWmB5foo
9J3eH8HX9dXE7gW0Ay/WRRW2BNp+yeAC9b+mkinANO1zc7zaQAv90mePiQ+tKBaUL26Q+a5i8QNQ
eqwp/zEW8mRKZCE/sDLS2bjml8OJeLgYP5lIc3JA/LNGSXQkQa1wyh0x4gtJ8GInrrsw6E9nqlt1
nDhU30mJbQtjox49esGWrZKWfqmsbjhVEWddmS8pzsKOJwQ8vRuL2/dMI/hv0UOthp8AjIOkA7S+
yb0eISrgmmTT+Zh5ROvD3FWiN8k9YRWs8/Moajm0/pXMFJNHfvWLY5hz7H1dzuwRgifZozr1XN79
K2x1KgGhBjWsHw49G4OBwwmMcvT7dAD5ss/kuD6TL7OPre/8jc5fabp7Pz6zkZHgeTsVlyTWNuHv
RehfOvxe0/ZEdz4QQx+4UyLiqP/ZmAqRI0In/gzXQAJetDkISlpLUG83wxBVbIz9SE7XjpSIrvX7
aoULyRjexORz2lqajGPPE7zef6Z3/jNpb5n4nve1bwlHM4iOZo626es102nxaqqv7vA509w5tL/v
qQn4MaRkPlwd4gqcRC17t6iDRW7ALNNNbArIiYFoV2qbeOE0pF+G1emOGKPZTfJbbpX98ExmNa1j
T1cyataNtmODjJj0krlO366tqHHvLjvZ9h9uTGkAsaVnfm3w84klsP8kBDOCzSWYhwCHr1q/L+Dq
EgMQV1TVx7bRkvVNHBH/t3aQ6TLQBV6bqS98DZXtUOHBtvtxKBfSBt5U76Yev7PNjtDUiofv9w0g
WQWc4HmYWnV8p9EGjaUBpqRcGHnnNeL+MKCgaVm7gQTmgE2VQOCWxOlkRINYKn6XOiH0gIafz+I3
YLYQxj4cA7L+9UVQeX17eCe9W1sP2Mr2IrLFzvZEmRQzOZ5iYMmzeB+POex+TWoXP9Vu8Huqe8tD
p1+JiJF1AnmQX6KGUQ7njmt9Br06TiMXuP6BjtSKONefOF+eHs9eaBJDA66UQCzOBFrlI6lMiZvi
3HZLLI15v+TkE4dwL8g8GSvgMc01XFbJ6YTiK/GVMJ6OqylPn35GS/svVUw4cteWtORTuzsNm9/s
r+UcYt1SQaklZ5Efio891oT43uD5YqX9BfhnAO38loGNrZ9swaPrN+FKnb69SMe65iKFwlTzwyLQ
c2uqdq6/BjW0/Vx3f6uZFxQSnfyAXr686Lsu8q4H3QETR+Lzcaf7vcFq1Tozvn7PxaOWeTSrGOmV
biDeSUXnwtPvFdJ/TpIrGiNNtD/JR0qwX2NBbvLHzWcAriyNiTKBQ1h4wCxKZeZTbZKxBSrSX/pe
ZMklo5eC3o8LOY7BAeI8DYdgt6kT/upGHqyALUiK6zqUbl3N40xYwa9TctCYwdzugBdLPFkYyezH
8MR2bs+HkFr4snVI2oHngM/MCsZ67AYLaoeMupxJKp8xM88ccL3g5QQkl+GZBCxIXzTcdwwhurPa
oc9s8B7vUL0z62UqWxK5B2FSOKHrZELa4aWCsDPiefuxKXLT+i780ra+1oghwJWJWWxeE9O7P/zC
fbqRTP+LbsK70AkYQ/Ct7zJyZaiiufDEpQDwRx6rohJWemnctS/6njo4R72wlCKiRnug5jL2Xbh8
xoYpTc07z9A5Zpea8udXZusqlregLVFV1hmoWJKORXfDE4Bx0fydXrjq9e9WMrOhnwBJREXwojr9
srQYhFTwNoHyYcVunK4eRckI3hXwkLDrvpVO5fLT/e7wIYtAnn7MKSnVeXUKROq9dXC51NDOm7VH
3cB2vTrsHm1Lu8xE8YWvv/082jwfr4tYo8xYMJtpFX6P1Lcyj19nBe5yKpYRsbYAuE5Ooc6oC/B2
LAJ6OtsfTqR5jzQCiNhN1Fhw1AplQ2SNl5/6ffbEBGq5T+q9O+BRTQABEFkOSofFFRnB0scX1j8h
fMNE0wlq4AIRpEV3PME2DP72KdvcqMJg0g8JCNMutFe2TH3gnHAC8+D8b9m/qFCafEC6PssQhRfj
lHlyypO6ljU/HBcZHXLAGlzKMrA6z7NdD19YFK8aAjBzRCF+x4urOkEs37X91i+mgJHWUaCm5Qyk
3OKVhw6SLiUt295FGAYd+PYtyw0PzeORIH45Cp9Um0LGnADbJDVvBxHOiVrbp6BCqZq8to6pOt/K
7Zs8wYj8Jl8TYjZEImL2CBLz6FoMb9JFBWd1TwFp6WA+dNDCBFTKAR/ygT0EJlXAOVNQw2PicVDF
/GKvA6xZOOsxZUbdAM9E5C0xTDi2jhQHy90tM0bsP1OccdzjaSvHgoDoXEoSKJr+9/epqDo0HpVd
6M1lxu2WoT+yHmAXv5m1meUT8DaXKT8vvbDhKKFGGYSOM/iV4LKGyMKqB618ZvWYX+RCA1wZrw6J
fBsrFkCJsrO1WtKdsR81UxLKvMheqyJ6kAxxFTo6ld99LK4dc9UwA7iMpg9z73TrE3SNPZ6zUUIF
y37YamaJmivYbajB0vb1hAiJiJhYLw3mJ98svc0PE4SXJneuj1TqVdYYugl3mpXIJDigVV5X4tFy
wYPXGjpsKImsjVf/BdRHcy56Y5jsRq7UxySiQ2tR7IZYuEhUMBS3MSc8xA6i+vNPjGTpImNHtTO3
0wGEb4IRztKP77rArYFMcn3AwGfVRzhgnA/h0NWcFtH/2vEflJOKwJs+aZ3ymC4+vuIwyp+03p7K
WATrxoLNuCJa8GU0cMeZC/ftI16HeElvBRc3QwtAZPpRG7V3XahBLz0g/QQ34lvbAgrAWPeE2ncO
WDri3GvaojyKrTU+T7oiV3wE+B7kE7FBoGCuOU6ffn/aCen+3gD2+7dYpy9HY7hMWd1p4QPNAnxp
A8eiJfN1PlHwPJqV55tzMj1SHbO/T+dOmlAQKyHsKIEINOFUOeT4nnK2AxBSdOfzzuo3Sh0zIV10
<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+cPre2cTtVn64IfieC/XaMyW/1+zJ8AspbFuUud/Oj/ooO8LQw8SUREjMWpraADpQ2W51KHrHg
iK4noWXlRNSqmmEF7KomCocvXDFDuOO1GfSsgoIh4F+ITdhJMB88Y6ESMvUvu09ZAdAIR3sxTTIf
CpSTewtHZfyDeRDckMn2IHlEE92rMypSCdymNExN4oZ+ftmUybFwM1tMK+ZXqiiFFjLAstb3q+O/
T96KQxW8Ek6nP+lV7yvFNiGWWzx20Gmg2fZZzFKn4lWDRZiVp/DL1Geb0dzbY24wMZJe7Lz6u5r6
8qqU/tDCBia3IY1nHxyk2Q9IiSNBL2+NJFEeCuMbrrCjVwnNXHPv3kSu8sMODOnFVAvhAJd7u7oS
Nc66MT8LtZjq4Ap0sZikSaU6cqWmt9rryQQ/5A3Q4oJRx9von/OVRtHMYcKjSy9qdcbDnsqYDEk9
WIFKEjmUAyKu7YOZSWZ0jT0GBtLo6xwoyKrtiYv2SGHf1SLtaZU43Vy2FXV9R+Knww2qGgJvOkTk
tKEfE3h57fZgI1HA6LnAj/T1OvQgipTl7F90M80pil5/s+HuGb2whNESXcuN9lWkRR2T/ELNW/7e
fSjyqlOerVY+XkaIzD52deB0Bgpd2DBhXp1hIuRff3CAFo2rQ2sNYWjIofE23wupY64Qisq/oABX
/tsBqhbN/SuzGjYpEYWhY2y3mlDaChAOLtNq15DyXz/GMpOezQ8MP5SDytcBJb7A9JafpSQ1YXfQ
LQzT4i4bP60BSrbRZK8t9v+tU++sVRxfHDyEIG70BeByhInPVd3wYPC3AWPERqlIwa8+6TMonQYU
uCGkPzM2U/Bqxzd9ZZJzB5Jr0lDDp0aYxNeBCJcmpGdYSh2ngeFF4a1TW9MB7EfksYYFyqr5U1Af
Mi2q0Nlz7q15pvqxtLrebZyqP/uxcvZfblirCwg06SdwS5Lj0p+z0Yppm278VdIp8y2XaT3bKkZ9
B4ZRhRwRxhqDA/zO3JiSCFjaZ93Yx+iUnWqKXaqPEvTXpU6VwESXidNCqLH4A+GjPo1QDvEteIvE
t+VYIfaK01CB39ZlhEkUp1cJCXoBf8Vc2TCtcRofMtGA5djECMogX7bmzllsg1XVOV2S5Pcx42La
WqawpiKdsuhQyOi6yYuqnWwflwVo40RV0VgpSheOBZOuLNY5XTH8cOCcoBDhRcWK4IoZzf27Lm7c
ty00MuHDexc0xhicMXS83ze8sh731Q+awvPEv9ZqY5ezup+ix8RAekBeKANwpl0+hXdWFlHdD3Dy
NTHbH43GcMBng5BeQT8hduHpj2/ZFcrn0yeSPhkWnXc6d9XmNr0wes/MdIb9qy6p5LyE1rKBH3bI
y9c+YlLIhTo3G9TjsX2AcxjjhB+WxR9xzoj6wAsaFiSxWjl8nuieTSKjCz10U1JyzOlrxr8ciCHh
8RHtRNefXq73K83k/bdM2wBWyowyW66zhvkCkAmG6vF0QilaMkt/58i+AHmpf7DPDnFT+/QdaB8j
da7RaASzZDpFaMNV53FMgNzBgNvnYWgwco2n8T2S5XgQc1rRzZemI0INZf+5EV8qiwaCW0EdRKht
XNJV2imnUwoObG9PXKdD3kdrXkGeQayHfzDxWaj5b1UkebzjEuzgdZ/tq73Xeo7SLscE49r7PpKT
e/cVg3+XogpeN7VbvcqWukIkeDb75Ei8YfWhTqGdGJ1l1C8iauD7VFleJVR8QS6DIa/U8RSDceWE
nuSkCaWGhL9H6gxltODX1hP9uAe2i74ibAzy+Qwwu4f52R23BJ9NpeZp/1nJACaBYoikLYlhM4ge
VnTSy2PNphpwyzHlbNHImkaUlTPavRJiMi6JN57iw5xc6gFrkPxzDRXHSZlhh/gDCTzY1E1KCd1N
StNPobCQYX/gtOowkrROn8XhvvMlVOHSwXVIxhf5PD22fcN39UKhNMdg5gXHMCqplcqEZnvdU+ep
NSEampulIT+W/8NYYXgYelNtXcgKwBgLb8EUQuM8p4RLFeiuuGGS4C7BLP7o5hOxzAld3yg1LNrI
AZKZr5lhDySv2bVBbSK9QVWjR9R07evEfFjjKEy7rOEBbbKUtMgtOIIbrcr45MIWm2WmIshQm2Ba
TuoV+TQ7IC9BfZf8ERPiGBeIN1LJKQLViVL7D2vxJZtbbHGLL5pwWLXBQu7r0GQyE9/nhdbqI/MC
ccM0a4s/co5EkIUqvFMsmXZb3W2+Wxos50hXx3CtYooEU9bO7z01sXULTOE0fIJwA7IoSuGljyew
XPQCVKZApr6dPGITxQfqJ2ab3aAwhmtVOpY2FOy8JQnB2ZyKqyLh24l7RDwT3ApIusvwXUpgDW0h
o6pmTDJ5wJ2dZdmj6SIrqcsQvXnGthanPor1di+aue6pI1FrKN6VgDCq5mvqW/ghmJHMYPazDAPp
me+trufnj6vsTrg+tpao7HDz6Toka5shWT0uhfapJLMWoCPGwJPDqVkHDK/P78EfID3M/3UGt9UI
hnC0a2U1NhxLJNnjjT08KTdWBb9SCGv0W6ae8aOZMtBzdEu+z+FZsGPtIWmneb7Qsa116JZeIR49
/fzDbqAjar/7xPgG6aTorQCz+hlUczFa7gnZ9J8+iE5cgCJUJU1xcVO2w410xe4zds//V3qF8+vU
7BOucOkH/rNNSQiGSwmuNf31VY0UTQ0P/lYkp93cU/c2cVvt4qcvZOPjllSjL5acJSSmd2t/IZLx
O7SJ7r5vVKdmjTkfxQA2fnR9kpEHt/aDGJuFq6kdEibnXSxdMReIfnTwr4xRSwQakT1uszj+p8yH
FmfvTmpP4EIsgSBXEMVX2TbwghOBt2oeKp3+KnCtKqi1pkKRnU4GP2wghMFvAoUgNHbQYyr2TUf6
uU1tGV4IHN9EZnTrKI1Pd1FnL6MEfpt71hDAQG/IMM/w0tlhbStuE84Tw9qpYdX5DaWvGJTB4R7x
pKcCtC4B90MjvXpYjkQKJu+jrNA+TV1WQDTxr79ESjHQ7LzKITqCSa9luIm4GggrJkjUwFD/adSM
tpenR7iTJDIgMXCxSxhYFfoXVmOs/aDaP1sarDhVGbQonJjoIRLDesz53o7uWecvIqVFwnI/juIe
ZAWFPYkBTeWSLY3w5FqeMuO2YL+xOTlUZJJjRcVlVosx2SdmOmXGHYeaUcYDdCg30xxr48UWOuse
WNWiTVWq8r5kzyacgg2Xk/OBjOXgNRnc5XIqTPfRkBN1cZ0RTjb3nOqO64dMvW6i8uy5EIX6adva
1on0hCR2paM3fb1D3CfbSfJnsJECuGjbtJazZ/Pr4n56NyJYcSWQK20n5ySqW347qsilqAiHeiRU
uDKleGl25EjoBq7auh+IfXdmqUFGMtGJ0u62ByDRxx3FZrs5wM1wDdW7GvBRLxh/w2jK+sXsY739
kT5DWCIk3d4dJq9CFt+cDS/e3eeb4WIQZ+pR3sQaO7vzCQsc1y9QHTXpWF+jY7mxeuCqHAuXdlMx
eCQf/2byUSAQyGTnywjKReBu4W/ytO1Hvc9fTGoBm2zBUYxZAzXB6qbtD63NsJAtn+AEKlwurFpq
4KgI6XuXC8w+OtNaAme28gWGVN78W32mKkhqPs3dqwUJ81gVvFABl9+OgslDNFn9mbtMvGogVTek
/56HJXf5japtiIwS1mPuLpVwuFFDc5HLJsJTIoSD8sUpBBpDRR6LV8nUSiIVYG1UClK//O9Gc3vi
c6x6Ea0nIUX1bxIle9U3wXWNnJXGiDRaaT6fo7NZIUlgcqjAcHlbGgHAKQugfp2lgd+Wiri1NSAB
pIYLfHRzlGkqg69idUPh/N/6acD6gaAEtyOppkFsFsh9LenSuxUodB/Pzg9XDB7fgXjEl4Js5Bum
YZhDvBXKlY3Q2ef+KXI5bI+pGd0jfCyCZyH9ucfVcvKigv8q28DmqTNNXVXVMR4LaFZxqPU7FWiZ
m2wrg7xZr2PCVfiNRZZTWNLOihUcrBWXP4q07TmWKj/0maLXe+VsZv0gvNFXLoG81XHXO0nyBaGI
0FGLx1F1aCWXyr8Fsno6equjSj146HiwSDIHAAZT5mxEqykh6FTcVw8H+YBMbGEyZziFRy/XwOXI
0XI51DCq+nZm26CVgvdoWYkz8ifLNH7/GS6PXUWaGOg5PEfDZpxpcAhXOiWmAuzpjRZaguRE9tdt
2slioNWVIlExl+CZ9cCB6nNzN2lMkvHG3TOic4uKp4DvzyL6ZV7ZYzOgCiOZiRhFBHfVKfbrUwCe
UQ4Vr0Sl35KsK6o0x4cptXAzALx5ig1MSJi9xcFQEgzIyplBWY9SUD2DjS/p3TouIX3yo2sxXh9s
5BsF+K0PRqj/FMpLz+qGcgSKeflKoB/PCchsizk61cAv4BgC31dCxzYtPWnZLYvJimfhiEe7SDMk
DtHyuNAX61TLEAbr2IFG1LOVGXbOkDL3UYacogHhr03eqP88Y7zB8CmRHMIBcUsTZQyjTWanFMk3
H5HeVJgMFJViQw3J9cLNbPxb4GVc/61D2dHbfu6Qb7Xvb/iCs7QSeLFIc0pV6SfHStwQ+/0qDPJC
4RaIF/howQ7uYjQFt0EkZRqh5ja58yqO2Cforzc2GrwCE16VPrGIGVJ/IE4hHugAvKbj3XGBVOL3
UkGbPLbnmuZgj7nKvQp6tS7UXA6v4WfQCiRcJFLSWpeR9w98DzPxDUC4XN/Urui/693Hi59RUvDY
laqWQx9ysUuY513wPYsEyn+u2HCgX2XRk29CJG/a1AKO///3d8Harh2YU7DS48CIfstjDZ8lqXm9
RlPsGcvQDKD1LQYwaNFmx9MNtZK8nAmeY7Aix1KUeol0OTIHOKfEC/0VvmMctKxXrgJFN6Ktjd0c
3HV2bwNTkgkZ2uLWsg3yw/sJ1E37eF+EIZYfPlazDEeZRVCqI5ug3pf2pK2Xb95xXNWLwJKUWLMB
TK4vkOwQ4IRKRbsbaCPlvSatMgbmcVL6fdHw3n4t2U6Y0UQAliZ4tZPK8wpjWCvp04qe+p7gNCiL
WkDCcwe6dhGU4VxS0hNvpaA5AlIaqf2URZqmIGZmBxMsaZ9V5LwaFTwzpK9zHlX6uQrfWsmOrv7y
7shWsOgaxRk71LWP3bmwDExPjsS0usW=<?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+cPy+wR6MQEbLBOsVvHd1xxVt1gP8S6B9H1QIu1ugNV2Hsb8mRkahGryjNVYZx83i7dVpooKKi
J1Z5aKlRs02bSqEgISu0/q9OVEcV+IB2JgVB7aDu+yjpgsnOSk149B//ARLL2FN+61P0o7duPaTU
JM6PhweRisFjVYdMCA9ymyvcdUGfbC5yjMPZ59JY4DWAuUbRxFSqhaRXxUabyi+aVFr7sUeRtaQ7
VPjoVhnpGpz3naz0peOrdRJ1ixweDj1/hq8HzFKn4lWDRZiVp/DL1Geb0iThPMw3jx/RFNsX3rr6
8qrO/pLiiqX4hkYCvQ7OKjOw2SXzYrr/FWaEf9UX3xx4NdUMuVIzvwGgPK+TfYJVd47q5TstNiSk
+kaTTXVc8v+Xc0E1hkOpneAisB6CdzvjN7DJs6weu82LDn5LheLimOPWrzlwp3YPSPypjx//EQ0c
EePYpdZ2nbnCUr07hEXM/eQ3iYC1Ob4bJQFVJMaeCpwTm5JVQXKnRnhxK+tdTYgMdmeqlMRXRPnu
03vRCnAfZyV/AtAKOEJJ5ArgtWk8hM6nJEIcGSXRCX0rytNppFFRRU5UFS9rjngfSZ3uMnlhwzrz
2M+PMWYMG9AUIvo4/U9bbOg7QCLQ6VUV8yVLc2LlpsZ/zmTnDRQivX81G1GuTf+TDFURHcUp39Wq
j5KKuzoCjJLNr4R9kHS4JzhG3mj6SCP3f9yutKkjSVlsOlKs2/Hfl8ccm58uzvj6ZjFqDIuqHCNM
QSuZHUHfj8GiigCXn49CzAhwROZuvlvFSDkaLONjT9MDa+v/Io7/e0wtpKkRzr472klg1TxohWQf
VolYjwetxLfrhexDDRS0VmeAT/Kk1YPW4GrEReVr++uH/Y+IWqifgHEq31YLkOp26+V5u1vm0Dz4
nXF8t+Z7b6lWhX3dJn174l2++oKRJUKKrwemL5Alkh1Pn0Y7+DNDaCVuMAQ5azTLqu344TIfgoLY
P7t55CFsD8sD6MaZCBbXyu/OPMtd3NDUcPa0d8oFh4+LhET7QTWi6ZFj+KAJwe+4zIdot8F4YIXn
FTiSKv/lylFfaq5Ai+Xu//aiSYME19VGxKE0Hjy4lYu30vYTBQjHw+7AMIJCnYHNI0deCG376mik
R8FEsjQoxwkVdwp7rHMs9amitcjJ+/YU1PFuJAIAXV0f/ZG5pQBBlYFBzagXhlEU8RXTFzvkHRVf
hLY6ExnJrq6crXDdGjI1dljZydg8B1vWLl6Y3TcKXnSxbHj+an15Erlph9aao4JZRxD62cvnXc4D
ezV2+e86pp5rsYHJevUWof6+KYOFmKL8g3T4LX00b0tetHrFGfnv6KlKKi1IQM80znXVrHWJs+OA
I6giyWM25sggpR9yWjeRDcE0eqsrzvzy75TKadR35G0P6hAiNmeCSzDjz2FZoe+zH0niAmq13ex0
yZwuP0Q4qtvAFLN76NUuoei5ozAwgJSG4kXmAt/WsjhWwKz3HjeNHeGW13C6L5/NfydWiZCDEOEN
/wSgWh1jephUIkK+0dj47CEbzi94HTh//FsURMjatkUO8WSEbxWpGHrc4Ju0X68Lgmsygn9vFdt3
TbhDPoDvwGeBPyYSHZty2nw7Zx5GIq27RVRwZW382Ud87o4LErvpiTT7m4rUGFTG2iBoWTtj2c6p
BmAHR1ZCKTaW9f2/3aOXbomd1/h4bx6tcCP1RM84yahb68U93lGZ9iWNkhm0c6XXaD5yZEmlziyf
Z2jHrpDIJeOafAqs3V0kh4IQNswywoeK7xg2kLZMvbKd8LwpFpPhAHzi8RxCLhOmMbmqGGzMsLa7
13Y/wSDgpzYE5lAa/65XfHuRsyBI4tItPPHj11d6YSiU6V6o7sQ7E211tsGzhjMm8aZZFae3yML9
OWLcLhXEeY0vf8qsPZlTn2+/gyg4JQ9xBGNQClVQYddmj1IGsKnbDhmhHVsPuZObO9S/MMgEP8jA
I4FaagIavQAgBSKKgcqBDtg01blz88OQA/0g/RkwTndH2ZRIPOGKfkj1IpSVVwgKTIs+A4uYt829
ueoN3jFXwOyA4luOMiuEC8S+fXOsj8zZeX8PhnsK8JFj+4bbEwwLgsiM/cD/aFm2bOzt3CPw5eNp
ZW+xhJT9pOjPTGGupb9RbIuOjGX6rhppZ87qgYzd1Y6GJv5irbru0P9UrAJ6mNz2y/QImiUlTAMs
MgjcSg3pNS2/Oajx+R2ountyhwDuZdzVB85oPScLIubWEf1VXkCV6033FTjea0Dd3KwEtDtDZ360
SwuIvlpui76fLD1/JN8NWmwnkY8LhjpuX8NSZUOQR1RJzl+DK1pxQwOL/VLBqYyCvIYEzIsElKSD
BDzCys138nC0uEHczTsz1FJP5C8RPANelmYf461s/rpjeQYFivLEwxFsrfu8ifcDYOuN+eDpCtce
+qr1wcIxQdh8iWuXRTRsyTV2XDrMZY+FgE1t6qi+QfgpMOjaozWcYf4Eo/ZE39WPqJ+VA4BoFuY5
M7RC1Im7xK+Q/Gx9ST1158jBt54rvhCwlfg2FL74BBvvFNWFoXzbOIGxAqotlZVB0OE9shoObxy3
UxucEjgIg+RUz/LKOS3RSzYwxoBrEM1L4pI2SOTqiZ2t+RxZoiv2kbU6Nry/D4CI4PVLBfua0YAA
4ygbAutHwOWnxub7ahNs6zX2JC7cVw4PjkfoJEduuntKtKje4XaV302198bEVNsDvm8gvbfGGgqA
T1B/0rgwfs3b8qZFaPGByHuVtpsUgLYSxL7rmlpHzzVNknpH6wLFimgNoqD3H6z9dl1GolwJV5/N
D1y68idI4Pp9k+oov47CxK1DMevpd/pZP0i/rC97AgfDBoR3OyJaXcYrHPplDaUwZMqhZMeslhT1
WY2+CWrjifhdj7JRE7qWKAMmfh230MNWXJsQVmOwZimqIFCaJKJSyiz3W6uEAV/VCf6L0oEdGp4R
iFhIJL0L9+E4Z+X+XJxghh1daa8oRhXz+0FB7t9VJiYTclM25f8SHBtlNEsPqoYYQ48PUWXHx5H+
M246mrVnfE9R77Q+mtCEp13vNmSFcw4qIgHhJYIoAOF6vJjvkZw0pAmUFiA25YaM9kYtg6C4n0gO
vtrKhPlxZtoXHTIpEpaa8Ie5voWNV6N4z76zfF1SCVgXWWJOg+O6qxqZRthDMFQlzvC13bqYtLX6
r3K9dVzT5gqWkw/+Wx+NfVXhnrZfhbzX1IRTEtMOzyWz7Esl5oozJI4DbxGX7omJaObbSWHsyZSX
ajSgThPHLFTZiGc92D1/kGgsN67sT0diWeDWCkG7NM7wyf5Y+UAkIL+xCrjc1wmCxQpbW3bmXxWY
3pF8odjrfONODFLYSPivn4rbEFuM20HHtY9Txzd1/cOZulooxoEoKtPphYkJ0Qw/2b1gcQwdTZ6P
+BaGTW1Bh40S/vlJTKFIAj42U6/IWOZEbjjuFk2JmDnVwvpTlFHOg5Y6tFdlEIio0XN2mbDO1mi5
TwoEfB1yKzxxrxGox0Jbi89fjIwfnclTwhoxTWc/BjGsV2gUv1oJiUjzcIoez6oj62etBwViu4sK
d5YZT2sO06IwH2TtlEyk+4PrMg4q1On/3EBncDtdTtnP0Ez/uJAwX/ueI2yrOGYjBiul5pe1eZb8
XyOZr+PKZrlkAVVTgqi6gSyE8eASjpsP64BWuBSvuDP+f8hs9Z2WWPaHNiNC4yaV7QP0KRF7/8K/
R5tLJwHr9OLaQvaSITnDj/aTJLHuxIH8SgAgTwlMHwjSVlsiYcA21/CtC98Gkb2x3WgZiWJAt5AP
H2eE3nc7XgU63ZG1bJxE92UXj8ZVAQj62gMDZFBXkrs7vIhyQAbpHJPYlz+xSLIgWbr0+mTWfIht
izI/hUms3W9qcBrKoFh6MnluvCaIO8SwiaYWQngvk8ihlPwVNTf9br67ZosMkoz/9kzreo/xPOBv
BdpNEXtYQnLzMQa9huyIci6zV1ir2daMFLCRz6BmMjIGz4N/3QPC7ogZykKupv9b0gTH97ySIVHL
Dht2jH5/Zy7dOY2dFWseAMSFQV91QfdxnsAR9DvmE7ZKa57lDtqW757C3/fWR2aNtWuNODsoYkgF
VRZohHy/1GWA6ZIWVFU9Irp2urvOgD9RCmjtQ2+bWvNt1wEX0Ft9toW40ocbWyUMM718QiPLuwMS
2UV/7ML+BB17P2nmO83njLQj4b+CY+P4i7wm8fHkMDV532YVgt/v/BpBIljuVaciMhUjjBKAhWfO
/ySDaw+zPJN2AfWhZ1gvwcpuY7RyHyn+mpQt4vuG6iLJdk+qmXwCP3NjRUZBt73UKYCWc9YPPD1D
w+JuYbXKoejRZ4G/hi9JkDdBb2Ipl+tPpDbSmmu/Ii3QI6HlYgOVSVtVpAbIr/HnFHGrINfQEx8w
15Xo/Y4TIOxrva63KxnvPgeKFzCo8MrhaJNs40KseEPdd7T/1uY3pIcFzw1B/pElD/CWu1uN4b/v
65z8QW1z9QlVo+d9HkGg830PDI3c2BbRPk4RyVjlPemwhv3rRY917GDRvWT9d8YyR3WJF+92VqOg
qkty3VxkY86g/uOL0B8rUbOXqJwwc06XxUrUU4QbdbwqwLSnvGP1lm/AOnMYhz5DFXPWo4wCG6fq
bWtEouB1XdAibANVwpdPxdHpbZLkj4b4U+2k+ZBa5H0oN/2MJpYJsiYQ5C0+ATjIz82MCgniDvt8
mTYNrKLmP/NO9UmVC24zRhKdJ3NuIH7GQUIO3zvJ37bdT4s7gYmVqbLcp78S7e4F2IQASazxL4Jg
C96ygybID4/DyQn1R9X0657/d4zwDpF7omlXcZ3G/WnNIrBCY5hgx40tOSPTMixJMwgIezNnrTGN
qHye6uxxxLBblTwMocXMSaa9xmySYnrO3yP1ErrXKxIDaTXuBsWel7MsumjqxXohdQzJUxqut8w4
go+vdGnPVY3az5NpiZT5bbnQZ5nJGPTW78ZlFX9SZ3bywvi0j0R8cJMTTa/gE0MbUYRhlHaDLfal
MT+ZHI9zLYIdNu8DNj+e/QO+1sb96YvzDErQp4uOsqMXTvoccJiVEho1SYsY7+vKlUyM0Vb/6mKH
60QMlMLnsFu987thxAyjQzecirlidIM/OoxKPotp7VCZvO/qSxqrn0Y4+KqcSHMwybGkdSmiOJqp
Uf9gtIUIdT0hUH+HXopfdWBkt6+MAi+FnwAo98b7MnzZdmJQnCUV0Cwpv5PkWVDbmIRMw09TnxG6
vmB0hknzZyRRUnwmY9IpexhEAWVLqVooWhTwR/7PxsUF4SwF2tY8HK/zvGOSxH08WISliAyMm+qj
cQdye8ELEdi/Cjp497/Et1CgBAgCncOanwFD6zawK6/ev0J9jQHylRZHsAFXzejVZ379ENUVxqQd
pL4OyyAX8hPuhxvpOEEWkJ9acaPsuvg47b2MwlVlTW485nIeLLVSR1zBPugVOsVJE1qZJHIjTHzL
s987WeVydIFpslDBbB/HDIoyzanF/q1VgTkXWPbpMyFwC31REc+XxhpzubrSK6ygB3EVlVjayNQk
bXANWh0FG/90UcdWSel1+DMy6R1wDyCdkcSnyoH+XubwAyeEv3tswzg6i1fF8qX6gOzH/mqRVYXf
xU67+6GSCmGMq3ZrLsmjtH3BHlmdoRKxJZa7KFGKSRH9MmM0/fHHV24JeZ0FuDEoScWzX5+YOLpb
NPkABBnhebN/G1YxTq8/yHJL6smCbEt543HrnQUD0AEID8t7C/H8Ve/N94MxExUNFidRLDnrRUfi
zytCk6smXA6obTQC4d5b+rYT5Qz7jhFW/AjYXmO3h1GUCNrINRyRlhixOe1sLwdB3cqMedAxTM2g
uzAgPMhiTYIldu0YGYK2mOtPRHPDdYYccDSQTX6Vt9LjKsxUPzdRI4d1ZNWpqKkO3grUzXkt9Q0d
dYu/5FFoS8bBVlNiWGaY35pYYYtf0HX8jPn/qxW4LQ466DeKKXvbX6564ZqIdSJSKt0JGuLmT3VG
PPFCwcAcUu1BI0O1eACocQVWwmtSFeRdoK2hsTeJFlZRA4uZ0ua/6NvnW/D4QeLZslckbvcOU3Lb
KndwMP4Pe1/nYXXnsbW3YlbTYDlNDQRGhcTkF+wXxi8Vz8TH1CDIiXdVD2uHgTBAa/yaJ54LrFn9
/OAffbjPPg56aJROSe4g5RmHRiOIl6bcs6ytBK5upKOC8wskIrgSYzBkCjdRIvzNmqoswgbe36Oz
M8scXhyugLJglmmBpmPVdyf+BynQNTfSufv9feJTx46Tc4HckOroGpkgjd9vnTcB1sldm/solMR+
M4orhZKYxbpS/j0zUYMHfzEHEQ0UF+HOGBUKlMPZPsK5fh1BbS0TsxXNXeE5UO7tpl1aNFB9Z0Iy
qOQ+3CPzkA3UNH5gZhd16NYSZQvYdE/DsgVwwR2FI10R+oOgCy67JfXr2CjhATNXs1V987qZYWbd
vLeDGVgfifZ18/D7HiT93IQIgj+vkxdgR76ua2jOZtebXE2D8v5CAeltv7DsrV1USjpqnQ0FDBt6
MbxZ1NjSs/2gpCjrNixnTUk6+qiC73VEiAGRcijXEMU6leYMGF20EsOVm/SkPh4t2axLSC9CGwvp
rd/OHYtSrsg1JIhDtARIEL1hpE+dntaRi9EvEmVdagth+u2WxKJLxHYxzURO+VrvvX8z1SIiEdiR
BACsXWxFTX240I7ioPtL8IjxVtvqYJ3J7jxpP/hLnI+KFw5Lrxe1wNxkXR4fcMKE3r5lWg8pugb4
PKryqlS7OrWit6pyYFXsUJW6JZqLn3XU7nFcn9goCeNqrOI5EGHKlGDly7voOxhOzXSmE/08rfnE
9YEeZWqjElKH27M036sWBmNJRbGoD+5wXHNWJXKonHlGHKIfj4JmAMnGw4s7cmIhaC12GCPUVlW4
aUUzkaV2lo+VCETzsG1YbBZsT0/DQWgTvfS3X+V6ZM3bdz8UHELDCHG1k9Uv+PDhOqRFzgvbs551
5zbvVEQwwnwyIsiUjc8eP+icHqZ7O9S5OZ946zFyBla7XfNEuYUY1CSgAoNtIF4RBKf4ELhAUMiT
AzzUrIioN1jDpyU4S0JSZzKGYL0fEXMV6a7vxCRfRSgukoBgDJ3bdDTnWg71kLovJk9SNpMMJ0Dt
Jlh2NyrWzGsRg11j+FqFaKNXVTfl+ZBI/YhENe3YeIfFEvBvTZPEnmNhCr8A50xL3G5cXCrg3d6t
vfhSyibt5xsEgboFU2XUlFBT2Oedrv9zoBHyCMnh1x/bCGJh18AoTkII0/w/4VgyhwXiev2Ac5O8
JksBxjJladjrEV8id9kJtbM8PlfsBD2mXrEc6taNo2hFjC1EtzeTeHru8jeKbwkzjs7Kpl7MJ6F2
06QxqEvIpGdIZSFoYh/JWG7o7+N6d8YF3uSeiRwBKWI5dtiJwguEbMuKMKSUmHAZR0JRdn1wvw5C
G2u17iS8qvu+/0vsKMmtNP+h7TODgX4m96l+v7Owka8sP8pjk5wlW7Iq3/R/BtaOvSvnmU6Q+73Y
r+1XpkSOJwwUKweHmoGPWiV067Lb4PI0JWyMc8htVl/JLjNs9IITuoJFhZiOZKT9EDS2ElnlDS18
bDpK7cxCy9wcioscul7u0Cm2ymBujRPlCNKpQdr3uatgJ6GOP2pJoYc1v46veXEiYKL/4uyI9+Hy
AQab8FgfJVE6+Y9B4bUVnsUooJNjSflHBIwvvmWZ+FkzAROjZnnfVNQHU801S3/s5V1gpdxqzGe/
HLw0uxdi8B/D6Rv0/k57vrSspoE2zdKoJWW/q0AhrFRNgJkXjXqfcwCd72VChX/T2U4O/SaxTBRj
PDUUiTeOlUCl5OrG9/IkUUBOL+gYWlEDyd1wJjl0btuBsxYlhq7FFuF4k6CSWhjieO0SydWFHE7u
uEXFiYJf9EXdncNmPyXmSiyKG7zGjnf8DrF/Ona5+CLpmJA1gSPARXwFNEhV6zBHhzRo+pMXET+I
OcnKwVH7T9nJvGb+sShnA8J7qDFseRIebvtvV6GIhDUhPiLrrNEwBvct1/d7FJ6ksb5WwEUVUMrq
UqJJsJ3NihFAnT9ldyetQa5aFOrK+YJj5tIanLlaI20EZn8CaoN9Qo/awjwoxFftdbf3rR+hmdf6
aShuCulABsx4hCg3i4HjWbZqv9mE0vUGT5zuUQ0hSJzSx6l0K9nRELWjIvd7potBDS4xaefQp8M6
1/DoUpABfGwAKNaPKzt5C4ngzsvBH9azXmWY0yoxIj1bzdlqRS40rAdytyW/SNWfenE5+0vrCZ/f
j2T7RKK8PC8Nt17le1zOwXVcm/zVDg06JMDf3DdiVgAR3gzuVxTqBLVAOn5okF/0DJ6AAd0u0tma
G81+FbcI7qk+t4nzuMK1A8kYgrlGeCL1FWUc+LozJs6KIWatJM0BbSqDDVbRGfQ8vyqjlIY7fHqf
zMUX7bvGnOd0EGPDOICOL34uWWAZliAkfx938bkNIgTl9vl7BjrnGl4xWwhBc7S6vUY0EKRvOFWU
tmPRe1C1foZnaTmujetCEHavotREXlcyh2KQo987vF01hu+PHfwfexezd/BXGz7k2M+AtswS8Bzz
3ES3nwYiOpSbnSw/Agba7nIdAU6Kr1pU6APn3ekCMGgsBkxupYeLUd6UcKywncJF+lrGapr4alGg
HEnBifQuM5JqQ5SLJe7mRgcWra1wLysY30n78cEnjEEHer6yChVNfSo8tOEBrqlAkmPMIXRDifGK
UH4u3LhY6aPa/mik59i6oee0U+/IJfC7NkgO4oSQmDnE6t3kkZ1ixvrQPdys++F5cN3CvI+zL1OE
ptlrX6hkAPAi95aq+otz5047XuMShl90aFkZHryLU++Y66vdX/8H6xwoMV+PH620oipHcOulkTrG
dwPKZW+9v/iAsYIuvETj0fhFJ2tuZ0cU5wFgkyiRR/Nj/zcYqEdehW9xBtvG0HxbGs1DqT9Y0d3s
oNompSf3uNKE/pUFck9C/wF8tPHQVd9HYOGxyGY22ohYqJy4iHQ1CLzJQ42aMe26W6AASugiqT79
XsHV7AvMRB8oG1Qrii3lVAYLjPR6jrYjaNNVrCQjzSEz2klr4gz1VkSlO3KAqokZb9lKK+bhPRvk
M2RxpaMzKA2eTJhwXC8MqP1ODuqzL0KwkMHQfL+KnaJjm9lw4HGrio9/eJknlKpcmXDILbceefjQ
DweSrLOp4C8qXRAU1xmcfEUEwiea5W/xCG3xWJllTGGBXQePjc3xlGLtdDhvfeWL29KC4HpIi5cd
3/5qMDDYvqCvMHnIQWI+iDlB+KbZoy0JUnSgswguz4qFGLu8G4J15mpeLE8Xeyaga362A+l0efSn
mCMHDN12OkK/cxCrsFvdT499FwGGY7FVRnW23jYfCY2yYrF5mPE6ZN4X51xHYnSDD3+YYByohckH
hS0LQvCUygGLbKRWw7Jxtj6KBiPGSAXEW3qCGm08iJrDEWarVr/fHi81DizdBEZgLgug3AsdQEPE
yv1wwwe3IBcc/SbULcb5hjlIhTdv9kDhf65hNVYgreCwRucjQTd34SNX8+EW8sPxxbQQbt0DGLx1
TSXaiOHBEpUWS2Xa49vRgRuS+KCRUVoB/uEn9xoh5CC5TMo9U04Ttt4pS30Kxm5P3kNlwaqTC03P
OpKXTUWYlFsZ3Pa=<?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+cPzIzRERvW5NAX0xvnN5Vaa3fSb/uvX/dyjjk/p3saZaTv8pgvzeAXT2NGS4oDVF2WlPXOq2w
fJMm5p+N0IyOSaR1AcF6t0iHoKDtphIgIzQalwSaVERgFwkqG0kyuR8Wl2BSJfyoRBYnYbsqm/js
WMzsPCmINLethuDnELzY6kCQ0brBy5/ttt+jIJFhngO4DEioAu2ni7eIuAi5/D58PGoadf4spu97
4TbtvxRdJsNtjTTfgBXlMTJNmTtwFQWF+x+GX/JrCHBu3Mux7y/pLGKA9G8YRzWxhz0fn3E1dwfT
1Y5DNF+rIdhrXfXikJV7bHru9U8t2puq4rFdm2KiPjfUpRykJ4fIbOMz98hdPZxtOzSNPt9zOXB4
Z/TgpnMYnrhcuJ/7nfNaddajykcQyYBNcTNgyZFjwGFRHp0Z1MCTe2TSENQx2mJjStMJVQ25+mc8
KwDd5vM2p5+W4AJeXYYUcyNP/ezWDm2Prkf3K4i6xkiMA9EQ/x/IiX7uu6qdIMeR5DfYqp2sATy3
jjcM6c66jPlNYFynh6QRROFWSsctFOpC0k+2eug3RdbidjXQ1xwJsyev3PRiY1xo6WyGK4Ad6g5y
GgoPN5cntl5LkDn2b1ku/RJDeo6KPHLTbjC3hnYG7jKbvfgmV/lKltd00+JHxsT8wM/u/9yzknle
59LtuHbJaBDj05KiHGKL67HSImhqHpZ8rOjO/M94lpfvxPl+QS67+nD1a1BS5ViH9fXw68Y+8gCF
ldpWotuogAUYd+fqkZ/krH35k3kga4O+ZMI4IMnl/Dr3BxZVNbz4SDMmueANf/jmDVcVAHmaoup5
6dmC3/2SEIw/S4BoQWYMYWOAGIJ3gpOmTuTvkhpgltoiclLrBq3cOd5w44Gfj5tKBKyqQMFHFYga
jWXQqyYXc13iIKtpbdAbEBN9oLKN/zPC/+nynpZ926DrwJHMXVbf69OBiPozGW7mSG4hlDA8AcqC
Lpc37WtDlNl528lSByjr8lie9cTD0mSUjMtP+cbZaQaVAIxzKFXpCvX60amlOmwA7Tjq7Gke58n5
sMIH99iOAxS6zGur9qswb+2ey7wof7UbpYQ3a+qEa13JvNh4OpdF7xEfPLcko9rXt69AP+KUTBJN
v969xVb+Z6ubwGjrsFRA+LI+lvonlxaA7CWEesxTZd+G1KQhrhUz0hhpDYzZEzojLwsud4xvej32
loyCIcGodhBRWYN/1kpGQRBQJR52pev024zABKSSXtvKVYIRy40vAFegZtkbL3InhFWNimW3RRwg
5GTXnpqPu9dPLaHcaUbRMtiDC9yWCDyhTqgTaqcROPuW4twqa2aH0mRXis8FKvk3JYa3mJGwYV42
Zob3MAsNBrVjahxtSxHo2Es13CvsKVGfmw4loOVg9NBTm7QEeyhFV9qBNrlI08Hs50WFnCxrwBYZ
gozTzAC0MtL6Awtc1sMmawQc6YV0rlrYKNQHxyRIxcgjiVla7PSqjJ/77lbOl1IIcOh2ywTEPmiu
Zu1AtGUFJdHLF/EQat0h1GELS47vBK2dYj2vSkmlWXWHHpVk28wYDQoNvyTR4rUcEz8xs3E+S6fS
YBeF/6Fooec0cUJoCdwp6How0IAQNnqtnk2hRMiuSm87DVekNyNO7gEGS6443sW0aQ1u7F2msh+V
568I4PQdsxPb7D3/KdXCDELhUjw7Nz88G9MIL2BYRUevKHyMxo0X+xmqZrotxwnPK4tLNtp/p++d
wOg9O3ccVJ/V1vAkGSV0PvMMGAZDb9Knu/0Eqybqtwc8ILQ7cDFwQ2LJSw3FOu9M0pj0966Ydk52
YFo8fejCCzxYc1THhZHoIxuA6WXQN92S6Sj8pXVqXbHjThsHbfljwfIRw3lt4LrpCA81ooHu8K7t
1vPanv0LZlzaE1uw0gx8KRAeJiKnxp3DTmTsycRNqVrDEMeQJPljyXLtkW72mDCfdB6lvXh9zDB8
bfW2DfypVq4hlTpF/so5f+4xFeP0Dokv+b6KaOt1TwPc9yMZgs71z13wOxMUtOOjbIUMDMFFkDxy
EqrbzQ4PNWsbcSu1ErrtRUprYpNInWyWJH9jAjUJSxM9QPz/rLTxnNRu9HtKfHX0b8tcIhu65t7j
iKYMM/9UmNbOi8TyuVXjgxnlw3wRJ7duvl6WcwWf1ZQW6KaMipqb/KJb/QUsu/6DLZT+ZkRdlihf
S4w7xZb34FFo6opDHUnqUGXu568I6NBDrahQDadOvgXA0I7wmCgrZBjXsNJsoUVZk28pELyhQdce
bapc5mUoybRTIEqW48qogvWQB5nWrKILqwsna25N1rNwomelLwqUzEBeYm3G5zeYQMsCBL9/twbj
wHykN80lbtmA6i/J7Ak8+dq4sVGseFroHyNUdfU9oFOKFlbI3/zLODyjeIYubvP7lXTXWxaCGczw
aIBE5WIpE/xWX5Fs26OvYPQCfVJ7tcJMjZyuT3HiGH7iHLwoQ7uKiv169Y0HphrHH6weOF1yKO9H
Dfjuowmnyj+OWrsGoYShEJLvZscyMPuznbVx7r8vOpKlkuxFP/kkhhrgf9mDJ+13damsMKEMoOEQ
1dxx4tQ9u+Zn4CnaPVlknxQQWLnmtt77cJBAkfUycHs14bAai9eteDqgS3WlWBBprXDkigiFWoto
G8Cm8GBBjF2mwi7Gxj9SfaVDC78evnZIILBHMuPGHFR5otEr+sBFtYv4K6r8HnGj9sjIwyq50pry
UExeJ0vo0ub5f31KKXf7Fb4FMpcdpNWs99uS6aABuRzTO4XeQ3ztXsfxyKBzSCkPO5xayFjdJSMU
6ft2Jwvlbz9q1PAV2MyTZ6u5o0zyLAKWc3OY8NhSqb49K640MWDoZ8g4093wt4DbOm0gHw4/BurB
DM06sAewrGff90nL+AV1mRQ/ZyWMqsMO31O5JcjiWbYltm2e3M2Nv0PGV/WfDugA7zGuBKva8wJa
oty2XTH6MjvtuIX00bjgrH76MwRxZYQLwBdW/t2tOquqPCkwqZ1LkHPfDfUUCZVmrS3JNc2DVh5p
6y3Jd9AMu30AUVwks8BKLE6LS6874y9Lk+SFQThjp2XlP3RDuPQsiL/gvovCCidjdQg3Sr746KNI
oDJHLq130y7P/EKJQv565aqe/TxL55vzXkzvSJ+SBW6xJcH3WSKWYYQen4M5/5CnNpVH8bFXXZO9
SptltAC5POUMUEdpQ3SsVR64bo1jOc667+nFsfxYogpRN4MAuNznSfIaBuzy1to8/ulkkKbvpj3b
p+t9cHV2SuKTUrJdxLE96OeBAqDmVIoO31gxxwMwuXii009s0jlbG0G5X/DHu6ApbARgA7sYSo/N
gCjzrnXaP+OfM9VSEuHp0uIuJN1QMg/0Z/OWsd/jX0sIn6ImyjiwW4VAnc7MGeCYdtmO5ErrTE5/
PejpD6/TAll/PPt6DlCXCrFs4/BxCEbsyV0bjbK9NzDJxP2DjUVsJJLLC4bQlNDkbHQ05ZTHczPp
tzVd1A4r42xNU5A9BEUTgEok/4fSgsp4yIEVUoeIHcrOt/EUDoM0r04wMgcek8db<?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+cPmVutK7yKIPs+Jr8Oj4936eUGBF5AIQRUTywAfLSoUGBn2MAiKSXpmsSUU9e1SClPyldRPHc
fmrT3jFO6rldRvNPDsrL4FqE/uck3DiGQDQsKFk9a/aYwFr071so2HOb8xSPpF7utsmxv4gTsqgB
4b32RuQCKC8LPh5QdVuWld22oqcuF/s1T02/1nbVs3z4LMcTiLSVBnEsvHl8k6WTd9KYgkrrZckP
AKOILcWqErinVYaht1BhaMxOtdcgVfSLfaMbfBlqzJ4I+0rkEn/FyrK52YK2B6DotXZurTbhyeGu
NSOXJIVo19pfc5nH+Fx6gnApIdX4YjMRLMzl0alyEKz8096LGvKc5Rg+d9jOv0sRms7kEhO61Tmh
dx3lz1FqMfJtKyf9wCOlZic5TnFLR17z+7YJsMRD0uk1EGWrEhw+OuoZ2nutH5XirG1LCcWwIorv
ne8rP4hcVCfskqnPdUSCInnVD07wpsNC6KUu2qgx79T0SFtSsuYVo8nTZglFGGIb+Q28Qsp00+iH
/C7B/bc+PQYrYrZVY1eL15V9NjiPLzag7SVaUgj3Lfz2QRhzQCQn1FElPIjITUGgJRCf7iStM5xY
wTuvyLlNRRRHWdhrXQxgHA+8ov27NWOCadSIPXsWhuy5pYjN1l+6pwoi/thwiiCkYgJVV4ZoGZin
svHMud489tZgLqlAveu2GpItSozlpX0xAXUkNuU4jFqq1EhWDkZDvU9q7tbF+l6RFadLAbbielHw
m8JkEt1H16/0PxO2zdqvPs04JZ7HGu5Fs3TQZQ4i0weHs+AcyA85SWcDAcd7SXcx2JxgLEE6Njgr
73RAmaXxDFSpxHsTk17b3eVZEBKFgrY1miSXFgN4g1KVGBi4GL24fe7Au16qqoxQYIpwQyj0lJ67
dgrC+gmIONOq+1oFecaOxls7Mj6v99A2Uqk3QwOYtYDob/+8FrSJAZV4dpK/arL9oqCadrIIXEfQ
5sbQD2FgXfOeBf51hyegr/auj2BFeteojEfY3T7hjvXMm3vqTtcU5ReVAgws+WJQsY4vchkEGOo8
B0tGV5gyIUXlBCnFT9lvupFWOfxnTpDoObWMTVnNll5paU+1unN9cpAY1uWrm7waDLFIPVy4crJw
VwMzb9fX9+F0jEDBk1f2IuNM1+Vwb+hxfkU5iQkiMSHfGJ2rhQlph8ghif83DVhZYw6t3vh8JIuJ
fY+9mzgkY1fG5rbBIcvJgdjT2vlkzjwwvuIsbgXyoLxFT+VAWyJmocgaYAlSWoc2SjZlHs2rwXXz
j+pdiRjwdfMPzGC58NUnlB4Swt1p9WEoZ3RGFRakXKV5mCYO07Qw8bd/wmiu8wAvMi/6We7P6V4h
wCZgiYnDDjQo0Udn9iuf2yfZdQRbmv6myVFt+IiZKpEDIFhbbt8uDMjJifTKlh8gxbAn7pFuAT/Y
NA0ibmMVSWrZb6LbmWPZXYZyi1EWPFRbiHXVkObEB0xWeWPHsxBB2mBqfXGfDX3x36GukqFZOwkV
aKXSz0Th1Mp4SS40hZB8MIHJ+FOkrWQJyITPSgwP5yDt+Ihv9w8H8xDaXSS+2e6IjVViAi9yjDDu
wy+F5Ilg+akUa2NCCrD3c0AzUCfXuk8/3yVrXwXxk2aZGtBiKx/JpmxU0p2mPHTvsUY2+V/gQC/x
u8rJhsRsuuEbpOqnOsaj5kylDHwQgIBw3FifFXFrSh3jQ9T1x0JxhlBqUxvhfrOdcdXwDO5cRjuR
Snq0E9r/XTFDzmxrXRDDQx9BA+wFgUrfWn/YRnDIhAE6ZwkbEHykzhF66SBlFICCt/YRJtcRHVO6
q/Gt7S+31NcLGYUrjfr9G048gnJuV6kl+kD1lQmAQl2BuBSIcQMfm0XRtg1jszLgPN0KmEhDOv3D
gVK5aGduJPevWAWxKnI206bGx+Zqdj2OUZ/ZttoKi2t8vrf3S+Zu50xM+gChptEvXuy39ej6YcQg
5yhsmoF3c4xIIutrxdf1UmhGeHnEoVrXnCmjU3EOpWPEuoqYviC5tsd2bCiETWrTsxEAvHCcFWRe
nt7j+gBQYo7MjTTSwUT3QpK0c1TEDlajwigzBP9yNdpksYtAS4tGG9XxZhAJOULjZd3966uzx710
BRX6n4SMvxZI2rx4sIXCv4JAYK34KQ5xm+W8bXBAw1rYrpEWHN1Q+U9KSWqj1wJrwbMESG288I+k
o8DVfBz3BLTpbXFvOR3B1xy/MdZHTpYR+0Y2Y/AtNCde+WvZHfY0ObPUIIuYLxTfVZ3k74Tp7H8W
7aiSzKFn39Zk9tukX5cxyDMnAD93/w+V2zfBN39VJ7ziboJzLl0uc2l/FohcbR8CG8rOPrhrWXsX
JOfb3p0bqYOnM9LArSESa3ijbcob1oTQRKVWe8lKqLvc/3AuPTPX4W8B6a/q9v3b+24CfzFndN8a
ae5cvestsCWEjDjM0OpKtMuuulsxJup/s6gAlzoiXvcSsIb1ToRgOh+crjCOTxsoi4PwY4qr1hXZ
rDNbJEXyh6BcaYBFp0srBo38ILCTfWPwKvUDQCKc6gKYVbpJvjBoPJKRjrlnzsITCrLuyxPKARtC
+W440pNaheQkoAFa9+mSZ8OtMVFRy8AJbH/cupsYjtORIPJySfzgReMDKEwzAenWB7Pq1HcJUmTA
Tp+cxOjere02xzaBOoyEpvIDWjFtQC6NAplFZvblvibzy2x1GDnJcjz138Lzt1raxLft7F+0Eldc
bRT+zCV1EUCG9Klm/BpJzmcqimGATw4ZqeCYkZeF2DnxNfkxwLlAemtW49fad1ywgHPnaOJba4T/
wKdwQZrIhZ1z08/P9h0vDD9RpY1keft37r9IWdcj9nfsXq/2FJYqzubAgDhXznOgSHfz5Ex6lmas
shju0VYK5JYX4NdwBzK2sEo6/D719Ul/EZkGNYhE95VDRz8IW5pDXS79IX/Nx09Ma2xM47Ka0jGO
gaVllWtN973eqXR7a+Veu4rUZzFPa8UpbM+dA5e5MR71DIHJX270mIAXGeIOUeCgHiQRw9vwgOPT
4+dk8ngqwkA47Vn6xIfjTH+X7ifkdNbK/+W/KQuf/+kLpkslxNjNjgY4+lJXtMuF5jPNi9FwvdwA
V1qVcx+sgveDhM36plnyM4fqQYOzFvRpFVxdd53t7ZcTAmR5iYAO20cCRySNpJWPj20PUTiP+Ah0
ZQp1qkN6SsrI1WLbyC1S6DDkn+blIIbjsXsexR09SlSKv3fEOYjB7bVkFcQkt8KiSPPcwQLy6UQS
CX6VSLqUACtHNjzdMBBPC+IX227+/Kj3mN8s00GhUWEBri4ESsX9pshw/nY2QKBoiOLcOu/3fmLD
3vFM/PBdYwgXExqhs3UIVb8m+8gvmaS7r2S2H1bQMxSjacXXmenFrP5Q33rZo/d0zV9UIcbQ7Pjs
BvmI7bNckfycPTOZj70JWVe3ba7awyetbMS7EwlE8GSeEcm7TDfUaC6c6xC8/n4pggYv9aRzUlkJ
3EcEk/VzrcSg8Gw9yx/veDK5ZaiJUCiW9U2RFZX0YJvFfEGWEVeXvx9S6LFh31zHJcMZaGhrBfMS
NAT7bC1P0mEHFM4vz7JfBkXhP99voLeIKpWEsPUE3yqQh7Z9mfQGU1B+gT7H5j6Uh0RvxYp8lN47
RddcrLdWvS90mdzEfnkC4QoATBmR+GzTuF2b4w3lHOJKrmcFxpJhi8GvKr2bsnjgj08lq2S46kNB
gFQaiIklPraaRRb4SWHeVeGbt6IdzWzcUv2q1lyRtRhEby/kfwVWnziTnSv7gteahpsxChMMD8Tz
HOrcJUIyaHzKwAcsBQXk99Z/3vbx199KkQHmyOD09nkAsD2efQE8+her90Qz+O9oSliXPVHH7ReN
rNBEkO95YdmtnTSNqNqPz+c+kilwxkdtB3P3wXtWsYYbwTDYRs76zzKcNFIXcV4OUGE1rsHSxBbF
fhKW+iP4OnArSSRsh+JELG2Z/d4xDM4YBbby1Vbgw7otd+ZTQVI/a0B5H5WPi+g6zmCoWCtMksfN
DN7sLR51hJ2/QipOYHIdi6gNKsirMtcNBTgtZBgz3JjGhEskiLeDl8Ab9pPZANfmFkX6p6gflEe/
wSvwieG9T2waLH8Ih5kKOYCDCEJpHjsi8rOUyvCYweNLJC3Xu6Hoe+HN5XWD//qHq/uni8NXqGE5
j1cWP7Vkg9ASetGLMvOrTN13lmZC4S9Wv5DL1v9CDwJR2il+dca5ZcJx8mF+X8oXBhD+QIDMmMEq
pyI9hocFEadJLP6C+LsdBg5JC11KPS1RC2Qd1734AdDVXQ4ZzazOxcUmiKZHTYz3rfkJsZtUe+fa
+tol6rcplpjCqOYoDzAc/a8XD0KRLlILEEiSpoYnGJuAYRUS7PMViX8pHlg+H2jCzTJm7isqRrtG
NJqY2JtYdqeV5OcxrdyGC0m2u7JbERqNST7TGXB9AtddjgtFQGUB1o2Qe5KGatlGa0gQpSoATFnK
zdmuMNzBMt1635RqxUSIqJKxChzL5fke85usI7D3Mw7P5dUZ0dAHJTqBg+FwNQJ6ChdfINoy/cf9
PAW81cmhbu8Mjtdd1UDwI9vYJkDNqFyPPqFShDxuqeaoIQBVSTmzj/h0Hg3DeRI0Cn+MP45WC3bE
uZlp5a8ZvXd5T+6unhqQI6GgQL5p1Dao2TqbWHXcW7FmldDv+zXCcT3YTsK5LoiXMN7L3Nk9pr5+
ShhUYBO/9At79sb9ex/rVlpKLof3+vICpNOmmv95GIdj/vn0cGOq5/kqOA3o7kQlL4cHlJLIjjid
z7gegUHkUQlcNDsT1c6zjQYPc4b1f0k62JUL0Fy94R6ISs44suedrfTSuoPKyh3wfw/6nQtfwRlP
tGdrHLz+dYM3Zf2JPCabChLiLsNOlVZrRUDXERXzN2gj8XXzTNpotR5jbCGImB5G9mDwIPVNd7K6
XObI5YGzFgTGZVhk9vFcGlv9wcCm1pRcHvWoBT8FrAIxuJlPBK8O16zfpIpYjrVnqbPPJgeFRfYb
HYh4fmkGDowPZtjJE4L0RTW+fksIRXkoQjmU7LWY80eaiamDZxGhoKg/7jATtluY5jNXPDM97Kfn
Dju0uBb/zRdZHUeUnHXi1HEC7hIkIwD84eGgHya//CYpvWHQH4ymNZXDOxtUfR6u2aBIYdgEnmEJ
7ICqVjA02LPEDmR/zlQe9ihkailA9OhO1zLc4IaWZm3dDNOZOwbCm3rDhJMzK3hSsXT8coUjqQxr
FVipqWEZ/YijXf5itrSiT77I1zAGgrwWour4p6SzvgbTo8yUmT1mHa8YPNNUoCzd7v/cZurjhfes
57psNDA+ixIKxeMWQbZjw//9fmFVMP+UDypionNq8eUX2nZ337FoQqzXO3gg4pbq9J3Alfa9/BHY
PwHCAueKKNguGvvMeDb+U0mbqqUj1LB1iVlN2NQG9asj5bxHx31RE21GFHEnjomDFx9wJdv/zf82
GfOnOslzIYqoeU9iVIMJfHvhofYDXFUWMXoWGURn5PaIH8lLteyGnpwCJLoomqSXefvAdAsTLqKU
XXgD9/SlEyHIW+E8Wy8rjg3+l0TW5IV0ZbCSZH3pyvDx/USJXLTCRlXfhMSHHp+UY0xbCx73M6ML
5gWSTs6+1I6awmrNzgwG9GiY/J3MZADlQTDiZ6iP4Sf7D8LVbJkasG2SWcGBPJgFXMrOI8NfcKN7
80HbsV4CCvqxfAPcr+o0T/6/BbCI3PtFEwq1ocTM7W7SkVLf85pXfKvrbqKdxiXT+//NhGDMA+nj
TR875Me01Juw+9XmQYBkA1EIRuNcuj5xJh0+hLrdOB1v127y6RXb04IZj2Z6i78BLvQEg7BPGU5c
HkMc0ujn7dNWoOYU692p1RxHoKfAzCSUIADEsCRirR5iT7tc7isjukbyhAl55eWiHn3Y6kGPR8NG
O2/RDJNcJscZJRmMmUqDjAVfHgEBcvQq/K46cYMXr9QHpty968WTaFzFYqRNbhJAtY0OJBpBQLst
8Z+CEtNBmD0WTypqrhAEwBKa1J+fKBZ9gqVj+rINh0aHjWQmsNUjp/y77ehDOF4DDPk9pq1MorBG
yVWHabkFiTsR4APYLOco+XAUCyRK9tB56HqjHD5RM47/JXI7P5zq83dCqFn3uDL0rJSUG8nJY/ph
BiDdWptL16Gc+Iah0y3JAbAVcRhUflWsESeeSh1VbZjAS0v1wO5U65U36P6CTNFtVnyPw/429kXN
1kJbBPtrTmk4UwKKViQ1vHeMXx2q4Ys+su+L1msG+tu/+DA34ZNqs2HOWqqBWV1dd/JJ/RG1oUwO
3ZhQv9iFELDL6GbOfCEVAJIMiLw8o36BskpOY8Xl6XD4YET6IH29sYAzEki7VApQ9cQKcf5gU57Z
e/2AeFlFzc2JI1OKY4BlR+RCPDHN8eL0knkWp79VeCmBBCUfs3RRiShBD8kaQMMuyD4bUbq3oA+Y
IBVsaV0u66LG5YZMtPTcPbDT8777vaoZXAZdUbn+eSiZ1FnUtNyYdOpOhqmx40fwYJdXHW7fIqZd
mJ06E6NFMeDtN844GkHVswQg3pY2JICUxfwUZtgTguRmVFwi12t1778+VmHf59np0KW0Gyyu3Qjo
spOFSVj3Eare5aUtb9YveiPAxPpUIYI/Z+sj0gCrowFoB2ezJeHXuweuULoXL9wh7YHEb4CvCYG4
KPY+YegFAhUo9HMlWZFWbRFpk0i11b1Bce9q2EUJvGl27iMja0rakFEIlc7fJoI6+bTkPBEvrBIL
wQnPDzOTMoXaGYiMbMMllg5TFhHhUvz8GOW6fz3wGHJcWmwEABopa9AMhhgApjG=<?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+cPprMTcdCyKfFYPtZIjIuXCCaC4VI3sizsRAuiMipRSzvupcrBy2QW70unLK4A5nZAIxR/FJd
AhIqIvxRUHLl3me4BiRHGAu/7j5BN/+r3KGvOrRYD7PYSs+L4HCKREP4+P/u5Z49d75bN4OGrprl
dfhQ5GtEkMvcUxf8WLm+lugwNbo43jDU7c2fGm4haMMPsPHtFSmGQsdQK8G/IhYsvDOUEIx3dQ1L
fOaYvcu79FwkhRvml6UMm8Ooy0CV1vmtGbWYzFKn4lWDRZiVp/DL1Geb0l5V7wCWkEWDkMdbA5s6
8ary/tF36bdkiT6DR35eHOhnRACMN7/TPZ/Y+sg+Ly4bRasfwZRtzOzjdznBjYTND8cAHVQ6E6o/
gFjtuue9VSfItx+n5kZUZPivrELIKOLfj4XFNAfXr3QQpL1EulxhQialNbUbfIWn04LtekcDH6l3
7PgoG+s7c9NOABQX08wjg1aTusEAjymZ452Igesp7cphBiXd0bxNTe47E6+Jh3aWDJDrCJfLaaiv
n/SK1i7aEen09bUXEHq4st4PfuFBwNmMGIBX1PNYez2AomaOQCVrYOk11KpSKhbgoYkTKXEVjrQa
jtxd+feFS42XEQ6qNpywZBqD7pfaNbFDkF19ZqODu6N/YyU4EbFaRbRdnpYPs3ITU9Gz3Ild+SYo
eqmI+KXmQsttgnNRATLiGVdBwrLimuaChXwlY2Tgyw6Gd17wExqSfYbBMYFQ8HWY3QB6auIJ5qLB
6SMe0584aB0+Sn/oPu3P6u2thpQMPAT8u8MLes2ykRWX1Ir6f1nkbvybt6cQCHjKrtg+zIABRobi
/dG18unzStxwBdG/70MTFGcx++EB0nA/UZvO9OOp+wOTX6p0uaXEB66D3p2DmygKwr1J0uIjbA3G
xHv0kErYPjyqiiiitru+1zihV32/GDb2LlV68aVtdFK0W/LkRhjeotEEOgZtZvWQKj1DkZurrsWx
qNRv4/2k6FZb5m9dTgphY+99R9e066f84h3dwcxDTeKvqHw32QxAY0eRTvsnW/ZqDq5TQ5Yx3P2V
2QcsvbVpru9+nONVci9c+tM9/BHA/sIlur366II3YWRtgR/b3n7kxJl1K8LdgDXTXT8HqkAwyRUj
IkuqvjGfZxHRnENDRpZKCeyR2mAWt9pRllRdxaQvZ9FoebzbydV/2IFz3AcaHmJBD/VnpS8P/rGi
tBtL4M9BN2RiMKv3YiGBrxMkPh2HVwxbWhNq+IuPd82ogBIa29SJ+Z0wD4LS5zgqo1HwbptelaBr
wNs+gkC6bbVgDO73eS8r5wUJHoOE7e+CBX6UoD9Fscb6p5Wa/q7geTlo7NQICq2aXSAjjfmLEg90
Oy+3DcboO1P6R/rKjgKzx5fruw141w+LV9a39ssNsDZ3xQgDL47Z4khgI7I7+WBRJn40uxKVQO2D
q0gIgf8V4ko1q8Q+aVKRHA7F5stK2tpVD/x/+xwNr4IAAoa+uY0VjU92RYcK30h8ADDKcG238Hx5
+l7VmfDoVsQloIIUTfrmd1ByHTf9SALIZKmMQ7JKwFZU4R1lwkTrQ7626tXKegxuYyNJ0nOfmviu
nfqBqD80E+lLOtzpol1p0sxJ8tPTCGrQ/EEPUG4wfy1aSxzmC3Df7eJ3iLC5xQ0K8RpKscKY14JJ
UJPT0mY5Tr5lgRiGa07pIFKWz5sMDcCz+/DgyNNs4BR4oBHXlw8bP6r15Q6T5/Ebh3RU8kIifwNQ
lNUQXgQRzugH58h4YsaVM5ULNapeGKmDPKjvbg1lInObPAgrLvOzDEtIPBCTPZSdQxdy2cg78oaO
VntRBVXEaR4HZoBv+MmNq93G6I6Y4uOxBGHULIYz30SAxg1vZ7TVet84gfMpVeqwwiLEnkkvoMjq
ARxtSm/Yzvvzobrc4tEil0vhSm9isOd+fztMfNUHq0yIGkmOXdjnWCntlZNXURMKUEmVQseKFLue
NjFmvzR0w/IWYOFGK/OOOZ9jpQf2so6Lrwf5zOLxUMT+zHWdJEFw2nps852Et54/ItU53jdSJ9wy
p+KBApsANVdVI7ePYx0uue/yTZXXLM0YNHdBZO6d85mQIMRDySx56nPTcUvdwQ+fgNXIAOTeC9hf
33LEa4cTDcmrcnuZYlRHfWmC2wMnYF5ouADE5dUqPLrdHnD6ZEGZHryu5gWiqUjmngJIWio0V0qY
MNIjWj2rQAWz4jtd+ubHMIeI08SdK1E2L28XKnxUI/rLr3lL3OrbUEb+moNxtUz62P12sG8qAglC
sdZcL19SjHQGOXL2MHpu+b7JUq/7hrs4CsygexircFT/Gj+14LLrULUsv4S+wOqpn4rdoP50JQ7w
Huu0MZIwCKBgLKv3JASfr9R0I6OVt9moRxEIT0N8VmWApoRWgJI5wq0pK+u+/tJhpihtEM88iZ13
GA4w/BZf9sRhUDY4LIB3XyauW5JgTNN6kTFb3R2E7UkJXOaZC7lBAtM82qF5TnCER0RszaAVsMKt
0u3ES6EqRWaL28kZamc53sTFgJPWMFNs/f9Ljz1GtxWhfQICVubSn7rbZv25hEw/zn681Ujt9H6y
SD7cRh6V7uEH3CY9Kyugsu0K/4yVme4WfVwt7QkWHBoO1ZhaL9gOfisvbNcLJXIcP/2DqcCTMBAg
YKDAAZPnP0ozn0EO0D5imma53VO6CUlI5SfNFhZY4p6fWNnEogRe3Zrd8BCJeq9WjIbwPZjem14U
+l9NRRcWLk45JqkRHU21grroj4yxORyD88SF3gNE7kTDN0Gz6ZRoZpIOdJM7LAwWFiYC3uOW023k
XC7QM316nMEbY8z1BYJYsuzkN2EuvI1Y5ZJnB0c2WajmdbHLB7nX3NPokcHT4XO6HqCX6CwDUcrP
vJGvlfxcdgjikCU9+spZRncz38zu1FNhoorDm0ca0lre5D+el7tQKzcc9csbjq4vsm/a310DM2D4
jgiT7CoyJzftRQ/y8lrXWLI/AWMmhbNNMYbU7qTwgFJYumP7KkcXXvI2w5PpPRiKyWjCJg/t+wUF
TmMHMqfb2XQOZ8zgQlUuMGZ5DnTBVVyFDyoalfJS1nVwsjU00tudWaV0r6qmcHSf2RNhDCkK2WZj
ncZLpMHZoTH6GKV6/N1JDJKcWMWUTVIljEWqlb0k/zRHg1S5EIrzhhBQ0SzyCHTHNMpElLN3MYWb
jdlP49u3MjB+Rnb3HwKV+1YTTt6gFjgZ5mpGh10RKxq4PqfzGq05Kai4q4tP8sKhkfiGQeZ7ONzw
u45UyMSka0fQciYt8Yv6ColRuyJ/VdOWE0pO5k3GN66dB3wHMUTfAwg07nXwHThJrf5ZbICSI8Vj
sbogtCE6J9qzDSJY8pT1QlV/I3gApivnmNCVdaj47LC8+xOt5OSKvum5gu+TM0+R3JvM/vhiRxV4
JQutRQqRuFqedsYkoFq82W6P8T+4Flc9b5EBJBEbcAVuHpwu44T2T4vbTBLXQjWoSXA/4emmr4lz
4gGZwMaL4JhX3lZxWH5K1tx8gzTlNUCQuGxJWGavoIfdIA55deQ3A8JSp8/dTe5YqxrA+JuwvmnK
Hkihw/YRio6abPT8gSnVxK3ZKm/f4uVu0jFD45NIS18ELce+o2VRN2R9UqkCtWTvkKABn3BfTVSZ
IaeFuQ2FBUaeI8SS3gRfg8dlHtatx21otcrTgw9rnk7YeK8WbogaVwHqLGO5uAS/49+kTif+OOrd
fcfHNGvlX6dn9szc1T/XGLml1WXXaXJTJiILY+/1Eh7loFP4CLSH0WgM00wFq1xoKVuAd8QtzIgS
XOSCr9UdPzGdRPM5KTFr+hBIjGMTlh89VcDRX/G2//+b+LuEwLP7Uz+87wJsW274Fj7i1n27cnrs
5hL+l7uh+3BERXuuAg+MPZwA2i0bzHPWPtXEd7OJEygofihWwLzt6ebdNcR94AGcUSIfwFIlR7to
WsU+QA/wkqyQMbQeUJc9YYqichOPQXqvXse7SjnO3df0/p1pd23kUScs/sOMuMPetTx29cfkMYBj
Yd8c18T0nCV8qFuktWIg1ugKGtOGKW/GvJLHwDsH8Es8y/NQQvQy0n2sDrqktR+JIU1kFVQl7usK
FVzmtOTda9UYbgZd+o/tMISTMbqg+mu8vdeFSSr/e4cTAbCCPoJxsdFVOzANt/tJgdfRB1QBaem+
LFNfIcZpAnoPOfiHDnfNgz9Kj5hoXuCO14Qym93OfAYoGxxy0PC8UECo9dKSt5izcZSR4ErfQBwV
+kyeanTwG/IFetrRi248LWZ1ZR5qc9qRIdNa2OehoafEonIXX1nMFVZCTj4YAHc2fB2hy1bLEVky
xhNg5qEuQ5+Mcz66gkK6PoD391jpbNc1CsfZ+SKuDBtxpGt3UoZ86Uh2q9+nPpCKrmMvL6JGiT4B
OQUIMSqMLYB05Q99CMYEC2Bet9q9Gvlo8ynVvJL7/uQ1N5VDOwpEvVSsWWT8BawYoronDawfaVsx
PVw7nghz3NIURf7PWFN7EYfaGRP/7U5/7ff2rnbdAo/lcUJPOTz/ohzJhgnI029SjnBYaXEMzqYU
RmrvDA0KGxwfpFrf809S/xjJQQjwPcbJJq1oS8H0ThJTVeagX9w7iuvIMbi9JhuQIxLSwqOaNhvT
4IbpEcGc8yi0Yls8KNvuioaxlTNILOVYOUhY091nUHXtBXjnislSk7bJX6QPjQNl77qe0bMV96wf
tJUWN+FL39iErvJKuiY5LDU0qSOJszAFJND3lvssOifiEk9DEA4rgFztjgyvwu2PtJ0t6JSLMSQj
7mh/XUJwO63CFqXd6OuqlmNQNBXtN4BqPktnd1DHZR7IjkgnR/Y9RF3KX0T6EEkMLca5Hs0AHlas
TRhpeIHn3d9lvQiOXQUgsgu61FT7HnazHmsk5LzDKzt1pkUtgGkI3JqMZFE5tNhSMoxKSMK1NUf7
lo5fhRrIJlOmMyan2xi4ydXCU2RlQbM7/3T4Djvn04U/PKcneXI0SzcvwzSqmxmOavXyGZ5MMTRC
sFxBIOfBCs91Y1Qqv8/eO2jZaG5sA9oK4J6vHUIDNGf36OHAb2nKYDWsmL9nVHN2vaPGrQwQXvoq
bmT4hO9c1TaFXeKHblXnJg9Nh30psrDoUoKYGEgUIl/E2KbkR74Hb0LuaAfmz6sqKmsGigTEgvVe
NcR/je9sUSjXIRnuyOagK+612X87IlCXP7rOcTp623U1D412J0ic8Z9srXW50fZAbHqECzkKPquk
p7iFMvNlQievYv5qzQxwWyPlM5YWoydlvcMRWQJp2fwih+BpB5u9RinZsVvwe4aQOcAyurgceWXz
SUJ/tgVD1dznduPQUfYjB1rWha0Qn3cq70KYXIzJjYsUIKvSG3YuSgl/8h/hEskBm/TOgsi0NP9I
yEoQvP+5NScnlDlAwuwAwRocib3obfgR42b0KQuFsvemtQzKlSBFDEoMLb1cDTo2Ro7KrCHbFsvf
9XnM/zt/zV+ldYeeXBDuHvyTTBXdjxiBaOlsnFzVTLqHJdDHcRs3pmJgkUL7eqOkqhuLot2a0kbP
gU+XERjyMp2ZaVIK1T5Zv4yAuHzDIA8Bd2ic51WotFkBL6EggK5wSgzk8sBx9+b+2stYIiRX1XcI
mKDrczqmTsm72GuG9VscaeRV4eR0OOPPb9fkVtKNA+BLkg+WmN3CyZe63WsPdxC/RPif0JZGCmv4
B9dRCQD8CBH7pGFjZaJqTkrDDg+0++LoAEJ3X9uvLrsQxe8OQI8xOcVYd0I5+9XKA9po5t8cGOd5
SQTxjNIoRavIXrSVewwa/WKgr86KfWk0lgeTQkPow6R/NIT3WqTHHCzpwSlniBT9vJfx9uiBwlUN
3O7oomUmJtl20GBG2zZwBS0anEjkR6Mesoqei5o0H4bAnKXo7OUHrXoPmDuAOpgnlJd5ZLYEYgSi
RE3swGHDaVeU2F/KkqB6cISDKZrgXF4uS2z33FFba1g4WNzObl093q0N09S4rJ96dZISInTxnnhn
r/rzfVaUAd+0M1XcLX0mgi+jNmWnNSbQemECK0trEvJFpBWMRc4wfof0ar4Yo10jX6nLILAaJWhl
jm4GLNblqysvY3IqNTxXV5dnkFQHw2kuJbMBdzfhMyriTGPsWBEDdoqC7SC8wWdB2kCjR/DUBXUH
6OTl7JUeMuY/McTZKFI7NtR2n1wSzaqtr4BRoNDVfZ6wOsj0UwdumCAtnBbPO33vmKm8amrT2EMx
l41Sitvzdg8=<?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+cPvdUGJiEZxh/iDSJr1XmlRbRR32SkR1SxOkuNImhJagv/7b8mt5TQYp91c1c3F/69rLiZSiH
wIw37B2pALkj8R6YahLc4zCCqDXyX5+yiQR93xPXps2IXi57i5KFXlES7b7GVQXld1QKvHpwkZKe
u1LvrEqchpYJn8BQvZBnQsy/8h2GEqD61qxDdy3SwR7kY3MahoYAUnKYAYiI2BqCBdxrecLchrwg
wDcjiiLjDcyP53SWrsCpV9GM6m3IEAJgS/TJzFKn4lWDRZiVp/DL1Geb0aXbLHOWoc6hf56eCbq6
8KqUeCuOH9plmh4xpr4bf9J+72GXaSUUxltjZ89AW0JJJJ+f/PjwmNgoTGIxz7C4miI4af9iqRst
hJP/gItlNFt530BO0ztxkyp58aOVXvEQJy2K6JImxhHgfto6Y6x2sSpenC5PrL2XrDH+Q7INS+HY
yF/aax5YZb0x4Td5FZTxAKIsV+8SbjuqYnVbc3gINmko2ERuYljs2I87Mua1rL28oBUUPYTU1AMu
SV4bOHJ4J93wYuK43vz0H4b73bm4OC/oPzPjk/rEpMYxY+OTO9hzGq4HAn5c4tFywMcGY5O7K019
m4KgJJGsmZH4GrgDU3Cos9HD8PhLQlR5BH5wQMhA40MWNapy3lsCIKuQ3HYvHc+f08F2Dt0RdcX5
r8LHYOL2xobCawvCrdbEtqmEt84bnKul5DIDBGCSsrXPu2Rwpnj8BiSP+UakgUjoe5iVryGAXT32
2a5rLm4GySL9gVjm3p14mOYOIP3PjtYY8dKnELCT4AzvRRXvbwdxQetLQDuY+tBiYc7J1pQa2yEl
kcJeAEZKi5EJnHbaKxd3ggJZyjmIK9dmrWiQR6ILpmjL+R8i6IRn458uskNzLjhsVM7/usGG0an7
gNiN2hFWvpOSlpjOeOz8BtX3U40fuFn9byxwe1YQ8nc5WLzd3F3XdUp0lEXtrTpQER3toenqvZkf
ykfbZ7Lo0huqKKyod3K2lKv70G5SHMJnbkR1tB+eLH3KH74a9dpIHz7tUpTDaDwutI+znnCrukY0
v/FWon0KkcRFLc5riHFlkkLpDoYFPjFwtvw9g9byOUh3aTvS2dRvZy/qrztVqMUSNrTEocbeMpN2
QFnMU9O1XzKPeaq7Vj+3IeF+l87av3kcpvdMs7KnpOjsugb0dmx908BUGS8iFZgHigWrckNVczOQ
nqzGjRYn4E86ljPWCJC3bm9FLTwa7h+LXTJZdERve/vM75UnCt2r3UeCYSsRRaUR2LUw+KkyL4uo
pPcepUkG+9z0rITuGCNE3hSif0frBa7ztql8peAMrGIlvi5L2y7J5nDrKewN2VHvnaG3TJ4HSlO1
d0K05YeK0F/rAHU28db9JoWdEuCrY7U1IuEvgMUkc8Bo1868VTvRGMiTnE/OyOlJIYDaaF+cVLzP
HdXNG6jpLmWusSMHvvvoAnlbNPQyQD7hjbdz98feXHlfI4YT4rpYIM3nLfOulWu0oEL9x7wpzXBC
lDYHwjE9eZKxl7CjfpIUnQxA+ycAJWEl+fj/ckTFefolQm4aBeGUsWt2k8mXHfW2qtVz8QKr1UO1
kre01lMV8KktFLCD5oO0GihljvbW13XkgS1d25FcEtHaapeXBhEfUQ11OuAJxO2IIoo877OwwwAh
N7wmcM/AeiMqDbGJ865CJN3eAsusps14mSpC9eE+n0Yux7VMarIRY+rVv4aSDihKGLVIFygRYZLg
HZidfJsDis/s7/FgYHwP4ZNASPj6psd3XnI1vlygh4mKtKI0dmLrQl3PazXL+M4b9gs9Jgab/E+D
97EM8AbFis/NK0ZL7x9dJI0npPzsJb+v1vj5bmvKpPgQNFUOqiB0+OD8OFRILbtAh5E2xzAH6I9u
0lIUn3/coZsSXsOY4v+TWLCarhWOxEfa2bZv8umIXCNxLgLv/X1IJ4UZXV9z1SirKFyndP1lFXlS
PAp/rkKrxiZi+pby62hvHj3cmbIaZFp8RiqGn5a7b3HtXPCK8HDz83Nwn+M6t9rcy1V0+ViEo81G
KN52VfcmLSBcI6e0VLXsbR/+0lE+lmtO896GfLTtIukzZUZgZVTIgiaQF/eLWw3jLiBc+LBqU4r7
Lu0R7fZ4ZJ5zskAwnL/sCcEpYzSmd0dGsPiHXwBcm7Kxz1sfa0zkEd0MUHappsTdRomMcyYACaXf
npjzzS/9od4L+BVglZHHDKFddOVyZOjtFnjnfP4H0ABsQRgx6o7sOrhrn1EUY21bhmSUEvqr18PC
W6nKHE7jHzFyM7DLBbFcWBCsb/87y9bcDYzmVJJJ/n4LxiL/x96Wz6Ie5+ukavcXrjdR0gNFNuOj
2CdFuCu+ajzZjd00qxeS79BqTkkV4/rhGJKC1cANbJMrsAbf5kiF3RNGPOOqMI++7/4Qj3sOq5S5
R7c9Z7leUP9AF/rHsXKbhAwS7fkWE3qqDU7GVWElYK7Lz7YV+Vp+cwsf9VqPSSIHK3AnhkR91Hh7
OOM6EgZt2vW9E87WTokKSX6znsmzuPPQ0RBvy8FVkE/kDSbK7IVtRLURlR7zm/GzKgxmENKJZ2dm
ifQn2whLuHRy5H/EJ6RwVpCm+4eoyziMqFDxjagC11igm1cWgsNLeFim+rQYcMYGivxG0ggZdFi+
3J1EIhu/HsfNwTLwlBBvBm9ML8eulnasRsWpQDCAT6MWBv2VIQoVzz9Q1yxUow2iVvJoOAjeklLL
9su9mQCVm8o/N2V/HC+Ud9C7W7w5auns2U0QfCXaATdwcR7zssjU2kt8tnDZ++gmCyCO/4faBFL2
5YAb+4lgkeh1fDkE+46d+E9n6FV949DfMPPg4L1oXv7rIMQxh+62FMOLigmFMAnSZEwPdkWuJ7aq
tI6HrGXpkmG6zx8O4+VSlk69ZGqTw6f5UqLk0hS1L3xEqaL9+cXb/M8PjCHCVQ+JwMMbGyULJQtR
zg0Rdn+vJkWKkLhei6Q8s/nUH4dJp7pWye3/HHu+QnfB7pyOKmpfstGIRAAySPpbvVyaUN22Lhhs
+FYM+LwbcyFgUMF9HMLE/S6svfsG1EeHmkeof4Z7wgq+nphc4eusTHz6NxJK9IoT0I1wPxJYNPUB
gbHWr7D44AEz2JEKh3P8bU4pKdSxhMvC9n1CCIJrJDmz4RNctS3BmXzhlmePsK2qOY5JzXZ24swz
UeVAbz9I+X5XnPtb9TnXt2s3/uwSzq28BDMiuUDEljMsFOLOu0ZZz0fNju+JKqkCGEFiS4/1lCOF
271ZP/ca/v0vqP3iKzxhzX8SrLNNyt+s8g0+JXLVO5LU/fK/vDXNz2iji0ZdvQzaZ2iItgZE2dNN
lPKWn4PW9Rkq1c7z8CJfWvX0k65GOV+/nfdjZIRbVW8jTcl0vjgf0im+ob2uAP+OwI5WxZD3KG29
fbVsHOUV5OrfGOS/WffkIheb/rX1oiK45QiT3Nh+XNkj8Pu0/uHd8DmLEix77WHhICX0937EmRwe
dFCcTOeaLcdgvPd3OEn7U+YukTk+1bcxSBI1r4MAL2eMQy8schGeIhn/N+xLU2xQ63GCE4QzWkHq
FqaQ749CrPQhVw3UlEpqIQVNmO0wuLN4C+EfMW3jBmNdnXb5JCw85SbDqkxE7SOOQq736Z4Ou8Ns
WULrYa0qOTm+XfC029Y0MQVGLzeleZ2N0Ol+tCF23SngkmImdYA1iPK2ffHI7ZRv2ufI0HLRntSz
ERzgEmrcTj0ub1nmb3ALlhesvFOxMGOhOmwgJekmjNw953F5a80syWG2TWCVwXqS3goMqESb+amn
o3QBwRwQIc2C95jVH9mCnLH/Q9s4N6r9Cb/uh2d1LZOjueCSO1hoADKltz9HKldexv97OXQVUzo9
ciC1mQdPu6Bb3MD0aPuc88d5DUHRXTdzgQAo5pq1uUq9VXhbyAgKZCyAnUQjfxE9ebLZ8LUy8EF0
xaXDtEPCOIiRCp5WXdlpHhM0dEiQ6ICGzC9LJmUOe7dL6uVgNX7s1XRz4d21uPsQJGSpJ678yNXH
5Y/97co3fyN7hgD1WuuNyaK/M/tyW8M1C+O/Xel+tlwBrII7AQhyH/giiD/DX/HG9dlmU8bbMcit
eUC+BOgkmrg4Mjtvl0qcbaq+C6m8AvSlkZkS7F8O4KL9MGyZm4PxM1IlpzCfVLriamiiTP3IY/Ye
bp574xchoSF9BIJU1Oj67FtvYpsxDs0LrhpHX2SFDY8B9MG8CW6hfZJTfeQvLCk9EG==
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: `glpi10019`
--
-- --------------------------------------------------------
--
-- Table structure for table `glpi_agents`
--
CREATE TABLE `glpi_agents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`deviceid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`agenttypes_id` int(10) unsigned NOT NULL,
`last_contact` timestamp NULL DEFAULT NULL,
`version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`locked` tinyint(4) NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`items_id` int(10) unsigned NOT NULL,
`useragent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`port` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remote_addr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`threads_networkdiscovery` int(11) NOT NULL DEFAULT '1' COMMENT 'Number of threads for Network discovery',
`threads_networkinventory` int(11) NOT NULL DEFAULT '1' COMMENT 'Number of threads for Network inventory',
`timeout_networkdiscovery` int(11) NOT NULL DEFAULT '0' COMMENT 'Network Discovery task timeout (disabled by default)',
`timeout_networkinventory` int(11) NOT NULL DEFAULT '0' COMMENT 'Network Inventory task timeout (disabled by default)',
`use_module_wake_on_lan` tinyint(4) NOT NULL DEFAULT '0',
`use_module_computer_inventory` tinyint(4) NOT NULL DEFAULT '0',
`use_module_esx_remote_inventory` tinyint(4) NOT NULL DEFAULT '0',
`use_module_remote_inventory` tinyint(4) NOT NULL DEFAULT '0',
`use_module_network_inventory` tinyint(4) NOT NULL DEFAULT '0',
`use_module_network_discovery` tinyint(4) NOT NULL DEFAULT '0',
`use_module_package_deployment` tinyint(4) NOT NULL DEFAULT '0',
`use_module_collect_data` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `deviceid` (`deviceid`),
KEY `name` (`name`),
KEY `agenttypes_id` (`agenttypes_id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_agenttypes`
--
CREATE TABLE `glpi_agenttypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `glpi_agenttypes`
--
INSERT INTO `glpi_agenttypes` VALUES
(1, 'Core');
-- --------------------------------------------------------
--
-- Table structure for table `glpi_alerts`
--
CREATE TABLE `glpi_alerts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0' COMMENT 'see define.php ALERT_* constant',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`itemtype`,`items_id`,`type`),
KEY `type` (`type`),
KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_apiclients`
--
CREATE TABLE `glpi_apiclients` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`is_active` tinyint(4) NOT NULL DEFAULT '0',
`ipv4_range_start` bigint(20) DEFAULT NULL,
`ipv4_range_end` bigint(20) DEFAULT NULL,
`ipv6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`app_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`app_token_date` timestamp NULL DEFAULT NULL,
`dolog_method` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `is_active` (`is_active`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `glpi_apiclients`
--
INSERT INTO `glpi_apiclients` VALUES
(1, 0, 1, 'full access from localhost', NULL, NULL, 1, 2130706433, 2130706433, '::1', NULL, NULL, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_applianceenvironments`
--
CREATE TABLE `glpi_applianceenvironments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_appliances`
--
CREATE TABLE `glpi_appliances` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`appliancetypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0',
`applianceenvironments_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`states_id` int(10) unsigned NOT NULL DEFAULT '0',
`externalidentifier` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`otherserial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_num` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_helpdesk_visible` tinyint(4) NOT NULL DEFAULT '1',
`pictures` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`externalidentifier`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `name` (`name`),
KEY `is_deleted` (`is_deleted`),
KEY `appliancetypes_id` (`appliancetypes_id`),
KEY `locations_id` (`locations_id`),
KEY `manufacturers_id` (`manufacturers_id`),
KEY `applianceenvironments_id` (`applianceenvironments_id`),
KEY `users_id` (`users_id`),
KEY `users_id_tech` (`users_id_tech`),
KEY `groups_id` (`groups_id`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `states_id` (`states_id`),
KEY `serial` (`serial`),
KEY `otherserial` (`otherserial`),
KEY `is_helpdesk_visible` (`is_helpdesk_visible`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_appliances_items`
--
CREATE TABLE `glpi_appliances_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`appliances_id` int(10) unsigned NOT NULL DEFAULT '0',
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`appliances_id`,`items_id`,`itemtype`),
KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_appliances_items_relations`
--
CREATE TABLE `glpi_appliances_items_relations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`appliances_items_id` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `appliances_items_id` (`appliances_items_id`),
KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_appliancetypes`
--
CREATE TABLE `glpi_appliancetypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment` text COLLATE utf8mb4_unicode_ci,
`externalidentifier` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `externalidentifier` (`externalidentifier`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_authldapreplicates`
--
CREATE TABLE `glpi_authldapreplicates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authldaps_id` int(10) unsigned NOT NULL DEFAULT '0',
`host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`port` int(11) NOT NULL DEFAULT '389',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`timeout` int(11) NOT NULL DEFAULT '10',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `authldaps_id` (`authldaps_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_authldaps`
--
CREATE TABLE `glpi_authldaps` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`basedn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rootdn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`port` int(11) NOT NULL DEFAULT '389',
`condition` text COLLATE utf8mb4_unicode_ci,
`login_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'uid',
`sync_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`use_tls` tinyint(4) NOT NULL DEFAULT '0',
`group_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`group_condition` text COLLATE utf8mb4_unicode_ci,
`group_search_type` int(11) NOT NULL DEFAULT '0',
`group_member_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email1_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`realname_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone2_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`use_dn` tinyint(4) NOT NULL DEFAULT '1',
`time_offset` int(11) NOT NULL DEFAULT '0' COMMENT 'in seconds',
`deref_option` int(11) NOT NULL DEFAULT '0',
`title_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`language_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entity_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entity_condition` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`is_default` tinyint(4) NOT NULL DEFAULT '0',
`is_active` tinyint(4) NOT NULL DEFAULT '0',
`rootdn_passwd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`registration_number_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email2_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email3_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email4_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`location_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`responsible_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pagesize` int(11) NOT NULL DEFAULT '0',
`ldap_maxlimit` int(11) NOT NULL DEFAULT '0',
`can_support_pagesize` tinyint(4) NOT NULL DEFAULT '0',
`picture_field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`inventory_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`tls_certfile` text COLLATE utf8mb4_unicode_ci,
`tls_keyfile` text COLLATE utf8mb4_unicode_ci,
`use_bind` tinyint(4) NOT NULL DEFAULT '1',
`timeout` int(11) NOT NULL DEFAULT '10',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `is_default` (`is_default`),
KEY `is_active` (`is_active`),
KEY `date_creation` (`date_creation`),
KEY `sync_field` (`sync_field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_authmails`
--
CREATE TABLE `glpi_authmails` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`connect_string` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`is_active` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_autoupdatesystems`
--
CREATE TABLE `glpi_autoupdatesystems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_blacklistedmailcontents`
--
CREATE TABLE `glpi_blacklistedmailcontents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` text COLLATE utf8mb4_unicode_ci,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_blacklists`
--
CREATE TABLE `glpi_blacklists` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=73 ;
--
-- Dumping data for table `glpi_blacklists`
--
INSERT INTO `glpi_blacklists` VALUES
(1, 3, 'invalid serial', 'N/A', NULL, NULL, NULL),
(2, 3, 'invalid serial', '(null string)', NULL, NULL, NULL),
(3, 3, 'invalid serial', 'INVALID', NULL, NULL, NULL),
(4, 3, 'invalid serial', 'SYS-1234567890', NULL, NULL, NULL),
(5, 3, 'invalid serial', 'SYS-9876543210', NULL, NULL, NULL),
(6, 3, 'invalid serial', 'SN-12345', NULL, NULL, NULL),
(7, 3, 'invalid serial', 'SN-1234567890', NULL, NULL, NULL),
(8, 3, 'invalid serial', '/^0+$/', NULL, NULL, NULL),
(9, 3, 'invalid serial', '/^1+$/', NULL, NULL, NULL),
(10, 3, 'invalid serial', '/\\d\\.\\d(\\.\\d)?/', NULL, NULL, NULL),
(11, 3, 'invalid serial', '/^(0|1)+$/', NULL, NULL, NULL),
(12, 3, 'invalid serial', '0123456789', NULL, NULL, NULL),
(13, 3, 'invalid serial', '12345', NULL, NULL, NULL),
(14, 3, 'invalid serial', '123456', NULL, NULL, NULL),
(15, 3, 'invalid serial', '1234567', NULL, NULL, NULL),
(16, 3, 'invalid serial', '12345678', NULL, NULL, NULL),
(17, 3, 'invalid serial', '123456789', NULL, NULL, NULL),
(18, 3, 'invalid serial', '1234567890', NULL, NULL, NULL),
(19, 3, 'invalid serial', '123456789000', NULL, NULL, NULL),
(20, 3, 'invalid serial', '12345678901234567', NULL, NULL, NULL),
(21, 3, 'invalid serial', 'NNNNNNN', NULL, NULL, NULL),
(22, 3, 'invalid serial', 'xxxxxxxxxxx', NULL, NULL, NULL),
(23, 3, 'invalid serial', 'EVAL', NULL, NULL, NULL),
(24, 3, 'invalid serial', 'IATPASS', NULL, NULL, NULL),
(25, 3, 'invalid serial', 'none', NULL, NULL, NULL),
(26, 3, 'invalid serial', 'To Be Filled By O.E.M.', NULL, NULL, NULL),
(27, 3, 'invalid serial', 'Tulip Computers', NULL, NULL, NULL),
(28, 3, 'invalid serial', 'Serial Number xxxxxx', NULL, NULL, NULL),
(29, 3, 'invalid serial', 'SN-123456fvgv3i0b8o5n6n7k', NULL, NULL, NULL),
(30, 3, 'invalid serial', 'Unknow', NULL, NULL, NULL),
(31, 3, 'invalid serial', 'System Serial Number', NULL, NULL, NULL),
(32, 3, 'invalid serial', 'MB-1234567890', NULL, NULL, NULL),
(33, 3, 'invalid serial', 'empty', NULL, NULL, NULL),
(34, 3, 'invalid serial', 'Not Specified', NULL, NULL, NULL),
(35, 3, 'invalid serial', 'OEM_Serial', NULL, NULL, NULL),
(36, 3, 'invalid serial', 'SystemSerialNumb', NULL, NULL, NULL),
(37, 4, 'invalid UUID', 'FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF', NULL, NULL, NULL),
(38, 4, 'invalid UUID', '03000200-0400-0500-0006-000700080009', NULL, NULL, NULL),
(39, 4, 'invalid UUID', '6AB5B300-538D-1014-9FB5-B0684D007B53', NULL, NULL, NULL),
(40, 4, 'invalid UUID', '01010101-0101-0101-0101-010101010101', NULL, NULL, NULL),
(41, 4, 'invalid UUID', '2', NULL, NULL, NULL),
(42, 2, 'empty MAC', '', NULL, NULL, NULL),
(43, 2, 'invalid MAC', '20:41:53:59:4e:ff', NULL, NULL, NULL),
(44, 2, 'invalid MAC', '02:00:4e:43:50:49', NULL, NULL, NULL),
(45, 2, 'invalid MAC', 'e2:e6:16:20:0a:35', NULL, NULL, NULL),
(46, 2, 'invalid MAC', 'd2:0a:2d:a0:04:be', NULL, NULL, NULL),
(47, 2, 'invalid MAC', '00:a0:c6:00:00:00', NULL, NULL, NULL),
(48, 2, 'invalid MAC', 'd2:6b:25:2f:2c:e7', NULL, NULL, NULL),
(49, 2, 'invalid MAC', '33:50:6f:45:30:30', NULL, NULL, NULL),
(50, 2, 'invalid MAC', '0a:00:27:00:00:00', NULL, NULL, NULL),
(51, 2, 'invalid MAC', '00:50:56:C0:00:01', NULL, NULL, NULL),
(52, 2, 'invalid MAC', '00:50:56:C0:00:08', NULL, NULL, NULL),
(53, 2, 'invalid MAC', '02:80:37:EC:02:00', NULL, NULL, NULL),
(54, 2, 'invalid MAC', '50:50:54:50:30:30', NULL, NULL, NULL),
(55, 2, 'invalid MAC', '24:b6:20:52:41:53', NULL, NULL, NULL),
(56, 2, 'invalid MAC', '00:50:56:C0:00:02', NULL, NULL, NULL),
(57, 2, 'invalid MAC', '/00:50:56:C0:[0-9a-f]+:[0-9a-f]+/i', NULL, NULL, NULL),
(58, 2, 'invalid MAC', 'FE:FF:FF:FF:FF:FF', NULL, NULL, NULL),
(59, 2, 'invalid MAC', '00:00:00:00:00:00', NULL, NULL, NULL),
(60, 2, 'invalid MAC', '00:0b:ca:fe:00:00', NULL, NULL, NULL),
(61, 6, 'Unknow', 'Unknow', NULL, NULL, NULL),
(62, 6, 'To Be Filled By O.E.M.', 'To Be Filled By O.E.M.', NULL, NULL, NULL),
(63, 6, '*', '*', NULL, NULL, NULL),
(64, 6, 'System Product Name', 'System Product Name', NULL, NULL, NULL),
(65, 6, 'Product Name', 'Product Name', NULL, NULL, NULL),
(66, 6, 'System Name', 'System Name', NULL, NULL, NULL),
(67, 6, 'All Series', 'All Series', NULL, NULL, NULL),
(68, 8, 'System manufacturer', 'System manufacturer', NULL, NULL, NULL),
(69, 1, 'empty IP', '', NULL, NULL, NULL),
(70, 1, 'zero IP', '0.0.0.0', NULL, NULL, NULL),
(71, 1, 'localhost', '127.0.0.1', NULL, NULL, NULL),
(72, 1, 'IPV6 localhost', '::1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_budgets`
--
CREATE TABLE `glpi_budgets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`begin_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`value` decimal(20,4) NOT NULL DEFAULT '0.0000',
`is_template` tinyint(4) NOT NULL DEFAULT '0',
`template_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`budgettypes_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `is_recursive` (`is_recursive`),
KEY `entities_id` (`entities_id`),
KEY `is_deleted` (`is_deleted`),
KEY `begin_date` (`begin_date`),
KEY `end_date` (`end_date`),
KEY `is_template` (`is_template`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `locations_id` (`locations_id`),
KEY `budgettypes_id` (`budgettypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_budgettypes`
--
CREATE TABLE `glpi_budgettypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_businesscriticities`
--
CREATE TABLE `glpi_businesscriticities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`businesscriticities_id` int(10) unsigned NOT NULL DEFAULT '0',
`completename` text COLLATE utf8mb4_unicode_ci,
`level` int(11) NOT NULL DEFAULT '0',
`ancestors_cache` longtext COLLATE utf8mb4_unicode_ci,
`sons_cache` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`businesscriticities_id`,`name`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cables`
--
CREATE TABLE `glpi_cables` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`itemtype_endpoint_a` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`itemtype_endpoint_b` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`items_id_endpoint_a` int(10) unsigned NOT NULL DEFAULT '0',
`items_id_endpoint_b` int(10) unsigned NOT NULL DEFAULT '0',
`socketmodels_id_endpoint_a` int(10) unsigned NOT NULL DEFAULT '0',
`socketmodels_id_endpoint_b` int(10) unsigned NOT NULL DEFAULT '0',
`sockets_id_endpoint_a` int(10) unsigned NOT NULL DEFAULT '0',
`sockets_id_endpoint_b` int(10) unsigned NOT NULL DEFAULT '0',
`cablestrands_id` int(10) unsigned NOT NULL DEFAULT '0',
`color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`otherserial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`states_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`cabletypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `item_endpoint_a` (`itemtype_endpoint_a`,`items_id_endpoint_a`),
KEY `item_endpoint_b` (`itemtype_endpoint_b`,`items_id_endpoint_b`),
KEY `items_id_endpoint_b` (`items_id_endpoint_b`),
KEY `items_id_endpoint_a` (`items_id_endpoint_a`),
KEY `socketmodels_id_endpoint_a` (`socketmodels_id_endpoint_a`),
KEY `socketmodels_id_endpoint_b` (`socketmodels_id_endpoint_b`),
KEY `sockets_id_endpoint_a` (`sockets_id_endpoint_a`),
KEY `sockets_id_endpoint_b` (`sockets_id_endpoint_b`),
KEY `cablestrands_id` (`cablestrands_id`),
KEY `states_id` (`states_id`),
KEY `complete` (`entities_id`,`name`),
KEY `is_recursive` (`is_recursive`),
KEY `users_id_tech` (`users_id_tech`),
KEY `cabletypes_id` (`cabletypes_id`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `is_deleted` (`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cablestrands`
--
CREATE TABLE `glpi_cablestrands` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cabletypes`
--
CREATE TABLE `glpi_cabletypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_calendars`
--
CREATE TABLE `glpi_calendars` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`cache_duration` text COLLATE utf8mb4_unicode_ci,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `glpi_calendars`
--
INSERT INTO `glpi_calendars` VALUES
(1, 'Default', 0, 1, 'Default calendar', NULL, '[0,43200,43200,43200,43200,43200,0]', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_calendarsegments`
--
CREATE TABLE `glpi_calendarsegments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`calendars_id` int(10) unsigned NOT NULL DEFAULT '0',
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`day` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'numer of the day based on date(w)',
`begin` time DEFAULT NULL,
`end` time DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `calendars_id` (`calendars_id`),
KEY `day` (`day`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=6 ;
--
-- Dumping data for table `glpi_calendarsegments`
--
INSERT INTO `glpi_calendarsegments` VALUES
(1, 1, 0, 0, 1, '08:00:00', '20:00:00'),
(2, 1, 0, 0, 2, '08:00:00', '20:00:00'),
(3, 1, 0, 0, 3, '08:00:00', '20:00:00'),
(4, 1, 0, 0, 4, '08:00:00', '20:00:00'),
(5, 1, 0, 0, 5, '08:00:00', '20:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `glpi_calendars_holidays`
--
CREATE TABLE `glpi_calendars_holidays` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`calendars_id` int(10) unsigned NOT NULL DEFAULT '0',
`holidays_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`calendars_id`,`holidays_id`),
KEY `holidays_id` (`holidays_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cartridgeitems`
--
CREATE TABLE `glpi_cartridgeitems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ref` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`cartridgeitemtypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`alarm_threshold` int(11) NOT NULL DEFAULT '10',
`stock_target` int(11) NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`pictures` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `manufacturers_id` (`manufacturers_id`),
KEY `locations_id` (`locations_id`),
KEY `users_id_tech` (`users_id_tech`),
KEY `cartridgeitemtypes_id` (`cartridgeitemtypes_id`),
KEY `is_deleted` (`is_deleted`),
KEY `alarm_threshold` (`alarm_threshold`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cartridgeitems_printermodels`
--
CREATE TABLE `glpi_cartridgeitems_printermodels` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cartridgeitems_id` int(10) unsigned NOT NULL DEFAULT '0',
`printermodels_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`printermodels_id`,`cartridgeitems_id`),
KEY `cartridgeitems_id` (`cartridgeitems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cartridgeitemtypes`
--
CREATE TABLE `glpi_cartridgeitemtypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_cartridges`
--
CREATE TABLE `glpi_cartridges` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`cartridgeitems_id` int(10) unsigned NOT NULL DEFAULT '0',
`printers_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_in` date DEFAULT NULL,
`date_use` date DEFAULT NULL,
`date_out` date DEFAULT NULL,
`pages` int(11) NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `cartridgeitems_id` (`cartridgeitems_id`),
KEY `printers_id` (`printers_id`),
KEY `entities_id` (`entities_id`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_certificates`
--
CREATE TABLE `glpi_certificates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`otherserial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_template` tinyint(4) NOT NULL DEFAULT '0',
`template_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`certificatetypes_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_certificatetypes (id)',
`dns_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dns_suffix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_users (id)',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_groups (id)',
`locations_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_locations (id)',
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_manufacturers (id)',
`contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_num` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_autosign` tinyint(4) NOT NULL DEFAULT '0',
`date_expiration` date DEFAULT NULL,
`states_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to states (id)',
`command` text COLLATE utf8mb4_unicode_ci,
`certificate_request` text COLLATE utf8mb4_unicode_ci,
`certificate_item` text COLLATE utf8mb4_unicode_ci,
`date_creation` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `is_template` (`is_template`),
KEY `is_deleted` (`is_deleted`),
KEY `certificatetypes_id` (`certificatetypes_id`),
KEY `users_id_tech` (`users_id_tech`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `groups_id` (`groups_id`),
KEY `users_id` (`users_id`),
KEY `locations_id` (`locations_id`),
KEY `manufacturers_id` (`manufacturers_id`),
KEY `states_id` (`states_id`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_certificates_items`
--
CREATE TABLE `glpi_certificates_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`certificates_id` int(10) unsigned NOT NULL DEFAULT '0',
`items_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to various tables, according to itemtype (id)',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'see .class.php file',
`date_creation` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`certificates_id`,`itemtype`,`items_id`),
KEY `item` (`itemtype`,`items_id`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_certificatetypes`
--
CREATE TABLE `glpi_certificatetypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_creation` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `name` (`name`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changecosts`
--
CREATE TABLE `glpi_changecosts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`begin_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`actiontime` int(11) NOT NULL DEFAULT '0',
`cost_time` decimal(20,4) NOT NULL DEFAULT '0.0000',
`cost_fixed` decimal(20,4) NOT NULL DEFAULT '0.0000',
`cost_material` decimal(20,4) NOT NULL DEFAULT '0.0000',
`budgets_id` int(10) unsigned NOT NULL DEFAULT '0',
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `changes_id` (`changes_id`),
KEY `begin_date` (`begin_date`),
KEY `end_date` (`end_date`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `budgets_id` (`budgets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes`
--
CREATE TABLE `glpi_changes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '1',
`content` longtext COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date` timestamp NULL DEFAULT NULL,
`solvedate` timestamp NULL DEFAULT NULL,
`closedate` timestamp NULL DEFAULT NULL,
`time_to_resolve` timestamp NULL DEFAULT NULL,
`users_id_recipient` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_lastupdater` int(10) unsigned NOT NULL DEFAULT '0',
`urgency` int(11) NOT NULL DEFAULT '1',
`impact` int(11) NOT NULL DEFAULT '1',
`priority` int(11) NOT NULL DEFAULT '1',
`itilcategories_id` int(10) unsigned NOT NULL DEFAULT '0',
`impactcontent` longtext COLLATE utf8mb4_unicode_ci,
`controlistcontent` longtext COLLATE utf8mb4_unicode_ci,
`rolloutplancontent` longtext COLLATE utf8mb4_unicode_ci,
`backoutplancontent` longtext COLLATE utf8mb4_unicode_ci,
`checklistcontent` longtext COLLATE utf8mb4_unicode_ci,
`global_validation` int(11) NOT NULL DEFAULT '1',
`validation_percent` int(11) NOT NULL DEFAULT '0',
`actiontime` int(11) NOT NULL DEFAULT '0',
`begin_waiting_date` timestamp NULL DEFAULT NULL,
`waiting_duration` int(11) NOT NULL DEFAULT '0',
`close_delay_stat` int(11) NOT NULL DEFAULT '0',
`solve_delay_stat` int(11) NOT NULL DEFAULT '0',
`date_creation` timestamp NULL DEFAULT NULL,
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `is_deleted` (`is_deleted`),
KEY `date` (`date`),
KEY `closedate` (`closedate`),
KEY `status` (`status`),
KEY `priority` (`priority`),
KEY `date_mod` (`date_mod`),
KEY `itilcategories_id` (`itilcategories_id`),
KEY `users_id_recipient` (`users_id_recipient`),
KEY `solvedate` (`solvedate`),
KEY `urgency` (`urgency`),
KEY `impact` (`impact`),
KEY `time_to_resolve` (`time_to_resolve`),
KEY `global_validation` (`global_validation`),
KEY `users_id_lastupdater` (`users_id_lastupdater`),
KEY `date_creation` (`date_creation`),
KEY `locations_id` (`locations_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes_groups`
--
CREATE TABLE `glpi_changes_groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changes_id`,`type`,`groups_id`),
KEY `group` (`groups_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes_items`
--
CREATE TABLE `glpi_changes_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changes_id`,`itemtype`,`items_id`),
KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes_problems`
--
CREATE TABLE `glpi_changes_problems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`problems_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changes_id`,`problems_id`),
KEY `problems_id` (`problems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes_suppliers`
--
CREATE TABLE `glpi_changes_suppliers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`suppliers_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '1',
`use_notification` tinyint(4) NOT NULL DEFAULT '0',
`alternative_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changes_id`,`type`,`suppliers_id`),
KEY `group` (`suppliers_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes_tickets`
--
CREATE TABLE `glpi_changes_tickets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`tickets_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changes_id`,`tickets_id`),
KEY `tickets_id` (`tickets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changes_users`
--
CREATE TABLE `glpi_changes_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '1',
`use_notification` tinyint(4) NOT NULL DEFAULT '0',
`alternative_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changes_id`,`type`,`users_id`,`alternative_email`),
KEY `user` (`users_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changetasks`
--
CREATE TABLE `glpi_changetasks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`taskcategories_id` int(10) unsigned NOT NULL DEFAULT '0',
`state` int(11) NOT NULL DEFAULT '0',
`date` timestamp NULL DEFAULT NULL,
`begin` timestamp NULL DEFAULT NULL,
`end` timestamp NULL DEFAULT NULL,
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_editor` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`content` longtext COLLATE utf8mb4_unicode_ci,
`actiontime` int(11) NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`tasktemplates_id` int(10) unsigned NOT NULL DEFAULT '0',
`timeline_position` tinyint(4) NOT NULL DEFAULT '0',
`is_private` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uuid` (`uuid`),
KEY `changes_id` (`changes_id`),
KEY `state` (`state`),
KEY `users_id` (`users_id`),
KEY `users_id_editor` (`users_id_editor`),
KEY `users_id_tech` (`users_id_tech`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `date` (`date`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `begin` (`begin`),
KEY `end` (`end`),
KEY `taskcategories_id` (`taskcategories_id`),
KEY `tasktemplates_id` (`tasktemplates_id`),
KEY `is_private` (`is_private`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changetemplatehiddenfields`
--
CREATE TABLE `glpi_changetemplatehiddenfields` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changetemplates_id` int(10) unsigned NOT NULL DEFAULT '0',
`num` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changetemplates_id`,`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changetemplatemandatoryfields`
--
CREATE TABLE `glpi_changetemplatemandatoryfields` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changetemplates_id` int(10) unsigned NOT NULL DEFAULT '0',
`num` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`changetemplates_id`,`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `glpi_changetemplatemandatoryfields`
--
INSERT INTO `glpi_changetemplatemandatoryfields` VALUES
(1, 1, 21);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changetemplatepredefinedfields`
--
CREATE TABLE `glpi_changetemplatepredefinedfields` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changetemplates_id` int(10) unsigned NOT NULL DEFAULT '0',
`num` int(11) NOT NULL DEFAULT '0',
`value` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `changetemplates_id` (`changetemplates_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changetemplates`
--
CREATE TABLE `glpi_changetemplates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `glpi_changetemplates`
--
INSERT INTO `glpi_changetemplates` VALUES
(1, 'Default', 0, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_changevalidations`
--
CREATE TABLE `glpi_changevalidations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`changes_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_validate` int(10) unsigned NOT NULL DEFAULT '0',
`comment_submission` text COLLATE utf8mb4_unicode_ci,
`comment_validation` text COLLATE utf8mb4_unicode_ci,
`status` int(11) NOT NULL DEFAULT '2',
`submission_date` timestamp NULL DEFAULT NULL,
`validation_date` timestamp NULL DEFAULT NULL,
`timeline_position` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `users_id` (`users_id`),
KEY `users_id_validate` (`users_id_validate`),
KEY `changes_id` (`changes_id`),
KEY `submission_date` (`submission_date`),
KEY `validation_date` (`validation_date`),
KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_clusters`
--
CREATE TABLE `glpi_clusters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`states_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to states (id)',
`comment` text COLLATE utf8mb4_unicode_ci,
`clustertypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`autoupdatesystems_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `users_id_tech` (`users_id_tech`),
KEY `group_id_tech` (`groups_id_tech`),
KEY `is_deleted` (`is_deleted`),
KEY `states_id` (`states_id`),
KEY `clustertypes_id` (`clustertypes_id`),
KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_clustertypes`
--
CREATE TABLE `glpi_clustertypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_creation` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_computerantiviruses`
--
CREATE TABLE `glpi_computerantiviruses` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`computers_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0',
`antivirus_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`signature_version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_active` tinyint(4) NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_uptodate` tinyint(4) NOT NULL DEFAULT '0',
`is_dynamic` tinyint(4) NOT NULL DEFAULT '0',
`date_expiration` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `antivirus_version` (`antivirus_version`),
KEY `signature_version` (`signature_version`),
KEY `is_active` (`is_active`),
KEY `is_uptodate` (`is_uptodate`),
KEY `is_dynamic` (`is_dynamic`),
KEY `is_deleted` (`is_deleted`),
KEY `computers_id` (`computers_id`),
KEY `date_expiration` (`date_expiration`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `manufacturers_id` (`manufacturers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_computermodels`
--
CREATE TABLE `glpi_computermodels` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`product_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` int(11) NOT NULL DEFAULT '0',
`required_units` int(11) NOT NULL DEFAULT '1',
`depth` float NOT NULL DEFAULT '1',
`power_connections` int(11) NOT NULL DEFAULT '0',
`power_consumption` int(11) NOT NULL DEFAULT '0',
`is_half_rack` tinyint(4) NOT NULL DEFAULT '0',
`picture_front` text COLLATE utf8mb4_unicode_ci,
`picture_rear` text COLLATE utf8mb4_unicode_ci,
`pictures` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `product_number` (`product_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_computers`
--
CREATE TABLE `glpi_computers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`otherserial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contact_num` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`autoupdatesystems_id` int(10) unsigned NOT NULL DEFAULT '0',
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`networks_id` int(10) unsigned NOT NULL DEFAULT '0',
`computermodels_id` int(10) unsigned NOT NULL DEFAULT '0',
`computertypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_template` tinyint(4) NOT NULL DEFAULT '0',
`template_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_dynamic` tinyint(4) NOT NULL DEFAULT '0',
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id` int(10) unsigned NOT NULL DEFAULT '0',
`states_id` int(10) unsigned NOT NULL DEFAULT '0',
`ticket_tco` decimal(20,4) DEFAULT '0.0000',
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`last_inventory_update` timestamp NULL DEFAULT NULL,
`last_boot` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `date_mod` (`date_mod`),
KEY `name` (`name`),
KEY `is_template` (`is_template`),
KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
KEY `entities_id` (`entities_id`),
KEY `manufacturers_id` (`manufacturers_id`),
KEY `groups_id` (`groups_id`),
KEY `users_id` (`users_id`),
KEY `locations_id` (`locations_id`),
KEY `computermodels_id` (`computermodels_id`),
KEY `networks_id` (`networks_id`),
KEY `states_id` (`states_id`),
KEY `users_id_tech` (`users_id_tech`),
KEY `computertypes_id` (`computertypes_id`),
KEY `is_deleted` (`is_deleted`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `is_dynamic` (`is_dynamic`),
KEY `serial` (`serial`),
KEY `otherserial` (`otherserial`),
KEY `uuid` (`uuid`),
KEY `date_creation` (`date_creation`),
KEY `is_recursive` (`is_recursive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_computers_items`
--
CREATE TABLE `glpi_computers_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`items_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'RELATION to various table, according to itemtype (ID)',
`computers_id` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_dynamic` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `computers_id` (`computers_id`),
KEY `item` (`itemtype`,`items_id`),
KEY `is_deleted` (`is_deleted`),
KEY `is_dynamic` (`is_dynamic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_computertypes`
--
CREATE TABLE `glpi_computertypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_computervirtualmachines`
--
CREATE TABLE `glpi_computervirtualmachines` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`computers_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`virtualmachinestates_id` int(10) unsigned NOT NULL DEFAULT '0',
`virtualmachinesystems_id` int(10) unsigned NOT NULL DEFAULT '0',
`virtualmachinetypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`vcpu` int(11) NOT NULL DEFAULT '0',
`ram` int(10) unsigned DEFAULT NULL,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_dynamic` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `computers_id` (`computers_id`),
KEY `entities_id` (`entities_id`),
KEY `name` (`name`),
KEY `virtualmachinestates_id` (`virtualmachinestates_id`),
KEY `virtualmachinesystems_id` (`virtualmachinesystems_id`),
KEY `vcpu` (`vcpu`),
KEY `ram` (`ram`),
KEY `is_deleted` (`is_deleted`),
KEY `is_dynamic` (`is_dynamic`),
KEY `uuid` (`uuid`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `virtualmachinetypes_id` (`virtualmachinetypes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_configs`
--
CREATE TABLE `glpi_configs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`context` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`context`,`name`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=271 ;
--
-- Dumping data for table `glpi_configs`
--
INSERT INTO `glpi_configs` VALUES
(1, 'core', 'version', '10.0.19'),
(2, 'core', 'show_jobs_at_login', '0'),
(3, 'core', 'cut', '250'),
(4, 'core', 'list_limit', '15'),
(5, 'core', 'list_limit_max', '50'),
(6, 'core', 'url_maxlength', '30'),
(7, 'core', 'event_loglevel', '5'),
(8, 'core', 'notifications_mailing', '0'),
(9, 'core', 'admin_email', 'admsys@[[domhost]]'),
(10, 'core', 'admin_email_name', ''),
(11, 'core', 'from_email', ''),
(12, 'core', 'from_email_name', ''),
(13, 'core', 'noreply_email', ''),
(14, 'core', 'noreply_email_name', ''),
(15, 'core', 'replyto_email', ''),
(16, 'core', 'replyto_email_name', ''),
(17, 'core', 'mailing_signature', 'SIGNATURE'),
(18, 'core', 'use_anonymous_helpdesk', '0'),
(19, 'core', 'use_anonymous_followups', '0'),
(20, 'core', 'language', '[[language]]'),
(21, 'core', 'priority_1', '#fff2f2'),
(22, 'core', 'priority_2', '#ffe0e0'),
(23, 'core', 'priority_3', '#ffcece'),
(24, 'core', 'priority_4', '#ffbfbf'),
(25, 'core', 'priority_5', '#ffadad'),
(26, 'core', 'priority_6', '#ff5555'),
(27, 'core', 'date_tax', '2005-12-31'),
(28, 'core', 'cas_host', ''),
(29, 'core', 'cas_port', '443'),
(30, 'core', 'cas_uri', ''),
(31, 'core', 'cas_logout', ''),
(32, 'core', 'cas_version', 'CAS_VERSION_2_0'),
(33, 'core', 'existing_auth_server_field_clean_domain', '0'),
(34, 'core', 'planning_begin', '08:00:00'),
(35, 'core', 'planning_end', '20:00:00'),
(36, 'core', 'utf8_conv', '1'),
(37, 'core', 'use_public_faq', '0'),
(38, 'core', 'url_base', '[[softurl]]'),
(39, 'core', 'show_link_in_mail', '0'),
(40, 'core', 'text_login', ''),
(41, 'core', 'founded_new_version', ''),
(42, 'core', 'dropdown_max', '100'),
(43, 'core', 'ajax_wildcard', '*'),
(44, 'core', 'ajax_limit_count', '10'),
(45, 'core', 'is_users_auto_add', '1'),
(46, 'core', 'date_format', '0'),
(47, 'core', 'number_format', '0'),
(48, 'core', 'csv_delimiter', ';'),
(49, 'core', 'is_ids_visible', '0'),
(50, 'core', 'smtp_mode', '0'),
(51, 'core', 'smtp_host', ''),
(52, 'core', 'smtp_port', '25'),
(53, 'core', 'smtp_username', ''),
(54, 'core', 'smtp_oauth_provider', ''),
(55, 'core', 'smtp_oauth_client_id', ''),
(56, 'core', 'smtp_oauth_client_secret', ''),
(57, 'core', 'smtp_oauth_options', '{}'),
(58, 'core', 'smtp_oauth_refresh_token', ''),
(59, 'core', 'proxy_name', ''),
(60, 'core', 'proxy_port', '8080'),
(61, 'core', 'proxy_user', ''),
(62, 'core', 'add_followup_on_update_ticket', '1'),
(63, 'core', 'keep_tickets_on_delete', '0'),
(64, 'core', 'time_step', '5'),
(65, 'core', 'decimal_number', '2'),
(66, 'core', 'helpdesk_doc_url', ''),
(67, 'core', 'central_doc_url', ''),
(68, 'core', 'documentcategories_id_forticket', '0'),
(69, 'core', 'monitors_management_restrict', '2'),
(70, 'core', 'phones_management_restrict', '2'),
(71, 'core', 'peripherals_management_restrict', '2'),
(72, 'core', 'printers_management_restrict', '2'),
(73, 'core', 'use_log_in_files', '1'),
(74, 'core', 'time_offset', '0'),
(75, 'core', 'is_contact_autoupdate', '1'),
(76, 'core', 'is_user_autoupdate', '1'),
(77, 'core', 'is_group_autoupdate', '1'),
(78, 'core', 'is_location_autoupdate', '1'),
(79, 'core', 'state_autoupdate_mode', '0'),
(80, 'core', 'is_contact_autoclean', '0'),
(81, 'core', 'is_user_autoclean', '0'),
(82, 'core', 'is_group_autoclean', '0'),
(83, 'core', 'is_location_autoclean', '0'),
(84, 'core', 'state_autoclean_mode', '0'),
(85, 'core', 'use_flat_dropdowntree', '0'),
(86, 'core', 'use_flat_dropdowntree_on_search_result', '1'),
(87, 'core', 'use_autoname_by_entity', '1'),
(88, 'core', 'softwarecategories_id_ondelete', '1'),
(89, 'core', 'x509_email_field', ''),
(90, 'core', 'x509_cn_restrict', ''),
(91, 'core', 'x509_o_restrict', ''),
(92, 'core', 'x509_ou_restrict', ''),
(93, 'core', 'default_mailcollector_filesize_max', '2097152'),
(94, 'core', 'followup_private', '0'),
(95, 'core', 'task_private', '0'),
(96, 'core', 'default_software_helpdesk_visible', '1'),
(97, 'core', 'names_format', '0'),
(98, 'core', 'default_requesttypes_id', '1'),
(99, 'core', 'use_noright_users_add', '1'),
(100, 'core', 'cron_limit', '5'),
(101, 'core', 'priority_matrix', '{"1":{"1":1,"2":1,"3":2,"4":2,"5":2},"2":{"1":1,"2":2,"3":2,"4":3,"5":3},"3":{"1":2,"2":2,"3":3,"4":4,"5":4},"4":{"1":2,"2":3,"3":4,"4":4,"5":5},"5":{"1":2,"2":3,"3":4,"4":5,"5":5}}'),
(102, 'core', 'urgency_mask', '62'),
(103, 'core', 'impact_mask', '62'),
(104, 'core', 'user_deleted_ldap', '0'),
(105, 'core', 'user_restored_ldap', '0'),
(106, 'core', 'auto_create_infocoms', '0'),
(107, 'core', 'use_slave_for_search', '0'),
(108, 'core', 'proxy_passwd', ''),
(109, 'core', 'smtp_passwd', ''),
(110, 'core', 'show_count_on_tabs', '1'),
(111, 'core', 'refresh_views', '0'),
(112, 'core', 'set_default_tech', '1'),
(113, 'core', 'allow_search_view', '2'),
(114, 'core', 'allow_search_all', '0'),
(115, 'core', 'allow_search_global', '1'),
(116, 'core', 'display_count_on_home', '5'),
(117, 'core', 'use_password_security', '0'),
(118, 'core', 'password_min_length', '8'),
(119, 'core', 'password_need_number', '1'),
(120, 'core', 'password_need_letter', '1'),
(121, 'core', 'password_need_caps', '1'),
(122, 'core', 'password_need_symbol', '1'),
(123, 'core', 'use_check_pref', '0'),
(124, 'core', 'notification_to_myself', '1'),
(125, 'core', 'duedateok_color', '#06ff00'),
(126, 'core', 'duedatewarning_color', '#ffb800'),
(127, 'core', 'duedatecritical_color', '#ff0000'),
(128, 'core', 'duedatewarning_less', '20'),
(129, 'core', 'duedatecritical_less', '5'),
(130, 'core', 'duedatewarning_unit', '%'),
(131, 'core', 'duedatecritical_unit', '%'),
(132, 'core', 'realname_ssofield', ''),
(133, 'core', 'firstname_ssofield', ''),
(134, 'core', 'email1_ssofield', ''),
(135, 'core', 'email2_ssofield', ''),
(136, 'core', 'email3_ssofield', ''),
(137, 'core', 'email4_ssofield', ''),
(138, 'core', 'phone_ssofield', ''),
(139, 'core', 'phone2_ssofield', ''),
(140, 'core', 'mobile_ssofield', ''),
(141, 'core', 'comment_ssofield', ''),
(142, 'core', 'title_ssofield', ''),
(143, 'core', 'category_ssofield', ''),
(144, 'core', 'language_ssofield', ''),
(145, 'core', 'entity_ssofield', ''),
(146, 'core', 'registration_number_ssofield', ''),
(147, 'core', 'ssovariables_id', '0'),
(148, 'core', 'ssologout_url', ''),
(149, 'core', 'translate_kb', '0'),
(150, 'core', 'translate_dropdowns', '0'),
(151, 'core', 'translate_reminders', '0'),
(152, 'core', 'pdffont', 'dejavusans'),
(153, 'core', 'keep_devices_when_purging_item', '0'),
(154, 'core', 'maintenance_mode', '0'),
(155, 'core', 'maintenance_text', ''),
(156, 'core', 'attach_ticket_documents_to_mail', '0'),
(157, 'core', 'backcreated', '0'),
(158, 'core', 'task_state', '1'),
(159, 'core', 'palette', 'auror'),
(160, 'core', 'page_layout', 'vertical'),
(161, 'core', 'fold_menu', '0'),
(162, 'core', 'fold_search', '0'),
(163, 'core', 'savedsearches_pinned', '0'),
(164, 'core', 'timeline_order', 'natural'),
(165, 'core', 'itil_layout', ''),
(166, 'core', 'richtext_layout', 'classic'),
(167, 'core', 'lock_use_lock_item', '0'),
(168, 'core', 'lock_autolock_mode', '1'),
(169, 'core', 'lock_directunlock_notification', '0'),
(170, 'core', 'lock_item_list', '[]'),
(171, 'core', 'lock_lockprofile_id', '8'),
(172, 'core', 'set_default_requester', '1'),
(173, 'core', 'highcontrast_css', '0'),
(174, 'core', 'default_central_tab', '0'),
(175, 'core', 'smtp_check_certificate', '1'),
(176, 'core', 'enable_api', '0'),
(177, 'core', 'enable_api_login_credentials', '0'),
(178, 'core', 'enable_api_login_external_token', '1'),
(179, 'core', 'url_base_api', '[[softurl]]/apirest.php/'),
(180, 'core', 'login_remember_time', '604800'),
(181, 'core', 'login_remember_default', '1'),
(182, 'core', 'use_notifications', '0'),
(183, 'core', 'notifications_ajax', '0'),
(184, 'core', 'notifications_ajax_check_interval', '5'),
(185, 'core', 'notifications_ajax_sound', NULL),
(186, 'core', 'notifications_ajax_icon_url', '/pics/glpi.png'),
(187, 'core', 'dbversion', '10.0.19@d64066799f068b16ee973b377bdd13f984fe062a'),
(188, 'core', 'smtp_max_retries', '5'),
(189, 'core', 'smtp_sender', NULL),
(190, 'core', 'instance_uuid', NULL),
(191, 'core', 'registration_uuid', '[[random_int]]'),
(192, 'core', 'smtp_retry_time', '5'),
(193, 'core', 'purge_addrelation', '0'),
(194, 'core', 'purge_deleterelation', '0'),
(195, 'core', 'purge_createitem', '0'),
(196, 'core', 'purge_deleteitem', '0'),
(197, 'core', 'purge_restoreitem', '0'),
(198, 'core', 'purge_updateitem', '0'),
(199, 'core', 'purge_item_software_install', '0'),
(200, 'core', 'purge_software_item_install', '0'),
(201, 'core', 'purge_software_version_install', '0'),
(202, 'core', 'purge_infocom_creation', '0'),
(203, 'core', 'purge_profile_user', '0'),
(204, 'core', 'purge_group_user', '0'),
(205, 'core', 'purge_adddevice', '0'),
(206, 'core', 'purge_updatedevice', '0'),
(207, 'core', 'purge_deletedevice', '0'),
(208, 'core', 'purge_connectdevice', '0'),
(209, 'core', 'purge_disconnectdevice', '0'),
(210, 'core', 'purge_userdeletedfromldap', '0'),
(211, 'core', 'purge_comments', '0'),
(212, 'core', 'purge_datemod', '0'),
(213, 'core', 'purge_all', '0'),
(214, 'core', 'purge_user_auth_changes', '0'),
(215, 'core', 'purge_plugins', '0'),
(216, 'core', 'purge_refusedequipment', '0'),
(217, 'core', 'display_login_source', '1'),
(218, 'core', 'devices_in_menu', '["Item_DeviceSimcard"]'),
(219, 'core', 'password_expiration_delay', '-1'),
(220, 'core', 'password_expiration_notice', '-1'),
(221, 'core', 'password_expiration_lock_delay', '-1'),
(222, 'core', 'default_dashboard_central', 'central'),
(223, 'core', 'default_dashboard_assets', 'assets'),
(224, 'core', 'default_dashboard_helpdesk', 'assistance'),
(225, 'core', 'default_dashboard_mini_ticket', 'mini_tickets'),
(226, 'core', 'impact_enabled_itemtypes', '["Appliance","Cluster","Computer","Datacenter","DCRoom","Domain","Enclosure","Monitor","NetworkEquipment","PDU","Peripheral","Phone","Printer","Rack","Software","DatabaseInstance"]'),
(227, 'core', 'document_max_size', '8'),
(228, 'core', 'planning_work_days', '[0,1,2,3,4,5,6]'),
(229, 'core', 'system_user', '6'),
(230, 'core', 'support_legacy_data', '0'),
(231, 'core', 'initialized_rules_collections', '["RuleImportAssetCollection","RuleMailCollectorCollection","RuleRightCollection","RuleSoftwareCategoryCollection","RuleTicketCollection","RuleAssetCollection","RuleDictionnaryOperatingSystemCollection","RuleDictionnaryOperatingSystemVersionCollection","RuleDictionnaryOperatingSystemEditionCollection"]'),
(232, 'core', 'timeline_action_btn_layout', '0'),
(233, 'core', 'timeline_date_format', '0'),
(234, 'inventory', 'enabled_inventory', '0'),
(235, 'inventory', 'import_software', '1'),
(236, 'inventory', 'import_volume', '1'),
(237, 'inventory', 'import_antivirus', '1'),
(238, 'inventory', 'import_registry', '1'),
(239, 'inventory', 'import_process', '1'),
(240, 'inventory', 'import_vm', '1'),
(241, 'inventory', 'import_monitor_on_partial_sn', '0'),
(242, 'inventory', 'import_unmanaged', '1'),
(243, 'inventory', 'component_processor', '1'),
(244, 'inventory', 'component_memory', '1'),
(245, 'inventory', 'component_harddrive', '1'),
(246, 'inventory', 'component_networkcard', '1'),
(247, 'inventory', 'component_graphiccard', '1'),
(248, 'inventory', 'component_soundcard', '1'),
(249, 'inventory', 'component_drive', '1'),
(250, 'inventory', 'component_networkdrive', '1'),
(251, 'inventory', 'component_networkcardvirtual', '1'),
(252, 'inventory', 'component_control', '1'),
(253, 'inventory', 'component_battery', '1'),
(254, 'inventory', 'component_simcard', '1'),
(255, 'inventory', 'states_id_default', '0'),
(256, 'inventory', 'entities_id_default', '0'),
(257, 'inventory', 'location', '0'),
(258, 'inventory', 'group', '0'),
(259, 'inventory', 'vm_type', '0'),
(260, 'inventory', 'vm_components', '0'),
(261, 'inventory', 'vm_as_computer', '0'),
(262, 'inventory', 'component_removablemedia', '1'),
(263, 'inventory', 'component_powersupply', '1'),
(264, 'inventory', 'inventory_frequency', '24'),
(265, 'inventory', 'import_monitor', '1'),
(266, 'inventory', 'import_printer', '1'),
(267, 'inventory', 'import_peripheral', '1'),
(268, 'inventory', 'stale_agents_delay', '0'),
(269, 'inventory', 'stale_agents_action', '[0]'),
(270, 'inventory', 'stale_agents_status', '0');
-- --------------------------------------------------------
--
-- Table structure for table `glpi_consumableitems`
--
CREATE TABLE `glpi_consumableitems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ref` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`consumableitemtypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`alarm_threshold` int(11) NOT NULL DEFAULT '10',
`stock_target` int(11) NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`otherserial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pictures` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `manufacturers_id` (`manufacturers_id`),
KEY `locations_id` (`locations_id`),
KEY `users_id_tech` (`users_id_tech`),
KEY `consumableitemtypes_id` (`consumableitemtypes_id`),
KEY `is_deleted` (`is_deleted`),
KEY `alarm_threshold` (`alarm_threshold`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`),
KEY `otherserial` (`otherserial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_consumableitemtypes`
--
CREATE TABLE `glpi_consumableitemtypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_consumables`
--
CREATE TABLE `glpi_consumables` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`consumableitems_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_in` date DEFAULT NULL,
`date_out` date DEFAULT NULL,
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `date_in` (`date_in`),
KEY `date_out` (`date_out`),
KEY `consumableitems_id` (`consumableitems_id`),
KEY `entities_id` (`entities_id`),
KEY `item` (`itemtype`,`items_id`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contacts`
--
CREATE TABLE `glpi_contacts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`registration_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contacttypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`usertitles_id` int(10) unsigned NOT NULL DEFAULT '0',
`address` text COLLATE utf8mb4_unicode_ci,
`postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`town` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`pictures` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `contacttypes_id` (`contacttypes_id`),
KEY `is_deleted` (`is_deleted`),
KEY `usertitles_id` (`usertitles_id`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contacts_suppliers`
--
CREATE TABLE `glpi_contacts_suppliers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`suppliers_id` int(10) unsigned NOT NULL DEFAULT '0',
`contacts_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`suppliers_id`,`contacts_id`),
KEY `contacts_id` (`contacts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contacttypes`
--
CREATE TABLE `glpi_contacttypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contractcosts`
--
CREATE TABLE `glpi_contractcosts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`contracts_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`begin_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`cost` decimal(20,4) NOT NULL DEFAULT '0.0000',
`budgets_id` int(10) unsigned NOT NULL DEFAULT '0',
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `contracts_id` (`contracts_id`),
KEY `begin_date` (`begin_date`),
KEY `end_date` (`end_date`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `budgets_id` (`budgets_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contracts`
--
CREATE TABLE `glpi_contracts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`num` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contracttypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`begin_date` date DEFAULT NULL,
`duration` int(11) NOT NULL DEFAULT '0',
`notice` int(11) NOT NULL DEFAULT '0',
`periodicity` int(11) NOT NULL DEFAULT '0',
`billing` int(11) NOT NULL DEFAULT '0',
`comment` text COLLATE utf8mb4_unicode_ci,
`accounting_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`week_begin_hour` time NOT NULL DEFAULT '00:00:00',
`week_end_hour` time NOT NULL DEFAULT '00:00:00',
`saturday_begin_hour` time NOT NULL DEFAULT '00:00:00',
`saturday_end_hour` time NOT NULL DEFAULT '00:00:00',
`use_saturday` tinyint(4) NOT NULL DEFAULT '0',
`sunday_begin_hour` time NOT NULL DEFAULT '00:00:00',
`sunday_end_hour` time NOT NULL DEFAULT '00:00:00',
`use_sunday` tinyint(4) NOT NULL DEFAULT '0',
`max_links_allowed` int(11) NOT NULL DEFAULT '0',
`alert` int(11) NOT NULL DEFAULT '0',
`renewal` int(11) NOT NULL DEFAULT '0',
`template_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_template` tinyint(4) NOT NULL DEFAULT '0',
`states_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `begin_date` (`begin_date`),
KEY `name` (`name`),
KEY `contracttypes_id` (`contracttypes_id`),
KEY `locations_id` (`locations_id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `is_deleted` (`is_deleted`),
KEY `is_template` (`is_template`),
KEY `use_sunday` (`use_sunday`),
KEY `use_saturday` (`use_saturday`),
KEY `alert` (`alert`),
KEY `states_id` (`states_id`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contracts_items`
--
CREATE TABLE `glpi_contracts_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`contracts_id` int(10) unsigned NOT NULL DEFAULT '0',
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`contracts_id`,`itemtype`,`items_id`),
KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contracts_suppliers`
--
CREATE TABLE `glpi_contracts_suppliers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`suppliers_id` int(10) unsigned NOT NULL DEFAULT '0',
`contracts_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`suppliers_id`,`contracts_id`),
KEY `contracts_id` (`contracts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_contracttypes`
--
CREATE TABLE `glpi_contracttypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_crontasklogs`
--
CREATE TABLE `glpi_crontasklogs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`crontasks_id` int(10) unsigned NOT NULL,
`crontasklogs_id` int(10) unsigned NOT NULL COMMENT 'id of ''start'' event',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`state` int(11) NOT NULL COMMENT '0:start, 1:run, 2:stop',
`elapsed` float NOT NULL COMMENT 'time elapsed since start',
`volume` int(11) NOT NULL COMMENT 'for statistics',
`content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'message',
PRIMARY KEY (`id`),
KEY `date` (`date`),
KEY `crontasks_id` (`crontasks_id`),
KEY `crontasklogs_id_state` (`crontasklogs_id`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_crontasks`
--
CREATE TABLE `glpi_crontasks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'task name',
`frequency` int(11) NOT NULL COMMENT 'second between launch',
`param` int(11) DEFAULT NULL COMMENT 'task specify parameter',
`state` int(11) NOT NULL DEFAULT '1' COMMENT '0:disabled, 1:waiting, 2:running',
`mode` int(11) NOT NULL DEFAULT '1' COMMENT '1:internal, 2:external',
`allowmode` int(11) NOT NULL DEFAULT '3' COMMENT '1:internal, 2:external, 3:both',
`hourmin` int(11) NOT NULL DEFAULT '0',
`hourmax` int(11) NOT NULL DEFAULT '24',
`logs_lifetime` int(11) NOT NULL DEFAULT '30' COMMENT 'number of days',
`lastrun` timestamp NULL DEFAULT NULL COMMENT 'last run date',
`lastcode` int(11) DEFAULT NULL COMMENT 'last run return code',
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`itemtype`,`name`),
KEY `name` (`name`),
KEY `mode` (`mode`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Task run by internal / external cron.' AUTO_INCREMENT=44 ;
--
-- Dumping data for table `glpi_crontasks`
--
INSERT INTO `glpi_crontasks` VALUES
(2, 'CartridgeItem', 'cartridge', 86400, 10, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(3, 'ConsumableItem', 'consumable', 86400, 10, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(4, 'SoftwareLicense', 'software', 86400, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(5, 'Contract', 'contract', 86400, NULL, 1, 1, 3, 0, 24, 30, '[[regtime]]', NULL, NULL, NULL, NULL),
(6, 'Infocom', 'infocom', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(7, 'CronTask', 'logs', 86400, 30, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(9, 'MailCollector', 'mailgate', 600, 10, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(10, 'DBconnection', 'checkdbreplicate', 300, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(11, 'CronTask', 'checkupdate', 604800, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(12, 'CronTask', 'session', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(13, 'CronTask', 'graph', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(14, 'ReservationItem', 'reservation', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(15, 'Ticket', 'closeticket', 43200, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(16, 'Ticket', 'alertnotclosed', 43200, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(17, 'SlaLevel_Ticket', 'slaticket', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(18, 'Ticket', 'createinquest', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(19, 'CronTask', 'watcher', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(20, 'CommonITILRecurrentCron', 'RecurrentItems', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(21, 'PlanningRecall', 'planningrecall', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(22, 'QueuedNotification', 'queuednotification', 60, 50, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(23, 'QueuedNotification', 'queuednotificationclean', 86400, 30, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(24, 'CronTask', 'temp', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(25, 'MailCollector', 'mailgateerror', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(26, 'CronTask', 'circularlogs', 86400, 4, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(27, 'ObjectLock', 'unlockobject', 86400, 4, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(28, 'SavedSearch', 'countAll', 604800, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(29, 'SavedSearch_Alert', 'savedsearchesalerts', 86400, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(30, 'Telemetry', 'telemetry', 2592000, NULL, 0, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(31, 'Certificate', 'certificate', 86400, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(32, 'OlaLevel_Ticket', 'olaticket', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(33, 'PurgeLogs', 'PurgeLogs', 604800, 24, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(34, 'Ticket', 'purgeticket', 604800, NULL, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(35, 'Document', 'cleanorphans', 604800, NULL, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(36, 'User', 'passwordexpiration', 86400, 100, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(37, 'Glpi\\Marketplace\\Controller', 'checkAllUpdates', 86400, NULL, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(38, 'CleanSoftwareCron', 'cleansoftware', 2592000, 1000, 0, 2, 3, 0, 24, 300, NULL, NULL, NULL, NULL, NULL),
(39, 'Domain', 'DomainsAlert', 86400, NULL, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(40, 'Glpi\\Inventory\\Inventory', 'cleantemp', 86400, NULL, 0, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(41, 'Glpi\\Inventory\\Inventory', 'cleanorphans', 604800, NULL, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL),
(42, 'PendingReasonCron', 'pendingreason_autobump_autosolve', 1800, NULL, 1, 2, 3, 0, 24, 60, NULL, NULL, NULL, NULL, NULL),
(43, 'Agent', 'Cleanoldagents', 86400, NULL, 1, 2, 3, 0, 24, 30, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_dashboards_dashboards`
--
CREATE TABLE `glpi_dashboards_dashboards` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`context` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'core',
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`),
KEY `name` (`name`),
KEY `users_id` (`users_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=5 ;
--
-- Dumping data for table `glpi_dashboards_dashboards`
--
INSERT INTO `glpi_dashboards_dashboards` VALUES
(1, 'central', 'Central', 'core', 0),
(2, 'assets', 'Assets', 'core', 0),
(3, 'assistance', 'Assistance', 'core', 0),
(4, 'mini_tickets', 'Mini ticket Dashboard', 'mini_core', 0);
-- --------------------------------------------------------
--
-- Table structure for table `glpi_dashboards_filters`
--
CREATE TABLE `glpi_dashboards_filters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dashboards_dashboards_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id` int(10) unsigned NOT NULL DEFAULT '0',
`filter` longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `dashboards_dashboards_id` (`dashboards_dashboards_id`),
KEY `users_id` (`users_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_dashboards_items`
--
CREATE TABLE `glpi_dashboards_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dashboards_dashboards_id` int(10) unsigned NOT NULL,
`gridstack_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`card_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`card_options` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `dashboards_dashboards_id` (`dashboards_dashboards_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=65 ;
--
-- Dumping data for table `glpi_dashboards_items`
--
INSERT INTO `glpi_dashboards_items` VALUES
(1, 1, 'bn_count_Computer_4a315743-151c-40cb-a20b-762250668dac', 'bn_count_Computer', 3, 0, 3, 2, '{"color":"#e69393","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(2, 1, 'bn_count_Software_0690f524-e826-47a9-b50a-906451196b83', 'bn_count_Software', 0, 0, 3, 2, '{"color":"#aaddac","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(3, 1, 'bn_count_Rack_c6502e0a-5991-46b4-a771-7f355137306b', 'bn_count_Rack', 6, 2, 3, 2, '{"color":"#0e87a0","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(4, 1, 'bn_count_SoftwareLicense_e755fd06-283e-4479-ba35-2d548f8f8a90', 'bn_count_SoftwareLicense', 0, 2, 3, 2, '{"color":"#27ab3c","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(5, 1, 'bn_count_Monitor_7059b94c-583c-4ba7-b100-d40461165318', 'bn_count_Monitor', 3, 2, 3, 2, '{"color":"#b52d30","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(6, 1, 'bn_count_Ticket_a74c0903-3387-4a07-9111-b0938af8f1e7', 'bn_count_Ticket', 14, 7, 3, 2, '{"color":"#ffdc64","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(7, 1, 'bn_count_Problem_c1cf5cfb-f626-472e-82a1-49c3e200e746', 'bn_count_Problem', 20, 7, 3, 2, '{"color":"#f08d7b","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(8, 1, 'count_Computer_Manufacturer_6129c451-42b5-489d-b693-c362adf32d49', 'count_Computer_Manufacturer', 0, 4, 5, 4, '{"color":"#f8faf9","widgettype":"donut","use_gradient":"1","limit":"5"}'),
(9, 1, 'top_ticket_user_requester_c74f52a8-046a-4077-b1a6-c9f840d34b82', 'top_ticket_user_requester', 14, 9, 6, 5, '{"color":"#f9fafb","widgettype":"hbar","use_gradient":"1","limit":"5"}'),
(10, 1, 'bn_count_tickets_late_04c47208-d7e5-4aca-9566-d46e68c45c67', 'bn_count_tickets_late', 17, 7, 3, 2, '{"color":"#f8911f","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(11, 1, 'ticket_status_2e4e968b-d4e6-4e33-9ce9-a1aaff53dfde', 'ticket_status', 14, 0, 12, 7, '{"color":"#fafafa","widgettype":"stackedbars","use_gradient":"0","limit":"12"}'),
(12, 1, 'top_ticket_ITILCategory_37736ba9-d429-4cb3-9058-ef4d111d9269', 'top_ticket_ITILCategory', 20, 9, 6, 5, '{"color":"#fbf9f9","widgettype":"hbar","use_gradient":"1","limit":"5"}'),
(13, 1, 'bn_count_Printer_517684b0-b064-49dd-943e-fcb6f915e453', 'bn_count_Printer', 9, 2, 3, 2, '{"color":"#365a8f","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(14, 1, 'bn_count_Phone_f70c489f-02c1-46e5-978b-94a95b5038ee', 'bn_count_Phone', 9, 0, 3, 2, '{"color":"#d5e1ec","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(15, 1, 'bn_count_Change_ab950dbd-cd25-466d-8dff-7dcaca386564', 'bn_count_Change', 23, 7, 3, 2, '{"color":"#cae3c4","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(16, 1, 'bn_count_Group_b84a93f2-a26c-49d7-82a4-5446697cc5b0', 'bn_count_Group', 4, 8, 4, 2, '{"color":"#e0e0e0","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(17, 1, 'bn_count_Profile_770b35e8-68e9-4b4f-9e09-5a11058f069f', 'bn_count_Profile', 4, 10, 4, 2, '{"color":"#e0e0e0","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(18, 1, 'bn_count_Supplier_36ff9011-e4cf-4d89-b9ab-346b9857d734', 'bn_count_Supplier', 8, 8, 3, 2, '{"color":"#c9c9c9","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(19, 1, 'bn_count_KnowbaseItem_a3785a56-bed4-4a30-8387-f251f5365b3b', 'bn_count_KnowbaseItem', 8, 10, 3, 2, '{"color":"#c9c9c9","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(20, 1, 'bn_count_Entity_9b82951a-ba52-45cc-a2d3-1d238ec37adf', 'bn_count_Entity', 0, 10, 4, 2, '{"color":"#f9f9f9","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(21, 1, 'bn_count_Document_7dc7f4b8-61ff-4147-b994-5541bddd7b66', 'bn_count_Document', 11, 8, 3, 2, '{"color":"#b4b4b4","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(22, 1, 'bn_count_Project_4d412ee2-8b79-469b-995f-4c0a05ab849d', 'bn_count_Project', 11, 10, 3, 2, '{"color":"#b3b3b3","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(23, 1, 'bn_count_NetworkEquipment_c537e334-d584-43bc-b6de-b4a939143e89', 'bn_count_NetworkEquipment', 6, 0, 3, 2, '{"color":"#bfe7ea","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(24, 1, 'bn_count_User_ac0cbe52-3593-43c1-8ecc-0eb115de494d', 'bn_count_User', 0, 8, 4, 2, '{"color":"#fafafa","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(25, 1, 'count_Monitor_MonitorModel_5a476ff9-116e-4270-858b-c003c20841a9', 'count_Monitor_MonitorModel', 5, 4, 5, 4, '{"color":"#f5fafa","widgettype":"donut","use_gradient":"1","limit":"5"}'),
(26, 1, 'count_NetworkEquipment_State_81f2ae35-b366-4065-ac26-02ea4e3704a6', 'count_NetworkEquipment_State', 10, 4, 4, 4, '{"color":"#f5f3ef","widgettype":"donut","use_gradient":"1","limit":"5"}'),
(27, 2, 'bn_count_Computer_34cfbaf9-a471-4852-b48c-0dadea7644de', 'bn_count_Computer', 0, 0, 4, 3, '{"color":"#f3d0d0","widgettype":"bigNumber"}'),
(28, 2, 'bn_count_Software_60091467-2137-49f4-8834-f6602a482079', 'bn_count_Software', 4, 0, 4, 3, '{"color":"#d1f1a8","widgettype":"bigNumber"}'),
(29, 2, 'bn_count_Printer_c9a385d4-76a3-4971-ad0e-1470efeafacc', 'bn_count_Printer', 8, 3, 4, 3, '{"color":"#5da8d6","widgettype":"bigNumber"}'),
(30, 2, 'bn_count_PDU_60053eb6-8dda-4416-9a4b-afd51889bd09', 'bn_count_PDU', 12, 3, 4, 3, '{"color":"#ffb62f","widgettype":"bigNumber"}'),
(31, 2, 'bn_count_Rack_0fdc196f-20d2-4f63-9ddb-b75c165cc664', 'bn_count_Rack', 12, 0, 4, 3, '{"color":"#f7d79a","widgettype":"bigNumber"}'),
(32, 2, 'bn_count_Phone_c31fde2d-510a-4482-b17d-2f65b61eae08', 'bn_count_Phone', 16, 3, 4, 3, '{"color":"#a0cec2","widgettype":"bigNumber"}'),
(33, 2, 'bn_count_Enclosure_c21ce30a-58c3-456a-81ec-3c5f01527a8f', 'bn_count_Enclosure', 16, 0, 4, 3, '{"color":"#d7e8e4","widgettype":"bigNumber"}'),
(34, 2, 'bn_count_NetworkEquipment_76f1e239-777b-4552-b053-ae5c64190347', 'bn_count_NetworkEquipment', 8, 0, 4, 3, '{"color":"#c8dae4","widgettype":"bigNumber"}'),
(35, 2, 'bn_count_SoftwareLicense_576e58fe-a386-480f-b405-1c2315b8ab47', 'bn_count_SoftwareLicense', 4, 3, 4, 3, '{"color":"#9bc06b","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(36, 2, 'bn_count_Monitor_890e16d3-b121-48c6-9713-d9c239d9a970', 'bn_count_Monitor', 0, 3, 4, 3, '{"color":"#dc6f6f","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(37, 2, 'count_Computer_Manufacturer_986e92e8-32e8-4a6f-806f-6f5383acbb3f', 'count_Computer_Manufacturer', 4, 6, 4, 4, '{"color":"#f3f5f1","widgettype":"hbar","use_gradient":"1","limit":"5"}'),
(38, 2, 'count_Computer_State_290c5920-9eab-4db8-8753-46108e60f1d8', 'count_Computer_State', 0, 6, 4, 4, '{"color":"#fbf7f7","widgettype":"donut","use_gradient":"1","limit":"5"}'),
(39, 2, 'count_Computer_ComputerType_c58f9c7e-22d5-478b-8226-d2a752bcbb09', 'count_Computer_ComputerType', 8, 6, 4, 4, '{"color":"#f5f9fa","widgettype":"donut","use_gradient":"1","limit":"5"}'),
(40, 2, 'count_NetworkEquipment_Manufacturer_8132b21c-6f7f-4dc1-af54-bea794cb96e9', 'count_NetworkEquipment_Manufacturer', 12, 6, 4, 4, '{"color":"#fcf8ed","widgettype":"hbar","use_gradient":"0","limit":"5"}'),
(41, 2, 'count_Monitor_Manufacturer_43b0c16b-af82-418e-aac1-f32b39705c0d', 'count_Monitor_Manufacturer', 16, 6, 4, 4, '{"color":"#f9fbfb","widgettype":"donut","use_gradient":"1","limit":"5"}'),
(42, 3, 'bn_count_Ticket_344e761b-f7e8-4617-8c90-154b266b4d67', 'bn_count_Ticket', 0, 0, 3, 2, '{"color":"#ffdc64","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(43, 3, 'bn_count_Problem_bdb4002b-a674-4493-820f-af85bed44d2a', 'bn_count_Problem', 0, 4, 3, 2, '{"color":"#f0967b","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(44, 3, 'bn_count_Change_b9b87513-4f40-41e6-8621-f51f9a30fb19', 'bn_count_Change', 0, 6, 3, 2, '{"color":"#cae3c4","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(45, 3, 'bn_count_tickets_late_1e9ae481-21b4-4463-a830-dec1b68ec5e7', 'bn_count_tickets_late', 0, 2, 3, 2, '{"color":"#f8911f","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(46, 3, 'bn_count_tickets_incoming_336a36d9-67fe-4475-880e-447bd766b8fe', 'bn_count_tickets_incoming', 3, 6, 3, 2, '{"color":"#a0e19d","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(47, 3, 'bn_count_tickets_closed_e004bab5-f2b6-4060-a401-a2a8b9885245', 'bn_count_tickets_closed', 9, 8, 3, 2, '{"color":"#515151","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(48, 3, 'bn_count_tickets_assigned_7455c855-6df8-4514-a3d9-8b0fce52bd63', 'bn_count_tickets_assigned', 6, 6, 3, 2, '{"color":"#eaf5f7","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(49, 3, 'bn_count_tickets_solved_5e9759b3-ee7e-4a14-b68f-1ac024ef55ee', 'bn_count_tickets_solved', 9, 6, 3, 2, '{"color":"#d8d8d8","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(50, 3, 'bn_count_tickets_waiting_102b2c2a-6ac6-4d73-ba47-8b09382fe00e', 'bn_count_tickets_waiting', 3, 8, 3, 2, '{"color":"#ffcb7d","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(51, 3, 'bn_count_TicketRecurrent_13f79539-61f6-45f7-8dde-045706e652f2', 'bn_count_TicketRecurrent', 0, 8, 3, 2, '{"color":"#fafafa","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(52, 3, 'bn_count_tickets_planned_267bf627-9d5e-4b6c-b53d-b8623d793ccf', 'bn_count_tickets_planned', 6, 8, 3, 2, '{"color":"#6298d5","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(53, 3, 'top_ticket_ITILCategory_0cba0c84-6c62-4cd8-8564-18614498d8e4', 'top_ticket_ITILCategory', 12, 6, 4, 4, '{"color":"#f1f5ef","widgettype":"donut","use_gradient":"1","limit":"7"}'),
(54, 3, 'top_ticket_RequestType_b9e43f34-8e94-4a6e-9023-c5d1e2ce7859', 'top_ticket_RequestType', 16, 6, 4, 4, '{"color":"#f9fafb","widgettype":"hbar","use_gradient":"1","limit":"4"}'),
(55, 3, 'top_ticket_Entity_a8e65812-519c-488e-9892-9adbe22fbd5c', 'top_ticket_Entity', 20, 6, 4, 4, '{"color":"#f7f1f0","widgettype":"donut","use_gradient":"1","limit":"7"}'),
(56, 3, 'ticket_evolution_76fd4926-ee5e-48db-b6d6-e2947c190c5e', 'ticket_evolution', 3, 0, 12, 6, '{"color":"#f3f7f8","widgettype":"areas","use_gradient":"0","limit":"12"}'),
(57, 3, 'ticket_status_5b256a35-b36b-4db5-ba11-ea7c125f126e', 'ticket_status', 15, 0, 11, 6, '{"color":"#f7f3f2","widgettype":"stackedbars","use_gradient":"0","limit":"12"}'),
(58, 4, 'bn_count_tickets_closed_ccf7246b-645a-40d2-8206-fa33c769e3f5', 'bn_count_tickets_closed', 24, 0, 4, 2, '{"color":"#fafafa","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(59, 4, 'bn_count_Ticket_d5bf3576-5033-40fb-bbdb-292294a7698e', 'bn_count_Ticket', 0, 0, 4, 2, '{"color":"#ffd957","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(60, 4, 'bn_count_tickets_incoming_055e813c-b0ce-4687-91ef-559249e8ddd8', 'bn_count_tickets_incoming', 4, 0, 4, 2, '{"color":"#6fd169","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(61, 4, 'bn_count_tickets_waiting_793c665b-b620-4b3a-a5a8-cf502defc008', 'bn_count_tickets_waiting', 8, 0, 4, 2, '{"color":"#ffcb7d","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(62, 4, 'bn_count_tickets_assigned_d3d2f697-52b4-435e-9030-a760dd649085', 'bn_count_tickets_assigned', 12, 0, 4, 2, '{"color":"#eaf4f7","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(63, 4, 'bn_count_tickets_planned_0c7f3569-c23b-4ee3-8e85-279229b23e70', 'bn_count_tickets_planned', 16, 0, 4, 2, '{"color":"#6298d5","widgettype":"bigNumber","use_gradient":"0","limit":"7"}'),
(64, 4, 'bn_count_tickets_solved_ae2406cf-e8e8-410b-b355-46e3f5705ee8', 'bn_count_tickets_solved', 20, 0, 4, 2, '{"color":"#d7d7d7","widgettype":"bigNumber","use_gradient":"0","limit":"7"}');
-- --------------------------------------------------------
--
-- Table structure for table `glpi_dashboards_rights`
--
CREATE TABLE `glpi_dashboards_rights` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dashboards_dashboards_id` int(10) unsigned NOT NULL,
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`items_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`dashboards_dashboards_id`,`itemtype`,`items_id`),
KEY `item` (`itemtype`,`items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_databaseinstancecategories`
--
CREATE TABLE `glpi_databaseinstancecategories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_databaseinstances`
--
CREATE TABLE `glpi_databaseinstances` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`port` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`size` int(11) NOT NULL DEFAULT '0',
`databaseinstancetypes_id` int(10) unsigned NOT NULL DEFAULT '0',
`databaseinstancecategories_id` int(10) unsigned NOT NULL DEFAULT '0',
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`manufacturers_id` int(10) unsigned NOT NULL DEFAULT '0',
`users_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`groups_id_tech` int(10) unsigned NOT NULL DEFAULT '0',
`states_id` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`items_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_onbackup` tinyint(4) NOT NULL DEFAULT '0',
`is_active` tinyint(4) NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_helpdesk_visible` tinyint(4) NOT NULL DEFAULT '1',
`is_dynamic` tinyint(4) NOT NULL DEFAULT '0',
`autoupdatesystems_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_creation` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_lastboot` timestamp NULL DEFAULT NULL,
`date_lastbackup` timestamp NULL DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `name` (`name`),
KEY `databaseinstancetypes_id` (`databaseinstancetypes_id`),
KEY `databaseinstancecategories_id` (`databaseinstancecategories_id`),
KEY `locations_id` (`locations_id`),
KEY `manufacturers_id` (`manufacturers_id`),
KEY `users_id_tech` (`users_id_tech`),
KEY `groups_id_tech` (`groups_id_tech`),
KEY `states_id` (`states_id`),
KEY `item` (`itemtype`,`items_id`),
KEY `is_active` (`is_active`),
KEY `is_deleted` (`is_deleted`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`),
KEY `is_helpdesk_visible` (`is_helpdesk_visible`),
KEY `is_dynamic` (`is_dynamic`),
KEY `autoupdatesystems_id` (`autoupdatesystems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_databaseinstancetypes`
--
CREATE TABLE `glpi_databaseinstancetypes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` text COLLATE utf8mb4_unicode_ci,
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_databases`
--
CREATE TABLE `glpi_databases` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`size` int(11) NOT NULL DEFAULT '0',
`databaseinstances_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_onbackup` tinyint(4) NOT NULL DEFAULT '0',
`is_active` tinyint(4) NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`is_dynamic` tinyint(4) NOT NULL DEFAULT '0',
`date_creation` timestamp NULL DEFAULT NULL,
`date_mod` timestamp NULL DEFAULT NULL,
`date_update` timestamp NULL DEFAULT NULL,
`date_lastbackup` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `name` (`name`),
KEY `is_active` (`is_active`),
KEY `is_deleted` (`is_deleted`),
KEY `is_dynamic` (`is_dynamic`),
KEY `date_creation` (`date_creation`),
KEY `date_mod` (`date_mod`),
KEY `databaseinstances_id` (`databaseinstances_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `glpi_datacenters`
--
CREATE TABLE `glpi_datacenters` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entities_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_recursive` tinyint(4) NOT NULL DEFAULT '0',
`locations_id` int(10) unsigned NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`date_mod` timestamp NULL DEFAULT NULL,
`date_creation` timestamp NULL DEFAULT NULL,
`pictures` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `is_recursive` (`is_recursive`),
KEY `locations_id` (`locations_id`),
KEY `is_deleted` (`is_deleted`),
KEY `date_mod` (`date_mod`),
KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unico