Skip to content

Instantly share code, notes, and snippets.

@s4parke

s4parke/truncate-participant-data.sql

Last active August 21, 2018 18:16
Show Gist options
  • Save s4parke/5561dd0178d9966dbcd0669bcc289fd5 to your computer and use it in GitHub Desktop.
Save s4parke/5561dd0178d9966dbcd0669bcc289fd5 to your computer and use it in GitHub Desktop.
Download ZIP
Clear out participant data from old SHUTi codebase site
Raw
truncate-participant-data.sql
-- USE shuti_private_production;
UPDATE participant_private_data SET
participant_id = 999999,
prop_value_binary = 1,
prop_value_boolean = 1,
prop_value_integer = 999999,
prop_key = 'Zxd2lcwZUPDy1Aqv3dQpjOIhqOxqVJeBsy307mjijZ5gD9LHNB0N7GZoXfRTiN3JSDvOpjyu0k7UVm6Fr6k4m9I8kbAg23E3emZ0VitX3Cy46RJ01h0Pw6H07SH5skumig60p5PNolR2HUklD4eBVXqCXCSsodQbaHGjgUaIz1Z8ydRvURo3gzGKvSG48keEivOgPFV8',
prop_value = '1DqGViFRX8fHWRcD7Q4Rjjzinvf1pgWqXSM8o3DBkFxYrNOqjqUcUwNBPH33q03xpTbjbAOYgwnTiEgx5WWOk5QukDVKW8p5PQ9WOrzXZMnoZ3EFINWsp5XB88sz91N6a8P59aH4M5jIewOqfuJMybH2uKIe0nIcaDeapuQMRYigo33uUpR8rRhAj4FNxUlf2PLYjEerw9pTyMGeSmSN7lsteR2hYw3RzR25VEC2TxgkK3uDeT6BBFDfpq',
prop_value_text = 'fFiii6z9r071aNawt95XKfD9g8t6AyeYxGTzRkULiTz8zn9GL0NcFEyltwNplprNpGfKHNZ8yNqoZIo2JsaP6OnhmOb7hXij7z1YKqtheABKtsZ6NHiFSpEpLVqfnNiDAimo1PZXbejen2SnAMEfGtXrFD7W9oXswMIH19vONAe4LlrhfstaKUaGT7soeMAl8Kmaqe63uUttEOGn3W7jIY1L7YsYlSFam7rrXfTxkNBpBkkW6muyUES3mMKA8zwTARV4BuRoBJOFQZ7Rc98ngq4FqVahu16EVWUN5WKui8Kzq0bCzA8UIzq9Mp87tS9q0r0AruEKMaay1Pve8Hb0w9xeSkpxrFJvh7IXHGCY52AHxpP14YCExmuKLs8Q38TkypCvCVFcwyADRbv2DzxKbNZJzoVbM6JJPGaIVwhSAsF0Tgfm5pRJaWazvOglqxxOhgDe1IN3DxqGPuLfyUrNgWXSx1HkZceuYak5yuQmRDkeDU1BZGGgTEPQGOYuWQNhRBZQjoGH3SyEpgfFiii6z9r071aNawt95XKfD9g8t6AyeYxGTzRkULiTz8zn9GL0NcFEyltwNplprNpGfKHNZ8yNqoZIo2JsaP6OnhmOb7hXij7z1YKqtheABKtsZ6NHiFSpEpLVqfnNiDAimo1PZXbejen2SnAMEfGtXrFD7W9oXswMIH19vONAe4LlrhfstaKUaGT7soeMAl8Kmaqe63uUttEOGn3W7jIY1L7YsYlSFam7rrXfTxkNBpBkkW6muyUES3mMKA8zwTARV4BuRoBJOFQZ7Rc98ngq4FqVahu16EVWUN5WKui8Kzq0bCzA8UIzq9Mp87tS9q0r0AruEKMaay1Pve8Hb0w9xeSkpxrFJvh7IXHGCY52AHxpP14YCExmuKLs8Q38TkypCvCVFcwyADRbv2DzxKbNZJzoVbM6JJPGaIVwhSAsF0Tgfm5pRJaWazvOglqxxOhgDe1IN3DxqGPuLfyUrNgWXSx1HkZceuYak5yuQmRDkeDU1BZGGgTEPQGOYuWQNhRBZQjoGH3SyEpgr4jCucBhQ6Ig5bJiFDBWXVKphkg0rarZvoAHB83ZyoNxsYWmfy4RDNS4mjzEfM6Sbw5Y27Y7tozpz7E8ozXevvUmBgUNZNi8kKUjOYleAxbX5jpiFLLnYsuBrfWUPYzeWx9Fghm7JyoUBrfNolToYHoNQcN5xlG6M6rMqIVtw9EP2QROtCjayTMsPZXiq0OKrZRr89YY19oU5M70yBQxyZmBlgpU8niqFsboMRIG2ZH2k82jZcLkRKz2z75siPjYNmSGFizjI3xgGrwToUWlEZNOwokWGWQ7Ozon3qOLSONnXVZ7QlqsV63bCC2xIunWTFjhQ59cojpMLIGmKBSeimb3m91jzCG5SSv7mYIeo67ho8fwOJ8IbNuHO5NE4FVuKZZlfVkRaLMEEwSXBo8wTmR4Q0RoVFOtCA1OxeQrWJcU71yUTPGFZuZljvMeVqnxISoEMU0JmWuw2rfsvcqe6qHLVh',
form = 'KN5CDumw2CXu6FAFzPCTt9UmfVkuggEbrhv5O4rxoDhJ3yFL7F';
TRUNCATE participant_private_data;
-- USE shuti_production;
UPDATE participant_data SET
participant_id = 999999,
prop_value_binary = 1,
prop_value_boolean = 1,
prop_value_integer = 999999,
prop_key = 'Zxd2lcwZUPDy1Aqv3dQpjOIhqOxqVJeBsy307mjijZ5gD9LHNB0N7GZoXfRTiN3JSDvOpjyu0k7UVm6Fr6k4m9I8kbAg23E3emZ0VitX3Cy46RJ01h0Pw6H07SH5skumig60p5PNolR2HUklD4eBVXqCXCSsodQbaHGjgUaIz1Z8ydRvURo3gzGKvSG48keEivOgPFV8',
prop_value = '1DqGViFRX8fHWRcD7Q4Rjjzinvf1pgWqXSM8o3DBkFxYrNOqjqUcUwNBPH33q03xpTbjbAOYgwnTiEgx5WWOk5QukDVKW8p5PQ9WOrzXZMnoZ3EFINWsp5XB88sz91N6a8P59aH4M5jIewOqfuJMybH2uKIe0nIcaDeapuQMRYigo33uUpR8rRhAj4FNxUlf2PLYjEerw9pTyMGeSmSN7lsteR2hYw3RzR25VEC2TxgkK3uDeT6BBFDfpq',
prop_value_text = 'fFiii6z9r071aNawt95XKfD9g8t6AyeYxGTzRkULiTz8zn9GL0NcFEyltwNplprNpGfKHNZ8yNqoZIo2JsaP6OnhmOb7hXij7z1YKqtheABKtsZ6NHiFSpEpLVqfnNiDAimo1PZXbejen2SnAMEfGtXrFD7W9oXswMIH19vONAe4LlrhfstaKUaGT7soeMAl8Kmaqe63uUttEOGn3W7jIY1L7YsYlSFam7rrXfTxkNBpBkkW6muyUES3mMKA8zwTARV4BuRoBJOFQZ7Rc98ngq4FqVahu16EVWUN5WKui8Kzq0bCzA8UIzq9Mp87tS9q0r0AruEKMaay1Pve8Hb0w9xeSkpxrFJvh7IXHGCY52AHxpP14YCExmuKLs8Q38TkypCvCVFcwyADRbv2DzxKbNZJzoVbM6JJPGaIVwhSAsF0Tgfm5pRJaWazvOglqxxOhgDe1IN3DxqGPuLfyUrNgWXSx1HkZceuYak5yuQmRDkeDU1BZGGgTEPQGOYuWQNhRBZQjoGH3SyEpgfFiii6z9r071aNawt95XKfD9g8t6AyeYxGTzRkULiTz8zn9GL0NcFEyltwNplprNpGfKHNZ8yNqoZIo2JsaP6OnhmOb7hXij7z1YKqtheABKtsZ6NHiFSpEpLVqfnNiDAimo1PZXbejen2SnAMEfGtXrFD7W9oXswMIH19vONAe4LlrhfstaKUaGT7soeMAl8Kmaqe63uUttEOGn3W7jIY1L7YsYlSFam7rrXfTxkNBpBkkW6muyUES3mMKA8zwTARV4BuRoBJOFQZ7Rc98ngq4FqVahu16EVWUN5WKui8Kzq0bCzA8UIzq9Mp87tS9q0r0AruEKMaay1Pve8Hb0w9xeSkpxrFJvh7IXHGCY52AHxpP14YCExmuKLs8Q38TkypCvCVFcwyADRbv2DzxKbNZJzoVbM6JJPGaIVwhSAsF0Tgfm5pRJaWazvOglqxxOhgDe1IN3DxqGPuLfyUrNgWXSx1HkZceuYak5yuQmRDkeDU1BZGGgTEPQGOYuWQNhRBZQjoGH3SyEpgr4jCucBhQ6Ig5bJiFDBWXVKphkg0rarZvoAHB83ZyoNxsYWmfy4RDNS4mjzEfM6Sbw5Y27Y7tozpz7E8ozXevvUmBgUNZNi8kKUjOYleAxbX5jpiFLLnYsuBrfWUPYzeWx9Fghm7JyoUBrfNolToYHoNQcN5xlG6M6rMqIVtw9EP2QROtCjayTMsPZXiq0OKrZRr89YY19oU5M70yBQxyZmBlgpU8niqFsboMRIG2ZH2k82jZcLkRKz2z75siPjYNmSGFizjI3xgGrwToUWlEZNOwokWGWQ7Ozon3qOLSONnXVZ7QlqsV63bCC2xIunWTFjhQ59cojpMLIGmKBSeimb3m91jzCG5SSv7mYIeo67ho8fwOJ8IbNuHO5NE4FVuKZZlfVkRaLMEEwSXBo8wTmR4Q0RoVFOtCA1OxeQrWJcU71yUTPGFZuZljvMeVqnxISoEMU0JmWuw2rfsvcqe6qHLVh',
form = 'KN5CDumw2CXu6FAFzPCTt9UmfVkuggEbrhv5O4rxoDhJ3yFL7F';
TRUNCATE access_codes;
TRUNCATE access_tokens;
TRUNCATE action_data;
TRUNCATE actions;
TRUNCATE contact_categories_contacts;
TRUNCATE contacts;
TRUNCATE conversations;
TRUNCATE event_data;
TRUNCATE events;
TRUNCATE locked_triggers;
TRUNCATE participant_data;
TRUNCATE participant_private_data;
TRUNCATE participant_types;
TRUNCATE participants;
TRUNCATE partners;
TRUNCATE pending_reports;
TRUNCATE pending_triggers;
TRUNCATE settings;
TRUNCATE subscriptions;
TRUNCATE users ;
@s4parke
Copy link
Author

s4parke commented Aug 21, 2018

This gist will self-destruct in 10 minutes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment