API tools faq
paste
Joker0day

atosresearch

Joker0day
Dec 14th, 2017
600
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.70 KB | None | 0 0
raw download clone embed print report
  1. /*
  2.  
  3.  
  4. SET NAMES 'utf8' COLLATE 'utf8_general_ci';
  5.  
  6. DROP TABLE IF EXISTS `vehicleowner`;
  7. CREATE TABLE `vehicleowner` (
  8. `_id` VARBINARY(12) NOT NULL,
  9. `aggregationServiceDataClearance` BIT,
  10. `cloudStorageProvider` VARBINARY(12),
  11. `cloudVaultId` LONGTEXT,
  12. `createdAt` DATETIME,
  13. `discoveryClearance` BIT,
  14. `email` LONGTEXT,
  15. `name` LONGTEXT,
  16. `readAccessKey` LONGTEXT,
  17. `testDataClearance` BIT,
  18. `updatedAt` DATETIME,
  19. PRIMARY KEY (`_id`)
  20. ) CHARSET=utf8;
  21.  
  22. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  23. VALUES
  24. (x'587F41061B6BD0800E1087DA', FALSE, x'587F40E81B6BD0800E10875A', '8adc52ca-3d9c-404d-9435-229cc5a59afe', '2017-01-18 10:18:46.420000', TRUE, '[email protected]', 'rt65', '49e60393-8f8a-4e57-b337-809d93efb7d7', FALSE, '2017-09-25 10:16:55.297000');
  25. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  26. VALUES
  27. (x'587F41131B6BD0800E1095D3', FALSE, x'587F40E81B6BD0800E10875A', '941b460c-2351-472e-b92d-6be89e7e228f', '2017-01-18 10:18:59.174000', TRUE, '[email protected]', 'c2eTestUser_A', '36756fbb-c5b0-4433-b477-03739abced44', FALSE, '2017-07-17 08:52:13.646000');
  28. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  29. VALUES
  30. (x'58E39C4044E38E3867A43CEB', FALSE, x'587F40E81B6BD0800E10875A', 'fb9d75d7-ccd5-4866-98ca-b5f28e666190', '2017-04-04 13:14:40.741000', TRUE, '[email protected]', 'SampleDataRSA', '00bb4849-8506-4241-b576-61583eb5b2ff', FALSE, '2017-09-21 12:41:55.139000');
  31. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  32. VALUES
  33. (x'59B8F51F90E1C33D00973BAD', FALSE, x'587F40E81B6BD0800E10875A', '867918c8-8b88-41c6-842d-e6d44cf7a552', '2017-09-13 09:06:39.924000', TRUE, '[email protected]', 'calvoad_atos', '2ef249ac-bf55-4272-a0fd-b93e963ed8f9', FALSE, '2017-09-13 09:06:39.924000');
  34. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  35. VALUES
  36. (x'59B8F58C90E1C33D00973BAE', FALSE, x'587F40E81B6BD0800E10875A', '1d0a907a-e5fc-41e0-82f7-c5c0fd6bcbcd', '2017-09-13 09:08:28.941000', TRUE, '[email protected]', 'calvoad', 'edf10615-f374-42b8-b72b-89f30f846a3e', FALSE, '2017-09-13 09:08:28.941000');
  37. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  38. VALUES
  39. (x'59C8AC48C7F22519002E51AA', FALSE, x'587F40E81B6BD0800E10875A', '5281414c-b176-41a7-9309-13cdfd0f4472', '2017-09-25 07:12:08.128000', TRUE, '[email protected]', 'c2eTestUser_KU', 'ad62695c-c7e4-4757-92eb-2ed36a3eae5b', FALSE, '2017-09-25 07:12:08.128000');
  40. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  41. VALUES
  42. (x'59C8AC7AC7F22519002E51AB', FALSE, x'587F40E81B6BD0800E10875A', 'fa78cd01-e6f0-4449-9924-5a3877926c92', '2017-09-25 07:12:58.414000', TRUE, '[email protected]', 'c2eTestUser_H', 'e7c6b0f3-8621-49dd-9576-d6526d5bdd12', FALSE, '2017-09-25 07:12:58.414000');
  43. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  44. VALUES
  45. (x'59C8ACA0C7F22519002E51AC', FALSE, x'587F40E81B6BD0800E10875A', '1a0041cc-b29e-4f6c-8226-10ee8288d9cf', '2017-09-25 07:13:36.775000', TRUE, '[email protected]', 'c2eTestUser_SA2', '195bef40-6552-4c6a-867c-48111868b79a', FALSE, '2017-09-25 07:13:36.775000');
  46. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  47. VALUES
  48. (x'59C8ACC1C7F22519002E51AD', FALSE, x'587F40E81B6BD0800E10875A', '4e1a6ea5-60c1-4304-9df3-4dc9f8ec9fb3', '2017-09-25 07:14:09.695000', TRUE, '[email protected]', 'c2eTestUser_K', '3cc9fd13-9e57-4f67-923a-743854ade80d', FALSE, '2017-09-25 07:14:09.695000');
  49. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  50. VALUES
  51. (x'59C8ACE4C7F22519002E51AE', FALSE, x'587F40E81B6BD0800E10875A', '82eb167b-89a7-4f6a-b2f1-da68bb1083ac', '2017-09-25 07:14:44.456000', TRUE, '[email protected]', 'c2eTest4CVIM_1', 'cc1ac8df-0fae-4dbd-82ad-63d8131a4e9c', FALSE, '2017-09-25 07:14:44.456000');
  52. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  53. VALUES
  54. (x'59C8AD06C7F22519002E51AF', FALSE, x'587F40E81B6BD0800E10875A', '6d96aefa-39e9-4f0b-bcf7-d125d90adf65', '2017-09-25 07:15:18.775000', TRUE, '[email protected]', 'c2eTest4CVIM_2', '2c262782-f905-4f33-a754-a93f363a1b7e', FALSE, '2017-09-25 07:15:18.775000');
  55. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  56. VALUES
  57. (x'59C8AD27C7F22519002E51B0', FALSE, x'587F40E81B6BD0800E10875A', '4afe345b-abef-4d4a-aad0-a2a35994b444', '2017-09-25 07:15:51.572000', TRUE, '[email protected]', 'c2eTest4CVIM_3', '92f1ed1f-8fe8-4535-9f84-4a9c6445c1fc', FALSE, '2017-09-25 07:15:51.572000');
  58. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  59. VALUES
  60. (x'59C8AD4EC7F22519002E51B1', FALSE, x'587F40E81B6BD0800E10875A', 'a0787cf8-ce84-49ae-b5d5-4371a7a2b528', '2017-09-25 07:16:30.540000', TRUE, '[email protected]', 'Predictive4CVIM_1', 'f07119df-55ef-4bab-8ef9-90125005c6a1', FALSE, '2017-09-25 07:16:30.540000');
  61. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  62. VALUES
  63. (x'59C8AE4DC7F22519002E51B2', FALSE, x'587F40E81B6BD0800E10875A', '9694a097-1b7b-418b-ab16-5611e77712c8', '2017-09-25 07:20:45.433000', TRUE, '[email protected]', 'RSA27952AV', '0869cca6-8e8f-44fd-8785-acc8e7754490', FALSE, '2017-09-25 07:20:45.433000');
  64. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  65. VALUES
  66. (x'59C8AE6EC7F22519002E51B3', FALSE, x'587F40E81B6BD0800E10875A', 'a1d4a357-772d-43bf-af9e-04e4339f84f0', '2017-09-25 07:21:18.511000', TRUE, '[email protected]', 'RSA14273JJD', 'f31f4c6c-5d61-49d1-8840-c4ada033b209', FALSE, '2017-09-25 07:21:18.511000');
  67. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  68. VALUES
  69. (x'59C8AE8FC7F22519002E51B4', FALSE, x'587F40E81B6BD0800E10875A', 'c75b46be-2bbd-41dd-88a4-d1ae516292d0', '2017-09-25 07:21:51.038000', TRUE, '[email protected]', 'RSA06543XS', 'c8b9628b-b21f-43cf-a5ef-c70f1d1b88b5', FALSE, '2017-09-25 07:21:51.038000');
  70. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  71. VALUES
  72. (x'59C8AEB2C7F22519002E51B5', FALSE, x'587F40E81B6BD0800E10875A', '12b42bae-d800-44b1-a2f9-6fc151166904', '2017-09-25 07:22:26.572000', TRUE, '[email protected]', 'RSA11154EJ', '522d5616-8906-4692-95f0-8b9e501cbc75', FALSE, '2017-09-25 07:22:26.572000');
  73. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  74. VALUES
  75. (x'59C8AED1C7F22519002E51B6', FALSE, x'587F40E81B6BD0800E10875A', 'f9fc9e99-c4d6-4a36-82f7-e7fbc034dd0a', '2017-09-25 07:22:57.965000', TRUE, '[email protected]', 'RSA06683FC', '9f92a947-f530-4b8c-b830-cfedce28f60c', FALSE, '2017-09-25 07:22:57.965000');
  76. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  77. VALUES
  78. (x'59C8AEEFC7F22519002E51B7', FALSE, x'587F40E81B6BD0800E10875A', '7477a499-0a14-4f09-8545-3edec2218f8c', '2017-09-25 07:23:27.079000', TRUE, '[email protected]', 'RSA16799JMD', '9b15f6b5-4ba5-40a0-9ea7-19cfa3e6f2ea', FALSE, '2017-09-25 07:23:27.079000');
  79. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  80. VALUES
  81. (x'59C8AF0DC7F22519002E51B8', FALSE, x'587F40E81B6BD0800E10875A', 'c1804aeb-b411-4d4e-b0c4-f609defe7fe2', '2017-09-25 07:23:57.460000', TRUE, '[email protected]', 'RSA11535SB', '34fd2673-6bfa-40ca-a18a-e0a994dd43ad', FALSE, '2017-09-25 07:23:57.460000');
  82. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  83. VALUES
  84. (x'59C8AF33C7F22519002E51B9', FALSE, x'587F40E81B6BD0800E10875A', '27f6c515-814e-4c8c-b6e6-4bf24935e132', '2017-09-25 07:24:35.840000', TRUE, '[email protected]', 'RSA44346LP', 'c6f5a963-8b09-40cf-82a0-61ec8eb04209', FALSE, '2017-09-25 07:24:35.840000');
  85. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  86. VALUES
  87. (x'59C8AF6CC7F22519002E51BA', FALSE, x'587F40E81B6BD0800E10875A', '561ab419-6767-4bb7-8a1b-e3f3efee7bf5', '2017-09-25 07:25:32.877000', TRUE, '[email protected]', 'RSA Dawn', '9db5d995-1860-4f48-8f7f-bec9230a839e', FALSE, '2017-09-25 07:25:32.877000');
  88. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  89. VALUES
  90. (x'59C8AFA3C7F22519002E51BB', FALSE, x'587F40E81B6BD0800E10875A', '029442a4-bebc-4270-9999-b747bc55e4e8', '2017-09-25 07:26:27.529000', TRUE, '[email protected]', 'us01', 'cb438c33-9642-4d59-b2f7-c737dbf0acaf', FALSE, '2017-09-25 07:26:27.529000');
  91. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  92. VALUES
  93. (x'59C8AFB6C7F22519002E51BC', FALSE, x'587F40E81B6BD0800E10875A', '146f6e8e-8f5a-4d39-9429-3b8cff13d548', '2017-09-25 07:26:46.856000', TRUE, '[email protected]', 'us02', '01c7ee3d-6253-4d0e-83ef-67418eb565d6', FALSE, '2017-09-25 07:26:46.856000');
  94. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  95. VALUES
  96. (x'59C8AFCDC7F22519002E51BD', FALSE, x'587F40E81B6BD0800E10875A', '41d009b8-dc03-441c-ab73-6ceb9524f716', '2017-09-25 07:27:09.468000', TRUE, '[email protected]', 'us06', '9cd1c246-6e83-4460-893b-a7052927fe6a', FALSE, '2017-09-25 07:27:09.468000');
  97. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  98. VALUES
  99. (x'59E60177E5809235004FB26C', FALSE, x'587F40E81B6BD0800E10875A', 'f46b3965-bf1a-4b41-be62-6ecd3ba179e9', '2017-10-17 13:11:19.163000', TRUE, '[email protected]', 'c2e_HT026', '53cde805-6d79-482e-a8c0-b5b0f6be0883', FALSE, '2017-10-17 13:11:19.163000');
  100. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  101. VALUES
  102. (x'59E601A0E5809235004FB26D', FALSE, x'587F40E81B6BD0800E10875A', '431893c3-79dc-4258-9c13-bf5d6d0b73b5', '2017-10-17 13:12:00.258000', TRUE, '[email protected]', 'c2e_HT096', '45eaf06e-04b0-4c69-8aea-955cb3de9df7', FALSE, '2017-10-17 13:12:00.258000');
  103. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  104. VALUES
  105. (x'5A0AFCDE5384FB1D0005B656', FALSE, x'587F40E81B6BD0800E10875A', 'dde324ce-8121-4804-958f-ae11498a52c8', '2017-11-27 08:00:19.622000', TRUE, '[email protected]', 'SampleDataVW', '5294415a-dfbb-4058-98ca-4f321c8b0f40', FALSE, '2017-11-27 08:00:19.622000');
  106. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  107. VALUES
  108. (x'5A1BD9658924B41D00642A20', TRUE, x'587F40E81B6BD0800E10875A', 'efdaeb4a-aa31-4152-9c32-e0a096250a4b', '2017-11-27 09:22:45.770000', TRUE, '[email protected]', 'simulation01', '175bdb30-5f08-4715-8a81-412566eacca4', TRUE, '2017-11-27 09:22:45.770000');
  109. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  110. VALUES
  111. (x'5A1BD9668924B41D00642A21', TRUE, x'587F40E81B6BD0800E10875A', 'e44a1f3c-9c20-40a1-8f9f-aa952b6f5cfc', '2017-11-27 09:22:46.360000', TRUE, '[email protected]', 'simulation02', '976f5145-9d49-486c-948e-2c869ee825e0', TRUE, '2017-11-27 09:22:46.360000');
  112. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  113. VALUES
  114. (x'5A1BD9668924B41D00642A22', TRUE, x'587F40E81B6BD0800E10875A', 'c196f409-c4a6-41ad-9adc-902646e0229f', '2017-11-27 09:22:46.918000', TRUE, '[email protected]', 'simulation03', 'ca97b400-39d8-4d0a-b8bc-9ed3f9cd93df', TRUE, '2017-11-27 09:22:46.918000');
  115. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  116. VALUES
  117. (x'5A1BD9678924B41D00642A23', TRUE, x'587F40E81B6BD0800E10875A', '0618b188-3ff5-4774-845f-53a9b50d8133', '2017-11-27 09:22:47.390000', TRUE, '[email protected]', 'simulation04', '4912e5a2-cb45-486c-a7bd-d5d0dab77b9c', TRUE, '2017-11-27 09:22:47.390000');
  118. INSERT INTO `vehicleowner` (`_id`, `aggregationServiceDataClearance`, `cloudStorageProvider`, `cloudVaultId`, `createdAt`, `discoveryClearance`, `email`, `name`, `readAccessKey`, `testDataClearance`, `updatedAt`)
  119. VALUES
  120. (x'5A1BEF9E87DF771E00A8D823', FALSE, x'587F40E81B6BD0800E10875A', '7b2cc3e6-495d-4c9d-b6e8-159c36d146c0', '2017-11-27 10:57:34.294000', TRUE, '[email protected]', 'eh', 'bfe9164a-eb92-49d1-9461-351a9e4c2abb', FALSE, '2017-11-27 10:57:34.294000');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!