uCosminexus Portal Framework 06-11以前のバージョンからバージョンアップする場合,共通情報を使用しているときは,表示属性を使用するための設定をします。
表示属性を使用するための設定手順を次に示します。なお,DBにHiRDBを使用している場合は,この手順を実施する前に,RDエリア(RDARRANGE)を追加しておいてください。
CREATE TABLE PORTLET_ARRANGE
(
LAYOUTID MVARCHAR(64) NOT NULL,
AREAID MVARCHAR(64) NOT NULL,
PORTLETNAME MVARCHAR(64) NOT NULL,
PARAMNAME MVARCHAR(255) NOT NULL,
PARAMVALUE MVARCHAR(255) NOT NULL,
UPDATECD MVARCHAR(20),
DELETEFLG MVARCHAR(1)
) IN RDARRANGE;
CREATE INDEX PORTLET_ARRANGE_INDX1 ON PORTLET_ARRANGE(LAYOUTID) IN RDARRANGE;
CREATE INDEX PORTLET_ARRANGE_INDX2 ON PORTLET_ARRANGE(AREAID) IN RDARRANGE;
CREATE INDEX PORTLET_ARRANGE_INDX3 ON PORTLET_ARRANGE(PORTLETNAME) IN RDARRANGE;
CREATE INDEX PORTLET_ARRANGE_INDX4 ON PORTLET_ARRANGE(UPDATECD) IN RDARRANGE;
CREATE INDEX PORTLET_ARRANGE_INDX5 ON PORTLET_ARRANGE(DELETEFLG) IN RDARRANGE;
CREATE TABLE PORTLET_ARRANGE
(
LAYOUTID VARCHAR2(64) NOT NULL,
AREAID VARCHAR2(64) NOT NULL,
PORTLETNAME VARCHAR2(64) NOT NULL,
PARAMNAME VARCHAR2(255) NOT NULL,
PARAMVALUE VARCHAR2(255) NOT NULL,
UPDATECD VARCHAR2(20),
DELETEFLG VARCHAR2(1)
) ;
CREATE INDEX PORTLET_ARRANGE_INDX1 ON PORTLET_ARRANGE(LAYOUTID);
CREATE INDEX PORTLET_ARRANGE_INDX2 ON PORTLET_ARRANGE(AREAID);
CREATE INDEX PORTLET_ARRANGE_INDX3 ON PORTLET_ARRANGE(PORTLETNAME);
CREATE INDEX PORTLET_ARRANGE_INDX4 ON PORTLET_ARRANGE(UPDATECD);
CREATE INDEX PORTLET_ARRANGE_INDX5 ON PORTLET_ARRANGE(DELETEFLG);
<resource name="PORTLETARRANGE-R" type="DB">
<connection>DB-EM</connection>
<table name="PORTLET_ARRANGE" key="layoutid"/>
</resource>
<resource name="PORTLETARRANGE-W" type="DB">
<connection>DB-EM</connection>
<table name="PORTLET_ARRANGE" key="layoutid"/>
</resource>
<Mapping dest="ARRANGELAYOUTID_R" src="layoutid" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGEAREAID_R" src="areaid" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGEPORTLET_R" src="portletname" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGEPARAMNAME_R" src="paramname" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGEPARAMVALUE_R" src="paramvalue" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGEUPDATECD_R" src="updatecd" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGEDELETEFLG_R" src="deleteflg" options="multivalue=multirecord">PORTLETARRANGE-R</Mapping>
<Mapping dest="ARRANGELAYOUTID_W" src="layoutid" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>
<Mapping dest="ARRANGEAREAID_W" src="areaid" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>
<Mapping dest="ARRANGEPORTLET_W" src="portletname" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>
<Mapping dest="ARRANGEPARAMNAME_W" src="paramname" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>
<Mapping dest="ARRANGEPARAMVALUE_W" src="paramvalue" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>
<Mapping dest="ARRANGEUPDATECD_W" src="updatecd" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>
<Mapping dest="ARRANGEDELETEFLG_W" src="deleteflg" options="multivalue=multirecord">PORTLETARRANGE-W</Mapping>