c1(0-,zz|~*.88Vfffffffvvvyn38Cٖ%< KzBrJbRezervasiun_logcc@RD/MRezervasiun ZX4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZX4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZX4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZY4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlcc@RD/MRezervasiun ZY4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZX[4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlcc@RD/MRezervasiun ZX[4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZX[4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZX4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXlccRD/MRezervasiun ZX4aҲDoHZrrh ҲDoHZrrhc/Mw KPD&nXl `@W 4@{ߐ|> |$dШ4LШ4\43C4\44ɞVR4R34+R4+X4k4B4}34@{@{Ө4hh(Ԩ4Y:TԨ4<@{TԨ4Ԩ4y*xԨ4ب4P ; @{; ը4~==`sDը4W hs=${\4 ; ը4=64@{64_64T4=64T44hը4$ب4s_ը4N'{ר4{ը4(@{hר4"x@{54${D>=_54T4=T4D>D>D>0=T4\6 @{d6 `-; @{,; =D>d{ר4ר4.Eר4ר4ب4xר4,ר4`4ب4{_xר444`\44 a@ب4ب4`4-M\4_\4p4 `dب4`ب4\4 $`4Lۨ4dۨ4hhۨ4Y7ۨ4ۨ4hhۨ4YD9ܨ4<@{@ܨ4ߨ4ܨ4ܨ4y*xXܨ4ߨ4 1 @{ԧ1 ==`sܨ4W hsܨ4~ܨ4~==`s ݨ4W hs=${\4@1 ݨ4=>4@{>4T4>4g>4T4=>4T440ݨ4ߨ4s_ݨ4N'{ި4{ݨ4(@{0ߨ4"x@{T4D>D>D>0T4D>D>D>=4${D>=`ި4${g=4T4=T4D>D>D>0=T4b, @{,a, \1 @{d1 =D>d{ߨ4hߨ4.Eߨ4ߨ4ߨ4xߨ4,ߨ4`ߨ4{_xߨ4<4`\4`4 a@ߨ4ߨ4`t4-M\4PW `/Mc5/MWc|@Ө4hh(Ԩ4@:TԨ4<@{TԨ4Ԩ4y*xԨ4ب4P ; @{; ը4~==`sDը4W hs=${\4 ; ը4=64@{64_64T4=64T44hը4$ب4s_ը4N'{ר4{ը4(@{hר4"x@{54${D>=_54T4=T4D>D>D>0=T4\6 @{d6 `-; @{,; =D>d{ר4ר4.Eר4ר4ب4xר4,ר4`4ب4{_xר444`\44 a@@ب4ب4`4-M\4_\4p4 `dب4`ب4\4 $`4@Lۨ4dۨ4hhۨ4Y7ۨ4ۨ4hhۨ4YD9ܨ4<@{@ܨ4ߨ4ܨ4ܨ4y*xXܨ4@ߨ4 1 @{ԧ1 ==`sܨ4W hsܨ4~ܨ4~==`s ݨ4W hs=${\4@1 ݨ4=>4@{>4T4>4g>4T4=>4T440ݨ4ߨ4s_ݨ4N'{ި4{ݨ4(@{0ߨ4"x@{T4D>D>D>0T4HD>D>D>=4${D>=`ި4${g=4T4=T4D>D>D>0=T4b, @{,a, \1 @{d1 =D>d{ߨ4hߨ4.Eߨ4ߨ4ߨ4xߨ4,ߨ4`ߨ4{_xߨ4<4`\4`4 a@ߨ4ߨ4`t4-M@YPW48074!0MRemapSysfiles1P{_(>W7ULL   66hh   L Ga"x IE%jXmodeldevRezervasiunmodelRezervasiun>W7ULWL H   66  L 0@KzBrJbmodel"Rezervasiun_modelRezervasiun_0W7!0MWX.W084!0MRezervasiuneP{_(>W8 cV8$ >W8 cWAax IE%jXmodeldevRezervasiunmodelRezervasiun>W7ULWL P4W(094c!0MUpdate SysusersP{_(W9 W9 "E">W9_ 2 6   7Fj6 @ >W9_W(6(P{_( H 5>W9[ 3**ESnAUnAU 1228dboUnAU*0M 1MMSdboP{_(u  GfM0W9*0MW84TP4.0W\x>W8ULWL0x IE%jRezervasiunC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Rezervasiu@.mdf  L Ga"6 LW>W8ULWL10x IE%jRezervasiunC:\Program Files\Microsoft SQL Se@ver\MSSQL.1\MSSQL\DATA\Rezervasiun.mdf L Ga">W8ULWL0  KzBrJb"Rezervasiun_logC:\Program Files\Microsof@ SQL Server\MSSQL.1\MSSQL\DATA\Rezervasiun_log.ldf L 0>W8ULWL0  KzBrJb"Rezervasiun_logC:\Program @iles\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Rezervasiun_log.ldf L 0h!5-=h"@BCWD@ EW FW @GW HW @IWJW WL5-@=WL@h L@@WL@WL @WL @@WL@WL @@WL @WL @WL @ @WL @WL @@WL @WL @WL@ @W L@W!L@@W"L@W#L@W$@L @W%L@W&L @@W'L@W(L@@)L@W*L@W+L@@W,L@W-L@@W.L@W/L@W0L@"W5-=>W`H/0MWc9-,-\,+*))L(|'&% %<$l#"! , \L| <l,\L| < l h\$WWWFtrnX0W5 m288WWT &W4/0MW4cpRezervasiunC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RezervasiuXbW6Y_@W8\gZ W30M&W4/0MW4cpRezervasiunC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RezervasiuXRW7f0W830MW30M&W4/0MW4cpRezervasiunC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RezervasiuXW8&k > _W6 W`W4c0Mc9\RezervasiunC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RezervasiuXW9b6W8g0MW8cc0Mc9\RezervasiunC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RezervasiuXW: 00;4 1MStartupDBP{_(>W:; cW$ @ XbW;Ы#@W:;_gZW:1MDBP{_(>W:; cW$ @ XRW<#0W:;1MW:1MDBP{_(>W:; cW$ @ XW=11 0<41MInvP{_(>W=< cW::ZZx @ XbW>鯊#@W=<agZW=1MP{_(>W=< cW::ZZx @ XRW?#0W=<1MW=1MP{_(>W=< cW::ZZx @ X~W@T`W81Mc<=< cW::ZZx @ XWA}:@W@1MW@c:ZZx @ XWB30>4 O2MStartupDBP{_(>WB> cW=$ @ XbWC#@WB>dgZWBS2MDBP{_(>WB> cW=$ @ XRWD#0WB>X2MWBS2MDBP{_(>WB> cW=$ @ XWE.2w`0?4]2M@ALTER DATABASE OPTION STATE CHANP{_(>WE? cWB$ XbWF۩c@WE?jg[PWEa2MATABASE OPTION STATE CHANP{_(>WE? cWB$ XRWGc0WE?a2MWEa2MATABASE OPTION STATE CHANP{_(>WE? cWB$ P 8WH;T0@42M"CREATE STATISTICSTP{_(WH@WH@ @ >WH@|:6` 6a0'@  a_WA_Sys_00000004_00000040 6 M:*A>WH@~6`6B6@ B_W@_Sys_00000004_00000040 6 >WH@<@<"0<@  " < O.>WH@e7`7@  7 N>WH@<WH<   "$2M?@@`A@>'PA???<@  < O.>WH@|:6WH6   @  6 M:*A0WHH2MWHĸ4|LH@AP WL>@r0A3 NM"CREATE STATISTICSTP{_(WLAWLA 1 >WLA|$6WH 6a0'1  a_WA_Sys_00000002_00000031 6 <t>WLA~6WH6B61 B_W@_Sys_00000002_00000031 6 w՜7n>WLA<  <"0<1  " < x>WLA=7WH71  7 =8p>WLA<WL< "<1  < x>WLA|$6WL6H  1  6 <t0WLANMWL̸4`<LH>'PA???<@  < O.>WH@|:6WH6   @  6 M:*A0WH AP WO9L0B3NM"CREATE STATISTICSTP{_(WOBWOB 1 >WOB|%6WL 6a0'1  a_WA_Sys_00000003_00000031 6 =l>WOB~ 6WL6B61 B_W@_Sys_00000003_00000031 6 w>WOB<WL<"0<1  " < yk>WOB>7WL71  7 >1>WOB<WO< "<1  < yk>WOB|%6WO6H  1  6 =l0WOBNMWO̸4`<LH>'PA???<@  < O.>WH@|:6WH6   @  6 M:*A0WH AP WRd 0C3NM"CREATE STATISTICSTP{_(WRCWRC 1 >WRC|&6WO 6a0'1  a_WA_Sys_00000004_00000031 6 >!>WRC~6WO6B61 B_W@_Sys_00000004_00000031 6 w >WRC<WO<"0<1  " < zy>WRC?7WO71  7 ?O1(>WRC<WR< "<1  < zy>WRC|&6WR6H  1  6 >!0WRCNMWR̸4`<LH>'PA???<@  < O.>WH@|:6WH6   @  6 M:*A0WH AP TWU1?g0D3NM"CREATE STATISTICSTP{_(WUDWUD " >WUD|6WR 6a0'"  a_WA_Sys_00000005_00000022 6 /`>WUD~6WR6B6" B_W@_Sys_00000005_00000022 6 i!W>WUD<`<"0<"  " < kG>WUD)7WR7"  7 0CS>WUD<WU<   " $QNM//>@@ < kG>WUD|6WU6    "  6H /`M0WUDNMWU̸4 LHAP 8WYSI0E404hWM"CREATE STATISTICSTP{_(WYEWYE ">WYE|6WU 6a0'" a_WA_Sys_00000003_00000022 6 02Q>WYE~ 6WU6B6"B_W@_Sys_00000003_00000022 6 is>WYE<WU<"0<" " < lȌ>WYE*7WU7" 7 1 >WYE<WY<   " $7hWM//?@@'@@?0B??<" < lȌ>WYE|6WY6   6" 6 02Q0WYHhWMWY̸04|LH̸4 LHEAP  W]pϧ\0F5 \M"CREATE STATISTICSTP{_(W]FW]F < >W]F|;6WY 6a0'<  a_WA_Sys_00000002_0000003C 6 Gᾟ>W]F~6WY6B6< B_W@_Sys_00000002_0000003C 6 >W]F<WH<"0<<  " < z!>W]Fd7WY7<  7 H&9p>W]F<W]<   " $}\Moo>.<@**@B@Pg~6Md{3Jax@0G^u????@@??? ??????@?@?A?"@?)@?,@@@1@@?2@?3@@?6@?7@?:@@?<@?@??A@@?C??D@@?E??G??H??I@?J@?K@?L@?N@?Z@?[??\@?]??^@@?_@@?`@?a??eH?Xv@@@<8z<<  < z!>W]F|;6W]6   <  6 Gᾟ0W]F\MW]84 T LH@AP L Wc| k0G5\M"CREATE STATISTICSTP{_(WcGWcG < >WcG|<6W] 6a0'<  a_WA_Sys_00000003_0000003C 6 Hi>WcG~6W]6B6< B_W@_Sys_00000003_0000003C 6 卒[>WcG<W]<"0<<  " < c+>WcGe7W]7<  7 I?0z>WcG<Wc<   " $~\Mpp.=@ @B@UXo'>,B?A?A?@???@A?  AH? @? @@?????<<  < c+>WcG|<6Wc6  ? <  6 Hi0WcG\MWc84ALH@?)@?,@@@1@@?2@?3@@?6@?7@?:APdWga\0H5\M"CREATE STATISTICSTP{_(WgHWgH < >WgH|=6Wc 6a0'<  a_WA_Sys_00000004_0000003C 6 Iyպ>WgH~6Wc6B6< B_W@_Sys_00000004_0000003C 6 j>WgH<Wc<"0<<  " < n>WgHf7Wc7<  7 J00I5Y\MSplitPage"P{_(>WgI <W8 @@Wg I<PWg I<>Wg I<Wg Mx""""""""0<@$M|?%I=%I=%I= $A`A$A?@@h6c3P0??3db_accessadmin0??9db_backupoperator0??1db_datareader0??1db_datawriter0??-db_ddladmin0??9d@_denydatareader0??9db_denydatawriter0??'db_owner0??7db_securityadmin0??dbo0???;INFORMATION_SCHEMA0??%PRIMARY0??sys ((?db_accessadmindatareaderwriterenydatareaderownerguestPRIMARYsys@@ @%++05< 0<@ $xf?ى=@`A@@Wn@@?????????@??@??@?@? @0<@ $f?@`A@@:w%PA???FG ((FG@0<@ $2M?@`A@@>'PA???0Wg I<Wg >WgI<>Wg@I+<@<<@0WgI\MWg>WgH<Wg<   "$\Mqq?@B@HB?<<  < n>WgH|=6Wg6   <  6 Iyպ0WgH\MWg84PLDLH?b@AP!Wu0J5\M"CREATE STATISTICSTP{_(WuJWuJ 3 0K584\M$BTree Split/ShrinkP{_(>WuK 6Wg y0`>>WuK }64W@@WuK6PWuK6>WuK6Wu6|`Wu KW2066|!D\0WuK\MWu6 ct10L5a\MAllocMix@dP{_(6Wu Lcu36WuL cWu 30Wu L\MWu 840M5\MSplitPageP{_(>WuM 6Wu `>WuM }6Wu:`A@WuM6@PWuM6|'>WuM6Wu<aaa7aaa73aaa9755775573375aa757aaaa337535335335575575YYYYYY0':  a_WA_Sys_00000002_0000003A00':  a_WA_Sys_00000003_0000003A?0':  @ a_WA_Sys_00000004_0000003Ait0'< < 7clst0'<  a_WA_Sys_00000002_0000003CNF0'<  a_WA_Sys_00000003_0000003C0'<  a_WA_Sys_00000004_0000003Cy0'@ @ 7clst0'@ @@ 3nc0'@  a_WA_Sys_00000002_000000400'@  a_WA_Sys_00000005_000000400'@  a_WA_Sys_00000004_000000400'A A 9clust0'C C 7clst0'C C 5nc10'@ C 5nc2?0'D D 7clst0'E E 7clst0'E E 5nc1$0'E E 5nc20'G G 7clst0'H H 3cl0'I I 3cl0'J J 7clst0'J @J 5nc10'J  a_WA_Sys_00000001_0000004A0'J  a_WA_Sys_00000003_0000004A0'K K 7clst0'K K 5nc10'L L 7clst0'L  a_WA_Sys_0000000C_0000004C0'L@ a_WA_Sys_0000000D_0000004CPA0'L  a_WA_Sys_00000002_0000004C"0'L a_WA_Sys_00000003_0000004C0'N N 3cl0'N N 3nc0'Z Z 7clst0'Z Z 5nc10'@ [ 3cl0'[ [ 5nc10'\ \ 3cl0'] ] 3cl?0'] ] 5nc10'^ ^ 3cl0'_ _ 3cl0'_ _ 5nc10'_ _ 5nc30'` @` 7clst0'` ` 5nc10'` ` 5nc20'a a 7clst0'a a 5nc10'Xv  Yqueue_clustered_index0'Xv  Yqueue_secondary_index0'x  Yqueue_clustered_i@ndex0'x  Yqueue_secondary_index0'<8z  Yqueue_clustered_index0'<8z  Yqueue_secondary_index<WuM |76Wg7:>WuM|6Wu>WuM6Wu 6>: @0WuM\MWu>WuJ|.6Wu6a0'3  a_WA_Sys_00000002_00000033 6 > F>WuJ~6Wg6B63 B_WA_Sys_00000002_00000033 6 {U>WuJ <WR<"0<3  @" < z S>WuJM7Wg7 3  7 ?WK>WuJ <Wu<  6<3 0 < z SM>WuJ|.6Wu6   3  6 > F0WuJ\MWu̸84$(<\ p4\ L@HX[ CeP W#ʬ0N5\M"CREATE STATISTICSTP{_(WNWN 3 >WN|/6Wu 6ap0'3  a_WA_Sys_00000005_00000033 6 ?I>WN~6Wu6B63 B_W@_Sys_00000005_00000033 6 {">WN <Wu<"0<3  " < {PY>WNN7Wu73  7 @N\>WN <W<  <3  < {PY>WN|/6W6H  {_3  6 ?I0WN\MW̸84<LHu 30Wu L\MWu 840M5\MSplitPageP{_(>WuM 6Wu `>WuM }6Wu:`A@WuM6 AP Wn0O584\M"CREATE STATISTICSTP{_(WOWO J >WO6Wu6ap0'J  a_WA_Sys_00000005_0000004A 6 Wn&>WO~ 6W6B6J B_W@_Sys_00000005_0000004A 6 >WO<Wg<"0WO7W7J  7 X}\>WO<W<   " $\M?@@C@C?(WO6W6   J  6 Wn&0WO\MW̸84H\LHPWuM6|'>WuM6Wu<aaa7aaa73aaa9755775573375aa757aaaa337535335335575575YYYYYY0':  a_WA_Sys_00000002_0000003A00':  a_WA_Sys_00000003_0000003A?0': AP  Wh0P5iM"CREATE STATISTICSTP{_(WPWP 2 >WP|,6W 6ap0'2  a_WA_Sys_00000004_00000032 6 =4>WP~6W6B62 B_W@_Sys_00000004_00000032 6 y+J>WP<W<"0<2  " < ydY0>WPG7W72  7 >8\>WP<W<  C " $XiMى=@?A?  4H\p$8L`t??"?@?#??$??0??4??8??:??;??<??=??>??b??c??h??j??l??z????????????@?????0<2  H< ydY0>WP|,6W6   2  6 =4s0WPiMW̸5_LH00002_0000003CNF0'<  a_WA_Sys_00000003_0000003C0'<  a_WA_Sys_00000004_0000003Cy0'@ @ 7clst0'@AP  Wx,p0Q5iM"CREATE STATISTICSTP{_(WQWQ 2 >WQ|-6W 6ap0'2  a_WA_Sys_0000000C_00000032 6 >.>WQ~&6W6B62 B_W@_Sys_0000000C_00000032 6 y@_R>WQ<W<"0<2  " < z}P>WQH7W72   7 ?!+\>WQ<W<   " $iM?@@A@A?<2 H < z}P>WQ|-6W6   L2  6 >.0WQiMW̸5H\LH?$??0??4??8??:??;??<??=??>??b??c??h??j??l??z????????????@?????0<2 AP WI0R5iM"CREATE STATISTICSTP{_(WRWR 2 >WR|.6W 6ap0'2  a_WA_Sys_0000000D_00000032 6 ?K_>WR~(6W6B62 B_W@_Sys_0000000D_00000032 6 y7hJ>WR <W<"0<2  " < {P_>WRI7W72   7 @_\>WR <W<   " $iM?@@A@A?<2 H < {P_>WR|.6W6   L2  6 ?K_0WRiMW̸5H\LH?$??0??4??8??:??;??<??=??>??b??c??h??j??l??z????????????@?????0<2 AP 8Wj0S5M"CREATE STATISTICSTP{_(WSWS 6 >WS|66W 6ap0'6  a_WA_Sys_0000000A_00000036 6 Bũ>WS~&6W6B66 B_W@_Sys_0000000A_00000036 6 F>WS<P<"0<6  " < ~k>WSW7W76   7 C^-\>WS<W<   " $Mxx?@@B@>'B?A?<6  < ~k.>WS|66W6   K6  6 Bũ0WHMW̸4|LH??4??8??:??;??<??=??>??b??c??h??j??l??z????????????@?????0<2 SAP Wv0T5M"CREATE STATISTICSTP{_(WTWT 6 >WT|76W 6ap0'6  a_WA_Sys_00000004_00000036 6 C+>WT~6W6B66 B_W@_Sys_00000004_00000036 6 ^>WT<W<"0<6  " < kY >WTX7W76  7 D؇\\>WT<W<  % " $:Myy*>@@B@0G^u??????B? @? (B? K<6 6 < kY >WHT|76W6  4 6  6 C+0WTMW̸4lLH?>??b??c??h??j??l??z????????????@?????0<2 AP 8W)0U5M"CREATE STATISTICSTP{_(WUWU 6>WU|86W 6ap0'6 a_WA_Sys_00000009_00000036 6 D_ 9>WU~'6W6B66B_W@_Sys_00000009_00000036 6 Bd>WU<W<"0<6 " < lփ>WUY7W76  7 E#\>WU<W<   " $Mzz?@@B@>'0B?B?<6 < lփ>WU|86W6   K6 6 D_ 9 0WHMW̸4|LH 4 6  6 C+0WTMW̸4lLH?>??b??c??h??j??l??z????????????@?????0<2 UAP W鿞0V5sM"CREATE STATISTICSTP{_(WVWV  >WV|6W 6ap0'  a_WA_Sys_00000003_00000005 6 <>WV~ 6W6B6 B_W@_Sys_00000003_00000005 6 OE>WV<H<"0< `" < L>WV7W7  7 5_\>WV<W<  b`" @$w~MNN@?.<@))@B@H_v.E\s+BYp@(?Vm???@??? ??????@@???@?"@?)@?,@?.??1@@?2@?3@?6??7@?:?@?<@?@??A@@?C??D@@?E??G??H??I@?J@?K??L@?N@?Z@?[??\@?]??^@@?_@@?`@?a@?Xv@@H<8z<  < L>WV|6W6  00 40  6 <0WVMW̸40 4 LH@  a_WA_Sys_00000004_000000400'A A 9clust0'C C 7clst0'C C 5nc1@AP  W:0W5M"CREATE STATISTICSTP{_(WWWW  >WW|6W 6ap0'  a_WA_Sys_00000004_00000005 6 J>WW~6W6B6 B_W@_Sys_00000004_00000005 6 O]>WW<W<"0<  " < MD>WW7W7  7 <\>WW<W<   " $~MNNL>@@B@(?Vm??,B?A?A?@?<  < MD>WW|6WH6  V   6 J0WWMW̸4?LLH? ??????@@???@?"@?)@?,@?.??1@@?2@?3@?6??7@?:AP W:0X5M"CREATE STATISTICSTP{_(WXWX ) >WX|!6W 6ap0')  a_WA_Sys_00000003_00000029 6 4>WX~6W6B6) B_W@_Sys_00000003_00000029 6 wqFZ>WX<  <"0<)  " < p>WX37W7)  7 5ʣd\>WX<W<  , " $A#M!=@@C@&=Tk #:Qh  7Ne|@0B?0B?0B?,B? B?B?A?A?A? pA? `A? 0A? A? A?A?@?@@?@@?@@?@@?@?@?H@?@?@?@???????????<)  < p?>WX|!6W6   [)  6 4@0WXMW̸4p LH?`@?a@?Xv@AP  WT0Y5M"CREATE STATISTICSTP{_(WYWY <>WY6W 6ap0'< a_WA_Sys_00000005_0000003C 6 J`>WY~$6W6B6<B_W@_Sys_00000005_0000003C 6 ߯>WY<Wg<"0<< " < i>WYr7W7< 7 KB7?8\>WY<W<d "$wM~~L?<@ AB A:[|!Bc)Jk1Rs@0B?!0@?!0@@@!0??!0@?!0@?!0??!0@?!0@?!0@?!0@?!70??!Q0@@?!\0@?!]0??!c0@@?!i0@?!x0??!}0@?!~0??!0@?!0??!0@?!0???!0@?!0???!0???!0??!0@@?!#0@?!0??!HB<< < i>WY6W6  00 40< 6 J`0WYMW̸40 4 LH@  a_WA_Sys_00000004_000000400'A A 9clust0'C C 7clst0'C C 5nc1AP h W'0Z5M"CREATE STATISTICSTP{_(WZWZ K >WZ6W 6ap0'K  a_WA_Sys_00000001_0000004B 6 V,y+9>WZ~6W6B6K B_W@_Sys_00000001_0000004B 6 sص>WZ,<<"0WZ7W7K  7 W]Q \>WZ,<W<   "$iMff>@?B?p 4H\@?0A???B?TWZ6W6   KH  6 V,y+9!0WZMW̸4@ LH0??!0@?!0@?!0??!0@?!0@?!0@?!0@?!70??!Q0@@?!\0@?!]0??!c0AP W#0[5M"CREATE STATISTICSTP{_(W[W[ K >W[ 6W 6ap0'K  a_WA_Sys_00000005_0000004B 6 WA>W[~(6W6B6K B_W@_Sys_00000005_0000004B 6 ,>W[,<W<"0W[7W7K  7 XDX*\>W[,<W<   "$iMff?@@B@B?W[ 6W6   qK  6 WA0W[MW̸4H\LHV,y+9!0WZMW̸4@ LH0??!0@?!0@?!0??!0@?!0@?!0@?!0@?!70??!Q0@@?!\0@?!]0??!c0APn>@W_T> cWE(u\{|0\5y3M user_transactionP{_(W\  u\{>W\t/" "<0,u\{ U MM <Room " u7jQA>W\v" V"&u\{RoomW@ " N60>W\x" W"&u\{Room " Y>W\z," X" u\{ " v5gG>W\t/"W" DX*\u\{ " u7jQ>W\#) @)A0-u\{88 ARoomID )@ vr< >W \sT) )6u\{RoomID ) ^ W \u\{W \ u\{>W \#)W )0 ARoomID CPRoomIDu\{ ) vr< >W \$)W )C 0-u\{88 CCa@tRoom ) w00]5MSplitPageP{_(>W] )Wu ?`>W] n)%@0@W])PW])m s>W])W@x,,,* &$$* " && $$"&. &*,"" "( &" &&&@@@000 " """""""" &$ 6Xv ,fragment_size6x ,fragment_size6<8z ,fragment_size6D*frombrkrinst6D fromsvc6 grantee6 gra@tor6Lgrowth6Lgrpid6Nguid6Hhandle06Ihandle 6Zhash6`hash46D&hdrpartlen6D$hdrseclen6$hobtcolid6 *hobtcolumnid6 hobtid6hobtid 6id6id6id6"@id6)idn6,id6.id 61id62id66id6:id6@idn6Cid6Eid 6Gid6Nid6[id6^id6_idc6`id6 idmajor63 idmajor67 idmajor6a@ idmajor6 idminor67 idminor6)idtval_6<"imageval6 indepid6J indepid6K indepid6J&indepsubids6K&indepsubid6A indexid6indid66indid6H$initiator6I$initiator6I"ins@skey6I&inseskeyids6L.internalstatus6"  intprop6, intprop63  intprop66 intprop67 intprop6: intprop6@ intprop6a intprop6.issuer6[kind6\kindc6I&lastoorder6I*lasto@rderfr6L,lastupdatelsn6 length6)length62length63length6E"lifetime6I"lifetime16Llname66 lobds6  lockres6) "maxinrow6(maxinrowlen6maxint6 maxleaf6&max@ullbitc6]"maxoccur6L maxsize6Xv&message_id6x&message_id6<8z&message_id6Xv@message_sequence_number6x@message_sequence_number6<8z@message_sequence_number6Xv0message_type_id6x0message_type_id6<8z0m@ssage_type_id6minintq6 minleaf6]"minoccur6E miraddr6 "modified6" "modified6,"modifieda62 "modified6: "modified6@"modified6_"modified6`"modified6D msgbody6D&msgbody@en6Dmsgenc6Dmsgid6D$msgseqnum6D  msgtype<W] mm) mv>W]m)Ws>W]s)W my0>W]r)*).6Xv.fragment_size0W]M@W<>W\m )W) 6u\{ CatRoom ) 7>W\%)W)K0-u\{cc4KDescription ) x)K.>W\mD)W)(6u\{(Description ) i3>W\t/"W"@u\{ " u7jQW\  >W\N  )%/    ;>W\NW3*'u\{  ;>< X BC>W \YWu @IEC   hd>W"\V C  Ġ>W#\E[ ( -) 8    >W$\A %"  @ >W%\E\ W$ -) 8   ]>W&\AW%%"  ]>W'\E] W& -) c4  >W(\AW'%"@  ><W!CD>W)\ZW"IED   zXy>W+\W#D  [)g:$W,\4>W-\>6W 6@+'u\{  6 u<| >W.\~6W6 u\{ 6 vl>W/\t/"W"$u\{ " u7jQ$W0\x>W1\NW u\{  ;W2\  u\{>W@3\t/"W0"$u\{ " u7jQ> cW(|x}W4\  |>W6\t0"W4"B0,|PKu\{MM BPK_Room " 5f>W7\v"W"&|PK_Room " \>>@8\x"W"&|PK_Room " A>W9\z0"W" u\{| " $"W<\OW2)%#    >W=\OW *@'u\{  ><W*DE>W>\[W+IEE   ߋO>W@\XW,E  В>WA\E^ W( -@) 8   WB\AW)%"  WC\E_ WB -) 8   ß>WD\AWC%"  ß>WE\@` WD -) c4  #I>WF\AWE%"  #I>WG\ZW@ D  zXy>WH\WAD  [)g:6 @WS>WI\ WID  -h$WK\4$WL\>WM\NW>*'u\{  ;6 WJ>WN\AWG%"@   6 WO+>WP\AWP%"  ]>WR\AWR%"  >WS\NW=)%/ u\{   ;6@ WQ>WT\E[ WF -) 8    6  WUK>WV\E\ WV -) 8   ]>WX\E] WX -) c4  @>WY\XWKC  Ġ>WZ\YWHIEC   hd6 WW>W[\>6W.6! u\{ 6 u<| >W]\~6W/@6 u\{ 6 vl6 6W\>W^\>6W]6+'u\{  6 u<| 6 6W_>W`\?6W`6=0'u\{  =PK_Room 6 vY>Wb\~{6W^@66u\{PK_Room 6 .,>Wc\7W7u\{ 7 w2,>Wd\< <"0We\t/"W7"$u\{ " u7jQ$Wf\x>Wg\@OWT u\{  Wh\  u\{Wi\  |Wj\  u\{Wk\  u\{>Wl\?6Wb6   +u\{ 6 vY0W\MWx==<<W^|$6W 6a0',  a_WA_Sys_00000002_0000002C  6 7>>W^~6Wc6B6, B_W@_Sys_00000002_0000002C 6 ÿF>W^<W<"0<,  " < sg->W^97Wd7,  7 8|\>W^<W<   "$6M?@@?@??m<, oo < sg-\>W^|$6W6   ,  6 7{0W^6MW̸4HR\LH w00]5MSplitPageP{_(>W] )Wu ?`>W] n)%@0@W])PW])m s>W])WAP WRb0_56M"CREATE STATISTICSP{_(W_W_ , >W_|%6W 6a0',  a_WA_Sys_00000004_0000002C  6 87~>>W_~6W6B6, B_W@_Sys_00000004_0000002C 6 9>W_<W<"0<,  " < tn'>W_:7W7,  7 9v\>W_<W<   "$6M?@@?@??m<, oo < tn'\>W_|%6W6   ,  6 87~{0W_6MW̸4HR\LH w00]5MSplitPageP{_(>W] )Wu ?`>W] n)%@0@W])PW])m s>W])WAP  W/p40`5;M"CREATE STATISTICSP{_(W`W` ">W`|6W 6a0'" a_WA_Sys_00000009_00000022  6 1Uy>>W`~06W6B6"B_W@_Sys_00000009_00000022 6 i>W`<WY<"0<" " < mbb@>W`-7W7"  7 2> \>W`<W<  z "$Q;M11p=@@DB@)@Wn@?@?@@?@?@@?@?@?@? ?? @@? @? ?? @?????????<"0 < mbb@>W`|6W6   " 6 1Uy0W`;MW̸4LLHH,,,* &$$* " && $$"&. &*,"" "( &" &&&@@@000 " """""""" &$ 6Xv ,fragment_size6x ,fragment_size6<8z ,fragment_size6D*frombrkrinst6D fromsvc6 grantee6 gAP  W)0a5;M"CREATE STATISTICSP{_(WaWa ) >Wa|#6W 6a0')  a_WA_Sys_00000002_00000029  6 5S26>>Wa~6W6B6) B_W@_Sys_00000002_00000029 6 wVac>Wa<W<"0<)  " < q>Wa57W7)  7 6Ӫ\>Wa<W<   "$&;M?@@C@C?<)  < q>Wa|#6W6   )  6 5S260Wa;MW̸4HXLH?@?@? ?? @@? @? ?? @?????????<"0 < mbb@>W`|6W6   " 6 1Uy0W`;MW̸4LLAP W0b5;M"CREATE STATISTICSP{_(WbWb ) >Wb|$6W 6a0')  a_WA_Sys_00000005_00000029  6 66>>Wb~'6W6B6) B_W@_Sys_00000005_00000029 6 w!V{>Wb<W<"0<)  " < rs>Wb67W7)  7 7M "\>Wb<W<   "$&;M%I=@?C?p$8L`tA?$LB?0A?4%C?8A?=@?bH?c??hB?A?A?A?B?@?<)  < rs>Wb|$6W6   )  6 66 0Wb;MW̸48LH   " 6 1Uy0W`;MW̸4LL?AP WO0c5;M"CREATE STATISTICSP{_(WcWc )>Wc|%6W 6a0') a_WA_Sys_00000006_00000029  6 7.;>>Wc~06W6B6)B_W@_Sys_00000006_00000029 6 w e>Wc<W<"0<) " < sZ>Wc77W7) 7 8\>Wc<W<  < "$Q&;M=@@C@x0G^uA?$LB?0A?4%C?8A?=H@?b??c??hB?A?A?A?A?@?A?<) < sZ>Wc|%6W6   ) 6 7.;0Wc;MW̸4 LH`;MW̸4LLAP WF 0d5;M"CREATE STATISTICSP{_(WdWd )>Wd|&6W 6a0') a_WA_Sys_0000000D_00000029  6 8I$>>Wd~86W6B6)B_W@_Sys_0000000D_00000029 6 wH?>Wd<W<"0<) " < tl1>Wd87W7)  7 90.`\>Wd<W<   "$&?M?@@C@C?<) < tl1>Wd|&6W6  LB ) 6 8I$0Wd?MW̸4H@\LH??c??hB?A?A?A?A?@?A?<) < sZ>Wc|%6W6   ) 6 7.;0Wc;MW̸4 LH`;MW̸4LLAP WGh0e5?M"CREATE STATISTICSP{_(WeWe )>We|'6W 6a0') a_WA_Sys_0000000E_00000029  6 9t,>>We~;6W6B6)B_W@_Sys_0000000E_00000029 6 w-M>We<W<"0<) " < u=k>We97W7) 7 :\>We<W<   "$&?M?@@C@C?<) < u=k>We|'6W6  LB ) 6 9t,0We?MW̸4H@\LH??c??hB?A?A?A?A?@?A?<) < sZ>Wc|%6W6   ) 6 7.;0Wc;MW̸4 LH`;MW̸4LLAP`Wfg0f5?M"CREATE STATISTICSP{_(WfWf )>Wf|(6W 6a0') a_WA_Sys_0000000F_00000029  6 :iA>>Wf~<6W6B6)B_W@_Sys_0000000F_00000029 6 w>Wf<W<"0<) " < vu=X>Wf:7W7) 7 ;) \0g5?MSplitPage"P{_(>Wg <Wa @@W g<PW g<>W g<W Q"""""0<) $&;M%I=?C?@p$8L`tA?$LB?0A?4%C?8A?=@?b??c??hB?A?A?A?B?@?@<)$Q&;M=@C@x0G^uA@?$LB?0A?4%C?8A?=@?b??c??hB?A?A?A?A?@?A?0<)$&?M?@@C@C?0<)$&?M?@C@@C?0<) "d0<,$|??@??@@??0<,$|????pA?@@?@%_0??sys@((sys@0<, $6M?@?@??0<, $@6M?@?@??0<."m0<."0<."_0<."@e<W g <W >W g<W md>Wg<W>Wg+ <Wg< <) 0Wg?MW>Wf<W <   "g$&?M@?@C@C?y<) < vu=X>Wf|(6W6  s z) 6 :iH0Wf?MW̸4 LH DLH6u\{ CatRoom ) 7>W\%)W)K0-u\{cc4KDescription ) x)K.>W\mD)W)(6u\{(Description ) i3>W\t/"WA0@AP W,60h5?M"CREATE STATISTICSP{_(WhWh )>Wh|)6W6a0') a_WA_Sys_0000000B_00000029  6 ;>>Wh~66W6B6)B_W@_Sys_0000000B_00000029 6 w|>Wh<W<"0<) " < w:N>Wh;7W7)  7 <ʉ\>Wh<W<   "$&?ML>@@C@(?Vm@?C?0B?PB?@?<) < w:NC>Wh|)6WH6   ) 6 ;0Wh?MW̸4LLH$8L`tA?$LB?0A?4%C?8A?=@?b??c??hB?A?A?A?B?@?APa#$WxRQ> WZ> WW6 W S> >6Wm6 6W> NWN6 W> NWh@6 W> YW[6 W > AWS> AW > AW 6 W +> E[ WY>@ E[ W> E[ W6  WK> ~6W6 6W> cW5(x} l~0i5y3aN user_transactionP{_(Wi  @}>Wit1"Wf"@0,x} U aNaN @Rezerv " R0>Wiv"W8"&x}Rezerv " ?1 ?>Wix"W9"?&x}Rezerv? " ?N'>Wiz-"W:" x} " @x>Wit1"W" x} " R0>Wi&)W)E0-x}88 ERezervID ) :>WisT)W)"6x}"RezervID ) n>Wit1"W"x} @" R0 W ix}W!i x}>W"i&)W) 00EGx} ) :EGTW#i  >W$iOW)%  ?  m>W%iOW*'@x}  m><W?EF>W&i[W IEF M  q4>W(iXWF  ;>W)iE^ W -)@ 8   7!>W*iAW%"  7!$W+i4>W,i?6W6+'x}  6 APF>W-i~6W6 x} 6 S6X>W.it@1"W "$x} " R0$W/ix>W0iOW% x}  mW1i  x}>W2it1"W/"$x} " R0> cW( l~Y`W3i  l~@>W5it2"W3"F0, l~PKx}aNaN FPK_Rezerv " Z>W6iv"W" & l~ PK_Rezerv " ^1>W7ix"W" & l~ PK_Rezerv " CS>W8iz2"W" x} l~ @" =D|W9i   >W:iPW1)%       A>W;iPW&*' x}  A><W'FGm>W<i\W(I_EG @   *>>W>iYW)m G  @$m>W?iE_ W* -)  8 <)  \>W@iAW+%"   \$$WAi 4@$WBi>WCiOW<*'x}  m6 W>WDiAWA%"  7!)6 WE+>WFiOW;)% @x}   m6 WG>WHiE^ W@ -) 8   7!6  WIK>WJiXW?F  ;6 WKS>WLi[W>@IEF   q46 WM>WNi?6W-6! x} 6 APF>WPi~6W.6 x} 6 S6X6 6WO>WQi?6WP6@+'x}  6 APF6 6WR>WSi@6WS6A0'x}   APK_Rezerv 6 $7>WUi~6WQ6"6x}"PK_Rezerv 6 v4>WVi7W7 @x} 7 (i>WWi<We<"0WXit1"W6"$ x} " R0$WYi x>WZiPWH  x}   AW[i  x}W\H  l~W]i  x}W^i  x}>W_i@6WU6   +x} 6 $70WiaNW"h"@""!!L!(! 4 0T,x$`(h$TLT<(xTx@ 8 @ ( ` 4  x hl,t4|<L\-\>6WixPsv$W&TD> XWL6 WTS> ?6W`6 6W&> OWD6 W&> OW[6 W&>@ [WN6 W&> AWF6 W& +> E^ WJ6  W& K> ~6WV6 6W&`W@CN@ciW& 5-=W&@ W& W& @W& W& @W& W&5-=W&P@W&W&@W& W& W&@ W&  W&!@ W&"W&5-=W&\@W&#W&&@W&'W&(W&)@W&*W&+@W&,W&- W&.@ W&/ W&$ 5-=@W&% W&0 @&3 W&4  W&5 @!W&6 "W&7 @#W&8 $W&9 %W&: @&W&; 'W&< @(W&= )W&> *W&? @+W&@ W&15-=@W&2P,W&A-W&D@.W&E/W&F@0W&G1W&H2W&I@3W&J4W&K @%W&B"5-=FW&C"3W&M@5-=W&N\?W&L@@W&QAW&R @&O"5-= W&P"3RW&S";@SW&V";TW&W";@UW&X";VW&Y"WWW&Z";@XW&[";YW&\";@ZW&]" T[W&^" ;\W&_" @ W&T)5 -= W&U)@]W&`)'^W&c)'_W&d)@'`W&e)'aW&f)'@bW&g)'cW&h)'dW&i)@'eW&j) 'fW&k) '@gW&l) 'hW&m) 'iW&n@) 'jW&o)'kW&p)'@lW&q),W&a65-=@&b6@W16@W&u6@@W&v6@W&w6@@W&x6@ W&y6@ W&z6@@ W&{6@ W&|6 @@ W&}6 @W&~6 W&s75@-=W&t7@W&7@@W&7@W&7@W&7@@W&7@W&7@@W&7W&<5-=W&<@&W&<-=@W&<@@ W&<@!W&<@"W&@<@#W&<@$W&<@W&"5-=*W&"3@&)5-=+W&)W&65-=@0W&6#W&"5-=@?W&"3qqLp|onm m==L<|;:9 9<8l7654,4\32100L/|.-, ,<+l*)(','\&%$##L"|!  <l,\L| <l , \  L| <d,t<L \HWWWWWXvWaPNW&NW&c)Q3 ?6W`6 6W&> OWD6 W&> OW[6 W&>X~Wb! `W&Nci ?6W`6 6W&> OWD6 W&> OW[6 W&>XWc WbNWbc ?6W`6 6W&> OWD6 W&> OW[6 W&>XWd50k3 dStartupDBP{_(>Wdk cW4$@XbWe4"@Wdkg[WdsDBP{_(>Wdk cW4$@XRWf#0WdksWdsDBP{_(>Wdk cW4$@P LWgdtk0l44"CREATE STATISTICSP{_(WglWgl 6>Wgl|F6W 6a0'6 a_WA_Sys_00000007_00000036 6 E:j>Wgl~16W&6B66B_W@_Sys_00000007_00000036 6 o>Wgl<W<"0<6 " < l|O>Wglg7WW76 7 Fߢ>Wgl<Wg<   "$>@? C?T,@xB?4B?B?<6 < l|O>Wgl|F6Wg6   6 6 E:jH0WglWg̸4LHAP Wk,0m44"CREATE STATISTICSP{_(WkmWkm  >Wkm| 6Wg 6a0'  a_WA_Sys_00000002_00000019 6 $(.>Wkm~6Wg6B6 B_W@_Sys_00000002_00000019 6 gǥ>Wkm< H <"0< " < `&>Wkm 7Wg7  7 %ΕM>Wkm<Wk<"<  < `&>Wkm| 6Wk6H    6 $(.0WkmWk̸4 <LHT,@xB?4B?B?<6 < l|O>Wgl|F6Wg6   6 6 E AP$PRWnv> cWd(Y`U0n4y3D user_transactionP{_(Wnn  Y`>Wnnt3"WY"D0,Y` U DD DTmp_Room " Y2$l>>Wnnv"W7"&Y`T@p_Room0 " 10>Wnnx3"W8"&Y`Tmp_Room " )($">Wnnz."W9" Y` " Z0>Wnnt3"Wn" Y` " Y2$l>Wnn')W#)A>0-Y`88 A@RoomID ) Z;z >Wn nsV)W) 6Y`RoomID ) c7 Wn nY`Wn n Y`>Wn n')Wn )0 ARoomIDCPRoomIDY`< ) Z;z>Wn n()Wn )C0-Y`4@CCatRoom ) [E>Wnnm )W) 6Y` CatRoom ) `Z>Wnn))Wn)K0-Y`cc4KDescription ) \ sJ>WnnmF)Wn)(6Y`(Description ) Y.>Wn@*)Wn)G0-Y`88 GCountRoom ) ]ˤ>Wnnm+)Wn)$6Y`$CountRoom ) a>Wnnt3"Wn"Y` " Y2$lWnn   >WnnPW&)%@      f3AL>WnnPW&*' Y`  f3AL><W=GH>Wnn\W&IEH    >WnnYW&@ H  N>WnnE_ W& -)  8   >WnnAW& %"   >WnnE` Wn -)  4  bHa>WnnA@Wn%"   bHa>WnnEa Wn -)  c4  /ݼ>WnnAWn%"   /ݼ>Wn nEb Wn -)  8  @   !>Wn!nAWn %"    !><WnHI>Wn"n]WnIEI    K>Wn$n Wn I @ $Wn%n 4>Wn&n@6W&6+'Y`   6 Yw>Wn'n~6Wk6 Y` 6 Z%Ŷ>Wn(nt3"Wn"$DHY` " Y2$l$Wn)n [>Wn*nPWn@ Y`   f3ALWn+n  Y`>Wn,nt3"Wn)"$HMY` " Y2$l> cWn(U5IWn-n  U>Wn/nt)"Wn-"Z0,UD Y`MM ZDF_Room_Description " i@>Wn0nv"Wn"4&U4DF_Room_Description " 衲f>Wn1nx"Wn"4&U4DF_Room_Description " P.F>Wn2nz4"Wn" Y`U " ^>Wn3n))Wn)%UY` )@ \ sJWn4n  Y`>Wn5n<Wn#<%0U %8(N'') < |*Wn6n  Y`>Wn7nt4"Wn0"$MNY` " Y2$l> cWn.(5IZ=Wn8n  5I>Wn:nt*"Wn8"@V0,5ID Y`MM VDF_Room_CountRoom " E >Wn;nv"Wn1"0&5I0DF_Room_CountRoom " GT>Wn<nx"Wn2"0&5I0DF_Room_CountRoom " BJ>Wn=nz5"Wn3" Y`5I "@ %+| F>Wn>n*)Wn4)%5IY` ) ]ˤWn?n  Y`>Wn@n<Wn6<%05I %8((0)) < WnAn  u\{WnBn u\{$WnCno>WnDnNWn*'u\@  6 W&>WnEnAWn"%"  WnGnAWnG%"  ß>WnInAWnI%"@  #I>WnJnWn%D  -h6 WnHS>WnKnYWn$IED   zXy6 WnL>WnMnNWn+)@%# u\{   6 WnN>WnOnE[ Wn! -) 8   WnQnE\ WnQ -) 8   ß>WnSnE] WnS @-) c4  #I>WnTnXWnKE  В>WnUnZWnMIEE   ߋO>WnVnt1"Wn;"$M[u\{ " u7jQ>WnWn@>6Wn'6! u\{ 6 vYWnXn  |WnYn  u\{WnZn ,|>Wn[nv"Wn<"&|PK_Room " \>6 "WnR>Wn\nx"Wn="&|PK_Room "@ A6 "Wn]>Wn^nz2"Wn>" u\{| " $"Wn`nt2"WnW"B0,|PKu\{MM BPK_Room " 5f6 "WnaWnbn ,u\{>Wndn@6Wn(66u\{PK_Room 6 .,6 6Wnc>Wnen>6WnX6=0'u\{+ =PK_Room 6 vY6 6Wnf>Wngn7Wk7u\{ 7 w2,6@ 7Wnh>Wnin<WX<"0WnknsU)Wn )6u\{RoomID ) ^6 )Wnl>Wnmn#)Wn?)P0-u\{88 @CPRoomID ) vr< 6 )Wnn>Wnonm )Wn) 6u\{ CatRoom ) 6 )Wnp>Wnqn$)Wno)C0-u\{88 CCatRoom ) w>WnsnmF)Wnq)@(6u\{(Description ) i3>Wntn%)Wns)K0-u\{cc4KDescription ) x)K>Wnunv"Wn\"&u\{Room " N6>Wnvnx "Wn^"&u\{Room " Y>Wnwnz,"@n`" u\{ " v5gG>Wnxnt1"Wnb"<0,u\{U M[ <Room " u7jQWnyn  Y`>Wnznt5"Wny"$NY` " Y2$lWn{n  Y`>Wn|nt5"Wn{"$Y` "@ Y2$l>Wn}nv "Wnv"&Y`Tmp_Room " 1>Wn~nv"Wn~"&Y`Room " N6>Wnnx5"Wnw"&Y`Tmp_Room " )($>Wnnx "Wn"&Y`Room " Y>Wn@nt5"Wn}"2  DTmp_<Y` " Y2$lWnn  Y`>Wnnt5"Wn"$Y` " Y2$l> cWn9(Z==~1Wnn  Z=>Wnnt+"Wn"B0,Z=PKY` BPK_Roo@ " @5>Wnnv"Wn"&Z=PK_Room " \>>Wnnx"Wn"&Z=PK_Room " A>Wnnz6"Wnx" Y`Z= " ^.$Wnn 4Wnn   >WnnQWnO@)%      >WnnQWnE*' Y`  ><WnAIJ>Wnn^WnVIEJ    9C>Wnn[@nU J  310>WnnEc WnT -)  8   >WnnAWnJ%"   >WnnEd Wn -)  4  \#>@nnAWn%"   \#>WnnEe Wn -)  c4  9DS>WnnAWn%"   9DS>WnnEf Wn -)  8 @  |>WnnAWn%"   |>Wnn]Wn  I  K>Wnn Wn I  >Wnn Wn I @ J1$Wnn 4$Wnn >WnnPWn*' Y`  f3AL>WnnAWn%"   >WnnAWn%"   bHa>Wnn@AWn%"   /ݼ>WnnAWn%"    !>WnnPWn)%  Y`   f3AL>WnnE_ Wn -)  8   @>WnnE` Wn -)  4  bHa>WnnEa Wn -)  c4  /ݼ>WnnEb Wn -)  8    !>Wnn[Wn H@  N>Wnn\WnIEH    >Wnn@6Wng6!  Y` 6 Yw>Wnn~6Wne6 Y` 6 Z%Ŷ>Wnn@6Wn6+'Y`@  6 Yw>WnnA6Wn6=0'Y`   =PK_Room 6 Z y>Wnn~6Wn66Y`PK_Room 6 ʏ>Wnn7Wni7Y` 7 ["زC>Wnn<Wn@<"0Wnnt6"Wn"$Y` " Y2$l$Wnn [>WnnQWn  Y`   Wnn  Y`Wnn  Z=Wnn  Y`Wnn  @Y`>WnnA6Wn6   +Y` 6 Z y0WnnWnW|NNMMMhMLLXLKTKJ4JIDIH HG GFF|EDpDChCB\B8BBA(A@,@??>=l= Wn> W> WW> XW6 WnrS> >6Wn> ?6W6 6W@> 7Wn6 7W> t2"Wn> t2"W 6 "W > #)Wnu> #)W> #)W6@ )W > NWn> OW6 W> NWn> OW6 W> YWn> @YW> ZW6 W> AWn> AW> AW> AW> AW> A@ > AW!6 W+> E[ Wn> E[ W$> E[ W%> E\ W&> E\ W'> E\ W@> E\ W)6  W#K> m )Wnt> mE)W,6 )W+> sU)Wnm6 )W.> v "Wn6@ "W0> x5"Wn6 "W2> z,"Wn> z1"W56 "W4> ~6Wn> ~6W86 @6W7> <Wn6 <W:C> cWn(=~1v%0o4y3?{ user_transactionP{_(W>o  =~1>W?ot,"W "H0,=~1 U ?{?{ HTmp_@ezerv " =>W@ov "W1""&=~1"Tmp_Rezerv " +>WAox5"W3""&=~1"Tmp_Rezerv " !>WBoz)"W6" =~1  " >'>>WCot,"W@" =~1 " @ݨ0p4H{SplitPageP{_(>WEp )W<w `>>WFp l) oF6@WGp)PWHp)8->WIp)WI<EC=?A=AA;=@=GCEAEEA?9I=AA9=IGGE=E?9=GC=ACE?C?=ACAEj_[cISI[0-[Esymspace0-[88 Cnmscope0-[=kind0-[ ?deriv0-[ 88 Astatus0-[ =enum0-[ @@@Adefval0-\88 Acompidn0-\88 ;ord0-\=kindm0-\44Astatus0-\@@=dflt0-]88 Gplacingid0-]88 Cordi@nal0-]88 Eplacedid0-]88 Astatus 0-]88 Eminoccur 0-]88 Emaxoccur0-]@@Adefval0-^00?class0-^88 9id0-^ @ Ithumbprint0-^=type"0-^@Acrypto"0-^88 Astatusm0-_88 9id0-_4=namem0-_  Ithumbprint50-_88 Gbitlen@gth|0-_Galgorithm0-_==Emodified0-_=pkey0-_Eencrtype 0-_ @?pukey0-`88 9id0-`4=name0-`00@Gscopetype0-`88 Cscopeid0-`=hash0-`88 AstatusWKp8)WKZ>WLp)W8>WMpo) j)[0WEpL{WE >WDo0)W@J)E60-=~188 ERezervID ) >]*y>WPosT)W/)"6=~1"RezervID ) = WQo=~1WRo =~1>WSo0)WP) 00EG=~1 ) >]*yEGTo>WT@1)WT)A0-=~188 ARoomID ) ?k>WUosV)WQ)6=~1RoomID ) G@>WVo2)WU)=B0-=~14=Name  ) @`#>WWos)WV)6=~1@Name ) qNT\>WXo3)WW)A0-=~14AFamily> ) AoXN>WYomZ)W-)m6=~1Family6 ) \L>WZo4)WY)C0-=~14CAddress ) B ?H>W@[om)WZ) 6=~1 Address ) , >W\o5)W[)=0-=~1d4d=Tele ) C>W]os)WX)6=~1Tele ) G>>W^o6)W])?{0-=~14@?Email ) DA\ >W_omV)W\)6=~1Email ) O]>W`ot,"WD"=~1 " =Wao   >WboPW)%      {>WcoPW@*' =~1i  {><WnJK4>Wdo\WIEK  u\  E">WfoYW K  V>WgoE` W*@ -)  8 >  ˗>WhoAW"%M"   ˗>WioEa Wh -)  8    %8 >WjoAWi%"   %8 @>WkoEb Wj -)  4"  @_ñ>WloAWk%Y" 6  @_ñ>WmoEc Wl -o)  4  g,>WnoAWm%Y" @  g, >WooEd Wn -)  4  >WpoAWo%>"   >WqoEe Wp -)  d4  r>WroAW@q%>" d  r>WsoEf Wr -)  4  ȡ>P>WtoAWs%" Y`  ȡ> $Wuo 04>Wvo86W6+'=~1@   6 =cİ>Wwo~6W96 =~1 6 >|>Wxot,"Wa"$?L=~1 " =$Wyo >WzoPWc  =~1   {W{o  x}W|o x}$W@}o (>W~oNWd*' x}  A 6 WF>WoAWu%"   \6 W+>WoNW{)%   x}@   A6 W>WoE[ Wt -)  8   \c6  WK>WoWWg G  @$m6 WS>WoYWf@IEG    *6 W>Wot3"Wy"$aNL{x} " R0 >Wo?6Ww6!  x} 6 $7Wo  l~Wo  x}Wo@ , l~>Wov"WA" & l~ PK_Rezerv " ^16 "W>Wox"WB" & l~ PK_Rezerv " CS6 "W>Woz2"WC" x} l~ " =D|bH6 @"W>Wot4"W"F0, l~PKx}aNaN FPK_Rezerv " Z6 "WWo ,x}>Wo~6Wx6"6x}"PK_Rezerv 6 v46 6W>Wo?@W6A0'x}+ APK_Rezerv 6 $7 6 6W>Wo7W 7x}/ 7 (i6 7W>Wo<W;<"0WosV)W^)"6x}"RezervID ) n6 )W>Wo#)WM)T0-x}88 GTRezervID ) :`6 )W>Wov"W"@&x}Rezerv6 " ?1 >Wox "W"&x}Rezerv " ?N'o>Woz-"W" x} " x>Wot3"W"@0,x}U aNL{ @Rezerv " R0Wo  =~1>Wot,@W"$LM =~1 " = Wo  =~1>Wot,"W"$M2$Nl=~1 " =[>Wov "W""&=~1"Tmp_Rezerv " +>Wov"W" &=~1Rezerv " ?1 >Wox@5"W""&=~1"Tmp_Rezerv " !>Wox "W"&=~1RezervJ " ?N'pD>Wot,"W"2  HTmp_D2@h1=~1 " =ݜ*Wo  =~1>Wot,"W"$N`O=~1 " =< >@ cW=(v%Wo  v%>Wot-"W"F0,v%PK=~1L{L{ FPK_Rezerv " vSB>Wov"W" &v% PK_Rezerv " ^1>Wox"W" &v% PK_Rezerv "@ CS>Woz/"W" =~1v% " >؄Wo   >WoQW)%      DQ>WoQW*' =~1  DQ><WeK@>Wo]WIEL    @>WoZW L  [>WoEg W -)  8   >WoAW%@"   >WoEh W -)  8   S>WoAW%"   S>WoEi W -)  4  ~4^>Wo@W%"   ~4^>WoEj W -)  4   >WoAW%"    >WoEk W -)  4@  kj{>WoAW%"   kj{>WoEl W -)  d4  Li>WoAW%" d  Li>WoEm W -@)  4  )c>WoAW%"   )c$Wo 04$Wo >WoPW*' =~1  {>WoAW%" @  ˗>WoAW%"   %8 >WoAW%"   @_ñ>WoAW%"   g,>WoAW%" @  >WoAW%" d  r>WoAW%"   ȡ>>WoPW)%  =~1   {>WoE` W @-)  8   ˗>WoEa W -)  8   %8 >WoEb W -)  4  @_ñ>WoEc W -)  4  g,>W@oEd W -)  4  >WoEe W -)  d4  r>WoEf W -)  4  ȡ>>WoYW K @ V>Wo\WIEK    E>Wo86W6!  =~1 6 =cİ>Wo~6W6 =~1 6 >|>Wo86W6+'=~1@  6 =cİ>Wo96W6A0'=~1   APK_Rezerv 6 >x>Wo~6W6"6=~1"PK_Rezerv 6 ,u>Wo7W7=~1 7 ?Rh>Wo <W<@"0<=~1 " < zv9>Wot,"W"$OP=~1 " =$Wo >WoQW  =~1   DQWo  =~1Wo  v%Wo  =~1Wo  =~1>@o96W6   +=~1 6 >x0W>oL{W>Wplkkkk\kjjLjiHih hg0gf fe edchcbPbaX> >=`=<<<;;;(;;:(:9x98`87H76065544x32`21X10`0/H/ /.4.--x,+T+*0*))('P'$''&%%H%$$d$XpH$|T\ d , t 4 D T  T  \\d$l,t4|<L T\,WAL"6oXaA=R(WPfABpW Gk> WW> XW6 WS> NW> OW6 W> t4"W> t4"W@6 "W> #)W6 )W > NW> OW 6 W > YW> [W6@ W> AW> AW> AW> AW> AW> AW> AW>@ AW6 W+> E[ W> E_ W> E_ W> E_ W> E_ W> E_ W> E@_ W > E_ W!6  WK> sV)W6 )W#> v "W6 "W%> x5"W6 "W'@> z-"W> z2"W*6 "W)> ~6W> ~6W-6 6W,> <W6 <W/C>@ 7W6 7W1> 86W> ?6W46 6W3> cW( 0q5y30: user_transactionP{_(W8q  @>W9qt."W"V0,P 0:0: Vsp_upgraddiagrams " ՞>W:qv "W&"0&0sp_upgraddiagrams " ޘS_>W;qx "W("0&0sp_upgraddiagrams " ,C>W<qz*"@+"  " |O>W=q<W<0@ 8 CREATE PROCEDURE dbo.sp_upgraddiagrams AS BEGIN IF OBJECT_ID(N'dbo.sysdiagrams') IS NOT NULL return 0; CREATE TABLE dbo.sysdiagrams ( name sysname NOT NULL, principal_id int NOT NULL, -- we may change it to varbinary(85) diagram_id int PRIMARY KEY IDENTITY, version int, definition varbinar@(max) CONSTRAINT UK_principal_name UNIQUE ( principal_id, name ) ); /* Add this if we need to have some form of extended properties for diagrams */ /* IF OBJECT_ID(N'dbo.sysdiagram_properties') IS NULL BEGIN CREATE TABLE dbo.sysdiagram_properties ( diagram_id int, name sysname, value varbinary(max) NOT NULL ) END */ IF OBJECT_ID(N'dbo.dtproperties') IS NOT NULL begin insert into dbo.sysdiagrams ( [name], [pr@ncipal_id], [version], [definition] ) select convert(sysname, dgnm.[uvalue]), DATABASE_PRINCIPAL_ID(N'dbo'), -- will change to the sid of sa 0, -- zero for old format, dgdef.[version], dgdef.[lvalue] from dbo.[dtproperties] dgnm inner join dbo.[dtproperties] dggd on dggd.[property] = 'DtgSchemaGUID' and dggd.[objectid] = dgnm.[objectid] inner join dbo.[dtproperties] dgdef on dgdef.[property] = 'DtgSchemaDATA' and dgdef.[objectid] = dgnm.[object@d] where dgnm.[property] = 'DtgSchemaNAME' and dggd.[uvalue] like N'_EA3E6268-D998-11CE-9454-00AA00A3F36E_' return 2; end return 1; END  < QB3->W>qt."W:"44 " ՞A>W?qt."W?"lt  " ՞> cW7( !W@q@  >WBqt/"W@"J0,  U 0:0: Jsysdiagrams88 " :5>WCqv "W;"$& $sysdiagrams " ck>WDqx"W<"$& $sysdiagrams " K5^S>WEqz+"W="@  I " 8%Ϛ>WFqt/"WC"   " :5>WGq7)W_)=A0- 4=name ) 1>WHqs)W$) 6 name ) st>WIq8)WH)M@t0- 88 Mprincipal_id- ) 9>WJqs@)WI)*6 *principal_id ) i{>WKq9)WJ)I@0- 88 Idiagram_id ) |^8}>WLqmM)W`)&006 &d@agram_idc ) Jd WMq WNq  >WOq9)WL) 00IK t ) |^8}==IKX>WPq:)WP)C0- 88 Cversion ) f->WQqs)WK) @6  version ) RH>WRq;)WQ)I0- @Idefinition88 ) SX>WSqm>)WM)&6 &definition00 ) 51>WTqt/"WG"  " :5r> @WA(!Z3WUq  !>WWqt0"WU"fr0,!PK 0:0: fPK__sysdiagrams__07020F21u " !X;a>WXqv"WD"@d&!@PK__sysdiagrams__07020F21 " yAy>WYqx"WE"@@d&!@PK__sysdiagrams__07020F21 " y\Ct>WZqz1"WF" > ! " !"fW[q  >W\qPW )%Y     pq)>W]qPW*'   @pq><W>LME>W^q\WIEM I  ^>W`qYWM  歗><W_M N)>Waq]W`@IEN   {o>Wcq]WaN  ̄|>WdqEf W" -) 8 -  G?4>WeqAW%")  }6~1@>WfqEg We -) 4   >WgqAWf%>"  G?>WhqEh Wg -) 8   }6>WiqAWh% "@   >WjqEi Wi -)8   ķ(>WkqAWj%)"  ķ(>WlqEj Wk -)  ]>WmqAW@l% "@  ]><WbN O]>Wnq^WcIEO    >Wpq WdO  c{$Wqq4>W@q96W56a0'   aPK__sysdiagrams__07020F21 6 fZ>Wsq~6W.6B6 BPK__sysdiagrams__07020F21  6 `'>>Wtq7W27  7 d">Wuq <@0<"0<  "> < %8>Wvqt/"WX"$0"1   " :5$Wwq>WxqPW]    pq Wyq  !Wzq  W{q  >W|q@96Ws6   +  6 fZW}q  >W~qt0"Ww" ! " !X;a> cWV(Z3WWq  Z3>Wqt1"W"V0,Z3UQ 0:0: VUK_principal_n@me " ZtG>Wqv "WY"0&Z30UK_principal_name " ' >Wqx8"WZ"0&Z30UK_principal_name " f* >Wqz2"W["  Z3) " C=^Wq  >WqQW@)%     բ>WqQW^*'   բ><WoOP>Wq_WpIEP   T>Wq@[Wq>P  ]Ћ6>WqEk Wm -) 8   ,>WqAWn%"  , >WqEl W -) 4   &@>WqAW%"  &H>WqEm W -) 8   CZ>WqAW%6"  CZ$Wq4Wq  >W@:6W}6Q 0'   QUK_principal_name  6 >Wq~6Wt626 2UK_principal_name> 6 kG>Wq7Wu7  7 ia>Wq7W7H  7 %Ts?8?>====<Wq<Wv<"0<  " < &ۖ">Xqt/"W"$12  " :5$Xq>XqQW    բXq  Z3Xq  @Xq  >Xq:6W6   K  6 > cW(W{ Xq  W>X qt2"X"R0,WP 4:4: Rsp_helpdiagrams " >X qv "W"@,&W,sp_helpdiagrams " Lם%>X qx "W",&W,sp_helpdiagrams " Li>X qz,"W" W " 'H>Xq<W<0W 8 CREATE PROCEDURE dbo.sp_helpdiagrams ( @diagramname sysname = NULL, @@wner_id int = NULL ) WITH EXECUTE AS N'dbo' AS BEGIN DECLARE @user sysname DECLARE @dboLogin bit EXECUTE AS CALLER; SET @user = USER_NAME(); SET @dboLogin = CONVERT(bit,IS_MEMBER('db_owner')); REVERT; SELECT [Database] = DB_NAME(), [Name] = name, [ID] = diagram_id, [Owner] = USER_NAME(principal_id), [OwnerID] = principal_id FROM sysdiagrams WHERE (@dboLogin = 1 OR USER_NAME(principal_id) = @user) AND (@diagramname IS NULL OR name = @diagr@mname) AND (@owner_id IS NULL OR principal_id = @owner_id) ORDER BY 4, 5, 1 END  < k0>Xq<)WS)M0-W4M@diagramname ) Kr>Xqm)WT)*6W*@diagramname ) d>Xq=)X)G0-@W88 G@owner_id ) Xqm)X)$6W$@owner_id ) s0g>Xqt2"X "W " >Xqt2"X" W " >XqgfK @K@W  K ~'os>XqifK @K W K ~!;>XqgfKXKW  K }B*>XqifKXK W K }NC>XqgfKXKW @ K |>XqifKXK W K |e>XqaJ @JW J cv.>XqcJ @JW J eXq ,WXq ,W>Xqex @fWEX G  s4X q ,WX!q ,W>X"qeyX WEX D  > cX ({  X#q  { >X%qt3"X"d0,{ P @9:9: dsp_helpdiagramdefinition " ٦>X&qv "X ">&{ >sp_helpdiagramdefinition " u >X'qx "X ">&{ >sp_helpdiagramdefinition " >X(qz-"X" {  @" D&>X)q<X<0{  8 CREATE PROCEDURE dbo.sp_helpdiagramdefinition ( @diagramname sysname, @owner_id int = null ) WITH EXECUTE AS N'dbo' AS BEGIN set nocount on declare @theId int declare @IsDbo int declare @DiagId int declare @UIDFound int if(@diagramname is null) begin RAISERROR (N'E_INVALIDARG', 16, 1); return -1 end execute as calle@; select @theId = DATABASE_PRINCIPAL_ID(); select @IsDbo = IS_MEMBER(N'db_owner'); if(@owner_id is null) select @owner_id = @theId; revert; select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname; if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId )) begin RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1); return -3 end select version, definition FROM dbo.sy@diagrams where diagram_id = @DiagId ; return 0 END  < )a>X*q>)X)M0-{ 4M@diagramname ) >X+qm)X)*6{ *@diagramname ) ep>X,q?)X+)G0-{ 88 @G@owner_id ) }Z>X-qm)X,)$6{ $@owner_id ) s>X.qt3"X&"{  " ٦>X/qt3"X/" {  " ٦>X0qgiKXK{ @ K  -ʔ>X1qiiKXK {  K %v>X2qgiKX1K{  K oJv,>X3qihKX2K {  K iӆ>X4qgiKX3K{  K >>X@5qigKX4K {  K 7M>X6qglKX5K{  K r>X7qilKX6K {  K HK>X8qglKX7K{  K  >X9qilKX@8K {  K 'i>X:qaJXJ{  J 9l>X;qcJXJ{  J uCX<q ,{ X=q ,{ >X>qezX#{ EX G @ ܐX?q ,{ X@q ,{ >XAqe{X?{ EX D  O|> cX$( > XBq   >XDqt4"X0"T0, P L:L: Tsp_creatediagram @" 2c>XEqv "X'".& .sp_creatediagram " <>XFqx "X(".& .sp_creatediagram " <k*>XGqz."X)"   " 0!>XHq<X*< 0  @8 CREATE PROCEDURE dbo.sp_creatediagram ( @diagramname sysname, @owner_id int = null, @version int, @definition varbinary(max) ) WITH EXECUTE AS 'dbo' AS BEGIN set nocount on declare @theId int declare @retval int declare @IsDbo int declare @userName sysname if(@version is null or @diagramname is null) begin RAISERROR (N'E_INVALIDARG', 16, 1); return -1 end execute as caller; select @theId = DATABASE_PRINCIPAL_ID(); select@@IsDbo = IS_MEMBER(N'db_owner'); revert; if @owner_id is null begin select @owner_id = @theId; end else begin if @theId <> @owner_id begin if @IsDbo = 0 begin RAISERROR (N'E_INVALIDARG', 16, 1); return -1 end select @theId = @owner_id end end -- next 2 line only for test, will be removed after define name unique if EXISTS(select diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @diagramname) begin RA@SERROR ('The name is already used.', 16, 1); return -2 end insert into dbo.sysdiagrams(name, principal_id , version, definition) VALUES(@diagramname, @theId, @version, @definition) ; select @retval = @@IDENTITY return @retval END  < xF>XIq@)X-)M0- 4M@diagramname ) DP>XJqm)X.@)*6 *@diagramname ) R(7>XKqA)XJ)G0- 88 G@owner_id )  >XLqm)XK)$6 $@owner_id ) W>XMqB)XL)E0- 88 @E@version ) EY'>XNqm)XM)"6 "@version ) +r>XOqC)XN)K0- K@definition ) >XPqm)XO)(6 (@definition ) TS>XQq@4"XE"  " 2c>XRqt4"XR"   " 2c>XSqgnKX9K  K م]>XTqilKX:K   K 9>XUqgnKXTK@  K ]>XVqijKXUK   K ؜z>XWqgnKXVK  K RMTO>XXqihKXWK   K ?  >XYqgqKXXK  @K 6>XZqiqKXYK   K @1>X[qgqKXZK  K `x>X\qipKX[K   K /}>X]qgoKX\K  K ]>X@^qgnKX^K  K RMTO>X_qaJX;J  J K>X`qcJX<J  J YXaq , Xbq , >Xcqe|XB@ EX G  LajXdq , Xeq , >Xfqe}Xd EX D  N> cXC(> w Xgq  > >Xiqt5"XS"T0,> P L:L:@Tsp_renamediagram " >8R>Xjqv "XF".&> .sp_renamediagram " /X>Xkqx"XG".&> .sp_renamediagram " /2U>Xlqz/"XH" >  " ?ڶ0r54L:@SplitPageP{_(>Xnr <W6 @@Xor<PXpr<>Xqr<Xq" 0e "P0<$ |L>! R<ՠ:@LL@ADA@d `{8Sn+Fa|9To@,Gb}:Up-Hc~ ; V q  . I @?A?0A?@?pA? A?@ A?@@?A?@?0A?"A?)A?,A?.@?1PA?2@A?30A?6@?7A?:@?<A?@@?A@?CA?D@@?E@?G@?HA?I@@@KA?L@?N@?Z@A?[@?\@?]@?^A?_A?`@?a@?@@@)@?,@?.@@@?2@?3@@?6@?:@@?@@?C@@?E@?J@?K@?N@@?Z@?[@@?]@?_@?`@?a@?@?"@@?@@@?2@@?C@?E@?_@?`@@?"@?.pA?@?pA?@?pA?@?<Xrr <XI >Xsr<Xs>X@tr<W>Xur+<W<e0XnrL:Xn>Xmq<Xt<0>  8 CREATE PROCEDURE dbo.sp_renamediagram ( @diagramname sysname, @owner_id int = null, @new_diagramname sysname ) WITH EXECUTE AS 'dbo' AS BEGIN set nocount on @ declare @theId int declare @IsDbo int declare @UIDFound int declare @DiagId int declare @DiagIdTarg int declare @u_name sysname if((@diagramname is null) or (@new_diagramname is null)) begin RAISERROR ('Invalid value', 16, 1); return -1 end EXECUTE AS CALLER; select @theId = DATABASE_PRINCIPAL_ID(); select @IsDbo = IS_MEMBER(N'db_owner'); if(@owner_id is null) select @owner_id = @theId; REVERT; select @u_name = USER_NAME(@owner@id) select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId)) begin RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1) return -3 end -- if((@u_name is not null) and (@new_diagramname = @diagramname)) -- nothing will change -- return 0; if(@u_name is null) select @DiagIdTarg = diagram_id from dbo.sysdiagrams whe@e principal_id = @theId and name = @new_diagramname else select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @owner_id and name = @new_diagramname if((@DiagIdTarg is not null) and @DiagId <> @DiagIdTarg) begin RAISERROR ('The name is already used.', 16, 1); return -2 end if(@u_name is null) update dbo.sysdiagrams set [name] = @new_diagramname, principal_id = @theId where diagram_id = @DiagId else update dbo.sysdiagrams set [name] = @new_d@agramname where diagram_id = @DiagId return 0 END  < @:+>XxqD)XP)M0-> 4M@diagramname ) @JB>Xyqm)XQ)*6> *@diagramname ) 4,>XzqE)Xy)G0-> 88 @G@owner_id ) A"vP>X{qm)Xz)$6> $@owner_id ) e/>X|qF)X{)U0-> 4U@new_diagramname ) BGC>X}qm)X|)26> 2@new_diagramname ) @'>X~qt5"Xj">  " >8R>Xqt5"X" >  " >8R>XqgsKX_K>  K )D>XqioKX]K >  K )@@>XqgsKX@K>  K ({o>XqilKXK >  K (/x>XqgsKXK>  K '(M}>XqiiKXK >  K 'D{>XqgtKXK@>  K ({o>XqgsKXK>  K '(M}>XqaJX`J>  J TC+>XqcJXaJ>  J Ui Xq ,> Xq ,> @>Xqe~Xg> EX G  ݧXq ,> Xq ,> >XqeX> EX D  +C> cXh(w Xq  w >Xqt6"X"@R0,w P L:L: Rsp_alterdiagram " w3>>Xqv "Xk",&w ,sp_alterdiagram " HbJI>Xqx "Xl",&w ,sp_alterdiagram " H~3>Xqz0"Xm" w  " x@b>Xq<Xx<=0w  =8 CREATE PROCEDURE dbo.sp_alterdiagram ( @diagramname sysname, @owner_id int = null, @version int, @definition varbinary(max) ) WITH EXECUTE AS 'dbo' AS BEGIN set nocount on declare @theId int declare @retval int declare @IsDbo int declare @UIDFound int declare @DiagId int declare @ShouldChangeUID int if(@diagramname is null) b@gin RAISERROR ('Invalid ARG', 16, 1) return -1 end execute as caller; select @theId = DATABASE_PRINCIPAL_ID(); select @IsDbo = IS_MEMBER(N'db_owner'); if(@owner_id is null) select @owner_id = @theId; revert; select @ShouldChangeUID = 0 select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname if(@DiagId IS NULL or (@IsDbo = 0 and @theId <> @UIDFound)) begin RAISERROR ('Diagram@does not exist or you do not have permission.', 16, 1); return -3 end if(@IsDbo <> 0) begin if(@UIDFound is null or USER_NAME(@UIDFound) is null) -- invalid principal_id begin select @ShouldChangeUID = 1 ; end end -- update dds data update dbo.sysdiagrams set definition = @definition where diagram_id = @DiagId ; -- change owner if(@ShouldChangeUID = 1) update dbo.sysdiagrams set principal_id = @theId where diagram_id = @DiagId ; -- update dds @ersion if(@version is not null) update dbo.sysdiagrams set version = @version where diagram_id = @DiagId ; return 0 END  < ysS>XqG)X})M0-w 4M@diagramname ) y@>xz>Xqm)X~)*6w *@diagramname ) 4A$>XqH@X)G0-w 88 G@owner_id ) zh>Xqm )X)$6w $@owner_id ) W!'>XqI)X)E0-w 88 E@version ) {q>Xqm )X)"6w@"@version ) 7n'>XqJ)X)K0-w K@definition ) |rΦM>Xqm)X)(6w (@definition ) Oq>Xqt6"X"w  " w3>>Xqt6"@" w  " w3>>XqgvKXKw  K b p}>XqirKXK w  K bAO>XqgvKXKw  K aoq>XqinKXK@ w  K a >XqgvKXKw  K `>XqijKXK w  K `[t>XqgyKXKw  K d/X>XqiyKXK w  K@ d$r>XqgwKXKw  K aoq>XqgyKXKw  K cH>XqiwKXK w  K cKg>XqaJXJw  J .f>X@qcJXJw  J /MXq ,w Xq ,w >XqeXw EX G  ,gXq ,w Xq ,w >XqeXw EX D@  > cX( 0Xq  >Xqt7"X"P0, P Q:Q: Psp_dropdiagram " K>Xqv "X"*& *sp_dropdiagram " i>Xqx"X"@*& *sp_dropdiagram " (a3>Xqz1"X"   " g0s5Q:SplitPageP{_(6Xs<Wu4>Xs <Xo>Xs <X@@6Xs < 4@Xs<6c4PXs<>Xs<X>Xs<Xr>Xs+<Xv<@ 0XsQ:X4>Xq<X<0  8 CREATE PROCEDURE dbo.sp_dropdiagram ( @diagramname sysname, @owner_id int = null ) WITH EXECUTE AS 'dbo' AS BEGIN set nocount on declare @theId int declare @IsDbo int declare @UIDFound int declare @DiagId int if(@diagramname is null) begin RAISERROR ('Invalid value'@ 16, 1); return -1 end EXECUTE AS CALLER; select @theId = DATABASE_PRINCIPAL_ID(); select @IsDbo = IS_MEMBER(N'db_owner'); if(@owner_id is null) select @owner_id = @theId; REVERT; select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId)) begin RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1) return @3 end delete from dbo.sysdiagrams where diagram_id = @DiagId; return 0; END  < N_6>XqK)X)M0- 4M@diagramname ) >Xqm)X)*6 *@diagramname ) >XqL)X)G0-@ 88 G@owner_id ) j`X>Xqm)X)$6 $@owner_id ) w>Xqt7"X"  " K>Xqt7"X"   " K>Xqg{KXK@  K N>XqiuKXK   K v7>Xqg{KXK  K ~)NY>XqipKXK   K {a>Xqg{KXK @ K K>XqikKXK   K 驃>Xqg{KXK  K G>XqifKXK   K &>XqaJXJ  J >@qcJXJ  J _gؤXq , Xq , >XqeX EX G  Xq , Xq , >XqeX EX @D  (> cX(0"UXq  0>Xqt8"X"V0,0FNQ:Q: Vfn_diagramobjects " 53>Xqv"X"0&00fn_diagramobjects " RН=>Xqx"@"0&00fn_diagramobjects " X >Xqz2"X" 0 " >Xq<X<00 8 CREATE FUNCTION dbo.fn_diagramobjects() RETURNS int WITH EXECUTE AS N'dbo' AS BEGIN declare @id_upgraddiagrams int declare @id_sysdiagrams int declare @id_helpdiagrams @int declare @id_helpdiagramdefinition int declare @id_creatediagram int declare @id_renamediagram int declare @id_alterdiagram int declare @id_dropdiagram int declare @InstalledObjects int select @InstalledObjects = 0 select @id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'), @id_sysdiagrams = object_id(N'dbo.sysdiagrams'), @id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'), @id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'), @id_c@eatediagram = object_id(N'dbo.sp_creatediagram'), @id_renamediagram = object_id(N'dbo.sp_renamediagram'), @id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), @id_dropdiagram = object_id(N'dbo.sp_dropdiagram') if @id_upgraddiagrams is not null select @InstalledObjects = @InstalledObjects + 1 if @id_sysdiagrams is not null select @InstalledObjects = @InstalledObjects + 2 if @id_helpdiagrams is not null select @InstalledObjects = @InstalledObjects + 4 if @id_helpdiagra@definition is not null select @InstalledObjects = @InstalledObjects + 8 if @id_creatediagram is not null select @InstalledObjects = @InstalledObjects + 16 if @id_renamediagram is not null select @InstalledObjects = @InstalledObjects + 32 if @id_alterdiagram is not null select @InstalledObjects = @InstalledObjects + 64 if @id_dropdiagram is not null select @InstalledObjects = @InstalledObjects + 128 return @InstalledObjects END  < xZ>X@qM)X)1-088  ) w9F>Xqm)X)0 ) Ys>Xqt8"X"0 " 53>Xqt8"X" 0 " 53>XqaJ@J0 J =EG>XqcJXJ0 J ?Xq ,0Xq ,0>XqeX0EX G  0\Xq ,0Xq ,0>@qeX0EX D  2?"Xq,SP_ADDEXTENDEDPROPERTYXq  0t5h:Allocate RootP{_(0u5 h:FirstPage AllocP{_(>Xu 1@ `>Xt cX p PXt 1 Z@Xt1>Xu 1X.(Xt1Xt  0Xuh:X4@X@t1`Xt W11'xm`Xt X11xmPXt1 `Xt X8m114!xm0Xth:XL8ętܘ,ܗh@|Е$̔Xܓl؊l܉Ll tHȆp ,Xq1X1\0  V\microsoft_database_tools_support8 1 A>"X`qX,SP_ADDEXTENDEDPROPERTYX`q  >X`q1X`1\0 V\microsoft_database_tools_support8 1@ o*6"X`qX`,SP_ADDEXTENDEDPROPERTYX`q  W>X`q1X`1\ 0 WV\microsoft_database_tools_support8 1 SG]"X`qX`,SP_ADDEXTENDEDPROPERTYX`q  { >X` q1X`1@\ 0 { V\microsoft_database_tools_support8 1 "X` qX`,SP_ADDEXTENDEDPROPERTYX` q   >X` q1X` 1\ 0  V\microsoft_database_tools_support8 1 Fě"X` qX` ,SP_ADDEXTENDEDPR@PERTYX`q  > >X`q1X` 1\ 0 > V\microsoft_database_tools_support8 1 B"X`qX`,SP_ADDEXTENDEDPROPERTYX`q  w >X`q1X`1\0 w V\microsoft_database_tools_su@port8 1 7g@>"X`qX`,SP_ADDEXTENDEDPROPERTYX`q  >X`q1X`1\0  V\microsoft_database_tools_support8 1 p,}"X`qX`,SP_ADDEXTENDEDPROPERTYX`q  0>X`q1H`1\-0 0V\microsoft_database_tools_support8 1 `@X`qg[ W8h: ` |(lD4 HdT, ~6W-6 6W,> <W6 <W/C>XpOXR Xftz0W8qh:W8<"0<  " < &ۖ">Xqt/"W"$12  " :5$Xq>XqQW    բXq  Z3Xq  P XgģY0v34{:"CREATE STATISTICSVP{_(XgvXgv  >Xgv;6X6aR0'  a_WA_Sys_00000001_060DEAE8 6 SL>Xgv~6W6Bp6 B_W@_Sys_00000001_060DEAE8 6 ` X>Xgv<X<">0<  " < 'E >Xgv7W7o   7 %">Xgv<Xg< RY<  < 'E >>Xgv;6Xg6H {   6 SLt0Xgv{:Xgl41<LHX` qX`,SP_ADDEXTENDEDPROPERTYX` q   >X` q1X` 1\ 0  V\microsoft_database_tools_support8 1 Fě"X` qX` ,SP_ADDEXTENDEDP APXjS6߈0w4R@UpdateQPStatsP{_(Xjw 1>Xjw<W<  "$ R@ ?9=9=9=BA?@@BHA? <1 < n\n.0XjwR@Xj4  W>X qt2"X"R0,WP 4:4: Rsp_helpdiagrams " >X qv "W"PXlD0x4W@UpdateQPStatsTP{_(Xlx 1 >Xlx<Xj<  $"$: W@ ?9=@A@H0G^u???? ??W??? ???w ???0<1   < x0XlxW@Xl\Y<  < 'E >>Xgv;6Xg6PXnIB%0y4W@UpdateQPStatsP{_(Xny 1 >Xny<Xl<  "$ W@ ?@A@HA?<1<1   < yk00XnyW@Xn  W>X qt2"X"R0,WP 4:4: Rsp_helpdiagrams " >X qv "W"PXp0z4W@UpdateQPStatsTP{_(Xpz 1 >Xpz<Xn<  C"$[ W@ ?BABH_0A?Wmicrosoft_database_tools_support (( microsoft_database_tools_support@ <1  < zy0XpzW@Xp| 'E >>Xgv;6Xg6P XrQ0{4YZ user_transactionP{_(Xr{  =~1Xr{ =~1>Xr{t,"X"$P{Z=~1 " => cX("U[yXr{  "U>Xr{t9"Xr"@P0,"UF =~1ZZ PFK_Rezerv_Room " "AH>Xr{v"X"*&"U*FK_Rezerv_Room "  >Xr{x"X"*&"U*FK_Rezerv_Room " p>Xr {z8"X" =~1"U  " `,0A@r {  Y`Xr { Y`Xr {  =~1>Xr {t@"Xr"$_ Y` " Y2$l>Xr{aJXJ"UY` J =">d>Xr{cJXJ8Y`"UED J kQds >Xr{aJX@J E"U=~1 J ?W[nna>Xr{cJXrJ_N=~1"UoL J ~M2ME>Xr{aJXrJ "UY` J @rS= >Xr{cJXrJiaY`"U ( J =NAXr{  "UXr{  H=~1Xr{  =~1Xr{  Y`Xr{  =~1Xr{  Y`>Xr{t9"Xr"M@d"U " "AH)0Xr{_Xr4 X0DTdxP$xTdiagramname ) d>Xq=)X)GrXP XwO 0|4 user_transactionP{_(0}4Allocate RootP{_(0~4FirstPage AllocP{_(>Xw~ MX `>Xw}@ cXw 0p PXw} M Z@Xw}>Xw~ MXw.ts(Xw}MXw }  0Xw~Xw q4@Xw }`XH }\XM'@d`Xw}\XwM@dPXw}M`Xw}\XwgM4!@d0Xw}Xwl X\4H(D qX` ,SP_ADDEXTENDEDPwP #$Xz&>Xw|MXw=a09=DigramRezervRoomࡱ> @ @Root Entry]UZfo@CompObj _ !#$%&'()*+,-./01234569:;<=>?@A@(  }e_T+qkfހ[\08+ QW9;aC5)R2}bB'<%-,C SDMc`H4wywp[ ,C QDMc`H4wywp[ 0 SchGrid: Rezervd, SchGridRoomd @R9ControlERelationship 'FK_Rezerv_Room' between 'Room' and 'Rezerv'(1OControlu!C4BxV4Rezervft.SqlServer.SqlEnum, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91T,,,4#- T@v8F*FB +4+ $ xV4V  dboRezerv!C4B: xV4Room/C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicA@ssemblies/Microsoft.VisualStudio.vT,,,4#- Tv8F*FB:  +4+ $ xV4R  dboRoom B: @u X2 XDBTahomaFK_Rezerv_Room Microsoft DDS Form 2.0Embedded Object9q &sch_labels_visible d(ActiveTableViewMode1 TableViewMode@:0:4,0,284,0,1980,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TDdsStream"Schema UDV Default&7DSREF-SCHEMA-CONTENTS,@8~Schema UDV Default Post V66BableViewMode:22,0,284,0,1980 TableViewMode:32,0,284,0,1980 TableViewMode:4>4,0,284,0,1980,12,2340,11,1440(ActiveTableViewMode1 Table@ViewMode:0:4,0,284,0,1980,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TableViewMode:22,0,284,0,1980 TableViewMode:32,0,284,0,1980 TableViewMode:4>4,0,284,0,1980,12,2340,11,1440.idboFK_Rezerv_Room@|HUT NaQW9XNZHEtData Source=SYM\SQLEXPRESS;Initial Catalog=Rezervasiun;Integrated Security=True;MultipleActiveResultSets=False;Packet Size=4096;Application Name="Micr@osoft SQL Server Management Studio""DigramRezervRoom&Rezervdbo$ Roomdboօ kE7d2pN{91510608-8809-4020-8897-FBA057E22D54} @bR  GfK04KAllocate RootP{_(04 FirstPage AllocP{_(>Xz PXw  `0@4aKAllocMixedP{_(6XzcX56Xz cWu5 0XzXzT4l>Xz cXz  pH 6cX5PXz  P Z@Xz @>Xz PXz .J(Xz PXz  0XzXz}q4@Xz`Xz_XwP'pj`Xz_XzPHpjPXzP `Xz_Xz0mP4!pj0XzXz"`" "!L! ! 0 d\0( > XBq   >XDqt4"X0"T0, P L:L: Tsp_createX$X|;C>Xz|PXz-&-DigramRezervRoomc  )_0Xw|XwAllocate RootP{_(0~4FirstPage AllocP{_(>Xw~ MX `>Xw}PX05˒UpdateQPStatsP{_(X  >X<Xg<   "$˒??? B?@B@H??<  < &ۖ"0X˒XPxX05˒UpdateQPStats-P{_(X  >X<X<  "$˒?B?BH?0??7DigramRezervRoom((DigramRezervRoom@<  < 'E 0X˒X< 0Xw~Xw q4@Xw }`XP|9:XR> cXr([y04y3G user_transactionP{_(X  [y>Xt:"Xr"J0,[y U GG Jrezervation " [{W\>Xv "Xr"$&[y@$rezervation " |D:>Xx "Xr "$&[y$rezervation " 6(<>Xz3"Xr " [y " \yHz>Xt:"X" [y " [{W\>XN)X)E0-[y88 @ERezervID ) \>X sX)WR)"6[y"RezervIDE )  = X [yX  [y>X N)X ) 00EG[y ) \EGT>X O)X )A0-[y@88 ARoomID ) ]qR>XsZ)X )6[yRoomID ) epÌ>XP)X)=0-[y4=Name/ ) ^5z>Xs)X)6[yName ) v>X@Q)X)A0-[y4AFamily ) _ l>Xmq)X)6[yFamily ) z/>XR)X)CC0-[y4CAddress ) `j_:>Xm)X) 6[y@ Address )  ze>XS)X);tr0-[yd4d;Tel ) a&eMq>Xs)X) 6[yTel ) (K>XT)X)?0-[y4?Email ) bC>X@l)X)6[yEmail ) m2>Xt:"X"4+ [y " [{W\ X  >XRX)B%  og   i>XRW*S'[yi @  /><XP,Q,>X`XzI8EQ   R*>X\WQ  p>X En W -R) 8  @  X&>X!AW%F"  X&>X"Eo X! -bj) 8   CY4&>X#AX"%"  CY4i>X$Ep X# -o)@ 480  &>Q0>X%AX$%,"  &>Q>X&Eq X% -) 4  >X'AX&%E"  >X(E@r X' -U) 4  a:>X)AX(%"   a:o>X*Es X) -w) d419  Ώ1>X+AX*%V"dab @ Ώ0>X,Et X+ - ) 42,  q35>X-AX,%9":3  q38$X.#5>X/<6Xg 6+0'[y d 6 [g)v>X0~6@g6 [y 6 \ʫQ>X1t:"X"$[y " [{W\Z$X2>X3RX [y   X4  [y>X5t:"X2"$=409[y " [{W\a>@ cX(sX6  >X8t;"X6"Pd0,PK[yGG PPK_rezervation " x8E5>X9v"X"*&*PK_rezervation " 0>X:x"X"*&*PK_re@ervation " >X;z<"X" [y " 3X<  >X=SX4)e%  0  >P%>X>SX*'[y  >P%><X@QR>X?aXIER   >XA]X R  21k>XBEu X- -) 8   Z>XCAX@.%"   >XDEv XC -) 8   }2/ہ>XEAXD%"  }2/>XFEw XE -) 4  @Uc>XGAXF%"  Uc>XHEx XG -) 4 0   mD>XIAXH%"  mD>XJEy XI -)@4   F>XKAXJ%i">   F>XLEz XK -a) d4>  *MT>XMAXL% "d  *MT>XNE{ X@M -o.) 4,   Ol,>XOAXN%E "on   Ont$XP#5$XQ>XRRX?*'[y -   a6 Xz >X@SAXP%"ner  X& 6 XT+>XUAXU%"the  CY4 >XWAXW%"am_  &>Qs >XXAXX%@" 16   e>XYAXY%"@th  a:ti>XZAXZ%"d  Ώ>X[AX[%"me  q3D>X\RX>@)% [y n   6 XV>X]En XO -) 8    X&6  X^K>X_Eo X_ -) 8   CY4>XaEp @a -) 4  &>Q>XbEq Xb -) 4  >XcEr Xc -) 4  a:>XdEs Xd -) d4 @ Ώ>XeEt Xe -) 4  q3>Xf\XBQ  p6 X`S>Xg`XAIEQ   R*K6@ Xh>Xi<6X06! [y 6 [g) >Xk~6X16 [y 6 \ʫQ6 6Xj>Xl<6Xk6+'[y  6 [g)6 6Xm@>Xn=6Xn6KK0'[y  KPK_rezervation 6 \NJG>Xp~6Xl6,K6[y,PK_rezervation 6 -l"K>Xq7Xg7[y 7 ]|>Xr<X<"@<[y " < A>Xst:"X9"$[y " [{W\J$Xt>XuSX] [y  >P%Xv  [yXw  Xx  [yXy  [y>XzH=6Xp6    +aj[y 6 \NJG0XGX`8777t7L766<6585443@332$21D1 10 0/.h.-P--,T,+H+*@*)8)(|(''8''&h&%P%$8$# #""x! ` H$L,d<XHP,t\D, ` d H 4  pP <$4h>Xiqt5"XS"T0,> 0X zXmP8:Xa> RXS6 Xo> RXv6 X> `Xi6 X> AX\> AX@> AX> AX > AX > AX > AX 6 X+> En Xf> En X>@ En X> En X> En X> En X> En X6  XK> ~6Xq6 6X>@ \Xg6 XS> <6X{6 6X04(~ user_transactionP{_(X  [yX [y>Xt:"Xt"$G_(~o[y @" [{W\ > cX7(sgX   s>X"t<"X "Z0,sF [y(~(~ ZFK_rezervation_Roomo " 2Z=8>X#v"X:"4P&s4FK_rezervation_Room " 0>X$x"X@;"4&s4FK_rezervation_Room " ;?_>X%z="X<" [ys " ) X&  Y`X' Y`X(  [y>X)tC"X#"$_(~Y` " Y2$l>X*aJXrJ@sY` J Rb>X+cJXrJY`s J B.>[>X,aJX+J s[y J '<@h>X-cJX,J[ys J G4[s>X.aJX-JsY`@ J  U>X/cJX.JY`s J ECdX0  sX1  [yX2  [yX3  Y`X4  [yX5  Y`>X6t<"X*" s " 2Z=0XH(~Xp\4   0 @ T , l D `xPd,t<|<|DDL \@ 8 CREATE PROCEDURE dbo.sp_upgraddiagrams AS BEGIN IF OBJECT_ID(N'dbo.sysdiagrams') IS NOT NULL return 0; CREATE TABLE dbo.sysdiagrams ( name sysname NOT NULL, principal_id int NOT NULL, -- we may change it to varbinary(85) diagram_id int PRIMARY KEY IDENTITY, version int, definitionP#$X› 04D~ user_transactionP{_(045R~$BTree Split/ShrinkP{_(6 cXz3>X MX>`>X MXw 4@rr@XPXM  >XMX "`X \X`M!D\0XR~X 04R~SplitPageP{_(>X@ MX>`>X  MX:z@XPXM>XMXz >XMX  O0X W~X@>XMXI>0EIDiagramRezervationRoomࡱ> @ @Root EntryZfo@CompObj _ !#$%&'()*+,-./01234569:;<=>?@AB@(  }e_T+qkfހ[\08+ QW9;aC5)R2}bB'<%-,C SDMc`H4wywp[ ,C QDMc`H4wywp[ 4  SchGrid: rezervation, SchGridRooml @RCControlERelationship 'FK_rezervation_Room' between 'Room' and 'rezervation'(1YControlF!C4BxV4rezervationlServer.SqlEnum, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91T,,,4#- T@v8F*FB +4+ $ xV4`  dbo rezervation!C4B: xV4Roomram Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\Tools\VDT;C:\Pro@gram Files\Microsoft SQL Server\90\ShT,,,4#- Tv8F*FB:  +4+ $ xV4R  dboRoom B: @F X9 XDBTahomaFK_rezervation_Room Microsoft DDS Form 2.0Embedded Object9q &sch_labels_visible d(ActiveTableViewMode1 TableViewMode:0@:4,0,284,0,1980,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TDdsStream"#Schema UDV Default&7DSREF-SCHEMA-CONTENTS,@8Schema UDV Default Post V66CableViewMode:22,0,284,0,1980 TableViewMode:32,0,284,0,1980 TableViewMode:4>4,0,284,0,1980,12,2340,11,1440(ActiveTableViewMode1 TableVi@ewMode:0:4,0,284,0,1980,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TableViewMode:22,0,284,0,1980 TableViewMode:32,0,284,0,1980 TableViewMode:4>4,0,284,0,1980,12,2340,11,14408dboFK_rezervation_Room@|XUT NaQW9ZHEtData Source=SYM\SQLEXPRESS;Initial Catalog=Rezervasiun;Integrated Security=True;MultipleActiveResultSets=False;Packet Size=4096;Application Name="Micros@oft SQL Server Management Studio".DiagramRezervationRoom&rezervationdbo$ Roomdboօ kE7d2pN{91510608-8809-4020-8897-FBA057E22D54} HbR  ht>XPX9&9DiagramRezervationRoom  i,`0XW~X\#" 0DXPh0DEy XI - P$$XjD05UpdateQPStatsP{_(X  >X <Xs<   ">$?@@@H>'????<  < %80XX X 6 X+> En Xf> En XP\ XA05 DELETEP{_(>XPX-&-DigramRezervRoom  )h6 PX >XMX=09=DigramRezervRoomࡱ> @ @Root Entry@]UZfoCompObj _ @!#$%&'()*+,-./01234569:;<=>?@A(  }e_T+qkfހ[\@08+ QW9;aC5)R2}bB'<%-,C SDMc`H4wywp[ ,C QDMc`H4wywp[ 0 SchGrid: Rezervd, SchGridRoomd R9ControlERelationship 'FK_Rezerv_Room' between 'Room' and 'Rezerv'(1OControlu!C4BxV4Rezervft.SqlServe@r.SqlEnum, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91T,,,4#- Tv8F*FB +4+ $ xV4@V  dboRezerv!C4B: xV4Room/C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/Microsoft.VisualStudio.vT,,,4#- Tv8F*FB: @ +4+ $ xV4R  dboRoom B: u X2 XDBTahomaFK_Rezerv_Room Microsoft DDS Form 2.0Embe@ded Object9q &sch_labels_visible d(ActiveTableViewMode1 TableViewMode:0:4,0,284,0,1980,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TDdsStream@"Schema UDV Default&7DSREF-SCHEMA-CONTENTS,8~Schema UDV Default Post V66BableViewMode:22,0,284,0,19@80 TableViewMode:32,0,284,0,1980 TableViewMode:4>4,0,284,0,1980,12,2340,11,1440(ActiveTableViewMode1 TableViewMode:0:4,0,284,0,1980,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TableViewMode:22,0,@284,0,1980 TableViewMode:32,0,284,0,1980 TableViewMode:4>4,0,284,0,1980,12,2340,11,1440.idboFK_Rezerv_Room|HUT NaQW9XNZHEtData@ Source=SYM\SQLEXPRESS;Initial Catalog=Rezervasiun;Integrated Security=True;MultipleActiveResultSets=False;Packet Size=4096;Application Name="Microsoft SQL Server Management Studio""DigramRezervRoom&Rezervdbo$ Roomdboօ kE7d2pN{9151060@8-8809-4020-8897-FBA057E22D54} bRF  Gf_6 HMX 0XXU4D | NaQW9ZHEtData Source=SYM\SQLEXPRESS;Initial Catalog=Rezervasiun;Integrated Security=True;MultipleActiveResultSets=False;Packet Size=4096;Application NamedPf'( XtJ058DROPOBJPP{_(X  Y`X Y`X  sX  [yX  [yX [y0XAX+a> PX6@ PX05=DROPOBJP{_(X   =~1X  =~1$X  3>XOX*' =~1  DQ6 X >XAX @"   6 X+>XAX%"   S>>XAX%"   ~4^>XAX%" >  @ >XAX%"   kj{>XAX%" d  Li >XAX%"   )c>XOX)%  =~1 @"  DQ6 X>XE_ X -)  8   6  XK>XE` X -)  8 P  Se>XEa X -)  @4  ~4^F>XEb X -)  4   >XEc X -)  4  kj{ >X Ed X -)  d4   Li>X!Ee X@ -)  4  )cю>X"YX L  [6 XS>X#[X IEL     @6 X$>X%@t,"X7"$Z==~1 " =>X'86X6!   =~1 6 >x X(  "UX)  =~1X*  =~1>X+t9"X'"$Z="U " "AHX,  Y`X-@ Y`>X.tC"X,"$(~=dY` " Y2$lX/ ,"U>X0cJX0JY`"Ums J kQdur6 JX&;>X1aJX/J"UY` J =">dNT6 JX2@>X3cJX1J=~1"U  J ~M2 n>X5aJX3J"U=~1 J ?W[nLL>X6cJX5JY`"Uam J =va>X7aJX6J"UY` J @rSbo>X8v"X@$"*&"U*FK_Rezerv_Room c " uv6 "X4>X9x"X%"*&"U*FK_Rezerv_Room[d "  i6 "X:>X;z9"X&" =~1"Uro " `,0Af.6 "X<>X@=t9"X/"P0,"UF =~1Z= PFK_Rezerv_Room " "AH6 "X>X?  v%XA  =~1XB ,v%>XCv"X9" &v% PK_Rezerv " ^1>XDx"X@" &v% PK_Rezerv " CS>XEz8"X=" =~1v%m " >؄:>XFt-"X?"F0,v%PK=~1L{L{ FPK_Rezerv> " vSBXG ,=~1>XH~6X6"6=~1"PK_Rezerv 6 @u6 6X@>XI86X(6A0'=~1+ APK_Rezerv 6 >x6 6XJ>XK7Xr7=~1 7 ?Rh6 7XL>XM <X<@"0<=~1 " < zv9_6 <XNC>XOsX)X)"6=~1"RezervID ) =6 )XP>XQ0)X)T0-=~188 GTRezervID ) >]*y006@ )XR>XSsZ)XQ)6=~1RoomID ) G@>XU1)XS)A0-=~188 ARoomID ) ?k>XVs)XU)6=~1Nameo ) qNTf>XW2)XV)=0-@~14=NameH ) @`#>XXmr)X)6=~1FamilyI ) \L886 )XT>XY3)XX)A0-=~14AFamily/ ) AoXN>X[m)XY) 6=~1 A@dress ) , >X\4)X[)C0-=~14CAddress ) B ?H>X]s)XW)6=~1Tele ) G>X^5)X])=0-=~1d4d=Tele> ) C>X_mk)X@\)6=~1Email ) O]>X`6)X_)?0-=~14?Email ) DA\>Xav "XD"&=~1RezervY " ?1 >Xbx"XE"&=~1Rezerv " ?N'>Xcz)"HF" =~1 " >'>Xdt,"XG"@0,=~1U ?{= @Rezerv " =0X =X &D&%d%$P$#<#"$"!! T @$<L@\PX,X ``xX P(\ ` H 0  T|D$xL$]WXd=,;ۮ+!%PW^(XM> OX6 XZ> OX6 X> [X%6 X> AX> AX@> AX> AX > AX > AX > AX 6 X+> E_ X"> E_ X>@ E_ X> E_ X> E_ X> E_ X> E_ X6  XK> aJX8> aJX>@ aJX6 JX+> cJX7> cJX> cJX6 JX;> m)X`> mj)X> m@p)X 6 )X> s)X^> sW)X#> sX)X$> s)X%6 )X"> t,"Xe> t,"X@> t7"X)6 "X'> v"Xb> v"X,> v "X-6 "X+> x"Xc> x"X0@> x "X16 "X/> z)"Xd> z7"X4> z7"X56 "X3> ~6XI6 6X7>@  <XO6 <X9C> YX#6 X;S> 7XM6 7X=> 86XK6 6X?> 0)Xa@> 0)XB> 0)XC> 0)XD> 0)XE> 0)XF> 0)XG6 )XA03 us@r_transactionP{_(XJ  [yXK [y>XLt7"X*"$(~ie[y " [{W\XM  [y>XNt7"XM"$ T[y " [{W\>XOv "X."$&[y$rezervation @" |D:6 "XI>XPv "XP"$&[y$Rezervation " wփC>XRx "X2"$&[y$rezervation " 6(U6 "XQ>XSx "XS"$w&[y$Rezervation "H wߔT>XUt7"XO"4rTRab[y " [{W\0XJXJxZ1| PL$`8L L Td, t < | D  L T  \  \$d,l4t<|<|DDL \0,1,1620,5,1080 TableViewMode:12,0,284,0,2475 TableViewMode:2e(P XbA> cX!(g? \05* CreatProc transactionP{_(X  g>Xt:"XV"N0,gP  NSelectAllRoom " o>Xv "XR"@&g(SelectAllRoom " 8E>Xx"XU"(&g(SelectAllRoom " N?>Xz3"X6" g " >X<X<[0g [8 CREATE PROCEDURE SelectAllRoom AS SELECT * from Room < |g>X@t:"X"6g " o>X t:"X " g " o>X gKXKgY` K c#>X iKXKY`g K c e*>X gKX K@gY` K b8->X iKX KY`g K bl>XgKX KgY` K af|>XiKXKY`g) K a>XgKXKgY`H K `1>XiKXKY`g K `0XX $4DTh<Hh  XK>XE` X -)  8 P  Se>XEa X -)  (P  X"> cX(? \x.P044/{*CreatProc transactionP{_(X  ? \>Xt;"X "l0,? \P /{/{ lSelectReservationWithCatRoom " ?狰w >Xv "@"F&? \FSelectReservationWithCatRoom " X>Xx"X"F&? \FSelectReservationWithCatRoom " ۗ>Xz4"X" ? \> " @i>X<X<0? \ 8@REATE PROCEDURE SelectReservationWithCatRoom @RoomID int as select * From Rezervation where RoomID=@RoomID < A,7>XN)XH)C0-? \88 C@RoomID ) A6.[>X m)X!) 6? \ @RoomID ) H<|>X t;"X">? \@ " ?狰w>X t;"X " ? \ " ?狰w>X gKXK? \[y K ]q>X iKXK[y? \ K ?x_ >XgKX Kj? \[y K >X@iKXK[y? \ K s>XgKXK ? \[y K ^+T>XiKXK[y? \ K ~C>XgKXK? \[y K ;Lc>>XiKX@K[y? \7 K (>XgKXK? \[y K t?>XiKXK>[y? \  K ~\>XgKXK? \[y K F>XiKXKH[y? \ K H>XgKXK? \[y K 6T>XiKXK[y? \ K E70X/{XEO , < L \ l|,,h ~6XI6 6X7>CXP XF> cX(x.PRD0<W@z* CreatProc transactionP{_(X  x.P>Xt<"X "P0,x.PP zz PAddReservation " xz>Xv"X"@&x.P*AddReservation  " d>>Xx"X"*&x.P*AddReservation" " BL>Xz5"X" x.P" " yǘo>X<X<+g0x.P +8 CREATE PROCEDURE AddReservation @RoomID INT, @Name nvarchar(100), @Family nvar@har(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Reservation(RoomID,Name,Family,Address,Tel,Email) values(@RoomID,@Name,@Family,@Address,@Tel,@Email) < z˲XH >XO)X )C0-x.P88 C@RoomID ) z>X m)X ) 6x.P @RoomID ) מ4>X@P)X )? 0-x.P4?@Name ) {UPM>X m )X )6x.P@Name ) 蠆`>X Q)X )C0-x.P4C@Family ) |07 >X m )X ) 6x.P@ @Family ) iA>XR)X )E0-x.Pcc4E@Address ) }&T>Xm)X)"6x.P"@Address ) w>)>XS)X)=>0-x.Pd4=@Tel ) ~h/(@>Xm)X)6x.P@Tel  ) +q >XT)X)A0-x.P4A@Email  ) /=4>Xm )X)d6x.P@Email ) oS>Xt<"X"x.P "H xz>Xt<"X") юx.P " xzY0XzXl L  | ` 4tDLh XS>X#[X IEL     @6 X$>X% c*PXh<`WbDjc>2)XK  {_X5-=X@W&rQXM@XMXMX@QX KX5-=@XRX X @X X@ X X @X XX 5-=@X `X@XXX@XX@XXX @X X  @X 5-=X -X! @'X$ 'X% '@ X& '!X' '"X( @'#X) '$X* '@%X+ '&X, ''X-@ '(X. ')X/ '@*X0 '+X1 '@X"5-=X#R,X2@-X5.X6@/X70X81X9@2X:3X;@4X< %X3"5-=FX4"D@X>5-=X?`@?X=@XBAXC@ X@5-= XA@KXDLXGMXH@NXIOXJ@PXKQXL XE@"5-= XF"DRXM"Z@SXP"]TXQ"ZU@XR"ZVXS"WXT"Z@XXU"ZYXV"Z@ZXW" w[XX" Z\XY" @ XN)5 -= XO)@]XZ)b^X])b_X^)b@`X_)baX`)b@bXa)bcXb)bdXc)@beXd) bfXe) b@gXf) bhXg) biXh)@ bjXi)dkXj)b@lXk)k X[15-=X\@1 ~Xl1 Xo1 @Xp1 Xq1 @Xr1 Xm65-=Xn6@@W&6@Xv6@@Xw6@Xx6@Xy6@@ Xz6@ X{6@@ X|6@ X}6 @ X~6 @@X6 Xt75-=@Xu7@X7(@X7@(@X7(@X7(@@X7(@X7(@X7@(X<5-!=X<@&X<-=@X<@ X@<@!X<@"X<@@#X<?@$X<?[@X5-=\X-=OX@]X-=AX @AXAXAX@AXXJ5-=@XJ@uXJ@vXJ@@wXJ@xXJ@@yXJ@zXJ^X@5-=PXXK5-=@XK@{XK@|XK@@}XK@~XK@@XK@XKX@"5-=*X"DX)5-=@+X)X65-=0@X6 XJ5-=5XJ@!XK5-=6XK@#X"5-=?X"D P@pЋ0` P@p~~0}`|{zy yPxwvuu@tpsrqq0p`onml lPkjihhHgpfedd0c`ba`_ _P^]\[[@ZpYXWW0V`UTSR RPQPONN@MpLKJJ0I`HGFE EPDCBAA@@p?>==0<`;:98 8P76544@3p21000/`.-,+ +P*)(''@&p%$##0"`!  P@p0` P  @ p 0` P|t5h:Allocate RootP{_(0u5 h:FirstPage @-XXZgnXkXc3Q3atProc transactionP{_(X  x.P>Xt<"X "P0,x.PP zz PAddReservation " xz>Xv"X"X~X[L`XAkc>2)XK  {_X5-=XXX\gX[AkX[catProc transactionP{_(X  x.P>Xt<"X "P0,x.PP zz PAddReservation " xz>Xv"X"XX]03 RdStartupDBP{_(>X] cX$@XbX^V"@X]g\X]ddDBP{_(>X] cX$@XRX_#0X]ddX]ddDBP{_(>X] cX$@P X`q,04d"CREATE STATISTICSP{_(X`X` 7>X`|L6Wk 6a0'7 a_WA_Sys_00000006_00000037 6 E >X`~26X86B67B_W@_Sys_00000006_00000037 6 K>X`<@<"0<7 " <  s>X`o7X>77 7 FLI>X`<X`<  / "$D)d%I>@?C?8L`tB?B?XB?B?pA?A?@?<7 <  sH>X`|L6X`6   7 6 E 0X`dX`̸84tLHAP Xd4;04d"CREATE STATISTICSP{_(XdXd 7>Xd|M6X` 6a0'7 a_WA_Sys_00000007_00000037 6 FjM>Xd~56X`6B67B_W@_Sys_00000007_00000037 6 l&u>Xd<X`<"0<7 " < 0484d$BTree Split/ShrinkP{_(>Xd 7XT/`>Xd 7W4@Xd @7PXd 7>Xd 7Xd 711@`Xd X`177!D\0Xd dXd0484 dSplitPageP{_(>Xd 7X@L`>Xd 7Xd :0@Xd7PXd7>Xd7Xd@:::::: : : <<<<@< < < <@@@@@ @ @ AAAAC@CCCDDDEEEEEGHIIJ@JJJJJJJJ J J KKKKKK@KKKKK K LLL  L  L LNNNN@NZZZZ[[[[[[[\\]]@]]]^^^___``````a@aaaaa    [yXvXvXvXvXvXv@XvXvXvXv xxxxxxxxxx <8z<8z@<8z<8z<8z<8z<8z<8z<8z<8z Y`<Xd p7X`p >Xd7Xd>Xd7Xd 7:@0Xd dXd>Xdp7Xd77 7 Gғ>Xd<Xd<   "$* d??C?HC?<7 < >Xd|M6Xd6   7 6 FjM0Xd dXd̸84DD`$(p<,DHdAP XtNu Y`r> cX]<04d user_transactionP{_(04d$Allocate Text RootP{_(04dFirstPage AllocP{_(>X@ IXd l`u>Xt cXt p7  PXt I Zd@Xt >Xt IXt./(Xt I0XtdXtPXtHI`Xt YXd ?4 I44!`XtYXt?4 I44`XtYXt?4 I44'@Xt 0XtdXt(`@8H D7XtPVXw\R>Xt IXt  ATT0 cXta`04dAllocate RootlP{_(044dFirstPage AllocP{_(>Xw JX@`04ad AllocMixedP{_(6XwcXz66Xw cX60XwdXw̻4>>Xw cXw p 6cXz 6PXw  J@Z@Xw  >Xw JXw .(Xw JXw  0XwdXw4@Xw `XwZXt J'8~`XwZHXw J8~PXwJ `XwZXw~ J4!8~0XwdXw@@ d$<(d wXX{V>XwJXw 30 #3 *.*G Y` Gf0XtdXta`04dAllocate RootlP{_(044dFirstPage AllocP{_(>Xw JXP hX|rT04d"CREATE STATISTICS3P{_(X|X| Y`>X|C6X@6a0'Y` a_WA_Sys_00000002_7F60ED594 6 [cks>X|~6Xd6B6Y`B_W@_Sys_00000002_7F60ED59 6 n>X|<X:<"0X|7Xd7Y` 7 \=>X|<X|<   "$d?@`A?`A-o0??% *.*G(( *.*G@X|C6X|6   Y`H 6 [ck0X|dX|4 LH `XwZXw~ J4!8~0XwdXw@@ d$<(dAP DX>z04d"CREATE STATISTICS3P{_(XX Y`>XD6X| 6a0'Y` a_WA_Sys_00000003_7F60ED594 6 \s>X~6X|6B6Y`B_W@_Sys_00000003_7F60ED59 6 K >X<X|<"0X7X|7Y` 7 ]_ߗ>X<X<   "$d?@?J??((XD6X6   Y` 6 \0HdX4LH|4 LH `XwZXw~ J4!8~0XwdXw@@ d$<(dXAP X9'04d"CREATE STATISTICS3P{_(XX Y`>XE6X 6a0'Y` a_WA_Sys_00000004_7F60ED594 6 ]Ns>X~(6X6B6Y`B_W@_Sys_00000004_7F60ED59 6 S8>X<X<"0X7X7Y` 7 ^FR >X<X<   "$$d?@@?@??XE6X6  D Y` 6 ]N0XdX4H\LHX4LH|4 LH `XwZXw~ J4!8~0XwdXw@@ d$<(dAP2X| Y`r04e user_transactionP{_(>XIXw ATETpN0-L84-KXJX{ 3s0 #3/H *.*G Y` ht0XHeXE\D 6 S8>X<X<"0X7X7Y` 7 ^FR >X<X<   "$$d?P2X10u Y`r04Ke user_transactionP{_(>XIX ATET>XJX 3s0  #3/H(D93 Y`  0XHKeXE\D 6 S8>X<X<"0X7X7Y` 7 ^FR >X<X<   "$$d?P2XMA Y`r04oe user_transactionP{_(>XIX ATET>XJX 3s0 #33G *.*G Y` Q0XHoeXE\D 6 S8>X<X<"0X7X7Y` 7 ^FR >X<X<   "$$d?PX˳CM09cvj*CreatProc transactionsP{_(X  x.P>Xt<"X"$zlvjx.P " xz>Xm)X) 6x.P @RoomID ) מ436 )Xw >X@O)X)C0-x.P88 C@RoomID ) z6 )X>Xm )X)6x.P@Name ) 蠆>XP)X)?0-x.P4?@Name ) {UPM>X m )@) 6x.P @Family ) iA>X Q)X )C0-x.P4C@Family ) |07 >X m)X )"6x.P"@Address> ) w>>X R)X )E0-x.Pcc4E@Address@ ) }&>X m)X )6x.P@Tel  ) +q>XS)X )=0-x.Pd4=@Tel ) ~h/>Xm )X)6x.P@Email ) oS>XT)X)A0-x.P@4A@Email ) /=>X<X<+0x.P +8 CREATE PROCEDURE AddReservation @RoomID INT, @Name nvarchar(100), @Family nvarchar(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Reservation(RoomID,Name,Family,Address,Tel,Email) values(@RoomID,@Name,@Family,@Address,@Tel,@Email) < z˲XH6 <X@#>X<X<0x.P 8 CREATE PROCEDURE [dbo].[AddReservation] @Name nvarchar(100), @Family nvarchar(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Reservation(Name,Family,Address,Tel,Email) values(@Name,@Family,@Address,@Tel,@Email)  < z˲XH>XO)X)?0-x.P4@?@Name ) z>Xm )X)6x.P@Name ) 蠆>XP)X)C0-x.P4C@Family ) {UPM>Xm )X) 6x.P @Family ) iA>XQ)X)@E0-x.Pcc4E@Address ) |07 >Xm)X)"6x.P"@Address ) w>>XR)X)=0-x.Pd4=@Tel ) }&>Xm)X)6x.P@Tel )H +q>XS)X)A0-x.P4A@Email ) ~h/>Xm )X)6x.P@Email ) oS0XzvjXrc4p H ( L0xX@<NNNXP"pX׹D> m)X6 )X> T)X6 )X09j*CreatProc transaction)P{_(X  x.P>Xt<"X"$lv@x.P " xz)>Xm )X)6x.P@Name ) 蠆6 )X>XO)X)?0-x.P4?@Name ) z6 )X >X m )X) 6x.P @@amily ) iA.P>X P)X )C0-x.P4C@Family ) {UPM>X m)X )"6x.P"@Address) ) w>>XQ)X )E0-x.Pcc4E@Address ) |07 >X@)X)6x.P@Tel ) +q>XR)X)=0-x.Pd4=@Tel ) }&>Xm )X)6x.P@Email ) oS.P>XS)X)A0-x.P4A@Email@ ) ~h/>X<X<0x.P 8 CREATE PROCEDURE [dbo].[AddReservation] @Name nvarchar(100), @Family nvarchar(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Reservation(Name,Family,Address,Tel,Email) values(@Name,@Family,@Address,@Tel,@Email) dd < z˲XHs(>X<X<760x.P 78 CREA@E PROCEDURE [dbo].[AddReservation] @RoomID INT, @Name nvarchar(100), @Family nvarchar(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Reservation(RoomID,Name,Family,Address,Tel,Email) values(@RoomID,@Name,@Family,@Address,@Tel,@Email) i < z˲XH,F>XO)X)C0-x.P88 C@RoomID ) z>Xm)X)@  6x.P @RoomID ) מ4>XP)X)?)0-x.P4?@Name ) {UPM>Xm )X) 6x.P@Name ) 蠆 >XQ)X)Cy0-x.P4C@Family )@ |07 >Xm )X) s6x.P @Family ) iA>XR)X)Er0-x.Pcc4E@Address ) }&>Xm)X)"6x.P"@Address ) w>>XS)X)=)@-x.Pd4=@Tel ) ~h/>Xm)X) 6x.P@Tel ) +q >XT)X)A0-x.P4A@Email ) /=H >X m )X)6x.P@Email ) oS0XHjXexxX4 h L ( x`D$p$ \Z[[[[[[[\\]]0TmFP XuOǀ06.s"CREATE STATISTICSP{_(XX [y>X<6X 6a0'[y a_WA_Sys_00000002_108B795B 6 ]U>X~6X6B6[yB_W@_Sys_00000002_108B795B 6 mz>X<X<"0<[y "  < 'U>Xv7X7[y4 7 ^{{?>X<X< <[y < 'U >X<6X6H ) [y 6 ]U0X.sX̸35P<LHC@Family ) {UPM>X m)X )"6x.P"@Address) ) w>>XQ)X )E0-x.Pcc4E@Address ) |07 >X AP*XI0<3Zt*CreatProc transactionP{_(X  x.P>Xt<"X"$jZtx.P " xz>Xm)X!) 6x.P @RoomID ) מ4>XO)X )C0-x.P@88 C@RoomID ) z>Xm )X)6x.P@Name ) 蠆'>XP)X)?0-x.P4?@Name? ) {UPM>Xm )X) 6x.P @Family ) iA>XQ@X)C0-x.P4C@Family ) |07 >X m)X)"6x.P"@Address ) w>>X R)X )E0-x.Pcc4E@Address- ) }&4>X m)X )6x.P@Te@ ) +q)>X S)X )=0-x.Pd4=@Tel ) ~h/d>X m )X )6x.P@Email  ) oS>XT)X )A0-x.P4A@Email ) /=>X<X@<70x.P 78 CREATE PROCEDURE [dbo].[AddReservation] @RoomID INT, @Name nvarchar(100), @Family nvarchar(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Reservation(RoomID,Name,Family,Address,Tel,Email) values(@RoomID,@Name,@Family,@Address,@Tel,@Email) s < z˲XHs,>X<X<;0x.P ;8 CREATE PROCEDURE [dbo].[AddReservation] @RoomID INT, @Name nvarchar(100), @Family nvarchar(200), @Address ntext, @Tel nvarchar(50), @Email nvarchar(100) AS insert Rezervation(RoomID,Name,Family,Address,Tel,Email) values(@RoomID,@Name,@Family,@Address,@Tel,@Email) N < z˲XHTe>XO)X)C0-x.P88 C@RoomID ) zR>Xm)X) 6x.P@@RoomID ) מ4@>XP)X)?0-x.P4?@Name ) {UPM?>Xm )X)6x.P@Name ) 蠆>XQ)X)C0-x.P4C@Family ) |07 F>X@ )X) 6x.P @Family ) iA@>XR)X)E0-x.Pcc4E@Address ) }&d>Xm)X)"6x.P"@Address ) w>d>XS)X)=0-x.Pd4@=@Tel4 ) ~h/=>Xm)X)6x.P@Tel ) +q>XT)X)A0-x.P4A@Email ) /=E>Xm )X)6x.P@Email ) oS@>XgKX@Kx.P[y K }`>XiKXK[yx.P K Qp >XgKXKx.P[y K g>X iKXK[yx.P K >LՖ>X!gKX KT@x.P[y K Mt>X"iKX!K[yx.P K ΞK>X#gKX"Kx.P[y K *>X$iKX#K[yx.P K z>X%gKX$Kx.P[y K@ U>X&iKX%K[yx.P K .;v>X'gKX&K x.P[y K 0u >X(iKX'K[yx.P K Awӕ0XZtXntt 0@PT4h D (  h 4dP4HXvXvXvXv xxxxxxxxxx <8z<8z@m @l)PX0 [y3069t oINSERTP{_(069tAllocate Root"P{_(6 cXw5069tFirstPage AllocP{_(>X RX @ `>X cX p PX R Z @X>X RX. (X RX   0X9tXz35@X H`X_XwR'x#`X_XRx#PXR `X_X8&R35!x#0X9tXh/0|XlLD.P@TXXm3:>XRXU0 #+/;UTESTTESTTE767676TEST@TEST.COM [y Gf0X9tX[d_6 cXw5069tFirstPage AllocP{_(>X RX P_LNXVE`X[vc>G)XS[y>#)W C    X"5-=@ X"DRXs"ZSX"]@TX"ZUX"Z@VX "WX "ZXX "@ZYX "ZZX " w@[X" Z\X"  X)@5 -= X)]X)@^X)_X)`X@)aX)bX)@cX)dX)e@) fX) gX) @hX) iX) @jX)kX )lX!)@X65-=X6@@X6@X%6@X&6@@X'6#@X(6@@ X)6@ X*6@ X+6@@ X,6 @ X-6 @@X.6 X#75-=X$7@ @X/7.@X27.@@X37.@X47.@X5@7.@X67.@X77.@X0<5-!=X1<&@9<-=@X8<@ X<<@@!X=<@"X><@@#X?<Q@$X@<QZX; 5-@=NX: YXB -=@AX AXE AXF @AXG XDK5-=@XCK@{XAK@|XKK@@}XLK@~XMK@@XNK@XOK_XI@5-=QXJAXH@AXSAXTAXU@AXVAXW@AXXXQ)5-=+@R)XZ65-=0X[6@!X\K5-=6X]KKLJ|IHG G>L=|<;: :<9l8765,5\43211L0|/.- -<,l+*)(,(\'&%$$L#|"! <l,\L| <l,\  L | <l,|XXXXNX"*XvXc Q3S[y>#)W C    X"5-=X~X%a`XvcS[y>#)W C    X"5-=XX{aX vXcS[y>#)W C    X"5-=XX$03 $StartupDBP{_(>X cXt$@XbXa#@X h^X$DBP{_(>X cXt$@XRX#0X$X$DBP{_(>X cXt$@PX!j08&UpdateQPStatsP{_(X [y>X<X<  "$&?@?@H??<[y < 'U0X&XXXJ [y08}& INSERTP{_(>XRXc<0 %/9Ectest1test1test1878787test1@test1.com [y ht0X}&X[dlD@?@P`X]04 &UpdateQPStats&P{_(X Y`>X<X<   "t1$ &>@@@H| 7Ne????????X`R3044& user_transactionP{_(>XJX  Y` Gf"0X&X>@@@XXSb [y408y' INSERTP{_(>XRXc 0 %/9Ectest3test3test3656565test3@test3.com [y  0Xy'XlD@@@P XW`Xm0c>G)XGX^<5-!=X_<@&X<-=@XP<@@ X<@!X<@"X<@@#X <S@$X <S@ZX 5-=NX YX  @-=AXY AX HAX ( X Hx8h|( X Hx8h@YP2009-11-03 17:46:37.45 spid51 Starting up database 'Rezervasiun'. 3@ 88 P*  0X,p(8 0^(@ 88 (8 `4gY@ 88  h@ PhhbitJ),&( 4 _8is_sync_with_backup0(`d%@ ( 8X,8X,P@ $$) J)&) 48 pservice_broker_guid0((cL(h(dd%@ X,0X,`D@ X,0x4.2PxX,8ЇPhX,X,@ 88 x)  X,(X,(@ 88 8`4gYp@ hhPX,@wh(@ 88 8`4gYX,Љ((@ 88 z88`4gY@ @88 (h@ 3hh1؊bitJ)@"h 4؅is_broker_enabled(c 0d%@  X,HX,K7r@ 00 J)@` 4log_reuse_waitx(L((8p d%@ X, 4x(X,ЎDBX,@ x( J)p& &( 4  log_reuse_wait_desc(L((lrd