Package org.opencms.setup.db.update6to7
Class CmsUpdateDBAlterTables
- java.lang.Object
-
- org.opencms.setup.db.A_CmsUpdateDBPart
-
- org.opencms.setup.db.update6to7.CmsUpdateDBAlterTables
-
- All Implemented Interfaces:
I_CmsUpdateDBPart
- Direct Known Subclasses:
CmsUpdateDBAlterTables
,CmsUpdateDBAlterTables
,CmsUpdateDBAlterTables
public class CmsUpdateDBAlterTables extends A_CmsUpdateDBPart
This class makes the remaining changes to some tables in order to update them.The following tables will be altered CMS_ONLINE/OFFLINE_PROPERTYDEF Add the TYPE column CMS_ONLINE/OFFLINE_RESOURCES Add the columns DATE_CONTENT and RESOURCE_VERSION CMS_ONLINE/OFFLINE_STRUCTURE Add the column STRUCTURE_VERSION CMS_PROJECTS Drop the column TASK_ID and change the size for the project name
- Since:
- 7.0.0
-
-
Field Summary
Fields Modifier and Type Field Description protected static java.lang.String[]
CMS_OFFLINE_CONTENTS_QUERIES
Constant array with the queries for the CMS_ONLINE_CONTENTS table.protected static java.util.List<java.lang.String>
CMS_OFFLINE_CONTENTS_QUERIES_LIST
Constant ArrayList of the queries of the CMS_OFFLINE table.protected static java.lang.String[]
CMS_PROPERTYDEF
Constant array with the ONLINE and OFFLINE PROPERTYDEF tables.protected static java.util.List<java.lang.String>
CMS_PROPERTYDEF_LIST
Constant ArrayList of the two PROPERTYDEF tables.protected static java.lang.String[]
CMS_RESOURCES
Constant array with the ONLINE and OFFLINE RESOURCES tables.protected static java.util.List<java.lang.String>
CMS_RESOURCES_LIST
Constant ArrayList of the two RESOURCES tables.protected static java.lang.String[]
CMS_STRUCTURE
Constant array with the ONLINE and OFFLINE STRUCTURE tables.protected static java.util.List<java.lang.String>
CMS_STRUCTURE_LIST
Constant ArrayList of the two PROPERTYDEF tables.protected static java.lang.String
COLUMN_CMS_OFFLINE_CONTENTS_CONTENT_ID
Constant for the column CONTENT_ID of the table CMS_OFFLINE_CONTENTS.protected static java.lang.String
COLUMN_CMS_PROPERTYDEF_TYPE
Constant for the column PROPERTYDEF_TYPE of the PROPERTYDEF tables.protected static java.lang.String
COLUMN_CMS_STRUCTURE_STRUCTURE_VERSION
Constant for the column STRUCTURE_VERSION in the STRUCTURE tables.protected static java.lang.String
COLUMN_PROJECTS_PROJECT_NAME
Constant for the column PROJECT_NAME of the CMS_PROJECTS table.protected static java.lang.String
COLUMN_PROJECTS_TASK_ID
Constant for the column TASK_ID of the CMS_PROJECTS table.protected static java.lang.String
COLUMN_RESOURCES_DATE_CONTENT
Constant for the new column DATE_CONTENT of the CMS_RESOURCES tables.protected static java.lang.String
COLUMN_RESOURCES_RESOURCE_VERSION
Constant for the new column RESOURCE_VERSION of the CMS_RESOURCES tables.protected static java.lang.String
REPLACEMENT_TABLENAME
Constant for the sql replacement of the tablename.protected static java.lang.String
TABLE_CMS_OFFLINE_CONTENTS
Constant for the table name CMS_OFFLINE_CONTENTS.protected static java.lang.String
TABLE_CMS_PROJECTS
Constant for the table name CMS_PROJECTS.-
Fields inherited from class org.opencms.setup.db.A_CmsUpdateDBPart
m_poolData, m_queries
-
-
Constructor Summary
Constructors Constructor Description CmsUpdateDBAlterTables()
Default constructor.
-
Method Summary
All Methods Instance Methods Concrete Methods 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
-
-
-
-
Field Detail
-
CMS_OFFLINE_CONTENTS_QUERIES
protected static final java.lang.String[] CMS_OFFLINE_CONTENTS_QUERIES
Constant array with the queries for the CMS_ONLINE_CONTENTS table.
-
CMS_OFFLINE_CONTENTS_QUERIES_LIST
protected static final java.util.List<java.lang.String> CMS_OFFLINE_CONTENTS_QUERIES_LIST
Constant ArrayList of the queries of the CMS_OFFLINE table.
-
CMS_PROPERTYDEF
protected static final java.lang.String[] CMS_PROPERTYDEF
Constant array with the ONLINE and OFFLINE PROPERTYDEF tables.
-
CMS_PROPERTYDEF_LIST
protected static final java.util.List<java.lang.String> CMS_PROPERTYDEF_LIST
Constant ArrayList of the two PROPERTYDEF tables.
-
CMS_RESOURCES
protected static final java.lang.String[] CMS_RESOURCES
Constant array with the ONLINE and OFFLINE RESOURCES tables.
-
CMS_RESOURCES_LIST
protected static final java.util.List<java.lang.String> CMS_RESOURCES_LIST
Constant ArrayList of the two RESOURCES tables.
-
CMS_STRUCTURE
protected static final java.lang.String[] CMS_STRUCTURE
Constant array with the ONLINE and OFFLINE STRUCTURE tables.
-
CMS_STRUCTURE_LIST
protected static final java.util.List<java.lang.String> CMS_STRUCTURE_LIST
Constant ArrayList of the two PROPERTYDEF tables.
-
COLUMN_CMS_OFFLINE_CONTENTS_CONTENT_ID
protected static final java.lang.String COLUMN_CMS_OFFLINE_CONTENTS_CONTENT_ID
Constant for the column CONTENT_ID of the table CMS_OFFLINE_CONTENTS.- See Also:
- Constant Field Values
-
COLUMN_CMS_PROPERTYDEF_TYPE
protected static final java.lang.String COLUMN_CMS_PROPERTYDEF_TYPE
Constant for the column PROPERTYDEF_TYPE of the PROPERTYDEF tables.- See Also:
- Constant Field Values
-
COLUMN_CMS_STRUCTURE_STRUCTURE_VERSION
protected static final java.lang.String COLUMN_CMS_STRUCTURE_STRUCTURE_VERSION
Constant for the column STRUCTURE_VERSION in the STRUCTURE tables.- See Also:
- Constant Field Values
-
COLUMN_PROJECTS_PROJECT_NAME
protected static final java.lang.String COLUMN_PROJECTS_PROJECT_NAME
Constant for the column PROJECT_NAME of the CMS_PROJECTS table.- See Also:
- Constant Field Values
-
COLUMN_PROJECTS_TASK_ID
protected static final java.lang.String COLUMN_PROJECTS_TASK_ID
Constant for the column TASK_ID of the CMS_PROJECTS table.- See Also:
- Constant Field Values
-
COLUMN_RESOURCES_DATE_CONTENT
protected static final java.lang.String COLUMN_RESOURCES_DATE_CONTENT
Constant for the new column DATE_CONTENT of the CMS_RESOURCES tables.- See Also:
- Constant Field Values
-
COLUMN_RESOURCES_RESOURCE_VERSION
protected static final java.lang.String COLUMN_RESOURCES_RESOURCE_VERSION
Constant for the new column RESOURCE_VERSION of the CMS_RESOURCES tables.- See Also:
- Constant Field Values
-
REPLACEMENT_TABLENAME
protected static final java.lang.String REPLACEMENT_TABLENAME
Constant for the sql replacement of the tablename.- See Also:
- Constant Field Values
-
TABLE_CMS_OFFLINE_CONTENTS
protected static final java.lang.String TABLE_CMS_OFFLINE_CONTENTS
Constant for the table name CMS_OFFLINE_CONTENTS.- See Also:
- Constant Field Values
-
TABLE_CMS_PROJECTS
protected static final java.lang.String TABLE_CMS_PROJECTS
Constant for the table name CMS_PROJECTS.- See Also:
- Constant Field Values
-
-
Constructor Detail
-
CmsUpdateDBAlterTables
public CmsUpdateDBAlterTables() throws java.io.IOException
Default constructor.- Throws:
java.io.IOException
- if the default sql queries property file could not be read
-
-
Method Detail
-
internalExecute
protected void internalExecute(CmsSetupDb dbCon) throws java.sql.SQLException
Description copied from class:A_CmsUpdateDBPart
Does the hard work.- Specified by:
internalExecute
in classA_CmsUpdateDBPart
- Parameters:
dbCon
- the db connection interface- Throws:
java.sql.SQLException
- if something goes wrong- See Also:
A_CmsUpdateDBPart.internalExecute(org.opencms.setup.CmsSetupDb)
-
-