CmsUpdateDBCmsUsers (OpenCms Setup API, version 18.0)

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 Details
- CmsUpdateDBCmsUsers
  
  public CmsUpdateDBCmsUsers() throws IOException
  
  Default constructor.
  
  Throws:
  
  IOException - if the default sql queries property file could not be read
Method Details
- createUserDataTable
  
  protected void createUserDataTable(CmsSetupDb dbCon) throws SQLException
  
  Creates the CMS_USERDATA table if it does not exist yet.
  
  Overrides:
  
  createUserDataTable in class CmsUpdateDBCmsUsers
  
  Parameters:
  
  dbCon - the db connection interface
  
  Throws:
  
  SQLException - if something goes wrong