Advertisement
GWibisono

export isenk

May 31st, 2012
503
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.83 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.3.9
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: May 31, 2012 at 06:11 PM
  7. -- Server version: 5.5.8
  8. -- PHP Version: 5.3.5
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `work_css`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `bagian`
  20. --
  21.  
  22. CREATE TABLE IF NOT EXISTS `bagian` (
  23.   `id_bagian` tinyint(2) NOT NULL AUTO_INCREMENT,
  24.   `nama_bagian` VARCHAR(40) NOT NULL,
  25.   PRIMARY KEY (`id_bagian`)
  26. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
  27.  
  28. --
  29. -- Dumping data for table `bagian`
  30. --
  31.  
  32. INSERT INTO `bagian` (`id_bagian`, `nama_bagian`) VALUES
  33. (1, 'Poli Internist'),
  34. (2, 'Poli Anak'),
  35. (3, 'Kasir UGD'),
  36. (4, 'UGD'),
  37. (5, 'Farmasi'),
  38. (6, 'Radiology'),
  39. (7, 'Rehab Medik'),
  40. (8, 'Pendaftaran Rawat Inap'),
  41. (9, 'Pembayaran Rawat Inap'),
  42. (10, 'Kasir Farmasi'),
  43. (11, 'Counter OPD'),
  44. (12, 'Laboratorium'),
  45. (13, 'OT'),
  46. (14, 'ICU'),
  47. (15, 'Cendrawasih'),
  48. (16, 'Merak'),
  49. (17, 'Camar'),
  50. (18, 'Kutilang'),
  51. (19, 'Pinguin'),
  52. (20, 'VK'),
  53. (21, 'Merpati');
  54.  
  55. -- --------------------------------------------------------
  56.  
  57. --
  58. -- Table structure for table `bulan`
  59. --
  60.  
  61. CREATE TABLE IF NOT EXISTS `bulan` (
  62.   `id_bulan` tinyint(2) NOT NULL AUTO_INCREMENT,
  63.   `nama_bulan` VARCHAR(20) NOT NULL,
  64.   `kode_bulan` VARCHAR(2) NOT NULL,
  65.   PRIMARY KEY (`id_bulan`)
  66. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
  67.  
  68. --
  69. -- Dumping data for table `bulan`
  70. --
  71.  
  72. INSERT INTO `bulan` (`id_bulan`, `nama_bulan`, `kode_bulan`) VALUES
  73. (1, 'Januari', '01'),
  74. (2, 'Februari', '02'),
  75. (3, 'Maret', '03'),
  76. (4, 'April', '04'),
  77. (5, 'Mei', '05'),
  78. (6, 'Juni', '06'),
  79. (7, 'Juli', '07'),
  80. (8, 'Agustus', '08'),
  81. (9, 'September', '09'),
  82. (10, 'Oktober', '10'),
  83. (11, 'Nopember', '11'),
  84. (12, 'Desember', '12');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement