-- phpMyAdmin SQL Dump
-- version 4.8.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 12, 2022 at 04:09 PM
-- Server version: 10.1.32-MariaDB
-- PHP Version: 7.2.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `cias2`
--

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

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

CREATE TABLE `ci_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_access_matrix`
--

CREATE TABLE `tbl_access_matrix` (
  `id` int(11) NOT NULL,
  `access` text,
  `roleId` int(11) NOT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT '0',
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_access_matrix`
--

INSERT INTO `tbl_access_matrix` (`id`, `access`, `roleId`, `isDeleted`, `createdBy`, `createdDtm`, `updatedBy`, `updatedDtm`) VALUES
(1, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 12, 0, 1, '2022-05-25 06:06:43', NULL, NULL),
(2, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 13, 0, 1, '2022-05-25 07:57:09', NULL, NULL),
(3, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 14, 0, 1, '2022-05-25 08:00:30', NULL, NULL),
(4, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 15, 0, 1, '2022-05-25 08:11:39', NULL, NULL),
(5, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 16, 0, 1, '2022-05-25 08:48:55', NULL, NULL),
(6, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 17, 0, 1, '2022-05-25 08:49:04', NULL, NULL),
(7, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 18, 0, 1, '2022-05-25 08:49:12', NULL, NULL),
(8, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 19, 0, 1, '2022-05-25 08:49:27', NULL, NULL),
(9, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 20, 0, 1, '2022-05-25 08:49:36', NULL, NULL),
(10, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 21, 0, 1, '2022-05-25 08:51:05', NULL, NULL),
(11, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 22, 0, 1, '2022-05-25 08:51:24', NULL, NULL),
(12, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 23, 0, 1, '2022-05-25 09:21:28', NULL, NULL),
(13, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 24, 0, 1, '2022-05-26 11:59:48', NULL, NULL),
(14, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 25, 0, 1, '2022-05-31 03:39:32', NULL, NULL),
(15, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 26, 0, 1, '2022-05-31 03:39:42', NULL, NULL),
(16, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 27, 0, 1, '2022-05-31 03:39:52', NULL, NULL),
(17, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 28, 0, 1, '2022-05-31 03:40:02', NULL, NULL),
(18, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 29, 0, 1, '2022-05-31 03:40:08', NULL, NULL),
(19, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 30, 0, 1, '2022-05-31 03:40:16', NULL, NULL),
(20, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 31, 0, 1, '2022-05-31 03:40:23', NULL, NULL),
(21, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 32, 0, 1, '2022-05-31 03:41:14', NULL, NULL),
(22, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 33, 0, 1, '2022-05-31 03:42:18', NULL, NULL),
(23, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 34, 0, 1, '2022-05-31 03:42:28', NULL, NULL),
(24, '[{\"module\":\"Task\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Bookings\",\"total_access\":0,\"list\":0,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]', 35, 0, 1, '2022-05-31 03:43:49', NULL, NULL);

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

--
-- Table structure for table `tbl_last_login`
--

CREATE TABLE `tbl_last_login` (
  `id` bigint(20) NOT NULL,
  `userId` bigint(20) NOT NULL,
  `sessionData` varchar(2048) NOT NULL,
  `machineIp` varchar(1024) NOT NULL,
  `userAgent` varchar(128) NOT NULL,
  `agentString` varchar(1024) NOT NULL,
  `platform` varchar(128) NOT NULL,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_last_login`
--

INSERT INTO `tbl_last_login` (`id`, `userId`, `sessionData`, `machineIp`, `userAgent`, `agentString`, `platform`, `createdDtm`) VALUES
(1, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 17:49:08'),
(2, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 17:51:33'),
(3, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 17:52:58'),
(4, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:05:00'),
(5, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:07:38'),
(6, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:10:18'),
(7, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:13:28'),
(8, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:15:48'),
(9, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:17:35'),
(10, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:17:57'),
(11, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:18:54'),
(12, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-24 18:23:25'),
(13, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 08:53:25'),
(14, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 12:21:19'),
(15, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 21:27:41'),
(16, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 22:51:36'),
(17, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 22:52:01'),
(18, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 22:52:44'),
(19, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 22:53:17'),
(20, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-25 23:00:20'),
(21, 1, '{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 00:36:46'),
(22, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 00:59:34'),
(23, 1, '{\"role\":\"1\",\"roleText\":\"Admin\",\"name\":\"Admin\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 01:01:06'),
(24, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 01:01:42'),
(25, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 07:46:43'),
(26, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":null,\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:31:56'),
(27, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:34:54'),
(28, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:36:59'),
(29, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name2\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:39:01'),
(30, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name2\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:39:23'),
(31, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:41:52'),
(32, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name2\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:42:18'),
(33, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:51:24'),
(34, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"avatar3.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:52:31'),
(35, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"avatar3.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 09:52:46'),
(36, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"test1.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 10:40:15'),
(37, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1281.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 10:44:48'),
(38, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1282.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 10:46:44'),
(39, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 10:55:08'),
(40, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 10:59:30'),
(41, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 13:47:31'),
(42, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"avatar.png\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 14:10:56'),
(43, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user3-128x1284.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 14:12:07'),
(44, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user3-128x1284.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 16:04:20'),
(45, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-26 16:49:57'),
(46, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:03:20'),
(47, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:12:23'),
(48, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:28:14'),
(49, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:31:00'),
(50, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:31:47'),
(51, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:45:37'),
(52, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user8-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:52:54'),
(53, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user7-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-27 00:55:35'),
(54, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user7-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-29 12:26:06'),
(55, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user7-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-29 12:26:18'),
(56, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user3-128x12811.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-29 12:27:01'),
(57, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user3-128x12811.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-29 12:44:52'),
(58, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user3-128x12811.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-29 12:48:34'),
(59, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-29 12:49:21'),
(60, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 101.0.4951.67', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', 'Windows 8.1', '2022-05-31 05:49:31'),
(61, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.5005.62', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.62 Safari/537.36', 'Windows 8.1', '2022-05-31 21:03:51'),
(62, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-02 22:05:34'),
(63, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-02 22:08:26'),
(64, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"image\":\"avatar.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-02 22:10:21'),
(65, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-02 22:28:05'),
(66, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-10 04:55:14'),
(67, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-10 06:35:17'),
(68, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-10 17:11:12'),
(69, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-10 17:18:47'),
(70, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-10 23:33:27'),
(71, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-11 00:36:10'),
(72, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-11 08:16:00'),
(73, 2, '{\"role\":\"2\",\"roleText\":\"Manager\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-11 12:04:54'),
(74, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-11 12:05:25'),
(75, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"image\":\"avatar.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-11 13:41:38'),
(76, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-11 15:00:51'),
(77, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 05:52:08'),
(78, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 07:14:32'),
(79, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 07:28:02'),
(80, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 08:50:04'),
(81, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 08:52:39'),
(82, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Employee\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 09:10:22'),
(83, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Customer\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 09:25:53'),
(84, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 09:26:09'),
(85, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Customer\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 12:04:45'),
(86, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 12:15:22'),
(87, 2, '{\"role\":\"2\",\"roleText\":\"Agent\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 12:54:01'),
(88, 2, '{\"role\":\"2\",\"roleText\":\"Agent\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:00:51'),
(89, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:02:10'),
(90, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:05:28'),
(91, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:06:05'),
(92, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:06:58'),
(93, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:07:57'),
(94, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:13:38'),
(95, 2, '{\"role\":\"2\",\"roleText\":\"Agent\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:14:20'),
(96, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:18:31'),
(97, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Customer\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:19:09'),
(98, 2, '{\"role\":\"2\",\"roleText\":\"Agent\",\"name\":\"Manager\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:20:10'),
(99, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:21:13'),
(100, 3, '{\"role\":\"3\",\"roleText\":\"Employee\",\"name\":\"Customer\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 13:22:56'),
(101, 3, '{\"role\":\"3\",\"roleText\":\"Client\",\"name\":\"Customer\",\"image\":\"avatar311.png\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 15:40:31'),
(102, 2, '{\"role\":\"2\",\"roleText\":\"Agent\",\"name\":\"Agent1\",\"image\":\"user3-128x1283.jpg\",\"isAdmin\":\"0\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 15:42:33'),
(103, 1, '{\"role\":\"1\",\"roleText\":\"WebAstrals Admin\",\"name\":\"Admin\",\"image\":\"user1-128x1281.jpg\",\"isAdmin\":\"1\"}', '::1', 'Chrome 102.0.0.0', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'Windows 8.1', '2022-06-12 15:47:10');

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

--
-- Table structure for table `tbl_reset_password`
--

CREATE TABLE `tbl_reset_password` (
  `id` bigint(20) NOT NULL,
  `email` varchar(128) NOT NULL,
  `activation_id` varchar(32) NOT NULL,
  `agent` varchar(512) NOT NULL,
  `client_ip` varchar(32) NOT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT '0',
  `createdBy` bigint(20) NOT NULL DEFAULT '1',
  `createdDtm` datetime NOT NULL,
  `updatedBy` bigint(20) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `roleId` tinyint(4) NOT NULL COMMENT 'role id',
  `role` varchar(50) NOT NULL COMMENT 'role text',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `isDeleted` tinyint(4) NOT NULL DEFAULT '0',
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_roles`
--

INSERT INTO `tbl_roles` (`roleId`, `role`, `status`, `isDeleted`, `createdBy`, `createdDtm`, `updatedBy`, `updatedDtm`) VALUES
(1, 'WebAstrals Admin', 1, 0, 0, '2021-01-21 00:00:00', 1, '2022-05-25 22:01:33'),
(2, 'Agent', 1, 0, 0, '2021-01-13 00:00:00', 1, '2022-05-25 22:01:33'),
(3, 'Client', 1, 0, 0, '2021-01-13 00:00:00', 1, '2022-06-12 10:53:47');

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `userId` int(11) NOT NULL,
  `email` varchar(128) NOT NULL COMMENT 'login email',
  `password` varchar(128) NOT NULL COMMENT 'hashed login password',
  `name` varchar(128) DEFAULT NULL COMMENT 'full name of user',
  `mobile` varchar(20) DEFAULT NULL,
  `roleId` tinyint(4) NOT NULL,
  `isPaid` int(11) NOT NULL DEFAULT '0',
  `isAdmin` tinyint(4) NOT NULL DEFAULT '2',
  `isDeleted` tinyint(4) NOT NULL DEFAULT '0',
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  `image` varchar(30) NOT NULL DEFAULT 'avatar.png'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`userId`, `email`, `password`, `name`, `mobile`, `roleId`, `isPaid`, `isAdmin`, `isDeleted`, `createdBy`, `createdDtm`, `updatedBy`, `updatedDtm`, `image`) VALUES
(1, 'lee12day@gmail.com', '$2y$10$xP74GNO30EbdUMRh9qpbJepWZIZTb1hwDWdjCo7BBipjTfWj1EFK.', 'Admin', '3031234568', 1, 0, 1, 0, 0, '2015-07-01 18:56:49', 1, '2022-05-29 09:49:15', 'user1-128x1281.jpg'),
(2, 'manager@example.com', '$2y$10$cDlgJCskKDvKC4jwTzgevuYOHsvm3kOkkCycczRx/NyTL1sjdAwry', 'Agent1', '1234567894', 2, 0, 0, 0, 1, '2016-12-09 17:49:56', 2, '2022-05-26 07:55:21', 'user3-128x1283.jpg'),
(3, 'customer@example.com', '$2y$10$xP74GNO30EbdUMRh9qpbJepWZIZTb1hwDWdjCo7BBipjTfWj1EFK.', 'Customer', '1122334563', 3, 0, 0, 0, 1, '2016-12-09 17:50:22', 3, '2022-06-11 10:52:25', 'avatar311.png'),
(16, 'manager2@example.com', '$2y$10$cDlgJCskKDvKC4jwTzgevuYOHsvm3kOkkCycczRx/NyTL1sjdAwry', 'Agent2', '1234567894', 2, 0, 0, 0, 1, '2016-12-09 17:49:56', 2, '2022-05-26 07:55:21', 'user3-128x1283.jpg'),
(15, 'customer3@example.com', '$2y$10$xP74GNO30EbdUMRh9qpbJepWZIZTb1hwDWdjCo7BBipjTfWj1EFK.', 'Customer3', '1122334563', 3, 0, 0, 0, 1, '2016-12-09 17:50:22', 3, '2022-06-11 10:52:25', 'avatar311.png'),
(14, 'customer2@example.com', '$2y$10$xP74GNO30EbdUMRh9qpbJepWZIZTb1hwDWdjCo7BBipjTfWj1EFK.', 'Customer2', '1122334563', 3, 1, 0, 0, 1, '2016-12-09 17:50:22', 3, '2022-06-11 10:52:25', 'avatar311.png');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `ticket_code` varchar(20) COLLATE utf8_turkish_ci NOT NULL,
  `assigned_to` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `ticket_date` date NOT NULL,
  `categorie_id` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
  `priority` varchar(10) COLLATE utf8_turkish_ci NOT NULL DEFAULT 'Normal',
  `ticket_exp` text COLLATE utf8_turkish_ci NOT NULL,
  `ticket_title` text COLLATE utf8_turkish_ci NOT NULL,
  `ticket_status` int(11) NOT NULL,
  `attachments` varchar(40) COLLATE utf8_turkish_ci NOT NULL,
  `isDeleted` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`id`, `ticket_code`, `assigned_to`, `user_id`, `ticket_date`, `categorie_id`, `priority`, `ticket_exp`, `ticket_title`, `ticket_status`, `attachments`, `isDeleted`) VALUES
(1, '060818-01', 1, 2, '2018-08-06', 'Web', 'Normal', 'Sed molestie purus Sed molestie purus\r\n\r\n Sed molestie purus\r\n\r\n Sed molestie purus\r\n\r\nSed molestie purus\r\n\r\nSed molestie purus\r\n\r\nSed molestie purus\r\n\r\nSed molestie purus\r\n\r\n\r\n\r\n', 'Lorem ipsum dolor sit amet ', 0, '', 0),
(8, '180522-08', 16, 3, '2022-05-18', 'SEO', 'High', 'jhasdhsamna', 'my ticket', 1, 'null', 0),
(16, 'tkt_62a475ac810d13.0', 2, 3, '2022-06-11', 'SEO', 'Low', '<p>yes</p>\r\n', 'title', 2, 'null', 1),
(17, 'tkt_62a47712d2a8b8.5', 16, 3, '2022-06-11', 'SEO', 'Low', '<p>yes</p>\r\n', 'title', 1, 'demo.js', 0),
(18, 'tkt_62a5399fd12037.3', 16, 3, '2022-06-12', 'Web Development', 'High', '<p><strong>Do this</strong></p>\r\n\r\n<p>then next</p>\r\n', 'create page', 1, 'adminlte.js', 0),
(19, 'tkt_62a5a29b87ded4.0', 2, 3, '2022-06-12', 'Web Development', 'Low', '<p>ok hope so</p>\r\n', 'create new page', 0, 'null', 0),
(20, 'tkt_62a5a2ace1aeb2.8', 16, 3, '2022-06-12', 'Other', 'High', '<p>ok hope so</p>\r\n', 'create new page2', 1, 'null', 0);

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

--
-- Table structure for table `tickets_reply`
--

CREATE TABLE `tickets_reply` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `reply_exp` text COLLATE utf8_turkish_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `reply_date` datetime NOT NULL,
  `attachments` varchar(20) COLLATE utf8_turkish_ci NOT NULL,
  `isDeleted` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `tickets_reply`
--

INSERT INTO `tickets_reply` (`id`, `ticket_id`, `reply_exp`, `user_id`, `reply_date`, `attachments`, `isDeleted`) VALUES
(1, 1, 'Suspendisse potenti. Fusce lobortis vehicula ante, non luctus nisl vestibulum quis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse in odio sed orci elementum malesuada id ac risus.\r\n', 1, '2022-06-02 19:10:56', '1-1.png', 1),
(2, 1, 'Mauris pellentesque fringilla tellus, a ultrices elit congue a. Quisque condimentum justo at magna rutrum, eget auctor tellus placerat.\r\n', 2, '2022-06-02 19:11:56', '', 0),
(3, 1, 'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla quis velit tempus, pretium metus in, fermentum ligula.', 2, '2022-06-02 19:12:56', '', 0),
(4, 1, 'Mauris molestie aliquet eros eu semper. Suspendisse finibus felis neque, a blandit dui ullamcorper sit amet. Maecenas convallis semper vulputate.\r\n', 1, '2022-06-02 19:13:56', '', 0),
(5, 1, 'Quisque ex leo, commodo ac mauris eu, congue egestas ex. Pellentesque congue, risus a euismod efficitur, lectus mauris placerat risus, et hendrerit erat neque id augue.\r\n', 2, '2022-06-02 19:14:56', '', 0),
(6, 8, 'done', 1, '2022-06-02 19:15:56', 'null', 1),
(7, 8, 'yes', 1, '2022-06-02 19:16:56', 'null', 1),
(8, 8, 'ok', 1, '2022-06-02 19:17:56', 'null', 1),
(123, 1, 'yes', 2, '2022-06-11 05:44:51', '', 0),
(145, 1, 'done', 1, '2022-06-11 09:33:33', '', 0),
(146, 1, 'ok', 2, '2022-06-11 09:33:44', '', 0),
(147, 1, 'ok', 1, '2022-06-11 09:39:20', '', 1),
(148, 1, 'lll', 1, '2022-06-11 10:20:27', '', 1),
(149, 1, 'jj', 1, '2022-06-11 10:29:59', '', 1),
(150, 1, 'ok', 1, '2022-06-11 10:33:00', '', 1),
(151, 1, 'done', 1, '2022-06-11 10:33:36', '', 1),
(152, 1, 'gg', 1, '2022-06-11 10:34:12', '', 1),
(153, 1, 'ok', 1, '2022-06-11 10:34:29', '', 1),
(154, 1, 'ok', 1, '2022-06-11 10:37:20', '', 0),
(155, 1, 'yes', 2, '2022-06-11 10:37:41', '', 1),
(156, 1, 'sorry', 2, '2022-06-11 10:38:47', '', 1),
(157, 1, 'ok', 1, '2022-06-11 10:39:51', '', 1),
(158, 1, 'bb', 1, '2022-06-11 10:40:08', '', 1),
(159, 1, 'hi', 3, '2022-06-11 10:42:03', '', 0),
(160, 8, 'jkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk sadjfffffwe weqjklllllllllllllllllllllllllllr qwdihyqwe', 3, '2022-06-11 10:46:01', '', 0),
(161, 8, 'ye', 1, '2022-06-11 10:56:33', '', 0),
(162, 8, 'h', 3, '2022-06-11 10:58:29', '', 0),
(163, 8, 'g', 1, '2022-06-11 10:58:39', '', 1),
(164, 8, 'ok', 1, '2022-06-11 11:06:06', '', 1),
(165, 8, 'ok', 1, '2022-06-11 11:06:14', '', 1),
(166, 8, 'ok', 1, '2022-06-11 11:06:50', '', 1),
(167, 8, 'ok', 1, '2022-06-11 11:07:01', '', 0),
(168, 8, 'mo', 1, '2022-06-11 11:07:06', '', 1),
(169, 8, '???', 3, '2022-06-11 11:07:29', '', 0),
(170, 8, 'hn', 3, '2022-06-11 11:07:33', '', 0),
(171, 8, 'jm', 3, '2022-06-11 11:07:44', '', 0),
(172, 8, 'ok', 3, '2022-06-11 12:00:06', '', 0),
(175, 8, 'jkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkl', 1, '2022-06-11 01:48:08', '', 1),
(176, 8, 'jkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk sadjfffffwe weqjklllllllllllllllllllllllllllr qwdihyqwe', 1, '2022-06-11 01:49:50', '', 1),
(177, 8, 'jkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk sadjfffffwe weqjklllllllllllllllllllllllllllr qwdihyqwe jksaaaaaaaaaa wqekkkkkkkkkkj wqqqqqqqqqqqqqqqqqqq', 1, '2022-06-11 01:50:00', '', 1),
(182, 8, 'jkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk sadjfffffwe weqjklllllllllllllllllllllllllllr qwdihyqwe jhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhjhed wqhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhkhk wwwwwwwwwwwwwwwwwwwwwwwwwws', 1, '2022-06-11 01:52:54', '', 1),
(184, 8, 'hi', 1, '2022-06-11 02:06:27', '', 0),
(185, 8, 'ok', 1, '2022-06-11 02:09:23', '', 1),
(186, 8, 'ok', 1, '2022-06-11 02:09:25', '', 1),
(187, 8, 'ok', 1, '2022-06-11 02:09:26', '', 1),
(188, 8, 'ok', 1, '2022-06-11 02:10:13', '', 1),
(189, 18, 'hi', 3, '2022-06-12 12:43:29', '', 0),
(190, 18, 'yes?', 2, '2022-06-12 12:43:38', '', 1),
(191, 18, 'test', 2, '2022-06-12 12:45:10', '', 1),
(192, 18, 'hi', 1, '2022-06-12 12:49:52', '', 0),
(193, 19, 'hgashdgasdghsaj', 1, '2022-06-12 02:06:32', '', 1),
(194, 19, ' sjhgsahj\naHDGHASJD\n', 1, '2022-06-12 02:09:08', '', 0),
(195, 19, 'JKDSJKD\nHSADGHJAS\nGSAHGAS\n', 1, '2022-06-12 02:09:33', '', 0),
(196, 8, ' ', 1, '2022-06-12 02:17:35', '', 1),
(197, 8, '<h1>&nbsp;Rosetta</h1>\n\n<figure class=\"image image-narrow\" data-widget=\"image\"><a href=\"http://en.wikipedia.org/wiki/File:Comet_67P_on_19_September_2014_NavCam_mosaic.jpg\"><img alt=\"Comet 67P\" src=\"assets/comet-67p.jpg\" style=\"height:900px; width:1131px\" /></a>\n\n<figcaption contenteditable=\"true\">Comet 67P in September 2014</figcaption>\n</figure>\n\n<p>Rosetta is a robotic space probe built and launched by the <a href=\"http://en.wikipedia.org/wiki/European_Space_Agency\">European Space Agency</a>. Along with <a href=\"http://en.wikipedia.org/wiki/Philae_(spacecraft)\">Philae</a>, its lander module, Rosetta is performing a detailed study of <a href=\"http://en.wikipedia.org/wiki/67P/Churyumov%E2%80%93Gerasimenko\">comet 67P/Churyumov&ndash;Gerasimenko (67P)</a>. On 12 November 2014 the mission performed the first soft landing on a comet and returned data from the surface.</p>\n\n<h2>Mission overview</h2>\n\n<p>Rosetta was launched on 2 March 2004 on an <a href=\"http://en.wikipedia.org/wiki/Ariane_5\">Ariane 5</a> rocket and reached the comet on 6 August 2014, becoming the first spacecraft to orbit a comet. (Previous missions had conducted successful flybys of seven other comets.) It is one of ESA&#39;s Horizon 2000 cornerstone missions. The spacecraft consists of the Rosetta orbiter, which features 12 instruments, and the Philae lander, with nine additional instruments. The Rosetta mission will orbit 67P for 17 months and is designed to complete the most detailed study of a comet ever attempted. The spacecraft is controlled from the <a href=\"http://en.wikipedia.org/wiki/European_Space_Operations_Centre\">European Space Operations Centre</a> (ESOC), in Darmstadt, Germany. The planning for the operation of the scientific payload, together with the data retrieval, calibration, archiving and distribution, is performed from the <a href=\"http://en.wikipedia.org/wiki/European_Space_Astronomy_Centre\">European Space Astronomy Centre</a> (ESAC), in Villanueva de la Ca&ntilde;ada, near Madrid, Spain. It has been estimated that in the decade preceding 2014, some 2,000 people assisted in the mission in some capacity.</p>\n\n<p>The probe is named after the <a href=\"http://en.wikipedia.org/wiki/Rosetta_Stone\">Rosetta Stone</a>, a stele of Egyptian origin featuring a decree in three scripts. The lander is named after the Philae obelisk, which bears a bilingual Greek and Egyptian hieroglyphic inscription. A comparison of its hieroglyphs with those on the Rosetta Stone catalysed the deciphering of the Egyptian writing system. Similarly, it is hoped that these spacecraft will result in better understanding of comets and the early Solar System. In a more direct analogy to its namesake, the Rosetta spacecraft also carries a micro-etched nickel alloy Rosetta disc donated by the Long Now Foundation inscribed with 13,000 pages of text in 1200 languages.</p>\n\n<hr />\n<p>Source: <a href=\"http://en.wikipedia.org/wiki/Rosetta_(spacecraft)\">Wikipedia.org</a></p>\n', 1, '2022-06-12 02:23:53', '', 1),
(198, 8, '​\nRosetta\n\nComet 67P in September 2014\n\nRosetta is a robotic space probe built and launched by the European Space Agency. Along with Philae, its lander module, Rosetta is performing a detailed study of comet 67P/Churyumov–Gerasimenko (67P). On 12 November 2014 the mission performed the first soft landing on a comet and returned data from the surface.\n\nMission overview\nRosetta was launched on 2 March 2004 on an Ariane 5 rocket and reached the comet on 6 August 2014, becoming the first spacecraft to orbit a comet. (Previous missions had conducted successful flybys of seven other comets.) It is one of ESA\'s Horizon 2000 cornerstone missions. The spacecraft consists of the Rosetta orbiter, which features 12 instruments, and the Philae lander, with nine additional instruments. The Rosetta mission will orbit 67P for 17 months and is designed to complete the most detailed study of a comet ever attempted. The spacecraft is controlled from the European Space Operations Centre (ESOC), in Darmstadt, Germany. The planning for the operation of the scientific payload, together with the data retrieval, calibration, archiving and distribution, is performed from the European Space Astronomy Centre (ESAC), in Villanueva de la Cañada, near Madrid, Spain. It has been estimated that in the decade preceding 2014, some 2,000 people assisted in the mission in some capacity.\n\nThe probe is named after the Rosetta Stone, a stele of Egyptian origin featuring a decree in three scripts. The lander is named after the Philae obelisk, which bears a bilingual Greek and Egyptian hieroglyphic inscription. A comparison of its hieroglyphs with those on the Rosetta Stone catalysed the deciphering of the Egyptian writing system. Similarly, it is hoped that these spacecraft will result in better understanding of comets and the early Solar System. In a more direct analogy to its namesake, the Rosetta spacecraft also carries a micro-etched nickel alloy Rosetta disc donated by the Long Now Foundation inscribed with 13,000 pages of text in 1200 languages.\n\nSource: Wikipedia.org\n\n​', 1, '2022-06-12 02:25:03', '', 1),
(199, 8, ' hi\nok', 1, '2022-06-12 02:26:29', '', 0),
(200, 8, ' ok', 1, '2022-06-12 02:37:42', '', 0),
(201, 8, 'hi', 1, '2022-06-12 03:18:36', '', 0);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `user_name` varchar(30) COLLATE utf8_turkish_ci NOT NULL,
  `user_username` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
  `user_pass` varchar(255) COLLATE utf8_turkish_ci NOT NULL,
  `user_email` varchar(50) COLLATE utf8_turkish_ci NOT NULL,
  `hash` varchar(32) COLLATE utf8_turkish_ci NOT NULL,
  `user_auth` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `user_name`, `user_username`, `user_pass`, `user_email`, `hash`, `user_auth`) VALUES
(1, 'Melih Güleç', 'admin', '827ccb0eea8a706c4c34a16891f84e7b', 'melih.gulec14@gmail.com', 'E6xTDQ57ACs49LwPFqfGZyaKBXlRrNd0', 1),
(2, 'User Name', 'user', '202cb962ac59075b964b07152d234b70', 'melih.gulec15@gmail.com', 'uTGzgQUMhyldt1AripRnEexcPwO4fJs3', 2),
(3, 'Test User', 'user2', '202cb962ac59075b964b07152d234b70', 'abc@gmail.com', 'boRfeO4l1CuQsnFV5ZzWP9Y6hSd3wEv7', 2),
(4, 'shahbaz', 'shahbaz', '827ccb0eea8a706c4c34a16891f84e7b', 'shahbaz@gmail.com', 'E6xTDQ57ACs49LwPFqfGZyaKBXlRrNd0', 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`session_id`),
  ADD KEY `last_activity_idx` (`last_activity`);

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

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

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

--
-- Indexes for table `tbl_roles`
--
ALTER TABLE `tbl_roles`
  ADD PRIMARY KEY (`roleId`);

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`userId`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `tbl_last_login`
--
ALTER TABLE `tbl_last_login`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- AUTO_INCREMENT for table `tbl_reset_password`
--
ALTER TABLE `tbl_reset_password`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_roles`
--
ALTER TABLE `tbl_roles`
  MODIFY `roleId` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'role id', AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
