sample_audit_db.mysql revision 1c5b000d6aed5e39ab2ec8fdb8bb3ec5af7fe64d
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerCREATE DATABASE IF NOT EXISTS `audit` CHARACTER SET utf8 COLLATE utf8_bin;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller-- Table `audit`.`auditrecon`
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan MmillerCREATE TABLE IF NOT EXISTS `audit`.`auditrecon` (
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `objectid` VARCHAR(38) NOT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `entrytype` VARCHAR(7) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `rootactionid` VARCHAR(255) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `reconid` VARCHAR(36) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `reconciling` VARCHAR(12) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `sourceobjectid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `targetobjectid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `ambiguoustargetobjectids` MEDIUMTEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activitydate` VARCHAR(29) NULL COMMENT 'Date format: 2011-09-09T14:58:17.654+02:00' ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `situation` VARCHAR(24) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `activity` VARCHAR(24) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `status` VARCHAR(7) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `message` TEXT NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `actionid` VARCHAR(255) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `exceptiondetail` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `mapping` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `messagedetail` MEDIUMTEXT NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller PRIMARY KEY (`objectid`) )
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerENGINE = InnoDB;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller-- Table `audit`.`auditactivity`
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan MmillerCREATE TABLE IF NOT EXISTS `audit`.`auditactivity` (
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `objectid` VARCHAR(38) NOT NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `rootactionid` VARCHAR(255) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `parentactionid` VARCHAR(255) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `activityid` VARCHAR(255) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activitydate` VARCHAR(29) NULL COMMENT 'Date format: 2011-09-09T14:58:17.654+02:00' ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activity` VARCHAR(24) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `message` TEXT NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `subjectid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `subjectrev` VARCHAR(38) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `requester` TEXT NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `approver` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `subjectbefore` MEDIUMTEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `subjectafter` MEDIUMTEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `status` VARCHAR(7) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `changedfields` VARCHAR(255) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `passwordchanged` VARCHAR(5) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller PRIMARY KEY (`objectid`) ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller INDEX `idx_auditactivity_rootactionid` (`rootactionid` ASC) )
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerENGINE = InnoDB;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller-- Table `audit`.`auditaccess`
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan MmillerCREATE TABLE IF NOT EXISTS `audit`.`auditaccess` (
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `objectid` VARCHAR(38) NOT NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `activitydate` VARCHAR(29) NULL COMMENT 'Date format: 2011-09-09T14:58:17.654+02:00' ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activity` VARCHAR(24) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `ip` VARCHAR(40) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `principal` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `roles` VARCHAR(1024) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `status` VARCHAR(7) NULL ,
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmiller `userid` VARCHAR(24) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller PRIMARY KEY (`objectid`) )
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerENGINE = InnoDB;
1c5b000d6aed5e39ab2ec8fdb8bb3ec5af7fe64dJake Feaselgrant all on audit.* to root@'%' IDENTIFIED BY 'password';