· 9 years ago · Dec 16, 2016, 10:06 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.5.28 - MySQL Community Server (GPL)
4-- Server OS: Win32
5-- HeidiSQL version: 7.0.0.4053
6-- Date/time: 2016-12-13 23:19:14
7-- --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
12
13-- Dumping database structure for latihan
14CREATE DATABASE IF NOT EXISTS `latihan` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `latihan`;
16
17
18-- Dumping structure for table latihan.container
19CREATE TABLE IF NOT EXISTS `container` (
20 `Id` varchar(50) DEFAULT NULL,
21 `Container` varchar(50) DEFAULT NULL,
22 `TglTimbang` varchar(10) NOT NULL,
23 `Metode` varchar(50) DEFAULT NULL,
24 `Cargo` varchar(30) NOT NULL,
25 `Damage` varchar(12) NOT NULL,
26 `Tare` varchar(50) NOT NULL,
27 `Total` varchar(10) NOT NULL,
28 `Novgm` char(4) NOT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31-- Dumping data for table latihan.container: ~17 rows (approximately)
32/*!40000 ALTER TABLE `container` DISABLE KEYS */;
33REPLACE INTO `container` (`Id`, `Container`, `TglTimbang`, `Metode`, `Cargo`, `Damage`, `Tare`, `Total`, `Novgm`) VALUES
34 ('01', 'APHU 7800544', '30-12-1899', '1', '21,000', '', '1,200', '22,200', '0002'),
35 ('02', 'APZU 4500333', '30-12-1899', '2', '21,000', '', '1,244', '22,244', '0002'),
36 ('03', 'CLHU 8002311', '30-12-1899', '1', '21,000', '', '1,200', '22,200', '0002'),
37 ('04', 'APZU 5655433', '09-12-2016', '2', '21,111', '', '1,222', '22,333', '0002'),
38 ('10', 'CLDU 7809344', '09-12-2016', '1', '21,000', '', '1,200', '22,200', '0002'),
39 ('01', 'APHU 7800544', '30-12-1899', '1', '21,000', '', '1,200', '22,200', '0005'),
40 ('11', 'DRHU 6543222', '09-12-2016', '2', '21,222', '', '2,111', '23,333', '0002'),
41 ('02', 'APZU 4500333', '30-12-1899', '2', '21,000', '', '1,244', '22,244', '0005'),
42 ('03', 'CLHU 8002311', '30-12-1899', '1', '21,000', '', '1,200', '22,200', '0005'),
43 ('04', 'APZU 5655433', '09-12-2016', '2', '21,111', '', '1,222', '22,333', '0005'),
44 ('05', 'DRHU 8000999', '09-12-2016', '2', '21,333', '', '1,222', '22,555', '0005'),
45 ('12', 'DRTU 8900808', '30-12-1899', '1', '22,000', '', '1,200', '23,200', '0002'),
46 ('06', 'APHU 2990999', '28-11-2016', '1', '22,000', '', '1,200', '23,200', '0005'),
47 ('07', 'CLHU 9076655', '09-12-2016', '1', '21,900', '', '1,290', '23,190', '0005'),
48 ('08', 'GLDU 2009123', '09-12-2016', '1', '21,100', '', '1,200', '22,300', '0005'),
49 ('13', 'CLHU 5600321', '09-12-2016', '1', '21,000', '', '1,200', '22,200', '0005'),
50 ('09', 'TRLU 4400123', '30-12-1899', '1', '21,222', '', '1,200', '22,422', '0005');
51/*!40000 ALTER TABLE `container` ENABLE KEYS */;
52
53
54-- Dumping structure for table latihan.vgm
55CREATE TABLE IF NOT EXISTS `vgm` (
56 `Novgm` char(20) NOT NULL,
57 `Shipper` varchar(50) DEFAULT NULL,
58 `Booking` varchar(20) DEFAULT NULL,
59 `WName` varchar(50) DEFAULT NULL,
60 `WAddress` varchar(30) DEFAULT NULL,
61 `Measure` varchar(12) DEFAULT NULL,
62 `Metode1` varchar(50) DEFAULT NULL,
63 `Metode2` varchar(50) DEFAULT NULL,
64 `Signature` varchar(50) DEFAULT NULL,
65 `SignatoryN` varchar(50) DEFAULT NULL,
66 `SignatoryC` varchar(50) DEFAULT NULL,
67 `Tgl` varchar(10) DEFAULT NULL,
68 PRIMARY KEY (`Novgm`),
69 UNIQUE KEY `Nimx` (`Novgm`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
71
72-- Dumping data for table latihan.vgm: ~5 rows (approximately)
73/*!40000 ALTER TABLE `vgm` DISABLE KEYS */;
74REPLACE INTO `vgm` (`Novgm`, `Shipper`, `Booking`, `WName`, `WAddress`, `Measure`, `Metode1`, `Metode2`, `Signature`, `SignatoryN`, `SignatoryC`, `Tgl`) VALUES
75 ('0001', 'Timur Laut', '140023007', '', '', '', '', '', 'RM. ADI ', '-', '-', '30-12-1899'),
76 ('0002', 'Central Grow', '140023009', '', '', '', '', '', 'RM. HADI ', '-', '-', '30-12-1899'),
77 ('0003', 'Jaya Sarana', '140023008', '', '', '', '', '', 'RM. HADI ', '-', '-', '30-12-1899'),
78 ('0004', 'Guna Sempurna', '140023005', '', '', '', '', '', 'RM. HADI ', '-', '-', '30-12-1899'),
79 ('0005', 'Lestari Bahari', '140023006', '', '', '', '', '', 'RM. HADI ', '-', '-', '30-12-1899');
80/*!40000 ALTER TABLE `vgm` ENABLE KEYS */;
81/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
82/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;