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

START TRANSACTION;



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

--
-- Table structure for table `dispatch_failed`
--

CREATE TABLE `dispatch_failed` (
  `id` int(255) NOT NULL,
  `pickup_failed` varchar(255) NOT NULL,
  `deliver_failed` varchar(255) NOT NULL,
  `discription_failed` varchar(255) NOT NULL,
  `create_datetime` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `dispatch_success`
--

CREATE TABLE `dispatch_success` (
  `id` int(255) NOT NULL,
  `pickup` varchar(255) NOT NULL,
  `deliver` varchar(255) NOT NULL,
  `discription` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `create_datetime` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `ondemand_order`
--

CREATE TABLE `ondemand_order` (
  `id` int(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `daddress` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zipcode` varchar(255) NOT NULL,
  `numbers` varchar(255) NOT NULL,
  `language` varchar(255) NOT NULL,
  `dinstruct` varchar(255) NOT NULL,
  `rxnumber` varchar(255) NOT NULL,
  `section` varchar(255) NOT NULL,
  `assign` varchar(255) NOT NULL,
  `create_datetime` date NOT NULL,
  `success_order` varchar(255) NOT NULL,
  `success_deliver` varchar(255) NOT NULL,
  `success_discription` varchar(255) NOT NULL,
  `delivery_status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ondemand_order`
--

INSERT INTO `ondemand_order` (`id`, `fname`, `lname`, `dob`, `daddress`, `city`, `state`, `zipcode`, `numbers`, `language`, `dinstruct`, `rxnumber`, `section`, `assign`, `create_datetime`, `success_order`, `success_deliver`, `success_discription`, `delivery_status`) VALUES
(1, 'marius', 'Acolatse ', '2002-01-07', 'south', 'portland', 'OR', '907080', '58813543', '', 'goog good excellent ', '979649469', 'ondemand', 'sena01', '2021-06-07', 'Yes', 'Yes', 'w2vebjwhkldl/zcmtegh', 'Success');

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

--
-- Table structure for table `sameday_order`
--

CREATE TABLE `sameday_order` (
  `id` int(255) NOT NULL,
  `fname` varchar(225) NOT NULL,
  `lname` varchar(225) NOT NULL,
  `dob` varchar(225) NOT NULL,
  `daddress` varchar(225) NOT NULL,
  `city` varchar(225) NOT NULL,
  `state` varchar(225) NOT NULL,
  `zipcode` varchar(225) NOT NULL,
  `numbers` varchar(225) NOT NULL,
  `language` varchar(225) NOT NULL,
  `dinstruct` varchar(225) NOT NULL,
  `rxnumber` varchar(225) NOT NULL,
  `section` varchar(225) NOT NULL,
  `assign` varchar(255) NOT NULL,
  `create_datetime` date NOT NULL,
  `success_order` varchar(255) NOT NULL,
  `success_deliver` varchar(255) NOT NULL,
  `success_discription` varchar(255) NOT NULL,
  `delivery_status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sameday_order`
--

INSERT INTO `sameday_order` (`id`, `fname`, `lname`, `dob`, `daddress`, `city`, `state`, `zipcode`, `numbers`, `language`, `dinstruct`, `rxnumber`, `section`, `assign`, `create_datetime`, `success_order`, `success_deliver`, `success_discription`, `delivery_status`) VALUES
(1, 'kofi', 'yaw', '2017-01-07', 'south', 'portland', 'OR', '907080', '58813543', '', 'good condition', '5469494949494#*', 'sameday', 'sena01', '2021-06-07', 'Yes', '07/06/2021', 'qwertyqwertyqwerty', 'Success');

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

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

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

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

--
-- AUTO_INCREMENT for table `dispatch_failed`
--
ALTER TABLE `dispatch_failed`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dispatch_success`
--
ALTER TABLE `dispatch_success`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `sameday_order`
--
ALTER TABLE `sameday_order`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

