   `modified` datetime DEFAULT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=26 AUTO_INCREMENT=67 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=26 AUTO_INCREMENT=5 ;
 
 --
 -- Dumping data for table `acl_roles`

INSERT INTO `acl_roles` (`id`, `name`, `created`, `modified`) VALUES
(1, 'Administrator', '2011-12-27 12:00:00', NULL),
(2, 'Guest', '2011-12-27 12:00:00', NULL),
(3, 'Compliance Manager', '2011-12-27 12:00:00', '2012-07-09 20:54:23'),
(4, 'Accounting Manager', '2011-12-27 12:00:00', '2012-07-09 20:55:12'),
(5, 'Settlement Manager', '2011-12-27 12:00:00', '2012-07-09 20:55:55'),
(17, 'Head of Education', '2011-12-27 12:00:00', '2012-07-09 20:56:52'),
(35, 'Employee', '2012-02-06 10:52:26', NULL),
(36, 'Owner', '2012-07-09 20:44:03', NULL),
(37, 'Direktur', '2012-07-09 20:44:22', NULL),
(38, 'BM Regional', '2012-07-09 20:45:05', NULL),
(39, 'Branch Manager', '2012-07-09 20:45:51', NULL),
(40, 'Marketing Manager', '2012-07-09 20:46:18', '2012-07-12 11:31:20'),
(41, 'Division Manager', '2012-07-09 20:46:54', NULL),
(42, 'Assistant Manager', '2012-07-09 20:47:41', NULL),
(43, 'FC', '2012-07-09 20:48:02', '2012-07-09 21:51:08'),
(44, 'Head InHouse Manager', '2012-07-09 20:50:02', '2012-07-12 11:33:00'),
(45, 'InHouse Manager', '2012-07-09 20:51:07', NULL),
(46, 'Marketing', '2012-07-09 20:52:20', NULL),
(48, 'Compliance', '2012-07-09 20:54:37', '2012-07-12 11:55:31'),
(49, 'Accounting', '2012-07-09 20:55:27', '2012-10-16 19:18:55'),
(50, 'Settlement', '2012-07-09 20:56:13', '2012-07-12 11:57:10'),
(51, 'Education', '2012-07-09 20:57:13', '2012-07-12 11:53:53'),
(52, 'HRD', '2012-07-09 21:02:16', NULL),
(53, 'Head of Research & Analyst', '2012-07-09 21:03:30', NULL),
(54, 'Research & Analyst', '2012-07-09 21:04:01', '2012-07-12 11:56:44'),
(55, 'Head of Promotion', '2012-07-09 21:04:34', NULL),
(56, 'Promotion', '2012-07-09 21:05:05', '2012-07-12 11:56:13'),
(57, 'Bussiness Development Officer', '2012-07-09 21:07:11', '2012-07-12 11:34:48'),
(64, 'Assistant Branch Manager', '2012-07-12 11:30:44', NULL);

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


(1625, 'Yoshimi', 'Kato', 'ykato', 'ykato@classicmodelcars.com', '', '2012-03-01 05:54:30'),
(1702, 'Martin', 'Gerard', 'mgerard', 'mgerard@classicmodelcars.com', '', '2012-03-01 05:54:30');

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE IF NOT EXISTS `ci_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `acl_role_parents`
--
ALTER TABLE `acl_role_parents`
  ADD CONSTRAINT `acl_role_parents_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `acl_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `acl_role_parents_ibfk_2` FOREIGN KEY (`parent`) REFERENCES `acl_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `acl_rules`
--
ALTER TABLE `acl_rules`
  ADD CONSTRAINT `acl_rules_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `acl_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `acl_rules_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `acl_resources` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `auth_users`
