rFdabSP9

1/*
2Navicat MariaDB Data Transfer
3
4Source Server         : local
5Source Server Version : 100130
6Source Host           : localhost:3306
7Source Database       : transaksi
8
9Target Server Type    : MariaDB
10Target Server Version : 100130
11File Encoding         : 65001
12
13Date: 2018-02-12 13:56:31
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for barang
20-- ----------------------------
21DROP TABLE IF EXISTS `barang`;
22CREATE TABLE `barang` (
23  `id_barang` tinyint(4) NOT NULL AUTO_INCREMENT,
24  `kode_kategori` varchar(255) DEFAULT NULL,
25  `nama_barang` varchar(255) DEFAULT NULL,
26  `harga` int(11) DEFAULT NULL,
27  PRIMARY KEY (`id_barang`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30-- ----------------------------
31-- Records of barang
32-- ----------------------------
33
34-- ----------------------------
35-- Table structure for kode_kategori
36-- ----------------------------
37DROP TABLE IF EXISTS `kode_kategori`;
38CREATE TABLE `kode_kategori` (
39  `kode_kategori` varchar(255) NOT NULL,
40  `nama_kategori` varchar(255) DEFAULT NULL,
41  PRIMARY KEY (`kode_kategori`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44-- ----------------------------
45-- Records of kode_kategori
46-- ----------------------------
47SET FOREIGN_KEY_CHECKS=1;