Hi @esales2000,
Did you make any progress on this? I’d also like to be able to isolate all the DB entries used by SC.
What I’ve been able to figure out so far:
It *appears* that all the Support Candy tables and variables are prefixed by “wpsc.” There seem to be three main tables:
wpsc_email_notification
wpsc_ticket
wpsc_ticketmeta
And, using phpMyAdmin to search my Database, I came up with SC variables in the following tables:
156 matches in wp_options
44 matches in wp_postmeta
7343 matches in wp_posts
369 matches in wp_termmeta
148 matches in wp_term_taxonomy
9 matches in wp_usermeta
But I’m not very confident about the results, and it does all depend on being correct about the “wpsc” naming convention.
It would be great if the SC support people could comment here!
Mike