-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 13, 2025 at 02:28 PM
-- Server version: 5.7.23-23
-- PHP Version: 8.1.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `apptebjs_demo`
--

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `category` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category`, `image`, `created_at`) VALUES
(17, 'Restaurant', '8682293b397f364a5ff66902c65fd299.png', '2024-11-05 10:30:44'),
(18, 'Medical', '04acb8724cafaceffdd868ee910b1a31.png', '2024-11-05 10:31:16'),
(19, 'Design', '99f64a665c8d9bcb14a582e702ee6be3.png', '2024-11-05 10:32:02'),
(20, 'Information Technology', '20035defd415edb932d715f0e992be7c.png', '2024-11-05 10:32:33'),
(21, 'Finance', '353f84eeb3198d3281d8804d26806f8c.png', '2024-11-05 10:33:41'),
(22, 'Education', '769bd53cf2138f4b4a1feee87b32108e.png', '2024-11-05 10:34:01');

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

--
-- Table structure for table `chat_user`
--

CREATE TABLE `chat_user` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `chat_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sendername` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `receivername` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `senderimg` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `receiverimg` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `job_location`
--

CREATE TABLE `job_location` (
  `id` int(11) NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `job_location`
--

INSERT INTO `job_location` (`id`, `city`, `created_at`) VALUES
(1, 'Türkiye', '2024-08-13 18:22:16'),
(2, 'Frankfurt', '2024-08-16 17:52:43');

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

--
-- Table structure for table `job_save`
--

CREATE TABLE `job_save` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `minimum_charges`
--

CREATE TABLE `minimum_charges` (
  `id` int(11) NOT NULL,
  `bike` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `car` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `other` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `truck` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gst` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `driver_percentage` int(11) NOT NULL,
  `status_show_hide` int(11) NOT NULL,
  `radius` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `minimum_charges`
--

INSERT INTO `minimum_charges` (`id`, `bike`, `car`, `other`, `truck`, `gst`, `currency`, `driver_percentage`, `status_show_hide`, `radius`) VALUES
(1, '5', '10', '12', '20', '10', '₹', 10, 1, 200);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `order_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `category` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `subcategory` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `long` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `established_in` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `salary` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `job_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `requirement` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `pickup_comapny_name` varchar(100) NOT NULL,
  `dropoff_comapny_name` varchar(255) NOT NULL,
  `pickup_first_name` varchar(100) NOT NULL,
  `pickup_last_name` varchar(255) NOT NULL,
  `pickup_mob_number` varchar(15) NOT NULL,
  `pickup_building_type` varchar(255) NOT NULL,
  `pickup_elevator` varchar(255) NOT NULL,
  `pickup_floor` varchar(255) NOT NULL,
  `pickup_person` varchar(255) NOT NULL,
  `drop_building_type` varchar(255) NOT NULL,
  `drop_elevator` varchar(255) NOT NULL,
  `drop_floor` varchar(255) NOT NULL,
  `drop_person` varchar(255) NOT NULL,
  `pickup_landline_number` varchar(15) NOT NULL,
  `pickupaddress` varchar(255) NOT NULL,
  `dropoffaddress` varchar(255) NOT NULL,
  `pickup_unit_number` varchar(255) NOT NULL,
  `pickup_house_number` varchar(255) NOT NULL,
  `pickup_street_name` varchar(255) NOT NULL,
  `pickup_street_suff` varchar(255) NOT NULL,
  `pickup_suburb` varchar(255) NOT NULL,
  `pickup_state` varchar(255) NOT NULL,
  `pickup_postcode` varchar(255) NOT NULL,
  `pickup_country` varchar(255) NOT NULL,
  `item_description` varchar(255) NOT NULL,
  `item_quantity` varchar(255) NOT NULL,
  `delivery_date` varchar(255) NOT NULL,
  `pickup_special_inst` varchar(255) NOT NULL,
  `dropoff_first_name` varchar(255) NOT NULL,
  `dropoff_last_name` varchar(255) NOT NULL,
  `dropoff_mob_number` varchar(255) NOT NULL,
  `dropoff_landline_number` varchar(255) NOT NULL,
  `dropoff_special_inst` varchar(255) NOT NULL,
  `dropoff_unit_number` varchar(255) NOT NULL,
  `dropoff_house_number` varchar(255) NOT NULL,
  `dropoff_stree_name` varchar(255) NOT NULL,
  `dropoff_street_suff` varchar(255) NOT NULL,
  `dropoff_suburb` varchar(255) NOT NULL,
  `dropoff_state` varchar(255) NOT NULL,
  `dropoff_postcode` varchar(255) NOT NULL,
  `dropoff_country` varchar(255) NOT NULL,
  `parcel_height` varchar(255) NOT NULL,
  `parcel_width` varchar(255) NOT NULL,
  `parcel_lenght` varchar(255) NOT NULL,
  `parcel_weight` varchar(255) NOT NULL,
  `delivery_distance` varchar(255) NOT NULL,
  `delivery_duration` varchar(255) NOT NULL,
  `delivery_time_duration` varchar(10) NOT NULL DEFAULT '2',
  `delivery_time` varchar(255) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'No',
  `pickup_lat` varchar(60) NOT NULL,
  `pickup_long` varchar(60) NOT NULL,
  `dropoff_lat` varchar(60) NOT NULL,
  `dropoff_long` varchar(60) NOT NULL,
  `pickup_country_code` varchar(255) NOT NULL,
  `dropoff_country_code` varchar(255) NOT NULL,
  `driver_id` int(11) DEFAULT '0',
  `driver_delivery_cost` varchar(255) NOT NULL,
  `signature_image` text NOT NULL,
  `signature_name` varchar(255) NOT NULL,
  `received_user_image` text NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `delivery_status` tinyint(4) NOT NULL COMMENT '1 =pending 2 = confirmed, 3= canceled, 4= delivered,5=paid,6=picked,7=accepted,8=reportproblem',
  `delivery_cost` varchar(10) NOT NULL DEFAULT '0',
  `vehicle_type` varchar(100) DEFAULT NULL,
  `delivery_type` varchar(100) DEFAULT NULL,
  `shop_name` varchar(255) NOT NULL,
  `shop_address` varchar(255) NOT NULL,
  `shop_exp_price` varchar(255) NOT NULL,
  `shop_item_description` text NOT NULL,
  `shop_item_quantity` varchar(255) NOT NULL,
  `cancel_status` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` varchar(255) NOT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_received`
--

CREATE TABLE `payment_received` (
  `id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `paid` int(11) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `payout`
--

CREATE TABLE `payout` (
  `id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `productimage`
--

CREATE TABLE `productimage` (
  `pro_id` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `product_image` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `promocode`
--

CREATE TABLE `promocode` (
  `promo_id` int(11) NOT NULL,
  `coupon` varchar(250) NOT NULL,
  `coupon_image` varchar(250) NOT NULL,
  `percentage` varchar(250) NOT NULL,
  `title` varchar(255) NOT NULL,
  `detail` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promocode`
--

INSERT INTO `promocode` (`promo_id`, `coupon`, `coupon_image`, `percentage`, `title`, `detail`) VALUES
(7, 'App2024', '', '10', 'hh', 'Discount for delivery ');

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

--
-- Table structure for table `promocode_apply`
--

CREATE TABLE `promocode_apply` (
  `apply_id` int(10) NOT NULL,
  `coupon` varchar(50) NOT NULL,
  `user_id` int(10) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL,
  `category` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `subcategory` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`id`, `category`, `subcategory`, `created_at`) VALUES
(1, 'Design', 'UI/UX Design', '2024-05-09 06:25:46'),
(2, 'Finance', 'CA', '2024-05-09 06:25:46'),
(3, 'Education', 'BE', '2024-05-09 06:25:46'),
(4, 'Restaurent', 'Manager', '2024-05-09 06:25:46'),
(5, 'Health', 'MD', '2024-05-09 06:25:46'),
(6, 'Programmer', 'Flutter', '2024-05-09 06:25:46');

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

--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `id` int(11) NOT NULL,
  `duration` varchar(50) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `expiry` varchar(255) NOT NULL,
  `expiry_str` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subscription`
--

INSERT INTO `subscription` (`id`, `duration`, `amount`, `expiry`, `expiry_str`, `created_date`) VALUES
(9, '1 Month', '120', '', '', '2024-09-18 09:54:14'),
(11, '3 months', '200', '', '', '2024-10-25 11:07:43'),
(12, '6 Months', '500', '', '', '2024-10-25 11:07:56');

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

--
-- Table structure for table `subscription_for_apply`
--

CREATE TABLE `subscription_for_apply` (
  `id` int(11) NOT NULL,
  `duration` varchar(50) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subscription_for_apply`
--

INSERT INTO `subscription_for_apply` (`id`, `duration`, `amount`, `created_date`) VALUES
(4, '1 month', '40', '2024-09-06 07:34:52'),
(5, '3 months', '90', '2024-09-06 07:35:11'),
(6, '4 Month', '80', '2024-09-09 05:26:47'),
(7, '6 month', '60', '2024-09-09 05:26:47');

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

--
-- Table structure for table `subscription_user`
--

CREATE TABLE `subscription_user` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `duration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiry_str` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `subscription_user_apply`
--

CREATE TABLE `subscription_user_apply` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `duration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiry_str` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tbl_chat`
--

CREATE TABLE `tbl_chat` (
  `chat_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `lastmessage` varchar(255) NOT NULL,
  `image` text NOT NULL,
  `unreadchat` bigint(50) NOT NULL,
  `totalmessagecount` bigint(50) NOT NULL,
  `messageseen` int(11) NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(11) NOT NULL,
  `otp` varchar(255) NOT NULL,
  `verifystatus` int(11) NOT NULL,
  `online_status` int(11) NOT NULL,
  `device_token` varchar(255) NOT NULL,
  `social_id` varchar(255) NOT NULL,
  `social_type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `address` text NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `resume` varchar(255) NOT NULL,
  `date_of_birth` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1=admin,0=other',
  `user_status` int(11) NOT NULL COMMENT '1=active,2=inactive',
  `user_type` int(11) NOT NULL COMMENT '1=customer,2=delivery_boy',
  `profile_image` text NOT NULL,
  `device_type` enum('ios','android') NOT NULL,
  `admin_type` enum('super','normal') NOT NULL DEFAULT 'normal',
  `chatonline` int(11) NOT NULL,
  `login_status` varchar(255) NOT NULL DEFAULT 'yes' COMMENT '"yes=login","no=logout"',
  `forget_timestamp` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `month` varchar(255) NOT NULL
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_apply_on_job`
--

CREATE TABLE `user_apply_on_job` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `job_id` int(11) NOT NULL,
  `job_cv` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `information` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `work_experience`
--

CREATE TABLE `work_experience` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `job_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `start_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `end_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `currently_working` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`order_id`);

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

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

--
-- Indexes for table `productimage`
--
ALTER TABLE `productimage`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `promocode`
--
ALTER TABLE `promocode`
  ADD PRIMARY KEY (`promo_id`);

--
-- Indexes for table `promocode_apply`
--
ALTER TABLE `promocode_apply`
  ADD PRIMARY KEY (`apply_id`);

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

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

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

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

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

--
-- Indexes for table `tbl_chat`
--
ALTER TABLE `tbl_chat`
  ADD PRIMARY KEY (`chat_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`user_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `chat_user`
--
ALTER TABLE `chat_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `job_save`
--
ALTER TABLE `job_save`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order`
--
ALTER TABLE `order`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_received`
--
ALTER TABLE `payment_received`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payout`
--
ALTER TABLE `payout`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `productimage`
--
ALTER TABLE `productimage`
  MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `promocode`
--
ALTER TABLE `promocode`
  MODIFY `promo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `promocode_apply`
--
ALTER TABLE `promocode_apply`
  MODIFY `apply_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subcategory`
--
ALTER TABLE `subcategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `subscription`
--
ALTER TABLE `subscription`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `subscription_for_apply`
--
ALTER TABLE `subscription_for_apply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `subscription_user`
--
ALTER TABLE `subscription_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription_user_apply`
--
ALTER TABLE `subscription_user_apply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_chat`
--
ALTER TABLE `tbl_chat`
  MODIFY `chat_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_apply_on_job`
--
ALTER TABLE `user_apply_on_job`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_experience`
--
ALTER TABLE `work_experience`
  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 */;
