/*
SQLyog Community Edition- MySQL GUI v5.29
Host - 5.1.41 : Database - mhs
*********************************************************************
Server version : 5.1.41
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `mhs`;

USE `mhs`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `tbdetiltrxpendaftaran` */

DROP TABLE IF EXISTS `tbdetiltrxpendaftaran`;

CREATE TABLE `tbdetiltrxpendaftaran` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NoTRX` varchar(20) DEFAULT NULL,
  `idTemplate` varchar(20) DEFAULT NULL,
  `jumlah` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;

/*Data for the table `tbdetiltrxpendaftaran` */

insert  into `tbdetiltrxpendaftaran`(`id`,`NoTRX`,`idTemplate`,`jumlah`) values (56,'16030001','33',350000),(57,'16030002','19',250000),(58,'16030002','17',500000),(59,'16030002','18',250000),(60,'16030003','22',1995000),(61,'16030003','21',1600000),(62,'16030003','20',2000000),(63,'16030004','16',1000000);

/*Table structure for table `tbmastertrxpendaftaran` */

DROP TABLE IF EXISTS `tbmastertrxpendaftaran`;

CREATE TABLE `tbmastertrxpendaftaran` (
  `NoTRX` varchar(20) NOT NULL,
  `tglInput` date DEFAULT NULL,
  `noPendaftaran` varchar(50) DEFAULT NULL,
  `total` bigint(20) DEFAULT NULL,
  `idGrup` varchar(20) DEFAULT NULL,
  `idOperator` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`NoTRX`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tbmastertrxpendaftaran` */

insert  into `tbmastertrxpendaftaran`(`NoTRX`,`tglInput`,`noPendaftaran`,`total`,`idGrup`,`idOperator`) values ('16030001','2016-03-22','160001',350000,'G0015','1'),('16030002','2016-03-22','160001',1000000,'G0012','1'),('16030003','2016-03-22','160001',5595000,'G0013','1'),('16030004','2016-03-22','160001',1000000,'G0014','1');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
