The following tables describe database schema changes from version 2.1 to version 2.1.2.
The following items describe important functional changes in 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.
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:
<!-- 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>
The following tables describe database schema changes from version 2.0 to version 2.1.
| 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 | 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" |
