<commit_before>/*
SQLyog Professional v10.42 
MySQL - 5.6.25-log : Database - rally
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`rally` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `rally`;


-- -----------------------------------------------------
-- Table `rally`.`release`
-- -----------------------------------------------------

/*Table structure for table `tbl_release` */

DROP TABLE IF EXISTS `tbl_release`;

CREATE TABLE `tbl_release` (
    `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `project_id`  BIGINT(20) NOT NULL,
    `number` INT NOT NULL,
    `start_date` DATE NOT NULL,
    `end_date` DATE NULL,
    `create_time` DATETIME NULL,
    `update_time` DATETIME NULL,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `id_UNIQUE` (`id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


-- -----------------------------------------------------
-- Table `rally`.`project`
-- -----------------------------------------------------

/*Table structure for table `tbl_project` */

DROP TABLE IF EXISTS `tbl_project`;

CREATE TABLE `tbl_project` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `team_id` BIGINT(20) NOT NULL,
  `name` VARCHAR(45) NULL,
  `status` INT NULL COMMENT '0: set up\n1 : run\n2 : abort',
  `current_release_id` BIGINT(20) NULL,
  `release_interval` INT NULL COMMENT 'release interval : int type',
  `release_unit` INT NULL COMMENT '0: day\n1: week\n2: month\n3: year //no use',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- -----------------------------------------------------
-- Table `rally`.`story`
-- -----------------------------------------------------

/*Table structure for table `tbl_story` */

DROP TABLE IF EXISTS `tbl_story`;

CREATE TABLE `tbl_story` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(128) NULL COMMENT 'title of story',
  `desc` TEXT NULL,
  `notes` TEXT NULL,
  `files` VARCHAR(1024) NULL COMMENT 'file path',
  `status` BIGINT(20) NULL COMMENT '0: init\n1: ready\n2: developing\n3: developed\n4: testing\n5: tested\n6: accept',
  `plan_est` FLOAT NULL,
  `todo` FLOAT NULL,
  `task_est` FLOAT NULL,
  `start_date` DATE NULL,
  `end_date` DATE NULL,
  `qa` BIGINT(20) NULL,
  `pm` BIGINT(20) NULL,
  `fe` BIGINT(20) NULL,
  `rd` BIGINT(20) NULL,
  `owner_id` BIGINT(20) NULL,
  `release_id` BIGINT(20) NULL,
  `project_id` BIGINT(20) NULL,
  `pid` BIGINT(20) NULL COMMENT 'FOR THE SUB STORY',
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- -----------------------------------------------------
-- Table `rally`.`member`
-- -----------------------------------------------------
/*Table structure for table `tbl_member` */

DROP TABLE IF EXISTS `tbl_member`;

CREATE TABLE `tbl_member` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(128) NOT NULL,
  `introduction` TEXT NULL,<commit_msg>add test_date for story sql<commit_after>/*
SQLyog Professional v10.42 
MySQL - 5.6.25-log : Database - rally
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`rally` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `rally`;


-- -----------------------------------------------------
-- Table `rally`.`release`
-- -----------------------------------------------------

/*Table structure for table `tbl_release` */

DROP TABLE IF EXISTS `tbl_release`;

CREATE TABLE `tbl_release` (
    `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `project_id`  BIGINT(20) NOT NULL,
    `number` INT NOT NULL,
    `start_date` DATE NOT NULL,
    `end_date` DATE NULL,
    `create_time` DATETIME NULL,
    `update_time` DATETIME NULL,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `id_UNIQUE` (`id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


-- -----------------------------------------------------
-- Table `rally`.`project`
-- -----------------------------------------------------

/*Table structure for table `tbl_project` */

DROP TABLE IF EXISTS `tbl_project`;

CREATE TABLE `tbl_project` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `team_id` BIGINT(20) NOT NULL,
  `name` VARCHAR(45) NULL,
  `status` INT NULL COMMENT '0: set up\n1 : run\n2 : abort',
  `current_release_id` BIGINT(20) NULL,
  `release_interval` INT NULL COMMENT 'release interval : int type',
  `release_unit` INT NULL COMMENT '0: day\n1: week\n2: month\n3: year //no use',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- -----------------------------------------------------
-- Table `rally`.`story`
-- -----------------------------------------------------

/*Table structure for table `tbl_story` */

DROP TABLE IF EXISTS `tbl_story`;

CREATE TABLE `tbl_story` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(128) NULL COMMENT 'title of story',
  `desc` TEXT NULL,
  `notes` TEXT NULL,
  `files` VARCHAR(1024) NULL COMMENT 'file path',
  `status` BIGINT(20) NULL COMMENT '0: init\n1: ready\n2: developing\n3: developed\n4: testing\n5: tested\n6: accept',
  `plan_est` FLOAT NULL,
  `todo` FLOAT NULL,
  `task_est` FLOAT NULL,
  `start_date` DATE NULL,
  `end_date` DATE NULL,
  `test_date` DATE NULL,
  `qa` BIGINT(20) NULL,
  `pm` BIGINT(20) NULL,
  `fe` BIGINT(20) NULL,
  `rd` BIGINT(20) NULL,
  `owner_id` BIGINT(20) NULL,
  `release_id` BIGINT(20) NULL,
  `project_id` BIGINT(20) NULL,
  `pid` BIGINT(20) NULL COMMENT 'FOR THE SUB STORY',
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- -----------------------------------------------------
-- Table `rally`.`member`
-- -----------------------------------------------------
/*Table structure for table `tbl_member` */

DROP TABLE IF EXISTS `tbl_member`;

CREATE TABLE `tbl_member` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(128) NOT NULL,
  `introduction` TEXT NULL,
{'fraction_non_alphanumeric': 0.27073277753400615, 'fraction_numerical': 0.03422553751645459, 'mean_word_length': 2.4781281790437437, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2712092', 'n_tokens_mistral': 2588, 'n_tokens_neox': 2358, 'n_words': 620}