· 10 years ago · Sep 01, 2016, 06:28 AM
1-- phpMyAdmin SQL Dump
2-- version 3.2.4
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 26, 2016 at 05:05 PM
7-- Server version: 5.1.41
8-- PHP Version: 5.3.1
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `absenaja`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `absensi`
26--
27
28CREATE TABLE IF NOT EXISTS `absensi` (
29 `id_absen` int(100) NOT NULL AUTO_INCREMENT,
30 `idpegawai` int(20) DEFAULT NULL,
31 `kehadiran` int(1) NOT NULL,
32 `tanggal` date DEFAULT NULL,
33 PRIMARY KEY (`id_absen`),
34 KEY `absen_pegawai` (`idpegawai`)
35) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
36
37--
38-- Dumping data for table `absensi`
39--
40
41INSERT INTO `absensi` (`id_absen`, `idpegawai`, `kehadiran`, `tanggal`) VALUES
42(19, 212121, 1, '2016-01-26'),
43(18, 123, 1, '2016-01-26'),
44(17, 1234, 1, '2016-01-26'),
45(16, 1234321, 1, '2016-01-26'),
46(15, 176, 1, '2016-01-26');
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `adminsuper`
52--
53
54CREATE TABLE IF NOT EXISTS `adminsuper` (
55 `idadmin` int(5) NOT NULL AUTO_INCREMENT,
56 `nama_admin` varchar(30) DEFAULT NULL,
57 `username` varchar(30) DEFAULT NULL,
58 `password` varchar(100) DEFAULT NULL,
59 PRIMARY KEY (`idadmin`)
60) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
61
62--
63-- Dumping data for table `adminsuper`
64--
65
66INSERT INTO `adminsuper` (`idadmin`, `nama_admin`, `username`, `password`) VALUES
67(1, 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3');
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `jabatan`
73--
74
75CREATE TABLE IF NOT EXISTS `jabatan` (
76 `id_jabatan` int(3) NOT NULL AUTO_INCREMENT,
77 `jabatan` varchar(50) DEFAULT NULL,
78 PRIMARY KEY (`id_jabatan`)
79) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
80
81--
82-- Dumping data for table `jabatan`
83--
84
85INSERT INTO `jabatan` (`id_jabatan`, `jabatan`) VALUES
86(1, 'manager'),
87(2, 'kabag'),
88(3, 'mandor'),
89(4, 'karyawan');
90
91-- --------------------------------------------------------
92
93--
94-- Table structure for table `log`
95--
96
97CREATE TABLE IF NOT EXISTS `log` (
98 `id_log` int(100) NOT NULL AUTO_INCREMENT,
99 `id_pegawai` varchar(100) DEFAULT NULL,
100 `username` varchar(100) NOT NULL,
101 `waktu` datetime DEFAULT NULL,
102 PRIMARY KEY (`id_log`),
103 KEY `id_login` (`id_pegawai`)
104) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
105
106--
107-- Dumping data for table `log`
108--
109
110INSERT INTO `log` (`id_log`, `id_pegawai`, `username`, `waktu`) VALUES
111(36, '176', 'saya', '2016-01-26 16:53:40'),
112(35, '176', 'saya', '2016-01-26 16:03:47'),
113(34, '1234321', 'bowo', '2016-01-26 15:59:05'),
114(33, '176', 'saya', '2016-01-26 15:54:51'),
115(32, '212121', 'kamarujung', '2016-01-26 12:27:43'),
116(31, '123', 'bambang', '2016-01-26 12:27:30'),
117(30, '1234', 'budi', '2016-01-26 12:27:22'),
118(29, '1234321', 'bowo', '2016-01-26 12:27:04'),
119(28, '176', 'saya', '2016-01-26 12:26:53');
120
121-- --------------------------------------------------------
122
123--
124-- Table structure for table `login`
125--
126
127CREATE TABLE IF NOT EXISTS `login` (
128 `id_login` int(100) NOT NULL AUTO_INCREMENT,
129 `idPegawai` int(100) NOT NULL,
130 `username` varchar(50) DEFAULT NULL,
131 `password` varchar(100) DEFAULT NULL,
132 `level` varchar(20) DEFAULT NULL,
133 `status` varchar(1) DEFAULT NULL,
134 PRIMARY KEY (`id_login`)
135) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
136
137--
138-- Dumping data for table `login`
139--
140
141INSERT INTO `login` (`id_login`, `idPegawai`, `username`, `password`, `level`, `status`) VALUES
142(12, 1234321, 'bowo', '9b930621eaa7ca7e9f6f584a1450b8a6', 'karyawan', '1'),
143(11, 1234, 'budi', '00dfc53ee86af02e742515cdcf075ed3', 'mandor', '1'),
144(10, 123, 'bambang', 'a9711cbb2e3c2d5fc97a63e45bbe5076', 'kabag', '1'),
145(13, 212121, 'kamarujung', 'dfc75c08d0cc427d60776ffdcadb91a6', 'karyawan', '1'),
146(9, 176, 'saya', '20c1a26a55039b30866c9d0aa51953ca', 'manager', '1');
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `pegawai`
152--
153
154CREATE TABLE IF NOT EXISTS `pegawai` (
155 `id_pegawai` int(20) NOT NULL,
156 `nama_pegawai` varchar(50) DEFAULT NULL,
157 `jabatanpegawai` varchar(10) DEFAULT NULL,
158 PRIMARY KEY (`id_pegawai`)
159) ENGINE=MyISAM DEFAULT CHARSET=latin1;
160
161--
162-- Dumping data for table `pegawai`
163--
164
165INSERT INTO `pegawai` (`id_pegawai`, `nama_pegawai`, `jabatanpegawai`) VALUES
166(212121, 'kamarujung.blogspot.com', '4'),
167(1234321, 'bowo', '4'),
168(1234, 'budi', '3'),
169(123, 'bambang', '2'),
170(176, 'saya', '1');
171
172-- --------------------------------------------------------
173
174--
175-- Table structure for table `waktuabsen`
176--
177
178CREATE TABLE IF NOT EXISTS `waktuabsen` (
179 `id_waktuabsen` int(20) NOT NULL AUTO_INCREMENT,
180 `set_mulai` time DEFAULT NULL,
181 `set_selesai` time DEFAULT NULL,
182 `keterangan` varchar(100) DEFAULT NULL,
183 PRIMARY KEY (`id_waktuabsen`)
184) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
185
186--
187-- Dumping data for table `waktuabsen`
188--
189
190INSERT INTO `waktuabsen` (`id_waktuabsen`, `set_mulai`, `set_selesai`, `keterangan`) VALUES
191(1, '07:00:00', '07:30:00', 'Jam Isi Daftar Hadir');
192
193/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
194/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
195/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;