| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/MySQL/Connector NET 6.8.3/Assemblies/v4.0/ |
Upload File : |
MZ @ !L!This program cannot be run in DOS mode.
$ PE L ڰR ! A @ O ` T H .text `.rsrc ` @ @.reloc @ B H 8 P >íqD^,F&<tzn{9Gqł=ĨdicA%(0WheI!SrWm3
pGgյbJШ2' [ioH}@˿5ugZ2{ o
*6{ o
*2{ o
*6{ o
*2{ o
*6{ o
* { *"} * { * 0 H } { t o
{ t
o
o
,{ o
o
o
*2{ o
*J{ t o!
*2{ o"
*2{ o#
*6{ o$
*2{ o%
*s&
*N{ o'
s *2{ o(
*2{ o)
*2{ o*
* 0 6 s
{ } { } { o+
t } * o(
*^(-
s.
o +* o)
*^(-
s0
o +* o*
*^(-
s1
o2
*f} s3
} (4
*(6
} } { { } *2{ o7
*2{ o8
*2{ o9
*2{ o:
*2{ o;
*:o<
o=
*"o=
*J(>
{ o?
*6o=
*6{ o@
*N{ oA
*6{ oB
*N{ oC
*{ ,{ oD
*{ oE
*6{ oF
*6{ oG
*6{ oH
*2{ oI
*{ ,{ oJ
*{ oK
*6{ oL
*6{ oM
*6{ oN
*6{ oO
*6{ oP
*6{ oQ
*6{ o<
*2{ oR
*6{ oS
* 0 N { o=
{ ,7u -/oT
{ oJ
(U
,{ oJ
(<
* 0 u ,I& (V
(W
,t sX
& *и (V
(W
,t
1 *u" ,#л (V
(W
," sY
*(Z
([
* 0
+o=
X
i2i*6{ o\
*2{ o]
*2{ o^
*r(>
, { o_
(`
*r~ oa
/ r p(b
** 0 sc
oC od
*0 X r
p
oe
+-of
t og
&r pog
&oC r p
oh
-u
, oi
*
9F ' " ` ^ %И (j
* (k
* (G *:(G (L * { *"} * { *"} * {
*"}
*(N (P -*{ , { o
{
, {
o
** 0 i (M , r pog
&oR (M , r pog
&(K -*u -(M , u -r# p(K (B ol
&* 0 { oT
-
{
oT
*:(I (P *{ ,r3 p{ ol
&+r? p{ (B ol
&(S *sm
z 0 K { oC rG p{ ol
&{
oC { ,rS pog
&{ oC *6{ oF * (I *V(k
} } *********, o { (n
, { o *{1 r p{ (b
r p{ (b
oo
}1 *B{ } **sm
z (G *0 { , { r] p(p
, ra pog
&{ , r pog
&{ oC { , r pog
&{ , { r] p(n
,rm pog
&+rG p{ ol
&{ , r pog
&{ oC { , r pog
&{ , { r] p(p
, r pog
&*{ oF { oF ob * (s *J(s sq
} * 0 { oC { , rw pog
&r pog
&{ or
+(s
ot
r pog
&(u
- oi
ov
Yow
r pog
&* 8 '_ 0 < { oF
+{ ox
oF X
{ oy
2oa *0 r pog
&
+Lr pog
&{ oz
oC r pog
&{ oz
oC r pog
&X
{ o{
2{! ,$r pog
&{! oC r pog
&r pog
&* 0 d
{! oF
+{ oz
oF X
{ o{
2 +{ oz
oF X { o{
2o] *vs|
} s|
} (G *V(G ( ( * {" *"}" * {# *"}# * {$ *"}$ * {% *"}% *n( (}
-( *( * {& *"}& * 0 (~ ,(~ oC +8( ,r p( (B ol
&r? p( (B ol
&( ,+( ( (p
,r# p( (B ol
&* 0 , ( ( s}
( o (~ o *( - s ( ( o * 0 t u -*u
o ,( ,o ( o~
*o ( (p
,*o ( (p
,*o ( (p
,**"oc *:(s }' *0 @ { -r
p+r pog
&r pog
&{' oC r pog
&*R{' oF o^ * 0 W {+ -{* + {* (B
r p{( -r
p+r po
&{) oC r pog
&*6{) oF * (G *{, oC r- p{ -r
p+rG pol
&*R{, oF o\ * (s *0 Y {- oC { , rw pog
&rO pog
&{. oC {/ ,r] pog
&{/ oC *R{- oF o_ * (s *J{0 s o
*6{0 o
* 0 7 {0 o
+(
oC (
- oi
* ( 0 )
+{0 oz
oF X
{0 o{
2*Js|
}0 (G *:(G }1 *:{1 og
&*"od *J(G s
( * {2 *"}2 *sm
z( o
,( ( o
Yo
** 0 + ( o
( X( o
YYo
*:( o
* 0 m
u -*u
( o
Y o o
Y
+2( %Y o
o %Y o
(
,* X%
.2/* 0 C s
( o
+(
o o
(
-
oi
* !3 sm
zV(G ( ( * {3 *"}3 * {4 *"}4 * 0 4 ( u
oC ro p( -ry p+r pol
&*6( oF *{ oC {5 -r p+r pog
&{
oC *{ u? o ,*{
u? o *sm
z (I *~
}6 }7 s
}8 s
}; (
s
( *n{; o
-*{; o
* {< *"}< *sm
z 0 ! r p%{7 %
X}7 (b
* 0 s
o o
o
* 0 %{9 X}9 o
o +u
o o
o
o
%{9 Y}9 {9 1*o s} o {8 o , oK o u ,*u?
u ,
o &+
, o &*0 o
sU o
r po
, o
,o
u s } +}o
o
} o
} o
r po
,o
,o
u } o
r po
,o
,o
u } *Zr po
(
s * 0 o
o +
u
op *0 o
o +s
op * 0 s
o * 0 o
o
t o
o
( ,s *3 o
-r
p+r ps *s&
( o
o
( o
o
o
( o
( o
o
s *zo
o
o
( o *bo
o
r po *bo
o
r po *6o
o +* 0 e o
u2 o
u
sw } +-o
o
u8 o
u
{ o
X o
o
2*sm
z0 M s
o
o +}- o
o +}. o
o
&.o
o +}/ * 0 s|
+>{ o
o
o +o
{ o
o
o +o
X o
o
2o
, o
uC -o
o +}! * 0 s
o
o +}, *s
z.r# ps * 0 o
636s
r- po o
o
o +o r po *~
o
. YE ,."+(r3 p +&r7 p + r; p +r? p +rC p +s
zo
o
o
o
o *0 ~ o
o
u
+Zo
o
o +
u , u +s} o o
o
o
o o o
X o
o
2*s
zs
zs
zs
zs
zs
zs
zs
zs
zsm
zs
zsm
zsm
zsm
zsm
zsm
zsm
zsm
zsm
zsm
zsm
zsm
zsm
zsm
z 0 , u?
u? ( -*{ u? (
*0 { u oK
oK { } { u oL { -{ } +8{ ,0sv { } { } r p} } { ( { -{ } { ( o -zo ,ro o
+(
o (
- oi
o o
+(
( (
- oi
o -|o ,to o
+ (
o (
- oi
o o
+
(
(
(
-
oi
{ - { } * 4 ' R p 0
,
o o
,*{ u?
,
{ u -*{ ,{ -ho ,o -Xo ,o -H{ ,{ -8{ { 3*o +o
o~ ,*X o
2**0 -*se
oF *0 w o +
u oL ( &u ,, u } u? ,(u? { u ,u? { u } ,
{8 o * 0 ? ! s
uE ( o
o
o +t } s } * 0 " u7
9 u8 9 s o
o
rG p(n
9 t8 o
(
o
o
o +}- @S r] p(n
9C o
o
u8 ,Eo
o
t8 r_ po
od
rm prq poo
(b
s }. *o
o
@$ o
o
u7 %
9 o
o
u7 %9 o
o
rw p(n
9 o
o
rw p(n
9 o
o
u8 9 o
o
t8 r po
od
rm prq poo
(b
s }. o
o
o +}- *:D r p(n
94 o
o
u8 9 o
o
t8 r po
od
rm prq poo
(b
s }. *o
o
r p(n
9 o
o
u7 9 o
o
r p(n
9 o
o
u8 ,vo
o
u8 t8
o
o
3Jo
o
o +}- r p
o
od
rm prq poo
(b
s }. ** 0 R # (
,*sv } o +} ( } o +} ( } * 0 $ { r p(n
9 { u
{ u -G{ u -*-"{ u
-* ( ,M*( ,<*-%{ u -*( ,*( ,**{ { o~
,){ { 3{ -{ { o
** 0 % { { @ { -{{ r] p(n
,i{ r] p(n
,W ( ,I,F( ,8,5o~
,,sw } { o
{ o
** 0 W & { -M{ r] p(n
,; ( ,-,*{ o~
, { o
- { o
**{ u Q{ u QP-{ u Q{ u Q* 0 ' o
.
+. .3** 0 X ( u
s o
o
o +o {8 r po u o o
o +o od
* ( * {= *"}= * 0 ) u
o
( o
r po
o
t (}
,do
r po
o
t
(}
,o
o
r po
o
t (}
,oD
r p(b
*( * ( * 0 s
> s
? s
@ s
A s
B ~> rI pr_ po
~> rc pry po
~> r} pr po
~> r pr po
~? r pr po
~? r pr po
~? r pr po
~? r pr# po
~? r5 pr? po
~? rS pra po
~? ry pr po
~@ r pr po
~@ r pr po
~@ r pr po
~@ r) pr7 po
~@ rO pr[ po
~@ rq pr po
~@ r pr po
~@ r pr po
~@ r pr po
~@ r' pr; po
~@ rg prw po
~@ r pr po
~@ r pr po
~A r pr po
~A r pr po
~A r pr! po
~A r7 prC po
~B rO prq po
~B r pr po
~B r pr po
~B r pr) po
~B rM prs po
~B r pr po
~B r pr po
~B r pr po
~B r pr! po
~B rE pre po
~B r pr po
~B r pr po
~B r pr
po
~B rC
prk
po
~B r
pr
po
* 0 }C ~> o
oD
o
,( *~? o
oD
o
,
~? ( *~@ o
oD
o
,
~@ ( *~A o
oD
o
,
~A ( *~B o
oD
o
,
~B ( *( * 0 * s
o
r p( +}* {* (}
,o
oD
}* o
rB p( +}+ o
rd p( + ,o
o
1 r ps
zs r
p
o
o
+7o
o
1 s o {C o +o r p
oh
- ,oi
}) * D 0 + sc
o
o
1'r3 po
%X o
{C o +ol
&r p~> o
oD
o
o
o
{C o +o
&od
s * 0 , o
o
+ o
o
{C o +X o
o
2o
oD
%
, r7 p(n
,
( +o
oD
o
(
s * 0 sc
~A o
oD
o
og
&r pog
&o
o
{C o +ot
&r pog
&o
o
1 o
o
{C o +ot
&+ r
pog
&r pog
&od
* (k
* 0 A - u
s o
o
o +t o {8 r po o o
o
+$o
t
o o
o +o
oh
- ,oi
{: - s
}: o
o
+[ o
t o
o +o o
o
&."o
t2 o
{: o
oh
- , oi
o
,o
o }u od
* N 1 h 0 ? . (
s o
o
t3 o
r po o
o
o
8 (
{: o
: ,s
z
o
o
o
t o
. . .
. 3r ps +Ho
o
o
oD
rB p(n
,&rL po
r po
o
(b
s r p(b
o o (
:# oi
} * D ( ( *:{D o
* 0 ~ / -*,
{D o
&u? ,u? { (
*u , u
{ (
{
(
*u , u { (
{
(
*J-*oK ( *v{D o
-*{D o
* 0 c 0
o o
2Qo o
Y +=o o
,)(
, oO , * u? , u? { *Y /*Js
}D (k
*n{H o
, {H o
** 0 8 1 u
o
o
o
-3o + ( od
*0 } 2
u? 9Z { u? 9H oK o o
?/ o o
9 o o
o %{ u? 9 o o
? o o
9 o o
o (
: o o
o~ 9 o o
o~ u? 9 o o
@s o o
o~ 9] { u?
9K { 9< o o
o~ u o o
@ o o
9 9 s
oL { u
- o o
o +
{ } o s} o
o r ps} r po s o o
o s} }) { }( {* }* o o
oQ oL o o
o u? } * 0 o
(
} *0 J o
o
o
o
o
o
(
o
(
o
o +} * 0 3 o
o
o
o
( {8 o
o o
( o
o
t
o
o
t o
o
+\o
o +o Xu ,.o r p (b
o o o
oh
- ,oi
8 o
o
u^ -s
zo
%Xo
o
s}
o
o
o +( o
o o
o
X o
o
?k* s i 0 4 o
o
r p(p
,s
zs
o
oD
}* o
oD
r p(n
,
r p}* +o
oD
o
}* o
}( }) *o
o
o
o
o
( * 0 5 o
o
o
o
( o
o
o
o
(
s u -{8 oQ {8 oQ } {8 oQ u? 9n u? o o
8
(
s { } { } ,#{ u? { oK oK ( { } o o
{8 oQ {8 { oK { o oK o s} o o o oK o {8 o o (}
, o oL o o {8 o
(
:
! oi
{8 { o
{8 o
* A , ~o
o
o
o
( *0 6 sZ
( } o
o
o
( } { ( } o
o
o
( }
{
( }
{
u? , {
u? oM , o
oL ,o +} * 0 . o ,*s
{8 oQ oP } * 0 Z u? -u ,{8 oQ oP +3u ,+,(s
} oK oL {8 oQ ** 0 d 7 s
s} o
o
, o
o
o +t o +r# ps o r po o o
*0 J o
o
o
o
o
o
(
o
(
o
uE ( * 0 B 8 (
u? ,u? *s u ,u {8 oQ } * 0 o
(
{8 oQ * 0 ~ 9 o
o
o
o
o
o
(
o
(
o
o
+$o
o
o +o
s o oh
-
,oi
* B 0r
0 1 o
(
o
(
o
o +} * 0 9 o
o
o
o
o
o
(
4(
o
o
+$o
o
o +o
s o oh
-
,oi
o
(
o
o +} * > 0n
0 4 : s
o
( o
( } }
*Js
}H ( * 0 & ; u
s }I o
o
o +o {8 r po u o {: - s
}: o!
o
+lo
t o o
o +o
o
o +o o
o
&.!o
t2 o
{: o
oh
- ,oi
o"
o +o }I o#
,o#
o } od
* f y 0 : ! (
s r po t o"
o +o } * 0 < sv
} o +} ( } { u ,{J t2 o
o$
o +} { u , {J o%
&( } * (k
*ro
{ u {1 (n
*0 v = s } {I ,W{: {J o&
| o
,9{ u ,,( -
s'
o(
, o
s *( *Js)
}J ( *so *"sP * 0 (*
s0 (+
(2 s,
(-
(2 s (.
s- (/
(2 ~K -* s0
K ~K (1
s7 (2
(2 ~L -+ s3
L ~L (4
* s5
* (k
*0 > o6
( +,v E B B B & < +@s,
*s- *so *s *s3 *s7 *s= < s8
s9
*s? **0 ? (.
,
*( +* (k
*r
p*r
p* (k
*.(2 (;
* (k
*6(<
o=
* (k
*(k
}N }O }P }Q *0 @ (>
,*u'
,(; ** 0 Y +
/Z{N o?
X
/Z{O o?
X
/Z{P o?
X
/Z{Q (@
,+ {Q o?
X
* 0 M {N {N (W
,8{O {O (A
,%{P {P (B
,{Q {Q (A
** 0 / A
u ,oC
oD
(2 (V
s8 * (k
* 0 sE
^ ~^ sG oF
~^ sJ oF
~^ sK oF
~^ N sI oF
~^ sL oF
~^ sM oF
* 0 @ B (G
~^ oH
oI
+(J
oE (K
-, oi
* 1 0 l C rJ
p(L
u
~^ oM
oN
-!rP
poM
oO
(P
s
zoD (Q
,r
p(b
(L
*0 ) D -*u
,~^ oM
oN
,**6~` (C *}b (k
}b }a oE * 0 k E # @%{c X% }c l(R
# ?Y# @[
{c {b 1
- *|a (S
(T
(U
sV
*"}c *R# N@(U
` *Z # Y@(U
(C *V%{c X}c (D * (B *6 ~` (C *6 ~` (C * (B * (B * 0 Q F (D
(Q
-* (W
(S
# $@4# (W
# $@(U
(X
sV
** (B *&(Y
*:(k
}\
* {\
* 0 7 sc
r pog
&{\
/ ot
&rA pog
&od
* 0 # G u.
,(]
{\
{\
o^
** 0 ! J{
)UUZ(]
{\
o_
X
* 0 H (`
o + (V
rG p(b
c
1 (d
t e
(f
t (g
h
1 (d
t (i
( +o
+&*:(l
}d *>sm
on
*6{d oo
*(p
* 0 I sq
or
*rK pos
,rK pr
poo
** 0 " J ot
(W ou
sv
(w
*ox
(W oy
oz
(W o{
(|
*no}
(W o~
(
*0 j K
o
,,o
(W o
o
o
to s
+ o
(W o
o
s
, (
*(
&*no
(W o
(
* 0 ] L o
(W s
o
o
+o
o
o
oh
-
,oi
o
o
(
* >
0 " M o
(W o
s
(
*ox
(W oy
oz
(W o{
(
*no
(W o
(
*no}
(W o~
(
*0 N o
(W s
(
*0 " O o
(W o
s
(
* 0 ( P o
(W o
o
s
(
*0 " Q o
(W o
s
(
* (
* {i *"}i * {j *"}j * {k *"}k * {l *"}l *6uk oy *6um o} *6un o *6uo o{ *6up o *6uq o *6ur oz *6us o *6ut o *6uu o *6uv o *6uw o *6ux o| *6uy o *6u o *6u~ or *6u ou *6u} (q * 0 R
s
}e s
}g (
{g rU p-
s
o
{g r{ p-
s o
{g r p-
s o
{g r p -
s
o
{g r p- s o
{g r+ p- s o
{g rU p- s o
{g r} p- s o
{g r p- s o
{g r p - s o
{g r p
- s
o
{g r) p - s o
{g rO p - s o
{g r{ p
- s
o
{g r p- s o
s
(l s
(n {g r p- s o
{g r p- s o
{g r p- s o
* 0 S s
s
}h (<
o
}f o
+Uo
{g oT
o6
o
-oT
o6
s
z{g oT
o6
o
o o
oh
- ,oi
{e o
19{e o
+(
o
(
-; oi
* - b 0 T - r ps
zs
sc
s# o
( +-*rC pr pol
&o
&o
&r po
&o
&r pr pol
&o
&r po
&r po
&o
&rC po
&r po
&r po
&o
o
+J o
o o (s rQ pr p(
o
&r po
&o
& oh
- , oi
r po
&r po
&r po
&o
&o
o
8
o
o
o
9 r+ po
r_ p(
o
&o
{h o
o
+7 o
o
ro po
-ro p(
o
& oh
- , oi
r po
&o
&
oh
:<
,
oi
rs po
&o
&r po
&o
&r pr pol
&o
&o
&rC pr pol
&o
&od
o
* ( W D d/ 0 V -*s
r
p s# o
o
8 o
o
E
" +(s +6s +.s( +&s# + s + o
od
s
z o o (s %o
r pr
poo
ro p(
o
oh
:M ,oi
* $ 0 W o
8 o
o
3+Po
rm po
od
rm p(
oo
Q+]o
3:Po
r po
t (
r7 pr
poo
(
oo
Q+Po
o
od
oo
Qoh
:\
,oi
*
0 X s
s
(<
o
}f r
p s#
o
8 o
o
E 5 $ F +Ss
o +Bs
o +1s(
o + s#
o +s
o %o
rK pr
poo
ro p(
o
oh
:L ,oi
o
* 2 0 Y s
(v o
* 0 s sc
r po
rK pr
poo
o
(w (P
o
&r po
&o
o
&r po
&od
r pr
poo
* 0 t Z sc
o
+4o
r po
-r- p+r3 po
(x o
&oh
-
,oi
od
od
r po
o
*
@M
0 [ ~ {f o
o
o
sc
og
& r; prE po
( +,0o
(
, rU po
(
ol
&o
(
,Eo
(
,4rc po
(
o
(
o
&od
*0 V Y -*ot
(j s
r pot
( ou
o
(P
r pou
o~ (
o
* 0 5 Y -*s
sc
&r po
( o
(P
o
* 0 \ -*o
sc
o
(j
r p o
( r- p o
rC p (
og
&o~ og
&s
od
o
*0 ] -*sc
rI po
( r po
r p(
og
&o
&
r p o
( rN p o
rd p o
rl p (
og
&o
&r pog
&o
&r pog
&o
&r pog
&s
od
o
*Fr pr p(
*Fr pr p(
*0 0 ] sc
r poz
( r po
( rF p(
og
&r pr po
~m - s
m ~m (
+(
r p(
og
&
rf p ox
( r p r po
~n - s
n ~n (
+(
r p (
og
&o
, r pog
&s
od
o
*0 ^ {f o
o
sc
~ o og
&r po
: o
о (V
(W
-$o
(V
(W
,>o
o
,1o
(
, rU po
(
ol
&o
(
,Jo
(
,9rc po
(
o
(
o
&8 r p(n
- r p(n
-r p(n
9 o
(
,Go
(
25rU po
(
1 +o
(
ol
&o
,yr p(
,r p(
-]r po
(
,o
(
/r
p+'rB po
(
(
r p(
ol
&o
(
-+(
-8rH p(m o
o
-o
-r
p+rd p(b
og
&o
,f rx pr pr pr pr po
( +,"r pog
&(k o
o
8 o
9 r p(
: sc
r p(i ( (b
o
& rZ p(i ( (b
o
& r po
& r po
(b
o
& r p(i ( (b
o
& r| p(i ( (b
o
& r p(i ( o
(P
o
& r po
& od
s
{e o o
o
(}
-ra po
(b
og
&od
* 0 2 _ sc
r{ poz
o
o
s
od
o
* (k
*^r prC p{ (
* 0 ` s sc
r pog
o
, r pog
&o
r po
&,od
r p(n
-ry p+r p} r po
o
( o
&r po
s
(
+(
r p(
og
&o
r; po
&,od
rE p(
0rQ p+r[ p
rg p (
og
&s
od
o
* 0 * Y s
ru po
( o
(P
o
* (k
*6(m o
*vr po
rC po~ (
*Fr pr p(
*%{ { (m o
,r
p+ r p(b
(
} *0 a
s } sc
o
( (m o
(k o
(g - s
(h (g o
- (g o
r pr p(
og
&o
(j o
,&o
o
( + -
s
o
r po
s
( +(
og
&o
,Yr pog
&r pr po
o
~o - s
o ~o (
+(
r p(
og
&r p} (k s
o
{ { r po
o
og
&r pog
&s
od
o
* 0 ) Y s
r] po
( r p(
o
*Fr pr p(
* 0 _ sc
r po}
( rw p(
og
&r po
rC p(
og
&o
o
1HrB pr po
~p - s
p ~p (
+(
r p(
og
&s
od
o
* 0 b sc
o
r p o
&,od
(
&,[o
o
3M
s
o
o
o
o}
s
o{ o
r p(
og
&s
od
r po}
r p(
o
* 0 7 _ -*sc
r po
o
o
&s
od
o
*
* 0 Y s
o
o
o
o
*rK pos
-
rK po
,rK pr
poo
** (k
* 0 3 c ~q (>
, rO p8 (V
o
s
q ~q *~r * r *V( r p~r o
*V( r p~r o
*V( r! p~r o
*V( r7! p~r o
* {s *"}s * {t *"}t *rg! pog
&( oC ( ,r! pog
&( oC *sm
z (G *v(G s|
( s|
( * {v *"}v * {w *"}w * {x *"}x * 0 {u , {u o o
1 r! pog
&r! pog
&( oC ( o{
1%r pog
&( (E r pog
&r! pog
&r pog
&( (E r pog
&{u ,r! pog
&{u oC *sm
z 0 d
YE
O ; O " +Mod
*
r! p(Z
(
* r! p(Z
(
*#
(Z
(!
** 0 I e o
t
o
YE
+** 0 e o
t
o
E " %
+&*** * * * * * *
* * * * * *r" po
(b
s
z0 Q f o
t
o
.* ("
(#
/ s$
" *" * 0 g
E +*** * 0 h %
9 ~ -U s%
%r] p(&
%r?" p(&
%r p(&
%rC" p(&
%rI" p(&
%rO" p(&
~ ('
,"E +** 0 '
03 .{
YE Z Z T Z * 6 Z H +X YE +
%. +<r] p*r?" p*r p*rC" p*rI" p*rO" p*rU" p*ru" p*r" p*r" p*r" ps(
z 0 B u , t o)
*u , t o*
*u , t o
*s
z 0 ) i o
o
, o
R *R * (k
*N( (+
} *.r" p( *rW# p(n
,( *r# p(n
,( *r# p(b
s,
z.r $ p( * 0 x j { (Z
(-
# @4 rA$ ps(
z#ffffff@4 r$ p( *# @4 r$ p( *#ffffff@4 r % p( *r?% p( *0 k - rs% ps
zo
oD
o.
(/
o0
-r% p(b
s1
z(/
o2
o
-(3
*o
3Bo4
r% po5
,$o6
- o7
,o7
(8
*(9
*(:
* 0 l - r
& ps
zo
u
-( (b
s1
zo4
o
E P 1 G ] s ' 8. (;
r & po2
(:
*(;
r'& po2
(:
*(;
rx po2
(:
*(;
r po2
(:
*(;
r po2
(:
*(;
r po2
(:
*(;
r9& po2
(:
*(;
rC& po2
(:
*(;
rQ& po2
(:
*
o4
r]& po5
, o6
-o7
,
o7
o4
rq& po5
, o6
-o7
,
o7
(;
r}& po2
(<
*r& po=
o7
,r& po=
o7
+r% po=
o6
- o7
,o7
+, + o7
~
/ r& p ++ / r& p + ?/ r& p +r& p (;
o2
(>
*~
r& po=
o7
,r& po=
o7
+ r& po=
o7
,r& po=
o7
+ r% po=
9 -r; p+r& p
o7
,Ao7
od
(?
,,
0#(;
o2
o7
(8
*o7
,4o7
od
r' p(n
, (;
o2
(8
*(;
o2
(9
* -rE p+r
' p
o7
,mo7
od
(?
,X
1
0 r ' p
+o7
1r5' p
(;
o2
o7
(8
*(;
r5' po2
(8
*(;
r po2
(:
*(;
r po2
(:
*(;
r po2
(:
*( o
(P
s(
z 0 m (@
oA
(B
* 0 n rG' p(b
(
sC
(D
* 0 * o (@
oA
sE
oF
oG
oH
*
* 0 p s
(}
-sI
o +fr' pr
poo
s5
oJ
oK
od
(L
(M
r' p(N
(O
sI
o
,oi
o (P
,r' psI
o o * 2 Fx
(k
* { *"} *.s * 0 q - r' ps
z
u ,s#
+>u ,s
+.u ,s(
+ u ,s
+u ,s
o s o
u ,u o o
(
u , u o
oQ
oR
8 oS
oT
(U
o
oV
(W
( o
,K oX
(U
oY
,4oZ
o
o[
( oV
o\
( o
o]
o^
&oh
:^ ,oi
o o_
+ (`
o]
o^
& (a
- Y oi
ob
* ` y$ u ,u ( *u ,
u ( * 0 r o
uU
,ro
o
o
u ,Woc
od
}
+/oc
oe
o
o
u { X
oc
od
2* 0 s of
9 of
o
t
o
o
og
$3Ut oc
od
}
+* oe
o
o
t { X
od
2*og
3 } { t *0 t u o
oh
si
oj
oh
s5
oJ
oK
(L
(M
r' p(N
(O
sI
( oK
o
(Z
(-
# @4 r' ps(
z #ffffff@4 r'( p= # @4 r/( p( #ffffff@4 r' pr7( p
,oi
* )
s *0 u - r?( ps
zu
-( r?( psk
zol
om
s
on
si
oo
oj
oh
op
oJ
rU( p(P
sq
or
&
, oi
* ? T
0 v - r?( ps
zu
-( r?( psk
zss
on
ot
oo
oj
oh
s5
oJ
r( p ou
,ov
ow
3
, oi
* T ?
0 w - r?( ps
zu
-( r?( psk
zss
on
ot
oo
oj
oh
s5
oJ
r( p(b
sx
(
,(
o
o(
&
, oi
* T :
0 x sc
r( po
&r) p(y
" (z
o
&( (P
,,+r' psI
( o +o|
8 o}
o~
( +o
+o
( og
&oh
- ,oi
o~
( +o
+o
o
( og
&oh
- ,oi
oh
:e ,oi
od
* ( } # ( ^ 0 y sc
sc
o
9u o
o
o
o
o
t o
o
o
o
o
t
oD
o
@1/r/) p(
& od
r7 pr
poo
(
r7) p{ oD
o
(P
o
&r) pog
&r
po
o
o
o
+e (
o
o
o
-)r) p{ oD
o
o
(P
o
&r) po
o
&r p (
- c oi
r po
&r
pr) p{ oD
o
(b
og
&o
o
o
o
+e
(
o
o
o
-)r) p{ oD
o
o
(P
o
&r) po
o
&r p
(
-
c oi
r po
&o
o
o
r* p
,
& od
+rU* prU* p(P
o
&o
&od
og
&od
* r^ r+ 0 z o
s
} { oD
o
,{ oD
o
+a{ oD
o
r po
o
t , o
r po
o
t +oD
o
{ oD
o
ri* ps
r* pol
&r
p
o)
o
+m(
r* p (
o
o
( o
o
o
( o
&r p
(
-c oi
r po
&o
&o
od
1vr* p(b
og
&r
p
o
o
+# (
r) p o
o
&r p
(
- oi
r po
&o
&{ o
> r+ po
&r + pru+ p(
(P
o
&r+ po
&{ o
8
(
o
o
,`r+ p(b
o
&r, p(b
o
&r, p(b
o
&r, p(P
o
&r<- p(b
o
&+rp- p(b
o
&
(
:i
oi
r- po
&r po
&o
&od
* ( zA 0 9 0 I o
oD
r- po
,o
o
r- p(
+r9& p(
-r p** 0 { sc
o
o4
o
o
o
oD
r- p(n
,Jo
o
oD
r- po
: r% po5
9 r- po7
ol
&8 o
o
o
oD
r- p(n
,c rq& po5
9 r]& po5
9 o7
,o7
+-rc po7
o
&+eo
o
o
oD
r- p(n
,D( s
(
,0 r]& po5
, o7
(
2r. po7
ol
& r". po5
,o7
- r4. pog
& rH. po5
9 o7
( o~
9 o
o
o
oD
rt. pos
,r|. pog
&8 o
o
o
oD
rB p(n
,{ o
o
8 ( s
(
,ao
o
o
oD
r- p(n
,@r p,o7
(
/r
p+rB po7
od
r p(
ol
&+ r. ps
zod
*
*Js
} (
*j(J s
( } * { *"} * { *"} * { *"} *( - s|
( ( o
*( - s
( ( o
*0 < (M , r pog
&r. pog
&{ , r. pog
&( (E { ,r
/ pog
&{ oC { ,r/ pog
&{ oC ( ,r./ pog
&( (E ( { -{ ,NrH/ pog
&{ ,rX/ p{ ol
&{ -rb/ pog
&+r? p{ ol
&(M ,,r pog
&(K ,r# p(K (B ol
&*( -*r/ pog
&( (E *(Q ( o
-( (K ,o
(K o * 0 = | { - s
} { (
{ u ,6{ u { o - { u { { o o
8 (
o o
oK o { o o
o
,&o ( o { o o
+{ o o
o
( o
(
:r! oi
{ u , , { u { { o * m 0 } o o
oK o { o o
o
,&o ( o { o o
+=o (}
-{ o o
o
+{ o o
o
( o
* 0 ~ s
u ,
u ( *u -u ,ku ,{ {; o
{ (
u , {
,{
( o
u 9 { {; o
&8 u? 9 u? o o
8 (
o o (}
- o + o s} { o 31 o o o o o ,9 o o +* o o o , o -
o o oK ,
oK o o
(
:>! oi
*sm
zoK (}
-QoK { oK (p
,9o
+(
oK o (
-! oi
* ~ # 0 | s
{ o
( o
+H o
oK o
s} o
o oK -{ +oK o o
oh
-
, oi
* Tp
0 9
o
} r) p (P
{ o
-*X
+ 0 g { -*( o
+2(
o~
,!o (}
, +o o (
-! oi
** ?U 0 '
0 .- ; 8 .C -./ 3YE 7 A 8 { -( o
**( o
*{ *{ *( o
-( -
( **( o
-( -( -
{ **s
zsm
zv(G s|
( s|
( * { *"} * { *"} * { *"} * { *"} * 0 h r/ pog
&( oC r/ pog
&r
p
+Bog
&( oz
oC r] pog
&( oz
oC r p
X ( o{
2( ,r! pog
&( oC { ,r! pog
&{ oC *sm
z lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet PADPADPcX T4fQ; O ~ JC o n n e c t i o n M u s t B e O f T y p e M y S q l C o n n e c t i o n *N o S t o r e T y p e F o r E d m T y p e V T y p e N o t S u p p o r t e d .W r o n g F u n c t i o n R e s u l t T y p e TThe connection parameter must reference an object of type MySql.Data.MySqlConnectionSThere is no store type corresponding to the EDM type '{0}' of primitive type '{1}'.8The underlying provider does not support the type '{0}'.TResult type of a function is expected to be a collection of RowType or PrimitiveType S <?xml version="1.0" encoding="utf-8"?>
<Mapping xmlns:cs="urn:schemas-microsoft-com:windows:storage:mapping:CS"
Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
<cs:EntityContainerMapping StorageEntityContainer="Schema" CdmEntityContainer="SchemaInformation">
<cs:EntitySetMapping Name="Tables" StoreEntitySet="STables" TypeName="Store.Table">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="CatalogName" ColumnName="Catalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="Schema" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="TableColumns" StoreEntitySet="STableColumns" TypeName="Store.Column">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="Ordinal" ColumnName="Ordinal" />
<cs:ScalarProperty Name="IsNullable" ColumnName="IsNullable" />
<cs:ComplexProperty Name="ColumnType">
<cs:ScalarProperty Name="TypeName" ColumnName="TypeName" />
<cs:ScalarProperty Name="MaxLength" ColumnName="MaxLength" />
<cs:ScalarProperty Name="DateTimePrecision" ColumnName="DateTimePrecision" />
<cs:ScalarProperty Name="Precision" ColumnName="Precision" />
<cs:ScalarProperty Name="Scale" ColumnName="Scale" />
<cs:ComplexProperty Name="Collation">
<cs:ScalarProperty Name="CatalogName" ColumnName="CollationCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CollationSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CollationName" />
</cs:ComplexProperty>
<cs:ComplexProperty Name="CharacterSet">
<cs:ScalarProperty Name="CatalogName" ColumnName="CharacterSetCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CharacterSetSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CharacterSetName" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsMultiSet" ColumnName="IsMultiSet" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsIdentity" ColumnName="IsIdentity" />
<cs:ScalarProperty Name="IsStoreGenerated" ColumnName="IsStoreGenerated" />
<cs:ScalarProperty Name="Default" ColumnName="Default" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="Views" StoreEntitySet="SViews" TypeName="Store.View">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="CatalogName" ColumnName="CatalogName" />
<cs:ScalarProperty Name="SchemaName" ColumnName="SchemaName" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="ViewDefinition" ColumnName="ViewDefinition" />
<cs:ScalarProperty Name="IsUpdatable" ColumnName="IsUpdatable" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="ViewColumns" StoreEntitySet="SViewColumns" TypeName="Store.Column">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="Ordinal" ColumnName="Ordinal" />
<cs:ScalarProperty Name="IsNullable" ColumnName="IsNullable" />
<cs:ComplexProperty Name="ColumnType">
<cs:ScalarProperty Name="TypeName" ColumnName="TypeName" />
<cs:ScalarProperty Name="MaxLength" ColumnName="MaxLength" />
<cs:ScalarProperty Name="Precision" ColumnName="Precision" />
<cs:ScalarProperty Name="DateTimePrecision" ColumnName="DateTimePrecision" />
<cs:ScalarProperty Name="Scale" ColumnName="Scale" />
<cs:ComplexProperty Name="Collation">
<cs:ScalarProperty Name="CatalogName" ColumnName="CollationCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CollationSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CollationName" />
</cs:ComplexProperty>
<cs:ComplexProperty Name="CharacterSet">
<cs:ScalarProperty Name="CatalogName" ColumnName="CharacterSetCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CharacterSetSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CharacterSetName" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsMultiSet" ColumnName="IsMultiSet" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsIdentity" ColumnName="IsIdentity" />
<cs:ScalarProperty Name="IsStoreGenerated" ColumnName="IsStoreGenerated" />
<cs:ScalarProperty Name="Default" ColumnName="Default" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="Functions" TypeName="Store.ScalarFunction" StoreEntitySet="SFunctions">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="CatalogName" ColumnName="CatalogName" />
<cs:ScalarProperty Name="SchemaName" ColumnName="SchemaName" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ComplexProperty Name="ReturnType">
<cs:ScalarProperty Name="TypeName" ColumnName="ReturnTypeName" />
<cs:ScalarProperty Name="MaxLength" ColumnName="ReturnMaxLength" />
<cs:ScalarProperty Name="Precision" ColumnName="ReturnPrecision" />
<cs:ScalarProperty Name="DateTimePrecision" ColumnName="ReturnDateTimePrecision" />
<cs:ScalarProperty Name="Scale" ColumnName="ReturnScale" />
<cs:ComplexProperty Name="Collation">
<cs:ScalarProperty Name="CatalogName" ColumnName="ReturnCollationCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="ReturnCollationSchema" />
<cs:ScalarProperty Name="Name" ColumnName="ReturnCollationName" />
</cs:ComplexProperty>
<cs:ComplexProperty Name="CharacterSet">
<cs:ScalarProperty Name="CatalogName" ColumnName="ReturnCharacterSetCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="ReturnCharacterSetSchema" />
<cs:ScalarProperty Name="Name" ColumnName="ReturnCharacterSetName" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsMultiSet" ColumnName="ReturnIsMultiSet" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsAggregate" ColumnName="IsAggregate" />
<cs:ScalarProperty Name="IsBuiltIn" ColumnName="IsBuiltIn" />
<cs:ScalarProperty Name="IsNiladic" ColumnName="IsNiladic" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="FunctionParameters" TypeName="Store.Parameter" StoreEntitySet="SFunctionParameters">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="Ordinal" ColumnName="Ordinal" />
<cs:ComplexProperty Name="ParameterType">
<cs:ScalarProperty Name="TypeName" ColumnName="TypeName" />
<cs:ScalarProperty Name="MaxLength" ColumnName="MaxLength" />
<cs:ScalarProperty Name="DateTimePrecision" ColumnName="DateTimePrecision" />
<cs:ScalarProperty Name="Precision" ColumnName="Precision" />
<cs:ScalarProperty Name="Scale" ColumnName="Scale" />
<cs:ComplexProperty Name="Collation">
<cs:ScalarProperty Name="CatalogName" ColumnName="CollationCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CollationSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CollationName" />
</cs:ComplexProperty>
<cs:ComplexProperty Name="CharacterSet">
<cs:ScalarProperty Name="CatalogName" ColumnName="CharacterSetCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CharacterSetSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CharacterSetName" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsMultiSet" ColumnName="IsMultiSet" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="Mode" ColumnName="Mode" />
<cs:ScalarProperty Name="Default" ColumnName="Default" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="Procedures" TypeName="Store.Procedure" StoreEntitySet="SProcedures">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="CatalogName" ColumnName="CatalogName" />
<cs:ScalarProperty Name="SchemaName" ColumnName="SchemaName" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="ProcedureParameters" TypeName="Store.Parameter" StoreEntitySet="SProcedureParameters">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="Ordinal" ColumnName="Ordinal" />
<cs:ComplexProperty Name="ParameterType">
<cs:ScalarProperty Name="TypeName" ColumnName="TypeName" />
<cs:ScalarProperty Name="MaxLength" ColumnName="MaxLength" />
<cs:ScalarProperty Name="DateTimePrecision" ColumnName="DateTimePrecision" />
<cs:ScalarProperty Name="Precision" ColumnName="Precision" />
<cs:ScalarProperty Name="Scale" ColumnName="Scale" />
<cs:ComplexProperty Name="Collation">
<cs:ScalarProperty Name="CatalogName" ColumnName="CollationCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CollationSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CollationName" />
</cs:ComplexProperty>
<cs:ComplexProperty Name="CharacterSet">
<cs:ScalarProperty Name="CatalogName" ColumnName="CharacterSetCatalog" />
<cs:ScalarProperty Name="SchemaName" ColumnName="CharacterSetSchema" />
<cs:ScalarProperty Name="Name" ColumnName="CharacterSetName" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="IsMultiSet" ColumnName="IsMultiSet" />
</cs:ComplexProperty>
<cs:ScalarProperty Name="Mode" ColumnName="Mode" />
<cs:ScalarProperty Name="Default" ColumnName="Default" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="TableConstraints" >
<cs:EntityTypeMapping TypeName="IsTypeOf(Store.Constraint)">
<cs:MappingFragment StoreEntitySet="SConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="IsDeferrable" ColumnName="IsDeferrable" />
<cs:ScalarProperty Name="IsInitiallyDeferred" ColumnName="IsInitiallyDeferred" />
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.UniqueConstraint">
<cs:MappingFragment StoreEntitySet="SConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:Condition ColumnName="ConstraintType" Value="UNIQUE"/>
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.CheckConstraint">
<cs:MappingFragment StoreEntitySet="SConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:Condition ColumnName="ConstraintType" Value="CHECK"/>
</cs:MappingFragment>
<cs:MappingFragment StoreEntitySet="SCheckConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Expression" ColumnName="Expression" />
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.PrimaryKeyConstraint">
<cs:MappingFragment StoreEntitySet="SConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:Condition ColumnName="ConstraintType" Value="PRIMARY KEY"/>
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.ForeignKeyConstraint">
<cs:MappingFragment StoreEntitySet="SConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:Condition ColumnName="ConstraintType" Value="FOREIGN KEY"/>
</cs:MappingFragment>
<cs:MappingFragment StoreEntitySet="SForeignKeyConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="UpdateRule" ColumnName="UpdateRule" />
<cs:ScalarProperty Name="DeleteRule" ColumnName="DeleteRule" />
</cs:MappingFragment>
</cs:EntityTypeMapping>
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="ViewConstraints" >
<cs:EntityTypeMapping TypeName="Store.UniqueConstraint" >
<cs:MappingFragment StoreEntitySet="SViewConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="IsDeferrable" ColumnName="IsDeferrable" />
<cs:ScalarProperty Name="IsInitiallyDeferred" ColumnName="IsInitiallyDeferred" />
<cs:Condition ColumnName="ConstraintType" Value="UNIQUE"/>
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.CheckConstraint" >
<cs:MappingFragment StoreEntitySet="SViewConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="IsDeferrable" ColumnName="IsDeferrable" />
<cs:ScalarProperty Name="IsInitiallyDeferred" ColumnName="IsInitiallyDeferred" />
<cs:ScalarProperty Name="Expression" ColumnName="Expression" />
<cs:Condition ColumnName="ConstraintType" Value="CHECK"/>
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.PrimaryKeyConstraint" >
<cs:MappingFragment StoreEntitySet="SViewConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="IsDeferrable" ColumnName="IsDeferrable" />
<cs:ScalarProperty Name="IsInitiallyDeferred" ColumnName="IsInitiallyDeferred" />
<cs:Condition ColumnName="ConstraintType" Value="PRIMARY KEY"/>
</cs:MappingFragment>
</cs:EntityTypeMapping>
<cs:EntityTypeMapping TypeName="Store.ForeignKeyConstraint" >
<cs:MappingFragment StoreEntitySet="SViewConstraints">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Name" ColumnName="Name" />
<cs:ScalarProperty Name="IsDeferrable" ColumnName="IsDeferrable" />
<cs:ScalarProperty Name="IsInitiallyDeferred" ColumnName="IsInitiallyDeferred" />
<cs:ScalarProperty Name="UpdateRule" ColumnName="UpdateRule" />
<cs:ScalarProperty Name="DeleteRule" ColumnName="DeleteRule" />
<cs:Condition ColumnName="ConstraintType" Value="FOREIGN KEY"/>
</cs:MappingFragment>
</cs:EntityTypeMapping>
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="TableForeignKeys" StoreEntitySet="SForeignKeys" TypeName="Store.ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Ordinal" ColumnName="Ordinal" />
</cs:EntitySetMapping>
<cs:EntitySetMapping Name="ViewForeignKeys" StoreEntitySet="SViewForeignKeys" TypeName="Store.ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
<cs:ScalarProperty Name="Ordinal" ColumnName="Ordinal" />
</cs:EntitySetMapping>
<cs:AssociationSetMapping Name="TableTableColumns" StoreEntitySet="STableColumns" TypeName="Store.TableOrViewColumn">
<cs:EndProperty Name="Parent">
<cs:ScalarProperty Name="Id" ColumnName="ParentId" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ViewViewColumns" StoreEntitySet="SViewColumns" TypeName="Store.TableOrViewColumn">
<cs:EndProperty Name="Parent">
<cs:ScalarProperty Name="Id" ColumnName="ParentId" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="TableTableConstraints" StoreEntitySet="SConstraints" TypeName="Store.TableOrViewConstraint">
<cs:EndProperty Name="Parent">
<cs:ScalarProperty Name="Id" ColumnName="ParentId" />
</cs:EndProperty>
<cs:EndProperty Name="Constraint">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="TableConstraintColumns" StoreEntitySet="SConstraintColumns" TypeName="Store.TableOrViewConstraintColumn">
<cs:EndProperty Name="Constraint">
<cs:ScalarProperty Name="Id" ColumnName="ConstraintId" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="ColumnId" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="TableConstraintForeignKeys" StoreEntitySet="SForeignKeys" TypeName="Store.ConstraintForeignKey">
<cs:EndProperty Name="Constraint">
<cs:ScalarProperty Name="Id" ColumnName="ConstraintId" />
</cs:EndProperty>
<cs:EndProperty Name="ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ToTableForeignKeyColumns" StoreEntitySet="SForeignKeys" TypeName="Store.ToForeignKeyColumn">
<cs:EndProperty Name="ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="ToColumnId" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="FromTableForeignKeyColumns" StoreEntitySet="SForeignKeys" TypeName="Store.FromForeignKeyColumn">
<cs:EndProperty Name="ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="FromColumnId" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ViewViewConstraints" StoreEntitySet="SViewConstraints" TypeName="Store.TableOrViewConstraint">
<cs:EndProperty Name="Parent">
<cs:ScalarProperty Name="Id" ColumnName="ParentId" />
</cs:EndProperty>
<cs:EndProperty Name="Constraint">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ViewConstraintColumns" StoreEntitySet="SViewConstraintColumns" TypeName="Store.TableOrViewConstraintColumn">
<cs:EndProperty Name="Constraint">
<cs:ScalarProperty Name="Id" ColumnName="ConstraintId" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="ColumnId" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ViewConstraintForeignKeys" StoreEntitySet="SViewForeignKeys" TypeName="Store.ConstraintForeignKey">
<cs:EndProperty Name="Constraint">
<cs:ScalarProperty Name="Id" ColumnName="ConstraintId" />
</cs:EndProperty>
<cs:EndProperty Name="ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ToViewForeignKeyColumns" StoreEntitySet="SViewForeignKeys" TypeName="Store.ToForeignKeyColumn">
<cs:EndProperty Name="ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="ToColumnId" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="FromViewForeignKeyColumns" StoreEntitySet="SViewForeignKeys" TypeName="Store.FromForeignKeyColumn">
<cs:EndProperty Name="ForeignKey">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
<cs:EndProperty Name="Column">
<cs:ScalarProperty Name="Id" ColumnName="FromColumnId" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="FunctionFunctionParameters" StoreEntitySet="SFunctionParameters" TypeName="Store.RoutineParameter">
<cs:EndProperty Name="Routine">
<cs:ScalarProperty Name="Id" ColumnName="ParentId" />
</cs:EndProperty>
<cs:EndProperty Name="Parameter">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
<cs:AssociationSetMapping Name="ProcedureProcedureParameters" StoreEntitySet="SProcedureParameters" TypeName="Store.RoutineParameter">
<cs:EndProperty Name="Routine">
<cs:ScalarProperty Name="Id" ColumnName="ParentId" />
</cs:EndProperty>
<cs:EndProperty Name="Parameter">
<cs:ScalarProperty Name="Id" ColumnName="Id" />
</cs:EndProperty>
</cs:AssociationSetMapping>
</cs:EntityContainerMapping>
</Mapping> Yv <?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="MySqlClient"
Provider="MySql.Data.MySqlClient"
ProviderManifestToken="5"
Alias="Self"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
<EntityContainer Name="Schema">
<EntitySet Name="STables" EntityType="Self.Table">
<DefiningQuery>
SELECT /* Tables */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS `Catalog`,
TABLE_SCHEMA AS `Schema`,
TABLE_NAME AS `Name`
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="STableColumns" EntityType="Self.TableColumn">
<DefiningQuery>
SELECT /* Table columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
NUMERIC_PRECISION AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsIdentity`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViews" EntityType="Self.View">
<DefiningQuery>
SELECT /* Views */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS`CatalogName`,
TABLE_SCHEMA AS `SchemaName`,
TABLE_NAME AS `Name`,
VIEW_DEFINITION AS `ViewDefinition`,
CASE IS_UPDATABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsUpdatable`
FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewColumns" EntityType="Self.ViewColumn">
<DefiningQuery>
SELECT /* View columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
NUMERIC_PRECISION AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsIdentity`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SFunctions" EntityType="Self.Function">
<DefiningQuery>
SELECT /* Functions */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`,
SUBSTRING_INDEX(DTD_IDENTIFIER, '(', 1) AS `ReturnTypeName`,
NULL AS `ReturnMaxLength`,
NULL AS `ReturnPrecision`,
0 AS `ReturnDateTimePrecision`,
NULL AS `ReturnScale`,
NULL AS `ReturnCollationCatalog`,
NULL AS `ReturnCollationSchema`,
NULL AS `ReturnCollationName`,
NULL AS `ReturnCharacterSetCatalog`,
NULL AS `ReturnCharacterSetSchema`,
NULL AS `ReturnCharacterSetName`,
NULL AS `ReturnIsMultiSet`,
NULL AS `IsAggregate`,
NULL AS `IsBuiltIn`,
NULL AS `IsNiladic`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='FUNCTION'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedures" EntityType="Self.Procedure">
<DefiningQuery>
SELECT /* Procedures */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<!-- 6.0 -->
<EntitySet Name="SFunctionParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT /* Function parameters */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `Ordinal`,
NULL AS `TypeName`,
NULL AS `MaxLength`,
NULL AS `Precision`,
NULL AS `DateTimePrecision`,
NULL AS `Scale`,
NULL AS `CollatioCatalog`,
NULL AS `CollationSchema`,
NULL AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
NULL AS `CharacterSetName`,
NULL AS `IsMultiSet`,
NULL AS `Mode`,
NULL AS `Default`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedureParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT /* Procedure parameters */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `Ordinal`,
NULL AS `TypeName`,
NULL AS `MaxLength`,
NULL AS `Precision`,
NULL AS `DateTimePrecision`,
NULL AS `Scale`,
NULL AS `CollatioCatalog`,
NULL AS `CollationSchema`,
NULL AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
NULL AS `CharacterSetName`,
NULL AS `IsMultiSet`,
NULL AS `Mode`,
NULL AS `Default`
</DefiningQuery>
</EntitySet>
<!-- End 6.0 -->
<EntitySet Name="SConstraints" EntityType="Self.Constraint">
<DefiningQuery>
SELECT /* Constraints */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
CONSTRAINT_NAME AS `Name`,
CONSTRAINT_TYPE AS `ConstraintType`,
0 AS `IsDeferrable`,
0 AS `IsInitiallyDeferred`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE != 'CHECK' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SCheckConstraints" EntityType="Self.CheckConstraint">
<DefiningQuery>
SELECT /* Check constraints */
NULL AS `Id`,
NULL AS `Expression`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* Constraint columns */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `ConstraintId`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `ColumnId`
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
'NO ACTION' AS `UpdateRule`,
'NO ACTION' AS `DeleteRule`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE='FOREIGN KEY'
</DefiningQuery>
</EntitySet>
<EntitySet Name="SForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* Foreign keys */
CONCAT(KCU.TABLE_SCHEMA, '.', KCU.CONSTRAINT_NAME, '.', KCU.ORDINAL_POSITION) AS `Id`,
CONCAT(KCU.REFERENCED_TABLE_SCHEMA, '.', KCU.REFERENCED_TABLE_NAME, '.', KCU.REFERENCED_COLUMN_NAME) AS `ToColumnId`,
CONCAT(KCU.TABLE_SCHEMA, '.', KCU.TABLE_NAME, '.', KCU.COLUMN_NAME) AS `FromColumnId`,
CONCAT(KCU.TABLE_SCHEMA, '.', KCU.TABLE_NAME, '.', KCU.CONSTRAINT_NAME) AS `ConstraintId`,
KCU.ORDINAL_POSITION AS `Ordinal`
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU
WHERE TC.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND TC.TABLE_SCHEMA = KCU.TABLE_SCHEMA
AND TC.TABLE_NAME = KCU.TABLE_NAME
AND TC.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME
AND TC.TABLE_SCHEMA = schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewConstraints" EntityType="Self.ViewConstraint">
<DefiningQuery>
SELECT /* View constraints */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `ConstraintType`,
NULL AS `Expression`,
NULL AS `UpdateRule`,
NULL AS `DeleteRule`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* View constraint columns */
NULL AS `ConstraintId`,
NULL AS `ColumnId`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* View foreign keys */
NULL AS `Id`,
NULL AS `ToColumnId`,
NULL AS `FromColumnId`,
NULL AS `ConstraintId`,
0 AS `Ordinal`
</DefiningQuery>
</EntitySet>
<AssociationSet Name="STableTableColumns" Association="Self.TableTableColumn" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="STableConstraints" Association="Self.TableTableConstraint" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintConstraintColumns" Association="Self.ConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SConstraintColumns"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintForeignKeys" Association="Self.ConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Constraint" EntitySet="SForeignKeyConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyColumns" Association="Self.FromForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyColumns" Association="Self.ToForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewColumns" Association="Self.ViewViewColumn" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewConstraints" Association="Self.ViewViewConstraint" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintConstraintColumns" Association="Self.ViewConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SViewConstraintColumns"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintForeignKeys" Association="Self.ViewConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyViewColumns" Association="Self.FromForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyViewColumns" Association="Self.ToForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="FunctionFunctionParameters" Association="Self.FunctionFunctionParameter">
<End Role="Function" EntitySet="SFunctions"/>
<End Role="Parameter" EntitySet="SFunctionParameters"/>
</AssociationSet>
<AssociationSet Name="ProcedureProcedureParameters" Association="Self.ProcedureProcedureParameter" >
<End Role="Procedure" EntitySet="SProcedures"/>
<End Role="Parameter" EntitySet="SProcedureParameters"/>
</AssociationSet>
</EntityContainer>
<EntityType Name="Table">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Catalog" Type="varchar" MaxLength="256" />
<Property Name="Schema" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="TableColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength ="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="View">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="CatalogName" Type="varchar" MaxLength="256" />
<Property Name="SchemaName" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ViewDefinition" Nullable="true" Type="text" />
<Property Name="IsUpdatable" Nullable="false" Type="bit" />
</EntityType>
<EntityType Name="ViewColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="Function">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ReturnTypeName" Type="varchar" MaxLength="256" />
<Property Name="ReturnMaxLength" Type="bigint" />
<Property Name="ReturnPrecision" Type="bigint" />
<Property Name="ReturnDateTimePrecision" Type="int" />
<Property Name="ReturnScale" Type="bigint" />
<Property Name="ReturnCollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationName" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="ReturnIsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsAggregate" Type="bit" />
<Property Name="IsBuiltIn" Type="bit" />
<Property Name="IsNiladic" Type="bit" />
</EntityType>
<EntityType Name="Procedure">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
</EntityType>
<EntityType Name="Parameter">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Ordinal" Nullable="false" Type="int"/>
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Nullable="true" Type="bigint" />
<Property Name="Precision" Nullable="true" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Nullable="true" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="Mode" Type="varchar" MaxLength="16" />
<Property Name="Default" Type="longtext" />
</EntityType>
<EntityType Name="Constraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="CheckConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
</EntityType>
<EntityType Name="ConstraintColumn">
<Key>
<PropertyRef Name="ConstraintId" />
<PropertyRef Name="ColumnId" />
</Key>
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ColumnId" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="ForeignKeyConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="UpdateRule" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="ForeignKey">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="int" />
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="FromColumnId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ToColumnId" Nullable="false" Type="varchar" MaxLength ="256" />
</EntityType>
<EntityType Name="ViewConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
<Property Name="UpdateRule" Nullable="true" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="true" MaxLength="11" Type="varchar" />
</EntityType>
<Association Name="TableTableConstraint">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.Constraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintConstraintColumn">
<End Type="Self.Constraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintForeignKey">
<End Type="Self.ForeignKeyConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="TableTableColumn">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.TableColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewColumn">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FunctionFunctionParameter">
<End Type="Self.Function" Role="Function" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Function">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ProcedureProcedureParameter">
<End Type="Self.Procedure" Role="Procedure" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Procedure">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewConstraint">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintConstraintColumn">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintForeignKey">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema> 3 <?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="MySqlClient"
Provider="MySql.Data.MySqlClient"
ProviderManifestToken="5"
Alias="Self"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
<EntityContainer Name="Schema">
<EntitySet Name="STables" EntityType="Self.Table">
<DefiningQuery>
SELECT /* Tables */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS `Catalog`,
TABLE_SCHEMA AS `Schema`,
TABLE_NAME AS `Name`
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="STableColumns" EntityType="Self.TableColumn">
<DefiningQuery>
SELECT /* Table columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
NUMERIC_PRECISION AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsIdentity`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViews" EntityType="Self.View">
<DefiningQuery>
SELECT /* Views */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS`CatalogName`,
TABLE_SCHEMA AS `SchemaName`,
TABLE_NAME AS `Name`,
VIEW_DEFINITION AS `ViewDefinition`,
CASE IS_UPDATABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsUpdatable`
FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewColumns" EntityType="Self.ViewColumn">
<DefiningQuery>
SELECT /* View columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
NUMERIC_PRECISION AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsIdentity`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SFunctions" EntityType="Self.Function">
<DefiningQuery>
SELECT /* Functions */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`,
SUBSTRING_INDEX(DTD_IDENTIFIER, '(', 1) AS `ReturnTypeName`,
NULL AS `ReturnMaxLength`,
NULL AS `ReturnPrecision`,
0 AS `ReturnDateTimePrecision`,
NULL AS `ReturnScale`,
NULL AS `ReturnCollationCatalog`,
NULL AS `ReturnCollationSchema`,
NULL AS `ReturnCollationName`,
NULL AS `ReturnCharacterSetCatalog`,
NULL AS `ReturnCharacterSetSchema`,
NULL AS `ReturnCharacterSetName`,
NULL AS `ReturnIsMultiSet`,
NULL AS `IsAggregate`,
NULL AS `IsBuiltIn`,
NULL AS `IsNiladic`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='FUNCTION'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedures" EntityType="Self.Procedure">
<DefiningQuery>
SELECT /* Procedures */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SFunctionParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME, '.', f.PARAMETER_NAME) AS `Id`,
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME) AS `ParentId`,
f.PARAMETER_NAME AS `Name`,
f.ORDINAL_POSITION `Ordinal`,
f.DATA_TYPE AS `TypeName`,
f.CHARACTER_MAXIMUM_LENGTH AS `MaxLength`,
f.NUMERIC_PRECISION AS`Precision`,
NULL AS `DateTimePrecision`,
f.NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
f.COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
f.CHARACTER_SET_NAME AS `CharacterSetName`,
CAST(0 as decimal(0,0)) AS `IsMultiSet`,
f.PARAMETER_MODE AS `Mode`,
NULL AS `Default`
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.ROUTINE_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'FUNCTION'
WHERE
r.ROUTINE_SCHEMA=schema() AND f.ORDINAL_POSITION > 0
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedureParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME, '.', f.PARAMETER_NAME) AS `Id`,
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME) AS `ParentId`,
f.PARAMETER_NAME AS `Name`,
f.ORDINAL_POSITION `Ordinal`,
f.DATA_TYPE AS `TypeName`,
f.CHARACTER_MAXIMUM_LENGTH AS `MaxLength`,
f.NUMERIC_PRECISION AS`Precision`,
NULL AS `DateTimePrecision`,
f.NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
f.COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
f.CHARACTER_SET_NAME AS `CharacterSetName`,
CAST(0 as decimal(0,0)) AS `IsMultiSet`,
f.PARAMETER_MODE AS `Mode`,
NULL AS `Default`
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.ROUTINE_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'PROCEDURE'
WHERE
r.ROUTINE_SCHEMA=schema() AND f.ORDINAL_POSITION > 0
</DefiningQuery>
</EntitySet>
<EntitySet Name="SConstraints" EntityType="Self.Constraint">
<DefiningQuery>
SELECT /* Constraints */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
CONSTRAINT_NAME AS `Name`,
CONSTRAINT_TYPE AS `ConstraintType`,
0 AS `IsDeferrable`,
0 AS `IsInitiallyDeferred`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE != 'CHECK' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SCheckConstraints" EntityType="Self.CheckConstraint">
<DefiningQuery>
SELECT /* Check constraints */
NULL AS `Id`,
NULL AS `Expression`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* Constraint columns */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `ConstraintId`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `ColumnId`
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<!--
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT /* Foreign key constraints */
CONCAT('`', TABLE_SCHEMA, '`.`', CONSTRAINT_NAME, '`') AS `Id`,
'NO ACTION' AS `UpdateRule`,
'NO ACTION' AS `DeleteRule`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
-->
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
UPDATE_RULE AS `UpdateRule`,
DELETE_RULE AS `DeleteRule`
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
</DefiningQuery>
</EntitySet>
<EntitySet Name="SForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT
CONCAT(FC.CONSTRAINT_SCHEMA, '.', FC.CONSTRAINT_NAME, '.', FC.ORDINAL_POSITION) AS `Id`,
CONCAT(PC.TABLE_SCHEMA, '.', PC.TABLE_NAME, '.', PC.COLUMN_NAME) AS `ToColumnId`,
CONCAT(FC.TABLE_SCHEMA, '.', FC.TABLE_NAME, '.', FC.COLUMN_NAME) AS `FromColumnId`,
CONCAT(FC.CONSTRAINT_SCHEMA, '.', FC.TABLE_NAME, '.', FC.CONSTRAINT_NAME) AS `ConstraintId`,
FC.ORDINAL_POSITION AS `Ordinal`
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
AND RC.REFERENCED_TABLE_NAME = PC.TABLE_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND RC.TABLE_NAME = FC.TABLE_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
<!-- WHERE FC.CONSTRAINT_SCHEMA='test3'-->
</DefiningQuery>
</EntitySet>
<!--<EntitySet Name="SForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* Foreign keys */
CONCAT('`', KEYCOLS.TABLE_SCHEMA, '`.`', KEYCOLS.TABLE_NAME, '`.`',
KEYCOLS.CONSTRAINT_NAME, '`.`', KEYCOLS.COLUMN_NAME, '`') AS `Id`,
CONCAT('`', KEYCOLS.REFERENCED_TABLE_SCHEMA, '`.`',
KEYCOLS.REFERENCED_TABLE_NAME, '`.`',
KEYCOLS.REFERENCED_COLUMN_NAME, '`') AS `ToColumnId`,
CONCAT('`', KEYCOLS.TABLE_SCHEMA, '`.`', KEYCOLS.TABLE_NAME, '`.`', KEYCOLS.COLUMN_NAME, '`') AS `FromColumnId`,
KEYCOLS.COLUMN_NAME AS `Name`,
CONCAT('`', KEYCOLS.TABLE_SCHEMA, '`.`', KEYCOLS.CONSTRAINT_NAME, '`') AS `ConstraintId`,
KEYCOLS.ORDINAL_POSITION AS `Ordinal`
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE KEYCOLS
WHERE TC.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND TC.TABLE_SCHEMA = KEYCOLS.TABLE_SCHEMA
AND TC.TABLE_NAME = KEYCOLS.TABLE_NAME
AND TC.CONSTRAINT_NAME = KEYCOLS.CONSTRAINT_NAME
AND TC.TABLE_SCHEMA = schema()
</DefiningQuery>
</EntitySet>-->
<EntitySet Name="SViewConstraints" EntityType="Self.ViewConstraint">
<DefiningQuery>
SELECT /* View constraints */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `ConstraintType`,
NULL AS `Expression`,
NULL AS `UpdateRule`,
NULL AS `DeleteRule`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* View constraint columns */
NULL AS `ConstraintId`,
NULL AS `ColumnId`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* View foreign keys */
NULL AS `Id`,
NULL AS `ToColumnId`,
NULL AS `FromColumnId`,
NULL AS `ConstraintId`,
0 AS `Ordinal`
</DefiningQuery>
</EntitySet>
<AssociationSet Name="STableTableColumns" Association="Self.TableTableColumn" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="STableConstraints" Association="Self.TableTableConstraint" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintConstraintColumns" Association="Self.ConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SConstraintColumns"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintForeignKeys" Association="Self.ConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Constraint" EntitySet="SForeignKeyConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyColumns" Association="Self.FromForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyColumns" Association="Self.ToForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewColumns" Association="Self.ViewViewColumn" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewConstraints" Association="Self.ViewViewConstraint" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintConstraintColumns" Association="Self.ViewConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SViewConstraintColumns"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintForeignKeys" Association="Self.ViewConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyViewColumns" Association="Self.FromForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyViewColumns" Association="Self.ToForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="FunctionFunctionParameters" Association="Self.FunctionFunctionParameter">
<End Role="Function" EntitySet="SFunctions"/>
<End Role="Parameter" EntitySet="SFunctionParameters"/>
</AssociationSet>
<AssociationSet Name="ProcedureProcedureParameters" Association="Self.ProcedureProcedureParameter" >
<End Role="Procedure" EntitySet="SProcedures"/>
<End Role="Parameter" EntitySet="SProcedureParameters"/>
</AssociationSet>
</EntityContainer>
<EntityType Name="Table">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Catalog" Type="varchar" MaxLength="256" />
<Property Name="Schema" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="TableColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength ="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="View">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="CatalogName" Type="varchar" MaxLength="256" />
<Property Name="SchemaName" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ViewDefinition" Nullable="true" Type="text" />
<Property Name="IsUpdatable" Nullable="false" Type="bit" />
</EntityType>
<EntityType Name="ViewColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="Function">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ReturnTypeName" Type="varchar" MaxLength="256" />
<Property Name="ReturnMaxLength" Type="bigint" />
<Property Name="ReturnPrecision" Type="bigint" />
<Property Name="ReturnDateTimePrecision" Type="int" />
<Property Name="ReturnScale" Type="bigint" />
<Property Name="ReturnCollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationName" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="ReturnIsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsAggregate" Type="bit" />
<Property Name="IsBuiltIn" Type="bit" />
<Property Name="IsNiladic" Type="bit" />
</EntityType>
<EntityType Name="Procedure">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
</EntityType>
<EntityType Name="Parameter">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Ordinal" Nullable="false" Type="int"/>
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Nullable="true" Type="bigint" />
<Property Name="Precision" Nullable="true" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Nullable="true" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="Mode" Type="varchar" MaxLength="16" />
<Property Name="Default" Type="longtext" />
</EntityType>
<EntityType Name="Constraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="CheckConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
</EntityType>
<EntityType Name="ConstraintColumn">
<Key>
<PropertyRef Name="ConstraintId" />
<PropertyRef Name="ColumnId" />
</Key>
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ColumnId" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="ForeignKeyConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="UpdateRule" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="ForeignKey">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="int" />
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="FromColumnId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ToColumnId" Nullable="false" Type="varchar" MaxLength ="256" />
</EntityType>
<EntityType Name="ViewConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
<Property Name="UpdateRule" Nullable="true" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="true" MaxLength="11" Type="varchar" />
</EntityType>
<Association Name="TableTableConstraint">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.Constraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintConstraintColumn">
<End Type="Self.Constraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintForeignKey">
<End Type="Self.ForeignKeyConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="TableTableColumn">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.TableColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewColumn">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FunctionFunctionParameter">
<End Type="Self.Function" Role="Function" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Function">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ProcedureProcedureParameter">
<End Type="Self.Procedure" Role="Procedure" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Procedure">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewConstraint">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintConstraintColumn">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintForeignKey">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema> y <?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="MySqlClient"
Provider="MySql.Data.MySqlClient"
ProviderManifestToken="5"
Alias="Self"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
<EntityContainer Name="Schema">
<EntitySet Name="STables" EntityType="Self.Table">
<DefiningQuery>
SELECT /* Tables */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS `Catalog`,
TABLE_SCHEMA AS `Schema`,
TABLE_NAME AS `Name`
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="STableColumns" EntityType="Self.TableColumn">
<DefiningQuery>
SELECT /* Table columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
NUMERIC_PRECISION AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsIdentity`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsStoreGenerated`,
IF (COLUMN_TYPE = 'tinyint(1)', -128, COLUMN_DEFAULT) AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViews" EntityType="Self.View">
<DefiningQuery>
SELECT /* Views */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS`CatalogName`,
TABLE_SCHEMA AS `SchemaName`,
TABLE_NAME AS `Name`,
VIEW_DEFINITION AS `ViewDefinition`,
CASE IS_UPDATABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsUpdatable`
FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewColumns" EntityType="Self.ViewColumn">
<DefiningQuery>
SELECT /* View columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
NUMERIC_PRECISION AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsIdentity`,
CASE WHEN EXTRA LIKE '%auto%' THEN 1 ELSE 0 END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SFunctions" EntityType="Self.Function">
<DefiningQuery>
SELECT /* Functions */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`,
SUBSTRING_INDEX(DTD_IDENTIFIER, '(', 1) AS `ReturnTypeName`,
NULL AS `ReturnMaxLength`,
NULL AS `ReturnPrecision`,
0 AS `ReturnDateTimePrecision`,
NULL AS `ReturnScale`,
NULL AS `ReturnCollationCatalog`,
NULL AS `ReturnCollationSchema`,
NULL AS `ReturnCollationName`,
NULL AS `ReturnCharacterSetCatalog`,
NULL AS `ReturnCharacterSetSchema`,
NULL AS `ReturnCharacterSetName`,
NULL AS `ReturnIsMultiSet`,
NULL AS `IsAggregate`,
NULL AS `IsBuiltIn`,
NULL AS `IsNiladic`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='FUNCTION'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedures" EntityType="Self.Procedure">
<DefiningQuery>
SELECT /* Procedures */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<!-- 6.0 -->
<EntitySet Name="SFunctionParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT /* Function parameters */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `Ordinal`,
NULL AS `TypeName`,
NULL AS `MaxLength`,
NULL AS `Precision`,
NULL AS `DateTimePrecision`,
NULL AS `Scale`,
NULL AS `CollatioCatalog`,
NULL AS `CollationSchema`,
NULL AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
NULL AS `CharacterSetName`,
NULL AS `IsMultiSet`,
NULL AS `Mode`,
NULL AS `Default`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedureParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT /* Procedure parameters */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `Ordinal`,
NULL AS `TypeName`,
NULL AS `MaxLength`,
NULL AS `Precision`,
NULL AS `DateTimePrecision`,
NULL AS `Scale`,
NULL AS `CollatioCatalog`,
NULL AS `CollationSchema`,
NULL AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
NULL AS `CharacterSetName`,
NULL AS `IsMultiSet`,
NULL AS `Mode`,
NULL AS `Default`
</DefiningQuery>
</EntitySet>
<!-- End 6.0 -->
<EntitySet Name="SConstraints" EntityType="Self.Constraint">
<DefiningQuery>
SELECT /* Constraints */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
CONSTRAINT_NAME AS `Name`,
CONSTRAINT_TYPE AS `ConstraintType`,
0 AS `IsDeferrable`,
0 AS `IsInitiallyDeferred`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE != 'CHECK' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SCheckConstraints" EntityType="Self.CheckConstraint">
<DefiningQuery>
SELECT /* Check constraints */
NULL AS `Id`,
NULL AS `Expression`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* Constraint columns */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `ConstraintId`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `ColumnId`
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<!--
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT /* Foreign key constraints */
CONCAT('`', TABLE_SCHEMA, '`.`', CONSTRAINT_NAME, '`') AS `Id`,
'NO ACTION' AS `UpdateRule`,
'NO ACTION' AS `DeleteRule`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
-->
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
UPDATE_RULE AS `UpdateRule`,
DELETE_RULE AS `DeleteRule`
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
</DefiningQuery>
</EntitySet>
<EntitySet Name="SForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT
CONCAT(FC.CONSTRAINT_SCHEMA, '.', FC.CONSTRAINT_NAME, '.', FC.ORDINAL_POSITION) AS `Id`,
CONCAT(PC.TABLE_SCHEMA, '.', PC.TABLE_NAME, '.', PC.COLUMN_NAME) AS `ToColumnId`,
CONCAT(FC.TABLE_SCHEMA, '.', FC.TABLE_NAME, '.', FC.COLUMN_NAME) AS `FromColumnId`,
CONCAT(FC.CONSTRAINT_SCHEMA, '.', FC.TABLE_NAME, '.', FC.CONSTRAINT_NAME) AS `ConstraintId`,
FC.ORDINAL_POSITION AS `Ordinal`
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
AND RC.REFERENCED_TABLE_NAME = PC.TABLE_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND RC.TABLE_NAME = FC.TABLE_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
<!-- WHERE FC.CONSTRAINT_SCHEMA='test3'-->
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewConstraints" EntityType="Self.ViewConstraint">
<DefiningQuery>
SELECT /* View constraints */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `ConstraintType`,
NULL AS `Expression`,
NULL AS `UpdateRule`,
NULL AS `DeleteRule`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* View constraint columns */
NULL AS `ConstraintId`,
NULL AS `ColumnId`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* View foreign keys */
NULL AS `Id`,
NULL AS `ToColumnId`,
NULL AS `FromColumnId`,
NULL AS `ConstraintId`,
0 AS `Ordinal`
</DefiningQuery>
</EntitySet>
<AssociationSet Name="STableTableColumns" Association="Self.TableTableColumn" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="STableConstraints" Association="Self.TableTableConstraint" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintConstraintColumns" Association="Self.ConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SConstraintColumns"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintForeignKeys" Association="Self.ConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Constraint" EntitySet="SForeignKeyConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyColumns" Association="Self.FromForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyColumns" Association="Self.ToForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewColumns" Association="Self.ViewViewColumn" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewConstraints" Association="Self.ViewViewConstraint" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintConstraintColumns" Association="Self.ViewConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SViewConstraintColumns"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintForeignKeys" Association="Self.ViewConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyViewColumns" Association="Self.FromForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyViewColumns" Association="Self.ToForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="FunctionFunctionParameters" Association="Self.FunctionFunctionParameter">
<End Role="Function" EntitySet="SFunctions"/>
<End Role="Parameter" EntitySet="SFunctionParameters"/>
</AssociationSet>
<AssociationSet Name="ProcedureProcedureParameters" Association="Self.ProcedureProcedureParameter" >
<End Role="Procedure" EntitySet="SProcedures"/>
<End Role="Parameter" EntitySet="SProcedureParameters"/>
</AssociationSet>
</EntityContainer>
<EntityType Name="Table">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Catalog" Type="varchar" MaxLength="256" />
<Property Name="Schema" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="TableColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength ="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="View">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="CatalogName" Type="varchar" MaxLength="256" />
<Property Name="SchemaName" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ViewDefinition" Nullable="true" Type="text" />
<Property Name="IsUpdatable" Nullable="false" Type="bit" />
</EntityType>
<EntityType Name="ViewColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="Function">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ReturnTypeName" Type="varchar" MaxLength="256" />
<Property Name="ReturnMaxLength" Type="bigint" />
<Property Name="ReturnPrecision" Type="bigint" />
<Property Name="ReturnDateTimePrecision" Type="int" />
<Property Name="ReturnScale" Type="bigint" />
<Property Name="ReturnCollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationName" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="ReturnIsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsAggregate" Type="bit" />
<Property Name="IsBuiltIn" Type="bit" />
<Property Name="IsNiladic" Type="bit" />
</EntityType>
<EntityType Name="Procedure">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
</EntityType>
<EntityType Name="Parameter">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Ordinal" Nullable="false" Type="int"/>
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Nullable="true" Type="bigint" />
<Property Name="Precision" Nullable="true" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Nullable="true" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="Mode" Type="varchar" MaxLength="16" />
<Property Name="Default" Type="longtext" />
</EntityType>
<EntityType Name="Constraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="CheckConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
</EntityType>
<EntityType Name="ConstraintColumn">
<Key>
<PropertyRef Name="ConstraintId" />
<PropertyRef Name="ColumnId" />
</Key>
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ColumnId" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="ForeignKeyConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="UpdateRule" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="ForeignKey">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="int" />
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="FromColumnId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ToColumnId" Nullable="false" Type="varchar" MaxLength ="256" />
</EntityType>
<EntityType Name="ViewConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
<Property Name="UpdateRule" Nullable="true" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="true" MaxLength="11" Type="varchar" />
</EntityType>
<Association Name="TableTableConstraint">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.Constraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintConstraintColumn">
<End Type="Self.Constraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintForeignKey">
<End Type="Self.ForeignKeyConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="TableTableColumn">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.TableColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewColumn">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FunctionFunctionParameter">
<End Type="Self.Function" Role="Function" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Function">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ProcedureProcedureParameter">
<End Type="Self.Procedure" Role="Procedure" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Procedure">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewConstraint">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintConstraintColumn">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintForeignKey">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema> <?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="MySqlClient"
Provider="MySql.Data.MySqlClient"
ProviderManifestToken="5"
Alias="Self"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
<EntityContainer Name="Schema">
<EntitySet Name="STables" EntityType="Self.Table">
<DefiningQuery>
SELECT /* Tables */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS `Catalog`,
TABLE_SCHEMA AS `Schema`,
TABLE_NAME AS `Name`
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="STableColumns" EntityType="Self.TableColumn">
<DefiningQuery>
SELECT /* Table columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
CASE WHEN NUMERIC_PRECISION > 0 THEN CAST(NUMERIC_PRECISION AS CHAR)
WHEN DATETIME_PRECISION > 0 THEN CAST(DATETIME_PRECISION AS CHAR)
ELSE 0
END AS `Precision`,
DATETIME_PRECISION AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN COLUMN_DEFAULT LIKE 'CURRENT_TIMESTAMP' THEN 1
WHEN EXTRA LIKE '%auto%' THEN 1
ELSE 0
END AS `IsIdentity`,
CASE WHEN COLUMN_DEFAULT LIKE 'CURRENT_TIMESTAMP' THEN 1
WHEN EXTRA LIKE '%auto%' THEN 1
ELSE 0
END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViews" EntityType="Self.View">
<DefiningQuery>
SELECT /* Views */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `Id`,
TABLE_CATALOG AS`CatalogName`,
TABLE_SCHEMA AS `SchemaName`,
TABLE_NAME AS `Name`,
VIEW_DEFINITION AS `ViewDefinition`,
CASE IS_UPDATABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsUpdatable`
FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewColumns" EntityType="Self.ViewColumn">
<DefiningQuery>
SELECT /* View columns */
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
COLUMN_NAME AS `Name`,
ORDINAL_POSITION AS `Ordinal`,
CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS `IsNullable`,
IF(LEFT(COLUMN_TYPE,10) = 'tinyint(1)', 'bool',
IF (LEFT(COLUMN_TYPE,10) = 'binary(16)' OR LEFT(COLUMN_TYPE,8) = 'char(36)', 'guid',
IF (INSTR(COLUMN_TYPE, 'unsigned') = 0, DATA_TYPE,
CONCAT('u', DATA_TYPE)))) AS `TypeName`,
IF (CHARACTER_MAXIMUM_LENGTH > 2147483647, 2147483647, CHARACTER_MAXIMUM_LENGTH) AS `MaxLength`,
CASE WHEN NUMERIC_PRECISION > 0 THEN CAST(NUMERIC_PRECISION AS UNSIGNED INTEGER)
WHEN DATETIME_PRECISION > 0 THEN CAST(DATETIME_PRECISION AS UNSIGNED INTEGER)
ELSE 0
END AS `Precision`,
0 AS `DateTimePrecision`,
NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
CHARACTER_SET_NAME AS `CharacterSetName`,
0 AS `IsMultiSet`,
CASE WHEN COLUMN_DEFAULT LIKE 'CURRENT_TIMESTAMP' THEN 1
WHEN EXTRA LIKE '%auto%' THEN 1
ELSE 0
END AS `IsIdentity`,
CASE WHEN COLUMN_DEFAULT LIKE 'CURRENT_TIMESTAMP' THEN 1
WHEN EXTRA LIKE '%auto%' THEN 1
ELSE 0
END AS `IsStoreGenerated`,
COLUMN_DEFAULT AS `Default`
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SFunctions" EntityType="Self.Function">
<DefiningQuery>
SELECT /* Functions */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`,
SUBSTRING_INDEX(DTD_IDENTIFIER, '(', 1) AS `ReturnTypeName`,
NULL AS `ReturnMaxLength`,
NULL AS `ReturnPrecision`,
0 AS `ReturnDateTimePrecision`,
NULL AS `ReturnScale`,
NULL AS `ReturnCollationCatalog`,
NULL AS `ReturnCollationSchema`,
NULL AS `ReturnCollationName`,
NULL AS `ReturnCharacterSetCatalog`,
NULL AS `ReturnCharacterSetSchema`,
NULL AS `ReturnCharacterSetName`,
NULL AS `ReturnIsMultiSet`,
NULL AS `IsAggregate`,
NULL AS `IsBuiltIn`,
NULL AS `IsNiladic`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='FUNCTION'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedures" EntityType="Self.Procedure">
<DefiningQuery>
SELECT /* Procedures */
CONCAT(ROUTINE_SCHEMA, '.', SPECIFIC_NAME) AS `Id`,
ROUTINE_CATALOG AS `CatalogName`,
ROUTINE_SCHEMA AS `SchemaName`,
ROUTINE_NAME AS `Name`
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
AND ROUTINE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SFunctionParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME, '.', f.PARAMETER_NAME) AS `Id`,
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME) AS `ParentId`,
f.PARAMETER_NAME AS `Name`,
f.ORDINAL_POSITION `Ordinal`,
f.DATA_TYPE AS `TypeName`,
f.CHARACTER_MAXIMUM_LENGTH AS `MaxLength`,
f.NUMERIC_PRECISION AS`Precision`,
NULL AS `DateTimePrecision`,
f.NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
f.COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
f.CHARACTER_SET_NAME AS `CharacterSetName`,
CAST(0 as decimal(0,0)) AS `IsMultiSet`,
f.PARAMETER_MODE AS `Mode`,
NULL AS `Default`
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.ROUTINE_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'FUNCTION'
WHERE
r.ROUTINE_SCHEMA=schema() AND f.ORDINAL_POSITION > 0
</DefiningQuery>
</EntitySet>
<EntitySet Name="SProcedureParameters" EntityType="Self.Parameter">
<DefiningQuery>
SELECT
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME, '.', f.PARAMETER_NAME) AS `Id`,
CONCAT(f.SPECIFIC_SCHEMA, '.', f.SPECIFIC_NAME) AS `ParentId`,
f.PARAMETER_NAME AS `Name`,
f.ORDINAL_POSITION `Ordinal`,
f.DATA_TYPE AS `TypeName`,
f.CHARACTER_MAXIMUM_LENGTH AS `MaxLength`,
f.NUMERIC_PRECISION AS`Precision`,
NULL AS `DateTimePrecision`,
f.NUMERIC_SCALE AS `Scale`,
NULL AS `CollationCatalog`,
NULL AS `CollationSchema`,
f.COLLATION_NAME AS `CollationName`,
NULL AS `CharacterSetCatalog`,
NULL AS `CharacterSetSchema`,
f.CHARACTER_SET_NAME AS `CharacterSetName`,
CAST(0 as decimal(0,0)) AS `IsMultiSet`,
f.PARAMETER_MODE AS `Mode`,
NULL AS `Default`
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.ROUTINE_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'PROCEDURE'
WHERE
r.ROUTINE_SCHEMA=schema() AND f.ORDINAL_POSITION > 0
</DefiningQuery>
</EntitySet>
<EntitySet Name="SConstraints" EntityType="Self.Constraint">
<DefiningQuery>
SELECT /* Constraints */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS `ParentId`,
CONSTRAINT_NAME AS `Name`,
CONSTRAINT_TYPE AS `ConstraintType`,
0 AS `IsDeferrable`,
0 AS `IsInitiallyDeferred`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE != 'CHECK' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<EntitySet Name="SCheckConstraints" EntityType="Self.CheckConstraint">
<DefiningQuery>
SELECT /* Check constraints */
NULL AS `Id`,
NULL AS `Expression`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* Constraint columns */
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `ConstraintId`,
CONCAT(TABLE_SCHEMA, '.', TABLE_NAME, '.', COLUMN_NAME) AS `ColumnId`
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
<!--
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT /* Foreign key constraints */
CONCAT('`', TABLE_SCHEMA, '`.`', CONSTRAINT_NAME, '`') AS `Id`,
'NO ACTION' AS `UpdateRule`,
'NO ACTION' AS `DeleteRule`
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_SCHEMA=schema()
</DefiningQuery>
</EntitySet>
-->
<EntitySet Name="SForeignKeyConstraints" EntityType="Self.ForeignKeyConstraint">
<DefiningQuery>
SELECT
CONCAT(CONSTRAINT_SCHEMA, '.', TABLE_NAME, '.', CONSTRAINT_NAME) AS `Id`,
UPDATE_RULE AS `UpdateRule`,
DELETE_RULE AS `DeleteRule`
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
</DefiningQuery>
</EntitySet>
<EntitySet Name="SForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT
CONCAT(FC.CONSTRAINT_SCHEMA, '.', FC.CONSTRAINT_NAME, '.', FC.ORDINAL_POSITION) AS `Id`,
CONCAT(PC.TABLE_SCHEMA, '.', PC.TABLE_NAME, '.', PC.COLUMN_NAME) AS `ToColumnId`,
CONCAT(FC.TABLE_SCHEMA, '.', FC.TABLE_NAME, '.', FC.COLUMN_NAME) AS `FromColumnId`,
CONCAT(FC.CONSTRAINT_SCHEMA, '.', FC.TABLE_NAME, '.', FC.CONSTRAINT_NAME) AS `ConstraintId`,
FC.ORDINAL_POSITION AS `Ordinal`
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
AND RC.REFERENCED_TABLE_NAME = PC.TABLE_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND RC.TABLE_NAME = FC.TABLE_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
<!-- WHERE FC.CONSTRAINT_SCHEMA='test3'-->
</DefiningQuery>
</EntitySet>
<!--<EntitySet Name="SForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* Foreign keys */
CONCAT('`', KEYCOLS.TABLE_SCHEMA, '`.`', KEYCOLS.TABLE_NAME, '`.`',
KEYCOLS.CONSTRAINT_NAME, '`.`', KEYCOLS.COLUMN_NAME, '`') AS `Id`,
CONCAT('`', KEYCOLS.REFERENCED_TABLE_SCHEMA, '`.`',
KEYCOLS.REFERENCED_TABLE_NAME, '`.`',
KEYCOLS.REFERENCED_COLUMN_NAME, '`') AS `ToColumnId`,
CONCAT('`', KEYCOLS.TABLE_SCHEMA, '`.`', KEYCOLS.TABLE_NAME, '`.`', KEYCOLS.COLUMN_NAME, '`') AS `FromColumnId`,
KEYCOLS.COLUMN_NAME AS `Name`,
CONCAT('`', KEYCOLS.TABLE_SCHEMA, '`.`', KEYCOLS.CONSTRAINT_NAME, '`') AS `ConstraintId`,
KEYCOLS.ORDINAL_POSITION AS `Ordinal`
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE KEYCOLS
WHERE TC.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND TC.TABLE_SCHEMA = KEYCOLS.TABLE_SCHEMA
AND TC.TABLE_NAME = KEYCOLS.TABLE_NAME
AND TC.CONSTRAINT_NAME = KEYCOLS.CONSTRAINT_NAME
AND TC.TABLE_SCHEMA = schema()
</DefiningQuery>
</EntitySet>-->
<EntitySet Name="SViewConstraints" EntityType="Self.ViewConstraint">
<DefiningQuery>
SELECT /* View constraints */
NULL AS `Id`,
NULL AS `ParentId`,
NULL AS `Name`,
NULL AS `ConstraintType`,
NULL AS `Expression`,
NULL AS `UpdateRule`,
NULL AS `DeleteRule`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewConstraintColumns" EntityType="Self.ConstraintColumn">
<DefiningQuery>
SELECT /* View constraint columns */
NULL AS `ConstraintId`,
NULL AS `ColumnId`
</DefiningQuery>
</EntitySet>
<EntitySet Name="SViewForeignKeys" EntityType="Self.ForeignKey">
<DefiningQuery>
SELECT /* View foreign keys */
NULL AS `Id`,
NULL AS `ToColumnId`,
NULL AS `FromColumnId`,
NULL AS `ConstraintId`,
0 AS `Ordinal`
</DefiningQuery>
</EntitySet>
<AssociationSet Name="STableTableColumns" Association="Self.TableTableColumn" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="STableConstraints" Association="Self.TableTableConstraint" >
<End Role="Parent" EntitySet="STables"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintConstraintColumns" Association="Self.ConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SConstraintColumns"/>
<End Role="Constraint" EntitySet="SConstraints"/>
</AssociationSet>
<AssociationSet Name="SConstraintForeignKeys" Association="Self.ConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Constraint" EntitySet="SForeignKeyConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyColumns" Association="Self.FromForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyColumns" Association="Self.ToForeignKeyColumn" >
<End Role="ForeignKey" EntitySet="SForeignKeys"/>
<End Role="Column" EntitySet="STableColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewColumns" Association="Self.ViewViewColumn" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SViewViewConstraints" Association="Self.ViewViewConstraint" >
<End Role="Parent" EntitySet="SViews"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintConstraintColumns" Association="Self.ViewConstraintConstraintColumn" >
<End Role="ConstraintColumn" EntitySet="SViewConstraintColumns"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SViewConstraintForeignKeys" Association="Self.ViewConstraintForeignKey" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Constraint" EntitySet="SViewConstraints"/>
</AssociationSet>
<AssociationSet Name="SFromForeignKeyViewColumns" Association="Self.FromForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="SToForeignKeyViewColumns" Association="Self.ToForeignKeyViewColumn" >
<End Role="ForeignKey" EntitySet="SViewForeignKeys"/>
<End Role="Column" EntitySet="SViewColumns"/>
</AssociationSet>
<AssociationSet Name="FunctionFunctionParameters" Association="Self.FunctionFunctionParameter">
<End Role="Function" EntitySet="SFunctions"/>
<End Role="Parameter" EntitySet="SFunctionParameters"/>
</AssociationSet>
<AssociationSet Name="ProcedureProcedureParameters" Association="Self.ProcedureProcedureParameter" >
<End Role="Procedure" EntitySet="SProcedures"/>
<End Role="Parameter" EntitySet="SProcedureParameters"/>
</AssociationSet>
</EntityContainer>
<EntityType Name="Table">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Catalog" Type="varchar" MaxLength="256" />
<Property Name="Schema" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="TableColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength ="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="View">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="CatalogName" Type="varchar" MaxLength="256" />
<Property Name="SchemaName" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ViewDefinition" Nullable="true" Type="text" />
<Property Name="IsUpdatable" Nullable="false" Type="bit" />
</EntityType>
<EntityType Name="ViewColumn">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="bigint" />
<Property Name="IsNullable" Nullable="false" Type="bit" />
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Type="bigint" />
<Property Name="Precision" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsIdentity" Nullable="false" Type="bit" />
<Property Name="IsStoreGenerated" Nullable="false" Type="bit" />
<Property Name="Default" Nullable="true" Type="longtext"/>
</EntityType>
<EntityType Name="Function">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ReturnTypeName" Type="varchar" MaxLength="256" />
<Property Name="ReturnMaxLength" Type="bigint" />
<Property Name="ReturnPrecision" Type="bigint" />
<Property Name="ReturnDateTimePrecision" Type="int" />
<Property Name="ReturnScale" Type="bigint" />
<Property Name="ReturnCollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCollationName" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="ReturnCharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="ReturnIsMultiSet" Nullable="false" Type="bit" />
<Property Name="IsAggregate" Type="bit" />
<Property Name="IsBuiltIn" Type="bit" />
<Property Name="IsNiladic" Type="bit" />
</EntityType>
<EntityType Name="Procedure">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="CatalogName" Type="varchar" MaxLength="256"/>
<Property Name="SchemaName" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256"/>
</EntityType>
<EntityType Name="Parameter">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Ordinal" Nullable="false" Type="int"/>
<Property Name="TypeName" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="MaxLength" Nullable="true" Type="bigint" />
<Property Name="Precision" Nullable="true" Type="bigint" />
<Property Name="DateTimePrecision" Type="int" />
<Property Name="Scale" Nullable="true" Type="bigint" />
<Property Name="CollationCatalog" Type="varchar" MaxLength="128" />
<Property Name="CollationSchema" Type="varchar" MaxLength="128" />
<Property Name="CollationName" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetCatalog" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetSchema" Type="varchar" MaxLength="128" />
<Property Name="CharacterSetName" Type="varchar" MaxLength="128" />
<Property Name="IsMultiSet" Nullable="false" Type="bit" />
<Property Name="Mode" Type="varchar" MaxLength="16" />
<Property Name="Default" Type="longtext" />
</EntityType>
<EntityType Name="Constraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="CheckConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength ="256" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
</EntityType>
<EntityType Name="ConstraintColumn">
<Key>
<PropertyRef Name="ConstraintId" />
<PropertyRef Name="ColumnId" />
</Key>
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ColumnId" Nullable="false" Type="varchar" MaxLength="256" />
</EntityType>
<EntityType Name="ForeignKeyConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="UpdateRule" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="false" MaxLength="11" Type="varchar" />
</EntityType>
<EntityType Name="ForeignKey">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256"/>
<Property Name="Ordinal" Nullable="false" Type="int" />
<Property Name="ConstraintId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="FromColumnId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ToColumnId" Nullable="false" Type="varchar" MaxLength ="256" />
</EntityType>
<EntityType Name="ViewConstraint">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="ParentId" Nullable="false" Type="varchar" MaxLength="256" />
<Property Name="Name" Nullable="false" MaxLength="256" Type="varchar" />
<Property Name="IsDeferrable" Nullable="false" Type="bit" />
<Property Name="IsInitiallyDeferred" Nullable="false" Type="bit" />
<Property Name="ConstraintType" Nullable="false" MaxLength="11" Type="varchar" />
<Property Name="Expression" Nullable="true" MaxLength="4000" Type="varchar" />
<Property Name="UpdateRule" Nullable="true" MaxLength="11" Type="varchar" />
<Property Name="DeleteRule" Nullable="true" MaxLength="11" Type="varchar" />
</EntityType>
<Association Name="TableTableConstraint">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.Constraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintConstraintColumn">
<End Type="Self.Constraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ConstraintForeignKey">
<End Type="Self.ForeignKeyConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyColumn">
<End Type="Self.TableColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="TableTableColumn">
<End Type="Self.Table" Role="Parent" Multiplicity="1" />
<End Type="Self.TableColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewColumn">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewColumn" Role="Column" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Column">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FunctionFunctionParameter">
<End Type="Self.Function" Role="Function" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Function">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ProcedureProcedureParameter">
<End Type="Self.Procedure" Role="Procedure" Multiplicity="1" />
<End Type="Self.Parameter" Role="Parameter" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Procedure">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Parameter">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewViewConstraint">
<End Type="Self.View" Role="Parent" Multiplicity="1" />
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Parent">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Constraint">
<PropertyRef Name="ParentId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintConstraintColumn">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ConstraintColumn" Role="ConstraintColumn" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ConstraintColumn">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ViewConstraintForeignKey">
<End Type="Self.ViewConstraint" Role="Constraint" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Constraint">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ConstraintId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FromForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="FromColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="ToForeignKeyViewColumn">
<End Type="Self.ViewColumn" Role="Column" Multiplicity="1" />
<End Type="Self.ForeignKey" Role="ForeignKey" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Column">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="ForeignKey">
<PropertyRef Name="ToColumnId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema> <?xml version="1.0" encoding="utf-8"?>
<!--
####################################################################################################################
BE AWARE THAT THE ORDER IN WHICH TYPES ARE DESCRIBED IN THE PROVIDER MANIFEST IS RELEVANT AND HAVE IMPACT IN LOOKUP
PROCESS
####################################################################################################################
-->
<ProviderManifest Namespace="MySql" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/providermanifest">
<Types>
<Type Name ="guid" PrimitiveTypeKind ="Guid"/>
<Type Name="bool" PrimitiveTypeKind="Boolean"/>
<!-- signed types -->
<Type Name="tinyint" PrimitiveTypeKind="SByte"/>
<Type Name="smallint" PrimitiveTypeKind="Int16"/>
<Type Name="mediumint" PrimitiveTypeKind="Int32"/>
<Type Name="int" PrimitiveTypeKind ="Int32"/>
<Type Name="bigint" PrimitiveTypeKind="Int64"/>
<!-- unsigned types are mapped to signed value big enough to hold it
since EF doesn't support unsigned types directly -->
<Type Name="utinyint" PrimitiveTypeKind="Byte"/>
<Type Name="usmallint" PrimitiveTypeKind="Int32"/>
<Type Name="umediumint" PrimitiveTypeKind="Int32"/>
<Type Name="uint" PrimitiveTypeKind ="Int64"/>
<Type Name="ubigint" PrimitiveTypeKind="Decimal">
<FacetDescriptions>
<Precision Minimum="20" Maximum="20" DefaultValue="20" Constant="true" />
<Scale Minimum="0" Maximum="0" DefaultValue="0" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="year" PrimitiveTypeKind="Int16"/>
<Type Name="float" PrimitiveTypeKind="Single"/>
<Type Name="double" PrimitiveTypeKind="Double"/>
<Type Name="decimal" PrimitiveTypeKind="Decimal">
<FacetDescriptions>
<Precision Minimum="1" Maximum="65" DefaultValue="10" Constant="false" />
<Scale Minimum="0" Maximum="30" DefaultValue="0" Constant="false" />
</FacetDescriptions>
</Type>
<Type Name="timestamp" PrimitiveTypeKind="DateTime">
<FacetDescriptions>
<Precision Minimum="0" Maximum="6" DefaultValue="0" Constant="false" />
</FacetDescriptions>
</Type>
<Type Name="date" PrimitiveTypeKind="DateTime">
<FacetDescriptions>
<Precision DefaultValue="0" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="time" PrimitiveTypeKind="Time">
<FacetDescriptions>
<MaxLength DefaultValue="8" Constant="true" />
<FixedLength DefaultValue="true" Constant="true" />
<Precision Minimum="0" Maximum="6" DefaultValue="0" Constant="false" />
</FacetDescriptions>
</Type>
<Type Name="datetime" PrimitiveTypeKind="DateTime">
<FacetDescriptions>
<Precision Minimum="0" Maximum="6" DefaultValue="0" Constant="false" />
</FacetDescriptions>
</Type>
<Type Name="nvarchar" PrimitiveTypeKind="String">
<FacetDescriptions>
<MaxLength Minimum="1" Maximum="65535" DefaultValue="1000" Constant="false" />
<Unicode DefaultValue="true" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="varchar" PrimitiveTypeKind="String">
<FacetDescriptions>
<MaxLength Minimum="1" Maximum="65535" DefaultValue="1000" Constant="false" />
<Unicode DefaultValue="false" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="char" PrimitiveTypeKind="String">
<FacetDescriptions>
<MaxLength Minimum="1" Maximum="255" DefaultValue="255" Constant="false" />
<Unicode DefaultValue="false" Constant="true" />
<FixedLength DefaultValue="true" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="nchar" PrimitiveTypeKind="String">
<FacetDescriptions>
<MaxLength Minimum="1" Maximum="255" DefaultValue="255" Constant="false" />
<Unicode DefaultValue="true" Constant="true" />
<FixedLength DefaultValue="true" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="binary" PrimitiveTypeKind="Binary">
<FacetDescriptions>
<MaxLength Minimum="1" Maximum="255" Constant="false" />
<FixedLength DefaultValue="true" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="varbinary" PrimitiveTypeKind="Binary">
<FacetDescriptions>
<MaxLength Minimum="1" Maximum="65535" DefaultValue="100" Constant="false" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="bit" PrimitiveTypeKind="Boolean"/>
<Type Name="tinyblob" PrimitiveTypeKind="Binary" >
<FacetDescriptions>
<MaxLength DefaultValue="255" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="blob" PrimitiveTypeKind="Binary" >
<FacetDescriptions>
<MaxLength DefaultValue="65535" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="mediumblob" PrimitiveTypeKind="Binary" >
<FacetDescriptions>
<MaxLength DefaultValue="16777215" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="longblob" PrimitiveTypeKind="Binary" >
<FacetDescriptions>
<MaxLength DefaultValue="2147483647" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="tinytext" PrimitiveTypeKind="String" >
<FacetDescriptions>
<MaxLength DefaultValue="255" Constant="true" />
<Unicode DefaultValue="false" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="text" PrimitiveTypeKind="String" >
<FacetDescriptions>
<MaxLength DefaultValue="65535" Constant="true" />
<Unicode DefaultValue="false" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="mediumtext" PrimitiveTypeKind="String" >
<FacetDescriptions>
<MaxLength DefaultValue="16777215" Constant="true" />
<Unicode DefaultValue="false" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<!-- <Type Name="longtext" PrimitiveTypeKind="String" >
<FacetDescriptions>
<MaxLength Default="2147483647" Constant="true" />
<Unicode Default="false" Constant="true" />
<FixedLength Default="false" Constant="true" />
</FacetDescriptions>
</Type>-->
<Type Name="longtext" PrimitiveTypeKind="String" >
<FacetDescriptions>
<MaxLength DefaultValue="1073741823" Constant="true" />
<Unicode DefaultValue="false" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="set" PrimitiveTypeKind="String">
<FacetDescriptions>
<MaxLength DefaultValue="65531" Constant="true" />
<Unicode DefaultValue="true" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
<Type Name="enum" PrimitiveTypeKind="String">
<FacetDescriptions>
<MaxLength DefaultValue="65532" Constant="true" />
<Unicode DefaultValue="true" Constant="true" />
<FixedLength DefaultValue="false" Constant="true" />
</FacetDescriptions>
</Type>
</Types>
<Functions>
<!-- ### AGGREGAfTES ### -->
<!-- AVG -->
<Function Name="AVG" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="arg" Type="Collection(Int32)" Mode="In" />
</Function>
<Function Name="AVG" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int64)" Mode="In" />
</Function>
<Function Name="AVG" Aggregate="true" BuiltIn="true">
<ReturnType Type="Decimal" />
<Parameter Name="arg" Type="Collection(Decimal)" Mode="In" />
</Function>
<Function Name="AVG" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In" />
</Function>
<!-- COUNT -->
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Byte)" Mode="In"/>
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int16)" Mode="In"/>
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int32)" Mode="In"/>
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int64)" Mode="In"/>
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In" />
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Decimal)" Mode="In" />
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(DateTime)" Mode="In" />
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(String)" Mode="In" />
</Function>
<Function Name="COUNT" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Binary)" Mode="In" />
</Function>
<!-- MAX -->
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Byte" />
<Parameter Name="arg" Type="Collection(Byte)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int16" />
<Parameter Name="arg" Type="Collection(Int16)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="arg" Type="Collection(Int32)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int64)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Decimal" />
<Parameter Name="arg" Type="Collection(Decimal)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Single" />
<Parameter Name="arg" Type="Collection(Single)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="arg" Type="Collection(DateTime)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="arg" Type="Collection(String)" Mode="In" />
</Function>
<Function Name="MAX" Aggregate="true" BuiltIn="true">
<ReturnType Type="Binary" />
<Parameter Name="arg" Type="Collection(Binary)" Mode="In" />
</Function>
<!-- MIN -->
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Byte" />
<Parameter Name="arg" Type="Collection(Byte)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int16" />
<Parameter Name="arg" Type="Collection(Int16)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="arg" Type="Collection(Int32)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int64)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Decimal" />
<Parameter Name="arg" Type="Collection(Decimal)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Single" />
<Parameter Name="arg" Type="Collection(Single)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="arg" Type="Collection(DateTime)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="arg" Type="Collection(String)" Mode="In" />
</Function>
<Function Name="MIN" Aggregate="true" BuiltIn="true">
<ReturnType Type="Binary" />
<Parameter Name="arg" Type="Collection(Binary)" Mode="In" />
</Function>
<!-- SUM -->
<Function Name="SUM" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="arg" Type="Collection(Int32)" Mode="In" />
</Function>
<Function Name="SUM" Aggregate="true" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="arg" Type="Collection(Int64)" Mode="In" />
</Function>
<Function Name="SUM" Aggregate="true" BuiltIn="true">
<ReturnType Type="Decimal" />
<Parameter Name="arg" Type="Collection(Decimal)" Mode="In" />
</Function>
<Function Name="SUM" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In" />
</Function>
<!-- STDEV AGGREGATES -->
<Function Name="STDDEV" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In" />
</Function>
<!-- 5.0.3 -->
<Function Name="STDDEV_SAMP" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In"/>
</Function>
<Function Name="STDDEV_POP" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In"/>
</Function>
<Function Name="VAR_SAMP" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In"/>
</Function>
<Function Name="VAR_POP" Aggregate="true" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="arg" Type="Collection(Double)" Mode="In"/>
</Function>
<!-- end 5.0.3 -->
<!-- ### BIT FUNCTIONS ### -->
<!-- Bit_Count -->
<Function Name="BIT_COUNT" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="n" Type="Int64" Mode="In"/>
</Function>
<!-- ### STRING FUNCTIONS ### -->
<!-- Ascii -->
<Function Name="ASCII" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="arg" Type="String" Mode="In" />
</Function>
<Function Name="BIN" BuiltIn="true">
<ReturnType Type="String"/>
<Parameter Name="arg" Type="Int64" Mode="In"/>
</Function>
<Function Name="BIT_LENGTH" BuiltIn="true">
<ReturnType Type="Int64"/>
<Parameter Name="arg" Type="String" Mode="In"/>
</Function>
<Function Name="CHAR_LENGTH" BuiltIn="true">
<ReturnType Type="Int64"/>
<Parameter Name="arg" Type="String" Mode="In"/>
</Function>
<Function Name="CHARACTER_LENGTH" BuiltIn="true">
<ReturnType Type="Int64"/>
<Parameter Name="arg" Type="String" Mode="In"/>
</Function>
<Function Name="CONCAT" BuiltIn="true">
<ReturnType Type="String"/>
<Parameter Name="arg0" Type="String" Mode="In"/>
<Parameter Name="arg1" Type="String" Mode="In"/>
</Function>
<Function Name="CONV" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="N" Type="String" Mode="In"/>
<Parameter Name="from_base" Type="Int32" Mode="In"/>
<Parameter Name="to_base" Type="Int32" Mode="In"/>
</Function>
<!-- todo check longer versions of concat -->
<!-- todo implement concat_ws -->
<!-- todo implement elt -->
<!-- todo implement export_set -->
<!-- todo implement field -->
<Function Name="FIND_IN_SET" BuiltIn="true">
<ReturnType Type="Int64"/>
<Parameter Name="str_to_find" Type="String" Mode="In"/>
<Parameter Name="string_list" Type="String" Mode="In"/>
</Function>
<Function Name="FORMAT" BuiltIn="true">
<ReturnType Type="String"/>
<Parameter Name="value" Type="Double" Mode="In"/>
<Parameter Name="dec_places" Type="Int32" Mode="In"/>
</Function>
<Function Name="HEX" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="n_or_s" Type="String" Mode="In"/>
</Function>
<Function Name="INSERT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="original_string" Type="String" Mode="In"/>
<Parameter Name="position" Type="Int64" Mode="In"/>
<Parameter Name="length" Type="Int64" Mode="In"/>
<Parameter Name="new_string" Type="String" Mode="In"/>
</Function>
<Function Name="INSTR" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="substr" Type="String" Mode="In"/>
</Function>
<Function Name="LEFT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="len" Type="Int64" Mode="In"/>
</Function>
<Function Name="LENGTH" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="LOAD_FILE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="file_name" Type="String" Mode="In"/>
</Function>
<Function Name="LOCATE" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="substr" Type="String" Mode="In"/>
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="LOCATE" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="substr" Type="String" Mode="In"/>
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pos" Type="Int32" Mode="In"/>
</Function>
<Function Name="LOWER" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- LCASE is a synonym for LOWER -->
<Function Name="LCASE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="LPAD" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="len" Type="Int32" Mode="In"/>
<Parameter Name="padstr" Type="String" Mode="In"/>
</Function>
<Function Name="LTRIM" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- implement MAKE_SET -->
<Function Name="MID" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pos" Type="Int32" Mode="In"/>
<Parameter Name="len" Type="Int32" Mode="In"/>
</Function>
<Function Name="OCT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="N" Type="Int64" Mode="In"/>
</Function>
<Function Name="OCTET_LENGTH" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="ORD" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="QUOTE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="REPEAT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="count" Type="Int32" Mode="In"/>
</Function>
<Function Name="REPLACE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="from_str" Type="String" Mode="In"/>
<Parameter Name="to_str" Type="String" Mode="In"/>
</Function>
<Function Name="REVERSE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="RIGHT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="len" Type="Int32" Mode="In"/>
</Function>
<Function Name="RPAD" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="len" Type="Int32" Mode="In"/>
<Parameter Name="padstr" Type="String" Mode="In"/>
</Function>
<Function Name="RTRIM" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="SOUNDEX" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="SPACE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="N" Type="Int32" Mode="In"/>
</Function>
<Function Name="SUBSTR" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pos" Type="Int32" Mode="In"/>
</Function>
<Function Name="SUBSTR" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pos" Type="Int32" Mode="In"/>
<Parameter Name="len" Type="Int32" Mode="In"/>
</Function>
<Function Name="SUBSTRING" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pos" Type="Int32" Mode="In"/>
</Function>
<Function Name="SUBSTRING" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pos" Type="Int32" Mode="In"/>
<Parameter Name="len" Type="Int32" Mode="In"/>
</Function>
<Function Name="SUBSTRING_INDEX" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="delim" Type="String" Mode="In"/>
<Parameter Name="count" Type="Int32" Mode="In"/>
</Function>
<!-- implement TRIM -->
<Function Name="UCASE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="UNHEX" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="UPPER" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- ### MATH FUNCTIONS ### -->
<!-- Abs -->
<Function Name="ABS" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="x" Type="Int64" Mode="In"/>
</Function>
<!-- Acos -->
<Function Name="ACOS" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Asin -->
<Function Name="ASIN" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Atan -->
<Function Name="ATAN" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<Function Name="ATAN" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="y" Type="Double" Mode="In"/>
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Atan2 -->
<Function Name="ATAN2" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="y" Type="Double" Mode="In"/>
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Ceil -->
<Function Name="CEIL" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Ceiling -->
<Function Name="CEILING" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Cos -->
<Function Name="COS" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Cot -->
<Function Name="COT" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Crc32 -->
<Function Name="CRC32" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="expr" Type="String" Mode="In"/>
</Function>
<!-- Degrees -->
<Function Name="DEGREES" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Exp -->
<Function Name="EXP" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Floor -->
<Function Name="FLOOR" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Ln -->
<Function Name="LN" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Log-->
<Function Name="LOG" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<Function Name="LOG" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="b" Type="Double" Mode="In"/>
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Log2 -->
<Function Name="LOG2" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Log10 -->
<Function Name="LOG10" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Mod -->
<Function Name="MOD" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="n" Type="Double" Mode="In"/>
<Parameter Name="m" Type="Double" Mode="In"/>
</Function>
<!-- pi -->
<Function Name="PI" BuiltIn="true">
<ReturnType Type="Double" />
</Function>
<!-- Pow -->
<Function Name="POW" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
<Parameter Name="y" Type="Double" Mode="In"/>
</Function>
<!-- Power -->
<Function Name="POWER" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
<Parameter Name="y" Type="Double" Mode="In"/>
</Function>
<!-- Radians -->
<Function Name="RADIANS" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Rand -->
<Function Name="RAND" BuiltIn="true">
<ReturnType Type="Double" />
</Function>
<Function Name="RAND" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="n" Type="Double" Mode="In"/>
</Function>
<!-- Round -->
<Function Name="ROUND" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<Function Name="ROUND" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
<Parameter Name="d" Type="Int32" Mode="In"/>
</Function>
<!-- Sign -->
<Function Name="SIGN" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Sin -->
<Function Name="SIN" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Sqrt -->
<Function Name="SQRT" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Tan -->
<Function Name="TAN" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
</Function>
<!-- Truncate -->
<Function Name="TRUNCATE" BuiltIn="true">
<ReturnType Type="Double" />
<Parameter Name="x" Type="Double" Mode="In"/>
<Parameter Name="d" Type="Int32" Mode="In"/>
</Function>
<!-- ### DATE FUNCTIONS ### -->
<!-- AddDate -->
<Function Name="ADDDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="DateTime" Mode="In"/>
<Parameter Name="days" Type="Int32" Mode="In"/>
</Function>
<Function Name="ADDDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="String" Mode="In"/>
<Parameter Name="days" Type="Int32" Mode="In"/>
</Function>
<!-- AddTime -->
<Function Name="ADDTIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="ADDTIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="ADDTIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="Time" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="ADDTIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="ADDTIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="Time" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="ADDTIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<!-- Convert_Tz -->
<Function Name="CONVERT_TZ" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="dt" Type="String" Mode="In"/>
<Parameter Name="from_tz" Type="String" Mode="In"/>
<Parameter Name="to_tz" Type="String" Mode="In"/>
</Function>
<Function Name="CONVERT_TZ" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="dt" Type="DateTime" Mode="In"/>
<Parameter Name="from_tz" Type="String" Mode="In"/>
<Parameter Name="to_tz" Type="String" Mode="In"/>
</Function>
<!-- CurDate -->
<Function Name="CURDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<Function Name="CURRENT_DATE" BuiltIn="true">
<ReturnType Type="DateTime"/>
</Function>
<!-- CurTime -->
<Function Name="CURTIME" BuiltIn="true">
<ReturnType Type="Time" />
</Function>
<Function Name="CURRENT_TIME" BuiltIn="true">
<ReturnType Type="Time" />
</Function>
<!-- Current_TimeStamp -->
<Function Name="CURRENT_TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!--Date -->
<Function Name="DATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="String" Mode="In"/>
</Function>
<Function Name="DATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="DateTime" Mode="In"/>
</Function>
<!-- DateDiff -->
<Function Name="DATEDIFF" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="DateTime" Mode="In"/>
</Function>
<Function Name="DATEDIFF" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="DATEDIFF" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="DATEDIFF" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="DateTime" Mode="In"/>
</Function>
<!-- Date_Add (todo) -->
<!-- Date_Format -->
<Function Name="DATE_FORMAT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<Function Name="DATE_FORMAT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="date" Type="String" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<!-- Day -->
<Function Name="DAY" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="DAY" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- DayName -->
<Function Name="DAYNAME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="DAYNAME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- DayOfMonth -->
<Function Name="DAYOFMONTH" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="DAYOFMONTH" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- DayOfWeek-->
<Function Name="DAYOFWEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="DAYOFWEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- DayOfYear-->
<Function Name="DAYOFYEAR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="DAYOFYEAR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- Extract (todo) -->
<!-- From_Days -->
<Function Name="FROM_DAYS" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="n" Type="Int32" Mode="In"/>
</Function>
<!-- From_UnixTime -->
<Function Name="FROM_UNIXTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="unix_timestamp" Type="Int32" Mode="In"/>
</Function>
<Function Name="FROM_UNIXTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="unix_timestamp" Type="Int32" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<!-- Get_Format (todo) -->
<!-- Hour -->
<Function Name="HOUR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="time" Type="DateTime" Mode="In"/>
</Function>
<Function Name="HOUR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="time" Type="String" Mode="In"/>
</Function>
<!-- Last_Day -->
<Function Name="LAST_DAY" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="LAST_DAY" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- LocalTime -->
<Function Name="LOCALTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!-- LocalTimeStamp -->
<Function Name="LOCALTIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!-- MakeDate -->
<Function Name="MAKEDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="year" Type="Int32" Mode="In"/>
<Parameter Name="dayOfYear" Type="Int32" Mode="In"/>
</Function>
<!-- MakeTime -->
<Function Name="MAKETIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="hour" Type="Int32" Mode="In"/>
<Parameter Name="minute" Type="Int32" Mode="In"/>
<Parameter Name="second" Type="Int32" Mode="In"/>
</Function>
<!-- MicroSecond -->
<Function Name="MICROSECOND" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="expr" Type="DateTime" Mode="In"/>
</Function>
<Function Name="MICROSECOND" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="expr" Type="Time" Mode="In"/>
</Function>
<Function Name="MICROSECOND" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="expr" Type="String" Mode="In"/>
</Function>
<!-- Minute -->
<Function Name="MINUTE" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="time" Type="DateTime" Mode="In"/>
</Function>
<Function Name="MINUTE" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="time" Type="Time" Mode="In"/>
</Function>
<Function Name="MINUTE" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="time" Type="String" Mode="In"/>
</Function>
<!-- Month -->
<Function Name="MONTH" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="MONTH" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- MonthName -->
<Function Name="MONTHNAME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="MONTHNAME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- Now -->
<Function Name="NOW" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!-- Period_Add -->
<Function Name="PERIOD_ADD" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="p" Type="Int32" Mode="In"/>
<Parameter Name="n" Type="Int32" Mode="In"/>
</Function>
<!-- Period_Diff -->
<Function Name="PERIOD_DIFF" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="p1" Type="Int32" Mode="In"/>
<Parameter Name="p2" Type="Int32" Mode="In"/>
</Function>
<!-- Quarter -->
<Function Name="QUARTER" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="QUARTER" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- Second -->
<Function Name="SECOND" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="time" Type="DateTime" Mode="In"/>
</Function>
<Function Name="SECOND" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="time" Type="Time" Mode="In"/>
</Function>
<Function Name="SECOND" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="time" Type="String" Mode="In"/>
</Function>
<!-- Sec_To_Time -->
<Function Name="SEC_TO_TIME" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="seconds" Type="Int32" Mode="In"/>
</Function>
<!-- Str_To_Date -->
<Function Name="STR_TO_DATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<!-- SubDate -->
<Function Name="SUBDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="DateTime" Mode="In"/>
<Parameter Name="days" Type="Int32" Mode="In"/>
</Function>
<Function Name="SUBDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="String" Mode="In"/>
<Parameter Name="days" Type="Int32" Mode="In"/>
</Function>
<!-- SubTime -->
<Function Name="SUBTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="SUBTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="SUBTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="Time" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="SUBTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="Time" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="SUBTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="SUBTIME" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<!-- SysDate -->
<Function Name="SYSDATE" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!-- Time -->
<Function Name="TIME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="expr" Type="DateTime" Mode="In"/>
</Function>
<Function Name="TIME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="expr" Type="Time" Mode="In"/>
</Function>
<Function Name="TIME" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="expr" Type="String" Mode="In"/>
</Function>
<!-- TimeDiff -->
<Function Name="TIMEDIFF" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="DateTime" Mode="In"/>
</Function>
<Function Name="TIMEDIFF" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="Time" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="TIMEDIFF" BuiltIn="true">
<ReturnType Type="Time" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<!-- TimeStamp -->
<Function Name="TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="DateTime" Mode="In"/>
</Function>
<Function Name="TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr" Type="String" Mode="In"/>
</Function>
<Function Name="TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="DateTime" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<Function Name="TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="Time" Mode="In"/>
</Function>
<Function Name="TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
<Parameter Name="expr1" Type="String" Mode="In"/>
<Parameter Name="expr2" Type="String" Mode="In"/>
</Function>
<!-- TimeStampAdd (todo) -->
<!-- TimeStampDiff (todo) -->
<!-- Time_Format -->
<Function Name="TIME_FORMAT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="time" Type="DateTime" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<Function Name="TIME_FORMAT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="time" Type="Time" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<Function Name="TIME_FORMAT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="time" Type="String" Mode="In"/>
<Parameter Name="format" Type="String" Mode="In"/>
</Function>
<!-- Time_To_Sec -->
<Function Name="TIME_TO_SEC" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="time" Type="DateTime" Mode="In"/>
</Function>
<Function Name="TIME_TO_SEC" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="time" Type="Time" Mode="In"/>
</Function>
<Function Name="TIME_TO_SEC" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="time" Type="String" Mode="In"/>
</Function>
<!-- To_Days -->
<Function Name="TO_DAYS" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="TO_DAYS" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<Function Name="TO_DAYS" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="Int32" Mode="In"/>
</Function>
<!-- Unix_TimeStamp -->
<Function Name="UNIX_TIMESTAMP" BuiltIn="true">
<ReturnType Type="Int64" />
</Function>
<Function Name="UNIX_TIMESTAMP" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="UNIX_TIMESTAMP" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- Utc_Date -->
<Function Name="UTC_DATE" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!-- Utc_Time -->
<Function Name="UTC_TIME" BuiltIn="true">
<ReturnType Type="Time" />
</Function>
<!-- Utc_TimeStamp -->
<Function Name="UTC_TIMESTAMP" BuiltIn="true">
<ReturnType Type="DateTime" />
</Function>
<!-- Week -->
<Function Name="WEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="WEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<Function Name="WEEK" BuiltIn="true">
<ReturnType Type="Int32"/>
<Parameter Name="date" Type="DateTime" Mode="In"/>
<Parameter Name="mode" Type="Int32" Mode="In"/>
</Function>
<Function Name="WEEK" BuiltIn="true">
<ReturnType Type="Int32"/>
<Parameter Name="date" Type="String" Mode="In"/>
<Parameter Name="mode" Type="Int32" Mode="In"/>
</Function>
<!-- WeekDay -->
<Function Name="WEEKDAY" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="WEEKDAY" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- WeekOfYear-->
<Function Name="WEEKOFYEAR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="WEEKOFYEAR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- Year -->
<Function Name="YEAR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="YEAR" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<!-- YearWeek -->
<Function Name="YEARWEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
</Function>
<Function Name="YEARWEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
</Function>
<Function Name="YEARWEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="DateTime" Mode="In"/>
<Parameter Name="mode" Type="Int32" Mode="In"/>
</Function>
<Function Name="YEARWEEK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="date" Type="String" Mode="In"/>
<Parameter Name="mode" Type="Int32" Mode="In"/>
</Function>
<!-- ### ENCRYPTION AND COMPRESSION FUNCTIONS ### -->
<!-- Aes_Decrypt -->
<Function Name="AES_DECRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="crypt_str" Type="String" Mode="In"/>
<Parameter Name="key_str" Type="String" Mode="In"/>
</Function>
<!-- Aes_Encrypt -->
<Function Name="AES_ENCRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="key_str" Type="String" Mode="In"/>
</Function>
<!-- Compress -->
<Function Name="COMPRESS" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="string_to_compress" Type="String" Mode="In"/>
</Function>
<!-- Decode -->
<Function Name="DECODE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="crypt_str" Type="String" Mode="In"/>
<Parameter Name="pass_str" Type="String" Mode="In"/>
</Function>
<!-- Encode -->
<Function Name="ENCODE" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="pass_str" Type="String" Mode="In"/>
</Function>
<!-- Des_Decrypt -->
<Function Name="DES_DECRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="crypt_str" Type="String" Mode="In"/>
</Function>
<Function Name="DES_DECRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="crypt_str" Type="String" Mode="In"/>
<Parameter Name="key_str" Type="String" Mode="In"/>
</Function>
<!-- Des_Encrypt -->
<Function Name="DES_ENCRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="DES_ENCRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="key_num" Type="Int32" Mode="In"/>
</Function>
<Function Name="DES_ENCRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="key_str" Type="String" Mode="In"/>
</Function>
<!-- Encrypt -->
<Function Name="ENCRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<Function Name="ENCRYPT" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="salt" Type="String" Mode="In"/>
</Function>
<!-- Md5 -->
<Function Name="MD5" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Old_Password -->
<Function Name="OLD_PASSWORD" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Password -->
<Function Name="PASSWORD" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Sha -->
<Function Name="SHA" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Sha1 -->
<Function Name="SHA1" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Uncompress -->
<Function Name="UNCOMPRESS" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Uncompressed_Length -->
<Function Name="UNCOMPRESSED_LENGTH" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- ### INFORMATION FUNCTIONS ### -->
<!-- Benchmark (todo) -->
<!-- CharSet -->
<Function Name="charset" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Coercibility -->
<Function Name="COERCIBILITY" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Collation -->
<Function Name="COLLATION" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Connection_Id -->
<Function Name="CONNECTION_ID" BuiltIn="true">
<ReturnType Type="Int32" />
</Function>
<!-- Current_User -->
<Function Name="CURRENT_USER" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- Database -->
<Function Name="DATABASE" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- Found_Rows -->
<Function Name="FOUND_ROWS" BuiltIn="true">
<ReturnType Type="Int32" />
</Function>
<!-- Last_Insert_id -->
<Function Name="LAST_INSERT_ID" BuiltIn="true">
<ReturnType Type="Int64" />
</Function>
<!-- Row_Count -->
<Function Name="ROW_COUNT" BuiltIn="true">
<ReturnType Type="Int64" />
</Function>
<!-- User -->
<Function Name="USER" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- Session_User -->
<Function Name="SESSION_USER" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- System_user -->
<Function Name="SYSTEM_USER" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- Schema -->
<Function Name="SCHEMA" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- Version -->
<Function Name="VERSION" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- ### OTHER FUNCTIONS ### -->
<!-- Default (??) -->
<!-- Get_Lock-->
<Function Name="GET_LOCK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
<Parameter Name="timeout" Type="Int32" Mode="In"/>
</Function>
<!-- Inet_Aton -->
<Function Name="INET_ATON" BuiltIn="true">
<ReturnType Type="Int64" />
<Parameter Name="expr" Type="String" Mode="In"/>
</Function>
<!-- Inet_Ntoa -->
<Function Name="INET_NTOA" BuiltIn="true">
<ReturnType Type="String" />
<Parameter Name="expr" Type="Int64" Mode="In"/>
</Function>
<!-- Is_Free_Lock -->
<Function Name="IS_FREE_LOCK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Is_Used_Lock -->
<Function Name="IS_USED_LOCK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Master_Pos_Wait -->
<Function Name="MASTER_POS_WAIT" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="log_name" Type="String" Mode="In"/>
<Parameter Name="log_pos" Type="Int32" Mode="In"/>
</Function>
<Function Name="MASTER_POS_WAIT" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="log_name" Type="String" Mode="In"/>
<Parameter Name="log_pos" Type="Int32" Mode="In"/>
<Parameter Name="timeout" Type="Int32" Mode="In"/>
</Function>
<!-- Name_Const (??) -->
<!-- Release_Lock -->
<Function Name="RELEASE_LOCK" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="str" Type="String" Mode="In"/>
</Function>
<!-- Sleep -->
<Function Name="SLEEP" BuiltIn="true">
<ReturnType Type="Int32" />
<Parameter Name="duration" Type="Double" Mode="In"/>
</Function>
<!-- Uuid -->
<Function Name="UUID" BuiltIn="true">
<ReturnType Type="String" />
</Function>
<!-- Values (???) -->
</Functions>
</ProviderManifest>
BSJB v4.0.30319 l R #~ (S J #Strings 8 / #US #GUID # #Blob W) %3 ( F : ` g
^2
t y
7 R i z
<
R d d i " . ^
$
S
i
X
m
#
i 2 /2 M2 b2 s2 2 2 2 2 2 2 2 2 '2 62 I2 Z2 k2 ~2 2 2 2 2 2 $2 42 G2 X2 k2 2 2 2 2 2 2 2 2 2 '2 92 J2 ^2 q2 2 2 2 2 2 2
x *y
r
}
y
1
G l l l l ! l 6 l K l _ l w l l l l l l d l l ! l
2
L p l l l l
# %" W" w" " " " " ## $
$ $d *%2 S%2 % &
))
-y-
--
--
--
.-
*.-
C.-
^.-
y.-
.)
.)
.-
.-
/.
$/-
=/-
c/
///
/.
/. 0i .0i 0i 0i
1.
"1
:1
v1
}1-
1
1
1
1
2
72
?2
O2
}2
2
2
3.
3
"3
R3 r3
3 4 4 94 w4 42 +52
5 5
55
5 (6 h62
6 62 62 62 7'r3 72 7 72 K82 p82
8
8 B9i
9-
9 9 -:!: 8: : : r3 :i :i
*;
;/
;/
;/
; @<< a< <l< <l<
<-
<
<-
<- <l< =l< '=l< e=l =l >l
$?:? ?2
? ?l !@l
g@
!A
A CB
.C/
KC- wCaC CaC
C
C C C DC
eD D
-E
NE
[E
fE EE
E E ,F GF kF Fi F G %G WG wG G H +H
NH H $ 3 E 3
W 3 B c 3 I q 3 U 3 X 3 [ 3 e 3 p 3 ( t 3 ( w 3 z 3 " } 3 ( ' 3 ( 3 ( , .3 ( - ;3 0 H3 1 X3 2 i3 3 v3 5 3 6 3 ` = 3 ` = 3 > 3 ` D 3 D 3 E 3 ` H 3 ` I $ 3 K ) 3 M , .3 M . F3 M 1 a3 N 4 ~3 N 6 3 N 8 3 R < 3 R > 3 9 ^ > 3 _ B 3 d G 3 d I +3 d J C3 d K [3 d L s3 d M 3 d O 3 = d P 3 A d R 3 E e W 3 I e g M q
q *3 s :3 u J3 y SiQ y i iU 3 3 2 2 8 T; A A ! 0%
% g
* 2 < K Y g
x u >
G N V ] @ - > s x^ a ^ e q +1 H1 Y1 g1 w1 5^V=VB H
9 Lc 8v 9Q! ! ! ! 5^VVVV;V<V V7VRVViVM b T^4 = = ^ ^! #c ' ' 9 , @
) @ L @ ~@O @O ZBO BO O / T w! ! ! w! ! "Q#^Q"#^Q1#^QC#^QS#^Qa#^Qr#^Q#^S#^S#^ #3 $= <& M&@ & & & & & ! & ' 8' ' '
(9
! w! " !2 Cw 6(! ; A B BN <* L. \3 o7 ! < ! A !! G )! K 2! P <! U !
[ ! ` ! D f ! n k ! p ! v ! z ! " 3
" " v ("
r" +
" @
" X
" e
v j" 03 " J1 " c1v " e
#
3 #
3 %#
G 2#
G ?#
3 L# [# d# v
w#
# & # . # 7 # ? # H # a # u $ $ $$ " H$ ) V$ . d$ 5! r$ :" $ ?# $ $ $ D% $ I& $ & & $ 0 ' $% 9 O( % D W* % N + % W G , % b G , & g K , )& k- p. H& * / h& w/
1 & e
v 2 & 2 ' e
v 2 ' e
. 2 '
* 3 %'
. 3 .' '
G 4 6' 5
K 4 ?' C
G 5 G' N
K 5 P' Y
6 ' ^
p7 ' p8 ( l
9 3( e
v : B( p: (
; ( ^
p< (
= ( e
v > E> E? E@ EA EB EC ED EE EF EG ( e
H ) EJ
) EK ) EL ) EM ) EN ) EO ) EP ) EQ ) ER ?) ES r) qv T ) pT )
U ) e
v V ) pV *
W * e
v X * e
v X * pX p+
Y + pZ h,
[ , e
v \ , e
\ - ^ - ^ - * _ %- . _ .- * ` 6- . ` ?- * a G- . a P- %* b l- :
b t- Ob - pc .
d H. d. d l. ne .
f . e
g / ph P/
i h/ pj /
k / e
v l / pl 0
m $0 e
v n ,0 pn 0
o 0 e
v p 0 g. p 0 gq 0 pr $1
s Y1 e
v t l1 e
. t {1 pu 1
v 1 e
v w 1 n-w 1 }6w 1 px 1 * y 1 . y 2 . z 02 n{ 2
| 3
| 3 e
Q} )3 13 :3 G B3 K L3 p 3
3 ^
p 3 YX 3
3 e
v 4 e
v A4 z ]4 e4 n4 x4 * 4 E 4 E 5 E _6 E x6 E 6 E 6 E 6 E 7 E 7 E 7 E 7 E 7 E e8 E l8 E
8 E T9 E z9 E% 9 E- 9 E5 X: = : EG : EO : EW : E_ : Eg ; Eo ; Ew ; E ; E !; E (; E /; E 6; E =; E D; E K; E R; E Y; E `; E g; E n; E u; E |; E ; E ; ; = > ! > ) 0? 05 |? EA B VM B lY C }` C i D r D { 4E \E E e
v E < E A E F e
v F 4J K L L 4M M e
v M \O 05 P e
v P P
ZQ
mQ Q Q e
v R Y ,R pR k T E U E xU E W ! W E W E Y E Z + Z < [ H [ E [ E L\
P \ E \ E d] E ] E\^ E^ e
v ^ _ 05<` VM` E na e
v
a e
v
a 8q
a 8
8b \m @b e
v
Hb ms
b {c e
v c
* c c e
v %c 1c e
v 9c Gc e
v Oc e
tc nc 3 d ndd 4d e
v d 8e e
v e ( f 6Af e
v Of e
B tf J f v f g e
v g J 6g e
v >g e
v Lg e
v Zg e
v bg e
v lg J g e
v g e
U h
\ 6i e
k!Ei +u"Ui +. %ci :}&li T&i [k(i )i +j -$j /j 1j 34k 5bk 7k 9k ;k =k ? l ATl Cl e
v El E -El Z 6El o * Fl ~ . Fl -Gl 6Gl -Hl 6Hm e
v Ip 7Iq KKt TLu : ]Mv Z kOw yRw SHx Tx Uy V$z Whz Xz Y | Z\} [h \ȁ ] ^ _\ ` a` b$ cg dl !e [kfl 80gl 80hl N>0il Z>0jm f>0km r>0l"m ~>0m0m >0n>m >0oLm >0pZm >0qhm >0rvm >0sm >0tm >0um >0vm >0wm ?0x{ l@/ y| @/ z. *B. {< :B|Z JB/ } B/ ~ e
* 0 9 FƇ e
v Ї ? Y S _ _ e k 4 J ` v M!~ X! c! m! p҈
و e
v e
v M!x X! !} !! !}) !4 p
7" I" ^" h" "$ "̌ "x "ȍ " e
v e
. # % # _ $ l $ 4$ ?$ L$( [$( ؔ n$/ $G $4 ؕ e
v $B $H $O ܗ %[ =%d i%m T %\ %v d %} % ܛ %} % ܝ !& $ b& < p& & e
v e
# & + & 4 '}< 'E ' M ,'
V C'w N'
p Y'p Y
@ f' x'
L '
h '&
'kH YX̮ '2
e
v ¯ M!ʯ X!ӯ n}ۯ } !} ! c! m! pӰ
` e
v ` 8Dg e
[ g ;# g * 8h nhh 3 e
v Ak& e
v l B. 6( 6( 6( 6( 6( 6( 6( <( E( I( W( \( \( \( \( d( o( v( ( \( \( d( o( v( ( \( \( \( \( \( \( \( \( \( \( \( W( \( \( ( ( \( ( ( ( ( ( ( W( 6( 6( 6( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( 6( 6( 6( 6( 6( ( ( ) ( ( ( ( ( ( ( ( ( ( ) ) ( ( ) ( ( 6( ( W( ) ) ( ) #) 6( 6( ( ( ( ) ( 6( -) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) D) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) 9) ( K) Q) D) W) Z) c) l) W( n) s) x) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) l) s) 6( -) l) ) l) l) ) l) l) s) s) x) W( )
) ) W( ) s) ) 9) 9) 9) ) ) 9) 9) 9) ) ) ) * D) * ) #* 9) 9) l) W( n) 9) 9) 9) 9) 9) s) s) x) ) ) ) 9) * * /* n) @* n) @* D* P* ]* j* t* t* z* * * * * * * * * o( * * 6( * * * + + + + 5+ + L+ + a+ + v+ + + + + + + + + + + + + + , + , + 6( 6( 6( 6( 3, G, ], ) ( u, , , G, ) , , ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) * ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) |@ |@ &B |@ |@ |@ , , ) ) , , , 6( 6( 6( ( ( 6( 6( 6( ( ( n) 6( , , n) 6( , ) * n) , W( , , , , - - - $- /* , 6( .- -) -) E( s) E( s) E( # ?- N- ?- N- ?- N- G, N- b- $- n) ) d- n) & 6( 6( 6( ( ( ( ( ) ) * p- ) * ( 6( 6( 6( 6( ( ( 8 ; 6( |@ &B " ! # % $ ) % - & 1 ' 5 e
v e
. e
. e
. e
. e
. e
. e
. e
. e
. e
K e
. !e
K )e
. 1e
. 9e
. Ae
. Ie
. Qe
V
ae
7 ie
v <* L. \3 o7 < A 0
qK0 yX0G yz0 0 0 # n k p v ye
v 0) 3 v
e
v .16 e
*A1C e
*e
*A1c e
v e
v e
. e
v
3
3
G
G
3 D 0 1v v & . 7 ? q
* H a u 1{ " ) . 5 : ? I & ! 1{ )1 )1 )2 1e
e
A"2_9 N W G b G g v g K V2 a2 Ae
v ! * I !h2 Ag !t2G g v 53 ! e
v AE3 )e
v 2 j3 1 , e
v , 4 h2# Ag( 4 t2G A}33 A37 , ; , 33 < ; < 33 < e
v 3! nAE3N < [ < D h2# D t2G L e
v L 33 L ; L 3| L 3 L 3 3 L T h2# L [ T t2G 3\ e
v e
v d e
v \ 33 \ 3# 3* 3 q
4 i
* M! yJ4 l a4
Qm4 A4
Y
* A
* 4* 4'
a4 q4>
Q4D
4J
m4 5. 5P
!5W
d [ 4* i>5 iG5 qQ5f
El
d5t
t ; E
, [ | 33 4 m5 y5 5t
5t
5 qe
v !5t
)5t
yn
; [ e
v h2# t2G 33 ; M!>6 46LqA6* N6R5t
, V6, _6|6 6Ll q6* e
v 6e
. h2# }33 "a206@ h2# 4 e
v m4
7 A'777 h2# a4iF7>
qT7D
t2G
6 " e
v 33 3# a7 k7z7>3* 7>
|6 z776 3* 7>
7* F7>
7t
7= ; 5t
33 46L7* 8G 8 ; z7> 8> h2# t2G >5>G5>*8 z7><8 z7>X8 h2# 6 G 4 f8 z7>X83 e
v 6@|6
7 $8[ $8# $3# ,e
*d 8T$e
v 9 e
v 9 ,9 e
v 9 U99 h99 |94e
*9 99 9<e
*9 9qe
.
* 1 9De
*Le
[ )31L:' W:. k:! :5! 3 :n ! n59:* 1{ Te
v Tq e
v T!R\ hdh2~dt2G Q:Y;3 Ta41;* a2l ;G a/;)3;aD;)H;le
[ lm4# )y e
Uie
ye
v t;<&n0 | y
\9Z<B<Se
[ <d;* <p =y;# #=4=;= e
v e
u +. [ I<Qe
QB=K P=Y[=* YYe
y=* =. =* =. [=* =. =-y[=* y=G ye
3ye
@ J[=* =.
* e
U&[ h2# [ >%> [=*
* e
* e
U
* 4>* e
[=*
* B>* e
* B>* e
e
v e
v e
v e
v qe
v ?v h2# 6)e
. "[ 33 h2# t2G e
. e
v D?Z)S?eAW?wAW? b?} h2# 4 h2# x?33 ;* 7 h2# ?* ??. ? $h2# ?,, 4h2# ?[ m4 a
* @* < Dh2# @G !
* AE33D/@!F7>
?$ 9@* )_6!A@L ;G Lm4# !O@T ;G !]@Tm4# 4.
* @X\e
*)@i=i@XiAG ?2A{ )>AG JAG ) * YAd ;G dhA# L _6!e
U!zA* 4 AG A$la4
* &X36L Bv &X)BSe
*L Bete
*
* |33 9e
; !
. !?* !BG BK _6Ae
Ie
v )TC9e
9& Ye
$i 4q 4 <CVC3 e
\e
7 a4qe
. yn
n
e
e
. i*D0D* AD6e
. "QwDQDa4
DG m4 QDQDQD DQE QwD99QEBQ4EH4Oe
. 4ae
qsE* v v e
. }Ev E* *DE3 E3 42 h2# Ez E# Em4~a4
* FF7>
f d h2# t2G F;F33 ; 4>
yWFeF* ye
. yF. e
% % F* yF* F. e
F3 ye
v F. F9F 33 e
G4 4G h2# Y=G )PG h2# h2# '7\ fGG G ; G
iG G
1G h2# a4
t2G G $ ; ) ;H '7 Ae
. 9 ZH _6AE3 P=/@e
fH|HA Ye
. e
v e
v e
v [ ,e
v H* ,6,\ 8[ V6\ 8# 4 <h2# 4 L P T X \ ` d h l p t | . #. #. #. { ". # O . + s . { . +. ; . #. . 0 . K s . 3 y . [ s . C . c . k s . { ) . s c l ac c c `c c c Ac ac c c c + +Ac ac c c c c #c cc c c c ` c a c c c c c c
c !
c A
c a
c
c
c
c
c c ac c c c c c c c c @c `c c c c c c c !c Ac c c c c a
`c c c c c c c @c @ c ` c @%c `%c ,c -c -c @-c `-c -c -c -c @1c `1c 1c 1c 1c 1c 2c 2c @2c `2c 2c 2c 2c 2c 3c 3c @3c `3c 3c 3c 3c 3c 4c 4c 5c 5c 6c 6c 6c 6c 7c 7c @7c `7c :c :c =c @=c `=c =c =c =c ?c ?c ?c @c @c @@c `@c @c A
`A
A
A
B 1 / I W i
-
4
9
\
$27DWx)7hZ?`
!;A8
'O32gu4B?CNfq XjxSkb F j $ 4 " 6 # 8 ' 9 - : / > 2 ? 3 @ 6 D : k
w
.
o u ] b
# ! - X( H H# O +]
1 l H } H H l r ! $! 5! !# !# ! " " & *B
&( .(L
!# " !# ;
! " # $ % K ! L ! N # M # O % P % ~ ' ' ) ) + + - - / 1 1 3 3 5 7 7 9 9 ; ; = = ? 1A 2C UE hG gG iI jI kK lK mM nM O Q Q S U W Y [ [ ] ] _ _ a a c c e e g g i i k k m m o o q q s s
u
< X A a u
KT]HQ6KH^t ]fox!*#IRa.pJ
2 ; J S a & ]
/ " # : H H V I P 8I O oI I M I 7 6 B A C E 6 F 6 j; #_ T _ _ / ou_ Mqz, D <Module> MySql.Data.Entity.EF6.dll EFMySqlCommand MySql.Data.Entity EFMySqlDataReader SqlFragment InputFragment TableFragment JoinFragment SqlFragmentVisitor ReplaceTableNameVisitor NegatableFragment BinaryFragment InFragment CaseFragment ColumnFragment ExistsFragment FunctionFragment IsNullFragment LikeFragment ListFragment LiteralFragment PropertyFragment SortFragment UnionFragment SqlGenerator DeleteGenerator FunctionGenerator FunctionProcessor InsertGenerator Scope OpType SelectGenerator UpdateGenerator MySqlEFConfiguration MySqlConnectionFactory MySqlDependencyResolver MySqlProviderInvariantName MySqlProviderFactoryResolver MySqlManifestTokenResolver MySqlModelCacheKey MySqlModelCacheKeyFactory EServiceType MySqlExecutionStrategy BackoffAlgorithm BackoffAlgorithmErr1040 BackoffAlgorithmErr1614 BackoffAlgorithmErr1205 BackoffAlgorithmErr1213 BackoffAlgorithmErr2006 BackoffAlgorithmErr2013 BackoffAlgorithmNdb MySqlHistoryContext MySqlLogger MySqlMigrationCodeGenerator MySqlMigrationSqlGenerator OpDispatcher Resources MySql.Data.Entity.Properties DeleteStatement InsertStatement Metadata MySqlProviderManifest MySql.Data.MySqlClient MySqlScriptServices MySqlProviderServices SelectStatement UpdateStatement System.Data System.Data.Common DbCommand mscorlib System ICloneable DbDataReader Object EntityFramework System.Data.Entity.Core.Common.CommandTrees DbExpressionVisitor`1 Enum System.Data.Entity DbConfiguration System.Data.Entity.Infrastructure IDbConnectionFactory System.Data.Entity.Infrastructure.DependencyResolution IDbDependencyResolver IProviderInvariantName IDbProviderFactoryResolver IManifestTokenResolver IDbModelCacheKey DbExecutionStrategy System.Data.Entity.Migrations.History HistoryContext System.IO TextWriter System.Data.Entity.Migrations.Design CSharpMigrationCodeGenerator System.Data.Entity.Migrations.Sql MigrationSqlGenerator MulticastDelegate System.Data.Entity.Core.Common DbXmlEnabledProviderManifest DbProviderServices designTimeVisible DbConnection connection MySql.Data MySqlCommand command System.Data.Entity.Core.Metadata.Edm PrimitiveType ColumnTypes get_CommandText set_CommandText get_CommandTimeout set_CommandTimeout CommandType get_CommandType set_CommandType get_DesignTimeVisible set_DesignTimeVisible get_DbConnection set_DbConnection DbTransaction get_DbTransaction set_DbTransaction DbParameterCollection get_DbParameterCollection UpdateRowSource get_UpdatedRowSource set_UpdatedRowSource Cancel DbParameter CreateDbParameter CommandBehavior ExecuteDbDataReader ExecuteNonQuery ExecuteScalar Prepare Clone System.Threading.Tasks Task`1 ExecuteNonQueryAsync ExecuteScalarAsync Task PrepareAsync .ctor CommandText CommandTimeout DesignTimeVisible UpdatedRowSource MySqlDataReader reader types get_Depth get_FieldCount get_HasRows get_IsClosed get_RecordsAffected get_Item Close GetBoolean GetByte GetBytes GetChar GetChars GetDataTypeName DateTime GetDateTime Decimal GetDecimal GetDouble System.Collections IEnumerator GetEnumerator Type GetFieldType GetFloat Guid GetGuid GetInt16 GetInt32 GetInt64 GetName GetOrdinal DataTable GetSchemaTable GetString GetValue ChangeType GetValues IsDBNull NextResult Read Dispose Depth FieldCount HasRows IsClosed RecordsAffected Item quoteChars QuoteIdentifier System.Text StringBuilder WriteSql ToString IEnumerable WriteList Accept Left Right get_Name set_Name get_IsWrapped set_IsWrapped get_Scoped set_Scoped Wrap WriteInnerSql GetColumnFromProperties <Name>k__BackingField <IsWrapped>k__BackingField <Scoped>k__BackingField Name IsWrapped Scoped Schema Table DefiningQuery TypeUsage System.Collections.Generic List`1 Columns Condition JoinType Visit _oldTableName _newTableName IsNegated Negate Operator WrapLeft WrapRight InList Argument When Then Else get_Literal set_Literal get_TableName set_TableName get_ColumnName set_ColumnName get_ColumnAlias set_ColumnAlias get_ActualColumnName get_PropertyFragment set_PropertyFragment PushInput Equals <Literal>k__BackingField <TableName>k__BackingField <ColumnName>k__BackingField <ColumnAlias>k__BackingField <PropertyFragment>k__BackingField Literal TableName ColumnName ColumnAlias ActualColumnName Distinct Quoted Pattern Escape Fragments Append get_Properties set_Properties get_LastProperty Trim PushProperty <Properties>k__BackingField Properties LastProperty get_Column set_Column get_Ascending set_Ascending <Column>k__BackingField <Ascending>k__BackingField Column Ascending HasDifferentNameForColumn tabs parameterCount scope propertyLevel Dictionary`2 EdmMember values Stack`1 Ops GetTopOp MySqlParameter get_Parameters set_Parameters DbCommandTree GenerateSQL CreateUniqueParameterName DbVariableReferenceExpression DbPropertyExpression DbScanExpression DbParameterReferenceExpression DbNotExpression DbIsEmptyExpression DbFunctionExpression DbConstantExpression DbComparisonExpression DbAndExpression DbOrExpression DbCastExpression DbInExpression DbLambdaExpression DbLikeExpression DbCaseExpression DbIsNullExpression DbIntersectExpression DbNullExpression DbArithmeticExpression DbNewInstanceExpression VisitNewInstanceExpression DbTreatExpression DbRelationshipNavigationExpression DbRefExpression DbOfTypeExpression DbIsOfExpression DbRefKeyExpression DbEntityRefExpression DbExceptExpression DbExpression DbDerefExpression DbApplyExpression DbUnionAllExpression DbSortExpression DbSkipExpression DbQuantifierExpression DbProjectExpression DbLimitExpression DbJoinExpression DbGroupByExpression DbFilterExpression DbElementExpression DbDistinctExpression DbCrossJoinExpression TryFusingSelect FuseSelectWithInnerSelect CanFuseSelect VisitAndReplaceTableName VisitInputExpression DbModificationCommandTree GenerateReturningSql TryPromoteToLike VisitBinaryExpression TryToPromoteToIn TryMergeTwoInFragments TryMergeTwoBinaryFragments TryMergeBinaryFragmentAndInFragment GetBinaryFragmentPartsForIn ShouldWrapExpression <Parameters>k__BackingField Parameters <CommandType>k__BackingField bitwiseFunctions dateFunctions stringFunctions mathFunctions geoFunctions callingGenerator .cctor Generate UserDefinedFunction BitwiseFunction GenericFunction HandleFunctionRound scopeTable Add Remove GetFragment FindInputFromProperties value__ Join Union selectStatements get_CurrentSelect TryFlatteningGroupBy DbFunctionAggregate HandleFunction DbExpressionBinding DbExpressionKind HandleJoinExpression WrapIfNotCompatible WrapJoinInputIfNecessary VisitInputExpressionEnsureSelect CurrentSelect _onReturningSelect _columnsVisited CreateConnection GetService IEnumerable`1 GetServices _providerName get_ProviderName ProviderName DbProviderFactory ResolveProviderFactory ResolveManifestToken _ctxType _providerType _customKey GetHashCode DbContext Create DbSpatialServices IDbExecutionStrategy errorsToRetryOn Nullable`1 TimeSpan Exception GetNextDelay ShouldRetryOn DEFAULT_MAX_RETRIES DEFAULT_MAX_DELAY _maxDelay _maxRetries _totalRetries Reset DbModelBuilder OnModelCreating Action`1 _action Write Encoding get_Encoding StreamWriter Logger TrimSchemaPrefix System.Data.Entity.Migrations.Model AddColumnOperation System.Data.Entity.Migrations.Utilities IndentedTextWriter AddForeignKeyOperation AddPrimaryKeyOperation AlterColumnOperation CreateIndexOperation CreateTableOperation DropColumnOperation DropForeignKeyOperation DropIndexOperation DropPrimaryKeyOperation DropTableOperation MoveTableOperation RenameColumnOperation RenameTableOperation MigrationStatement _specialStmts DbProviderManifest _providerManifest _dispatcher get__generatedTables set__generatedTables get__tableName set__tableName _providerManifestToken get_autoIncrementCols set_autoIncrementCols get_primaryKeyCols set_primaryKeyCols MigrationOperation UpdateDatabaseOperation HistoryOperation IList`1 ReplaceParemeters ICollection`1 GenerateProcedureBody CreateProcedureOperation GenerateProcedureCmd ParameterModel GenerateParamSentence BuildParamType ColumnModel SqlOperation <_generatedTables>k__BackingField <_tableName>k__BackingField <autoIncrementCols>k__BackingField <primaryKeyCols>k__BackingField _generatedTables _tableName autoIncrementCols primaryKeyCols Invoke IAsyncResult AsyncCallback BeginInvoke EndInvoke System.Resources ResourceManager resourceMan System.Globalization CultureInfo resourceCulture get_ResourceManager get_Culture set_Culture get_ConnectionMustBeOfTypeMySqlConnection get_NoStoreTypeForEdmType get_TypeNotSupported get_WrongFunctionResultType Culture ConnectionMustBeOfTypeMySqlConnection NoStoreTypeForEdmType TypeNotSupported WrongFunctionResultType get_Target set_Target get_Where set_Where <Target>k__BackingField <Where>k__BackingField Target Where get_Sets set_Sets get_Values set_Values ReturningSelect <Sets>k__BackingField <Values>k__BackingField Sets Values PrimitiveTypeKind GetNumericLiteral IsNumericType DbType GetDbType NormalizeValue ParameterDirection ParameterMode ModeToDirection IsComparisonOperator GetOperator EdmProperty EdmType GetProperties MetadataItem TryGetValueMetadataProperty T CHAR_MAXLEN VARCHAR_MAXLEN MEDIUMTEXT_MAXLEN LONGTEXT_MAXLEN BINARY_MAXLEN VARBINARY_MAXLEN MEDIUMBLOB_MAXLEN LONGBLOB_MAXLEN DEFAULT_DECIMAL_PRECISION DEFAULT_DECIMAL_SCALE manifestToken System.Xml XmlReader GetManifest GetDbInformation GetStoreSchemaMapping GetStoreSchemaDescription GetEdmType GetStoreType GetXmlResource GetMappingResource GetResourceAsString SupportsInExpression EntitySet GetTableCreateScript Instance Version get_serverVersion set_serverVersion DbCommandDefinition CreateDbCommandDefinition SetExpectedTypes DbQueryCommandTree SetQueryExpectedTypes DbFunctionCommandTree SetFunctionExpectedTypes GetDbProviderManifestToken GetDbProviderManifest StoreItemCollection DbCreateDatabase DbDatabaseExists DbDeleteDatabase DbCreateDatabaseScript AssociationType GetAssociationCreateScript _pluralizedNames _guidIdentityColumns GetColumnType GetFacetString IsStringType <serverVersion>k__BackingField serverVersion columnHash hasRenamedColumns generator From get_Columns set_Columns Limit Skip get_GroupBy set_GroupBy get_OrderBy set_OrderBy IsDistinct AddGroupBy AddOrderBy WriteOrderBy AddDefaultColumns AddColumn GetDefaultColumnsForFragment GetDefaultColumnsForTable MakeColumnNameUnique IsCompatible <Columns>k__BackingField <GroupBy>k__BackingField <OrderBy>k__BackingField GroupBy OrderBy value behavior cmd wrappedReader name ordinal dataOffset buffer bufferOffset length sourceValue targetType disposing id sql list visitor properties f oldTableName newTableName tableName columnName inputName obj s literal property column ascending commandTree expression select outer inner sf oldTable newTable e type tree returning left right op bf infLeft infRight inf lf System.Runtime.InteropServices OutAttribute cf caller funcs fragment input fa arg joinType joinCondition expressionKind isRightPart connectionString key contextType providerName providerType customKey other context lastException exception maxRetries maxDelay existingConnection defaultSchema modelBuilder action index count logPath append table addColumnOperation writer addForeignKeyOperation addPrimaryKeyOperation alterColumnOperation createIndexOperation createTableOperation dropColumnOperation dropForeignKeyOperation dropIndexOperation dropPrimaryKeyOperation dropTableOperation moveTableOperation renameColumnOperation renameTableOperation migrationOperations providerManifestToken updateDatabaseOperation parameters commandTrees rowsAffectedParameter po param object method callback result typeUsage mode mi version informationType storeType edmType resourceName resourceBaseName entitySet providerManifest commandTimeout storeItemCollection a IsKeyMember baseName System.Runtime.Versioning TargetFrameworkAttribute System.Reflection AssemblyTitleAttribute AssemblyDescriptionAttribute AssemblyConfigurationAttribute AssemblyCompanyAttribute AssemblyProductAttribute AssemblyCopyrightAttribute AssemblyTrademarkAttribute AssemblyCultureAttribute ComVisibleAttribute GuidAttribute AssemblyDelaySignAttribute AssemblyKeyNameAttribute System.Runtime.CompilerServices InternalsVisibleToAttribute AssemblyVersionAttribute AssemblyInformationalVersionAttribute NeutralResourcesLanguageAttribute System.Diagnostics DebuggableAttribute DebuggingModes CompilationRelaxationsAttribute RuntimeCompatibilityAttribute MySql.Data.Entity.EF6 MySqlConnection set_Connection MySqlConnectionStringBuilder get_Settings get_UseDefaultCommandTimeoutForEF get_DefaultCommandTimeout MySqlTransaction get_Transaction set_Transaction MySqlParameterCollection ExecuteReader <ExecuteNonQueryAsync>b__0 CompilerGeneratedAttribute TaskFactory get_Factory Func`1 StartNew <ExecuteScalarAsync>b__1 <PrepareAsync>b__2 Action DefaultMemberAttribute GC SuppressFinalize Boolean get_ClrEquivalentType DBNull GetType op_Inequality RuntimeTypeHandle GetTypeFromHandle op_Equality DateTimeOffset get_InvariantCulture Convert IFormatProvider String IndexOfAny Format get_Current MoveNext IDisposable Char <PrivateImplementationDetails>{0D816C5F-548C-4321-BB99-990A0C0D1598} ValueType __StaticArrayInitTypeSize=6 $$method0x60001eb-1 RuntimeHelpers Array RuntimeFieldHandle InitializeArray AppendFormat NotImplementedException Replace Enumerator get_Length set_Length get_Count IsNullOrEmpty LastIndexOf RemoveRange Insert Compare Empty Peek Int32 get_VariableName get_Instance get_Property EntitySetBase ReadOnlyMetadataCollection`1 MetadataProperty get_MetadataProperties TryGetValue get_Value EntityContainer get_EntityContainer get_ParameterName Concat DbUnaryExpression get_Argument get_ResultType get_EdmType get_PrimitiveTypeKind set_ParameterName set_DbType set_Value DbBinaryExpression get_Left get_Right get_ExpressionKind get_List get_Pattern get_Escape get_When get_Then get_Else NotSupportedException get_Arguments RowType System.Collections.ObjectModel ReadOnlyCollection`1 InvalidOperationException get_Expression EdmFunction get_Function get_FullName ToInt32 AddRange Contains DbDeleteCommandTree get_Predicate get_EdmFunction get_NamespaceName ContainsKey IEnumerator`1 DbInsertCommandTree DbModificationClause get_SetClauses DbSetClause get_Returning EntityTypeBase get_ElementType get_KeyMembers get_TypeUsage get_BaseType get_Query CompareOrdinal get_Input get_VariableType DbGroupExpressionBinding get_GroupVariableName CollectionType get_Keys DbAggregate get_Aggregates ToUpperInvariant get_Distinct get_Inputs get_Apply get_JoinCondition get_Projection DbSortClause get_SortOrder get_Limit DbUpdateCommandTree Push Pop <>c__DisplayClass2 <Visit>b__0 p Predicate`1 Find <.ctor>b__0 CS$<>9__CachedAnonymousMethodDelegate2 <.ctor>b__1 Func`3 CS$<>9__CachedAnonymousMethodDelegate3 AddDependencyResolver MySqlClientFactory SetProviderFactory SetProviderServices SetDefaultConnectionFactory SetMigrationSqlGenerator SetManifestTokenResolver SetHistoryContext MemberInfo TryParse Func`2 SingletonDependencyResolver`1 System.Core System.Linq Enumerable DbProviderFactories GetFactory GetProviderServices GetProviderManifestToken ReferenceEquals IsNullOrWhiteSpace IDbModelCacheKeyProvider get_CacheKey ValueCollection MySqlTrace LogInformation MySqlException get_Number get_Message get_HasValue Math Pow get_TotalSeconds Min FromSeconds <>f__AnonymousType0`1 <MigrationId>j__TPar <MigrationId>i__Field get_MigrationId MigrationId DebuggerBrowsableAttribute DebuggerBrowsableState DebuggerHiddenAttribute EqualityComparer`1 get_Default System.Data.Entity.ModelConfiguration EntityTypeConfiguration`1 Entity HistoryRow System.Linq.Expressions Expression ParameterExpression Parameter MethodBase RuntimeMethodHandle GetMethodFromHandle ConstructorInfo MethodInfo MemberExpression Property NewExpression New Expression`1 Lambda HasKey set_AutoFlush StartsWith get_Table ForeignKeyOperation get_PrincipalTable set_PrincipalTable get_DependentTable set_DependentTable PrimaryKeyOperation set_Table get_Inverse get_IsDestructiveChange IndexOperation get_PrimaryKey set_PrimaryKey get_NewSchema get_NewName <.ctor>b__2 <.ctor>b__3 <.ctor>b__4 <.ctor>b__5 <.ctor>b__6 <.ctor>b__7 <.ctor>b__8 <.ctor>b__9 <.ctor>b__a <.ctor>b__b <.ctor>b__c <.ctor>b__d <.ctor>b__e <.ctor>b__f <.ctor>b__10 <.ctor>b__11 GetProviderManifest ArgumentNullException Migration get_Migrations Any AppendLine get_HistoryQueryTrees get_Operations get_Sql EndsWith set_Sql get_CommandTrees DbCommandTreeKind get_CommandTreeKind get_DbType BitConverter ProcedureOperation get_BodySql get_IsOutParameter PropertyModel Substring ToLower get_MaxLength get_Precision get_Scale Byte <Generate>b__27 c CS$<>9__CachedAnonymousMethodDelegate29 <Generate>b__28 CS$<>9__CachedAnonymousMethodDelegate2a get_DependentColumns Select get_PrincipalColumns get_CascadeDelete StringComparison get_ClrType get_IsArray get_IsIdentity get_IsNullable GetValueOrDefault get_DefaultValueSql <>c__DisplayClass2e sortOrder <Generate>b__2d get_IsUnique IDictionary`2 get_AnonymousArguments <>c__DisplayClass38 keyFields <>4__this <Generate>b__35 col <Generate>b__32 <Generate>b__33 <Generate>b__34 CS$<>9__CachedAnonymousMethodDelegate37 Clear ToList ForEach <Generate>b__3c CS$<>9__CachedAnonymousMethodDelegate3d get_SuppressTransaction set_SuppressTransaction System.CodeDom.Compiler GeneratedCodeAttribute DebuggerNonUserCodeAttribute Assembly get_Assembly System.ComponentModel EditorBrowsableAttribute EditorBrowsableState Double Single get_DateTime get_Year $$method0x60001a4-1 EntityType ComplexType System.Data.Entity.Core ProviderIncompatibleException Parse ToLowerInvariant get_StoreTypeNameToEdmPrimitiveType ArgumentException CreateBinaryTypeUsage Facet get_Facets get_IsUnbounded CreateStringTypeUsage CreateDefaultTypeUsage get_StoreTypeNameToStorePrimitiveType CreateDecimalTypeUsage GetExecutingAssembly Stream GetManifestResourceStream StringReader TextReader StreamReader ReadToEnd Open get_ServerVersion MySql.Data.Common DBVersion get_Major get_Minor KeyValuePair`2 CreateParameter get_Key set_Direction FunctionParameter get_Mode CreateCommandDefinition StructuralType get_Members BuiltInTypeKind get_BuiltInTypeKind DbConnectionStringBuilder get_ConnectionString set_Database get_Database set_ConnectionString MySqlScript Execute GetSchema DataRowCollection get_Rows InternalDataCollectionBase get_Now ItemCollection GetItems get_BaseEntitySets OfType AssociationSet get_IsForeignKey ReferentialConstraint get_ReferentialConstraints get_ToProperties get_DeclaringType get_FromProperties NewGuid AssociationEndMember get_AssociationEndMembers RelationshipEndMember OperationAction get_DeleteBehavior Environment get_NewLine op_GreaterThanOrEqual ToByte StoreGeneratedPattern ToUpper MySql.Data.Entity.Properties.Resources.resources MySql.Data.Entity.Properties.SchemaMapping.msl MySql.Data.Entity.Properties.SchemaDefinition-5.0.ssdl MySql.Data.Entity.Properties.SchemaDefinition-5.5.ssdl MySql.Data.Entity.Properties.SchemaDefinition-5.1.ssdl MySql.Data.Entity.Properties.SchemaDefinition-5.6.ssdl MySql.Data.Entity.Properties.ProviderManifest.xml ` { 0 } `
, ( ) A S { 0 } ( { 0 } ) { 0 } { 0 } O N = N O T ( ! = N O T
I N ( , ) C A S E W H E N ( ) T H E N ( ) E L S E ( E N D { 0 } . N O T E X I S T S ( { 0 } ( { 1 } D I S T I N C T I S { 0 } N U L L N O T
L I K E E S C A P E { 0 } D E S C A S C U N I O N A L L ! U N I O N D I S T I N C T
@ g p { 0 } D e f i n i n g Q u e r y
S c h e m a T a b l e @ 0 1 A N D O R N U L L - ( / - % * + E d m . I n d e x O f
' { 0 } % ' ' ' ' E d m . R e v e r s e
' % { 0 } ' > ' % { 0 } % ' E d m . R i g h t E d m . L e n g t h
t a r g e t )C o m m a n d T e x t A t t r i b u t e 5S t o r e F u n c t i o n N a m e A t t r i b u t e B i t w i s e A n d & B i t w i s e N o t ! B i t w i s e O r | B i t w i s e X o r ^ C u r r e n t D a t e T i m e N O W ( ) Y e a r Y E A R ( { 0 } ) M o n t h M O N T H ( { 0 } ) D a y D A Y ( { 0 } ) H o u r H O U R ( { 0 } )
M i n u t e M I N U T E ( { 0 } )
S e c o n d S E C O N D ( { 0 } )
C o n c a t !C O N C A T ( { 0 } , { 1 } ) I n d e x O f !L O C A T E ( { 0 } , { 1 } ) L e f t L E F T ( { 0 } , { 1 } )
L e n g t h L E N G T H ( { 0 } ) L T r i m L T R I M ( { 0 } ) R e p l a c e -R E P L A C E ( { 0 } , { 1 } , { 2 } ) R e v e r s e R E V E R S E ( { 0 } ) R i g h t R I G H T ( { 0 } , { 1 } ) R T r i m R T R I M ( { 0 } ) S u b s t r i n g +S U B S T R ( { 0 } , { 1 } , { 2 } ) T o L o w e r L O W E R ( { 0 } ) T o U p p e r U P P E R ( { 0 } ) T r i m T R I M ( { 0 } ) A b s A B S ( { 0 } ) C e i l i n g C E I L I N G ( { 0 } ) F l o o r F L O O R ( { 0 } ) R o u n d R O U N D !S p a t i a l D i m e n s i o n D i m e n s i o n ( { 0 } ) S p a t i a l E n v e l o p e E n v e l o p e ( { 0 } ) !I s S i m p l e G e o m e t r y I s S i m p l e ( { 0 } ) S p a t i a l T y p e N a m e #G e o m e t r y T y p e ( { 0 } ) %C o o r d i n a t e S y s t e m I d S R I D ( { 0 } ) P o i n t P O I N T ( { 0 } , { 1 } ) X C o o r d i n a t e
X ( { 0 } ) Y C o o r d i n a t e
Y ( { 0 } ) !G e o m e t r y F r o m T e x t #G e o m F r o m T e x t ( { 0 } ) S p a t i a l C o n t a i n s +M B R C o n t a i n s ( { 0 } , { 1 } )
A s T e x t A s T e x t ( { 0 } ) S p a t i a l B u f f e r !B u f f e r ( { 0 } , { 1 } ) #S p a t i a l D i f f e r e n c e )D i f f e r e n c e ( { 0 } , { 1 } ) 'S p a t i a l I n t e r s e c t i o n +I n t e r s e c t i o n ( { 0 } , { 1 } ) D i s t a n c e G L e n g t h ( L i n e S t r i n g ( G E O M F R O M W K B ( A S B I N A R Y ( { 0 } ) ) , G E O M F R O M W K B ( A S B I N A R Y ( { 1 } ) ) ) ) !B u i l t I n A t t r i b u t e 1N i l a d i c F u n c t i o n A t t r i b u t e QN i l a d i c f u n c t i o n s c a n n o t h a v e p a r a m e t e r s { 0 } ( { 1 } ) ! r o w _ c o u n t ( ) > 0 !l a s t _ i n s e r t _ i d ( ) G u i d KA N Y ( S E L E C T g u i d F R O M t m p I d e n t i t y _ { 0 } ) A N D ` { 0 } ` = C 0 C 1 K { 0 } E d m B i g C o u n t C O U N T X + r o w _ c o u n t ( ) > 0 a n d -M y S q l . D a t a . M y S q l C l i e n t R e T r y i n g t o r e t r y f o r n o n t r a n s i e n t e x c e p t i o n n u m b e r : { 0 } , m e s s a g e : { 1 } AR e t r y i n g q u e r y f o r e x c e p t i o n { 0 } !{ M i g r a t i o n I d = } h d b o . %A d d C o l u m n O p e r a t i o n -A d d F o r e i g n K e y O p e r a t i o n -A d d P r i m a r y K e y O p e r a t i o n )A l t e r C o l u m n O p e r a t i o n )C r e a t e I n d e x O p e r a t i o n )C r e a t e T a b l e O p e r a t i o n 'D r o p C o l u m n O p e r a t i o n /D r o p F o r e i g n K e y O p e r a t i o n %D r o p I n d e x O p e r a t i o n /D r o p P r i m a r y K e y O p e r a t i o n %D r o p T a b l e O p e r a t i o n %M o v e T a b l e O p e r a t i o n +R e n a m e C o l u m n O p e r a t i o n )R e n a m e T a b l e O p e r a t i o n S q l O p e r a t i o n !H i s t o r y O p e r a t i o n 1C r e a t e P r o c e d u r e O p e r a t i o n /U p d a t e D a t a b a s e O p e r a t i o n ?D R O P P R O C E D U R E I F E X I S T S ` { 0 } ` ; %_ i d e m p o t e n t _ s c r i p t D E L I M I T E R / / 1C R E A T E P R O C E D U R E ` { 0 } ` ( ) B E G I N A D E C L A R E C u r r e n t M i g r a t i o n T E X T ; i I F E X I S T S ( S E L E C T 1 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 U W H E R E t a b l e _ n a m e = ' _ _ M i g r a t i o n H i s t o r y ' M A N D t a b l e _ s c h e m a = D A T A B A S E ( ) ) T H E N 9 S E T C u r r e n t M i g r a t i o n = ( ) ; E N D I F ; E I F C u r r e n t M i g r a t i o n I S N U L L T H E N ? S E T C u r r e n t M i g r a t i o n = ' 0 ' ; 3 I F C u r r e n t M i g r a t i o n < ' ' T H E N ;
E N D / / D E L I M I T E R ; C A L L ` { 0 } ` ( ) ; d b o 0 x 7C R E A T E P R O C E D U R E ` { 0 } ` ( { 1 } )
B E G I N E N D { 0 } { 1 } { 2 } , I N O U T c h a r v a r c h a r
( { 0 } ) ( { 0 } , { 1 } ) Ea l t e r t a b l e ` { 0 } ` a d d c o l u m n ` { 1 } ` Ga l t e r t a b l e ` { 0 } ` d r o p c o l u m n ` { 1 } ` a l t e r t a b l e ` ` m o d i f y ` ` ss e t @ c o l u m n T y p e : = ( s e l e c t c a s e l o w e r ( I S _ N U L L A B L E ) w h e n ' n o ' t h e n C O N C A T ( c o l u m n _ t y p e , ' n o t n u l l ' ) w h e n ' y e s ' t h e n c o l u m n _ t y p e e n d f r o m i n f o r m a t i o n _ s c h e m a . c o l u m n s w h e r e t a b l e _ n a m e = ' +' a n d c o l u m n _ n a m e = ' ' ) ; [s e t @ s q l s t m t : = ( s e l e c t c o n c a t ( ' a l t e r t a b l e ` ` c h a n g e ` ` ` )` ' , @ c o l u m n T y p e ) ) ; 7p r e p a r e s t m t f r o m @ s q l s t m t ; e x e c u t e s t m t ; 1d e a l l o c a t e p r e p a r e s t m t ; ` %` a d d c o n s t r a i n t ` ` f o r e i g n k e y r e f e r e n c e s ` ` ( K o n u p d a t e c a s c a d e o n d e l e t e c a s c a d e d a t e t i m e t i m e s t a m p t i m e ; D E F A U L T C U R R E N T _ T I M E S T A M P { 0 } ( { 0 } n o t n u l l u n s i g n e d t i n y i n t s m a l l i n t m e d i u m i n t i n t
b i g i n t ! a u t o _ i n c r e m e n t C H A R ( 3 6 ) B I N A R Y SD R O P T R I G G E R I F E X I S T S ` { 0 } _ I d e n t i t y T g r ` ; oC R E A T E T R I G G E R ` { 0 } _ I d e n t i t y T g r ` B E F O R E I N S E R T O N ` { 0 } ` %F O R E A C H R O W B E G I N +S E T N E W . { 0 } = U U I D ( ) ; _D R O P T E M P O R A R Y T A B L E I F E X I S T S t m p I d e n t i t y _ { 0 } ; C R E A T E T E M P O R A R Y T A B L E t m p I d e n t i t y _ { 0 } ( g u i d C H A R ( 3 6 ) ) E N G I N E = M E M O R Y ; YI N S E R T I N T O t m p I d e n t i t y _ { 0 } V A L U E S ( N e w . { 1 } ) ; d e f a u l t { 0 } Qa l t e r t a b l e ` { 0 } ` d r o p f o r e i g n k e y ` { 1 } ` C R E A T E U N I Q U E S o r t A s c e n d i n g /i n d e x ` { 0 } ` o n ` { 1 } ` ( T y p e B T r e e H A S H B T R E E
u s i n g Ea l t e r t a b l e ` { 0 } ` d r o p i n d e x ` { 1 } ` K E Y ( ` { 0 } ` ) , c r e a t e t a b l e ` ` ( p r i m a r y k e y ( A) e n g i n e = I n n o D b a u t o _ i n c r e m e n t = 0 d r o p t a b l e ` %` a d d p r i m a r y k e y ` 'D e l e t e A u t o I n c r e m e n t ; a l t e r t a b l e ` '` d r o p p r i m a r y k e y 7r e n a m e t a b l e ` { 0 } ` t o ` { 1 } ` MM y S q l . D a t a . E n t i t y . P r o p e r t i e s . R e s o u r c e s KC o n n e c t i o n M u s t B e O f T y p e M y S q l C o n n e c t i o n +N o S t o r e T y p e F o r E d m T y p e !T y p e N o t S u p p o r t e d /W r o n g F u n c t i o n R e s u l t T y p e D E L E T E F R O M W H E R E 9S E T S E S S I O N s q l _ m o d e = ' A N S I ' ; I N S E R T I N T O V A L U E S ;
R ;U n k n o w n P r i m i t i v e T y p e K i n d { 0 } < < = > = ! = L E F T O U T E R J O I N I N N E R J O I N C R O S S J O I N O U T E R J O I N ;e x p r e s s i o n k i n d n o t s u p p o r t e d cM y S q l . D a t a . E n t i t y . P r o p e r t i e s . P r o v i d e r M a n i f e s t . x m l +S t o r e S c h e m a D e f i n i t i o n %S t o r e S c h e m a M a p p i n g sT h e p r o v i d e r r e t u r n e d n u l l f o r t h e i n f o r m a t i o n T y p e ' { 0 } ' . #S c h e m a M a p p i n g . m s l aY o u r v e r s i o n o f M y S Q L i s n o t c u r r e n t l y s u p p o r t e d 3S c h e m a D e f i n i t i o n - 5 . 0 . s s d l 3S c h e m a D e f i n i t i o n - 5 . 1 . s s d l 3S c h e m a D e f i n i t i o n - 5 . 5 . s s d l 3S c h e m a D e f i n i t i o n - 5 . 6 . s s d l s t o r e T y p e qT h e u n d e r l y i n g p r o v i d e r d o e s n o t s u p p o r t t h e t y p e ' { 0 } ' . M a x L e n g t h e d m T y p e b o o l u t i n y i n t g u i d
d o u b l e f l o a t P r e c i s i o n S c a l e d e c i m a l F i x e d L e n g t h t i n y b l o b b l o b m e d i u m b l o b l o n g b l o b U n i c o d e n c h a r M a x n v a r c h a r m e d i u m t e x t l o n g t e x t AM y S q l . D a t a . E n t i t y . P r o p e r t i e s . { 0 } " . 5 . 5 c o m m a n d T r e e uV e r s i o n s o f M y S Q L p r i o r t o 5 . 0 a r e n o t c u r r e n t l y s u p p o r t e d 5 . 0 5 . 1 5 . 6 c o n n e c t i o n KC R E A T E D A T A B A S E ` { 0 } ` ; U S E ` { 0 } ` ; { 1 } D a t a b a s e s ;D R O P D A T A B A S E I F E X I S T S ` { 0 } ` - - M y S q l s c r i p t - - C r e a t e d o n F K _ IA L T E R T A B L E ` { 0 } ` A D D C O N S T R A I N T { 1 } F O R E I G N K E Y ( EA L T E R T A B L E ` { 0 } ` A D D K E Y ( ` { 1 } ` ) ;
{ 0 } { 1 } # R E F E R E N C E S { 0 } ( ; O N D E L E T E { 0 } O N U P D A T E { 1 } ; N O A C T I O N C R E A T E T A B L E
` { 0 } ` ( '{ 0 } { 1 } ` { 2 } ` { 3 } { 4 } GA L T E R T A B L E ` { 0 } ` A D D P R I M A R Y K E Y ( D E L I M I T E R | | WC R E A T E T R I G G E R ` { 0 } ` B E F O R E I N S E R T O N ` { 1 } ` _ I d e n t i t y T g r ' F O R E A C H R O W B E G I N c D R O P T E M P O R A R Y T A B L E I F E X I S T S t m p I d e n t i t y _ { 0 } ; C R E A T E T E M P O R A R Y T A B L E t m p I d e n t i t y _ { 0 } ( g u i d C H A R ( 3 6 ) ) E N G I N E = M E M O R Y ; 1 S E T @ v a r _ { 0 } = U U I D ( ) ; _ I N S E R T I N T O t m p I d e n t i t y _ { 0 } V A L U E S ( @ v a r _ { 1 } ) ; 3 S E T n e w . { 0 } = @ v a r _ { 0 } ; / S E T n e w . { 0 } = U U I D ( ) ; E N D | | u U N S I G N E D
S t r i n g t e x t
( { 0 } ) D e c i m a l D a t e T i m e ( { 0 } ) N u l l a b l e N O T N U L L +S t o r e G e n e r a t e d P a t t e r n I n t - A U T O _ I N C R E M E N T U N I Q U E ;I n v a l i d i d e n t i t y c o l u m n t y p e .
S E L E C T D I S T I N C T
F R O M
W H E R E
G R O U P B Y L I M I T { 0 } , )1 8 4 4 6 7 4 4 0 7 3 7 0 9 5 5 1 6 1 5
O R D E R B Y U P D A T E S E T _l
T!C
z\V4YhȉiM] a e e Y Y i i m q q u
y } } ( ( ( e( ( Y( i( m( q
( ( t 8T8 D 4 < H @ 0 , 8 P P8 T T 8 T( ( T ( 8t x x
! % ) - 1 5 9 = A E I M Q U Y ] a e i m q 9 u9 H99 99 , 000 0,, 0,0 ,P8 9
( e` ` Tx y }}9 9( Y ,M y S q l . D a t a . M y S q l C l i e n t Y Y 5
Y (
u
! ! ! !
( ( % ) -1
59 = ? A A A A E I I M Q U YY YY Y ] E 5 I( I 8 ` 8
8 X
X X 8t 8 8 X ( 8 ( X $ $ RSA1 s qu,x)A&JACq_<_e Z@gюzF}zQ$q(X
i $[JNP c O\Nec2 n8b1A
lk> y 0}
Item
8 P P PP T TxT 9 0
T8\ !
%)%) - !) (<l 9 % ) %
99 9 80PH4DL
%5A58
=8XX* ,XXXX
8$ }L I HH, 00,,0,
8P8P0 8PM UI
9 Q Q9@L9Q9
YYQY
)
U}]]9QYQY a
%% e e L!%e \T
Q9
@8@ i
qqq+im=98qy8Q9@
}}8! }}888 8
uuQuuQu
\y ]9QY, } } } II =Y Y= % U !I I 1
Y= Y=
55
UY
(
0
0
Q
Q
8Q&Q
QQQQ Q
Q5 |QQQQQ
uuQu `uQuQ )
Q`uQu
Q Q
,
f
%
@ 3System.Resources.Tools.StronglyTypedResourceBuilder4.0.0.0 ) ) ! 1
%
a%
a1 ) A
aa a
%M%M
a a 9aM a a "a%MMMM% ) Q AQ)Q AYU Q )Q] a II a eeQe e -
%i%i 1 M0
`IeuiuQeAU9ma qm9%a
a
y } ]
0 A
-A-Q-
%!
EEQE
Q ]&-EQ-QEQ
%A m %5e5
%A 2==55e5e5 = ) =5e5 e MM%MMM8888'88888885Q5858Q5 88G .NETFramework,Version=v4.0 TFrameworkDisplayName.NET Framework 4 MySql.Data.Entity for EF6 # Entity Framework 6.0 supported Oracle MySql.Data.Entity P KCopyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved. ) $540e7b3c-bd0b-4980-96d1-5d140d303f7e ConnectorNet k eMySql.Data.Entity.Tests, PublicKey = 0024000004800000940000000602000000240000525341310004000001000100d973bda91f71752c78294126974a41a08643168271f65fc0fb3cd45f658da01fbca75ac74067d18e7afbf1467d7a519ce0248b13719717281bb4ddd4ecd71a580dfe0912dfc3690b1d24c7e1975bf7eed90e4ab14e10501eedf763bff8ac204f955c9c15c2cf4ebf6563d8320b6ea8d1ea3807623141f4b81ae30a6c886b3ee1 v pMySql.Data.Entity.Migrations.Tests, PublicKey = 0024000004800000940000000602000000240000525341310004000001000100d973bda91f71752c78294126974a41a08643168271f65fc0fb3cd45f658da01fbca75ac74067d18e7afbf1467d7a519ce0248b13719717281bb4ddd4ecd71a580dfe0912dfc3690b1d24c7e1975bf7eed90e4ab14e10501eedf763bff8ac204f955c9c15c2cf4ebf6563d8320b6ea8d1ea3807623141f4b81ae30a6c886b3ee1 u oMySql.Data.Entity.CodeFirst.Tests, PublicKey = 0024000004800000940000000602000000240000525341310004000001000100d973bda91f71752c78294126974a41a08643168271f65fc0fb3cd45f658da01fbca75ac74067d18e7afbf1467d7a519ce0248b13719717281bb4ddd4ecd71a580dfe0912dfc3690b1d24c7e1975bf7eed90e4ab14e10501eedf763bff8ac204f955c9c15c2cf4ebf6563d8320b6ea8d1ea3807623141f4b81ae30a6c886b3ee1
6.8.3
en-US TWrapNonExceptionThrows ڰR p p RSDS 4`JYOX* c:\Jenkins\Jobs\C_Net_6_8_Compilation\Workspace\Source\MySql.Data.Entity\obj\ReleaseEF6\MySql.Data.Entity.EF6.pdb _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 h S t r i n g F i l e I n f o D 0 0 0 0 0 4 b 0 X C o m m e n t s E n t i t y F r a m e w o r k 6 . 0 s u p p o r t e d 0 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 . D a t a . E n t i t y f o r E F 6 0 F i l e V e r s i o n 6 . 8 . 3 . 0 T I n t e r n a l N a m e M y S q l . D a t a . E n t i t y . E F 6 . 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 8 , 2 0 1 3 , 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 . \ O r i g i n a l F i l e n a m e M y S q l . D a t a . E n t i t y . E F 6 . d l l D P r o d u c t N a m e M y S q l . D a t a . E n t i t y 0 P r o d u c t V e r s i o n 6 . 8 . 3 8 A s s e m b l y V e r s i o n 6 . 8 . 3 . 0 ;