| Table Name | Description |
|---|---|
| ADMIN_ACTIVITY | Tracks administrative auditing activities by the admin users. Activities like adding and deleting users from User Manager |
| USER_ACTIVITY | Tracks user activity. Tracks User activities like logging on and off, changing password, updating user profile |
#-------------------------------------------------------------------------
# jetspeed.properties
#-------------------------------------------------------------------------
portal.audit.enable=true
| Table Name | Description |
|---|---|
| PAGE_STATISTICS | Counts page accesses and min, max and average page render times system wide |
| USER_STATISTICS | Counts user total sessions and session max, min and average session times |
| PORTLET_STATISTICS | Counts portlet accesses and min, max and average portlet render times system wide |
#-------------------------------------------------------------------------
# jetspeed.properties
#-------------------------------------------------------------------------
portal.statistics.logToLogger=false
portal.statistics.logToDatabase=true
# Number of records
portal.statistics.MaxPortalRecordToFlush=300
portal.statistics.MaxUserUserRecordToFlush=50
portal.statistics.MaxPagePageRecordToFlush=100
# Flush time in in Millisecond
portal.statistics.MaxTimePortalToFlush=300000
portal.statistics.MaxTimeUserToFlush=5000
portal.statistics.MaxTimePageToFlush=60000
| Table Name | Description |
|---|---|
| PROFILING_RULE | Defines a profiling rule name and class |
| RULE_CRITERION | Defines a Profiling Rule Criterion and associates it with a Profiling Rule(RULE_ID) with a RULE CRITERIA(CRITERIA_ID) |
| PRINCIPAL_RULE_ASSOC | Associates a user (PRINCIPAL_NAME) to a profiling rule (RULE_ID). Determines which profiling rule is used per user. |
| PROFILE_PAGE_ASSOC | Deprecated |
#-------------------------------------------------------------------------
# jetspeed.properties
#-------------------------------------------------------------------------
# default profiling rule names assigned to a new user
profiler.rule.names.default = page
# default profiling rule values assigned to a new user
profiler.rule.values.default = j2
# Registration default profiling rules assigned during registration or new user creation
# comma separated list
registration.rules.default = j2
| Table Name | Description |
|---|---|
| SECURITY_DOMAIN | Multi-tenant domain identifier. Currently modeled in database, but not used by Jetspeed |
| SECURITY_PRINCIPAL | Defines a Security Principal of type User, Role, Group. Users are stored in this table. Usernames stored in PRINCIPAL_NAME column, unique by DTYPE + PRINCIPAL_NAME |
| SECURITY_PRINCIPAL_ASSOC | Associates a principal to another principal by FROM_PRINCIPAL to TO_PRINCIPAL. This is how we represent user's group and role membership. Valid association types are: isMemberOf, isChildOf, isA, isPartOf, belongsTo |
| SECURITY_PERMISSION | Java Security Policy permission definitions. Supported permissions: Folder, Page, Portlet, Fragment. |
| SECURITY_CREDENTIAL | Defines a credential associated with a Security Principal. Also defines credential/password rules and expirations |
| SECURITY_ATTRIBUTE | An attribute name value pair associated (one-to-many attributes) with a Security Principal. Typically used for dynamic user attributes per user |
| PRINCIPAL_PERMISSION | Association(join) table joining a Security Principal(SECURITY_PRINCIPAL) to a Permission(SECURITY_PERMISSION) |
#-------------------------------------------------------------------------
# jetspeed.properties
#-------------------------------------------------------------------------
#1 = Permissions = use Jetspeed Java Security Policy
#2 = Constraints = use Jetspeed (PageManager) Constraint-based Security
portal.core.security.type=2
# jetspeed security persistence manager cache size:
org.apache.jetspeed.ehcache.jspm.maxelements=128
# jetspeed security persistence manager cache element expiration in seconds, (infinite = 0):
org.apache.jetspeed.ehcache.jspm.element.ttl=150
# if no user has been setup, default.user.principal will be
# automatically added via HttpRequestContext.setUserPrincpal()
default.user.principal=guest
default.admin.user=admin
default.admin.role=admin
default.manager.role=manager
default.user.role=user
default.guest.role=guest
| Table Name | Description |
|---|---|
| FOLDER | PSML Folder |
| FOLDER_CONSTRAINT | PSML Folder Security |
| FOLDER_CONSTRAINTS_REF | PSML Folder Security |
| FOLDER_MENU | PSML Folder Menu |
| FOLDER_MENU_METADATA | PSML Folder Menu |
| FOLDER_METADATA | PSML Folder Menu |
| FOLDER_ORDER | PSML Folder Menu |
| FRAGMENT | PSML Fragment (Portlet Instance) |
| FRAGMENT_CONSTRAINT | PSML Fragment (Portlet Instance) Security |
| FRAGMENT_CONSTRAINTS_REF | PSML Fragment (Portlet Instance) Security |
| FRAGMENT_PREF | Entity (Page Fragment) level preferences |
| FRAGMENT_PREF_VALUE | Entity (Page Fragment) level preferences |
| FRAGMENT_PROP | Fragment properties like number of columns, row/column positioning |
| LINK | PSML Links |
| LINK_CONSTRAINT | PSML Link security |
| LINK_CONSTRAINT_REF | PSML Link Security |
| LINK_METADATA | PSML Links |
| PAGE | PSML Pages |
| PAGE_CONSTRAINT | PSML Page Security |
| PAGE_CONSTRAINT_REF | PSML Page Security |
| PAGE_MENU | PSML Page Menu |
| PAGE_MENU_METADATA | PSML Page Menu |
| PAGE_METADATA | PSML Page Metadata |
| PAGE_SECURITY | PSML Page Security definitions and references |
| PAGE_SEC_CONSTRAINTS_DEF | PSML Global Security Constraints collection definitions |
| PAGE_SEC_CONSTRAINTS_REF | PSML Global Security Constraints references |
| PAGE_SEC_CONSTRAINT_DEF | PSML Global Security Constraints definition |
#-------------------------------------------------------------------------
# jetspeed.properties
#-------------------------------------------------------------------------
# defaults for page manager security
page.manager.permissions.security = false
page.manager.constraints.security = true
db.page.manager.cache.size=128
#- folder/page/link cache expires seconds, default=-1 (default then is 150 seconds), infinite=0, min=30
db.page.manager.cache.expire=-1
| Table Name | Description |
|---|---|
| PORTLET_PREFERENCE | Primary Portlet and User Preferences definitions |
| PORTLET_PREFERENCE_VALUE | Primary Portlet and User Preferences values associated to PORTLET_PREFERENCE by PREF_ID |
#-------------------------------------------------------------------------
# jetspeed.properties
#-------------------------------------------------------------------------
preferences.session.cache.enabled = true
| Table Name | Description |
|---|---|
| CUSTOM_PORTLET_MODE | portlet.xml |
| CUSTOM_WINDOW_STATE | portlet.xml |
| EVENT_ALIAS | portlet.xml |
| EVENT_DEFINITION | portlet.xml |
| FILTERED_PORTLET | portlet.xml |
| FILTER_LIFECYCLE | portlet.xml |
| FILTER_MAPPING | portlet.xml |
| JETSPEED_SERVICE | jetspeed-portlet.xml |
| LANGUAGE | portlet.xml |
| LOCALE_ENCODING_MAPPING | portlet.xml |
| LOCALIZED_DESCRIPTION | portlet.xml |
| LOCALIZED_DISPLAY_NAME | portlet.xml |
| NAMED_PARAMETER | portlet.xml |
| PARAMETER | portlet.xml |
| PARAMETER_ALIAS | portlet.xml |
| PA_METADATA_FIELDS | jetspeed-portlet.xml |
| PA_SECURITY_CONSTRAINT | jetspeed-portlet.xml |
| PD_METADATA_FIELDS | jetspeed-portlet.xml |
| PORTLET_APPLICATION | Primary Portlet Application definition from portlet.xml |
| PORTLET_DEFINITION | Primary Portlet Definition definition from portlet.xml |
| PORTLET_FILTER | portlet.xml |
| PORTLET_LISTENER | portlet.xml |
| PORTLET_SUPPORTS | portlet.xml |
| PROCESSING_EVENT | portlet.xml |
| PUBLIC_PARAMETER | portlet.xml |
| PUBLISHING_EVENT | portlet.xml |
| RUNTIME_OPTION | portlet.xml |
| RUNTIME_VALUE | portlet.xml |
| SECURED_PORTLET | portlet.xml |
| SECURITY_ROLE | portlet.xml |
| SECURITY_ROLE_REFERENCE | portlet.xml |
| USER_ATTRIBUTE | portlet.xml |
| USER_ATTRIBUTE_REF | portlet.xml |
| Table Name | Description |
|---|---|
| CAPABILITY | A device capability |
| CLIENT | Defines a device |
| CLIENT_TO_CAPABILITY | Association table: a device(client) can have many capabilities |
| CLIENT_TO_MIMETYPE | Association table: a device(client) can have many mimetypes |
| MEDIATYPE_TO_CAPABILITY | Association table: a mediatype can have many capabilities |
| MEDIATYPE_TO_MIMETYPE | Assocation table: media type to mime type |
| MEDIA_TYPE | A generalized media type such as HTML or XML |
| MIMETYPE | A Internet Standard Mime Type such as text/html |