Package org.opencms.setup.db.update6to7

Class CmsUpdateDBDropOldIndexes

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBDropOldIndexes

All Implemented Interfaces:

I_CmsUpdateDBPart

Direct Known Subclasses:

CmsUpdateDBDropOldIndexes, CmsUpdateDBDropOldIndexes, CmsUpdateDBDropOldIndexes

public class CmsUpdateDBDropOldIndexes
extends A_CmsUpdateDBPart

This class drops all indexes of each table of the database.

This is done so that the indexes can be updated to the version 6.2.3 and afterwards to version 7

Since:

7.0.0

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String[]	CMS_TABLES	Constant array of the base tables of the OpenCms 7.0.x installation.
protected static final List<String>	CMS_TABLES_LIST	Constant ArrayList of the tables of the base OpenCms 7.0.x installation.
protected static final String	QUERY_DROP_INDEX	Constant for the sql query to drop an index from a table.
protected static final String	QUERY_SHOW_INDEX	Constant for the sql query to show the indexes of a table.
protected static final String	REPLACEMENT_TABLENAME	Constant for the sql query replacement of the tablename.

Fields inherited from class org.opencms.setup.db.A_CmsUpdateDBPart

m_poolData, m_queries

Constructor Summary

Constructors

Constructor	Description
CmsUpdateDBDropOldIndexes()	Constructor.

Method Summary

Modifier and Type	Method	Description
protected void	internalExecute(CmsSetupDb dbCon)	Does the hard work.

Methods inherited from class org.opencms.setup.db.A_CmsUpdateDBPart

execute, getPoolData, getPropertyFileLocation, isKeepHistory, loadQueryProperties, readQuery

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

CMS_TABLES

protected static final String[] CMS_TABLES

Constant array of the base tables of the OpenCms 7.0.x installation.

CMS_TABLES_LIST

protected static final List<String> CMS_TABLES_LIST

Constant ArrayList of the tables of the base OpenCms 7.0.x installation.

QUERY_DROP_INDEX

protected static final String QUERY_DROP_INDEX

Constant for the sql query to drop an index from a table.

See Also:

• Constant Field Values

QUERY_SHOW_INDEX

protected static final String QUERY_SHOW_INDEX

Constant for the sql query to show the indexes of a table.

See Also:

• Constant Field Values

REPLACEMENT_TABLENAME

protected static final String REPLACEMENT_TABLENAME

Constant for the sql query replacement of the tablename.

See Also:

• Constant Field Values

Constructor Details

CmsUpdateDBDropOldIndexes

public CmsUpdateDBDropOldIndexes()
                          throws IOException

Constructor.

Throws:

IOException - if the query properties cannot be read

Method Details

internalExecute

protected void internalExecute(CmsSetupDb dbCon)

Description copied from class: A_CmsUpdateDBPart

Does the hard work.

Specified by:

internalExecute in class A_CmsUpdateDBPart

Parameters:

dbCon - the db connection interface

See Also:

• A_CmsUpdateDBPart.internalExecute(org.opencms.setup.CmsSetupDb)