Created
June 25, 2013 17:10
-
-
Save JasPanesar/5860317 to your computer and use it in GitHub Desktop.
Quick Script to drop all Mura CMS 6.0 tables from a MS SQL Server. Copy, paste, and rename the Use statement to reference your Mura TableName.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* MSSQL Script to delete Mura 6.0 installation tables | |
Be sure to replace your database name below inside the USE [] Statement */ | |
USE [MyMuraDatabase] | |
GO | |
DROP TABLE [dbo].[tadcampaigns] | |
DROP TABLE [dbo].[tadcreatives] | |
DROP TABLE [dbo].[tadipwhitelist] | |
DROP TABLE [dbo].[tadplacementcategoryassign] | |
DROP TABLE [dbo].[tadplacementdetails] | |
DROP TABLE [dbo].[tadplacements] | |
DROP TABLE [dbo].[tadstats] | |
DROP TABLE [dbo].[tadzones] | |
DROP TABLE [dbo].[tcaptcha] | |
DROP TABLE [dbo].[tchangesets] | |
DROP TABLE [dbo].[tclassextend] | |
DROP TABLE [dbo].[tclassextendattributes] | |
DROP TABLE [dbo].[tclassextenddata] | |
DROP TABLE [dbo].[tclassextenddatauseractivity] | |
DROP TABLE [dbo].[tclassextendsets] | |
DROP TABLE [dbo].[tclustercommands] | |
DROP TABLE [dbo].[tclusterpeers] | |
DROP TABLE [dbo].[tcontent] | |
DROP TABLE [dbo].[tcontentassignments] | |
DROP TABLE [dbo].[tcontentcategories] | |
DROP TABLE [dbo].[tcontentcategoryassign] | |
DROP TABLE [dbo].[tcontentcomments] | |
DROP TABLE [dbo].[tcontentdisplaytitleapprovals] | |
DROP TABLE [dbo].[tcontenteventreminders] | |
DROP TABLE [dbo].[tcontentfeedadvancedparams] | |
DROP TABLE [dbo].[tcontentfeeditems] | |
DROP TABLE [dbo].[tcontentfeeds] | |
DROP TABLE [dbo].[tcontentobjects] | |
DROP TABLE [dbo].[tcontentpublicsubmissionapprovals] | |
DROP TABLE [dbo].[tcontentratings] | |
DROP TABLE [dbo].[tcontentrelated] | |
DROP TABLE [dbo].[tcontentstats] | |
DROP TABLE [dbo].[tcontenttags] | |
DROP TABLE [dbo].[tdirectories] | |
DROP TABLE [dbo].[temails] | |
DROP TABLE [dbo].[temailstats] | |
DROP TABLE [dbo].[temailreturnstats] | |
DROP TABLE [dbo].[tfiles] | |
DROP TABLE [dbo].[tformresponsepackets] | |
DROP TABLE [dbo].[tformresponsequestions] | |
DROP TABLE [dbo].[timagesizes] | |
DROP TABLE [dbo].[tmailinglist] | |
DROP TABLE [dbo].[tmailinglistmembers] | |
DROP TABLE [dbo].[tpermissions] | |
DROP TABLE [dbo].[tplugindisplayobjects] | |
DROP TABLE [dbo].[tplugins] | |
DROP TABLE [dbo].[tpluginscripts] | |
DROP TABLE [dbo].[tpluginsettings] | |
DROP TABLE [dbo].[tredirects] | |
DROP TABLE [dbo].[tsessiontracking] | |
DROP TABLE [dbo].[tsettings] | |
DROP TABLE [dbo].[tsystemobjects] | |
DROP TABLE [dbo].[ttrash] | |
DROP TABLE [dbo].[tuseraddresses] | |
DROP TABLE [dbo].[tuserremotesessions] | |
DROP TABLE [dbo].[tusers] | |
DROP TABLE [dbo].[tusersfavorites] | |
DROP TABLE [dbo].[tusersinterests] | |
DROP TABLE [dbo].[tusersmemb] | |
DROP TABLE [dbo].[tuserstags] | |
DROP TABLE [dbo].[tuserstrikes] | |
GO |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment