-- phpMyAdmin SQL Dump -- version 3.3.2deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 22, 2010 at 07:57 AM -- Server version: 5.1.41 -- PHP Version: 5.3.2-1ubuntu4.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `app_am` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE IF NOT EXISTS `admins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `client_id` int(11) NOT NULL, `username` varchar(64) NOT NULL, `password` varchar(64) NOT NULL, `firstName` varchar(255) NOT NULL, `lastName` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `status` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `ID_Client_Client` (`client_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `client_id`, `username`, `password`, `firstName`, `lastName`, `email`, `phone`, `status`) VALUES (1, 1052512, 'stelian', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Stelian', 'Mocanita', 'smocanita@ocenture.com', '1111111111', 1), (20, 1052512, 'customersupport', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Customer', 'Support', 'customer@suppor.com', '1231111122', 1), (22, 1052512, 'sales', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Ocenture', 'Sales', 'accounting@ocenture.dev', '1111111111', 1), (23, 1052512, 'customeradmin', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Customer', 'Admin', 'customer@admin.com', '1111111111', 1), (24, 1052512, 'smokey', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Shmokey', 'MOCANITA', 'smocanita@ocenture.com', '11111111111', 1), (25, 1052512, 'apantescu', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Andreea', 'Pantescu', 'accounting@ocenture.dev', '1111111111', 1), (26, 1052512, 'andreea', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Andreea', 'Pantescu', 'accounting@ocenture.dev', '1111111111', 1); -- -------------------------------------------------------- -- -- Table structure for table `admin_logins` -- CREATE TABLE IF NOT EXISTS `admin_logins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL, `created_at` datetime NOT NULL, `ip` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `admin_id` (`admin_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ; -- -- Dumping data for table `admin_logins` -- INSERT INTO `admin_logins` (`id`, `admin_id`, `created_at`, `ip`) VALUES (1, 1, '2010-12-20 08:33:36', '127.0.0.1'), (2, 1, '2010-12-20 08:33:43', '127.0.0.1'), (3, 1, '2010-12-21 02:31:08', '127.0.0.1'), (4, 1, '2010-12-21 07:58:48', '127.0.0.1'), (5, 1, '2010-12-21 07:59:28', '127.0.0.1'), (6, 1, '2010-12-21 08:00:36', '127.0.0.1'), (7, 1, '2010-12-21 08:03:44', '127.0.0.1'), (8, 20, '2010-12-21 08:05:00', '127.0.0.1'), (9, 1, '2010-12-21 08:09:56', '127.0.0.1'), (10, 20, '2010-12-22 01:39:47', '127.0.0.1'), (11, 20, '2010-12-22 01:41:48', '127.0.0.1'), (12, 20, '2010-12-22 01:42:10', '127.0.0.1'), (13, 20, '2010-12-22 01:42:33', '127.0.0.1'), (14, 20, '2010-12-22 01:43:19', '127.0.0.1'), (15, 20, '2010-12-22 01:43:28', '127.0.0.1'), (16, 20, '2010-12-22 01:43:48', '127.0.0.1'), (17, 20, '2010-12-22 01:44:31', '127.0.0.1'), (18, 20, '2010-12-22 01:47:13', '127.0.0.1'), (19, 20, '2010-12-22 01:50:12', '127.0.0.1'), (20, 1, '2010-12-22 02:18:13', '127.0.0.1'), (21, 20, '2010-12-22 03:17:36', '127.0.0.1'), (22, 1, '2010-12-22 03:17:57', '127.0.0.1'), (23, 22, '2010-12-22 03:26:13', '127.0.0.1'), (24, 22, '2010-12-22 03:34:36', '127.0.0.1'), (25, 22, '2010-12-22 03:35:36', '127.0.0.1'), (26, 22, '2010-12-22 03:36:29', '127.0.0.1'), (27, 22, '2010-12-22 03:36:46', '127.0.0.1'), (28, 22, '2010-12-22 03:36:49', '127.0.0.1'), (29, 22, '2010-12-22 03:37:05', '127.0.0.1'), (30, 22, '2010-12-22 03:38:10', '127.0.0.1'), (31, 22, '2010-12-22 03:38:27', '127.0.0.1'), (32, 22, '2010-12-22 03:39:26', '127.0.0.1'), (33, 22, '2010-12-22 03:39:40', '127.0.0.1'), (34, 22, '2010-12-22 03:39:47', '127.0.0.1'), (35, 22, '2010-12-22 03:41:57', '127.0.0.1'), (36, 20, '2010-12-22 03:44:19', '127.0.0.1'), (37, 22, '2010-12-22 03:57:04', '127.0.0.1'), (38, 23, '2010-12-22 03:58:55', '127.0.0.1'), (39, 1, '2010-12-22 06:10:40', '127.0.0.1'), (40, 1, '2010-12-22 06:18:43', '192.168.36.106'), (41, 1, '2010-12-22 06:31:05', '192.168.36.106'), (42, 1, '2010-12-22 06:33:37', '192.168.36.106'), (43, 1, '2010-12-22 06:39:03', '192.168.36.106'), (44, 20, '2010-12-22 07:06:48', '127.0.0.1'), (45, 1, '2010-12-22 07:26:32', '127.0.0.1'), (46, 1, '2010-12-22 07:28:13', '127.0.0.1'); -- -------------------------------------------------------- -- -- Table structure for table `modules_permissions` -- CREATE TABLE IF NOT EXISTS `modules_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `permission_id` int(11) NOT NULL, `controller` varchar(255) NOT NULL, `call` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `permission_id` (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- Dumping data for table `modules_permissions` -- INSERT INTO `modules_permissions` (`id`, `permission_id`, `controller`, `call`) VALUES (1, 2, 'account', 'add'), (2, 1, 'account', 'index'), (3, 3, 'order', 'edit'), (4, 7, 'order', 'dependant'), (5, 6, 'order', 'status'), (6, 8, 'administration', 'index'), (7, 9, 'administration', 'add'), (8, 10, 'administration', 'edit'), (9, 11, 'administration', 'delete'), (11, 12, 'account', 'addnote'), (12, 14, 'backendstatic', 'training'), (13, 13, 'backendstatic', 'marketing'); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE IF NOT EXISTS `permissions` ( `permission_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`permission_id`, `name`) VALUES (1, 'View customers list'), (2, 'Create a customer entry'), (3, 'Update an existing entry'), (4, 'Delete a customer entry'), (5, 'Cancel or reactivate order'), (6, 'Upgrade or degrade an order'), (7, 'Create dependants'), (8, 'Administration Read'), (9, 'Administration Add'), (10, 'Administration Update'), (11, 'Administration Delete'), (12, 'Create account note'), (13, 'Marketing Materials'), (14, 'Training Center'); -- -------------------------------------------------------- -- -- Table structure for table `reseller_endorment` -- CREATE TABLE IF NOT EXISTS `reseller_endorment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `company` varchar(255) NOT NULL, `industry` varchar(255) NOT NULL, `base` varchar(255) NOT NULL, `status` int(1) NOT NULL DEFAULT '0', `client_id` int(11) NOT NULL, `ip` varchar(255) NOT NULL, `created_at` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `credentials` (`username`,`password`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Temporary table for resellers enrollment' AUTO_INCREMENT=6 ; -- -- Dumping data for table `reseller_endorment` -- INSERT INTO `reseller_endorment` (`id`, `username`, `password`, `firstname`, `lastname`, `email`, `phone`, `company`, `industry`, `base`, `status`, `client_id`, `ip`, `created_at`) VALUES (1, 'smocanita', '901c74372ef9f19cb03de33debcb2d9d', 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222333', 'Ocenture', '1', '1', 0, 1000001, '', '2010-11-24 06:48:26'), (2, 'stelian', '901c74372ef9f19cb03de33debcb2d9d', 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222333', 'Ocenture', '1', '1', 0, 1000001, '', '2010-11-24 06:54:20'), (3, 'stelian', '901c74372ef9f19cb03de33debcb2d9d', 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222333', 'Ocenture', '1', '1', 0, 1000001, '', '2010-11-24 06:54:36'), (4, 'stelian', '901c74372ef9f19cb03de33debcb2d9d', 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222333', 'Ocenture', '1', '1', 0, 1000001, '', '2010-11-24 06:54:57'), (5, 'stelian', 'faadf7dac1dd3347ae9a747c7b2803bb', 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222222', 'Ocenture', '1', '1', 0, 1000001, '', '2010-12-03 05:29:20'); -- -------------------------------------------------------- -- -- Table structure for table `reseller_pricing_request` -- CREATE TABLE IF NOT EXISTS `reseller_pricing_request` ( `id` int(11) NOT NULL AUTO_INCREMENT, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `company` varchar(255) NOT NULL, `ip` varchar(255) NOT NULL, `client_id` int(11) NOT NULL, `created_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `reseller_pricing_request` -- INSERT INTO `reseller_pricing_request` (`id`, `firstname`, `lastname`, `email`, `phone`, `company`, `ip`, `client_id`, `created_at`) VALUES (1, 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222333', 'Ocenture', '127.0.0.1', 1000001, '2010-11-24 06:41:11'), (2, 'Stelian', 'Mocanita', 'stelian.mocanita@gmail.com', '0232222222', 'Ocenture', '127.0.0.1', 1000001, '2010-12-03 02:05:25'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE IF NOT EXISTS `roles` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `public` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`role_id`, `name`, `description`, `public`) VALUES (1, 'Ocenture admin', 'Can do everything for everybody', 0), (2, 'Reseller Admin', 'Add/Update/Delete IdentaSafeUsers Add/Update/Cancel/Reactivate Orders Add Family Member Upgrade Protection Level Downgrade Protection Level', 1), (3, 'Reseller Customer Support', 'Add/Update/Cancel/Reactivate Orders Add Family Member Upgrade Protection Level Downgrade Protection Level', 1), (4, 'Reseller Sales and Marketing', 'Access financial reporting and invoices', 1); -- -------------------------------------------------------- -- -- Table structure for table `roles_permissions` -- CREATE TABLE IF NOT EXISTS `roles_permissions` ( `role_permission_id` int(11) NOT NULL AUTO_INCREMENT, `role_id` int(111) NOT NULL, `permission_id` int(11) NOT NULL, PRIMARY KEY (`role_permission_id`), KEY `role_id` (`role_id`), KEY `permission_id` (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ; -- -- Dumping data for table `roles_permissions` -- INSERT INTO `roles_permissions` (`role_permission_id`, `role_id`, `permission_id`) VALUES (1, 2, 1), (4, 2, 4), (5, 2, 3), (6, 2, 2), (7, 2, 7), (8, 2, 6), (9, 3, 1), (10, 3, 14), (11, 2, 8), (12, 2, 9), (13, 2, 10), (14, 2, 11), (15, 2, 12), (16, 2, 13), (17, 2, 14), (26, 3, 2), (27, 3, 3), (28, 3, 4), (29, 3, 5), (30, 3, 6), (31, 3, 7), (33, 3, 13), (35, 3, 12), (36, 4, 1), (37, 4, 13), (38, 4, 14); -- -------------------------------------------------------- -- -- Table structure for table `user_roles` -- CREATE TABLE IF NOT EXISTS `user_roles` ( `user_role_id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, PRIMARY KEY (`user_role_id`), KEY `user_id` (`admin_id`), KEY `role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- Dumping data for table `user_roles` -- INSERT INTO `user_roles` (`user_role_id`, `admin_id`, `role_id`) VALUES (1, 1, 2), (5, 18, 3), (7, 20, 3), (9, 22, 4), (10, 23, 2), (11, 24, 2), (12, 25, 2), (13, 26, 2); -- -- Constraints for dumped tables -- -- -- Constraints for table `admin_logins` -- ALTER TABLE `admin_logins` ADD CONSTRAINT `admin_logins_ibfk_1` FOREIGN KEY (`adm