imc_alba/dadamigrate/clean_db_for_testing.sql

-- I use this when testing the module, to allow repeated runs.
-- It wipes articles, imported users and some other stuff.
-- XXX Don't use this on a live site.
delete from node;
delete from node_comment_statistics;
delete from node_revisions;
delete from users where uid > 900;
delete from dada_articles;
delete from dada_features;
delete from comments;
delete from cache_menu;
delete from cache;
delete from cache_filter;
delete from cache_form;
delete from cache_page;
delete from cache_update;
delete from watchdog;
delete from batch;
delete from vocabulary;
delete from term_data;
delete from term_node;
delete from term_hierarchy;
delete from term_relation;
delete from term_synonym;
delete from imc_node_moderation;
delete from imc_feature_proposal;
delete from imc_feature_vote;
delete from search_index;
delete from search_dataset;
delete from users_roles;
1	-- I use this when testing the module, to allow repeated runs.
2	-- It wipes articles, imported users and some other stuff.
3	-- XXX Don't use this on a live site.
4	delete from node;
5	delete from node_comment_statistics;
6	delete from node_revisions;
7	delete from users where uid > 900;
8	delete from dada_articles;
9	delete from dada_features;
10	delete from comments;
11	delete from cache_menu;
12	delete from cache;
13	delete from cache_filter;
14	delete from cache_form;
15	delete from cache_page;
16	delete from cache_update;
17	delete from watchdog;
18	delete from batch;
19	delete from vocabulary;
20	delete from term_data;
21	delete from term_node;
22	delete from term_hierarchy;
23	delete from term_relation;
24	delete from term_synonym;
25	delete from imc_node_moderation;
26	delete from imc_feature_proposal;
27	delete from imc_feature_vote;
28	delete from search_index;
29	delete from search_dataset;
30	delete from users_roles;