nDh4

brgMasuk

Jun 26th, 2012
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. CREATE TABLE `d_msk` (
  2. `id_detail` int(11) NOT NULL auto_increment,
  3. `id_msk` varchar(20) default NULL,
  4. `kd_brg` varchar(20) default NULL,
  5. `jml` int(11) default NULL,
  6. PRIMARY KEY (`id_detail`)
  7. ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
  8.  
  9. -- ----------------------------
  10. -- Records of d_msk
  11. -- ----------------------------
  12. INSERT INTO `d_msk` VALUES ('25', 'TUG1', 'kabel tc', '10');
  13. INSERT INTO `d_msk` VALUES ('26', 'TUG1', 'kabel nym', '11');
  14. INSERT INTO `d_msk` VALUES ('27', 'TUG1', 'konektor', '30');
  15. INSERT INTO `d_msk` VALUES ('28', 'TUG1', 'clamp', '17');
  16.  
  17.  
  18. CREATE TABLE `masuk` (
  19. `id_msk` varchar(20) NOT NULL,
  20. `no_kwh` int(11) default NULL,
  21. `merk` varchar(30) default NULL,
  22. `tgl` date default NULL,
  23. PRIMARY KEY (`id_msk`)
  24. ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
  25.  
  26. -- ----------------------------
  27. -- Records of masuk
  28. -- ----------------------------
  29. INSERT INTO `masuk` VALUES ('TUG1', '1234567890', 'metbelosa', '2012-06-26');
  30.  
  31. CREATE TABLE `t_brg` (
  32. `kd_brg` varchar(20) NOT NULL default '',
  33. `nm_brg` varchar(100) default NULL,
  34. PRIMARY KEY (`kd_brg`)
  35. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  36.  
  37. -- ----------------------------
  38. -- Records of t_brg
  39. -- ----------------------------
Advertisement
Add Comment
Please, Sign In to add comment