-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `vgu`
--

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) NOT NULL,
  `node_id` bigint(20) NOT NULL,
  `data` longtext NOT NULL,
  `node` varchar(100) NOT NULL,
  `action` enum('update','delete') NOT NULL,
  `created_by` int(10) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `node_id`, `data`, `node`, `action`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, '{\"id\":1,\"name\":\"Rajasthan\",\"slug\":\"rajasthan\",\"status\":\"active\",\"created_at\":\"2025-06-12T06:38:08.000000Z\",\"updated_at\":\"2025-06-12T06:38:08.000000Z\"}', 'state', 'update', 1, '2025-06-12 06:39:32', '2025-06-12 06:39:32'),
(2, 1, '{\"id\":1,\"name\":\"Rajasthana\",\"slug\":\"rajasthan\",\"status\":\"active\",\"created_at\":\"2025-06-12T06:38:08.000000Z\",\"updated_at\":\"2025-06-12T06:39:32.000000Z\"}', 'state', 'update', 1, '2025-06-12 06:39:41', '2025-06-12 06:39:41'),
(3, 2, '{\"id\":2,\"name\":\"Test2\",\"status\":\"active\",\"created_at\":\"2025-06-12T06:57:04.000000Z\",\"updated_at\":\"2025-06-12T06:57:04.000000Z\"}', 'offering', 'update', 1, '2025-06-12 07:01:19', '2025-06-12 07:01:19'),
(4, 2, '{\"id\":2,\"name\":\"Test90\",\"status\":\"active\",\"created_at\":\"2025-06-12T06:57:04.000000Z\",\"updated_at\":\"2025-06-12T07:01:19.000000Z\"}', 'offering', 'update', 1, '2025-06-12 07:01:29', '2025-06-12 07:01:29'),
(5, 2, '{\"id\":2,\"name\":\"Test100\",\"status\":\"active\",\"created_at\":\"2025-06-12T06:57:04.000000Z\",\"updated_at\":\"2025-06-12T07:01:29.000000Z\"}', 'offering', 'update', 1, '2025-06-12 07:01:34', '2025-06-12 07:01:34'),
(6, 2, '{\"id\":2,\"name\":\"Test2\",\"status\":\"inactive\",\"created_at\":\"2025-06-12T07:11:52.000000Z\",\"updated_at\":\"2025-06-12T07:11:52.000000Z\"}', 'partnertype', 'update', 1, '2025-06-12 07:13:21', '2025-06-12 07:13:21'),
(7, 2, '{\"id\":2,\"name\":\"Test20\",\"status\":\"inactive\",\"created_at\":\"2025-06-12T07:11:52.000000Z\",\"updated_at\":\"2025-06-12T07:13:21.000000Z\"}', 'partnertype', 'update', 1, '2025-06-12 07:13:25', '2025-06-12 07:13:25'),
(8, 1, '{\"id\":1,\"name\":\"Test\",\"status\":\"inactive\",\"created_at\":\"2025-06-12T07:24:04.000000Z\",\"updated_at\":\"2025-06-12T07:24:04.000000Z\"}', 'programtype', 'update', 1, '2025-06-12 07:25:49', '2025-06-12 07:25:49'),
(9, 1, '{\"id\":1,\"name\":\"Test123\",\"status\":\"inactive\",\"created_at\":\"2025-06-12T07:24:04.000000Z\",\"updated_at\":\"2025-06-12T07:25:49.000000Z\"}', 'programtype', 'update', 1, '2025-06-12 07:25:52', '2025-06-12 07:25:52'),
(10, 1, '{\"id\":1,\"name\":\"Test\",\"status\":\"active\",\"created_at\":\"2025-06-12T07:33:09.000000Z\",\"updated_at\":\"2025-06-12T07:33:09.000000Z\"}', 'sector', 'update', 1, '2025-06-12 07:34:32', '2025-06-12 07:34:32'),
(11, 1, '{\"id\":1,\"name\":\"Test\",\"designation\":\"Test\",\"organization\":\"Test\",\"summary\":\"Test\",\"linkedin\":\"Test\",\"city_id\":1,\"state_id\":1,\"sectors\":null,\"status\":\"active\",\"created_at\":\"2025-06-12T08:01:46.000000Z\",\"updated_at\":\"2025-06-12T08:01:46.000000Z\"}', 'mentor', 'update', 1, '2025-06-12 08:46:29', '2025-06-12 08:46:29'),
(12, 1, '{\"id\":1,\"state_id\":1,\"name\":\"Jaipur\",\"slug\":\"jaipur\",\"status\":\"active\",\"created_at\":\"2025-06-20T09:45:46.000000Z\",\"updated_at\":\"2025-06-20T09:45:46.000000Z\"}', 'city', 'update', 1, '2025-06-20 09:46:54', '2025-06-20 09:46:54'),
(13, 1, '{\"id\":1,\"state_id\":1,\"name\":\"JaipurA\",\"slug\":\"jaipur\",\"status\":\"active\",\"created_at\":\"2025-06-20T09:45:46.000000Z\",\"updated_at\":\"2025-06-20T09:46:54.000000Z\"}', 'city', 'update', 1, '2025-06-20 09:47:01', '2025-06-20 09:47:01');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` int(10) NOT NULL,
  `state_id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `state_id`, `name`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Jaipur', 'jaipur', 'active', '2025-06-20 10:17:26', '2025-06-20 10:17:26');

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

--
-- Table structure for table `expertise`
--

CREATE TABLE `expertise` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `expertise`
--

INSERT INTO `expertise` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Sector A', 'active', '2025-06-20 09:49:27', '2025-06-20 09:49:27'),
(2, 'Sector B', 'active', '2025-06-20 09:49:27', '2025-06-20 09:49:27');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mentors`
--

CREATE TABLE `mentors` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `designation` varchar(191) NOT NULL,
  `organization` varchar(191) NOT NULL,
  `summary` text NOT NULL,
  `linkedin` varchar(191) DEFAULT NULL,
  `city_id` int(10) NOT NULL,
  `state_id` int(10) NOT NULL,
  `sectors` text DEFAULT NULL,
  `expertise` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mentors`
--

INSERT INTO `mentors` (`id`, `name`, `image`, `designation`, `organization`, `summary`, `linkedin`, `city_id`, `state_id`, `sectors`, `expertise`, `status`, `created_at`, `updated_at`) VALUES
(3, 'cxvvcx', 'mentors/mentor_1ae55410-8e9e-4b3e-904b-13d3190515dc.jpg', 'xcv', 'xcvcxv', 'xcvxcv', 'https://www.youtube.com', 1, 1, '1', NULL, 'active', '2025-06-27 01:45:22', '2025-06-27 07:18:27'),
(4, 'te', 'mentors/mentor_067b2981-e07b-418f-b51d-914acbfeeb8c.jpg', 'er', 'dfsf', 'dsf', NULL, 1, 1, '1, 2', NULL, 'active', '2025-06-27 05:53:46', '2025-06-27 05:57:08');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1);

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

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Offering Type A', 'active', '2025-06-20 09:47:48', '2025-06-20 09:47:48');

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `partnertype_id` int(10) NOT NULL,
  `website` varchar(191) NOT NULL,
  `summary` text NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `name`, `image`, `partnertype_id`, `website`, `summary`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Test', NULL, 1, 'Test', 'Test', 'active', '2025-06-12 08:43:39', '2025-06-12 08:43:39'),
(2, 'dfgdfg vv', 'partners/partner_2a544db0-7812-4ba7-ad0f-38f69ae44f5c.jpg', 1, 'https://adityauniversity.in/', 'dfgdfg', 'active', '2025-06-26 11:12:55', '2025-06-26 11:28:51');

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

--
-- Table structure for table `partnertypes`
--

CREATE TABLE `partnertypes` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `partnertypes`
--

INSERT INTO `partnertypes` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Partner Type A', 'active', '2025-06-20 09:48:22', '2025-06-20 09:48:22');

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

--
-- Table structure for table `programs`
--

CREATE TABLE `programs` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `programtype_id` int(10) NOT NULL,
  `summary` text NOT NULL,
  `eligibility` text NOT NULL,
  `duration` varchar(191) NOT NULL,
  `mode` enum('online','offline','hybrid') NOT NULL,
  `offerings` text DEFAULT NULL,
  `link` varchar(191) NOT NULL,
  `partner_id` int(10) NOT NULL,
  `program_dates` varchar(191) NOT NULL,
  `program_start_date` date DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`id`, `name`, `image`, `programtype_id`, `summary`, `eligibility`, `duration`, `mode`, `offerings`, `link`, `partner_id`, `program_dates`, `program_start_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 'dsfs vvv', 'programs/program_9992cb71-46e3-4983-a99b-e38a63ac68e4.jpg', 1, 'fsfsdf', 'sdfdsf', 'dfsf', 'online', '1', 'https://example.com', 2, 'xdfd', '2025-06-29', 'active', '2025-06-27 01:34:41', '2025-06-27 01:58:35');

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

--
-- Table structure for table `programtypes`
--

CREATE TABLE `programtypes` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `programtypes`
--

INSERT INTO `programtypes` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Program Type A', 'active', '2025-06-20 09:48:57', '2025-06-20 09:48:57');

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

--
-- Table structure for table `sectors`
--

CREATE TABLE `sectors` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sectors`
--

INSERT INTO `sectors` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Sector A', 'active', '2025-06-20 09:49:27', '2025-06-20 09:49:27'),
(2, 'Sector B', 'active', '2025-06-20 09:49:27', '2025-06-20 09:49:27');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('1424ftUCHlw0aSF7O3eJ9jWxY7rSmGQks8zkFR8X', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVjFUaTNhWXAxWXg5Z2p5NjUwcFlZYUg3NGM1YTNseDlxTEN5cWFlZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1751378456),
('7vmHkEPJ9LR28czdR21FUy4waIM5sV0qpWXdzvMS', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMHZ1T3NhYXNaWjdmdzZYSTN2NE5hUkFkYzhKb2szQnhjbEFzQUw2ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1751390230);

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

--
-- Table structure for table `startups`
--

CREATE TABLE `startups` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `founder_one` varchar(191) NOT NULL,
  `founder_two` varchar(191) DEFAULT NULL,
  `founder_three` varchar(191) DEFAULT NULL,
  `founder_four` varchar(191) DEFAULT NULL,
  `summary` text NOT NULL,
  `sector_id` int(10) NOT NULL,
  `state_id` int(10) NOT NULL,
  `city_id` int(10) NOT NULL,
  `website` varchar(191) DEFAULT NULL,
  `linkedin` varchar(191) DEFAULT NULL,
  `instagram` varchar(191) DEFAULT NULL,
  `twitter` varchar(191) DEFAULT NULL,
  `youtube` varchar(191) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `startups`
--

INSERT INTO `startups` (`id`, `name`, `image`, `founder_one`, `founder_two`, `founder_three`, `founder_four`, `summary`, `sector_id`, `state_id`, `city_id`, `website`, `linkedin`, `instagram`, `twitter`, `youtube`, `status`, `created_at`, `updated_at`) VALUES
(1, 'sdf a', 'startups/startup_08235a5b-5ae1-471a-9f04-9c98eae2badd.jpg', 'sdfsdf', 'sdfs', 'fsdf', 'sdfs', 'fsf', 1, 1, 1, 'https://adityauniversity.in/', 'https://www.youtube.com', 'https://example.com', 'https://example.com', 'https://example.com', 'active', '2025-06-26 10:03:29', '2025-06-26 10:18:29'),
(2, 'vcxvx', 'startups/startup_e313a0b4-02e4-43f8-ad25-b8ff74bfec5d.jpg', 'cvxcv', 'xcxv', 'xcvxcv', 'xvcxv', 'cxvcxv', 1, 1, 1, 'https://adityauniversity.in/', 'https://www.youtube.com', 'https://example.com', 'https://example.com', NULL, 'active', '2025-06-26 15:49:13', '2025-06-26 15:49:13');

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(10) NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Rajasthan', 'rajasthan', 'active', '2025-06-20 09:27:11', '2025-06-20 09:27:11'),
(2, 'Gujarat', 'gujarat', 'active', '2025-06-20 09:27:39', '2025-06-20 09:27:39');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `state_id` (`state_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `expertise`
--
ALTER TABLE `expertise`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mentors`
--
ALTER TABLE `mentors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offerings`
--
ALTER TABLE `offerings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `partnertypes`
--
ALTER TABLE `partnertypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `programs`
--
ALTER TABLE `programs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `programtypes`
--
ALTER TABLE `programtypes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sectors`
--
ALTER TABLE `sectors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `startups`
--
ALTER TABLE `startups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `status` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `expertise`
--
ALTER TABLE `expertise`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mentors`
--
ALTER TABLE `mentors`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `offerings`
--
ALTER TABLE `offerings`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `partnertypes`
--
ALTER TABLE `partnertypes`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `programs`
--
ALTER TABLE `programs`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `programtypes`
--
ALTER TABLE `programtypes`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sectors`
--
ALTER TABLE `sectors`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `startups`
--
ALTER TABLE `startups`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

