create user

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `BEGDA` INT(10) UNSIGNED NOT NULL DEFAULT '99991231',
  `ENDDA` INT(10) UNSIGNED NOT NULL DEFAULT '99991231',
  `COUNTER` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `USER_NAME` VARCHAR(50) NOT NULL,
  `PASSWORD` VARCHAR(88) NOT NULL,
  `IS_ADMIN` bit(1) NOT NULL DEFAULT b'1',
  `MODIFIER_COUNTER` INT(10) UNSIGNED DEFAULT NULL,
  `DEPARTMENT_COUNTER` INT(10) UNSIGNED DEFAULT NULL,
  `ACCESSIBLE_MODULES` VARCHAR(1024) NOT NULL DEFAULT 'ALL',
  PRIMARY KEY (`COUNTER`),
  KEY `USER_TO_DIVISION` (`DEPARTMENT_COUNTER`),
  CONSTRAINT `USER_TO_DIVISION` FOREIGN KEY (`DEPARTMENT_COUNTER`) REFERENCES `departmentmaster` (`COUNTER`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (20111201,20111220,1,'fahrul','yydQGUwnK9s5FUSdyjpuiDvzHv0=','\0',0,2,'Absensi.Module.DataKaryawan.Nodes.EmployeeViewableNode=True;Absensi.Module.DataMaster.Nodes.DataMasterNode=True;Absensi.Module.SystemConfiguration.Nodes.SystemConfigurationNode=False;Absensi.Module.Transaction.Nodes.TransactionViewableNode=False;Absensi.Module.DataKaryawan.Nodes.WorkScheduleViewableNode=True;'),(20111203,20111203,2,'roger','s2oocadJWxQa7mI2XLJ3X60+0+QQrazub71PSVGRVFnXxIePhXzYcQVxX4r0Q7ib40PhUvOma7YyhDWRvSqYxg==','
',0,NULL,'ALL'),(20111203,20111203,3,'roger','xcbOcYkVk+z7wnKAwFPMXlZfoxJCarpNx05iz7X7l/pV0k07+tJvz2zcRawIS3MV/N8f+axfXKdDg65hSR66LQ==','
',0,NULL,'ALL'),(20111203,20111203,4,'robert','yLOVbInHXvdH6xyjVdldP9E3tSEcP6uoWBZVprjlWZj5IKzeS6quOk6BVvg2MfzwHGUK2zJC83DpAahpt/9hoA==','
',0,NULL,'ALL'),(20111203,20111220,5,'roger','aovFaVWp0tmg8IkMAM0V/mscpDc=','
',0,NULL,'ALL'),(20111210,20111220,6,'robert','EukpPsazDH+ooJJq9CgH6SnBaE8=','\0',0,2,'Absensi.Module.DataKaryawan.Nodes.EmployeeViewableNode=False;Absensi.Module.DataMaster.Nodes.DataMasterNode=False;Absensi.Module.SystemConfiguration.Nodes.SystemConfigurationNode=True;Absensi.Module.Transaction.Nodes.TransactionViewableNode=True;Absensi.Module.DataKaryawan.Nodes.WorkScheduleViewableNode=False;'),(20111220,99991231,7,'roger','phoa3XHa3HQDeuXkTuMHE9uadFE=','\0',0,NULL,'Absensi.Module.DataKaryawan.Nodes.EmployeeViewableNode=False;Absensi.Module.DataMaster.Nodes.DataMasterNode=False;Absensi.Module.SystemConfiguration.Nodes.SystemConfigurationNode=False;Absensi.Module.Transaction.Nodes.TransactionViewableNode=True;Absensi.Module.DataKaryawan.Nodes.WorkScheduleViewableNode=True;');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;