akademik.sql

-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 23 Sep 2014 pada 06.11
-- Versi Server: 5.6.16
-- PHP Version: 5.5.11

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 utf8 */;

--
-- Database: `akademik`
--

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

--
-- Struktur dari tabel `akademik_jadwal_kuliah`
--

CREATE TABLE IF NOT EXISTS `akademik_jadwal_kuliah` (
  `jadwal_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`jadwal_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=109 ;

--
-- Dumping data untuk tabel `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, '', '');

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

--
-- Struktur dari tabel `akademik_khs`
--

CREATE TABLE IF NOT EXISTS `akademik_khs` (
  `khs_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`khs_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=162 ;

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `akademik_konsentrasi`
--

CREATE TABLE IF NOT EXISTS `akademik_konsentrasi` (
  `konsentrasi_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`konsentrasi_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data untuk tabel `akademik_konsentrasi`
--

INSERT INTO `akademik_konsentrasi` (`konsentrasi_id`, `nama_konsentrasi`, `ketua`, `jenjang`, `jml_semester`, `kode_nomor`, `gelar`, `prodi_id`) VALUES
(1, 'teknik inormatika', 'sample text', 'd4', 8, '23323232', 'd4', 6),
(2, 'multimedia', 'hasan sadikin', 'd4', 5, 'dsdsd', 'sst', 1),
(3, 'teknik mesin produksi', 'sample text', 'd3', 6, '', 'D4', 2),
(4, 'rekamedik dan infokes', 'sample text', 'd4', 8, '', 'sst', 6),
(5, 'teknik sipil', '', 'd3', 6, '', '', 3),
(6, 'teknik kontruksi bangunan', '', 'd4', 8, '', '', 7),
(7, 'teknik komputer', '', 'd3', 6, '', '', 15),
(8, 'mekatronika', '', 'd4', 8, '', '', 8),
(9, 'mekanik industri & desain', '', 'd4', 8, '', '', 8),
(10, 'alamat berat', '', 'd3', 6, '', '', 4),
(11, 'teknik otomotif', '', 'd3', 6, '', '', 9),
(12, 'teknik otomasi', '', 'd4', 8, '', '', 14),
(13, 'teknik otomasi industri', '', 'd4', 8, '', '', 13),
(14, 'analisis kesehatan', '', 'd3', 6, '', '', 12),
(15, 'perpajakan', '', 'd3', 6, '', '', 5),
(16, 'komputerisasi akutansi', '', 'd4', 8, '', '', 10),
(17, 'rekamedik dan infokes', '', 'd3', 6, '', '', 11);

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

--
-- Struktur dari tabel `akademik_krs`
--

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

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `akademik_prodi`
--

CREATE TABLE IF NOT EXISTS `akademik_prodi` (
  `prodi_id` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`prodi_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data untuk tabel `akademik_prodi`
--

INSERT INTO `akademik_prodi` (`prodi_id`, `nama_prodi`, `ketua`, `no_izin`, `status`) VALUES
(2, 'teknik mesin', 'sample text', '1169/D/T/2008', 2),
(3, 'teknik sipil', '', '', 2),
(4, 'teknik otomotif', '', '', 2),
(5, 'akutansi', '', '', 2),
(6, 'teknik informatika', '', '', 2),
(7, 'teknik kontruksi bangunan', '', '', 2),
(8, 'mekanik industri dan desain', '', '', 2),
(9, 'mesin otomotif', '', '', 2),
(10, 'komputerisasi akutansi', '', '', 2),
(11, 'rekamedis dan infokes', '', '', 2),
(12, 'teknik kimia', '', '', 2),
(13, 'teknik otomasi', '', '', 2),
(14, 'teknik elektro', '', '', 2),
(15, 'teknik komputer', '', '', 2);

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

--
-- Struktur dari tabel `akademik_registrasi`
--

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

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `akademik_tahun_akademik`
--

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

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `akademik_waktu_kuliah`
--

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

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

--
-- Struktur dari tabel `app_agama`
--

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

--
-- Dumping data untuk tabel `app_agama`
--

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

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

--
-- Struktur dari tabel `app_dosen`
--

CREATE TABLE IF NOT EXISTS `app_dosen` (
  `dosen_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`dosen_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

--
-- Dumping data untuk tabel `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
(0, 'not set', '', '', '', '', '0000-00-00', '', 0, 0, '', '', '', '', 6),
(1, 'nuris akbar sst', '748343', '196105041987032002', '43434', 'langsa', '2014-03-06', '1', 1, 1, 'sst', 'dsdsd', '081212123454', 'nu@gmail.com', 6),
(6, 'Dr. Ciek Juliati Hisyam, MM.,M.Si', '', '196204121987032001', '', '', '0000-00-00', '1', 1, 1, '', '', '089690987654', 'saidatunnafsiah@gmail.com', 6),
(7, 'Dr. Etin Solihatin, M.Pd.', '', '196601011989032003', '', '', '0000-00-00', '1', 1, 1, '', '', '089690987654', 'sampleemail@gmail.com', 6),
(8, 'Alex Iskandar, Drs.,M.Pd.', '0423085601', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(11, 'Indra Hermawan, SE.', '0403077902', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(17, 'Anton Gultom, SST.,M.Pd.', '0420075701', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(18, 'Berayan Munthe, MT.', '0426055402', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(19, 'Rahmat Kuswandy, Drs.', '0412034601', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(20, 'Chrestian Maxi Adri Mamesah', '0424035101', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(21, 'Ahadiat, SST.,M.Pd.', '0423065703', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(22, 'Rahmat Gunawan, SST.,M.Pd.', '0416056602', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(23, 'Hernawati, M.Si.', '0403027206', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(24, 'Darsono, M.T.', '0413016101', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(25, 'Sutandi, M.Pd.', '0402037305', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(26, 'Sueb, Drs.,M.Si.,M.Pd.', '0025035803', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(27, 'Theresia Florens Meliala, SST.,M.Pd.', '0419108101', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(28, 'Dini Arianti, ST.', '0401097702', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(29, 'Dadan Saeful Ramdhan, SST', '', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(30, 'Ganar Afin Nendriyawan, SST', '', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(31, 'Dian Rosdiana, SST', '', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(32, 'Riri Damayanti Apnena, SST', '', '', '', '', '0000-00-00', '1', 0, 0, '', '', '', '', 6),
(33, 'sample dosen', '2323', '444444', '', 'langsa', '2014-08-23', '1', 1, 1, '', 'sample alamat', '085654987654', 'nuris.akbar@gmail.com', 0);

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

--
-- Struktur dari tabel `app_gedung`
--

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

--
-- Dumping data untuk tabel `app_gedung`
--

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

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

--
-- Struktur dari tabel `app_hari`
--

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

--
-- Dumping data untuk tabel `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');

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

--
-- Struktur dari tabel `app_nilai_grade`
--

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

--
-- Dumping data untuk tabel `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', ' ');

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

--
-- Struktur dari tabel `app_pekerjaan`
--

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

--
-- Dumping data untuk tabel `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');

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

--
-- Struktur dari tabel `app_ruangan`
--

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

--
-- Dumping data untuk tabel `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, ''),
(3, 'L1.R02', 2, 60, ''),
(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, ''),
(17, 'L1.R01', 2, 0, 'lab elektro'),
(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');

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

--
-- Struktur dari tabel `app_users`
--

CREATE TABLE IF NOT EXISTS `app_users` (
  `id_users` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_users`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data untuk tabel `app_users`
--

INSERT INTO `app_users` (`id_users`, `username`, `nama`, `password`, `level`, `keterangan`, `last_login`) VALUES
(1, 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, '', '2014-09-22 15:45:22'),
(4, 'informatika', '', '270007185d0f4b290ded51f9345a7f29', 2, '6', '2014-09-06 10:57:51'),
(6, 'nuris', 'nuris akbar', '74d7273be4b0ddeac49bfa169b288c5b', 3, '1', '2014-09-06 11:12:14'),
(7, 'mesin', '', '9c6bd054e8eebbc99bb4d655caad4b3c', 2, '2', '2014-09-08 16:31:32'),
(8, 'admin', '', '21232f297a57a5a743894a0e4a801fc3', 3, '33', '2014-09-22 15:45:22'),
(9, 'mesin', '', '9c6bd054e8eebbc99bb4d655caad4b3c', 2, '2', '2014-09-08 16:31:32');

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

--
-- Struktur dari tabel `daemons`
--

CREATE TABLE IF NOT EXISTS `daemons` (
  `Start` text NOT NULL,
  `Info` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `gammu`
--

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

--
-- Dumping data untuk tabel `gammu`
--

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

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

--
-- Struktur dari tabel `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 AUTO_INCREMENT,
  `RecipientID` text NOT NULL,
  `Processed` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktur dari tabel `keuangan_biaya_kuliah`
--

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

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `keuangan_jenis_bayar`
--

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

--
-- Dumping data untuk tabel `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');

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

--
-- Struktur dari tabel `keuangan_pembayaran`
--

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

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

--
-- Struktur dari tabel `keuangan_pembayaran_detail`
--

CREATE TABLE IF NOT EXISTS `keuangan_pembayaran_detail` (
  `pembayara_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`pembayara_detail_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `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;

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

--
-- Struktur dari tabel `mainmenu`
--

CREATE TABLE IF NOT EXISTS `mainmenu` (
  `id_mainmenu` int(11) NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id_mainmenu`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

--
-- Dumping data untuk tabel `mainmenu`
--

INSERT INTO `mainmenu` (`id_mainmenu`, `nama_mainmenu`, `icon`, `aktif`, `link`, `level`) VALUES
(26, 'master data', 'fa fa-bar-chart-o', 'y', '#', 1),
(27, 'mahassiwa', 'gi gi-group', 'y', 'mahasiswa', 1),
(28, 'akademik', 'fa fa-building-o', 'y', '#', 1),
(29, 'keuangan', 'gi gi-money', 'y', '#', 1),
(30, 'pengguna sistem', 'gi gi-qrcode', 'y', 'users', 1),
(31, 'Mahasiswa', 'gi gi-group', 'y', 'mahasiswa', 2),
(32, 'dosen', 'gi gi-user', 'y', 'dosen', 2),
(33, 'matakuliah', 'gi gi-address_book', 'y', 'matakuliah', 2),
(34, 'registrasi', 'hi hi-qrcode', 'y', 'registrasi', 2),
(35, 'krs & khs', 'gi gi-display', 'y', '#', 2),
(36, 'jadwal kuliah', 'gi gi-calendar', 'y', 'jadwalkuliah', 2),
(37, 'jadwal', 'gi gi-calendar', 'y', 'jadwalkuliah/jadwalngajar', 3),
(38, 'absen mahasiswa', 'gi gi-notes_2', 'y', 'absensi', 3),
(39, 'nilai', 'gi gi-stats', 'y', 'khs/berinilai', 3),
(40, 'bodata', 'gi gi-user', 'y', 'users/account', 3);

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

--
-- Struktur dari tabel `makul_kelompok`
--

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

--
-- Dumping data untuk tabel `makul_kelompok`
--

INSERT INTO `makul_kelompok` (`kelompok_id`, `kode_kelompok`, `nama`) VALUES
(1, 'mpk', 'mata kuliah pengembangan keperibadian'),
(2, 'mkk', 'mata kuliah pengembangan keilmuan dan keterampilan'),
(3, 'mkb', 'mata kuliah keahlian berkarya'),
(4, 'mpb', 'mata kuliah perilaku berkarya'),
(5, 'mbb', 'matakuliah berkehidupan bermasyarakat');

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

--
-- Struktur dari tabel `makul_matakuliah`
--

CREATE TABLE IF NOT EXISTS `makul_matakuliah` (
  `makul_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`makul_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

--
-- Dumping data untuk tabel `makul_matakuliah`
--

INSERT INTO `makul_matakuliah` (`makul_id`, `kode_makul`, `nama_makul`, `sks`, `semester`, `konsentrasi_id`, `kelompok_id`, `aktif`, `jam`) VALUES
(1, 'DTIKB01', 'STRUKTUR DATA', 4, 1, 3, 2, 'n', 4),
(2, 'DTIKB011', 'KONSEP PEMROGRAMAN', 4, 1, 3, 2, 'y', 4),
(3, 'DTIKB012', 'PRAKTEK KONSEP PEMROGRAMAN', 4, 1, 3, 2, 'y', 4),
(4, 'DTIKB02', 'SISTEM OPERASI 1', 4, 1, 3, 2, 'y', 4),
(5, 'DTIKB03', 'SISTEM OPERASI 2', 4, 1, 3, 2, 'y', 4),
(6, 'DTIKB04', 'PEMROGRAMAN DELPHI', 4, 1, 3, 2, 'y', 4),
(7, 'DTIKB05', 'JARINGAN KOMPUTER 1', 4, 2, 3, 2, 'y', 4),
(8, 'DTIKB06', 'APLIKASI DAN TEKNOLOGI WEB', 4, 2, 3, 2, 'y', 4),
(9, 'DTIKB07', 'KOMUNIKASI DATA', 4, 2, 3, 2, 'y', 4),
(10, 'DTIKB08', 'DESAIN BERBASIS KOMPUTER', 4, 2, 3, 2, 'y', 4),
(11, 'DTIKB09', 'MIKROPROSESOR', 4, 2, 3, 2, 'y', 4),
(12, 'DTIKB10', 'INTERFACING PERIPHERAL KOMPUTER', 4, 2, 3, 2, 'y', 4),
(13, 'DTIKB11', 'ARSITEKTUR KOMPUTER 1', 4, 3, 3, 2, 'y', 4),
(14, 'DTIKB12', 'ARSITEKTUR KOMPUTER 2', 4, 3, 3, 2, 'y', 4),
(15, 'DTIKB13', 'PERALATAN ELEKTRONIKA', 4, 3, 3, 2, 'y', 4),
(16, 'DTIKB14', 'TROUBLESHOOTING', 4, 3, 3, 2, 'y', 4),
(17, 'DTIKB15', 'PEMROGRAMAN BASIS DATA', 4, 3, 3, 2, 'y', 4),
(18, 'DTIKB16', 'SISTEM INFORMASI MANAJEMEN', 4, 3, 3, 2, 'y', 4),
(19, 'DTIKB17', 'PERANCANGAN SISTEM INFORMASI', 4, 4, 3, 2, 'y', 4),
(20, 'DTIKB18', 'PENGOLAHAN CITRA DIGITAL', 4, 4, 3, 2, 'y', 4),
(21, 'DTIKB19', 'RANGKAIAN DIGITAL', 4, 4, 3, 2, 'y', 4),
(22, 'DTIKB20', 'PEMROGRAMAN BAHASA C++', 4, 4, 3, 2, 'y', 4),
(23, 'DTIKB21', 'PEMROGRAMAN VISUAL', 4, 4, 3, 2, 'y', 4),
(24, 'DTIKB22', 'KOMPUTER GRAFIS', 4, 4, 3, 2, 'y', 4),
(25, 'DTIKB23', 'WIRELESS & MOBILE COMM', 4, 5, 3, 2, 'y', 4),
(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);

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

--
-- Struktur dari tabel `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 AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`ID`),
  KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
  KEY `outbox_sender` (`SenderID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;

--
-- Dumping data untuk tabel `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');

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

--
-- Struktur dari tabel `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',
  PRIMARY KEY (`ID`,`SequencePosition`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktur dari tabel `pbk`
--

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

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

--
-- Struktur dari tabel `pbk_groups`
--

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

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

--
-- Struktur dari tabel `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',
  PRIMARY KEY (`IMEI`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `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);

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

--
-- Struktur dari tabel `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,
  PRIMARY KEY (`ID`,`SequencePosition`),
  KEY `sentitems_date` (`DeliveryDateTime`),
  KEY `sentitems_tpmr` (`TPMR`),
  KEY `sentitems_dest` (`DestinationNumber`),
  KEY `sentitems_sender` (`SenderID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data untuk tabel `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');

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

--
-- Struktur dari tabel `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 untuk tabel `setting`
--

INSERT INTO `setting` (`id`, `nama_kampus`, `alamat_kampus`, `telpon`) VALUES
(1, 'politeknik tedc bandung1', 'cimahi', '0218765431');

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

--
-- Struktur dari tabel `student_absen`
--

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

--
-- Dumping data untuk tabel `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');

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

--
-- Struktur dari tabel `student_absen_detail`
--

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

--
-- Dumping data untuk tabel `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', '');

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

--
-- Struktur dari tabel `student_angkatan`
--

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

--
-- Dumping data untuk tabel `student_angkatan`
--

INSERT INTO `student_angkatan` (`angkatan_id`, `keterangan`, `aktif`) VALUES
(1, '2013-2014', 'n'),
(2, '2014-2015', 'y');

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

--
-- Struktur dari tabel `student_mahasiswa`
--

CREATE TABLE IF NOT EXISTS `student_mahasiswa` (
  `mahasiswa_id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`mahasiswa_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data untuk tabel `student_mahasiswa`
--

INSERT INTO `student_mahasiswa` (`mahasiswa_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
(1, 'ti102134', 'nuris akbar', 3, 1, 'jl.pesantren km 2', 0, '1', 1, 'langsa', '1992-08-24', 'nurhayati', 'ishak husein', '082121473036', 1, 9, 'telaga meku', 'telaga meku', 2, 0, 'smkn 2 langsa', '02121456', 'jl pb.seleumak', 'rpl', 2010, 'smkn 2 langsa', '02121456', 'jl pb.seleumak', 'rpl', 2010, 'reka pancatama', '02134567', 'jl soekarno hataa', 'sample text', '02145675', 'saple', 2010, 2014, 5),
(5, 'KA131002', 'Etika Cahya Pribadi', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 4),
(6, 'KA131003', 'Indira Nuaisyah', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 6),
(7, 'KA131004', 'Irmawati Sipahutar', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 3),
(8, 'KA131005', 'Lutfhyyah Nadia Zulfikrie', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 3),
(9, 'KA131006', 'Nabila Ladysthya Taufiq', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 4),
(10, 'KA131007', 'Tiara Nur Cahya', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 2),
(13, 'KA131010', 'Andhyka Adiguna Sujana', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 2),
(14, 'KA131011', 'Nunu Suherna Nusuri', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 2),
(15, 'KA131012', 'Nurul Rahmatun Putri Rustama', 3, 1, '', 0, 'l', 0, '', '0000-00-00', '', '', '', 0, 0, '', '', 0, 0, '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', 0, 0, 2);

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

--
-- Struktur dari tabel `submenu`
--

CREATE TABLE IF NOT EXISTS `submenu` (
  `id_submenu` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_submenu`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

--
-- Dumping data untuk tabel `submenu`
--

INSERT INTO `submenu` (`id_submenu`, `id_mainmenu`, `nama_submenu`, `link`, `aktif`, `icon`, `level`) VALUES
(70, 28, 'tahun akademik', 'tahunakademik', 'y', 'gi gi-calendar', 1),
(71, 26, 'gedung', 'gedung', 'y', 'gi gi-cargo', 1),
(72, 26, 'ruangan', 'ruangan', 'y', 'gi gi-bank', 1),
(73, 28, 'matakuliah', 'matakuliah', 'y', 'gi gi-book_open', 1),
(74, 26, 'prodi', 'prodi', 'y', 'gi gi-table', 1),
(75, 26, 'konsentrasi', 'konsentrasi', 'y', 'fa fa-credit-card', 1),
(76, 26, 'dosen', 'dosen', 'y', 'gi gi-parents', 1),
(77, 28, 'jadwal kuliah', 'jadwalkuliah', 'y', 'fa fa-calendar', 1),
(78, 26, 'kelompok matakuliah', 'kelompokmatakuliah', 'y', 'gi gi-address_book', 1),
(79, 29, 'form pembayaran', 'keuangan/pembayaran', 'y', 'gi gi-coins', 1),
(80, 29, 'jenis pembayaran', 'jenisbayar', 'y', 'fa fa-puzzle-piece', 1),
(81, 29, 'biaya kuliah', 'setupbiayakuliah', 'y', 'fa fa-money', 1),
(82, 29, 'laporan keuangan', 'keuangan/laporan', 'y', 'gi gi-notes_2', 1),
(83, 28, 'registrasi', 'registrasi', 'y', 'fa fa-keyboard-o', 1),
(84, 28, 'kartu rencana studi', 'krs/lihat', 'y', 'gi gi-cart_in', 1),
(85, 35, 'kartu rencana studi', 'krs/lihat', 'y', 'gi gi-notes_2', 0),
(86, 35, 'kartu rencana studi', 'khs', 'y', 'hi hi-list-alt', 0),
(87, 26, 'grade nilai', 'grade', 'y', 'gi gi-credit_card', 0),
(88, 28, 'kartu hasil studi', 'khs', 'y', 'gi gi-notes', 0),
(89, 26, 'tahun angkatan', 'tahunangkatan', 'y', 'gi gi-calendar', 0);

/*!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 */;