KfHh7JpG

1CREATE TABLE `produksi` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `tgl` date NOT NULL,
4  `id_truck` int(11) NOT NULL,
5  `id_lokasi_muat` int(11) NOT NULL,
6  `id_lokasi_bongkar` int(11) NOT NULL,
7  `id_jenis_muatan` int(11) NOT NULL,
8  `id_vendor_solar` int(100) NOT NULL,
9  `shift` int(11) NOT NULL,
10  `ret` int(11) NOT NULL,
11  `muatan_ton` float NOT NULL,
12  `isi_solar` enum('Ya','Tidak') NOT NULL,
13  `jml_solar` int(11) NOT NULL,
14  `jam_m` time NOT NULL,
15  `jam_b` time NOT NULL,
16  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
17  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
18  `id_user` int(11) NOT NULL,
19  PRIMARY KEY (`id`)
20) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
21
22-- ----------------------------
23-- Records of produksi
24-- ----------------------------
25INSERT INTO `produksi` VALUES ('1', '2016-08-23', '1', '1', '1', '3', '1', '1', '1', '25.99', 'Ya', '80', '07:19:03', '09:19:09', '2016-08-26 11:19:16', '2016-08-30 14:02:26', '2');
26INSERT INTO `produksi` VALUES ('2', '2016-08-23', '1', '1', '1', '1', '1', '1', '2', '26.17', 'Ya', '80', '11:32:15', '16:32:15', '2016-08-28 11:35:06', '2016-08-30 14:02:36', '2');
27INSERT INTO `produksi` VALUES ('3', '2016-08-24', '1', '3', '2', '3', '1', '2', '1', '25.37', 'Ya', '80', '23:06:15', '03:06:15', '2016-08-28 23:07:45', '2016-08-30 14:02:48', '2');
28INSERT INTO `produksi` VALUES ('4', '2016-08-25', '2', '3', '2', '2', '1', '2', '2', '27.28', 'Ya', '80', '00:36:45', '02:36:45', '2016-08-29 00:38:34', '2016-08-30 14:02:09', '2');
29INSERT INTO `produksi` VALUES ('5', '2016-08-25', '2', '1', '2', '1', '1', '1', '1', '26.86', 'Ya', '80', '16:43:15', '18:43:15', '2016-08-29 16:45:20', '2016-08-31 14:13:17', '2');
30INSERT INTO `produksi` VALUES ('6', '2016-08-26', '3', '2', '1', '1', '1', '1', '1', '26.83', 'Ya', '80', '18:45:30', '20:45:30', '2016-08-29 16:46:05', '2016-08-31 14:13:21', '2');
31INSERT INTO `produksi` VALUES ('7', '2016-08-26', '3', '2', '2', '2', '1', '1', '1', '27.4', 'Ya', '80', '11:57:00', '12:57:00', '2016-08-30 12:00:10', '2016-08-31 14:13:26', '2');
32INSERT INTO `produksi` VALUES ('8', '2016-08-27', '3', '2', '2', '1', '1', '1', '1', '26.44', 'Ya', '80', '12:57:00', '15:57:00', '2016-08-30 12:01:20', '2016-08-31 14:13:43', '2');
33
34-- ----------------------------
35-- Table structure for truck
36-- ----------------------------
37DROP TABLE IF EXISTS `truck`;
38CREATE TABLE `truck` (
39  `id` int(11) NOT NULL AUTO_INCREMENT,
40  `kd_dt` varchar(10) NOT NULL,
41  `no_polisi` varchar(10) NOT NULL,
42  `merk` varchar(30) DEFAULT NULL,
43  `model` varchar(50) DEFAULT NULL,
44  `no_rangka` varchar(35) DEFAULT NULL,
45  `no_mesin` varchar(35) DEFAULT NULL,
46  `tgl_stnk` date DEFAULT NULL,
47  `thn_pembuatan` int(4) DEFAULT NULL,
48  `created_at` timestamp NULL DEFAULT NULL,
49  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
50  `id_user` int(11) NOT NULL,
51  PRIMARY KEY (`id`)
52) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
53
54-- ----------------------------
55-- Records of truck
56-- ----------------------------
57INSERT INTO `truck` VALUES ('1', '001', 'DD 9895 XT', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKD JM37663', 'JO8E UF J52553 BABBBB', '2016-08-26', '2000', '2016-08-25 20:21:26', '2016-08-26 07:49:15', '2');
58INSERT INTO `truck` VALUES ('2', '002', 'DD 9660 XS', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKD JM38144', 'JO8E UF J53986 AAAABB', '2000-01-01', '2000', '2016-08-25 20:22:16', '2016-08-26 07:43:03', '2');
59INSERT INTO `truck` VALUES ('3', '003', 'DD 9661 XS', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKDJM37901', 'JO8E UF J53403 BBBBBB', '2000-01-01', '2000', '2016-08-25 20:22:18', '2016-08-26 07:43:06', '2');
60INSERT INTO `truck` VALUES ('4', '004', 'DD 9662 XS', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKDJM38146', 'JO8E UF J53988 AAAAAA', '2000-01-01', '2000', '2016-08-25 20:22:20', '2016-08-26 07:43:09', '2');
61INSERT INTO `truck` VALUES ('5', '005', 'DD 8978 XK', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKEJM41066', 'JO8E UF J59714', '2000-01-01', '2000', '2016-08-25 20:22:23', '2016-08-26 07:43:12', '2');
62INSERT INTO `truck` VALUES ('6', '006', 'DD 9665 XS', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKDJM37893', 'JO8E UF J53365 AABABB', '2000-01-01', '2000', '2016-08-25 20:22:25', '2016-08-26 07:43:15', '2');
63INSERT INTO `truck` VALUES ('7', '007', 'DD 8975 XK', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKEJM41072', 'J08E-UFJ59720 BBBBBB', '2000-01-01', '2000', '2016-08-25 20:22:28', '2016-08-26 07:43:17', '2');
64INSERT INTO `truck` VALUES ('8', '008', 'DD 8981 XK', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKEJM41069', 'J08E-UFJ59717 AAAAAA', '2000-01-01', '2000', '2016-08-25 20:22:31', '2016-08-26 07:43:23', '2');
65INSERT INTO `truck` VALUES ('9', '009', 'DD 8373 XY', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKEJM41082', 'J08E-UFJ59746 BBBBBB', '2000-01-01', '2000', '2016-08-25 20:22:34', '2016-08-26 07:43:25', '2');
66INSERT INTO `truck` VALUES ('10', '010', 'DD 8973 XK', 'HINO', 'HINO FM 260 JD (DT)', 'MJEFM8JNKEJM41080', 'J08E-UFJ59746 BBBBBB', '2000-01-01', '2000', '2016-08-25 20:22:39', '2016-08-26 07:43:29', '2');