-- http://www.phpmyadmin.net
--




--
-- Database: `lmsAdmin`
--

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

--
-- Table structure for table `application_details`
--

CREATE TABLE IF NOT EXISTS `application_details` (
  `app_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_type` varchar(45) DEFAULT NULL,
  `customer_name` varchar(45) DEFAULT NULL,
  `cutomer_address` varchar(45) DEFAULT NULL,
  `cutomer_email` varchar(45) DEFAULT NULL,
  `cutomer_phone_1` varchar(45) DEFAULT NULL,
  `cutomer_phone_2` varchar(45) DEFAULT NULL,
  `customer_city` varchar(45) DEFAULT NULL,
  `customer_state` varchar(45) DEFAULT NULL,
  `customer_country` varchar(45) DEFAULT NULL,
  `customer_logo_img` varchar(200) DEFAULT NULL,
  `customer_header_logo` varchar(200) DEFAULT NULL,
  `customer_site_address` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `application_details`
--

INSERT INTO `application_details` (`app_id`, `app_type`, `customer_name`, `cutomer_address`, `cutomer_email`, `cutomer_phone_1`, `cutomer_phone_2`, `customer_city`, `customer_state`, `customer_country`, `customer_logo_img`, `customer_header_logo`, `customer_site_address`, `created_by`, `created_date`, `updated_by`, `updated_date`, `status`) VALUES
(8, 'service_customer', 'CustomerA', 'CustomerA', 'CustomerA@gmail.com', '255425', 'CustomerA', 'CustomerA', 'CustomerA', 'CustomerA', 'Uploads/Customer/index_2770111537.png', '', '', 'naga', '2015-09-21 16:44:35', '2015-09-21 16:44:35', '2015-10-09 15:59:36', '1'),
(9, 'project_customer', 'CustomerB', 'CustomerA', 'CustomerA@gmail.com', 'CustomerA', 'CustomerA', 'CustomerA', 'CustomerA', 'CustomerA', 'Uploads/Customer/model_a_2423550300_6988029396.svg', '', 'CustomerA', 'naga', '2015-09-21 16:45:01', 'naga', '2015-10-09 07:26:49', '1'),
(10, 'service_customer', 'xvxc', 'vcxvxcv', 'xcvxcv@gmai.cmo', 'xcvxcvx', 'xcvxcv', 'xcvxc', 'vxcvxc', 'xcvxc', '', '', '', 'naga', '2015-09-21 20:21:49', '2015-09-21 20:21:49', '2015-09-21 14:51:49', '1'),
(11, 'service_customer', 'Test', 'Test', 'Test@gmail.com', 'Test', 'Test', 'Test', 'Test', 'Test', '', '', 'Test', 'naga', '2015-09-22 11:31:22', '2015-09-22 11:31:22', '2015-09-22 06:01:22', '1'),
(12, 'project_customer', 'dfds', 'fsdf', 'dfdsf@gmail.com', 'dfsdf', 'sdfsd', 'sdfds', 'sdfsd', 'sdfsd', '', '', 'dfsdf', 'native', '2015-09-22 13:27:11', '2015-09-22 13:27:11', '2015-09-22 07:57:11', '1'),
(13, 'service_customer', 'dfsd', 'fsdfsdf', 'dsfsdfdf@gma.com', 'dfd', 'dfd', '', '', '', '', '', '', 'native', '2015-09-22 15:26:47', '2015-09-22 15:26:47', '2015-09-22 09:56:47', '1'),
(14, 'service_customer', '', '', '', '', '', '', '', '', '', '', '', 'native', '2015-09-22 15:27:18', '2015-09-22 15:27:18', '2015-09-22 09:57:18', '1');

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

--
-- Table structure for table `app_config`
--

CREATE TABLE IF NOT EXISTS `app_config` (
  `config_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) DEFAULT NULL,
  `designer_height` varchar(45) DEFAULT NULL,
  `designer_width` varchar(45) DEFAULT NULL,
  `dsgnr_control_height` varchar(45) DEFAULT NULL,
  `dsgnr_control_width` varchar(45) DEFAULT NULL,
  `design_mode` varchar(45) DEFAULT NULL,
  `design_output_mode` varchar(45) DEFAULT NULL,
  `prd_category_level` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `app_resource`
--

CREATE TABLE IF NOT EXISTS `app_resource` (
  `resource_id` int(11) NOT NULL AUTO_INCREMENT,
  `resource_name` varchar(45) DEFAULT NULL,
  `resource_action` varchar(45) DEFAULT NULL,
  `resource_url` varchar(45) DEFAULT NULL,
  `common_resource` varchar(3) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`resource_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;

--
-- Dumping data for table `app_resource`
--

INSERT INTO `app_resource` (`resource_id`, `resource_name`, `resource_action`, `resource_url`, `common_resource`, `created_by`, `created_date`, `updated_by`, `updated_date`, `status`) VALUES
(1, 'dashboard', 'dashboard', 'dashboard.php', NULL, 'naga', '2015-09-21 14:15:42', 'naga', '2015-09-22 06:06:05', '1'),
(2, 'view_app_add', 'view_app_add', 'view_app_add.php', NULL, 'naga', '2015-09-21 14:16:50', 'naga', '2015-09-22 06:06:05', '1'),
(3, 'list_application', 'list_application', 'list_application.php', NULL, 'naga', '2015-09-21 15:34:38', 'naga', '2015-09-22 06:06:05', '1'),
(4, 'view_add_role', 'view_add_role', 'view_add_role.php', NULL, NULL, NULL, NULL, '2015-09-22 06:06:05', '1'),
(5, 'list_role', 'list_role', 'list_role.php', NULL, NULL, NULL, NULL, '2015-09-22 06:06:05', '1'),
(6, 'view_user_add', 'view_user_add', 'view_user_add.php', NULL, NULL, NULL, NULL, '2015-09-22 06:06:10', '1'),
(7, 'list_user', 'list_user', 'list_user.php', NULL, NULL, NULL, NULL, '2015-09-22 06:06:39', '1'),
(8, 'view_add_resource', 'view_add_resource', 'view_add_resource.php', NULL, NULL, NULL, NULL, '2015-09-22 06:07:28', '1'),
(9, 'list_resource', 'list_resource', 'list_resource.php', NULL, NULL, NULL, NULL, '2015-09-22 06:07:28', '1'),
(10, 'role_user', 'role_user', 'view_role_user.php', NULL, NULL, NULL, NULL, '2015-09-22 06:07:56', '1'),
(11, 'role_resource', 'role_resource', 'role_resource.php', NULL, NULL, NULL, NULL, '2015-09-22 06:08:13', '1'),
(12, 'logout', 'logout', 'logout.php', '1', 'native', '2015-09-22 14:01:55', 'native', '2015-09-22 09:31:49', '1'),
(13, 'Test_Common', 'Test_Common', 'Test_Common', '0', 'native', '2015-09-22 14:57:01', 'native', '2015-09-22 09:27:55', '1'),
(14, 'Test_Common_1', 'Test_Common_1', 'Test_Common_1', '1', 'native', '2015-09-22 14:57:21', 'native', '2015-09-22 09:27:21', '1'),
(15, 'view_cliparts_category', 'view_cliparts_category', 'view_cliparts_category.php', '1', 'native', '2015-09-22 15:53:13', 'native', '2015-09-22 10:23:13', '1'),
(16, 'view_cliparts_sub_category', 'view_cliparts_sub_category', 'view_sub_CA.php', '1', 'native', '2015-09-22 19:30:42', 'native', '2015-09-23 06:04:07', '1'),
(17, 'Add Clip Arts', 'view_add_cliparts', 'view_add_cliparts.php', '1', 'native', '2015-09-23 15:15:10', 'native', '2015-10-09 07:23:59', '1'),
(18, 'Product Add', 'product_add', 'product_add.php', '1', 'native', '2015-10-09 13:12:57', 'native', '2015-10-09 07:42:57', '1'),
(19, 'Product Add', 'product_add', 'product_add.php', '1', 'native', '2015-10-09 13:12:57', 'native', '2015-10-09 07:42:57', '1'),
(20, 'Product Add', 'product_add', 'product_add.php', '1', 'native', '2015-10-09 13:12:57', 'native', '2015-10-09 07:42:57', '1'),
(21, 'List Product Category', 'product_list', 'product_list.php', '1', 'native', '2015-10-09 13:14:08', 'native', '2015-10-09 07:44:08', '1'),
(22, 'List Product Category', 'product_list', 'product_list.php', '1', 'native', '2015-10-09 13:14:08', 'native', '2015-10-09 07:44:08', '1'),
(23, 'List Product Category', 'product_list', 'product_list.php', '1', 'native', '2015-10-09 13:14:08', 'native', '2015-10-09 07:44:08', '1'),
(24, 'Add practice', 'add_practice', 'add_practice.php', '1', 'native', '2015-10-12 16:40:52', 'native', '2015-10-14 12:13:42', '1'),
(27, 'list_department', 'list_department', 'list_department.php', '0', 'native', '2015-10-13 10:20:22', 'native', '2015-10-13 04:50:22', '1'),
(28, 'list_department', 'list_department', 'list_department.php', '0', 'native', '2015-10-13 10:20:22', 'native', '2015-10-13 04:50:22', '1'),
(29, 'list_department', 'list_department', 'list_department.php', '0', 'native', '2015-10-13 10:20:22', 'native', '2015-10-13 04:50:22', '1'),
(30, 'staff_registration', 'staff_registration', 'staff_registration.php', '0', 'native', '2015-10-13 13:27:46', 'native', '2015-10-13 08:08:37', '3'),
(31, 'staff_registration', 'staff_registration', 'staff_registration.php', '0', 'native', '2015-10-13 13:27:46', 'native', '2015-10-13 08:08:45', '3'),
(32, 'staff_registration', 'staff_registration', 'staff_registration.php', '0', 'native', '2015-10-13 13:27:46', 'native', '2015-10-13 08:08:51', '3'),
(33, 'add_staff', 'add_staff', 'add_staff.php', '1', 'native', '2015-10-13 13:39:56', 'native', '2015-10-13 10:04:11', '1'),
(34, 'add_staff', 'add_staff', 'add_staff.php', '1', 'native', '2015-10-13 13:39:56', 'native', '2015-10-13 10:04:29', '1'),
(35, 'add_staff', 'add_staff', 'add_staff.php', '1', 'native', '2015-10-13 13:39:56', 'native', '2015-10-13 10:04:48', '1'),
(36, 'lms_sb_add_subpractice_area', 'lms_sb_add_subpractice_area', 'lms_sb_add_subpractice_area.php', '1', 'native', '2015-10-14 16:39:27', 'native', '2015-10-14 11:53:31', '1'),
(37, 'lms_sb_add_client', 'lms_sb_add_client', 'lms_sb_add_client.php', '1', 'native', '0000-00-00 00:00:00', NULL, '2015-10-15 10:52:28', '1'),
(38, 'lms_sb_add_office', 'lms_sb_add_office', 'lms_sb_add_office.php', '1', 'native', NULL, NULL, '2015-10-15 10:52:28', '1'),
(39, 'lms_sb_add_activity', 'lms_sb_add_activity', 'lms_sb_add_activity.php', '1', 'native', NULL, NULL, '2015-10-15 10:52:28', '1'),
(40, 'lms_sb_add_subactivity', 'lms_sb_add_subactivity', 'lms_sb_add_subactivity.php', '1', 'native', NULL, NULL, '2015-10-15 10:52:28', '1'),
(41, 'lms_sb_add_task', 'lms_sb_add_task', 'lms_sb_add_task.php', '1', NULL, NULL, NULL, '2015-10-15 10:52:28', '1'),
(42, 'lms_sb_add_client', 'lms_sb_add_client', 'lms_sb_add_client.php', '1', 'native', '2015-10-15 13:29:53', 'native', '2015-10-15 07:59:53', '1'),
(43, 'lms_sb_add_client', 'lms_sb_add_client', 'lms_sb_add_client.php', '1', 'native', '2015-10-15 13:29:53', 'native', '2015-10-15 07:59:53', '1'),
(44, 'lms_sb_add_client', 'lms_sb_add_client', 'lms_sb_add_client.php', '1', 'native', '2015-10-15 13:29:53', 'native', '2015-10-15 07:59:53', '1'),
(45, 'lms_sb_add_office', 'lms_sb_add_office', 'lms_sb_add_office.php', '1', 'native', '2015-10-15 13:35:34', 'native', '2015-10-15 08:05:34', '1'),
(46, 'lms_sb_add_office', 'lms_sb_add_office', 'lms_sb_add_office.php', '1', 'native', '2015-10-15 13:35:34', 'native', '2015-10-15 08:05:34', '1'),
(47, 'lms_sb_add_office', 'lms_sb_add_office', 'lms_sb_add_office.php', '1', 'native', '2015-10-15 13:35:34', 'native', '2015-10-15 08:05:34', '1'),
(48, 'lms_sb_add_activity', 'lms_sb_add_activity', 'lms_sb_add_activity.php', '1', 'native', '2015-10-15 13:46:22', 'native', '2015-10-15 08:16:22', '1'),
(49, 'lms_sb_add_activity', 'lms_sb_add_activity', 'lms_sb_add_activity.php', '1', 'native', '2015-10-15 13:46:22', 'native', '2015-10-15 08:16:22', '1'),
(50, 'lms_sb_add_activity', 'lms_sb_add_activity', 'lms_sb_add_activity.php', '1', 'native', '2015-10-15 13:46:23', 'native', '2015-10-15 08:16:23', '1'),
(51, 'lms_sb_add_subactivity', 'lms_sb_add_subactivity', 'lms_sb_add_subactivity.php', '1', 'native', '2015-10-15 14:09:19', 'native', '2015-10-15 08:51:14', '1'),
(52, 'lms_sb_add_subactivity', 'lms_sb_add_subactivity', 'lms_sb_add_subactivity.php', '0', 'native', '2015-10-15 14:09:19', 'native', '2015-10-15 08:39:19', '1'),
(53, 'lms_sb_add_subactivity', 'lms_sb_add_subactivity', 'lms_sb_add_subactivity.php', '0', 'native', '2015-10-15 14:09:19', 'native', '2015-10-15 08:39:19', '1'),
(54, 'lms_sb_add_task', 'lms_sb_add_task', 'lms_sb_add_task.php', '1', 'native', '2015-10-15 15:14:35', 'native', '2015-10-15 09:44:35', '1'),
(55, 'lms_sb_add_task', 'lms_sb_add_task', 'lms_sb_add_task.php', '1', 'native', '2015-10-15 15:14:35', 'native', '2015-10-15 09:44:35', '1'),
(56, 'lms_sb_add_task', 'lms_sb_add_task', 'lms_sb_add_task.php', '1', 'native', '2015-10-15 15:14:35', 'native', '2015-10-15 09:44:35', '1'),
(57, 'ssss', 'sss', 'sss', '1', 'native', '2015-10-15 16:23:23', 'native', '2015-10-15 10:53:23', '1'),
(58, 'ssss', 'sss', 'sss', '1', 'native', '2015-10-15 16:23:24', 'native', '2015-10-15 10:53:24', '1'),
(59, 'ssss', 'sss', 'sss', '1', 'native', '2015-10-15 16:23:24', 'native', '2015-10-15 10:53:24', '1'),
(60, 'qqqq', 'qqq', 'qqq', '1', 'native', '2015-10-15 16:23:59', 'native', '2015-10-15 10:53:59', '1'),
(61, 'qqqq', 'qqq', 'qqq', '1', 'native', '2015-10-15 16:23:59', 'native', '2015-10-15 10:53:59', '1'),
(62, 'qqqq', 'qqq', 'qqq', '1', 'native', '2015-10-15 16:23:59', 'native', '2015-10-15 10:53:59', '1'),
(63, 'ssss', 'ssss', 'ss', '1', 'native', '2015-10-15 16:25:11', 'native', '2015-10-15 10:55:11', '1'),
(64, 'ssss', 'ssss', 'ss', '1', 'native', '2015-10-15 16:25:11', 'native', '2015-10-15 10:55:11', '1'),
(65, 'ssss', 'ssss', 'ss', '1', 'native', '2015-10-15 16:25:11', 'native', '2015-10-15 10:55:11', '1'),
(66, 'naga', 'naga', 'naga', '1', 'native', '2015-10-15 16:29:06', 'native', '2015-10-15 10:59:06', '1'),
(67, 'view_form_add', 'view_form_add', 'view_form_add.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-10-16 08:54:44', '1'),
(68, 'add_subactivity_form', 'add_subactivity_form', 'add_subactivity_form.php', '1', 'native', '2015-11-12 16:42:37', 'native', '2015-11-12 11:12:37', '1'),
(69, 'process_master', 'process_master', 'process_master.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-13 10:39:14', '1'),
(70, 'template_master', 'template_master', 'template_master.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-13 10:40:16', '1'),
(71, 'activity_management', 'activity_management', 'activity_management.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-13 11:33:20', '1'),
(72, 'practice_management', 'practice_management', 'practice_management.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-13 12:56:50', '1'),
(73, 'staff_management', 'staff_management', 'staff_management.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-13 13:14:11', '1'),
(74, 'resource_management', 'resource_management', 'resource_management.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-13 13:32:45', '1'),
(75, 'task_management', 'task_management', 'task_management.php', '1', 'native', '2015-10-16 14:24:44', 'native', '2015-11-14 05:07:33', '1'),
(76, 'file_explorer', 'file_explorer', 'file_explorer.php', '1', '', NULL, NULL, '2015-11-28 14:16:36', '1');

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

--
-- Table structure for table `app_role`
--

CREATE TABLE IF NOT EXISTS `app_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` varchar(45) DEFAULT NULL,
  `app_type` varchar(45) DEFAULT NULL,
  `role_name` varchar(45) DEFAULT NULL,
  `status` varchar(3) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `app_role`
--

INSERT INTO `app_role` (`role_id`, `app_id`, `app_type`, `role_name`, `status`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
(19, '8', 'service_customer', 'RoleCustomerA', '1', 'naga', '2015-09-21 16:45:36', 'native', '2015-10-09 15:20:28'),
(20, '9', 'project_customer', 'RoleCustomerB', '1', 'naga', '2015-09-21 16:45:52', 'naga', '2015-09-21 11:15:52'),
(21, '10', 'service_customer', 'nihih', '1', 'naga', '2015-09-21 20:28:37', 'naga', '2015-09-22 05:59:27'),
(22, '11', 'service_customer', 'SuperAdmin', '1', 'naga', '2015-09-22 11:31:44', 'naga', '2015-09-22 06:01:44'),
(23, '11', 'service_customer', 'TestRole', '1', 'native', '2015-09-22 13:34:15', 'native', '2015-09-22 08:04:15'),
(24, '9', 'project_customer', 'office assistant', '0', 'native', '2015-10-09 20:39:14', 'native', '2015-10-09 15:19:26'),
(25, '9', 'project_customer', 'admin', '1', 'native', '2015-10-09 20:39:27', 'native', '2015-10-09 15:09:27'),
(26, '9', 'project_customer', 'Team Lead', '1', 'native', '2015-10-09 20:40:17', 'native', '2015-10-09 15:10:17'),
(27, '9', 'project_customer', 'Consultant', '1', 'native', '2015-10-09 20:41:08', 'native', '2015-10-09 15:11:08');

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

--
-- Table structure for table `client_contact`
--

CREATE TABLE IF NOT EXISTS `client_contact` (
  `contact_id` int(11) NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(45) DEFAULT NULL,
  `contact_mobile` varchar(45) DEFAULT NULL,
  `contact_landline` varchar(45) DEFAULT NULL,
  `contact_email` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `client_details`
--

CREATE TABLE IF NOT EXISTS `client_details` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_name` varchar(200) DEFAULT NULL,
  `client_short` varchar(45) DEFAULT NULL,
  `client_owner_solute` varchar(45) DEFAULT NULL,
  `client_owner_name` varchar(45) DEFAULT NULL,
  `client_address` varchar(45) DEFAULT NULL,
  `clientstate` varchar(45) DEFAULT NULL,
  `client_country` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `office`
--

CREATE TABLE IF NOT EXISTS `office` (
  `office_id` int(10) NOT NULL,
  `office_name` int(10) DEFAULT NULL,
  `salutation` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `mobile_no` int(20) DEFAULT NULL,
  `primary_email` varchar(45) DEFAULT NULL,
  `secondary_email` varchar(45) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `pan_no` varchar(45) DEFAULT NULL,
  `tan_no` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`office_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `office`
--

INSERT INTO `office` (`office_id`, `office_name`, `salutation`, `name`, `mobile_no`, `primary_email`, `secondary_email`, `address`, `pan_no`, `tan_no`, `created_by`, `created_date`, `updated_by`, `updated_date`, `status`) VALUES
(1, 1, NULL, 'Test', NULL, NULL, NULL, NULL, NULL, NULL, 'native', '2015-10-17 13:30:15', 'native', '2015-10-17 08:00:15', '1'),
(2, 6, NULL, 'Testtt', NULL, NULL, NULL, NULL, NULL, NULL, 'native', '2015-10-17 13:34:05', 'native', '2015-10-17 08:04:05', '1');

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

--
-- Table structure for table `office_category_service`
--

CREATE TABLE IF NOT EXISTS `office_category_service` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(45) DEFAULT NULL,
  `service_short` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `office_details`
--

CREATE TABLE IF NOT EXISTS `office_details` (
  `office_id` int(11) NOT NULL AUTO_INCREMENT,
  `office_name` varchar(100) DEFAULT NULL,
  `office_short` varchar(45) DEFAULT NULL,
  `office_owner_solute` varchar(45) DEFAULT NULL,
  `office_owner_name` varchar(45) DEFAULT NULL,
  `office_address` varchar(500) DEFAULT NULL,
  `office_mobile_no` varchar(2000) DEFAULT NULL,
  `office_landline_no` varchar(2000) DEFAULT NULL,
  `office_email` varchar(2000) DEFAULT NULL,
  `office_pan_no` varchar(45) DEFAULT NULL,
  `office_tan_no` varchar(45) DEFAULT NULL,
  `service_tax_register` varchar(45) DEFAULT NULL,
  `office_category_service` varchar(45) DEFAULT NULL,
  `office_bank_account_no` varchar(45) DEFAULT NULL,
  `office_bank_name` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`office_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `office_staff`
--

CREATE TABLE IF NOT EXISTS `office_staff` (
  `staff_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(45) DEFAULT NULL,
  `staff_name` varchar(45) DEFAULT NULL,
  `staff_solute` varchar(45) DEFAULT NULL,
  `staff_location` varchar(45) DEFAULT NULL,
  `staff_state` varchar(45) DEFAULT NULL,
  `staff_country` varchar(45) DEFAULT NULL,
  `staff_mobile_no` varchar(45) DEFAULT NULL,
  `staff_landline_no` varchar(45) DEFAULT NULL,
  `staff_email` varchar(45) DEFAULT NULL,
  `staff_qualification` varchar(45) DEFAULT NULL,
  `staff_role_id` varchar(45) DEFAULT NULL,
  `staff_office_id` varchar(45) DEFAULT NULL,
  `staff_practice_area_id` varchar(45) DEFAULT NULL,
  `staff_sub_practice_area_id` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `practice`
--

CREATE TABLE IF NOT EXISTS `practice` (
  `practice_id` int(11) NOT NULL AUTO_INCREMENT,
  `practice_area` varchar(45) CHARACTER SET big5 DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`practice_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `practice`
--

INSERT INTO `practice` (`practice_id`, `practice_area`, `created_by`, `created_date`, `updated_by`, `updated_date`, `status`) VALUES
(1, 'zsd', 'native', '2015-10-17 10:36:12', 'native', '2015-10-17 05:06:15', '1'),
(2, 'zsd', 'native', '2015-10-17 10:37:00', 'native', '2015-10-17 05:07:00', '1'),
(3, 'zsdasasdasdadsad', 'native', '2015-10-17 10:43:02', 'native', '2015-10-17 05:13:02', '1'),
(4, 'income', 'native', '2015-10-17 10:59:30', 'native', '2015-10-17 05:29:30', '1'),
(5, 'incometax', 'native', '2015-10-17 11:08:02', 'native', '2015-10-17 05:38:02', '1'),
(6, 'direct', 'native', '2015-10-17 11:10:29', 'native', '2015-10-17 05:40:29', '1'),
(7, 'direct tax', 'native', '2015-10-17 11:13:16', 'native', '2015-10-17 05:43:16', '1'),
(8, 'direct taxs', 'native', '2015-10-17 11:14:26', 'native', '2015-10-17 05:44:26', '1'),
(9, 'direct taxss', 'native', '2015-10-17 11:15:59', 'native', '2015-10-17 05:45:59', '1'),
(10, 'direct taxc', 'native', '2015-10-17 11:18:41', 'native', '2015-10-17 05:48:41', '1'),
(11, 'dsff', 'native', '2015-10-17 11:22:38', 'native', '2015-10-17 05:52:38', '1');

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

--
-- Table structure for table `practice_area`
--

CREATE TABLE IF NOT EXISTS `practice_area` (
  `practice_id` int(11) NOT NULL AUTO_INCREMENT,
  `practice_name` varchar(45) DEFAULT NULL,
  `practice_short` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`practice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `role_resource`
--

CREATE TABLE IF NOT EXISTS `role_resource` (
  `role_resource_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) DEFAULT NULL,
  `resource_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`role_resource_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;

--
-- Dumping data for table `role_resource`
--

INSERT INTO `role_resource` (`role_resource_id`, `app_id`, `resource_id`, `role_id`, `status`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
(18, 8, 1, 19, '1', 'naga', '2015-09-21 20:09:03', 'naga', '2015-09-21 14:39:03'),
(19, 8, 2, 19, '1', 'naga', '2015-09-21 20:09:03', 'naga', '2015-09-21 14:39:03'),
(20, 8, 3, 19, '1', 'naga', '2015-09-21 20:09:03', 'naga', '2015-09-21 14:39:04'),
(44, 11, 1, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:15'),
(45, 11, 2, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:15'),
(46, 11, 3, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:15'),
(47, 11, 4, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:15'),
(48, 11, 5, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:15'),
(49, 11, 6, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:15'),
(50, 11, 7, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:16'),
(51, 11, 8, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:16'),
(52, 11, 9, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:16'),
(53, 11, 10, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:16'),
(54, 11, 11, 22, '1', 'native', '2015-09-22 13:23:15', 'native', '2015-09-22 07:53:16'),
(55, 9, 1, 20, '1', 'native', '2015-09-25 11:21:22', 'native', '2015-09-25 05:51:22'),
(56, 9, 2, 20, '1', 'native', '2015-09-25 11:21:22', 'native', '2015-09-25 05:51:22');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE IF NOT EXISTS `role_user` (
  `role_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`role_user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`role_user_id`, `app_id`, `role_id`, `user_id`, `status`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
(21, 8, 19, 27, '1', 'naga', '2015-09-21 18:51:24', 'naga', '2015-09-21 13:21:24'),
(22, 8, 19, 30, '1', 'naga', '2015-09-21 18:51:24', 'naga', '2015-09-21 13:21:24'),
(33, 11, 22, 32, '1', 'native', '2015-09-22 13:48:44', 'native', '2015-09-22 08:18:44'),
(34, 11, 23, 34, '1', 'native', '2015-09-22 13:48:52', 'native', '2015-09-22 08:18:52'),
(35, 9, 20, 0, '1', 'native', '2015-10-09 12:53:16', 'native', '2015-10-09 07:23:16');

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

--
-- Table structure for table `sub_practice_area`
--

CREATE TABLE IF NOT EXISTS `sub_practice_area` (
  `sub_practice_id` int(11) NOT NULL AUTO_INCREMENT,
  `practice_id` varchar(45) DEFAULT NULL,
  `practice_name` varchar(45) DEFAULT NULL,
  `practice_short` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`sub_practice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `system_role`
--

CREATE TABLE IF NOT EXISTS `system_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(45) DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

