�����JFIF��XX����������    $.' ",#(7),01444'9=82<.342  2!!22222222222222222222222222222222222222222222222222�����"����4���������������������������� ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������,�PG"Z_�4�˷����kjز�Z�,F+��_z�,�© �����zh6�٨�ic�fu������������������������������������#ډb���_�N��?�����������wQ���5-�~�I���8���������������������������������TK<5o�Iv-������������������k�_U_������������������������������~b�M��d��������Ӝ�U�Hh��?]��E�w��Q���k�{��_}qFW7HTՑ��Y��F�����?_�'ϔ��_�Ջt������������������������=||I �����6�έ"�����D���/[�k�9����Y�8������ds|\���Ҿp6�Ҵ���]��.����6���z<�v��@]�i%������������������������$j��~����g��J>��no����pM[me�i$[�����������s�o�ᘨ�˸ nɜG-�ĨU�ycP���3.DB�li�;���������������������hj���x����7Z^�N�h��������N3u{�:j�����x�힞��#M��&��jL P@��_���� P�������������������&��o8��������9������@Sz���6�t7#O�ߋ �����s}Yf�T������lmr����Z)'N��k�۞p�����w\�T���������������ȯ?�8`���O��i{wﭹW�[�r�� ��Q4F�׊������3m&L�=��h3�������z~��#����\�l :�F,j@�� ʱ�wQT����8�"kJO����6�֚l������������������}����R�>ډK���]��y����&����p�}b������;N�1�m�r$����|��7�>e�@���B�TM*-i�H��g�D�)� E�m�|�ؘbҗ�a���Ҿ����������������t4�����o���G��*oCN�rP���Q��@z,|?W[0���������:�n,j���WiE��W������$~/�hp\��?��{(�0���+�Y8rΟ�+����>S-S���������������VN;���}�s?.����� w��9��˟<���Mq4�Wv'������{)0�1mB����V����W[��������8�/<� �%���wT^�5���b��)iM� p�g�N�&ݝ������������VO~��q���u���9��� ����!��J27�����$����O-���! �:���%H��� ـ�������y�ΠM=t{!S�� �oK8�������t<����è��������:a��������[������ա�H���~��w��Qz`�p����o�^ ������Q��n����� �,uu�C��$ ^���,�������8�#��:�6��e�|~�����������!�3��3.�\0�����q��o�4`.|� ����y�Q�`~;�d�ׯ,��O�Zw�������`73�v�܋�<�����Ȏ�� ـ4k��5�K�a�u�=9Yd��$>x�A�&�� j0� ���vF��� Y���|�y��� ~�6�@c��1vOp��������Ig�����4��l�OD�����L����� R���c���j�_�uX�6��3?nk��Wy�f;^*B� ��@���~a�`��Eu�������+�����6�L��.ü>��}y���}_�O�6�͐�:�Yr���G�X��kG������l^w����������~㒶sy���Iu�!���� W ��X��N�7BV��O��!X�2����wvG�R�f�T#�����t�/?���%8�^�W�aT����G�cL�M���I��(J����1~�8�?aT ���]����AS�E��(��*E}� 2������#I/�׍qz��^t�̔���������b�Yz4x����t�){ OH�����+(E��A&�N�������XT��o��"�XC����'���)}�J�z�p� ����~5�}�^����+�6����w��c��Q�|�Lp�d�H��}�(�.|����k��c4^�����"�����Z?ȕ ��a<�������L�!0�39C� �Eu�����C�F�Ew�ç ;�n?�*o���B�8�bʝ���'#Rqf����M}7����]�������s2tcS{�\icTx;�\��7K���P������ʇ Z O-��~�������c>"��?��������P�����E��O�8��@�8��G��Q�g�a�Վ���󁶠��䧘��_%#r�>�����1�z�a���eb��qcP��ѵ��n���#L��� =��׀t� L�7�`�����V����A{�C:�g���e@�����w1 Xp�3�c3�ġ�������p��M"'-�@n4���fG���B3�DJ�8[Jo�ߐ���gK)ƛ��$���� �������8�3�����+���� �����6�ʻ���� ���S�kI�*KZlT _`�������?��K�����QK�d���������B`�s}�>���`������*�>��,*@J�d�oF*�����弝��O}�k��s��]��y�ߘ�������c1G�V���<=�7��7����6��q�PT��tXԀ�!9*4�4Tހ���3XΛex�46�������Y��D ����� ����BdemDa����\�_l,����G�/���֌7���Y�](�xTt^%�GE�����4�}bT����ڹ�����;��Y)���B�Q��u��>J/J ���⮶.�XԄ��j�ݳ������+E��d ���r�5�_D�����1 ���o�� �B�x�΢�#����<��W�����8���R6�@���g�M�.��� dr�D��>(otU��@�x=��~v���2� ӣ�d�oBd�����3�eO�6�㣷����������ݜ�6��6Y��Qz`����S��{���\P��~z m5{J/L��1������<�e�ͅPu���b�]�ϔ��������'�������f�b� Zpw��c`"��i���BD@:)ִ�:�]��h���v�E��w���T�l�������P����"Ju�}��وV ��J��G6��. J/�Qgl߭�e�����@�z�Zev2u����)]կ���������7x�������s�M�-<ɯ�c��r��v�����@��$�ޮ}lk���a����'����>x��O\�Z������Fu>������ck#��&:��`�$��ai�>2Δ����l���oF[h�������lE�ܺ�Π���k:)���`������� $[6�����9�����kOw�\|�����8}������ބ:��񶐕��������I�A1/���=�2[�,�!��.}gN#�u����b���� ~���������݊��}34q�����d�E��L��������c��$���"�[q�U�硬g^��%B ��z���r�p�������J�ru%v\h�����1Y�ne`������ǥ:g����pQM~�^��Xi� ��`S�:V2������9.�P���V������?B�k�� ��������AEvw%�_�9C�Q����wKekP�ؠ�\������;Io d�{ ߞo�c1eP�����\� `����E=���@K<�Y��������eڼ�J����w����{av�F�'�M�@��������������/J��+9p����|]���������Iw &`���8���&�M�hg���[�{�������Xj���%��Ӓ�������������������$��(�����ʹN�������<>�I���RY�����K2�NPlL�ɀ�)��&e��������B+ь����(������������������� � �JTx����_?EZ� }@���� 6�U���뙢ط�z��dWI��n` D����噥�[��uV��"�G&�����Ú����2�g�}&m���������������������?ċ���"����Om#�������������������������� ��{���������������������ON��"S�X���Ne��ysQ���@�������������Fn��Vg�����dX�~nj����������������������]J�<�K]:����FW���b�������62����������=��5f����JKw����bf�X������������������������55��~J �%^�������:�-�QIE��P��v�nZum� z � ~ə ���� ���ة����;�f��\v�������g�8�1��f2�������������������������4;�V���ǔ�)�������������������9���1\������������������������������c��v�/'Ƞ�w������������������$�4�R-��t����������������������������������� e�6�/�ġ �̕Ecy�J���u�B���<�W�ַ~�w[B1L۲�-JS΂�{���΃�������������������������������������������A��20�c#���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������@���� 0!1@AP"#2Q`$3V�%45a6�FRUq����� ������^7ׅ,$n��������+��F�`��2X'��0vM��p�L=�������5��8������u�p~���.�`r�����\����O��,ư�0oS ��_�M�����l���4�kv\JSd���x���SW�<��Ae�IX����������$I���w�:S���y���›R��9�Q[���,�5�;�@]�%���u�@ *ro�lbI �� ��+���%m:�͇ZV�����u�̉����θau<�fc�.����{�4Ա� �Q����*�Sm��8\ujqs]{kN���)qO�y�_*dJ�b�7���yQqI&9�ԌK!�M}�R�;�������S�T���1���i[U�ɵz�]��U)V�S6���3$K{��ߊ<�(� E]Զ[ǼENg�����'�\?#)Dkf��J���o��v���'�%ƞ�&K�u��!��b�35LX�Ϸ��63$K�a�;�9>,R��W��3�3� d�JeTYE.Mϧ��-�o�j3+y��y^�c�������VO�9NV\nd�1 ��!͕_)a�v;����թ�M�lWR1��)El��P;��yوÏ�u 3�k�5Pr6<�⒲l�!˞*��u־�n�!�l:����UNW ��%��Chx8vL'��X�@��*��)���̮��ˍ��� ����D-M�+J�U�kvK����+�x8��cY������?�Ԡ��~3mo��|�u@[XeY�C�\Kp�x8�oC�C�&����N�~3-H���� ��MX�s�u<`���~"WL��$8ξ��3���a�)|:@�m�\���^�`�@ҷ)�5p+��6���p�%i)P M���ngc�����#0Aruz���RL+xSS?���ʮ}()#�t��mˇ!��0}}y����<�e� �-ή�Ԩ��X������ MF���ԙ~l L.3���}�V뽺�v������멬��Nl�)�2����^�Iq��a��M��qG��T�����c3#������3U�Ǎ���}��לS�|qa��ڃ�+���-��2�f����/��bz��ڐ�� �ݼ[2�ç����k�X�2�* �Z�d���J�G����M*9W���s{��w���T��x��y,�in�O�v��]���n����P�$��JB@=4�OTI�n��e�22a\����q�d���%�$��(���:���: /*�K[PR�fr\nڙdN���F�n�$�4��[�� U�zƶ����� �mʋ���,�ao�u 3�z� �x��Kn����\[��VFmbE;�_U��&V�Gg�]L�۪&#n%�$ɯ��dG���D�TI=�%+AB�Ru#��b4�1�»x�cs�YzڙJG��f��Il���d�eF'T� iA��T���uC�$����Y��H?����[!G`}���ͪ� �纤Hv\������j�Ex�K���!���OiƸ�Yj�+u-<���'q����uN�*�r\��+�]���<�wOZ.fp�ێ��,-*)V?j-kÊ#�`�r��dV����(�ݽBk�����G�ƛk�QmUڗe��Z���f}|����8�8��a���i��3'J�����~G_�^���d�8w������ R�`(�~�.��u���l�s+g�bv���W���lGc}��u���afE~1�Ue������Z�0�8�=e�� f@/�jqEKQQ�J���oN��J���W5~M>$6�Lt�;$ʳ{���^��6�{����v6���ķܰg�V�cnn �~z�x�«�,2�u�?cE+Ș�H؎�%�Za�)���X>uW�Tz�Nyo����s���FQƤ��$��*�&�LLXL)�1�" L��eO��ɟ�9=���:t��Z���c��Ž���Y?�ӭV�wv�~,Y��r�ۗ�|�y��GaF�����C�����.�+� ���v1���fήJ�����]�S��T��B��n5sW}y�$��~z�'�c ��8 ��� ,! �p��VN�S��N�N�q��y8z˱�A��4��*��'������2n<�s���^ǧ˭P�Jޮɏ�U�G�L�J�*#��<�V��t7�8����TĜ>��i}K%,���)[��z�21z ?�N�i�n1?T�I�R#��m-�����������������1����lA�`��fT5+��ܐ�c�q՝��ʐ��,���3�f2U�եmab��#ŠdQ�y>\��)�SLY����w#��.���ʑ�f��� ,"+�w�~�N�'�c�O�3F�������N<���)j��&��,-� �љ���֊�_�zS���TǦ����w�>��?�������n��U仆�V���e�����0���$�C�d���rP �m�׈e�Xm�Vu� �L��.�bֹ��� �[Դaզ���*��\y�8�Է:�Ez\�0�Kq�C b��̘��cө���Q��=0Y��s�N��S.����3.���O�o:���#���v7�[#߫ ��5�܎�L���Er4���9n��COWlG�^��0k�%<���ZB���aB_���������'=��{i�v�l�$�uC���mƎҝ{�c㱼�y]���W�i ��ߧc��m�H� m�"�"�����;Y�ߝ�Z�Ǔ�����:S#��|}�y�,/k�Ld� TA�(�AI$+I3��;Y*���Z��}|��ӧO��d�v��..#:n��f>�>���ȶI�TX��� 8��y����"d�R�|�)0���=���n4��6ⲑ�+��r<�O�܂~zh�z����7ܓ�HH�Ga롏���nCo�>������a ���~]���R���̲c?�6(�q�;5%� |�uj�~z8R�=X��I�V=�|{v�Gj\gc��q����z�؋%M�ߍ����1y��#��@f^���^�>N������#x#۹��6�Y~�?�dfPO��{��P�4��V��u1E1J �*|���%����JN��`eWu�zk M6���q t[�� ��g�G���v��WIG��u_ft����5�j�"�Y�:T��ɐ���*�;� e5���4����q$C��2d�}���� _S�L#m�Yp��O�.�C�;��c����Hi#֩%+) �Ӎ��ƲV���SYź��g |���tj��3�8���r|���V��1#;.SQ�A[���S������#���`n�+���$��$�I �P\[�@�s��(�ED�z���P��])8�G#��0B��[ى��X�II�q<��9�~[Z멜�Z�⊔IWU&A>�P~�#��dp<�?����7���c��'~���5 ��+$���lx@�M�dm��n<=e�dyX��?{�|Aef ,|n3�<~z�ƃ�uۧ�����P��Y,�ӥQ�*g�#먙R�\���;T��i,��[9Qi歉����c>]9�� ��"�c��P�� �Md?٥��If�ت�u��k��/����F��9�c*9��Ǎ:�ØF���z�n*�@|I�ށ9����N3{'��[�'ͬ�Ҳ4��#}��!�V� Fu��,�,mTIk���v C�7v���B�6k�T9��1�*l� '~��ƞF��lU��'�M ����][ΩũJ_�{�i�I�n��$����L�� j��O�dx�����kza۪��#�E��Cl����x˘�o�����V���ɞ�ljr��)�/,�߬h�L��#��^��L�ф�,íMƁe�̩�NB�L�����iL����q�}��(��q��6IçJ$�W�E$��:������=#����(�K�B����zђ <��K(�N�۫K�w��^O{!����)��H���>x�������lx�?>Պ�+�>�W���,Ly!_�D���Ō�l���Q�!�[ �S����J��1��Ɛ�Y}��b,+�Lo�x�ɓ)����=�y�oh�@�꥟/��I��ѭ=��P�y9��� �ۍYӘ�e+�p�Jnϱ?V\SO%�(�t� ���=?MR�[Ș�����d�/ ��n�l��B�7j� ��!�;ӥ�/�[-���A�>��dN�sLj ��,ɪv��=1c�.SQ�O3�U���ƀ�ܽ�E����������̻��9G�ϷD�7(�}��Ävӌ\��y�_0[w ���<΍>����a_��[0+�L��F.�޺��f�>oN�T����q;���y\��bՃ��y�jH�<|q-eɏ�_?_9+P���Hp$�����[ux�K w�Mw��N�ی'$Y2�=��q���KB��P��~�������Yul:�[<����F1�2�O���5=d����]Y�sw:���Ϯ���E��j,_Q��X��z`H1,#II ��d�wr��P˂@�ZJV����y$�\y�{}��^~���[:N����ߌ�U�������O��d�����ؾe��${p>G��3c���Ė�lʌ�� ת��[��`ϱ�-W����dg�I��ig2��� ��}s ��ؤ(%#sS@���~���3�X�nRG�~\jc3�v��ӍL��M[JB�T��s3}��j�Nʖ��W����;7���ç?=X�F=-�=����q�ߚ���#���='�c��7���ڑW�I(O+=:uxq�������������e2�zi+�kuG�R��������0�&e�n���iT^J����~\jy���p'dtG��s����O��3����9* �b#Ɋ�� p������[Bws�T�>d4�ۧs���nv�n���U���_�~,�v����ƜJ1��s�� �QIz���)�(lv8M���U=�;����56��G���s#�K���MP�=��LvyGd��}�VwWBF�'�à �?MH�U�g2�� ����!�p�7Q��j��ڴ����=��j�u��� Jn�A s���uM������e��Ɔ�Ҕ�!)�'��8Ϣ�ٔ���ޝ(��Vp���צ֖d=�IC�J�Ǡ{q������kԭ�߸���i��@K����u�|�p=..�*+����x�����z[Aqġ#s2a�Ɗ���RR�)*HRsi�~�a &f��M��P����-K�L@��Z��Xy�'x�{}��Zm+���:�)�) IJ�-i�u���� ���ܒH��'��L(7�y�GӜq���� j��� 6ߌg1�g�o���,kر���tY�?W,���p���e���f�OQS��!K�۟cҒA�|ս�j�>��=⬒��˧L[�� �߿2JaB~R��u�:��Q�] �0H~���]�7��Ƽ�I���(�}��cq '�ήET���q�?f�ab���ӥvr� �)o��-Q��_'����ᴎo��K������;��V���o��%���~OK ����*��b�f:���-ťIR��`B�5!RB@���ï�� �u �̯e\�_U�_������� g�ES��3��������QT��a�����x����U<~�c?�*�#]�MW,[8O�a�x��]�1bC|踤�P��lw5V%�)�{t�<��d��5���0i�XSU��m:��Z�┵�i�"��1�^B�-��P�hJ��&)O��*�D��c�W��vM��)����}���P��ܗ-q����\mmζZ-l@�}��a��E�6��F�@��&Sg@���ݚ�M����� ȹ 4����#p�\H����dYDo�H���"��\��..R�B�H�z_�/5˘����6��KhJR��P�mƶi�m���3��,#c�co��q�a)*P�t����R�m�k�7x�D�E�\Y�閣_X�<���~�)���c[[�BP����6�Yq���S��0����%_����;��Àv�~�| VS؇ ��'O0��F0��\���U�-�d@�����7�SJ*z��3n��y��P����O����������m�~�P�3|Y��ʉr#�C�<�G~�.,! ���bqx���h~0=��!ǫ�jy����l��O,�[B��~��|9��ٱ����Xly�#�i�B��g%�S��������tˋ���e���ې��\[d�t)��.+u�|1 ������#�~Oj����hS�%��i.�~X���I�H�m��0n���c�1uE�q��cF�RF�o���7� �O�ꮧ� ���ۛ{��ʛi5�rw?׌#Qn�TW��~?y$��m\�\o����%W� ?=>S�N@�� �Ʈ���R����N�)�r"C�:��:����� �����#��qb��Y�. �6[��2K����2u�Ǧ�HYR��Q�MV��� �G�$��Q+.>�����nNH��q�^��� ����q��mM��V��D�+�-�#*�U�̒ ���p욳��u:�������IB���m����PV@O���r[b= �� ��1U�E��_Nm�yKbN�O���U�}�the�`�|6֮P>�\2�P�V���I�D�i�P�O;�9�r�mAHG�W�S]��J*�_�G��+kP�2����Ka�Z���H�'K�x�W�MZ%�O�YD�Rc+o��?�q��Ghm��d�S�oh�\�D�|:W������UA�Qc yT�q��������~^�H��/��#p�CZ���T�I�1�ӏT����4��"�ČZ�����}��`w�#�*,ʹ�� ��0�i��課�Om�*�da��^gJ݅{���l�e9uF#T�ֲ��̲�ٞC"�q���ߍ ոޑ�o#�XZTp����@ o�8��(jd��xw�]�,f���`~��|,s��^����f�1���t��|��m�򸄭/ctr��5s��7�9Q�4�H1꠲BB@�l9@���C�����+�wp�xu�£Yc�9��?`@#�o�mH�s2��)�=��2�.�l����jg�9$�Y�S�%*L������R�Y������7Z���,*=�䷘$�������arm�o�ϰ���UW.|�r�uf����IGw�t����Zwo��~5 ��YյhO+=8fF�)�W�7�L9lM�̘·Y���֘YLf�큹�pRF���99.A �"wz��=E\Z���'a� 2��Ǚ�#;�'}�G���*��l��^"q��+2FQ� hj��kŦ��${���ޮ-�T�٭cf�|�3#~�RJ����t��$b�(R��(����r���dx� >U b�&9,>���%E\� Ά�e�$��'�q't��*�א���ެ�b��-|d���SB�O�O��$�R+�H�)�܎�K��1m`;�J�2�Y~9��O�g8=vqD`K[�F)k�[���1m޼c��n���]s�k�z$@��)!I �x՝"v��9=�ZA=`Ɠi �:�E��)`�7��vI��}d�YI�_ �o�:ob���o ���3Q��&D&�2=�� �Ά��;>�h����y.*ⅥS������Ӭ�+q&����j|UƧ�����}���J0��WW< ۋS�)jQR�j���Ư��rN)�Gű�4Ѷ(�S)Ǣ�8��i��W52���No˓� ۍ%�5brOn�L�;�n��\G����=�^U�dI���8$�&���h��'���+�(������cȁ߫k�l��S^���cƗjԌE�ꭔ��gF���Ȓ��@���}O���*;e�v�WV���YJ\�]X'5��ղ�k�F��b 6R�o՜m��i N�i�����>J����?��lPm�U��}>_Z&�KK��q�r��I�D�Չ~�q�3fL�:S�e>���E���-G���{L�6p�e,8��������QI��h��a�Xa��U�A'���ʂ���s�+טIjP�-��y�8ۈZ?J$��W�P� ��R�s�]��|�l(�ԓ��sƊi��o(��S0���Y� 8�T97.�����WiL��c�~�dxc�E|�2!�X�K�Ƙਫ਼�$((�6�~|d9u+�qd�^3�89��Y�6L�.I�����?���iI�q���9�)O/뚅����O���X��X�V��ZF[�یgQ�L��K1���RҖr@v�#��X�l��F���Нy�S�8�7�kF!A��sM���^rkp�jP�DyS$N���q���nxҍ!U�f�!eh�i�2�m����`�Y�I�9r�6� �TF���C}/�y�^���Η���5d�'��9A-��J��>{�_l+�`��A���[�'��յ�ϛ#w:݅�%��X�}�&�PSt�Q�"�-��\縵�/����$Ɨh�Xb�*�y��BS����;W�ջ_mc�����vt?2}1�;qS�d�d~u:2k5�2�R�~�z+|HE!)�Ǟl��7`��0�<�,�2*���Hl-��x�^����'_TV�gZA�'j� ^�2Ϊ��N7t�����?w�� �x1��f��Iz�C-Ȗ��K�^q�;���-W�DvT�7��8�Z�������� hK�(P:��Q- �8�n�Z���܃e貾�<�1�YT<�,�����"�6{�/ �?�͟��|1�:�#g��W�>$����d��J��d�B���=��jf[��%rE^��il:��B���x���Sּ�1հ��,�=��*�7 fcG��#q� �eh?��2�7�����,�!7x��6�n�LC�4x��},Geǝ�tC.��vS �F�43��zz\��;QYC,6����~;RYS/6���|2���5���v��T��i����������mlv��������&� �nRh^ejR�LG�f���? �ۉҬܦƩ��|��Ȱ����>3����!v��i�ʯ�>�v��オ�X3e���_1z�Kȗ\<������!�8���V��]��?b�k41�Re��T�q��mz��TiOʦ�Z��Xq���L������q"+���2ۨ��8}�&N7XU7Ap�d�X��~�׿��&4e�o�F��� �H�����O���č�c�� 懴�6���͉��+)��v;j��ݷ�� �UV�� i��� j���Y9GdÒJ1��詞�����V?h��l�����l�cGs�ځ�������y�Ac������\V3�? �� ܙg�>qH�S,�E�W�[�㺨�uch�⍸�O�}���a��>�q�6�n6�����N6�q��������N� ���! 1AQaq�0@����"2BRb�#Pr���3C`��Scst���$4D���%Td���� ?�����N����a��3��m���C���w��������xA�m�q�m����m������$����4n淿t'��C"w��zU=D�\R+w�p+Y�T�&�պ@��ƃ��3ޯ?�Aﶂ��aŘ���@-�����Q�=���9D��ռ�ѻ@��M�V��P��܅�G5�f�Y<�u=,EC)�<�Fy'�"�&�չ�X~f��l�KԆV��?�� �W�N����=(� �;���{�r����ٌ�Y���h{�١������jW����P���Tc�����X�K�r��}���w�R��%��?���E��m�� �Y�q|����\lEE4����r���}�lsI�Y������f�$�=�d�yO����p�����yBj8jU�o�/�S��?�U��*������ˍ�0�������u�q�m [�?f����a�� )Q�>����6#������� ?����0UQ����,IX���(6ڵ[�DI�MNލ�c&���υ�j\��X�R|,4��� j������T�hA�e��^���d���b<����n�� �즇�=!���3�^�`j�h�ȓr��jẕ�c�,ٞX����-����a�ﶔ���#�$��]w�O��Ӫ�1y%��L�Y<�wg#�ǝ�̗`�x�xa�t�w��»1���o7o5��>�m뭛C���Uƃߜ}�C���y1Xνm�F8�jI���]����H���ۺиE@I�i;r�8ӭ�����V�F�Շ| ��&?�3|x�B�MuS�Ge�=Ӕ�#BE5G������Y!z��_e��q�р/W>|-�Ci߇�t�1ޯќd�R3�u��g�=0 5��[?�#͏��q�cf���H��{ ?u�=?�?ǯ���}Z��z���hmΔ�BFTW�����<�q��(v� ��!��z���iW]*�J�V�z��gX֧A�q�&��/w���u�gYӘa���; �i=����g:��?2�dž6�ى�k�4�>�Pxs����}������G�9���3 ���)gG�R<>r h�$��'nc�h�P��Bj��J�ҧH� -��N1���N��?��~��}-q!=��_2hc�M��l�vY%UE�@|�v����M2�.Y[|y�"Eï��K�ZF,�ɯ?,q�?v�M 80jx�"�;�9vk�����+ ֧�� �ȺU��?�%�vcV��mA�6��Qg^M�����A}�3�nl� QRN�l8�kkn�'�����(��M�7m9و�q���%ޟ���*h$Zk"��$�9��: �?U8�Sl��,,|ɒ��xH(ѷ����Gn�/Q�4�P��G�%��Ա8�N��!� �&�7�;���eKM7�4��9R/%����l�c>�x;������>��C�:�����t��h?aKX�bhe�ᜋ^�$�Iհ �hr7%F$�E��Fd���t��5���+�(M6�t����Ü�UU|zW�=a�Ts�Tg������dqP�Q����b'�m���1{|Y����X�N��b �P~��F^F:����k6�"�j!�� �I�r�`��1&�-$�Bevk:y���#y�w��I0��x��=D�4��tU���P�ZH��ڠ底taP��6����b>�xa�����Q�#� WeF��ŮNj�p�J* mQ�N�����*I�-*�ȩ�F�g�3 �5��V�ʊ�ɮ�a��5F���O@{���NX��?����H�]3��1�Ri_u��������ѕ�� ����0��� F��~��:60�p�͈�S��qX#a�5>���`�o&+�<2�D����: �������ڝ�$�nP���*)�N�|y�Ej�F�5ټ�e���ihy�Z �>���k�bH�a�v��h�-#���!�Po=@k̆IEN��@��}Ll?j�O������߭�ʞ���Q|A07x���wt!xf���I2?Z��<ץ�T���cU�j��]���陎Ltl �}5�ϓ��$�,��O�mˊ�;�@O��jE��j(�ا,��LX���LO���Ц�90�O �.����a��nA���7������j4 ��W��_ٓ���zW�jcB������y՗+EM�)d���N�g6�y1_x��p�$Lv�:��9�"z��p���ʙ$��^��JԼ*�ϭ����o���=x�Lj�6�J��u82�A�H�3$�ٕ@�=Vv�]�'�qEz�;I˼��)��=��ɯ���x �/�W(V���p�����$ �m�������u�����񶤑Oqˎ�T����r��㠚x�sr�GC��byp�G��1ߠ�w e�8�$⿄����/�M{*}��W�]˷.�CK\�ުx���/$�WP�w���r� |i���&�}�{�X� �>��$-��l���?-z���g����lΆ���(F���h�vS*���b���߲ڡn,|)mrH[���a�3�ר�[1��3o_�U�3�TC�$��(�=�)0�kgP���� ��u�^=��4 �WYCҸ:��vQ�ר�X�à��tk�m,�t*��^�,�}D*�� �"(�I��9R����>`�`��[~Q]�#af��i6l��8���6�:,s�s�N6�j"�A4���IuQ��6E,�GnH��zS�HO�uk�5$�I�4��ؤ�Q9�@��C����wp��BGv[]�u�Ov����0I4���\��y�����Q�Ѹ��~>Z��8�T��a��q�ޣ;z��a���/��S��I:�ܫ_�|������>=Z����8:�S��U�I�J��"IY���8%b8���H��:�QO�6�;7�I�S��J��ҌAά3��>c���E+&jf$eC+�z�;��V����� �r���ʺ������my�e���aQ�f&��6�ND���.:��NT�vm�<- u���ǝ\MvZY�N�NT��-A�>jr!S��n�O 1�3�Ns�%�3D@���`������ܟ 1�^c<���� �a�ɽ�̲�Xë#�w�|y�cW�=�9I*H8�p�^(4���՗�k��arOcW�tO�\�ƍR��8����'�K���I�Q�����?5�>[�}��yU�ײ -h��=��% q�ThG�2�)���"ו3]�!kB��*p�FDl�A���,�eEi�H�f�Ps�����5�H:�Փ~�H�0Dت�D�I����h�F3�������c��2���E��9�H��5�zԑ�ʚ�i�X�=:m�xg�hd(�v����׊�9iS��O��d@0ڽ���:�p�5�h-��t�&���X�q�ӕ,��ie�|���7A�2���O%P��E��htj��Y1��w�Ѓ!����  ���� ࢽ��My�7�\�a�@�ţ�J ��4�Ȼ�F�@o�̒?4�wx��)��]�P��~�����u�����5�����7X ��9��^ܩ�U;Iꭆ 5 �������eK2�7(�{|��Y׎ �V��\"���Z�1� Z�����}��(�Ǝ"�1S���_�vE30>���p;� ΝD��%x�W�?W?v����o�^V�i�d��r[��/&>�~`�9Wh��y�;���R���� ;;ɮT��?����r$�g1�K����A��C��c��K��l:�'��3 c�ﳯ*"t8�~l��)���m��+U,z��`(��>yJ�?����h>��]��v��ЍG*�{`��;y]��I�T� ;c��NU�fo¾h���/$���|NS���1�S�"�H��V���T���4��uhǜ�]�v;���5�͠x��'C\�SBpl���h}�N����� A�Bx���%��ޭ�l��/����T��w�ʽ]D�=����K���ž�r㻠l4�S�O?=�k �M:� ��c�C�a�#ha���)�ѐxc�s���gP�iG���{+���x���Q���I= �� z��ԫ+ �8"�k�ñ�j=|����c ��y��CF��/���*9ж�h{ �?4�o� ��k�m�Q�N�x��;�Y��4膚�a�w?�6�>�e]�����Q�r�:����g�,i"�����ԩA��*M�<�G��b�if��l^M��5�� �Ҩ�{����6J��ZJ�����P�*�����Y���ݛu�_4�9�I8�7���������,^ToR���m4�H��?�N�S�ѕw��/S��甍�@�9H�S�T��t�ƻ���ʒU��*{Xs�@����f������֒Li�K{H�w^���������Ϥm�tq���s� ���ք��f:��o~s��g�r��ט� �S�ѱC�e]�x���a��) ���(b-$(�j>�7q�B?ӕ�F��hV25r[7 Y� }L�R��}����*sg+��x�r�2�U=�*'WS��ZDW]�WǞ�<��叓���{�$�9Ou4��y�90-�1�'*D`�c�^o?(�9��u���ݐ��'PI&� f�Jݮ�������:wS����jfP1F:X �H�9dԯ����˝[�_54 �}*;@�ܨ�� ð�yn�T���?�ןd�#���4rG�ͨ��H�1�|-#���Mr�S3��G�3�����)�.᧏3v�z֑��r����$G"�`j �1t��x0<Ɔ�Wh6�y�6��,œ�Ga��gA����y��b��)���h�D��ß�_�m��ü �gG;��e�v��ݝ�nQ� ��C����-�*��o���y�a��M��I�>�<���]obD��"�:���G�A��-\%LT�8���c�)��+y76���o�Q�#*{�(F�⽕�y����=���rW�\p���۩�c���A���^e6��K������ʐ�cVf5$�'->���ՉN"���F�"�UQ@�f��Gb~��#�&�M=��8�ט�JNu9��D��[̤�s�o�~������� G��9T�tW^g5y$b��Y'��س�Ǵ�=��U-2 #�MC�t(�i� �lj�@Q 5�̣i�*�O����s�x�K�f��}\��M{E�V�{�υ��Ƈ�����);�H����I��fe�Lȣr�2��>��W��I�Ȃ6������i��k�� �5�YOxȺ����>��Y�f5'��|��H+��98pj�n�.O�y�������jY��~��i�w'������l�;�s�2��Y��:'lg�ꥴ)o#'Sa�a�K��Z� �m��}�`169�n���"���x��I ��*+� }F<��cГ���F�P�������ֹ*�PqX�x۩��,� ��N�� �4<-����%����:��7����W���u�`����� $�?�I��&����o��o��`v�>��P��"��l���4��5'�Z�gE���8���?��[�X�7(��.Q�-��*���ތL@̲����v��.5���[��=�t\+�CNܛ��,g�SQnH����}*F�G16���&:�t��4ُ"A��̣��$�b �|����#rs��a�����T�� ]�<�j��B�S�('$�ɻ� �wP;�/�n��?�ݜ��x�F��yUn�~mL*-�������Xf�wd^�a�}��f�,=t�׵i�.2/wpN�Ep8�OР���•��R�FJ� 55TZ��T �ɭ�<��]��/�0�r�@�f��V��V����Nz�G��^���7hZi����k��3�,kN�e|�vg�1{9]_i��X5y7� 8e]�U����'�-2,���e"����]ot�I��Y_��n�(JҼ��1�O ]bXc���Nu�No��pS���Q_���_�?i�~�x h5d'�(qw52] ��'ޤ�q��o1�R!���`ywy�A4u���h<קy���\[~�4�\ X�Wt/� 6�����n�F�a8��f���z �3$�t(���q��q�x��^�XWeN'p<-v�!�{�(>ӽDP7��ո0�y)�e$ٕv�Ih'Q�EA�m*�H��RI��=:��� ���4牢) �%_iN�ݧ�l]� �Nt���G��H�L��� ɱ�g<���1V�,�J~�ٹ�"K��Q�� 9�HS�9�?@��k����r�;we݁�]I�!{ �@�G�[�"��`���J:�n]�{�cA�E����V��ʆ���#��U9�6����j�#Y�m\��q�e4h�B�7��C�������d<�?J����1g:ٳ���=Y���D�p�ц� ׈ǔ��1�]26؜oS�'��9�V�FVu�P�h�9�xc�oq�X��p�o�5��Ա5$�9W�V(�[Ak�aY錎qf;�'�[�|���b�6�Ck��)��#a#a˙��8���=äh�4��2��C��4tm^ �n'c����]GQ$[Wҿ��i���vN�{Fu ��1�gx��1┷���N�m��{j-,��x�� Ūm�ЧS�[�s���Gna���䑴�� x�p 8<������97�Q���ϴ�v�aϚG��Rt�Һ׈�f^\r��WH�JU�7Z���y)�vg=����n��4�_)y��D'y�6�]�c�5̪��\� �PF�k����&�c;��cq�$~T�7j ���nç]�<�g ":�to�t}�159�<�/�8������m�b�K#g'I'.W������6��I/��>v��\�MN��g���m�A�yQL�4u�Lj�j9��#44�t��l^�}L����n��R��!��t��±]��r��h6ٍ>�yҏ�N��fU�� ���� Fm@�8}�/u��jb9������he:A�y�ծw��GpΧh�5����l}�3p468��)U��d��c����;Us/�֔�YX�1�O2��uq�s��`hwg�r~�{ R��mhN��؎*q 42�*th��>�#���E����#��Hv�O����q�}������6�e��\�,Wk�#���X��b>��p}�դ��3���T5��†��6��[��@��P�y*n��|'f�֧>�lư΂�̺����SU�'*�q�p�_S�����M�� '��c�6������m�� ySʨ;M��r���Ƌ�m�Kxo,���Gm�P��A�G�:��i��w�9�}M(�^�V��$ǒ�ѽ�9���|���� �a����J�SQ�a���r�B;����}���ٻ֢�2�%U���c�#�g���N�a�ݕ�'�v�[�OY'��3L�3�;,p�]@�S��{ls��X�'���c�jw��k'a�.��}�}&�� �dP�*�bK=ɍ!����;3n�gΊU�ߴmt�'*{,=SzfD� A��ko~�G�aoq�_mi}#�m�������P�Xhύ�����mxǍ�΂���巿zf��Q���c���|kc�����?���W��Y�$���_Lv����l߶��c���`?����l�j�ݲˏ!V��6����U�Ђ(A���4y)H���p�Z_�x��>���e���R��$�/�`^'3qˏ�-&Q�=?��CFVR �D�fV�9��{�8g�������n�h�(P"��6�[�D���< E�����~0<@�`�G�6����Hг�cc�� �c�K.5��D��d�B���`?�XQ��2��ٿyqo&+�1^� DW�0�ꊩ���G�#��Q�nL3��c���������/��x ��1�1�[y�x�პCW��C�c�UĨ80�m�e�4.{�m��u���I=��f�����0QRls9���f���������9���~f�����Ǩ��a�"@�8���ȁ�Q����#c�ic������G��$���G���r/$W�(��W���V�"��m�7�[m�A�m����bo��D� j����۳� l���^�k�h׽����� ��#� iXn�v��eT�k�a�^Y�4�BN���ĕ���0������� !01@Q"2AaPq3BR�������?�����@4�Q�����T3,���㺠�W�[=JK�Ϟ���2�r^7��vc�:�9 �E�ߴ�w�S#d���Ix��u��:��Hp��9E!�� V 2;73|F��9Y���*ʬ�F��D����u&���y؟��^EA��A��(ɩ���^��GV:ݜDy�`��Jr29ܾ�㝉��[���E;Fzx��YG��U�e�Y�C���� ����v-tx����I�sם�Ę�q��Eb�+P\ :>�i�C'�;�����k|z�رn�y]�#ǿb��Q��������w�����(�r|ӹs��[�D��2v-%��@;�8<a���[\o[ϧw��I!��*0�krs)�[�J9^��ʜ��p1)� "��/_>��o��<1����A�E�y^�C��`�x1'ܣn�p��s`l���fQ��):�l����b>�Me�jH^?�kl3(�z:���1ŠK&?Q�~�{�ٺ�h�y���/�[��V�|6��}�KbX����mn[-��7�5q�94�������dm���c^���h� X��5��<�eޘ>G���-�}�دB�ޟ� ��|�rt�M��V+�]�c?�-#ڛ��^ǂ}���Lkr���O��u�>�-D�ry� D?:ޞ�U��ǜ�7�V��?瓮�"�#���r��չģVR;�n���/_� ؉v�ݶe5d�b9��/O��009�G���5n�W����JpA�*�r9�>�1��.[t���s�F���nQ� V 77R�]�ɫ8����_0<՜�IF�u(v��4��F�k�3��E)��N:��yڮe��P�`�1}�$WS��J�SQ�N�j��ٺ��޵�#l���ј(�5=��5�lǏmoW�v-�1����v,W�mn��߀$x�<����v�j(����c]��@#��1������Ǔ���o'��u+����;G�#�޸��v-lη��/(`i⣍Pm^����ԯ̾9Z��F��������n��1��� ��]�[��)�'�������:�֪�W��FC����� �B9،!?���]��V��A�Վ�M��b�w��G F>_DȬ0¤�#�QR�[V��kz���m�w�"��9ZG�7'[��=�Q����j8R?�zf�\a�=��O�U����*oB�A�|G���2�54 �p��.w7� �� ���&������ξxGHp� B%��$g�����t�Џ򤵍z���HN�u�Я�-�'4��0���;_���3������� !01"@AQa2Pq#3BR�������?����ʩca��en��^��8���<�u#��m*08r��y�N"�<�Ѳ0��@\�p��� �����Kv�D��J8�Fҽ� �f�Y��-m�ybX�NP����}�!*8t(�OqѢ��Q�wW�K��ZD��Δ^e��!� ��B�K��p~�����e*l}z#9ң�k���q#�Ft�o��S�R����-�w�!�S���Ӥß|M�l޶V��!eˈ�8Y���c�ЮM2��tk���� ������J�fS����Ö*i/2�����n]�k�\���|4yX�8��U�P.���Ы[���l��@"�t�<������5�lF���vU�����W��W��;�b�cД^6[#7@vU�xgZv��F�6��Q,K�v��� �+Ъ��n��Ǣ��Ft���8��0��c�@�!�Zq s�v�t�;#](B��-�nῃ~���3g������5�J�%���O������n�kB�ĺ�.r��+���#�N$?�q�/�s�6��p��a����a��J/��M�8��6�ܰ"�*������ɗud"\w���aT(����[��F��U՛����RT�b���n�*��6���O��SJ�.�ij<�v�MT��R\c��5l�sZB>F��<7�;EA��{��E���Ö��1U/�#��d1�a�n.1ě����0�ʾR�h��|�R��Ao�3�m3 ��%�� ���28Q�� ��y��φ���H�To�7�lW>����#i`�q���c����a��� �m,B�-j����݋�'mR1Ήt�>��V��p���s�0IbI�C.���1R�ea�����]H�6�����������4B>��o��](��$B���m�����a�!=���?�B� K�Ǿ+�Ծ"�n���K��*��+��[T#�{�E�J�S����Q�����s�5�:�U�\wĐ�f�3����܆&�)�����I���Ԇw��E T�lrTf6Q|R�h:��[K�� �z��c֧�G�C��%\��_�a��84��HcO�bi��ؖV��7H �)*ģK~Xhչ0��4?�0��� �E<���}3���#���u�?�� ��|g�S�6ꊤ�|�I#Hڛ� �ա��w�X��9��7���Ŀ%�SL��y6č��|�F�a 8���b���$�sק�h���b9RAu7�˨p�Č�_\*w��묦��F ����4D~�f����|(�"m���NK��i�S�>�$d7SlA��/�²����SL��|6N�}���S�˯���g��]6��; �#�.��<���q'Q�1|KQ$�����񛩶"�$r�b:���N8�w@��8$�� �AjfG|~�9F ���Y��ʺ��Bwؒ������M:I岎�G��`s�YV5����6��A �b:�W���G�q%l�����F��H���7�������Fsv7���k�� 403WebShell
403Webshell
Server IP : 103.30.72.248  /  Your IP : 216.73.216.61
Web Server : Microsoft-IIS/10.0
System : Windows NT WIN-CARKG80MF9A 10.0 build 17763 (Windows Server 2019) AMD64
User : IUSR ( 0)
PHP Version : 8.2.7
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /Program Files (x86)/ManageEngine/UEMS_Agent/data/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /Program Files (x86)/ManageEngine/UEMS_Agent/data/data-dictionary-onpremise.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE data-dictionary SYSTEM "data-dictionary.dtd">
<!--?xml-stylesheet type="text/xsl" href="http://nms5-server/dd_styles/data-dictionary-transform.xsl"?-->
<!--
Repository Version Details:

$Id: data-dictionary.xml,v 1.91.6.28.8.7.14.31.4.8.8.1 2014/08/20 14:02:39 narunkumar Exp $

-->

<data-dictionary name="DeviceManagementFramework">


    <table name="ServerUptime">
        <description>
            <![CDATA[
		This table will hold the start and end time of the sever. This will be useful for debugging purposes.
		]]>
        </description>
        <columns>
            <column name="SERVER_NAME">
                <description>Name of the server. Eg: DesktopCentral. </description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="START_TIME">
                <description>Start time of the DesktopCentral server. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="END_TIME">
                <description>End time of the DesktopCentral server. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="ServerUptime_PK">
            <primary-key-column>SERVER_NAME</primary-key-column>
        </primary-key>
    </table>
	


    <table name="ApplnServerSettings">
        <description>
            <![CDATA[
			This table can be used to confiure the server configuration details of associated applications
		]]>
        </description>
        <columns>
            <column name="APPNAME">
                <data-type>CHAR</data-type>
                <max-size>200</max-size>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
            <column name="SERVER">
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <nullable>true</nullable>
            </column>
            <column name="PORT">
                <data-type>CHAR</data-type>
                <max-size>20</max-size>
                <nullable>true</nullable>
            </column>
            <column name="PROTOCOL">
                <data-type>CHAR</data-type>
                <max-size>20</max-size>
                <nullable>true</nullable>
            </column>
            <column name="INSTALLATION_TYPE">
                <data-type>CHAR</data-type>
                <max-size>20</max-size>
                <default-value>sdp</default-value>
                <nullable>false</nullable>
            </column>
            <column name="THIRD_PARTY_SSL_ENABLED">
                <description>Enable/disable Third Party SSL</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
            </column>
            <column name="SSL_ALIAS_NAME">
                <description>SDP SSL Alias name</description>
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <nullable>true</nullable>
            </column>
            <column name="SSL_PASSWORD">
                <description>SDP SSL password</description>
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <nullable>true</nullable>
            </column>
            <column name="AUTHENDICATION_KEY">
                <description>The user account name. </description>
                <data-type>SCHAR</data-type>
                <max-size>200</max-size>
                <nullable>true</nullable>
            </column>
            <column name="IS_ENABLED">
                <description>Enable/disable application server integration</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
            </column>
            <column name="IS_LEFT_TREE_ENABLE">
                <description>Enable/disable application server integration</description>
                <data-type>BOOLEAN</data-type>
                <default-value>true</default-value>
                <nullable>false</nullable>
            </column>
            <column name="CREATED_TIME">
                <description>Integration Settings Enabled Time</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
            </column>
            <column name="SKIP_AUTHENTICATION">
                <description>Allows SDP requests to skip API validation</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="ApplnServerSettings_PK">
            <primary-key-column>APPNAME</primary-key-column>
        </primary-key>
    </table>
    <table name="StatusNotificationInfo">
        <description>
            <![CDATA[
			This table will be used as Queue for notification update.This table will hold the status details for the Collections.
		]]>
        </description>
        <columns>
            <column name="COLLECTION_ID">
                <description>Unique Id for each Collection. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="STATUS">
                <description>Holds the current state of the Collection. The value would be one from "SAVED", "DEPLOYED", "IN PROGRESS", "IN PROGRESS WITH FAILURES", "EXECUTED SUCCESSFULLY", "EXECUTED WITH FAILURES", "SUSPENDED", etc. Once the user is comfortable to apply the collection of configurations on the user machines, he can deploy the changes done. </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="StatusNotificationInfo_PK">
            <primary-key-column>COLLECTION_ID</primary-key-column>
        </primary-key>
    </table>
    <table name="IntegrationParams">
        <description>
            <![CDATA[
       	 		This table can be used to confiure the params related to Helpdesk and DesktopCentral integration
        	]]>
        </description>
        <columns>
            <column name="INTEGRATION_PARAM_ID">
                <description>Unique id generated for each parameter.</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>IntegrationParams.INTEGRATION_PARAM_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="PARAM_NAME">
                <description>Key name of the parameter.</description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="PARAM_VALUE">
                <description>Value of the parameter.</description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="IntegrationParams_PK">
            <primary-key-column>INTEGRATION_PARAM_ID</primary-key-column>
        </primary-key>
        <indexes>
            <index name="IntegrationParams_IDX1">
                <index-column>PARAM_NAME</index-column>
            </index>
        </indexes>
    </table>
    <table name="DBBackupInfo">
        <description>
            <![CDATA[
			This table holds the information about the scheduled backup configurations.
			]]>
        </description>
        <columns>
            <column name="ID">
                <description>Unique Id for DBBackupInfo . </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>DBBackupInfo.ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="NO_OF_BACKUP">
                <description>This Column used for number of backup maintain</description>
                <data-type>INTEGER</data-type>
                <default-value>7</default-value>
                <nullable>false</nullable>
            </column>
            <column name="BACKUP_DIR">
                <description>The Directory name in which the database is stored in the zip formate. </description>
                <data-type>NCHAR</data-type>
                <max-size>255</max-size>
                <nullable>true</nullable>
            </column>
            <column name="SHOW_MESSAGE_STATUS">
                <description>Last backup process status</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
            </column>
            <column name="BACKUP_PASSWORD">
                <description>Password for backup</description>
                <data-type>SCHAR</data-type>
            </column>
            <column name="BACKUP_PASSWORD_HINT">
                <description>hint for backup password</description>
                <data-type>NCHAR</data-type>
                <max-size>255</max-size>
                <nullable>true</nullable>
            </column>
        </columns>
        <primary-key name="DBBackupInfo_PK">
            <primary-key-column>ID</primary-key-column>
        </primary-key>
    </table>
    <table name="DCServerUptimeHistory">
        <description>
            <![CDATA[
			This table contains the DC server runtime Details with build numbers.
			]]>
        </description>
        <columns>
            <column name="DC_UPTIME_RECORD_ID">
                <description>Unique Id for each agent slot info. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>DCServerUptimeHistory.DC_UPTIME_RECORD_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="SERVER_HOST_NAME">
                <description>Host name where the DC server is running. </description>
                <data-type>NCHAR</data-type>
                <max-size>50</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="START_TIME">
                <description>Time at which the server has been started. </description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="START_TIME_STR">
                <description>Time at which the server has been started, in date format. </description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SHUTDOWN_TIME">
                <description>Time at which the server has been shutdown. </description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SHUTDOWN_TIME_STR">
                <description>Time at which the server has been shutdown, in date format. </description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="TOTAL_UPTIME_MIN">
                <description>Total uptime in minutes for this run. </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="TOTAL_UPTIME_STR">
                <description>Total uptime for this run, in readable format. </description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_NUMBER">
                <description>Build number of the server at this run. </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="DCServerUptimeHistory_PK">
            <primary-key-column>DC_UPTIME_RECORD_ID</primary-key-column>
        </primary-key>
    </table>
    <table name="DCServerBuildHistory">
        <description>
            <![CDATA[
			This table contains the DC server runtime Details with build numbers.
			]]>
        </description>
        <columns>
            <column name="BUILD_NUMBER">
                <description>Build number of the server at this run. </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_DETECTED_AT">
                <description>Time at which the new build number is detected. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_DETECTED_AT_STR">
                <description>Time at which the server has been started, in date format. </description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="REMARKS">
                <description>Any remarks about the build. </description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_TYPE">
                <description>Type number of the build with respect to the table DCServerBuildType </description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
		</columns>
        <primary-key name="DCServerBuildHistory_PK">
            <primary-key-column>BUILD_NUMBER</primary-key-column>
        </primary-key>
    </table>
	<table name="DMJarBuildHistory">
        <description>
            <![CDATA[
			This table contains the DC server runtime Details with build numbers.
			]]>
        </description>
        <columns>
            <column name="JAR_BUILD_ID">
                <description>Build number of the server at this run. </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>DMJarBuildHistory.JAR_BUILD_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="BUILD_NUMBER">
                <description>Build number of the server at this run. </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_INSTALLED_AT">
                <description>Time at which the new build number is detected. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_DETECTED_AT">
                <description>Time at which the new build number is detected. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_DETECTED_AT_STR">
                <description>Time at which the server has been started, in date format. </description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="REMARKS">
                <description>Any remarks about the build. </description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_TYPE">
                <description>Type number of the build with respect to the table DCServerBuildType </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="DMJarBuildHistory_PK">
            <primary-key-column>JAR_BUILD_ID</primary-key-column>
        </primary-key>
    </table>
    <table name="DCServerNATInfo">
        <description>This table contains server NAT config details. </description>
        <columns>
            <column name="NAT_ID">
                <description>Primary key id</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>DCServerNATInfo.NAT_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="NAT_ADDRESS">
                <description>This will store the NAT ipaddress of the machine where configured in the router</description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="NAT_HTTPS_PORT">
                <description>This will store the port number at which the https port is opened for communication. </description>
                <data-type>INTEGER</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="NAT_RDS_HTTPS_PORT">
                <description>This will store the port number at which the https port is opened for remote control.  </description>
                <data-type>INTEGER</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="NAT_FT_HTTPS_PORT">
                <description>This will store the port number at which the https port is opened for File transfer</description>
                <data-type>INTEGER</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="NAT_NS_PORT">
                <description>This will store the port number at which the long lived http connections are established.</description>
                <data-type>INTEGER</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="NAT_CHAT_PORT">
                <description>This will store the port number at which the https port is opened for chat.</description>
                <data-type>INTEGER</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

        </columns>
        <primary-key name="DCServerNATInfo_PK">
            <primary-key-column>NAT_ID</primary-key-column>
        </primary-key>
    </table>

   <table name="MailAlertCallBackHandler" >
        <description>This table contains the Smtp configuration details</description>
        <columns>
            <column name="ALERT_ID">
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
            <column name="CALLBACK_HANDLER">
                <data-type>NCHAR</data-type>
                <max-size>300</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="MailAlertCallBackHandler_PK">
            <primary-key-column>ALERT_ID</primary-key-column>
        </primary-key>
    </table>

<!--  ProxyConfiguration table below columns are deprecated (FTPPROXYHOST, FTPPROXYPORT, FTPPROXYUSER, FTPPROXYPASSWORD) -->
    <table name="ProxyConfiguration" >
        <description>This table contains the proxy configuration details</description>
        <columns>
            <column name="PCID">
                <description>The unique generated ID of the server.</description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <nullable>false</nullable>
            </column>

            <column name="HTTPPROXYHOST">
                <data-type>NCHAR</data-type>
                <max-size>500</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="HTTPPROXYPORT">
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <default-value>80</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="HTTPPROXYUSER">
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="HTTPPROXYPASSWORD">
                <data-type>NCHAR</data-type>
                <max-size>30</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="FTPPROXYHOST">
                <data-type>NCHAR</data-type>
                <max-size>500</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="FTPPROXYPORT">
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <default-value>80</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="FTPPROXYUSER">
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="FTPPROXYPASSWORD">
                <data-type>NCHAR</data-type>
                <max-size>30</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="PROXYSCRIPT_ENABLED">
                <description>Proxy script enable=1 , disabled=0 </description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="PROXYSCRIPT">
                <description>proxy script web URL</description>
                <data-type>NCHAR</data-type>
                <max-size>255</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

        </columns>
        <primary-key name="ProxyConfiguration_PK">
            <primary-key-column>PCID</primary-key-column>
        </primary-key>
    </table>


    <table name="DCDomainExceptionList" >
        <description>This table contains the Failed Domains List</description>
        <columns>
            <column name="URLID">
                <description>The unique ID of URL list.</description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <nullable>false</nullable>
            </column>

            <column name="VENDORNAME">
                <description>URL Vendor name details</description>
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="URLDOMAIN">
                <description>Domain URL</description>
                <data-type>NCHAR</data-type>
                <max-size>255</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="URLTYPE">
                <description>URL type, Example 1=Microsof, 2=TU, 3=Mac</description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <default-value>1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="REMARKS">
                <description>Crawler pre populated Remarks details</description>
                <data-type>NCHAR</data-type>
                <max-size>255</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

             <column name="STATUS">
                <description>status of the domain access, 1=Success 2=Failed</description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <default-value>1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="UPDATED_VERSION">
                <description>Last updated version, download tried time</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

        </columns>
        <primary-key name="DCDomainExceptionList_PK">
            <primary-key-column>URLID</primary-key-column>
        </primary-key>
    </table>

    <table name="DbOptimization">
        <description>This table can be used to store the Physical Memory configured for Usage by the Database</description>
	    <columns>
		<column name="DBOPTIMIZATION_ID">
                <description>Unique Id for each DB Memory Configuration </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>DbOptimization.DBOPTIMIZATION_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="DB_NAME">
                <data-type>CHAR</data-type>
                <max-size>20</max-size>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
			<column name="SYSTEM_TOTAL_MEMORY">
                <description>System Total Memory available </description>
                <data-type>FLOAT</data-type>
                <default-value>0.0</default-value>
                <nullable>false</nullable>
            </column>
            <column name="MEMORY_ALLOCATED">
                <description>Current Memory Configured for Usage </description>
                <data-type>FLOAT</data-type>
                <default-value>0.0</default-value>
                <nullable>false</nullable>
            </column>
			<column name="MEMORY_ALLOCATED_TIME">
                <description>Current Memory Configured for Usage Updated Time</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
            </column>
			<column name="DC_USER_ID">
                <description>User id for visual status for each user</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="DbOptimization_PK">
            <primary-key-column>DBOPTIMIZATION_ID</primary-key-column>
        </primary-key>
		<foreign-keys>
			<foreign-key name="DbOptimization_FK" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>DC_USER_ID</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
		</foreign-keys>
    </table>

<table name="DbLockInfo">
		<description>
			<![CDATA[
			This table will contain the details of locks occured in database.
			]]>
		</description>
		<columns>
			<column name="DBLOCKINFO_ID">
				<description>Unique Id of the File created. </description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
				<uniquevalue-generation>
                    <generator-name>DbLockInfo.DBLOCKINFO_ID</generator-name>
                </uniquevalue-generation>
			</column>
			<column name="FILE_NAME">
				<description>Name of the file created</description>
				<data-type>CHAR</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
			<column name="CREATED_TIME">
				<description>DB Lock Details File creation time</description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
			<column name="NO_OF_QUERIES_LOCKED">
				<description>Total number of queries locked when the file is created</description>
				<data-type>INTEGER</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
			<column name="LOCKED_QUERY_MAX_TIME">
				<description>Of all the locked queries, maximum time a query takes</description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
                        <column name="THREADS_BLOCKED">
                            <description>Number of threads blocked</description>
                            <data-type>INTEGER</data-type>
                            <nullable>false</nullable>
                            <unique>false</unique>
                        </column>
			<column name="IS_DELETED">
				<description>Does the file exists or deleted</description>
				<data-type>BOOLEAN</data-type>
				<default-value>false</default-value>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
		</columns>
		<primary-key name="DbLockInfo_PK">
			<primary-key-column>DBLOCKINFO_ID</primary-key-column>
		</primary-key>

	</table>
	<table name="DbLockNotification">
		<columns>
			<column name="LOGIN_ID">
				<description>Unique identifier</description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
			<column name="LAST_NOTIFIED_TIME">
				<description>Last notified time of the user</description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>

		</columns>

		<primary-key name="DbLockNotification_PK">
            <primary-key-column>LOGIN_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="DbLockNotification_FK" reference-table-name="AaaLogin" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>LOGIN_ID</fk-local-column>
                        <fk-reference-column>LOGIN_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
	</table>
	<table name="DbLockSettings">
		<columns>
		<column name="DBLOCKSETTINGS_ID">
				<description>Unique Id</description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
				<unique>false</unique>
				<uniquevalue-generation>
                    <generator-name>DbLockSettings.DBLOCKSETTINGS_ID</generator-name>
                </uniquevalue-generation>
		</column>
		<column name="LOCK_TIME_LIMIT">
			<description>Number of minutes that a query can lock</description>
			<data-type>BIGINT</data-type>
			<nullable>false</nullable>
			<unique>false</unique>
		</column>
		<column name="IS_AUTOMATIC">
			<description>Automatic mail sending option is enabled</description>
			<data-type>BOOLEAN</data-type>
			<nullable>false</nullable>
			<unique>false</unique>
		</column>
		<column name="NOTIFY_LIMIT">
			<description>Days after which notification is allowed</description>
			<data-type>INTEGER</data-type>
			<nullable>false</nullable>
			<unique>false</unique>
		</column>
		<column name="CLEANUP_LIMIT">
			<description>Days after which the files can be deleted</description>
			<data-type>INTEGER</data-type>
			<nullable>false</nullable>
			<unique>false</unique>
		</column>
		<column name="DBLOCKS_RETAIN_COUNT">
			<description>Number of files to retain</description>
			<data-type>INTEGER</data-type>
			<nullable>false</nullable>
			<unique>false</unique>
		</column>

		</columns>
		<primary-key name="DbLockSettings_PK">
            <primary-key-column>LOCK_TIME_LIMIT</primary-key-column>
        </primary-key>
	</table>
    <table name="FileUploadDetails">
        <description>
            <![CDATA[
		This table contains details on debug file upload details for tracking desktopcentral performance.
		]]>
        </description>
        <columns>
            <column name="FILEUPLOADDETAILS_ID">
                <description>Unique Id</description>
                <data-type>INTEGER</data-type>
                <uniquevalue-generation>
                    <generator-name>FileUploadDetails.FILEUPLOADDETAILS_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="FILE_TYPE">
                <description>type of file such as hprof,no-managed connection,pid</description>
                <data-type>CHAR</data-type>
                <max-size>255</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BUILD_NUMBER">
                <description> Build Number at the time of upload </description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="LAST_UPLOADED_TIME">
                <description> Last uploaded time for each file </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="UPLOAD_COUNT_PER_BUILD_NUMBER">
                <description>No of times the file has been uploaded for current build </description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
            </column>
            <column name="UPLOAD_SUCCESS_STATUS">
                <description>True if file has been uploaded successfully. </description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
            </column>
        </columns>
        <primary-key name="FileUploadDetails_PK">
            <primary-key-column>FILEUPLOADDETAILS_ID</primary-key-column>
        </primary-key>
        <indexes>
            <index name="FileUploadDetails_IDX1">
                <index-column>FILE_TYPE</index-column>
            </index>
        </indexes>
    </table>
	<table name="GoogleAuthentication">
        <description>
			<![CDATA[
			This table will have Google Authentication details with respect to the user .
		]]>
        </description>
        <columns>
            <column name="LOGIN_ID">
                <description>Its taken from AAALogin</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SECRET_KEY">
				<description>Secret key with respect to the user for Bar Code Generation </description>
				<data-type>CHAR</data-type>
				<max-size>250</max-size>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
			<column name="KEY_LABEL">
				<description>A unique key to identify the user</description>
				<data-type>CHAR</data-type>
				<max-size>250</max-size>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
            <column name="FIRST_LOGIN_STATUS">
				<description>Whether user login for the first time-to show the Google Authentication configuration details </description>
				<data-type>BOOLEAN</data-type>
				<default-value>false</default-value>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
        </columns>
        <primary-key name="GoogleAuthentication_PK">
            <primary-key-column>LOGIN_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="GoogleAuthentication_FK1" reference-table-name="AaaLogin" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>LOGIN_ID</fk-local-column>
                        <fk-reference-column>LOGIN_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
	 <table name="DCAaaLogin">
        <description><![CDATA[This table tells if user created by plugin server ]]>
        </description>
        <columns>
            <column name="LOGIN_ID">
                <description>its refer from AaaLogin table</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>

            <column name="APPNAME">
                <description>Name of the application used this plugin -> SDP or IT360 or MSPCenterlite</description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="DCAaaLogin_PK">
            <primary-key-column>LOGIN_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key reference-table-name="AaaLogin" name="DCAaaLogin_FK1" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>LOGIN_ID</fk-local-column>
                        <fk-reference-column>LOGIN_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
	<table name="DBBackupFilesInfo">
        <description>
            <![CDATA[
            Contains details of installation time and option selected for patch.
        ]]>
        </description>
        <columns>
            <column name="ID">
                <description>id for DB backup files info</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>DBBackupFilesInfo.ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="GENRATED_TIME">
                <description>DB Backup file generated Time</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="FILE_NAME">
                <description>The Directory name in which the database is stored in the zip formate. </description>
                <data-type>NCHAR</data-type>
                <max-size>50</max-size>
                <default-value>-1</default-value>
                <nullable>false</nullable>
            </column>
            <column name="BACKUP_STATUS">
                <description>Last backup process status</description>
                <data-type>BOOLEAN</data-type>
                <default-value>true</default-value>
                <nullable>false</nullable>
            </column>
          <column name="BACKUP_TYPE">
            <description>Backup type (i.e) binary [1] or dump [2] or copy [3]</description>
            <data-type>INTEGER</data-type>
            <nullable>true</nullable>
          </column>
        </columns>
        <primary-key name="DBBackupFilesInfo_PK">
            <primary-key-column>ID</primary-key-column>
        </primary-key>
    </table>
	<table name="RemoteDBComputer">
        <description>
            <![CDATA[
        This table will hold computer list for those have permission to access DC DB.
        ]]>
        </description>
        <columns>

            <column name="REMOTE_COMPUTER_ID">
                <description>Unique id for each computer that have permission to access DC DB. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>RemoteDBComputer.REMOTE_COMPUTER_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="COMPUTER_NAME">
                <description>Name of the Computer </description>
                <data-type>NCHAR</data-type>
                <max-size>200</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="OPERATION_TYPE">
                <description>Type of the operation involved with to control remote DB Access. The value will be 1 - READ Persmisson,  2 -Revoke permission </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="RemoteDBComputer_PK">
            <primary-key-column>REMOTE_COMPUTER_ID</primary-key-column>
        </primary-key>
    </table>
        <table name="DomainExceptionList">
        <description>
            URL to be added in exception should be sent out through crawler.
        </description>
        <columns>
            <column name="URLID">
                <description>URL ID</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="VENDORNAME">
                <description>Vendor Name </description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
            </column>
            <column name="URLDOMAIN">
             <description>URL DOMAIN ADDRESS</description>
                <data-type>CHAR</data-type>
                <max-size>255</max-size>
                <nullable>false</nullable>
            </column>
         <column name="URLTYPE">
                <description>URL TYPE, Example 1-Windows,2-TU and 3-Mac </description>
                 <data-type>INTEGER</data-type>
                 <max-size>11</max-size>
                <nullable>false</nullable>
            </column>
          <column name="REMARKS">
                <data-type>CHAR</data-type>
                <max-size>255</max-size>
                <nullable>true</nullable>
            </column>
         <column name="VERSION">
                <description>Version(Time)</description>
                <data-type>BIGINT</data-type>
                 <max-size>19</max-size>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="DomainExceptionList_PK">
            <primary-key-column>URLID</primary-key-column>
        </primary-key>
    </table>

     <table name="DCQueueSummary">
        <description>
            <![CDATA[
                            This table holds the information about the number of rows in queue.
                            ]]>
        </description>
        <columns>
            <column name="Q_METADATA_ID">
                <description>Unique Id from DCQueueMetaData for each queue data. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Q_COUNT">
                <description>Number of rows maintained in the queue table. </description>
                <data-type>BIGINT</data-type>
                <default-value>100</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Q_SIZE_IN_MEMORY">
                <description>The size of the queue in memory</description>
                <data-type>BIGINT</data-type>
                <default-value>100</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="QUEUE_SIZE_PENDING_IN_DB">
                <description>The count difference between database count and memory count</description>
                <data-type>BIGINT</data-type>
                <default-value>100</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="DATA_POSTED_TIME_LOW">
                <description>Time at which the data was POSTED in server which is being processed.</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="DATA_POSTED_TIME_HIGH">
                <description>Time at which the last data was POSTED in server.</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="DCQueueSummary_PK">
            <primary-key-column>Q_METADATA_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="DCQueueSummary_FK"
                         reference-table-name="DCQueueMetaData"
                         isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>Q_METADATA_ID</fk-local-column>
                        <fk-reference-column>Q_METADATA_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
     <table name="AaaLoginExtn">
        <description><![CDATA[Contains custom group and customer relation]]>
        </description>
        <columns>
            <column name="LOGIN_ID">
                <description>AaaLogin ID</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="CREATION_TIME">
                <description>Time at which this template is created. </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_TIME">
                <description>Time at which this template is last modified. </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SCOPE">
                <description>0-All computer,1- unique CG,2-Remote off </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
	    <column name="MDM_SCOPE">
                <description>0-All devices,1- unique CG</description>
                <data-type>INTEGER</data-type>
		        <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="AaaLoginExtn_PK">
            <primary-key-column>LOGIN_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="AaaLoginExtn_FK1" reference-table-name="AaaLogin" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>LOGIN_ID</fk-local-column>
                        <fk-reference-column>LOGIN_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
	<table name="FosReplicationErrorCodes">
        <description>This table is used to store the failover replication error details</description>
        <columns>
            <column name="ERROR_CODE">
                <description>Robocopy error code</description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
            </column>
            <column name="ERROR_FREQUENCY">
                <description>Error frequency</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
			<column name="LAST_ERROR_TIME">
				<description>Last Error occurred time</description>
				<data-type>BIGINT</data-type>
				<nullable>false</nullable>
			</column>
        </columns>
        <primary-key name="FosReplicationErrorCodes_PK">
            <primary-key-column>ERROR_CODE</primary-key-column>
        </primary-key>
    </table>

    <table name="FosParams">
        <description>This table is used to store the parameters for fail over service.</description>
        <columns>
            <column name="SERVER_IP">
                <description>Unique ID generated for each parameter</description>
                <data-type>NCHAR</data-type>
                <nullable>false</nullable>
            </column>
            <column name="IS_REPLICATION_PENDING">
                <description>Is Completing pending replication failed during takeover </description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="TAKEOVER_COUNT">
                <description>Take Over count</description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="LAST_TAKEOVER_TIME">
                <description>Slave TakeOver time </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
			<column name="NOTIFICATION_COUNT">
				<description>Slave down notification count</description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
			</column>
			<column name="SEND_TAKEOVER_MAIL">
				<description>Send mail when takeover happened</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
			</column>
        </columns>
        <primary-key name="FosParams_PK">
            <primary-key-column>SERVER_IP</primary-key-column>
        </primary-key>
    </table>

    <table name="ServerDebuggingFileSummary">
        <description>
            <![CDATA[
            This table  contains the debugging file occurences in customer setup.
            ]]>
        </description>
        <columns>
            <column name="BUILD_NUMBER">
                <description>Build Number for which debug info is stored </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="FILE_TYPE">
                <description>hprof files -1,pid files -2,dblock files -3 </description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="COUNT">
                <description>No of times the file has been generated in customer setup </description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="ServerDebuggingFileSummary_PK">
            <primary-key-column>BUILD_NUMBER</primary-key-column>
            <primary-key-column>FILE_TYPE</primary-key-column>
        </primary-key>
    </table>

    <table name="METrackParams">
        <description>
            <![CDATA[
            This table will contain the parameters for METracking, to track the usage for a few features
            ]]>
        </description>
        <columns>
            <column name="METRACK_PARAM_ID">
                <description>Unique id generated for each METracking parameter. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>METrackParams.METRACK_PARAM_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="PARAM_NAME">
                <description> Key name of the METracking parameter. </description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="PARAM_VALUE">
                <description>Value for the METracking parameter. </description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="LAST_UPDATED_TIME">
                <description>The last Updated time of the METracking parameter, which would suggest the usage of the feature. </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="METrackParams_PK">
            <primary-key-column>METRACK_PARAM_ID</primary-key-column>
        </primary-key>
        <indexes>
            <index name="METrackParams_IDX1">
                <index-column>PARAM_NAME</index-column>
            </index>
        </indexes>
    </table>

	 <table name="APIMETrackParams">
        <description>
            <![CDATA[
            This table will contain the parameters to track the usages from Desktop Central Mobile App
            ]]>
        </description>
        <columns>
            <column name="API_METRACK_PARAM_ID">
                <description>Unique id generated for each API METracking parameter. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>APIMETrackParams.API_METRACK_PARAM_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="PARAM_NAME">
                <description> Key name of the API METracking parameter. </description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="PARAM_VALUE">
                <description>Value for the API METracking parameter. </description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="LAST_UPDATED_TIME">
                <description>The last Updated time of the API METracking parameter, which would suggest the usage of the feature. </description>
                <data-type>BIGINT</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="API_TYPE">
                <description>The API Type of the API METracking parameter. 1. iOS 2. Android 3. 3rd Party API </description>
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="APIMETrackParams_PK">
            <primary-key-column>API_METRACK_PARAM_ID</primary-key-column>
        </primary-key>
        <indexes>
            <index name="APIMETrackParams_IDX1">
                <index-column>PARAM_NAME</index-column>
            </index>
        </indexes>
    </table>

    <table name="ONDemandDataCollectorTasks">
        <description>
            <![CDATA[
            This table will contain the details of On-demand Data Collector tasks.
            ]]>
        </description>
        <columns>
            <column name="TASK_ID">
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
            <column name="ZC_FORM_NAME">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="ZC_COLUMN_NAME">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MIN_BUILD_NUMBER">
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="DATA_FROM">
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="EXPIRE_DAYS">
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="TASK_RELEASED_TIME">
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="DATA_POSTED_TO">
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="ONDemandDataCollectorTasks_PK">
            <primary-key-column>TASK_ID</primary-key-column>
        </primary-key>
    </table>

    <table name="ONDemandDataCollectorTasksExtn">
        <description>
            <![CDATA[
                This table will contain the details of On-demand Data Collector tasks.
                ]]>
        </description>
        <columns>
            <column name="TASK_ID">
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
            <column name="MAX_BUILD_NUMBER">
                <data-type>INTEGER</data-type>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="LICENSE_TYPE">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="LICENSE_EDITION">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="PRODUCT_ARCHITECTURE">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="DB_TYPE">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="SQL_FOR">
                <data-type>INTEGER</data-type>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="COMMON_QUERY">
                <data-type>CHAR</data-type>
                <max-size>-1</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="POSTGRES_QUERY">
                <data-type>CHAR</data-type>
                <max-size>-1</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="MSSQL_QUERY">
                <data-type>CHAR</data-type>
                <max-size>-1</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="FILE_PATH">
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="STARTS_WITH">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="ENDS_WITH">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="MATCHES">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="KEY_NAMES">
                <data-type>CHAR</data-type>
                <max-size>200</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="ONDemandDataCollectorTasksExtn_PK">
            <primary-key-column>TASK_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="ONDemandDataCollectorTasksExtn_FK" reference-table-name="ONDemandDataCollectorTasks" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>TASK_ID</fk-local-column>
                        <fk-reference-column>TASK_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>

    <table name="TwoFactorTokenDetails">
        <description>
            <![CDATA[
        This table is to used to maintain two factor cookie detail.
        ]]>
        </description>
        <columns>
            <column name="ID">
                <description>Unique id</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <uniquevalue-generation>
                    <generator-name>TwoFactorTokenDetails.ID</generator-name>
                </uniquevalue-generation>
            </column>

            <column name="USER_NAME">
                <description>Name of the user</description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
            </column>

            <column name="TOKEN">
                <description>The two factor value which is stored in the cookie</description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
            </column>

            <column name="REMEMBER_ME">
                <description>No of days to remember user</description>
                <data-type>INTEGER</data-type>
                <nullable>false</nullable>
            </column>

            <column name="CREATED_TIME">
                <description>Token created time</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="TwoFactorTokenDetails_PK">
            <primary-key-column>ID</primary-key-column>
        </primary-key>
    </table>

    <table name="SmtpConfiguration" >
        <description>This table contains the Smtp configuration details</description>
        <columns>
            <column name="SERVERNAME">
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>true</nullable>
            </column>
            <column name="PORT">
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="USERNAME">
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="PASSWORD">
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="SENDER_NAME">
                <description>Mail sender name </description>
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SENDER_ADDRESS">
                <description>Mail sender address </description>
                <data-type>NCHAR</data-type>
                <max-size>100</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="IS_TLS_ENABLED">
                <description>Option to enable Transport Layer Security (TLS).</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="IS_SMTPS_ENABLED">
                <description>Option to enable Transport Layer Security (TLS).</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="PREVIOUS_ERROR_CODE">
                <description>Previous error code if mail sending failed</description>
                <data-type>INTEGER</data-type>
                <default-value>-1</default-value>
                <nullable>true</nullable>
            </column>
        </columns>
        <primary-key name="SmtpConfiguration_PK">
            <primary-key-column>SERVERNAME</primary-key-column>
        </primary-key>
    </table>

    <table name="FSMCorruptionInfo">
        <description><![CDATA[Contains the Method details]]> </description>
        <columns>
            <column name="FSM_ID">
                <description>FSM Id</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <uniquevalue-generation>
                    <generator-name>FSMCorruptionInfo.FSM_ID</generator-name>
                </uniquevalue-generation>
            </column>

            <column name="FSM_CORRUPTED_TABLENAME">
                <description>FSM corrupted table name</description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <default-value>--</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="FSM_CORRUPTED_FINDING_DATE">
                <description>FSM COrruption Finding date</description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>

            <column name="IS_FSM_CORRUPTION_HANDLED">
                <description>Maintains the status of the FSM Corrupted </description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
            </column>

            <column name="FSM_CORRUPTION_COUNT">
                <description>Gives count for Number of times particular table was corrupted</description>
                <data-type>INTEGER</data-type>
                <default-value>0</default-value>
                <nullable>false</nullable>
            </column>
        </columns>

        <primary-key name="FSMCorruptionInfo_PK">
            <primary-key-column>FSM_ID</primary-key-column>
        </primary-key>
    </table>


	<!-- Antivirus detection table -->
	<table name="ANTIVIRUSTEST">
	<description>
	<![CDATA[
	This tool checks if the DC folder is excluded from the antivirus or not.
	This table should have only one row.
	]]>
	</description>
		<columns>
            <column name="ANTIVIRUSTEST_ID">
                <description>Unique id generated for ANTIVIRUSTEST parameter. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>ANTIVIRUSTEST.ANTIVIRUSTEST_ID</generator-name>
                </uniquevalue-generation>
            </column>
			<column name="IS_PRODUCT_EXCLUDED">
					<description>Stores the result of the AV test.</description>
					<data-type>BOOLEAN</data-type>
					<default-value>false</default-value>
					<nullable>false</nullable>
					<unique>false</unique>
			</column>
			<column name="ANTIVIRUS_NAMES">
				<description>Stores the name of the antivirus if present</description>
				<data-type>CHAR</data-type>
				<max-size>250</max-size>
				<nullable>false</nullable>
				<unique>false</unique>
			</column>
			<column name="STATUS">
                <description>Status of the attempt.</description>
                <data-type>INTEGER</data-type>
                <nullable>true</nullable>
			</column>
		</columns>
        <primary-key name="ANTIVIRUSTEST_PK">
            <primary-key-column>ANTIVIRUSTEST_ID</primary-key-column>
        </primary-key>
	</table>

    <table name="CheckforUpdatesStatusClicks">
        <description> <![CDATA[ Contains METracking Data for the Check for Updates Feature ]]></description>
        <columns>
            <column name="STATUS_ID">
                <description>Unique ID to refer the CheckforUpdatesStatusClicks Table </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <uniquevalue-generation>
                    <generator-name>CheckforUpdatesStatusClicks.CLICK_INFO_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="STATUS">
                <description>It refers to the status of the updates msg displayed to the user</description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
            </column>
            <column name="COUNT">
                <description>The number of times the status has been viewed by the user</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="CheckforUpdatesStatusClicks_PK">
            <primary-key-column>STATUS_ID</primary-key-column>
        </primary-key>
    </table>
    <table name="CheckforUpdatesUserClicks">
        <description> <![CDATA[ Contains METracking Data for the Check for Updates Feature ]]></description>
        <columns>
            <column name="CLICK_INFO_ID">
                <description>Unique ID to refer the CheckforUpdatesUserClicks Table </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>CheckforUpdatesUserClicks.CLICK_INFO_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="USER_ID">
                <description>its referred from AaaUser table</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="NO_OF_CLICKS">
                <description>The number of times BuildNo link is clicked</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="CheckforUpdatesUserClicks_PK">
            <primary-key-column>CLICK_INFO_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="CheckforUpdatesUserClicks_FK1" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>USER_ID</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
	  <table name="NotifiedUserForUpdates">
        <description>This table will contain entries after the user has been notified about updates of the Product Server (i.e) entries of users that have been notified of updates.</description>
        <columns>
            <column name="NOTIFIEDUSERFORUPDATES_ID">
                <description>Unique Id for changes notified to users </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
                <uniquevalue-generation>
                    <generator-name>NotifiedUserForUpdates.NOTIFIEDUSERFORUPDATES_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="LOGIN_ID">
                <description>it is referred from AaaLogin table</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="NotifiedUserForUpdates_PK">
            <primary-key-column>NOTIFIEDUSERFORUPDATES_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key reference-table-name="AaaLogin" name="NotifiedUserForUpdates_FK1" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>LOGIN_ID</fk-local-column>
                        <fk-reference-column>LOGIN_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
      </table>

	<table name="SilentUpdateDetails">
        <description><![CDATA[This table contains silent update details]]></description>
        <columns>
            <column name="TASK_ID">
                <description><![CDATA[Unique ID for each row.]]></description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="QPPM_ID">
                <description><![CDATA[Holds QPM unique id from Jar Tracker tool]]></description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="QPPM_URL">
                <description><![CDATA[Contains QPM url]]></description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="QPPM_TYPE">
                <description><![CDATA[Contains type(0 : Without Restart, 1 : With Restart) of the QPPM.]]></description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
                <allowed-values>
                    <value>0</value>
                    <value>1</value>
                </allowed-values>
            </column>
            <column name="QPPM_CHECKSUM">
                <description><![CDATA[Holds checksum hash value generated from QPPM.]]> </description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="BASE_BUILD_NUMBER">
                <description><![CDATA[Contains applicable base build number ]]></description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_TIME_IN_CRS">
                <description><![CDATA[Time at which the task has been modified in CRS. ]]></description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="ALERT_MSG_CONTENT">
                <description><![CDATA[Contains alert message content of the QPPM.]]></description>
                <data-type>CHAR</data-type>
                <max-size>-1</max-size>
                <unique>false</unique>
            </column>
            <column name="PRODUCT_COMPONENTS">
                <description><![CDATA[Contains server component's details.]]></description>
                <data-type>CHAR</data-type>
                <max-size>-1</max-size>
                <unique>false</unique>
            </column>
            <column name="IMMEDIATE_MOVE_PRODUCT_COMPONENTS">
                <description><![CDATA[Contains immediate move server component's list.]]></description>
                <data-type>CHAR</data-type>
                <max-size>-1</max-size>
                <unique>false</unique>
            </column>
            <column name="HIDE_REMINDME_LATER">
                <description><![CDATA[Contains remind me later option]]></description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SHOW_DISMISS">
                <description><![CDATA[Contains dismiss option]]></description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SHOW_IGNORE_THIS_FIX">
                <description><![CDATA[Contains ignore this fix option]]></description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="ALERT_MSG_FREQUENCY">
                <description><![CDATA[Time at which the alert msg frequency.]]></description>
                <data-type>BIGINT</data-type>
                <unique>false</unique>
            </column>
            <column name="DYNAMIC_CHECKER_CLASS_URL">
                <description><![CDATA[Contains dynamic checker class url]]></description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <unique>false</unique>
            </column>
            <column name="DYNAMIC_CHECKER_CLASS_CHECKSUM">
                <description><![CDATA[Holds checksum hash value generated from dynamic checker class zip.]]> </description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="SilentUpdateDetails_PK">
            <primary-key-column>TASK_ID</primary-key-column>
        </primary-key>
    </table>

    <table name="SilentUpdateDetailsExtn">
        <columns>
            <column name="TASK_ID">
                <description><![CDATA[Unique ID for each row.]]></description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="TASK_STATUS">
                <description><![CDATA[Contains status(-4: Failed, -3: Reverted -2 : Ignored, -1 : Not Applicable, 0 : Download Pending, 1 : Process Pending, 2 : QuickFix Apply Pending, 3 : Finish) of the QPPM.]]></description>
                <data-type>INTEGER</data-type>
                <max-size>11</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
                <allowed-values>
                    <value>-4</value>
                    <value>-3</value>
                    <value>-2</value>
                    <value>-1</value>
                    <value>0</value>
                    <value>1</value>
                    <value>2</value>
                    <value>3</value>
                </allowed-values>
            </column>
            <column name="ALERT_MSG_LAST_SHOWN_TIME">
                <description><![CDATA[Time at which the alert msg last shown.]]></description>
                <data-type>BIGINT</data-type>
                <default-value>-1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="IS_SHOW_ALERT_MSG">
                <description><![CDATA[Contains dynamic checker shown msg]]></description>
                <data-type>BOOLEAN</data-type>
                <default-value>true</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="IS_FIX_APPROVED">
                <description><![CDATA[Contains fix approval value]]></description>
                <data-type>BOOLEAN</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="QPPM_FIXES_ID">
                <description><![CDATA[Contains QPPM fixes id.]]> </description>
                <data-type>CHAR</data-type>
                <max-size>250</max-size>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="SilentUpdateDetailsExtn_PK">
            <primary-key-column>TASK_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="SilentUpdateDetailsExtn_FK" reference-table-name="SilentUpdateDetails" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>TASK_ID</fk-local-column>
                        <fk-reference-column>TASK_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
    <table name="IntegrationService">
        <columns>
            <column name="SERVICE_ID">
                <description>Unique Id for the service</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>true</unique>
                <uniquevalue-generation>
                    <generator-name>IntegrationService.SERVICE_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="NAME">
                <description>Service Name</description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
            <column name="STATUS">
                <description>status of the integration Service</description>
                <data-type>INTEGER</data-type>
                <default-value>1</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
                <allowed-values>
                    <value>1</value>
                    <value>2</value>
                </allowed-values>
            </column>
            <column name="CREATED_BY">
                <description>AAA user id of user creating the service</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="CREATION_TIME">
                <description>Time at which this service was created. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_BY">
                <description>AAA user id of user modifying the service</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_TIME">
                <description>Time at which this service was last modified. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="IntegrationService_PK">
            <primary-key-column>SERVICE_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="IntegrationService_FK1" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>CREATED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
            <foreign-key name="IntegrationService_FK2" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>MODIFIED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
        </foreign-keys>
    </table>
    <table name="APIKeyScope">
        <columns>
            <column name="SCOPE_ID">
                <description>Unique Id for the Scope</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>true</unique>
                <uniquevalue-generation>
                    <generator-name>APIKeyScope.SCOPE_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="SCOPE_NAME">
                <description>Scope Name</description>
                <data-type>NCHAR</data-type>
                <max-size>250</max-size>
                <nullable>false</nullable>
                <unique>true</unique>
            </column>
            <column name="DESCRIPTION">
                <description>Description for the scope</description>
                <data-type>CHAR</data-type>
                <max-size>500</max-size>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="CREATED_BY">
                <description>AAA user id of user creating the service</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="CREATION_TIME">
                <description>Time at which this service was created. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_BY">
                <description>AAA user id of user modifying the scope</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_TIME">
                <description>Time at which the scope was last modified. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="APIKeyScope_PK">
            <primary-key-column>SCOPE_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="APIKeyScope_FK1" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>CREATED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
            <foreign-key name="APIKeyScope_FK2" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>MODIFIED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
        </foreign-keys>
    </table>
    <table name="ScopeRoleRel">
        <columns>
            <column name="SCOPE_ID">
                <description>Scope ID</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="AAA_ROLE_ID">
                <description>AAA role Id</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="ScopeRoleAssociation_PK">
            <primary-key-column>SCOPE_ID</primary-key-column>
            <primary-key-column>AAA_ROLE_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="ScopeRoleAssociation_FK1" reference-table-name="APIKeyScope" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>SCOPE_ID</fk-local-column>
                        <fk-reference-column>SCOPE_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
            <foreign-key name="ScopeRoleAssociation_FK2" reference-table-name="AaaRole" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>AAA_ROLE_ID</fk-local-column>
                        <fk-reference-column>ROLE_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
        </foreign-keys>
    </table>
    <table name="APIKeyInfo">
        <columns>
            <column name="API_KEY_ID">
                <description>Unique Id for the API Key</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>true</unique>
                <uniquevalue-generation>
                    <generator-name>APIKeyInfo.API_KEY_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="API_KEY">
                <description>Service Name</description>
                <data-type>SCHAR</data-type>
                <nullable>false</nullable>
            </column>
            <column name="VALIDITY">
                <description>Time at which this service was created. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="SERVICE_ID">
                <description>Unique Id for the service</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="USER_ID">
                <description>AAA user id of user for whom the key is being created</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="CREATED_BY">
                <description>AAA user id of user creating the service</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="CREATION_TIME">
                <description>Time at which this service was created. </description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_BY">
                <description>AAA user id of user modifying the api key</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_TIME">
                <description>Time at which this key was last modified</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="APIKeyInfo_PK">
            <primary-key-column>API_KEY_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="APIKeyInfo_FK1" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>USER_ID</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
            <foreign-key name="APIKeyInfo_FK2" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>CREATED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
            <foreign-key name="APIKeyInfo_FK3" reference-table-name="IntegrationService" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>SERVICE_ID</fk-local-column>
                        <fk-reference-column>SERVICE_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
            <foreign-key name="APIKeyInfo_FK5" reference-table-name="AaaUser" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>MODIFIED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
        </foreign-keys>
    </table>
    <table name="APIKeyScopeRel">
        <columns>
            <column name="API_KEY_ID">
                <description>Api Key ID</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="SCOPE_ID">
                <description>Scope Id</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="APIKeyScopeRel_PK">
            <primary-key-column>API_KEY_ID</primary-key-column>
            <primary-key-column>SCOPE_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="APIKeyScopeRel_FK1" reference-table-name="APIKeyInfo" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>API_KEY_ID</fk-local-column>
                        <fk-reference-column>API_KEY_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
            <foreign-key name="APIKeyScopeRel_FK2" reference-table-name="APIKeyScope" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>SCOPE_ID</fk-local-column>
                        <fk-reference-column>SCOPE_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
            </foreign-key>
        </foreign-keys>
    </table>

    <table name="ColumnDetailsExtn">
        <description>
            <![CDATA[
			This table will contains the extended column details.
			]]>
        </description>
        <columns>
            <column name="COLUMN_ID">
                <description>Unique id for the each column.</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="EXTENDED_DATA_TYPE_NAME">
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
            </column>
            <column name="ADDED_BY">
                <description>Refer from AAAUSEr table</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="ADDED_TIME">
                <description>Added At</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_BY">
                <description>Refer from AAAUSEr table</description>
                <data-type>BIGINT</data-type>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="MODIFIED_TIME">
                <description>Added At</description>
                <data-type>BIGINT</data-type>
                <nullable>true</nullable>
                <unique>false</unique>
            </column>
            <column name="IS_PII">
                <description>IS PII Column</description>
                <data-type>BOOLEAN</data-type>
                <default-value>false</default-value>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="ColumnDetailsExtn_PK">
            <primary-key-column>COLUMN_ID</primary-key-column>
        </primary-key>
        <foreign-keys>
            <foreign-key name="ColumnDetailsExtn_FK1" reference-table-name="ColumnDetails" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>COLUMN_ID</fk-local-column>
                        <fk-reference-column>COLUMN_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
            <foreign-key reference-table-name="AaaUser" name="ColumnDetailsExtn_FK2" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>ADDED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
            <foreign-key reference-table-name="AaaUser" name="ColumnDetailsExtn_FK3" isbidirectional="false">
                <fk-columns>
                    <fk-column>
                        <fk-local-column>MODIFIED_BY</fk-local-column>
                        <fk-reference-column>USER_ID</fk-reference-column>
                    </fk-column>
                </fk-columns>
                <fk-constraints>ON-DELETE-CASCADE</fk-constraints>
            </foreign-key>
        </foreign-keys>
    </table>
    <table name="CustomDataType">
        <description>
            <![CDATA[ Table to store user defined data types.
		 ]]>
        </description>
        <columns>
            <column name="CUSTOMDATATYPE_ID">
                <description>Unique ID for custom data type</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <uniquevalue-generation>
                    <generator-name>CustomDataType.CUSTOMDATATYPE_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="DATATYPE">
                <description>custom data types </description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
        </columns>
        <primary-key name="CustomDataType_PK">
            <primary-key-column>CUSTOMDATATYPE_ID</primary-key-column>
        </primary-key>
    </table>

    <table name="AccessLogAnalysis">
        <columns>
            <column name="AccessLogAnalysis_ID">
                <description>Unique ID for accessLogAnalysis</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <uniquevalue-generation>
                    <generator-name>AccessLogAnalysis.AccessLogAnalysis_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="time_stamp">
                <description> timestamp </description>
                <data-type>DATE</data-type>
                <default-value>0</default-value>
                <unique>false</unique>
            </column>
            <column name="IPAddress">
                <description>IP Address of Agent Machine</description>
                <data-type>CHAR</data-type>
                <max-size>50</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Request">
                <description> request URL </description>
                <data-type>CHAR</data-type>
                <max-size>1000</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Status_Code">
                <description>StatusCode</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="Data_Size">
                <description>Size in bytes</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="Time_Taken">
                <description>StatusCode</description>
                <data-type>Float</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="AccessLogAnalysis_PK">
            <primary-key-column>AccessLogAnalysis_ID</primary-key-column>
        </primary-key>
    </table>

    <table name="AccessLogData">
        <columns>
            <column name="AccessLogData_ID">
                <description>Unique ID for accessLogData</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
                <uniquevalue-generation>
                    <generator-name>AccessLogData.AccessLogData_ID</generator-name>
                </uniquevalue-generation>
            </column>
            <column name="Req_Time">
                <description> Date of req </description>
                <data-type>DATE</data-type>
                <unique>false</unique>
            </column>
            <column name="Type">
                <description> request URL </description>
                <data-type>CHAR</data-type>
                <max-size>1000</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Max_Duration">
                <description>StatusCode</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="Average_Duration">
                <description>Size in bytes</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="Req_Count">
                <description>StatusCode</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
            <column name="Reqps">
                <description>Request Per Second</description>
                <data-type>CHAR</data-type>
                <max-size>100</max-size>
                <default-value>0</default-value>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Total_Size">
                <description>StatusCode</description>
                <data-type>Float</data-type>
                <nullable>false</nullable>
            </column>
            <column name="Total_Size_Readable">
                <data-type>CHAR</data-type>
                <max-size>1000</max-size>
                <nullable>false</nullable>
                <unique>false</unique>
            </column>
            <column name="Error_Count">
                <description>StatusCode</description>
                <data-type>BIGINT</data-type>
                <nullable>false</nullable>
            </column>
        </columns>
        <primary-key name="AccessLogData_PK">
            <primary-key-column>AccessLogData_ID</primary-key-column>
        </primary-key>
    </table>

</data-dictionary>

Youez - 2016 - github.com/yon3zu
LinuXploit