DROP PROCEDURE [addAnnotation] DROP PROCEDURE [addAnnotationType] DROP PROCEDURE [addAssignment] DROP PROCEDURE [addConnection] DROP PROCEDURE [addContent] DROP PROCEDURE [addDetail] DROP PROCEDURE [addDocument] DROP PROCEDURE [addDocVersion] DROP PROCEDURE [addEntry] DROP PROCEDURE [addFolder] DROP PROCEDURE [addFormat] DROP PROCEDURE [addGroup] DROP PROCEDURE [addItem] DROP PROCEDURE [addMembership] DROP PROCEDURE [addPart] DROP PROCEDURE [addPermission] DROP PROCEDURE [addRole] DROP PROCEDURE [addRoUsage] DROP PROCEDURE [addTransition] DROP PROCEDURE [addUser] DROP PROCEDURE [addZContent] DROP PROCEDURE [addZTransition] DROP PROCEDURE [deleteAnnotation] DROP PROCEDURE [deleteAnnotationType] DROP PROCEDURE [deleteAssignment] DROP PROCEDURE [deleteConnection] DROP PROCEDURE [deleteContent] DROP PROCEDURE [deleteDetail] DROP PROCEDURE [deleteDocument] DROP PROCEDURE [deleteDocVersion] DROP PROCEDURE [deleteEntry] DROP PROCEDURE [deleteFolder] DROP PROCEDURE [deleteFormat] DROP PROCEDURE [deleteGroup] DROP PROCEDURE [deleteItem] DROP PROCEDURE [deleteMembership] DROP PROCEDURE [deletePart] DROP PROCEDURE [deletePermission] DROP PROCEDURE [deleteRole] DROP PROCEDURE [deleteRoUsage] DROP PROCEDURE [deleteTransition] DROP PROCEDURE [deleteUser] DROP PROCEDURE [deleteZContent] DROP PROCEDURE [deleteZTransition] DROP PROCEDURE [existsAnnotation] DROP PROCEDURE [existsAnnotationType] DROP PROCEDURE [existsAssignment] DROP PROCEDURE [existsConnection] DROP PROCEDURE [existsContent] DROP PROCEDURE [existsDetail] DROP PROCEDURE [existsDocument] DROP PROCEDURE [existsDocVersion] DROP PROCEDURE [existsEntry] DROP PROCEDURE [existsFolder] DROP PROCEDURE [existsFormat] DROP PROCEDURE [existsGroup] DROP PROCEDURE [existsItem] DROP PROCEDURE [existsMembership] DROP PROCEDURE [existsPart] DROP PROCEDURE [existsPermission] DROP PROCEDURE [existsRole] DROP PROCEDURE [existsRoUsage] DROP PROCEDURE [existsTransition] DROP PROCEDURE [existsUser] DROP PROCEDURE [existsZContent] DROP PROCEDURE [existsZTransition] DROP PROCEDURE [getAnnotation] DROP PROCEDURE [getAnnotations] DROP PROCEDURE [getAnnotationsByItemID] DROP PROCEDURE [getAnnotationsByTypeID] DROP PROCEDURE [getAnnotationType] DROP PROCEDURE [getAnnotationTypeByName] DROP PROCEDURE [getAnnotationTypes] DROP PROCEDURE [getAssignment] DROP PROCEDURE [getAssignments] DROP PROCEDURE [getAssignmentsByFolderID] DROP PROCEDURE [getAssignmentsByGID] DROP PROCEDURE [getAssignmentsByRID] DROP PROCEDURE [getChildFolders] DROP PROCEDURE [getChildFormats] DROP PROCEDURE [getConnection] DROP PROCEDURE [getConnectionByName] DROP PROCEDURE [getConnections] DROP PROCEDURE [getContent] DROP PROCEDURE [getContents] DROP PROCEDURE [getContentsByFormatID] DROP PROCEDURE [getDetail] DROP PROCEDURE [getDetails] DROP PROCEDURE [getDetailsByContentID] DROP PROCEDURE [getDocument] DROP PROCEDURE [getDocuments] DROP PROCEDURE [getDocVersion] DROP PROCEDURE [getDocVersions] DROP PROCEDURE [getDocVersionsByFolderID] DROP PROCEDURE [getDocVersionsByFormatID] DROP PROCEDURE [getDocVersionsByItemID] DROP PROCEDURE [getEntries] DROP PROCEDURE [getEntriesByContentID] DROP PROCEDURE [getEntriesByDocID] DROP PROCEDURE [getEntry] DROP PROCEDURE [getFolder] DROP PROCEDURE [getFolderByParentID_Name] DROP PROCEDURE [getFolders] DROP PROCEDURE [getFoldersByDBID] DROP PROCEDURE [getFoldersByFormatID] DROP PROCEDURE [getFormat] DROP PROCEDURE [getFormatByParentID_Name] DROP PROCEDURE [getFormats] DROP PROCEDURE [getGroup] DROP PROCEDURE [getGroupByGroupName] DROP PROCEDURE [getGroups] DROP PROCEDURE [getItem] DROP PROCEDURE [getItems] DROP PROCEDURE [getItemsByContentID] DROP PROCEDURE [getLibraryDocuments] DROP PROCEDURE [getMembership] DROP PROCEDURE [getMemberships] DROP PROCEDURE [getMembershipsByGID] DROP PROCEDURE [getMembershipsByUID] DROP PROCEDURE [getNextItems] DROP PROCEDURE [getParentFolder] DROP PROCEDURE [getParentFormat] DROP PROCEDURE [getPart] DROP PROCEDURE [getParts] DROP PROCEDURE [getPartsByContentID] DROP PROCEDURE [getPartsByItemID] DROP PROCEDURE [getPermission] DROP PROCEDURE [getPermissions] DROP PROCEDURE [getPermissionsByRID] DROP PROCEDURE [getPreviousItem] DROP PROCEDURE [getRole] DROP PROCEDURE [getRoleByName] DROP PROCEDURE [getRoles] DROP PROCEDURE [getRoUsage] DROP PROCEDURE [getRoUsages] DROP PROCEDURE [getRoUsagesByContentID] DROP PROCEDURE [getTransition] DROP PROCEDURE [getTransitions] DROP PROCEDURE [getTransitionsByFromID] DROP PROCEDURE [getTransitionsByRangeID] DROP PROCEDURE [getTransitionsByToID] DROP PROCEDURE [getUser] DROP PROCEDURE [getUsers] DROP PROCEDURE [getZContent] DROP PROCEDURE [getZContents] DROP PROCEDURE [getZContentsByContentID] DROP PROCEDURE [getZTransition] DROP PROCEDURE [getZTransitions] DROP PROCEDURE [getZTransitionsByTransitionID] DROP PROCEDURE [purgeData] DROP PROCEDURE [updateAnnotation] DROP PROCEDURE [updateAnnotationType] DROP PROCEDURE [updateAssignment] DROP PROCEDURE [updateConnection] DROP PROCEDURE [updateContent] DROP PROCEDURE [updateDetail] DROP PROCEDURE [updateDocument] DROP PROCEDURE [updateDocVersion] DROP PROCEDURE [updateEntry] DROP PROCEDURE [updateFolder] DROP PROCEDURE [updateFormat] DROP PROCEDURE [updateGroup] DROP PROCEDURE [updateItem] DROP PROCEDURE [updateMembership] DROP PROCEDURE [updatePart] DROP PROCEDURE [updatePermission] DROP PROCEDURE [updateRole] DROP PROCEDURE [updateRoUsage] DROP PROCEDURE [updateTransition] DROP PROCEDURE [updateUser] DROP PROCEDURE [updateZContent] DROP PROCEDURE [updateZTransition] DROP PROCEDURE [addDocVersionROFst] DROP PROCEDURE [addRODb] DROP PROCEDURE [addROFst] DROP PROCEDURE [addROFstImage] DROP PROCEDURE [addROImage] DROP PROCEDURE [deleteDocVersionROFst] DROP PROCEDURE [deleteRODb] DROP PROCEDURE [deleteROFst] DROP PROCEDURE [deleteROFstImage] DROP PROCEDURE [deleteROImage] DROP PROCEDURE [existsDocVersionROFst] DROP PROCEDURE [existsRODb] DROP PROCEDURE [existsROFst] DROP PROCEDURE [existsROFstImage] DROP PROCEDURE [existsROImage] DROP PROCEDURE [getDocVersionROFst] DROP PROCEDURE [getDocVersionROFsts] DROP PROCEDURE [getDocVersionROFstsByROFstID] DROP PROCEDURE [getDocVersionROFstsByVersionID] DROP PROCEDURE [getRODb] DROP PROCEDURE [getRODbs] DROP PROCEDURE [getROFst] DROP PROCEDURE [getROFstImage] DROP PROCEDURE [getROFstImages] DROP PROCEDURE [getROFstImagesByImageID] DROP PROCEDURE [getROFstImagesByROFstID] DROP PROCEDURE [getROFsts] DROP PROCEDURE [getROFstsByRODbID] DROP PROCEDURE [getROImage] DROP PROCEDURE [getROImages] DROP PROCEDURE [getROImagesByRODbID] DROP PROCEDURE [getRoUsagesByRODbID] DROP PROCEDURE [updateDocVersionROFst] DROP PROCEDURE [updateRODb] DROP PROCEDURE [updateROFst] DROP PROCEDURE [updateROFstImage] DROP PROCEDURE [updateROImage]