/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 100129
 Source Host           : localhost:3306
 Source Schema         : mbi

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

 Date: 25/05/2018 03:20:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sv_stok_in
-- ----------------------------
DROP TABLE IF EXISTS `sv_stok_in`;
CREATE TABLE `sv_stok_in` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) DEFAULT NULL,
  `brand` varchar(50) DEFAULT NULL,
  `jenis_produk` varchar(50) DEFAULT NULL,
  `produk` varchar(50) DEFAULT NULL,
  `total` bigint(100) DEFAULT NULL,
  `tgl` date DEFAULT NULL,
  `exp` date DEFAULT NULL,
  `gudang` varchar(50) DEFAULT NULL,
  `param` enum('in','out') DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `modify_on` datetime DEFAULT NULL,
  `modify_by` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for sv_ref_exp
-- ----------------------------
DROP TABLE IF EXISTS `sv_ref_exp`;
CREATE TABLE `sv_ref_exp` (
  `id` bigint(100) NOT NULL AUTO_INCREMENT,
  `produk` varchar(50) DEFAULT NULL,
  `tgl` date DEFAULT NULL,
  `create_user_id` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `modify_user_id` varchar(50) DEFAULT NULL,
  `modify_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for sv_master_gudang
-- ----------------------------
DROP TABLE IF EXISTS `sv_master_gudang`;
CREATE TABLE `sv_master_gudang` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `lokasi` text,
  `create_date` datetime DEFAULT NULL,
  `create_user_id` varchar(50) DEFAULT NULL,
  `modify_date` datetime DEFAULT NULL,
  `modify_user_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for sv_ref_min_stok
-- ----------------------------
DROP TABLE IF EXISTS `sv_ref_min_stok`;
CREATE TABLE `sv_ref_min_stok` (
  `id` bigint(100) NOT NULL AUTO_INCREMENT,
  `produk` varchar(50) DEFAULT NULL,
  `min_stok` bigint(100) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `create_user_id` varchar(50) DEFAULT NULL,
  `modify_date` datetime DEFAULT NULL,
  `modify_user_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

SET FOREIGN_KEY_CHECKS = 1;
