· 8 years ago · Jun 24, 2018, 08:46 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.12
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 24 Jun 2018 pada 10.37
7-- Versi Server: 5.6.16
8-- PHP Version: 5.5.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `simpussajad`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `pegawai`
27--
28
29CREATE TABLE IF NOT EXISTS `pegawai` (
30 `pegawai_id` int(32) NOT NULL AUTO_INCREMENT,
31 `pegawai_nip` varchar(32) NOT NULL,
32 `pegawai_nama` varchar(32) NOT NULL,
33 `jabatan_id` bigint(20) NOT NULL,
34 `pegawai_jk` varchar(32) NOT NULL,
35 `pegawai_telepon` varchar(32) NOT NULL,
36 `pegawai_email` varchar(32) NOT NULL,
37 `pegawai_tempat_lahir` varchar(32) NOT NULL,
38 `pegawai_tanggal_lahir` date NOT NULL,
39 `pegawai_alamat` text NOT NULL,
40 PRIMARY KEY (`pegawai_id`)
41) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
42
43--
44-- Dumping data untuk tabel `pegawai`
45--
46
47INSERT INTO `pegawai` (`pegawai_id`, `pegawai_nip`, `pegawai_nama`, `jabatan_id`, `pegawai_jk`, `pegawai_telepon`, `pegawai_email`, `pegawai_tempat_lahir`, `pegawai_tanggal_lahir`, `pegawai_alamat`) VALUES
48(29, '0000', 'Suandi,S.ST', 36, 'Laki-Laki', '081345080373', 'suandisimpangempat@gmail.com', 'Sambas', '0000-00-00', 'Puskesmas Sajad'),
49(30, '', 'Hidayat, A.Md.Kep', 41, 'Laki-Laki', '085252083271', 'bangngah72@gmail.com', '', '0000-00-00', 'Puskesmas Sajad');
50
51/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
52/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
53/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;