/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 10.1.19-MariaDB : Database - diamond
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`diamond` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `diamond`;

/*Table structure for table `tb_bimbingan` */


CREATE TABLE `tb_bimbingan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ID_KP` varchar(20) DEFAULT NULL,
  `Pesan` text,
  `File` varchar(100) DEFAULT NULL,
  `Tanggal` datetime DEFAULT NULL,
  `pengirim` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `tb_bimbingan` */

insert  into `tb_bimbingan`(`id`,`ID_KP`,`Pesan`,`File`,`Tanggal`,`pengirim`) values 
(1,'K0001','Selamat malam.. berikut saya lampirkan BAB 3 skripsi saya','','2018-11-01 23:32:50','1832121100'),
(4,'K0001','','bab 3.doc','2018-11-01 23:36:16','1832121100'),
(5,'K0001','oke file diterima.. akan saya cek dahulu','','2018-11-01 23:37:17','P0001');

/*Table structure for table `tb_kerja_praktek` */


CREATE TABLE `tb_kerja_praktek` (
  `ID_KP` varchar(20) NOT NULL,
  `NIM` varchar(20) DEFAULT NULL,
  `ID_Dosen` varchar(20) DEFAULT NULL,
  `Topik_Laporan` varchar(255) DEFAULT NULL,
  `Nama_Perusahaan` varchar(50) DEFAULT NULL,
  `Alamat_Perusahaan` varchar(100) DEFAULT NULL,
  `No_Telpon_Perusahaan` varchar(20) DEFAULT NULL,
  `Nilai` tinyint(1) DEFAULT NULL,
  `Tanggal_Daftar` date DEFAULT NULL,
  `Status` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_KP`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tb_kerja_praktek` */

insert  into `tb_kerja_praktek`(`ID_KP`,`NIM`,`ID_Dosen`,`Topik_Laporan`,`Nama_Perusahaan`,`Alamat_Perusahaan`,`No_Telpon_Perusahaan`,`Nilai`,`Tanggal_Daftar`,`Status`) values 
('K0001','1832121100','P0001','SISTEM INFORMASI PEMETAAN MASYARAKAT MISKIN KABUPATEN KLUNGKUNG','SARI BAKTI MEENING','JALAN SEDAP MALAM DENPASAR','08765431233321',NULL,'2018-11-01',1);

