User Tools

Site Tools


4.2-trunk_버전

4.2 trunk 버전의 default-schema.xml 변경 또는 패치와 관련된 특이 사항 입니다.

1. 15.07.13

가. 성격 : alter
나. 대상 테이블 : KONA_UNIVERSE_DETAIL_S_PARAM
다. 설명 : 4.0 default-schema.xml 병합 작업 시 컬럼 누락
라. 변경 내역 : 추가
              <column name="PARAM_KEY" primaryKey="false" required="false"
		type="VARCHAR" size="50" autoIncrement="false" />
마. 변경 전 -> 변경 후 비교

  1) 변경 전
      <table name="KONA_UNIVERSE_DETAIL_S_PARAM">
	<column name="UNIVERSE_ID" primaryKey="true" required="true"
		type="VARCHAR" size="10" autoIncrement="false" />
	<column name="SEQ" primaryKey="true" required="true" type="INTEGER"
		autoIncrement="false" />
	<column name="PARAM_TYPE" primaryKey="true" required="true"
		type="VARCHAR" size="10" autoIncrement="false" />
	<column name="SP_PARAM_TYPE" primaryKey="false" required="false"
		type="VARCHAR" size="10" autoIncrement="false" />
	<column name="PARAM_EXPR" primaryKey="false" required="false"
		type="VARCHAR" size="2000" autoIncrement="false" />
	<column name="DATA_TYPE" primaryKey="false" required="true"
		type="INTEGER" autoIncrement="false" />
</table>
  2) 변경 후
  	<table name="KONA_UNIVERSE_DETAIL_S_PARAM">
	<column name="UNIVERSE_ID" primaryKey="true" required="true"
		type="VARCHAR" size="10" autoIncrement="false" />
	<column name="SEQ" primaryKey="true" required="true" type="INTEGER"
		autoIncrement="false" />
	<column name="PARAM_KEY" primaryKey="false" required="false"
		type="VARCHAR" size="50" autoIncrement="false" />
	<column name="PARAM_TYPE" primaryKey="true" required="true"
		type="VARCHAR" size="10" autoIncrement="false" />
	<column name="SP_PARAM_TYPE" primaryKey="false" required="false"
		type="VARCHAR" size="10" autoIncrement="false" />
	<column name="PARAM_EXPR" primaryKey="false" required="false"
		type="VARCHAR" size="2000" autoIncrement="false" />
	<column name="DATA_TYPE" primaryKey="false" required="true"
		type="INTEGER" autoIncrement="false" />
</table>
4.2-trunk_버전.txt · Last modified: 2015/07/22 17:30 by jeonjehun86