/*
Navicat MySQL Data Transfer

Source Server         : Local Database
Source Server Version : 100424
Source Host           : localhost:3306
Source Database       : regional_db

Target Server Type    : MYSQL
Target Server Version : 100424
File Encoding         : 65001

Date: 2023-09-30 13:27:41
*/


-- ----------------------------
-- Table structure for amscountry
-- ----------------------------
CREATE TABLE `amscountry` (
  `AMSCountryID` int(10) NOT NULL AUTO_INCREMENT,
  `C_Code` varchar(4) DEFAULT NULL,
  `ISO_Code` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Note` varchar(50) DEFAULT NULL,
  `ABB` varchar(10) DEFAULT NULL,
  `AMSCentroid` varchar(30) DEFAULT NULL,
  `AMSNPAMap` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`AMSCountryID`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of amscountry
-- ----------------------------
INSERT INTO `amscountry` VALUES ('1', '096', 'BN', 'Brunei Darussalam', 'Brunei Darussalam', 'BRN', '114.609272;4.448288', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/bn_npa.kml');
INSERT INTO `amscountry` VALUES ('2', '360', 'ID', 'Indonesia', 'Indonesia', 'IDN', '120.159152;-3.015062', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/id_npa.kmz');
INSERT INTO `amscountry` VALUES ('4', '116', 'KH', 'Cambodia', 'Cambodia', 'KHM', '105.112789;12.669789', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/kh_npa.kml');
INSERT INTO `amscountry` VALUES ('6', '418', 'LA', 'Laos', 'Lao People\'s Dem. Rep.', 'LAO', '102.414613;19.776164', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/la_npa.kml');
INSERT INTO `amscountry` VALUES ('7', '458', 'MY', 'Malaysia', 'Malaysia', 'MYS', '101.771388;4.22886', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/my_npa.kml');
INSERT INTO `amscountry` VALUES ('8', '104', 'MM', 'Myanmar', 'Myanmar', 'MMR', '95.513576;21.628667', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/mm_npa.kml');
INSERT INTO `amscountry` VALUES ('9', '608', 'PH', 'Philippines', 'Philippines', 'PHL', '122.984022;12.565959', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/ph_npa.kmz');
INSERT INTO `amscountry` VALUES ('10', '702', 'SG', 'Singapore', 'Singapore', 'SGP', '103.83822;1.262994', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/sg_npa.kml');
INSERT INTO `amscountry` VALUES ('11', '764', 'TH', 'Thailand', 'Thailand', 'THA', '101.29079;15.897228', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/th_npa.kml');
INSERT INTO `amscountry` VALUES ('13', '704', 'VN', 'Viet Nam', 'Viet Nam', 'VNM', '108.824229;14.260645', 'http://bim.aseanbiodiversity.org/biss/kml/pa/paByCountry/vn_npa.kml');

-- ----------------------------
-- Table structure for system_settings
-- ----------------------------
CREATE TABLE `system_settings` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `email` varchar(200) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `cover_img` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of system_settings
-- ----------------------------
INSERT INTO `system_settings` VALUES ('1', 'Regional Dashboard', 'evan.reblora@gmai.com', '+63 9566643437', 'LB', '');

-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE `users` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `prefix` varchar(15) NOT NULL,
  `firstname` varchar(200) NOT NULL,
  `lastname` varchar(200) NOT NULL,
  `position` varchar(255) NOT NULL,
  `email` varchar(200) NOT NULL,
  `alternate_email` varchar(255) NOT NULL,
  `username` varchar(14) NOT NULL,
  `password` text NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = admin, 2 = staff',
  `gender` varchar(200) NOT NULL,
  `address` varchar(255) NOT NULL,
  `contactno` varchar(255) CHARACTER SET latin1 NOT NULL,
  `mobileno` varchar(255) CHARACTER SET latin1 NOT NULL,
  `faxno` varchar(255) CHARACTER SET latin1 NOT NULL,
  `country` varchar(255) NOT NULL,
  `organisation` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `avatar` text NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', '', 'Administrator', '', '', 'admin@admin.com', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1', '', '', '0', '0', '0', '', '', '', 'no-image-available.png', '2020-11-26 10:57:04');
INSERT INTO `users` VALUES ('2', '', 'Riley', 'Reblora', '', 'riley@gmail.com', '', 'riley', '827ccb0eea8a706c4c34a16891f84e7b ', '2', '', '', '0', '0', '0', '', '', '', '1606978560_avatar.jpg', '2020-12-03 09:26:03');
INSERT INTO `users` VALUES ('3', '', 'Zoey', 'Reblora', '', 'zoey@gmail.com', '', 'zoey', '9ba162296e5b2552da7cacdb69956bc7', '3', '', '', '0', '0', '0', '', '', '', '1606958760_47446233-clean-noir-et-gradient-sombre-image-de-fond-abstrait-.jpg', '2020-12-03 09:26:42');
INSERT INTO `users` VALUES ('36', '', 'brunei01', 'brunei01', 'brunei01', '', '', 'brunei01', 'edb349bc0f780870e0ccb0d06d440f49', '3', '', '', '', '', '', 'Brunei Darussalam', '', '', '', '2022-09-06 11:12:20');
INSERT INTO `users` VALUES ('37', '', 'brunei02', 'brunei02', 'brunei02', 'brunei02@gmail.com', '', 'brunei02', '5a385a3e4544ec41c6734079302b831f', '3', '', '', '', '', '', 'Brunei Darussalam', '', '', '', '2022-09-06 11:37:00');
INSERT INTO `users` VALUES ('38', '', 'Dian Indah', 'Pratiwi', 'indonesia01', 'dian916@gmail.com', '', 'indonesia01', 'a6973aab24a60123f98bb21261d6f6de', '3', '', '', '', '', '', 'Indonesia', '', '', '1663738320_DSC00009.JPG', '2022-09-06 11:40:58');
INSERT INTO `users` VALUES ('39', '', 'indonesia02', 'indonesia02', 'indonesia02', 'indonesia02@indonesia02', '', 'indonesia02', '98cc93558d56af1f82eb6c99134ed342', '3', '', '', '', '', '', 'Brunei Darussalam', '', '', '', '2022-09-06 11:42:52');
INSERT INTO `users` VALUES ('40', '', 'cambodia01', 'cambodia01', 'cambodia01', 'cambodia01@cambodia01', '', 'cambodia01', '6d3524bc90fea95aeff7fe6c7abfd2b8', '3', '', '', '', '', '', 'Cambodia', '', '', '', '2022-09-06 11:43:54');
INSERT INTO `users` VALUES ('41', '', 'cambodia02', 'cambodia02', 'cambodia02', 'cambodia02@cambodia02', '', 'cambodia02', 'a17cae6ad3e333eafdc0da0132a970b1', '3', '', '', '', '', '', 'Cambodia', '', '', '', '2022-09-06 11:44:17');
INSERT INTO `users` VALUES ('42', '', 'laopdr01', 'laopdr01', 'laopdr01', 'laopdr01@laopdr01', '', 'laopdr01', 'c0ac72ed2f3386d1de34f39cf298b503', '3', '', '', '', '', '', 'Laos', '', '', '', '2022-09-06 11:44:51');
INSERT INTO `users` VALUES ('43', '', 'laopdr02', 'laopdr02', 'laopdr02', 'laopdr02@laopdr02', '', 'laopdr02', 'e779c97b5adb56079fb6f345d131ea48', '3', '', '', '', '', '', 'Laos', '', '', '', '2022-09-06 11:45:09');
INSERT INTO `users` VALUES ('44', '', 'malaysia01', 'malaysia01', 'malaysia01', 'malaysia01@malaysia01', '', 'malaysia01', '28fba9c0ac1efb8a52d76247fba65d78', '3', '', '', '', '', '', 'Malaysia', '', '', '', '2022-09-06 11:45:41');
INSERT INTO `users` VALUES ('45', '', 'malaysia02', 'malaysia02', 'malaysia02', 'malaysia02@malaysia02', '', 'malaysia02', 'cd06ab26edfa538d8835252362a547e6', '3', '', '', '', '', '', 'Malaysia', '', '', '', '2022-09-06 11:46:00');
INSERT INTO `users` VALUES ('46', '', 'myanmar01', 'myanmar01', 'myanmar01', 'myanmar01@myanmar01', '', 'myanmar01', 'c206b8c60dfa1060d727dca0e9ca4d9d', '3', '', '', '', '', '', 'Myanmar', '', '', '', '2022-09-06 11:48:03');
INSERT INTO `users` VALUES ('47', '', 'myanmar02', 'myanmar02', 'myanmar02', 'myanmar02@myanmar02', '', 'myanmar02', '4f23d24e603eeb734ac40f7bc7f55a04', '3', '', '', '', '', '', 'Myanmar', '', '', '', '2022-09-06 11:48:18');
INSERT INTO `users` VALUES ('48', '', 'philippines01', 'philippines01', 'philippines01', 'philippines01@philippines01', '', 'philippines01', '21b01b2dbc178c9a830b40b8367d5b0c', '3', '', '', '', '', '', 'Philippines', '', '', '', '2022-09-06 11:48:40');
INSERT INTO `users` VALUES ('49', '', 'philippines02', 'philippines02', 'philippines02', 'philippines02@philippines02', '', 'philippines02', 'a0f8beb6ee87c41fb5ce35fa137fe9eb', '3', '', '', '', '', '', 'Philippines', '', '', '', '2022-09-06 11:49:04');
INSERT INTO `users` VALUES ('50', '', 'singapore01', 'singapore01', 'singapore01', 'singapore01@singapore01', '', 'singapore01', '21e80f3a2dda770e097582a9d111cac2', '3', '', '', '', '', '', 'Singapore', '', '', '', '2022-09-06 11:50:04');
INSERT INTO `users` VALUES ('51', '', 'singapore02', 'singapore02', 'singapore02', 'singapore02@singapore02', '', 'singapore02', '9f331834f4e3be1a407d2e1f0a59c991', '3', '', '', '', '', '', 'Singapore', '', '', '', '2022-09-06 11:50:21');
INSERT INTO `users` VALUES ('52', '', 'thailand01', 'thailand01', 'thailand01', 'thailand01@thailand01', '', 'thailand01', 'b386842c7bcc09cf474781e694df4f62', '3', '', '', '', '', '', 'Thailand', '', '', '', '2022-09-06 11:50:50');
INSERT INTO `users` VALUES ('53', '', 'thailand02', 'thailand02', 'thailand02', 'thailand02@thailand02', '', 'thailand02', '17401f173c0a8508b18bf86ea8b68697', '3', '', '', '', '', '', 'Thailand', '', '', '', '2022-09-06 11:52:19');
INSERT INTO `users` VALUES ('54', '', 'thailand03', 'thailand03', 'thailand03', 'thailand03@thailand03', '', 'thailand03', 'e4615162fab6eae597e286648aa8c2be', '3', '', '', '', '', '', 'Thailand', '', '', '', '2022-09-06 11:52:39');
INSERT INTO `users` VALUES ('55', '', 'thailand04', 'thailand04', 'thailand04', 'thailand04@thailand04', '', 'thailand04', '09a4a04038e9f80fe441a06d64c4e68e', '3', '', '', '', '', '', 'Thailand', '', '', '', '2022-09-06 11:52:55');
INSERT INTO `users` VALUES ('56', '', 'thailand05', 'thailand05', 'thailand05', 'thailand05@thailand05', '', 'thailand05', '0757f4bb62c0fe1f62f3c1e2eb752089', '3', '', '', '', '', '', 'Thailand', '', '', '', '2022-09-06 11:53:11');
INSERT INTO `users` VALUES ('57', '', 'vietnam01', 'vietnam01', 'vietnam01', 'vietnam01@vietnam01', '', 'vietnam01', 'ffdc940b34520c7e1a0fd3554245ddba', '3', '', '', '', '', '', 'Thailand', '', '', '', '2022-09-06 11:53:27');
INSERT INTO `users` VALUES ('58', '', 'vietnam02', 'vietnam02', 'vietnam02', 'vietnam02@vietnam02', '', 'vietnam02', '64a9bb06b69f234e1ed91a6c729aea3d', '3', '', '', '', '', '', 'Viet Nam', '', '', '', '2022-09-06 11:53:45');
INSERT INTO `users` VALUES ('59', '', 'Nur ', 'Rahmah', 'PEH', 'nurrahmahnunu@gmail.com', 'tn.babul@gmail.com', 'indonesia10', '544a2f00490178ff52f00c5ab4f5aa33', '3', '', 'Maros, Indonesia', '+6285395419289', '+6285395419289', '-', 'Indonesia', 'Bantimurung Bulusaraung National Park', '-', '', '2022-09-21 13:30:22');
INSERT INTO `users` VALUES ('60', 'Mr.', 'Alfian Fandi', 'Nugroho', 'Staff', 'alfianponky@gmail.com', 'bbtngl.pemanfaatan.pelayanan@gmail.com', '18Ganesha', '2f009e5df57b4b5f27dfa4bc7840ba9d', '3', '', 'Jl. Selamat No 137, Kel. Sitirejo III, Medan Amplas, Medan', '+6281228855032', '+6281228855032', '', 'Indonesia', 'Gunung Leuser National Park', '', '1663740420_30221708_1844219348950763_1078515340847087616_n.jpg', '2022-09-21 14:07:55');
INSERT INTO `users` VALUES ('61', 'rhaw', 'Rodzay', 'Haji Abdul Wahab', 'Lecturer', 'rodzay.wahab@ubd.edu.bn', 'rodzay@gmail.com', 'rodzay', '23fdb592aa4be3f8c2c4f8c194a3ad7e', '3', '', '', '', '', '', 'Brunei Darussalam', 'Universiti Brnei Darussalam', 'iber.ubd.edu.bn', '', '2022-09-21 14:12:15');
INSERT INTO `users` VALUES ('62', '', 'Ari', 'Iswandari', 'Staff', 'wandatngl@gmail.com', '', 'GNLP', '1f968b714d9e77efce06e3cc47e51e8d', '3', '', '', '', '', '', '', 'Gunung Leuser National Park', '', '', '2022-09-21 16:30:20');
INSERT INTO `users` VALUES ('63', 'Mrs.', 'Hastuty', 'Hastuty', 'Ecosystem Control Officier', 'labyboo@gmail.com', '', 'Indonesia01', '64ec3a1115791e97ad528940b723b9e7', '3', '', 'Baubau City, Southeast Sulawesi Province', '085242675076', '', '', 'Indonesia', 'Wakatobi National Park', '', '', '2022-09-22 13:07:34');
