/*
SQLyog Community Edition- MySQL GUI v5.29
Host - 5.1.41 : Database - mhs
*********************************************************************
Server version : 5.1.41
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `mhs`;

USE `mhs`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `tbdosen` */

DROP TABLE IF EXISTS `tbdosen`;

CREATE TABLE `tbdosen` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Nama` varchar(100) DEFAULT NULL,
  `JK` varchar(10) DEFAULT NULL,
  `NIDN` varchar(100) DEFAULT NULL,
  `NIP` varchar(100) DEFAULT NULL,
  `JURUSAN` varchar(100) DEFAULT NULL,
  `PANGKAT` varchar(100) DEFAULT NULL,
  `JABATAN` varchar(100) DEFAULT NULL,
  `GOL` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;

/*Data for the table `tbdosen` */

insert  into `tbdosen`(`Id`,`Nama`,`JK`,`NIDN`,`NIP`,`JURUSAN`,`PANGKAT`,`JABATAN`,`GOL`) values (1,'Drs. I Wayan Rupa, Ak.,M.Agb.,CA','L','0831126401','230340102','Akuntansi','Pembina TK.I','Lektor Kepala','IV B'),(2,'Ni Putu Riasning,S.E.,Akt.,M.M.A','P','0820045901','230340065','Akuntansi','Pembina TK.I','Lektor Kepala','IV B'),(3,'I Made Wianto Putra, S.E.,M.Si','L','0809046401','230340165','Akuntansi','Pembina TK.I','Lektor Kepala','IV B'),(4,'Luh Kade Datrini, S.E.,M.Si.','P','0805056501','230340099','Akuntansi','Pembina TK.I','Lektor Kepala','IV B'),(5,'Ni Nengah Seri Ekayani ,S.E.,Ak.,M.Si,CA','P','0830066501','230340094','Akuntansi','Pemb. Utama Muda','Lektor  Kepala','IV C'),(6,'I Gusti Ngurah Sanjaya,S.E.,M.Si.,Ak.,CA','L','0805106504','230340093','Akuntansi','Pemb. Utama Muda','Lektor  Kepala','IV C'),(7,'Ida I.D.A.M. Manik Sastri ,S.E.,Ak.,M.Si,CA','P','0820026701','230340100','Akuntansi','Pemb. Utama Muda','Lektor  Kepala','IV C'),(8,'I.B.Made Putra Manuaba, S.E.,M.Si','L','0802117002','230340229','Akuntansi','Pembina','Lektor Kepala','IV A'),(9,'L.G.P.Sri Eka Jayanti,S.E.,Ak.,M.Si','P','0810127301','230340230','Akuntansi','Pembina TK.I','Lektor Kepala','IV B'),(10,'A.A.A. Erna Trisnadewi .,S.E.,M.Si.','P','0825127301','230340222','Akuntansi','Pembina TK.I','Lektor Kepala','IV B'),(11,' I Wayan Kartana ,S.E.,M.Sc','L','0831127301','230340227','Akuntansi','Penata TK. I','Lektor ','III D'),(12,'A.A.Bagus Amlayasa ,S.E.,M.Si.','L','0801017401','230340226','Akuntansi','Penata TK. I','Lektor ','III D'),(13,'I Ketut Puja Wirya Sanjaya,S.E..,M.Si.','L','0825047401','230340236','Akuntansi','Pemb. Utama Muda','Lektor Kepala','IV C'),(14,'Gst.Ayu Intan Saputra Rini, S.E.,Ak.,M.Si.,CA','P','0828028301','19830228 200501 2 001','Akuntansi','Penata  ','Lektor ','III C'),(15,'Partiwi Dwi Astuti, S.E.,M.Si.,Ak..,CA','','','230340296','Akuntansi','Penata Muda TK.I','Lektor ','III B'),(16,'Drs. I Ketut Darma, M.Si','L','0801116401','230340064','IESP','Pembina','Lektor Kepala','IV A'),(17,'Dra. Ni Putu  Rediatni Giri, M.Si','P','0819045701','230340162','IESP','Pemb. Utama Muda','Lektor Kepala','IV C'),(18,'Drs. Nyoman  Senimantara, M.Si.','L','0806095801','230340098','IESP','Pembina','Lektor Kepala','IV A'),(19,'I Gede Aryawan, S.E.,M.Si','L','0803065902','230340163','IESP','Penata TK. I','Lektor ','III D'),(20,'Ita Silvia Azita Azis,S.E.,M.Si','P','0825096101','230340088','IESP','Pembina','Lektor Kepala','IV A'),(21,' I Gst. Lanang Putu Tantra,S.E.,M.Si','L','0803026501','230340097','IESP','Pemb. Utama Muda','Lektor Kepala','IV C'),(22,'A.A. Sri Purnami, S.E.,M.Si.','P','0825026701','230340193','IESP','Pemb. Utama Muda','Lektor Kepala','IV C'),(23,'Dr. I Made Sara, S.E.,M.P.','L','0810085801','230340024','IESP','Pembina TK.I','Lektor  Kepala ','IV B'),(24,'Kompiang Bagiada,S.E.,M.Si.','L','0020116508','19651120 199303 1 001','IESP','Penata  ','Lektor ','III D'),(25,'A.A. Ketut Jayawarsa  ,S.E.,M.Si','L','0827036501','230340103','IESP','Pembina','Lektor Kepala','IV A'),(26,'Dr. Putu Ngurah  Suyatna Yasa, S.E.,M.Si.','L','0802096301','230340073','IESP','Pembina TK.I','Lektor Kepala','IV B'),(27,'Drs. I Wayan Arjana,  M.M','L','0814125301','230340016','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(28,'Dra.  Dewa Ayu Rumini ,M.M.','P','0815065701','230340017','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(29,'Dra. Ni Putu Sri Mariyatni.  M.M','P','0812025801','230340166','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(30,'Dewi Soraya,S.E.,M.M','P','0820075901','230340164','Manajemen','Pembina TK.I','Lektor Kepala','IV B'),(31,'Ida Ayu Sri Meitri, S.E.,M.Agb.','P','0817056001','230340176','Manajemen','Pembina TK.I','Lektor  Kepala','IV B'),(32,'Ni Putu Pertamawati, S.E.,M.M','P','0825066001','230340174','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(33,'Drs. I Gst. Lanang Putra  ,M.M','L','0822086001','230340008','Manajemen','Pembina','Lektor Kepala','IV A'),(34,'Drs. I Made Pulawan, M.MA','L','0025086011','19600825 198703 1 002','Manajemen','Pembina TK.I','Lektor Kepala','IV B'),(35,'Drs. I Made Jamin Yasa, M.M.','L','0831126029','230340061','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(36,'Dra. Nengah Ganawati, M.Si','P','0810026101','230340087','Manajemen','Pemb. Utama Muda','Lektor  Kepala','IV C'),(37,'I.B. Komang Suarka, S.E.,M.M.','L','0815046001','230340096','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(38,'Ni Nyoman Rusmiati, S.E.,M.M','P','0831016201','230340025','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(39,'I Wayan Gede Merta, S.E.,M.Si','L','0829046201','230340063','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(40,'Ni Made Rustini, S.E.,M.Agb.','P','0801066201','230340173','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(41,'I.B. Udayana Putra  ,S.E.,M.M.','L','0028086213','19620828 199003 1 003','Manajemen','Pemb. Utama Muda','Lektor  Kepala','IV C'),(42,'Ni Luh Putu Pradnya Dewi, S.E,M.M','P','0817096202','230340188','Manajemen','Pemb. Utama Muda','Lektor  Kepala','IV C'),(43,'Ketut Sudarmini, S.E.,M.Agb.','P','0014126204','19621214 198910 2 001','Manajemen','Pembina TK.I','Lektor  Kepala','IV B'),(44,' I Made Setena, S.E.,M.Agb.','L','0831126201','230340090','Manajemen','Pembina TK.I','Lektor  Kepala','IV B'),(45,'Ni Ketut Sariani, S.E.,M.M','P','0806066301','230340167','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(46,'Dr. I.B. Agung Dharmanegara ,S.E,M.Si','L','0010076304','19630710 199203 1 003','Manajemen','Penata TK. I','Lektor','III D'),(47,'Gusti Ayu Sugiati, S.E.,M.M','P','0825086301','230340075','Manajemen','Pemb. Utama Muda','Lektor  Kepala','IV C'),(48,'A.A. Media Martadiani, S.E.,M.M','P','0815036401','230340095','Manajemen','Pemb. Utama Muda','Lektor  Kepala','IV C'),(49,'Ni Nyoman Suriani, S.E.,M.M.','P','0820056502','230340187','Manajemen','Pemb. Utama Muda','Lektor  Kepala','IV C'),(50,'I Made Yogiarta  S.E.,M.M.','L','0825076502','230340203','Manajemen','Penata TK. I','Lektor','III D'),(51,'Dra. Ni Made  Taman Sari ,Ak.,M.Agb','P','0802096505','19650902 200501 2 001','Manajemen','Penata Tk..I','Lektor','III D'),(52,'I Ketut Selamet, S.E.,M.Si','L','0031126523','19651231 199310 1 001','Manajemen','Pembina','Lektor Kepala','IV A'),(53,'Ni Made Wahyuni, S.E.,M.Agb.','P','0825066601','230340109','Manajemen','Pembina TK.I','Lektor  Kepala','IV B'),(54,'Made Artawan , S.E., M.M','L','0805126601','230340185','Manajemen','Pembina','Lektor Kepala','IV B'),(55,'Ni Wayan Sitiari,S.E., M.M','P','0812126601','230340106','Manajemen','Pembina TK.I','Lektor Kepala','IV B'),(56,'Dewa Ayu Putu Niti Widari ,S.E.,M.M','P','0823056701','230340186','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(57,'Ni Made Santini, S.E.,M.Agb.','P','0803106701','230340184','Manajemen','Pemb. Utama Muda','Lektor Kepala','IV C'),(58,'Ni Luh Anik Puspa Ningsih, S.E.,M.M.','p','','230340238','Manajemen','Penata Muda TK.I','Lektor ','III B'),(59,'Made Pratiwi Dewi, S.E.,M.M.','p','','230340239','Manajemen','Penata Muda TK.I','Lektor ','III B'),(60,'Dr. Ni Luh Putu Indiani, S.E.,M.M.','','','','Manajemen','Penata Muda TK.I','Lektor ','III B'),(61,'I Dewa Ayu Eka Pertiwi,S.E.,Ak.,M.SA.','','','Honorer','','Penata Muda TK.I','Lektor ','III B'),(62,'A.A. Krisna Murti, S.E.,M.Si.','','','Honorer','','Penata Muda Tk. I ','','III b'),(63,'I Gede Sudiarta','L','','230990135','','Penata Muda TK.I','KTU','III C'),(64,'I Gusti Ayu Ketut PutriArtini','P','','230990050','','Pembina','Staf Fak Ekonomi','IV A'),(65,'I Made Arjana','L','','230990071','','Penata ','Staf Fak Ekonomi','III C'),(66,'I Made Mustiana','L','','230990078','','Penata  ','Staf Fak Ekonomi','III D'),(67,'Ni Made Mastini','P','','230990083','','Penata Muda TK.I','Kasub. Kemahasiswaan','III C'),(68,'I Wayan Sukanada Atmaja','L','','230990133','','Penata Muda TK.I','Kasub. Reg & Akad.','III C'),(69,'I Ketut Sueta','L','','230990044','','Penata Muda TK.I','Staf Fak Ekonomi','III C'),(70,'Ni Luh Sekartini, S.E.','P','','230990138','','Penata Muda TK.I','Kasub. Data & Informasi','III C'),(71,'Ni Wayan Maseni','P','','230990130','','Penata Muda TK.I','Kasub. Keu & Umum','III C'),(72,'Ni Ketut Suniti, S.E','P','','230990167','','Penata  ','Staf Fak Ekonomi','III C'),(73,'I Ketut Toh Bawa','L','','220990021','','Penata Muda TK.I','Staf Fak Ekonomi','III B'),(74,'I Nyoman Pasek Sudiasa','L','','220990024','','Penata Muda TK.I','Staf Fak Ekonomi','III B'),(75,'A.A. Made Artama','L','','230990156','','Penata Muda','Staf Fak Ekonomi','III A'),(76,'I Made Nuarta','L','','230990159','','Penata Muda','Staf Fak Ekonomi','III A'),(77,'Ni Ketut Manik Widiasih','P','','220990023','','Penata Muda TK.I','Staf Fak Ekonomi','III B'),(78,'Dewa Ayu Srinadi','P','','230990168','','Penata Muda','Staf Fak Ekonomi','III A'),(79,'Ni Ketut Ruminten','P','','220990009','','Pengatur TK. I','Staf Fak Ekonomi','III A'),(80,'Ni Made Suarsani','P','','220990014','','Pengatur Muda Tk.I','Staf Fak Ekonomi','II C'),(81,'Putu Bagus Ari Wismaya, S.Pd.','','','Kontrak','','','',''),(82,'Aminrais','L','123333','12121','Akuntansi','Letkol','Kepsek','III B'),(83,'Aminrasiisme','L','12333','101010','Akuntansi','Letkol','Kepsek','III B');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
