# MySQL-Front Dump 2.1
#
# Host: localhost   Database: test
#--------------------------------------------------------
# Server version 4.0.15-max-debug


#
# Table structure for table 'costcenter'
#

CREATE TABLE IF NOT EXISTS costcenter (
  AREA char(2) ,
  KD_DEPT char(3) ,
  DES varchar(30) 
);



#
# Dumping data for table 'costcenter'
#
INSERT INTO costcenter VALUES("30","58","ACCOUNTING");
INSERT INTO costcenter VALUES("30","57","GENERAL AFFAIR");
INSERT INTO costcenter VALUES("30","56","MTE");
INSERT INTO costcenter VALUES("30","60","EXPORT");
INSERT INTO costcenter VALUES("30","40","MANAGEMENT");
INSERT INTO costcenter VALUES("30","53","TERMINAL");
INSERT INTO costcenter VALUES("30","54","APRON");
INSERT INTO costcenter VALUES("30","43","SECURITY");
INSERT INTO costcenter VALUES("30","70","LME");
INSERT INTO costcenter VALUES("30","61","IMPORT");
INSERT INTO costcenter VALUES("30","41","FINANCE");
INSERT INTO costcenter VALUES("30","51","HUMAN RESOURCES");


#
# Table structure for table 'ms_peg'
#

CREATE TABLE IF NOT EXISTS ms_peg (
  ID int(11) ,
  NIP varchar(10) ,
  NAMA varchar(30) ,
  KD_DEPT char(3) ,
  KD_SEKSI varchar(5) ,
  STAT_PEG varchar(12) ,
  STA_PEG1 varchar(12) ,
  STAT_GOL char(2) ,
  KD_GRADE varchar(4) ,
  Kel_Jabatan char(1) ,
  TGL_MASUK datetime ,
  TGL_BERGABUNG datetime ,
  GOL_DARAH char(2) 
);



#
# Dumping data for table 'ms_peg'
#
INSERT INTO ms_peg VALUES("1","2011006","NYOMAN REKUN","60","6007","TETAP","A","","3","2","2000-11-01 00:00:00","","B");
INSERT INTO ms_peg VALUES("2","2011007","I NYOMAN SUDIASA","60","6007","TETAP","A","","3","2","2000-11-01 00:00:00","","B");
INSERT INTO ms_peg VALUES("3","2011008","DEVRIANTO","60","6007","TETAP","A","","2","2","2000-11-01 00:00:00","","B");
INSERT INTO ms_peg VALUES("4","2101004","NI MADE ADI PURNAWATI","53","5304","BERHENTI","N","","3","2","2001-01-02 00:00:00","","");
INSERT INTO ms_peg VALUES("5","2101005","NI KADEK AYU KOMALA DEWI","53","5301","TETAP","A","","4","2","2001-01-02 00:00:00","","O");
