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

START TRANSACTION;



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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `bm_id` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`id`, `name`, `bm_id`, `address`, `city`, `status`) VALUES
(1, 'Nobat Khan', 2, 'Saddar Peshawar, Peshawar', 'Peshawar ', 0),
(4, 'C++ PROGRAMING', 2, 'Mohalla School Ghari PO Box Pabbi Khudrizi , Nowshera', 'Peshawar ', 1);

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

--
-- Table structure for table `consignee`
--

CREATE TABLE `consignee` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `pincode` int(11) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `gst_no` int(11) NOT NULL,
  `status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `consignee`
--

INSERT INTO `consignee` (`id`, `name`, `city`, `address`, `pincode`, `mobile`, `gst_no`, `status`) VALUES
(6, 'Shahid ali', 'Nowshera', 'PO Box Pabbi Khudrizi , Nowshera', 1232, '1968473', 123, 0),
(7, 'hamza', 'Peshawar', 'Attock , KPK', 1232, '1968473', 123, 1),
(8, 'hamza', 'Peshawar', 'PO Box Pabbi Khudrizi , Nowshera', 1232, '1968473', 123, 0),
(9, '', '', '', 0, '', 0, 1);

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

--
-- Table structure for table `consigner`
--

CREATE TABLE `consigner` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `pincode` int(11) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `consigner`
--

INSERT INTO `consigner` (`id`, `name`, `address`, `city`, `pincode`, `mobile`, `status`) VALUES
(1, 'Hamza Khan', 'peshawar', 'Peshawar', 1232, '1968473', 0),
(2, 'Eric Matision ', 'PO Box Pabbi Khudrizi , Nowshera', 'Peshawar', 1232, '1968473', 1);

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

--
-- Table structure for table `consignment`
--

CREATE TABLE `consignment` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `consigner_id` int(11) NOT NULL,
  `consignee_id` int(11) NOT NULL,
  `challan` varchar(255) NOT NULL,
  `challan_no` varchar(255) NOT NULL,
  `tax_payer` varchar(255) NOT NULL,
  `transpotation_mode` varchar(255) NOT NULL,
  `payment` int(11) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `picese` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `consignment`
--

INSERT INTO `consignment` (`id`, `date`, `consigner_id`, `consignee_id`, `challan`, `challan_no`, `tax_payer`, `transpotation_mode`, `payment`, `status`, `picese`, `weight`, `driver_id`) VALUES
(1, '2022-04-05', 2, 6, '1212', '122222', '123', 'sjsjs', 20000, '1', 3, 4, 2),
(2, '2022-03-29', 1, 6, '223', '122222', '123', 'sjsjs', 20000, '1', 3, 4, 2),
(3, '2022-03-29', 1, 6, '2121', '122222', '123', 'sjsjs', 20000, '1', 3, 4, 2),
(4, '2022-03-29', 1, 6, '2121', '122222', '123', 'sjsjs', 20000, '1', 3, 4, 2);

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

--
-- Table structure for table `manifest`
--

CREATE TABLE `manifest` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `vehicle_no` varchar(255) NOT NULL,
  `charge_amount` varchar(255) NOT NULL,
  `advance_pay` int(11) NOT NULL,
  `due_balance` int(11) NOT NULL,
  `remark` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `vehicle`
--

CREATE TABLE `vehicle` (
  `id` int(11) NOT NULL,
  `reg_no` varchar(255) NOT NULL,
  `vehicle_type` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `vehicle`
--

INSERT INTO `vehicle` (`id`, `reg_no`, `vehicle_type`, `model`, `company`, `status`) VALUES
(1, 'Rj-19083', 'Loder', '121', 'Honda', 0),
(3, 'Rj-190822', 'kjan', '50000029', '', 0);

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `vehicle`
--
ALTER TABLE `vehicle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

