1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
CREATE TABLE IF NOT EXISTS `audit_ssn` (
`session_id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` varchar(16) NOT NULL default 'UNKNOWN',
`date` date NOT NULL default '2000-01-01',
`time` time NOT NULL default '00:00:00',
PRIMARY KEY (`session_id`)
);
CREATE TABLE IF NOT EXISTS `audit_trn` (
`session_id` bigint(20) unsigned NOT NULL default '0',
`tran_seq_no` smallint(6) unsigned NOT NULL default '0',
`date` date NOT NULL default '2000-01-01',
`time` time NOT NULL default '00:00:00',
`task_id` varchar(40) NOT NULL default '',
PRIMARY KEY (`session_id`,`tran_seq_no`)
);
CREATE TABLE IF NOT EXISTS `audit_tbl` (
`session_id` bigint(20) unsigned NOT NULL default '0',
`tran_seq_no` smallint(6) unsigned NOT NULL default '0',
`table_seq_no` smallint(6) unsigned NOT NULL default '0',
`base_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pkey` varchar(255) NOT NULL default '',
PRIMARY KEY (`session_id`,`tran_seq_no`,`table_seq_no`),
KEY `pkey` (`pkey`)
);
CREATE TABLE IF NOT EXISTS `audit_fld` (
`session_id` bigint(20) unsigned NOT NULL default '0',
`tran_seq_no` smallint(6) unsigned NOT NULL default '0',
`table_seq_no` smallint(6) unsigned NOT NULL default '0',
`field_id` varchar(255) NOT NULL default '',
`old_value` text,
`new_value` text,
PRIMARY KEY (`session_id`,`tran_seq_no`,`table_seq_no`,`field_id`),
KEY `field_id` (`field_id`)
);
CREATE TABLE `audit_logon_errors` (
`id` int(11) NOT NULL auto_increment,
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`ip_address` varchar(16) NOT NULL default '0.0.0.0',
`user_id` varchar(16) NOT NULL default '',
`user_password` varchar(16) NOT NULL default '',
PRIMARY KEY (`id`)
); |
Partager