--
-- Host: localhost    Database: fmedia_biddingdb
-- ------------------------------------------------------


--
-- Table structure for table `admin_groups`
--

CREATE TABLE `admin_groups` (
  `ag_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `ag_name` varchar(255) NOT NULL,
  PRIMARY KEY (`ag_group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `admin_groups`
--

INSERT INTO `admin_groups` VALUES (1,'admin'),(2,'manajemen'),(3,'user'),(4,'sosa');

--
-- Table structure for table `admin_resources`
--

CREATE TABLE `admin_resources` (
  `ar_group_id` int(11) NOT NULL DEFAULT 0,
  `ar_resource_id` int(11) NOT NULL DEFAULT 0,
  KEY `ar_admin_id` (`ar_group_id`,`ar_resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `admin_resources`
--


--
-- Table structure for table `bam`
--

CREATE TABLE `bam` (
  `nik` varchar(20) NOT NULL,
  `namabam` varchar(50) NOT NULL,
  `jabatan` varchar(100) NOT NULL,
  `loker` char(6) NOT NULL,
  `email` varchar(30) NOT NULL,
  PRIMARY KEY (`nik`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bam`
--

INSERT INTO `bam` VALUES ('561284','ARI PURWANTONO','BUSINESS ACCOUNT MANAGER-2','V','561284@telkom.co.id'),('570186','WIDJIANTO','BUSINESS ACCOUNT MANAGER-1','V','570186@telkom.co.id'),('570372','SUMARTINI','BUSINESS ACCOUNT MANAGER-2','II','570372@telkom.co.id'),('570549','HENOCH SULISTYO HARYONO','BUSINESS ACCOUNT MANAGER-2','VII','570549@telkom.co.id'),('570590','AGUS WINARKO','BUSINESS ACCOUNT MANAGER-1','I','570590@telkom.co.id'),('580439','ISMADI','BUSINESS ACCOUNT MANAGER-1','II','580439@telkom.co.id'),('580520','HELENA BASRI','BUSINESS ACCOUNT MANAGER-2','I','580520@telkom.co.id'),('580790','SITI DJENABSIAH','BUSINESS ACCOUNT MANAGER-1','II','580790@telkom.co.id'),('580887','NURHAYATI','BUSINESS ACCOUNT MANAGER-2','II','580887@telkom.co.id'),('581090','JOHANA LIES SUGIAKSI','BUSINESS ACCOUNT MANAGER-1','V','581090@telkom.co.id'),('581166','TATTY E. PATTIHAWEAN','BUSINESS ACCOUNT MANAGER-2','VII','581166@telkom.co.id'),('590011','ABDUL MALIK','BUSINESS ACCOUNT MANAGER-1','VII','590011@telkom.co.id'),('590827','DESMULYATI ADRIANI','BUSINESS ACCOUNT MANAGER-2','III','590827@telkom.co.id'),('591040','I MADE MAWAYANA','BUSINESS ACCOUNT MANAGER-2','VII','591040@telkom.co.id'),('591609','ABDUL ISMAIL','BUSINESS ACCOUNT MANAGER-2','V','591609@telkom.co.id'),('600539','I KETUT SUDIANA','BUSINESS ACCOUNT MANAGER-1','II','600539@telkom.co.id'),('600646','RUMZIBAY','BUSINESS ACCOUNT MANAGER-1','III','600646@telkom.co.id'),('600885','SUPRIJO','BUSINESS ACCOUNT MANAGER-2','II','600885@telkom.co.id'),('600910','SYARONI','BUSINESS ACCOUNT MANAGER-1','VI','600910@telkom.co.id'),('601057','YAHYA','BUSINESS ACCOUNT MANAGER-1','II','601057@telkom.co.id'),('601331','HERYAMAN','BUSINESS ACCOUNT MANAGER-2','III','601331@telkom.co.id'),('601529','AGUS WAHYUDI','BUSINESS ACCOUNT MANAGER-1','II','601529@telkom.co.id'),('601577','SAMSUL HADI','BUSINESS ACCOUNT MANAGER-1','V','601577@telkom.co.id'),('601599','EDWARDI','BUSINESS ACCOUNT MANAGER-1','I','601599@telkom.co.id'),('601632','NURSAMAN','BUSINESS ACCOUNT MANAGER-1','II','601632@telkom.co.id'),('601730','SUPRIYANTO','BUSINESS ACCOUNT MANAGER-2','II','601730@telkom.co.id'),('601943','SUWITO','BUSINESS ACCOUNT MANAGER-2','V','601943@telkom.co.id'),('602104','SORAYA AZIS','BUSINESS ACCOUNT MANAGER-2','II','602104@telkom.co.id'),('602304','SAMSUDDIN','BUSINESS ACCOUNT MANAGER-2','VII','602304@telkom.co.id'),('602483','ITANG SURYANA','BUSINESS ACCOUNT MANAGER-2','III','602483@telkom.co.id'),('610078','CHAIRUL IRIANTO KUEMBA','BUSINESS ACCOUNT MANAGER','VII','610078@telkom.co.id'),('610310','JOHN VILDA','BUSINESS ACCOUNT MANAGER','II','610310@telkom.co.id'),('610532','MAHFUDIN','BUSINESS ACCOUNT MANAGER-2','II','610532@telkom.co.id'),('610534','PUDJO SUMARDIONO','BUSINESS ACCOUNT MANAGER-1','II','610534@telkom.co.id'),('611215','IDA RUSDIAWATI','BUSINESS ACCOUNT MANAGER-1','V','611215@telkom.co.id'),('611529','RIZAL ARIYANTO, SE','BUSINESS ACCOUNT MANAGER-2','I','611529@telkom.co.id'),('611764','R. AGUS PUSPOWARTO','BUSINESS ACCOUNT MANAGER-2','II','611764@telkom.co.id'),('611873','JUBELINA LATURIUW','BUSINESS ACCOUNT MANAGER-2','VII','611873@telkom.co.id'),('611896','I WAYAN BANTAS','BUSINESS ACCOUNT MANAGER-2','VII','611896@telkom.co.id'),('611908','SUHARNI','BUSINESS ACCOUNT MANAGER-2','II','611908@telkom.co.id'),('611919','DIRHAMSYAH','BUSINESS ACCOUNT MANAGER-2','II','611919@telkom.co.id'),('611982','SULISTIJONO','BUSINESS ACCOUNT MANAGER-2','V','611982@telkom.co.id'),('612149','KIAGUS ABDUL RAHMAN','BUSINESS ACCOUNT MANAGER-1','II','612149@telkom.co.id'),('612180','RIZAL','BUSINESS ACCOUNT MANAGER-2','I','612180@telkom.co.id'),('612402','AGUS SUHARYONO','BUSINESS ACCOUNT MANAGER-2','II','612402@telkom.co.id'),('612501','ACHMAD YANIS','BUSINESS ACCOUNT MANAGER-1','V','612501@telkom.co.id'),('612579','HANES','BUSINESS ACCOUNT MANAGER-2','VII','612579@telkom.co.id'),('612710','MUCHYAR YANTO','BUSINESS ACCOUNT MANAGER-2','VI','612710@telkom.co.id'),('620164','HELVIANA','BUSINESS ACCOUNT MANAGER-1','V','620164@telkom.co.id'),('620216','MUSLICH ABDULLAH','BUSINESS ACCOUNT MANAGER-2','V','620216@telkom.co.id'),('620222','SUTIKNO','BUSINESS ACCOUNT MANAGER-1','V','620222@telkom.co.id'),('620276','I GUSTI AYU NGURAH','BUSINESS ACCOUNT MANAGER-2','VII','620276@telkom.co.id'),('620289','YUSNITA NUR','BUSINESS ACCOUNT MANAGER-1','VII','620289@telkom.co.id'),('620300','SUWITI M. K.','BUSINESS ACCOUNT MANAGER-2','II','620300@telkom.co.id'),('620307','ASNIDAR, DRA.','BUSINESS ACCOUNT MANAGER-1','II','620307@telkom.co.id'),('620436','YANUAR ISMAIRIN','BUSINESS ACCOUNT MANAGER-1','II','620436@telkom.co.id'),('620467','LOMRAH','BUSINESS ACCOUNT MANAGER-2','II','620467@telkom.co.id'),('620518','RAMDANI, DRS.','BUSINESS ACCOUNT MANAGER-1','I','620518@telkom.co.id'),('620526','RINGGIT SURYADI','BUSINESS ACCOUNT MANAGER-2','II','620526@telkom.co.id'),('620553','TULUS','BUSINESS ACCOUNT MANAGER-2','II','620553@telkom.co.id'),('620637','ENDY SUGIANTO','BUSINESS ACCOUNT MANAGER-2','II','620637@telkom.co.id'),('620705','NANI MANSYUR','BUSINESS ACCOUNT MANAGER-2','II','620705@telkom.co.id'),('621024','MUHAJIR','BUSINESS ACCOUNT MANAGER-1','V','621024@telkom.co.id'),('621047','BUDIYANTO','BUSINESS ACCOUNT MANAGER-1','V','621047@telkom.co.id'),('621048','ANDI PERNADI','BUSINESS ACCOUNT MANAGER-1','V','621048@telkom.co.id'),('621104','NI KETUT SARIANI','BUSINESS ACCOUNT MANAGER-2','VII','621104@telkom.co.id'),('621106','I GST AYU NGR REDI SURYANTHI','BUSINESS ACCOUNT MANAGER-1','VII','621106@telkom.co.id'),('621169','M. YUSUF','BUSINESS ACCOUNT MANAGER-2','I','621169@telkom.co.id'),('621343','AGUS PRASETYO, ST.','BUSINESS ACCOUNT MANAGER-1','V','621343@telkom.co.id'),('621533','HARTONO, SE','BUSINESS ACCOUNT MANAGER-1','IV','621533@telkom.co.id'),('621675','HELMIZAR','BUSINESS ACCOUNT MANAGER-2','I','621675@telkom.co.id'),('621742','KATARINA ANGELA ZINA','BUSINESS ACCOUNT MANAGER-1','VII','621742@telkom.co.id'),('621750','I NYOMAN ARSA','BUSINESS ACCOUNT MANAGER-2','VII','621750@telkom.co.id'),('621879','SOETOWO','BUSINESS ACCOUNT MANAGER-1','I','621879@telkom.co.id'),('621893','WAHYU BUDI','BUSINESS ACCOUNT MANAGER-2','V','621893@telkom.co.id'),('621922','SUJUD GUSNANDAR','BUSINESS ACCOUNT MANAGER-2','V','621922@telkom.co.id'),('621964','HERRY PRASETYO','BUSINESS ACCOUNT MANAGER-2','V','621964@telkom.co.id'),('621996','SUSY IRMAWATI','BUSINESS ACCOUNT MANAGER-1','II','621996@telkom.co.id'),('622013','ADI GAGARIYANTO','BUSINESS ACCOUNT MANAGER-1','V','622013@telkom.co.id'),('622119','IKE ARIFIN ENDON','BUSINESS ACCOUNT MANAGER-1','II','622119@telkom.co.id'),('622160','JOKO SUSILO','BUSINESS ACCOUNT MANAGER-2','I','622160@telkom.co.id'),('622240','ELLI YANTI','BUSINESS ACCOUNT MANAGER-1','I','622240@telkom.co.id'),('622300','BOEDI MARTOYO','BUSINESS ACCOUNT MANAGER-1','IV','622300@telkom.co.id'),('622611','ASMIN','BUSINESS ACCOUNT MANAGER-2','VII','622611@telkom.co.id'),('622655','SUMARNO','BUSINESS ACCOUNT MANAGER-2','II','622655@telkom.co.id'),('622880','SUKARDI','BUSINESS ACCOUNT MANAGER-2','II','622880@telkom.co.id'),('623134','DESFIRIZAL','BUSINESS ACCOUNT MANAGER-2','I','623134@telkom.co.id'),('623166','NASWAR','BUSINESS ACCOUNT MANAGER-2','I','623166@telkom.co.id'),('630251','RACHMAT DALIMONTHE','BUSINESS ACCOUNT MANAGER-1','II','630251@telkom.co.id'),('630263','IDRIS PATIMURA','BUSINESS ACCOUNT MANAGER-1','II','630263@telkom.co.id'),('630363','DEDI IRIANTO','BUSINESS ACCOUNT MANAGER-1','III','630363@telkom.co.id'),('630406','WIRYAWAN','BUSINESS ACCOUNT MANAGER-1','V','630406@telkom.co.id'),('630445','ISKANDAR','BUSINESS ACCOUNT MANAGER','VII','630445@telkom.co.id'),('630498','EDI SISWANTO','BUSINESS ACCOUNT MANAGER-2','II','630498@telkom.co.id'),('630510','ASEP FACHRUDIN','BUSINESS ACCOUNT MANAGER-1','II','630510@telkom.co.id'),('630512','ANTHONY SALIM','BUSINESS ACCOUNT MANAGER-1','II','630512@telkom.co.id'),('630537','PURWO SUYONO','BUSINESS ACCOUNT MANAGER-1','II','630537@telkom.co.id'),('630688','EDY SURYANTO, SE','BUSINESS ACCOUNT MANAGER-1','IV','630688@telkom.co.id'),('630698','TITUT WAHYU TJAHYADI','BUSINESS ACCOUNT MANAGER-1','II','630698@telkom.co.id'),('630842','WARNAENI','BUSINESS ACCOUNT MANAGER-2','II','630842@telkom.co.id'),('630930','HALIJAH','BUSINESS ACCOUNT MANAGER-2','VII','630930@telkom.co.id'),('630937','YULIANI','BUSINESS ACCOUNT MANAGER-2','VII','630937@telkom.co.id'),('631018','ERLINDA','BUSINESS ACCOUNT MANAGER-2','II','631018@telkom.co.id'),('631088','NANANG SUNARDI','BUSINESS ACCOUNT MANAGER-1','V','631088@telkom.co.id'),('631093','BAMBANG SISWANTO','BUSINESS ACCOUNT MANAGER-1','V','631093@telkom.co.id'),('631110','SUCI ERNANINGTYAS','BUSINESS ACCOUNT MANAGER-1','V','631110@telkom.co.id'),('631112','YULI DAMAYANTI','BUSINESS ACCOUNT MANAGER-1','V','631112@telkom.co.id'),('631140','GATOT SUNJONO','BUSINESS ACCOUNT MANAGER-1','V','631140@telkom.co.id'),('631159','AGUS HARI SUSANTO','BUSINESS ACCOUNT MANAGER-1','V','631159@telkom.co.id'),('631165','JACOB MANUPUTTY','BUSINESS ACCOUNT MANAGER-2','VII','631165@telkom.co.id'),('631167','SRI HASANAH','BUSINESS ACCOUNT MANAGER-2','II','631167@telkom.co.id'),('631266','SUROSO','BUSINESS ACCOUNT MANAGER-2','I','631266@telkom.co.id'),('631331','HARYUNI','BUSINESS ACCOUNT MANAGER-2','I','631331@telkom.co.id'),('631398','IDA AYU KETUT KARTIKA','BUSINESS ACCOUNT MANAGER-2','VII','631398@telkom.co.id'),('631432','AGUSTINUS SUMARYOTO','BUSINESS ACCOUNT MANAGER-1','VII','631432@telkom.co.id'),('631626','ADRIAN','BUSINESS ACCOUNT MANAGER-1','VI','631626@telkom.co.id'),('631845','ALIM HAMID','BUSINESS ACCOUNT MANAGER-1','VII','631845@telkom.co.id'),('631848','HERRI SOEHARIYONO','BUSINESS ACCOUNT MANAGER-1','VII','631848@telkom.co.id'),('631877','OKTORIZAL','BUSINESS ACCOUNT MANAGER','I','631877@telkom.co.id'),('631915','SENTOT HARTANTO','BUSINESS ACCOUNT MANAGER-2','II','631915@telkom.co.id'),('631923','SRI SUBEKTI','BUSINESS ACCOUNT MANAGER-2','I','631923@telkom.co.id'),('631946','M.MULYONO','BUSINESS ACCOUNT MANAGER-2','I','631946@telkom.co.id'),('631962','AGUNG PRIANTONO','BUSINESS ACCOUNT MANAGER-2','V','631962@telkom.co.id'),('631980','IKMAL YAZID','BUSINESS ACCOUNT MANAGER-1','II','631980@telkom.co.id'),('632033','NIKU PIDU','BUSINESS ACCOUNT MANAGER-2','VII','632033@telkom.co.id'),('632058','MEIDY MULIA','BUSINESS ACCOUNT MANAGER-1','II','632058@telkom.co.id'),('632136','JULIUS LATUHERU','BUSINESS ACCOUNT MANAGER-2','VII','632136@telkom.co.id'),('632141','ABRAHAM MAINAKE','BUSINESS ACCOUNT MANAGER-1','VII','632141@telkom.co.id'),('632213','RATNA, SE','BUSINESS ACCOUNT MANAGER-2','VII','632213@telkom.co.id'),('632249','SUBADI','BUSINESS ACCOUNT MANAGER-1','V','632249@telkom.co.id'),('632353','HERI SANTOSA','BUSINESS ACCOUNT MANAGER-1','VI','632353@telkom.co.id'),('632506','EDY TAHSIN','BUSINESS ACCOUNT MANAGER-1','V','632506@telkom.co.id'),('632540','ENDANG SURYANA','BUSINESS ACCOUNT MANAGER-2','II','632540@telkom.co.id'),('640013','MUHAMMAD HANIS','BUSINESS ACCOUNT MANAGER-2','I','640013@telkom.co.id'),('640142','ACHWANI SETIJOKO','BUSINESS ACCOUNT MANAGER-1','IV','640142@telkom.co.id'),('640238','ACHMAD NURUL L','BUSINESS ACCOUNT MANAGER-1','IV','640238@telkom.co.id'),('640258','SAMIN','BUSINESS ACCOUNT MANAGER-2','V','640258@telkom.co.id'),('640259','JAZULI','BUSINESS ACCOUNT MANAGER-2','V','640259@telkom.co.id'),('640281','SRI SUHARTINI','BUSINESS ACCOUNT MANAGER-1','V','640281@telkom.co.id'),('640282','MUSYAWATI','BUSINESS ACCOUNT MANAGER-1','V','640282@telkom.co.id'),('640286','WAHYU SRI ROCHANI','BUSINESS ACCOUNT MANAGER-2','V','640286@telkom.co.id'),('640299','MAJID','BUSINESS ACCOUNT MANAGER-2','V','640299@telkom.co.id'),('640350','YAYAN MULYANA','BUSINESS ACCOUNT MANAGER-1','I','640350@telkom.co.id'),('640412','YUNIZAR MUSTAFA, SE.','BUSINESS ACCOUNT MANAGER-1','I','640412@telkom.co.id'),('640442','AZHARI ARWANI','BUSINESS ACCOUNT MANAGER-2','I','640442@telkom.co.id'),('640475','EKA PUDJIANTORO','BUSINESS ACCOUNT MANAGER-1','II','640475@telkom.co.id'),('640543','MELKIANUS DARIUS LANING','BUSINESS ACCOUNT MANAGER-1','VII','640543@telkom.co.id'),('640610','ERIZALDI','BUSINESS ACCOUNT MANAGER-2','I','640610@telkom.co.id'),('640618','SELAMAT RIYADI','BUSINESS ACCOUNT MANAGER-1','I','640618@telkom.co.id'),('640682','MAHTA VIVA','BUSINESS ACCOUNT MANAGER-1','I','640682@telkom.co.id'),('640701','HETTY NUGRAWENI','BUSINESS ACCOUNT MANAGER-1','II','640701@telkom.co.id'),('640722','TRI RATNAWATI, RR, A.Md','BUSINESS ACCOUNT MANAGER-1','IV','640722@telkom.co.id'),('640778','BAMBANG PURWANTO','BUSINESS ACCOUNT MANAGER','IV','640778@telkom.co.id'),('640870','SURYONO','BUSINESS ACCOUNT MANAGER-1','II','640870@telkom.co.id'),('640892','NURASI M. LANGKEJA','BUSINESS ACCOUNT MANAGER-2','VII','640892@telkom.co.id'),('640971','AGUS SUSILO','BUSINESS ACCOUNT MANAGER-1','V','640971@telkom.co.id'),('640999','MOHAMMAD IKHWAN, SE','BUSINESS ACCOUNT MANAGER-1','IV','640999@telkom.co.id'),('641036','MARIA DETJE MONINGKA','BUSINESS ACCOUNT MANAGER-2','VII','641036@telkom.co.id'),('641057','WISMARHADI','BUSINESS ACCOUNT MANAGER-2','I','641057@telkom.co.id'),('641123','DAMASKUS','BUSINESS ACCOUNT MANAGER-2','V','641123@telkom.co.id'),('641130','AGUS WIBOWO','BUSINESS ACCOUNT MANAGER-2','V','641130@telkom.co.id'),('641184','JOYCE FRANSISCA KALIGIS','BUSINESS ACCOUNT MANAGER-2','VII','641184@telkom.co.id'),('641374','BUJUNG RINDING A.','BUSINESS ACCOUNT MANAGER-1','VII','641374@telkom.co.id'),('641404','NI LUH WIRATI,SE','BUSINESS ACCOUNT MANAGER-1','VII','641404@telkom.co.id'),('641447','GUSTI AYU KADE SEDANI','BUSINESS ACCOUNT MANAGER-2','II','641447@telkom.co.id'),('641474','ROBERT S.M.SIANTURI','BUSINESS ACCOUNT MANAGER-1','I','641474@telkom.co.id'),('641514','SUYONO','BUSINESS ACCOUNT MANAGER-1','V','641514@telkom.co.id'),('641515','HANAFIK USMAN','BUSINESS ACCOUNT MANAGER-1','VII','641515@telkom.co.id'),('641676','NURJANNAH A.T.','BUSINESS ACCOUNT MANAGER-1','I','641676@telkom.co.id'),('641821','MUHAMMAD KASIM','BUSINESS ACCOUNT MANAGER-2','VII','641821@telkom.co.id'),('641827','RAMLAH HARDJO','BUSINESS ACCOUNT MANAGER-2','VII','641827@telkom.co.id'),('641983','MOCH. HASAN HAMDANI, R','BUSINESS ACCOUNT MANAGER','II','641983@telkom.co.id'),('642066','SETYA BUDI RUSTAMADJI','BUSINESS ACCOUNT MANAGER-1','II','642066@telkom.co.id'),('642067','SUWANDI','BUSINESS ACCOUNT MANAGER-2','II','642067@telkom.co.id'),('642351','IMAN JAYA','BUSINESS ACCOUNT MANAGER-1','VII','642351@telkom.co.id'),('642355','PUTU SUARTAWAN','BUSINESS ACCOUNT MANAGER-1','VII','642355@telkom.co.id'),('642394','AHMAD YANI','BUSINESS ACCOUNT MANAGER-1','VI','642394@telkom.co.id'),('642416','OLIPER SILALAHI','BUSINESS ACCOUNT MANAGER-2','VI','642416@telkom.co.id'),('642460','ROSMEN SITUMORANG','BUSINESS ACCOUNT MANAGER-2','I','642460@telkom.co.id'),('642478','MIDUK MARDONGAN PARDEDE','BUSINESS ACCOUNT MANAGER-2','I','642478@telkom.co.id'),('642509','SUGIONO','BUSINESS ACCOUNT MANAGER-2','I','642509@telkom.co.id'),('642522','RAMLI','BUSINESS ACCOUNT MANAGER-2','I','642522@telkom.co.id'),('642551','ARIFUDDIN','BUSINESS ACCOUNT MANAGER-2','VII','642551@telkom.co.id'),('650065','LUHUT','BUSINESS ACCOUNT MANAGER-1','I','650065@telkom.co.id'),('650096','ROSIANNA BR PURBA','BUSINESS ACCOUNT MANAGER-2','III','650096@telkom.co.id'),('650108','ERMALADIANI','BUSINESS ACCOUNT MANAGER-1','I','650108@telkom.co.id'),('650176','I NYOMAN PUTRA WIJAYA','BUSINESS ACCOUNT MANAGER-2','VII','650176@telkom.co.id'),('650208','ZULKARNAEN','BUSINESS ACCOUNT MANAGER-1','I','650208@telkom.co.id'),('650258','HAN DWI CAHYONO','BUSINESS ACCOUNT MANAGER','VII','650258@telkom.co.id'),('650279','JOKO PRIHANTORO, S.E.','BUSINESS ACCOUNT MANAGER-1','IV','650279@telkom.co.id'),('650295','HARI SUBRIHANDOKO, S.T.','BUSINESS ACCOUNT MANAGER','IV','650295@telkom.co.id'),('650315','SOFYAN HUSAIN','BUSINESS ACCOUNT MANAGER-1','VII','650315@telkom.co.id'),('650357','SRI MULATSIH','BUSINESS ACCOUNT MANAGER-2','II','650357@telkom.co.id'),('650360','TRI RIYANTI','BUSINESS ACCOUNT MANAGER-2','II','650360@telkom.co.id'),('650389','HERU BIANTORO','BUSINESS ACCOUNT MANAGER-1','V','650389@telkom.co.id'),('650408','ZAKIAH','BUSINESS ACCOUNT MANAGER','III','650408@telkom.co.id'),('650451','SUJONO','BUSINESS ACCOUNT MANAGER-1','VI','650451@telkom.co.id'),('650487','HARIMURTI WISNU BUDOYO','BUSINESS ACCOUNT MANAGER-1','III','650487@telkom.co.id'),('650501','ROSDIANSYAH','BUSINESS ACCOUNT MANAGER-1','VI','650501@telkom.co.id'),('650530','NAHAN HABEAHAN','BUSINESS ACCOUNT MANAGER-2','VII','650530@telkom.co.id'),('650614','CAHYO DWIKORANU','BUSINESS ACCOUNT MANAGER-1','V','650614@telkom.co.id'),('650642','EKO HERI SUSANTO','BUSINESS ACCOUNT MANAGER','VI','650642@telkom.co.id'),('650768','EDY SUMARKO','BUSINESS ACCOUNT MANAGER-1','I','650768@telkom.co.id'),('650800','TRI SUKO AGUSTIN','BUSINESS ACCOUNT MANAGER','II','650800@telkom.co.id'),('650870','SISWADI','BUSINESS ACCOUNT MANAGER-1','I','650870@telkom.co.id'),('650975','BAMBANG EDI KARISENA','BUSINESS ACCOUNT MANAGER-1','VI','650975@telkom.co.id'),('651033','OKTAVIANUS MAY','BUSINESS ACCOUNT MANAGER','VII','651033@telkom.co.id'),('651190','ETWIN SOETJININGSIH','BUSINESS ACCOUNT MANAGER','II','651190@telkom.co.id'),('651471','ARIF HIDAYAT, A.Md','BUSINESS ACCOUNT MANAGER-2','IV','651471@telkom.co.id'),('651533','WASITO','BUSINESS ACCOUNT MANAGER-2','I','651533@telkom.co.id'),('651535','AMINULLAH PULUNGAN,S.E','BUSINESS ACCOUNT MANAGER-1','I','651535@telkom.co.id'),('651551','SARINO','BUSINESS ACCOUNT MANAGER-2','I','651551@telkom.co.id'),('651617','KHOIRUL AMIN','BUSINESS ACCOUNT MANAGER-1','V','651617@telkom.co.id'),('660017','MUNAWIR','BUSINESS ACCOUNT MANAGER-2','V','660017@telkom.co.id'),('660082','PUJIYANTO','BUSINESS ACCOUNT MANAGER-1','VII','660082@telkom.co.id'),('660102','TRIARSO SAMBODO','BUSINESS ACCOUNT MANAGER-1','V','660102@telkom.co.id'),('660115','HARRY CHRISTHIJANTO','BUSINESS ACCOUNT MANAGER-1','IV','660115@telkom.co.id'),('660142','CIPTADI WIDODO','BUSINESS ACCOUNT MANAGER-1','IV','660142@telkom.co.id'),('660264','DIAH SAPTAPUTRI DECIANTI','BUSINESS ACCOUNT MANAGER-1','V','660264@telkom.co.id'),('660457','YUSRIZAL','BUSINESS ACCOUNT MANAGER-2','I','660457@telkom.co.id'),('660480','MUNIR B','BUSINESS ACCOUNT MANAGER-2','VII','660480@telkom.co.id'),('660486','ROHAYATI','BUSINESS ACCOUNT MANAGER-2','II','660486@telkom.co.id'),('660502','EDI ZULFAN','BUSINESS ACCOUNT MANAGER-1','I','660502@telkom.co.id'),('670144','IRHAM','BUSINESS ACCOUNT MANAGER-1','VII','670144@telkom.co.id'),('670170','YULIA SARI NASUTION','BUSINESS ACCOUNT MANAGER','II','670170@telkom.co.id'),('670321','KMS. M. YUSUF','BUSINESS ACCOUNT MANAGER-2','I','670321@telkom.co.id'),('670331','UMI FATIMAH','BUSINESS ACCOUNT MANAGER-2','IV','670331@telkom.co.id'),('670340','BURHANUDDIN','BUSINESS ACCOUNT MANAGER-2','I','670340@telkom.co.id'),('670454','MARTALENA','BUSINESS ACCOUNT MANAGER','I','670454@telkom.co.id'),('670512','ASEP TARYO','BUSINESS ACCOUNT MANAGER-1','III','670512@telkom.co.id'),('670556','DIMSON SITUMORANG','BUSINESS ACCOUNT MANAGER-2','VII','670556@telkom.co.id'),('670573','ISMAIL MUTAWAKKIL','BUSINESS ACCOUNT MANAGER-2','II','670573@telkom.co.id'),('670583','JOKO SARWONO','BUSINESS ACCOUNT MANAGER-1','II','670583@telkom.co.id'),('680040','SITI RAHAYU, ST','BUSINESS ACCOUNT MANAGER-1','IV','680040@telkom.co.id'),('680115','SUDARMINAH','BUSINESS ACCOUNT MANAGER-2','II','680115@telkom.co.id'),('680136','DEKY STEFANUS ROHI DJAWA','BUSINESS ACCOUNT MANAGER-2','VII','680136@telkom.co.id'),('680253','UDIN SUHARDI','BUSINESS ACCOUNT MANAGER-1','II','680253@telkom.co.id'),('680258','DELFI NORA','BUSINESS ACCOUNT MANAGER-2','I','680258@telkom.co.id'),('680273','HIDAYAT','BUSINESS ACCOUNT MANAGER','I','680273@telkom.co.id'),('680488','ZAINAL HANIF','BUSINESS ACCOUNT MANAGER-2','II','680488@telkom.co.id'),('680551','RIFRINALDI','BUSINESS ACCOUNT MANAGER-1','II','680551@telkom.co.id'),('690043','I MADE PANDE WINDIA','BUSINESS ACCOUNT MANAGER-1','VII','690043@telkom.co.id'),('690070','SARIP','BUSINESS ACCOUNT MANAGER-2','II','690070@telkom.co.id'),('690105','BAMBANG ASMADI','BUSINESS ACCOUNT MANAGER-1','II','690105@telkom.co.id'),('690111','DWINANTO SUYOSO','BUSINESS ACCOUNT MANAGER-2','II','690111@telkom.co.id'),('690113','EKO WICAKSONO','BUSINESS ACCOUNT MANAGER-2','II','690113@telkom.co.id'),('690138','SUGIARTO','BUSINESS ACCOUNT MANAGER-2','II','690138@telkom.co.id'),('690226','HARYO ISMAIL','BUSINESS ACCOUNT MANAGER-2','II','690226@telkom.co.id'),('690318','BUDIYONO','BUSINESS ACCOUNT MANAGER-1','II','690318@telkom.co.id'),('690385','I GUSTI AYU LIANASARI','BUSINESS ACCOUNT MANAGER-2','VII','690385@telkom.co.id'),('690398','SARWOKO','BUSINESS ACCOUNT MANAGER-2','II','690398@telkom.co.id'),('690438','SOLIHIN','BUSINESS ACCOUNT MANAGER-2','II','690438@telkom.co.id'),('690457','DEDI PURWANTO','BUSINESS ACCOUNT MANAGER-2','II','690457@telkom.co.id'),('690503','UTARIYANTO','BUSINESS ACCOUNT MANAGER-2','II','690503@telkom.co.id'),('690509','SRI IDAYATUN','BUSINESS ACCOUNT MANAGER-2','II','690509@telkom.co.id'),('690526','AHMAD KOSASIH','BUSINESS ACCOUNT MANAGER-2','II','690526@telkom.co.id'),('690594','ELLY RAHMALYA','BUSINESS ACCOUNT MANAGER-2','II','690594@telkom.co.id'),('700005','JUNIAR FIRNANDO SIRAIT','BUSINESS ACCOUNT MANAGER-1','I','700005@telkom.co.id'),('700012','FENY IRIANI','BUSINESS ACCOUNT MANAGER-1','II','700012@telkom.co.id'),('700016','RIKA YUDHANTI','BUSINESS ACCOUNT MANAGER-2','II','700016@telkom.co.id'),('700026','CHRISTIANA NILA DEWI','BUSINESS ACCOUNT MANAGER-2','IV','700026@telkom.co.id'),('700045','AGUS WIJAYA','BUSINESS ACCOUNT MANAGER-1','II','700045@telkom.co.id'),('700046','MISWAN ADIL','BUSINESS ACCOUNT MANAGER-1','II','700046@telkom.co.id'),('700084','HANAFI','BUSINESS ACCOUNT MANAGER-2','II','700084@telkom.co.id'),('700161','ZULMAN EFFENDI','BUSINESS ACCOUNT MANAGER-2','I','700161@telkom.co.id'),('700237','TOMY CHERIAWAN','BUSINESS ACCOUNT MANAGER-1','II','700237@telkom.co.id'),('700247','ANDI HARYADI','BUSINESS ACCOUNT MANAGER-2','II','700247@telkom.co.id'),('700260','VARIDA DELIANA MANIK','BUSINESS ACCOUNT MANAGER-2','I','700260@telkom.co.id'),('700290','NUR DJANNAH','BUSINESS ACCOUNT MANAGER-1','VII','700290@telkom.co.id'),('700291','WILHELMINA STANLY WANTAH','BUSINESS ACCOUNT MANAGER-2','VII','700291@telkom.co.id'),('700304','LEONARD KITU RIWU','BUSINESS ACCOUNT MANAGER-2','VII','700304@telkom.co.id'),('700306','ACHMAD SUPRIADI','BUSINESS ACCOUNT MANAGER-1','II','700306@telkom.co.id'),('700366','MUHAMAD TAUFIK','BUSINESS ACCOUNT MANAGER-1','II','700366@telkom.co.id'),('700382','ANDRI WIBOWO','BUSINESS ACCOUNT MANAGER-2','II','700382@telkom.co.id'),('700393','MAIDA KUSTANTINA','BUSINESS ACCOUNT MANAGER-1','II','700393@telkom.co.id'),('700406','NI WAYAN SUKASANI','BUSINESS ACCOUNT MANAGER-1','VII','700406@telkom.co.id'),('700408','MARGARETHA MARIA ALACOQUE','BUSINESS ACCOUNT MANAGER-2','VII','700408@telkom.co.id'),('700416','ENDANG WULANDARI','BUSINESS ACCOUNT MANAGER-1','VII','700416@telkom.co.id'),('700419','NI MADE ASTITI PURBA SARI','BUSINESS ACCOUNT MANAGER-1','VII','700419@telkom.co.id'),('700439','TUTIEK SUDARINI, S.E.','BUSINESS ACCOUNT MANAGER-2','IV','700439@telkom.co.id'),('700468','CHUMAIDI HAMBALI','BUSINESS ACCOUNT MANAGER-2','II','700468@telkom.co.id'),('700491','ABDUL FATTAH','BUSINESS ACCOUNT MANAGER-2','II','700491@telkom.co.id'),('700537','RIZAL IDHAM','BUSINESS ACCOUNT MANAGER-2','II','700537@telkom.co.id'),('700540','SUTISNA','BUSINESS ACCOUNT MANAGER-2','II','700540@telkom.co.id'),('700542','SUHADA','BUSINESS ACCOUNT MANAGER-1','II','700542@telkom.co.id'),('700564','SUSI NURSULASIAH','BUSINESS ACCOUNT MANAGER-2','II','700564@telkom.co.id'),('700584','WERDI MEGANINGSIH','BUSINESS ACCOUNT MANAGER-2','II','700584@telkom.co.id'),('700616','ERNI GUSTINAR','BUSINESS ACCOUNT MANAGER-2','II','700616@telkom.co.id'),('700628','BUDIYANTI','BUSINESS ACCOUNT MANAGER-1','II','700628@telkom.co.id'),('700639','SITI NURHAYATI,RADEN','BUSINESS ACCOUNT MANAGER-1','II','700639@telkom.co.id'),('710004','DEWI AISYAH','BUSINESS ACCOUNT MANAGER-2','VII','710004@telkom.co.id'),('710008','EKA RAHARDJA ZAIBI','BUSINESS ACCOUNT MANAGER-1','IV','710008@telkom.co.id'),('710019','HENDRIANA','BUSINESS ACCOUNT MANAGER-2','II','710019@telkom.co.id'),('710046','RICHARD','BUSINESS ACCOUNT MANAGER-1','II','710046@telkom.co.id'),('710048','SOMANTRI','BUSINESS ACCOUNT MANAGER-1','II','710048@telkom.co.id'),('710073','ARFAN SUATAN','BUSINESS ACCOUNT MANAGER-1','I','710073@telkom.co.id'),('710091','NAHASON SINAGA','BUSINESS ACCOUNT MANAGER-1','II','710091@telkom.co.id'),('710099','MURWANINGSIH','BUSINESS ACCOUNT MANAGER-1','II','710099@telkom.co.id'),('710124','JULIE ISNAWATI','BUSINESS ACCOUNT MANAGER-2','II','710124@telkom.co.id'),('710141','DEWI ANA PARWATI','BUSINESS ACCOUNT MANAGER-1','VI','710141@telkom.co.id'),('710203','LULUK ERIKAWATI','BUSINESS ACCOUNT MANAGER-1','II','710203@telkom.co.id'),('710211','AMBAR SADWI S.P','BUSINESS ACCOUNT MANAGER-1','V','710211@telkom.co.id'),('710256','DENI HANDHOKO','BUSINESS ACCOUNT MANAGER-1','II','710256@telkom.co.id'),('710268','PUJI PRAMONO HADI','BUSINESS ACCOUNT MANAGER-2','II','710268@telkom.co.id'),('710309','NAKHDUDIN','BUSINESS ACCOUNT MANAGER-1','II','710309@telkom.co.id'),('710325','ANSORI','BUSINESS ACCOUNT MANAGER-1','II','710325@telkom.co.id'),('710336','BENSON SINAGA','BUSINESS ACCOUNT MANAGER-1','I','710336@telkom.co.id'),('710337','M. ARIFIN','BUSINESS ACCOUNT MANAGER-2','II','710337@telkom.co.id'),('710423','RIZAL FAISAL','BUSINESS ACCOUNT MANAGER','II','710423@telkom.co.id'),('710441','HENDRY ZULFIKAR, ST','BUSINESS ACCOUNT MANAGER','II','710441@telkom.co.id'),('720001','ERLINA','BUSINESS ACCOUNT MANAGER-2','I','720001@telkom.co.id'),('720005','RAHAYU RUSYANTATI','BUSINESS ACCOUNT MANAGER-2','II','720005@telkom.co.id'),('720006','RINA WATI','BUSINESS ACCOUNT MANAGER-1','II','720006@telkom.co.id'),('720009','ARIZONA','BUSINESS ACCOUNT MANAGER-1','III','720009@telkom.co.id'),('720022','SUHARTYANI','BUSINESS ACCOUNT MANAGER-1','VII','720022@telkom.co.id'),('720031','LAELY ISTIARINI NIRMALA','BUSINESS ACCOUNT MANAGER-2','VII','720031@telkom.co.id'),('720032','KHADIJAH','BUSINESS ACCOUNT MANAGER-2','I','720032@telkom.co.id'),('720041','DESAK PUTU MULIANI','BUSINESS ACCOUNT MANAGER-2','VII','720041@telkom.co.id'),('720043','SUTARSIH','BUSINESS ACCOUNT MANAGER-2','II','720043@telkom.co.id'),('720052','NURSUCI KARTINI','BUSINESS ACCOUNT MANAGER-2','VII','720052@telkom.co.id'),('720139','TUTIK SRI ASTUTI,ST','BUSINESS ACCOUNT MANAGER','V','720139@telkom.co.id'),('720153','RIDWAN NULCHOLIQ','BUSINESS ACCOUNT MANAGER','V','720153@telkom.co.id'),('720385','ARIF SUTRISNO','BUSINESS ACCOUNT MANAGER','V','720385@telkom.co.id'),('720491','BAMBANG SUNARYADI, ST','BUSINESS ACCOUNT MANAGER','IV','720491@telkom.co.id'),('730007','FARIDA','BUSINESS ACCOUNT MANAGER-2','VII','730007@telkom.co.id'),('730016','NENI TRIANA','BUSINESS ACCOUNT MANAGER-2','I','730016@telkom.co.id'),('730019','DWI IRIANI','BUSINESS ACCOUNT MANAGER-1','II','730019@telkom.co.id'),('730096','ANTON DANISMAYA','BUSINESS ACCOUNT MANAGER','II','730096@telkom.co.id'),('730297','FELISA HERU PRATOMO EDIATMOKO, ST','BUSINESS ACCOUNT MANAGER-1','IV','730297@telkom.co.id'),('730386','ATIK MASYANI','BUSINESS ACCOUNT MANAGER','V','730386@telkom.co.id'),('730470','ACHMAD BUDIANTORO, ST','BUSINESS ACCOUNT MANAGER','IV','730470@telkom.co.id'),('740294','ARYONO','BUSINESS ACCOUNT MANAGER','I','740294@telkom.co.id'),('770019','NELTJI LEASA','BUSINESS ACCOUNT MANAGER-2','VII','770019@telkom.co.id'),('770027','GEDE ARKA PUNIATMAJA','BUSINESS ACCOUNT MANAGER','V','770027@telkom.co.id'),('790083','MUHAMMAD CHAYRUDIN NOER','BUSINESS ACCOUNT MANAGER-1','VI','790083@telkom.co.id'),('790085','PRINA TIESSA PRINS','BUSINESS ACCOUNT MANAGER-2','II','790085@telkom.co.id'),('800068','FIDYA SAVITRI','BUSINESS ACCOUNT MANAGER-2','I','800068@telkom.co.id'),('800082','JASRIZAL, SE, MM','BUSINESS ACCOUNT MANAGER-2','II','800082@telkom.co.id'),('800088','INDAH ARFIYATI KURNIA','BUSINESS ACCOUNT MANAGER-1','IV','800088@telkom.co.id'),('810098','RIEKE ARIESKA AFRIANA','BUSINESS ACCOUNT MANAGER-1','III','810098@telkom.co.id'),('820063','ANETTA NIMASAYU','BUSINESS ACCOUNT MANAGER-1','IV','820063@telkom.co.id'),('830058','A. NUR QALBY','BUSINESS ACCOUNT MANAGER-2','VII','830058@telkom.co.id'),('830109','DEWI ARSANTI BR KETAREN','BUSINESS ACCOUNT MANAGER-2','I','830109@telkom.co.id'),('830118','RINI SASMITA','BUSINESS ACCOUNT MANAGER-2','III','830118@telkom.co.id'),('840000','Adam','Business Account Manager','I','anggarakids@gmail.com'),('840016','KHAIRIL BAKRI','BUSINESS ACCOUNT MANAGER-2','VI','840016@telkom.co.id'),('840057','MISA JANUAR SENI','BUSINESS ACCOUNT MANAGER-2','VI','840057@telkom.co.id'),('840068','YUSTINE PITASARI','BUSINESS ACCOUNT MANAGER-2','IV','840068@telkom.co.id'),('840080','DWISARI WIGUNA','BUSINESS ACCOUNT MANAGER-2','II','840080@telkom.co.id'),('840088','LEDY CAROLINE','BUSINESS ACCOUNT MANAGER-2','I','840088@telkom.co.id'),('840107','NOOR FAJAR RIDWAN','BUSINESS ACCOUNT MANAGER-2','V','840107@telkom.co.id'),('850009','SRI DWI NINGSIH','BUSINESS ACCOUNT MANAGER-2','I','850009@telkom.co.id'),('850013','EVA MARINI','BUSINESS ACCOUNT MANAGER-2','I','850013@telkom.co.id'),('850014','T. SURYA HASRI','BUSINESS ACCOUNT MANAGER-2','I','850014@telkom.co.id'),('850024','ANDI SYAPUTRA','BUSINESS ACCOUNT MANAGER-2','I','850024@telkom.co.id'),('850057','YESRU MARDANIATI','BUSINESS ACCOUNT MANAGER-2','VI','850057@telkom.co.id'),('850069','DEWI RATNASARI','BUSINESS ACCOUNT MANAGER-2','II','850069@telkom.co.id'),('860048','IRMA HAYATI','BUSINESS ACCOUNT MANAGER-2','II','860048@telkom.co.id'),('860049','PUTRI APRILLIANI','BUSINESS ACCOUNT MANAGER-2','VI','860049@telkom.co.id'),('870050','ANGGI AGUSTINA','BUSINESS ACCOUNT MANAGER-2','II','870050@telkom.co.id'),('870051','ENY SHOLIKAH PUJI HASTUTI','BUSINESS ACCOUNT MANAGER-2','II','870051@telkom.co.id'),('880030','AFIF ROMADHON','BUSINESS ACCOUNT MANAGER-2','VI','880030@telkom.co.id'),('880040','ANGGI ANGGRAENI','BUSINESS ACCOUNT MANAGER-2','III','880040@telkom.co.id'),('nik','namabam','jabatan','loker','email');

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `e_email_id` int(11) NOT NULL AUTO_INCREMENT,
  `e_email` varchar(255) NOT NULL,
  PRIMARY KEY (`e_email_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` VALUES (1,'anggarakids@gmail.com');

--
-- Table structure for table `listregional`
--

CREATE TABLE `listregional` (
  `id_regional` char(6) NOT NULL,
  `regional` varchar(10) NOT NULL,
  PRIMARY KEY (`id_regional`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `listregional`
--

INSERT INTO `listregional` VALUES ('DM','BSR1'),('IMC','BSR3'),('INCUBT','BSR2');

--
-- Table structure for table `pic_sosa`
--

CREATE TABLE `pic_sosa` (
  `ps_nik` varchar(6) NOT NULL,
  `ps_name` varchar(255) NOT NULL,
  `ps_job_title` varchar(255) NOT NULL,
  `ps_work_location` char(4) NOT NULL,
  `ps_email` varchar(255) NOT NULL,
  PRIMARY KEY (`ps_nik`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pic_sosa`
--

INSERT INTO `pic_sosa` VALUES ('000001','Anisa Chibi','SA1','I','anisa.chibi@telkom.co.id'),('000002','Maya Septa','SA2','II','maya.septa@telkom.co.id');

--
-- Table structure for table `picadmin`
--

CREATE TABLE `picadmin` (
  `nik` varchar(20) NOT NULL,
  `namaadmin` varchar(50) NOT NULL,
  `jabatan` varchar(100) NOT NULL,
  `loker` char(6) NOT NULL,
  `email` varchar(30) NOT NULL,
  PRIMARY KEY (`nik`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `picadmin`
--

INSERT INTO `picadmin` VALUES ('902012','Angelina SR','AE','DM','angel@futuremediatrix.com');

--
-- Table structure for table `picteknis`
--

CREATE TABLE `picteknis` (
  `nik` varchar(20) NOT NULL,
  `namateknis` varchar(50) NOT NULL,
  `jabatan` varchar(100) NOT NULL,
  `loker` char(6) NOT NULL,
  `email` varchar(30) NOT NULL,
  PRIMARY KEY (`nik`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `picteknis`
--

INSERT INTO `picteknis` VALUES ('802012','Thomas Joseph','Director DM','IV','830041@telkom.co.id'),('822012','Irfan Ade P','Director Marketing Comn','IMC','irfan@futuremediatrix.com'),('912012','Denma R Willyando','Multimedia Comn','IMC','denma@futuremediatrix.com');

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id_project` int(11) NOT NULL AUTO_INCREMENT,
  `customer` varchar(100) NOT NULL,
  `bam` varchar(100) NOT NULL,
  `segmen` varchar(100) NOT NULL,
  `id_regional` char(6) NOT NULL,
  `nilai` varchar(100) NOT NULL,
  `solution` varchar(100) NOT NULL,
  `layanan` varchar(100) NOT NULL,
  `keterangan` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pekerjaan` varchar(100) NOT NULL,
  `pendukung` varchar(100) NOT NULL,
  `pic_sosa` varchar(255) NOT NULL,
  `kompetitor` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `nomor_ao` varchar(255) DEFAULT NULL,
  `dokumen` varchar(255) DEFAULT NULL,
  `tglmulai` date NOT NULL,
  `tglselesai` date NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'p',
  `inputby` varchar(20) NOT NULL,
  `tglinput` datetime NOT NULL,
  `lasteditby` varchar(20) NOT NULL,
  `tgllastedit` datetime NOT NULL,
  PRIMARY KEY (`id_project`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `project`
--

INSERT INTO `project` VALUES (1,'Kakaban','Denma R Willyando','Website','DM','30000000','','Website & CMS','Diamond Packet','Website Tour Travel','Ferli Juli H','',NULL,'30000000','','','2012-12-01','2012-08-31','p','912012','2013-01-28 00:00:00','650791','0000-00-00 00:00:00'),(2,'FMG','Thomas Joseph','Website','DM','','Denma R Willyando','Website & CMS','Internal','Web Internal Compro','','',NULL,NULL,NULL,NULL,'2013-01-23','2013-01-31','p','','2013-01-28 00:00:00','','2013-01-28 00:00:00');

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `r_resource_id` int(11) NOT NULL AUTO_INCREMENT,
  `r_name` varchar(255) NOT NULL,
  PRIMARY KEY (`r_resource_id`),
  UNIQUE KEY `r_name` (`r_name`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` VALUES (1,'home'),(2,'input-project'),(3,'input-tender'),(4,'progress-project'),(5,'progress-tender'),(6,'progress-project-edit'),(7,'progress-tender-edit'),(8,'progress-project-status'),(9,'progress-tender-status'),(10,'progress-project-delete'),(11,'progress-tender-delete'),(12,'progress-project-view'),(13,'progress-tender-view'),(14,'history-project-delete'),(15,'history-tender-delete'),(16,'history-project-view'),(17,'history-tender-view'),(18,'report-project-delete'),(19,'report-tender-delete'),(20,'report-project-view'),(21,'report-tender-view');

--
-- Table structure for table `segmen`
--

CREATE TABLE `segmen` (
  `id_segmen` int(11) NOT NULL AUTO_INCREMENT,
  `segmen` varchar(100) NOT NULL,
  PRIMARY KEY (`id_segmen`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `segmen`
--

INSERT INTO `segmen` VALUES (1,'Gov'),(2,'Education'),(3,'Perdagangan Umum'),(4,'Automotive'),(5,'Contruction'),(6,'Mining');

--
-- Table structure for table `tender`
--

CREATE TABLE `tender` (
  `id_tender` int(11) NOT NULL AUTO_INCREMENT,
  `customer` varchar(100) NOT NULL,
  `bam` varchar(100) NOT NULL,
  `segmen` varchar(100) NOT NULL,
  `pagu` varchar(100) NOT NULL,
  `hps` varchar(100) NOT NULL,
  `jenis` varchar(100) NOT NULL,
  `tglumum` date NOT NULL,
  `tglaan` date NOT NULL,
  `tglsubmit` date NOT NULL,
  `tgl_klarifikasi` date DEFAULT NULL,
  `tgl_kontrak` date DEFAULT NULL,
  `id_regional` char(6) NOT NULL,
  `keterangan` varchar(100) NOT NULL,
  `picadmin` varchar(100) NOT NULL,
  `picteknis` varchar(100) NOT NULL,
  `pic_sosa` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `layanan` varchar(100) NOT NULL,
  `pekerjaan` varchar(100) NOT NULL,
  `pendukung` varchar(100) NOT NULL,
  `status` char(1) NOT NULL DEFAULT 'p',
  `dokumen_rks` varchar(255) DEFAULT NULL,
  `dokumen_aan` varchar(255) DEFAULT NULL,
  `dokumen_tender` varchar(255) DEFAULT NULL,
  `inputby` varchar(20) NOT NULL,
  `tglinput` datetime NOT NULL,
  `lasteditby` varchar(20) NOT NULL,
  `tgllastedit` datetime NOT NULL,
  `kompetitor` varchar(255) DEFAULT NULL,
  `penawaran` varchar(50) NOT NULL,
  `harga` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_tender`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tender`
--

INSERT INTO `tender` VALUES (33,'Teh Susu','Irfan Ade P','Product','','Rp. 600.000.000.000','','2013-01-29','2013-02-01','2013-01-29','2013-01-30','2013-01-29','IMC','Marcomn Agency','','','','','Marcomn Agency product teh susu','','m','','','','912012','2013-01-28 03:04:42','912012','2013-01-28 03:04:42','NA','','Rp. 600.000.000.000'),(34,'Sampoerna Telkom Indonesia','Thomas','Mining','7','10','Portal Website','2013-02-15','2013-02-01','2013-02-01','2013-02-01','2013-02-15','DM','','Angelina SR','Denma R Willyando','Angelina','Website Digital Marketing','Website','Cs','p','',NULL,NULL,'912012','2013-02-01 16:26:14','912012','2013-02-01 16:26:14','Semut Api','483000000','750000000');


