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

START TRANSACTION;



--
-- Database: `db_sena_vibes`
--

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

--
-- Table structure for table `admin_user`
--

CREATE TABLE `admin_user` (
  `id` int(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `section` varchar(255) NOT NULL,
  `create_datetime` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_user`
--

INSERT INTO `admin_user` (`id`, `username`, `password`, `firstname`, `lastname`, `email`, `tel`, `section`, `create_datetime`) VALUES
(1, 'admin', 'admin', 'Joy', 'Kattah', 'admin@admin.com', '0541212330', 'admin', '2021-06-06');

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

--
-- 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 `driver_user`
--

CREATE TABLE `driver_user` (
  `id` int(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `create_datetime` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `driver_user`
--

INSERT INTO `driver_user` (`id`, `username`, `password`, `firstname`, `lastname`, `email`, `mobile`, `location`, `section`, `create_datetime`) VALUES
(1, 'driver', 'driver', 'Vonzy', 'Lokipoil', 'driver@driver.cpm', '0209898766', 'Maryland', 'driver', '2021-06-06'),
(2, 'sena01', '012345', 'sena', 'vibes', 'senavibes@gmail.com', '0202255071', 'south', 'driver', '2021-06-07');

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

--
-- 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 `pharmacist_user`
--

CREATE TABLE `pharmacist_user` (
  `id` int(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `businessname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phonenumber` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `section` varchar(255) NOT NULL,
  `create_datetime` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pharmacist_user`
--

INSERT INTO `pharmacist_user` (`id`, `username`, `password`, `businessname`, `email`, `phonenumber`, `location`, `section`, `create_datetime`) VALUES
(1, 'pharm', 'pharm', 'JoySel Creative', 'pharm@pharm.com', '0579876255', 'Maryland', 'pharmacist', '2021-06-06'),
(2, 'senavibes', '012345', 'senavibes', 'sena@gmail.com', '0542732233', 'osu', 'pharmacist', '2021-06-07');

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

--
-- 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 dumped tables
--

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

--
-- 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 `driver_user`
--
ALTER TABLE `driver_user`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- 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 `driver_user`
--
ALTER TABLE `driver_user`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 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 `pharmacist_user`
--
ALTER TABLE `pharmacist_user`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

