Has anyone available a SQLscript that deletes all members from a database.
I've found a few older V7 versions and obviously there are packages out there, but I'm looking to delete them via SQL Script so that I can incorporate it in as part of a deployment package.
From what I can see the data is in the following tables. Can anyone confirm?
cmsMember,
cmsContentNu,
umbracoNode,
cmsMember2MemberGroup
SELECT cmsMember.nodeId, cmsMember.Email, cmsMember.LoginName, cmsMember.Password, cmsContentNu.nodeId AS Expr1, cmsContentNu.published, cmsContentNu.data, cmsContentNu.rv, umbracoNode.nodeObjectType,
cmsMember2MemberGroup.MemberGroup
FROM cmsMember LEFT OUTER JOIN
cmsMember2MemberGroup ON cmsMember.nodeId = cmsMember2MemberGroup.Member LEFT OUTER JOIN
umbracoNode ON cmsMember.nodeId = umbracoNode.id LEFT OUTER JOIN
cmsContentNu ON cmsMember.nodeId = cmsContentNu.nodeId
Delete all members via SQL script?
Has anyone available a SQLscript that deletes all members from a database.
I've found a few older V7 versions and obviously there are packages out there, but I'm looking to delete them via SQL Script so that I can incorporate it in as part of a deployment package.
From what I can see the data is in the following tables. Can anyone confirm?
cmsMember,
cmsContentNu,
umbracoNode,
cmsMember2MemberGroup
is working on a reply...