The Portal global table is used for storing properties for all Portals in a cluster. Important information such as which Portal in the cluster that has the search engine is stored here. The table is populate initially using information set in the [portalserver]/properties/global.properties file. All subsequent updates and requests for information are from the por_global table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| zipremote | integer | not null | Boolean value 0/1.
(This field is unused.) |
| maintimezone | nvarchar(100) | not null | Timezone as reported by the JVM.
(This field is unused.) |
| schemaversion | nvarchar(10) | not null | Database schema version. Portal does not use this column, the value is always 3.0. |
| supportemail | nvarchar(100) | with null | The email address to send notification emails and direct user technical issues to. |
| enablemessages | integer | not null | Boolean value 0/1 describing whether or not discussion boards are enabled. |
| usersetpassword | integer | not null | Boolean value 0/1 describing whether or not users can change their password in the MyProfile page. |
| usertimeout | integer | not null | Time in minutes that a user can be idle before his or her session expires and they have to log in again. A value of -1 means that the session never expires. (Default value is 30 minutes) |
| postsessionkey | integer | not null | Boolean value 0/1 that describes whether the session key should be posted when serving content. |
| newfulllib | integer | not null | Boolean value 0/1 which describes whether new users, by default, have full use of the library |
| newfullchan | integer | not null | Boolean value 0/1 which describes whether new users, by default, have full use of the channels. |
| newfullmess | integer | not null | Boolean value 0/1 which describes whether new users, by
default, have full use of messengers.
(Messengers are unused since Portal 3.0) |
| pluginurl | nvarchar(255) | with null | URL where client browsers can download a compatible plugin to use Portal's plugin features. |
| pluginclassid | nvarchar(100) | with null | Classid of plugin downloadable from pluginurl. This is required by the plugin html element. |
| pluginhtmlcodebase | nvarchar(255) | with null | Html Code Base of plugin downloadable from pluginurl. This is required by the plugin html element. |
| expirecontent | integer | not null | Boolean value 0/1 describing whether or not content can be set to expire. |
| searchenginecs | integer | with null | Server key of the Portal Server considered the Search Engine Master. It contains the running instance of the embedded search engine. |
| searchengine | nvarchar(40) | with null | The search engine this portal cluster is configured to use. |
| searchenginemaint | integer | with null | The interval in minutes between search engine scheduled maintence. This is not used by the current embedded search engine, but has been used in the past and may be used in the future. |
| sessioncookiename | nvarchar(40) | with null | The name of the cookie that stores the portal session key. |
| sessioncookiedom | nvarchar(100) | with null | The domain of the cookie that stores the portal session key. |
Product Name: Portal
Table Type: Table