-- -- `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'); -- --------------------------------------------------------