Jetspeed 2 企業ポータル
The following tables describe database schema changes from version 2.1 to version 2.1.2.
以下の表で，バージョン 2.1 と 2.1.2 の間でデータベーススキーマが変更されたものについて説明しています．
The following items describe important functional changes in Jetspeed 2.1
以下，Jetspeed 2.1 での重要な機能変更について述べます．
Portlet Preferences are now by default user specific on all pages. In Jetspeed 2.0, for shared pages, the Portlet Preferences were shared as well.
ポートレットプリファレンスは，全てのページにおいて，デフォルトでユーザ特有となりました．Jetspeed 2.0 では，共有ページでは，ポートレットプリファレンスは共有されていました．
To retain most of the old Jetspeed 2.0 behavior, allowing an administrator to still set/modify initial Preferences for other users,
modify the following setting in the registry.xml spring assembly configuration for the portletEntityAccessImpl component:
Jetspeed 2.0 での古い動きのほとんどを保存するため，管理者が他のユーザに対する初期設定を設定/変更するのを許すには，portletEntityAccessImpl コンポーネントに対する Spring の設定である registry.xml の設定を以下のように変更するしてください．
<!-- All preferences were shared. With JS2-449, preferences are now stored 'per user'. The username is stored in the preferences FULL_PATH To turn on mergeSharedPreferences configure this property to true This will NOT turn off per user prefs, but instead merge with them, where user prefs override. boolean --> <constructor-arg type="boolean"> <value>false</value> </constructor-arg>
<!-- 全設定は共有されていました．JS2-449 で，設定はユーザごとに保存されるようになりました． ユーザ名は FULL_PATH という設定項目に保存されます． mergeSharedPreferences 設定をオンにするには，このプロパティを true に設定します． これは，ユーザごとの設定をオフにはしません．しかし，これらをまとめることにより， ユーザの設定を上書きします． boolean --> <constructor-arg type="boolean"> <value>false</value> </constructor-arg>
As is commented in the assembly configuration also, setting mergeSharedPreferences to true will NOT turn off per user Preferences.
Once a user sets its own Preference values (if allowed), those will override the shared Preference values.
See for further information: JS2-449
設定のコメントにもあるように，mergeSharedPreferences の設定を true にすることは，ユーザ毎の設定をオフにすることには なりません．あるユーザが自身の設定値を設定した時点で (もしゆるされている場合)，共有の設定値は上書きされます．
詳しい情報は JS-449 を参照してください．
The following tables describe database schema changes from version 2.0 to version 2.1.
以下の表で，バージョン 2.0 から 2.1 でデータベーススキーマの変更があったものについて説明しています．
| Table |
|---|
| CUSTOM_PORTLET_MODE |
| CUSTOM_WINDOW_STATE |
| Table |
|---|
| CUSTOM_PORTLET_MODE |
| CUSTOM_WINDOW_STATE |
| Table | Column | 2.0 | 2.1 |
|---|---|---|---|
| PORTLET_STATISTICS | ELAPSED_TIME | INTEGER | BIGINT |
| PAGE_STATISTICS | ELAPSED_TIME | INTEGER | BIGINT |
| USER_STATISTICS | ELAPSED_TIME | INTEGER | BIGINT |
| FOLDER | SKIN | NEW: VARCHAR(80) | |
| FOLDER | DEFAULT_LAYOUT_DECORATOR | NEW: VARCHAR(80) | |
| FOLDER | DEFAULT_PORTLET_DECORATOR | NEW: VARCHAR(80) | |
| FRAGMENT | STATE | VARCHAR(40) | VARCHAR(10) |
| FRAGMENT | PMODE | NEW: VARCHAR(10) | |
| FRAGMENT | LAYOUT_X | NEW: REAL | |
| FRAGMENT | LAYOUT_Y | NEW: REAL | |
| FRAGMENT | LAYOUT_Z | NEW: REAL | |
| FRAGMENT | LAYOUT_WIDTH | NEW: REAL | |
| FRAGMENT | LAYOUT_HEIGHT | NEW: REAL | |
| LINK | SKIN | NEW: VARCHAR(80) | |
| PORTLET_DEFINITION | SECURITY_REF | NEW: VARCHAR(40) | |
| PORTLET_DEFINITION | SECURITY_REF | NEW: VARCHAR(40) | |
| PORTLET_APPLICATION | SECURITY_REF | NEW: VARCHAR(40) | |
| SSO_COOKIE | COOKIE | VARCHAR(250) | VARCHAR(1024) |
| Table | Column | 2.0 | 2.1 |
|---|---|---|---|
| PORTLET_STATISTICS | ELAPSED_TIME | INTEGER | BIGINT |
| PAGE_STATISTICS | ELAPSED_TIME | INTEGER | BIGINT |
| USER_STATISTICS | ELAPSED_TIME | INTEGER | BIGINT |
| FOLDER | SKIN | NEW: VARCHAR(80) | |
| FOLDER | DEFAULT_LAYOUT_DECORATOR | NEW: VARCHAR(80) | |
| FOLDER | DEFAULT_PORTLET_DECORATOR | NEW: VARCHAR(80) | |
| FRAGMENT | STATE | VARCHAR(40) | VARCHAR(10) |
| FRAGMENT | PMODE | NEW: VARCHAR(10) | |
| FRAGMENT | LAYOUT_X | NEW: REAL | |
| FRAGMENT | LAYOUT_Y | NEW: REAL | |
| FRAGMENT | LAYOUT_Z | NEW: REAL | |
| FRAGMENT | LAYOUT_WIDTH | NEW: REAL | |
| FRAGMENT | LAYOUT_HEIGHT | NEW: REAL | |
| LINK | SKIN | NEW: VARCHAR(80) | |
| PORTLET_DEFINITION | SECURITY_REF | NEW: VARCHAR(40) | |
| PORTLET_DEFINITION | SECURITY_REF | NEW: VARCHAR(40) | |
| PORTLET_APPLICATION | SECURITY_REF | NEW: VARCHAR(40) | |
| SSO_COOKIE | COOKIE | VARCHAR(250) | VARCHAR(1024) |
| Table | Index | 2.0 | 2.1 |
|---|---|---|---|
| FOLDER_MENU | UN_FOLDER_MENU_1 | unique | (non unique) index |
| PAGE_MENU | UN_PAGE_MENU_1 | unique | (non unique) index |
| FRAGMENT | UN_FRAGMENT_1 | unique | (non unique) index |
| Table | Index | 2.0 | 2.1 |
|---|---|---|---|
| FOLDER_MENU | UN_FOLDER_MENU_1 | 一意性制約 | (一意性制約ではない) index |
| PAGE_MENU | UN_PAGE_MENU_1 | 一意性制約 | (一意性制約ではない) index |
| FRAGMENT | UN_FRAGMENT_1 | 一意性制約 | (一意性制約ではない) index |
| Table | Column | 2.0 | 2.1 |
|---|---|---|---|
| FOLDER | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_1" |
| FOLDER_METADATA | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_METADATA_1" |
| FOLDER_CONSTRAINT | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_CONSTRAINT_1" |
| FOLDER_CONSTRAINTS_REF | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_CONSTRAINT_REF_1" |
| FOLDER_ORDER | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_ORDER_1" |
| FOLDER_MENU | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_MENU_1" |
| FOLDER_MENU | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_MENU_2" |
| FOLDER_MENU_METADATA | (FK constraint) | (not named) | named FK constraint "FK_FOLDER_MENU_METADATA_1" |
| PAGE | (FK constraint) | (not named) | named FK constraint "FK_PAGE_1" |
| PAGE_METADATA | (FK constraint) | (not named) | named FK constraint "FK_PAGE_METADATA_1" |
| PAGE_CONSTRAINT | (FK constraint) | (not named) | named FK constraint "FK_PAGE_CONSTRAINT_1" |
| PAGE_CONSTRAINT_REF | (FK constraint) | (not named) | named FK constraint "FK_PAGE_CONSTRAINTS_REF_1" |
| PAGE_MENU | (FK constraint) | (not named) | named FK constraint "FK_PAGE_MENU_1" |
| PAGE_MENU | (FK constraint) | (not named) | named FK constraint "PM_M_FK_PAGE_ID_PAGE" |
| PAGE_MENU_METADATA | (FK constraint) | (not named) | named FK constraint "FK_PAGE_MENU_METADATA_1" |
| FRAGMENT | (FK constraint) | (not named) | named FK constraint "FK_FRAGMENT_1" |
| FRAGMENT | (FK constraint) | (not named) | named FK constraint "FK_FRAGMENT_2" |
| FRAGMENT_CONSTRAINT | (FK constraint) | (not named) | named FK constraint "FK_FRAGMENT_CONSTRAINT_1" |
| FRAGMENT_CONSTRAINT_REF | (FK constraint) | (not named) | named FK constraint "FK_FRAGMENT_CONSTRAINT_REF_1" |
| FRAGMENT_PREF | (FK constraint) | (not named) | named FK constraint "FK_FRAGMENT_PREF_1" |
| FRAGMENT_PREF_VALUE | (FK constraint) | (not named) | named FK constraint "FK_FRAGMENT_PREF_VALUE_1" |
| LINK | (FK constraint) | (not named) | named FK constraint "FK_LINK_1" |
| LINK_METADATA | (FK constraint) | (not named) | named FK constraint "FK_LINK_METADATA_1" |
| LINK_CONSTRAINT | (FK constraint) | (not named) | named FK constraint "FK_LINK_CONSTRAINT_1" |
| LINK_CONSTRAINT_REF | (FK constraint) | (not named) | named FK constraint "FK_LINK_CONSTRAINT_REF_1" |
| PAGE_SECURITY | (FK constraint) | (not named) | named FK constraint "FK_PAGE_SECURITY_1" |
| PAGE_SEC_CONSTRAINTS_DEF | (FK constraint) | (not named) | named FK constraint "FK_PAGE_SEC_CONSTRAINTS_DEF_1" |
| PAGE_SEC_CONSTRAINT_DEF | (FK constraint) | (not named) | named FK constraint "FK_PAGE_SEC_CONSTRAINT_DEF_1" |
| PAGE_SEC_CONSTRAINTS_REF | (FK constraint) | (not named) | named FK constraint "FK_PAGE_SEC_CONSTRAINTS_REF_1" |
| PAGE_SEC_CONSTRAINT_REF | (FK constraint) | (not named) | named FK constraint "FK_PAGE_SEC_CONSTRAINT_REF_1" |
| RULE_CRITERION | (FK constraint) | (not named) | named FK constraint "FK_RULE_CRITERION_1" |
| PREFS_NODE | (FK constraint) | (not named) | named FK constraint "FK_PREFS_NODE_1" |
| PA_METADATA_FIELDS | (FK constraint) | (not named) | named FK constraint "FK_PA_METADATA_FIELDS_1" |
| PD_METADATA_FIELDS | (FK constraint) | (not named) | named FK constraint "FK_PD_METADATA_FIELDS_1" |
| USER_ATTRIBUTE_REF | (FK constraint) | (not named) | named FK constraint "FK_USER_ATTRIBUTE_REF_1" |
| USER_ATTRIBUTE | (FK constraint) | (not named) | named FK constraint "FK_USER_ATTRIBUTE_1" |
| PRINCIPAL_PERMISSION | (FK constraint) | (not named) | named FK constraint "FK_PRINCIPAL_PERMISSION_1" |
| PRINCIPAL_PERMISSION | (FK constraint) | (not named) | named FK constraint "FK_PRINCIPAL_PERMISSION_2" |
| SECURITY_CREDENTIAL | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_CREDENTIAL_1" |
| SSO_SITE_TO_PRINCIPALS | (FK constraint) | (not named) | named FK constraint "SSO_SITE_TO_PRINC_FK1" |
| SSO_SITE_TO_PRINCIPALS | (FK constraint) | (not named) | named FK constraint "SSO_SITE_TO_PRINC_FK2" |
| SSO_PRINCIPAL_TO_REMOTE | (FK constraint) | (not named) | named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_1" |
| SSO_PRINCIPAL_TO_REMOTE | (FK constraint) | (not named) | named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_2" |
| SSO_SITE_TO_REMOTE | (FK constraint) | (not named) | named FK constraint "FK_SSO_SITE_TO_REMOTE_1" |
| SSO_SITE_TO_REMOTE | (FK constraint) | (not named) | named FK constraint "FK_SSO_SITE_TO_REMOTE_2" |
| SSO_COOKIE_TO_REMOTE | (FK constraint) | (not named) | named FK constraint "FK_SSO_COOKIE_TO_REMOTE_1" |
| SSO_COOKIE_TO_REMOTE | (FK constraint) | (not named) | named FK constraint "FK_SSO_COOKIE_TO_REMOTE_2" |
| SECURITY_USER_ROLE | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_USER_ROLE_1" |
| SECURITY_USER_ROLE | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_USER_ROLE_2" |
| SECURITY_USER_GROUP | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_USER_GROUP_1" |
| SECURITY_USER_GROUP | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_USER_GROUP_2" |
| SECURITY_GROUP_ROLE | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_GROUP_ROLE_1" |
| SECURITY_GROUP_ROLE | (FK constraint) | (not named) | named FK constraint "FK_SECURITY_GROUP_ROLE_2" |
| Table | Column | 2.0 | 2.1 |
|---|---|---|---|
| FOLDER | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_1" |
| FOLDER_METADATA | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_METADATA_1" |
| FOLDER_CONSTRAINT | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_CONSTRAINT_1" |
| FOLDER_CONSTRAINTS_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_CONSTRAINT_REF_1" |
| FOLDER_ORDER | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_ORDER_1" |
| FOLDER_MENU | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_MENU_1" |
| FOLDER_MENU | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_MENU_2" |
| FOLDER_MENU_METADATA | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FOLDER_MENU_METADATA_1" |
| PAGE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_1" |
| PAGE_METADATA | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_METADATA_1" |
| PAGE_CONSTRAINT | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_CONSTRAINT_1" |
| PAGE_CONSTRAINT_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_CONSTRAINTS_REF_1" |
| PAGE_MENU | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_MENU_1" |
| PAGE_MENU | (外部キー制約) | (名前なし) | 外部キー制約 "PM_M_FK_PAGE_ID_PAGE" |
| PAGE_MENU_METADATA | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_MENU_METADATA_1" |
| FRAGMENT | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FRAGMENT_1" |
| FRAGMENT | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FRAGMENT_2" |
| FRAGMENT_CONSTRAINT | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FRAGMENT_CONSTRAINT_1" |
| FRAGMENT_CONSTRAINT_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FRAGMENT_CONSTRAINT_REF_1" |
| FRAGMENT_PREF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FRAGMENT_PREF_1" |
| FRAGMENT_PREF_VALUE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_FRAGMENT_PREF_VALUE_1" |
| LINK | (外部キー制約) | (名前なし) | 外部キー制約 "FK_LINK_1" |
| LINK_METADATA | (外部キー制約) | (名前なし) | 外部キー制約 "FK_LINK_METADATA_1" |
| LINK_CONSTRAINT | (外部キー制約) | (名前なし) | 外部キー制約 "FK_LINK_CONSTRAINT_1" |
| LINK_CONSTRAINT_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_LINK_CONSTRAINT_REF_1" |
| PAGE_SECURITY | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_SECURITY_1" |
| PAGE_SEC_CONSTRAINTS_DEF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_SEC_CONSTRAINTS_DEF_1" |
| PAGE_SEC_CONSTRAINT_DEF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_SEC_CONSTRAINT_DEF_1" |
| PAGE_SEC_CONSTRAINTS_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_SEC_CONSTRAINTS_REF_1" |
| PAGE_SEC_CONSTRAINT_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PAGE_SEC_CONSTRAINT_REF_1" |
| RULE_CRITERION | (外部キー制約) | (名前なし) | 外部キー制約 "FK_RULE_CRITERION_1" |
| PREFS_NODE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PREFS_NODE_1" |
| PA_METADATA_FIELDS | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PA_METADATA_FIELDS_1" |
| PD_METADATA_FIELDS | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PD_METADATA_FIELDS_1" |
| USER_ATTRIBUTE_REF | (外部キー制約) | (名前なし) | 外部キー制約 "FK_USER_ATTRIBUTE_REF_1" |
| USER_ATTRIBUTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_USER_ATTRIBUTE_1" |
| PRINCIPAL_PERMISSION | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PRINCIPAL_PERMISSION_1" |
| PRINCIPAL_PERMISSION | (外部キー制約) | (名前なし) | 外部キー制約 "FK_PRINCIPAL_PERMISSION_2" |
| SECURITY_CREDENTIAL | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_CREDENTIAL_1" |
| SSO_SITE_TO_PRINCIPALS | (外部キー制約) | (名前なし) | 外部キー制約 "SSO_SITE_TO_PRINC_FK1" |
| SSO_SITE_TO_PRINCIPALS | (外部キー制約) | (名前なし) | 外部キー制約 "SSO_SITE_TO_PRINC_FK2" |
| SSO_PRINCIPAL_TO_REMOTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SSO_PRINCIPAL_TO_REMOTE_1" |
| SSO_PRINCIPAL_TO_REMOTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SSO_PRINCIPAL_TO_REMOTE_2" |
| SSO_SITE_TO_REMOTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SSO_SITE_TO_REMOTE_1" |
| SSO_SITE_TO_REMOTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SSO_SITE_TO_REMOTE_2" |
| SSO_COOKIE_TO_REMOTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SSO_COOKIE_TO_REMOTE_1" |
| SSO_COOKIE_TO_REMOTE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SSO_COOKIE_TO_REMOTE_2" |
| SECURITY_USER_ROLE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_USER_ROLE_1" |
| SECURITY_USER_ROLE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_USER_ROLE_2" |
| SECURITY_USER_GROUP | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_USER_GROUP_1" |
| SECURITY_USER_GROUP | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_USER_GROUP_2" |
| SECURITY_GROUP_ROLE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_GROUP_ROLE_1" |
| SECURITY_GROUP_ROLE | (外部キー制約) | (名前なし) | 外部キー制約 "FK_SECURITY_GROUP_ROLE_2" |
