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

START TRANSACTION;



--
-- Database: `myharakaha_redads`
--
DROP DATABASE IF EXISTS `myharakaha_redads`;
CREATE DATABASE IF NOT EXISTS `myharakaha_redads` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE `myharakaha_redads`;

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

--
-- Table structure for table `bank`
--

CREATE TABLE IF NOT EXISTS `bank` (
  `bank_id` int NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `ibg_code` varchar(10) NOT NULL,
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `bank`
--

INSERT INTO `bank` (`bank_id`, `bank_name`, `ibg_code`) VALUES
(1, 'Affin Bank Berhad', 'PHBMMYKL'),
(2, 'Alliance Bank Malaysia Berhad', 'MFBBMYKL'),
(3, 'Ambank/Amfinance', 'ARBKMYKL'),
(4, 'Bank Islam Malaysia Berhad', 'BIMBMYKL'),
(5, 'Bank Kerjasama Rakyat Malaysia Berhad', 'BKRMMYKL'),
(6, 'Bank Muamalat Malaysia Berhad', 'BMMBMYKL'),
(7, 'Bank Of America', 'BOFAMY2X'),
(8, 'Agrobank Berhad', 'AGOBMYKL'),
(9, 'Bank Simpanan Nasional Berhad', 'BSNAMYK1'),
(10, 'Citibank Berhad', 'CITIMYKL'),
(11, 'Deutsche Bank (Malaysia) Berhad', 'DEUTMYKL'),
(12, 'China Construction Bank (M) Berhad', 'PCBCMYKL'),
(13, 'Hong Leong Bank', 'HLBBMYKL'),
(14, 'HSBC Bank Malaysia Berhad', 'HBMBMYKL'),
(15, 'J.P. Morgan Chase Bank Bhd', 'CHASMYKX'),
(16, 'Kuwait Finance House (Malaysia) Berhad', 'KFHOMYKL'),
(17, 'Maybank', 'MBBEMYKL'),
(18, 'OCBC Bank (Malaysia) Berhad', 'OCBCMYKL'),
(19, 'Public Bank Berhad/Public Finance Berhad', 'PBBEMYKL'),
(20, 'RHB Bank', 'RHBBMYKL'),
(21, 'Standard Chartered Bank Malaysia Berhad', 'SCBLMYKX'),
(22, 'Industrial & Comm. Bank Of China Berhad', 'ICBKMYKL'),
(23, 'United Overseas Bank Berhad', 'UOVBMYKL'),
(24, 'CIMB Bank', 'CIBBMYKL'),
(25, 'MBSB Bank', 'AFBQMYKL'),
(26, 'Mizuho Bank', 'MHCBMYKA'),
(27, 'MUFG Bank', 'BOTKMYKX'),
(28, 'Sumitomo Mitsui Bank', 'SMBCMYKL'),
(29, 'Al-Rajhi Bank', 'RJHIMYKL'),
(30, 'Bangkok Bank', 'BKKBMYKL'),
(31, 'Bank Of China', 'BKCHMYKL'),
(32, 'BNP Paribas', 'BNPAMYKL');

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

--
-- Table structure for table `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `state_id` varchar(3) NOT NULL,
  `city_name` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`state_id`, `city_name`) VALUES
('JHR', 'Batu Pahat'),
('JHR', 'Bukit Indah'),
('JHR', 'Johor Bahru'),
('JHR', 'Johor Bahru Tengah'),
('JHR', 'Kluang'),
('JHR', 'Kota Tinggi'),
('JHR', 'Kulai'),
('JHR', 'Labis'),
('JHR', 'Mersing'),
('JHR', 'Muar'),
('JHR', 'Pagoh'),
('JHR', 'Pasir Gudang'),
('JHR', 'Pontian'),
('JHR', 'Pontian Kecil'),
('JHR', 'Segamat'),
('JHR', 'Senai'),
('JHR', 'Simpang Renggam'),
('JHR', 'Skudai'),
('JHR', 'Tangkak'),
('JHR', 'Tebrau'),
('JHR', 'Ulu Tiram'),
('JHR', 'Yong Peng'),
('KDH', 'Alor Star'),
('KDH', 'Baling'),
('KDH', 'Bandar Baharu'),
('KDH', 'Bedong'),
('KDH', 'Jitra'),
('KDH', 'Kota Setar'),
('KDH', 'Kuah'),
('KDH', 'Kuala Muda'),
('KDH', 'Kuala Nerang'),
('KDH', 'Kubang Pasu'),
('KDH', 'Kulim'),
('KDH', 'Padang Terap'),
('KDH', 'Pendang'),
('KDH', 'Pulau Langkawi'),
('KDH', 'Sik'),
('KDH', 'Sungai Petani'),
('KDH', 'Yan'),
('KTN', 'Bachok'),
('KTN', 'Gua Musang'),
('KTN', 'Jeli'),
('KTN', 'Kota Bharu'),
('KTN', 'Kuala Krai'),
('KTN', 'Machang'),
('KTN', 'Pasir Mas'),
('KTN', 'Pasir Puteh'),
('KTN', 'Tanah Merah'),
('KTN', 'Tumpat'),
('MLK', 'Alor Gajah'),
('MLK', 'Bandaraya Melaka'),
('MLK', 'Bukit Baru'),
('MLK', 'Jasin'),
('MLK', 'Melaka Tengah'),
('NSN', 'Bahau'),
('NSN', 'Bandar Seri Jempol'),
('NSN', 'Gemas'),
('NSN', 'Jelebu'),
('NSN', 'Jempol'),
('NSN', 'Kuala Klawang'),
('NSN', 'Kuala Pilah'),
('NSN', 'Port Dickson'),
('NSN', 'Rembau'),
('NSN', 'Seremban'),
('NSN', 'Tampin'),
('PHG', 'Bandar Bera'),
('PHG', 'Bentong'),
('PHG', 'Bera'),
('PHG', 'Cameron Highlands'),
('PHG', 'Jerantut'),
('PHG', 'Kuala Lipis'),
('PHG', 'Kuala Rompin'),
('PHG', 'Kuantan'),
('PHG', 'Maran'),
('PHG', 'Pekan'),
('PHG', 'Raub'),
('PHG', 'Rompin'),
('PHG', 'Tanah Rata'),
('PHG', 'Temerloh'),
('PRK', 'Batang Padang'),
('PRK', 'Batu Gajah'),
('PRK', 'Gerik'),
('PRK', 'Hilir Perak'),
('PRK', 'Hulu Perak'),
('PRK', 'Ipoh'),
('PRK', 'Kampar'),
('PRK', 'Kerian'),
('PRK', 'Kinta'),
('PRK', 'Kuala Kangsar'),
('PRK', 'Larut'),
('PRK', 'Manjung'),
('PRK', 'Matang'),
('PRK', 'Parit Buntar'),
('PRK', 'Perak Tengah'),
('PRK', 'Selama'),
('PRK', 'Seri Iskandar'),
('PRK', 'Seri Manjung'),
('PRK', 'Simpang Empat'),
('PRK', 'Sitiawan'),
('PRK', 'Taiping'),
('PRK', 'Tanjung Malim'),
('PRK', 'Tapah'),
('PRK', 'Teluk Intan'),
('PLS', 'Kangar'),
('PNG', 'Ayer Itam'),
('PNG', 'Balik Pulau'),
('PNG', 'Bayan Lepas'),
('PNG', 'Bukit Mertajam'),
('PNG', 'Butterworth'),
('PNG', 'Gelugor'),
('PNG', 'George Town'),
('PNG', 'Kepala Batas'),
('PNG', 'Perai'),
('PNG', 'Pulau Pinang Barat Daya'),
('PNG', 'Pulau Pinang Timur Laut'),
('PNG', 'Seberang Perai Selatan'),
('PNG', 'Seberang Perai Tengah'),
('PNG', 'Seberang Perai Utara'),
('PNG', 'Sungai Ara'),
('PNG', 'Sungai Jawi'),
('PNG', 'Val d\'or'),
('SBH', 'Beaufort'),
('SBH', 'Beluran'),
('SBH', 'Donggongon'),
('SBH', 'Inanam'),
('SBH', 'Keningau'),
('SBH', 'Kinabatangan'),
('SBH', 'Kinarut'),
('SBH', 'Kota Belud'),
('SBH', 'Kota Kinabalu'),
('SBH', 'Kota Kinabatangan'),
('SBH', 'Kota Marudu'),
('SBH', 'Kuala Penyu'),
('SBH', 'Kudat'),
('SBH', 'Kunak'),
('SBH', 'Lahad Datu'),
('SBH', 'Nabawan'),
('SBH', 'Papar'),
('SBH', 'Penampang'),
('SBH', 'Pitas'),
('SBH', 'Putatan'),
('SBH', 'Ranau'),
('SBH', 'Sandakan'),
('SBH', 'Semporna'),
('SBH', 'Sipitang'),
('SBH', 'Tambunan'),
('SBH', 'Tawau'),
('SBH', 'Telupid'),
('SBH', 'Tenom'),
('SBH', 'Tongod'),
('SBH', 'Tuaran'),
('SWK', 'Asajaya'),
('SWK', 'Bau'),
('SWK', 'Belaga'),
('SWK', 'Betong'),
('SWK', 'Bintangor'),
('SWK', 'Bintulu'),
('SWK', 'Dalat'),
('SWK', 'Daro'),
('SWK', 'Julau'),
('SWK', 'Kanowit'),
('SWK', 'Kapit'),
('SWK', 'Kota Samarahan'),
('SWK', 'Kuching'),
('SWK', 'Lawas'),
('SWK', 'Limbang'),
('SWK', 'Lubok Antu'),
('SWK', 'Lundu'),
('SWK', 'Marudi'),
('SWK', 'Matu'),
('SWK', 'Meradong'),
('SWK', 'Miri'),
('SWK', 'Mukah'),
('SWK', 'Samarahan'),
('SWK', 'Saratok'),
('SWK', 'Sarikei'),
('SWK', 'Serian'),
('SWK', 'Sibu'),
('SWK', 'Simunjan'),
('SWK', 'Song'),
('SWK', 'Sri Aman'),
('SWK', 'Tatau'),
('SGR', 'Ampang Jaya'),
('SGR', 'Balakong'),
('SGR', 'Bandar Baru Bangi'),
('SGR', 'Bandar Baru Selayang'),
('SGR', 'Banting'),
('SGR', 'Cheras'),
('SGR', 'Cyberjaya'),
('SGR', 'Gombak'),
('SGR', 'Gombak Setia'),
('SGR', 'Hulu Langat'),
('SGR', 'Hulu Selangor'),
('SGR', 'Kajang'),
('SGR', 'Klang'),
('SGR', 'Kuala Kubu Bharu'),
('SGR', 'Kuala Langat'),
('SGR', 'Kuala Selangor'),
('SGR', 'Petaling'),
('SGR', 'Petaling Jaya'),
('SGR', 'Rawang'),
('SGR', 'Sabak'),
('SGR', 'Sabak Bernam'),
('SGR', 'Salak Tinggi'),
('SGR', 'Selayang Baru'),
('SGR', 'Semenyih'),
('SGR', 'Sepang'),
('SGR', 'Shah Alam'),
('SGR', 'Subang Jaya'),
('SGR', 'Titiwangsa'),
('SGR', 'Teluk Datok'),
('TRG', 'Bandar Permaisuri'),
('TRG', 'Besut'),
('TRG', 'Chukai'),
('TRG', 'Dungun'),
('TRG', 'Hulu Terengganu'),
('TRG', 'Jerteh'),
('TRG', 'Kemaman'),
('TRG', 'Kerteh'),
('TRG', 'Kuala Berang'),
('TRG', 'Kuala Besut'),
('TRG', 'Kuala Dungun'),
('TRG', 'Kuala Terengganu'),
('TRG', 'Marang'),
('TRG', 'Setiu'),
('WKL', 'Kuala Lumpur'),
('WLB', 'Labuan'),
('WPJ', 'Putrajaya'),
('NSN', 'Ampangan'),
('MLK', 'Masjid Tanah'),
('WPJ', ''),
('WPJ', ''),
('WKL', 'Keramat'),
('SGR', 'Ampang'),
('SGR', 'Ara Damansara'),
('SGR', 'Bandar Baru Salak Tinggi'),
('SGR', 'Bandar Bukit Raja'),
('SGR', 'Bandar Kinrara'),
('SGR', 'Bandar Puteri'),
('SGR', 'Bandar Sunway'),
('SGR', 'Bandar Utama'),
('SGR', 'Bangi'),
('SGR', 'Batang Berjuntai'),
('SGR', 'Batang Kali'),
('SGR', ''),
('SGR', 'Batu Arang'),
('SGR', 'Batu Caves'),
('SGR', 'Beranag'),
('SGR', 'Bukit Beruntung'),
('SGR', 'Bukit Rotan'),
('SGR', 'Country Heights'),
('SGR', 'Cyberjaya'),
('SGR', 'Damansara'),
('SGR', 'Damansara Damai'),
('SGR', 'Damansara Intan'),
('SGR', 'Damansara Jaya'),
('SGR', 'Damansara Kim'),
('SGR', 'Damansara Perdana'),
('SGR', 'Damansara Utama'),
('SGR', 'Dengkil'),
('SGR', 'Glenmarie'),
('SGR', 'Jenjarom'),
('SGR', 'Kapar'),
('SGR', 'Kayu Ara'),
('SGR', 'Kelana Jaya'),
('SGR', 'Kepong'),
('SGR', 'Kerling'),
('SGR', 'Kota Damansara'),
('SGR', 'Kota Kemuning'),
('SGR', 'Kuang'),
('SGR', 'Mutiara Damansara'),
('SGR', 'Nilai'),
('SGR', 'Pengkalan'),
('SGR', 'Kundang'),
('SGR', 'Port Klang'),
('SGR', 'Puchong'),
('SGR', 'Pulau Indah'),
('SGR', 'Pulau Carey'),
('SGR', 'Pulau Ketam'),
('SGR', 'Bukit Rotan'),
('SGR', 'Putra Heights'),
('SGR', 'Putrajaya'),
('SGR', 'Rasa'),
('SGR', 'Rawang'),
('SGR', 'Sabak Bernam'),
('SGR', 'Sekinchan'),
('SGR', 'Selayang'),
('SGR', 'Serdang'),
('SGR', 'Serendah'),
('SGR', 'Seri Kembangan'),
('SGR', 'Setia Alam'),
('SGR', 'Sierra Mas'),
('SGR', 'Seri Damansara'),
('SGR', 'SS2'),
('SGR', 'Subang'),
('SGR', 'Sungai Ayer Tawar'),
('SGR', 'Sungai Besar'),
('SGR', 'Sungai Buloh'),
('SGR', 'Sungai Pelek'),
('SGR', 'Tanjung Karang'),
('SGR', 'Tanjung Sepat'),
('SGR', 'Telok Panglima Garang'),
('SGR', 'Tropicana'),
('SGR', 'Ulu Kelang'),
('SGR', 'USJ'),
('SGR', 'Valencia');

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

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

CREATE TABLE IF NOT EXISTS `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int UNSIGNED NOT NULL DEFAULT '0',
  `data` mediumblob,
  `last_activity` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`, `last_activity`) VALUES
('ci_session:0213088b99ef71d5b2e359d231b77330', '::1', 4294967295, '__ci_last_regenerate|i:1772511183;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}token|a:1:{s:16:\"login_form_token\";a:1:{s:18:\"d35212b820cd7247f0\";s:64:\"1f9ad3a189b7a7e8e51f9cb4ea2b5c0d69ad6cba2e3ad98d66640a6187bace1c\";}}_ci_previous_url|s:25:\"https://redads.test/login\";', '2026-03-03 12:13:03'),
('ci_session:2b0eb3db8a79288ab5afa23c71fc272a', '::1', 4294967295, '__ci_last_regenerate|i:1772508002;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}', '2026-03-03 11:20:05'),
('ci_session:3f0ce9fc67130f189be3c82a91536463', '::1', 4294967295, '__ci_last_regenerate|i:1772508347;web|a:3:{s:10:\"module_url\";s:32:\"https://redads.test/Builtin/User\";s:11:\"nama_module\";s:12:\"Builtin/User\";s:11:\"method_name\";s:4:\"edit\";}', '2026-03-03 11:25:47'),
('ci_session:467d99a686782d778937b015ea6662ad', '::1', 4294967295, '__ci_last_regenerate|i:1772508433;web|a:3:{s:10:\"module_url\";s:32:\"https://redads.test/Builtin/User\";s:11:\"nama_module\";s:12:\"Builtin/User\";s:11:\"method_name\";s:4:\"edit\";}', '2026-03-03 11:27:13'),
('ci_session:541fade91c9d92d42501305fd9c3c57e', '::1', 4294967295, '__ci_last_regenerate|i:1772511339;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}token|a:1:{s:16:\"login_form_token\";a:1:{s:18:\"c4592365610b1c1be2\";s:64:\"c3dd4a015ff9af0f843076339b19eb2eb0246eb9ede241cd79f6698628145f66\";}}_ci_previous_url|s:25:\"https://redads.test/login\";', '2026-03-03 12:15:40'),
('ci_session:7bdf71a6042a655bee7e74cc250dd5ce', '::1', 4294967295, '__ci_last_regenerate|i:1772508001;web|a:3:{s:10:\"module_url\";s:38:\"https://redads.test/Builtin/Permission\";s:11:\"nama_module\";s:18:\"Builtin/Permission\";s:11:\"method_name\";s:5:\"index\";}', '2026-03-03 11:20:01'),
('ci_session:87f4f3b2786465265630ccf179819e6c', '::1', 4294967295, '__ci_last_regenerate|i:1772511195;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}token|a:1:{s:16:\"login_form_token\";a:1:{s:18:\"f1b8835b2ed32c5b29\";s:64:\"910663f5a66566dab966d2b3f0cb14ecd9861acbfbca64233d23511633df91a5\";}}_ci_previous_url|s:25:\"https://redads.test/login\";', '2026-03-03 12:13:16'),
('ci_session:89d8cf8131d2b1c557cf30406f9465e7', '::1', 4294967295, '__ci_last_regenerate|i:1772508348;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}token|a:1:{s:16:\"login_form_token\";a:1:{s:18:\"6b725073c39ac2a057\";s:64:\"7fc22346a99d244f4579ab7200188d60a7b5a1c75a469ae3fc15dad8d3d27749\";}}_ci_previous_url|s:25:\"https://redads.test/login\";', '2026-03-03 11:25:48'),
('ci_session:98431e5b1d19787645a675fc7dfddbfa', '::1', 4294967295, '__ci_last_regenerate|i:1772508433;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}token|a:1:{s:16:\"login_form_token\";a:1:{s:18:\"3184ffd1a5869f50e2\";s:64:\"70c23d8ca5c5b15da023c1054b9c11eb0acc1877a07ddf06ea88a88bdfbb029a\";}}_ci_previous_url|s:25:\"https://redads.test/login\";', '2026-03-03 11:27:14'),
('ci_session:9cb37671e64dc06f42c76296c3f7e930', '::1', 4294967295, '__ci_last_regenerate|i:1772508002;web|a:3:{s:10:\"module_url\";s:25:\"https://redads.test/Login\";s:11:\"nama_module\";s:5:\"Login\";s:11:\"method_name\";s:5:\"index\";}token|a:1:{s:16:\"login_form_token\";a:1:{s:18:\"79eeded4fdeaa468aa\";s:64:\"900cfcfa1d072867068bc2ec1feb616c36ca62d1c71d06e02b95393cba31e53e\";}}_ci_previous_url|s:25:\"https://redads.test/login\";', '2026-03-03 11:20:02');

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

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `id` int NOT NULL AUTO_INCREMENT,
  `iso_code` char(2) NOT NULL,
  `iso3_code` char(3) DEFAULT NULL,
  `country_name` varchar(100) NOT NULL,
  `continent` char(2) DEFAULT NULL,
  `phone_code` varchar(10) DEFAULT NULL,
  `currency_code` char(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `iso_code` (`iso_code`),
  UNIQUE KEY `country_name` (`country_name`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `iso_code`, `iso3_code`, `country_name`, `continent`, `phone_code`, `currency_code`) VALUES
(1, 'AF', 'AFG', 'Afghanistan', 'AS', '+93', 'AFN'),
(2, 'AL', 'ALB', 'Albania', 'EU', '+355', 'ALL'),
(3, 'DZ', 'DZA', 'Algeria', 'AF', '+213', 'DZD'),
(4, 'AS', 'ASM', 'American Samoa', 'OC', '+1684', 'USD'),
(5, 'AD', 'AND', 'Andorra', 'EU', '+376', 'EUR'),
(6, 'AO', 'AGO', 'Angola', 'AF', '+244', 'AOA'),
(7, 'AI', 'AIA', 'Anguilla', 'NA', '+1264', 'XCD'),
(8, 'AG', 'ATG', 'Antigua and Barbuda', 'NA', '+1268', 'XCD'),
(9, 'AR', 'ARG', 'Argentina', 'SA', '+54', 'ARS'),
(10, 'AM', 'ARM', 'Armenia', 'AS', '+374', 'AMD'),
(11, 'AU', 'AUS', 'Australia', 'OC', '+61', 'AUD'),
(12, 'AT', 'AUT', 'Austria', 'EU', '+43', 'EUR'),
(13, 'AZ', 'AZE', 'Azerbaijan', 'AS', '+994', 'AZN'),
(14, 'BS', 'BHS', 'Bahamas', 'NA', '+1242', 'BSD'),
(15, 'BH', 'BHR', 'Bahrain', 'AS', '+973', 'BHD'),
(16, 'BD', 'BGD', 'Bangladesh', 'AS', '+880', 'BDT'),
(17, 'BB', 'BRB', 'Barbados', 'NA', '+1246', 'BBD'),
(18, 'BY', 'BLR', 'Belarus', 'EU', '+375', 'BYN'),
(19, 'BE', 'BEL', 'Belgium', 'EU', '+32', 'EUR'),
(20, 'BZ', 'BLZ', 'Belize', 'NA', '+501', 'BZD'),
(21, 'BJ', 'BEN', 'Benin', 'AF', '+229', 'XOF'),
(22, 'BM', 'BMU', 'Bermuda', 'NA', '+1441', 'BMD'),
(23, 'BT', 'BTN', 'Bhutan', 'AS', '+975', 'BTN'),
(24, 'BO', 'BOL', 'Bolivia', 'SA', '+591', 'BOB'),
(25, 'BA', 'BIH', 'Bosnia and Herzegovina', 'EU', '+387', 'BAM'),
(26, 'BW', 'BWA', 'Botswana', 'AF', '+267', 'BWP'),
(27, 'BR', 'BRA', 'Brazil', 'SA', '+55', 'BRL'),
(28, 'BN', 'BRN', 'Brunei Darussalam', 'AS', '+673', 'BND'),
(29, 'BG', 'BGR', 'Bulgaria', 'EU', '+359', 'BGN'),
(30, 'BF', 'BFA', 'Burkina Faso', 'AF', '+226', 'XOF'),
(31, 'BI', 'BDI', 'Burundi', 'AF', '+257', 'BIF'),
(32, 'KH', 'KHM', 'Cambodia', 'AS', '+855', 'KHR'),
(33, 'CM', 'CMR', 'Cameroon', 'AF', '+237', 'XAF'),
(34, 'CA', 'CAN', 'Canada', 'NA', '+1', 'CAD'),
(35, 'CV', 'CPV', 'Cape Verde', 'AF', '+238', 'CVE'),
(36, 'KY', 'CYM', 'Cayman Islands', 'NA', '+1345', 'KYD'),
(37, 'CF', 'CAF', 'Central African Republic', 'AF', '+236', 'XAF'),
(38, 'TD', 'TCD', 'Chad', 'AF', '+235', 'XAF'),
(39, 'CL', 'CHL', 'Chile', 'SA', '+56', 'CLP'),
(40, 'CN', 'CHN', 'China', 'AS', '+86', 'CNY'),
(41, 'CO', 'COL', 'Colombia', 'SA', '+57', 'COP'),
(42, 'KM', 'COM', 'Comoros', 'AF', '+269', 'KMF'),
(43, 'CG', 'COG', 'Congo', 'AF', '+242', 'XAF'),
(44, 'CD', 'COD', 'Congo, Democratic Republic', 'AF', '+243', 'CDF'),
(45, 'CR', 'CRI', 'Costa Rica', 'NA', '+506', 'CRC'),
(46, 'CI', 'CIV', 'Côte d\'Ivoire', 'AF', '+225', 'XOF'),
(47, 'HR', 'HRV', 'Croatia', 'EU', '+385', 'HRK'),
(48, 'CU', 'CUB', 'Cuba', 'NA', '+53', 'CUP'),
(49, 'CY', 'CYP', 'Cyprus', 'EU', '+357', 'EUR'),
(50, 'CZ', 'CZE', 'Czech Republic', 'EU', '+420', 'CZK'),
(51, 'DK', 'DNK', 'Denmark', 'EU', '+45', 'DKK'),
(52, 'DJ', 'DJI', 'Djibouti', 'AF', '+253', 'DJF'),
(53, 'DM', 'DMA', 'Dominica', 'NA', '+1767', 'XCD'),
(54, 'DO', 'DOM', 'Dominican Republic', 'NA', '+1809', 'DOP'),
(55, 'EC', 'ECU', 'Ecuador', 'SA', '+593', 'USD'),
(56, 'EG', 'EGY', 'Egypt', 'AF', '+20', 'EGP'),
(57, 'SV', 'SLV', 'El Salvador', 'NA', '+503', 'USD'),
(58, 'GQ', 'GNQ', 'Equatorial Guinea', 'AF', '+240', 'XAF'),
(59, 'ER', 'ERI', 'Eritrea', 'AF', '+291', 'ERN'),
(60, 'EE', 'EST', 'Estonia', 'EU', '+372', 'EUR'),
(61, 'SZ', 'SWZ', 'Eswatini', 'AF', '+268', 'SZL'),
(62, 'ET', 'ETH', 'Ethiopia', 'AF', '+251', 'ETB'),
(63, 'FJ', 'FJI', 'Fiji', 'OC', '+679', 'FJD'),
(64, 'FI', 'FIN', 'Finland', 'EU', '+358', 'EUR'),
(65, 'FR', 'FRA', 'France', 'EU', '+33', 'EUR'),
(66, 'GA', 'GAB', 'Gabon', 'AF', '+241', 'XAF'),
(67, 'GM', 'GMB', 'Gambia', 'AF', '+220', 'GMD'),
(68, 'GE', 'GEO', 'Georgia', 'AS', '+995', 'GEL'),
(69, 'DE', 'DEU', 'Germany', 'EU', '+49', 'EUR'),
(70, 'GH', 'GHA', 'Ghana', 'AF', '+233', 'GHS'),
(71, 'GR', 'GRC', 'Greece', 'EU', '+30', 'EUR'),
(72, 'GD', 'GRD', 'Grenada', 'NA', '+1473', 'XCD'),
(73, 'GT', 'GTM', 'Guatemala', 'NA', '+502', 'GTQ'),
(74, 'GN', 'GIN', 'Guinea', 'AF', '+224', 'GNF'),
(75, 'GW', 'GNB', 'Guinea-Bissau', 'AF', '+245', 'XOF'),
(76, 'GY', 'GUY', 'Guyana', 'SA', '+592', 'GYD'),
(77, 'HT', 'HTI', 'Haiti', 'NA', '+509', 'HTG'),
(78, 'HN', 'HND', 'Honduras', 'NA', '+504', 'HNL'),
(79, 'HU', 'HUN', 'Hungary', 'EU', '+36', 'HUF'),
(80, 'IS', 'ISL', 'Iceland', 'EU', '+354', 'ISK'),
(81, 'IN', 'IND', 'India', 'AS', '+91', 'INR'),
(82, 'ID', 'IDN', 'Indonesia', 'AS', '+62', 'IDR'),
(83, 'IR', 'IRN', 'Iran', 'AS', '+98', 'IRR'),
(84, 'IQ', 'IRQ', 'Iraq', 'AS', '+964', 'IQD'),
(85, 'IE', 'IRL', 'Ireland', 'EU', '+353', 'EUR'),
(86, 'IL', 'ISR', 'Israel', 'AS', '+972', 'ILS'),
(87, 'IT', 'ITA', 'Italy', 'EU', '+39', 'EUR'),
(88, 'JM', 'JAM', 'Jamaica', 'NA', '+1876', 'JMD'),
(89, 'JP', 'JPN', 'Japan', 'AS', '+81', 'JPY'),
(90, 'JO', 'JOR', 'Jordan', 'AS', '+962', 'JOD'),
(91, 'KZ', 'KAZ', 'Kazakhstan', 'AS', '+7', 'KZT'),
(92, 'KE', 'KEN', 'Kenya', 'AF', '+254', 'KES'),
(93, 'KI', 'KIR', 'Kiribati', 'OC', '+686', 'AUD'),
(94, 'KW', 'KWT', 'Kuwait', 'AS', '+965', 'KWD'),
(95, 'KG', 'KGZ', 'Kyrgyzstan', 'AS', '+996', 'KGS'),
(96, 'LA', 'LAO', 'Laos', 'AS', '+856', 'LAK'),
(97, 'LV', 'LVA', 'Latvia', 'EU', '+371', 'EUR'),
(98, 'LB', 'LBN', 'Lebanon', 'AS', '+961', 'LBP'),
(99, 'LS', 'LSO', 'Lesotho', 'AF', '+266', 'LSL'),
(100, 'LR', 'LBR', 'Liberia', 'AF', '+231', 'LRD'),
(101, 'LY', 'LBY', 'Libya', 'AF', '+218', 'LYD'),
(102, 'LI', 'LIE', 'Liechtenstein', 'EU', '+423', 'CHF'),
(103, 'LT', 'LTU', 'Lithuania', 'EU', '+370', 'EUR'),
(104, 'LU', 'LUX', 'Luxembourg', 'EU', '+352', 'EUR'),
(105, 'MG', 'MDG', 'Madagascar', 'AF', '+261', 'MGA'),
(106, 'MW', 'MWI', 'Malawi', 'AF', '+265', 'MWK'),
(107, 'MY', 'MYS', 'Malaysia', 'AS', '+60', 'MYR'),
(108, 'MV', 'MDV', 'Maldives', 'AS', '+960', 'MVR'),
(109, 'ML', 'MLI', 'Mali', 'AF', '+223', 'XOF'),
(110, 'MT', 'MLT', 'Malta', 'EU', '+356', 'EUR'),
(111, 'MH', 'MHL', 'Marshall Islands', 'OC', '+692', 'USD'),
(112, 'MR', 'MRT', 'Mauritania', 'AF', '+222', 'MRU'),
(113, 'MU', 'MUS', 'Mauritius', 'AF', '+230', 'MUR'),
(114, 'MX', 'MEX', 'Mexico', 'NA', '+52', 'MXN'),
(115, 'FM', 'FSM', 'Micronesia', 'OC', '+691', 'USD'),
(116, 'MD', 'MDA', 'Moldova', 'EU', '+373', 'MDL'),
(117, 'MC', 'MCO', 'Monaco', 'EU', '+377', 'EUR'),
(118, 'MN', 'MNG', 'Mongolia', 'AS', '+976', 'MNT'),
(119, 'ME', 'MNE', 'Montenegro', 'EU', '+382', 'EUR'),
(120, 'MA', 'MAR', 'Morocco', 'AF', '+212', 'MAD'),
(121, 'MZ', 'MOZ', 'Mozambique', 'AF', '+258', 'MZN'),
(122, 'MM', 'MMR', 'Myanmar', 'AS', '+95', 'MMK'),
(123, 'NA', 'NAM', 'Namibia', 'AF', '+264', 'NAD'),
(124, 'NR', 'NRU', 'Nauru', 'OC', '+674', 'AUD'),
(125, 'NP', 'NPL', 'Nepal', 'AS', '+977', 'NPR'),
(126, 'NL', 'NLD', 'Netherlands', 'EU', '+31', 'EUR'),
(127, 'NZ', 'NZL', 'New Zealand', 'OC', '+64', 'NZD'),
(128, 'NI', 'NIC', 'Nicaragua', 'NA', '+505', 'NIO'),
(129, 'NE', 'NER', 'Niger', 'AF', '+227', 'XOF'),
(130, 'NG', 'NGA', 'Nigeria', 'AF', '+234', 'NGN'),
(131, 'KP', 'PRK', 'North Korea', 'AS', '+850', 'KPW'),
(132, 'MK', 'MKD', 'North Macedonia', 'EU', '+389', 'MKD'),
(133, 'NO', 'NOR', 'Norway', 'EU', '+47', 'NOK'),
(134, 'OM', 'OMN', 'Oman', 'AS', '+968', 'OMR'),
(135, 'PK', 'PAK', 'Pakistan', 'AS', '+92', 'PKR'),
(136, 'PW', 'PLW', 'Palau', 'OC', '+680', 'USD'),
(137, 'PA', 'PAN', 'Panama', 'NA', '+507', 'PAB'),
(138, 'PG', 'PNG', 'Papua New Guinea', 'OC', '+675', 'PGK'),
(139, 'PY', 'PRY', 'Paraguay', 'SA', '+595', 'PYG'),
(140, 'PE', 'PER', 'Peru', 'SA', '+51', 'PEN'),
(141, 'PH', 'PHL', 'Philippines', 'AS', '+63', 'PHP'),
(142, 'PL', 'POL', 'Poland', 'EU', '+48', 'PLN'),
(143, 'PT', 'PRT', 'Portugal', 'EU', '+351', 'EUR'),
(144, 'QA', 'QAT', 'Qatar', 'AS', '+974', 'QAR'),
(145, 'RO', 'ROU', 'Romania', 'EU', '+40', 'RON'),
(146, 'RU', 'RUS', 'Russia', 'EU', '+7', 'RUB'),
(147, 'RW', 'RWA', 'Rwanda', 'AF', '+250', 'RWF'),
(148, 'WS', 'WSM', 'Samoa', 'OC', '+685', 'WST'),
(149, 'SM', 'SMR', 'San Marino', 'EU', '+378', 'EUR'),
(150, 'ST', 'STP', 'Sao Tome and Principe', 'AF', '+239', 'STN'),
(151, 'SA', 'SAU', 'Saudi Arabia', 'AS', '+966', 'SAR'),
(152, 'SN', 'SEN', 'Senegal', 'AF', '+221', 'XOF'),
(153, 'RS', 'SRB', 'Serbia', 'EU', '+381', 'RSD'),
(154, 'SC', 'SYC', 'Seychelles', 'AF', '+248', 'SCR'),
(155, 'SL', 'SLE', 'Sierra Leone', 'AF', '+232', 'SLL'),
(156, 'SG', 'SGP', 'Singapore', 'AS', '+65', 'SGD'),
(157, 'SK', 'SVK', 'Slovakia', 'EU', '+421', 'EUR'),
(158, 'SI', 'SVN', 'Slovenia', 'EU', '+386', 'EUR'),
(159, 'SB', 'SLB', 'Solomon Islands', 'OC', '+677', 'SBD'),
(160, 'SO', 'SOM', 'Somalia', 'AF', '+252', 'SOS'),
(161, 'ZA', 'ZAF', 'South Africa', 'AF', '+27', 'ZAR'),
(162, 'KR', 'KOR', 'South Korea', 'AS', '+82', 'KRW'),
(163, 'SS', 'SSD', 'South Sudan', 'AF', '+211', 'SSP'),
(164, 'ES', 'ESP', 'Spain', 'EU', '+34', 'EUR'),
(165, 'LK', 'LKA', 'Sri Lanka', 'AS', '+94', 'LKR'),
(166, 'SD', 'SDN', 'Sudan', 'AF', '+249', 'SDG'),
(167, 'SR', 'SUR', 'Suriname', 'SA', '+597', 'SRD'),
(168, 'SE', 'SWE', 'Sweden', 'EU', '+46', 'SEK'),
(169, 'CH', 'CHE', 'Switzerland', 'EU', '+41', 'CHF'),
(170, 'SY', 'SYR', 'Syria', 'AS', '+963', 'SYP'),
(171, 'TW', 'TWN', 'Taiwan', 'AS', '+886', 'TWD'),
(172, 'TJ', 'TJK', 'Tajikistan', 'AS', '+992', 'TJS'),
(173, 'TZ', 'TZA', 'Tanzania', 'AF', '+255', 'TZS'),
(174, 'TH', 'THA', 'Thailand', 'AS', '+66', 'THB'),
(175, 'TL', 'TLS', 'Timor?Leste', 'AS', '+670', 'USD'),
(176, 'TG', 'TGO', 'Togo', 'AF', '+228', 'XOF'),
(177, 'TO', 'TON', 'Tonga', 'OC', '+676', 'TOP'),
(178, 'TT', 'TTO', 'Trinidad and Tobago', 'NA', '+1868', 'TTD'),
(179, 'TN', 'TUN', 'Tunisia', 'AF', '+216', 'TND'),
(180, 'TR', 'TUR', 'Turkey', 'AS', '+90', 'TRY'),
(181, 'TM', 'TKM', 'Turkmenistan', 'AS', '+993', 'TMT'),
(182, 'TV', 'TUV', 'Tuvalu', 'OC', '+688', 'AUD'),
(183, 'UG', 'UGA', 'Uganda', 'AF', '+256', 'UGX'),
(184, 'UA', 'UKR', 'Ukraine', 'EU', '+380', 'UAH'),
(185, 'AE', 'ARE', 'United Arab Emirates', 'AS', '+971', 'AED'),
(186, 'GB', 'GBR', 'United Kingdom', 'EU', '+44', 'GBP'),
(187, 'US', 'USA', 'United States', 'NA', '+1', 'USD'),
(188, 'UY', 'URY', 'Uruguay', 'SA', '+598', 'UYU'),
(189, 'UZ', 'UZB', 'Uzbekistan', 'AS', '+998', 'UZS'),
(190, 'VU', 'VUT', 'Vanuatu', 'OC', '+678', 'VUV'),
(191, 'VA', 'VAT', 'Vatican City', 'EU', '+379', 'EUR'),
(192, 'VE', 'VEN', 'Venezuela', 'SA', '+58', 'VES'),
(193, 'VN', 'VNM', 'Vietnam', 'AS', '+84', 'VND'),
(194, 'YE', 'YEM', 'Yemen', 'AS', '+967', 'YER'),
(195, 'ZM', 'ZMB', 'Zambia', 'AF', '+260', 'ZMW'),
(196, 'ZW', 'ZWE', 'Zimbabwe', 'AF', '+263', 'ZWL');

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `customer_id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(100) NOT NULL,
  `customer_email` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `customer_phone` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `customer_address1` varchar(100) NOT NULL,
  `customer_address2` varchar(100) NOT NULL,
  `customer_address3` varchar(100) NOT NULL,
  `customer_address4` varchar(100) NOT NULL,
  `customer_postcode` varchar(5) NOT NULL,
  `customer_city` varchar(100) NOT NULL,
  `customer_state` varchar(100) NOT NULL,
  `customer_status` tinyint NOT NULL,
  `customer_type_id` int NOT NULL,
  `zone_id` int NOT NULL,
  `area_id` int NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`customer_id`),
  KEY `customer_id` (`customer_id`,`customer_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer_type`
--

CREATE TABLE IF NOT EXISTS `customer_type` (
  `customer_type_id` int NOT NULL AUTO_INCREMENT,
  `customer_type_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `customer_type_desc` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `created_by` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int NOT NULL DEFAULT '0',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`customer_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `file_picker`
--

CREATE TABLE IF NOT EXISTS `file_picker` (
  `id_file_picker` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alt_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nama_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `size` int UNSIGNED NOT NULL,
  `tgl_upload` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `id_user_upload` int UNSIGNED NOT NULL,
  `meta_file` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id_file_picker`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE IF NOT EXISTS `general_settings` (
  `param` varchar(255) NOT NULL,
  `value` tinytext,
  PRIMARY KEY (`param`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`param`, `value`) VALUES
('Allowed_ip', '192.168.0.251,175.139.173.116,2001:e68:6430:5200:4ee8:9032:6752:6a1f,2001:e68:6430:5200:e104:fda7:9f0:325b'),
('ASB_no', ''),
('Baitulmal_no', ''),
('Bank_account_no', '14023010050299'),
('Bank_branch', 'KL Central'),
('Bank_code', 'BIM'),
('Bank_name', 'Bank Islam Malaysia Berhad'),
('Company_address', '28, Jalan Pahang Barat, Off Jalan Pahang, 53000 Kuala Lumpur.'),
('Company_code', '0070000027'),
('Company_email', 'sumbermanusia@harakah.net.my'),
('Company_fax', '03-4021 4055'),
('Company_name', 'Galeri Media Serbanika Sdn. Bhd.'),
('Company_phone', '03-4021 3343'),
('Company_registration', '1084907-V'),
('Company_stamp', 'stamp.png'),
('Document_logo', 'Logo-RedAds-Small.png'),
('email_encryption', 'TLS'),
('email_from', 'sumbermanusia@harakah.net.my'),
('email_google_client_id', ''),
('email_google_client_secret', ''),
('email_google_refresh_token', ''),
('email_google_sender', ''),
('email_port', '587'),
('email_provider', 'standard'),
('email_ses_key', ''),
('email_ses_region', ''),
('email_ses_secret', ''),
('email_ses_sender', ''),
('email_smtp_host', 'smtp.gmail.com'),
('email_smtp_password', 'tghtoduustxxjcap'),
('email_smtp_username', 'sumbermanusia@harakah.net.my'),
('email_support', 'admin@harakah.net.my'),
('Enable_carry_forward', 'Y'),
('Enable_control_access', 'N'),
('End_time', '17:00:00'),
('Epf_no', '020997826'),
('Hajj_leave', '7'),
('Home_branch', 'KL Central'),
('HQ_BLOCK_RADIUS_M', '150'),
('HQ_CIDRS', '169.254.100.206/16, 169.254.201.255/16, 169.254.76.177/16, 192.168.0.251/24'),
('HQ_LAT', '3.1768'),
('HQ_LNG', '101.699'),
('Maternity_leave', '98'),
('Max_carry_forward', '5'),
('Max_replacement_leave', '60'),
('Notification_medical_claim_colection', 'Y'),
('Notification_pending_leave', 'Y'),
('Notification_pending_medical_claim', 'Y'),
('Notification_pending_wfh', 'Y'),
('Notification_tasks', 'Y'),
('Paternity_leave', '7'),
('PTPTN_no', ''),
('Show_dashboard_attendance', 'Y'),
('Show_dashboard_leave', 'Y'),
('Show_dashboard_offday', 'N'),
('Show_dashboard_task', 'N'),
('Show_Offday_Attendance', 'Y'),
('Show_On_Leave_Attendance', 'Y'),
('Show_overlay_camera_desktop', 'N'),
('Show_overlay_camera_mobile', 'Y'),
('Show_WFH_Attendance', 'N'),
('Signatory_name1', 'YB DATUK SERI HAJI TAKIYUDDIN BIN HASSAN'),
('Signatory_name2', 'SHAHZADA MOHAMMAD BIN NISAR AHMAD SALIMI'),
('Signature_img1', 'Sign-Dato-Taki.png'),
('Signature_img2', 'sign-cfo-new.png'),
('Socso_no', 'A3702014143F'),
('Start_time', '09:00:59'),
('Tax_no', 'E9150475109'),
('TH_no', ''),
('Upload_file_max_size', '5120'),
('Upload_file_type', 'jpeg,jpg,gif,png,pdf'),
('Wedding_leave', '7'),
('Zakat_no', '');

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

--
-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id_menu` smallint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_menu` varchar(50) NOT NULL,
  `id_menu_kategori` int UNSIGNED NOT NULL DEFAULT '0',
  `class` varchar(50) DEFAULT NULL,
  `url` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `id_module` smallint UNSIGNED DEFAULT NULL,
  `id_parent` smallint UNSIGNED DEFAULT NULL,
  `aktif` tinyint(1) NOT NULL DEFAULT '1',
  `new` tinyint(1) NOT NULL DEFAULT '0',
  `urut` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_menu`) USING BTREE,
  KEY `menu_module` (`id_module`) USING BTREE,
  KEY `menu_menu` (`id_parent`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=latin1 COMMENT='Tabel menu aplikasi' ROW_FORMAT=COMPACT;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id_menu`, `nama_menu`, `id_menu_kategori`, `class`, `url`, `id_module`, `id_parent`, `aktif`, `new`, `urut`) VALUES
(1, 'User', 1, 'fas fa-users', 'builtin/user', 5, 67, 1, 0, 1),
(2, 'Assign Role', 1, 'fas fa-link', '#', NULL, 67, 1, 0, 5),
(3, 'User Role', 1, 'fas fa-user-tag', 'builtin/user-role', 7, 2, 1, 0, 4),
(4, 'Module', 1, 'fas fa-network-wired', 'builtin/module', 2, 67, 1, 0, 3),
(6, 'Menu', 1, 'fas fa-folder-tree', 'builtin/menu', 1, 67, 1, 0, 2),
(7, 'Menu Role', 1, 'fas fa-folder-minus', 'builtin/menu-role', 8, 2, 1, 0, 2),
(9, 'Role', 1, 'fas fa-briefcase', 'builtin/role', 4, 2, 1, 0, 1),
(10, 'Apps Settings', 1, 'fas fa-cog', 'builtin/setting-app', 16, 67, 1, 0, 6),
(11, 'Layout Settings', 1, 'fas fa-brush', 'builtin/setting-layout', 15, 67, 1, 0, 7),
(23, 'Registration', 6, 'fas fa-user-plus', 'builtin/setting-registrasi', 34, 66, 1, 0, 13),
(36, 'Dashboard', 6, 'fas fa-table', 'dashboard', 46, NULL, 1, 0, 5),
(38, 'Module Permission', 1, 'fas fa-shield-alt', 'builtin/permission', 51, 67, 1, 0, 4),
(39, 'Role Permission', 1, 'far fa-user', 'builtin/role-permission', 52, 2, 1, 0, 3),
(66, 'Bussines Settings', 6, 'fas fa-cogs', '#', NULL, NULL, 1, 0, 31),
(67, 'Apps Settings', 1, 'far fa-sun', '#', NULL, NULL, 1, 0, 1),
(73, 'Backup Database', 1, 'fas fa-server', 'BackupDatabase', 78, 121, 1, 0, 3),
(85, 'Holidays', 6, 'far fa-calendar-days', 'holidays', NULL, 66, 1, 0, 10),
(96, 'General Settings', 6, 'fas fa-sliders', 'builtin/GeneralSettings', 100, 66, 1, 0, 1),
(113, 'My Dashboard', 6, 'fas fa-display', 'DashboardManager', 102, NULL, 1, 0, 2),
(121, 'Tools', 1, 'fas fa-screwdriver-wrench', '#', NULL, NULL, 1, 0, 2),
(175, 'Logs', 1, 'far fa-circle', 'logs', 145, 121, 1, 0, 2),
(176, 'Active Session', 1, 'fas fa-user-shield', 'SessionMonitor', 146, 121, 1, 0, 1),
(196, 'Reports', 6, 'fas fa-chart-line', '#', NULL, NULL, 1, 0, 4);

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

--
-- Table structure for table `menu_kategori`
--

CREATE TABLE IF NOT EXISTS `menu_kategori` (
  `id_menu_kategori` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_kategori` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deskripsi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aktif` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `show_title` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `urut` tinyint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id_menu_kategori`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `menu_kategori`
--

INSERT INTO `menu_kategori` (`id_menu_kategori`, `nama_kategori`, `deskripsi`, `aktif`, `show_title`, `urut`) VALUES
(1, 'Master', '', 'Y', 'Y', 2),
(6, 'Dashboard', '', 'Y', 'Y', 1),
(9, 'Manager', '', 'Y', 'Y', 3);

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

--
-- Table structure for table `menu_role`
--

CREATE TABLE IF NOT EXISTS `menu_role` (
  `id_menu` smallint UNSIGNED NOT NULL,
  `id_role` smallint UNSIGNED NOT NULL,
  KEY `module_role_module` (`id_menu`),
  KEY `module_role_role` (`id_role`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Tabel hak akses dari menu aplikasi' ROW_FORMAT=COMPACT;

--
-- Dumping data for table `menu_role`
--

INSERT INTO `menu_role` (`id_menu`, `id_role`) VALUES
(2, 1),
(2, 5),
(4, 1),
(4, 5),
(38, 1),
(38, 5),
(9, 1),
(9, 5),
(39, 1),
(39, 5),
(3, 1),
(3, 5),
(6, 1),
(6, 5),
(7, 1),
(7, 5),
(66, 1),
(67, 1),
(10, 1),
(10, 5),
(11, 1),
(11, 5),
(23, 1),
(23, 5),
(85, 1),
(1, 1),
(1, 5),
(96, 1),
(36, 1),
(113, 5),
(121, 1),
(73, 1),
(175, 1),
(176, 1),
(196, 1);

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

--
-- Table structure for table `module`
--

CREATE TABLE IF NOT EXISTS `module` (
  `id_module` smallint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_module` varchar(50) DEFAULT NULL,
  `judul_module` varchar(50) DEFAULT NULL,
  `id_module_status` tinyint(1) DEFAULT NULL,
  `login` enum('Y','N','R') NOT NULL DEFAULT 'Y',
  `deskripsi` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id_module`),
  UNIQUE KEY `module_nama` (`nama_module`),
  KEY `module_module_status` (`id_module_status`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1 COMMENT='Tabel modul aplikasi' ROW_FORMAT=DYNAMIC;



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

--
-- Table structure for table `module_permission`
--

CREATE TABLE IF NOT EXISTS `module_permission` (
  `id_module_permission` smallint UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_module` smallint UNSIGNED NOT NULL DEFAULT '0',
  `nama_permission` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `judul_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `keterangan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id_module_permission`) USING BTREE,
  UNIQUE KEY `id_module_nama_permission` (`id_module`,`nama_permission`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=535 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `module_permission`
--

INSERT INTO `module_permission` (`id_module_permission`, `id_module`, `nama_permission`, `judul_permission`, `keterangan`) VALUES
(1, 1, 'create', 'Create Data', 'Access rights to add data'),
(2, 2, 'create', 'Create Data', 'Access rights to add data'),
(4, 4, 'create', 'Create Data', 'Access rights to add data'),
(5, 5, 'create', 'Create Data', 'Access rights to add data'),
(6, 6, 'create', 'Create Data', 'Access rights to add data'),
(7, 7, 'create', 'Create Data', 'Access rights to add data'),
(8, 8, 'create', 'Create Data', 'Access rights to add data'),
(10, 15, 'create', 'Create Data', 'Access rights to add data'),
(11, 16, 'create', 'Create Data', 'Access rights to add data'),
(22, 33, 'create', 'Create Data', 'Access rights to add data'),
(23, 34, 'create', 'Create Data', 'Access rights to add data'),
(24, 35, 'create', 'Create Data', 'Access rights to add data'),
(28, 39, 'create', 'Create Data', 'Access rights to add data'),
(35, 46, 'create', 'Create Data', 'Access rights to add data'),
(37, 51, 'create', 'Create Data', 'Access rights to add data'),
(38, 1, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(39, 2, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(41, 4, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(42, 5, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(43, 6, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(44, 7, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(45, 8, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(47, 15, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(48, 16, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(59, 33, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(60, 34, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(61, 35, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(65, 39, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(72, 46, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(74, 51, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(75, 1, 'update_all', 'Update All Data', 'Access rights to update all data'),
(76, 2, 'update_all', 'Update All Data', 'Access rights to update all data'),
(78, 4, 'update_all', 'Update All Data', 'Access rights to update all data'),
(79, 5, 'update_all', 'Update All Data', 'Access rights to update all data'),
(80, 6, 'update_all', 'Update All Data', 'Access rights to update all data'),
(81, 7, 'update_all', 'Update All Data', 'Access rights to update all data'),
(82, 8, 'update_all', 'Update All Data', 'Access rights to update all data'),
(84, 15, 'update_all', 'Update All Data', 'Access rights to update all data'),
(85, 16, 'update_all', 'Update All Data', 'Access rights to update all data'),
(96, 33, 'update_all', 'Update All Data', 'Access rights to update all data'),
(97, 34, 'update_all', 'Update All Data', 'Access rights to update all data'),
(98, 35, 'update_all', 'Update All Data', 'Access rights to update all data'),
(102, 39, 'update_all', 'Update All Data', 'Access rights to update all data'),
(109, 46, 'update_all', 'Update All Data', 'Access rights to update all data'),
(111, 51, 'update_all', 'Update All Data', 'Access rights to update all data'),
(112, 1, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(113, 2, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(115, 4, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(116, 5, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(117, 6, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(118, 7, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(119, 8, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(121, 15, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(122, 16, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(133, 33, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(134, 34, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(135, 35, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(139, 39, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(146, 46, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(148, 51, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(149, 52, 'read_all', 'Read All Data', 'Access rights to read chartjs data'),
(150, 52, 'create', 'Create Data', 'Access rights to add data'),
(152, 52, 'update_all', 'Update All Data', 'Access rights to update all data'),
(153, 52, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(186, 60, 'create', 'Create Data', 'Access rights to create data'),
(187, 60, 'read_all', 'Read All Data', 'Access rights to read all data'),
(188, 60, 'update_all', 'Update All Data', 'Access rights to update all data'),
(189, 60, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(238, 5, 'read_own', 'Read Own Data', 'Access rights to read own data'),
(239, 5, 'update_own', 'Update Own Data', 'Access rights to update own data'),
(240, 5, 'delete_own', 'Delete Own Data', 'Access rights to delete own data'),
(253, 15, 'read_own', 'Read Own Data', 'Access rights to read own data'),
(254, 15, 'update_own', 'Update Own Data', 'Access rights to update own data'),
(255, 15, 'delete_own', 'Delete Own Data', 'Access rights to delete own data'),
(264, 78, 'create', 'Create Data', 'Access rights to create data'),
(265, 78, 'read_all', 'Read All Data', 'Access rights to read all data'),
(266, 78, 'update_all', 'Update All Data', 'Access rights to update all data'),
(267, 78, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(352, 100, 'create', 'Create Data', 'Access rights to create data'),
(353, 100, 'read_all', 'Read All Data', 'Access rights to read all data'),
(354, 100, 'update_all', 'Update All Data', 'Access rights to update all data'),
(355, 100, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(360, 102, 'create', 'Create Data', 'Access rights to create data'),
(361, 102, 'read_all', 'Read All Data', 'Access rights to read all data'),
(362, 102, 'update_all', 'Update All Data', 'Access rights to update all data'),
(363, 102, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(447, 124, 'create', 'Create Data', 'Access rights to create data'),
(448, 124, 'read_own', 'Read Own Data', 'Access rights to read own data'),
(449, 124, 'update_own', 'Update Own Data', 'Access rights to update own data'),
(450, 124, 'delete_own', 'Delete Own Data', 'Access rights to delete own data'),
(527, 145, 'create', 'Create Data', 'Access rights to create data'),
(528, 145, 'read_all', 'Read All Data', 'Access rights to read all data'),
(529, 145, 'update_all', 'Update All Data', 'Access rights to update all data'),
(530, 145, 'delete_all', 'Delete All Data', 'Access rights to delete all data'),
(531, 146, 'create', 'Create Data', 'Access rights to create data'),
(532, 146, 'read_all', 'Read All Data', 'Access rights to read all data'),
(533, 146, 'update_all', 'Update All Data', 'Access rights to update all data'),
(534, 146, 'delete_all', 'Delete All Data', 'Access rights to delete all data');

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

--
-- Table structure for table `module_status`
--

CREATE TABLE IF NOT EXISTS `module_status` (
  `id_module_status` tinyint(1) NOT NULL AUTO_INCREMENT,
  `nama_status` varchar(50) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_module_status`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COMMENT='Tabel status modul, seperti: aktif, non aktif, dalam perbaikan' ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `module_status`
--

INSERT INTO `module_status` (`id_module_status`, `nama_status`, `keterangan`) VALUES
(1, 'Active', NULL),
(2, 'Inactive', NULL),
(3, 'Development', 'Only the developer role can access modules with this status');

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

--
-- Table structure for table `role`
--

CREATE TABLE IF NOT EXISTS `role` (
  `id_role` smallint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nama_role` varchar(50) NOT NULL,
  `judul_role` varchar(50) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `id_module` smallint UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id_role`),
  UNIQUE KEY `role_nama` (`nama_role`),
  KEY `role_module` (`id_module`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COMMENT='Tabel yang berisi daftar role, role ini mengatur bagaimana user mengakses module, role ini nantinya diassign ke user' ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`id_role`, `nama_role`, `judul_role`, `keterangan`, `id_module`) VALUES
(1, 'admin', 'Administrator', 'Standard administrator access rights', 46),
(5, 'manager', 'Manager', 'Standard manager access rights', 102);

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

--
-- Table structure for table `role_module_permission`
--

CREATE TABLE IF NOT EXISTS `role_module_permission` (
  `id_role` smallint UNSIGNED NOT NULL,
  `id_module_permission` smallint UNSIGNED NOT NULL,
  PRIMARY KEY (`id_role`,`id_module_permission`) USING BTREE,
  KEY `role_permission_permission` (`id_module_permission`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `role_module_permission`
--

INSERT INTO `role_module_permission` (`id_role`, `id_module_permission`) VALUES
(1, 1),
(1, 2),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 10),
(1, 11),
(1, 22),
(1, 23),
(1, 24),
(1, 28),
(1, 35),
(1, 37),
(1, 38),
(1, 39),
(5, 39),
(1, 41),
(5, 41),
(1, 42),
(1, 43),
(5, 43),
(1, 44),
(5, 44),
(1, 45),
(5, 45),
(1, 47),
(5, 47),
(1, 48),
(5, 48),
(1, 59),
(5, 59),
(1, 60),
(5, 60),
(1, 61),
(5, 61),
(1, 65),
(5, 65),
(1, 72),
(5, 72),
(1, 74),
(5, 74),
(1, 75),
(1, 76),
(1, 78),
(1, 79),
(1, 80),
(1, 81),
(1, 82),
(1, 84),
(1, 85),
(1, 96),
(1, 97),
(1, 98),
(1, 102),
(1, 109),
(5, 109),
(1, 111),
(1, 112),
(1, 113),
(1, 115),
(1, 116),
(1, 117),
(1, 118),
(1, 119),
(1, 121),
(1, 122),
(1, 133),
(1, 134),
(1, 135),
(1, 139),
(1, 146),
(5, 146),
(1, 148),
(1, 149),
(5, 149),
(1, 150),
(1, 152),
(1, 153),
(1, 186),
(5, 186),
(1, 187),
(5, 187),
(1, 188),
(5, 188),
(1, 189),
(5, 189),
(1, 238),
(5, 238),
(1, 239),
(5, 239),
(1, 240),
(1, 253),
(5, 253),
(1, 254),
(5, 254),
(1, 255),
(1, 264),
(1, 265),
(5, 265),
(1, 266),
(1, 267),
(1, 352),
(1, 353),
(1, 354),
(1, 355),
(5, 360),
(5, 361),
(5, 362),
(5, 363),
(5, 447),
(5, 448),
(5, 449),
(5, 450),
(1, 527),
(1, 528),
(1, 529),
(1, 530),
(1, 531),
(1, 532),
(1, 533),
(1, 534);

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

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `param` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `value` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`type`,`param`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`type`, `param`, `value`) VALUES
('app', 'background_logo', 'transparent'),
('app', 'btn_login', 'btn-danger'),
('app', 'deskripsi_web', 'your ads mate'),
('app', 'favicon', 'RedAds-Favicon-100x100-01.png'),
('app', 'footer_app', '&copy; {{YEAR}} GMSSB'),
('app', 'footer_login', '&copy; {{YEAR}} GMSSB'),
('app', 'judul_web', 'RedAds'),
('app', 'logo_app', 'Logo-GMS-White.png'),
('app', 'logo_login', 'Logo-RedAds-Small_1.png'),
('app', 'logo_register', 'Logo-RedAds-Small_2.png'),
('invoice', 'footer_text', 'Terima kasih.'),
('invoice', 'jml_digit', '6'),
('invoice', 'logo', 'Logo-GMS-small.png'),
('invoice', 'no_invoice', '{{nomor}}/INV/CO/{{tahun}}'),
('invoice', 'template_invoice', 'template_1'),
('kasir', 'bersihkan_form', 'setelah_cetak_nota'),
('kasir', 'item_layout', 'grid'),
('kasir', 'item_layout_grid_height', '127'),
('kasir', 'item_layout_grid_length', '12'),
('kasir', 'item_layout_grid_show_stok', 'Y'),
('kasir', 'item_layout_grid_width', '160'),
('kasir', 'qty_pengali', 'N'),
('kasir', 'qty_pengali_suffix', 'm'),
('kasir', 'qty_pengali_text', 'Panjang'),
('layout', 'bootswatch_theme', 'spacelab'),
('layout', 'color_scheme', 'blue'),
('layout', 'font_family', 'montserrat'),
('layout', 'font_size', '12.5'),
('layout', 'logo_background_color', 'default'),
('layout', 'sidebar_color', 'light'),
('nota_retur', 'jml_digit', '6'),
('nota_retur', 'no_nota_retur', '{{nomor}}/NR/CO/{{tahun}}'),
('nota_transfer', 'jml_digit', '6'),
('nota_transfer', 'no_nota_transfer', '{{nomor}}/NT/CO/{{tahun}}'),
('pajak', 'display_text', 'Pajak'),
('pajak', 'status', 'non_aktif'),
('pajak', 'tarif', '10'),
('piutang', 'notifikasi_periode', '7'),
('piutang', 'notifikasi_show', 'N'),
('piutang', 'piutang_periode', '30'),
('register', 'enable', 'N'),
('register', 'id_module', '46'),
('register', 'id_role', '7'),
('register', 'metode_aktivasi', 'manual'),
('stok', 'dashboard_show', 'N'),
('stok', 'notifikasi_show', 'N');

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

--
-- Table structure for table `setting_user`
--

CREATE TABLE IF NOT EXISTS `setting_user` (
  `id_user` int UNSIGNED NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT '',
  `param` varchar(255) NOT NULL,
  PRIMARY KEY (`id_user`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `setting_user`
--

INSERT INTO `setting_user` (`id_user`, `type`, `param`) VALUES
(3, 'layout', '{\"color_scheme\":\"purple\",\"sidebar_color\":\"dark\",\"bootswatch_theme\":\"pulse\",\"logo_background_color\":\"dark\",\"font_family\":\"poppins\",\"font_size\":\"14.5\"}'),
(7, 'layout', '{\"color_scheme\":\"blue\",\"sidebar_color\":\"blue\",\"bootswatch_theme\":\"litera\",\"logo_background_color\":\"dark\",\"font_family\":\"montserrat\",\"font_size\":\"13.5\"}'),
(34, 'layout', '{\"color_scheme\":\"blue\",\"sidebar_color\":\"light\",\"bootswatch_theme\":\"cerulean\",\"logo_background_color\":\"dark\",\"font_family\":\"montserrat\",\"font_size\":\"13\"}'),
(81, 'layout', '{\"color_scheme\":\"blue\",\"sidebar_color\":\"light\",\"bootswatch_theme\":\"cosmo\",\"logo_background_color\":\"default\",\"font_family\":\"poppins\",\"font_size\":\"13\"}');

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

--
-- Table structure for table `state`
--

CREATE TABLE IF NOT EXISTS `state` (
  `state_id` varchar(3) NOT NULL,
  `state_name` varchar(40) NOT NULL,
  `state_flag` varchar(50) NOT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`state_id`, `state_name`, `state_flag`) VALUES
('JHR', 'Johor', 'JHR.jpg'),
('KDH', 'Kedah', 'KDH.jpg'),
('KTN', 'Kelantan', 'KTN.jpg'),
('MLK', 'Melaka', 'MLK.jpg'),
('NSN', 'Negeri Sembilan', 'NSN.jpg'),
('PHG', 'Pahang', 'PHG.jpg'),
('PLS', 'Perlis', 'PLS.jpg'),
('PNG', 'Pulau Pinang', 'PNG.jpg'),
('PRK', 'Perak', 'PRK.jpg'),
('SBH', 'Sabah', 'SBH.jpg'),
('SGR', 'Selangor', 'SGR.jpg'),
('SWK', 'Sarawak', 'SWK.jpg'),
('TRG', 'Terengganu', 'TRG.jpg'),
('WKL', 'WP Kuala Lumpur', 'WKL.jpg'),
('WLB', 'WP Labuan', 'WLB.jpg'),
('WPJ', 'WP Putrajaya', 'WPJ.jpg');

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

--
-- Table structure for table `user_login_activity`
--

CREATE TABLE IF NOT EXISTS `user_login_activity` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_user` int UNSIGNED NOT NULL,
  `id_activity` tinyint UNSIGNED DEFAULT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `user_login_activity_user` (`id_user`),
  KEY `fk_ula_activity` (`id_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `user_login_activity_ref`
--

CREATE TABLE IF NOT EXISTS `user_login_activity_ref` (
  `id_activity` tinyint UNSIGNED NOT NULL AUTO_INCREMENT,
  `value` varchar(50) NOT NULL,
  PRIMARY KEY (`id_activity`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_login_activity_ref`
--

INSERT INTO `user_login_activity_ref` (`id_activity`, `value`) VALUES
(1, 'login'),
(2, 'logout'),
(3, 'failed_login'),
(4, 'logout_by_timeout');

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

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
  `id` smallint UNSIGNED NOT NULL AUTO_INCREMENT,
  `id_user` int UNSIGNED NOT NULL,
  `id_role` smallint UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `module_role_module` (`id_user`),
  KEY `module_role_role` (`id_role`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=latin1 COMMENT='Tabel yang berisi role yang dimili oleh masing masing user' ROW_FORMAT=COMPACT;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`id`, `id_user`, `id_role`) VALUES
(1, 1, 1),
(102, 2, 5);

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

--
-- Table structure for table `user_role_ori`
--

CREATE TABLE IF NOT EXISTS `user_role_ori` (
  `id_user` int UNSIGNED NOT NULL,
  `id_role` smallint UNSIGNED NOT NULL,
  PRIMARY KEY (`id_user`,`id_role`),
  KEY `module_role_module` (`id_user`),
  KEY `module_role_role` (`id_role`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Tabel yang berisi role yang dimili oleh masing masing user' ROW_FORMAT=COMPACT;

--
-- Dumping data for table `user_role_ori`
--

INSERT INTO `user_role_ori` (`id_user`, `id_role`) VALUES
(1, 1),
(2, 7);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `menu`
--
ALTER TABLE `menu`
  ADD CONSTRAINT `menu_menu` FOREIGN KEY (`id_parent`) REFERENCES `menu` (`id_menu`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `menu_module` FOREIGN KEY (`id_module`) REFERENCES `module` (`id_module`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `menu_role`
--
ALTER TABLE `menu_role`
  ADD CONSTRAINT `menu_role_menu` FOREIGN KEY (`id_menu`) REFERENCES `menu` (`id_menu`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `menu_role_role` FOREIGN KEY (`id_role`) REFERENCES `role` (`id_role`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `module`
--
ALTER TABLE `module`
  ADD CONSTRAINT `module_module_status` FOREIGN KEY (`id_module_status`) REFERENCES `module_status` (`id_module_status`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `module_permission`
--
ALTER TABLE `module_permission`
  ADD CONSTRAINT `module_permission_module` FOREIGN KEY (`id_module`) REFERENCES `module` (`id_module`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `role`
--
ALTER TABLE `role`
  ADD CONSTRAINT `role_module` FOREIGN KEY (`id_module`) REFERENCES `module` (`id_module`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `role_module_permission`
--
ALTER TABLE `role_module_permission`
  ADD CONSTRAINT `role_module_permission_module_permission` FOREIGN KEY (`id_module_permission`) REFERENCES `module_permission` (`id_module_permission`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `role_module_permission_role` FOREIGN KEY (`id_role`) REFERENCES `role` (`id_role`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_login_activity`
--
ALTER TABLE `user_login_activity`
  ADD CONSTRAINT `fk_ula_activity` FOREIGN KEY (`id_activity`) REFERENCES `user_login_activity_ref` (`id_activity`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `user_login_activity_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_role`
--
ALTER TABLE `user_role`
  ADD CONSTRAINT `fk_userrole_role` FOREIGN KEY (`id_role`) REFERENCES `role` (`id_role`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_userrole_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_role_ori`
--
ALTER TABLE `user_role_ori`
  ADD CONSTRAINT `user_role_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

