/*
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', '');
