/*
 Navicat Premium Data Transfer

 Source Server         : bidkesmapta.com
 Source Server Type    : MySQL
 Source Server Version : 100322
 Source Host           : bidkesmapta.com:4981
 Source Schema         : dokkes_db

 Target Server Type    : MySQL
 Target Server Version : 100322
 File Encoding         : 65001

 Date: 29/03/2020 13:26:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bulan
-- ----------------------------
DROP TABLE IF EXISTS `bulan`;
CREATE TABLE `bulan`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bulan` varchar(14) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bulan
-- ----------------------------
INSERT INTO `bulan` VALUES (1, 'Januari');
INSERT INTO `bulan` VALUES (2, 'Februari');
INSERT INTO `bulan` VALUES (3, 'Maret');
INSERT INTO `bulan` VALUES (4, 'April');
INSERT INTO `bulan` VALUES (5, 'Mei');
INSERT INTO `bulan` VALUES (6, 'Juni');
INSERT INTO `bulan` VALUES (7, 'Juli');
INSERT INTO `bulan` VALUES (8, 'Agustus');
INSERT INTO `bulan` VALUES (9, 'September');
INSERT INTO `bulan` VALUES (10, 'Oktober');
INSERT INTO `bulan` VALUES (11, 'November');
INSERT INTO `bulan` VALUES (12, 'Desember');

-- ----------------------------
-- Table structure for hari
-- ----------------------------
DROP TABLE IF EXISTS `hari`;
CREATE TABLE `hari`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hari` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `kode` char(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `english` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 8 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hari
-- ----------------------------
INSERT INTO `hari` VALUES (1, 'Senin', 'SEN', 'Monday');
INSERT INTO `hari` VALUES (2, 'Selasa', 'SEL', 'Tuesday');
INSERT INTO `hari` VALUES (3, 'Rabu', 'RAB', 'Wednesday');
INSERT INTO `hari` VALUES (4, 'Kamis', 'KAM', 'Thursday');
INSERT INTO `hari` VALUES (5, 'Jumat', 'JUM', 'Friday');
INSERT INTO `hari` VALUES (6, 'Sabtu', 'SAB', 'Saturday');
INSERT INTO `hari` VALUES (7, 'Minggu', 'MIN', 'Sunday');

SET FOREIGN_KEY_CHECKS = 1;