Diffusion Genome Privacy - SHCS App (develop) Browse

genopri-shcs/documentation/requirements/migration_cryptokeys.sql
88fb96c48d61develop

migration_cryptokeys.sql
View Options

			CREATE DATABASE 'pharmacogenomics_server';

			USE 'pharmacogenomics_server';

			DROP TABLE 'cryptokeys';

			CREATE TABLE 'cryptokeys' (
			'ID_ck' int(11) NOT NULL AUTO_INCREMENT,
			'ID_p' int(11) DEFAULT NULL,
			'value' blob,
			'isPublic' bit(1) NOT NULL,
			PRIMARY KEY ('ID_ck')
			) AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

			LOCK TABLES 'cryptokeys' WRITE;
			INSERT INTO 'cryptokeys' VALUES (1,30351,0x0401B14D02B197A8203ADEF7413FB63FF4A2B188DEE96413F0DA807CDB26CF2489AA5858688B0A7F8A93F2AD42FF1E9680859AF2C89BDC16E8B1AD334E902C1A4264E20129FC40E20A6962373C97F9993AFA5B9AC601E0886FCFAE509C5EE0D86EA600EE344C5273DABCC023448D08180EB1FA14F81EB34D25016FD031A54131D5C9169540,0x01),(2,30351,0x32363837383632373737353333353031363738313134323133333036323539363132343837323631383831313633393837343930363632313739373639303431393531303739353535353232313836353336383532373535323232303139383131323532393731323837393138333435373132383830363238323339373635343736373933383435333939343933373932353637333332323431343434,0x00),(3,30824,0x04010EA4A7196998EA935119111F872182ED4BBD9CD3EEA62D8CE373E0502266E6BB9AC857F623BFAB2927446451800D0CC954F922387382D4553623AEAB6EA2AC32E2013D06AB6071054111338D43C32C9FC7A513A6FB8F525CA27BB070FF24BA9AFBB36C512F999DDB758512B77DB613B62FBA973A3F49B840A9B9B07A379C917791AA90,0x01),(4,30824,0x32383939353137373732373932303238333031373934313237313539303638313930393535373331373133393730313834353634343337373833303939373536383931333536373832333739343130343533353639383735373933323136363736383233373732303636353935383630383630323639323034393433333330303831353939373830393137333831373230313731313234343634373335,0x00),(5,31024,0x04003E19B26A76EF0D2518B07ED84866062E8B5DD78FD4361EB47E2F816AC6534BC12236C091EAACC5ABB7058CC69A6F61F26C2C78303A23D19B5ED37E35B6AEB3676901E7DFC0038A523441753725E9F848A59F4471AF811D151572AA967AD81913D9DA67D79E60CC9CA2C49C64A5C4A41CEF5518B3DE3C657DE7E10167A1B5D7DBE249A3,0x01),(6,31024,0x36353533383536373439323633393132313031343434363035323239363634333634393538353637313733383730353339393335373333363130343436323437323833393236333838373035393330323737393732343535333438323134333538333533333030373535393935313639383530343037303639343738313934333130373733333637393734333235303531323333303538343631373237,0x00),(7,31291,0x0400F6032A8A777763F60DD29CA9AC7FD7788411E2B3698DB6F67FE9A01E8FB19D0E860B2B9E67906A50D6D1540A97F009400D953995064042014090BDE420B18D71FE01F6C0C7354D0D25E0497D04486C9B498315ED80F050C7C857710BB0ACA43C34700FAB52D4EAFF5F454FE6DD0BED461E85D42DC2B9C90E9B45FE8270E2E70E2A8843,0x01),(8,31291,0x36383337383830323738313337343833373932303730363233353732393830323138383937373938393539373636323830393437393233313536383435383133333338303338373334363339323433303436383537383839313136363337363831383232393632373034313338323434303632333930303734333230303232393430363536303936303136323639363434323830373937383636343137,0x00),(9,30367,0x0401023336D65B68D46B369255B590BB89DB0CFAA976468F3F9FDA5D9DA246008A6387CDFEDA2BDFBD549B2762D268043F8AFE3F588DD7E6C72655D32D5FB306B8BAED01E448CA42F7987C74BE426B18F6625754A2D28462466BF0B9206151163F081493AFB1076D92FAA12CA715783E3DC32990C65C0710B77FA5D9A1F78D9BA3EA1F7148,0x01),(10,30367,0x35363733353134393031343738313132393236363532343534323038363636373134363236333134343538343230393530323636363338333335373033373038323634343834323034343235373238303530323734383339303536323231303733393232313835333138333831393635353839353038363839353731393438333935323935303530353638363631323937353637313034303234363735,0x00),(11,30889,0x04009206F07FF250CC5057EEE2012D2F270B056C0D7DA50374E9604D5CB3CF13BD5B95E3EB31372FA319BC460591677A6DA7BF45D62A3E5E213EF3FFCBC3D9B680126A0132DEE68F9388D24DCFAA5C48E61AD1C50481D4F087FB1075A949FBE4C9C0CF8A74FBC94CA129CB314D91DAEEC3F76D1CAB6C3442016AF191D494D4A069169D575B,0x01),(12,30889,0x36373934303132393238363533333737343130343130393832383632373135383030313232363334333031323832373039303832303736303133313835303832303132393131323534343537393935343935373633313831373032393235353239343238343236343838313936383736333332373732303139353339323937313138353835343135383438393130333739343431393339363132353738,0x00),(13,31227,0x04001D7FB0D7A6D3D6749DF3C44D5032250ED5448A8EA5799B04361615BBE3AC2E829A4BCDD781FD596319CB8457B071AD9199DA785F33E15EDFC8CD782F237DCA069E0013064CA0A21D8241964FE3DC7A70B5885E8F2074AFBF1471880EFC52E89EC6F0548E0AEBC183922F951EE1DB08B0054463FEA914132A79D95CB9E36274282229E7,0x01),(14,31227,0x32333739323830383031353630313336363439353530383139333732343730343331353433323636383635363531343933393630363537353034313338303439363331333538333435373935373430303032313638303637383335393234393934353331343836393838353838363138393638393233303032393033303234333738373136303036373833363339353734353335383337393238383435,0x00),(15,52498,0x04017E8CBFBBDD6D06BB531C114F613EB210A21B5DCE881509C318DCFB283C53D319873FC1A6DF74088FE9C992E630FBA4BCABA70BA049F60FBDAFA74872FD53A6785C01CEA9CFF2F4C67A599ED431368DA63F9A88DE85DE6E3B36122E8B3C3E380BCA8969A10C59C793B7C33A4CECCDEC2D3C4B83B1A6EF85388D79CC702E94A1502E7886,0x01),(16,52498,0x34383833363938303135363138363230313235373530363032343130373431373739373636353034393834393838313033363333333933383630323032373437373735373037313638323738333134313534313231333532383431363639343338393837363432303130393930323133393730353430303933303634313831343434333137313731363936363731353832303836353837383837383139,0x00),(17,19768,0x0401E01BFCBB8381254472D5E682747AA25BD6093A18425292851918803C32572894633AB3F71C4F9B8953CB5C2859CB32B80E830E840C8618C3E7AE82222EAD57AE000161A1B63BF9E11753B9D15E9F6CE18E00DAA7C7598EE2B142AEB7F0DFD8873D34CACED3E393B4068203110E8282EC12D66A8DF6E26B7E710ADC4C7FA4C88A01F09E,0x01),(18,19768,0x36353230323130383832343736333635313636313233303439323930313339373334373431383838323735303232353332353537373436383332353439383631323336393737303437373031383233383631303434363239393934383235323231373033323439373239323239343435313535303532333335303038373230343830343835353734353730333030323537303237303735353032343331,0x00),(19,91007,0x0401F46285EE3CA3D9D79C01FB0156173045D7C3D191C3683CFFF12531085F58546A8A40BE3390D588502F1347E240E76D3B3034F6D84A617CB4C2ED0A42A670BBDF23007096BB700FF8D9091FA26589FED68DBFA507AA0937B8CF87C0C2F93F37EEF72F05F0F80C09EFD4A6A7F22B5031D4E94B6D18BB2DD79D1A307C9810A46EB800C5D4,0x01),(20,91007,0x34363538393039313136353638313239333833333433323936383537383236313130383337353331303635333235393234353632313537383336323336303636383636303032303138323930363831393930313239363937373338373635333336313435343837383038353634373730393837313939353734333839303638363330323338313336323433313130323530393937313835323433313637,0x00),(21,60789,0x0401A9418D55272CA38D7BF9AB6BD34E3B72D348172EE03ABA775E651B4B8D8401EAA43D96CF3EA97D83D7867F74C05BB10A7A9CA96CD9449A8E802D8CB86186A4F4FA01F62CFBE5C8D2B7EC2B25399088C063831E82BCF73AF5C0C071E54AB7456B756BDB79394356819D6266A72C4FCFEECF559EC5B328FEEE73801AF63CDE0DE50F8DA7,0x01),(22,60789,0x32313131333833363730313936323430383635343835363932323634363136323030343137343937313038353633323139353834393534383738313437373130343835373232333839353530363536303639353637323331373638393038333032363237313233393938383432323432363133383238313332323231373635343334323234363134353732393836383730303534333139383338343137,0x00),(23,52503,0x040134C084F1EC6D08473C763EB8DE0F0FFA9C511F2FEE8F376269B680AC53EF27BDF701FCCBCA3371146C78CDE12CB9B9199FA9DB036D00B518DB0F5DC5CA528A153A0184DF6F7291D19CFEAA8E079ACD63E54EA4300D3EC04661FEA443EA93BE5D1EA79B5792D5E21091903DDB8E5D9FEB58E90E9F14B6657B9C253ED8F8F9A43B34C7F8,0x01),(24,52503,0x33363938393834343138383532383432353432343232313238323232303830323436373132333039383039363736333536353935383536383735373036333432393636343235373130353735303030333239333934393232333238373437373637333333373334303232303334343139343135353731383435353934333532393934373738393934363439323130363737353935353335383537373239,0x00),(25,42706,0x0400F9604F86BB1F0686558DA1831191958B962640790F1435C80EB451C780EC85B253DE6D3D9A9A1CC19E8EE49C69096B116DD05F3AE6CB7C0236E3774C7638BB219B01ECE72793C1F5226F63A3A0D1FBABE3912D7BE9D746ABAB52D2A2D2EF08E88772C0EBFFD5DEDDBB5A884242B9417CE25C8D157490460BFA724724A280875D193843,0x01),(26,42706,0x31363036303739333732393736303134333035323030363636343133383930313335383736383930323332363736313136333034323935313635383239373939313736373338343036373936383737303836373335313330383530313137363930393636343136343432343130343433313832393930373234323938313936363035303139363736393035323838393531383031333735333430323037,0x00),(27,19632,0x04012D877BC24F32B4DAB59E335F459231C5FD94F775CEA64CE4F57E6FEC68E6686B9A049A7086F00981332A8295BE91748E6BEB766695B233A7150DD865DBE180BEB2018F8D8CA4861C929B28A6F677F79EB57AE96B9D3A0776B615F6E6057A6B976D3ABFDB259270E6E214022B141F1087F62E97EE93195270C1F32A37C70D8751DFC308,0x01),(28,19632,0x34333538373539353430383436373436313633373431303736373837303037303335393233333534393930373638303131343733383433373736333934393235383838343736363432303832313236363031313236303030303034313130353832363138363330303539343333373036323938313536333337343834393334393538343734373436343430383435323038383235373234353834303630,0x00),(29,27039,0x040133E135FBB93D75FBE4D23B9CDC6A0AEE7673290478C303938045641B17A2C7FAB9E08E0F72CFE9F8EBF366D1AFB87C4A764F6A67F5C61ED6EF691F8851E170EAA600B33F74A7793FA8656B992C95F99EAE3DD85500B3AC30B92B87F615A5E981B991A2034197D6B5ECF8255432924865A5B77C0FC2E9C772E1843A8B9BE8D449924359,0x01),(30,27039,0x33313332373236313239323031313737373234393830313530363335383436353937333431313833303338373838353130303238333237383432303033383539343134323932343731373630313530313739393331343737323437393732343239333232383034353134353435333434363537343131303439333936353338313438303735323035393036353933393336383335353533383430343735,0x00),(31,19755,0x0400C6E22C76D2BFB278191610DB62AC87B5BD1EE39C2DA3321BB2597B8FBDFFA398650A027A45331CD680BC6459FE28DB87ACFD9392560C69C1B3FA6AB5A25FCDD1F500DF6382CFA09025BCA2E8A61A6B287FB6BABD858F8FAE8DD1AA23DBC426472282FADC2A18DAAF47ABB8590AAD29164F281EF6693416A87B9A8BFE8DB92D17B5A0E3,0x01),(32,19755,0x36373233303733333834303337393730373338363938353535373133383831303938363634363231313636333436353431353932343031393330313738363934393137303934333033323038313632393534363738323539393930303832333534313037303130303533383134333137393734343432343837353432383231343837343939333639303139383432313337343532393237393433323532,0x00),(33,60710,0x040105819A8F1AD1CA3C548E02DEE5391F1ABACA209AFE87F623DADB62634CDBEB527E1D5EF85686AB9F56F48E9521AA4F02EE7B7E6995C767ED4694981A8753F57C4C00C3FF341EA7A6766AF11D5A23F974BD3F53378DA1ED8E3EAEEA8AC33763D08FFE767F910A71FFA590D374FFBD5EE4984E290DE57A99499374BAB7243EFA940235A7,0x01),(34,60710,0x32343239323533393830353037373536353737353335373039333531343031363532343136333531313833353634333132333535333733363932353638353035313938333430313231343835393631303935393832303234313434303837353134303132313030313038343033393635343830343438383837333330373839383438303631363530333932373736373239373839303436343136333234,0x00),(35,32094,0x04014B10E2C4515023AFF6F6C77EB62A8DBA0D5F5AD7AF5D9EAE1E1805A210160FE41E8F2E36E81CBD7C6379F890ED5238122FC8E1A66B12C3F12AEC17198D4F488BA20064039611EC54648D4BD2B951EA6019C0DA8BAC995E9CB72D7113C63DD8B43F3D9A6E97832C8BBE998BFF4639149DC84D686D79BCB1EC4C5CD2CE150FFFA9F76379,0x01),(36,32094,0x35333334343132313137313639333739313136383931343035323035333733323835323638353935383533383437383038383233333039323030303132313732343730323735383932373135383535313835353238323330313838303433353736333835363436313037323030323833313030373536313433353537333031343434373032353430383037353036393839343233383536393031333433,0x00),(37,46193,0x04004D3325A7E050D86AE785FB67F2E69331A50BFB43D783CDC125B0E649B7BD5F374ABCABA0BF059FC48AAB2403A45444799A585849B0DCF8FC7D301193A11444E4FE012A0B4477AB80F974D1C96C40C4A3934EAD51098E5876E40B06FB6A19CFC36FB73DF1E5424CDECA4303AA533F417939B223CCDCFCF5EAFF05D2592300EF5A3C6942,0x01),(38,46193,0x33383535313234373532343932333632383730393339363637333631393137353336353631313435393330373532303633333837303432383332343131323034313031323437303334393233353035303532343332333039333431343831353238363439383234313738373531343632393032313530323937353632313830383632313537313239363639363534393836393133313839343639323037,0x00),(39,91020,0x04002F7FBE947DB60E11A52807F2E38010D5500E350B434506A26E603DDF2765167FC835AFD2584679E99E7CA96ACD2A305FADEED1B78E2D53D2B8454C7E97E5BDAFC10048BD13F3FC383CA28323C129BCE257A36C8AD1DB6622DBBA95AF1F000EDB5D08B952DAB4BFCAB7EDE0E7D6B9E40B125CA87B82F2FB871727E476C5B559F09EC0CC,0x01),(40,91020,0x363533333634333138353836313531383638343732333230343939363537393831373539353138383037333739313339353231313131383834383534343931343330333433323739303639333430363330353937393839383034303533353237393731383236313739323435343530353534393230303634383236393335323939323233393830353435373037353133343637333233393933333439,0x00),(41,91023,0x0400CA6F2E462E80EA5F08BD30779DF242ED7886EC18C498BF1AFE0ADD0C677284FF6816D47AD763875669E23BFA60C1C927CF3BEAF5AFAE9EC904DF6212682B50A22B01147BCBA7894E433711C240AADE5D3F3548F2F160E4C26B1C02CCF70E3FA284A358534400657F24C83481AFB00E4C354FA5A92AD56F0117EB5F12DE0CE2958048D3,0x01),(42,91023,0x33373335393132363330363031353932313538393534353230313835373939373233383037383330313832343930303034313537303633343231343932363134363834393339343935393937363636373931373430313039393530393334333432343233343734343232303530303030353539303230393534313438333735343737383435343533323933343134383835343730323530353833353131,0x00),(43,32237,0x040036EE17366201DD0F316D621A9E9A7EEC650F31FC7AF35608EBD1BF5110416339A6B1731DCE4C517EF50347469CC187FEA1A124BBB74104B08F3A304F2AA074AD9B010FEEC69B623162880777FCCA59D4F37CB3E2F5A022ED598B8BBE5EF558FBE2C1F7797FDE6975CF0BF38A6759544AC74831AD3C7982425F0B780BB8D7847ABB2A8A,0x01),(44,32237,0x32363139313631373239363939333430373831333638303335333032323836303037323733303139313538303132323733343536353930323135353635383433323534353633303538383632393437333338313934323531393235373636393436353734393934393731383033303033323333323331343336333034343237393834313038323834313130363531383632373630303935383730333738,0x00),(45,42695,0x04011EE08F3091A06FBAA3DE1157648033203064328B5A6C42A41892BFC97E0F92538155B1120C7D4CD7E624D0BE344B4361EAC98EFBEA00F1DA212F56A7406FABBD4701451C66167587EB3FF7AFBDA4CEF8E8E1DA94511D9457587BC91EE96E4A356CB5FEC4C23EED574599C4B2E7771A7F4646E3415DB13ADC72047E3DB5021A94BC420C,0x01),(46,42695,0x323338353331333638353634333037373134343130333936343734373132363335383634393831383735353632303133343634343833363535393431303136363039373230323833333334373638343236303330353432353037333935333133343330343030363932383535373330313634393531393539323835353531393533373337383034373431303736383431343539353431363732333536,0x00),(47,91040,0x04014826DC688D1A58544A2B10937BBC85C57D6E546143200AB07B7FF821BE30786E1E28A8B87FB029BC7E8A2C62525FA80968D46010CF685C8448847F1A058E7CDC1F0026F642A2B90017F946B11D6C7021C238E6C423B851F4CF17EE4D77BA9232AF4B8938E0E1AB5ABA4FE48F2AE4ED87BA2BCD5CC0BBC660015E2340BF8EAB6054B39B,0x01),(48,91040,0x35363131393038383432363430323534303538373638303238353633313734383736323533353936383233393038353934383036383231303134373433353637363031383535383832353538373031323631373830323536343731303235303737353035313133323533383735383238323135393932373231333330313830303135383134393133333036363838313934393538323137373334373632,0x00);
			UNLOCK TABLES;