From 8e116843fd0b5582dc7a59336c888f62e5b65d68 Mon Sep 17 00:00:00 2001 From: rtrimana Date: Thu, 22 Dec 2016 14:07:20 -0800 Subject: [PATCH] Updating database with relations; Adding new SQL query config files --- localconfig/mysql/alarmSet.config | 3 +++ localconfig/mysql/camSet.config | 3 +++ localconfig/mysql/roomCameraRelation.config | 6 ++++++ localconfig/mysql/roomSensorRelation.config | 6 ++++++ localconfig/mysql/roomSet.config | 5 +++++ localconfig/mysql/smartSensorsSet.config | 3 +++ others/Mysql/IoTMain.gz | Bin 4827 -> 4860 bytes 7 files changed, 26 insertions(+) create mode 100644 localconfig/mysql/alarmSet.config create mode 100644 localconfig/mysql/camSet.config create mode 100644 localconfig/mysql/roomCameraRelation.config create mode 100644 localconfig/mysql/roomSensorRelation.config create mode 100644 localconfig/mysql/roomSet.config create mode 100644 localconfig/mysql/smartSensorsSet.config diff --git a/localconfig/mysql/alarmSet.config b/localconfig/mysql/alarmSet.config new file mode 100644 index 0000000..a321ced --- /dev/null +++ b/localconfig/mysql/alarmSet.config @@ -0,0 +1,3 @@ +SELECT * FROM +Alarm +; diff --git a/localconfig/mysql/camSet.config b/localconfig/mysql/camSet.config new file mode 100644 index 0000000..939eb25 --- /dev/null +++ b/localconfig/mysql/camSet.config @@ -0,0 +1,3 @@ +SELECT * FROM +Camera +; diff --git a/localconfig/mysql/roomCameraRelation.config b/localconfig/mysql/roomCameraRelation.config new file mode 100644 index 0000000..3297815 --- /dev/null +++ b/localconfig/mysql/roomCameraRelation.config @@ -0,0 +1,6 @@ +SELECT RELATION FROM +FIRST +Room +OTHER +Camera +; diff --git a/localconfig/mysql/roomSensorRelation.config b/localconfig/mysql/roomSensorRelation.config new file mode 100644 index 0000000..52a7dce --- /dev/null +++ b/localconfig/mysql/roomSensorRelation.config @@ -0,0 +1,6 @@ +SELECT RELATION FROM +FIRST +Room +OTHER +SmartthingsSensor +; diff --git a/localconfig/mysql/roomSet.config b/localconfig/mysql/roomSet.config new file mode 100644 index 0000000..a085212 --- /dev/null +++ b/localconfig/mysql/roomSet.config @@ -0,0 +1,5 @@ +SELECT * FROM +Room +WHERE +TYPE='LabRoom' +; diff --git a/localconfig/mysql/smartSensorsSet.config b/localconfig/mysql/smartSensorsSet.config new file mode 100644 index 0000000..be13609 --- /dev/null +++ b/localconfig/mysql/smartSensorsSet.config @@ -0,0 +1,3 @@ +SELECT * FROM +SmartthingsSensor +; diff --git a/others/Mysql/IoTMain.gz b/others/Mysql/IoTMain.gz index 3a61a3f24a0ba51515ad4391db2c51ab624a70d5..a7449b7e91dbdbd4b6a2b2f51cf64c7642bbb7e2 100644 GIT binary patch literal 4860 zcmVa z2Ad8ufGIBNnfdhV8`+*dFMHa6BxU@qIFEebO7~(=Vf;?lu|y zp0I{*8)0Mq z??G$9=AaWH+7olOvISQX$NAy7vwb-n{B2*`D^~?yJ-avE@#tQdv~T;m(7O}#|Md)) zh|nN;JbUxIZB6I<>3p@cH@;YeUxfGX=ikhoIX~FD>E1q^cBaCCwfY4@(i!XRi5~VP z?1Aw1jUasOb-xPV&7If4TlJmL)$iIaxWe$E->-W6C!gcf5ku-g-aZ zy?H0-!w)@|uHI(jbZ;X!PbY4de_5G_`7>E9-^C>v? zDEz|XxHr*Hpo*f4ShTjdc(;mGVzt`E_+ABM4RGJ&?9@9h1dW3KI;*|x0CKq6v?F)tNDOn(9-yZUdvj^6He-6U#2 z_5g;xulJ+zWcV<+)yH3j<>v5Kl5j@j(PZQ%S0d?gj1xV0o7lhs+*xCfqK*qO8GM`v zMFu#RNEGs1vlm)(t~D0gT-2mirP>s$mBV~X5D2ctSC9+HCl|n(T)FP95ok_*T! z7m!~r04JCFLTj`%)qIg$K+$r^Q(CyHE3l|MxMSeWoM{4S8^+^k+|4%Q3ucDIpEK*{ zP5EfPH?8$@<4%KAwb5vG%!A<^H`d=WV8r(oQhlC0&sCC#8UA9~rDoxrDL8NbMU!s^ zyD~Goh2-6%wRFagvmOs*BDZn7Qkji+B;a*C8V$TNLEH?Zd<0VgM)5-qhm0O#O2H1X zJs~G%lZDt9NtMD#mBI^E$`3}BLZ(V#r%K5|l>(`fSg2A8pz3zz?Dx*v*zT5_KUVh6 zoqS5hJ+a(oxs=ITR-dk?SB&rzIY4xf8ET>=GQG&^$aIS;K4@xlpjnot)HS=IS*+bW>Swn58iE4(1qC=16u1iNJV60wL4g+u3cO5E02P#fA1VGf5Y)!m?wnkL03spYD76jIQfIQ-s(tYR&p$QIixf zYb-=%)>15XdJ7_Vw_L59zTUlCnfq_{?)H&*2@YpoD!G{cgyi}+*W=(yA};j@c82b@ zJIRLJH*Med+(1)|f*jAcV6w&>6$~!4WWnG(D1yPcM1rY08Z!~p>WjHlGescR>UGNorqq;Lz$6G5cdTa%IJhW8(rjo^rcA>w zT==5^@u5JZbUJ*ZdQL`U!JMojjdTXy;{eDN!pgg^Yq9}yHA|r#LdcNGv1GYO?_}biA_Iv zV=on7ggxYNi0mPjDfSqAiX+9cjC(d%0!uD<3A%E<2$C1u*kI$y4Fk&tZ)i-;ok{B` zeM(JjVQaFYSu;&-X$?1Ns;XMAR*n|o5shSXMF=5&wS+E)q;<)HNOtEc3U*Oo2R|#Vw;`_u+$gLgntd|K@D$aDR4|i?>k(m+^OX zv!>e{3ZfW?l4-^C=sF)@mp~Q)Nj2cYOcMsqhpG{r6MV={)Wn%KGc~)V$);w_y*q>= z{ib_HyG2VVpME$K4^$54Gli_6laS5LD;`#M*YnZxZ+QfF7analN)qKJ9^Ro;z_2|E z7)#}4+-YoZRiX(DBWC{^e)>@A^oefOyqqDaCM?gOjfkEub1P19ynI~FbjnTunqd)fg-A;Q< zxk%B~jR}+G4|V#Mh6j-XI#fg{pr+(JjM_%&ciz-2)w^!|u0_@cbgFxD-Fm%61~>lQcK zQpj~nVXs?Cj=H71THR8Lty>CX-BNg|TgtU=@uV$M-BQ@=mXf1xDX&(ylw#|a%2>Bl zUh0;5ty|n^OC{GWmA!7MIqH`BYIRF3wr;76bxY-?ZmHM0#gn#3bxUQhTWXHFrM_C- zQVXnGEH#UZdIf70=MVCrVNDaqn91>3oaRsz6!c`vMWTgC_Q!xCGYv7OAbk3vIh+rL zGjY?-&ff2dSU{^%!GPU($tS%O?$AjDAB87&uw;BoOFeQ;+DTX#J>I(_xb8S>;`b7rOiCu&@52e_X)v{; zQ=KxzeT>m-(3}7DhW@u~F|>-c#x~vVbkHZp`O_8zAStXM<}_6WR#Zs^W|5x8{(>`o za~7;S?7hIOK@)89d*I6jcDHQ2qkpw@5{N(cD{+)maGJ{GnaDi zi5ZS0v55nx5t}fl5}UA(h{a5OPbZz28RuyiX6g&QQuEu>uJoKT+LM~3p7wlrjGZ$l zmT3qKaEqiw?ZWA(_rV6tHh|eCW40-nZECm;VBP~@-UDFX17O|*q~8NO?S*fbwVQkm zAi+ctdB^+WZA!ZFO-jx(ejhG;2_s}QlG!E*04>P`R@B@Qn59xmm>6QYB(^AQaDwHX zGR01!qL-)qf;IurCW3Sl;T}sQ182GS;0#hp>}=9IkxZwRXl12%I*D%#&TV6zRpKv$ zq+o2_GsIIbd5%q=7HXrz<6$7O8aE_U8n=x2403exYaFuij5l&Vn9;RJBAC#s zR4`#Teu$gN$>5@R#SVsySIm&{mU7&sI7Eog8pN!)K;#E`-XIxVJR-Db4&sJ+5h>!i z18>ethU2;1^D(~zmtM@GK}bOKOgjw=Oem$xw}B^M=$$h{wetPWCoFLt$UOlh0*5g# zl|M{>uB*hdf}J(?DCf8kld;EnP*i|(ftTh*ts#3)k4ivm+L|m@s%pLAEe}gvIv(5T zD=3CszcJ=~DdzeOtY;_&JH5b#IHzK$Pg!GK(uxs*rbwD)zEm-V%wiG`=P=8KtLg$v z%b?wvreq@3d7A-aqn-_F&b*#CsiPUaD>me=DuJdhd+#GMBKZm#JWu-ODtE)g{X_Cd zO`JKiX5N&E=F5Ob5hzl(or}j}@?+Q>8N`!OxdfhiaS`9Yn23A=#^_Kf6h?M5{31ir zE&QyT^duyshKpm7`lX-=OD?FqpsxnS4FsM~mM;iR8Z(lb{F=~WaV_ebLZb#J_MQz{ z-;fJp{hnMFuy7RcyatENhHGHUNNZsHO0WivpUo=zcmoO6gk_nuCc1Lr*L!h8gpiyJ z2NC6@F`4D0HQ{D^HnYh_3V;@V^rCH9#)NnZkFhQn-c)z4*SnadfFJmT9MS=%NFwb( zlSSGCE-WBwis`LBDv4TauFd31RTV{*a;Xc~WT8UIp%R`X0`@+N%xX6B|2uANW#c4a|vD8^Ck3&t=cSF^@aOWZOmK1Y_MfX z*wFcer#@ckH!Tw>&+;ji^sG)@rx>ilA)l=$W3> z%x0FXNOGS13!6Jz5#Ga}B=-INWm4{U;KDEA!9hUK4Gx_MX<$OeF|ffeWs_c31h?P{ zZc&wNUW4~5giPvPJ!n)mqZf29FA@0^lPq`eVs>;ollSfZ5k!l+otOIHBZ=3vahcqv zdvg)|W{e2JG3L;TJY($1Tw@&I-I3G^QLzuwCf0z8eKa>c5y&PS^Y-VH9(>A}$aiQ` zD%D{hE_~8}j0Vc~DF9@mPgWF;PiBx_xH3g@6$t{5r)CPEF#KdYnZuJ&xg?%?aq%o7 zW0IgT3Ic`4$c{#2WC)o|t@lD$t%O8r)N~P?#+R5e4B|}@jCIN6CcAUJM9eM*?7$~g zkqR(P9w`T^PEsCcUJAxFS*TEQsDvkpKz(q2$rl^zOfd6NiAR#ruTYAD>tpOFMfSY# z6m{sbFXU#AStgP&GR#~;7xsJ!ebN_fWqY;&HgT?tYv^pk6DNlLC1B!*f$$DxGLG-j zb!Ne+7Xkr@U^2o?R7{2sSuz<;XU;M*S}j^Y`P9Ribf9iHpK)Xbodj%dTJfl|yB3XB zc!MqvUy%z(kVSpE>}d#b@JO7(_~d~VdgV&4&@DYBF)g#9+Jt+^nQfgUvcqpG>l7z$pe7 zZWi(2{FrovbA*!}Q4?p{%+&0bCYzcyuT-0&xA@gzzI}S8>I&EPYe+1=zBm*YR2J{o zO$Y-(L;6KL<6+L{PQfmWmF&lA(i`a0FC#a????UaGFsIXAmt%$$fh)l9trJ^8i7Mx^_+G_!=c{sehnMI?1}kHFs{SVL^ohy{g)>`eK>`=v)-=k igKY`UMgXEzuSuW=fFP)v($wU}oBsoghd+C4;Q#;>(w*f1 literal 4827 zcmV<15+v;(iwFR~(_2^o1MQt#liD~I$DcQ!!uv$B3%#~%bMe+xg$8#*g-Z{nr#E>a z226(uV2Vq6W8-t8{irS9y{S~ZztTr{w>PAv zJGGbJyk8~nPut$x6MN?vQpX+j?8Vx*tGwus?`b*PAI?_t{_Pg-`X6EED)PU*p4AV^ zn>YXY*FQB`krl}@N7DO2w>@rsYz~{PkvSZDo5rnf$Lx=OdHyA(Xj%{5 zk(FrTxIL|nLATo+bq0O!w|?Jj`M>&25H=@U=r?<&B^~zjI=WAVt&ciAbNpq{H@zmK z-;=h`tn_bLHe|U3ZDd7*?LG86zdo4Wft#&Q{*hv@%M!j@PHE(BFf=o`wbdVtOzYTK z@O#)=xH;^^5$%yZSvry@iNkb%*gAn6_QAHV&84S;ufE-z_Hb}7jheSzQ|jDF=KngD zN5s(}empz-hcg>bcjM`D;j9C(NWVz$-%r2UTYI{9w&R_%KkZC}gJ|^&grqezng-$?SjVcyx8vYqxzHx%oQry8O%1-Y?b)-*F_OgA7I6%TkN=lQi>EOUgKO2dz)x zu}9&T9*3Qgc>-0IrDoTYZY)6UjupK24lPu2r*E0Vk<{sr29Z%fmnFR|HM>fwTrzi? zU`Od4qj9s3xBbvZy2%CFYPxlH`@c6y<2nmRa&g~Zxw}PG#rcuUUH?9j$$0^!Q0pd0pLy>dmMFAi0R;y zJQy+{xkRE+r-m~(>QkdOH>R?oG)m>VTrTaW8;U?kExv+WKsLDm!Q=w2a(TI20GC`q zX1Rduasec{ROd#mVd(aYRf9A{*NYk<&2g7!{nOHD$B>s$9 zKWoaz^SwP=E!N&NNY`t%M$6t??qNOqO9h~QGlVWtf1 zFxwMyaynU=vHrev zw%+7ZvF@qmHqE6-*3$ZPJ-yNl@T* z1eH-tq6rC#$Rn}eH@n!~8_`boQiD$=I6J*BAQz{$CeQSVsy8YP@BfM>+w)4jI-ge* z4NPitS(`Mp89%)_k-J?imu}Z=-!1LkH)nhMNWBC{GB1=|LVu3r1~=DHa21)9`a?U* z^x7SzLmrqm?>k}FXZ134cndS-yQYF-fVU^Ppi2&>wQHN_!)~lS|Nd-M{{UaSUCqv4w)JPrY*aRrb?f$XzxCtWboZ>(o2yFSdD>N< zdyBUI*|V(I8nQB%^-66bgGzNiRVua&)JnBFbAYYXl?JdW0wx{n*#ZtP3ehxsv?x-h z$1Ys>qX6hoU{X3AK2<#@Bf4NtR*^$!u5Q#s5!{gy{z<9LeA@XSY8dx5iKAX+cBQwn|b&7+U70D*rkC08XcRxa= zAEL3Bh%d$-b~se_Fv|pc96tGxGMicVe6WO;LhurH<$4h$E4IjBlgT{>mJi;eF+F$2 zt)uj*)Q!1gsG2dG7<$8~c}Y{(^=i3vm{A_lh&Pvq5YVe7Y%#>G3l>DYJ6BQgi-I`t zabY9^%o0b!fhmxL$N3^jG?}YVGN?o(i9mgbKhH?UIu*=pRFaY8^gElP5BJswd+$8k zf6@R#tcqj@>Bfbh*T;tiV+{=h6*JV3p7c=5DA|4Z;Ga-=yY9caYv;H>JfzT zq0GMNp3-jK63V6@!NdcVBlt`qE$B34GxJJ@mEZMzw1Qh6;oXHt$BUA}xQR!0C=@Va zk3z;0d6{(E4Nay<8WkvkrVkQMBRLXuAjv+A1WI;-33NJj59|Huj#_XVEj??J8_OSU zkQHqp9NOUG(FUAogBPF;UV=8j(SCk@K2mLO7Q2jOgPh3TI?lRlKd-wCpi#R*IYvA3 zb5#FCh;baT1EN!inex_p%;{`kIv?GY6FdU?i3$v6S0pf4M~Xbr`f3dxhAs24(`~n! zL&imlwrP#HEPtxgwe=V9D7O25;(G1L7kw@%ftXGWu1Dl0P3!jGSp zOLKd$^dVvhp3*gm@@X>>ca{A~&W_f{ps~6y`UO<%U1+LXg zBze)Q7vQg6AVc*6c=gI%UU^n8m9u)OqEs*STD^pkmrAc*Du4A-GgL2?dG6)Q%YR@7 zip!G#hqlywOP9)7x>Qk0mwGK-B58|Ox>WwsrDiByD)Yqa3~l9Ew=~YWrHN9vv}@fG zMq3)aZfX2=OUqEVv{$QJTE2BlXw#o-O@Sh zmM%)&(yw((7;WkFx~22iEj>fs(qFA^>G{?zowIJ~qSP(@TDL^f7OigS{B=vuP`C6~ zt6O@Gb&IEF2~n?LtrGk}9z3i`;y5!oIg7I#@`8e$Y=ua)FvRiD+Sxk09Tf{`RVWy+8!!2!mnIxKvEbwIAO}mw2Qg&SFT^scUXOSF=eZsod;iVZ z-nm<6YVY=*S+GjR;~hxfdHWcA5-jn^HEkzlVRW>2d2rowSJdw%I++wqbkK(r&f{=u z$EG@ANctF~-=IJL>-2+f+2UxGXiaRo*=pfWjEko&2tZs|Va!>o3ayxu3e6%t4TA+| zy7nYoci4YHSc4|q6!ajF3&E><8~j|%|L88BzU^-h%SpHi^#Z6@@ZuIEy#ULLuo_Od z33_!yK_d?n^Boz{&$5D_8&A28<*aw^Hr&E;yFY&A6#9AR*s-a8hmh68eYa1((P=6b zv)6EYEwBgBo+Ap@y>CQV7ZJKLG0Q3AZ4P^<@6H@{;)^Vc&wo)@!Zi4CV2u*z)Wjs@ zoi6)XXh1uq?wP&8@Ux)HsFMbbkgQ;UIC2&==1E=98ZHm288h2Z>qfP1)PPa9OXY?v z2M=%h5{P!oGeg!5T}O8F_AF=G?_2!5d$!^b?{((yWMf^ALxbq7Xlz z88qUXXHki7AL(TFTmd(ZGu_=Bri&YAb|{rq?;Xo3;M9TNS{_PhJ3kgvhwnTNw=Gx+ zcxNuZRMD4<9p8tUX!ZtwIrV_Skgl+n98z8&~AiM`4yayn>2S~mLaXJa# zE^Rmc+&acY9(l+ALTg642}}ykGC?0Md}$zTG~(GN3;-+1gjUSl5}GAa$}uq@xdd5k zH9Vp9Pq2^^(CFnUzu-*(yooTKM7Se~q~|VnKAd4HLC(_r6SQPniB>E^(+RpUJZD5Y ztD!H$q+o3v`}?UEfrPOw_aM>N@Ol_rbUWA>eueV!`;&dgQEIVNkQ zQ1$`xKIU-ekp{jjo+b|G^aHmoI5FUzxs>S#VL0LmA$H)b%n&nYrihq*lq-^j|I2Mq zy!qezY+j)PX`~`nMKX$XCic(^w_Jp( zF0i!pnyqm{CQ4Pb889*G>7ZuJ>sgaJp3&QKO>OH6sGF+)J~AhguaLpBq;H{eH%#0= zC6CO+nK5f-O__MU40)7+rnH-xc+4k19-E_scrq%Mz*8?S;(HBak&nR`9V&yu$c}|y zWJtS(pLUa;hGf)mek?M-Y%^vl1eF)`m7Ao2AoI!d#hY>FIS3!N2)TQ6xoZyQ`8}P(!HciiH}(-k}xvdTtXNAd`b?*JtYtsg> zYkXM}HgrDWhvj~;IczuX&OuVJN~Ju_r%=+c$XJs^7U& zkJN@=L0FkpC7z_9o?m6?i*ViHy)iUSg3Kb?d?>FN{%Szzd_4 zkznYUH4{V6thX34*>xw94FKm18!KiFR+D@o@ye7{`CWZu<-MnyAvLHF`vkxwwma|aKxW78SGZ}+z#n%C{T z#0MW~ye5r{SG@+eA0l82F~^=0Cb{HRt%0$W{_UEGDUn92?~#= zW^$nL_{nxUhbNP-=Xb;0DuyK}un%r6Gwz{gdQ2rx??2?wT55*}w>3MMs~t57niL?nqoeF%QZml*3* zFtbrfMv~JnSBk>xWBe#Z_M-3ACOo|U(GAT}H&N5P3&09d()FYU5 zpl$@8aij&E25e?p$*A(X=8e|z23;1uA{T)mi~4lg(-7+5(KvO=?8=mr;0H!*vYBaxYIcIGBKMRcD_ zc8+=bxb`py(kDv+SUz>-!tbh(hKK}o6b>GeBV#UvBkPFW)K&7C2uE$@#cpgFey?X7 z7!#ZXAezvt>s66#GD)L>q!?1TdBj8V