· 8 years ago · Feb 23, 2018, 06:56 AM
1/*
2SQLyog Ultimate v12.4.3 (64 bit)
3MySQL - 5.6.17 : Database - absensi
4*********************************************************************
5*/
6
7/*!40101 SET NAMES utf8 */;
8
9/*!40101 SET SQL_MODE=''*/;
10
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15CREATE DATABASE /*!32312 IF NOT EXISTS*/`absensi` /*!40100 DEFAULT CHARACTER SET latin1 */;
16
17USE `absensi`;
18
19/*Table structure for table `absen` */
20
21DROP TABLE IF EXISTS `absen`;
22
23CREATE TABLE `absen` (
24 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
25 `siswa_id` int(10) unsigned NOT NULL,
26 `tanggal` int(8) unsigned NOT NULL,
27 `minggu` tinyint(1) unsigned NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
30
31/*Data for the table `absen` */
32
33insert into `absen`(`id`,`siswa_id`,`tanggal`,`minggu`) values
34(5,1,20180221,4),
35(6,5,20180221,4);
36
37/*Table structure for table `cabang` */
38
39DROP TABLE IF EXISTS `cabang`;
40
41CREATE TABLE `cabang` (
42 `id` smallint(3) unsigned zerofill NOT NULL AUTO_INCREMENT,
43 `nama` varchar(45) NOT NULL DEFAULT '',
44 `ket` varchar(200) DEFAULT '',
45 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
46 PRIMARY KEY (`id`),
47 UNIQUE KEY `id_UNIQUE` (`id`)
48) ENGINE=MyISAM AUTO_INCREMENT=503 DEFAULT CHARSET=latin1;
49
50/*Data for the table `cabang` */
51
52insert into `cabang`(`id`,`nama`,`ket`,`disabled`) values
53(501,'GRAHA NGINDEN','',0),
54(502,'MANYAR','',0);
55
56/*Table structure for table `guru` */
57
58DROP TABLE IF EXISTS `guru`;
59
60CREATE TABLE `guru` (
61 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62 `nama` varchar(45) NOT NULL,
63 `lahir` int(8) unsigned NOT NULL,
64 `alamat` varchar(100) NOT NULL DEFAULT '',
65 `phone` varchar(45) NOT NULL DEFAULT '',
66 `pekerjaan` varchar(45) NOT NULL DEFAULT '',
67 `ket` varchar(200) NOT NULL DEFAULT '',
68 `cabang_id` smallint(3) unsigned zerofill NOT NULL DEFAULT '000',
69 `ibadah_id` smallint(3) unsigned zerofill NOT NULL DEFAULT '000',
70 `kelompok_id` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
71 `kelas_id` tinyint(2) unsigned zerofill NOT NULL DEFAULT '00',
72 `disabled` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
73 PRIMARY KEY (`id`),
74 UNIQUE KEY `nis_UNIQUE` (`id`)
75) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
76
77/*Data for the table `guru` */
78
79insert into `guru`(`id`,`nama`,`lahir`,`alamat`,`phone`,`pekerjaan`,`ket`,`cabang_id`,`ibadah_id`,`kelompok_id`,`kelas_id`,`disabled`) values
80(1,'Ivan Sagita',20120808,'surabaya','083422131','','',501,002,1,01,0);
81
82/*Table structure for table `ibadah` */
83
84DROP TABLE IF EXISTS `ibadah`;
85
86CREATE TABLE `ibadah` (
87 `id` smallint(3) unsigned zerofill NOT NULL AUTO_INCREMENT,
88 `cabang_id` smallint(3) unsigned NOT NULL DEFAULT '0',
89 `nama` varchar(45) NOT NULL DEFAULT '',
90 `jam` time NOT NULL,
91 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
92 PRIMARY KEY (`id`),
93 UNIQUE KEY `id_UNIQUE` (`id`)
94) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
95
96/*Data for the table `ibadah` */
97
98insert into `ibadah`(`id`,`cabang_id`,`nama`,`jam`,`disabled`) values
99(001,501,'Pagi','06:30:00',0),
100(002,501,'Siang 1','09:30:00',0),
101(003,502,'Pagi','06:00:00',0),
102(004,502,'Siang','07:45:00',0);
103
104/*Table structure for table `kelas` */
105
106DROP TABLE IF EXISTS `kelas`;
107
108CREATE TABLE `kelas` (
109 `id` tinyint(2) unsigned zerofill NOT NULL AUTO_INCREMENT,
110 `kelompok_id` tinyint(1) unsigned NOT NULL DEFAULT '0',
111 `nama` varchar(45) NOT NULL DEFAULT '',
112 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
113 PRIMARY KEY (`id`),
114 UNIQUE KEY `id_UNIQUE` (`id`)
115) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
116
117/*Data for the table `kelas` */
118
119insert into `kelas`(`id`,`kelompok_id`,`nama`,`disabled`) values
120(01,1,'BENYAMIN 1 (BS)',0),
121(02,1,'BENYAMIN 2 (PG)',0);
122
123/*Table structure for table `kelompok` */
124
125DROP TABLE IF EXISTS `kelompok`;
126
127CREATE TABLE `kelompok` (
128 `id` tinyint(1) unsigned zerofill NOT NULL AUTO_INCREMENT,
129 `nama` varchar(45) NOT NULL DEFAULT '',
130 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
131 PRIMARY KEY (`id`),
132 UNIQUE KEY `id_UNIQUE` (`id`)
133) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
134
135/*Data for the table `kelompok` */
136
137insert into `kelompok`(`id`,`nama`,`disabled`) values
138(1,'BALITA',0),
139(2,'PRATAMA',0),
140(3,'ALUMNI',0);
141
142/*Table structure for table `siswa` */
143
144DROP TABLE IF EXISTS `siswa`;
145
146CREATE TABLE `siswa` (
147 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
148 `nama` varchar(45) NOT NULL,
149 `kelas` varchar(2) NOT NULL DEFAULT '',
150 `lahir` int(8) unsigned NOT NULL,
151 `alamat` varchar(100) NOT NULL DEFAULT '',
152 `orangtua` varchar(45) NOT NULL DEFAULT '',
153 `phone` varchar(45) NOT NULL DEFAULT '',
154 `ket` varchar(200) NOT NULL DEFAULT '',
155 `cabang_id` smallint(3) unsigned zerofill NOT NULL DEFAULT '000',
156 `ibadah_id` smallint(3) unsigned zerofill NOT NULL DEFAULT '000',
157 `kelompok_id` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
158 `kelas_id` tinyint(2) unsigned zerofill NOT NULL DEFAULT '00',
159 `disabled` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
160 PRIMARY KEY (`id`),
161 UNIQUE KEY `nis_UNIQUE` (`id`)
162) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
163
164/*Data for the table `siswa` */
165
166insert into `siswa`(`id`,`nama`,`kelas`,`lahir`,`alamat`,`orangtua`,`phone`,`ket`,`cabang_id`,`ibadah_id`,`kelompok_id`,`kelas_id`,`disabled`) values
167(1,'Ivan Sagita','2',20110224,'Grand Semanggi Residance','','0','tes coba coba saja yang agak panjang............',501,002,1,01,0),
168(2,'Jasmine','2',19990107,'Jl. Tenggilis no 14','Tjahyana','081213545','',501,001,1,02,0),
169(3,'Novi','1',19921113,'Jl. Nginden','','0812154652','',501,002,1,01,0);
170
171/*Table structure for table `user` */
172
173DROP TABLE IF EXISTS `user`;
174
175CREATE TABLE `user` (
176 `username` varchar(20) NOT NULL,
177 `password` varchar(45) NOT NULL DEFAULT '',
178 `level` tinyint(1) unsigned NOT NULL DEFAULT '1',
179 `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
180 `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
181 PRIMARY KEY (`username`),
182 UNIQUE KEY `username_UNIQUE` (`username`)
183) ENGINE=MyISAM DEFAULT CHARSET=latin1;
184
185/*Data for the table `user` */
186
187insert into `user`(`username`,`password`,`level`,`last_login`,`disabled`) values
188('admin','21232f297a57a5a743894a0e4a801fc3',2,'2018-02-15 14:15:08',0);
189
190/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
191/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
192/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
193/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;