Oracle Waveset 8.1.1 Business Administrator's Guide

MySQL Database Type

Table B–3 lists the data schema values for the MySQL database type.

Table B–3 Data Schema Values for the MySQL Database Type


Database Column	Value
`id`	`VARCHAR(50) BINARY NOT NULL`
`name`	`VARCHAR(128) BINARY NOT NULL`
`repomod`	`TIMESTAMP`
`resourceName`	`VARCHAR(128)`
`accountName`	`VARCHAR(255)`
`objectType`	`CHAR(2)`
`objectName`	`VARCHAR(128)`
`action`	`CHAR(2)`
`actionDateTime`	`CHAR(21)`
`actionStatus`	`CHAR(1)`
`interface`	`VARCHAR(50)`
`server`	`VARCHAR(128)`
`subject`	`VARCHAR(128)`
`reason`	`CHAR(2)`
`message`	`VARCHAR(255)` or `CLOB` (See note¹ at end of table.)
`acctAttrChanges`	`TEXT`
`acctAttr01label`	`VARCHAR(50)`
`acctAttr01value`	`VARCHAR(128)`
`acctAttr02label`	`VARCHAR(50)`
`acctAttr02value`	`VARCHAR(128)`
`acctAttr03label`	`VARCHAR(50)`
`acctAttr03value`	`VARCHAR(128)`
`acctAttr04label`	`VARCHAR(50)`
`acctAttr04value`	`VARCHAR(128)`
`acctAttr05label`	`VARCHAR(50)`
`acctAttr05value`	`VARCHAR(128)`
`parm01label`	`VARCHAR(50)`
`parm01value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm02label`	`VARCHAR(50)`
`parm02value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm03label`	`VARCHAR(50)`
`parm03value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm04label`	`VARCHAR(50)`
`parm04value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`parm05label`	`VARCHAR(50)`
`parm05value`	`VARCHAR(128)` or `CLOB` (See note¹ at end of table.)
`sequence`	`CHAR(19)`
`xmlSize`	`BIGINT`
`xml`	`MEDIUMTEXT`

Note –

The column length limit for these columns is configurable. The default data type is VARCHAR and the default size limit is noted in parentheses. See Audit Log Configuration for information on how to adjust the size limit.