sample_audit_db.mysql revision 7dcb2f62e25d05f2afeb4e79f10102350d7c2c7b
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerCREATE DATABASE IF NOT EXISTS `audit` CHARACTER SET utf8 COLLATE utf8_bin;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- Table `audit`.`recon`
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerCREATE TABLE IF NOT EXISTS `audit`.`recon` (
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `objectid` VARCHAR(38) NOT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `entrytype` VARCHAR(7) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `rootactionid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activity` VARCHAR(24) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `message` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `reconciling` VARCHAR(12) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `reconid` VARCHAR(36) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `situation` VARCHAR(24) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `sourceobjectid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `status` VARCHAR(7) 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' ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `actionid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `exceptiondetail` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `mapping` TEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `messagedetail` MEDIUMTEXT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller PRIMARY KEY (`objectid`) )
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerENGINE = InnoDB;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- Table `audit`.`activity`
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerCREATE TABLE IF NOT EXISTS `audit`.`activity` (
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `objectid` VARCHAR(38) NOT NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activityid` VARCHAR(511) 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 ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `subjectid` VARCHAR(38) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `subjectrev` VARCHAR(38) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `rootactionid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `parentactionid` VARCHAR(511) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `requester` 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 ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller PRIMARY KEY (`objectid`) )
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerENGINE = InnoDB;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- Table `audit`.`access`
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller-- -----------------------------------------------------
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerCREATE TABLE IF NOT EXISTS `audit`.`access` (
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `objectid` VARCHAR(38) NOT NULL ,
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 ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `activitydate` VARCHAR(29) NULL COMMENT 'Date format: 2011-09-09T14:58:17.654+02:00' ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller `userid` VARCHAR(24) NULL ,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller PRIMARY KEY (`objectid`) )
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan MmillerENGINE = InnoDB;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmillergrant all on *.* to root@'%' IDENTIFIED BY 'password';