DROP TABLE IF EXISTS `struktur_organisasi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `struktur_organisasi` (
  `so_id` INT(11) NOT NULL AUTO_INCREMENT,
  `so_name` VARCHAR(100) NOT NULL,
  `so_index` INT(11) NOT NULL,
  PRIMARY KEY (`so_id`)
) ENGINE=INNODB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `struktur_organisasi`
--

LOCK TABLES `struktur_organisasi` WRITE;
/*!40000 ALTER TABLE `struktur_organisasi` DISABLE KEYS */;
INSERT INTO `struktur_organisasi` (`so_id`, `so_name`, `so_index`) VALUES (5,'Commissaries',0),(11,' Managing Director',5),(12,'Director',11),(13,'Finance Manager',12),(14,'Project Manager',12),(15,'Warehousing & Marketing Manager',12),(16,'Sales Operation Division',15),(17,'Export & Import Division',14),(18,'Transportation Division',14),(19,'Project Drilling, Building & Mining Division',14),(20,'Accounting & Tax',13),(21,'Customer Services',16),(22,'Documentation Staff',17),(23,'Mechanical & Heavy Equipment',18),(24,'Project Team',19),(25,'Admin & Kasir',20);
/*!40000 ALTER TABLE `struktur_organisasi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `struktur_pejabat`
--

DROP TABLE IF EXISTS `struktur_pejabat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `struktur_pejabat` (
  `so_id` INT(11) NOT NULL,
  `sp_id` INT(11) NOT NULL AUTO_INCREMENT,
  `sp_nama` VARCHAR(200) NOT NULL,
  `sp_nip` VARCHAR(30) NOT NULL,
  `sp_foto` VARCHAR(200) NOT NULL,
  `sp_jobdesc` TEXT NOT NULL,
  PRIMARY KEY (`sp_id`)
) ENGINE=INNODB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `struktur_pejabat`
--

LOCK TABLES `struktur_pejabat` WRITE;
/*!40000 ALTER TABLE `struktur_pejabat` DISABLE KEYS */;
INSERT INTO `struktur_pejabat` (`so_id`, `sp_id`, `sp_nama`, `sp_nip`, `sp_foto`, `sp_jobdesc`) VALUES (5,15,'Rahmad Budianto ( 10 % of Shareholding )','001','','Warehousing & Marketing Manager'),(11,35,' Andrie Noviantoro ( 57,5 % of Shareholding )','002','','Project Manager'),(12,36,'A. Davey Marindra ( 32,5 % of Shareholding )','003','','Director'),(13,37,'Fany Rosita Dewi','004','','Finance Manager'),(14,38,'Andrie Noviantoro','002','','Project Manager'),(16,40,'Ade Wirmansyah','005','','Sales Operation Division'),(17,41,'Didik Widhi Harsono','006','','Export & Import Division'),(18,42,'Arjunanto','007','','Transportation Division'),(19,43,'Bambang Karyadi','008','','Project Drilling, Building & Mining Division'),(20,44,'Deasy Adiningtyas','009','','Accounting & Tax'),(15,45,'Rahmad Budianto','004','','Warehousing & Marketing Manager'),(21,46,'Handy Suryani','009','','Customer Services'),(22,47,'Handy Suryani','010','','Documentation Staff'),(23,48,'Sirojuddin & Irwan','011','','Mechanical & Heavy Equipment'),(24,49,'Sucipto & Hariadi','012','','Project Team'),(25,50,'Deasy Adiningtyas','-','','Admin & Kasir');
/*!40000 ALTER TABLE `struktur_pejabat` ENABLE KEYS */;
UNLOCK TABLES;
