| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/MySQL/Connector.NET 6.9/Assemblies/v4.0/ |
Upload File : |
MZ� �� � @ � � � �!�L�!This program cannot be run in DOS mode.
$ PE L 2"dW � " 0 r" @ � � @� " O @ < ` � H .text x `.rsrc < @ @ @.reloc ` @ B T" H $� �6 �� �D h � { *>{ o
�*�(
(
, r ps
zs
} * 0 : { o
.+, (
{ o
�,o
�{ o
*
$
f{ o
, { o!
* { * 0 � ("
- (m s#
zr# po$
%
(
, (m s#
z(%
o&
o'
} } rM po$
, rM po$
o(
r� p()
} { (/ *0 � {
(*
{ ,
{ �p r� p { s
o
s+
o,
r" po-
r( po-
r4 po-
rL po-
rT po-
r` po-
8� ( +
( +( + ( +
( + ( + (.
s/
{ o0
,{ o1
o2
+o3
-} o4
:U���� ,o
��"rr p( � o
_, o!
�{ �
,(5
�* Ad L R 8 ( ` 8 9 q � �
�o6
,� *o7
� � * 0 " (
,*(8
{ o9
&* 0 k ( ,Vs:
{ o;
{ o<
r� p r p(=
r po>
(=
o?
�
,o
�{ s@
z FT
Z{ -oA
&{ *�s
} sB
} r. p} rH p} r` p} (C
* { *"} * { *"} *2{ {? *6{ }? *2{ o *0 k ( ,Vs:
{ o;
{
o<
r� p r p(=
r po>
(=
o?
�
,o
�{ s@
z FT
0 � - r� ps#
z,oD
- r� ps#
zr� po$
(
,r� poE
r� pr� poF
(G
(H
r< po$
(
- r< po$
(H
(I
oJ
r\ poK
oL
rr poM
t! } (%
r# po$
o&
} { , { o'
oN
r� p()
, r� psO
z{ o'
}
} rM po$
, rM po$
o(
r� p()
} } r� po$
, r� po$
o(
r� p()
} {
(/ (P
s
} {
s
o
{ o &() �
,o
��
r� p( � {
s
r ps+
%oQ
r p( �x oR
&o
oS
&( (( } � ,o
��r� p( � { 0} �' sT
{ � Z <ZsU
} * 4 � �
�4� �K/ �f= JsV
(W
sX
* 0 � {
s
r# ps+
%oQ
r� poR
&%oQ
r p( �x oR
&%oQ
r� p�m oR
&%oQ
r� p�m oR
&%oQ
r� p�m oR
&%oQ
r� poR
&%oQ
r� p�m oR
&o
oS
&�
,o
�� r� p( � * ��
�� R{ , { oY
**F(" *F(" * 0 � {
s
r(
ps+
%oQ
r� p{ oZ
([
� oR
&%oQ
r� poR
&%oQ
r p( �x oR
&%oQ
r� poR
&o
oS
&�
,o
�� r} p( � * ��
�� 0 � {
s
r� ps+
%oQ
r� poR
&%oQ
r p( �x oR
&%oQ
r� poR
&o
oS
�
�
,o
�,{ ,{ o\
� r� po]
(^
( � * \h
�� 0 � {
s
r� ps+
%oQ
r� p{ oZ
([
� oR
&%oQ
r� poR
&%oQ
r p( �x oR
&o
oS
&�
,o
�� r�
p( � * p|
�� 0 �
{
s
o_
t+ ($ 9� r# ps+
oQ
r� poR
&oQ
r p( �x oR
&oQ
r� po`
�m oR
&oQ
r� p�m oR
&oQ
r� p�m oR
&oQ
r� poR
&oQ
r� p�m oR
&8� r�
ps+
oQ
r� po`
�m oR
&oQ
r� poR
&oQ
r� p�m oR
&oQ
r� poR
&oQ
r p( �x oR
&oQ
r� poR
&o
oS
&�
,o
��
r� p( � *A4 l x
� � 0 J
~a
�' QRT
{
s
o
,Kr� ps+
%oQ
r� poR
&%oQ
r p( �x oR
&oS
-R+Rr ps+
%oQ
r� poR
&%oQ
r p( �x oR
&o,
o4
9� ob
ob
(c
1R+ o7
u� - t + o7
QPu� , �m Qod
Tod
ob
(e
�' - of
R� ,o
�-R9� G:� P�m X�m Qr\ ps+
%oQ
r� pPoR
&%oQ
r� poR
&%oQ
r p( �x oR
&oS
&J3 { oZ
([
iog
+
(%
� ,o
�� rS p( � * AL � � q - � ) 7 N{ , } **0 " sh
%si
,oj
ok
ol
* 0 4
sV
, sm
on
j1 so
(p
(W
sX
*0 (
sV
, sm
on
j1 so
(p
*0 �
(*
{ ,ݘ } �
,(5
� {
s
o
r{ ps+
%oQ
r p( �x oR
&oS
1(* �
,o
��/
r� p( �
(*
} �
,(5
��* @ "
9 =v
- U� � �
- d� �r� ps+
%oQ
r p�x oR
&oq
�m * 0 � rq ps+
o,
o4
,Uor
r p()
,Br& p s:
{ o;
{
o<
o?
�
,o
�� &(s
� �
,o
��
r� p (t
(u
� *4 8 !Y
2 3e . _p
|| Z{ ,(, *(+ * 0 a {
s
o
r ps+
%oQ
r p( �x oR
&oS
&�
,o
�� r� p(t
(u
�* 5A
MM / 0 - {
s
o
r0 ps+
%oQ
r p( �x oR
&o,
8� or
o7
u� - t +(& sv
sX
{ ,{ o\
{
s
r ps+
%oQ
r� poR
&%oQ
r p( �x oR
&o
oS
&� ,o
��r� p(t
(u
�o4
:.����,o
�,o
�* Ad � I � | z � / ? �
"
�rD p} rH p}
r` p} (w
*
* 0 M (1
(. 3* rr po$
r� p(x
- (0 + (J sy
z�
(J s@
z* .?
/ 0 � r� p� (z
o{
s|
(. 3*s
o
X +br� p�m (}
o~
s
o�
o�
&�-o�
3 3r� po�
o�
&�zX (. 1��
,o
�* ]
g - * x�
0 � s
o
rN ps+
oq
, �m
�n�^o�
z .��d r� p�r� po�
o�
o�
3 o�
o�
r� po�
(�
��
�
,o
� * . ^ ��
0 � r� ps+
oQ
r� p�x oR
&oQ
r� poR
&oq
,�m j*r� po�
oQ
rt p��� oR
&oS
. (o sy
zr� po�
oq
(�
* (
*�~ - r� p� (z
o{
s|
� ~ *~ * � *V(4 r� p~ o�
*V(4 r� p~ o�
*V(4 r& p~ o�
*V(4 rV p~ o�
*V(4 r� p~ o�
*V(4 r� p~ o�
*V(4 r� p~ o�
*V(4 r p~ o�
*V(4 r> p~ o�
*V(4 rn p~ o�
*V(4 r� p~ o�
*V(4 r� p~ o�
*V(4 r! p~ o�
*V(4 r6! p~ o�
*V(4 rV! p~ o�
*V(4 r�! p~ o�
*V(4 r�! p~ o�
*V(4 r�! p~ o�
*V(4 r" p~ o�
*V(4 r" p~ o�
*V(4 rD" p~ o�
*V(4 rr" p~ o�
*V(4 r�" p~ o�
*V(4 r�" p~ o�
*V(4 r # p~ o�
*V(4 r,# p~ o�
*V(4 r^# p~ o�
*V(4 r�# p~ o�
*V(4 r�# p~ o�
*V(4 r�# p~ o�
*V(4 r"$ p~ o�
*V(4 r^$ p~ o�
*V(4 r�$ p~ o�
*V(4 r�$ p~ o�
*V(4 r�$ p~ o�
*V(4 r"% p~ o�
*V(4 rF% p~ o�
*V(4 rZ% p~ o�
*V(4 r�% p~ o�
*V(4 r�% p~ o�
*V(4 r�% p~ o�
*V(4 r�% p~ o�
*V(4 r�% p~ o�
*V(4 r�% p~ o�
*V(4 r
& p~ o�
*V(4 r& p~ o�
*V(4 r*& p~ o�
*V(4 r:& p~ o�
*V(4 rJ& p~ o�
*V(4 rZ& p~ o�
*V(4 rj& p~ o�
*V(4 r|& p~ o�
*V(4 r�& p~ o�
*V(4 r ' p~ o�
*V(4 r:' p~ o�
*V(4 rx' p~ o�
*V(4 r�' p~ o�
*V(4 r�' p~ o�
*V(4 r�' p~ o�
*V(4 r2( p~ o�
*V(4 rh( p~ o�
*V(4 r�( p~ o�
*V(4 r�( p~ o�
*V(4 r�( p~ o�
*V(4 r) p~ o�
*V(4 rB) p~ o�
*V(4 rb) p~ o�
*V(4 r�) p~ o�
*V(4 r�) p~ o�
*V(4 r�) p~ o�
*V(4 r�) p~ o�
*V(4 r** p~ o�
*V(4 rN* p~ o�
*0 � - r� ps
z,oD
-r�* pr� po$
(
,r� poE
r� pr�* po�
(G
r< po$
(H
(�
r� p} (%
r# po$
o&
,o'
oN
} { (
,�-{ (/ (P
s
} �
(@ s@
z* U z�
/ 0 L { s
o
r�* ps+
oQ
r� p{ o �x oR
&oQ
r�+ p�* oR
&-%o�
r, p(^
o�
+3%o�
rC, p(^
o�
rm, ps+
oQ
r�, p � o�
&s�
o,
+ r�, po�
o�
o4
-�� ,o
� o�
+,(�
oQ
o�
�� o�
oS
X(�
-��� o
��
,o
�*AL � � � 9 + 3 ?
0 � { s
o
r�, ps+
oQ
r� p{ o �x oR
&oQ
r� p � o�
&rm, ps+
oQ
r�, po�
&
+N�oQ
o�
o�
oq
�m oQ
o�
�m o�
oS
X
X�i2� �
,o
�* ��
0 V o�
�d
o�
+o�
t?
%X o�
�o�
-��u ,o
�o�
* %: B(� *N~�
(� *>(� *J~�
(� *0 � { s
o
r�- ps+
oQ
r� p{ o �x oR
&oQ
r�+ p�* oR
&-%o�
r, p(^
o�
+3%o�
rC, p(^
o�
oq
�m �
,o
�* ��
2{ {? *6{ }? * 0 O s�
o�
/*r�. po�
td o�
+Lo�
tC
o�
o�
- o�
�d (z
(�
, o�
+ o�
s�
o�
o�
-��u ,o
�(
,* { s
o
r�. ps+
%oQ
r� p{ o �x oR
&%oQ
r� poR
&s�
s�
o�
&o�
o�
1o�
o�
(� �,o
�(q s@
z* ( ) X� � �1 � �=/ 0 6 rL0 po�
��
r�. po�
td (
,*o�
/*~�
~�
(� /*{ s
o
o�
{ o (2 rl0 ps+
%oQ
o�
%oQ
r�, p�x oR
&%oQ
r�2 poR
&%oQ
r�2 p oR
&%oQ
r�2 poR
&oS
- (Y s�
zo�
�&,o�
(Y s@
z,o
�* f �/ f �) �r�2 ps+
%oQ
r�, p�m oR
&oS
&* 0 rE3 po�
td
r[3 po�
td rq3 po�
t -*�� % :�o�
8� ��� % /�o�
�o�
9� �(�
(�
�(�
(�
3o�
o�
o�
+B�r�3 po�
,o�
o�
+ �� (�
o�
X �i?F���*0 �
o�
+Ao�
tF o�
,*o�
o�
r�3 po�
�� o�
,,
� o�
-��u ,o
�-*s�
s�
sh
o�
8 o�
tF o�
, o�
9� o�
o�
r�3 po�
�� o�
,9� Xo�
o�
, o�
, o�
-r�3 po�
o�
&8� ud ,:r�3 po�
o�
�m ud oD
�m o�
& o�
&+= t
r�3 po�
o�
�x
�i�m o�
&
�io�
o�
:���u ,o
�o>
Qo>
Q ol
Q* A4
N X � ! � 0 � s�
&{ s
o
r�3 ps+
oQ
r� p{ o �x oR
&,(%o�
r26 p(^
o�
oQ
rh6 poR
&~�
(�
,-%o�
r|6 p(^
o�
oQ
r�+ p�* oR
&-%o�
r�6 p(^
o�
+3%o�
r7 p(^
o�
%o�
r07 pZ�m �m (�
(^
o�
s�
o,
+F r� po�
rN7 po�
rf7 po�
r�7 po�
r�7 po�
s�
o�
o4
-��
, o
�r�7 po�
oq
(�
T�
,o
�*A4 R k
� �
2(
,** (�
*2{" {? *6{" }? *2{" o * 0 ] - r� ps
z(
,r�7 pr� po$
(
,r� poE
r� pr"8 po�
(G
(H
r< po$
(
- r< po$
rM po$
,#rM po$
o(
r� p()
,}! (%
r# po$
o&
} { ,{ o'
oN
} + r� p} { (
,*{ (/ (P
s
}" { s
o
{" o &�
,o
�� {! , r`8 p(� �* $9
-E/ 0 � ! - r�8 ps
z/ r�8 ps�
z/ r�8 ps�
zo�
- r�8 ps
zo�
- r
9 ps
zo�
-#o�
oN
o�
oN
(� *o�
oN
(� * 0 A - r�8 ps
z- o�
oN
o�
o�
(� *o�
oN
(� * 0 p " QQ{ s
o (� (� Q(
-(� (�
(� Qo � {! , r.9 p(� �o �* 6Q / Mh 0 ^ " { s
o (
,(� (� +(� (�
(� � {! , r�9 p(� �o �* ,? / CV 0 � # ,��+
,��+ { s
o 3E-(� (� �l(� (� �[{! ,
r: p(� � o �--(� (� +#-~�
(� +~�
(� ** 1 %V / 1 >o 0 A $ (
,*, �d %�+
(� � {! , rb: p(� �*
( / 0 h " { s
s�
&o (
-(� (�
(� &+(� (�
(� &� {! , r�: p(� �* DP / 0 % { s
s�
o (� o�
~�
(� Ts�
o,
8� r,; po�
o6
- ob
(�
+~�
o6
-
r6; po�
+ o6
-
rX; po�
+ o6
-
rv; po�
+s�
o�
o4
:i����
, o
�o �
{! ,
r�; p(� �o � * AL G � �
� � / 0 � & { s
s�
o (� o�
(� Ts�
o,
+a r,; po�
r�; po�
(�
& r< po�
r� po�
r< po�
(�
s�
o�
o4
-��
, o
�o � {! ,
r4< p(� �o �* ( E m�
�� / �� 0 V ' { s
s�
&o o�
(� ~�
(� � {! , r�< p(� �o �* *6 / AM 0 R ' { s
s�
&o o�
(� (� � {! , r�< p(� �o �* &2 / =I 0 w ' { s
o -(� (�
(� �G3(� (� �1(� (� � {! , rb: p(� �o �* DW / [n 0 � s:
{ o;
{ o<
{ (�
(�
(=
�d %�%r p�%�%(�
�%(�
�(�
r p(�
o?
�
,o
�* pv
�rZ= p} rH p} r` p} (�
* 0 ( r�= po - r�> ps�
zo s+
oS
&r�> po�
o o�
oS
&Z YX 9� r? p
o�
oQ
r p�x oR
&oQ
r�E poR
&o o�
oS
&r�E po�
o o�
oq
�m rHF p
P o�
Po o�
PoQ
r�O p�m oR
& PoQ
r P p�m oR
&*r+P po�
oQ
r p�x oR
&oQ
r�E poR
&oQ
rU poR
&oQ
rU p�* oR
&o o�
oS
&r<U po�
o o�
oq
o>
r�U p Po�
PoQ
r P p�m oR
& PoQ
r�O p�m oR
& Po o�
(�
*0 � j0*o - r�> ps�
z,Wr�Z po s+
%oQ
r p�x oR
&%oQ
r�E poR
&%o o�
oq
o>
(�
*r�\ po s+
%oQ
r p�x oR
&%oQ
r�E poR
&%oQ
rU poR
&%oQ
rU p�* oR
&%o o�
oq
o>
(�
* 0 � ) j0*o - r�> ps�
zr` po s+
%o o�
%oQ
r p�x oR
&%oQ
r�E poR
&oq
%-&r� po>
(
,*r�` po s+
%o o�
%oQ
r p�x oR
&%oQ
rU poR
&oq
%-&r� po>
(
-+r�3 p (�
-*o (�
(� &r�a ps�
%o o�
%oQ
r�b poR
&%oQ
r�b poR
&o,
+%jo�
i��
j o�
&o4
-�o�
*0 � * j0*o - r�> ps�
zr�b po s+
oQ
r p�x oR
&oQ
r�E poR
&oq
td (
-ir�c po�
oQ
r�b poR
&o o�
o,
+%jo�
i��
j o�
&o4
-�o�
** 0 + j0*o - r�> ps�
zr�b po s+
%oQ
r p�x oR
&%oQ
r�E poR
&oq
td
(
:� rJd po s+
%o o�
%oQ
r p�x oR
&%oQ
rU poR
&oq
�m ,Vo (� ,Fr�d ps�
%o o�
%oQ
r�b poR
&%oQ
r�b p�m oR
&oS
&* 0 � j0*o - r�> ps�
zr�b po s+
%oQ
r p�x oR
&%oQ
r�E poR
&oq
%-&r� po>
(
-.r�e ps�
%o o�
%oQ
r�b poR
&oS
&* 0 f , o�
r�f ps�
%o�
%o�
%oQ
r&g p�* oR
&%oQ
r�b p�m oR
&oS
o�
� &o�
�* T[ 0 > - j0*o - r�> ps�
z
s�
-�d %r� p�-�d %r� p�
8� �8� �rFg p(
-r�i p(^
%+(
-r=j p(^
%+o�
oQ
r p�x oR
&oQ
rU p�* oR
&oQ
r�E poR
&oQ
rU poR
&o o�
oS
X
X�i?3��� X
�i?���* 0 | . j0*o - r�> ps�
zs�
o o�
,$r�j po�
oQ
r p�x oR
&+"r�k po�
oQ
r p�x oR
&oS
*0 � / j0*o - r�> ps�
z-*s�
o o�
+G �r#m po�
oQ
r p�x oR
&oQ
r�E poR
&oS
X X
�i2�*0 e . j0*o - r�> ps�
zs�
o o�
,
r*o po�
+ rep po�
oQ
r p�x oR
&oS
* 0 � 0 j0*o - r�> ps�
zs�
o o�
r�q po�
oQ
r p�x oR
&oQ
r�E poR
&oq
td oQ
o�
:� o o�
o�
rgr po�
oQ
r p�x oR
&oQ
r�b p(�
�N o>
% oR
&oQ
r�E poR
&oS
&o�
�
&o�
�oQ
o�
rbs po�
oQ
r p�x oR
&oQ
rU poR
&oq
%-&r� po>
(
-+r�3 p (�
:� o o�
oQ
o�
o�
r#t po�
oQ
r p�x oR
&oQ
rU poR
&oQ
r&g p(�
�* oR
&oS
&o�
�
&o�
�oQ
o�
r<u po�
oQ
r p�x oR
&oQ
rU poR
&oq
td o (�
(�
(�
- r�u ps�
zoQ
o�
rv po�
oQ
r�b poR
&oQ
r�b poR
&oq
�x j1soQ
o�
r�v po�
oQ
r�b poR
&oQ
r�b poR
&oQ
rx poR
&oQ
r&g p(�
�* oR
&oS
&8� oQ
o�
r!x po�
oQ
r�y p�x oR
&oQ
r�b poR
&oQ
r�b poR
&oQ
rx poR
&oQ
r�y p(�
�* oR
&oS
* � s
�r�
0 s 1 j0*o - r�> ps�
zs�
o o�
r�q po�
oQ
r p�x oR
&oQ
r�E poR
&oq
td oQ
o�
:� o o�
o�
rgr po�
oQ
r p�x oR
&oQ
r�b p(�
�N o>
% oR
&oQ
r�E poR
&oS
&o�
� &o�
�r�y po�
%o�
r�z p(^
o�
oQ
o�
oQ
rx poR
&oQ
r�b poR
&oQ
r&g p�* oR
&oS
* � p� :(�
(� *:(�
(� * 0 j 2 r�{ pr | p(�
- r$| ps�
zo>
(� o>
oD
Yo�
r�| p~�
�� (�
(�
,(� * 0 ] 3 �d %r�| p�%r�| p�
+;� (^
r�| p (}
(�
,,
(� +(� X �i2�* 0 � 4 r�| p(}
(�
-*s�
%o�
o�
s�
o�
(� (� (� (� (� (� s�
o�
o�
o
o
* 0 � 5 r} pr� po
tV
r� pr } po
r pr� po
r.} po
o
o
o
+/ o�
tW o
r� po
o
r } p()
, � o�
-�� u ,o
�-o
&* W ;� 0 � 6 r} pr� po
tV
r� prR} po
(
r�} po
r�} pr�} po
r ~ p~�
o
(}
r~ po
r# pr } po
r~ prH~ po
rT~ pr� po
r|~ pr� po
r< pr�~ po
r�~ prH~ po
r�~ pr�~ po
r pr< po
r@ prt po
rx pr� po
r� pr� po
r� pr� po
r<� po
o
o
o
o
+<o�
tW o
r~ po
o
rR� po
, o
&� o�
-��u ,o
� o
&* LI� 0 6 r} pr� po
tV
r� pr�� po
(
r̀ po
r�} pr�} po
r ~ p~�
o
(}
r~ po
r# pr } po
r< pr�~ po
r � po
o
o
o
o
+<o�
tW o
r~ po
o
r8� po
, o
&� o�
-��u ,o
� o
&* � I� 0 6 r} pr� po
tV
r� pr�* po
(
r�� po
r�} pr�} po
r ~ p~�
o
(}
r~ po
r# pr } po
r< pr�~ po
rځ po
o
o
o
o
+<o�
tW o
r~ po
o
r� po
, o
&� o�
-��u ,o
� o
&* � I� 0 � 7 r} pr� po
tV
r� pr8� po
(
rb� po
r�} pr�} po
r ~ p~�
o
(}
r~ po
r# pr } po
r< pr�~ po
r�� po
, o
-1r\ po
r�� pr� po
tV o
o
& o
o
o
-'rʂ pr� po
tV o
o
& o
o
o
o
+=o�
tW o
r~ po
o
rނ po
, o
&� o�
-��u , o
�o
&* &Jp 0 � 8 r,� po
o
-*r,� pr� po
r\ po
o
o
&o
o
- r>� pr� po
o
&o
o
o
- o
rʂ pr� po
o
&r} pr� po
tV r� prZ= po
(
r^� po
r�} pr�} po
r ~ p~�
o
(}
r~ p o
r# pr } po
r< pr�~ po
o
o
,vo
,mo
o
+=o�
tW o
r~ po
o
rփ po
, o
&� o�
-��u ,o
�o
&* GJ� 0 j 2 r�{ pr | p(�
- r$| ps�
zo>
(� o>
oD
Yo�
r�| p~�
�� (�
(�
,(� * 0 � 4 r�| p(}
(�
-*s�
%o�
o�
s�
o�
(� (� (� (� (� (� s�
o�
o�
o
o
* 0 � 9 r.} po
o
-*o
o
o
+7o�
tW
o
r� po
o
r } p()
,
o
&� o�
-��u ,o
�* ) Cl 0 � 9 r<� po
o
-*o
o
o
o
+7o�
tW
o
r� po
o
rR} p()
,
o
&� o�
-��u ,o
�* . Cq 0 � 9 r � po
o
-*o
o
o
o
+7o�
tW
o
r� po
o
r�� p()
,
o
&� o�
-��u ,o
�* . Cq 0 � 9 rځ po
o
-*o
o
o
o
+7o�
tW
o
r� po
o
r�* p()
,
o
&� o�
-��u ,o
�* . Cq 0 � 9 r�� po
o
,o
o
-*o
o
o
o
+8o�
tW
o
r� po
o
r8� p(
-
o
&� o�
-��u ,o
�o
o
--o
o
o
3o
o
o
o
&* < D� 0 � 9 r>� po
o
,o
o
-*o
o
o
o
+7o�
tW
o
r� po
o
rZ= p()
,
o
&� o�
-��u ,o
�o
o
-Po
o
o
3<o
o
o
o
3#o
o
o
o
o
o
&* < C (
*0 � : - r� ps
z,oD
-rR} pr� po$
(
,r� poE
r� prD� po�
(G
r< po$
(H
(�
r po$
r< p(� (8
}. r� po$
r� p(� (8
}/ rx po$
r� p(� (8
}1 r@ po$
rt p(� (8
}( r� po$
r� p(� (
}2 rT~ po$
rx� p(� (
}* r~ po$
r�� p(� (
}+ r|~ po$
r�� p(� (
}, r�~ po$
rx� p(� (
}- rM po$
rx� p(� (
}) r�~ po$
-r�� p +o
r�� p()
, }0 +7r�� p()
, }0 +!r�� p()
, }0 + r�� psy
zo
3o
, (8 sy
z(%
r# po$
o&
,o'
oN
}' + r� p}' {' (
,*{' (/ (P
s
}3 *2{3 {? * 0 I ;
(*
o
{3 {? o
()
,� ~�
s
}3 �
,(5
�* :>
{* * {+ * {, * {- * {. * {/ * {0 * {1 * {( * {2 * {) *"}) * 0 < o
-*s
o
o
,o
,o
z(: sy
zr�� p(� -* {' s
o
(� (� r� ps+
%oQ
rm� p (� oR
&%oQ
ry� p(
�* oR
&%oQ
r�, p�m oR
&oS
��/,o
�(� ,
r�� p(� {& s@
z* \ ��
P �� % 0 � = o
-* {' s
o
(�
(� rɆ ps+
%oQ
r(� poR
&%oQ
rL� p(� oR
&%oQ
r�, p �m oR
&oS
��/,o
�(� ,
rl� p(� {& s@
z* v�
�� % 0 � > (� s
o
o
,T*o!
,o"
(
- T*(� r�� p(� -T*o#
, T*(� (
{' s
o
o�
{3 o (2 r�� ps+
%oQ
r�, p�x oR
&%oQ
rW� poR
&%oQ
re� pr� poR
&%oQ
rw� po
(� oR
&%oQ
r�� poR
&%oQ
r�� po
�[ oR
&%oQ
r(� poR
&%oQ
rL� po
(� oR
&%oQ
rō p�� oR
&%oQ
r�+ p�* oR
&%oQ
rݍ p�* oR
&%oQ
ry� p�* oR
&%oQ
r�� p�* oR
&%oQ
r� p�� oR
&%oQ
r1� p�* oR
&%oQ
rW� p�m oR
&%oQ
r�� p�* oR
&%oQ
rӎ p�m oR
&%oQ
r� p�* oR
&oS
1T+ T o�
�6(� ,
rg� p(� T , o�
�,o
�o#
** A4 � � * � 5 � 0 � ? {' s
o
(� 3 ݠ ,( (� r}� p-r� p+r�� p(}
s+
%oQ
r� p{3 o �x oR
&%oQ
r�, p�m oR
&oS
� �,,o
�
(� , r�� p(� {& s@
z* ��
�� " 2(� * 0 � @ ($
(%
(
(&
{' s
o
r�� p s+
%oQ
r� p�* oR
&%oQ
r� p{3 o �x oR
&oq
(�
�/ , o
�(� ,
r � p(� {& s@
z* ) X�
n� % 0 I A o
- (W sy
z {' s
o
(� 3 rM� psy
zru� ps+
%oQ
r�, p�m oR
& o'
o4
&r�� po�
, (x s(
zr�� po�
r�� po-
o7
o>
rܓ po�
od
o�
o)
,'(� -r�� p(� (E s(
zo
3
(�
�9,o
�,o
�(� ,
r� p(� {& s@
z* AL g �
�
! % 0 e B
{' s
o
(�
3 �>�
,o
��m o*
�"
(� , r � p(� {& s@
z* '
AA " 0 � C
{' s
o
o�
r� ps+
oQ
r�, poR
&,?r>� po�
oQ
r� p(
�* oR
&oS
&rɔ po�
oS
&rb� po�
o,
o4
-�X(�
� ,o
�o�
�6,o
�,o�
(� ,
r�� p(� {& sy
z* ( � � ��
�� , 0 � ? {' s
o
(� 3 �tr�� ps+
%oQ
r�� p(
�* oR
&%oQ
r�, p�m oR
&oS
� �,,o
�
(� , r� p(� {& s@
z* _k
uu " 0 � D {' s
o
r$� ps+
%oQ
rW� poR
&%oQ
r� p{3 o �x oR
&oq
td �+,o
� (� , r�� p(� {& sy
z* R^
hh ! 0 E o+
- (V s,
z {' s
o
(� 3 (z sy
z- o)
,r�� p(� (T sy
z{# o-
(.
s
o
o
, o
, o
z(U s(
zr�� ps+
oQ
r�, p�m oR
&~�
o'
o4
&r�� po�
, (x s(
zr�� po-
o7
rܓ po�
r� po/
o�
o)
,,td (� -r�� p(� (E s(
z� ,o
�r � po�
oQ
rm� p(� oR
&oQ
rU� p(
�* oR
&oS
. (A s(
z �/,o
�
(� ,
ru� p(� {&
s@
z * AL � � j � �
� � % 0 + F {' s
o
o0
(� 3 (z sy
zr�� ps+
%oQ
r�� po1
oR
&%oQ
r�� po2
oR
&%oQ
rō po3
�� oR
&%oQ
rݍ po4
�* oR
&%oQ
r�+ po5
�* oR
&%oQ
r� po0
oR
&%oQ
r� p{3 o �x oR
&oS
&�
,o
��! (� , r p(� {& sy
z* A4 � �
! 0 t G
{' s
o
(� 3
�J r؟ ps+
%oQ
r�, p�m oR
& o'
o6
-
� o4
&r�� po�
,
�� or
or
od
of
o�
(� -r�� p(� +e,a
(
r�� ps+
%oQ
rݍ p �* oR
&%oQ
r� p �* oR
&%oQ
r0� p�m oR
&oS
&� ,o
�
�/,o
�
(� ,
r@� p(� {&
s@
z *AL R � 3 5 C
K M % 6(� *6(� *0 Q H rZ� ps+
%oQ
r� poR
&%oQ
r� p{3 o �x oR
&oq
-*�m * 0 � s:
{$ o;
{% o<
r� p(�
(�
(=
�d %�%r p�%�%(�
�%(�
�(�
r p(�
o?
�
,o
�* ou
0
O I r�, po�
�m
r� po�
re� po-
o6
- re� po�
r� p
rq� po-
o7
~7
. rq� po�
r� pr�� po-
o7
~7
.
r�� po�
r�� po�
r�� po�
r�� po�
�* rӤ po-
o7
~7
.
rӤ po�
r< po�
r� po�
�* r � po-
o7
~7
.
r � po�
o8
s9
* 0 <
-*3(:
(;
o<
o=
*3 (9 sy
z(s sy
z0 J s>
��
o?
(@
* 0 , K (A
(B
u� , u� oC
oD
(@
*0 k L -*-*(:
oE
(;
�i�iX�� �i(F
�i�i(G
3
oH
(@
*3 (� *(s sy
z 0 � M rC� ps+
oQ
r�, p�m oR
&�* o'
o6
- (r sy
zo4
&r�� p()
,od
ob
r�� p()
,od
ob
� ,o
�oI
l(J
,(
(K
9� r�� p()
, r*� po�
r�� p()
, r� po�
oQ
o�
oQ
rت p�m oR
&oQ
r� p(
�* oR
&oQ
r�, p�m oR
&oS
< (r sy
zX oL
2vr � po�
oQ
o�
oQ
r� p�� oR
&oQ
r1� p(
�* oR
&oQ
r�, p�m oR
&oS
<� (p sy
zr�� p()
, r-� po�
r�� p()
, r$� po�
oQ
o�
oQ
rت p�m oR
&oQ
r�, p�m oR
&oS
/ rk� psy
z�%(� ,
r�� p(� {& s@
z* A4 6 \ � - 0 ] % R(� ()
* 0 c N rѮ ps+
%oQ
r�, p�m oR
&o,
o4
&rܓ po-
or
Qr� po-
oM
T�
,o
�* ( 0X
0 C O sN
{' s
o
s�
o�
r�� p
, r� p(^
oQ
r� poR
&+!, r?� p(^
oQ
rW� poR
& rq� p(^
Z�m �m (�
o�
oQ
r� p{3 o �x oR
&o,
+(� oO
o4
-�� ,o
�r�7 po�
oQ
o�
oq
(�
T�
,o
��#(� ,
r�� p(� {& sy
z* AL � � �
# �o)
,(
, (S s#
zo)
,(
, (O s#
z*0 � P
oP
�m oD
oP
/(R
+G
+ oQ
(R
-X X oD
2�o-
/(N
o-
�m ,,(�
sS
z*oT
oD
1oT
(U
-** 0 w P(
- PoN
+PQP(
- PoN
+PQP(
- PoN
+PQP(
-
PoN
+PQP(
-
PoN
+PQ*� }# rR} p}$ rH p}% rű p}& (V
* 0 - r� ps
z,oD
-r�� pr� po$
(
,r� poE
r� pr+� po�
(G
(H
r< po$
(
- r< po$
rM po$
,#rM po$
o(
r� p()
,}9 (%
r# po$
o&
}7 {7 ,{7 o'
oN
}8 + r� p}8 {8 (
,*{8 (/ oP
s
}: *2{: {? *6{: }? * {9 *"}9 *0 � Q ,�-*,�-*
+4� (
,(C rS� psS
zoW
- (] sy
zX �i2�
+i�
(
,(D rg� psS
z ,oX
. (H s#
z+#� oY
, (w sy
zX�i2�X �i2�{8 s
o
o�
r{� ps+
oQ
r�, po�
& oQ
r� po�
&
8� �
{: o (2 +S� (
oQ
o�
�x o�
oQ
o�
�m o�
oS
&X�i2�X �i?r���o�
�0,o�
(� ,
r� p( �,o
�* A4 � � � $ / � � 0 � ,oX
. (H s#
zoW
, (\ sy
z{8 s
o
r#� ps+
%oQ
r� p{: o �x oR
&%oQ
r� poR
&oS
&�! (� , r�� p( �,o
�* 6 M� 6 d�
0 � R {8 s
oW
- (] sy
z,oZ
�, (7 sy
zo
o�
r�� ps+
%oQ
r*� poR
&%oQ
r� p{: o �x oR
&%oS
&%r>� po�
oS
&o�
�* ,o�
(� , r� p( �,o
�* �� / ��
0 ) S {8 s
o
( �
,o
�*
0 ) S {8 s
o
( �
,o
�*
0 � T s�
{8 s
o
( r � ps+
%oQ
r� p�m oR
&%oQ
r� p{: o �x oR
&o,
+
or
o[
o4
-��
, o
��
,o
�o\
�(� ,
r�� p( �*( k �
~�
�� / 0 � U oW
-
ݔ {8 s
o
r�� ps+
%oQ
r� p{: o �x oR
&%oQ
rh6 poR
&%oQ
r� poR
&oq
(�
�
�!,o
� (� , r'� p( �* g�
�� / 0 � V ,�-*,�-*
+ � oW
- (] sy
zX �i2�
+;�
+#� oY
- (| sy
zX�i2�X �i2�{8 s
o
o�
rA� ps+
oQ
r� p � � o]
& oQ
r*� p � � o]
& oQ
r� p{: o �x oR
&
+V�
+=� oQ
o�
o�
oQ
o�
o�
oS
&X�i2�X �i2�o�
�0 ,o�
(� ,
r� p( �,o
�* A4 � � t $ � � 0 � W {8 s
o
rB� ps+
%oQ
r� p{: o �x oR
&%oQ
r� poR
&oq
(�
� �!,o
� (� , r � p( �* Ua
kk / 0 � X oW
- (] sy
zs�
{8 s
o
r5� ps+
%oQ
r� poR
&%oQ
r*� poR
&%oQ
r� p{: o �x oR
&o,
+
or
o[
o4
-��
,o
��
,o
�o\
�(� ,
r� p( � * ( � �
& ��
�� �r�� ps+
%oQ
r�, p�m oR
&oS
&* 0 � Y s�
rf� p ,r�� p( �m (�
r9� p(^
s+
%oQ
r� p{: o �x oR
&o,
+
or
o[
o4
-��
,o
�o\
�(� ,
ru� p( � * c |
�� / 0 J r�� ps+
%oQ
r� poR
&%oQ
r� p{: o �x oR
&oq
(�
* 0 J r.� ps+
%oQ
r� poR
&%oQ
r� p{: o �x oR
&oq
�m * 0 � s:
{4 o;
{5 o<
{6 (�
(�
(=
�d %�%r p�%�%(�
�%(�
�(�
r p(�
o?
�
,o
�* pv
�r�� p}4 rH p}5 rű p}6 (^
*J~; -( ~< *r�; r�� p(_
(`
�< *v(
j( }? ( * {= *"}= * {> *"}> * 0 L H ( j3;r�� ps+
%oQ
r� p{? oR
&oq
,(�
+j( ( *0 l . ( j0ZrI� ps+
oQ
r�� p{? oR
&oQ
r�� p( oR
&oS
. (n sy
zoa
( ( *BSJB v4.0.30319 l �. #~ / �1 #Strings �` �� #US �% #GUID �% � #Blob W]� �3 � C t a Y g s P�& ��& �& �& �� ��& N� � �� �� �� �� e� pz1 !p& e-z1 9z1 �� 5� �0 ^-�
� �- � �!� �� _ g ��
e �-
x �- �& � � �)� �� c# K� � �� [/� � +�
��- ^ � � b$� @� � z1 � � �"�&
�.�-
@ �4# �& ��& { Yn n C!o � o + g� �% N o �%)+ o o �� g/� D � �1�
k�- �/@ � �" / �!5, d 5, � 5, �05, #5, �� S� #n R#� >�* ��* �0)+" 7.-" T$-"
.-" �- �0�" �.-& �"f1& !-f1& 3*f1& �#f1& �,f1& � f1 �\0& �!f1 � @ �� \ � $. >"� � � #� � � �% X Y � �.� � � � � �"� � � � / � �� � �
� �- � �
;$�- � � ?1� � � - � &� F� � � `& C � 4 � 2 @ � @ ��
� �- � � /$ # )+ �%�
�$�- u$ � ] : � �"� #� �"� 0� �0� @ � �� � 5, � 5, � 5, +.� 1> }� 1� X � � � � � /" 1-" J$-" -" �-" �- D � � f1 {%@& $ f1 � � \0 �%\0 �\0 0�* � i#�U 9"� a ` �}
� �"3 U . �&'U 3 � ] � � �!$! � �'$U # � L#S1A# � N"S1i# � S!S1�4 � � w S1U ; ��U =
} 5@ � H ! Y-L �% �O 'S �\ q � � � *_ q � � d �h \#m Sr !\ �\ �u 6\ Q�9r �z � � d � *_ q � � �\ d �r q � � � �r �\ �-\ (\ �$\ �\ ,r �/r :-� �+r u d q � � �)_ � �\ d �\ � \ �� � D � r V�j
� V�M*� V�t+� P �j � X ��� h ��% � � � � � � ! �T� ! � �M �! � � �# � <� �# � 10� $ � r � �$ � P �$ ��% �$ �� �$ � �$ �T� �$ �r % �a
f
% �u
#% ��B 0% � r � �% � �M �( � � �( � _� �) �
�) � �.� �) � �� �) � M� �) � �.� $ �) � 8� % �* � �� ( |+ � �.� , <, � 2� . . � w� 3 �0 � j : �0 � ~ ; �0 � �# < 81 � }*/ ? l1 � �*t@ l2 � @7 A �2 � � �C l3 � �* D �3 � � D 4 � � D �5 ��% D �5 � �D �5 � > D L6 � c.E F $7 � (� H �7 � �K I �8 ��% M �8 ��"T M �8 �w @M �8 �� Z M �8 �� 5N �8 �/&5N �8 �5N 9 �s5N &9 �*5N <9 ��5N R9 �c5N h9 ��"5N ~9 ��!5N �9 �6!5N �9 ��5N �9 �5N �9 �+
5N �9 ��
5N : ��$5N : �C.5N .: ��5N D: ��
5N Z: ��#5N p: �5N �: �=5N �: �C5N �: �j5N �: �65N �: �65N �: ��5N
; ��5N ; �5N 6; �5N L; ��-5N b; ��5N x; �W5N �; �75N �; �� 5N �; ��5N �; �c,5N �; �� 5N �; �y,5N < ��5N (< ��5N >< �2 5N T< � 5N j< �l 5N �< �x 5N �< �� 5N �< �� 5N �< �� 5N �< �� 5N �< �� 5N = �� 5N = � 5N 0= ��5N F= �j5N \= ��5N r= ��5N �= ��5N �= ��#5N �= �$5N �= ��5N �= �~.5N �= �-5N > ��5N "> ��,5N 8> �*5N N> �
5N d> ��.5N z> �I5N �> ��5N �> �5N �> �� 5N �> ��5N �> ��5N �> ��5N ? � �M N @ � 2'a P �A � #'�R �B � #'k S ,C � �
r T =C � �
� Z QC � e'� _ aC � |'� d tC � I'a h 8D �a
f j ED �u
j TD � h(� k �E � z(� m 8G � �� o dG � a� q |H � s� s �J � �'r x �L � n�~ �L ��% � �L �a
f � �L �u
� �L ��B� �L � �M � HN � O� � �N � �� � <O � �%� � �O � N
� \P � r
� 8Q � Q!
� �Q � 6)
� R � �
4
� �S � ?
� �T � �
� � 4U � `N
� �U � QW
� PV � Dd
� �V ��% � W � (l
� 8Y � n�
� <Z � �(�
� �[ � �(�
� �\ � �)�
� �] � �)�
� |^ � Q
�
� _ � )�
� L` � ��
� �` � �
�
� ha � ��
� �a � -)�
� �e � ^)�
� �8 ��% � Lg � �)� [g � )� lg � � � �g � �(� Ph � [% � �h � �
� �i � f"
� �k � e!
� �l �
!
� �m � "
� �o � �!
� Xq � � � �q � 6% � `r � �
� s � |"
� �s � u!
� Ht � !
� �t � #"
� �u � �!
� �v ��% � �v � �M � �L � n� �y �a
f �y �u
z �u-� z � � z ��$� z ��� (z ��+10z ��/18z ��,<@z ��+1Hz ��1Pz �Of Xz �T� `z �r lz � Z�{ � �$�| � �# � � �#1�� � h+7�� � � 1�� � ��4� �
$�ă �
$� � � �#N �� � �T h� � �� Ȉ � �# "4� � �#X# � � 9 A%� � �A) � � L-|� � Dd
/� � � S1t� � I[2�� � 0f 4� � 2(c4 � � Kk6�� � �.t9X� � �|<p� � _ �@� � }+�D�� � � IĔ � i�Kt� � S(�N�� ��% S(� � �M SP� �a
f U]� �u
Uk� �T� Vs� �r V|� � �'�W�� � � Yx� � � 1Zt� � �'�\�� � �#S \� � � S ]�� � � X^ȝ � �'�`�� � X,Nb\� � � �ch� � �� e�� � �gh� � Li�� � �Lk� � Dd
m�� ��% o� �� �o� � �-�o� ��% o/� ��Bq7� ���q@� �� f rH� �� rT� � ��s�� � ��t � H/ V �% � _ X0 � � ' ' ' � � V w/ / w/ U / w/ w/ U 0 � � + w/ U 0 � � + w/ w/ U � w/ U � � w/ U w/ U � � � " w/ U 0 � � �( � �* w/ m* / m* � � � � G � � R � � ' V � )
�' �' � � )
�/ u "& � � �/ u "& � )
�/ u "& � �/ u "& � )
' w/ _ w/ _ � �/ �( _ � �/ � � � � )
�/ u "& } � ' V � 1 �/ u "& � 1 %# � # %# � # � V* �' � )
%# � # - � �/ u "& � ?
# �/ u "& � � )
# � )
V* �' � � � � �
�/ u � # ?
�
� � �
� � # ?
� � � # � � � � � � # � � � � � � � � ?
�' V* � � � � � V* � � � � � # � ** � � � � ** � � �$ y , � � � � � � � � � � � � � � V } � ' ' R = R "% R � � % � H0 �, R L �/ u "& R /% R � H0 � R � R /% *$ R � �/ u "& �/ u "& � R � � � - I- X0 M( %0 I-
� %0 I- � %0 :- R � �/ u "& /% , <+ R � � % V ' ' �' �' I I � R I R I �' �' I I � � � R � R � I � � V � ' ' � � �% �% �%
) �% 1 �% 9 �% A �% I �% Q �% Y �% a �% i �% q �% y �% � �% � �% � �% � �% ��% ��% ��% ��%& y�% ��%- �
4 � �% !�1: )�% � �% 1�
D �
� 9�M A�% � MT I�(Y QM_ {f !�#f !%1j Yo$� I�%� Iu � a�� i�f � �%� (� M� 9�� 9�� a#� Y�-� a$� a�� qN � �� � �% � f � < !�,� �f � 1 y�%� � �% � �% !�1� n � V ��M 1^5��9!L+@�MF� +M�MS!�f ��% �� f I�+Z��`��01��%h�%nY�% ��+x)�%�
�.�9!(� �y�f !�,�)c*�)�.19� �a[ �QU �aV QP-a�� � �i�% a�% Y~'a� i0.i�%< �B�% Y�F�? Ya�g l!�,q}l��% � �% !H �y�% !F �!y0���%�!B-���T ��%���0 �1� M 1+���,�9t.11M�)M�qN ��8/ q� ��
� ( �(/f �(;$ �% � � L$ (Q$ �%W, W.h�MmY2t, /� �t.1��%��W.Y��
f �/� �#'�Q���% t.1aM��%�7 �!^� !%1��%�1�%�(�q�%���% y �t.1!�1� |�" y�% ��- �� !�-2M9�� @i
F1�t1�1 1 !\*N!�S1Zt��0Y�%�1�1� 1�1�(�� \*�9�% 1�� 1FY1� 1�Y1"
f 9�,�9�19�,�9�� � B }�4 �% Q11�!B-���% � �T � �N� [ �� V � ��%��(���% ��% Y�f Y�f Y
Q�/Q��I�% Aa
f I�% Q�L��%XI(c��%�Qg �� 5!�,�!�,�A�% Iy �i
� I�% aD(�a� IM�qP��)�)��5�( <�,: �,: �% f � ��% �8 ��%S�-[�-b1X 1� ��x�� �?
������&���%��(�A���(f �X���0��T
f !X��p�!���d��t.1!H &�����% q�7q�: !�-f ��,<� � ��#X��%^��e�c� ��lQ/��� ��T �
$�Y�/�9�%�QP-�Iu �i�% ��$� �
$��u-� q�% ��+1Yz*� 0��
f ��f �.f ��� �z
��
a�,� !o�"
f ��%t!��qJ����!��y�% �D(<q[�Y 5�
��0<1�!D(���0���0Y�����/1Q(�Q����+1a ���% �( ��1!^+ ��-# A�% �Of �j ��% X,N!�C � X � S 4 (Q4 0s �(� �% !/ � !11�I�B \ �
�
�
�
. . . >. # G. + R. 3 ]. ; l. C �. K �. S ]. [ �. c �. k �
. s �. { �. � �. � �. � � � `� � �
� � �
)� >C� �I� > ( �
( �
? I p � "�����3O]w��� y��� f�� )2j��������� 0?Hi���/BHr����� 5=RV������ ( H Y ` y � � � � T U W c
e f � � �� �� !� �� y
� �� ?� �"� � � � 3& w . � g �" �! :! � /
�
�$ G. � �
�#
A G n : : � � �- � [ ; � � g, � }, � � 6 " p | � � � � � � � n � � � �# $ � �. - � �, .
�. M � � � � y
� y
� �� y
� y-� � �$� �� �+ �/ +- �+ � S� �� y
� �� � � � �
. 4 5 6 7 8 9 : ; < ! = # > % ? ' @ ) A + B - C / D 1 E 3 F 5 G 7 H 9 I ; J = K ? L A M C N E O G P I Q K R M S O T Q U S V U W W X Y Y [ Z ] [ _ \ a ] c ^ e _ g ` i a k b m c o d q e s f u g w h y i { j } k l � m � n � o � p � q � r � s � t � u � v � w � x � y � z � { � | � } � ~ � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �Ea�� � � � 5 � � � � � � � @ � � � - � Q& �& � � � get_schema10 MySql.Web.NET40 get_schema11 List`1 get_schema1 Microsoft.Win32 ToInt32 GetInt32 Dictionary`2 get_schema2 get_schema3 GetUInt64 ToInt64 get_schema4 get_schema5 get_schema6 get_schema7 get_schema8 get_schema9 <Module> ValidateQA System.IO T value__ get_MissingOrWrongSchema CheckSchema GetSchema MySql.Data System.Data deleteAllRelatedData DecodeProfileData EncodeProfileData get_UnableToRetrieveProfileData SessionStateStoreData CreateNewStoreData stringData DeleteUserData binaryData MySql.Web System.Web mscorlib sharedDataBlob userDataBlob dataBlob SavePersonalizationBlob ResetPersonalizationBlob System.Collections.Generic doc _desc currentTimeUtc get_Id set_Id get_LastInsertedId GetRoleId EnsureId FetchId lockId get_ApplicationId applicationId CreateOrFetchUserId GetUserId userId Read Add add locked get_PasswordRetrievalNotEnabled get_PasswordResetNotEnabled get_ChangePasswordCanceled get_ValidatePasswordCanceled get_CreateRoleFailed get_ProfileUpdateFailed get_UpdateTokenFailed get_SaveTokenFailed get_GeneratePassVerificationTokenFailed get_ClearPassTokenFailed get_NewPasswordValidationFailed get_DeleteOAuthAccountFailed get_Opened isAuthenticated authenticated inited get_PasswordFormatNotSupported get_IsApproved isApproved System.Collections.Specialized get_Deserialized set_Deserialized get_UserIdColumnNotInitialized get_UserNameColumnNotInitialized get_SimpleMembershipNotInitialized get_SimpleRoleAlreadyInitialized get_SimpleMembershipAlreadyInitialized get_UserTableNameNotInitilized _id get_PasswordResetCanceledNotValid get_PasswordQuestionInvalid get_PasswordAnswerInvalid NewGuid AppendChild RemoveChild get_FirstChild ReadToEnd DbCommand findStateCommand MySqlCommand Append DateTimeKind SpecifyKind get_UserTableNotFound get_RoleNameNotFound get_UsernameNotFound get_UserNotFound lockRecord encodedPassword oldPassword UnEncodePassword ChangePassword ValidatePassword GeneratePassword OnValidatingPassword get_ErrorResettingPassword CheckPassword GetPassword ResetPassword DecryptPassword EncryptPassword newPassword dbpassword get_CannotUnencodeHashedPwd get_NotEnoughNonAlphaNumericInPwd Replace Trace set_Source eventSource ResetUserStateMode AddNode CreateNode XmlNode SiteMapNode get_ParentNode _rootNode get_Unicode mode lockAge get_Message exceptionMessage Invoke DataTable IDisposable Hashtable Double RuntimeTypeHandle GetTypeFromHandle File MySql.Web.Profile System.Web.Profile get_CannotDeleteAPopulatedRole throwOnPopulatedRole CreateRole DeleteRole IsUserInRole FindUsersInRole GetUsersInRole get_UserNotInRole get_UserIsAlreadyInRole get_Name get_IllegalRoleName GetElementsByTagName get_FullName get_ApplicationName set_ApplicationName applicationName get_UserName get_IllegalUserName get_InvalidCharactersInUserName FindProfilesByUserName FindInactiveProfilesByUserName GetRolesByUserName userName argumentName FindUsersByName rolename username GetDateTime ToUniversalTime Runtime WriteLine get_NewLine CheckStorageEngine userIsOnline GetNumberOfUsersOnline PersonalizationScope allUsersScope scope MySqlDbType XmlNodeType failureType get_HashAlgorithmType GetType get_PropertyType Compare GetRootNodeCore MySqlSessionStateStore get_Culture set_Culture resourceCulture get_InvariantCulture get_RoleInUse InternalDataCollectionBase SessionStateStoreProviderBase Close Dispose Parse get_UserInactiveSinceDate userInactiveSinceDate inactiveSinceDate UpdateUserLastActiveDate PerInactiveDate get_LastLoginDate get_LastActivityDate Create Impersonate get_State FindSharedState GetCountOfSharedState my_aspnet_PersonalizationAdministration_ResetSharedState savedState myaspnet_PersonalizationAdministration_FindState EditorBrowsableState myaspnet_PersonalizationAdministration_GetCountOfState my_aspnet_PersonalizationAdministration_DeleteAllState MySql.Web.SessionState System.Web.SessionState ConnectionState FindUserState my_aspnet_PersonalizationAdministration_ResetUserState GetCountUserState ResetState Write CompilerGeneratedAttribute GeneratedCodeAttribute DebuggerNonUserCodeAttribute NeutralResourcesLanguageAttribute DebuggableAttribute EditorBrowsableAttribute ComVisibleAttribute AssemblyKeyFileAttribute AssemblyTitleAttribute AssemblyTrademarkAttribute TargetFrameworkAttribute XmlAttribute AssemblyDelaySignAttribute AssemblyInformationalVersionAttribute AssemblyConfigurationAttribute AssemblyDescriptionAttribute RunInstallerAttribute SecurityRulesAttribute CompilationRelaxationsAttribute AllowPartiallyTrustedCallersAttribute AssemblyProductAttribute PermissionSetAttribute AssemblyCopyrightAttribute AssemblyCompanyAttribute RuntimeCompatibilityAttribute Execute GetByte get_Value set_Value LoadValue get_SerializedValue set_SerializedValue GetConfigValue configValue AddWithValue MinValue TryGetValue get_UsingDefaultValue defaultValue MaxValue get_InvalidArrayValue get_PropertyValue set_PropertyValue SettingsPropertyValue value Save SetAndReleaseItemExclusive GetItemExclusive get_IsPrimitive Remove pageSize Serialize Deserialize Initialize get_ItemOf IndexOf RemoveProviderFromMachineConfig AddProviderToMachineConfig sessionStateConfig config System.Threading Encoding cleanupRunning System.Runtime.Versioning FromBase64String ToBase64String get_NoConnString get_ConnectionString AddDefaultConnectionString RemoveDefaultConnectionString connectionString ToString GetString Substring get_SiteMapConnectionStringMissing System.Web.Hosting set_Formatting set_Log WriteToEventLog get_WriteExceptionsToEventLog set_WriteExceptionsToEventLog pWriteExceptionsToEventLog writeExceptionsToEventLog eventLog get_UsernameToMatch usernameToMatch get_PathToMatch emailToMatch IsMatch get_PasswordNotLongEnough ComputeHash get_MonoDoesNotSupportHash Flush get_ApplicationVirtualPath rootPath path get_Length get_MinRequiredPasswordLength minRequiredPasswordLength newPasswordLength get_PasswordExceedsMaxLength StartsWith get_EnableExpireCallback set_EnableExpireCallback enableExpireCallback SessionStateItemExpireCallback SetItemExpireCallback expireCallback DeleteTimedOutSessionsWithCallback TimerCallback DeleteTimedOutSessionsWithoutCallback Rollback GetOrdinal MySql.Web.General get_EnablePasswordRetrieval enablePasswordRetrieval GetCleanupInterval cleanupInterval get_Cancel System.ComponentModel get_Email get_RequiresUniqueEmail requiresUniqueEmail GetUserNameByEmail FindUsersByEmail email System.Configuration.Install Uninstall MySql.Web.NET40.dll Fill IsDBNull System.Xml LoadXml MemoryStream get_Item set_Item CreateUninitializedItem GetSessionStoreItem RemoveItem GetItem newItem item System KeyedHashAlgorithm Trim fldNum Enum resourceMan ToBoolean GetBoolean op_GreaterThan TimeSpan Open cnn con get_Version GetSchemaVersion schemaVersion version get_PasswordStrengthRegularExpression passwordStrengthRegularExpression get_UnableToCreateApplication get_FailureInformation System.Web.Configuration System.Configuration OpenWebConfiguration System.Globalization MySql.Web.Personalization SecurityAction set_Transaction DbTransaction MySqlTransaction BeginTransaction SessionStateSection ConfigurationSection System.Reflection XmlAttributeCollection NameValueCollection SettingsPropertyValueCollection ISessionStateItemCollection ConfigurationSectionCollection ProfileInfoCollection PersonalizationStateInfoCollection ConfigurationSectionGroupCollection MembershipUserCollection DbParameterCollection MySqlParameterCollection ConnectionStringSettingsCollection HttpStaticObjectsCollection DataRowCollection SettingsPropertyCollection collection get_Connection set_Connection DbConnection CloseConnection MySqlConnection OpenConnection _connection get_Position ProfileAuthenticationOption authenticationOption NotSupportedException MembershipPasswordException ArgumentOutOfRangeException ArgumentNullException HandleMySqlException HttpException get_PreviousProviderException ArgumentException SecurityException get_Description set_Description passwordQuestion newPwdQuestion question System.Data.Common MySql.Web.Common StringComparison CompareTo GetPasswordInfo ProfileInfo CultureInfo SharedPersonalizationStateInfo UserPersonalizationStateInfo get_IsMono isMono Zero MySql.Web.SiteMap BuildSiteMap Membership app ConfigurationSectionGroup Clear DirectorySeparatorChar ExecuteScalar get_Number DbDataReader MySqlDataReader ExecuteReader StreamReader GetUserFromReader TextReader BinaryReader reader System.Configuration.Provider RNGCryptoServiceProvider MySQLProfileProvider AddProfileProvider RemoveProfileProvider get_ErrorInitProfileProvider MySQLRoleProvider AddRoleProvider RemoveRoleProvider get_ErrorInitOfRoleProvider AddPersonalizationProvider RemovePersonalizationProvider MySqlPersonalizationProvider StaticSiteMapProvider AddSiteMapProvider RemoveSiteMapProvider MySqlSiteMapProvider MySQLMembershipProvider AddMembershipProvider RemoveMembershipProvider get_ErrorInitOfMembershipProvider IFormatProvider StringBuilder Buffer SchemaManager get_ResourceManager WebConfigurationManager WebPartManager webPartManager System.CodeDom.Compiler CustomInstaller cleanupTimer MySQLPersonalizationConnectionHelper ToUpper get_InvalidUser ValidateUser UpdateUser get_UnableToCreateUser DeleteUser UnlockUser MembershipUser GetRolesForUser GetUser get_UnableToLockOutUser user DbParameter MySqlParameter XmlWriter XmlTextWriter BinaryWriter Enter DbDataAdapter MySqlDataAdapter stateSaver ChangePasswordQuestionAndAnswer get_RequiresQuestionAndAnswer requiresQuestionAndAnswer get_IncorrectPasswordAnswer passwordAnswer newPwdAnswer answer RemoveProviderFromMachineConfigInDir AddProviderToMachineConfigInDir CommandBehavior IEnumerator GetEnumerator RandomNumberGenerator .ctor Monitor _connStr set_SerializeAs SettingsSerializeAs LoadPersonalizationBlobs System.Diagnostics totalRecords get_CannotRetrieveHashedPasswords System.Web.ApplicationServices System.Runtime.InteropServices System.Runtime.CompilerServices System.Resources MySql.Web.Properties.Resources.resources DebuggingModes get_ChildNodes _nodes MySql.Web.Properties DeleteProfiles DeleteInactiveProfiles GetNumberOfInactiveProfiles GetAllInactiveProfiles GetAllProfiles GetProfiles profiles GetAllRoles RemoveUsersFromRoles AddUsersToRoles rolenames usernames PersonalizationProviderProcedures get_Attributes AddMinutes get_TotalMinutes HashPasswordBytes GetBytes bytes TrimParametersValues GetPropertyValues SetPropertyValues values actionFlags UpdateMachineConfigs get_ConnectionStrings my_aspnet_PersonalizationPerUser_GetPageSettings my_aspnet_PersonalizationAllUsers_GetPageSettings my_aspnet_PersonalizationPerUser_SetPageSettings my_aspnet_PersonalizationAllUsers_SetPageSettings my_aspnet_PersonalizationPerUser_ResetPageSettings my_aspnet_PersonalizationAllUsers_ResetPageSettings pConnectionStringSettings connectionStringSettings settings ValidatePasswordEventArgs PerPaths paths Equals get_Items serializedItems DeserializeSessionItems items CleanupOldSessions DeleteTimedOutSessions System.Text.RegularExpressions System.Security.Permissions SessionStateActions actions get_Sections System.Collections throwExceptions get_SectionGroups get_Chars GetAllUsers PerUsers GetUsers get_MinRequiredNonAlphanumericCharacters minRequiredNonAlphanumericCharacters get_Parameters GetSessionStaticObjects get_MaxInvalidPasswordAttempts maxInvalidPasswordAttempts System.Web.UI.WebControls.WebParts RoleExists get_RoleAlreadyExists get_RoleNameAlreadyExists get_UserAlreadyExists MembershipCreateStatus status get_Rows get_HasRows Concat AppendFormat get_PasswordFormat get_UnsupportedPasswordFormat MembershipPasswordFormat passwordFormat format Subtract _lockObject SecurityRuleSet get_EnablePasswordReset enablePasswordReset get_PasswordRequiredForReset IsLetterOrDigit Split Commit Init Exit ToLowerInvariant MySql.Data.MySqlClient XmlElement get_Comment HostingEnvironment XmlDocument get_InvalidArgument get_Current UpgradeToCurrent get_Count get_UnableToUpdateFailureCount MySqlScript Convert EndRequest InitializeRequest XmlNodeList get_UserIsLockedOut get_Timeout ResetItemTimeout timeout MoveNext System.Text get_CommandText set_CommandText impersonateContext HttpContext SettingsContext context get_Now get_UtcNow DataRow profileRow get_UserIsOnlineTimeWindow get_PasswordAttemptWindow passwordAttemptWindow pageIndex index Regex ToArray set_Key GetPasswordKey passwordKey FindSiteMapNodeFromKey providerUserKey key System.Security.Cryptography get_Assembly GetExecutingAssembly BlockCopy IDictionary SettingsAttributeDictionary set_Query PersonalizationStateQuery ExecuteNonQuery query Directory WriteEntry Registry op_Equality op_Inequality SessionStateUtility MySql.Web.Security System.Web.Security System.Security IsNullOrEmpty get_Property SettingsProperty get_IsDirty set_IsDirty !c o n n e c t i o n S t r i n g )c o n n e c t i o n S t r i n g N a m e 3w r i t e E x c e p t i o n s T o E v e n t L o g T R U E ��s e l e c t I d , T i t l e , D e s c r i p t i o n , U r l , R o l e s , P a r e n t I d f r o m m y _ a s p n e t _ s i t e m a p I d T i t l e D e s c r i p t i o n U r l R o l e s P a r e n t I d B u i l d S i t e M a p wA n e x c e p t i o n o c c u r r e d c o m m u n i c a t i n g w i t h t h e d a t a s o u r c e .
A c t i o n : E x c e p t i o n : M y S Q L S i t e M a p A p p l i c a t i o n eA n e x c e p t i o n o c c u r r e d . P l e a s e c h e c k t h e e v e n t l o g .
c o n f i g n a m e d e s c r i p t i o n EM y S Q L S e s s i o n S t a t e S t o r e P r o v i d e r a p p l i c a t i o n N a m e s y s t e m . w e b s e s s i o n S t a t e EC o n n e c t i o n s t r i n g c a n n o t b e b l a n k )e n a b l e E x p i r e C a l l b a c k I n i t i a l i z e ��I N S E R T I G N O R E I N T O m y _ a s p n e t _ s e s s i o n c l e a n u p S E T A p p l i c a t i o n I d = @ A p p l i c a t i o n I d , L a s t R u n = N O W ( ) , I n t e r v a l M i n u t e s = 1 0 @ A p p l i c a t i o n I d �aI N S E R T I N T O m y _ a s p n e t _ s e s s i o n s
( S e s s i o n I d , A p p l i c a t i o n I d , C r e a t e d , E x p i r e s , L o c k D a t e ,
L o c k I d , T i m e o u t , L o c k e d , S e s s i o n I t e m s , F l a g s )
V a l u e s ( @ S e s s i o n I d , @ A p p l i c a t i o n I d , N O W ( ) , N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E , N O W ( ) ,
@ L o c k I d , @ T i m e o u t , @ L o c k e d , @ S e s s i o n I t e m s , @ F l a g s )
o n d u p l i c a t e k e y u p d a t e C r e a t e d = v a l u e s ( C r e a t e d ) , E x p i r e s = v a l u e s ( E x p i r e s ) ,
L o c k D a t e = v a l u e s ( L o c k D a t e ) , L o c k I d = v a l u e s ( L o c k I d ) , T i m e o u t = v a l u e s ( T i m e o u t ) ,
L o c k e d = v a l u e s ( L o c k e d ) , S e s s i o n I t e m s = v a l u e s ( S e s s i o n I t e m s ) , F l a g s = v a l u e s ( F l a g s ) @ S e s s i o n I d @ L o c k I d @ T i m e o u t @ L o c k e d @ S e s s i o n I t e m s
@ F l a g s /C r e a t e U n i n i t i a l i z e d I t e m �SU P D A T E m y _ a s p n e t _ s e s s i o n s S E T L o c k e d = 0 , E x p i r e s = N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k I d = @ L o c k I d )R e l e a s e I t e m E x c l u s i v e ��D E L E T E F R O M m y _ a s p n e t _ s e s s i o n s W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k I d = @ L o c k I d %R e m o v e I t e m E r r o r : �U P D A T E m y _ a s p n e t _ s e s s i o n s S E T E x p i r e s = N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d !R e s e t I t e m T i m e o u t ��U P D A T E m y _ a s p n e t _ s e s s i o n s S E T E x p i r e s = N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E , S e s s i o n I t e m s = @ S e s s i o n I t e m s , L o c k e d = @ L o c k e d W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k I d = @ L o c k I d 5S e t A n d R e l e a s e I t e m E x c l u s i v e �=U P D A T E m y _ a s p n e t _ s e s s i o n s S E T L o c k e d = 1 , L o c k D a t e = N O W ( ) W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k e d = 0 A N D E x p i r e s > N O W ( ) �YS E L E C T N O W ( ) , E x p i r e s , S e s s i o n I t e m s , L o c k I d , F l a g s , T i m e o u t , L o c k D a t e , L o c k e d F R O M m y _ a s p n e t _ s e s s i o n s W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ��U P D A T E m y _ a s p n e t _ s e s s i o n s S E T L o c k I d = @ L o c k I d , F l a g s = 0 W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d 'G e t S e s s i o n S t o r e I t e m �U P D A T E m y _ a s p n e t _ s e s s i o n c l e a n u p S E T L a s t R u n = N O W ( ) W H E R E L a s t R u n + I N T E R V A L I n t e r v a l M i n u t e s M I N U T E < N O W ( ) A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d %C l e a n u p O l d S e s s i o n s ��S E L E C T I n t e r v a l M i n u t e s f r o m m y _ a s p n e t _ s e s s i o n c l e a n u p w h e r e A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ��S E L E C T E N G I N E F R O M I N F O R M A T I O N _ S C H E M A . T A B L E S W H E R E T A B L E _ N A M E = ' m y _ a s p n e t _ s e s s i o n s '
M y I S A M ��S t o r a g e e n g i n e f o r t a b l e m y _ a s p n e t _ s e s s i o n s i s M y I S A M . I f p o s s i b l e , p l e a s e c h a n g e i t t o a t r a n s a c t i o n a l s t o r a g e e n g i n e t o i m p r o v e p e r f o r m a n c e , e . g w i t h ' a l t e r t a b l e m y _ a s p n e t _ s e s s i o n s e n g i n e i n n o d b '
Og o t e x c e p t i o n w h i l e c h e c k i n g f o r e n g i n e ��D E L E T E F R O M m y _ a s p n e t _ s e s s i o n s W H E R E E x p i r e s < N O W ( ) A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d {G o t e x c e p t i o n i n D e l e t e T i m e d O u t S e s s i o n s W i t h O u t C a l l b a c k ��S E L E C T S e s s i o n I D , S e s s i o n I t e m s F R O M m y _ a s p n e t _ s e s s i o n s W H E R E E x p i r e s < N O W ( ) A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ��D E L E T E F R O M m y _ a s p n e t _ s e s s i o n s W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d sG o t e x c e p t i o n i n D e l e t e T i m e d O u t S e s s i o n s W i t h C a l l b a c k -M y S Q L S e s s i o n S t a t e S t o r e %a u t o g e n e r a t e s c h e m a t r u e =M y S q l . W e b . P r o p e r t i e s . R e s o u r c e s s c h e m a { 0 } YU P D A T E m y _ a s p n e t _ s c h e m a v e r s i o n S E T v e r s i o n = 7 KS E L E C T * F R O M m y _ a s p n e t _ s c h e m a v e r s i o n !m y s q l _ m e m b e r s h i p
T a b l e s T A B L E _ C O M M E N T ��S E L E C T i d F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D n a m e = @ n a m e
@ a p p I d @ n a m e ��I N S E R T I N T O m y _ a s p n e t _ u s e r s V A L U E S
( N U L L , @ a p p I d , @ n a m e , @ i s A n o n , N o w ( ) ) @ i s A n o n /S E L E C T L A S T _ I N S E R T _ I D ( ) 5C a n n o t D e l e t e A P o p u l a t e d R o l e ;C a n n o t R e t r i e v e H a s h e d P a s s w o r d s /C a n n o t U n e n c o d e H a s h e d P w d -C h a n g e P a s s w o r d C a n c e l e d )C l e a r P a s s T o k e n F a i l e d !C r e a t e R o l e F a i l e d 1D e l e t e O A u t h A c c o u n t F a i l e d ;E r r o r I n i t O f M e m b e r s h i p P r o v i d e r /E r r o r I n i t O f R o l e P r o v i d e r 1E r r o r I n i t P r o f i l e P r o v i d e r -E r r o r R e s e t t i n g P a s s w o r d GG e n e r a t e P a s s V e r i f i c a t i o n T o k e n F a i l e d I l l e g a l R o l e N a m e I l l e g a l U s e r N a m e /I n c o r r e c t P a s s w o r d A n s w e r I n v a l i d A r g u m e n t #I n v a l i d A r r a y V a l u e 7I n v a l i d C h a r a c t e r s I n U s e r N a m e I n v a l i d U s e r )M i s s i n g O r W r o n g S c h e m a -M o n o D o e s N o t S u p p o r t H a s h 7N e w P a s s w o r d V a l i d a t i o n F a i l e d N o C o n n S t r i n g ;N o t E n o u g h N o n A l p h a N u m e r i c I n P w d +P a s s w o r d A n s w e r I n v a l i d 1P a s s w o r d E x c e e d s M a x L e n g t h 5P a s s w o r d F o r m a t N o t S u p p o r t e d +P a s s w o r d N o t L o n g E n o u g h /P a s s w o r d Q u e s t i o n I n v a l i d 1P a s s w o r d R e q u i r e d F o r R e s e t ;P a s s w o r d R e s e t C a n c e l e d N o t V a l i d /P a s s w o r d R e s e t N o t E n a b l e d 7P a s s w o r d R e t r i e v a l N o t E n a b l e d 3P r e v i o u s P r o v i d e r E x c e p t i o n 'P r o f i l e U p d a t e F a i l e d #R o l e A l r e a d y E x i s t s R o l e I n U s e +R o l e N a m e A l r e a d y E x i s t s !R o l e N a m e N o t F o u n d S a v e T o k e n F a i l e d s c h e m a 1 s c h e m a 1 1 s c h e m a 2 s c h e m a 3 s c h e m a 4 s c h e m a 5 s c h e m a 6 s c h e m a 7 s c h e m a 8 s c h e m a 9 s c h e m a 1 0 ES i m p l e M e m b e r s h i p A l r e a d y I n i t i a l i z e d =S i m p l e M e m b e r s h i p N o t I n i t i a l i z e d 9S i m p l e R o l e A l r e a d y I n i t i a l i z e d =S i t e M a p C o n n e c t i o n S t r i n g M i s s i n g 3U n a b l e T o C r e a t e A p p l i c a t i o n %U n a b l e T o C r e a t e U s e r 'U n a b l e T o L o c k O u t U s e r 7U n a b l e T o R e t r i e v e P r o f i l e D a t a 5U n a b l e T o U p d a t e F a i l u r e C o u n t 3U n s u p p o r t e d P a s s w o r d F o r m a t #U p d a t e T o k e n F a i l e d #U s e r A l r e a d y E x i s t s 5U s e r I d C o l u m n N o t I n i t i a l i z e d 'U s e r I s A l r e a d y I n R o l e U s e r I s L o c k e d O u t 9U s e r N a m e C o l u m n N o t I n i t i a l i z e d !U s e r n a m e N o t F o u n d U s e r N o t F o u n d U s e r N o t I n R o l e 5U s e r T a b l e N a m e N o t I n i t i l i z e d #U s e r T a b l e N o t F o u n d 1V a l i d a t e P a s s w o r d C a n c e l e d )M y S Q L P r o f i l e P r o v i d e r -M y S Q L P r o f i l e p r o v i d e r �S E L E C T * F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D
l a s t A c t i v i t y D a t e < @ l a s t A c t i v i t y D a t e #@ l a s t A c t i v i t y D a t e ) A N D i s A n o n y m o u s = 1 ) A N D i s A n o n y m o u s = 0 kD E L E T E F R O M m y _ a s p n e t _ p r o f i l e s W H E R E u s e r I d = @ u s e r I d @ u s e r I d
u s e r I d ��S E L E C T * F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D n a m e = @ n a m e �+S E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D
l a s t A c t i v i t y D a t e < @ l a s t A c t i v i t y D a t e U s e r N a m e �QS E L E C T * F R O M m y _ a s p n e t _ p r o f i l e s p
J O I N m y _ a s p n e t _ u s e r s u O N u . i d = p . u s e r I d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d A N D u . n a m e = @ n a m e I s A u t h e n t i c a t e d �1I N S E R T I N T O m y _ a s p n e t _ p r o f i l e s
V A L U E S ( @ u s e r I d , @ i n d e x , @ s t r i n g D a t a , @ b i n a r y D a t a , N U L L ) O N D U P L I C A T E K E Y U P D A T E
v a l u e i n d e x = V A L U E S ( v a l u e i n d e x ) , s t r i n g d a t a = V A L U E S ( s t r i n g d a t a ) ,
b i n a r y d a t a = V A L U E S ( b i n a r y d a t a )
@ i n d e x @ s t r i n g D a t a @ b i n a r y D a t a gD E L E T E F R O M m y _ a s p n e t _ p r o f i l e s W H E R E u s e r I d = @ u s e r I d v a l u e i n d e x s t r i n g D a t a b i n a r y D a t a 0 A l l o w A n o n y m o u s { 0 } / / 0 / - 1 : { 0 } / 0 / { 1 } / { 2 } : { 0 } / 1 / { 1 } / { 2 } : �5S E L E C T p . * , u . n a m e , u . i s A n o n y m o u s , u . l a s t A c t i v i t y D a t e ,
L E N G T H ( p . s t r i n g d a t a ) + L E N G T H ( p . b i n a r y d a t a ) A S p r o f i l e s i z e
F R O M m y _ a s p n e t _ p r o f i l e s p
J O I N m y _ a s p n e t _ u s e r s u O N u . i d = p . u s e r I d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d 5 A N D u . n a m e L I K E @ u s e r N a m e @ u s e r N a m e W A N D u . l a s t A c t i v i t y D a t e < @ l a s t A c t i v i t y D a t e - A N D u . i s A n o n y m o u s = 1 - A N D u . i s A n o n y m o u s = 0 L I M I T { 0 } , { 1 } i s A n o n y m o u s !l a s t A c t i v i t y D a t e l a s t U p d a t e d D a t e p r o f i l e s i z e 'S E L E C T F O U N D _ R O W S ( ) 9M y S q l P e r s o n a l i z a t i o n P r o v i d e r =M y S q l P e r s o n a l i z a t i o n p r o v i d e r SM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - I n i t i a l i z e q u e r y p a g e I n d e x p a g e S i z e #q u e r y . P a t h T o M a t c h #q u e r y . U s e r T o M a t c h oM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - L o a d P e r s o n a z a l i t i o n B l o b s oM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - R e s e t P e r s o n a l i z a t i o n B l o b SM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - R e s e t S t a t e [M y S Q L P e r s o n a l i z a t i o n P r o v i d e r - R e s e t U s e r S t a t e mM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - S a v e P e r s o n a l i z a t i o n B l o b P a t h !S h a r e d D a t a L e n g t h U s e r D a t a L e n g t h U s e r C o u n t ]M y S Q L P e r s o n a l i z a t i o n P r o v i d e r - F i n d S h a r e d S t a t e L a s t U p d a t e d D a t e S i z e !L a s t A c t i v i t y D a t e YM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - F i n d U s e r S t a t e iM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - G e t C o u n t O f S h a r e d S t a t e aM y S Q L P e r s o n a l i z a t i o n P r o v i d e r - G e t C o u n t U s e r S t a t e 9M y S Q L P e r s o n a l i z a t i o n P r o v i d e r ��C R E A T E T E M P O R A R Y T A B L E I F N O T E X I S T S p a g e I n d e x R e s u l t s ( I n d e x I d i n t A U T O _ I N C R E M E N T N O T N U L L P R I M A R Y K E Y , I t e m I d i n t n o t n u l l ) AE r r o r : C o n n e c t i o n s h o u l d b e o p e n ?T R U N C A T E T A B L E p a g e I n d e x R e s u l t s ��I N S E R T I N T O p a g e I n d e x R e s u l t s ( I t e m I d ) ( S E L E C T m y a s p n e t _ P a t h s . P a t h I d F R O M m y a s p n e t _ P a t h s , ( ( S E L E C T a s p n e t _ P a t h s . P a t h I d F R O M m y a s p n e t _ P e r s o n a l i z a t i o n A l l U s e r s , a s p n e t _ P a t h s W H E R E m y a s p n e t _ P a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D a s p n e t _ P e r s o n a l i z a t i o n A l l U s e r s . P a t h I d = a s p n e t _ P a t h s . P a t h I d A N D ( @ P a t h I S N U L L O R a s p n e t _ P a t h s . L o w e r e d P a t h L I K E @ P a t h ) ) A S S h a r e d D a t a P e r P a t h F U L L O U T E R J O I N ( S E L E C T D I S T I N C T a s p n e t _ P a t h s . P a t h I d F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r , m y _ a s p n e t _ p a t h s W H E R E m y _ a s p n e t _ p a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . P a t h I d = a s p n e t _ P a t h s . P a t h I d A N D ( @ P a t h I S N U L L O R m y _ a s p n e t _ p a t h s . L o w e r e d P a t h L I K E @ P a t h ) ) A S U s e r D a t a P e r P a t h O N S h a r e d D a t a P e r P a t h . P a t h I d = U s e r D a t a P e r P a t h . P a t h I d ) W H E R E m y _ a s p n e t _ P a t h s . P a t h I d = S h a r e d D a t a P e r P a t h . P a t h I d O R m y _ a s p n e t _ P a t h s . P a t h I d = U s e r D a t a P e r P a t h . P a t h I d O R D E R B Y m y _ a s p n e t _ P a t h s . P a t h A S C ) @ P a t h US E L E C T C o u n t ( P a t h I d ) F R O M p a g e I n d e x R e s u l t s ��S E L E C T m y _ a s p n e t _ P a t h s . P a t h , S h a r e d D a t a P e r P a t h . L a s t U p d a t e d D a t e , S h a r e d D a t a P e r P a t h . S h a r e d D a t a L e n g t h , U s e r D a t a P e r P a t h . U s e r D a t a L e n g t h , U s e r D a t a P e r P a t h . U s e r C o u n t F R O M a s p n e t _ P a t h s , ( ( S E L E C T p a g e I n d e x R e s u l t s . I t e m I d A S P a t h I d , a s p n e t _ P e r s o n a l i z a t i o n A l l U s e r s . L a s t U p d a t e d D a t e A S L a s t U p d a t e d D a t e , L E N G T H ( a s p n e t _ P e r s o n a l i z a t i o n A l l U s e r s . P a g e S e t t i n g s ) A S S h a r e d D a t a L e n g t h F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s , P a g e I n d e x W H E R E m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s . P a t h I d = p a g e I n d e x R e s u l t s . I n d e x I d A N D p a g e I n d e x R e s u l t s . I n d e x I d > = @ P a g e L o w e r B o u n d A N D p a g e I n d e x R e s u l t s . I n d e x I d < = @ P a g e U p p e r B o u n d ) A S S h a r e d D a t a P e r P a t h F U L L O U T E R J O I N ( S E L E C T p a g e I n d e x R e s u l t s . I t e m I d A S P a t h I d , S U M ( L E N G T H ( m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . P a g e S e t t i n g s ) ) A S U s e r D a t a L e n g t h , C O U N T ( * ) A S U s e r C o u n t F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r , p a g e I n d e x R e s u l t s W H E R E m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . P a t h I d = p a g e I n d e x R e s u l t s . I n d e x I d A N D p a g e I n d e x R e s u l t s . I n d e x I d > = @ P a g e L o w e r B o u n d A N D p a g e I n d e x R e s u l t s . I n d e x I d < = @ P a g e U p p e r B o u n d G R O U P B Y p a g e I n d e x R e s u l t s . I n d e x I d ) A S U s e r D a t a P e r P a t h O N S h a r e d D a t a P e r P a t h . P a t h I d = U s e r D a t a P e r P a t h . P a t h I d ) W H E R E a s p n e t _ P a t h s . P a t h I d = S h a r e d D a t a P e r P a t h . P a t h I d O R a s p n e t _ P a t h s . P a t h I d = U s e r D a t a P e r P a t h . P a t h I d O R D E R B Y m y _ a s p n e t _ P a t h s . P a t h A S C @ P a g e L o w e r B o u n d @ P a g e U p p e r B o u n d ��I N S E R T I N T O p a g e I n d e x R e s u l t s ( I t e m I d ) ( S E L E C T m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . I d F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r , m y _ a s p n e t _ u s e r s , m y _ a s p n e t _ p a t h s W H E R E m y _ a s p n e t _ p a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . U s e r I d = m y _ a s p n e t _ U s e r s . I d A N D m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . P a t h I d = m y _ a s p n e t _ P a t h s . P a t h I d A N D ( @ P a t h I S N U L L O R m y _ a s p n e t _ p a t h s . L o w e r e d P a t h L I K E @ P a t h ) A N D ( @ U s e r N a m e I S N U L L O R m y _ a s p n e t _ u s e r s . n a m e L I K E @ U s e r N a m e ) A N D ( @ I n a c t i v e S i n c e D a t e I S N U L L O R m y _ a s p n e t _ u s e r s . L a s t A c t i v i t y D a t e < = @ I n a c t i v e S i n c e D a t e ) O R D E R B Y m y _ a s p n e t _ p a t h s . P a t h A S C , m y _ a s p n e t _ u s e r s . n a m e A S C ) @ U s e r N a m e %@ I n a c t i v e S i n c e D a t e WS E L E C T C o u n t ( I n d e x I d ) F R O M p a g e I n d e x R e s u l t s � S E L E C T m y _ a s p n e t _ P a t h s . P a t h , m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . L a s t U p d a t e d D a t e , L E N G T H ( m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . P a g e S e t t i n g s ) a s S i z e , m y _ a s p n e t _ U s e r s . N a m e , m y _ a s p n e t _ U s e r s . L a s t A c t i v i t y D a t e F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r , m y _ a s p n e t _ u s e r s , m y _ a s p n e t _ p a t h s , p a g e I n d e x R e s u l t s W H E R E m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . I d = P a g e I n d e x R e s u l t s . I n d e x I d A N D m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . U s e r I d = m y _ a s p n e t _ u s e r s . I d A N D m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r . P a t h I d = m y _ a s p n e t _ p a t h s . P a t h I d A N D p a g e I n d e x R e s u l t s . I t e m I d > = @ P a g e L o w e r B o u n d A N D P a g e I n d e x R e s u l t s . I t e m I d < = @ P a g e U p p e r B o u n d O R D E R B Y m y _ a s p n e t _ p a t h s . P a t h A S C , m y _ a s p n e t _ u s e r s . n a m e A S C �S e l e c t c o u n t ( * ) f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s , m y _ a s p n e t _ p a t h s w h e r e m y _ a s p n e t _ p a t h s . a p p l i c a t i o n I d = @ A p p l i c a t i o n I d a n d m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s . p a t h i d = m y _ a s p n e t _ p a t h s . p a t h i d a n d ( @ P a t h i s n u l l o r m y _ a s p n e t _ p a t h s . l o w e r e d p a t h l i k e l o w e r ( @ P a t h ) ) �QS e l e c t c o u n t ( * ) f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r a s p e r u s e r , m y _ a s p n e t _ u s e r s a s u s e r s , m y _ a s p n e t _ p a t h s a s p a t h s w h e r e p a t h s . a p p l i c a t i o n I d = @ A p p l i c a t i o n I d a n d p e r u s e r . u s e r i d = u s e r s . i d a n d p e r u s e r . p a t h I d = p a t h s . p a t h I d a n d ( @ P a t h i s n u l l o r p a t h s . l o w e r e d p a t h l i k e l o w e r ( @ P a t h ) a n d ( @ U s e r N a m e i s n u l l o r u s e r s . n a m e l i k e l o w e r ( @ U s e r N a m e ) ) ) a n d ( @ I n a c t i v e S i n c e D a t e i s n u l l o r u s e r s . l a s t a c t i v i t y d a t e < = @ I n a c t i v e S i n c e D a t e ) ��s e l e c t p a t h I d f r o m m y _ a s p n e t _ p a t h s w h e r e a p p l i c a t i o n i d = @ A p p l i c a t i o n I d a n d l o w e r e d p a t h = l o w e r ( @ P a t h ) ��s e l e c t I d f r o m m y _ a s p n e t _ u s e r s w h e r e a p p l i c a t i o n i d = @ A p p l i c a t i o n I d a n d n a m e = @ U s e r N a m e �s e l e c t p a g e s e t t i n g s f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r a s p e r u s e r w h e r e p e r u s e r . p a t h i d = @ P a t h I d a n d p e r u s e r . u s e r i d = @ U s e r I d @ P a t h I d @ U s e r I d ��S e l e c t p a t h i d f r o m m y _ a s p n e t _ p a t h s a s p a t h s w h e r e p a t h s . a p p l i c a t i o n i d = @ A p p l i c a t i o n I d a n d p a t h s . l o w e r e d P a t h = l o w e r ( @ P a t h ) ��S e l e c t P a g e S e t t i n g s f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s w h e r e p a t h I d = @ P a t h I d ��s e l e c t I d f r o m m y _ a s p n e t _ u s e r s w h e r e a p p l i c a t i o n i d = @ A p p l i c a t i o n I d a n d n a m e = @ U s e r N a m e ��d e l e t e f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r W H E R E p a t h I d = @ P a t h I d A N D u s e r I d = @ U s e r I d ��d e l e t e m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s . * f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s W H E R E p a t h I d = @ P a t h I d ��u p d a t e m y _ a s p n e t _ u s e r s s e t l a s t a c t i v i t y d a t e = @ C u r r e n t T i m e U t c w h e r e i d = @ U s e r I d @ C u r r e n t T i m e U t c ��D E L E T E p e r u s e r . * F R O M ( m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r a s p e r u s e r I N N E R J O I N m y _ a s p n e t _ u s e r s a s u s e r s O N p e r u s e r . u s e r i d = u s e r s . i d ) I N N E R J O I N m y _ a s p n e t _ p a t h s a s p a t h s O N p a t h s . a p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D p a t h s . p a t h i d = p e r u s e r . p a t h i d A N D ( @ I n a c t i v e S i n c e D a t e i s n u l l O R u s e r s . l a s t a c t i v i t y d a t e < = @ I n a c t i v e S i n c e D a t e ) i A N D ( @ U s e r N a m e i s n u l l O R u s e r s . n a m e = @ U s e r N a m e ) q A N D ( @ P a t h i s n u l l O R p a t h s . l o w e r e d p a t h = L O W E R ( @ P a t h ) ) �9D E L E T E F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s W H E R E P a t h I d I N ( S E L E C T P a t h s . P a t h I d F R O M m y _ a s p n e t _ p a t h s a s p a t h s W H E R E p a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ) �7D E L E T E F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r W H E R E P a t h I d I N ( S E L E C T P a t h s . P a t h I d F R O M m y _ a s p n e t _ p a t h s a s p a t h s W H E R E p a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ) �D E L E T E m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s . * F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s I N N E R J O I N m y _ a s p n e t _ p a t h s a s p a t h s O N ( ( p a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s . P a t h I d = p a t h s . P a t h I d ) A N D p a t h s . l o w e r e d p a t h = L O W E R ( @ P a t h ) ) �9D E L E T E F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s W H E R E P a t h I d I N ( S E L E C T p a t h s . P a t h I d F R O M m y _ a s p n e t _ p a t h s a s p a t h s W H E R E p a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ) �1D E L E T E F R O M m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r W H E R E P a t h I d I N ( S E L E C T P a t h s . P a t h I d F R O M m y _ a s p n e t _ p a t h s P a t h s W H E R E P a t h s . A p p l i c a t i o n I d = @ A p p l i c a t i o n I d ) ��S E L E C T P a t h I d F R O M m y _ a s p n e t _ p a t h s W H E R E A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o w e r e d P a t h = L O W E R ( @ P a t h ) ��I N S E R T I N T O m y _ a s p n e t _ p a t h s ( a p p l i c a t i o n I d , p a t h I d , p a t h , l o w e r e d p a t h ) v a l u e s ( @ A p p l i c a t i o n I d , @ P a t h I d , @ P a t h , L O W E R ( @ P a t h ) ) ��S E L E C T i d F R O M m y _ a s p n e t _ u s e r s W H E R E A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D n a m e = L O W E R ( @ U s e r N a m e ) �I N S E R T I N T O m y _ a s p n e t _ u s e r s ( a p p l i c a t i o n I d , n a m e , i s A n o n y m o u s , l a s t A c t i v i t y D a t e ) v a l u e s ( @ A p p l i c a t i o n I d , @ U s e r N a m e , f a l s e , @ C u r r e n t T i m e U t c ) ��S E L E C T I d f r o m m y _ a s p n e t _ u s e r s w h e r e a p p l i c a t i o n I d = @ A p p l i c a t i o n I d a n d n a m e = @ U s e r N a m e ) U s e r n o t f o u n d ��S e l e c t C O U N T ( * ) f r o m m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r w h e r e u s e r i d = @ U s e r I d a n d p a t h I d = @ P a t h I d �/U P D A T E m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r S E T P a g e S e t t i n g s = @ P a g e S e t t i n g s , L a s t U p d a t e d D a t e = @ C u r r e n t T i m e U t c w h e r e u s e r i d = @ U s e r I d a n d p a t h I d = @ P a t h I d @ P a g e S e t t i n g s �iI N S E R T I N T O m y _ a s p n e t _ p e r s o n a l i z a t i o n p e r u s e r ( a p p l i c a t i o n I d , p a t h I d , u s e r I d , p a g e S e t t i n g s , l a s t U p d a t e d D a t e ) V A L U E S ( @ a p p l i c a t i o n I d , @ P a t h I d , @ u s e r I d , @ P a g e S e t t i n g s , @ L a s t U p d a t e d D a t e ) @ a p p l i c a t i o n I d !@ L a s t U p d a t e d D a t e � I N S E R T I N T O m y _ a s p n e t _ p e r s o n a l i z a t i o n a l l u s e r s ( P a t h I d , P a g e S e t t i n g s , L a s t U p d a t e d D a t e ) V A L U E S ( @ P a t h I d , @ P a g e S e t t i n g s , @ C u r r e n t T i m e U t c ) �� O N D U P L I C A T E K E Y U P D A T E P a g e S e t t i n g s = V a l u e s ( P a g e S e t t i n g s ) , L a s t U p d a t e d D a t e = V a l u e s ( L a s t U p d a t e d D a t e ) iH K E Y _ L O C A L _ M A C H I N E \ S o f t w a r e \ M i c r o s o f t \ . N E T F r a m e w o r k \ I n s t a l l R o o t eU n a b l e t o r e t r i e v e i n s t a l l r o o t f o r . N E T f r a m e w o r k { 0 } 6 4 { 1 } v 2 . 0 . 5 0 7 2 7 v 4 . 0 . 3 0 3 1 9 { 0 } \ C O N F I G %{ 0 } \ m a c h i n e . c o n f i g a d d !L o c a l M y S q l S e r v e r #c o n n e c t i o n S t r i n g s /M y S Q L M e m b e r s h i p P r o v i d e r _M y S q l . W e b . S e c u r i t y . M y S Q L M e m b e r s h i p P r o v i d e r , { 0 } I n s t a l l e r s W e b
. N E T 4 0 t y p e /e n a b l e P a s s w o r d R e t r i e v a l f a l s e 'e n a b l e P a s s w o r d R e s e t 3r e q u i r e s Q u e s t i o n A n d A n s w e r / 'r e q u i r e s U n i q u e E m a i l p a s s w o r d F o r m a t C l e a r 5m a x I n v a l i d P a s s w o r d A t t e m p t s 5 3m i n R e q u i r e d P a s s w o r d L e n g t h 7 Im i n R e q u i r e d N o n a l p h a n u m e r i c C h a r a c t e r s 1 +p a s s w o r d A t t e m p t W i n d o w 1 0 Cp a s s w o r d S t r e n g t h R e g u l a r E x p r e s s i o n m e m b e r s h i p UM y S q l . W e b . S e c u r i t y . M y S Q L M e m b e r s h i p P r o v i d e r #M y S Q L R o l e P r o v i d e r SM y S q l . W e b . S e c u r i t y . M y S Q L R o l e P r o v i d e r , { 0 } r o l e M a n a g e r IM y S q l . W e b . S e c u r i t y . M y S Q L R o l e P r o v i d e r WM y S q l . W e b . P r o f i l e . M y S Q L P r o f i l e P r o v i d e r , { 0 } p r o f i l e MM y S q l . W e b . P r o f i l e . M y S Q L P r o f i l e P r o v i d e r )M y S q l S i t e M a p P r o v i d e r WM y S q l . W e b . S i t e M a p . M y S q l S i t e M a p P r o v i d e r , { 0 } s i t e M a p p r o v i d e r s MM y S q l . W e b . S i t e M a p . M y S q l S i t e M a p P r o v i d e r w e b P a r t s p e r s o n a l i z a t i o n wM y S q l . W e b . P e r s o n a l i z a t i o n . M y S q l P e r s o n a l i z a t i o n P r o v i d e r , { 0 } mM y S q l . W e b . P e r s o n a l i z a t i o n . M y S q l P e r s o n a l i z a t i o n P r o v i d e r 3M y S Q L d e f a u l t a p p l i c a t i o n T r u e F a l s e
h a s h e d e n c r y p t e d c l e a r =P a s s w o r d f o r m a t n o t s u p p o r t e d . n e w P a s s w o r d �YU P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T P a s s w o r d = @ p a s s , L a s t P a s s w o r d C h a n g e d D a t e = @ l a s t P a s s w o r d C h a n g e d D a t e
W H E R E u s e r I d = @ u s e r I d @ p a s s 1@ l a s t P a s s w o r d C h a n g e d D a t e C h a n g e P a s s w o r d �]U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T P a s s w o r d Q u e s t i o n = @ p a s s w o r d Q u e s t i o n , P a s s w o r d A n s w e r = @ p a s s w o r d A n s w e r
W H E R E u s e r I d = @ u s e r I d #@ p a s s w o r d Q u e s t i o n @ p a s s w o r d A n s w e r ?C h a n g e P a s s w o r d Q u e s t i o n A n d A n s w e r p a s s w o r d ��I N S E R T I N T O m y _ a s p n e t _ m e m b e r s h i p
V A L U E S ( @ u s e r I d , @ e m a i l , @ c o m m e n t , @ p a s s w o r d , @ p a s s w o r d K e y ,
@ p a s s w o r d F o r m a t , @ p a s s w o r d Q u e s t i o n , @ p a s s w o r d A n s w e r ,
@ i s A p p r o v e d , @ l a s t A c t i v i t y D a t e , @ l a s t L o g i n D a t e ,
@ l a s t P a s s w o r d C h a n g e d D a t e , @ c r e a t i o n D a t e ,
@ i s L o c k e d O u t , @ l a s t L o c k e d O u t D a t e , @ f a i l e d P a s s w o r d A t t e m p t C o u n t ,
@ f a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t , @ f a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t ,
@ f a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t )
@ e m a i l @ c o m m e n t @ p a s s w o r d @ p a s s w o r d K e y @ p a s s w o r d F o r m a t @ i s A p p r o v e d @ l a s t L o g i n D a t e @ c r e a t i o n D a t e @ i s L o c k e d O u t %@ l a s t L o c k e d O u t D a t e 7@ f a i l e d P a s s w o r d A t t e m p t C o u n t C@ f a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t C@ f a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t O@ f a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t C r e a t e U s e r �%D E L E T E { 0 } m
F R O M m y _ a s p n e t _ u s e r s u , m y _ a s p n e t _ m e m b e r s h i p m
W H E R E u . i d = m . u s e r I d A N D u . i d = @ u s e r I d u , D e l e t e U s e r �QS E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ m e m b e r s h i p m J O I N m y _ a s p n e t _ u s e r s u
O N m . u s e r I d = u . i d W H E R E m . L a s t A c t i v i t y D a t e > @ d a t e A N D u . a p p l i c a t i o n I d = @ a p p I d @ d a t e -G e t N u m b e r O f U s e r s O n l i n e 'U s e r n a m e n o t f o u n d . � S E L E C T P a s s w o r d , P a s s w o r d A n s w e r , P a s s w o r d K e y , P a s s w o r d F o r m a t ,
I s L o c k e d O u t F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E u s e r I d = @ u s e r I d I s L o c k e d O u t P a s s w o r d P a s s w o r d A n s w e r P a s s w o r d K e y G e t P a s s w o r d 1G e t U s e r ( S t r i n g , B o o l e a n ) ��U P D A T E m y _ a s p n e t _ u s e r s S E T l a s t A c t i v i t y D a t e = @ d a t e W H E R E i d = @ u s e r I d ��U P D A T E m y _ a s p n e t _ m e m b e r s h i p S E T L a s t A c t i v i t y D a t e = @ d a t e W H E R E u s e r I d = @ u s e r I d �)S E L E C T m . * , u . n a m e
F R O M m y _ a s p n e t _ m e m b e r s h i p m J O I N m y _ a s p n e t _ u s e r s u O N m . u s e r I d = u . i d
W H E R E u . i d = @ u s e r I d 1G e t U s e r ( O b j e c t , B o o l e a n ) �9U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T I s L o c k e d O u t = f a l s e , L a s t L o c k e d O u t D a t e = @ l a s t D a t e
W H E R E u s e r I d = @ u s e r I d @ l a s t D a t e U n l o c k U s e r �kS E L E C T u . n a m e F R O M m y _ a s p n e t _ u s e r s u
J O I N m y _ a s p n e t _ m e m b e r s h i p m O N m . u s e r i d = u . i d
W H E R E m . E m a i l = @ e m a i l A N D u . a p p l i c a t i o n I d = @ a p p I d %G e t U s e r N a m e B y E m a i l �5S E L E C T P a s s w o r d A n s w e r ,
P a s s w o r d K e y , P a s s w o r d F o r m a t , I s L o c k e d O u t
F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E u s e r I d = @ u s e r I d P a s s w o r d F o r m a t �GU P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T P a s s w o r d = @ p a s s , L a s t P a s s w o r d C h a n g e d D a t e = @ l a s t P a s s C h a n g e
W H E R E u s e r I d = @ u s e r I d @ l a s t P a s s C h a n g e R e s e t P a s s w o r d �U P D A T E m y _ a s p n e t _ m e m b e r s h i p m , m y _ a s p n e t _ u s e r s u
S E T m . E m a i l = @ e m a i l , m . C o m m e n t = @ c o m m e n t , m . I s A p p r o v e d = @ i s A p p r o v e d ,
m . L a s t L o g i n D a t e = @ l a s t L o g i n D a t e , u . l a s t A c t i v i t y D a t e = @ l a s t A c t i v i t y D a t e ,
m . L a s t A c t i v i t y D a t e = @ l a s t A c t i v i t y D a t e
W H E R E m . u s e r I d = u . i d A N D u . n a m e L I K E @ n a m e A N D u . a p p l i c a t i o n I d = @ a p p I d
@ E m a i l @ C o m m e n t U p d a t e U s e r �#S E L E C T P a s s w o r d , P a s s w o r d K e y , P a s s w o r d F o r m a t , I s A p p r o v e d ,
I s l o c k e d o u t F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E u s e r I d = @ u s e r I d �1U P D A T E m y _ a s p n e t _ m e m b e r s h i p m , m y _ a s p n e t _ u s e r s u
S E T m . L a s t L o g i n D a t e = @ l a s t L o g i n D a t e , u . l a s t A c t i v i t y D a t e = @ d a t e ,
m . L a s t A c t i v i t y D a t e = @ d a t e
W H E R E m . u s e r I d = @ u s e r i d A N D u . i d = @ u s e r i d @ u s e r i d V a l i d a t e U s e r ��S E L E C T i d F R O M m y _ a s p n e t _ u s e r s W H E R E n a m e = @ n a m e A N D a p p l i c a t i o n I d = @ a p p I d sA n e x c e p t i o n o c c u r r e d c o m m u n i c a t i n g w i t h t h e d a t a s o u r c e . E m a i l !P a s s w o r d Q u e s t i o n C o m m e n t I s A p p r o v e d C r e a t i o n D a t e L a s t L o g i n D a t e /L a s t P a s s w o r d C h a n g e d D a t e #L a s t L o c k e d o u t D a t e ��S E L E C T F a i l e d P a s s w o r d A t t e m p t C o u n t ,
F a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t , F a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t ,
F a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t F R O M m y _ a s p n e t _ m e m b e r s h i p
W H E R E u s e r I d = @ u s e r I d ��U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A t t e m p t C o u n t = @ c o u n t ,
F a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t = @ w i n d o w S t a r t
W H E R E u s e r I d = @ u s e r I d ��U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t = @ c o u n t ,
F a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t = @ w i n d o w S t a r t
W H E R E u s e r I d = @ u s e r I d
@ c o u n t @ w i n d o w S t a r t �+U P D A T E m y _ a s p n e t _ m e m b e r s h i p S E T I s L o c k e d O u t = @ i s L o c k e d O u t ,
L a s t L o c k e d O u t D a t e = @ l a s t L o c k e d O u t D a t e W H E R E u s e r I d = @ u s e r I d ��U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A t t e m p t C o u n t = @ c o u n t W H E R E u s e r I d = @ u s e r I d �EU P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t = @ c o u n t
W H E R E u s e r I d = @ u s e r I d ?U n a b l e t o u p d a t e f a i l u r e c o u n t . %U p d a t e F a i l u r e C o u n t ��S E L E C T P a s s w o r d K e y , P a s s w o r d F o r m a t F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E
u s e r I d = @ u s e r I d �sS E L E C T S Q L _ C A L C _ F O U N D _ R O W S u . n a m e , m . * F R O M m y _ a s p n e t _ u s e r s u
J O I N m y _ a s p n e t _ m e m b e r s h i p m O N m . u s e r I d = u . i d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d - A N D u . n a m e L I K E @ n a m e 1 A N D m . E m a i l L I K E @ e m a i l A O R D E R B Y u . i d A S C L I M I T { 0 } , { 1 } G e t U s e r s eA n e x c e p t i o n o c c u r r e d . P l e a s e c h e c k t h e E v e n t L o g . 'M y S Q L R o l e p r o v i d e r r o l e n a m e s u s e r n a m e s wI N S E R T I N T O m y _ a s p n e t _ u s e r s i n r o l e s V A L U E S ( @ u s e r I d , @ r o l e I d ) @ r o l e I d A d d U s e r s T o R o l e s oI N S E R T I N T O m y _ a s p n e t _ r o l e s V a l u e s ( N U L L , @ a p p I d , @ n a m e ) C r e a t e R o l e �D E L E T E u i r F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r J O I N
m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E r . n a m e L I K E @ r o l e n a m e A N D r . a p p l i c a t i o n I d = @ a p p I d @ r o l e n a m e ��D E L E T E F R O M m y _ a s p n e t _ r o l e s W H E R E n a m e = @ r o l e n a m e
A N D a p p l i c a t i o n I d = @ a p p I d D e l e t e R o l e �kS E L E C T u . n a m e F R O M m y _ a s p n e t _ u s e r s u J O I N
m y _ a s p n e t _ u s e r s i n r o l e s u i r O N u i r . u s e r I d = u . i d A N D u i r . r o l e I d = @ r o l e I d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d G e t U s e r s I n R o l e �iS E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r
J O I N m y _ a s p n e t _ u s e r s u O N u i r . u s e r I d = u . i d
J O I N m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d A N D
u . n a m e = @ u s e r N a m e A N D r . n a m e = @ r o l e N a m e @ r o l e N a m e I s U s e r I n R o l e ��D E L E T E u i r F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r
J O I N m y _ a s p n e t _ u s e r s u O N u i r . u s e r I d = u . i d
J O I N m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E u . n a m e L I K E @ u s e r n a m e A N D r . n a m e L I K E @ r o l e n a m e
A N D u . a p p l i c a t i o n I d = @ a p p I d A N D r . a p p l i c a t i o n I d = @ a p p I d @ u s e r n a m e )R e m o v e U s e r s F r o m R o l e s ��S E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ r o l e s W H E R E a p p l i c a t i o n I d = @ a p p I d
A N D n a m e L I K E @ n a m e R o l e E x i s t s ��S E L E C T u . n a m e F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r
J O I N m y _ a s p n e t _ u s e r s u O N u i r . u s e r I d = u . i d
J O I N m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E r . n a m e L I K E @ r o l e n a m e A N D
u . n a m e L I K E @ u s e r n a m e A N D
u . a p p l i c a t i o n I d = @ a p p I d F i n d U s e r s I n R o l e oD E L E T E F R O M m y _ a s p n e t _ u s e r s i n r o l e s W H E R E u s e r I d = @ u s e r I d KS E L E C T r . n a m e F R O M m y _ a s p n e t _ r o l e s r ��J O I N m y _ a s p n e t _ u s e r s i n r o l e s u i r O N u i r . r o l e I d = r . i d A N D u i r . u s e r I d = ; W H E R E r . a p p l i c a t i o n I d = @ a p p I d %G e t R o l e s B y U s e r N a m e ��S E L E C T i d F R O M m y _ a s p n e t _ u s e r s W H E R E n a m e = @ n a m e A N D a p p l i c a t i o n I d = @ a p p I d ��S E L E C T i d F R O M m y _ a s p n e t _ r o l e s W H E R E n a m e = @ n a m e A N D a p p l i c a t i o n I d = @ a p p I d M o n o . R u n t i m e mS E L E C T i d F R O M m y _ a s p n e t _ a p p l i c a t i o n s W H E R E n a m e = @ n a m e ��I N S E R T I N T O m y _ a s p n e t _ a p p l i c a t i o n s V A L U E S ( N U L L , @ a p p N a m e , @ a p p D e s c ) @ a p p N a m e @ a p p D e s c ���pA�B��}��� A �� �E �� ] ] m �� �� Yeqeeu Y q
��ie ee e e y �� e��YuYu �� �� �� �� �� �� �� �� ����
����Yu Y��u ��
Yu �� Y ��u �� �� Yq���� ����u�� �� �� ���� ������ � �� ����
��� Yu qyu Y��Yq ��Y���� ��Y��u �� �a �a YY�� �� �� � � ��
�� ���� Y������ q�� ���%�� �� �� �� Y����
����] �� ��Y�� ����
]Y����� � �� �5 �
� �� �� �Y
�� �
� � �� �M �Y�Y � � �����]� �
�] � � � Y����q������ ���� �� ���� ��Y���� ���� �� �� �� ���%q���%�� �����e
�� �m
���%q���%�� ������ �� q
��q � � �� ��
�� ����9� �9 ����9 �M
�Q�U �� �� ���Y�]��]
�]�� �e �] �e �� �� �]�]�Y�a�]���]] �a �] ��
�Y�a�e�]�Y�Y���]] �]�Y�a�]�]���]]�e�]���]] ���� �m,�qY�mu �q �� Y�mu�q���Y
u�u �uYu������Yu ���� Yq�mu q��
Y�uu �u �Y���uq�uuYu Y�q���mq u Yu Yq�m��u �����������
���������� �� �� ��
�Y�Y������qu ��
q �}Y��q�}u �u Y���
��
Y��� Y ��Yq �� Y��
Y���u
���%Y����Yq u��q �� ��z\V4��hȉi�M�?_�
:1�8V�6N5�� $ � � $ RSA1 �s�� qu,x)A&�JA��C�q�_��<�_e�� ��Z�@gюz��F}zQ��$�q�(�����X
� ��i $��[���J�NP �c��� O�\���N�ec�2 n���8b1A��
l�k>�
��.System.Security.Permissions.PermissionSetAttribute, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089TName FullTrustY eie��8�����������m
< Y
0q e u �� �� ������ �� �� �� �� �� ���� ������ �� �� �� ���� �� Y
m
Y
�� �� ���� �� ������
���� ������ ���� ��� �� Y �� � �%�)�- �)�- �1 �1
�) ��
�1
�% �%�� �� <�� ��
����
��
��
��
Y��
��
��
�� �Q �u �y �}
�} Y �uq �m �m Y �m Y�m �}
Y
Y( Y( ( (
�� �� ( ( �m TWrapNonExceptionThrows
6.9.9
en-US MySql.Web ADO.Net driver for MySQL Oracle P KCopyright © 2004, 2015, Oracle and/or its affiliates. All rights reserved. $ ..\..\ConnectorNetPublicKey.snk G .NETFramework,Version=v4.0 TFrameworkDisplayName.NET Framework 4@ 3System.Resources.Tools.StronglyTypedResourceBuilder4.0.0.0 �D ��� � lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet I PADPADPZ:X�;Da�� ���x��Y���c���$���N��OؙrK�E)�=���U¤�ɤ�ɤ�ɤ�ɤ�ɤ�ɤ�ɤ�ɤ�ɤ #V�<Y�U�
�� �����
� �3˗��ΐ��ZV�ֶG��l�����F�� %� ��;��+�G��핢��;A���n[xp�^m�_�
�^����s �3y���0"���%�V�&��='@�`*N�s*�Q:���<��=��=>��Q�:�Q"x�Q���T�GdW=ÿY��c���eyjsU)t��� 1 ;
. � �
� �
|
c 5 H [ n � " � � Z �
x � � � � U : � u � Q
� �
� � Q � 9 � � x � � 8 � � " � � ` i � � S � � I � � � � � D � � 4C a n n o t D e l e t e A P o p u l a t e d R o l e :C a n n o t R e t r i e v e H a s h e d P a s s w o r d s ! .C a n n o t U n e n c o d e H a s h e d P w d z ,C h a n g e P a s s w o r d C a n c e l e d � (C l e a r P a s s T o k e n F a i l e d � C r e a t e R o l e F a i l e d 0D e l e t e O A u t h A c c o u n t F a i l e d Z :E r r o r I n i t O f M e m b e r s h i p P r o v i d e r � .E r r o r I n i t O f R o l e P r o v i d e r � 0E r r o r I n i t P r o f i l e P r o v i d e r 5 ,E r r o r R e s e t t i n g P a s s w o r d p FG e n e r a t e P a s s V e r i f i c a t i o n T o k e n F a i l e d � I l l e g a l R o l e N a m e � I l l e g a l U s e r N a m e .I n c o r r e c t P a s s w o r d A n s w e r @ I n v a l i d A r g u m e n t \ "I n v a l i d A r r a y V a l u e � 6I n v a l i d C h a r a c t e r s I n U s e r N a m e � I n v a l i d U s e r (M i s s i n g O r W r o n g S c h e m a 4 ,M o n o D o e s N o t S u p p o r t H a s h r 6N e w P a s s w o r d V a l i d a t i o n F a i l e d � N o C o n n S t r i n g :N o t E n o u g h N o n A l p h a N u m e r i c I n P w d = *P a s s w o r d A n s w e r I n v a l i d � 0P a s s w o r d E x c e e d s M a x L e n g t h � 4P a s s w o r d F o r m a t N o t S u p p o r t e d � *P a s s w o r d N o t L o n g E n o u g h .P a s s w o r d Q u e s t i o n I n v a l i d F 0P a s s w o r d R e q u i r e d F o r R e s e t n :P a s s w o r d R e s e t C a n c e l e d N o t V a l i d � .P a s s w o r d R e s e t N o t E n a b l e d � 6P a s s w o r d R e t r i e v a l N o t E n a b l e d � 2P r e v i o u s P r o v i d e r E x c e p t i o n &P r o f i l e U p d a t e F a i l e d � "R o l e A l r e a d y E x i s t s � R o l e I n U s e � *R o l e N a m e A l r e a d y E x i s t s � R o l e N a m e N o t F o u n d S a v e T o k e n F a i l e d DS i m p l e M e m b e r s h i p A l r e a d y I n i t i a l i z e d L <S i m p l e M e m b e r s h i p N o t I n i t i a l i z e d � 8S i m p l e R o l e A l r e a d y I n i t i a l i z e d � <S i t e M a p C o n n e c t i o n S t r i n g M i s s i n g 2U n a b l e T o C r e a t e A p p l i c a t i o n \ $U n a b l e T o C r e a t e U s e r { &U n a b l e T o L o c k O u t U s e r � 6U n a b l e T o R e t r i e v e P r o f i l e D a t a � 4U n a b l e T o U p d a t e F a i l u r e C o u n t � 2U n s u p p o r t e d P a s s w o r d F o r m a t #
"U p d a t e T o k e n F a i l e d A
"U s e r A l r e a d y E x i s t s y
4U s e r I d C o l u m n N o t I n i t i a l i z e d �
&U s e r I s A l r e a d y I n R o l e �
U s e r I s L o c k e d O u t �
8U s e r N a m e C o l u m n N o t I n i t i a l i z e d U s e r N o t F o u n d 3 U s e r N o t I n R o l e V 4U s e r T a b l e N a m e N o t I n i t i l i z e d i "U s e r T a b l e N o t F o u n d � U s e r n a m e N o t F o u n d 0V a l i d a t e P a s s w o r d C a n c e l e d 0 s c h e m a 1 _ s c h e m a 1 0 s c h e m a 1 1 s c h e m a 2 � s c h e m a 3 � s c h e m a 4 �+ s c h e m a 5 �, s c h e m a 6 0 s c h e m a 7 �0 s c h e m a 8 3 s c h e m a 9 �3 Cannot delete a populated role.WSetting EnablePasswordRetrieval to true when PasswordFormat is Hashed is not supported."Cannot unencode a hashed password.'Change password operation was canceled.TFailed to clear the token for the userid {0} in the table {1} after password update.;An unexpected error occurred while creating the role '{0}'.cFailed to delete OAuth Account, combination of provider '{0}' and provider user id '{1}' not found.<There was an error during membership provider initilization.6There was an error during role provider initilization.9There was an error during profile provider initilization.*There was an error resetting the password.TFailed to generates the PasswordVerificationToken, update not performed to Database.%Role names must not be null or empty.%User names must not be null or empty.Incorrect password answer.>Please provide a valid value: value provided is null or empty.NSome of the values in the arrays received are null or empty, please verify it. Invalid characters in user name.$User {0} not found in the table {1}.<Unable to initialize provider. Missing or incorrect schema.\The mono runtime did not support hashed passwords. Please use clear or encrypted passwords.@Change password canceled due to New password validation failure.)There is no connection string configured.QNon alpha numeric characters in '{0}' needs to be greater than or equal to '{1}'.$Password answer supplied is invalid.(Password exceeds maximum length allowed. Password format not supported.DThe length of parameter '{0}' needs to be greater or equal to '{1}'.&Password question supplied is invalid.,Password answer required for password reset.;Reset password canceled due to password validation failure. Password Reset is not enabled. Password Retrieval Not Enabled.vMySqlSimpleMembershipProvider is already initialized and its schema does not match the MySqlMembershipProvider schema.Profile update failed. The role '{0}' already exists.The role '{0}' is in use.Role name already exists.Role name not found.4Failed to save the request token secret value '{0}'.9The MySqlSimpleMembershipProvider is already initialized.ZThe membership provider was not initialized, it must be initialized before start using it.3The MySqlSimpleRoleProvider is already initialized.BThe connection string name is missing for the MySqlSiteMapProvider Unable to create application.Unable to create user.Unable to lock out user..Unable to retrieve profile data from database.DUnable to update failure count. Membership database may be corrupt. Unsupported password format.6Failed to update the request token secret value '{0}'.User {0} already exists./UserIdColumn configuration was not initialized.User is already in role. The supplied user is locked out.1UserNameColumn configuration was not initialized.!User not found int the table {0}.User not in role.0UserTableName configuration was not initialized.~Unable to find the table users {0}. Please create it or initialize the MySqlSimpleMembershipProvider with 'createTables=true'.Username not found.-The validate password operation was canceled.�CREATE TABLE mysql_Membership(`PKID` varchar(36) NOT NULL,
Username varchar(255) NOT NULL,
ApplicationName varchar(255) NOT NULL,
Email varchar(128) NOT NULL,
Comment varchar(255) default NULL,
Password varchar(128) NOT NULL,
PasswordQuestion varchar(255) default NULL,
PasswordAnswer varchar(255) default NULL,
IsApproved tinyint(1) default NULL,
LastActivityDate datetime default NULL,
LastLoginDate datetime default NULL,
LastPasswordChangedDate datetime default NULL,
CreationDate datetime default NULL,
IsOnline tinyint(1) default NULL,
IsLockedOut tinyint(1) default NULL,
LastLockedOutDate datetime default NULL,
FailedPasswordAttemptCount int(10) unsigned default NULL,
FailedPasswordAttemptWindowStart datetime default NULL,
FailedPasswordAnswerAttemptCount int(10) unsigned default NULL,
FailedPasswordAnswerAttemptWindowStart datetime default NULL,
PRIMARY KEY (`PKID`)) DEFAULT CHARSET=latin1 COMMENT='1';
CREATE TABLE mysql_UsersInRoles(`Username` varchar(255) NOT NULL,
`Rolename` varchar(255) NOT NULL, `ApplicationName` varchar(255) NOT NULL,
KEY `Username` (`Username`,`Rolename`,`ApplicationName`)
) DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
CREATE TABLE mysql_Roles(`Rolename` varchar(255) NOT NULL,
`ApplicationName` varchar(255) NOT NULL,
KEY `Rolename` (`Rolename`,`ApplicationName`)
) DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
�CREATE TABLE my_aspnet_personalizationperuser(
id INT PRIMARY KEY AUTO_INCREMENT,
applicationId INT NOT NULL,
pathId VARCHAR(36) DEFAULT NULL,
userId INT,
pageSettings BLOB NOT NULL,
lastUpdatedDate DATETIME NOT NULL)DEFAULT CHARSET=latin1 ;
CREATE TABLE my_aspnet_personalizationallusers(
pathId VARCHAR(36) PRIMARY KEY,
pageSettings BLOB NOT NULL,
lastUpdatedDate DATETIME NOT NULL)DEFAULT CHARSET=latin1 ;
CREATE TABLE my_aspnet_paths
(
applicationId INT NOT NULL,
pathId VARCHAR(36) PRIMARY KEY,
path VARCHAR(256) NOT NULL,
loweredPath VARCHAR(256) NOT NULL
)DEFAULT CHARSET=latin1 ;
UPDATE my_aspnet_schemaversion SET version=10;� CREATE TABLE IF NOT EXISTS webpages_membership (
UserId int NOT NULL primary key,
CreateDate datetime NULL,
ConfirmationToken nvarchar(128) NULL,
IsConfirmed bit NULL DEFAULT 0,
LastPasswordFailureDate datetime NULL,
PasswordFailuresSinceLastSuccess int NOT NULL DEFAULT 0,
Password nvarchar(128) NOT NULL,
PasswordChangedDate datetime NULL,
PasswordSalt nvarchar(128) NOT NULL,
PasswordVerificationToken nvarchar(128) NULL,
PasswordVerificationTokenExpirationDate datetime NULL
);
CREATE TABLE IF NOT EXISTS webpages_OAuthMembership(
Provider nvarchar(30) NOT NULL,
ProviderUserId nvarchar(100) NOT NULL,
UserId int NOT NULL, primary key (Provider, ProviderUserId));
CREATE TABLE IF NOT EXISTS webpages_OAuthtoken (
Token nvarchar(100) not null primary key,
Secret nvarchar(100) not null);
CREATE TABLE IF NOT EXISTS webpages_Roles(
RoleId int auto_increment NOT NULL primary key,
RoleName varchar(256) NOT NULL);
CREATE TABLE IF NOT EXISTS webpages_UsersInRoles(
UserId int NOT NULL,
RoleId int NOT NULL,
primary key(UserId, RoleId),
CONSTRAINT fk_RoleId FOREIGN KEY(RoleId) REFERENCES webpages_Roles (RoleId));� ALTER TABLE mysql_Membership
ADD PasswordKey char(32) AFTER Password,
ADD PasswordFormat tinyint AFTER PasswordKey,
CHANGE Email Email VARCHAR(128), COMMENT='2';
� /* Provider schema block -- version 3 */
/* create our application and user tables */
create table my_aspnet_applications(id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(256), description VARCHAR(256));
create table my_aspnet_users(id INT PRIMARY KEY AUTO_INCREMENT,
applicationId INT NOT NULL, name VARCHAR(256) NOT NULL,
isAnonymous TINYINT(1) NOT NULL DEFAULT 1, lastActivityDate DATETIME);
create table my_aspnet_profiles(userId INT PRIMARY KEY, valueindex longtext, stringdata longtext, binarydata longblob, lastUpdatedDate timestamp);
create table my_aspnet_schemaversion(version INT);
insert into my_aspnet_schemaversion VALUES (3);
/* now we need to migrate all applications into our apps table */
insert into my_aspnet_applications (name) select ApplicationName from mysql_Membership UNION select ApplicationName from mysql_UsersInRoles;
/* now we make our changes to the existing tables */
alter table mysql_Membership
rename to my_aspnet_membership,
drop primary key,
drop column pkid,
drop column IsOnline,
add column userId INT FIRST,
add column applicationId INT AFTER userId;
alter table mysql_Roles
rename to my_aspnet_roles,
drop key Rolename,
add column id INT PRIMARY KEY AUTO_INCREMENT FIRST,
add column applicationId INT NOT NULL AFTER id;
alter table mysql_UsersInRoles
drop key Username,
rename to my_aspnet_usersinroles,
add column userId INT FIRST,
add column roleId INT AFTER userId,
add column applicationId INT AFTER roleId;
ALTER TABLE my_aspnet_membership CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_roles CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_usersinroles CONVERT TO CHARACTER SET DEFAULT;
/* these next lines set the application Id on our tables appropriately */
update my_aspnet_membership m, my_aspnet_applications a set m.applicationId = a.id where a.name=m.ApplicationName;
update my_aspnet_roles r, my_aspnet_applications a set r.applicationId = a.id where a.name=r.ApplicationName;
update my_aspnet_usersinroles u, my_aspnet_applications a set u.applicationId = a.id where a.name=u.ApplicationName;
/* now merge our usernames into our users table */
insert into my_aspnet_users (applicationId, name)
select applicationId, Username from my_aspnet_membership
UNION select applicationId, Username from my_aspnet_usersinroles;
/* now set the user ids in our tables accordingly */
update my_aspnet_membership m, my_aspnet_users u set m.userId = u.id where u.name=m.Username AND u.applicationId=m.applicationId;
update my_aspnet_usersinroles r, my_aspnet_users u set r.userId = u.id where u.name=r.Username AND u.applicationId=r.applicationId;
/* now update the isanonymous and last activity date fields for the users */
update my_aspnet_users u, my_aspnet_membership m
set u.isAnonymous=0, u.lastActivityDate=m.LastActivityDate
where u.name = m.Username;
/* make final changes to our tables */
alter table my_aspnet_membership
drop column Username,
drop column ApplicationName,
drop column applicationId,
add primary key (userId);
/* next we set our role id values appropriately */
update my_aspnet_usersinroles u, my_aspnet_roles r set u.roleId = r.id where u.Rolename = r.Rolename and r.applicationId=u.applicationId;
/* now we make the final changes to our roles tables */
alter table my_aspnet_roles
drop column ApplicationName,
change column Rolename name VARCHAR(255) NOT NULL;
alter table my_aspnet_usersinroles
drop column ApplicationName,
drop column applicationId,
drop column Username,
drop column Rolename,
add primary key (userId, roleId);
�ALTER TABLE my_aspnet_membership CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_roles CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_usersinroles CONVERT TO CHARACTER SET DEFAULT;
UPDATE my_aspnet_schemaversion SET version=4 WHERE version=3;
�CREATE TABLE my_aspnet_sessions
(
SessionId varchar(191) NOT NULL,
ApplicationId int NOT NULL,
Created datetime NOT NULL,
Expires datetime NOT NULL,
LockDate datetime NOT NULL,
LockId int NOT NULL,
Timeout int NOT NULL,
Locked tinyint(1) NOT NULL,
SessionItems BLOB,
Flags int NOT NULL,
primary key (SessionId,ApplicationId)
) DEFAULT CHARSET=latin1;
/*
Cleaning up timed out sessions.
In 5.1 events provide a support for periodic jobs.
In older version we need a do-it-yourself event.
*/
CREATE TABLE my_aspnet_sessioncleanup
(
LastRun datetime NOT NULL,
IntervalMinutes int NOT NULL
);
INSERT INTO my_aspnet_sessioncleanup(LastRun,IntervalMinutes) values(NOW(), 10);
UPDATE my_aspnet_schemaversion SET version=5;
�ALTER TABLE my_aspnet_sessions CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_sessions MODIFY SessionItems LONGBLOB;
UPDATE my_aspnet_schemaversion SET version=6;
�RENAME TABLE my_aspnet_Applications TO my_aspnet_applications;
RENAME TABLE my_aspnet_Membership TO my_aspnet_membership;
RENAME TABLE my_aspnet_Profiles TO my_aspnet_profiles;
RENAME TABLE my_aspnet_Roles TO my_aspnet_roles;
RENAME TABLE my_aspnet_SchemaVersion TO my_aspnet_schemaversion;
RENAME TABLE my_aspnet_SessionCleanup TO my_aspnet_sessioncleanup;
RENAME TABLE my_aspnet_Sessions TO my_aspnet_sessions;
RENAME TABLE my_aspnet_Users TO my_aspnet_users;
RENAME TABLE my_aspnet_UsersInRoles TO my_aspnet_usersinroles;
UPDATE my_aspnet_schemaversion SET version=7;�DELETE FROM my_aspnet_sessioncleanup;
ALTER TABLE my_aspnet_sessioncleanup ADD ApplicationId INT NOT NULL;
ALTER TABLE my_aspnet_sessioncleanup ADD Primary Key (ApplicationId);
UPDATE my_aspnet_schemaversion SET version=8;�
create table my_aspnet_sitemap(
Id int auto_increment primary key,
Title varchar( 50 ),
Description varchar( 512 ),
Url varchar( 512 ),
Roles varchar( 1000 ),
ParentId int default null
) engine=Innodb;
UPDATE my_aspnet_schemaversion SET version=9; � �}QP�K� �o!y&Q��V��|�n$�U�- -� �|-� �R��� �|c�"�ٮ� ��^b; � �Ac�q��]!���8��>,��X��� Lx
f/�4薒�.��=���0� <��si�Ո� 2"dW ! RSDS`a)�/�M���]Un E:\Jenkins\jobs\Connector Net 6.9-release Build\workspace\Source\MySql.Web\obj\NET40_Only\MySql.Web.NET40.pdb H" b" T" _CorDllMain mscoree.dll �% � 0 � H X@ � �4 V S _ V E R S I O N _ I N F O �� ? D V a r F i l e I n f o $ T r a n s l a t i o n �@ S t r i n g F i l e I n f o 0 0 0 0 0 4 b 0 J C o m m e n t s A D O . N e t d r i v e r f o r M y S Q L . C o m p a n y N a m e O r a c l e <
F i l e D e s c r i p t i o n M y S q l . W e b 0 F i l e V e r s i o n 6 . 9 . 9 . 0 H I n t e r n a l N a m e M y S q l . W e b . N E T 4 0 . d l l � K L e g a l C o p y r i g h t C o p y r i g h t � 2 0 0 4 , 2 0 1 5 , O r a c l e a n d / o r i t s a f f i l i a t e s . A l l r i g h t s r e s e r v e d . * L e g a l T r a d e m a r k s P O r i g i n a l F i l e n a m e M y S q l . W e b . N E T 4 0 . d l l 4
P r o d u c t N a m e M y S q l . W e b 0 P r o d u c t V e r s i o n 6 . 9 . 9 8 A s s e m b l y V e r s i o n 6 . 9 . 9 . 0 t2