source: pro-violet-viettel/docs/db/violet-viettel-2.3.2015.sql @ 776

--
-- `tbladminrole` - admin roles relations
--

DROP TABLE IF EXISTS `tbladminrole`;
CREATE TABLE IF NOT EXISTS `tbladminrole` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbladminrole`
--

INSERT INTO `tbladminrole` (`role_id`, `admin_id`) VALUES
(1, 1),
(2, 1);

-- --------------------------------------------------------

--
--  `tblrole` - roles table
--

DROP TABLE IF EXISTS `tblrole`;
CREATE TABLE IF NOT EXISTS `tblrole` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tblrole`
--

INSERT INTO `tblrole` (`role_id`, `role_name`) VALUES
(1, 'editUserInfo'),
(2, 'editAdminInfo');

-- --------------------------------------------------------