001
014
015 package com.liferay.portal.upgrade.v6_2_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.upgrade.v6_2_0.util.DDMTemplateTable;
019 import com.liferay.portal.util.PortalUtil;
020 import com.liferay.portlet.dynamicdatamapping.model.DDMTemplate;
021
022 import java.sql.SQLException;
023
024
027 public class UpgradeDynamicDataMapping extends UpgradeProcess {
028
029 @Override
030 protected void doUpgrade() throws Exception {
031 try {
032 runSQL("alter table DDMTemplate add classNameId LONG");
033
034 runSQL("alter table DDMTemplate add templateKey STRING");
035
036 runSQL("alter_column_name DDMTemplate structureId classPK LONG");
037 }
038 catch (SQLException sqle) {
039 upgradeTable(
040 DDMTemplateTable.TABLE_NAME, DDMTemplateTable.TABLE_COLUMNS,
041 DDMTemplateTable.TABLE_SQL_CREATE,
042 DDMTemplateTable.TABLE_SQL_ADD_INDEXES);
043 }
044
045 long classNameId = PortalUtil.getClassNameId(DDMTemplate.class);
046
047 runSQL("update DDMTemplate set classNameId = " + classNameId);
048 }
049
050 }