// this is for reference for cleaning the database to release it publicly

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