/*

SQLyog Ultimate v8.55 
MySQL - 5.7.28-log : Database - ceulocker

*********************************************************************

*/



/*!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*/`ceulocker` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;



USE `ceulocker`;



/*Table structure for table `application_discussion_comments` */



DROP TABLE IF EXISTS `application_discussion_comments`;



CREATE TABLE `application_discussion_comments` (
  `commentId` int(11) NOT NULL AUTO_INCREMENT,
  `groupId_fk` int(11) DEFAULT NULL,
  `reviewerid_fk` int(11) DEFAULT NULL,
  `comment` varchar(600) DEFAULT NULL,
  `active` bit(10) DEFAULT NULL,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `last_modified_time_stamp` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`commentId`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4;



/*Table structure for table `application_discussion_group` */



DROP TABLE IF EXISTS `application_discussion_group`;



CREATE TABLE `application_discussion_group` (
  `groupId` int(11) NOT NULL AUTO_INCREMENT,
  `ceulid_fk` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(600) DEFAULT NULL,
  `active` bit(10) DEFAULT NULL,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(50) DEFAULT NULL,
  `last_modified_time_stamp` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`groupId`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 

