Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
The same queries can be used on both v6 and v7 LUNA databases.
Code Block
languagesql
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%';

...