text: -- phpMyAdmin SQL Dump
  -- version 4.7.0
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Oct 28, 2017 at 02:29 PM
  -- Server version: 10.1.25-MariaDB
  -- PHP Version: 5.6.31
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!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 utf8mb4 */;
  
  --
  -- Database: `db_reviewit`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin_groups`
  --
  
  CREATE TABLE `admin_groups` (
    `id` mediumint(8) UNSIGNED NOT NULL,
    `name` varchar(20) NOT NULL,
    `description` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `admin_groups`
  --
  
  INSERT INTO `admin_groups` (`id`, `name`, `description`) VALUES
  (1, 'webmaster', 'Webmaster'),
  (2, 'admin', 'Administrator'),
  (3, 'manager', 'Manager'),
  (4, 'staff', 'Staff');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin_login_attempts`
  --
  
  CREATE TABLE `admin_login_attempts` (
    `id` int(11) UNSIGNED NOT NULL,
    `ip_address` varchar(15) NOT NULL,
    `login` varchar(100) NOT NULL,
    `time` int(11) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin_users`
  --
  
  CREATE TABLE `admin_users` (
    `id` int(11) UNSIGNED NOT NULL,
    `ip_address` varchar(15) NOT NULL,
    `username` varchar(100) DEFAULT NULL,
    `password` varchar(255) NOT NULL,
    `salt` varchar(255) DEFAULT NULL,
    `email` varchar(100) DEFAULT NULL,
    `activation_code` varchar(40) DEFAULT NULL,
    `forgotten_password_code` varchar(40) DEFAULT NULL,
    `forgotten_password_time` int(11) UNSIGNED DEFAULT NULL,
    `remember_code` varchar(40) DEFAULT NULL,
    `created_on` int(11) UNSIGNED NOT NULL,
    `last_login` int(11) UNSIGNED DEFAULT NULL,
    `active` tinyint(1) UNSIGNED DEFAULT NULL,
    `first_name` varchar(50) DEFAULT NULL,
    `last_name` varchar(50) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `admin_users`
  --
  
  INSERT INTO `admin_users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`) VALUES
  (1, '127.0.0.1', 'webmaster', '$2y$08$/X5gzWjesYi78GqeAv5tA.dVGBVP7C1e1PzqnYCVe5s1qhlDIPPES', NULL, NULL, NULL, NULL, NULL, 'LiY/s61D493CH4N4o6ctY.', 1451900190, 1509189123, 1, 'Administrator', ''),
  (2, '127.0.0.1', 'admin', '$2y$08$7Bkco6JXtC3Hu6g9ngLZDuHsFLvT7cyAxiz1FzxlX5vwccvRT7nKW', NULL, NULL, NULL, NULL, NULL, NULL, 1451900228, 1465489580, 1, 'Admin', ''),
  (3, '127.0.0.1', 'manager', '$2y$08$snzIJdFXvg/rSHe0SndIAuvZyjktkjUxBXkrrGdkPy1K6r5r/dMLa', NULL, NULL, NULL, NULL, NULL, NULL, 1451900430, 1465489585, 1, 'Manager', ''),
  (4, '127.0.0.1', 'staff', '$2y$08$NigAXjN23CRKllqe3KmjYuWXD5iSRPY812SijlhGeKfkrMKde9da6', NULL, NULL, NULL, NULL, NULL, NULL, 1451900439, 1465489590, 1, 'Staff', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin_users_groups`
  --
  
  CREATE TABLE `admin_users_groups` (
    `id` int(11) UNSIGNED NOT NULL,
    `user_id` int(11) UNSIGNED NOT NULL,
    `group_id` mediumint(8) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `admin_users_groups`
  --
  
  INSERT INTO `admin_users_groups` (`id`, `user_id`, `group_id`) VALUES
  (1, 1, 1),
  (2, 2, 2),
  (3, 3, 3),
  (4, 4, 4);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `api_access`
  --
  
  CREATE TABLE `api_access` (
    `id` int(11) UNSIGNED NOT NULL,
    `key` varchar(40) NOT NULL DEFAULT '',
    `controller` varchar(50) NOT NULL DEFAULT '',
    `date_created` datetime DEFAULT NULL,
    `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `api_keys`
  --
  
  CREATE TABLE `api_keys` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `key` varchar(40) NOT NULL,
    `level` int(2) NOT NULL,
    `ignore_limits` tinyint(1) NOT NULL DEFAULT '0',
    `is_private_key` tinyint(1) NOT NULL DEFAULT '0',
    `ip_addresses` text,
    `date_created` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `api_keys`
  --
  
  INSERT INTO `api_keys` (`id`, `user_id`, `key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES
  (1, 1, 'anonymous', 1, 1, 0, NULL, 1463388382);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `api_limits`
  --
  
  CREATE TABLE `api_limits` (
    `id` int(11) NOT NULL,
    `uri` varchar(255) NOT NULL,
    `count` int(10) NOT NULL,
    `hour_started` int(11) NOT NULL,
    `api_key` varchar(40) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `api_logs`
  --
  
  CREATE TABLE `api_logs` (
    `id` int(11) NOT NULL,
    `uri` varchar(255) NOT NULL,
    `method` varchar(6) NOT NULL,
    `params` text,
    `api_key` varchar(40) NOT NULL,
    `ip_address` varchar(45) NOT NULL,
    `time` int(11) NOT NULL,
    `rtime` float DEFAULT NULL,
    `authorized` varchar(1) NOT NULL,
    `response_code` smallint(3) DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `app_settings`
  --
  
  CREATE TABLE `app_settings` (
    `id` int(11) NOT NULL,
    `terms` text NOT NULL,
    `privacy` text NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `app_settings`
  --
  
  INSERT INTO `app_settings` (`id`, `terms`, `privacy`, `created_on`) VALUES
  (1, 'Google Analytics for Firebase is a free app measurement solution that provides insight on app usage and user engagement.\r\nAt the heart of Firebase is Google Analytics for Firebase, a free and unlimited analytics solution. Analytics integrates across Firebase features and provides you with unlimited reporting for up to 500 distinct events that you can define using the Firebase SDK. Analytics reports help you understand clearly how your users behave, which enables you to make informed decisions regarding app marketing and performance optimizations.\r\n\r\nGoogle Analytics for Firebase helps you understand how people use your iOS or Android app. The SDK automatically captures a number of events and user properties and also allows you to define your own custom events to measure the things that uniquely matter to your business. Once the data is captured, it\'s available in a dashboard through the Firebase console. This dashboard provides detailed insights about your data — from summary data such as active users and demographics, to more detailed data such as identifying your most purchased items.\r\n\r\nAnalytics also integrates with a number of other Firebase features. For example, it automatically logs events that correspond to notification messages sent via the Notifications composer and provides reporting on the impact of each campaign.\r\n\r\nAnalytics helps you understand how your users behave, so you can make informed decisions about how to market your app. See the performance of your campaigns across organic and paid channels to understand which methods are most effective at driving high-value users. If you need to perform custom analysis or join your data with other sources you can link your Analytics data to BigQuery, which allows for more complex analysis like querying large data sets and joining multiple data sources.', 'If you are setting up a new project, you need to install the SDK. You may have already completed this as part of creating a Firebase project.\r\n\r\nWe recommend using CocoaPods to install the libraries. You can install Cocoapods by following the installation instructions. If you\'d rather not use CocoaPods, you can integrate the SDK frameworks directly by following the instructions below.\r\n\r\nIf you are planning to download and run one of the quickstart samples, the Xcode project and Podfile are already present, but you\'ll still need to install the pods and download the GoogleService-Info.plist file. If you would like to integrate the Firebase libraries into one of your own projects, you will need to add the pods for the libraries that you want to use.', '2017-09-22 20:07:58');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `company_review`
  --
  
  CREATE TABLE `company_review` (
    `id` int(11) NOT NULL,
    `company_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `rate` double NOT NULL,
    `rating` decimal(11,0) NOT NULL,
    `immigration_rate` int(11) NOT NULL,
    `work_rating` int(11) NOT NULL,
    `payroll_rate` int(11) NOT NULL,
    `hr_rate` int(11) NOT NULL,
    `comment` text NOT NULL,
    `anonymous` int(11) NOT NULL DEFAULT '0',
    `flag` int(11) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `groups`
  --
  
  CREATE TABLE `groups` (
    `id` mediumint(8) UNSIGNED NOT NULL,
    `name` varchar(20) NOT NULL,
    `description` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `groups`
  --
  
  INSERT INTO `groups` (`id`, `name`, `description`) VALUES
  (1, 'Student', 'Student Users Group'),
  (2, 'Illuminati', 'Illuminati users group'),
  (3, 'Company', 'Company Users group');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `jobs`
  --
  
  CREATE TABLE `jobs` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `description` text NOT NULL,
    `skills` varchar(255) NOT NULL,
    `min_salary` int(11) NOT NULL,
    `max_salary` int(11) NOT NULL,
    `city` varchar(255) NOT NULL,
    `state` varchar(255) NOT NULL,
    `country` varchar(255) NOT NULL,
    `location` varchar(100) NOT NULL,
    `latitude` decimal(10,6) NOT NULL,
    `longitude` decimal(10,6) NOT NULL,
    `phone` int(11) NOT NULL,
    `active` int(11) NOT NULL DEFAULT '1',
    `flag` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `jobs`
  --
  
  INSERT INTO `jobs` (`id`, `user_id`, `title`, `description`, `skills`, `min_salary`, `max_salary`, `city`, `state`, `country`, `location`, `latitude`, `longitude`, `phone`, `active`, `flag`, `created_at`) VALUES
  (1, 1, 'Android developer', 'We are looking for the android app developer and designer.', 'Android', 2500, 3000, 'Rajkot', 'Gujarat', '', '', '22.403708', '70.802627', 132456798, 1, 0, '2017-10-16 04:27:40'),
  (2, 1, 'iOS developer', 'Looking for ios developer and experience in swift and objective C', 'iOS', 5000, 6000, 'Rajkot', 'Gujarat', '', '', '22.303895', '70.802160', 101010111, 1, 0, '2017-10-16 04:27:44'),
  (3, 1, 'iPhone App', 'Looking for iPhone developer near here.', 'Swift,iOS App Designing,iOS', 5000, 6000, 'Rajkot', 'Gujarat', '', '', '22.203895', '70.802160', 123465798, 1, 0, '2017-10-16 04:27:47'),
  (4, 1, 'PHP developer needed', 'Hello, Please find more job information  at.  https://jobs.github.com/positions/c62c9822-afb4-11e7-98ea-746cca247aa4 ', 'Android, iOS', 50000, 60000, 'Rajkot', 'Gujarat', '', '', '22.299940', '70.806367', 13456846, 1, 0, '2017-10-16 04:39:57');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `jobs_applications`
  --
  
  CREATE TABLE `jobs_applications` (
    `id` int(11) NOT NULL,
    `job_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `document_url` varchar(255) NOT NULL,
    `status` int(11) NOT NULL DEFAULT '1' COMMENT '1-Apply, 2-Cancel',
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `job_saved`
  --
  
  CREATE TABLE `job_saved` (
    `id` int(11) NOT NULL,
    `job_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `login_attempts`
  --
  
  CREATE TABLE `login_attempts` (
    `id` int(11) UNSIGNED NOT NULL,
    `ip_address` varchar(15) NOT NULL,
    `login` varchar(100) NOT NULL,
    `time` int(11) UNSIGNED DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `messages`
  --
  
  CREATE TABLE `messages` (
    `id` int(11) NOT NULL,
    `from_id` int(11) NOT NULL,
    `group_id` int(11) NOT NULL DEFAULT '0',
    `to_id` int(11) NOT NULL,
    `message` text NOT NULL,
    `media` varchar(255) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `messages_group`
  --
  
  CREATE TABLE `messages_group` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `messages_group_members`
  --
  
  CREATE TABLE `messages_group_members` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `group_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `skills`
  --
  
  CREATE TABLE `skills` (
    `id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `description` varchar(255) NOT NULL DEFAULT ''
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `skills`
  --
  
  INSERT INTO `skills` (`id`, `name`, `description`) VALUES
  (1, 'Android', ''),
  (2, 'iOS', ''),
  (3, 'Objective C', ''),
  (4, 'C++', ''),
  (5, 'HTML', ''),
  (6, 'CSS', ''),
  (7, 'CodeIgniter', ''),
  (8, 'Ruby', ''),
  (9, 'iOS App Designing', ''),
  (10, 'Swift', ''),
  (11, 'Python', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) UNSIGNED NOT NULL,
    `sign_in_type` int(11) NOT NULL DEFAULT '1' COMMENT '1-SignUp, 2-FB, 3-Twit, 4-G, 5-LinkIn',
    `user_type` int(11) NOT NULL DEFAULT '1' COMMENT '1- Student, 2-Illuminaty, 3-Company',
    `ip_address` varchar(15) NOT NULL,
    `username` varchar(100) DEFAULT NULL,
    `password` varchar(255) NOT NULL,
    `gcm_token` varchar(255) NOT NULL,
    `profile_url` varchar(255) NOT NULL,
    `website` varchar(255) NOT NULL,
    `email` varchar(100) NOT NULL,
    `first_name` varchar(50) DEFAULT NULL,
    `last_name` varchar(50) DEFAULT NULL,
    `company` varchar(100) DEFAULT NULL,
    `phone` varchar(20) DEFAULT NULL,
    `about` text NOT NULL,
    `city` varchar(125) NOT NULL,
    `state` varchar(125) NOT NULL,
    `country` varchar(125) NOT NULL,
    `zip` varchar(11) NOT NULL DEFAULT '',
    `address` varchar(255) NOT NULL,
    `location` varchar(255) NOT NULL,
    `latitude` double(10,6) NOT NULL,
    `longitude` double(10,6) NOT NULL,
    `collage_name` varchar(255) NOT NULL,
    `collage_year` varchar(5) NOT NULL,
    `salt` varchar(255) DEFAULT NULL,
    `remember_code` varchar(40) DEFAULT NULL,
    `activation_code` varchar(40) DEFAULT NULL,
    `last_login` int(11) UNSIGNED DEFAULT NULL,
    `forgotten_password_code` varchar(40) DEFAULT NULL,
    `forgotten_password_time` int(11) UNSIGNED DEFAULT NULL,
    `active` tinyint(1) UNSIGNED DEFAULT NULL,
    `created_on` int(11) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `sign_in_type`, `user_type`, `ip_address`, `username`, `password`, `gcm_token`, `profile_url`, `website`, `email`, `first_name`, `last_name`, `company`, `phone`, `about`, `city`, `state`, `country`, `zip`, `address`, `location`, `latitude`, `longitude`, `collage_name`, `collage_year`, `salt`, `remember_code`, `activation_code`, `last_login`, `forgotten_password_code`, `forgotten_password_time`, `active`, `created_on`) VALUES
  (1, 1, 3, '127.0.0.1', '', '$2y$08$s5QNCYJZ4n2J3M7POrHxmeIy0sMQLBaVBxpvTRp9O3XjOgNnyIAAO', 'cZTNfighefA:APA91bGSJ4KBsbsG_qEfGg7r7ok8IQljnx7WtP_HlXNXMmIMOvhmaIIr-epDmr8rYa6b6USTgvgOq7bKCGurLAJ-su7aC6RY9uOYamLmMzs2xi6UH4TFk-ECTA8wN0c4J0AI5gri4Gzk', '', '', 'jamariya@jamariya.com', 'jamariya', 'raju', 'Android company', '1324567890', '', '', '', '', '', '', '', 0.000000, 0.000000, '', '', NULL, NULL, '', 2017, NULL, NULL, 1, 1508128018),
  (2, 1, 2, '127.0.0.1', '', '$2y$08$TKRXM7XMuihOjz2q2IfzJura6K4vD4wSvkrIHFNHl693Oj0yVGJU.', 'cZTNfighefA:APA91bGSJ4KBsbsG_qEfGg7r7ok8IQljnx7WtP_HlXNXMmIMOvhmaIIr-epDmr8rYa6b6USTgvgOq7bKCGurLAJ-su7aC6RY9uOYamLmMzs2xi6UH4TFk-ECTA8wN0c4J0AI5gri4Gzk', '', '', 'btech@mail.com', 'Raj', 'Jack', '', '1234657890', '', '', '', '', '', '', '', 0.000000, 0.000000, 'btech', '2000', NULL, NULL, '', 2017, NULL, NULL, 1, 1508130193);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users_authentication`
  --
  
  CREATE TABLE `users_authentication` (
    `id` int(11) NOT NULL,
    `users_id` int(11) NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `expired_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `users_authentication`
  --
  
  INSERT INTO `users_authentication` (`id`, `users_id`, `token`, `expired_at`) VALUES
  (1, 1, 'fbd2367b610709a34ef4', '2017-10-16 12:56:58'),
  (2, 1, '67baaa05759c5f8da208', '2017-10-16 13:14:02'),
  (3, 1, 'c6b8c8d762da15fa8dbb', '2017-10-16 13:30:14'),
  (4, 2, 'da5e8bfed9bdb84595be', '2017-10-16 13:33:13'),
  (5, 2, 'bbcbff5c1f1ded46c25d', '2017-10-16 13:39:23');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users_certificates`
  --
  
  CREATE TABLE `users_certificates` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `description` text NOT NULL,
    `year` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users_experience`
  --
  
  CREATE TABLE `users_experience` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `name` varchar(255) NOT NULL,
    `start_month` varchar(25) NOT NULL,
    `start_year` varchar(25) NOT NULL,
    `end_month` varchar(25) NOT NULL,
    `end_year` varchar(25) NOT NULL,
    `company_id` int(11) NOT NULL DEFAULT '0',
    `company` varchar(255) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users_groups`
  --
  
  CREATE TABLE `users_groups` (
    `id` int(11) UNSIGNED NOT NULL,
    `user_id` int(11) UNSIGNED NOT NULL,
    `group_id` mediumint(8) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `users_groups`
  --
  
  INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
  (1, 1, 3),
  (2, 2, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users_skills`
  --
  
  CREATE TABLE `users_skills` (
    `id` int(11) NOT NULL,
    `skill_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `admin_groups`
  --
  ALTER TABLE `admin_groups`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `admin_login_attempts`
  --
  ALTER TABLE `admin_login_attempts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `admin_users`
  --
  ALTER TABLE `admin_users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `admin_users_groups`
  --
  ALTER TABLE `admin_users_groups`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `api_access`
  --
  ALTER TABLE `api_access`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `api_keys`
  --
  ALTER TABLE `api_keys`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `api_limits`
  --
  ALTER TABLE `api_limits`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `api_logs`
  --
  ALTER TABLE `api_logs`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `app_settings`
  --
  ALTER TABLE `app_settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `company_review`
  --
  ALTER TABLE `company_review`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `groups`
  --
  ALTER TABLE `groups`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `jobs`
  --
  ALTER TABLE `jobs`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `jobs_applications`
  --
  ALTER TABLE `jobs_applications`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `job_id` (`job_id`,`user_id`);
  
  --
  -- Indexes for table `job_saved`
  --
  ALTER TABLE `job_saved`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `job_id` (`job_id`,`user_id`);
  
  --
  -- Indexes for table `login_attempts`
  --
  ALTER TABLE `login_attempts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `messages`
  --
  ALTER TABLE `messages`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `messages_group`
  --
  ALTER TABLE `messages_group`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `messages_group_members`
  --
  ALTER TABLE `messages_group_members`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `skills`
  --
  ALTER TABLE `skills`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users_authentication`
  --
  ALTER TABLE `users_authentication`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users_certificates`
  --
  ALTER TABLE `users_certificates`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users_experience`
  --
  ALTER TABLE `users_experience`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users_groups`
  --
  ALTER TABLE `users_groups`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users_skills`
  --
  ALTER TABLE `users_skills`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `admin_groups`
  --
  ALTER TABLE `admin_groups`
    MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `admin_login_attempts`
  --
  ALTER TABLE `admin_login_attempts`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `admin_users`
  --
  ALTER TABLE `admin_users`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `admin_users_groups`
  --
  ALTER TABLE `admin_users_groups`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `api_access`
  --
  ALTER TABLE `api_access`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `api_keys`
  --
  ALTER TABLE `api_keys`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `api_limits`
  --
  ALTER TABLE `api_limits`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `api_logs`
  --
  ALTER TABLE `api_logs`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `app_settings`
  --
  ALTER TABLE `app_settings`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `company_review`
  --
  ALTER TABLE `company_review`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `groups`
  --
  ALTER TABLE `groups`
    MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `jobs`
  --
  ALTER TABLE `jobs`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `jobs_applications`
  --
  ALTER TABLE `jobs_applications`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `job_saved`
  --
  ALTER TABLE `job_saved`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `login_attempts`
  --
  ALTER TABLE `login_attempts`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `messages`
  --
  ALTER TABLE `messages`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `messages_group`
  --
  ALTER TABLE `messages_group`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `messages_group_members`
  --
  ALTER TABLE `messages_group_members`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `skills`
  --
  ALTER TABLE `skills`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `users_authentication`
  --
  ALTER TABLE `users_authentication`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `users_certificates`
  --
  ALTER TABLE `users_certificates`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `users_experience`
  --
  ALTER TABLE `users_experience`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `users_groups`
  --
  ALTER TABLE `users_groups`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `users_skills`
  --
  ALTER TABLE `users_skills`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  