# --------------------------------------------------------
# Host:                         103.246.90.247
# Server version:               5.0.77-log
# Server OS:                    redhat-linux-gnu
# HeidiSQL version:             6.0.0.3603
# Date/time:                    2013-07-18 08:58:31
# --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!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' */;

# Dumping structure for table idt_m3tech.user_detail
CREATE TABLE IF NOT EXISTS `user_detail` (
  `user_id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(255) default NULL,
  `user_fullname` varchar(255) default NULL,
  `user_email` varchar(255) default NULL,
  `user_password` varchar(255) default NULL,
  `user_contactno` varchar(255) default NULL,
  `client_id` int(11) default NULL,
  `menu permission` varchar(255) default NULL,
  `user_group` varchar(255) default NULL,
  `user_status` varchar(255) default NULL,
  `user_created` int(11) default NULL,
  `date_created` datetime default NULL,
  `user_modified` int(11) default NULL,
  `date_modified` datetime default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

# Dumping data for table idt_m3tech.user_detail: 11 rows
/*!40000 ALTER TABLE `user_detail` DISABLE KEYS */;
INSERT INTO `user_detail` (`user_id`, `username`, `user_fullname`, `user_email`, `user_password`, `user_contactno`, `client_id`, `menu permission`, `user_group`, `user_status`, `user_created`, `date_created`, `user_modified`, `date_modified`) VALUES
	(1, 'admin', 'Ahmad Saifuddin', 'saifuddin@m3tech.com.my', '892f880b7a1635487b69e35a92067c11', '+60192142606', 2, NULL, '1', '1', NULL, NULL, 0, '2013-07-03 15:14:37'),
	(21, 'ndrea66', 'saiful', 'saifulhafiz@m3tech.com.my', '81dc9bdb52d04dc20036dbd8313ed055', '+60137455502', 11, NULL, '1', '1', 1, '2013-07-05 16:24:15', NULL, NULL),
	(9, 'saiful', 'saifulhafiz', 'saiful.kl@gmail.com', '94f192dee566b018e0acf31e1f99a2d9', '+60137455502', 2, NULL, '2', '1', 1, '2013-05-27 16:12:09', 0, '2013-05-28 09:32:46'),
	(17, 's', 's', 'vistro@gmail.com', '46f94c8de14fb36680850768ff1b7f2a', '+60123256325', 3, NULL, '2', '1', 1, '2013-06-27 12:08:37', NULL, NULL),
	(14, 'asma', 'asma', 'asma@m3tech.com.my', '892f880b7a1635487b69e35a92067c11', '+60379551101', 6, NULL, '1', '1', 1, '2013-06-06 11:33:27', NULL, NULL),
	(15, 'ndrea', 'andrea', 'm3tech_my_298@yahoo.com', 'e10adc3949ba59abbe56e057f20f883e', '+60137455502', 6, NULL, '1', '1', 1, '2013-06-10 10:56:53', NULL, NULL),
	(16, 'user1', 'user1', NULL, '46f94c8de14fb36680850768ff1b7f2a', NULL, 7, NULL, '2', '1', 1, '2013-06-27 11:52:30', NULL, '2013-06-27 11:52:33'),
	(18, 'user2', 'user2', NULL, '46f94c8de14fb36680850768ff1b7f2a', NULL, 8, NULL, '2', '1', 1, '2013-06-27 11:53:03', NULL, NULL),
	(19, 'user3', 'user3', NULL, '46f94c8de14fb36680850768ff1b7f2a', NULL, 9, NULL, '2', '1', 1, '2013-06-27 11:53:33', NULL, NULL),
	(20, 'user4', 'user4', NULL, '46f94c8de14fb36680850768ff1b7f2a', NULL, 10, NULL, '2', '1', 1, NULL, NULL, NULL),
	(22, 'taufiq', 'Taufiq', 'taufiqism@gmail.com', 'bf5f7ee58f32b0cc4673376d4579a132', '+60192000000', 11, NULL, '1', '1', 1, '2013-07-05 18:14:58', NULL, NULL);
/*!40000 ALTER TABLE `user_detail` ENABLE KEYS */;


# Dumping structure for table idt_m3tech.user_group
CREATE TABLE IF NOT EXISTS `user_group` (
  `iduser_group` int(11) unsigned NOT NULL auto_increment,
  `group_name` varchar(255) default NULL,
  `date_inserted` datetime default NULL,
  `user_inserted` varchar(255) default NULL,
  `date_modified` datetime default NULL,
  `user_modified` varchar(255) default NULL,
  PRIMARY KEY  (`iduser_group`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

# Dumping data for table idt_m3tech.user_group: 2 rows
/*!40000 ALTER TABLE `user_group` DISABLE KEYS */;
INSERT INTO `user_group` (`iduser_group`, `group_name`, `date_inserted`, `user_inserted`, `date_modified`, `user_modified`) VALUES
	(1, 'Super_Admin', NULL, NULL, NULL, NULL),
	(2, 'Content', NULL, NULL, NULL, NULL);
/*!40000 ALTER TABLE `user_group` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;