sql

CREATE TABLE IF NOT EXISTS `jos_hrd_userrole` (
  `urole_id` int(11) NOT NULL AUTO_INCREMENT,
  `urole_user` int(11) NOT NULL,
  `urole_role` int(11) NOT NULL,
  PRIMARY KEY (`urole_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `jos_hrd_userrole`
--

INSERT INTO `jos_hrd_userrole` (`urole_id`, `urole_user`, `urole_role`) VALUES
(1, 62, 1),
(2, 62, 2);

CREATE TABLE IF NOT EXISTS `jos_hrd_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(20) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `jos_hrd_role`
--

INSERT INTO `jos_hrd_role` (`role_id`, `role_name`) VALUES
(1, 'worker'),
(2, 'hrd'),
(3, 'admin');