sample_audit_db.mysql revision 8013147372959d2435f1f8b0305057cfce308168
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;
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle-- -----------------------------------------------------
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle-- Table `openidm`.`auditsync`
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle-- -----------------------------------------------------
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad KienleCREATE TABLE IF NOT EXISTS `openidm`.`auditsync` (
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `objectid` VARCHAR(38) NOT NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `rootactionid` VARCHAR(255) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `sourceobjectid` VARCHAR(511) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `targetobjectid` VARCHAR(511) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `activitydate` VARCHAR(29) NULL COMMENT 'Date format: 2011-09-09T14:58:17.654+02:00' ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `activity` VARCHAR(24) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `situation` VARCHAR(24) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `status` VARCHAR(7) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `message` TEXT NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `actionid` VARCHAR(255) NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `exceptiondetail` TEXT NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `mapping` TEXT NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle `messagedetail` MEDIUMTEXT NULL ,
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad Kienle PRIMARY KEY (`objectid`) )
5c69c2ad57233ee2eeb27d57e02de30d8066c113Chad KienleENGINE = 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;
8013147372959d2435f1f8b0305057cfce308168Jason Lemay-- -----------------------------------------------------
8013147372959d2435f1f8b0305057cfce308168Jason Lemay-- Table `audit`.`auditsync`
8013147372959d2435f1f8b0305057cfce308168Jason Lemay-- -----------------------------------------------------
8013147372959d2435f1f8b0305057cfce308168Jason LemayCREATE TABLE IF NOT EXISTS `audit`.`auditsync` (
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `objectid` VARCHAR(38) NOT NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `rootactionid` VARCHAR(255) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `sourceobjectid` VARCHAR(511) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `targetobjectid` VARCHAR(511) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `activitydate` VARCHAR(29) NULL COMMENT 'Date format: 2011-09-09T14:58:17.654+02:00' ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `activity` VARCHAR(24) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `situation` VARCHAR(24) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `status` VARCHAR(7) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `message` TEXT NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `actionid` VARCHAR(255) NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `exceptiondetail` TEXT NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `mapping` TEXT NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay `messagedetail` MEDIUMTEXT NULL ,
8013147372959d2435f1f8b0305057cfce308168Jason Lemay PRIMARY KEY (`objectid`) )
8013147372959d2435f1f8b0305057cfce308168Jason LemayENGINE = InnoDB;
1c5b000d6aed5e39ab2ec8fdb8bb3ec5af7fe64dJake Feaselgrant all on audit.* to root@'%' IDENTIFIED BY 'password';