... | ... | @@ -16,6 +16,9 @@ psql -U betaforms -W -h 127.0.0.1 betaforms < /home/pyg/backups_pyg/framaforms_2 |
|
|
Connect to your temp database, and execute those queries
|
|
|
|
|
|
```sql
|
|
|
-- clean DB tables based on node id
|
|
|
TRUNCATE field_data_field_form1_expiration, field_data_field_form1_file, field_data_field_form1_image, field_data_field_form1_progress, field_data_field_form1_results_access, field_data_field_form1_results_access, field_data_field_form1_template, field_data_field_form1_template_desc, field_revision_field_form1_image, field_revision_field_form1_expiration, field_revision_field_form1_file, field_revision_field_form1_progress, field_revision_field_form1_results_access, field_revision_field_form1_results_public,
|
|
|
field_revision_field_form1_template, field_revision_field_form1_template;
|
|
|
|
|
|
DELETE FROM node_revision
|
|
|
WHERE node_revision.nid in
|
... | ... | @@ -27,25 +30,24 @@ WHERE pathauto_state.entity_id in |
|
|
|
|
|
DELETE FROM url_alias
|
|
|
WHERE url_alias.alias IN
|
|
|
(SELECT url_alias.alias FROM node JOIN url_alias ON CONCAT('node/', node.nid) = url_alias.source WHERE node.type='form1')
|
|
|
(SELECT url_alias.alias FROM node JOIN url_alias ON CONCAT('node/', node.nid) = url_alias.source WHERE node.type='form1');
|
|
|
|
|
|
DELETE FROM url_alias WHERE url_alias.source LIKE 'user/%'
|
|
|
-- delete also aliases based on users
|
|
|
DELETE FROM url_alias WHERE url_alias.source LIKE 'user/%';
|
|
|
|
|
|
-- delete all existing forms
|
|
|
DELETE FROM node WHERE type='form1';
|
|
|
|
|
|
-- sql to empty DB
|
|
|
-- sql to empty some DB tables
|
|
|
TRUNCATE "batch", "cache", "cache_admin_menu", "cache_block", "cache_bootstrap", "cache_field", "cache_filter", "cache_form", "cache_image", "cache_libraries", "cache_menu", "cache_page", "cache_panels", "cache_path", "cache_rules", "cache_token", "cache_update", "cache_views", "cache_views_data", "flood", "history", "pgbar_webform_submissions_static", "search_dataset", "search_index", "search_total", "sessions", "themekey_ui_node_theme", "watchdog", "webform", "webform_component", "webform_conditional", "webform_conditional_actions", "webform_conditional_rules", "webform_confirm_email", "webform_confirm_email_code", "webform_confirm_email_confirmation_emails", "webform_confirmation", "webform_emails", "webform_last_download", "webform_report", "webform_roles", "webform_submissions", "webform_submitted_data", "webform_validation_rule", "webform_validation_rule_components";
|
|
|
|
|
|
-- truncate other tables
|
|
|
TRUNCATE "node_comment_statistics", "file_usage", "file_managed";
|
|
|
|
|
|
-- purge some existing tables using forms
|
|
|
DELETE FROM field_data_body WHERE bundle='form1';
|
|
|
DELETE FROM field_revision_body WHERE bundle='form1';
|
|
|
|
|
|
TRUNCATE field_data_field_form1_expiration, field_data_field_form1_file, field_data_field_form1_image, field_data_field_form1_progress, field_data_field_form1_results_access, field_data_field_form1_results_access, field_data_field_form1_template, field_data_field_form1_template_desc, field_revision_field_form1_image, field_revision_field_form1_expiration, field_revision_field_form1_file, field_revision_field_form1_progress, field_revision_field_form1_results_access, field_revision_field_form1_results_public,
|
|
|
field_revision_field_form1_template, field_revision_field_form1_template;
|
|
|
|
|
|
|
|
|
-- query to delete all users except admin
|
|
|
delete from users where uid != 0 and uid != 1;
|
|
|
|
... | ... | |