org.opencms.setup.db.update6to7

类 CmsUpdateDBAlterTables

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBAlterTables

所有已实现的接口:

I_CmsUpdateDBPart

直接已知子类:

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

从以下版本开始:

7.0.0

字段概要

字段

限定符和类型	字段和说明
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.

从类继承的字段 org.opencms.setup.db.A_CmsUpdateDBPart

m_poolData, m_queries

构造器概要

构造器

构造器和说明
CmsUpdateDBAlterTables() Default constructor.

方法概要

方法

限定符和类型	方法和说明
protected void	internalExecute(CmsSetupDb dbCon) Does the hard work.

从类继承的方法 org.opencms.setup.db.A_CmsUpdateDBPart

execute, getPoolData, getPropertyFileLocation, isKeepHistory, loadQueryProperties, readQuery

从类继承的方法 java.lang.Object

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

字段详细资料

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.

另请参阅:

常量字段值

COLUMN_CMS_PROPERTYDEF_TYPE

protected static final java.lang.String COLUMN_CMS_PROPERTYDEF_TYPE

Constant for the column PROPERTYDEF_TYPE of the PROPERTYDEF tables.

另请参阅:

常量字段值

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.

另请参阅:

常量字段值

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.

另请参阅:

常量字段值

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.

另请参阅:

常量字段值

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.

另请参阅:

常量字段值

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.

另请参阅:

常量字段值

REPLACEMENT_TABLENAME

protected static final java.lang.String REPLACEMENT_TABLENAME

Constant for the sql replacement of the tablename.

另请参阅:

常量字段值

TABLE_CMS_OFFLINE_CONTENTS

protected static final java.lang.String TABLE_CMS_OFFLINE_CONTENTS

Constant for the table name CMS_OFFLINE_CONTENTS.

另请参阅:

常量字段值

TABLE_CMS_PROJECTS

protected static final java.lang.String TABLE_CMS_PROJECTS

Constant for the table name CMS_PROJECTS.

另请参阅:

常量字段值

构造器详细资料

CmsUpdateDBAlterTables

public CmsUpdateDBAlterTables()
                       throws java.io.IOException

Default constructor.

抛出:

java.io.IOException - if the default sql queries property file could not be read

方法详细资料

internalExecute

protected void internalExecute(CmsSetupDb dbCon)
                        throws java.sql.SQLException

从类复制的说明: A_CmsUpdateDBPart

Does the hard work.

指定者:

internalExecute 在类中 A_CmsUpdateDBPart

参数:

dbCon - the db connection interface

抛出:

java.sql.SQLException - if something goes wrong

另请参阅:

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