akademik.sql

-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 15, 2016 at 08:59 PM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `akademik`
--

-- --------------------------------------------------------

--
-- Table structure for table `akademik_jadwal_kuliah`
--

CREATE TABLE IF NOT EXISTS `akademik_jadwal_kuliah` (
  `jadwal_id` int(11) NOT NULL,
  `tahun_akademik_id` int(11) NOT NULL,
  `konsentrasi_id` int(11) NOT NULL,
  `makul_id` int(11) NOT NULL,
  `hari_id` int(11) NOT NULL,
  `waktu_id` int(11) NOT NULL,
  `ruangan_id` int(11) NOT NULL,
  `dosen_id` int(11) NOT NULL,
  `semester` int(11) NOT NULL,
  `jam_mulai` varchar(9) NOT NULL,
  `jam_selesai` varchar(9) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_jadwal_kuliah`
--

INSERT INTO `akademik_jadwal_kuliah` (`jadwal_id`, `tahun_akademik_id`, `konsentrasi_id`, `makul_id`, `hari_id`, `waktu_id`, `ruangan_id`, `dosen_id`, `semester`, `jam_mulai`, `jam_selesai`) VALUES
(73, 1, 3, 1, 3, 0, 5, 11, 1, '08:00', '11:20'),
(74, 1, 3, 2, 1, 0, 5, 25, 1, '11:21', '14:41'),
(75, 1, 3, 3, 3, 0, 0, 19, 1, '08:00', '11:20'),
(76, 1, 3, 4, 1, 0, 1, 17, 1, '13:00', '16:20'),
(77, 1, 3, 5, 0, 0, 0, 7, 1, '', ''),
(78, 1, 3, 6, 0, 0, 0, 12, 1, '', ''),
(79, 1, 3, 7, 0, 0, 0, 0, 2, '', ''),
(80, 1, 3, 8, 0, 0, 0, 0, 2, '', ''),
(81, 1, 3, 9, 0, 0, 0, 0, 2, '', ''),
(82, 1, 3, 10, 0, 0, 0, 0, 2, '', ''),
(83, 1, 3, 11, 0, 0, 0, 0, 2, '', ''),
(84, 1, 3, 12, 0, 0, 0, 0, 2, '', ''),
(85, 1, 3, 13, 0, 0, 0, 1, 3, '', ''),
(86, 1, 3, 14, 0, 0, 0, 5, 3, '', ''),
(87, 1, 3, 15, 0, 0, 0, 18, 3, '', ''),
(88, 1, 3, 16, 0, 0, 0, 26, 3, '', ''),
(89, 1, 3, 17, 0, 0, 0, 21, 3, '', ''),
(90, 1, 3, 18, 0, 0, 0, 18, 3, '', ''),
(91, 1, 3, 19, 0, 0, 0, 0, 4, '', ''),
(92, 1, 3, 20, 0, 0, 0, 0, 4, '', ''),
(93, 1, 3, 21, 0, 0, 0, 0, 4, '', ''),
(94, 1, 3, 22, 0, 0, 0, 0, 4, '', ''),
(95, 1, 3, 23, 0, 0, 0, 0, 4, '', ''),
(96, 1, 3, 24, 0, 0, 0, 0, 4, '', ''),
(97, 1, 3, 25, 0, 0, 0, 0, 5, '', ''),
(98, 1, 3, 26, 0, 0, 0, 0, 5, '', ''),
(99, 1, 3, 27, 0, 0, 0, 0, 5, '', ''),
(100, 1, 3, 28, 0, 0, 0, 0, 5, '', ''),
(101, 1, 3, 29, 0, 0, 0, 0, 5, '', ''),
(102, 1, 3, 30, 0, 0, 0, 0, 5, '', ''),
(103, 1, 3, 31, 0, 0, 0, 0, 6, '', ''),
(104, 1, 3, 32, 0, 0, 0, 0, 6, '', ''),
(105, 1, 3, 33, 0, 0, 0, 0, 6, '', ''),
(106, 1, 3, 34, 0, 0, 0, 0, 6, '', ''),
(107, 1, 3, 35, 0, 0, 0, 0, 6, '', ''),
(108, 1, 3, 36, 0, 0, 0, 0, 6, '', ''),
(109, 6, 1, 50, 0, 0, 0, 0, 1, '', ''),
(110, 6, 1, 50, 0, 0, 0, 0, 1, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `akademik_khs`
--

CREATE TABLE IF NOT EXISTS `akademik_khs` (
  `khs_id` int(11) NOT NULL,
  `krs_id` int(11) NOT NULL,
  `mutu` int(11) NOT NULL,
  `kehadiran` int(11) NOT NULL,
  `tugas` int(11) NOT NULL,
  `grade` varchar(1) NOT NULL,
  `confirm` int(11) NOT NULL COMMENT '1=ya 2=tidak'
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_khs`
--

INSERT INTO `akademik_khs` (`khs_id`, `krs_id`, `mutu`, `kehadiran`, `tugas`, `grade`, `confirm`) VALUES
(1, 1, 0, 0, 0, '', 2),
(2, 2, 0, 0, 0, '', 2),
(3, 3, 0, 0, 0, '', 2),
(4, 4, 0, 0, 0, '', 2),
(5, 5, 0, 0, 0, '', 2),
(6, 6, 0, 0, 0, '', 2),
(7, 7, 0, 0, 0, '', 1),
(8, 8, 0, 0, 0, '', 2),
(9, 9, 0, 0, 0, '', 2),
(10, 10, 0, 0, 0, '', 2),
(11, 11, 0, 0, 0, '', 2),
(12, 12, 0, 0, 0, '', 2),
(13, 13, 0, 0, 0, '', 2),
(14, 14, 0, 0, 0, '', 2),
(15, 15, 0, 0, 0, '', 2),
(16, 16, 0, 0, 0, '', 2),
(17, 17, 0, 0, 0, '', 2),
(18, 18, 0, 0, 0, '', 2),
(21, 21, 0, 0, 0, '', 2),
(22, 22, 0, 0, 0, '', 2),
(23, 23, 0, 0, 0, '', 2),
(24, 24, 0, 0, 0, '', 2),
(25, 25, 0, 0, 0, '', 2),
(26, 26, 0, 0, 0, '', 2),
(27, 27, 0, 0, 0, '', 2),
(28, 28, 0, 0, 0, '', 2),
(29, 29, 0, 0, 0, '', 2),
(30, 30, 0, 0, 0, '', 2),
(31, 31, 0, 0, 0, '', 2),
(32, 32, 0, 0, 0, '', 2),
(33, 33, 0, 0, 0, '', 2),
(34, 34, 0, 0, 0, '', 2),
(35, 35, 0, 0, 0, '', 2),
(36, 36, 0, 0, 0, '', 2),
(37, 37, 0, 0, 0, '', 2),
(38, 38, 0, 0, 0, '', 2),
(39, 39, 0, 0, 0, '', 2),
(40, 40, 0, 0, 0, '', 2),
(41, 41, 0, 0, 0, '', 2),
(42, 42, 0, 0, 0, '', 2),
(43, 43, 0, 0, 0, '', 2),
(44, 44, 0, 0, 0, '', 2),
(45, 45, 0, 0, 0, '', 2),
(46, 46, 0, 0, 0, '', 2),
(47, 47, 0, 0, 0, '', 2),
(48, 48, 0, 0, 0, '', 2),
(49, 49, 0, 0, 0, '', 2),
(50, 50, 0, 0, 0, '', 2),
(51, 51, 0, 0, 0, '', 2),
(52, 52, 0, 0, 0, '', 2),
(53, 53, 0, 0, 0, '', 2),
(54, 54, 0, 0, 0, '', 2),
(55, 55, 0, 0, 0, '', 2),
(56, 56, 0, 0, 0, '', 2),
(57, 57, 0, 0, 0, '', 2),
(58, 58, 0, 0, 0, '', 2),
(59, 59, 0, 0, 0, '', 2),
(60, 60, 0, 0, 0, '', 2),
(61, 61, 0, 0, 0, '', 2),
(62, 62, 0, 0, 0, '', 2),
(63, 63, 0, 0, 0, '', 2),
(64, 64, 0, 0, 0, '', 2),
(65, 65, 0, 0, 0, '', 2),
(66, 66, 0, 0, 0, '', 2),
(67, 67, 0, 0, 0, '', 2),
(68, 68, 0, 0, 0, '', 2),
(69, 69, 0, 0, 0, '', 2),
(70, 70, 0, 0, 0, '', 2),
(71, 71, 0, 0, 0, '', 2),
(72, 72, 0, 0, 0, '', 2),
(73, 73, 0, 0, 0, '', 2),
(74, 74, 0, 0, 0, '', 2),
(75, 75, 0, 0, 0, '', 2),
(76, 76, 0, 0, 0, '', 2),
(77, 77, 0, 0, 0, '', 2),
(78, 78, 0, 0, 0, '', 2),
(79, 79, 0, 0, 0, '', 2),
(80, 80, 0, 0, 0, '', 2),
(81, 81, 0, 0, 0, '', 2),
(82, 82, 0, 0, 0, '', 2),
(83, 83, 0, 0, 0, '', 2),
(84, 84, 0, 0, 0, '', 2),
(85, 85, 0, 0, 0, '', 2),
(86, 86, 0, 0, 0, '', 2),
(87, 87, 0, 0, 0, '', 2),
(88, 88, 0, 0, 0, '', 2),
(89, 89, 0, 0, 0, '', 2),
(90, 90, 0, 0, 0, '', 2),
(91, 91, 0, 0, 0, '', 2),
(92, 92, 0, 0, 0, '', 2),
(93, 93, 0, 0, 0, '', 2),
(94, 94, 0, 0, 0, '', 2),
(95, 95, 0, 0, 0, '', 2),
(96, 96, 0, 0, 0, '', 2),
(97, 97, 0, 0, 0, '', 2),
(98, 98, 0, 0, 0, '', 2),
(100, 100, 0, 0, 0, '', 1),
(102, 102, 0, 0, 0, '', 1),
(103, 103, 0, 0, 0, '', 1),
(104, 104, 0, 0, 0, '', 1),
(105, 105, 6, 6, 6, 'D', 2),
(106, 106, 0, 0, 0, '', 2),
(107, 107, 0, 0, 0, '', 2),
(108, 108, 0, 0, 0, '', 2),
(109, 109, 0, 0, 0, '', 2),
(110, 110, 0, 0, 0, '', 2),
(111, 111, 0, 0, 0, '', 2),
(112, 112, 0, 0, 0, '', 2),
(113, 113, 0, 0, 0, '', 2),
(114, 114, 0, 0, 0, '', 2),
(115, 115, 0, 0, 0, '', 2),
(116, 116, 0, 0, 0, '', 2),
(117, 117, 0, 0, 0, '', 2),
(118, 118, 0, 0, 0, '', 2),
(119, 119, 0, 0, 0, '', 2),
(120, 120, 0, 0, 0, '', 2),
(121, 121, 0, 0, 0, '', 2),
(122, 122, 0, 0, 0, '', 2),
(123, 123, 0, 0, 0, '', 1),
(124, 124, 0, 0, 0, '', 2),
(125, 125, 0, 0, 0, '', 2),
(126, 126, 0, 0, 0, '', 2),
(127, 127, 0, 0, 0, '', 2),
(128, 128, 0, 0, 0, '', 2),
(129, 129, 0, 0, 0, '', 2),
(130, 130, 0, 0, 0, '', 2),
(131, 131, 0, 0, 0, '', 2),
(132, 132, 0, 0, 0, '', 2),
(133, 133, 0, 0, 0, '', 2),
(134, 134, 0, 0, 0, '', 2),
(135, 135, 0, 0, 0, '', 2),
(136, 136, 0, 0, 0, '', 2),
(137, 137, 0, 0, 0, '', 2),
(138, 138, 0, 0, 0, '', 2),
(139, 139, 0, 0, 0, '', 2),
(140, 140, 0, 0, 0, '', 2),
(141, 141, 0, 0, 0, '', 2),
(142, 142, 0, 0, 0, '', 2),
(143, 143, 0, 0, 0, '', 2),
(144, 144, 0, 0, 0, '', 2),
(145, 145, 0, 0, 0, '', 2),
(146, 146, 0, 0, 0, '', 2),
(147, 147, 0, 0, 0, '', 2),
(148, 148, 0, 0, 0, '', 2),
(149, 149, 0, 0, 0, '', 2),
(150, 150, 0, 0, 0, '', 2),
(151, 151, 0, 0, 0, '', 2),
(152, 152, 0, 0, 0, '', 2),
(153, 153, 0, 0, 0, '', 2),
(154, 154, 0, 0, 0, '', 2),
(155, 155, 0, 0, 0, '', 2),
(156, 156, 0, 0, 0, '', 2),
(157, 157, 0, 0, 0, '', 2),
(158, 158, 0, 0, 0, '', 2),
(159, 159, 0, 0, 0, '', 2),
(160, 160, 0, 0, 0, '', 2),
(161, 161, 0, 0, 0, '', 2);

-- --------------------------------------------------------

--
-- Table structure for table `akademik_konsentrasi`
--

CREATE TABLE IF NOT EXISTS `akademik_konsentrasi` (
  `konsentrasi_id` int(11) NOT NULL,
  `nama_konsentrasi` varchar(100) NOT NULL,
  `ketua` varchar(50) NOT NULL,
  `jenjang` varchar(3) NOT NULL COMMENT '1=D1,2=D2,3=D3,4=D4',
  `jml_semester` int(11) NOT NULL,
  `kode_nomor` varchar(20) NOT NULL,
  `gelar` varchar(40) NOT NULL,
  `prodi_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_konsentrasi`
--

INSERT INTO `akademik_konsentrasi` (`konsentrasi_id`, `nama_konsentrasi`, `ketua`, `jenjang`, `jml_semester`, `kode_nomor`, `gelar`, `prodi_id`) VALUES
(1, 'Belum Penjurusan', '0', '0', 0, '0', '0', 1),
(2, 'IPA', '', '', 2, '', '', 2),
(3, 'IPS', '', '', 2, '', '', 2),
(4, 'IPA', '', '', 2, '', '', 3),
(5, 'IPS', '', '', 2, '', '', 3),
(18, 'IPA', '0', '0', 0, '0', '0', 16),
(19, 'IPS', '0', '0', 0, '0', '0', 16);

-- --------------------------------------------------------

--
-- Table structure for table `akademik_krs`
--

CREATE TABLE IF NOT EXISTS `akademik_krs` (
  `krs_id` int(11) NOT NULL,
  `nim` varchar(10) NOT NULL,
  `jadwal_id` int(11) NOT NULL,
  `semester` int(11) NOT NULL COMMENT 'semester mahasiswa waktu pengambilan krs'
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_krs`
--

INSERT INTO `akademik_krs` (`krs_id`, `nim`, `jadwal_id`, `semester`) VALUES
(7, 'ti102134', 7, 2),
(8, 'ti102134', 8, 2),
(9, 'ti102134', 9, 2),
(10, 'ti102134', 10, 2),
(11, 'ti102134', 11, 2),
(12, 'ti102134', 12, 2),
(13, 'KA131002', 7, 2),
(14, 'KA131002', 8, 2),
(15, 'KA131002', 9, 2),
(16, 'KA131002', 10, 2),
(17, 'KA131002', 11, 2),
(18, 'KA131002', 12, 2),
(21, 'KA131003', 7, 2),
(22, 'KA131003', 8, 2),
(23, 'KA131003', 9, 2),
(24, 'KA131003', 10, 2),
(25, 'KA131003', 11, 2),
(26, 'KA131003', 12, 2),
(27, 'KA131004', 7, 2),
(28, 'KA131004', 8, 2),
(29, 'KA131004', 9, 2),
(30, 'KA131004', 10, 2),
(31, 'KA131004', 11, 2),
(32, 'KA131004', 12, 2),
(33, 'KA131005', 7, 2),
(34, 'KA131005', 8, 2),
(35, 'KA131005', 9, 2),
(36, 'KA131005', 10, 2),
(37, 'KA131005', 11, 2),
(38, 'KA131005', 12, 2),
(39, 'KA131006', 7, 2),
(40, 'KA131006', 8, 2),
(41, 'KA131006', 9, 2),
(42, 'KA131006', 10, 2),
(43, 'KA131006', 11, 2),
(44, 'KA131006', 12, 2),
(45, 'KA131007', 7, 2),
(46, 'KA131007', 8, 2),
(47, 'KA131007', 9, 2),
(48, 'KA131007', 10, 2),
(49, 'KA131007', 11, 2),
(50, 'KA131007', 12, 2),
(51, 'KA131008', 7, 2),
(52, 'KA131008', 8, 2),
(53, 'KA131008', 9, 2),
(54, 'KA131008', 10, 2),
(55, 'KA131008', 11, 2),
(56, 'KA131008', 12, 2),
(57, 'KA131010', 7, 2),
(58, 'KA131010', 8, 2),
(59, 'KA131010', 9, 2),
(60, 'KA131010', 10, 2),
(61, 'KA131010', 11, 2),
(62, 'KA131010', 12, 2),
(63, 'KA131009', 7, 2),
(64, 'KA131009', 8, 2),
(65, 'KA131009', 9, 2),
(66, 'KA131009', 10, 2),
(67, 'KA131009', 11, 2),
(68, 'KA131009', 12, 2),
(69, 'KA131011', 7, 2),
(70, 'KA131011', 8, 2),
(71, 'KA131011', 9, 2),
(72, 'KA131011', 10, 2),
(73, 'KA131011', 11, 2),
(74, 'KA131011', 12, 2),
(75, 'KA131012', 7, 2),
(76, 'KA131012', 8, 2),
(77, 'KA131012', 9, 2),
(78, 'KA131012', 10, 2),
(79, 'KA131012', 11, 2),
(80, 'KA131012', 12, 2),
(81, 'KA131003', 13, 3),
(82, 'KA131003', 14, 3),
(83, 'KA131003', 15, 3),
(84, 'KA131003', 16, 3),
(85, 'KA131003', 17, 3),
(86, 'KA131003', 18, 3),
(87, 'KA131003', 19, 4),
(88, 'KA131003', 20, 4),
(89, 'KA131003', 21, 4),
(90, 'KA131003', 22, 4),
(91, 'KA131003', 23, 4),
(92, 'KA131003', 24, 4),
(93, 'KA131003', 25, 5),
(94, 'KA131003', 26, 5),
(95, 'KA131003', 27, 5),
(96, 'KA131003', 28, 5),
(97, 'KA131003', 29, 5),
(98, 'KA131003', 30, 5),
(100, 'ti102134', 86, 3),
(102, 'ti102134', 88, 3),
(103, 'ti102134', 89, 3),
(104, 'ti102134', 90, 3),
(105, 'KA131002', 85, 3),
(106, 'KA131002', 86, 3),
(107, 'KA131002', 87, 3),
(108, 'KA131002', 88, 3),
(109, 'KA131002', 89, 3),
(110, 'KA131002', 90, 3),
(111, 'KA131003', 103, 6),
(112, 'KA131003', 104, 6),
(113, 'KA131003', 105, 6),
(114, 'KA131003', 106, 6),
(115, 'KA131003', 107, 6),
(116, 'KA131003', 108, 6),
(117, 'KA131004', 85, 3),
(118, 'KA131004', 86, 3),
(119, 'KA131004', 87, 3),
(120, 'KA131004', 88, 3),
(121, 'KA131004', 89, 3),
(122, 'KA131004', 90, 3),
(123, 'ti102134', 76, 3),
(124, 'KA131005', 85, 3),
(125, 'KA131005', 86, 3),
(126, 'KA131005', 87, 3),
(127, 'KA131005', 88, 3),
(128, 'KA131005', 89, 3),
(129, 'KA131005', 90, 3),
(130, 'ti102134', 75, 3),
(131, 'KA131006', 85, 3),
(132, 'KA131006', 86, 3),
(133, 'KA131006', 87, 3),
(134, 'KA131006', 88, 3),
(135, 'KA131006', 89, 3),
(136, 'KA131006', 90, 3),
(137, 'ti102134', 91, 4),
(138, 'ti102134', 92, 4),
(139, 'ti102134', 93, 4),
(140, 'ti102134', 94, 4),
(141, 'ti102134', 95, 4),
(142, 'ti102134', 96, 4),
(143, 'KA131006', 91, 4),
(144, 'KA131006', 92, 4),
(145, 'KA131006', 93, 4),
(146, 'KA131006', 94, 4),
(147, 'KA131006', 95, 4),
(148, 'KA131006', 96, 4),
(149, 'ti102134', 97, 5),
(150, 'ti102134', 98, 5),
(151, 'ti102134', 99, 5),
(152, 'ti102134', 100, 5),
(153, 'ti102134', 101, 5),
(154, 'ti102134', 102, 5),
(155, 'KA131002', 91, 4),
(156, 'KA131002', 92, 4),
(157, 'KA131002', 93, 4),
(158, 'KA131002', 94, 4),
(159, 'KA131002', 95, 4),
(160, 'KA131002', 96, 4),
(161, 'ti102134', 79, 5);

-- --------------------------------------------------------

--
-- Table structure for table `akademik_prodi`
--

CREATE TABLE IF NOT EXISTS `akademik_prodi` (
  `prodi_id` int(11) NOT NULL,
  `nama_prodi` varchar(100) NOT NULL,
  `ketua` varchar(70) NOT NULL,
  `no_izin` varchar(40) NOT NULL,
  `status` int(11) NOT NULL COMMENT '1=aktif ,2=g aktif'
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_prodi`
--

INSERT INTO `akademik_prodi` (`prodi_id`, `nama_prodi`, `ketua`, `no_izin`, `status`) VALUES
(1, 'Tingkat 1', '0', '0', 1),
(2, 'Tingkat 2', '', '', 1),
(16, 'Tingkat 3', '0', '0', 0);

-- --------------------------------------------------------

--
-- Table structure for table `akademik_registrasi`
--

CREATE TABLE IF NOT EXISTS `akademik_registrasi` (
  `registrasi_id` int(11) NOT NULL,
  `nim` varchar(10) NOT NULL,
  `tanggal_registrasi` datetime NOT NULL,
  `tahun_akademik_id` int(11) NOT NULL,
  `semester` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_registrasi`
--

INSERT INTO `akademik_registrasi` (`registrasi_id`, `nim`, `tanggal_registrasi`, `tahun_akademik_id`, `semester`) VALUES
(18, 'KA131002', '2014-07-21 08:12:15', 1, 3),
(19, 'KA131003', '2014-07-21 08:12:16', 1, 6),
(20, 'KA131004', '2014-07-21 11:51:59', 1, 3),
(21, 'KA131005', '2014-09-05 17:01:43', 1, 3),
(22, 'ti102134', '2014-09-08 16:33:19', 1, 4),
(23, 'KA131006', '2014-09-08 16:33:35', 1, 4),
(24, 'ti102134', '2014-09-08 17:09:26', 6, 5),
(25, 'KA131002', '2014-09-08 17:12:59', 6, 4);

-- --------------------------------------------------------

--
-- Table structure for table `akademik_tahun_akademik`
--

CREATE TABLE IF NOT EXISTS `akademik_tahun_akademik` (
  `tahun_akademik_id` int(11) NOT NULL,
  `keterangan` varchar(15) NOT NULL,
  `batas_registrasi` date NOT NULL,
  `status` enum('n','y') NOT NULL,
  `tahun` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akademik_tahun_akademik`
--

INSERT INTO `akademik_tahun_akademik` (`tahun_akademik_id`, `keterangan`, `batas_registrasi`, `status`, `tahun`) VALUES
(1, '20141', '2014-09-06', 'n', 2014),
(6, '20142', '2014-09-25', 'y', 0);

-- --------------------------------------------------------

--
-- Table structure for table `akademik_waktu_kuliah`
--

CREATE TABLE IF NOT EXISTS `akademik_waktu_kuliah` (
  `waktu_id` int(11) NOT NULL,
  `keterangan` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `app_agama`
--

CREATE TABLE IF NOT EXISTS `app_agama` (
  `agama_id` int(11) NOT NULL,
  `keterangan` varchar(15) COLLATE utf8_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `app_agama`
--

INSERT INTO `app_agama` (`agama_id`, `keterangan`) VALUES
(1, 'Islam'),
(2, 'Kristen'),
(3, 'Katolik'),
(4, 'Budha'),
(5, 'Hindu'),
(6, 'Kepercayaan');

-- --------------------------------------------------------

--
-- Table structure for table `app_dosen`
--

CREATE TABLE IF NOT EXISTS `app_dosen` (
  `dosen_id` int(11) NOT NULL,
  `nama_lengkap` varchar(70) NOT NULL,
  `nidn` varchar(20) NOT NULL,
  `nip` varchar(22) NOT NULL,
  `no_ktp` varchar(20) NOT NULL,
  `tempat_lahir` varchar(30) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `gender` enum('1','2') NOT NULL,
  `agama_id` int(1) NOT NULL,
  `status_kawin` int(1) NOT NULL COMMENT '1=kawin ,2=belum kawin',
  `gelar_pendidikan` varchar(10) NOT NULL,
  `alamat` text NOT NULL,
  `hp` varchar(12) NOT NULL,
  `email` varchar(40) NOT NULL,
  `prodi_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_dosen`
--

INSERT INTO `app_dosen` (`dosen_id`, `nama_lengkap`, `nidn`, `nip`, `no_ktp`, `tempat_lahir`, `tanggal_lahir`, `gender`, `agama_id`, `status_kawin`, `gelar_pendidikan`, `alamat`, `hp`, `email`, `prodi_id`) VALUES
(37, 'aaa', 'aa', 'aa', '', 'aa', '0000-00-00', '1', 1, 1, '', 'aaaa', '4234', 'e@d.com', 0),
(38, 'aaaa', 'aaa', 'aaaa', '', '', '0000-00-00', '1', 1, 1, '', 'a', '', '', 0),
(39, 'Coba', '', '', '', '', '0000-00-00', '1', 1, 1, '', '', '', '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `app_gedung`
--

CREATE TABLE IF NOT EXISTS `app_gedung` (
  `gedung_id` int(11) NOT NULL,
  `nama_gedung` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_gedung`
--

INSERT INTO `app_gedung` (`gedung_id`, `nama_gedung`) VALUES
(2, 'gedung 1'),
(3, 'gedung 2'),
(4, 'gedung 31');

-- --------------------------------------------------------

--
-- Table structure for table `app_hari`
--

CREATE TABLE IF NOT EXISTS `app_hari` (
  `hari_id` int(11) NOT NULL,
  `hari` varchar(15) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_hari`
--

INSERT INTO `app_hari` (`hari_id`, `hari`) VALUES
(0, 'not set'),
(1, 'senin'),
(2, 'selasa'),
(3, 'rabu'),
(4, 'kamis'),
(5, 'jumat'),
(6, 'sabtu'),
(7, 'minggu');

-- --------------------------------------------------------

--
-- Table structure for table `app_nilai_grade`
--

CREATE TABLE IF NOT EXISTS `app_nilai_grade` (
  `nilai_id` int(11) NOT NULL,
  `dari` float NOT NULL,
  `sampai` float NOT NULL,
  `grade` varchar(1) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_nilai_grade`
--

INSERT INTO `app_nilai_grade` (`nilai_id`, `dari`, `sampai`, `grade`, `keterangan`) VALUES
(1, 9.5, 10, 'A', ''),
(2, 8.5, 9.4, 'B', ''),
(3, 7.5, 8.4, 'C', ''),
(4, 6, 7.4, 'D', 'perbaikan'),
(5, 0, 5.9, 'E', 'tidak lulus'),
(6, 8.5, 9.3, 'a', ' ');

-- --------------------------------------------------------

--
-- Table structure for table `app_pekerjaan`
--

CREATE TABLE IF NOT EXISTS `app_pekerjaan` (
  `pekerjaan_id` varchar(2) NOT NULL,
  `keterangan` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_pekerjaan`
--

INSERT INTO `app_pekerjaan` (`pekerjaan_id`, `keterangan`) VALUES
('01', 'tidak bekerja'),
('02', 'nelayan'),
('03', 'petani'),
('04', 'peternak'),
('05', 'PNS/ TNI/ Polri'),
('06', 'Karyawan Swasta'),
('07', 'Pedagang Kecil'),
('08', 'Pedagang Besar'),
('09', 'Wiraswasta'),
('10', 'Wirausaha'),
('11', 'buruh'),
('12', 'pensiunan'),
('99', 'lainya');

-- --------------------------------------------------------

--
-- Table structure for table `app_ruangan`
--

CREATE TABLE IF NOT EXISTS `app_ruangan` (
  `ruangan_id` int(11) NOT NULL,
  `nama_ruangan` varchar(20) NOT NULL,
  `gedung_id` int(11) NOT NULL,
  `kapasitas` int(11) NOT NULL,
  `keterangan` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_ruangan`
--

INSERT INTO `app_ruangan` (`ruangan_id`, `nama_ruangan`, `gedung_id`, `kapasitas`, `keterangan`) VALUES
(0, 'not set', 0, 0, ''),
(1, 'L1.R06', 2, 25, ''),
(2, 'L1.R05', 2, 25, ''),
(4, 'L1.R07', 2, 25, ''),
(5, 'L1.R08', 2, 50, ''),
(6, 'L1.R09', 2, 25, ''),
(7, 'L2.R02', 2, 20, ''),
(8, 'L2.R03', 2, 20, ''),
(9, 'L2.R04', 2, 20, ''),
(10, 'L2.R05', 2, 20, ''),
(11, 'L2.R06', 2, 20, ''),
(12, 'L2.R07', 2, 25, ''),
(13, 'L2.R08', 2, 25, ''),
(14, 'L2.R09', 2, 20, ''),
(15, 'L2.R10', 2, 20, ''),
(16, 'L3.R03', 2, 60, ''),
(18, 'L1.R03-4', 2, 0, 'lab elektro'),
(19, 'L1.R10', 2, 0, 'lab elektro'),
(20, 'L2.R02', 2, 0, 'lab bahasa'),
(21, 'L3.R02', 2, 0, 'lab jaringan'),
(22, 'L3.R05', 2, 0, 'lab dasar'),
(23, 'L3.R06', 2, 0, 'lab AK'),
(24, 'L3.R07', 2, 0, 'lab multimedia'),
(25, 'L2.R03', 2, 25, ''),
(26, 'L3.R01', 2, 30, ''),
(27, 'ruangan test', 2, 45, 'sampe');

-- --------------------------------------------------------

--
-- Table structure for table `app_users`
--

CREATE TABLE IF NOT EXISTS `app_users` (
  `id_users` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `password` varchar(32) NOT NULL,
  `level` int(1) NOT NULL COMMENT '1=admin ,2=pihak jurusan ,3=pegawai ,4=mahasiswa',
  `keterangan` varchar(5) NOT NULL,
  `last_login` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_users`
--

INSERT INTO `app_users` (`id_users`, `username`, `nama`, `password`, `level`, `keterangan`, `last_login`) VALUES
(1, 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, '', '2016-04-16 01:57:50'),
(4, 'kepalasekolah', '', 'ad9e9366bd65e665fa808da635512230', 2, '6', '2016-04-12 14:26:05'),
(6, 'siswa', '', 'bcd724d15cde8c47650fda962968f102', 3, '1', '2016-04-12 13:27:32'),
(7, 'guru', '', '77e69c137812518e359196bb2f5e9bb9', 4, '2', '2016-04-14 02:31:32'),
(11, 'kepegawaian', '', 'd45de20a488481327b5c7f2600b861cf', 5, '2', '2016-04-12 13:54:09'),
(12, 'a', '', '0cc175b9c0f1b6a831c399e269772661', 3, '34', '2016-04-14 05:21:13'),
(15, 'aaa', '', '47bce5c74f589f4867dbd57e9ca9f808', 3, '37', '0000-00-00 00:00:00'),
(16, '123', '', '202cb962ac59075b964b07152d234b70', 3, '38', '0000-00-00 00:00:00'),
(17, 'guru1', '', '92afb435ceb16630e9827f54330c59c9', 4, '39', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `gammu`
--

CREATE TABLE IF NOT EXISTS `gammu` (
  `Version` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gammu`
--

INSERT INTO `gammu` (`Version`) VALUES
(11),
(11),
(11);

-- --------------------------------------------------------

--
-- Table structure for table `inbox`
--

CREATE TABLE IF NOT EXISTS `inbox` (
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ReceivingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Text` text NOT NULL,
  `SenderNumber` varchar(20) NOT NULL DEFAULT '',
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
  `UDH` text NOT NULL,
  `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
  `Class` int(11) NOT NULL DEFAULT '-1',
  `TextDecoded` text NOT NULL,
  `ID` int(10) unsigned NOT NULL,
  `RecipientID` text NOT NULL,
  `Processed` enum('false','true') NOT NULL DEFAULT 'false'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `keuangan_biaya_kuliah`
--

CREATE TABLE IF NOT EXISTS `keuangan_biaya_kuliah` (
  `biaya_kuliah_id` int(11) NOT NULL,
  `jenis_bayar_id` int(3) NOT NULL,
  `konsentrasi_id` int(3) NOT NULL,
  `angkatan_id` int(3) NOT NULL,
  `jumlah` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=943 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keuangan_biaya_kuliah`
--

INSERT INTO `keuangan_biaya_kuliah` (`biaya_kuliah_id`, `jenis_bayar_id`, `konsentrasi_id`, `angkatan_id`, `jumlah`) VALUES
(227, 1, 1, 2, 500000),
(228, 2, 1, 2, 500000),
(229, 3, 1, 2, 500000),
(230, 9, 1, 2, 500000),
(231, 10, 1, 2, 500000),
(232, 11, 1, 2, 500000),
(233, 19, 1, 2, 500000),
(234, 1, 1, 1, 500000),
(235, 2, 1, 1, 500000),
(236, 3, 1, 1, 500000),
(237, 9, 1, 1, 500000),
(238, 10, 1, 1, 500000),
(239, 11, 1, 1, 500000),
(240, 19, 1, 1, 500000),
(241, 1, 1, 2, 0),
(242, 2, 1, 2, 0),
(243, 3, 1, 2, 0),
(244, 9, 1, 2, 0),
(245, 10, 1, 2, 0),
(246, 11, 1, 2, 0),
(247, 19, 1, 2, 0),
(248, 1, 2, 2, 600000),
(249, 2, 2, 2, 0),
(250, 3, 2, 2, 0),
(251, 9, 2, 2, 0),
(252, 10, 2, 2, 0),
(253, 11, 2, 2, 0),
(254, 19, 2, 2, 0),
(255, 1, 3, 2, 0),
(256, 2, 3, 2, 0),
(257, 3, 3, 2, 0),
(258, 9, 3, 2, 0),
(259, 10, 3, 2, 0),
(260, 11, 3, 2, 0),
(261, 19, 3, 2, 0),
(262, 1, 4, 2, 0),
(263, 2, 4, 2, 0),
(264, 3, 4, 2, 0),
(265, 9, 4, 2, 0),
(266, 10, 4, 2, 0),
(267, 11, 4, 2, 0),
(268, 19, 4, 2, 0),
(269, 1, 5, 2, 0),
(270, 2, 5, 2, 0),
(271, 3, 5, 2, 0),
(272, 9, 5, 2, 0),
(273, 10, 5, 2, 0),
(274, 11, 5, 2, 0),
(275, 19, 5, 2, 0),
(276, 1, 6, 2, 0),
(277, 2, 6, 2, 0),
(278, 3, 6, 2, 0),
(279, 9, 6, 2, 0),
(280, 10, 6, 2, 0),
(281, 11, 6, 2, 0),
(282, 19, 6, 2, 0),
(283, 1, 7, 2, 0),
(284, 2, 7, 2, 0),
(285, 3, 7, 2, 0),
(286, 9, 7, 2, 0),
(287, 10, 7, 2, 0),
(288, 11, 7, 2, 0),
(289, 19, 7, 2, 0),
(290, 1, 8, 2, 0),
(291, 2, 8, 2, 0),
(292, 3, 8, 2, 0),
(293, 9, 8, 2, 0),
(294, 10, 8, 2, 0),
(295, 11, 8, 2, 0),
(296, 19, 8, 2, 0),
(297, 1, 9, 2, 0),
(298, 2, 9, 2, 0),
(299, 3, 9, 2, 0),
(300, 9, 9, 2, 0),
(301, 10, 9, 2, 0),
(302, 11, 9, 2, 0),
(303, 19, 9, 2, 0),
(304, 1, 10, 2, 0),
(305, 2, 10, 2, 0),
(306, 3, 10, 2, 0),
(307, 9, 10, 2, 0),
(308, 10, 10, 2, 0),
(309, 11, 10, 2, 0),
(310, 19, 10, 2, 0),
(311, 1, 11, 2, 0),
(312, 2, 11, 2, 0),
(313, 3, 11, 2, 0),
(314, 9, 11, 2, 0),
(315, 10, 11, 2, 0),
(316, 11, 11, 2, 0),
(317, 19, 11, 2, 0),
(318, 1, 12, 2, 0),
(319, 2, 12, 2, 0),
(320, 3, 12, 2, 0),
(321, 9, 12, 2, 0),
(322, 10, 12, 2, 0),
(323, 11, 12, 2, 0),
(324, 19, 12, 2, 0),
(325, 1, 13, 2, 0),
(326, 2, 13, 2, 0),
(327, 3, 13, 2, 0),
(328, 9, 13, 2, 0),
(329, 10, 13, 2, 0),
(330, 11, 13, 2, 0),
(331, 19, 13, 2, 0),
(332, 1, 14, 2, 0),
(333, 2, 14, 2, 0),
(334, 3, 14, 2, 0),
(335, 9, 14, 2, 0),
(336, 10, 14, 2, 0),
(337, 11, 14, 2, 0),
(338, 19, 14, 2, 0),
(339, 1, 15, 2, 0),
(340, 2, 15, 2, 0),
(341, 3, 15, 2, 0),
(342, 9, 15, 2, 0),
(343, 10, 15, 2, 0),
(344, 11, 15, 2, 0),
(345, 19, 15, 2, 0),
(346, 1, 16, 2, 0),
(347, 2, 16, 2, 0),
(348, 3, 16, 2, 0),
(349, 9, 16, 2, 0),
(350, 10, 16, 2, 0),
(351, 11, 16, 2, 0),
(352, 19, 16, 2, 0),
(353, 1, 17, 2, 0),
(354, 2, 17, 2, 0),
(355, 3, 17, 2, 0),
(356, 9, 17, 2, 0),
(357, 10, 17, 2, 0),
(358, 11, 17, 2, 0),
(359, 19, 17, 2, 0),
(360, 1, 2, 1, 600000),
(361, 2, 2, 1, 0),
(362, 3, 2, 1, 0),
(363, 9, 2, 1, 0),
(364, 10, 2, 1, 600000),
(365, 11, 2, 1, 0),
(366, 19, 2, 1, 0),
(367, 1, 3, 1, 400000),
(368, 2, 3, 1, 300000),
(369, 3, 3, 1, 3400000),
(370, 9, 3, 1, 200000),
(371, 10, 3, 1, 100000),
(372, 11, 3, 1, 100000),
(373, 19, 3, 1, 950000),
(374, 1, 10, 1, 0),
(375, 2, 10, 1, 0),
(376, 3, 10, 1, 0),
(377, 9, 10, 1, 0),
(378, 10, 10, 1, 0),
(379, 11, 10, 1, 0),
(380, 19, 10, 1, 0),
(381, 1, 1, 2, 0),
(382, 2, 1, 2, 0),
(383, 3, 1, 2, 0),
(384, 9, 1, 2, 0),
(385, 10, 1, 2, 0),
(386, 11, 1, 2, 0),
(387, 19, 1, 2, 0),
(388, 1, 2, 2, 0),
(389, 2, 2, 2, 0),
(390, 3, 2, 2, 0),
(391, 9, 2, 2, 0),
(392, 10, 2, 2, 0),
(393, 11, 2, 2, 0),
(394, 19, 2, 2, 0),
(395, 1, 3, 2, 0),
(396, 2, 3, 2, 0),
(397, 3, 3, 2, 0),
(398, 9, 3, 2, 0),
(399, 10, 3, 2, 0),
(400, 11, 3, 2, 0),
(401, 19, 3, 2, 0),
(402, 1, 4, 2, 0),
(403, 2, 4, 2, 0),
(404, 3, 4, 2, 0),
(405, 9, 4, 2, 0),
(406, 10, 4, 2, 0),
(407, 11, 4, 2, 0),
(408, 19, 4, 2, 0),
(409, 1, 5, 2, 0),
(410, 2, 5, 2, 0),
(411, 3, 5, 2, 0),
(412, 9, 5, 2, 0),
(413, 10, 5, 2, 0),
(414, 11, 5, 2, 0),
(415, 19, 5, 2, 0),
(416, 1, 6, 2, 0),
(417, 2, 6, 2, 0),
(418, 3, 6, 2, 0),
(419, 9, 6, 2, 0),
(420, 10, 6, 2, 0),
(421, 11, 6, 2, 0),
(422, 19, 6, 2, 0),
(423, 1, 7, 2, 0),
(424, 2, 7, 2, 0),
(425, 3, 7, 2, 0),
(426, 9, 7, 2, 0),
(427, 10, 7, 2, 0),
(428, 11, 7, 2, 0),
(429, 19, 7, 2, 0),
(430, 1, 8, 2, 0),
(431, 2, 8, 2, 0),
(432, 3, 8, 2, 0),
(433, 9, 8, 2, 0),
(434, 10, 8, 2, 0),
(435, 11, 8, 2, 0),
(436, 19, 8, 2, 0),
(437, 1, 9, 2, 0),
(438, 2, 9, 2, 0),
(439, 3, 9, 2, 0),
(440, 9, 9, 2, 0),
(441, 10, 9, 2, 0),
(442, 11, 9, 2, 0),
(443, 19, 9, 2, 0),
(444, 1, 10, 2, 0),
(445, 2, 10, 2, 0),
(446, 3, 10, 2, 0),
(447, 9, 10, 2, 0),
(448, 10, 10, 2, 0),
(449, 11, 10, 2, 0),
(450, 19, 10, 2, 0),
(451, 1, 11, 2, 0),
(452, 2, 11, 2, 0),
(453, 3, 11, 2, 0),
(454, 9, 11, 2, 0),
(455, 10, 11, 2, 0),
(456, 11, 11, 2, 0),
(457, 19, 11, 2, 0),
(458, 1, 12, 2, 0),
(459, 2, 12, 2, 0),
(460, 3, 12, 2, 0),
(461, 9, 12, 2, 0),
(462, 10, 12, 2, 0),
(463, 11, 12, 2, 0),
(464, 19, 12, 2, 0),
(465, 1, 13, 2, 0),
(466, 2, 13, 2, 0),
(467, 3, 13, 2, 0),
(468, 9, 13, 2, 0),
(469, 10, 13, 2, 0),
(470, 11, 13, 2, 0),
(471, 19, 13, 2, 0),
(472, 1, 14, 2, 0),
(473, 2, 14, 2, 0),
(474, 3, 14, 2, 0),
(475, 9, 14, 2, 0),
(476, 10, 14, 2, 0),
(477, 11, 14, 2, 0),
(478, 19, 14, 2, 0),
(479, 1, 15, 2, 0),
(480, 2, 15, 2, 0),
(481, 3, 15, 2, 0),
(482, 9, 15, 2, 0),
(483, 10, 15, 2, 0),
(484, 11, 15, 2, 0),
(485, 19, 15, 2, 0),
(486, 1, 16, 2, 0),
(487, 2, 16, 2, 0),
(488, 3, 16, 2, 0),
(489, 9, 16, 2, 0),
(490, 10, 16, 2, 0),
(491, 11, 16, 2, 0),
(492, 19, 16, 2, 0),
(493, 1, 17, 2, 0),
(494, 2, 17, 2, 0),
(495, 3, 17, 2, 0),
(496, 9, 17, 2, 0),
(497, 10, 17, 2, 0),
(498, 11, 17, 2, 0),
(499, 19, 17, 2, 0),
(500, 20, 1, 1, 0),
(501, 20, 2, 1, 0),
(502, 20, 3, 1, 0),
(503, 20, 4, 1, 0),
(504, 20, 5, 1, 0),
(505, 20, 6, 1, 0),
(506, 20, 7, 1, 0),
(507, 20, 8, 1, 0),
(508, 20, 9, 1, 0),
(509, 20, 10, 1, 0),
(510, 20, 11, 1, 0),
(511, 20, 12, 1, 0),
(512, 20, 13, 1, 0),
(513, 20, 14, 1, 0),
(514, 20, 15, 1, 0),
(515, 20, 16, 1, 0),
(516, 20, 17, 1, 0),
(517, 22, 1, 1, 0),
(518, 22, 2, 1, 0),
(519, 22, 3, 1, 0),
(520, 22, 4, 1, 0),
(521, 22, 5, 1, 0),
(522, 22, 6, 1, 0),
(523, 22, 7, 1, 0),
(524, 22, 8, 1, 0),
(525, 22, 9, 1, 0),
(526, 22, 10, 1, 0),
(527, 22, 11, 1, 0),
(528, 22, 12, 1, 0),
(529, 22, 13, 1, 0),
(530, 22, 14, 1, 0),
(531, 22, 15, 1, 0),
(532, 22, 16, 1, 0),
(533, 22, 17, 1, 0),
(534, 22, 2, 2, 0),
(535, 1, 1, 2, 0),
(536, 2, 1, 2, 0),
(537, 3, 1, 2, 0),
(538, 9, 1, 2, 0),
(539, 10, 1, 2, 0),
(540, 11, 1, 2, 0),
(541, 19, 1, 2, 0),
(542, 22, 1, 2, 0),
(543, 1, 2, 2, 0),
(544, 2, 2, 2, 0),
(545, 3, 2, 2, 0),
(546, 9, 2, 2, 0),
(547, 10, 2, 2, 0),
(548, 11, 2, 2, 0),
(549, 19, 2, 2, 0),
(550, 22, 2, 2, 0),
(551, 1, 3, 2, 0),
(552, 2, 3, 2, 0),
(553, 3, 3, 2, 0),
(554, 9, 3, 2, 0),
(555, 10, 3, 2, 0),
(556, 11, 3, 2, 0),
(557, 19, 3, 2, 0),
(558, 22, 3, 2, 0),
(559, 1, 4, 2, 0),
(560, 2, 4, 2, 0),
(561, 3, 4, 2, 0),
(562, 9, 4, 2, 0),
(563, 10, 4, 2, 0),
(564, 11, 4, 2, 0),
(565, 19, 4, 2, 0),
(566, 22, 4, 2, 0),
(567, 1, 5, 2, 0),
(568, 2, 5, 2, 0),
(569, 3, 5, 2, 0),
(570, 9, 5, 2, 0),
(571, 10, 5, 2, 0),
(572, 11, 5, 2, 0),
(573, 19, 5, 2, 0),
(574, 22, 5, 2, 0),
(575, 1, 6, 2, 0),
(576, 2, 6, 2, 0),
(577, 3, 6, 2, 0),
(578, 9, 6, 2, 0),
(579, 10, 6, 2, 0),
(580, 11, 6, 2, 0),
(581, 19, 6, 2, 0),
(582, 22, 6, 2, 0),
(583, 1, 7, 2, 0),
(584, 2, 7, 2, 0),
(585, 3, 7, 2, 0),
(586, 9, 7, 2, 0),
(587, 10, 7, 2, 0),
(588, 11, 7, 2, 0),
(589, 19, 7, 2, 0),
(590, 22, 7, 2, 0),
(591, 1, 8, 2, 0),
(592, 2, 8, 2, 0),
(593, 3, 8, 2, 0),
(594, 9, 8, 2, 0),
(595, 10, 8, 2, 0),
(596, 11, 8, 2, 0),
(597, 19, 8, 2, 0),
(598, 22, 8, 2, 0),
(599, 1, 9, 2, 0),
(600, 2, 9, 2, 0),
(601, 3, 9, 2, 0),
(602, 9, 9, 2, 0),
(603, 10, 9, 2, 0),
(604, 11, 9, 2, 0),
(605, 19, 9, 2, 0),
(606, 22, 9, 2, 0),
(607, 1, 10, 2, 0),
(608, 2, 10, 2, 0),
(609, 3, 10, 2, 0),
(610, 9, 10, 2, 0),
(611, 10, 10, 2, 0),
(612, 11, 10, 2, 0),
(613, 19, 10, 2, 0),
(614, 22, 10, 2, 0),
(615, 1, 11, 2, 0),
(616, 2, 11, 2, 0),
(617, 3, 11, 2, 0),
(618, 9, 11, 2, 0),
(619, 10, 11, 2, 0),
(620, 11, 11, 2, 0),
(621, 19, 11, 2, 0),
(622, 22, 11, 2, 0),
(623, 1, 12, 2, 0),
(624, 2, 12, 2, 0),
(625, 3, 12, 2, 0),
(626, 9, 12, 2, 0),
(627, 10, 12, 2, 0),
(628, 11, 12, 2, 0),
(629, 19, 12, 2, 0),
(630, 22, 12, 2, 0),
(631, 1, 13, 2, 0),
(632, 2, 13, 2, 0),
(633, 3, 13, 2, 0),
(634, 9, 13, 2, 0),
(635, 10, 13, 2, 0),
(636, 11, 13, 2, 0),
(637, 19, 13, 2, 0),
(638, 22, 13, 2, 0),
(639, 1, 14, 2, 0),
(640, 2, 14, 2, 0),
(641, 3, 14, 2, 0),
(642, 9, 14, 2, 0),
(643, 10, 14, 2, 0),
(644, 11, 14, 2, 0),
(645, 19, 14, 2, 0),
(646, 22, 14, 2, 0),
(647, 1, 15, 2, 0),
(648, 2, 15, 2, 0),
(649, 3, 15, 2, 0),
(650, 9, 15, 2, 0),
(651, 10, 15, 2, 0),
(652, 11, 15, 2, 0),
(653, 19, 15, 2, 0),
(654, 22, 15, 2, 0),
(655, 1, 16, 2, 0),
(656, 2, 16, 2, 0),
(657, 3, 16, 2, 0),
(658, 9, 16, 2, 0),
(659, 10, 16, 2, 0),
(660, 11, 16, 2, 0),
(661, 19, 16, 2, 0),
(662, 22, 16, 2, 0),
(663, 1, 17, 2, 0),
(664, 2, 17, 2, 0),
(665, 3, 17, 2, 0),
(666, 9, 17, 2, 0),
(667, 10, 17, 2, 0),
(668, 11, 17, 2, 0),
(669, 19, 17, 2, 0),
(670, 22, 17, 2, 0),
(671, 1, 1, 2, 0),
(672, 2, 1, 2, 0),
(673, 3, 1, 2, 0),
(674, 9, 1, 2, 0),
(675, 10, 1, 2, 0),
(676, 11, 1, 2, 0),
(677, 19, 1, 2, 0),
(678, 22, 1, 2, 0),
(679, 1, 2, 2, 0),
(680, 2, 2, 2, 0),
(681, 3, 2, 2, 0),
(682, 9, 2, 2, 0),
(683, 10, 2, 2, 0),
(684, 11, 2, 2, 0),
(685, 19, 2, 2, 0),
(686, 22, 2, 2, 0),
(687, 1, 3, 2, 0),
(688, 2, 3, 2, 0),
(689, 3, 3, 2, 0),
(690, 9, 3, 2, 0),
(691, 10, 3, 2, 0),
(692, 11, 3, 2, 0),
(693, 19, 3, 2, 0),
(694, 22, 3, 2, 0),
(695, 1, 4, 2, 0),
(696, 2, 4, 2, 0),
(697, 3, 4, 2, 0),
(698, 9, 4, 2, 0),
(699, 10, 4, 2, 0),
(700, 11, 4, 2, 0),
(701, 19, 4, 2, 0),
(702, 22, 4, 2, 0),
(703, 1, 5, 2, 0),
(704, 2, 5, 2, 0),
(705, 3, 5, 2, 0),
(706, 9, 5, 2, 0),
(707, 10, 5, 2, 0),
(708, 11, 5, 2, 0),
(709, 19, 5, 2, 0),
(710, 22, 5, 2, 0),
(711, 1, 6, 2, 0),
(712, 2, 6, 2, 0),
(713, 3, 6, 2, 0),
(714, 9, 6, 2, 0),
(715, 10, 6, 2, 0),
(716, 11, 6, 2, 0),
(717, 19, 6, 2, 0),
(718, 22, 6, 2, 0),
(719, 1, 7, 2, 0),
(720, 2, 7, 2, 0),
(721, 3, 7, 2, 0),
(722, 9, 7, 2, 0),
(723, 10, 7, 2, 0),
(724, 11, 7, 2, 0),
(725, 19, 7, 2, 0),
(726, 22, 7, 2, 0),
(727, 1, 8, 2, 0),
(728, 2, 8, 2, 0),
(729, 3, 8, 2, 0),
(730, 9, 8, 2, 0),
(731, 10, 8, 2, 0),
(732, 11, 8, 2, 0),
(733, 19, 8, 2, 0),
(734, 22, 8, 2, 0),
(735, 1, 9, 2, 0),
(736, 2, 9, 2, 0),
(737, 3, 9, 2, 0),
(738, 9, 9, 2, 0),
(739, 10, 9, 2, 0),
(740, 11, 9, 2, 0),
(741, 19, 9, 2, 0),
(742, 22, 9, 2, 0),
(743, 1, 10, 2, 0),
(744, 2, 10, 2, 0),
(745, 3, 10, 2, 0),
(746, 9, 10, 2, 0),
(747, 10, 10, 2, 0),
(748, 11, 10, 2, 0),
(749, 19, 10, 2, 0),
(750, 22, 10, 2, 0),
(751, 1, 11, 2, 0),
(752, 2, 11, 2, 0),
(753, 3, 11, 2, 0),
(754, 9, 11, 2, 0),
(755, 10, 11, 2, 0),
(756, 11, 11, 2, 0),
(757, 19, 11, 2, 0),
(758, 22, 11, 2, 0),
(759, 1, 12, 2, 0),
(760, 2, 12, 2, 0),
(761, 3, 12, 2, 0),
(762, 9, 12, 2, 0),
(763, 10, 12, 2, 0),
(764, 11, 12, 2, 0),
(765, 19, 12, 2, 0),
(766, 22, 12, 2, 0),
(767, 1, 13, 2, 0),
(768, 2, 13, 2, 0),
(769, 3, 13, 2, 0),
(770, 9, 13, 2, 0),
(771, 10, 13, 2, 0),
(772, 11, 13, 2, 0),
(773, 19, 13, 2, 0),
(774, 22, 13, 2, 0),
(775, 1, 14, 2, 0),
(776, 2, 14, 2, 0),
(777, 3, 14, 2, 0),
(778, 9, 14, 2, 0),
(779, 10, 14, 2, 0),
(780, 11, 14, 2, 0),
(781, 19, 14, 2, 0),
(782, 22, 14, 2, 0),
(783, 1, 15, 2, 0),
(784, 2, 15, 2, 0),
(785, 3, 15, 2, 0),
(786, 9, 15, 2, 0),
(787, 10, 15, 2, 0),
(788, 11, 15, 2, 0),
(789, 19, 15, 2, 0),
(790, 22, 15, 2, 0),
(791, 1, 16, 2, 0),
(792, 2, 16, 2, 0),
(793, 3, 16, 2, 0),
(794, 9, 16, 2, 0),
(795, 10, 16, 2, 0),
(796, 11, 16, 2, 0),
(797, 19, 16, 2, 0),
(798, 22, 16, 2, 0),
(799, 1, 17, 2, 0),
(800, 2, 17, 2, 0),
(801, 3, 17, 2, 0),
(802, 9, 17, 2, 0),
(803, 10, 17, 2, 0),
(804, 11, 17, 2, 0),
(805, 19, 17, 2, 0),
(806, 22, 17, 2, 0),
(807, 1, 1, 2, 0),
(808, 2, 1, 2, 0),
(809, 3, 1, 2, 0),
(810, 9, 1, 2, 0),
(811, 10, 1, 2, 0),
(812, 11, 1, 2, 0),
(813, 19, 1, 2, 0),
(814, 22, 1, 2, 0),
(815, 1, 2, 2, 0),
(816, 2, 2, 2, 0),
(817, 3, 2, 2, 0),
(818, 9, 2, 2, 0),
(819, 10, 2, 2, 0),
(820, 11, 2, 2, 0),
(821, 19, 2, 2, 0),
(822, 22, 2, 2, 0),
(823, 1, 3, 2, 0),
(824, 2, 3, 2, 0),
(825, 3, 3, 2, 0),
(826, 9, 3, 2, 0),
(827, 10, 3, 2, 0),
(828, 11, 3, 2, 0),
(829, 19, 3, 2, 0),
(830, 22, 3, 2, 0),
(831, 1, 4, 2, 0),
(832, 2, 4, 2, 0),
(833, 3, 4, 2, 0),
(834, 9, 4, 2, 0),
(835, 10, 4, 2, 0),
(836, 11, 4, 2, 0),
(837, 19, 4, 2, 0),
(838, 22, 4, 2, 0),
(839, 1, 5, 2, 0),
(840, 2, 5, 2, 0),
(841, 3, 5, 2, 0),
(842, 9, 5, 2, 0),
(843, 10, 5, 2, 0),
(844, 11, 5, 2, 0),
(845, 19, 5, 2, 0),
(846, 22, 5, 2, 0),
(847, 1, 6, 2, 0),
(848, 2, 6, 2, 0),
(849, 3, 6, 2, 0),
(850, 9, 6, 2, 0),
(851, 10, 6, 2, 0),
(852, 11, 6, 2, 0),
(853, 19, 6, 2, 0),
(854, 22, 6, 2, 0),
(855, 1, 7, 2, 0),
(856, 2, 7, 2, 0),
(857, 3, 7, 2, 0),
(858, 9, 7, 2, 0),
(859, 10, 7, 2, 0),
(860, 11, 7, 2, 0),
(861, 19, 7, 2, 0),
(862, 22, 7, 2, 0),
(863, 1, 8, 2, 0),
(864, 2, 8, 2, 0),
(865, 3, 8, 2, 0),
(866, 9, 8, 2, 0),
(867, 10, 8, 2, 0),
(868, 11, 8, 2, 0),
(869, 19, 8, 2, 0),
(870, 22, 8, 2, 0),
(871, 1, 9, 2, 0),
(872, 2, 9, 2, 0),
(873, 3, 9, 2, 0),
(874, 9, 9, 2, 0),
(875, 10, 9, 2, 0),
(876, 11, 9, 2, 0),
(877, 19, 9, 2, 0),
(878, 22, 9, 2, 0),
(879, 1, 10, 2, 0),
(880, 2, 10, 2, 0),
(881, 3, 10, 2, 0),
(882, 9, 10, 2, 0),
(883, 10, 10, 2, 0),
(884, 11, 10, 2, 0),
(885, 19, 10, 2, 0),
(886, 22, 10, 2, 0),
(887, 1, 11, 2, 0),
(888, 2, 11, 2, 0),
(889, 3, 11, 2, 0),
(890, 9, 11, 2, 0),
(891, 10, 11, 2, 0),
(892, 11, 11, 2, 0),
(893, 19, 11, 2, 0),
(894, 22, 11, 2, 0),
(895, 1, 12, 2, 0),
(896, 2, 12, 2, 0),
(897, 3, 12, 2, 0),
(898, 9, 12, 2, 0),
(899, 10, 12, 2, 0),
(900, 11, 12, 2, 0),
(901, 19, 12, 2, 0),
(902, 22, 12, 2, 0),
(903, 1, 13, 2, 0),
(904, 2, 13, 2, 0),
(905, 3, 13, 2, 0),
(906, 9, 13, 2, 0),
(907, 10, 13, 2, 0),
(908, 11, 13, 2, 0),
(909, 19, 13, 2, 0),
(910, 22, 13, 2, 0),
(911, 1, 14, 2, 0),
(912, 2, 14, 2, 0),
(913, 3, 14, 2, 0),
(914, 9, 14, 2, 0),
(915, 10, 14, 2, 0),
(916, 11, 14, 2, 0),
(917, 19, 14, 2, 0),
(918, 22, 14, 2, 0),
(919, 1, 15, 2, 0),
(920, 2, 15, 2, 0),
(921, 3, 15, 2, 0),
(922, 9, 15, 2, 0),
(923, 10, 15, 2, 0),
(924, 11, 15, 2, 0),
(925, 19, 15, 2, 0),
(926, 22, 15, 2, 0),
(927, 1, 16, 2, 0),
(928, 2, 16, 2, 0),
(929, 3, 16, 2, 0),
(930, 9, 16, 2, 0),
(931, 10, 16, 2, 0),
(932, 11, 16, 2, 0),
(933, 19, 16, 2, 0),
(934, 22, 16, 2, 0),
(935, 1, 17, 2, 0),
(936, 2, 17, 2, 0),
(937, 3, 17, 2, 0),
(938, 9, 17, 2, 0),
(939, 10, 17, 2, 0),
(940, 11, 17, 2, 0),
(941, 19, 17, 2, 0),
(942, 22, 17, 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `keuangan_jenis_bayar`
--

CREATE TABLE IF NOT EXISTS `keuangan_jenis_bayar` (
  `jenis_bayar_id` int(11) NOT NULL,
  `keterangan` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keuangan_jenis_bayar`
--

INSERT INTO `keuangan_jenis_bayar` (`jenis_bayar_id`, `keterangan`) VALUES
(1, 'pendaftaran'),
(2, 'peka'),
(3, 'spp'),
(9, 'dsp'),
(10, 'kemahasiswaan'),
(11, 'asuransi'),
(19, 'wisuda'),
(22, 'xzxzxdsd');

-- --------------------------------------------------------

--
-- Table structure for table `keuangan_pembayaran`
--

CREATE TABLE IF NOT EXISTS `keuangan_pembayaran` (
  `pembayaran_id` int(11) NOT NULL,
  `mahasiswa_id` int(11) NOT NULL,
  `semester` int(11) NOT NULL,
  `no_bayar` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `keuangan_pembayaran_detail`
--

CREATE TABLE IF NOT EXISTS `keuangan_pembayaran_detail` (
  `pembayara_detail_id` int(11) NOT NULL,
  `tanggal` datetime NOT NULL,
  `nim` varchar(11) NOT NULL,
  `jenis_bayar_id` int(11) NOT NULL,
  `id_users` int(11) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `semester` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keuangan_pembayaran_detail`
--

INSERT INTO `keuangan_pembayaran_detail` (`pembayara_detail_id`, `tanggal`, `nim`, `jenis_bayar_id`, `id_users`, `jumlah`, `semester`) VALUES
(13, '2014-06-04 14:03:51', 'TI102134', 1, 1, 400000, 0),
(14, '2014-06-04 14:07:16', 'TI102134', 3, 1, 3400000, 1),
(15, '2014-06-04 14:07:37', 'TI102134', 3, 1, 3400000, 2),
(16, '2014-06-04 14:07:49', 'TI102134', 2, 1, 150000, 0),
(17, '2014-06-14 10:09:00', 'KA131002', 3, 1, 3400000, 1),
(18, '2014-06-14 10:09:37', 'KA131002', 3, 1, 3400000, 2),
(19, '2014-06-14 14:57:34', 'ti102134', 10, 1, 100000, 0);

-- --------------------------------------------------------

--
-- Table structure for table `keuangan_transaksi`
--

CREATE TABLE IF NOT EXISTS `keuangan_transaksi` (
  `transaksi_id` int(11) NOT NULL,
  `tanggal` datetime NOT NULL,
  `nim` varchar(8) NOT NULL,
  `biaya_kuliah_id` int(11) NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` text NOT NULL,
  `added_by` int(11) NOT NULL,
  `semester` int(11) NOT NULL,
  `status` int(11) NOT NULL COMMENT 'L=lunas ,1= cicilan ke 1 ,2=cicilan ke 2, 3=cicilan ke 3'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `mainmenu`
--

CREATE TABLE IF NOT EXISTS `mainmenu` (
  `id_mainmenu` int(11) NOT NULL,
  `nama_mainmenu` varchar(100) NOT NULL,
  `icon` varchar(30) NOT NULL,
  `aktif` enum('y','t') NOT NULL,
  `link` varchar(50) NOT NULL,
  `level` int(11) NOT NULL COMMENT '1= admin,2=jurusan,3 dosen'
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mainmenu`
--

INSERT INTO `mainmenu` (`id_mainmenu`, `nama_mainmenu`, `icon`, `aktif`, `link`, `level`) VALUES
(11, 'kelola data siswa', '', 'y', '#', 1),
(12, 'kelola data guru', '', 'y', 'guru', 1),
(13, 'kelola mata pelajaran', '', 'y', 'matakuliah', 1),
(14, 'pembelajaran', '', 'y', '#', 1),
(15, 'keuangan', '', 'y', '#', 1),
(19, 'pengguna sistem', '', 'y', 'users', 1),
(34, 'data guru', '', 'y', '#', 2),
(35, 'data siswa', '', 'y', '#', 2),
(36, 'Data Nilai', '', 'y', '#', 2),
(37, 'jadwal', '', 'y', '#', 3),
(38, 'absen siswa', '', 'y', '#', 3),
(39, 'nilai', '', 'y', '#', 3),
(40, 'bodata', '', 'y', '#', 3),
(41, 'data siswa', '', 'y', '#', 4),
(42, 'kelola nilai', '', '', '', 4),
(50, 'lihat laporan', '', 'y', '#', 2),
(52, 'data siswa', '', 'y', '#', 4),
(53, 'data nilai', '', 'y', '#', 4),
(54, 'data guru', '', 'y', '#', 5),
(55, 'Kelola Gaji', '', 'y', '#', 5),
(56, 'laporan gaji', '', 'y', '', 5);

-- --------------------------------------------------------

--
-- Table structure for table `makul_kelompok`
--

CREATE TABLE IF NOT EXISTS `makul_kelompok` (
  `kelompok_id` int(11) NOT NULL,
  `kode_kelompok` varchar(5) NOT NULL,
  `nama` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `makul_kelompok`
--

INSERT INTO `makul_kelompok` (`kelompok_id`, `kode_kelompok`, `nama`) VALUES
(1, 'teori', 'teori'),
(2, 'prakt', 'Praktikum');

-- --------------------------------------------------------

--
-- Table structure for table `makul_matakuliah`
--

CREATE TABLE IF NOT EXISTS `makul_matakuliah` (
  `makul_id` int(11) NOT NULL,
  `kode_makul` varchar(11) NOT NULL,
  `nama_makul` varchar(60) NOT NULL,
  `sks` int(11) NOT NULL,
  `semester` int(1) NOT NULL,
  `konsentrasi_id` int(3) NOT NULL,
  `kelompok_id` int(1) NOT NULL,
  `aktif` enum('y','n') NOT NULL,
  `jam` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `makul_matakuliah`
--

INSERT INTO `makul_matakuliah` (`makul_id`, `kode_makul`, `nama_makul`, `sks`, `semester`, `konsentrasi_id`, `kelompok_id`, `aktif`, `jam`) VALUES
(26, 'DTIKB24', 'REKAYASA PERANGKAT LUNAK', 4, 5, 3, 2, 'y', 4),
(27, 'DTIKB25', 'SISTEM KEAMANAN JARINGAN', 4, 5, 3, 2, 'y', 4),
(28, 'DTIKB26', 'PEMROGRAMAN BERBASIS OBJEK', 4, 5, 3, 2, 'y', 4),
(29, 'DTIKB27', 'ROBOTIK', 4, 5, 3, 2, 'y', 4),
(30, 'DTIKB28', 'SISTEM MULTIMEDIA', 4, 5, 3, 2, 'y', 4),
(31, 'DTIKB29', 'KOMPUTER ANIMASI', 4, 6, 3, 2, 'y', 4),
(32, 'DTIKB30', 'SIMULASI & PEMODELAN', 4, 6, 3, 2, 'y', 4),
(33, 'DTIKB31', 'PENGOLAHAN SINYAL DIGITAL', 4, 6, 3, 2, 'y', 4),
(34, 'DTIKB32', 'KECERDASAN BUATAN', 4, 6, 3, 2, 'y', 4),
(35, 'DTIKB33', 'DATA WAREHOUSE', 4, 6, 3, 2, 'y', 4),
(36, 'DTIKB34', 'JARINGAN KOMPUTER 2', 4, 6, 3, 2, 'y', 4),
(37, 'DTIKB35', 'PRAKTEK BASIS DATA', 4, 7, 3, 2, 'y', 4),
(38, 'DTIKB36', 'PRAKTEK JARINGAN', 4, 7, 3, 2, 'y', 4),
(39, 'DTIKB37', 'PRAKTEK PEMOGRAMAN', 4, 7, 3, 2, 'y', 4),
(40, 'DTIKB38', 'PRAKTEK PEMOGRAMAN WEB', 4, 7, 3, 2, 'y', 4),
(41, 'DTIKB39', 'DATA MINING', 4, 7, 3, 2, 'y', 4),
(42, 'DTIKB40', 'MACHINE LEARNING', 4, 7, 3, 2, 'y', 4),
(43, 'DTIKB41', 'KEAMANAN DATA', 4, 8, 3, 2, 'y', 4),
(44, 'DTIKB42', 'PRAKTEK KEAMANAN DATA', 4, 8, 3, 2, 'y', 4),
(45, 'DTIKB43', 'ISSU PROFESIONAL DAN SOSIAL IT', 4, 8, 3, 2, 'y', 4),
(46, 'DTIKK01', 'MATEMATIKA 1', 4, 8, 3, 2, 'y', 4),
(47, 'DTIKK02', 'MATEMATIKA 2', 4, 8, 3, 2, 'y', 4),
(48, 'DTIKK03', 'STATISTIK & PROBABILITAS', 4, 8, 3, 2, 'y', 4),
(49, 'DTIKK04', 'PERANGKAT LUNAK APLIKASI', 4, 9, 3, 2, 'y', 4),
(50, '11', '111', 1, 1, 1, 1, 'y', 2);

-- --------------------------------------------------------

--
-- Table structure for table `outbox`
--

CREATE TABLE IF NOT EXISTS `outbox` (
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `SendingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Text` text,
  `DestinationNumber` varchar(20) NOT NULL DEFAULT '',
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
  `UDH` text,
  `Class` int(11) DEFAULT '-1',
  `TextDecoded` text NOT NULL,
  `ID` int(10) unsigned NOT NULL,
  `MultiPart` enum('false','true') DEFAULT 'false',
  `RelativeValidity` int(11) DEFAULT '-1',
  `SenderID` varchar(255) DEFAULT NULL,
  `SendingTimeOut` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `DeliveryReport` enum('default','yes','no') DEFAULT 'default',
  `CreatorID` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `outbox`
--

INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID`) VALUES
('2014-05-12 09:23:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 46, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:23:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 45, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:23:17', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 44, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:23:02', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 42, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:23:17', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 43, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:23:02', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 41, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:24:02', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 47, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-12 09:24:02', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 48, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-22 03:14:25', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah -500000', 49, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris'),
('2014-05-22 03:14:25', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '082121473036', 'Default_No_Compression', NULL, -1, 'Biaya Tunggakan Keuangan anak anda adalah 4750000', 50, 'false', -1, 'keuangan', '0000-00-00 00:00:00', 'default', 'Nuris');

-- --------------------------------------------------------

--
-- Table structure for table `outbox_multipart`
--

CREATE TABLE IF NOT EXISTS `outbox_multipart` (
  `Text` text,
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
  `UDH` text,
  `Class` int(11) DEFAULT '-1',
  `TextDecoded` text,
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `SequencePosition` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `pbk`
--

CREATE TABLE IF NOT EXISTS `pbk` (
  `ID` int(11) NOT NULL,
  `GroupID` int(11) NOT NULL DEFAULT '-1',
  `Name` text NOT NULL,
  `Number` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `pbk_groups`
--

CREATE TABLE IF NOT EXISTS `pbk_groups` (
  `Name` text NOT NULL,
  `ID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `phones`
--

CREATE TABLE IF NOT EXISTS `phones` (
  `ID` text NOT NULL,
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `TimeOut` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Send` enum('yes','no') NOT NULL DEFAULT 'no',
  `Receive` enum('yes','no') NOT NULL DEFAULT 'no',
  `IMEI` varchar(35) NOT NULL,
  `Client` text NOT NULL,
  `Battery` int(11) NOT NULL DEFAULT '0',
  `Signal` int(11) NOT NULL DEFAULT '0',
  `Sent` int(11) NOT NULL DEFAULT '0',
  `Received` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phones`
--

INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client`, `Battery`, `Signal`, `Sent`, `Received`) VALUES
('keuangan', '2014-05-12 01:27:43', '2014-05-11 23:20:24', '2014-05-12 01:27:53', 'yes', 'yes', '354058180822796', 'Gammu 1.28.90, Windows Server 2007, GCC 4.4, MinGW 3.13', 0, 0, 3, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sentitems`
--

CREATE TABLE IF NOT EXISTS `sentitems` (
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `SendingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DeliveryDateTime` timestamp NULL DEFAULT NULL,
  `Text` text NOT NULL,
  `DestinationNumber` varchar(20) NOT NULL DEFAULT '',
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
  `UDH` text NOT NULL,
  `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
  `Class` int(11) NOT NULL DEFAULT '-1',
  `TextDecoded` text NOT NULL,
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
  `SenderID` varchar(255) NOT NULL,
  `SequencePosition` int(11) NOT NULL DEFAULT '1',
  `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL DEFAULT 'SendingOK',
  `StatusError` int(11) NOT NULL DEFAULT '-1',
  `TPMR` int(11) NOT NULL DEFAULT '-1',
  `RelativeValidity` int(11) NOT NULL DEFAULT '-1',
  `CreatorID` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sentitems`
--

INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID`) VALUES
('2014-04-27 23:08:17', '0000-00-00 00:00:00', '2014-04-27 23:08:17', NULL, '00740065007300740069006E006700200073006D0073002000700065007200740061006D0061', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'testing sms pertama', 1, 'testingSMS', 1, 'SendingOKNoReport', -1, 19, 255, 'Gammu 1.28.90'),
('2014-04-27 23:26:31', '0000-00-00 00:00:00', '2014-04-27 23:26:31', NULL, '007400650073007400200073006D00730020006B0065006400750061', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'test sms kedua', 2, 'testingSMS', 1, 'SendingError', -1, -1, 255, 'nuris'),
('2014-04-27 23:28:50', '0000-00-00 00:00:00', '2014-04-27 23:28:50', NULL, '006800680068006800680068', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'hhhhhh', 8, 'testingSMS', 1, 'SendingOKNoReport', -1, 20, 255, 'Gammu 1.28.90'),
('2014-04-27 23:28:53', '0000-00-00 00:00:00', '2014-04-27 23:28:53', NULL, '00680061006C006C006F0020006E0075007200690073', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'hallo nuris', 3, 'testingSMS', 1, 'SendingOKNoReport', -1, 21, 255, 'Gammu'),
('2014-04-27 23:28:56', '0000-00-00 00:00:00', '2014-04-27 23:28:56', NULL, '00680061006C006C006F0020006E0075007200690073', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'hallo nuris', 4, 'testingSMS', 1, 'SendingOKNoReport', -1, 22, 255, 'Gammu'),
('2014-04-27 23:29:00', '0000-00-00 00:00:00', '2014-04-27 23:29:00', NULL, '0068006100690020006E007500720069007300200061006B006200610072', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'hai nuris akbar', 5, 'testingSMS', 1, 'SendingOKNoReport', -1, 23, 255, 'Gammu 1.28.90'),
('2014-04-27 23:29:03', '0000-00-00 00:00:00', '2014-04-27 23:29:03', NULL, '0068006100690020006E007500720069007300200061006B0062006100720032', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'hai nuris akbar2', 6, 'testingSMS', 1, 'SendingOKNoReport', -1, 24, 255, 'Gammu 1.28.90'),
('2014-04-27 23:29:06', '0000-00-00 00:00:00', '2014-04-27 23:29:06', NULL, '00630063006300630063', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'ccccc', 7, 'testingSMS', 1, 'SendingOKNoReport', -1, 25, 255, 'Gammu 1.28.90'),
('2014-04-27 23:29:09', '0000-00-00 00:00:00', '2014-04-27 23:29:09', NULL, '006B006B006B006B006B', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'kkkkk', 9, 'testingSMS', 1, 'SendingOKNoReport', -1, 26, 255, 'Gammu 1.28.90'),
('2014-04-27 23:45:17', '0000-00-00 00:00:00', '2014-04-27 23:45:17', NULL, '0063006F006200610020006B006900720069006D0020006400610072006900200063006F0064006500690067006E0069007400650072', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'coba kirim dari codeigniter', 10, 'testingSMS', 1, 'SendingOKNoReport', -1, 27, 255, 'Gammu 1.28.90'),
('2014-04-27 23:45:21', '0000-00-00 00:00:00', '2014-04-27 23:45:21', NULL, '0063006F006200610020006B006900720069006D0020006400610072006900200063006F0064006500690067006E00690074006500720020006B0065006400750061', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'coba kirim dari codeigniter kedua', 11, 'testingSMS', 1, 'SendingOKNoReport', -1, 28, 255, 'Gammu 1.28.90'),
('2014-04-27 23:45:56', '0000-00-00 00:00:00', '2014-04-27 23:45:56', NULL, '0063006F006200610020006B006900720069006D0020006400610072006900200063006F0064006500690067006E00690074006500720020006B00650074006900670061', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'coba kirim dari codeigniter ketiga', 12, 'testingSMS', 1, 'SendingOKNoReport', -1, 29, 255, 'Gammu 1.28.90'),
('2014-04-27 23:49:01', '0000-00-00 00:00:00', '2014-04-27 23:49:01', NULL, '006800610069002000620072006F', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'hai bro', 13, 'testingSMS', 1, 'SendingOKNoReport', -1, 30, 255, 'Gammu 1.28.90'),
('2014-04-28 00:30:10', '0000-00-00 00:00:00', '2014-04-28 00:30:10', NULL, '0057006500620020006F006600200049006E0066006F0072006D006100740069006F006E002000530079007300740065006D0020006F006600200041006B006100640065006D00690063002000500072006F006700720061006D00200053007400750064007900200049006E0073007400720075006D0065006E0074006100740069006F006E000D000A00200020002000200020002000200020002000200020002000200020002000200061006E006400200045006C0065006300740072006F006E006900630073002000680061007600650020006200650065006E002000640065007300690067006E0065006400200061006E0064002000630061006E0020006200650020006100630063006500730073006500640020007400680072006F00750067006800200069006E007400650072', '082121473036', 'Default_No_Compression', '0500038C0301', '+6289644000001', -1, 'Web of Information System of Akademic Program Study Instrumentation\r\n                and Electronics have been designed and can be accessed through inter', 15, 'testingSMS', 1, 'SendingOKNoReport', -1, 31, 255, 'Gammu'),
('2014-04-28 00:30:14', '0000-00-00 00:00:00', '2014-04-28 00:30:14', NULL, '006E00650074002E0020004200790020007700650062000D000A002000200020002000200020002000200020002000200020002000200020002000740068006500200061006C006C00200069006E0066006F0072006D006100740069006F006E002000610062006F007500740020006B006E006F007700610062006C006500200061006B006100640065006D00690063002E000D000A0020002000200020002000200020002000200020002000200020002000200020005700650062002000640065007300690067006E0065006400200072006500700072006500730065006E0074002000640079006E0061006D00690063002000770065006200200073006F00200074006800610074002000630061006E0020006D0061006B0065002000610020006300680061006E0067006500200064', '082121473036', 'Default_No_Compression', '0500038C0302', '+6289644000001', -1, 'net. By web\r\n                the all information about knowable akademic.\r\n                Web designed represent dynamic web so that can make a change d', 15, 'testingSMS', 2, 'SendingOKNoReport', -1, 32, 255, 'Gammu'),
('2014-04-28 00:30:16', '0000-00-00 00:00:00', '2014-04-28 00:30:16', NULL, '006100740061002000610074002E', '082121473036', 'Default_No_Compression', '0500038C0303', '+6289644000001', -1, 'ata at.', 15, 'testingSMS', 3, 'SendingOKNoReport', -1, 33, 255, 'Gammu'),
('2014-05-11 09:21:47', '0000-00-00 00:00:00', '2014-05-11 09:21:47', NULL, '0067006600670066006700660067', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'gfgfgfg', 23, 'keuangan', 1, 'SendingOKNoReport', -1, 134, 255, 'Gammu 1.28.90'),
('2014-05-11 23:20:58', '0000-00-00 00:00:00', '2014-05-11 23:20:58', NULL, '0074006500730020006B006900720069006D00200073006D0073', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'tes kirim sms', 36, 'keuangan', 1, 'SendingOKNoReport', -1, 160, 255, 'Gammu 1.28.90'),
('2014-05-11 23:25:35', '0000-00-00 00:00:00', '2014-05-11 23:25:35', NULL, '00420069006100790061002000540075006E006700670061006B0061006E0020004B006500750061006E00670061006E00200061006E0061006B00200061006E006400610020006100640061006C0061006800200033003500300030003000300030', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'Biaya Tunggakan Keuangan anak anda adalah 3500000', 40, 'keuangan', 1, 'SendingOKNoReport', -1, 161, 255, 'Nuris'),
('2014-05-11 23:25:38', '0000-00-00 00:00:00', '2014-05-11 23:25:38', NULL, '00420069006100790061002000540075006E006700670061006B0061006E0020004B006500750061006E00670061006E00200061006E0061006B00200061006E006400610020006100640061006C0061006800200031003400300030003000300030', '082121473036', 'Default_No_Compression', '', '+6289644000001', -1, 'Biaya Tunggakan Keuangan anak anda adalah 1400000', 39, 'keuangan', 1, 'SendingOKNoReport', -1, 162, 255, 'Nuris');

-- --------------------------------------------------------

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(11) NOT NULL,
  `nama_kampus` varchar(160) NOT NULL,
  `alamat_kampus` text NOT NULL,
  `telpon` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `nama_kampus`, `alamat_kampus`, `telpon`) VALUES
(1, 'politeknik tedc bandung1', 'cimahi', '0218765431'),
(2, 'Telkom University', 'Jl. Telekomunikasi', '');

-- --------------------------------------------------------

--
-- Table structure for table `student_absen`
--

CREATE TABLE IF NOT EXISTS `student_absen` (
  `absen_id` int(11) NOT NULL,
  `jadwal_id` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_absen`
--

INSERT INTO `student_absen` (`absen_id`, `jadwal_id`, `tanggal`, `keterangan`) VALUES
(4, 7, '2014-06-08', 'sample materi'),
(5, 1, '2014-06-08', 'sample aja'),
(6, 85, '2014-07-21', 'trobleshooting jaringan'),
(7, 73, '2014-07-25', 'sample materi'),
(8, 85, '2014-09-05', 'sample'),
(9, 85, '2014-09-06', 'vggvgv');

-- --------------------------------------------------------

--
-- Table structure for table `student_absen_detail`
--

CREATE TABLE IF NOT EXISTS `student_absen_detail` (
  `detail_id` int(11) NOT NULL,
  `absen_id` int(11) NOT NULL,
  `nim` varchar(10) NOT NULL,
  `kehadiran` varchar(1) NOT NULL,
  `keterangan` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_absen_detail`
--

INSERT INTO `student_absen_detail` (`detail_id`, `absen_id`, `nim`, `kehadiran`, `keterangan`) VALUES
(2, 4, 'ti102134', 'i', ''),
(3, 4, 'KA131002', 'i', ''),
(4, 4, 'KA131003', 'i', ''),
(5, 4, 'KA131004', 'i', ''),
(6, 4, 'KA131005', 'i', ''),
(7, 4, 'KA131006', 'i', ''),
(8, 4, 'KA131007', 'a', ''),
(9, 4, 'KA131008', 'i', ''),
(10, 4, 'KA131010', 'i', ''),
(11, 4, 'KA131009', 'i', ''),
(12, 4, 'KA131011', 'i', ''),
(13, 4, 'KA131012', 'i', ''),
(14, 5, 'ti102134', 'h', ''),
(15, 6, 'ti102134', 'h', ''),
(16, 6, 'KA131002', 'h', ''),
(17, 8, 'KA131002', 'h', ''),
(18, 8, 'KA131004', 'h', ''),
(19, 8, 'KA131005', 'h', ''),
(20, 8, 'KA131006', 'h', ''),
(21, 9, 'KA131002', 'a', ''),
(22, 9, 'KA131004', 'h', ''),
(23, 9, 'KA131005', 'h', ''),
(24, 9, 'KA131006', 'h', '');

-- --------------------------------------------------------

--
-- Table structure for table `student_angkatan`
--

CREATE TABLE IF NOT EXISTS `student_angkatan` (
  `angkatan_id` int(11) NOT NULL,
  `keterangan` varchar(15) NOT NULL,
  `aktif` varchar(1) NOT NULL COMMENT 'y = aktif dan n = tidak'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_angkatan`
--

INSERT INTO `student_angkatan` (`angkatan_id`, `keterangan`, `aktif`) VALUES
(2, '2014-2015', 'y'),
(3, '2016 - 2017', 'n');

-- --------------------------------------------------------

--
-- Table structure for table `student_siswa`
--

CREATE TABLE IF NOT EXISTS `student_siswa` (
  `siswa_id` int(11) NOT NULL,
  `nim` varchar(13) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `konsentrasi_id` int(2) NOT NULL,
  `angkatan_id` int(4) NOT NULL COMMENT 'tahun akademik ketika masuk',
  `alamat` text NOT NULL,
  `semester` int(11) NOT NULL,
  `gender` varchar(1) NOT NULL,
  `agama_id` int(11) NOT NULL,
  `tempat_lahir` varchar(100) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `nama_ibu` varchar(100) NOT NULL,
  `nama_ayah` varchar(100) NOT NULL,
  `no_hp_ortu` varchar(12) NOT NULL,
  `pekerjaan_id_ibu` int(11) NOT NULL,
  `pekerjaan_id_ayah` int(11) NOT NULL,
  `alamat_ayah` text NOT NULL,
  `alamat_ibu` text NOT NULL,
  `penghasilan_ayah` int(11) NOT NULL,
  `penghasilan_ibu` int(11) NOT NULL,
  `sekolah_nama` varchar(50) NOT NULL,
  `sekolah_telpon` varchar(12) NOT NULL,
  `sekolah_alamat` text NOT NULL,
  `sekolah_jurusan` varchar(80) NOT NULL,
  `sekolah_tahun_lulus` int(4) NOT NULL,
  `kampus_nama` varchar(50) NOT NULL,
  `kampus_telpon` varchar(12) NOT NULL,
  `kampus_alamat` text NOT NULL,
  `kampus_jurusan` varchar(80) NOT NULL,
  `kampus_tahun_lulus` int(4) NOT NULL,
  `institusi_nama` varchar(80) NOT NULL,
  `institusi_telpon` varchar(12) NOT NULL,
  `institusi_alamat` text NOT NULL,
  `instansi_nama` varchar(80) NOT NULL,
  `instansi_telpon` varchar(12) NOT NULL,
  `instansi_alamat` text NOT NULL,
  `instansi_mulai` int(4) NOT NULL,
  `instansi_sampai` int(4) NOT NULL,
  `semester_aktif` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_siswa`
--

INSERT INTO `student_siswa` (`siswa_id`, `nim`, `nama`, `konsentrasi_id`, `angkatan_id`, `alamat`, `semester`, `gender`, `agama_id`, `tempat_lahir`, `tanggal_lahir`, `nama_ibu`, `nama_ayah`, `no_hp_ortu`, `pekerjaan_id_ibu`, `pekerjaan_id_ayah`, `alamat_ayah`, `alamat_ibu`, `penghasilan_ayah`, `penghasilan_ibu`, `sekolah_nama`, `sekolah_telpon`, `sekolah_alamat`, `sekolah_jurusan`, `sekolah_tahun_lulus`, `kampus_nama`, `kampus_telpon`, `kampus_alamat`, `kampus_jurusan`, `kampus_tahun_lulus`, `institusi_nama`, `institusi_telpon`, `institusi_alamat`, `instansi_nama`, `instansi_telpon`, `instansi_alamat`, `instansi_mulai`, `instansi_sampai`, `semester_aktif`) VALUES
(20, 'a', 'a', 1, 2, 'aaa', 0, '1', 1, 'aaaa', '2016-04-19', '', '', '', 1, 1, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '0', '', '', '', '', '0', 0, 0, 0),
(21, 'a', 'a', 1, 2, 'a', 0, '1', 1, 'a', '2016-04-18', '', '', '', 1, 1, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '0', '', '', '', '', '0', 0, 0, 0),
(22, 'a', 'a', 1, 2, '', 0, '1', 1, '', '0000-00-00', '', '', '', 1, 1, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '0', '', '', '', '', '0', 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `submenu`
--

CREATE TABLE IF NOT EXISTS `submenu` (
  `id_submenu` int(11) NOT NULL,
  `id_mainmenu` int(11) NOT NULL,
  `nama_submenu` varchar(50) NOT NULL,
  `link` varchar(50) NOT NULL,
  `aktif` enum('y','t') NOT NULL,
  `icon` varchar(30) NOT NULL,
  `level` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submenu`
--

INSERT INTO `submenu` (`id_submenu`, `id_mainmenu`, `nama_submenu`, `link`, `aktif`, `icon`, `level`) VALUES
(111, 11, 'tambah siswa baru', 'siswa/post', 'y', '', 1),
(112, 11, 'tampilkan data siswa', 'siswa', 'y', '', 1),
(131, 13, 'Tambah Mata Pelajaran', 'matakuliah/post', 'y', '', 1),
(132, 13, 'Kelola Mata Pelajaran', 'matakuliah', 'y', '', 1),
(141, 14, 'kelola tingkat', 'tingkat', 'y', '', 1),
(142, 14, 'kelola penjurusan', 'penjurusan', 'y', '', 1),
(143, 14, 'kelola tahun angkatan', 'tahunangkatan', 'y', '', 1),
(144, 14, 'kelola tipe pembelajaran', 'kelompokmatakuliah', 'y', '', 1),
(145, 14, 'kelola ruang kelas', 'ruangan', 'y', '', 1),
(146, 14, 'kelola tingkat nilai', 'grade', 'y', '', 1),
(147, 14, 'kelola jadwal belajar', 'jadwalkuliah', 'y', '', 1),
(148, 14, 'kelola laporan belajar', 'khs', 'y', '', 1),
(151, 15, 'pembayaran', 'pembayaran', 'y', '', 1),
(152, 15, 'jenis pembayaran', 'jenisbayar', 'y', '', 1),
(153, 15, 'laporan pembayaran', 'laporan', 'y', '', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `akademik_jadwal_kuliah`
--
ALTER TABLE `akademik_jadwal_kuliah`
  ADD PRIMARY KEY (`jadwal_id`);

--
-- Indexes for table `akademik_khs`
--
ALTER TABLE `akademik_khs`
  ADD PRIMARY KEY (`khs_id`);

--
-- Indexes for table `akademik_konsentrasi`
--
ALTER TABLE `akademik_konsentrasi`
  ADD PRIMARY KEY (`konsentrasi_id`);

--
-- Indexes for table `akademik_krs`
--
ALTER TABLE `akademik_krs`
  ADD PRIMARY KEY (`krs_id`);

--
-- Indexes for table `akademik_prodi`
--
ALTER TABLE `akademik_prodi`
  ADD PRIMARY KEY (`prodi_id`);

--
-- Indexes for table `akademik_registrasi`
--
ALTER TABLE `akademik_registrasi`
  ADD PRIMARY KEY (`registrasi_id`);

--
-- Indexes for table `akademik_tahun_akademik`
--
ALTER TABLE `akademik_tahun_akademik`
  ADD PRIMARY KEY (`tahun_akademik_id`);

--
-- Indexes for table `akademik_waktu_kuliah`
--
ALTER TABLE `akademik_waktu_kuliah`
  ADD PRIMARY KEY (`waktu_id`);

--
-- Indexes for table `app_agama`
--
ALTER TABLE `app_agama`
  ADD PRIMARY KEY (`agama_id`);

--
-- Indexes for table `app_dosen`
--
ALTER TABLE `app_dosen`
  ADD PRIMARY KEY (`dosen_id`);

--
-- Indexes for table `app_gedung`
--
ALTER TABLE `app_gedung`
  ADD PRIMARY KEY (`gedung_id`);

--
-- Indexes for table `app_hari`
--
ALTER TABLE `app_hari`
  ADD PRIMARY KEY (`hari_id`);

--
-- Indexes for table `app_nilai_grade`
--
ALTER TABLE `app_nilai_grade`
  ADD PRIMARY KEY (`nilai_id`);

--
-- Indexes for table `app_pekerjaan`
--
ALTER TABLE `app_pekerjaan`
  ADD PRIMARY KEY (`pekerjaan_id`);

--
-- Indexes for table `app_ruangan`
--
ALTER TABLE `app_ruangan`
  ADD PRIMARY KEY (`ruangan_id`);

--
-- Indexes for table `app_users`
--
ALTER TABLE `app_users`
  ADD PRIMARY KEY (`id_users`);

--
-- Indexes for table `inbox`
--
ALTER TABLE `inbox`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `keuangan_biaya_kuliah`
--
ALTER TABLE `keuangan_biaya_kuliah`
  ADD PRIMARY KEY (`biaya_kuliah_id`);

--
-- Indexes for table `keuangan_jenis_bayar`
--
ALTER TABLE `keuangan_jenis_bayar`
  ADD PRIMARY KEY (`jenis_bayar_id`);

--
-- Indexes for table `keuangan_pembayaran`
--
ALTER TABLE `keuangan_pembayaran`
  ADD PRIMARY KEY (`pembayaran_id`);

--
-- Indexes for table `keuangan_pembayaran_detail`
--
ALTER TABLE `keuangan_pembayaran_detail`
  ADD PRIMARY KEY (`pembayara_detail_id`);

--
-- Indexes for table `mainmenu`
--
ALTER TABLE `mainmenu`
  ADD PRIMARY KEY (`id_mainmenu`);

--
-- Indexes for table `makul_kelompok`
--
ALTER TABLE `makul_kelompok`
  ADD PRIMARY KEY (`kelompok_id`);

--
-- Indexes for table `makul_matakuliah`
--
ALTER TABLE `makul_matakuliah`
  ADD PRIMARY KEY (`makul_id`);

--
-- Indexes for table `outbox`
--
ALTER TABLE `outbox`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
  ADD KEY `outbox_sender` (`SenderID`);

--
-- Indexes for table `outbox_multipart`
--
ALTER TABLE `outbox_multipart`
  ADD PRIMARY KEY (`ID`,`SequencePosition`);

--
-- Indexes for table `pbk`
--
ALTER TABLE `pbk`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `pbk_groups`
--
ALTER TABLE `pbk_groups`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `phones`
--
ALTER TABLE `phones`
  ADD PRIMARY KEY (`IMEI`);

--
-- Indexes for table `sentitems`
--
ALTER TABLE `sentitems`
  ADD PRIMARY KEY (`ID`,`SequencePosition`),
  ADD KEY `sentitems_date` (`DeliveryDateTime`),
  ADD KEY `sentitems_tpmr` (`TPMR`),
  ADD KEY `sentitems_dest` (`DestinationNumber`),
  ADD KEY `sentitems_sender` (`SenderID`);

--
-- Indexes for table `student_absen`
--
ALTER TABLE `student_absen`
  ADD PRIMARY KEY (`absen_id`);

--
-- Indexes for table `student_absen_detail`
--
ALTER TABLE `student_absen_detail`
  ADD PRIMARY KEY (`detail_id`);

--
-- Indexes for table `student_angkatan`
--
ALTER TABLE `student_angkatan`
  ADD PRIMARY KEY (`angkatan_id`);

--
-- Indexes for table `student_siswa`
--
ALTER TABLE `student_siswa`
  ADD PRIMARY KEY (`siswa_id`);

--
-- Indexes for table `submenu`
--
ALTER TABLE `submenu`
  ADD PRIMARY KEY (`id_submenu`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `akademik_jadwal_kuliah`
--
ALTER TABLE `akademik_jadwal_kuliah`
  MODIFY `jadwal_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=111;
--
-- AUTO_INCREMENT for table `akademik_khs`
--
ALTER TABLE `akademik_khs`
  MODIFY `khs_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=162;
--
-- AUTO_INCREMENT for table `akademik_konsentrasi`
--
ALTER TABLE `akademik_konsentrasi`
  MODIFY `konsentrasi_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `akademik_krs`
--
ALTER TABLE `akademik_krs`
  MODIFY `krs_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=162;
--
-- AUTO_INCREMENT for table `akademik_prodi`
--
ALTER TABLE `akademik_prodi`
  MODIFY `prodi_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `akademik_registrasi`
--
ALTER TABLE `akademik_registrasi`
  MODIFY `registrasi_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `akademik_tahun_akademik`
--
ALTER TABLE `akademik_tahun_akademik`
  MODIFY `tahun_akademik_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `akademik_waktu_kuliah`
--
ALTER TABLE `akademik_waktu_kuliah`
  MODIFY `waktu_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `app_dosen`
--
ALTER TABLE `app_dosen`
  MODIFY `dosen_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `app_gedung`
--
ALTER TABLE `app_gedung`
  MODIFY `gedung_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `app_hari`
--
ALTER TABLE `app_hari`
  MODIFY `hari_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `app_nilai_grade`
--
ALTER TABLE `app_nilai_grade`
  MODIFY `nilai_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `app_ruangan`
--
ALTER TABLE `app_ruangan`
  MODIFY `ruangan_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `app_users`
--
ALTER TABLE `app_users`
  MODIFY `id_users` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `inbox`
--
ALTER TABLE `inbox`
  MODIFY `ID` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `keuangan_biaya_kuliah`
--
ALTER TABLE `keuangan_biaya_kuliah`
  MODIFY `biaya_kuliah_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=943;
--
-- AUTO_INCREMENT for table `keuangan_jenis_bayar`
--
ALTER TABLE `keuangan_jenis_bayar`
  MODIFY `jenis_bayar_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `keuangan_pembayaran`
--
ALTER TABLE `keuangan_pembayaran`
  MODIFY `pembayaran_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `keuangan_pembayaran_detail`
--
ALTER TABLE `keuangan_pembayaran_detail`
  MODIFY `pembayara_detail_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `mainmenu`
--
ALTER TABLE `mainmenu`
  MODIFY `id_mainmenu` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT for table `makul_kelompok`
--
ALTER TABLE `makul_kelompok`
  MODIFY `kelompok_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `makul_matakuliah`
--
ALTER TABLE `makul_matakuliah`
  MODIFY `makul_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT for table `outbox`
--
ALTER TABLE `outbox`
  MODIFY `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT for table `pbk`
--
ALTER TABLE `pbk`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pbk_groups`
--
ALTER TABLE `pbk_groups`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `student_absen`
--
ALTER TABLE `student_absen`
  MODIFY `absen_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `student_absen_detail`
--
ALTER TABLE `student_absen_detail`
  MODIFY `detail_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `student_angkatan`
--
ALTER TABLE `student_angkatan`
  MODIFY `angkatan_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `student_siswa`
--
ALTER TABLE `student_siswa`
  MODIFY `siswa_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `submenu`
--
ALTER TABLE `submenu`
  MODIFY `id_submenu` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=154;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;