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




--
-- Database: `metro_client_settings`
--

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

--
-- Table structure for table `contact_types`
--

CREATE TABLE IF NOT EXISTS `contact_types` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `readonly` tinyint(4) NOT NULL DEFAULT '1',
  `allow_company_field` tinyint(1) NOT NULL DEFAULT '1',
  `table` varchar(200) NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `contact_types`
--

INSERT INTO `contact_types` (`id`, `name`, `readonly`, `allow_company_field`, `table`, `submitter`, `date_submitted`) VALUES
(1, 'Supplier', 1, 1, 'suppliers', 2, '2011-04-04 15:38:04'),
(2, 'Client', 1, 1, 'clients', 2, '2011-04-04 15:38:04'),
(3, 'Business Associate', 1, 1, '', 2, '2011-04-04 15:38:04'),
(4, 'Contractor', 1, 1, '', 2, '2011-04-04 15:38:04'),
(5, 'Friends/Family', 1, 0, '', 2, '2011-04-04 15:38:04');

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `access` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `access_module` text NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `default_home` int(11) unsigned NOT NULL,
  `creator` bigint(11) unsigned NOT NULL,
  `date_created` datetime NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `description`, `access`, `status`, `access_module`, `display_name`, `default_home`, `creator`, `date_created`, `submitter`, `date_submitted`) VALUES
(31, 'Super Administrator', 'Super Administrator', '11111101111111111111101111111111111111111111111111111111111111111111111111111111100000000111111111111111111111111111111111111110000000011111111111111111111111111111111011111111111111111111111111111101111111111111111111111111111100000111100000011110000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000011100000000010001100000000000000000000000000000000000000000000000110110001000', 1, '10110010101010110000010000010', 'Super Administrator', 101, 1, '2011-08-01 20:21:29', 1, '2012-01-13 14:53:31'),
(35, 'Employee', 'Employee', '11111110001010000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000001100000000000000100000000000000000000000000000000000000000000000000010000000', 1, '1010000001000000', 'Employee', 11, 1, '2011-08-19 16:00:16', 1, '2011-08-19 16:00:16'),
(36, 'Manager', 'Manager', '11111100111111011111100111111111011111110000000000000010111111111111001111000000000000000011101111111111111100001111111111111110000000011111000000111111111111111111111011111111111111111111111111111101111111111000111111111111100100000111100000011110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000001100000000010001100000000000000000000000000000000000000000000000110110001000', 1, '10110010101010110000010000010', 'Manager', 101, 1, '2011-08-19 16:06:55', 1, '2011-08-19 16:06:55'),
(39, 'Supervisor', 'Supervisor', '11111000100000000000000001001111010000110000000000011111100000001111001111000000000000000000001111111111110000000000111110011110000000011111000000111100000000111000000000111111111111111111111111111100011111110000000000001111100000000111100000011110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010001110100000000000000000000000000000000000000001100000000010000100000000000000000000000000000000000000000000000100000001000', 1, '10010101010110000000000000', 'Supervisor', 101, 1, '2011-11-14 16:20:01', 1, '2011-11-14 16:20:01'),
(40, 'Timesheet Login', 'Timesheet Login', '100000000000001100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001100000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000', 1, '1000000', 'Timesheet Login', 11, 1, '2012-01-11 16:45:42', 1, '2012-01-11 16:49:56'),
(41, 'Job Tracking Login', 'Job Tracking Login', '110000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001100000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000', 1, '1000000', 'Job Tracking Login', 11, 1, '2012-01-11 16:46:01', 1, '2012-01-11 16:49:46'),
(42, 'Administrator', 'Administrator', '11111000111111011111100101000000000000010000000000011111011000001000001111000000000000000011101111111111111100001111111111111100000000010011000101011111111111000111111011111111111111111111111111111101111110101000000000000100001100000010100000011110000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000001100000000010000100000000000000000000000000000000000000000000000100110001000', 1, '10010010101010010000010000010', 'Administrator', 101, 1, '2012-01-13 14:53:47', 19, '2017-08-04 14:08:43'),
(43, 'General Manager', 'General Manager', '11111100111111111111111111111111010000110000000000011111111111111111001111000000000000000011001111111111110000001111111111111110000000011111000101111111111111111111111011111111111111111111111111111101111111111000001000011111110100000111100000011110000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000001100000000010001100000000000000000000000000000000000000000000000110110001000', 1, '10110010101010110000010000010', 'General Manager', 101, 1, '2012-02-02 21:41:51', 1, '2012-02-02 21:41:51'),
(44, 'Stocktake', 'Stocktake', '11111011111100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 1, '10000000000000000000000000000', 'Stocktake', 114, 1, '2015-05-27 16:13:01', 1, '2015-05-28 00:00:00');

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

--
-- Table structure for table `groups_add`
--

CREATE TABLE IF NOT EXISTS `groups_add` (
  `group_id` int(11) unsigned NOT NULL,
  `group_add_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`group_id`,`group_add_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groups_add`
--

INSERT INTO `groups_add` (`group_id`, `group_add_id`) VALUES
(31, 31),
(31, 35),
(31, 36),
(31, 39),
(31, 40),
(31, 41),
(31, 42),
(31, 43),
(31, 44),
(36, 35),
(36, 36),
(36, 39),
(41, 35),
(42, 35),
(42, 36),
(42, 39),
(42, 40),
(42, 41),
(42, 42),
(42, 44),
(43, 35),
(43, 36),
(43, 39),
(43, 44);

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

--
-- Table structure for table `groups_menu_landing`
--

CREATE TABLE IF NOT EXISTS `groups_menu_landing` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(11) unsigned NOT NULL,
  `module_id` bigint(11) unsigned NOT NULL,
  `sub_module_id` bigint(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2979 ;

--
-- Dumping data for table `groups_menu_landing`
--

INSERT INTO `groups_menu_landing` (`id`, `group_id`, `module_id`, `sub_module_id`) VALUES
(1313, 37, 11, 11),
(1314, 37, 88, 369),
(1315, 37, 91, 370),
(1316, 37, 89, 371),
(1317, 37, 90, 372),
(1318, 37, 94, 373),
(1319, 37, 93, 374),
(1320, 37, 82, 178),
(1321, 37, 80, 164),
(1322, 37, 5, 5),
(1323, 37, 81, 165),
(1324, 37, 12, 12),
(1337, 38, 11, 11),
(1338, 38, 88, 369),
(1339, 38, 91, 370),
(1340, 38, 89, 371),
(1341, 38, 90, 372),
(1342, 38, 94, 373),
(1343, 38, 93, 374),
(1344, 38, 82, 178),
(1345, 38, 80, 164),
(1346, 38, 5, 5),
(1347, 38, 81, 165),
(1348, 38, 12, 12),
(1518, 35, 11, 11),
(1519, 35, 99, 446),
(1520, 35, 82, 178),
(1521, 35, 80, 164),
(1522, 35, 5, 5),
(1523, 35, 81, 165),
(1524, 35, 12, 12),
(2325, 40, 11, 11),
(2326, 40, 103, 461),
(2327, 40, 105, 479),
(2328, 40, 107, 503),
(2329, 40, 102, 456),
(2330, 40, 101, 450),
(2331, 40, 106, 531),
(2332, 40, 109, 566),
(2333, 40, 108, 543),
(2334, 40, 5, 5),
(2335, 40, 81, 165),
(2336, 40, 12, 12),
(2337, 40, 111, 628),
(2338, 41, 11, 11),
(2339, 41, 103, 461),
(2340, 41, 105, 479),
(2341, 41, 107, 503),
(2342, 41, 102, 456),
(2343, 41, 101, 450),
(2344, 41, 106, 531),
(2345, 41, 109, 566),
(2346, 41, 108, 543),
(2347, 41, 5, 5),
(2348, 41, 81, 165),
(2349, 41, 12, 12),
(2350, 41, 111, 628),
(2875, 43, 11, 11),
(2876, 43, 101, 694),
(2877, 43, 107, 504),
(2878, 43, 103, 461),
(2879, 43, 105, 479),
(2880, 43, 112, 531),
(2881, 43, 82, 629),
(2882, 43, 5, 5),
(2883, 43, 81, 165),
(2884, 43, 12, 12),
(2885, 43, 111, 628),
(2886, 43, 113, 593),
(2887, 43, 114, 682),
(2901, 31, 11, 11),
(2902, 31, 101, 694),
(2903, 31, 107, 504),
(2904, 31, 103, 461),
(2905, 31, 105, 479),
(2906, 31, 112, 531),
(2907, 31, 82, 629),
(2908, 31, 5, 5),
(2909, 31, 81, 165),
(2910, 31, 12, 12),
(2911, 31, 111, 628),
(2912, 31, 113, 593),
(2913, 31, 114, 682),
(2914, 36, 11, 11),
(2915, 36, 101, 694),
(2916, 36, 107, 504),
(2917, 36, 103, 461),
(2918, 36, 105, 479),
(2919, 36, 112, 531),
(2920, 36, 82, 629),
(2921, 36, 5, 5),
(2922, 36, 81, 165),
(2923, 36, 12, 12),
(2924, 36, 111, 628),
(2925, 36, 113, 593),
(2926, 36, 114, 682),
(2927, 39, 11, 11),
(2928, 39, 101, 694),
(2929, 39, 107, 504),
(2930, 39, 103, 461),
(2931, 39, 105, 479),
(2932, 39, 112, 531),
(2933, 39, 82, 629),
(2934, 39, 5, 5),
(2935, 39, 81, 165),
(2936, 39, 12, 12),
(2937, 39, 111, 628),
(2938, 39, 113, 593),
(2939, 39, 114, 682),
(2940, 44, 11, 11),
(2941, 44, 101, 450),
(2942, 44, 107, 503),
(2943, 44, 103, 461),
(2944, 44, 105, 479),
(2945, 44, 112, 531),
(2946, 44, 82, 178),
(2947, 44, 5, 5),
(2948, 44, 81, 165),
(2949, 44, 12, 12),
(2950, 44, 111, 628),
(2951, 44, 113, 593),
(2952, 44, 114, 682),
(2966, 42, 11, 11),
(2967, 42, 101, 450),
(2968, 42, 107, 503),
(2969, 42, 103, 461),
(2970, 42, 105, 479),
(2971, 42, 112, 531),
(2972, 42, 82, 178),
(2973, 42, 5, 5),
(2974, 42, 81, 165),
(2975, 42, 12, 12),
(2976, 42, 111, 628),
(2977, 42, 113, 593),
(2978, 42, 114, 682);

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

--
-- Table structure for table `groups_old`
--

CREATE TABLE IF NOT EXISTS `groups_old` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `access` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `access_module` text NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `default_home` int(11) unsigned NOT NULL,
  `creator` bigint(11) unsigned NOT NULL,
  `date_created` datetime NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `groups_old`
--

INSERT INTO `groups_old` (`id`, `name`, `description`, `access`, `status`, `access_module`, `display_name`, `default_home`, `creator`, `date_created`, `submitter`, `date_submitted`) VALUES
(31, 'Super Administrator', 'Super Administrator', '101111111111111101101111111111111111111111111111111111111111111111111111111100000000111111111111111111111111111111111111110000000011111111111111111111111111111111011111111111111111111111111111101111111111111111111111111111100000111100000011110000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000011100000000010001100000000000000000000000000000000000000000000000110110001000', 1, '10110010101010110000010000010', 'Super Administrator', 101, 1, '2011-08-01 20:21:29', 1, '2012-01-13 14:53:31'),
(35, 'Employee', 'Employee', '11111110001010000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000001100000000000000100000000000000000000000000000000000000000000000000010000000', 1, '1010000001000000', 'Employee', 11, 1, '2011-08-19 16:00:16', 1, '2011-08-19 16:00:16'),
(36, 'Manager', 'Manager', '100111111011111100111111111011111110000000000000010111111111111001111000000000000000011101111111111111100001111111111111110000000011111000000111111111111111111111011111111111111111111111111111101111111111000111111111111100100000111100000011110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000001100000000010001100000000000000000000000000000000000000000000000110110001000', 1, '10110010101010110000010000010', 'Manager', 101, 1, '2011-08-19 16:06:55', 1, '2011-08-19 16:06:55'),
(39, 'Supervisor', 'Supervisor', '100000000000000001001111010000110000000000011111100000001111001111000000000000000000001111111111110000000000111110011110000000011111000000111100000000111000000000111111111111111111111111111100011111110000000000001111100000000111100000011110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010001110100000000000000000000000000000000000000001100000000010000100000000000000000000000000000000000000000000000100000001000', 1, '10010101010110000000000000', 'Supervisor', 101, 1, '2011-11-14 16:20:01', 1, '2011-11-14 16:20:01'),
(40, 'Timesheet Login', 'Timesheet Login', '100000000000001100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001100000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000', 1, '1000000', 'Timesheet Login', 11, 1, '2012-01-11 16:45:42', 1, '2012-01-11 16:49:56'),
(41, 'Job Tracking Login', 'Job Tracking Login', '110000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001100000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000', 1, '1000000', 'Job Tracking Login', 11, 1, '2012-01-11 16:46:01', 1, '2012-01-11 16:49:46'),
(42, 'Administrator', 'Administrator', '11111011111100001000000000000000000000000011101011000001000001110000000000000000011101111111111111100001111111111111100000000010011000000011111111111000111111011111111111111111111111111111101111110001000000000000000001100000010100000011110000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000010001111100000000000000000000000000000000000000001100000000010000100000000000000000000000000000000000000000000000100110001000', 1, '10010010101010010000010000010', 'Administrator', 101, 1, '2012-01-13 14:53:47', 1, '2012-01-13 14:53:47'),
(43, 'General Manager', 'General Manager', '100111111111111111111111111010000110000000000011111111111111111001111000000000000000011001111111111110000001111111111111110000000011111000101111111111111111111111011111111111111111111111111111101111111111000001000011111110100000111100000011110000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000011001111100000000000000000000000000000000000000001100000000010001100000000000000000000000000000000000000000000000110110001000', 1, '10110010101010110000010000010', 'General Manager', 101, 1, '2012-02-02 21:41:51', 1, '2012-02-02 21:41:51'),
(44, 'Stocktake', 'Stocktake', '11111011111100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 1, '10000000000000000000000000000', 'Stocktake', 114, 1, '2015-05-27 16:13:01', 1, '2015-05-28 00:00:00');

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

--
-- Table structure for table `logs_notes`
--

CREATE TABLE IF NOT EXISTS `logs_notes` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `action_type` tinyint(4) NOT NULL,
  `table_name` varchar(255) NOT NULL,
  `foreign_id` bigint(11) unsigned NOT NULL,
  `description` text NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `foreign_id` (`foreign_id`),
  KEY `date_submitted` (`date_submitted`),
  KEY `submitter` (`submitter`),
  KEY `item_type` (`action_type`),
  KEY `table` (`table_name`),
  KEY `item_type_2` (`action_type`,`table_name`),
  KEY `item_type_3` (`action_type`,`table_name`,`foreign_id`),
  KEY `table_name` (`table_name`,`foreign_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `logs_notes`
--

INSERT INTO `logs_notes` (`id`, `action_type`, `table_name`, `foreign_id`, `description`, `submitter`, `date_submitted`) VALUES
(1, 2, 'groups', 13, 'Sed suscipit scelerisque dui, vitae sed.\r\n', 1, '2011-08-01 19:54:51'),
(2, 2, 'groups', 28, 'Maecenas eget leo sit amet lacus nullam.\r\n', 1, '2011-08-01 19:58:16'),
(3, 2, 'accounts', 3, 'Phasellus mollis suscipit eleifend? sed.\r\n', 1, '2011-08-01 20:01:29'),
(4, 2, 'packages_notes', 9, 'Proin nec nulla velit. Aenean nec metus.\r\n', 1, '2011-08-01 20:12:34'),
(5, 4, 'groups', 31, 'In iaculis purus eu metus mollis ultrices. Cras tempor porta blandit. Aliquam eget sapien et arcu venenatis posuere. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Vivamus in ante lorem. Fusce consectetur massa quis nunc tempus faucibus consequat orci condimentum. Sed id tellus quam. Vestibulum non est nec massa vestibulum aliquam eget quis eros. Sed ut felis porta mauris volutpat euismod in quis risus.\r\n\r\nQuisque nec felis purus, nec egestas erat. Vestibulum ullamcorper lobortis aliquet. Integer sodales varius tristique. Sed pellentesque ornare molestie. Donec cursus tortor vel odio pellentesque adipiscing. Vivamus ut enim velit. Nunc sit amet orci lectus, vel scelerisque ante.\r\n\r\nAenean feugiat consectetur orci at tincidunt. Sed id odio dolor, ut auctor neque! Proin in velit odio; sed dignissim libero? Phasellus a vestibulum odio. Fusce vel erat lorem, vitae ullamcorper magna? Cras feugiat varius metus, ac mollis ligula luctus et. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tristique libero vel urna blandit auctor id non dui. Nulla facilisi. Donec pretium mauris eget lectus blandit faucibus. Sed id magna ante. Suspendisse potenti.\r\n', 15, '2012-01-06 17:23:50'),
(6, 4, 'jobs', 3, 'asdf', 15, '2012-01-12 15:09:44');

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

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `ordering` int(11) unsigned NOT NULL,
  `permission` text NOT NULL,
  `sub_module_id` bigint(11) unsigned NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  `menu` tinyint(4) NOT NULL,
  `main_menu` tinyint(4) NOT NULL,
  `status` int(11) unsigned NOT NULL DEFAULT '1',
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=115 ;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `name`, `ordering`, `permission`, `sub_module_id`, `display_name`, `description`, `icon`, `menu`, `main_menu`, `status`, `submitter`, `date_submitted`) VALUES
(5, 'Users', 8, '10', 5, 'Users', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'icons/staff', 1, 1, 1, 1, '2011-08-23 16:29:57'),
(11, 'Home', 1, '1000000', 11, 'Home', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'icons/home', 1, 0, 1, 1, '2011-11-14 15:03:02'),
(12, 'Setup', 10, '10000000', 12, 'Settings', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'icons/setup', 1, 1, 1, 1, '2011-12-09 16:39:07'),
(81, 'My Account', 9, '10000000000000', 165, 'My Account', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'icons/my_account', 1, 1, 1, 1, '2011-07-25 17:56:13'),
(82, 'reports', 7, '100000000000000', 178, 'Reports', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'images/icons/reports', 1, 0, 1, 1, '2012-01-19 13:08:35'),
(101, 'Tasks', 2, '10000000000000000', 450, 'Tasks', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'images/tasks', 1, 0, 1, 1, '2012-01-19 16:48:06'),
(103, 'Request', 4, '1000000000000000000', 11, 'Quotes', '<p>Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary </p>', 'images/icon/request', 1, 0, 1, 1, '2011-11-14 15:02:32'),
(105, 'Jobs', 5, '100000000000000000000', 450, 'Jobs', 'asas', 'images/icons/jobs.ico', 1, 0, 1, 1, '2011-11-14 16:40:56'),
(107, 'Contacts', 3, '10000000000000000000000', 466, 'Contacts', 'Contacts', 'Contacts', 1, 0, 1, 1, '2011-12-20 14:56:57'),
(111, 'Calendar', 11, '10000000000000000000000000', 628, 'Calendar', 'Company Job Schedules', 'icons/calendar.png', 1, 0, 1, 1, '2012-01-19 13:00:37'),
(112, 'Payroll', 6, '100000000000000000000000000', 600, 'Payroll', 'Payroll', 'Payroll', 1, 0, 1, 1, '2012-01-19 12:59:24'),
(113, 'Tablet', 12, '1000000000000000000000000000', 452, 'Tablet', 'Tablet', 'Tablet', 0, 0, 1, 1, '2012-01-25 18:00:46'),
(114, 'Stock', 13, '10000000000000000000000000000', 682, 'Stock', 'Stock', 'Stock', 1, 0, 1, 1, '2014-05-19 11:47:12');

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

--
-- Table structure for table `modules_sub`
--

CREATE TABLE IF NOT EXISTS `modules_sub` (
  `id` bigint(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `page` varchar(255) NOT NULL,
  `primary_module` int(11) NOT NULL,
  `permission` text NOT NULL,
  `permission_type` varchar(255) NOT NULL,
  `module_type` varchar(255) NOT NULL,
  `first_layer` tinyint(4) NOT NULL,
  `second_layer` tinyint(4) NOT NULL,
  `first_layer_id` bigint(11) unsigned NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `ordering` int(11) unsigned NOT NULL,
  `status` int(11) unsigned NOT NULL DEFAULT '1',
  `asset_type` char(50) NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



INSERT INTO `modules_sub` (`id`, `name`, `page`, `primary_module`, `permission`, `permission_type`, `module_type`, `first_layer`, `second_layer`, `first_layer_id`, `display_name`, `ordering`, `status`, `asset_type`, `submitter`, `date_submitted`) VALUES
(679, 'Jobs Updates', 'payroll_jobs_update', 112, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Jobs Updates', 0, 0, 0, 'Jobs Updates', 0, 1, 'page', 1, '2012-02-23 16:32:03'),
(680, 'Sales Reports', 'reports_sales', 82, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Sales Reports', 0, 0, 0, 'Sales Reports', 0, 1, 'page', 1, '2013-05-27 12:22:38'),
(681, 'Non-Billable Hours Reports', 'reports_non_billable', 82, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Non-Billable Hours Reports', 0, 0, 0, 'Non-Billable Hours Reports', 0, 0, 'page', 1, '2013-10-17 16:21:32'),
(682, 'Stock', 'stock', 114, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Stock', 0, 0, 0, 'Stock', 0, 1, 'page', 1, '2014-05-19 11:27:18'),
(683, 'Create New Order', 'stock_create_order', 114, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Order', 0, 0, 0, 'Create New Order', 0, 1, 'page', 1, '2014-05-19 11:30:59'),
(684, 'Order Edit', 'stock_order_edit', 114, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Order', 0, 0, 0, 'Edit Order', 0, 1, 'page', 1, '2014-05-19 11:46:02'),
(685, 'Order Detail', 'stock_order_detail', 114, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Order', 0, 0, 0, 'Order Detail', 0, 1, 'page', 1, '2014-05-19 13:32:22'),
(686, 'Order Tracking', 'stock_order_track', 114, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Stock', 0, 0, 0, 'Order Tracking', 0, 1, 'page', 1, '2014-06-06 14:10:31'),
(687, 'Order History', 'stock_order_history', 114, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Stock', 0, 0, 0, 'Order History', 0, 1, 'page', 1, '2014-06-06 14:10:57'),
(688, 'Materials Summary', 'reports_material_summary', 82, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Material', 0, 0, 0, 'Materials Summary', 0, 1, 'page', 1, '2014-06-13 14:42:54'),
(689, 'Stock Material', 'stock_material', 114, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Stock Material', 0, 0, 0, 'Stock Material', 0, 1, 'page', 1, '2014-06-24 16:08:57'),
(690, 'Add Material', 'stock_create_material', 114, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Stock Material', 0, 0, 0, 'Add Material', 0, 1, 'page', 1, '2014-06-24 16:12:36'),
(691, 'Edit Material', 'stock_material_edit', 114, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Stock Material', 0, 0, 0, 'Edit Material', 0, 1, 'page', 1, '2014-06-27 12:29:38'),
(692, 'Material Detail', 'stock_material_detail', 114, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Stock Material', 0, 0, 0, 'Material Detail', 0, 1, 'page', 1, '2014-06-27 12:30:54'),
(693, 'Stock Take', 'stock_take', 114, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Stock Take', 0, 0, 0, 'Stock Take', 0, 1, 'page', 1, '2014-06-30 15:21:01'),
(694, 'All Tasks', 'tasks_all', 101, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Tasks', 0, 0, 0, 'All Tasks', 0, 1, 'page', 1, '2015-02-03 12:49:12'),
(695, 'Workflow', 'setup_workflow_list', 12, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Workflow', 0, 0, 0, 'Workflow', 0, 1, 'page', 1, '2015-03-05 14:44:19'),
(697, 'Setup Inventory History', 'setup_inventory_history', 12, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Setup Inventory', 0, 0, 0, 'Inventory History', 0, 1, 'page', 1, '2015-07-14 14:39:55'),
(698, 'Setup Templates', 'setup_templates', 12, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Setup Templates', 1, 0, 0, 'Templates', 0, 1, 'page', 1, '2016-06-07 17:58:09'),
(699, 'Templates', 'setup_templates_create', 12, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Setup Templates', 0, 0, 0, 'Setup Templates Create', 0, 1, 'page', 1, '2016-06-07 17:59:05'),
(700, 'Setup Templates Edit', 'setup_templates_edit', 12, '100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'write', 'Setup Templates', 0, 0, 0, 'Setup Templates Edit', 0, 1, 'page', 1, '2016-06-10 20:30:10'),
(701, 'Setup Templates Delete', 'setup_templates_delete', 12, '1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'delete', 'Setup Templates', 0, 0, 0, 'Setup Templates Delete', 0, 1, 'action', 1, '2016-06-14 13:01:40'),
(702, 'Setup Templates Details', 'setup_templates_details', 12, '10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 'read', 'Setup Templates', 0, 1, 698, 'Setup Templates Details', 0, 1, 'page', 1, '2016-06-14 15:17:45');
