usermoduleaccess

-- Adminer 4.2.5 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

USE `dps_main_db`;

DROP TABLE IF EXISTS `app_usermoduleaccess`;
CREATE TABLE `app_usermoduleaccess` (
  `useraccess_id` int(11) NOT NULL AUTO_INCREMENT,
  `useracces_name` varchar(255) NOT NULL,
  `useraccess_status` int(10) NOT NULL,
  `useraccess_order` int(10) NOT NULL,
  PRIMARY KEY (`useraccess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `app_usermoduleaccess` (`useraccess_id`, `useracces_name`, `useraccess_status`, `useraccess_order`) VALUES
(1, 'REG',  1,  1),
(2, 'CASH', 1,  2),
(3, 'GRAD', 1,  3),
(4, 'LIB',  1,  4),
(5, 'HR',   1,  5),
(6, 'PUR',  1,  6),
(7, 'ACC',  1,  7),
(8, 'PAY',  1,  8);

-- 2016-09-22 06:34:15


-- Adminer 4.2.5 MySQL dump

DROP TABLE IF EXISTS `app_usermoduleaccess_header`;
CREATE TABLE `app_usermoduleaccess_header` (
  `useraccess_header_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) NOT NULL,
  `useraccess_form` text NOT NULL,
  PRIMARY KEY (`useraccess_header_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2016-09-23 02:09:40