text: /*
   Navicat Premium Data Transfer
  
   Source Server         : local
   Source Server Type    : MySQL
   Source Server Version : 100420
   Source Host           : localhost:3306
   Source Schema         : dbasuransi
  
   Target Server Type    : MySQL
   Target Server Version : 100420
   File Encoding         : 65001
  
   Date: 27/08/2021 13:24:23
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for members
  -- ----------------------------
  DROP TABLE IF EXISTS `members`;
  CREATE TABLE `members`  (
    `memberid` int NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `identitynumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`memberid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of members
  -- ----------------------------
  INSERT INTO `members` VALUES (2, 'Tanjung Mirza Savana', '002', 'Jalan Cigugur Cimahi', '085220304568');
  INSERT INTO `members` VALUES (3, 'Dina Marsha', '324549684512155', 'Lembang - Kabupaten Bandung Barat', '08579826526595');
  
  -- ----------------------------
  -- Table structure for packages
  -- ----------------------------
  DROP TABLE IF EXISTS `packages`;
  CREATE TABLE `packages`  (
    `packageid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `price` decimal(10, 0) NULL DEFAULT NULL,
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `status` int NULL DEFAULT 1,
    PRIMARY KEY (`packageid`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of packages
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for registrations
  -- ----------------------------
  DROP TABLE IF EXISTS `registrations`;
  CREATE TABLE `registrations`  (
    `registrationid` int NOT NULL,
    `registrationdatetime` datetime NULL DEFAULT current_timestamp,
    `expireddate` date NULL DEFAULT NULL,
    `memberid` int NULL DEFAULT NULL,
    `packageid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `grandtotal` decimal(10, 0) NULL DEFAULT NULL,
    `createdby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`registrationid`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of registrations
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for users
  -- ----------------------------
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users`  (
    `userid` int NOT NULL AUTO_INCREMENT,
    `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`userid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of users
  -- ----------------------------
  INSERT INTO `users` VALUES (1, 'adhimas', '$2y$10$6q.Kt/n/9JKKsDzJ/UTcCekYKicWpTQPSLJ1KSQJYBaqGaNhEw6Vm', 'Adhimas Wisnuyudo', 'Admin');
  INSERT INTO `users` VALUES (2, 'asep', '$2y$10$cjhibj2p5vND5Grrx3B/KeEvsHrgBpwTzfvr6l/sne3BrFSlKlc46', 'Asep Subagdja', 'User');
  
  SET FOREIGN_KEY_CHECKS = 1;
  