org.opencms.setup.update6to7.generic
Class CmsUpdateDBDropOldIndexes

java.lang.Object
  extended by org.opencms.setup.update6to7.A_CmsUpdateDBPart
      extended by org.opencms.setup.update6to7.generic.CmsUpdateDBDropOldIndexes
All Implemented Interfaces:
I_CmsUpdateDBPart
Direct Known Subclasses:
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
Version:
$Revision: 1.3 $
Author:
Roland Metzler

Field Summary
protected static java.lang.String[] CMS_TABLES
          Constant array of the base tables of the OpenCms 7.0.x installation.
protected static java.util.List CMS_TABLES_LIST
          Constant ArrayList of the tables of the base OpenCms 7.0.x installation.
protected static java.lang.String QUERY_DROP_INDEX
          Constant for the sql query to drop an index from a table.
protected static java.lang.String QUERY_SHOW_INDEX
          Constant for the sql query to show the indexes of a table.
protected static java.lang.String REPLACEMENT_TABLENAME
          Constant for the sql query replacement of the tablename.
 
Fields inherited from class org.opencms.setup.update6to7.A_CmsUpdateDBPart
m_poolData, m_queries, QUERY_PROPERTIES_PREFIX
 
Constructor Summary
CmsUpdateDBDropOldIndexes()
          Constructor.
 
Method Summary
protected  void internalExecute(CmsSetupDb dbCon)
          Does the hard work.
 
Methods inherited from class org.opencms.setup.update6to7.A_CmsUpdateDBPart
execute, getDbInstance, getPoolData, isKeepHistory, loadQueryProperties, readQuery, setPoolData
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

CMS_TABLES

protected static final java.lang.String[] CMS_TABLES
Constant array of the base tables of the OpenCms 7.0.x installation.


CMS_TABLES_LIST

protected static final java.util.List CMS_TABLES_LIST
Constant ArrayList of the tables of the base OpenCms 7.0.x installation.


QUERY_DROP_INDEX

protected static final java.lang.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 java.lang.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 java.lang.String REPLACEMENT_TABLENAME
Constant for the sql query replacement of the tablename.

See Also:
Constant Field Values
Constructor Detail

CmsUpdateDBDropOldIndexes

public CmsUpdateDBDropOldIndexes()
                          throws java.io.IOException
Constructor.

Throws:
java.io.IOException - if the query properties cannot be read
Method Detail

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)