Page Comparison

DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'Pomona%';


DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'CORNELL%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'univcincin%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'JCBBOOKS%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'CUL_KAR%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'BIRKBECKBCM%';
DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'Pomona%';


DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID LIKE 'Pomona%';



DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'Pomona%';


DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'CORNELL%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'univcincin%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'JCBBOOKS%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'CUL_KAR%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'BIRKBECKBCM%';
DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'Pomona%';


DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID LIKE 'CORNELL%';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'univcincin';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'JCBBOOKS';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'CUL_KAR';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'BIRKBECKBCM';
DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID LIKE 'Pomona%';
 
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'CORNELL%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'univcincin%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'JCBBOOKS%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'CUL_KAR%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'BIRKBECKBCM%';
DELETE  FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'Pomona%';
 
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'CORNELL%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'univcincin%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'JCBBOOKS%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'CUL_KAR%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'BIRKBECKBCM%';
DELETE  FROM ROLESPERMISSIONS WHERE ROLENAME LIKE 'Pomona%';

DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'CORNELL%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'univcincin%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'JCBBOOKS%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'CUL_KAR%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'BIRKBECKBCM%';
DELETE  FROM CREDENTIALROLES WHERE ROLENAME LIKE 'Pomona%';