cms_drop_all_indexes_queries.properties

找了很久才找到到源代码

Q_SHOW_INDEXES=\
SELECT pgc.relname \
  FROM pg_class pgc, \
  pg_index, \
  pg_class pgc1, \
  pg_authid \
  WHERE pgc.oid = pg_index.indexrelid \
  AND pg_index.indrelid = pgc1.oid \
  AND pgc1.relname='${tablename}' \
  AND pg_authid.oid = pgc.relowner \
  AND pg_authid.rolname = current_user \
  AND pgc.relname not in ( \
                           SELECT pg_constraint.conname \
                           FROM pg_class pgc, \
                           pg_constraint, \
                           pg_authid \
                           WHERE pgc.oid = pg_constraint.conrelid \
                           AND pg_authid.oid = pgc.relowner \
                           AND pgc.relname = '${tablename}' \
                           AND pg_authid.rolname = current_user \
                          )

Q_SHOW_CONSTRAINTS=\
SELECT pg_constraint.conname \
  FROM pg_class pgc, \
  pg_constraint, \
  pg_authid \
  WHERE pgc.oid = pg_constraint.conrelid \
  AND pg_authid.oid = pgc.relowner \
  AND pgc.relname = '${tablename}' \
  AND pg_authid.rolname = current_user

Q_DROP_INDEX=\
DROP INDEX ${indexname}

Q_DROP_CONSTRAINT=\
ALTER TABLE ${tablename} \
DROP CONSTRAINT ${indexname}


CMS_BACKUP_CONTENTS_INDEX_1=\
CREATE INDEX TMP_BKP_CNT_1 ON CMS_BACKUP_CONTENTS(RESOURCE_ID)

CMS_BACKUP_CONTENTS_INDEX_2=\
CREATE INDEX TMP_BKP_CNT_2 ON CMS_BACKUP_CONTENTS(PUBLISH_TAG)


CMS_BACKUP_PROJECTRESOURCES_INDEX_1=\
CREATE INDEX TMP_BKP_PRJRES_1 ON CMS_BACKUP_PROJECTRESOURCES(PROJECT_ID)


CMS_BACKUP_PROJECTS_INDEX_1=\
CREATE INDEX TMP_BKP_PRJ_1 ON CMS_BACKUP_PROJECTS(PUBLISH_TAG)

CMS_BACKUP_PROJECTS_INDEX_2=\
CREATE INDEX TMP_BKP_PRJ_2 ON CMS_BACKUP_PROJECTS(PROJECT_ID)

CMS_BACKUP_PROJECTS_INDEX_3=\
CREATE INDEX TMP_BKP_PRJ_3 ON CMS_BACKUP_PROJECTS(USER_ID)

CMS_BACKUP_PROJECTS_INDEX_4=\
CREATE INDEX TMP_BKP_PRJ_4 ON CMS_BACKUP_PROJECTS(MANAGERGROUP_ID)

CMS_BACKUP_PROJECTS_INDEX_5=\
CREATE INDEX TMP_BKP_PRJ_5 ON CMS_BACKUP_PROJECTS(GROUP_ID)

CMS_BACKUP_PROJECTS_INDEX_6=\
CREATE INDEX TMP_BKP_PRJ_6 ON CMS_BACKUP_PROJECTS(PROJECT_PUBLISHED_BY)


CMS_BACKUP_PROPERTIES_INDEX_1=\
CREATE INDEX TMP_BKP_PROPS_1 ON CMS_BACKUP_PROPERTIES(PROPERTYDEF_ID)

CMS_BACKUP_PROPERTIES_INDEX_2=\
CREATE INDEX TMP_BKP_PROPS_2 ON CMS_BACKUP_PROPERTIES(PROPERTY_MAPPING_ID)

CMS_BACKUP_PROPERTIES_INDEX_3=\
CREATE INDEX TMP_BKP_PROPS_3 ON CMS_BACKUP_PROPERTIES(PUBLISH_TAG)


CMS_BACKUP_PROPERTYDEF_INDEX_1=\
CREATE INDEX TMP_BKP_PROPDEF_1 ON CMS_BACKUP_PROPERTYDEF(PROPERTYDEF_ID)


CMS_BACKUP_RESOURCES_INDEX_1=\
CREATE INDEX TMP_BKP_RES_1 ON CMS_BACKUP_RESOURCES(RESOURCE_ID)

CMS_BACKUP_RESOURCES_INDEX_2=\
CREATE INDEX TMP_BKP_RES_2 ON CMS_BACKUP_RESOURCES(PROJECT_LASTMODIFIED)

CMS_BACKUP_RESOURCES_INDEX_3=\
CREATE INDEX TMP_BKP_RES_3 ON CMS_BACKUP_RESOURCES(PUBLISH_TAG)

CMS_BACKUP_RESOURCES_INDEX_4=\
CREATE INDEX TMP_BKP_RES_4 ON CMS_BACKUP_RESOURCES(USER_CREATED)

CMS_BACKUP_RESOURCES_INDEX_5=\
CREATE INDEX TMP_BKP_RES_5 ON CMS_BACKUP_RESOURCES(USER_LASTMODIFIED)


CMS_BACKUP_STRUCTURE_INDEX_1=\
CREATE INDEX TMP_BKP_STR_1 ON CMS_BACKUP_STRUCTURE(STRUCTURE_ID)

CMS_BACKUP_STRUCTURE_INDEX_2=\
CREATE INDEX TMP_BKP_STR_2 ON CMS_BACKUP_STRUCTURE(RESOURCE_ID)

CMS_BACKUP_STRUCTURE_INDEX_3=\
CREATE INDEX TMP_BKP_STR_3 ON CMS_BACKUP_STRUCTURE(PUBLISH_TAG)

CMS_BACKUP_STRUCTURE_INDEX_4=\
CREATE INDEX TMP_BKP_STR_4 ON CMS_BACKUP_STRUCTURE(VERSION_ID)


CMS_GROUPS_INDEX_1=\
CREATE INDEX TMP_GRP_1 ON CMS_GROUPS(GROUP_ID)


CMS_OFFLINE_CONTENTS_INDEX_1=\
CREATE INDEX TMP_OFF_CNT ON CMS_OFFLINE_CONTENTS(RESOURCE_ID)


CMS_OFFLINE_RESOURCES_INDEX_1=\
CREATE INDEX TMP_OFF_RES_1 ON CMS_OFFLINE_RESOURCES(RESOURCE_ID)

CMS_OFFLINE_RESOURCES_INDEX_2=\
CREATE INDEX TMP_OFF_RES_2 ON CMS_OFFLINE_RESOURCES(PROJECT_LASTMODIFIED)

CMS_OFFLINE_RESOURCES_INDEX_3=\
CREATE INDEX TMP_OFF_RES_3 ON CMS_OFFLINE_RESOURCES(USER_CREATED)

CMS_OFFLINE_RESOURCES_INDEX_4=\
CREATE INDEX TMP_OFF_RES_4 ON CMS_OFFLINE_RESOURCES(USER_LASTMODIFIED)


CMS_OFFLINE_STRUCTURE_INDEX_1=\
CREATE INDEX TMP_OFF_STR_1 ON CMS_OFFLINE_STRUCTURE(STRUCTURE_ID)

CMS_OFFLINE_STRUCTURE_INDEX_2=\
CREATE INDEX TMP_OFF_STR_2 ON CMS_OFFLINE_STRUCTURE(RESOURCE_ID)

CMS_OFFLINE_STRUCTURE_INDEX_3=\
CREATE INDEX TMP_OFF_STR_3 ON CMS_OFFLINE_STRUCTURE(PARENT_ID)


CMS_ONLINE_CONTENTS_INDEX_1=\
CREATE INDEX TMP_ON_CNT ON CMS_ONLINE_CONTENTS(RESOURCE_ID) 


CMS_ONLINE_RESOURCES_INDEX_1=\
CREATE INDEX TMP_ON_RES_1 ON CMS_ONLINE_RESOURCES(RESOURCE_ID)

CMS_ONLINE_RESOURCES_INDEX_2=\
CREATE INDEX TMP_ON_RES_2 ON CMS_ONLINE_RESOURCES(PROJECT_LASTMODIFIED)

CMS_ONLINE_RESOURCES_INDEX_3=\
CREATE INDEX TMP_ON_RES_3 ON CMS_ONLINE_RESOURCES(USER_CREATED)

CMS_ONLINE_RESOURCES_INDEX_4=\
CREATE INDEX TMP_ON_RES_4 ON CMS_ONLINE_RESOURCES(USER_LASTMODIFIED)


CMS_ONLINE_STRUCTURE_INDEX_1=\
CREATE INDEX TMP_ON_STR_1 ON CMS_ONLINE_STRUCTURE(STRUCTURE_ID)

CMS_ONLINE_STRUCTURE_INDEX_2=\
CREATE INDEX TMP_ON_STR_2 ON CMS_ONLINE_STRUCTURE(RESOURCE_ID)

CMS_ONLINE_STRUCTURE_INDEX_3=\
CREATE INDEX TMP_ON_STR_3 ON CMS_ONLINE_STRUCTURE(PARENT_ID)


CMS_PROJECTRESOURCES_INDEX_1=\
CREATE INDEX TMP_PRJ_RES_1 ON CMS_PROJECTRESOURCES(PROJECT_ID)


CMS_PROJECTS_INDEX_1=\
CREATE INDEX TMP_PRJ_1 ON CMS_PROJECTS(PROJECT_ID)

CMS_PROJECTS_INDEX_2=\
CREATE INDEX TMP_PRJ_2 ON CMS_PROJECTS(GROUP_ID)

CMS_PROJECTS_INDEX_3=\
CREATE INDEX TMP_PRJ_3 ON CMS_PROJECTS(MANAGERGROUP_ID)

CMS_PROJECTS_INDEX_4=\
CREATE INDEX TMP_PRJ_4 ON CMS_PROJECTS(USER_ID)


CMS_PUBLISH_HISTORY_INDEX_1=\
CREATE INDEX TMP_PUB_HIST_1 ON CMS_PUBLISH_HISTORY(PUBLISH_TAG)

CMS_PUBLISH_HISTORY_INDEX_2=\
CREATE INDEX TMP_PUB_HIST_2 ON CMS_PUBLISH_HISTORY(HISTORY_ID)