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

START TRANSACTION;



--
-- Database: `gasd3326_tugas`
--

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

--
-- Table structure for table `assetcategories`
--

CREATE TABLE `assetcategories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `assetcategories`
--

INSERT INTO `assetcategories` (`id`, `name`, `color`) VALUES
(1, 'Desktops', '#1e3fda'),
(2, 'Laptops', '#058e29'),
(3, 'Servers', '#ff0000'),
(4, 'Printers', '#99ac14'),
(5, 'Routers', '#0b7c36');

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

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int(11) NOT NULL,
  `categoryid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `manufacturerid` int(11) NOT NULL,
  `modelid` int(11) NOT NULL,
  `supplierid` int(11) NOT NULL,
  `statusid` int(11) NOT NULL,
  `purchase_date` date NOT NULL,
  `warranty_months` int(11) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `serial` varchar(255) NOT NULL,
  `notes` text NOT NULL,
  `locationid` int(11) NOT NULL,
  `purchase_order` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `condition` varchar(255) NOT NULL,
  `removal_date` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `assets`
--

INSERT INTO `assets` (`id`, `categoryid`, `adminid`, `clientid`, `userid`, `manufacturerid`, `modelid`, `supplierid`, `statusid`, `purchase_date`, `warranty_months`, `tag`, `name`, `serial`, `notes`, `locationid`, `purchase_order`, `value`, `condition`, `removal_date`) VALUES
(1, 1, 0, 1, 0, 2, 4, 1, 3, '2016-02-01', 24, 'IT-1', 'Desktop 1', 'QWERT12345', '', 0, '', '', '', ''),
(2, 3, 0, 2, 0, 2, 3, 1, 3, '2016-02-01', 24, 'IT-2', 'DC Server', 'ASDFG12345', '', 0, '', '', '', ''),
(3, 2, 0, 2, 0, 1, 1, 3, 3, '2016-02-01', 24, 'IT-3', 'Laptop 1', 'BNMHJK98765', '', 0, '', '', '', '');

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `asset_tag_prefix` varchar(255) NOT NULL,
  `license_tag_prefix` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `name`, `asset_tag_prefix`, `license_tag_prefix`) VALUES
(1, 'Gatot Tri Pranoto', 'IT-', 'ITL-'),
(2, 'Lely Dahlia', 'IT-', 'ITL-');

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

--
-- Table structure for table `clients_admins`
--

CREATE TABLE `clients_admins` (
  `id` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `clients_admins`
--

INSERT INTO `clients_admins` (`id`, `adminid`, `clientid`) VALUES
(1, 1, 1);

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `peopleid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `ticketid` int(11) NOT NULL,
  `comment` text NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `name` varchar(128) NOT NULL,
  `value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`name`, `value`) VALUES
('email_from_address', 'ontrack@example.com'),
('email_from_name', 'OnTrack'),
('email_smtp_enable', 'false'),
('email_smtp_host', ''),
('email_smtp_port', ''),
('email_smtp_username', ''),
('email_smtp_password', ''),
('email_smtp_security', ''),
('email_smtp_domain', ''),
('email_smtp_auth', 'false'),
('week_start', '1'),
('log_retention', '365'),
('tickets_encrypton', ''),
('tickets_password', ''),
('tickets_username', ''),
('tickets_server', ''),
('license_tag_prefix', 'ITL-'),
('asset_tag_prefix', 'IT-'),
('company_details', ''),
('company_name', 'LEMBAGA PENJAMINAN MUTU'),
('tickets_notification', 'false'),
('sms_provider', 'clickatell'),
('sms_user', ''),
('sms_password', ''),
('sms_api_id', ''),
('sms_from', ''),
('app_name', '<b>TUGAS</b> HARIAN'),
('app_url', 'localhost/tugas'),
('table_records', '50'),
('db_version', '1.9'),
('project_tag_prefix', 'P-'),
('password_generator_length', '8'),
('default_lang', 'id'),
('auto_close_tickets', '0'),
('timezone', 'Asia/Jakarta'),
('auto_close_tickets_notify', 'false'),
('tickets_defaultdepartment', '0'),
('date_format', 'd/m/Y;dd/mm/yyyy');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `emaillog`
--

CREATE TABLE `emaillog` (
  `id` int(11) NOT NULL,
  `peopleid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `to` varchar(128) NOT NULL,
  `subject` varchar(256) NOT NULL,
  `message` text NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `emaillog`
--

INSERT INTO `emaillog` (`id`, `peopleid`, `clientid`, `to`, `subject`, `message`, `timestamp`) VALUES
(1, 3, 1, 'annisa@trilogi.ac.id', 'New User', 'Could not instantiate mail function.', '2022-12-10 10:26:38'),
(2, 4, 1, 'syafbrani@trilogi.ac.id', 'New User', 'Could not instantiate mail function.', '2022-12-10 10:27:20'),
(3, 6, 1, 'lidya@trilogi.ac.id', 'New User', 'Could not instantiate mail function.', '2022-12-10 10:28:27');

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `assetid` int(11) NOT NULL,
  `ticketreplyid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `hosts`
--

CREATE TABLE `hosts` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `status` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `hosts`
--

INSERT INTO `hosts` (`id`, `clientid`, `name`, `address`, `status`) VALUES
(1, 1, 'Google', 'www.google.com', ''),
(2, 2, 'DC Server', '10.0.0.25', ''),
(3, 2, 'Router', '10.0.0.1', '');

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

--
-- Table structure for table `hosts_checks`
--

CREATE TABLE `hosts_checks` (
  `id` int(11) NOT NULL,
  `hostid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(60) NOT NULL,
  `port` varchar(60) NOT NULL,
  `monitoring` int(1) NOT NULL,
  `email` int(1) NOT NULL,
  `sms` int(1) NOT NULL,
  `status` varchar(60) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `hosts_checks`
--

INSERT INTO `hosts_checks` (`id`, `hostid`, `name`, `type`, `port`, `monitoring`, `email`, `sms`, `status`) VALUES
(1, 1, 'HTTP', 'Service', '80', 1, 1, 1, ''),
(2, 3, 'HTTP admin', 'Service', '80', 1, 1, 0, ''),
(3, 2, 'MySQL Database', 'Service', '3306', 1, 1, 1, '');

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

--
-- Table structure for table `hosts_history`
--

CREATE TABLE `hosts_history` (
  `id` int(11) NOT NULL,
  `checkid` int(11) NOT NULL,
  `status` varchar(20) NOT NULL,
  `latency` varchar(10) NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `hosts_people`
--

CREATE TABLE `hosts_people` (
  `id` int(11) NOT NULL,
  `hostid` int(11) NOT NULL,
  `peopleid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `issues`
--

CREATE TABLE `issues` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `assetid` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `issuetype` varchar(15) NOT NULL,
  `priority` varchar(60) NOT NULL,
  `status` varchar(60) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `duedate` varchar(20) NOT NULL,
  `timespent` int(10) NOT NULL,
  `dateadded` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `issues`
--

INSERT INTO `issues` (`id`, `clientid`, `assetid`, `projectid`, `adminid`, `issuetype`, `priority`, `status`, `name`, `description`, `duedate`, `timespent`, `dateadded`) VALUES
(1, 2, 2, 0, 0, 'Task', 'High', 'To Do', 'Configure Active Directory', '', '', 180, '2016-02-03 00:00:00'),
(2, 2, 2, 0, 0, 'Task', 'Low', 'In Progress', 'Reconfigure DNS server', '', '2016-03-27', 25, '2016-02-01 00:00:00'),
(3, 1, 1, 0, 0, 'Task', 'Normal', 'Done', 'Install Office Suite', '', '2016-08-03', 45, '2016-02-03 00:00:00'),
(4, 1, 0, 13, 2, 'Task', 'Low', 'Done', 'Terselesaikan', 'Sudah diselesaikan dengan link spmi.online/tugas', '2022-12-15', 240, '2022-12-10 13:06:43');

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

--
-- Table structure for table `kb_articles`
--

CREATE TABLE `kb_articles` (
  `id` int(11) NOT NULL,
  `categoryid` int(11) NOT NULL,
  `clients` text NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `kb_articles`
--

INSERT INTO `kb_articles` (`id`, `categoryid`, `clients`, `name`, `content`) VALUES
(1, 1, 'a:1:{i:0;s:1:\"0\";}', 'Test Article', '<p>Article body.<br></p>');

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

--
-- Table structure for table `kb_categories`
--

CREATE TABLE `kb_categories` (
  `id` int(11) NOT NULL,
  `clients` text NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `kb_categories`
--

INSERT INTO `kb_categories` (`id`, `clients`, `name`) VALUES
(1, 'a:1:{i:0;s:1:\"0\";}', 'Test Category');

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

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `labels`
--

INSERT INTO `labels` (`id`, `name`, `color`) VALUES
(1, 'Requested', '#1ecbbd'),
(2, 'Pending', '#1ccd2b'),
(3, 'Deployed', '#3479da'),
(4, 'Archived', '#959d1c'),
(5, 'In Repair', '#da2727'),
(6, 'Broken', '#776e6e');

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL,
  `code` varchar(4) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `code`, `name`) VALUES
(1, 'id', 'Indonesia');

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

--
-- Table structure for table `licensecategories`
--

CREATE TABLE `licensecategories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `licensecategories`
--

INSERT INTO `licensecategories` (`id`, `name`, `color`) VALUES
(1, 'Operating Systems', '#355ea7'),
(2, 'Office Suite', '#e4d811'),
(3, 'Graphics Editor', '#c62121'),
(4, 'Other', '#370b0b');

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

--
-- Table structure for table `licenses`
--

CREATE TABLE `licenses` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `statusid` int(11) NOT NULL,
  `categoryid` int(11) NOT NULL,
  `supplierid` int(11) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `serial` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `licenses`
--

INSERT INTO `licenses` (`id`, `clientid`, `statusid`, `categoryid`, `supplierid`, `tag`, `name`, `serial`, `notes`) VALUES
(1, 1, 3, 1, 1, 'ITL-1', 'Windows 10 Pro', '', ''),
(2, 1, 3, 1, 2, 'ITL-2', 'Office Home & Business 2016', '', ''),
(3, 2, 3, 1, 3, 'ITL-3', 'Windows Server 2012 R2 Essentials', '', ''),
(4, 2, 3, 3, 1, 'ITL-4', 'Corel Draw x5', '', '');

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

--
-- Table structure for table `licenses_assets`
--

CREATE TABLE `licenses_assets` (
  `id` int(11) NOT NULL,
  `licenseid` int(11) NOT NULL,
  `assetid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `licenses_assets`
--

INSERT INTO `licenses_assets` (`id`, `licenseid`, `assetid`) VALUES
(1, 3, 1),
(2, 2, 1),
(3, 1, 2);

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `manufacturers`
--

CREATE TABLE `manufacturers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `manufacturers`
--

INSERT INTO `manufacturers` (`id`, `name`) VALUES
(1, 'Apple'),
(2, 'Dell'),
(3, 'Microsoft'),
(4, 'HP'),
(5, 'Samsung'),
(6, 'ASUS'),
(7, 'Canon'),
(8, 'Cisco'),
(9, 'Lenovo'),
(10, 'Acer'),
(11, 'Epson');

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

--
-- Table structure for table `models`
--

CREATE TABLE `models` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `models`
--

INSERT INTO `models` (`id`, `name`) VALUES
(1, 'MacBook Pro'),
(2, 'MacBook Air'),
(3, 'PowerEdge R220'),
(4, 'Optiplex 3020 MT');

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

--
-- Table structure for table `notificationtemplates`
--

CREATE TABLE `notificationtemplates` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `info` text NOT NULL,
  `sms` varchar(254) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `notificationtemplates`
--

INSERT INTO `notificationtemplates` (`id`, `name`, `subject`, `message`, `info`, `sms`) VALUES
(1, 'New Ticket', 'Ticket #{ticketid} created', '<p>Hello {contact},<br><br>A new ticket has been created for your request.<br>Ticket ID:<b> #{ticketid}</b><br><br>{message}<br><br>You can reply to this email to add additional information.<br>Please do not remove the ticket number from the subject line.<br><br>Best regards,<br>{company}</p>', '{ticketid}, {status}, {subject}, {contact}, {message}, {company}, {appurl}, {client}, {department}', ''),
(2, 'New Ticket Reply', '#{ticketid} New Reply', '<p>Hello {contact},<br><br>A new reply has been added to your ticket.<br><br>Ticket ID: #{ticketid}<br><br>{message}<br><br>You can reply to this email to add additional information.<br>Please do not remove the ticket number from the subject line.<br><br>Best regards,<br>{company}<br></p>', '{ticketid}, {status}, {subject}, {contact}, {message}, {company}, {appurl}, {client}, {department}', ''),
(3, 'New User', 'New User', '<p>Hello {contact},<br><br>Your account has been successfully created.</p><p><br>Email Address: {email}<br>Password: {password}<br>{appurl}<br><br>Best regards,<br>{company}<br></p>', '{contact}, {email}, {password}, {company}, {appurl}', ''),
(5, 'Password Reset', 'Password Reset', '<p>Hello {contact},<br><br>Please follow the link below to reset your password.<br>{resetlink}<br><br>Best regards,<br>{company}<br></p>', '{contact}, {resetlink}, {company}, {appurl}', ''),
(6, 'Monitoring Notification', '{hostinfo} is now {status}', '<p>{hostinfo} status has changed to {status}.<br><br>Best regards,<br>{company}<br></p>', '{hostinfo}, {status}, {contact}, {company}', '{hostinfo} is now {status}'),
(7, 'New Ticket (Admin)', 'New Support Ticket #{ticketid}', '<p>A new support ticket has been opened.</p>\r\n<p>Ticket ID:<b> #{ticketid}</b><br>Subject: {subject}</p>\r\n<p><br>{message}</p><br>\r\n<p>Best regards,<br>{company}</p>', '{ticketid}, {status}, {subject}, {contact}, {message}, {company}, {appurl}, {client}, {department}', ''),
(8, 'New Ticket Reply (Admin)', 'New Reply to Ticket #{ticketid}', '<p>A new reply has been added to ticket #{ticketid}.<br>Subject: {subject}<br></p><p><br>{message}<br></p><p><br>Best regards,<br>{company}<br></p><p><br></p><p></p>', '{ticketid}, {status}, {subject}, {contact}, {message}, {company}, {appurl}, {client}, {department}', ''),
(9, 'Ticket Escalation (Admin)', 'Escalation Rule Processed #{ticketid}', '<p>Escalation rule processed for ticket #{ticketid}.<br>Subject: {subject}<br></p><p><br>{message}<br></p><p><br>Best regards,<br>{company}<br></p><p><br></p><p></p>', '{ticketid}, {status}, {subject}, {contact}, {message}, {company}, {appurl}, {client}, {department}', ''),
(10, 'Ticket Auto Close (User)', 'Support Ticket #{ticketid} Auto Closed', '<p>This is a notification to let you know that we are changing the status of your ticket #{ticketid}  to Closed as we have not received a response from you lately.<br></p><p><br>Ticket Subject: {subject}<br></p><p><br>Best regards,<br>{company}<br></p><p><br></p><p></p>', '{ticketid}, {status}, {subject}, {contact}, {message}, {company}, {appurl}, {client}, {department}', '');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `notes` text NOT NULL,
  `description` text NOT NULL,
  `startdate` varchar(20) NOT NULL,
  `deadline` varchar(20) NOT NULL,
  `progress` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `clientid`, `tag`, `name`, `notes`, `description`, `startdate`, `deadline`, `progress`) VALUES
(2, 2, 'Akreditasi', 'Review LED PGSD', '', '<ul><li>Review Kriteria 1</li><li>Review Kriteria 4</li><li>Review Kriteria 5 dan lain-lain.<br></li></ul>', '0', '2022-12-31', 51),
(3, 2, 'Akreditasi', 'Review LED PGPAUD', '', '<ul><li>Review kriteria 1</li><li>Review kriteria 4</li><li>Review kriteria 5 dan lain-lain<br></li></ul><p><br></p>', '0', '2022-12-31', 0),
(4, 2, 'Akreditasi', 'ISK APT', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"186\" style=\"width: 140pt;\"><tbody><tr height=\"20\" style=\"height:15.0pt\">\r\n  <td height=\"20\" class=\"xl65\" width=\"186\" style=\"height:15.0pt;width:140pt\">Surat\r\n  Tim Penyusun ISK</td></tr></tbody></table>', '2022-12-09', '2022-12-15', 1),
(5, 2, 'Akreditasi', 'PEPA DP', '', '<p>Rutin&nbsp;Pemantaun SAPTO BAN PT</p><p>1 hari 3x di cek di SAPTO</p>', '2022-12-09', '2023-01-31', 0),
(6, 1, 'Monev dan Audit', 'Membuat rekap hasil ami untuk audit rektor', '', '<p>Ambil data dari PPT RTM<br></p>', '2022-12-12', '2022-12-30', 0),
(7, 1, 'Monev dan Audit', 'Membuat laporan AMI tahun 2021/2022', '', 'membuat laporan dimulai sedikit demi sedikit.', '2022-12-12', '2022-12-30', 0),
(8, 1, 'Monev dan Audit', 'Pelaksanaan survei kepuasan dosen dan tendik thd unit kerja', '', '<p>Kirim gfom ke seluruh dosen dan tendik (send copy bukti isi kuesioner)<br></p>', '2022-12-09', '2022-12-23', 0),
(9, 1, 'Monev dan Audit', 'Perencanaan survei kepuasan', '', '<br>Membuat List jenis survei, responden, masa pelaksanaan', '2022-12-09', '2022-12-15', 0),
(10, 1, 'Monev dan Audit', 'Persiapan survei TE', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"303\" style=\"width: 227pt;\"><tbody><tr height=\"40\" style=\"height:30.0pt\">\r\n  <td height=\"40\" class=\"xl66\" width=\"303\" style=\"height:30.0pt;width:227pt\">Cek\r\n  ulang indikator pernyataan kuesioner</td></tr></tbody></table>', '2022-12-09', '2023-01-31', 0),
(11, 1, 'Monev dan Audit', 'Finishing PPT RTM', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"303\" style=\"width: 227pt;\"><tbody><tr height=\"20\" style=\"height:15.0pt\">\r\n  <td height=\"20\" class=\"xl65\" width=\"303\" style=\"height:15.0pt;width:227pt\">Lihat\r\n  gdrive</td></tr></tbody></table>', '2022-12-09', '2022-12-15', 0),
(12, 1, 'Monev dan Audit', 'Pemantauan tindak lanjut temuan AMI unit kerja', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"303\" style=\"width: 227pt;\"><tbody><tr height=\"60\" style=\"height:45.0pt\">\r\n  <td height=\"60\" class=\"xl66\" width=\"303\" style=\"height:45.0pt;width:227pt\">Membuat\r\n  jadwal pertemuan dengan unit kerja</td></tr></tbody></table>', '2022-12-12', '2023-01-31', 0),
(13, 1, 'Data dan Informasi', 'Membuat aplikasi ceklis pekerjaan', '', '<p>Sudah Selesai dengan link spmi.online/tugas</p>', '0', '2022-12-15', 100),
(14, 1, 'Data dan Informasi', 'Pelaporan PDDikti', '', '<p>Menyiapkan aplikasi excel untuk pengolahan data mentah yang akan digunakan untuk pelaporan ke LLDIKTI.</p>', '2022-12-09', '2022-12-15', 60),
(15, 1, 'Data dan Informasi', 'Ceklis pelaporan PDDikti', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"303\" style=\"width: 227pt;\"><tbody><tr height=\"40\" style=\"height:30.0pt\">\r\n  <td height=\"40\" class=\"xl66\" width=\"303\" style=\"height:30.0pt;width:227pt\"><p>Membuat\r\n  ceklis pekerjaan pelaporan PDDIKTI agar mudah di pantau.</p></td></tr></tbody></table>', '2022-12-09', '2022-12-15', 0),
(16, 2, 'Lain-lain', 'Diskusi dengan warek', '', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"272\" style=\"width: 204pt;\"><tbody><tr height=\"40\" style=\"height:30.0pt\">\r\n  <td height=\"40\" class=\"xl66\" width=\"272\" style=\"height:30.0pt;width:204pt\">Mengingatkan\r\n  pemegang website trilogi untuk diupdate</td></tr></tbody></table>', '2022-12-12', '2022-12-12', 0);

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

--
-- Table structure for table `projects_admins`
--

CREATE TABLE `projects_admins` (
  `id` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `projects_admins`
--

INSERT INTO `projects_admins` (`id`, `projectid`, `adminid`) VALUES
(1, 1, 1),
(2, 5, 10),
(3, 4, 7),
(4, 3, 10),
(5, 2, 10),
(6, 15, 9),
(8, 14, 11),
(9, 6, 10),
(10, 6, 8),
(11, 7, 2),
(12, 7, 10),
(13, 7, 8),
(14, 8, 8),
(15, 10, 7),
(16, 10, 2),
(17, 10, 8),
(18, 11, 7),
(19, 11, 2),
(20, 12, 2),
(21, 12, 8);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `type` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `perms` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `type`, `name`, `perms`) VALUES
(1, 'admin', 'Super Administrator', 'a:90:{i:0;s:9:\"addClient\";i:1;s:10:\"editClient\";i:2;s:12:\"deleteClient\";i:3;s:12:\"manageClient\";i:4;s:12:\"adminsClient\";i:5;s:11:\"viewClients\";i:6;s:8:\"addAsset\";i:7;s:9:\"editAsset\";i:8;s:11:\"deleteAsset\";i:9;s:11:\"manageAsset\";i:10;s:12:\"licenseAsset\";i:11;s:10:\"viewAssets\";i:12;s:10:\"addLicense\";i:13;s:11:\"editLicense\";i:14;s:13:\"deleteLicense\";i:15;s:13:\"manageLicense\";i:16;s:12:\"assetLicense\";i:17;s:12:\"viewLicenses\";i:18;s:10:\"addProject\";i:19;s:11:\"editProject\";i:20;s:13:\"deleteProject\";i:21;s:13:\"manageProject\";i:22;s:18:\"manageProjectNotes\";i:23;s:13:\"adminsProject\";i:24;s:12:\"viewProjects\";i:25;s:9:\"addTicket\";i:26;s:10:\"editTicket\";i:27;s:12:\"deleteTicket\";i:28;s:12:\"manageTicket\";i:29;s:17:\"manageTicketRules\";i:30;s:17:\"manageTicketNotes\";i:31;s:22:\"manageTicketAssignment\";i:32;s:11:\"viewTickets\";i:33;s:8:\"addIssue\";i:34;s:9:\"editIssue\";i:35;s:11:\"deleteIssue\";i:36;s:11:\"manageIssue\";i:37;s:10:\"viewIssues\";i:38;s:10:\"addComment\";i:39;s:11:\"editComment\";i:40;s:13:\"deleteComment\";i:41;s:13:\"assignComment\";i:42;s:12:\"viewComments\";i:43;s:13:\"addCredential\";i:44;s:14:\"editCredential\";i:45;s:16:\"deleteCredential\";i:46;s:14:\"viewCredential\";i:47;s:15:\"viewCredentials\";i:48;s:5:\"addKB\";i:49;s:6:\"editKB\";i:50;s:8:\"deleteKB\";i:51;s:6:\"viewKB\";i:52;s:9:\"addPReply\";i:53;s:10:\"editPReply\";i:54;s:12:\"deletePReply\";i:55;s:12:\"viewPReplies\";i:56;s:10:\"uploadFile\";i:57;s:12:\"downloadFile\";i:58;s:10:\"deleteFile\";i:59;s:9:\"viewFiles\";i:60;s:7:\"addHost\";i:61;s:8:\"editHost\";i:62;s:10:\"deleteHost\";i:63;s:10:\"manageHost\";i:64;s:14:\"viewMonitoring\";i:65;s:7:\"addUser\";i:66;s:8:\"editUser\";i:67;s:10:\"deleteUser\";i:68;s:9:\"viewUsers\";i:69;s:8:\"addStaff\";i:70;s:9:\"editStaff\";i:71;s:11:\"deleteStaff\";i:72;s:9:\"viewStaff\";i:73;s:7:\"addRole\";i:74;s:8:\"editRole\";i:75;s:10:\"deleteRole\";i:76;s:9:\"viewRoles\";i:77;s:10:\"addContact\";i:78;s:11:\"editContact\";i:79;s:13:\"deleteContact\";i:80;s:12:\"viewContacts\";i:81;s:10:\"manageData\";i:82;s:14:\"manageSettings\";i:83;s:8:\"viewLogs\";i:84;s:10:\"viewSystem\";i:85;s:10:\"viewPeople\";i:86;s:11:\"viewReports\";i:87;s:11:\"autorefresh\";i:88;s:6:\"search\";i:89;s:4:\"Null\";}'),
(2, 'user', 'LPM', 'a:8:{i:0;s:10:\"addProject\";i:1;s:11:\"editProject\";i:2;s:13:\"deleteProject\";i:3;s:13:\"manageProject\";i:4;s:18:\"manageProjectNotes\";i:5;s:13:\"adminsProject\";i:6;s:12:\"viewProjects\";i:7;s:4:\"Null\";}'),
(5, 'admin', 'LPM', 'a:17:{i:0;s:10:\"addProject\";i:1;s:11:\"editProject\";i:2;s:13:\"deleteProject\";i:3;s:13:\"manageProject\";i:4;s:18:\"manageProjectNotes\";i:5;s:13:\"adminsProject\";i:6;s:12:\"viewProjects\";i:7;s:10:\"addComment\";i:8;s:11:\"editComment\";i:9;s:13:\"deleteComment\";i:10;s:13:\"assignComment\";i:11;s:12:\"viewComments\";i:12;s:10:\"uploadFile\";i:13;s:12:\"downloadFile\";i:14;s:10:\"deleteFile\";i:15;s:9:\"viewFiles\";i:16;s:4:\"Null\";}'),
(3, 'admin', 'Administrator', 'a:70:{i:0;s:9:\"addClient\";i:1;s:10:\"editClient\";i:2;s:12:\"manageClient\";i:3;s:12:\"adminsClient\";i:4;s:11:\"viewClients\";i:5;s:8:\"addAsset\";i:6;s:9:\"editAsset\";i:7;s:11:\"manageAsset\";i:8;s:12:\"licenseAsset\";i:9;s:10:\"viewAssets\";i:10;s:10:\"addLicense\";i:11;s:11:\"editLicense\";i:12;s:13:\"manageLicense\";i:13;s:12:\"assetLicense\";i:14;s:12:\"viewLicenses\";i:15;s:10:\"addProject\";i:16;s:11:\"editProject\";i:17;s:13:\"manageProject\";i:18;s:18:\"manageProjectNotes\";i:19;s:13:\"adminsProject\";i:20;s:12:\"viewProjects\";i:21;s:9:\"addTicket\";i:22;s:10:\"editTicket\";i:23;s:12:\"manageTicket\";i:24;s:17:\"manageTicketRules\";i:25;s:17:\"manageTicketNotes\";i:26;s:11:\"viewTickets\";i:27;s:8:\"addIssue\";i:28;s:9:\"editIssue\";i:29;s:11:\"manageIssue\";i:30;s:10:\"viewIssues\";i:31;s:10:\"addComment\";i:32;s:11:\"editComment\";i:33;s:13:\"assignComment\";i:34;s:12:\"viewComments\";i:35;s:13:\"addCredential\";i:36;s:14:\"editCredential\";i:37;s:14:\"viewCredential\";i:38;s:15:\"viewCredentials\";i:39;s:5:\"addKB\";i:40;s:6:\"viewKB\";i:41;s:9:\"addPReply\";i:42;s:12:\"viewPReplies\";i:43;s:10:\"uploadFile\";i:44;s:12:\"downloadFile\";i:45;s:9:\"viewFiles\";i:46;s:7:\"addHost\";i:47;s:8:\"editHost\";i:48;s:10:\"manageHost\";i:49;s:14:\"viewMonitoring\";i:50;s:7:\"addUser\";i:51;s:8:\"editUser\";i:52;s:9:\"viewUsers\";i:53;s:8:\"addStaff\";i:54;s:9:\"editStaff\";i:55;s:9:\"viewStaff\";i:56;s:7:\"addRole\";i:57;s:8:\"editRole\";i:58;s:9:\"viewRoles\";i:59;s:10:\"addContact\";i:60;s:11:\"editContact\";i:61;s:12:\"viewContacts\";i:62;s:10:\"manageData\";i:63;s:8:\"viewLogs\";i:64;s:10:\"viewSystem\";i:65;s:10:\"viewPeople\";i:66;s:11:\"viewReports\";i:67;s:11:\"autorefresh\";i:68;s:6:\"search\";i:69;s:4:\"Null\";}'),
(4, 'admin', 'Technician', 'a:48:{i:0;s:9:\"addClient\";i:1;s:12:\"manageClient\";i:2;s:11:\"viewClients\";i:3;s:8:\"addAsset\";i:4;s:11:\"manageAsset\";i:5;s:10:\"viewAssets\";i:6;s:10:\"addLicense\";i:7;s:13:\"manageLicense\";i:8;s:12:\"viewLicenses\";i:9;s:10:\"addProject\";i:10;s:13:\"manageProject\";i:11;s:18:\"manageProjectNotes\";i:12;s:12:\"viewProjects\";i:13;s:9:\"addTicket\";i:14;s:12:\"manageTicket\";i:15;s:17:\"manageTicketRules\";i:16;s:17:\"manageTicketNotes\";i:17;s:11:\"viewTickets\";i:18;s:8:\"addIssue\";i:19;s:11:\"manageIssue\";i:20;s:10:\"viewIssues\";i:21;s:10:\"addComment\";i:22;s:12:\"viewComments\";i:23;s:13:\"addCredential\";i:24;s:14:\"viewCredential\";i:25;s:15:\"viewCredentials\";i:26;s:5:\"addKB\";i:27;s:6:\"viewKB\";i:28;s:9:\"addPReply\";i:29;s:12:\"viewPReplies\";i:30;s:10:\"uploadFile\";i:31;s:12:\"downloadFile\";i:32;s:9:\"viewFiles\";i:33;s:7:\"addHost\";i:34;s:10:\"manageHost\";i:35;s:14:\"viewMonitoring\";i:36;s:7:\"addUser\";i:37;s:9:\"viewUsers\";i:38;s:10:\"addContact\";i:39;s:11:\"editContact\";i:40;s:12:\"viewContacts\";i:41;s:10:\"manageData\";i:42;s:10:\"viewSystem\";i:43;s:10:\"viewPeople\";i:44;s:11:\"viewReports\";i:45;s:11:\"autorefresh\";i:46;s:6:\"search\";i:47;s:4:\"Null\";}');

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

--
-- Table structure for table `smslog`
--

CREATE TABLE `smslog` (
  `id` int(11) NOT NULL,
  `peopleid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `mobile` varchar(128) NOT NULL,
  `sms` varchar(256) NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `statuscodes`
--

CREATE TABLE `statuscodes` (
  `id` int(11) NOT NULL,
  `code` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `message` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `statuscodes`
--

INSERT INTO `statuscodes` (`id`, `code`, `type`, `message`) VALUES
(48, 11, 'danger', 'Error! Cannot add item.'),
(49, 21, 'danger', 'Error! Cannot save item.'),
(50, 31, 'danger', 'Error! Cannot delete item.'),
(47, 30, 'success', 'Item has been deleted successfully!'),
(46, 20, 'success', 'Item has been saved successfully!'),
(45, 10, 'success', 'Item has been added successfully!'),
(51, 40, 'success', 'Settings updated successfully!'),
(52, 1200, 'danger', 'Authentication Failed!'),
(53, 1300, 'success', 'Please check your email for a password reset link.'),
(54, 1400, 'danger', 'Email address was not found.'),
(55, 1500, 'danger', 'Invalid reset key!'),
(56, 1600, 'success', 'Success. Please log in with your new password! '),
(57, 1, 'danger', 'Unauthorized Access');

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `contactname` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `web` varchar(255) NOT NULL,
  `notes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `address`, `contactname`, `phone`, `email`, `web`, `notes`) VALUES
(1, 'Amazon', '', '', '', '', '', ''),
(2, 'Best Buy', '', '', '', '', '', ''),
(3, 'Newegg', '', '', '', '', '', '');

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

--
-- Table structure for table `systemlog`
--

CREATE TABLE `systemlog` (
  `id` int(11) NOT NULL,
  `peopleid` int(11) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `systemlog`
--

INSERT INTO `systemlog` (`id`, `peopleid`, `ipaddress`, `description`, `timestamp`) VALUES
(1, -1, '180.252.89.57', 'User/Admin Logged In - ID: 2', '2022-12-10 02:07:51'),
(2, 2, '180.252.89.57', 'Language Added - ID: 2', '2022-12-10 02:10:27'),
(3, -1, '::1', 'User/Admin Login Failure - EMAIL: admin@gmail.com', '2022-12-10 02:18:36'),
(4, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 02:18:56'),
(5, 2, '::1', 'Language Deleted - ID: 2', '2022-12-10 02:27:27'),
(6, 2, '::1', 'Language Added - ID: 3', '2022-12-10 02:27:38'),
(7, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 02:46:49'),
(8, 2, '::1', 'Language Deleted - ID: 3', '2022-12-10 09:50:56'),
(9, 2, '::1', 'Language Added - ID: 4', '2022-12-10 09:51:08'),
(10, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 09:51:59'),
(11, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 09:55:30'),
(12, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 09:59:10'),
(13, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:08:14'),
(14, 2, '::1', 'User/Staff Logged Out - ID: 2', '2022-12-10 10:14:08'),
(15, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:14:13'),
(16, 2, '::1', 'User/Staff Logged Out - ID: 2', '2022-12-10 10:14:18'),
(17, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:14:31'),
(18, 2, '::1', 'User/Staff Logged Out - ID: 2', '2022-12-10 10:17:25'),
(19, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:17:31'),
(20, 2, '::1', 'User/Staff Logged Out - ID: 2', '2022-12-10 10:17:55'),
(21, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:17:56'),
(22, 2, '::1', 'Language Added - ID: 5', '2022-12-10 10:18:13'),
(23, 2, '::1', 'User/Staff Logged Out - ID: 2', '2022-12-10 10:18:34'),
(24, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:18:36'),
(25, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:21:07'),
(26, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 10:22:06'),
(27, 2, '::1', 'Role Edited - ID: 2', '2022-12-10 10:23:37'),
(28, 2, '::1', 'Client Edited - ID: 1', '2022-12-10 10:25:23'),
(29, 2, '::1', 'Client Edited - ID: 2', '2022-12-10 10:25:34'),
(30, 2, '::1', 'User Added - ID: 3', '2022-12-10 10:26:38'),
(31, 2, '::1', 'User Added - ID: 4', '2022-12-10 10:27:20'),
(32, 2, '::1', 'User Added - ID: 5', '2022-12-10 10:27:56'),
(33, 2, '::1', 'User Added - ID: 6', '2022-12-10 10:28:27'),
(34, 2, '::1', 'Role Added - ID: 5', '2022-12-10 10:31:05'),
(35, 2, '::1', 'Staff Account Added - ID: 7', '2022-12-10 10:32:09'),
(36, 2, '::1', 'User Deleted - ID: 6', '2022-12-10 10:34:45'),
(37, 2, '::1', 'User Deleted - ID: 5', '2022-12-10 10:34:47'),
(38, 2, '::1', 'User Deleted - ID: 4', '2022-12-10 10:34:49'),
(39, 2, '::1', 'User Deleted - ID: 3', '2022-12-10 10:34:52'),
(40, 2, '::1', 'Staff Account Added - ID: 8', '2022-12-10 10:35:18'),
(41, 2, '::1', 'Staff Account Added - ID: 9', '2022-12-10 10:35:43'),
(42, 2, '::1', 'Staff Account Added - ID: 10', '2022-12-10 10:36:03'),
(43, 2, '::1', 'Staff Account Added - ID: 11', '2022-12-10 10:36:25'),
(44, 2, '::1', 'Staff Account Edited - ID: 2', '2022-12-10 10:38:03'),
(45, 2, '::1', 'Staff Account Edited - ID: 7', '2022-12-10 10:38:31'),
(46, -1, '::1', 'User/Admin Logged In - ID: 7', '2022-12-10 10:39:14'),
(47, 7, '::1', 'Project Deleted - ID: 1', '2022-12-10 10:40:06'),
(48, 7, '::1', 'Project Added - ID: 2', '2022-12-10 11:00:33'),
(49, 7, '::1', 'Project Added - ID: 3', '2022-12-10 11:03:03'),
(50, 7, '::1', 'Project Edited - ID: 3', '2022-12-10 11:03:12'),
(51, 7, '::1', 'Project Added - ID: 4', '2022-12-10 11:04:05'),
(52, 7, '::1', 'Project Added - ID: 5', '2022-12-10 11:05:43'),
(53, 2, '::1', 'User/Staff Logged Out - ID: 2', '2022-12-10 11:07:12'),
(54, -1, '::1', 'User/Admin Logged In - ID: 10', '2022-12-10 11:07:21'),
(55, 10, '::1', 'User/Staff Logged Out - ID: 10', '2022-12-10 11:11:00'),
(56, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 11:11:02'),
(57, -1, '::1', 'User/Admin Logged In - ID: 2', '2022-12-10 11:44:26'),
(58, 7, '::1', 'User/Staff Logged Out - ID: 7', '2022-12-10 12:08:30'),
(59, -1, '::1', 'User/Admin Logged In - ID: 7', '2022-12-10 12:08:35'),
(60, 2, '::1', 'Project Added - ID: 6', '2022-12-10 12:42:26'),
(61, 2, '::1', 'Project Added - ID: 7', '2022-12-10 12:44:21'),
(62, 2, '::1', 'Project Added - ID: 8', '2022-12-10 12:45:33'),
(63, 2, '::1', 'Project Added - ID: 9', '2022-12-10 12:48:27'),
(64, 2, '::1', 'Project Added - ID: 10', '2022-12-10 12:49:49'),
(65, 2, '::1', 'Project Added - ID: 11', '2022-12-10 12:52:09'),
(66, 2, '::1', 'Project Added - ID: 12', '2022-12-10 12:53:04'),
(67, 2, '::1', 'Project Added - ID: 13', '2022-12-10 12:54:27'),
(68, 2, '::1', 'Project Added - ID: 14', '2022-12-10 12:56:37'),
(69, 2, '::1', 'Project Added - ID: 15', '2022-12-10 12:59:14'),
(70, 2, '::1', 'Project Added - ID: 16', '2022-12-10 13:00:29'),
(71, 2, '::1', 'Issue Added - ID: 4', '2022-12-10 13:06:43'),
(72, 2, '::1', 'Project Edited - ID: 13', '2022-12-10 13:07:09'),
(73, 2, '::1', 'Issue Edited - ID: 4', '2022-12-10 13:10:15'),
(74, 2, '::1', 'Comment Added - ID: 1', '2022-12-10 13:10:46'),
(75, 7, '::1', 'User/Staff Logged Out - ID: 7', '2022-12-10 13:11:20'),
(76, -1, '::1', 'User/Admin Logged In - ID: 10', '2022-12-10 13:11:30'),
(77, 2, '::1', 'Role Edited - ID: 5', '2022-12-10 13:12:48'),
(78, 2, '::1', 'Role Edited - ID: 5', '2022-12-10 13:13:54'),
(79, 10, '::1', 'Comment Deleted - ID: 1', '2022-12-10 13:14:45'),
(80, 2, '::1', 'Role Edited - ID: 5', '2022-12-10 13:27:07'),
(81, 2, '::1', 'Role Edited - ID: 5', '2022-12-10 13:29:40'),
(82, 2, '::1', 'Role Edited - ID: 5', '2022-12-10 13:31:39'),
(83, -1, '::1', 'User/Admin Login Failure - EMAIL: gatot@gmail.com', '2023-10-03 18:40:37'),
(84, -1, '::1', 'User/Admin Logged In - ID: 2', '2023-10-03 18:42:48'),
(85, 2, '::1', 'User/Staff Logged Out - ID: 2', '2023-10-03 18:43:18'),
(86, -1, '::1', 'User/Admin Logged In - ID: 8', '2023-10-03 18:43:40'),
(87, 8, '::1', 'User/Staff Logged Out - ID: 8', '2023-10-03 18:44:18'),
(88, -1, '101.255.123.106', 'User/Admin Login Failure - EMAIL: gatot.pranoto@trilogi.ac.id', '2023-10-04 09:55:15'),
(89, -1, '101.255.123.106', 'User/Admin Logged In - ID: 2', '2023-10-04 09:55:37'),
(90, -1, '101.255.123.106', 'User/Admin Logged In - ID: 3', '2023-10-04 09:56:36'),
(91, 3, '101.255.123.106', 'Project Edited - ID: 2', '2023-10-04 10:01:53'),
(92, -1, '101.255.123.106', 'User/Admin Logged In - ID: 3', '2023-10-04 10:05:36'),
(93, -1, '101.255.123.108', 'User/Admin Login Failure - EMAIL: gatot.pranoto@trilogi.ac.id', '2024-05-15 09:28:53'),
(94, -1, '101.255.123.108', 'User/Admin Logged In - ID: 2', '2024-05-15 09:29:04'),
(95, 2, '101.255.123.108', 'User/Staff Logged Out - ID: 2', '2024-05-15 09:29:56'),
(96, -1, '101.255.123.108', 'User/Admin Logged In - ID: 8', '2024-05-15 09:30:11'),
(97, -1, '101.255.123.108', 'User/Admin Logged In - ID: 10', '2024-05-15 09:31:07'),
(98, 10, '101.255.123.108', 'User/Staff Logged Out - ID: 10', '2024-05-15 09:32:01'),
(99, -1, '101.255.123.108', 'User/Admin Logged In - ID: 7', '2024-05-15 09:32:19'),
(100, -1, '101.255.123.108', 'User/Admin Logged In - ID: 8', '2024-05-16 14:10:52'),
(101, -1, '101.255.123.106', 'User/Admin Login Failure - EMAIL: gatot.pranoto@trilogi.ac.id', '2024-05-31 14:37:34'),
(102, -1, '101.255.123.106', 'User/Admin Logged In - ID: 8', '2024-05-31 14:38:57'),
(103, 8, '101.255.123.106', 'User/Staff Logged Out - ID: 8', '2024-05-31 14:39:11'),
(104, -1, '101.255.123.106', 'User/Admin Login Failure - EMAIL: gatot@trilogi.ac.id', '2024-05-31 14:39:21'),
(105, -1, '101.255.123.106', 'User/Admin Login Failure - EMAIL: gatot.pranoto@trilogi.ac.id', '2024-05-31 14:39:32'),
(106, -1, '101.255.123.106', 'User/Admin Logged In - ID: 7', '2024-05-31 14:39:40'),
(107, 7, '101.255.123.106', 'User/Staff Logged Out - ID: 7', '2024-05-31 14:39:45'),
(108, -1, '101.255.123.106', 'User/Admin Login Failure - EMAIL: admin@trilogi.ac.id', '2024-05-31 14:39:57'),
(109, -1, '101.255.123.106', 'User/Admin Logged In - ID: 2', '2024-05-31 14:40:08');

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

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

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `ticket` int(11) NOT NULL,
  `departmentid` int(11) NOT NULL,
  `clientid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `assetid` int(11) NOT NULL,
  `email` varchar(128) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `status` varchar(50) NOT NULL,
  `priority` varchar(50) NOT NULL,
  `timestamp` datetime NOT NULL,
  `notes` text NOT NULL,
  `ccs` varchar(255) NOT NULL,
  `timespent` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tickets_departments`
--

CREATE TABLE `tickets_departments` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tickets_departments`
--

INSERT INTO `tickets_departments` (`id`, `name`) VALUES
(1, 'Default Department');

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

--
-- Table structure for table `tickets_pr`
--

CREATE TABLE `tickets_pr` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tickets_pr`
--

INSERT INTO `tickets_pr` (`id`, `name`, `content`) VALUES
(1, 'Demo Predefined Reply', '<div><p>Predefined reply body.<br></p></div>');

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

--
-- Table structure for table `tickets_replies`
--

CREATE TABLE `tickets_replies` (
  `id` int(11) NOT NULL,
  `ticketid` int(11) NOT NULL,
  `peopleid` int(11) NOT NULL,
  `message` text NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tickets_rules`
--

CREATE TABLE `tickets_rules` (
  `id` int(11) NOT NULL,
  `ticketid` int(11) NOT NULL,
  `executed` int(1) NOT NULL,
  `name` varchar(255) NOT NULL,
  `cond_status` varchar(255) NOT NULL,
  `cond_priority` varchar(255) NOT NULL,
  `cond_timeelapsed` varchar(20) NOT NULL,
  `cond_datetime` datetime NOT NULL,
  `act_status` varchar(255) NOT NULL,
  `act_priority` varchar(255) NOT NULL,
  `act_assignto` int(11) NOT NULL,
  `act_notifyadmins` int(1) NOT NULL,
  `act_addreply` int(1) NOT NULL,
  `reply` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tag` (`tag`);

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

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

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

--
-- Indexes for table `config`
--
ALTER TABLE `config`
  ADD UNIQUE KEY `name` (`name`);

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

--
-- Indexes for table `emaillog`
--
ALTER TABLE `emaillog`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

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

--
-- Indexes for table `licenses`
--
ALTER TABLE `licenses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tag` (`tag`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `smslog`
--
ALTER TABLE `smslog`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

