— MySQL Script generated by MySQL Workbench
— Fri Jun 27 16:34:04 2014
— Model: New Model Version: 1.0
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’TRADITIONAL,ALLOW_INVALID_DATES’;
— —————————————————–
— Schema mydb
— —————————————————–
— —————————————————–
— Schema jira
— —————————————————–
CREATE SCHEMA IF NOT EXISTS `jira` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
USE `jira` ;
— —————————————————–
— Table `jira`.`AO_21D670_WHITELIST_RULES`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_21D670_WHITELIST_RULES` (
`ALLOWINBOUND` TINYINT(1) NULL DEFAULT NULL,
`EXPRESSION` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`TYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_4AEACD_WEBHOOK_DAO`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_4AEACD_WEBHOOK_DAO` (
`ENABLED` TINYINT(1) NULL DEFAULT NULL,
`ENCODED_EVENTS` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`EXCLUDE_ISSUE_DETAILS` TINYINT(1) NULL DEFAULT NULL,
`FILTER` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`JQL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LAST_UPDATED` DATETIME NOT NULL,
`LAST_UPDATED_USER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`NAME` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`PARAMETERS` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REGISTRATION_METHOD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`URL` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_563AEE_ACTOR_ENTITY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_563AEE_ACTOR_ENTITY` (
`FULL_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`PROFILE_PAGE_URI` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROFILE_PICTURE_URI` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_563AEE_MEDIA_LINK_ENTITY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_563AEE_MEDIA_LINK_ENTITY` (
`DURATION` INT(11) NULL DEFAULT NULL,
`HEIGHT` INT(11) NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`URL` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`WIDTH` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_563AEE_OBJECT_ENTITY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_563AEE_OBJECT_ENTITY` (
`CONTENT` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DISPLAY_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`IMAGE_ID` INT(11) NULL DEFAULT NULL,
`OBJECT_ID` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_TYPE` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SUMMARY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_563aee_object_entity_image_id`
FOREIGN KEY (`IMAGE_ID`)
REFERENCES `jira`.`AO_563AEE_MEDIA_LINK_ENTITY` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_563aee_object_entity_image_id` ON `jira`.`AO_563AEE_OBJECT_ENTITY` (`IMAGE_ID` ASC);
— —————————————————–
— Table `jira`.`AO_563AEE_TARGET_ENTITY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_563AEE_TARGET_ENTITY` (
`CONTENT` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DISPLAY_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`IMAGE_ID` INT(11) NULL DEFAULT NULL,
`OBJECT_ID` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_TYPE` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SUMMARY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_563aee_target_entity_image_id`
FOREIGN KEY (`IMAGE_ID`)
REFERENCES `jira`.`AO_563AEE_MEDIA_LINK_ENTITY` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_563aee_target_entity_image_id` ON `jira`.`AO_563AEE_TARGET_ENTITY` (`IMAGE_ID` ASC);
— —————————————————–
— Table `jira`.`AO_563AEE_ACTIVITY_ENTITY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_563AEE_ACTIVITY_ENTITY` (
`ACTIVITY_ID` BIGINT(20) NOT NULL AUTO_INCREMENT,
`ACTOR_ID` INT(11) NULL DEFAULT NULL,
`CONTENT` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`GENERATOR_DISPLAY_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`GENERATOR_ID` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICON_ID` INT(11) NULL DEFAULT NULL,
`ID` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_ID` INT(11) NULL DEFAULT NULL,
`POSTER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PUBLISHED` DATETIME NULL DEFAULT NULL,
`TARGET_ID` INT(11) NULL DEFAULT NULL,
`TITLE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`VERB` VARCHAR(767) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ACTIVITY_ID`),
CONSTRAINT `fk_ao_563aee_activity_entity_actor_id`
FOREIGN KEY (`ACTOR_ID`)
REFERENCES `jira`.`AO_563AEE_ACTOR_ENTITY` (`ID`),
CONSTRAINT `fk_ao_563aee_activity_entity_icon_id`
FOREIGN KEY (`ICON_ID`)
REFERENCES `jira`.`AO_563AEE_MEDIA_LINK_ENTITY` (`ID`),
CONSTRAINT `fk_ao_563aee_activity_entity_object_id`
FOREIGN KEY (`OBJECT_ID`)
REFERENCES `jira`.`AO_563AEE_OBJECT_ENTITY` (`ID`),
CONSTRAINT `fk_ao_563aee_activity_entity_target_id`
FOREIGN KEY (`TARGET_ID`)
REFERENCES `jira`.`AO_563AEE_TARGET_ENTITY` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_563aee_activity_entity_actor_id` ON `jira`.`AO_563AEE_ACTIVITY_ENTITY` (`ACTOR_ID` ASC);
CREATE INDEX `fk_ao_563aee_activity_entity_icon_id` ON `jira`.`AO_563AEE_ACTIVITY_ENTITY` (`ICON_ID` ASC);
CREATE INDEX `fk_ao_563aee_activity_entity_object_id` ON `jira`.`AO_563AEE_ACTIVITY_ENTITY` (`OBJECT_ID` ASC);
CREATE INDEX `fk_ao_563aee_activity_entity_target_id` ON `jira`.`AO_563AEE_ACTIVITY_ENTITY` (`TARGET_ID` ASC);
— —————————————————–
— Table `jira`.`AO_B9A0F0_APPLIED_TEMPLATE`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_B9A0F0_APPLIED_TEMPLATE` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`PROJECT_ID` BIGINT(20) NULL DEFAULT NULL,
`PROJECT_TEMPLATE_MODULE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT_TEMPLATE_WEB_ITEM_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_REPOSITORY_MAPPING`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_REPOSITORY_MAPPING` (
`ACTIVITY_LAST_SYNC` DATETIME NULL DEFAULT NULL,
`DELETED` TINYINT(1) NULL DEFAULT NULL,
`FORK` TINYINT(1) NULL DEFAULT NULL,
`FORK_OF_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FORK_OF_OWNER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FORK_OF_SLUG` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`LAST_CHANGESET_NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LAST_COMMIT_DATE` DATETIME NULL DEFAULT NULL,
`LINKED` TINYINT(1) NULL DEFAULT NULL,
`LOGO` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ORGANIZATION_ID` INT(11) NULL DEFAULT ‘0’,
`SLUG` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SMARTCOMMITS_ENABLED` TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_BRANCH`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_BRANCH` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_ID` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_branch_repository_id`
FOREIGN KEY (`REPOSITORY_ID`)
REFERENCES `jira`.`AO_E8B6CC_REPOSITORY_MAPPING` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_branch_repository_id` ON `jira`.`AO_E8B6CC_BRANCH` (`REPOSITORY_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_BRANCH_HEAD_MAPPING`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_BRANCH_HEAD_MAPPING` (
`BRANCH_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`HEAD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`REPOSITORY_ID` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_branch_head_mapping_repository_id`
FOREIGN KEY (`REPOSITORY_ID`)
REFERENCES `jira`.`AO_E8B6CC_REPOSITORY_MAPPING` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_branch_head_mapping_repository_id` ON `jira`.`AO_E8B6CC_BRANCH_HEAD_MAPPING` (`REPOSITORY_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_CHANGESET_MAPPING`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_CHANGESET_MAPPING` (
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`AUTHOR_EMAIL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`BRANCH` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DATE` DATETIME NULL DEFAULT NULL,
`FILES_DATA` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FILE_DETAILS_JSON` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MESSAGE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PARENTS_DATA` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RAW_AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RAW_NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_ID` INT(11) NULL DEFAULT ‘0’,
`SMARTCOMMIT_AVAILABLE` TINYINT(1) NULL DEFAULT NULL,
`VERSION` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_COMMIT`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_COMMIT` (
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`AUTHOR_AVATAR_URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DATE` DATETIME NOT NULL,
`DOMAIN_ID` INT(11) NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`MESSAGE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RAW_AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_COMMIT_ISSUE_KEY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_COMMIT_ISSUE_KEY` (
`COMMIT_ID` INT(11) NULL DEFAULT NULL,
`DOMAIN_ID` INT(11) NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_commit_issue_key_commit_id`
FOREIGN KEY (`COMMIT_ID`)
REFERENCES `jira`.`AO_E8B6CC_COMMIT` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_commit_issue_key_commit_id` ON `jira`.`AO_E8B6CC_COMMIT_ISSUE_KEY` (`COMMIT_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_GIT_HUB_EVENT`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_GIT_HUB_EVENT` (
`CREATED_AT` DATETIME NOT NULL,
`GIT_HUB_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`REPOSITORY_ID` INT(11) NOT NULL,
`SAVE_POINT` TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_git_hub_event_repository_id`
FOREIGN KEY (`REPOSITORY_ID`)
REFERENCES `jira`.`AO_E8B6CC_REPOSITORY_MAPPING` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_git_hub_event_repository_id` ON `jira`.`AO_E8B6CC_GIT_HUB_EVENT` (`REPOSITORY_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_ISSUE_MAPPING`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_ISSUE_MAPPING` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_URI` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_ISSUE_MAPPING_V2`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_ISSUE_MAPPING_V2` (
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`BRANCH` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DATE` DATETIME NULL DEFAULT NULL,
`FILES_DATA` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MESSAGE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PARENTS_DATA` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RAW_AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RAW_NODE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_ID` INT(11) NULL DEFAULT NULL,
`VERSION` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_ISSUE_TO_BRANCH`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_ISSUE_TO_BRANCH` (
`BRANCH_ID` INT(11) NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_issue_to_branch_branch_id`
FOREIGN KEY (`BRANCH_ID`)
REFERENCES `jira`.`AO_E8B6CC_BRANCH` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_issue_to_branch_branch_id` ON `jira`.`AO_E8B6CC_ISSUE_TO_BRANCH` (`BRANCH_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_ISSUE_TO_CHANGESET`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_ISSUE_TO_CHANGESET` (
`CHANGESET_ID` INT(11) NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_issue_to_changeset_changeset_id`
FOREIGN KEY (`CHANGESET_ID`)
REFERENCES `jira`.`AO_E8B6CC_CHANGESET_MAPPING` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_issue_to_changeset_changeset_id` ON `jira`.`AO_E8B6CC_ISSUE_TO_CHANGESET` (`CHANGESET_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_MESSAGE`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_MESSAGE` (
`ADDRESS` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`PAYLOAD` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`PAYLOAD_TYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`PRIORITY` INT(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_MESSAGE_QUEUE_ITEM`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_MESSAGE_QUEUE_ITEM` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`LAST_FAILED` DATETIME NULL DEFAULT NULL,
`MESSAGE_ID` INT(11) NOT NULL,
`QUEUE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`RETRIES_COUNT` INT(11) NOT NULL DEFAULT ‘0’,
`STATE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`STATE_INFO` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_message_queue_item_message_id`
FOREIGN KEY (`MESSAGE_ID`)
REFERENCES `jira`.`AO_E8B6CC_MESSAGE` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_message_queue_item_message_id` ON `jira`.`AO_E8B6CC_MESSAGE_QUEUE_ITEM` (`MESSAGE_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_MESSAGE_TAG`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_MESSAGE_TAG` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`MESSAGE_ID` INT(11) NULL DEFAULT NULL,
`TAG` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_message_tag_message_id`
FOREIGN KEY (`MESSAGE_ID`)
REFERENCES `jira`.`AO_E8B6CC_MESSAGE` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_message_tag_message_id` ON `jira`.`AO_E8B6CC_MESSAGE_TAG` (`MESSAGE_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_ORGANIZATION_MAPPING`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_ORGANIZATION_MAPPING` (
`ACCESS_TOKEN` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ADMIN_PASSWORD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ADMIN_USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`AUTOLINK_NEW_REPOS` TINYINT(1) NULL DEFAULT NULL,
`DEFAULT_GROUPS_SLUGS` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DVCS_TYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`HOST_URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OAUTH_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OAUTH_SECRET` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SMARTCOMMITS_FOR_NEW_REPOS` TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_PROJECT_MAPPING`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_PROJECT_MAPPING` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`PASSWORD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_URI` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_PROJECT_MAPPING_V2`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_PROJECT_MAPPING_V2` (
`ACCESS_TOKEN` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ADMIN_PASSWORD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ADMIN_USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`LAST_COMMIT_DATE` DATETIME NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_TYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REPOSITORY_URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_PR_ISSUE_KEY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_PR_ISSUE_KEY` (
`DOMAIN_ID` INT(11) NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PULL_REQUEST_ID` INT(11) NULL DEFAULT ‘0’,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_PULL_REQUEST`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_PULL_REQUEST` (
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`COMMENT_COUNT` INT(11) NULL DEFAULT ‘0’,
`CREATED_ON` DATETIME NULL DEFAULT NULL,
`DESTINATION_BRANCH` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DOMAIN_ID` INT(11) NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`LAST_STATUS` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REMOTE_ID` BIGINT(20) NULL DEFAULT NULL,
`SOURCE_BRANCH` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SOURCE_REPO` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TO_REPOSITORY_ID` INT(11) NULL DEFAULT ‘0’,
`TO_REPO_ID` INT(11) NULL DEFAULT ‘0’,
`UPDATED_ON` DATETIME NULL DEFAULT NULL,
`URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`AO_E8B6CC_PR_PARTICIPANT`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_PR_PARTICIPANT` (
`APPROVED` TINYINT(1) NULL DEFAULT NULL,
`DOMAIN_ID` INT(11) NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`PULL_REQUEST_ID` INT(11) NULL DEFAULT NULL,
`ROLE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_pr_participant_pull_request_id`
FOREIGN KEY (`PULL_REQUEST_ID`)
REFERENCES `jira`.`AO_E8B6CC_PULL_REQUEST` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_pr_participant_pull_request_id` ON `jira`.`AO_E8B6CC_PR_PARTICIPANT` (`PULL_REQUEST_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_PR_TO_COMMIT`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_PR_TO_COMMIT` (
`COMMIT_ID` INT(11) NOT NULL,
`DOMAIN_ID` INT(11) NOT NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`REQUEST_ID` INT(11) NOT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_pr_to_commit_commit_id`
FOREIGN KEY (`COMMIT_ID`)
REFERENCES `jira`.`AO_E8B6CC_COMMIT` (`ID`),
CONSTRAINT `fk_ao_e8b6cc_pr_to_commit_request_id`
FOREIGN KEY (`REQUEST_ID`)
REFERENCES `jira`.`AO_E8B6CC_PULL_REQUEST` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_pr_to_commit_commit_id` ON `jira`.`AO_E8B6CC_PR_TO_COMMIT` (`COMMIT_ID` ASC);
CREATE INDEX `fk_ao_e8b6cc_pr_to_commit_request_id` ON `jira`.`AO_E8B6CC_PR_TO_COMMIT` (`REQUEST_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_REPO_TO_CHANGESET`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_REPO_TO_CHANGESET` (
`CHANGESET_ID` INT(11) NULL DEFAULT NULL,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`REPOSITORY_ID` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
CONSTRAINT `fk_ao_e8b6cc_repo_to_changeset_changeset_id`
FOREIGN KEY (`CHANGESET_ID`)
REFERENCES `jira`.`AO_E8B6CC_CHANGESET_MAPPING` (`ID`),
CONSTRAINT `fk_ao_e8b6cc_repo_to_changeset_repository_id`
FOREIGN KEY (`REPOSITORY_ID`)
REFERENCES `jira`.`AO_E8B6CC_REPOSITORY_MAPPING` (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fk_ao_e8b6cc_repo_to_changeset_changeset_id` ON `jira`.`AO_E8B6CC_REPO_TO_CHANGESET` (`CHANGESET_ID` ASC);
CREATE INDEX `fk_ao_e8b6cc_repo_to_changeset_repository_id` ON `jira`.`AO_E8B6CC_REPO_TO_CHANGESET` (`REPOSITORY_ID` ASC);
— —————————————————–
— Table `jira`.`AO_E8B6CC_SYNC_AUDIT_LOG`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`AO_E8B6CC_SYNC_AUDIT_LOG` (
`END_DATE` DATETIME NULL DEFAULT NULL,
`EXC_TRACE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIRST_REQUEST_DATE` DATETIME NULL DEFAULT NULL,
`FLIGHT_TIME_MS` INT(11) NULL DEFAULT ‘0’,
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`NUM_REQUESTS` INT(11) NULL DEFAULT ‘0’,
`REPO_ID` INT(11) NULL DEFAULT ‘0’,
`START_DATE` DATETIME NULL DEFAULT NULL,
`SYNC_STATUS` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SYNC_TYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TOTAL_ERRORS` INT(11) NULL DEFAULT ‘0’,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_BLOB_TRIGGERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_BLOB_TRIGGERS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`BLOB_DATA` BLOB NULL DEFAULT NULL,
PRIMARY KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_CALENDARS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_CALENDARS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CALENDAR_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`CALENDAR` BLOB NULL DEFAULT NULL,
PRIMARY KEY (`CALENDAR_NAME`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_CRON_TRIGGERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_CRON_TRIGGERS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`CRON_EXPRESSION` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TIME_ZONE_ID` VARCHAR(80) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_FIRED_TRIGGERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_FIRED_TRIGGERS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ENTRY_ID` VARCHAR(95) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_VOLATILE` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INSTANCE_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIRED_TIME` BIGINT(20) NULL DEFAULT NULL,
`SCHED_TIME` BIGINT(20) NULL DEFAULT NULL,
`PRIORITY` INT(11) NULL DEFAULT NULL,
`STATE` VARCHAR(16) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_STATEFUL` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_NONCONCURRENT` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_UPDATE_DATA` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REQUESTS_RECOVERY` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ENTRY_ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_qrtz_ft_trig_inst_name` ON `jira`.`JQUARTZ_FIRED_TRIGGERS` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC);
CREATE INDEX `idx_qrtz_ft_inst_job_req_rcvry` ON `jira`.`JQUARTZ_FIRED_TRIGGERS` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC);
CREATE INDEX `idx_qrtz_ft_j_g` ON `jira`.`JQUARTZ_FIRED_TRIGGERS` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC);
CREATE INDEX `idx_qrtz_ft_jg` ON `jira`.`JQUARTZ_FIRED_TRIGGERS` (`SCHED_NAME` ASC, `JOB_GROUP` ASC);
CREATE INDEX `idx_qrtz_ft_t_g` ON `jira`.`JQUARTZ_FIRED_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC);
CREATE INDEX `idx_qrtz_ft_tg` ON `jira`.`JQUARTZ_FIRED_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC);
— —————————————————–
— Table `jira`.`JQUARTZ_JOB_DETAILS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_JOB_DETAILS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`JOB_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`DESCRIPTION` VARCHAR(250) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_CLASS_NAME` VARCHAR(250) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_DURABLE` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_VOLATILE` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_STATEFUL` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_NONCONCURRENT` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_UPDATE_DATA` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REQUESTS_RECOVERY` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_DATA` BLOB NULL DEFAULT NULL,
PRIMARY KEY (`JOB_NAME`, `JOB_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_qrtz_j_req_recovery` ON `jira`.`JQUARTZ_JOB_DETAILS` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC);
CREATE INDEX `idx_qrtz_j_grp` ON `jira`.`JQUARTZ_JOB_DETAILS` (`SCHED_NAME` ASC, `JOB_GROUP` ASC);
— —————————————————–
— Table `jira`.`JQUARTZ_JOB_LISTENERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_JOB_LISTENERS` (
`JOB_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`JOB_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`JOB_LISTENER` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`JOB_NAME`, `JOB_GROUP`, `JOB_LISTENER`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_LOCKS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_LOCKS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LOCK_NAME` VARCHAR(40) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`LOCK_NAME`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_PAUSED_TRIGGER_GRPS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_PAUSED_TRIGGER_GRPS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`TRIGGER_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_SCHEDULER_STATE`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_SCHEDULER_STATE` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INSTANCE_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`LAST_CHECKIN_TIME` BIGINT(20) NULL DEFAULT NULL,
`CHECKIN_INTERVAL` BIGINT(20) NULL DEFAULT NULL,
PRIMARY KEY (`INSTANCE_NAME`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_SIMPLE_TRIGGERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_SIMPLE_TRIGGERS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`REPEAT_COUNT` BIGINT(20) NULL DEFAULT NULL,
`REPEAT_INTERVAL` BIGINT(20) NULL DEFAULT NULL,
`TIMES_TRIGGERED` BIGINT(20) NULL DEFAULT NULL,
PRIMARY KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_SIMPROP_TRIGGERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_SIMPROP_TRIGGERS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`STR_PROP_1` VARCHAR(512) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STR_PROP_2` VARCHAR(512) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STR_PROP_3` VARCHAR(512) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INT_PROP_1` INT(11) NULL DEFAULT NULL,
`INT_PROP_2` INT(11) NULL DEFAULT NULL,
`LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL,
`LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL,
`DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL,
`DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL,
`BOOL_PROP_1` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`BOOL_PROP_2` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`JQUARTZ_TRIGGERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_TRIGGERS` (
`SCHED_NAME` VARCHAR(120) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`JOB_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_VOLATILE` VARCHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(250) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NEXT_FIRE_TIME` BIGINT(20) NULL DEFAULT NULL,
`PREV_FIRE_TIME` BIGINT(20) NULL DEFAULT NULL,
`PRIORITY` INT(11) NULL DEFAULT NULL,
`TRIGGER_STATE` VARCHAR(16) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_TYPE` VARCHAR(8) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`START_TIME` BIGINT(20) NULL DEFAULT NULL,
`END_TIME` BIGINT(20) NULL DEFAULT NULL,
`CALENDAR_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL,
`JOB_DATA` BLOB NULL DEFAULT NULL,
PRIMARY KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_qrtz_t_j` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC);
CREATE INDEX `idx_qrtz_t_jg` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `JOB_GROUP` ASC);
CREATE INDEX `idx_qrtz_t_c` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC);
CREATE INDEX `idx_qrtz_j_g` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC);
CREATE INDEX `idx_qrtz_j_state` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC);
CREATE INDEX `idx_qrtz_t_n_state` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC);
CREATE INDEX `idx_qrtz_t_n_g_state` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC);
CREATE INDEX `idx_qrtz_t_next_fire_time` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC);
CREATE INDEX `idx_qrtz_t_nft_st` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC);
CREATE INDEX `idx_qrtz_t_nft_misfire` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC);
CREATE INDEX `idx_qrtz_t_nft_st_misfire` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC);
CREATE INDEX `idx_qrtz_t_nft_st_misfire_grp` ON `jira`.`JQUARTZ_TRIGGERS` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC);
— —————————————————–
— Table `jira`.`JQUARTZ_TRIGGER_LISTENERS`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`JQUARTZ_TRIGGER_LISTENERS` (
`TRIGGER_NAME` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_GROUP` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TRIGGER_LISTENER` VARCHAR(200) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`TRIGGER_GROUP`, `TRIGGER_LISTENER`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`OS_CURRENTSTEP`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`OS_CURRENTSTEP` (
`ID` DECIMAL(18,0) NOT NULL,
`ENTRY_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`STEP_ID` DECIMAL(9,0) NULL DEFAULT NULL,
`ACTION_ID` DECIMAL(9,0) NULL DEFAULT NULL,
`OWNER` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`START_DATE` DATETIME NULL DEFAULT NULL,
`DUE_DATE` DATETIME NULL DEFAULT NULL,
`FINISH_DATE` DATETIME NULL DEFAULT NULL,
`STATUS` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CALLER` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `wf_entryid` ON `jira`.`OS_CURRENTSTEP` (`ENTRY_ID` ASC);
— —————————————————–
— Table `jira`.`OS_CURRENTSTEP_PREV`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`OS_CURRENTSTEP_PREV` (
`ID` DECIMAL(18,0) NOT NULL,
`PREVIOUS_ID` DECIMAL(18,0) NOT NULL,
PRIMARY KEY (`ID`, `PREVIOUS_ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`OS_HISTORYSTEP`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`OS_HISTORYSTEP` (
`ID` DECIMAL(18,0) NOT NULL,
`ENTRY_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`STEP_ID` DECIMAL(9,0) NULL DEFAULT NULL,
`ACTION_ID` DECIMAL(9,0) NULL DEFAULT NULL,
`OWNER` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`START_DATE` DATETIME NULL DEFAULT NULL,
`DUE_DATE` DATETIME NULL DEFAULT NULL,
`FINISH_DATE` DATETIME NULL DEFAULT NULL,
`STATUS` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CALLER` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `historystep_entryid` ON `jira`.`OS_HISTORYSTEP` (`ENTRY_ID` ASC);
— —————————————————–
— Table `jira`.`OS_HISTORYSTEP_PREV`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`OS_HISTORYSTEP_PREV` (
`ID` DECIMAL(18,0) NOT NULL,
`PREVIOUS_ID` DECIMAL(18,0) NOT NULL,
PRIMARY KEY (`ID`, `PREVIOUS_ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`OS_WFENTRY`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`OS_WFENTRY` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INITIALIZED` DECIMAL(9,0) NULL DEFAULT NULL,
`STATE` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`SEQUENCE_VALUE_ITEM`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`SEQUENCE_VALUE_ITEM` (
`SEQ_NAME` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQ_ID` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`SEQ_NAME`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`app_user`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`app_user` (
`ID` DECIMAL(18,0) NOT NULL,
`user_key` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_user_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uk_user_key` ON `jira`.`app_user` (`user_key` ASC);
CREATE UNIQUE INDEX `uk_lower_user_name` ON `jira`.`app_user` (`lower_user_name` ASC);
— —————————————————–
— Table `jira`.`audit_changed_value`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`audit_changed_value` (
`ID` DECIMAL(18,0) NOT NULL,
`LOG_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DELTA_FROM` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DELTA_TO` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_changed_value_log_id` ON `jira`.`audit_changed_value` (`LOG_ID` ASC);
— —————————————————–
— Table `jira`.`audit_item`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`audit_item` (
`ID` DECIMAL(18,0) NOT NULL,
`LOG_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`OBJECT_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_PARENT_ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_PARENT_NAME` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_audit_item_log_id2` ON `jira`.`audit_item` (`LOG_ID` ASC);
— —————————————————–
— Table `jira`.`audit_log`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`audit_log` (
`ID` DECIMAL(18,0) NOT NULL,
`REMOTE_ADDRESS` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`AUTHOR_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SUMMARY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CATEGORY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_PARENT_ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OBJECT_PARENT_NAME` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`AUTHOR_TYPE` DECIMAL(9,0) NULL DEFAULT NULL,
`SEARCH_FIELD` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_audit_log_created` ON `jira`.`audit_log` (`CREATED` ASC);
— —————————————————–
— Table `jira`.`avatar`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`avatar` (
`ID` DECIMAL(18,0) NOT NULL,
`filename` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`contenttype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`avatartype` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`owner` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`systemavatar` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `avatar_index` ON `jira`.`avatar` (`avatartype` ASC, `owner` ASC);
— —————————————————–
— Table `jira`.`changegroup`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`changegroup` (
`ID` DECIMAL(18,0) NOT NULL,
`issueid` DECIMAL(18,0) NULL DEFAULT NULL,
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `chggroup_issue` ON `jira`.`changegroup` (`issueid` ASC);
— —————————————————–
— Table `jira`.`changeitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`changeitem` (
`ID` DECIMAL(18,0) NOT NULL,
`groupid` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDTYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OLDVALUE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OLDSTRING` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NEWVALUE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NEWSTRING` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `chgitem_chggrp` ON `jira`.`changeitem` (`groupid` ASC);
CREATE INDEX `chgitem_field` ON `jira`.`changeitem` (`FIELD` ASC);
— —————————————————–
— Table `jira`.`clusterlockstatus`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`clusterlockstatus` (
`ID` DECIMAL(18,0) NOT NULL,
`LOCK_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LOCKED_BY_NODE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `cluster_lock_name_idx` ON `jira`.`clusterlockstatus` (`LOCK_NAME` ASC);
— —————————————————–
— Table `jira`.`clustermessage`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`clustermessage` (
`ID` DECIMAL(18,0) NOT NULL,
`SOURCE_NODE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESTINATION_NODE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CLAIMED_BY_NODE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MESSAGE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MESSAGE_TIME` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `source_destination_node_idx` ON `jira`.`clustermessage` (`SOURCE_NODE` ASC, `DESTINATION_NODE` ASC);
— —————————————————–
— Table `jira`.`clusternode`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`clusternode` (
`NODE_ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`NODE_STATE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`NODE_ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`columnlayout`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`columnlayout` (
`ID` DECIMAL(18,0) NOT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SEARCHREQUEST` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `cl_searchrequest` ON `jira`.`columnlayout` (`SEARCHREQUEST` ASC);
CREATE INDEX `cl_username` ON `jira`.`columnlayout` (`USERNAME` ASC);
— —————————————————–
— Table `jira`.`columnlayoutitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`columnlayoutitem` (
`ID` DECIMAL(18,0) NOT NULL,
`COLUMNLAYOUT` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDIDENTIFIER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`HORIZONTALPOSITION` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`component`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`component` (
`ID` DECIMAL(18,0) NOT NULL,
`PROJECT` DECIMAL(18,0) NULL DEFAULT NULL,
`cname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`description` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LEAD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ASSIGNEETYPE` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`configurationcontext`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`configurationcontext` (
`ID` DECIMAL(18,0) NOT NULL,
`PROJECTCATEGORY` DECIMAL(18,0) NULL DEFAULT NULL,
`PROJECT` DECIMAL(18,0) NULL DEFAULT NULL,
`customfield` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDCONFIGSCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `confcontext` ON `jira`.`configurationcontext` (`PROJECTCATEGORY` ASC, `PROJECT` ASC, `customfield` ASC);
CREATE INDEX `confcontextprojectkey` ON `jira`.`configurationcontext` (`PROJECT` ASC, `customfield` ASC);
CREATE INDEX `confcontextfieldconfigscheme` ON `jira`.`configurationcontext` (`FIELDCONFIGSCHEME` ASC);
— —————————————————–
— Table `jira`.`customfield`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`customfield` (
`ID` DECIMAL(18,0) NOT NULL,
`CUSTOMFIELDTYPEKEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CUSTOMFIELDSEARCHERKEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`cfname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`defaultvalue` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDTYPE` DECIMAL(18,0) NULL DEFAULT NULL,
`PROJECT` DECIMAL(18,0) NULL DEFAULT NULL,
`ISSUETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`customfieldoption`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`customfieldoption` (
`ID` DECIMAL(18,0) NOT NULL,
`CUSTOMFIELD` DECIMAL(18,0) NULL DEFAULT NULL,
`CUSTOMFIELDCONFIG` DECIMAL(18,0) NULL DEFAULT NULL,
`PARENTOPTIONID` DECIMAL(18,0) NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`customvalue` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`optiontype` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`disabled` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `cf_cfoption` ON `jira`.`customfieldoption` (`CUSTOMFIELD` ASC);
— —————————————————–
— Table `jira`.`customfieldvalue`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`customfieldvalue` (
`ID` DECIMAL(18,0) NOT NULL,
`ISSUE` DECIMAL(18,0) NULL DEFAULT NULL,
`CUSTOMFIELD` DECIMAL(18,0) NULL DEFAULT NULL,
`PARENTKEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STRINGVALUE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NUMBERVALUE` DECIMAL(18,6) NULL DEFAULT NULL,
`TEXTVALUE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DATEVALUE` DATETIME NULL DEFAULT NULL,
`VALUETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `cfvalue_issue` ON `jira`.`customfieldvalue` (`ISSUE` ASC, `CUSTOMFIELD` ASC);
— —————————————————–
— Table `jira`.`cwd_application`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_application` (
`ID` DECIMAL(18,0) NOT NULL,
`application_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_application_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`created_date` DATETIME NULL DEFAULT NULL,
`updated_date` DATETIME NULL DEFAULT NULL,
`active` DECIMAL(9,0) NULL DEFAULT NULL,
`description` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`application_type` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`credential` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uk_application_name` ON `jira`.`cwd_application` (`lower_application_name` ASC);
— —————————————————–
— Table `jira`.`cwd_application_address`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_application_address` (
`application_id` DECIMAL(18,0) NOT NULL,
`remote_address` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`encoded_address_binary` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`remote_address_mask` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`application_id`, `remote_address`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`cwd_directory`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_directory` (
`ID` DECIMAL(18,0) NOT NULL,
`directory_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_directory_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`created_date` DATETIME NULL DEFAULT NULL,
`updated_date` DATETIME NULL DEFAULT NULL,
`active` DECIMAL(9,0) NULL DEFAULT NULL,
`description` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`impl_class` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_impl_class` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`directory_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`directory_position` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `uk_directory_name` ON `jira`.`cwd_directory` (`lower_directory_name` ASC);
CREATE INDEX `idx_directory_active` ON `jira`.`cwd_directory` (`active` ASC);
CREATE INDEX `idx_directory_impl` ON `jira`.`cwd_directory` (`lower_impl_class` ASC);
CREATE INDEX `idx_directory_type` ON `jira`.`cwd_directory` (`directory_type` ASC);
— —————————————————–
— Table `jira`.`cwd_directory_attribute`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_directory_attribute` (
`directory_id` DECIMAL(18,0) NOT NULL,
`attribute_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`attribute_value` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`directory_id`, `attribute_name`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`cwd_directory_operation`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_directory_operation` (
`directory_id` DECIMAL(18,0) NOT NULL,
`operation_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
PRIMARY KEY (`directory_id`, `operation_type`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`cwd_group`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_group` (
`ID` DECIMAL(18,0) NOT NULL,
`group_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_group_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`active` DECIMAL(9,0) NULL DEFAULT NULL,
`local` DECIMAL(9,0) NULL DEFAULT NULL,
`created_date` DATETIME NULL DEFAULT NULL,
`updated_date` DATETIME NULL DEFAULT NULL,
`description` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_description` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`group_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`directory_id` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uk_group_name_dir_id` ON `jira`.`cwd_group` (`lower_group_name` ASC, `directory_id` ASC);
CREATE INDEX `idx_group_active` ON `jira`.`cwd_group` (`lower_group_name` ASC, `active` ASC);
CREATE INDEX `idx_group_dir_id` ON `jira`.`cwd_group` (`directory_id` ASC);
— —————————————————–
— Table `jira`.`cwd_group_attributes`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_group_attributes` (
`ID` DECIMAL(18,0) NOT NULL,
`group_id` DECIMAL(18,0) NULL DEFAULT NULL,
`directory_id` DECIMAL(18,0) NULL DEFAULT NULL,
`attribute_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`attribute_value` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_attribute_value` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uk_group_attr_name_lval` ON `jira`.`cwd_group_attributes` (`group_id` ASC, `attribute_name` ASC, `lower_attribute_value` ASC);
CREATE INDEX `idx_group_attr_dir_name_lval` ON `jira`.`cwd_group_attributes` (`directory_id` ASC, `attribute_name` ASC, `lower_attribute_value` ASC);
— —————————————————–
— Table `jira`.`cwd_membership`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_membership` (
`ID` DECIMAL(18,0) NOT NULL,
`parent_id` DECIMAL(18,0) NULL DEFAULT NULL,
`child_id` DECIMAL(18,0) NULL DEFAULT NULL,
`membership_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`group_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`parent_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_parent_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`child_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_child_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`directory_id` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uk_mem_parent_child_type` ON `jira`.`cwd_membership` (`parent_id` ASC, `child_id` ASC, `membership_type` ASC);
CREATE INDEX `idx_mem_dir_parent_child` ON `jira`.`cwd_membership` (`lower_parent_name` ASC, `lower_child_name` ASC, `membership_type` ASC, `directory_id` ASC);
CREATE INDEX `idx_mem_dir_parent` ON `jira`.`cwd_membership` (`lower_parent_name` ASC, `membership_type` ASC, `directory_id` ASC);
CREATE INDEX `idx_mem_dir_child` ON `jira`.`cwd_membership` (`lower_child_name` ASC, `membership_type` ASC, `directory_id` ASC);
— —————————————————–
— Table `jira`.`cwd_user`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_user` (
`ID` DECIMAL(18,0) NOT NULL,
`directory_id` DECIMAL(18,0) NULL DEFAULT NULL,
`user_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_user_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`active` DECIMAL(9,0) NULL DEFAULT NULL,
`created_date` DATETIME NULL DEFAULT NULL,
`updated_date` DATETIME NULL DEFAULT NULL,
`first_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_first_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`last_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_last_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`display_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_display_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`email_address` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_email_address` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREDENTIAL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`deleted_externally` DECIMAL(9,0) NULL DEFAULT NULL,
`EXTERNAL_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uk_user_name_dir_id` ON `jira`.`cwd_user` (`lower_user_name` ASC, `directory_id` ASC);
CREATE INDEX `uk_user_externalid_dir_id` ON `jira`.`cwd_user` (`EXTERNAL_ID` ASC, `directory_id` ASC);
CREATE INDEX `idx_first_name` ON `jira`.`cwd_user` (`lower_first_name` ASC);
CREATE INDEX `idx_last_name` ON `jira`.`cwd_user` (`lower_last_name` ASC);
CREATE INDEX `idx_display_name` ON `jira`.`cwd_user` (`lower_display_name` ASC);
CREATE INDEX `idx_email_address` ON `jira`.`cwd_user` (`lower_email_address` ASC);
— —————————————————–
— Table `jira`.`cwd_user_attributes`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`cwd_user_attributes` (
`ID` DECIMAL(18,0) NOT NULL,
`user_id` DECIMAL(18,0) NULL DEFAULT NULL,
`directory_id` DECIMAL(18,0) NULL DEFAULT NULL,
`attribute_name` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`attribute_value` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lower_attribute_value` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `idx_user_attr_dir_name_lval` ON `jira`.`cwd_user_attributes` (`directory_id` ASC, `attribute_name` ASC, `lower_attribute_value` ASC);
CREATE INDEX `uk_user_attr_name_lval` ON `jira`.`cwd_user_attributes` (`user_id` ASC, `attribute_name` ASC);
— —————————————————–
— Table `jira`.`draftworkflowscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`draftworkflowscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`WORKFLOW_SCHEME_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`LAST_MODIFIED_DATE` DATETIME NULL DEFAULT NULL,
`LAST_MODIFIED_USER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `draft_workflow_scheme_parent` ON `jira`.`draftworkflowscheme` (`WORKFLOW_SCHEME_ID` ASC);
— —————————————————–
— Table `jira`.`draftworkflowschemeentity`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`draftworkflowschemeentity` (
`ID` DECIMAL(18,0) NOT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`WORKFLOW` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`issuetype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `draft_workflow_scheme` ON `jira`.`draftworkflowschemeentity` (`SCHEME` ASC);
— —————————————————–
— Table `jira`.`entity_property`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`entity_property` (
`ID` DECIMAL(18,0) NOT NULL,
`ENTITY_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ENTITY_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`PROPERTY_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`UPDATED` DATETIME NULL DEFAULT NULL,
`json_value` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `entityproperty_identiti` ON `jira`.`entity_property` (`ENTITY_NAME` ASC, `ENTITY_ID` ASC, `PROPERTY_KEY` ASC);
— —————————————————–
— Table `jira`.`entity_property_index_document`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`entity_property_index_document` (
`ID` DECIMAL(18,0) NOT NULL,
`PLUGIN_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MODULE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ENTITY_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`UPDATED` DATETIME NULL DEFAULT NULL,
`DOCUMENT` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `entpropindexdoc_module` ON `jira`.`entity_property_index_document` (`PLUGIN_KEY` ASC, `MODULE_KEY` ASC);
— —————————————————–
— Table `jira`.`external_entities`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`external_entities` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`entitytype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `ext_entity_name` ON `jira`.`external_entities` (`NAME` ASC);
— —————————————————–
— Table `jira`.`externalgadget`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`externalgadget` (
`ID` DECIMAL(18,0) NOT NULL,
`GADGET_XML` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`favouriteassociations`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`favouriteassociations` (
`ID` DECIMAL(18,0) NOT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`entitytype` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`entityid` DECIMAL(18,0) NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `favourite_index` ON `jira`.`favouriteassociations` (`USERNAME` ASC, `entitytype` ASC, `entityid` ASC);
— —————————————————–
— Table `jira`.`feature`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`feature` (
`ID` DECIMAL(18,0) NOT NULL,
`FEATURE_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FEATURE_TYPE` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USER_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `feature_id_userkey` ON `jira`.`feature` (`ID` ASC, `USER_KEY` ASC);
— —————————————————–
— Table `jira`.`fieldconfigscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldconfigscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`configname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CUSTOMFIELD` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fcs_fieldid` ON `jira`.`fieldconfigscheme` (`FIELDID` ASC);
— —————————————————–
— Table `jira`.`fieldconfigschemeissuetype`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldconfigschemeissuetype` (
`ID` DECIMAL(18,0) NOT NULL,
`ISSUETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDCONFIGSCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDCONFIGURATION` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fcs_issuetype` ON `jira`.`fieldconfigschemeissuetype` (`ISSUETYPE` ASC);
CREATE INDEX `fcs_scheme` ON `jira`.`fieldconfigschemeissuetype` (`FIELDCONFIGSCHEME` ASC);
— —————————————————–
— Table `jira`.`fieldconfiguration`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldconfiguration` (
`ID` DECIMAL(18,0) NOT NULL,
`configname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CUSTOMFIELD` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fc_fieldid` ON `jira`.`fieldconfiguration` (`FIELDID` ASC);
— —————————————————–
— Table `jira`.`fieldlayout`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldlayout` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`layout_type` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LAYOUTSCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`fieldlayoutitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldlayoutitem` (
`ID` DECIMAL(18,0) NOT NULL,
`FIELDLAYOUT` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDIDENTIFIER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`VERTICALPOSITION` DECIMAL(18,0) NULL DEFAULT NULL,
`ISHIDDEN` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ISREQUIRED` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RENDERERTYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`fieldlayoutscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldlayoutscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`fieldlayoutschemeassociation`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldlayoutschemeassociation` (
`ID` DECIMAL(18,0) NOT NULL,
`ISSUETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PROJECT` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDLAYOUTSCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fl_scheme_assoc` ON `jira`.`fieldlayoutschemeassociation` (`PROJECT` ASC, `ISSUETYPE` ASC);
— —————————————————–
— Table `jira`.`fieldlayoutschemeentity`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldlayoutschemeentity` (
`ID` DECIMAL(18,0) NOT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`issuetype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDLAYOUT` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fieldlayout_scheme` ON `jira`.`fieldlayoutschemeentity` (`SCHEME` ASC);
CREATE INDEX `fieldlayout_layout` ON `jira`.`fieldlayoutschemeentity` (`FIELDLAYOUT` ASC);
— —————————————————–
— Table `jira`.`fieldscreen`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldscreen` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`fieldscreenlayoutitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldscreenlayoutitem` (
`ID` DECIMAL(18,0) NOT NULL,
`FIELDIDENTIFIER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDSCREENTAB` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fieldscitem_tab` ON `jira`.`fieldscreenlayoutitem` (`FIELDSCREENTAB` ASC);
CREATE INDEX `fieldscreen_field` ON `jira`.`fieldscreenlayoutitem` (`FIELDIDENTIFIER` ASC);
— —————————————————–
— Table `jira`.`fieldscreenscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldscreenscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`fieldscreenschemeitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldscreenschemeitem` (
`ID` DECIMAL(18,0) NOT NULL,
`OPERATION` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDSCREEN` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDSCREENSCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `screenitem_scheme` ON `jira`.`fieldscreenschemeitem` (`FIELDSCREENSCHEME` ASC);
— —————————————————–
— Table `jira`.`fieldscreentab`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fieldscreentab` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDSCREEN` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fieldscreen_tab` ON `jira`.`fieldscreentab` (`FIELDSCREEN` ASC);
— —————————————————–
— Table `jira`.`fileattachment`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`fileattachment` (
`ID` DECIMAL(18,0) NOT NULL,
`issueid` DECIMAL(18,0) NULL DEFAULT NULL,
`MIMETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FILENAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`FILESIZE` DECIMAL(18,0) NULL DEFAULT NULL,
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`zip` DECIMAL(9,0) NULL DEFAULT NULL,
`thumbnailable` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `attach_issue` ON `jira`.`fileattachment` (`issueid` ASC);
— —————————————————–
— Table `jira`.`filtersubscription`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`filtersubscription` (
`ID` DECIMAL(18,0) NOT NULL,
`FILTER_I_D` DECIMAL(18,0) NULL DEFAULT NULL,
`USERNAME` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`groupname` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LAST_RUN` DATETIME NULL DEFAULT NULL,
`EMAIL_ON_EMPTY` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `subscrpt_user` ON `jira`.`filtersubscription` (`FILTER_I_D` ASC, `USERNAME` ASC);
CREATE INDEX `subscrptn_group` ON `jira`.`filtersubscription` (`FILTER_I_D` ASC, `groupname` ASC);
— —————————————————–
— Table `jira`.`gadgetuserpreference`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`gadgetuserpreference` (
`ID` DECIMAL(18,0) NOT NULL,
`PORTLETCONFIGURATION` DECIMAL(18,0) NULL DEFAULT NULL,
`USERPREFKEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERPREFVALUE` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `userpref_portletconfiguration` ON `jira`.`gadgetuserpreference` (`PORTLETCONFIGURATION` ASC);
— —————————————————–
— Table `jira`.`genericconfiguration`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`genericconfiguration` (
`ID` DECIMAL(18,0) NOT NULL,
`DATATYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DATAKEY` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`XMLVALUE` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `type_key` ON `jira`.`genericconfiguration` (`DATATYPE` ASC, `DATAKEY` ASC);
— —————————————————–
— Table `jira`.`globalpermissionentry`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`globalpermissionentry` (
`ID` DECIMAL(18,0) NOT NULL,
`PERMISSION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`GROUP_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`groupbase`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`groupbase` (
`ID` DECIMAL(18,0) NOT NULL,
`groupname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `osgroup_name` ON `jira`.`groupbase` (`groupname` ASC);
— —————————————————–
— Table `jira`.`issuelink`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuelink` (
`ID` DECIMAL(18,0) NOT NULL,
`LINKTYPE` DECIMAL(18,0) NULL DEFAULT NULL,
`SOURCE` DECIMAL(18,0) NULL DEFAULT NULL,
`DESTINATION` DECIMAL(18,0) NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `issuelink_src` ON `jira`.`issuelink` (`SOURCE` ASC);
CREATE INDEX `issuelink_dest` ON `jira`.`issuelink` (`DESTINATION` ASC);
CREATE INDEX `issuelink_type` ON `jira`.`issuelink` (`LINKTYPE` ASC);
— —————————————————–
— Table `jira`.`issuelinktype`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuelinktype` (
`ID` DECIMAL(18,0) NOT NULL,
`LINKNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INWARD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OUTWARD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`pstyle` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `linktypename` ON `jira`.`issuelinktype` (`LINKNAME` ASC);
CREATE INDEX `linktypestyle` ON `jira`.`issuelinktype` (`pstyle` ASC);
— —————————————————–
— Table `jira`.`issuesecurityscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuesecurityscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DEFAULTLEVEL` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`issuestatus`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuestatus` (
`ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`pname` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICONURL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSCATEGORY` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`issuetype`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuetype` (
`ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`pname` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`pstyle` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICONURL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`issuetypescreenscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuetypescreenscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`issuetypescreenschemeentity`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`issuetypescreenschemeentity` (
`ID` DECIMAL(18,0) NOT NULL,
`ISSUETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`FIELDSCREENSCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fieldscreen_scheme` ON `jira`.`issuetypescreenschemeentity` (`FIELDSCREENSCHEME` ASC);
— —————————————————–
— Table `jira`.`jiraaction`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`jiraaction` (
`ID` DECIMAL(18,0) NOT NULL,
`issueid` DECIMAL(18,0) NULL DEFAULT NULL,
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`actiontype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`actionlevel` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`rolelevel` DECIMAL(18,0) NULL DEFAULT NULL,
`actionbody` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`UPDATEAUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`UPDATED` DATETIME NULL DEFAULT NULL,
`actionnum` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `action_issue` ON `jira`.`jiraaction` (`issueid` ASC, `actiontype` ASC);
CREATE INDEX `action_authorcreated` ON `jira`.`jiraaction` (`issueid` ASC, `AUTHOR` ASC, `CREATED` ASC);
CREATE INDEX `action_authorupdated` ON `jira`.`jiraaction` (`issueid` ASC, `AUTHOR` ASC, `UPDATED` ASC);
— —————————————————–
— Table `jira`.`jiradraftworkflows`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`jiradraftworkflows` (
`ID` DECIMAL(18,0) NOT NULL,
`PARENTNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTOR` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`jiraeventtype`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`jiraeventtype` (
`ID` DECIMAL(18,0) NOT NULL,
`TEMPLATE_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`event_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`jiraissue`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`jiraissue` (
`ID` DECIMAL(18,0) NOT NULL,
`pkey` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`issuenum` DECIMAL(18,0) NULL DEFAULT NULL,
`PROJECT` DECIMAL(18,0) NULL DEFAULT NULL,
`REPORTER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ASSIGNEE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`issuetype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SUMMARY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ENVIRONMENT` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PRIORITY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RESOLUTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`issuestatus` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`UPDATED` DATETIME NULL DEFAULT NULL,
`DUEDATE` DATETIME NULL DEFAULT NULL,
`RESOLUTIONDATE` DATETIME NULL DEFAULT NULL,
`VOTES` DECIMAL(18,0) NULL DEFAULT NULL,
`WATCHES` DECIMAL(18,0) NULL DEFAULT NULL,
`TIMEORIGINALESTIMATE` DECIMAL(18,0) NULL DEFAULT NULL,
`TIMEESTIMATE` DECIMAL(18,0) NULL DEFAULT NULL,
`TIMESPENT` DECIMAL(18,0) NULL DEFAULT NULL,
`WORKFLOW_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`SECURITY` DECIMAL(18,0) NULL DEFAULT NULL,
`FIXFOR` DECIMAL(18,0) NULL DEFAULT NULL,
`COMPONENT` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `issue_proj_num` ON `jira`.`jiraissue` (`issuenum` ASC, `PROJECT` ASC);
CREATE INDEX `issue_proj_status` ON `jira`.`jiraissue` (`PROJECT` ASC, `issuestatus` ASC);
CREATE INDEX `issue_updated` ON `jira`.`jiraissue` (`UPDATED` ASC);
CREATE INDEX `issue_assignee` ON `jira`.`jiraissue` (`ASSIGNEE` ASC);
CREATE INDEX `issue_workflow` ON `jira`.`jiraissue` (`WORKFLOW_ID` ASC);
— —————————————————–
— Table `jira`.`jiraperms`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`jiraperms` (
`ID` DECIMAL(18,0) NOT NULL,
`permtype` DECIMAL(18,0) NULL DEFAULT NULL,
`projectid` DECIMAL(18,0) NULL DEFAULT NULL,
`groupname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`jiraworkflows`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`jiraworkflows` (
`ID` DECIMAL(18,0) NOT NULL,
`workflowname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`creatorname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTOR` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ISLOCKED` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`label`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`label` (
`ID` DECIMAL(18,0) NOT NULL,
`FIELDID` DECIMAL(18,0) NULL DEFAULT NULL,
`ISSUE` DECIMAL(18,0) NULL DEFAULT NULL,
`LABEL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `label_fieldissue` ON `jira`.`label` (`ISSUE` ASC, `FIELDID` ASC);
CREATE INDEX `label_fieldissuelabel` ON `jira`.`label` (`ISSUE` ASC, `FIELDID` ASC, `LABEL` ASC);
CREATE INDEX `label_label` ON `jira`.`label` (`LABEL` ASC);
CREATE INDEX `label_issue` ON `jira`.`label` (`ISSUE` ASC);
— —————————————————–
— Table `jira`.`listenerconfig`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`listenerconfig` (
`ID` DECIMAL(18,0) NOT NULL,
`CLAZZ` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`listenername` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`mailserver`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`mailserver` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`mailfrom` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PREFIX` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`smtp_port` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`protocol` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`server_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SERVERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JNDILOCATION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`mailusername` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`mailpassword` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ISTLSREQUIRED` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TIMEOUT` DECIMAL(18,0) NULL DEFAULT NULL,
`socks_port` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`socks_host` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`managedconfigurationitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`managedconfigurationitem` (
`ID` DECIMAL(18,0) NOT NULL,
`ITEM_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ITEM_TYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MANAGED` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ACCESS_LEVEL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SOURCE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `managedconfigitem_id_type_idx` ON `jira`.`managedconfigurationitem` (`ITEM_ID` ASC, `ITEM_TYPE` ASC);
— —————————————————–
— Table `jira`.`membershipbase`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`membershipbase` (
`ID` DECIMAL(18,0) NOT NULL,
`USER_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`GROUP_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `mshipbase_user` ON `jira`.`membershipbase` (`USER_NAME` ASC);
CREATE INDEX `mshipbase_group` ON `jira`.`membershipbase` (`GROUP_NAME` ASC);
— —————————————————–
— Table `jira`.`moved_issue_key`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`moved_issue_key` (
`ID` DECIMAL(18,0) NOT NULL,
`OLD_ISSUE_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ISSUE_ID` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `idx_old_issue_key` ON `jira`.`moved_issue_key` (`OLD_ISSUE_KEY` ASC);
— —————————————————–
— Table `jira`.`nodeassociation`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`nodeassociation` (
`SOURCE_NODE_ID` DECIMAL(18,0) NOT NULL,
`SOURCE_NODE_ENTITY` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SINK_NODE_ID` DECIMAL(18,0) NOT NULL,
`SINK_NODE_ENTITY` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`ASSOCIATION_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQUENCE` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`SOURCE_NODE_ID`, `SOURCE_NODE_ENTITY`, `SINK_NODE_ID`, `SINK_NODE_ENTITY`, `ASSOCIATION_TYPE`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `node_source` ON `jira`.`nodeassociation` (`SOURCE_NODE_ID` ASC, `SOURCE_NODE_ENTITY` ASC);
CREATE INDEX `node_sink` ON `jira`.`nodeassociation` (`SINK_NODE_ID` ASC, `SINK_NODE_ENTITY` ASC);
— —————————————————–
— Table `jira`.`nodeindexcounter`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`nodeindexcounter` (
`ID` DECIMAL(18,0) NOT NULL,
`NODE_ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SENDING_NODE_ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INDEX_OPERATION_ID` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `node_id_idx` ON `jira`.`nodeindexcounter` (`NODE_ID` ASC, `SENDING_NODE_ID` ASC);
— —————————————————–
— Table `jira`.`notification`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`notification` (
`ID` DECIMAL(18,0) NOT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`EVENT` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`EVENT_TYPE_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`TEMPLATE_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`notif_type` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`notif_parameter` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `ntfctn_scheme` ON `jira`.`notification` (`SCHEME` ASC);
— —————————————————–
— Table `jira`.`notificationinstance`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`notificationinstance` (
`ID` DECIMAL(18,0) NOT NULL,
`notificationtype` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SOURCE` DECIMAL(18,0) NULL DEFAULT NULL,
`emailaddress` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MESSAGEID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `notif_source` ON `jira`.`notificationinstance` (`SOURCE` ASC);
— —————————————————–
— Table `jira`.`notificationscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`notificationscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`oauthconsumer`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`oauthconsumer` (
`ID` DECIMAL(18,0) NOT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`consumername` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CONSUMER_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`consumerservice` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PUBLIC_KEY` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PRIVATE_KEY` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CALLBACK` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SIGNATURE_METHOD` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SHARED_SECRET` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `oauth_consumer_index` ON `jira`.`oauthconsumer` (`CONSUMER_KEY` ASC);
CREATE UNIQUE INDEX `oauth_consumer_service_index` ON `jira`.`oauthconsumer` (`consumerservice` ASC);
— —————————————————–
— Table `jira`.`oauthconsumertoken`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`oauthconsumertoken` (
`ID` DECIMAL(18,0) NOT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`TOKEN_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TOKEN` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TOKEN_SECRET` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TOKEN_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CONSUMER_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `oauth_consumer_token_key_index` ON `jira`.`oauthconsumertoken` (`TOKEN_KEY` ASC);
CREATE INDEX `oauth_consumer_token_index` ON `jira`.`oauthconsumertoken` (`TOKEN` ASC);
— —————————————————–
— Table `jira`.`oauthspconsumer`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`oauthspconsumer` (
`ID` DECIMAL(18,0) NOT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`CONSUMER_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`consumername` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PUBLIC_KEY` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CALLBACK` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TWO_L_O_ALLOWED` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`EXECUTING_TWO_L_O_USER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TWO_L_O_IMPERSONATION_ALLOWED` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`THREE_L_O_ALLOWED` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `oauth_sp_consumer_index` ON `jira`.`oauthspconsumer` (`CONSUMER_KEY` ASC);
— —————————————————–
— Table `jira`.`oauthsptoken`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`oauthsptoken` (
`ID` DECIMAL(18,0) NOT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`TOKEN` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TOKEN_SECRET` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TOKEN_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CONSUMER_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TTL` DECIMAL(18,0) NULL DEFAULT NULL,
`spauth` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CALLBACK` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`spverifier` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`spversion` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SESSION_HANDLE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SESSION_CREATION_TIME` DATETIME NULL DEFAULT NULL,
`SESSION_LAST_RENEWAL_TIME` DATETIME NULL DEFAULT NULL,
`SESSION_TIME_TO_LIVE` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `oauth_sp_token_index` ON `jira`.`oauthsptoken` (`TOKEN` ASC);
CREATE INDEX `oauth_sp_consumer_key_index` ON `jira`.`oauthsptoken` (`CONSUMER_KEY` ASC);
— —————————————————–
— Table `jira`.`optionconfiguration`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`optionconfiguration` (
`ID` DECIMAL(18,0) NOT NULL,
`FIELDID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OPTIONID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIELDCONFIG` DECIMAL(18,0) NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `fieldid_optionid` ON `jira`.`optionconfiguration` (`FIELDID` ASC, `OPTIONID` ASC);
CREATE INDEX `fieldid_fieldconf` ON `jira`.`optionconfiguration` (`FIELDID` ASC, `FIELDCONFIG` ASC);
— —————————————————–
— Table `jira`.`permissionscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`permissionscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`pluginstate`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`pluginstate` (
`pluginkey` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`pluginenabled` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`pluginkey`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`pluginversion`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`pluginversion` (
`ID` DECIMAL(18,0) NOT NULL,
`pluginname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`pluginkey` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`pluginversion` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`portalpage`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`portalpage` (
`ID` DECIMAL(18,0) NOT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PAGENAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`FAV_COUNT` DECIMAL(18,0) NULL DEFAULT NULL,
`LAYOUT` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ppversion` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `ppage_username` ON `jira`.`portalpage` (`USERNAME` ASC);
— —————————————————–
— Table `jira`.`portletconfiguration`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`portletconfiguration` (
`ID` DECIMAL(18,0) NOT NULL,
`PORTALPAGE` DECIMAL(18,0) NULL DEFAULT NULL,
`PORTLET_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`COLUMN_NUMBER` DECIMAL(9,0) NULL DEFAULT NULL,
`positionseq` DECIMAL(9,0) NULL DEFAULT NULL,
`GADGET_XML` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`COLOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`priority`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`priority` (
`ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`pname` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICONURL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUS_COLOR` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`project`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`project` (
`ID` DECIMAL(18,0) NOT NULL,
`pname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`LEAD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`pkey` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`pcounter` DECIMAL(18,0) NULL DEFAULT NULL,
`ASSIGNEETYPE` DECIMAL(18,0) NULL DEFAULT NULL,
`AVATAR` DECIMAL(18,0) NULL DEFAULT NULL,
`ORIGINALKEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `idx_project_key` ON `jira`.`project` (`pkey` ASC);
— —————————————————–
— Table `jira`.`project_key`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`project_key` (
`ID` DECIMAL(18,0) NOT NULL,
`PROJECT_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`PROJECT_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `idx_all_project_keys` ON `jira`.`project_key` (`PROJECT_KEY` ASC);
CREATE INDEX `idx_all_project_ids` ON `jira`.`project_key` (`PROJECT_ID` ASC);
— —————————————————–
— Table `jira`.`projectcategory`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`projectcategory` (
`ID` DECIMAL(18,0) NOT NULL,
`cname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`description` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`projectrole`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`projectrole` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`projectroleactor`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`projectroleactor` (
`ID` DECIMAL(18,0) NOT NULL,
`PID` DECIMAL(18,0) NULL DEFAULT NULL,
`PROJECTROLEID` DECIMAL(18,0) NULL DEFAULT NULL,
`ROLETYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ROLETYPEPARAMETER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `role_player_idx` ON `jira`.`projectroleactor` (`PROJECTROLEID` ASC, `PID` ASC);
— —————————————————–
— Table `jira`.`projectversion`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`projectversion` (
`ID` DECIMAL(18,0) NOT NULL,
`PROJECT` DECIMAL(18,0) NULL DEFAULT NULL,
`vname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`RELEASED` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ARCHIVED` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STARTDATE` DATETIME NULL DEFAULT NULL,
`RELEASEDATE` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`propertydata`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertydata` (
`ID` DECIMAL(18,0) NOT NULL,
`propertyvalue` BLOB NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`propertydate`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertydate` (
`ID` DECIMAL(18,0) NOT NULL,
`propertyvalue` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`propertydecimal`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertydecimal` (
`ID` DECIMAL(18,0) NOT NULL,
`propertyvalue` DECIMAL(18,6) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`propertyentry`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertyentry` (
`ID` DECIMAL(18,0) NOT NULL,
`ENTITY_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ENTITY_ID` DECIMAL(18,0) NULL DEFAULT NULL,
`PROPERTY_KEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`propertytype` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `osproperty_all` ON `jira`.`propertyentry` (`ENTITY_ID` ASC);
CREATE INDEX `osproperty_entityName` ON `jira`.`propertyentry` (`ENTITY_NAME` ASC);
CREATE INDEX `osproperty_propertyKey` ON `jira`.`propertyentry` (`PROPERTY_KEY` ASC);
— —————————————————–
— Table `jira`.`propertynumber`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertynumber` (
`ID` DECIMAL(18,0) NOT NULL,
`propertyvalue` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`propertystring`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertystring` (
`ID` DECIMAL(18,0) NOT NULL,
`propertyvalue` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`propertytext`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`propertytext` (
`ID` DECIMAL(18,0) NOT NULL,
`propertyvalue` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_calendars`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_calendars` (
`ID` DECIMAL(18,0) NULL DEFAULT NULL,
`CALENDAR_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`CALENDAR` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`CALENDAR_NAME`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_cron_triggers`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_cron_triggers` (
`ID` DECIMAL(18,0) NOT NULL,
`trigger_id` DECIMAL(18,0) NULL DEFAULT NULL,
`cronExperssion` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_fired_triggers`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_fired_triggers` (
`ID` DECIMAL(18,0) NULL DEFAULT NULL,
`ENTRY_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`trigger_id` DECIMAL(18,0) NULL DEFAULT NULL,
`TRIGGER_LISTENER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FIRED_TIME` DATETIME NULL DEFAULT NULL,
`TRIGGER_STATE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ENTRY_ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_job_details`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_job_details` (
`ID` DECIMAL(18,0) NOT NULL,
`JOB_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_GROUP` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CLASS_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_DURABLE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IS_STATEFUL` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`REQUESTS_RECOVERY` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB_DATA` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_job_listeners`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_job_listeners` (
`ID` DECIMAL(18,0) NOT NULL,
`JOB` DECIMAL(18,0) NULL DEFAULT NULL,
`JOB_LISTENER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_simple_triggers`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_simple_triggers` (
`ID` DECIMAL(18,0) NOT NULL,
`trigger_id` DECIMAL(18,0) NULL DEFAULT NULL,
`REPEAT_COUNT` DECIMAL(9,0) NULL DEFAULT NULL,
`REPEAT_INTERVAL` DECIMAL(18,0) NULL DEFAULT NULL,
`TIMES_TRIGGERED` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_trigger_listeners`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_trigger_listeners` (
`ID` DECIMAL(18,0) NOT NULL,
`trigger_id` DECIMAL(18,0) NULL DEFAULT NULL,
`TRIGGER_LISTENER` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`qrtz_triggers`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`qrtz_triggers` (
`ID` DECIMAL(18,0) NOT NULL,
`TRIGGER_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_GROUP` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`JOB` DECIMAL(18,0) NULL DEFAULT NULL,
`NEXT_FIRE` DATETIME NULL DEFAULT NULL,
`TRIGGER_STATE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TRIGGER_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`START_TIME` DATETIME NULL DEFAULT NULL,
`END_TIME` DATETIME NULL DEFAULT NULL,
`CALENDAR_NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`MISFIRE_INSTR` DECIMAL(9,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`remembermetoken`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`remembermetoken` (
`ID` DECIMAL(18,0) NOT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`TOKEN` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `remembermetoken_username_index` ON `jira`.`remembermetoken` (`USERNAME` ASC);
— —————————————————–
— Table `jira`.`remotelink`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`remotelink` (
`ID` DECIMAL(18,0) NOT NULL,
`ISSUEID` DECIMAL(18,0) NULL DEFAULT NULL,
`GLOBALID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TITLE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SUMMARY` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICONURL` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICONTITLE` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RELATIONSHIP` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`RESOLVED` CHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSDESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSICONURL` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSICONTITLE` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSICONLINK` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSCATEGORYKEY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`STATUSCATEGORYCOLORNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`APPLICATIONTYPE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`APPLICATIONNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `remotelink_issueid` ON `jira`.`remotelink` (`ISSUEID` ASC, `GLOBALID` ASC);
CREATE INDEX `remotelink_globalid` ON `jira`.`remotelink` (`GLOBALID` ASC);
— —————————————————–
— Table `jira`.`replicatedindexoperation`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`replicatedindexoperation` (
`ID` DECIMAL(18,0) NOT NULL,
`INDEX_TIME` DATETIME NULL DEFAULT NULL,
`NODE_ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`AFFECTED_INDEX` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ENTITY_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`AFFECTED_IDS` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`OPERATION` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `node_operation_idx` ON `jira`.`replicatedindexoperation` (`NODE_ID` ASC, `AFFECTED_INDEX` ASC, `OPERATION` ASC, `INDEX_TIME` ASC);
— —————————————————–
— Table `jira`.`resolution`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`resolution` (
`ID` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQUENCE` DECIMAL(18,0) NULL DEFAULT NULL,
`pname` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`ICONURL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`rundetails`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`rundetails` (
`ID` DECIMAL(18,0) NOT NULL,
`JOB_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`START_TIME` DATETIME NULL DEFAULT NULL,
`RUN_DURATION` DECIMAL(18,0) NULL DEFAULT NULL,
`RUN_OUTCOME` CHAR(1) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`INFO_MESSAGE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `rundetails_jobid_idx` ON `jira`.`rundetails` (`JOB_ID` ASC);
CREATE INDEX `rundetails_starttime_idx` ON `jira`.`rundetails` (`START_TIME` ASC);
— —————————————————–
— Table `jira`.`schemeissuesecurities`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`schemeissuesecurities` (
`ID` DECIMAL(18,0) NOT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`SECURITY` DECIMAL(18,0) NULL DEFAULT NULL,
`sec_type` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`sec_parameter` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `sec_scheme` ON `jira`.`schemeissuesecurities` (`SCHEME` ASC);
CREATE INDEX `sec_security` ON `jira`.`schemeissuesecurities` (`SECURITY` ASC);
— —————————————————–
— Table `jira`.`schemeissuesecuritylevels`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`schemeissuesecuritylevels` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`schemepermissions`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`schemepermissions` (
`ID` DECIMAL(18,0) NOT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`PERMISSION` DECIMAL(18,0) NULL DEFAULT NULL,
`perm_type` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`perm_parameter` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `prmssn_scheme` ON `jira`.`schemepermissions` (`SCHEME` ASC);
— —————————————————–
— Table `jira`.`searchrequest`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`searchrequest` (
`ID` DECIMAL(18,0) NOT NULL,
`filtername` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`authorname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`username` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`groupname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`projectid` DECIMAL(18,0) NULL DEFAULT NULL,
`reqcontent` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`FAV_COUNT` DECIMAL(18,0) NULL DEFAULT NULL,
`filtername_lower` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `sr_author` ON `jira`.`searchrequest` (`authorname` ASC);
CREATE INDEX `searchrequest_filternameLower` ON `jira`.`searchrequest` (`filtername_lower` ASC);
— —————————————————–
— Table `jira`.`serviceconfig`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`serviceconfig` (
`ID` DECIMAL(18,0) NOT NULL,
`delaytime` DECIMAL(18,0) NULL DEFAULT NULL,
`CLAZZ` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`servicename` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`sharepermissions`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`sharepermissions` (
`ID` DECIMAL(18,0) NOT NULL,
`entityid` DECIMAL(18,0) NULL DEFAULT NULL,
`entitytype` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`sharetype` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PARAM1` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PARAM2` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `share_index` ON `jira`.`sharepermissions` (`entityid` ASC, `entitytype` ASC);
— —————————————————–
— Table `jira`.`trackback_ping`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`trackback_ping` (
`ID` DECIMAL(18,0) NOT NULL,
`ISSUE` DECIMAL(18,0) NULL DEFAULT NULL,
`URL` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TITLE` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`BLOGNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`EXCERPT` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`trustedapp`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`trustedapp` (
`ID` DECIMAL(18,0) NOT NULL,
`APPLICATION_ID` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PUBLIC_KEY` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`IP_MATCH` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`URL_MATCH` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`TIMEOUT` DECIMAL(18,0) NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`CREATED_BY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`UPDATED` DATETIME NULL DEFAULT NULL,
`UPDATED_BY` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `trustedapp_id` ON `jira`.`trustedapp` (`APPLICATION_ID` ASC);
— —————————————————–
— Table `jira`.`upgradehistory`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`upgradehistory` (
`ID` DECIMAL(18,0) NULL DEFAULT NULL,
`UPGRADECLASS` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TARGETBUILD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`UPGRADECLASS`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`upgradeversionhistory`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`upgradeversionhistory` (
`ID` DECIMAL(18,0) NULL DEFAULT NULL,
`TIMEPERFORMED` DATETIME NULL DEFAULT NULL,
`TARGETBUILD` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`TARGETVERSION` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`TARGETBUILD`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`userassociation`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`userassociation` (
`SOURCE_NAME` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SINK_NODE_ID` DECIMAL(18,0) NOT NULL,
`SINK_NODE_ENTITY` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`ASSOCIATION_TYPE` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NOT NULL,
`SEQUENCE` DECIMAL(9,0) NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`SOURCE_NAME`, `SINK_NODE_ID`, `SINK_NODE_ENTITY`, `ASSOCIATION_TYPE`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `user_source` ON `jira`.`userassociation` (`SOURCE_NAME` ASC);
CREATE INDEX `user_sink` ON `jira`.`userassociation` (`SINK_NODE_ID` ASC, `SINK_NODE_ENTITY` ASC);
— —————————————————–
— Table `jira`.`userbase`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`userbase` (
`ID` DECIMAL(18,0) NOT NULL,
`username` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`PASSWORD_HASH` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `osuser_name` ON `jira`.`userbase` (`username` ASC);
— —————————————————–
— Table `jira`.`userhistoryitem`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`userhistoryitem` (
`ID` DECIMAL(18,0) NOT NULL,
`entitytype` VARCHAR(10) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`entityid` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`USERNAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`lastviewed` DECIMAL(18,0) NULL DEFAULT NULL,
`data` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE UNIQUE INDEX `uh_type_user_entity` ON `jira`.`userhistoryitem` (`entitytype` ASC, `USERNAME` ASC, `entityid` ASC);
— —————————————————–
— Table `jira`.`userpickerfilter`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`userpickerfilter` (
`ID` DECIMAL(18,0) NOT NULL,
`CUSTOMFIELD` DECIMAL(18,0) NULL DEFAULT NULL,
`CUSTOMFIELDCONFIG` DECIMAL(18,0) NULL DEFAULT NULL,
`enabled` VARCHAR(60) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `upf_customfield` ON `jira`.`userpickerfilter` (`CUSTOMFIELD` ASC);
CREATE INDEX `upf_fieldconfigid` ON `jira`.`userpickerfilter` (`CUSTOMFIELDCONFIG` ASC);
— —————————————————–
— Table `jira`.`userpickerfiltergroup`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`userpickerfiltergroup` (
`ID` DECIMAL(18,0) NOT NULL,
`USERPICKERFILTER` DECIMAL(18,0) NULL DEFAULT NULL,
`groupname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `cf_userpickerfiltergroup` ON `jira`.`userpickerfiltergroup` (`USERPICKERFILTER` ASC);
— —————————————————–
— Table `jira`.`userpickerfilterrole`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`userpickerfilterrole` (
`ID` DECIMAL(18,0) NOT NULL,
`USERPICKERFILTER` DECIMAL(18,0) NULL DEFAULT NULL,
`PROJECTROLEID` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `cf_userpickerfilterrole` ON `jira`.`userpickerfilterrole` (`USERPICKERFILTER` ASC);
— —————————————————–
— Table `jira`.`versioncontrol`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`versioncontrol` (
`ID` DECIMAL(18,0) NOT NULL,
`vcsname` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`vcsdescription` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`vcstype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`votehistory`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`votehistory` (
`ID` DECIMAL(18,0) NOT NULL,
`issueid` DECIMAL(18,0) NULL DEFAULT NULL,
`VOTES` DECIMAL(18,0) NULL DEFAULT NULL,
`TIMESTAMP` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `votehistory_issue_index` ON `jira`.`votehistory` (`issueid` ASC);
— —————————————————–
— Table `jira`.`workflowscheme`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`workflowscheme` (
`ID` DECIMAL(18,0) NOT NULL,
`NAME` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`DESCRIPTION` TEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
— —————————————————–
— Table `jira`.`workflowschemeentity`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`workflowschemeentity` (
`ID` DECIMAL(18,0) NOT NULL,
`SCHEME` DECIMAL(18,0) NULL DEFAULT NULL,
`WORKFLOW` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`issuetype` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `workflow_scheme` ON `jira`.`workflowschemeentity` (`SCHEME` ASC);
— —————————————————–
— Table `jira`.`worklog`
— —————————————————–
CREATE TABLE IF NOT EXISTS `jira`.`worklog` (
`ID` DECIMAL(18,0) NOT NULL,
`issueid` DECIMAL(18,0) NULL DEFAULT NULL,
`AUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`grouplevel` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`rolelevel` DECIMAL(18,0) NULL DEFAULT NULL,
`worklogbody` LONGTEXT CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`CREATED` DATETIME NULL DEFAULT NULL,
`UPDATEAUTHOR` VARCHAR(255) CHARACTER SET ‘utf8’ COLLATE ‘utf8_bin’ NULL DEFAULT NULL,
`UPDATED` DATETIME NULL DEFAULT NULL,
`STARTDATE` DATETIME NULL DEFAULT NULL,
`timeworked` DECIMAL(18,0) NULL DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;
CREATE INDEX `worklog_issue` ON `jira`.`worklog` (`issueid` ASC);
CREATE INDEX `worklog_author` ON `jira`.`worklog` (`AUTHOR` ASC);
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Predictive Innovation Training
Predictive Innovation: Core Skills Book
RoundSquareTriangle.com