-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy patht_rsakey_config.sql
17 lines (14 loc) · 9.43 KB
/
t_rsakey_config.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `t_rsakey_config`;
CREATE TABLE `t_rsakey_config` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '密钥对id',
`client_public_key` varchar(4096) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT '客户端公钥',
`server_private_key` varchar(4096) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT '服务器私钥',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci COMMENT = '非对称加密密钥' ROW_FORMAT = DYNAMIC;
INSERT INTO `t_rsakey_config` VALUES (2, '-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAz/fyfozlDIDWG9e3Lb29\n+7j3c66wvUJBaBWP10rB9HTE6prjfcGMqC9imr6zAdD9q+Gr1j7egvqgi3Da+VBA\nMFH92/5wD5PsD7dX8Z2f4o65Vk2nVOY8Dl75Z/uRhg0Euwnfrved69z9LG6utmly\nv6YUPAflXh/JFw7Dq6c4EGeR+KejFTwmVhEdzPGHjXhFmsVt9HdXRYSf4NxHPzOw\nj8tiSaOQA0jC4E4mM7rvGSH5GX6hma+7pJnl/5+rEVM0mSQvm0m1XefmuFy040bE\nZ/6O7ZenOGBsvvwuG3TT4FNDNzW8Dw9ExH1l6NoRGaVkDdtrl/nFu5+a09Pm/E0E\nlwIDAQAB\n-----END PUBLIC KEY-----', '-----BEGIN RSA PRIVATE KEY-----\nMIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQDFtvHabV94fKtD\nuM/7ya0MX+nJguslYpYB0S/fBms62M5nN4sY/OyaRyCdyChGFfh1P7WK1IxH2P2b\nT87CwfZSgXpTfYvEI5BZAPUAyAhmMCQl4m8VOu2fx8xDXvTUKRtotNUiNEyVPDyQ\n1e80D8D1Rq2iIOaLhMUbqavFMpmkhxMie88SmQrYDtCynUTiyQUryObKzLu5GExp\nge09OwG/E/TOfeWEoHdb4dOqmd57BdYeMIN8vs1tvL3WNvPkQo9ldYu6Fci9HUK7\ni2Ku6ivBcnGZdo/UdBmifK0QI1T9Q7M/oY0t2rR4UMThvThaOnf3rnnUb31iIU/a\neodUnk4xAgMBAAECggEBAMR5hmGPKr5q9S55K4WE5ohTj9mGVfJyw6rOnAm/MTPr\nW0FK+tk8DktJv2nMC+mJz7uEMf3iNfz37x0187uqUAOxU0RAkHG6/ajUwKOkJGSY\nFnPnTogEZTrQq3WPmTB0IR6uBNbWrfvnPjCXx/suZIvZTpa8px2iNNXGiEGQhQnu\nyG2aa6QOLZicx97pP/Ym5cMMvyu8hyd+vkQwKA9Cz7Et4sQasgl2lTLWIhhlivO+\nuknB/0QkvcPR7uOSlu8BBnwQX1iESLMmE6Z3NOpbg+BbbJRodh3erlCOIgvLsAL6\ng5ihNmWfdF+M87GX5tiN4w5aWqSC2k9CQATgjrjDxFkCgYEA8tHjikSSZN18ggXx\nm3MGJV8Nnb1tP3onQJZcZXOnzHptK7knmOWzuw/wMRyMZnq8ewsY6+Rw3HNydHeX\n/kc7PpMi69W5SbfpvWMeW2rXFlK2MZ4pmzWKGElK7aUgD5OsrwUJGcoBEnS6CFcY\n1kUi2B4zbfRKCOnZEvghJcnvbhcCgYEA0HJLZHA2lRi+QJJkdIWdAz+OrWOV3HD7\nSniMAalYuKURoD/zFZSdmucKs8UX+32WWlt1NH90Ijye0gwDLZ0fghQfJgpRqHId\nLMIBQ0qlLSzjfeSfmHL20a+fuPK44nh2T0WjU8hkzup/OaR0IFtfc0XZManM69tg\nYkccLeyxWvcCgYEA0ckOik32INjOklNqS0BURgNaczbOZTI3KXD+wNPsXBhFq6nb\nERkbb/k0LmoYzw0pPDD5Rgxmib/gWcldct29zLE4UYKkA5G2it5QwvCKhYnOSQ35\nqlPWTGc+KhUonuyaG9gA5dwFkxlwBHajSbQPh6KIEm4lbJAE8IOZt9lAV98CgYEA\nqlyvh7A6vBLT87xyA9XsJOp+NvIMWnWwvAXYD8eTrp2i0UFS8FFdmmu4kILGfhH/\nn2veWADPLugyueN9eXtQdCTz7EhEwxI5DAqns5K/ezOT3qHLWnKjjW8ncKZYOyhP\nMazttx0yXvbC8p6ZFpT3ZyQwRmnMBPxwQwJxYotvzLMCgYAyJsbwjIdKjsInPzb7\ntQeb3yM06WDqzvcISOnRb/4UvjkprswX+WnG1Hd5KbGW2/C+NCi2LdXhBuiq1zYg\n8K34S1qlMztajjXCUsJYI3Hi7bmlk8f9zyDXJD468f7E5gb5J473w+HD/x3chF9H\nzdqqKxAe/m6mjZGjPOjQqHc6wQ==\n-----END RSA PRIVATE KEY-----');
INSERT INTO `t_rsakey_config` VALUES (3, '-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA02M1I1V/YvxANOvLFX8R\n7D8At40IlT7HDWpAW3t+tAgQ7sqjCeYOxiXqOaaw2kJhM3HT5nZll48UmykVq45Q\n05J57nhdSsGXLJshtLcTg9liMEoW61BjVZi9EPPRSnE05tBJc57iqZw+aEcaSU0a\nwfzBc8IkRd6+pJ5iIgEVfuTluanizhHWvRli3EkAF4VNhaTfP3EkYfr4NE899aUe\nScbbdLFI6u1XQudlJCPTxaISx5ZcwM+nP3v242ABcjgUcfCbz0AY547WazK4bWP3\nqicyxo4MoLOoe9WBq6EuG4CuZQrzKnq8ltSxud/6chdg8Mqp/IasEQ2TpvY78tEX\nDQIDAQAB\n-----END PUBLIC KEY-----', '-----BEGIN RSA PRIVATE KEY-----\nMIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQDFtvHabV94fKtD\nuM/7ya0MX+nJguslYpYB0S/fBms62M5nN4sY/OyaRyCdyChGFfh1P7WK1IxH2P2b\nT87CwfZSgXpTfYvEI5BZAPUAyAhmMCQl4m8VOu2fx8xDXvTUKRtotNUiNEyVPDyQ\n1e80D8D1Rq2iIOaLhMUbqavFMpmkhxMie88SmQrYDtCynUTiyQUryObKzLu5GExp\nge09OwG/E/TOfeWEoHdb4dOqmd57BdYeMIN8vs1tvL3WNvPkQo9ldYu6Fci9HUK7\ni2Ku6ivBcnGZdo/UdBmifK0QI1T9Q7M/oY0t2rR4UMThvThaOnf3rnnUb31iIU/a\neodUnk4xAgMBAAECggEBAMR5hmGPKr5q9S55K4WE5ohTj9mGVfJyw6rOnAm/MTPr\nW0FK+tk8DktJv2nMC+mJz7uEMf3iNfz37x0187uqUAOxU0RAkHG6/ajUwKOkJGSY\nFnPnTogEZTrQq3WPmTB0IR6uBNbWrfvnPjCXx/suZIvZTpa8px2iNNXGiEGQhQnu\nyG2aa6QOLZicx97pP/Ym5cMMvyu8hyd+vkQwKA9Cz7Et4sQasgl2lTLWIhhlivO+\nuknB/0QkvcPR7uOSlu8BBnwQX1iESLMmE6Z3NOpbg+BbbJRodh3erlCOIgvLsAL6\ng5ihNmWfdF+M87GX5tiN4w5aWqSC2k9CQATgjrjDxFkCgYEA8tHjikSSZN18ggXx\nm3MGJV8Nnb1tP3onQJZcZXOnzHptK7knmOWzuw/wMRyMZnq8ewsY6+Rw3HNydHeX\n/kc7PpMi69W5SbfpvWMeW2rXFlK2MZ4pmzWKGElK7aUgD5OsrwUJGcoBEnS6CFcY\n1kUi2B4zbfRKCOnZEvghJcnvbhcCgYEA0HJLZHA2lRi+QJJkdIWdAz+OrWOV3HD7\nSniMAalYuKURoD/zFZSdmucKs8UX+32WWlt1NH90Ijye0gwDLZ0fghQfJgpRqHId\nLMIBQ0qlLSzjfeSfmHL20a+fuPK44nh2T0WjU8hkzup/OaR0IFtfc0XZManM69tg\nYkccLeyxWvcCgYEA0ckOik32INjOklNqS0BURgNaczbOZTI3KXD+wNPsXBhFq6nb\nERkbb/k0LmoYzw0pPDD5Rgxmib/gWcldct29zLE4UYKkA5G2it5QwvCKhYnOSQ35\nqlPWTGc+KhUonuyaG9gA5dwFkxlwBHajSbQPh6KIEm4lbJAE8IOZt9lAV98CgYEA\nqlyvh7A6vBLT87xyA9XsJOp+NvIMWnWwvAXYD8eTrp2i0UFS8FFdmmu4kILGfhH/\nn2veWADPLugyueN9eXtQdCTz7EhEwxI5DAqns5K/ezOT3qHLWnKjjW8ncKZYOyhP\nMazttx0yXvbC8p6ZFpT3ZyQwRmnMBPxwQwJxYotvzLMCgYAyJsbwjIdKjsInPzb7\ntQeb3yM06WDqzvcISOnRb/4UvjkprswX+WnG1Hd5KbGW2/C+NCi2LdXhBuiq1zYg\n8K34S1qlMztajjXCUsJYI3Hi7bmlk8f9zyDXJD468f7E5gb5J473w+HD/x3chF9H\nzdqqKxAe/m6mjZGjPOjQqHc6wQ==\n-----END RSA PRIVATE KEY-----');
INSERT INTO `t_rsakey_config` VALUES (4, '-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyaxqjPJP5+Innfv5IdfQ\nqY/ftS++lnDRe3EczNkIjESWXhHSOljEw9b9C+/BtF+fO9QZL7Z742y06eIdvsMP\nQKdGflB26+9OZ8AF4SpXDn3aVWGr8+9qpB7BELRZI/Ph2FlFL4cobCzMHunncW8z\nTfMId48+fgHkAzCjRl5rC6XT0Yge6+eKpXmF+hr0vGYWiTzqPzTABl44WZo3rw0y\nurZTzkrmRE4kR2VzkjY/rBnQAbFKKFUKsUozjCXvSag4l461wDkhmmyivpNkK5cA\nxuDbsmC39iqagMt9438fajLVvYOvpVs9ci5tiLcbBtfB4Rf/QVAkqtTm86Z0O3e7\nDwIDAQAB\n-----END PUBLIC KEY-----', '-----BEGIN RSA PRIVATE KEY-----\nMIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQDFtvHabV94fKtD\nuM/7ya0MX+nJguslYpYB0S/fBms62M5nN4sY/OyaRyCdyChGFfh1P7WK1IxH2P2b\nT87CwfZSgXpTfYvEI5BZAPUAyAhmMCQl4m8VOu2fx8xDXvTUKRtotNUiNEyVPDyQ\n1e80D8D1Rq2iIOaLhMUbqavFMpmkhxMie88SmQrYDtCynUTiyQUryObKzLu5GExp\nge09OwG/E/TOfeWEoHdb4dOqmd57BdYeMIN8vs1tvL3WNvPkQo9ldYu6Fci9HUK7\ni2Ku6ivBcnGZdo/UdBmifK0QI1T9Q7M/oY0t2rR4UMThvThaOnf3rnnUb31iIU/a\neodUnk4xAgMBAAECggEBAMR5hmGPKr5q9S55K4WE5ohTj9mGVfJyw6rOnAm/MTPr\nW0FK+tk8DktJv2nMC+mJz7uEMf3iNfz37x0187uqUAOxU0RAkHG6/ajUwKOkJGSY\nFnPnTogEZTrQq3WPmTB0IR6uBNbWrfvnPjCXx/suZIvZTpa8px2iNNXGiEGQhQnu\nyG2aa6QOLZicx97pP/Ym5cMMvyu8hyd+vkQwKA9Cz7Et4sQasgl2lTLWIhhlivO+\nuknB/0QkvcPR7uOSlu8BBnwQX1iESLMmE6Z3NOpbg+BbbJRodh3erlCOIgvLsAL6\ng5ihNmWfdF+M87GX5tiN4w5aWqSC2k9CQATgjrjDxFkCgYEA8tHjikSSZN18ggXx\nm3MGJV8Nnb1tP3onQJZcZXOnzHptK7knmOWzuw/wMRyMZnq8ewsY6+Rw3HNydHeX\n/kc7PpMi69W5SbfpvWMeW2rXFlK2MZ4pmzWKGElK7aUgD5OsrwUJGcoBEnS6CFcY\n1kUi2B4zbfRKCOnZEvghJcnvbhcCgYEA0HJLZHA2lRi+QJJkdIWdAz+OrWOV3HD7\nSniMAalYuKURoD/zFZSdmucKs8UX+32WWlt1NH90Ijye0gwDLZ0fghQfJgpRqHId\nLMIBQ0qlLSzjfeSfmHL20a+fuPK44nh2T0WjU8hkzup/OaR0IFtfc0XZManM69tg\nYkccLeyxWvcCgYEA0ckOik32INjOklNqS0BURgNaczbOZTI3KXD+wNPsXBhFq6nb\nERkbb/k0LmoYzw0pPDD5Rgxmib/gWcldct29zLE4UYKkA5G2it5QwvCKhYnOSQ35\nqlPWTGc+KhUonuyaG9gA5dwFkxlwBHajSbQPh6KIEm4lbJAE8IOZt9lAV98CgYEA\nqlyvh7A6vBLT87xyA9XsJOp+NvIMWnWwvAXYD8eTrp2i0UFS8FFdmmu4kILGfhH/\nn2veWADPLugyueN9eXtQdCTz7EhEwxI5DAqns5K/ezOT3qHLWnKjjW8ncKZYOyhP\nMazttx0yXvbC8p6ZFpT3ZyQwRmnMBPxwQwJxYotvzLMCgYAyJsbwjIdKjsInPzb7\ntQeb3yM06WDqzvcISOnRb/4UvjkprswX+WnG1Hd5KbGW2/C+NCi2LdXhBuiq1zYg\n8K34S1qlMztajjXCUsJYI3Hi7bmlk8f9zyDXJD468f7E5gb5J473w+HD/x3chF9H\nzdqqKxAe/m6mjZGjPOjQqHc6wQ==\n-----END RSA PRIVATE KEY-----');
INSERT INTO `t_rsakey_config` VALUES (5, '-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsJbFp3WcsiojjdQtVnTu\nvtawL2m4XxK93F6lCnFwcZqUP39txFGGlrogHMqreyawIUN7E5shtwGzigzjW8Ly\n5CryBJpXP3ehNTqJS7emb+9LlC19Oxa1eQuUQnatgcsd16DPH7kJ5JzN3vXnhvUy\nk4Qficdmm0uk7FRaNYFi7EJs4xyqFTrp3rDZ0dzBHumlIeK1om7FNt6Nyivgp+Uy\nbO7kl0NLFEeSlV4S+7ofitWQsO5xYqKAzSzz+KIRQcxJidGBlZ1JN/g5DPDpx/zt\nvOWYUlM7TYk6xN3focZpU0kBzAw/rn94yW9z8jpXfzk+MvWzVL/HAcPy4ySwkay0\nNwIDAQAB\n-----END PUBLIC KEY-----', '-----BEGIN RSA PRIVATE KEY-----\nMIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQDFtvHabV94fKtD\nuM/7ya0MX+nJguslYpYB0S/fBms62M5nN4sY/OyaRyCdyChGFfh1P7WK1IxH2P2b\nT87CwfZSgXpTfYvEI5BZAPUAyAhmMCQl4m8VOu2fx8xDXvTUKRtotNUiNEyVPDyQ\n1e80D8D1Rq2iIOaLhMUbqavFMpmkhxMie88SmQrYDtCynUTiyQUryObKzLu5GExp\nge09OwG/E/TOfeWEoHdb4dOqmd57BdYeMIN8vs1tvL3WNvPkQo9ldYu6Fci9HUK7\ni2Ku6ivBcnGZdo/UdBmifK0QI1T9Q7M/oY0t2rR4UMThvThaOnf3rnnUb31iIU/a\neodUnk4xAgMBAAECggEBAMR5hmGPKr5q9S55K4WE5ohTj9mGVfJyw6rOnAm/MTPr\nW0FK+tk8DktJv2nMC+mJz7uEMf3iNfz37x0187uqUAOxU0RAkHG6/ajUwKOkJGSY\nFnPnTogEZTrQq3WPmTB0IR6uBNbWrfvnPjCXx/suZIvZTpa8px2iNNXGiEGQhQnu\nyG2aa6QOLZicx97pP/Ym5cMMvyu8hyd+vkQwKA9Cz7Et4sQasgl2lTLWIhhlivO+\nuknB/0QkvcPR7uOSlu8BBnwQX1iESLMmE6Z3NOpbg+BbbJRodh3erlCOIgvLsAL6\ng5ihNmWfdF+M87GX5tiN4w5aWqSC2k9CQATgjrjDxFkCgYEA8tHjikSSZN18ggXx\nm3MGJV8Nnb1tP3onQJZcZXOnzHptK7knmOWzuw/wMRyMZnq8ewsY6+Rw3HNydHeX\n/kc7PpMi69W5SbfpvWMeW2rXFlK2MZ4pmzWKGElK7aUgD5OsrwUJGcoBEnS6CFcY\n1kUi2B4zbfRKCOnZEvghJcnvbhcCgYEA0HJLZHA2lRi+QJJkdIWdAz+OrWOV3HD7\nSniMAalYuKURoD/zFZSdmucKs8UX+32WWlt1NH90Ijye0gwDLZ0fghQfJgpRqHId\nLMIBQ0qlLSzjfeSfmHL20a+fuPK44nh2T0WjU8hkzup/OaR0IFtfc0XZManM69tg\nYkccLeyxWvcCgYEA0ckOik32INjOklNqS0BURgNaczbOZTI3KXD+wNPsXBhFq6nb\nERkbb/k0LmoYzw0pPDD5Rgxmib/gWcldct29zLE4UYKkA5G2it5QwvCKhYnOSQ35\nqlPWTGc+KhUonuyaG9gA5dwFkxlwBHajSbQPh6KIEm4lbJAE8IOZt9lAV98CgYEA\nqlyvh7A6vBLT87xyA9XsJOp+NvIMWnWwvAXYD8eTrp2i0UFS8FFdmmu4kILGfhH/\nn2veWADPLugyueN9eXtQdCTz7EhEwxI5DAqns5K/ezOT3qHLWnKjjW8ncKZYOyhP\nMazttx0yXvbC8p6ZFpT3ZyQwRmnMBPxwQwJxYotvzLMCgYAyJsbwjIdKjsInPzb7\ntQeb3yM06WDqzvcISOnRb/4UvjkprswX+WnG1Hd5KbGW2/C+NCi2LdXhBuiq1zYg\n8K34S1qlMztajjXCUsJYI3Hi7bmlk8f9zyDXJD468f7E5gb5J473w+HD/x3chF9H\nzdqqKxAe/m6mjZGjPOjQqHc6wQ==\n-----END RSA PRIVATE KEY-----');
SET FOREIGN_KEY_CHECKS = 1;