· 7 years ago · Dec 23, 2018, 04:06 PM
1/*
2SQLyog Ultimate - MySQL GUI v8.2
3MySQL - 5.5.5-10.1.36-MariaDB : Database - penduduk
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16CREATE DATABASE /*!32312 IF NOT EXISTS*/`penduduk` /*!40100 DEFAULT CHARACTER SET latin1 */;
17
18USE `penduduk`;
19
20/*Table structure for table `rt` */
21
22DROP TABLE IF EXISTS `rt`;
23
24CREATE TABLE `rt` (
25 `id_rt` smallint(6) NOT NULL AUTO_INCREMENT,
26 `id_rw` smallint(6) DEFAULT NULL,
27 `nama_rt` varchar(5) DEFAULT NULL,
28 `jumlah_kk` smallint(6) DEFAULT NULL,
29 `jumlah_l` smallint(6) DEFAULT NULL,
30 `jumlah_p` smallint(6) DEFAULT NULL,
31 `tahun` year(4) DEFAULT NULL,
32 PRIMARY KEY (`id_rt`)
33) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
34
35/*Data for the table `rt` */
36
37insert into `rt`(`id_rt`,`id_rw`,`nama_rt`,`jumlah_kk`,`jumlah_l`,`jumlah_p`,`tahun`) values (1,1,'RT 1',83,130,120,2018),(2,1,'RT 2',65,97,88,2018),(3,2,'RT 1',58,87,82,2018),(4,2,'RT 2',74,114,104,2018),(5,3,'RT 1',74,115,101,2018),(6,3,'RT 2',69,109,102,2018),(7,4,'RT 1',77,114,123,2018),(8,4,'RT 2',49,65,63,2018),(9,5,'RT 1',60,70,88,2018),(10,5,'RT 2',53,71,70,2018),(11,6,'RT 1',50,75,68,2018),(12,6,'RT 2',53,79,75,2018),(13,7,'RT 1',71,109,110,2018),(14,7,'RT 2',80,118,123,2018),(15,8,'RT 1',84,131,123,2018),(16,8,'RT 2',40,66,54,2018),(17,9,'RT 1',57,78,76,2018),(18,9,'RT 2',57,88,85,2018);
38
39/*Table structure for table `rw` */
40
41DROP TABLE IF EXISTS `rw`;
42
43CREATE TABLE `rw` (
44 `id_rw` int(11) NOT NULL AUTO_INCREMENT,
45 `nama_rw` varchar(5) DEFAULT NULL,
46 PRIMARY KEY (`id_rw`)
47) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
48
49/*Data for the table `rw` */
50
51insert into `rw`(`id_rw`,`nama_rw`) values (1,'RW 1'),(2,'RW 2'),(3,'RW 3'),(4,'RW 4'),(5,'RW 5'),(6,'RW 6'),(7,'RW 7'),(8,'RW 8'),(9,'RW 9');
52
53/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
54/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
55/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
56/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;