-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `humati_training`
--

-- --------------------------------------------------------

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `cron_list`
--

CREATE TABLE `cron_list` (
  `id` int(11) NOT NULL,
  `module` varchar(255) NOT NULL,
  `cron_name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `interval` varchar(100) NOT NULL COMMENT 'Cron execute interval time',
  `status` tinyint(1) NOT NULL COMMENT '1- Active, 0-Inactive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `jwt_token_master`
--

CREATE TABLE `jwt_token_master` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(11) NOT NULL,
  `expire_time` int(11) NOT NULL,
  `user_data` text NOT NULL,
  `user_url` varchar(255) NOT NULL,
  `refresh_token` text NOT NULL,
  `sso_refresh_token` text,
  `user_information` text NOT NULL,
  `token_counter` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `login_master`
--

CREATE TABLE `login_master` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_login_id` int(10) UNSIGNED NOT NULL COMMENT 'From login_master (Parent DB)',
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `db_name` varchar(255) NOT NULL,
  `profile_pic` varchar(250) NOT NULL,
  `token_id` varchar(100) NOT NULL,
  `created_date` datetime NOT NULL,
  `created_by` int(10) UNSIGNED NOT NULL COMMENT 'From login_master',
  `modified_date` datetime NOT NULL,
  `modified_by` int(10) UNSIGNED NOT NULL COMMENT 'From login_master',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0.Deactive, 1.Active(Default), 2. Archive'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `cron_list`
--
ALTER TABLE `cron_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jwt_token_master`
--
ALTER TABLE `jwt_token_master`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_master`
--
ALTER TABLE `login_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `parent_login_id` (`parent_login_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cron_list`
--
ALTER TABLE `cron_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jwt_token_master`
--
ALTER TABLE `jwt_token_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `login_master`
--
ALTER TABLE `login_master`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

