|
||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.opencms.setup.update6to7.A_CmsUpdateDBPart
org.opencms.setup.update6to7.generic.CmsUpdateDBProjectId
org.opencms.setup.update6to7.mysql.CmsUpdateDBProjectId
public class CmsUpdateDBProjectId
This class updates the project ids from integer values to CmsUUIDs in all existing database tables.
It creates new UUIDs for each existing project and stores it into a temporary table.
For each table using a project id a new column for the UUID is added and the according data is transferred.
After that the original indexes and the column for the project id index is dropped and the new column with the project uuid becomes the primary key.
Field Summary |
---|
Fields inherited from class org.opencms.setup.update6to7.A_CmsUpdateDBPart |
---|
m_poolData, m_queries, QUERY_PROPERTIES_PREFIX |
Constructor Summary | |
---|---|
CmsUpdateDBProjectId()
Constructor. |
Method Summary | |
---|---|
protected void |
createHistProjectsTable(CmsSetupDb dbCon)
Creates the CMS_HISTORY_PROJECTS table if it does not exist yet. |
protected void |
createTempTable(CmsSetupDb dbCon)
Creates the temp table for project ids if it does not exist yet. |
Methods inherited from class org.opencms.setup.update6to7.generic.CmsUpdateDBProjectId |
---|
addPrimaryKey, addUUIDColumnToTable, checkColumnTypeProjectId, getColumnProjectIdResourcePath, internalExecute, needsUpdating, transferDataToHistoryTable |
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 |
Constructor Detail |
---|
public CmsUpdateDBProjectId() throws java.io.IOException
java.io.IOException
- if the query properties cannot be readMethod Detail |
---|
protected void createHistProjectsTable(CmsSetupDb dbCon) throws java.sql.SQLException
createHistProjectsTable
in class CmsUpdateDBProjectId
dbCon
- the db connection interface
java.sql.SQLException
- if soemthing goes wrongprotected void createTempTable(CmsSetupDb dbCon) throws java.sql.SQLException
createTempTable
in class CmsUpdateDBProjectId
dbCon
- the db connection interface
java.sql.SQLException
- if soemthing goes wrong
|
||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |