-- --------------------------------------------------------
-- Host:                         dt0026
-- Server version:               10.1.16-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win32
-- HeidiSQL Version:             9.4.0.5173
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;

-- Dumping structure for table int_rqx_for_db001.api
CREATE TABLE IF NOT EXISTS `api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `info` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.api: ~0 rows (approximately)
/*!40000 ALTER TABLE `api` DISABLE KEYS */;
/*!40000 ALTER TABLE `api` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.attachment
CREATE TABLE IF NOT EXISTS `attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `size` int(11) NOT NULL,
  `content` longblob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.attachment: ~0 rows (approximately)
/*!40000 ALTER TABLE `attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachment` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.cron
CREATE TABLE IF NOT EXISTS `cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expression` text NOT NULL,
  `directory` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.cron: ~0 rows (approximately)
/*!40000 ALTER TABLE `cron` DISABLE KEYS */;
/*!40000 ALTER TABLE `cron` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.dbase
CREATE TABLE IF NOT EXISTS `dbase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.dbase: ~0 rows (approximately)
/*!40000 ALTER TABLE `dbase` DISABLE KEYS */;
/*!40000 ALTER TABLE `dbase` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.description
CREATE TABLE IF NOT EXISTS `description` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `detail` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.description: ~0 rows (approximately)
/*!40000 ALTER TABLE `description` DISABLE KEYS */;
/*!40000 ALTER TABLE `description` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.domain
CREATE TABLE IF NOT EXISTS `domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `status` enum('enabled','disabled') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.domain: ~0 rows (approximately)
/*!40000 ALTER TABLE `domain` DISABLE KEYS */;
/*!40000 ALTER TABLE `domain` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.email
CREATE TABLE IF NOT EXISTS `email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.email: ~0 rows (approximately)
/*!40000 ALTER TABLE `email` DISABLE KEYS */;
/*!40000 ALTER TABLE `email` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.funcx
CREATE TABLE IF NOT EXISTS `funcx` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `status` enum('enabled','disabled') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.funcx: ~0 rows (approximately)
/*!40000 ALTER TABLE `funcx` DISABLE KEYS */;
/*!40000 ALTER TABLE `funcx` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.live
CREATE TABLE IF NOT EXISTS `live` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sprint` varchar(20) NOT NULL,
  `test` text NOT NULL,
  `live` text NOT NULL,
  `update_db` enum('yes','no') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.live: ~0 rows (approximately)
/*!40000 ALTER TABLE `live` DISABLE KEYS */;
/*!40000 ALTER TABLE `live` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.pay
CREATE TABLE IF NOT EXISTS `pay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `recurring` enum('yes','no') NOT NULL,
  `first_pay` varchar(50) NOT NULL,
  `sub_pay` varchar(50) NOT NULL,
  `coupon` enum('yes','no') NOT NULL,
  `address` enum('yes','no') NOT NULL,
  `update_url` text NOT NULL,
  `update_changes` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.pay: ~0 rows (approximately)
/*!40000 ALTER TABLE `pay` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.relate
CREATE TABLE IF NOT EXISTS `relate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.relate: ~0 rows (approximately)
/*!40000 ALTER TABLE `relate` DISABLE KEYS */;
/*!40000 ALTER TABLE `relate` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.request
CREATE TABLE IF NOT EXISTS `request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `function_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `domain_id` int(11) NOT NULL,
  `attachment_id` int(11) NOT NULL,
  `relate_id` int(11) NOT NULL,
  `email_id` int(11) NOT NULL,
  `cron_id` int(11) NOT NULL,
  `dbase_id` int(11) NOT NULL,
  `live_id` int(11) NOT NULL,
  `api_id` int(11) NOT NULL,
  `pay_id` int(11) NOT NULL,
  `desc_id` int(11) NOT NULL,
  `datetime` datetime NOT NULL,
  `status` enum('not seen','seen','ongoing','done','cancelled') NOT NULL,
  `done` datetime NOT NULL,
  `ongoing` datetime NOT NULL,
  `cancelled` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.request: ~0 rows (approximately)
/*!40000 ALTER TABLE `request` DISABLE KEYS */;
/*!40000 ALTER TABLE `request` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.user
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `type` enum('admin','user') NOT NULL,
  `status` enum('online','offline','idle') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.user: ~0 rows (approximately)
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `name`, `email`, `username`, `password`, `type`, `status`) VALUES
	(1, 'Cristobal, Ronell Tecson', 'rtcristobal@sjcgroup.ph', 'rtcristobal@sjcgroup.ph', 'S@vv1234', 'admin', 'online');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;

-- Dumping structure for table int_rqx_for_db001.user_log
CREATE TABLE IF NOT EXISTS `user_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `activity` text NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table int_rqx_for_db001.user_log: ~0 rows (approximately)
/*!40000 ALTER TABLE `user_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_log` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
