x
1
BEGIN
2
DROP TEMPORARY TABLE IF EXISTS GComp_MT;
3
4
CREATE TEMPORARY TABLE GComp_MT
5
SELECT * FROM SubGroups
6
WHERE GroupID IN (SELECT GroupID FROM MasterGroups WHERE MASTER=0) AND
7
ComputerID IN (SELECT ComputerID FROM SubGroups JOIN Mastergroups USING (groupid)
8
WHERE Mastergroups.AutoJoinScript>0 AND Mastergroups.Master=1);
9
10
DELETE SubGroups FROM Subgroups JOIN GComp_MT USING (ComputerID,GroupID);
11
12
DROP TEMPORARY TABLE GComp_MT;
13
END