/*
SQLyog - Free MySQL GUI v5.12
Host - 5.0.11-beta-nt : Database - ctslocaldbfinal
*********************************************************************
Server version : 5.0.11-beta-nt
*/


SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `ctslocaldbfinal`;

USE `ctslocaldbfinal`;

/*Table structure for table `t_cts_role_master` */

DROP TABLE IF EXISTS `t_cts_role_master`;

CREATE TABLE `t_cts_role_master` (
  `ROLE_ID` int(11) NOT NULL auto_increment,
  `ROLE_NAME` varchar(20) NOT NULL default '',
  `DESCRIPTION` varchar(100) NOT NULL default '',
  `STATUS` char(1) NOT NULL default 'A',
  PRIMARY KEY  (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `t_cts_role_master` */

insert into `t_cts_role_master` (`ROLE_ID`,`ROLE_NAME`,`DESCRIPTION`,`STATUS`) values (0,'Super Admin','Super Admin','A'),(1,'Service Branch Admin','Service Branch Admin','A'),(2,'MI','MakerIn','A'),(3,'MIMO','MakerInMakerOut','A'),(4,'MIMOCI','MakerInMakerOutCheckerIn','A'),(5,'MIMOCICO','MakerInMakerOutCheckerInCheckerOut','A'),(6,'MO','MakerOut','A'),(7,'MOCI','MakerOutChecker In','A'),(8,'MOCICO','MO+CI+CO','A'),(9,'CI','CI','A'),(10,'CICO','CI+CO','A'),(11,'CO','CheckerOut','A'),(12,'MIMOCO','MI+MO+CO','A'),(13,'MICI','MI+CI','A'),(14,'MICICO','MI+CI+CO','A'),(15,'MICO','MI+CO','A'),(16,'MOCO','MO+CO','A'),(17,'Super Admin','Super Admin','A');