Cleaning the NewsCloud Database for Public Release

From Newscloud

This query cleans the NewsCloud database so that it can be released publicly without exposing user data. It leaves 7 days of stories and one user account.

delete from delilog;
delete from apiSession;
delete from apiLog;
delete from apiLimits;
delete from User where uid<>1;
delete from Trackers;
delete from SiteTitles where uid<>1;
delete from TrackerItems;
delete from UserBlogroll ;
delete from UserBlogs ;
delete from UserDelicious ;
delete from UserFriends ;
delete from UserInvites ;
delete from UserLocale ;
delete from UserLog ;
delete from UserPages ;
delete from UserRead ;
delete from UserTellFriend ;
delete from UserTrackers ;
delete from SearchWords;
delete from Ratings where uid<>1;
delete from Rankings;
delete from Orders;
delete from OrderContent;
delete from OrderPayments;
delete from MetricsToday;
delete from MetricsDaily;
delete from Log_api;
delete from Links;
delete from Groups where taglist=;
delete from GroupMembers where uid<>1;
delete from Flood;
delete from Flags;
delete from Feeds where feedid<45;
delete from FeedTags where feedid<45;
delete from FeaturedBits;
delete from Favorites;
delete from ContentModerators;
delete from Channels where userid<>1;
delete from ChannelContent where postedbyid<>1;
delete from Carts;
delete from CartContent;
delete from AccountLedger;
delete from Accounts where uid<>1;
delete from Content where Content.date < date_sub(NOW(), INTERVAL 7 DAY);
delete from ContentTags where uid<>1;
delete from Blogs where (blogtype<>'wire' AND blogtype<>'mediafeed') or status<>'approved';
delete from BlogTags where blogid <57;
delete from User where uid<>1;
delete from ContentRelated;
delete from zip_code where zip_code<>'98103';
delete from youTube;
delete from youTubeRollup;
delete from UserFeedRead;
delete from ImageWire;
delete from fbMap;
delete from fbInvites;
delete from fbActions;
Update SiteTitles set uid=1;
Update comments set postedbyid=1;
Update Content set submitbyid =1;
Update JournalContent set uid =1;
Update Groups set ownerid=1;

This changes the initial user id to newsmonkey@gmail.com and password to NewsCloud

UPDATE User set email='newsmonkey@gmail.com' ,password='ne8QXA/gYiVGA' where uid=1