Script Biblioteca base de datos.

...

`numDoc` varchar(10),

`numTelefono` varchar(20),

`DOMICILIO` varchar(50),

`id_imagen` int(4) unsigned zerofill NULL,

`estado` varchar(10),

PRIMARY KEY(id_usuario),

INDEX(id_tipoUsuario, id_tipoDoc, id_imagen),

FOREIGN KEY(id_tipoUsuario)REFERENCES tipousuario(id_tipoUsuario),

FOREIGN KEY(id_tipoDoc)REFERENCES tipodocumento(id_tipoDoc),

FOREIGN KEY(id_imagen)REFERENCES imagenes(id_imagen)

) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS `prestamo` (

`id_prestamo` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,

`id_usuario` int(3) unsigned zerofill NOT NULL,

`referCopiasPorLibro` int(4) NOT NULL,

`id_tipoPrestamo` int(3) unsigned zerofill NOT NULL,

`fechaSalida` VARCHAR(10) NOT NULL,

`fechaEntrega` VARCHAR(10) NOT NULL,

PRIMARY KEY(id_prestamo),

INDEX(id_usuario, referCopiasPorLibro, id_tipoPrestamo),

FOREIGN KEY(id_usuario)REFERENCES usuario(id_usuario),

FOREIGN KEY(referCopiasPorLibro)REFERENCES copiasporlibro(SecuenciaCopXlibro),

FOREIGN KEY(id_tipoPrestamo)REFERENCES tipoprestamo(id_tipoPrestamo)

) ENGINE=InnoDB;

INSERT INTO `genero` (`id_genero`, `denominacion`) VALUES

(001, 'Ciencias'),

(002, 'Matematicas'),

(003, 'Computacion'),

(004, 'Universitarios');

INSERT INTO `tipodocumento` (`id_tipoDoc`, `denominacion`, `Descripcion`) VALUES

(001, 'DUE', 'Documento Unico Estudiantil'),

(002, 'DUI', 'Documento Unico de Identidad'),

(003, 'CE', 'Carnet Estudiantil');

INSERT INTO `tipoprestamo` (`id_tipoPrestamo`, `denominacion`) VALUES

(01, 'Interno'),

(02, 'Externo');

INSERT INTO `tipousuario` (`id_tipoUsuario`, `denominacion`) VALUES

(01, 'Estudiante'),

(02, 'Docente'),

(03, 'Particulares');

INSERT INTO `ubicacion` (`id_ubicacion`, `ubicacion`) VALUES

(001, 'Modulo 1'),

(002, 'Modulo 2'),

(003, 'Modulo 3'),

(004, 'Modulo 4');

INSERT INTO `paises` (`id_pais`, `nombrePais`) VALUES

(0001, 'Mexico'),

(0002, 'Inglaterra'),

(0003, 'Estados Unidos'),

(0004, 'España');

INSERT INTO `editorial` (`id_editorial`, `nombre`, `paisEditorial`) VALUES

(001, 'PEARSON', 0001),

(002, 'MAPASA S.A DE C.V', 0001),

(003, 'MAPEX EDITORIAL', 0004);

INSERT INTO `imageneslibros` (`idImagen`, `imagen`, `nombre`) VALUES

(001, 0x89504e470d0a1a0a0000000d49484452000000cf000000f3080300000016e7b2bb0000008a504c5445ffffff000000040404fefefefbfbfb070707f3f3f3e1e1e1eeeeeef8f8f8f1f1f1f5f5f5494949acacaccbcbcbd7d7d7c4c4c42c2c2c5f5f5fe9e9e97c7c7cd2d2d2dddddda8a8a8999999878787b7b7b7646464929292393939c1c1c1595959171717333333979797a1a1a15151517676763636364040408282826f6f6f1e1e1e2525252d2d2d13131331d67cff00001e6449444154789cd51d0997aabc8e4e41700154c40511c77d1bffffdf7b4dd2224b8be37c77465ece79df9b2ba009cd9e34b5ac7600176071dbb26cdb7e372eff020411e16434da4648d4ff3fd8c98a214c2c9bbf1b991f03e7b62df8cc0acf1f8c7d0030b6834fff5f4942c4930193d408705860f1ff57722cab934c04318ef3e17c30a28ab1e8ff5084382e827b70800807a86083647a65f0e7c5faff5c9f6c2ff90c883ac7e213efc66881de8ddaeb10edae0c5603396ce083e5112b9620c74dde8ddcb741e8335401c185a1d8a0d42c03bac685153a31f8287a2f96df070ea2eeee506a48050ce69e952b346ec5f0393bbc17cb57a09fac49a1019f5d53975c1da5d06ceb880bd4792b8edf01ce1f7cc668699643ba022e8ead74da16555c62b55d6573f0698e0c758023f8cd597896429adb283b082ed23368bf4df5e6b79ccfd8e7ac53766be244fd75421517b5747d38319a9dadc9d6c0d2b08b54687859fc11838f708f88e5e6484ffa4ea41b00a989d2ab72d0185bf97d2b770080547f8512c59c297ee4c2ad6cd3d2f511f80e972c779ed9312385a6080a6169d840fcf783ade0036ead5065c76f44590b847334ff247d863eda09a92126440571026a0ea1657547822060436eed909ed46a991707d80cc7726998c29b2ea13673cf402a4bc91908043d0b7ccc45eefbb278cb549cb793a606c9d9ec1e6223fecff361693ec7a0d64054381741d009ffb006e894baed3041eaa5ba07f269281658065ce63c10d0ac1e26c36efe806d8120212b5a073441b376f01b063676b22ee880eb3c22e54c04f567a0d03ec3ca63be60b808a94bd07f58b7c6a4ba0b56a006bd1a9b784ac87d800a8d2dbac29816ec29b77ba8105087e0fa081feecdf410e3f803f6086cd8ccb3c89fc18bc1e50ac47cee7a18ee141640fc79c75c08fc83e2eee4bdf488d0c6e2c1522e8d0341e7972f31a22421a5a4560b8369998bb5b440a2ac25d273f923c48dd09d8da4878611f42acb9d66418d37db00357b500cb63621d53fa18213b0437aaeefd36f809d972a0f0dadcd242cf099952d496adcdc9e961f06707d416eda17ff0ec966bdc545e0f8b2797c507c46a91a7cb736d263871307a3eb7957fb0510cdf130bd81cbc3845a13c1d0155d84c5df5222d1b19406560e275b4c2dca42932fbaa1446eea493557876807c61553a48cc5e2a93132dcea4f09b1944243e3882b03cbb0078b9f47d001383ce2e38d1f59bce2c0c87fc48b1b11c3d80d62ed81f8cca7ec82763d7f8f1a40c84d6fc5a559c78427283bab03cb06d2b40c6aeb2289f3e61b2258b80b49645de04ff10553645d36fc53932ac40633820f637309955b2d640055005073082d4d11840bd3ba903505a1c3832eba161bb15042e8bae0f78100fd0d3d9c1601ec09f219e56ae69ec5bb980ab0ace9849134388ba81cf02897349e30454c0a811c961ac0d561a1b8872cd09abca43fa047fc86bf927c8621f45e189b1cefe15a2e0d9b57124f9433e0c159aeccd76e1a95be58301c08e00cec18bbf72d997ffc6d7053150aa0125890c3890e5934bf630023909dc90462096c54ed00275484bce0d6d8d659bc9a6196213de285cca2bfa80581d6faa0981382cea4ffd0c4b1921ab6ce78c1a04ae0f16284b48c16197a76d53b7c520e980ac69712fd9e1767a31bf630360e701a84d04a5db9e997d456ebc47bd0c025cfb8096513378be071550612f03aa6fe64257d3fe743b1f2f4b7a8a138329ee4ea1956619091ee8288737694c4dc276ef1317cff9da15c98fb2456df55faee707197ba923d40acd02fae8f88a04fb97ac6d02646df127023ed8c7664d8c74f0bcf45b3b144f00c21a95de5c278763916a8582d17f32474dd48f8a5ccb5fe3d606f8015e54b832ee77de1293ef330808324ee61587c882cee8e16c619cf0ab8a9c289f042978a8eafe53c8b4bf80bcefe95b05bfcf47459acd98ad0a6af729fd3835c9ae3acafeca9254bbd91bf2655368ffb56c996a02af42fb7dc08259e2ddfc3e37713a642887f0c19059d8e726b400920a3f18410665708d34aea4ad9ff411aa0152a470962dd06f4e4e8b00bfb92142eedb1ba07cdebbf022e17209a3f7c34b10eb7ad2b89b14369e4bfcef9af4a46520b334efa8fefb3b98ce4fac19698906de6da5a1cfd34e7e28e5b8f9efc471459c93e379db0369bac2ba5265c6c08a745882ea8421a6204cc7bb243d62b6639698178301b938dd9a743b7c0a0a51f96b992b560e4db3afd47b945e155fab8348e6234d0cff8fefbfe4ddac5d82a3b68910f2fe0eb90b8445ef1c5f68354393aa95c51a343d3718399f82af4a658f4237ad42a630a0dfe07484b85866213586439dc05a66ad925e6921ac2ca0e70cd466968e75fa9448abbb3f59dcce92c9b16578de8c6509644ccee86e9ea53fa09985ad9ff48cbd12ae31b13dfdbdd954c273b4b55eacd48909759476243e65d6ade25aae5bcc22b95b64faec1781bf4f0f3aa38f0dc8f73334a6ac9188fa8faa99b60bb41d8a184b9ff59149beb96e43a92c4b0cb945e2a21d6091680c47a472fbe24bf51728075198d67b86adcc0605dd79fdc58198efb34f4e2ecca5e6d4940b6b03a932f89aa3d1f4947006de7c8a7d0d7bdc8d776761fea4f480c9aff4b466a19a3238974373ba36a5824c59e0f8af8205a92cbc883ddb8448b73d8fa71a4bc3c7855fd971c6d58ecbe4c38018b17f5b39012bc67b8503f992275f8fdbde119c39f34b08a5537588868b8c0d7739a68124faa0464f55dff3c2a92b216e2e5956f3db09763556e0d7345062a250f3b31b601e38816154460a67a086d3289a334405e2caa323b235b7a4a871dae8b82f081fe70beff7c50f2b9dcf9f2ab9093d5e2414588bd2041c86b89e22fe5d450dcb905f1edf8933bfde4751b59b40e9d2172fb6a3ea5dfe4883462e025a818c6692ccdbe8c68496bd22dc1fcb07e9072bc9c778142b812990304ec1515073fb193d9c0870e802cd30e188b7a2020703b4ba6ea865b908adbd28fac5c95d1ebecc47869b5732b38e516aa379d1d1eb2f235b86c87cf6dff84392cf8263980d024af0aaaac80587e6c0988f74a054803e8251778b14bdf55259d1ce9608bf99e83ef5ad4f55179a35ee02ff6ce4352b621f9a0dce24f1c00977db7a987c312aca9a7ee0635418bfcf71bd606e235098d4ce07602a8bcb3c14275443d782c9e232dc7b37a8dd2bb913409e5302808fd6031ec176f33f092b2ef960d2b6a81a5552d25267a8462cd8e94bebb74e9be5490002aac3b1c5066032da9edcef6f8f2a7aa104a0dd34255ec961ba4456865ebd1c4223371bda13fd9a3a22306b8dff6f3ef0469947d50ffda0844d2c3e976bd099b14d756be408fd4044291615310bcf16e5fa0dc81200db39b3d611217e02e6f164af8f3af8be7e447af77b1b43e0533618bc07353d4c5a34932cdc9fd064d56a7df098320992c65ab9c84bb6f16b90873358c65167950f44bc199511bd4328891c7568b043d1572b428b49c49d65c27392df29add9b26d2c996948cb749d6938470f5536a25ca3478ee3049127f7b5915bee0a3084237754d4bb42455a0fa81e0977a73d5d9296279781de72ccaaf922989fd0ba17bdc3dde385dea0dd37561554e977436741fa9752ed548099f280612b2d9e2b25edd59193e74807515e3f2c065025bf0960f0a4caa3bf63146a55c88400aa2bd47b5fc28ec76a7fee1fa10fa73f6a0a3c65f762f9ac6c97c71d86f2a04a884b8a3a544ad90a16976888f61f1550a39688550b2bb1f750ba64304a4fee54bfee87a36f4ac42e82362ce3dd2820a593806bdca2ff1ae1dc599bf9bac4f9bcdf1782bc8c303cdc25f8a9c720a4bddce665a72ac90e8397ae537181f843fa8de2b5ce806b3c95e89e3390bc9c5a247baa17f20ee437f6fa01c0358cc691cc741b23b5f8a3ca8e524993baa228fb05aeff797c50cc46ab91fa0aa34244a5c693eef45a7516e5a51b21d85bbbdfade851f209d5297823b29c5169c3fe7baf7a3485030db2e8f35ac3087abe7a2d27d9f5fa7fdf890ce922c76ed8aa401a4d4a5ada5c7cbdbecf61a874258f4075e87dcef25518cb28574273f94dfe7dc569518e6e3a3e8133e64a246ece9906e77fe307623af532180f4a1646ca1746294eea1a58523cb7fe1ba0bdd0ebef47c41248c2633195a93e84741bad6f1cc87e6a38f0fd52e5686ebea345e5ecee90e96e1a5d8c696d52e2d2cf2981a05f9be196c28934cb103a474d2022ff28e700764c653cb390d8c745d8dd3ddcccf8661d4ebf4bb251aec672e5c811e6b04823ad05f76254b388e4a7b908fadb2fc6cb0dd6d530507252c5ac0c758792556cbf35c2c41484b5f43ed41c6b77352dcbaa0a9d75a54d9dfe8381fa6d75de5932a0d948129ddf6395a0dd6935d12fc4636dd923ca52f3dd8a82d9c8697fe4d66629b4b8af22c04ba5734a3bfd06798a1c739d4d143dd256c102a77eb816b255ed5add64d58057f1808a554ff621593fe023d215a205f4b8f6d5db1ea0f89a5f9f25a409672094e858afb683c99cffc2408bd4ee74d2d437da467a1a5875b7b607e4fbe45e1172f16e7f930f47c5620e4765a4e16736027bbf8e8bb7a0871df93d6251508ad21493c248d59ccc39e049deb59320cbdea33b2b2f1be16dc35793c7af648216cdb553e1498420b714b77e29c819e6b5f7f3106ebb4ac7cc8b1cd898dfeb627e8bbb0932dcd5ae8013dd5e62ca0672a0467feebb8fd0448b64dd6ed040aced3c80238716f92906608909ecc70f5020234ad6d9ce6c26e3d02f136018f909eaacc2b98013d75eb2454d8e7cb958abf811e1a20d326a1802ed66a4c36a4815bb9f5ab7b6da2a70b17979a940534d6b14efbe8917b360c1dda3634a4b37b8d1ec83f89f040ebf6bd17a863364f4ad5ae2ec1e3d1d6bf52d6c6ad6c50e212f48c4c5731c110eae8494440d6bef5512911fd35d4cba0cd357847ac9dbba969e3bafe1af5070bbed2ad8310a0f659202e0d6a3565a9ae7a1fc243d06b0be1c39d7f13b51f81ecd036f42a09bd7664a6f6faf4b75ab6fe0b70abd39482038f474897c6fda68ee8df44eda780f41872d8d2e3d156c4c185fbc59ed41f83c39a0659a0c7a3957b28959bfcd877c29e7c1a03003b6a431d1ebede9bf1739015d91818a2a1460a70a688db80181f09b4f5ee034397f4bf62fa3d80bac61412e3b7b96bd98d2f110daad3507574b4ee03c77daebd3f5b9f4eaa324abb66a6f031e5db33dd9416735605b021b7dab4930db7353e6b7de2a5be0bc3dd82d57ad48fbac4ff1b37fa2501a64863d3fa0c216715d6a9e548cfcecc70028be1d39160d849c0ed70369bf991a919c2b6a21bbcd56320e23568256fb4e3ae9c3362589f29d3ef60c5edfbfa4ca4828920f7799e345eaa22f297c97f721dc863ec38ae60c89ad52ad6b1cd2fda668876ed4553166e6dec47b1fa905d4dad7a5130bf434ddb784054cf437218bd23c859ca2929b6e5f51ab5907d230364ba4704b0ba1055202cded9d5c4225ddaf2669e7166c7d9a309fe737c595e064c87850dc931930fa985136b980343219da3451b9256067ee2d65c2071da085562a0782849596e33d5f31b69671b2039e6d75d074cf9de0c176548a7956b5036268fc7c38c239fb0b181e3f806546fa61afb38699863991c6849f944725e98e13041036448f9e2f801507f9aefdb31c7e8c8fa0cf657c270899981a07935deb0b9cbaab55c9b434af3353fbe31e5cb9582d3006c8ad81abe7401ce036923c3c6a329aba4fdb0a0b1297dd405a3e0b0578adc2a423558468efa4faf97ed2bd3caa940ac7f176f082de5da344f8257132ac260edd9b5541b162b26c8d9bee6550572488216b8657f193c38c055cb0a1c98945dfb28742ed3cf5fe0c2b1afdac5ce27bb95cb163306a2fdda1e12af698e1256e91cc354a2895ec1d9f00c280229e477fd90b3656d71dddafb816d24b317e9b1594304c46d6ca165d54a9c451e82a31bc8c621af2a2d0fe7dd4fed1c4720b4daf890b1ca47989f9dbe460fc7a102a694a2853b3fb5e2a536216b2f383299c5b1813bd0f91773f659c64398e04a2016a033fc1d2a1e605344e7186f18824cfa862b3ab9031bac780954c289ed75ea3e29a5fd38683ca7a2f286c66c8c19b049c49882b364954e2b5e9053d4651e40bba90738eaeca05e73818fa989513e947c329998c90dd690d5eb9dcf001d7f50f2c63b18d3b3238710552777212beb97091b68e20d971c656ad4b6bd1336fd9dd2a1f5d8f0e0cbd955af009753538c292b2841e832c25417de6b1e00dfad9073b0fb9a542a0747186f72cf83cb65f418a07a1ae60a00d4b596d31b0036903418204b6618ea52c9a1c3a762d009568c8d0acb6d834ab12bd11a87520df21205d21ff23fd04098a75986724ac06b103719200b1d221c235767999d70f5ebd397ec7a7bc24a37b66d02d686f38c88f8bcac55370d120477873f2ad3524437365ec778cad785dc43a673cf02562bbac620fbd5fb66cce991c70b7bb8c407aef86776825f73e9d7ba3f911f8e63a14c5d7d167a8e10b3d777ea6154e0d52ea49adde2143894214105272c53778a7935daa9c4e71015c9b7c7aa16f61bf4401f15d4b44c469877efec43830ec01e22a0b25c60e5a1aa3ea20bab6fd309b4ae1d350364f496842133784b4db0976dbea6481ffa8faeda8bbe861e2815b3ad9f04eeec724a7700b8b9e6abfab0c734a525101cc1c657f24b67af6c57cae18c43465c63c88d35c96aaf30c1be1aa1da3464aadcdd87731f6b92dd65bac444d746c7877238dfdfae5484b934407a8e9321aafe3545d5dc11a79284f3e1941bda91a3cbc8f3913e9fc2795ffa4b9c7f316a50d16626e9d36eed928f29b89d219f47b39af576adfe0668448ed4bc9f83e518815a36ab9d2663a66dc5e5e800d29781677b1cda5a171ba871334d06299406c814067698212949db7d2bf203d378bd10a0f740c28b85d9742af49f99be3088ed27a4f23002621b6d4728e60099a65c1dc99d31faecac9050a83a9ebe19f5c29e506d42d667d5354e8c3d19216487685fee0daded80264615ba2461a3f1942c6375eda889e766a2c7c61cdced9ba584a121eb03cd2695ac98b0b2867c4a080d83880ef736b4eb6d8de323731c803162c875b2610d6d9829fba1e7650bd91936027e77a04acab4fd8e1cbda372741155e3b7023daa8bdab6ec316e40111ed1b684028c537298a3cbc0920132078243b382ab95cbc6cc14eb76afecd62ffeb888f4bf74efb02b56ce296456774ccddf392d12572874bb1fc8edfc632dd2cba6949545a39a2ba163e162b91cc3aa79b507cccb2a0ee3274de7831093152ba4b9845f3579f8e062f9aff9f0974c3fd96ff124028222b8c9ae65e5f26ac4cc5f14b1125383e3a15df5e90ae3042517543aad0c0e808d95a165a83dfa8d5d8a16e6ec4d81fcb99ccbcf042a7d93e61894f087481ffd762e75177d0d4ceec2a6079edf47d08d92c512b7b1dc2e5bbf499c29a26b68a05ce843548963b1b16f662ea280a7595400a067e825e6f7775d1cacf8f1a466458f9bf52d19d486ccc38ce136141deccb466482ae8ac9906dd86731012a04fdd0ed77844ae9747ac1ec805b4c519799b654a8312a95f94215e8233d0d99a1187c326ddf18e8b33cbb8df96ab3a381b9b8b0f04f39d46d34589545635c0ffed4238fbfcce4c8884ed7a7232162c6e2ef923d5c07f1e648c40dd8c098bd87f6b0d15da9bae2c765a3687c07386ecbf868384ca33bc29a9f6e896186476ea179ffaa8bace5456096d9432160eda204eb34cbf7b6fe07905da46603445b67f44d24bbc2101cce3d87ddfb26742a3c02ffe80bf08220f03a9d7e2ffff4b50289e677ce985234a65230a4137a4c67bb0256dcb31ed59cb43700b7b6cf0c1086745abe8e0a553a6c82793541fbefe1e9f147bca16f0c9c16e5b0f17674c9cac1d2e6d410c7a21714ac351785463baabf859f7f6bc319717436482d03a3c0a6a4bc9e935296bbe6bccb6eafa763fe3970da7c0e63640d3750d5f1aabde83f1a2fb9d56db2737f05c22edc30c0981a53565475d4d1cba73f2802fc2e700bf7367fe8fac2e806eaa6d2161779efdebaad0c6a90b9e964032e73563aa717a39871dbf6029d65caca5849966d1575005b8bbd2dbf88ddebb043f99934b4fd5c0db54c1b15027fa161e82f800ceabec17382aaa3be31169217da86a5370235bdb006ac3067a59d3e07c34ddb762e5c44b36b1a8c874fbd1a35e0e821343692be01ba444f83ef656c8c4527545fee7a1fd8f767292b182d00a1b4066f9f551b0bdf0fa727457bc8f199ce460af579c1b7c2f249d19e1a638f5a7aec169e4c7a7892b2e2d4f9af47fbc49a38f52d9036474096dceba8efe74d6ba59db70319d4a6290d2605870fb76e1c8234a8c69a09a7904e9f2b74db90352843c81a273b809f7637f48d6181f5cfcf187a0272faa351acb9dcccad5d9fee86dd7f11b71f017b96b282137c1d2d4362d6ba6d0afbf3890142a9d77b10e8f1fcbbe303fe05d02084a6ae315470d58655f5f0fc3b059bbf043979d8343900c1837ab28e602c54b54b61ab946fe31666f0e056ba3a13143eda351e856309ee891fb666fa13cab1f0a16b8c7d27600dd56914eb140448d3bf802d8e4db1e0df0357116ad3d16e709e2a6c8fd0f41462c4d02682e4bcd1460304236375553a1bab8ea6feb9b700e7d8c4d3b4d151dc44b353347b2b8436d197a4df088367457b0bbb054d55ba97f620fe052c9f15ed65eb61a8c33bfac3cdf6df01ae9a7898b94f41eeddd487409bea56b1b7834f0a4edfc70b2043547dc3fab2751e6946f41877da6359d2d859bed3b74abd11e4e1bc4d29ab2e33f62505e6b6b737814c91368c34b069bca73626ef42176c8b1482a522ba8399df6c5270da1856e8f2b685dc4799b26a78cbb8375ab7658ec3d942bf86d9cf800c906ec3550e9969fa1dc4836d537054736cdc9f12410a41cf57fbd6e54877a4109abacfb0c870d76e16deb74ec1651401359ea63e608e9662dce3f2c2508cbf80a706c8c27963dabe326ca57c756bd82f833cb1a4b13702eae0baa42f979be35b64816027fc93b665a9e074f3b2b9f5d5327a2c815173cdc4a2430ca00cae4921a4b001eb17b17b15b049f449ca0acef5d66f1696bdc82d224876913e992278336e35095b56b5e7df3140385c40efb37ad00adba2361ed9456adce843f7a4268f077ab45b959497b33b9f18a08c197dd675bb188ed3690c1f4d5311b95470dac6cc05337464be07b8d5bd3f4f59f5afe021182778363a4b7f0c4a61371d5849a7ce98e63ffd64fac26f024d46b975cdfc267370fa1c4febe859a8a27d43c88d21aa76cc1324e54df3b9de03099dd166daf0820047ecb0bbf686636dded99b21a0e341f51bb12478a63e05dc45deaeb60af779cd04e69c39863e8573ebaa742a026ab28a031902d5ab263b669edaf11e709e16edb1f3dfd14fbc0c58932e790790016ade61050372617c576dde0b1e3bd3a84bfe1c16cf8bf672fc50bd5aca39cce1326d19780fec9e17ede5995b751d8893d19ec8de5f435e333103b7705a427d04054705679a80fb1e702905d794e8a4ce18fdf80dbf6d6d08df28da7339b0d4d3e00d0ae1f57146bf09a7a7292b7564836e0d613452bbaa7497a711905c447dda71d0ae360435abafa932c5b9bd31b9d8d0d7d7a683e9e4acbe8f276797e14466edde19bf5d496cce7bb268df740f2838477fe609ec0f6e511b02367e39cd0688dbd867a53d95d3b6be5aa5106438dd98b2e2742480a39b628b13225bd478c96de9c13557da3ab83eab7a35015dd281d59a3203e7f2c4da274a0a0714b2fa644b1420f33c8777408af43c5152b4b946e3925a306fc3dc31f3d7c015aa4fd21a3400af2e401c2daa7eacc0df007ffc3f8e2b0187c7799a469b223d779d665e6a8722fe151019788c889ce8c79ee93704dabe5ed3cc1c676eb5c2c5ee47d338f0e767a2e7595a7067e4ca8ca6bbfe275cf2a7e53ad3c81775168deebbed7ec70b87c96c3e01180f6ef7c2204a438b4e1168f793ce857399f938d56f829acfc50bc250825eafd3f1a6c32cd94e2ecbcbe5321e8c6a87b5b3e229e84f679c77681975971a0e657819ba9e1b4591eb86993ff37d7f9e4ed6271de60c279cd6cf3857e49887c9230871a352b866e83224b1b18391d311e835e63123ef02c459e22f0eebc109e0a6455e83b1f6c47675e9f941861c4fe2c5812f352485c23eea0fe0e69e1b2a00595d4c2efbd16d84f075d7616e26a0ba020e0e7035acddec59a73b8e8c751ced76e131cef68753bacf9bc359b0f6a782269401eb469ea993d004d7d3208779f8f4982835e08675ea774e4821448746dcc5c388ba5325a1468e63c2fc3618e730596c6759ecba1e4154ae877ee7fc869169e0c859d07319a6df601347fe179c757ae57ad49ddb6abf5e221c16f3241bc6535d32e6bf016d7f3ad62f0412ab66be312d9cf3295efb24dded922c468822afa39bc708c37b7901fe2b3d6e5edba7ef7ad88a13739c22de7adc3f8feb0b1abf73ea4bd46337d20ef879fc87e7c3232b7cf19fc951fb0759cfe6e0c6d9961c68d8d9dd25a339ce03fbd169b53a8d273b3f8941294776b7052e5119e4f68025491bbdbf6932cec546c8f161e712d4d8dd36f82def039ab908fdc05318191d05f3cbb5243785c1e2fcc1ea96e416fe3e1f5c0f389c12abc76cb3dc8f941656c4381f2deb867b025cee0652baaaa68bd9b565ddd84fc0e672e89532214e999ccfa84ddbe9be05d8a3ac3133a0d8d66d9b8ff21ce0549b4467381974966be738b71b60827b74ae6802f8d7c1d5fad7ff1fd0490ec7a2e1bff89dd6e4137f089cbbfe7830586efd61645bffc76b03507106e148863612f43f86af738fc68adb610000000049454e44ae426082,