Package org.opencms.setup.db.update6to7.mysql

Class CmsUpdateDBCmsUsers

java.lang.Object

org.opencms.setup.db.A_CmsUpdateDBPart

org.opencms.setup.db.update6to7.CmsUpdateDBCmsUsers

org.opencms.setup.db.update6to7.mysql.CmsUpdateDBCmsUsers

All Implemented Interfaces:

I_CmsUpdateDBPart

public class CmsUpdateDBCmsUsers
extends CmsUpdateDBCmsUsers

This class makes an update of the CMS_USERS table splitting it up into CMS_USERS and CMS_USERDATA.

Unnecessary colums from CMS_USERS will be deleted and the new column USER_DATECREATED is added.

Field Summary

Fields inherited from class org.opencms.setup.db.update6to7.CmsUpdateDBCmsUsers

QUERY_CREATE_TABLE_USERDATA, QUERY_INSERT_CMS_USERDATA

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

m_poolData, m_queries

Constructor Summary

Constructors

Constructor	Description
CmsUpdateDBCmsUsers()	Default constructor.

Method Summary

Modifier and Type	Method	Description
protected void	createUserDataTable(CmsSetupDb dbCon)	Creates the CMS_USERDATA table if it does not exist yet.

Methods inherited from class org.opencms.setup.db.update6to7.CmsUpdateDBCmsUsers

addUserDateCreated, addWebusersToGroup, checkUserDataTable, createWebusersGroup, internalExecute, removeUnnecessaryColumns, writeAdditionalUserInfo, writeUserInfo

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

Constructor Detail

CmsUpdateDBCmsUsers

public CmsUpdateDBCmsUsers()
                    throws java.io.IOException

Default constructor.

Throws:

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

Method Detail

createUserDataTable

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

Creates the CMS_USERDATA table if it does not exist yet.

Overrides:

createUserDataTable in class CmsUpdateDBCmsUsers

Parameters:

dbCon - the db connection interface

Throws:

java.sql.SQLException - if something goes wrong