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

START TRANSACTION;



--
-- Database: `android`
--

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

--
-- Table structure for table `friday_menu_tb`
--

CREATE TABLE `friday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `friday_menu_tb`
--

INSERT INTO `friday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(4, 'fahdhfjadfshj', 'kjjnhoioijoiioio', 'Friday', '2019-03-05 00:45:51');

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

--
-- Table structure for table `monday_menu_tb`
--

CREATE TABLE `monday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `monday_menu_tb`
--

INSERT INTO `monday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(35, 'iwigosgo1', 'kakfkadllfalfdkflasfdll', 'Monday', '2019-02-07 19:17:22'),
(36, 'hh', 'JHJ', 'Monday', '2019-02-07 19:46:45'),
(37, 'jollof', 'banku', 'Monday', '2019-02-08 09:57:47');

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

--
-- Table structure for table `orders_made_tb`
--

CREATE TABLE `orders_made_tb` (
  `id` int(11) NOT NULL,
  `orders` text NOT NULL,
  `user` varchar(255) NOT NULL,
  `day` text NOT NULL,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(22) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders_made_tb`
--

INSERT INTO `orders_made_tb` (`id`, `orders`, `user`, `day`, `update_time`, `status`) VALUES
(53, 'food nad nkow', 'Melansi', 'Monday', '2019-03-05 22:59:24', 'N'),
(54, 'food nad nkow', 'Melansi', 'Monday', '2019-03-05 22:59:29', 'N'),
(55, 'food nad nkow', 'time', 'Mondays', '2019-03-07 08:58:11', 'N'),
(57, 'food nad nkow', 'time', 'Hjoafod', '2019-03-07 08:58:05', 'N'),
(59, 'akjdfkjasjdfjask', 'time', 'Sunday', '2019-03-05 22:59:39', 'N'),
(60, 'kkkjkjj', 'time', 'Thursday', '2019-03-07 12:16:02', 'N'),
(61, 'fahdhfjadfshj', 'time', 'Friday', '2019-03-07 12:16:04', 'N'),
(62, 'iaifdiafsdjaj', 'time', 'Saturday', '2019-03-07 12:16:07', 'N'),
(63, 'akjdfkjasjdfjask', 'time', 'Sunday', '2019-03-07 12:16:09', 'N'),
(64, 'fdadfkaskdfkl', 'shoto1', 'Wednesday', '2019-03-07 12:22:21', 'N'),
(65, 'kkkjkjj', 'shoto1', 'Thursday', '2019-03-07 12:22:22', 'N'),
(66, 'fahdhfjadfshj', 'shoto1', 'Friday', '2019-03-07 12:22:24', 'N'),
(67, 'iaifdiafsdjaj', 'shoto1', 'Saturday', '2019-03-07 12:22:25', 'N'),
(68, 'akjdfkjasjdfjask', 'shoto1', 'Sunday', '2019-03-07 12:22:27', 'N');

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

--
-- Table structure for table `password_reset_request`
--

CREATE TABLE `password_reset_request` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `arial_code` varchar(255) NOT NULL,
  `status` varchar(3) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `saturday_menu_tb`
--

CREATE TABLE `saturday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saturday_menu_tb`
--

INSERT INTO `saturday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(2, 'iaifdiafsdjaj', 'asdjfkafjdkajsdfkjasfkj', 'Saturday', '2019-02-07 19:21:04');

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

--
-- Table structure for table `sunday_menu_tb`
--

CREATE TABLE `sunday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunday_menu_tb`
--

INSERT INTO `sunday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(4, 'akjdfkjasjdfjask', 'jdfkajdkjfajsk', 'Sunday', '0000-00-00 00:00:00');

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

--
-- Table structure for table `thursday_menu_tb`
--

CREATE TABLE `thursday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `thursday_menu_tb`
--

INSERT INTO `thursday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(9, 'jdjfkaj,dkafkldsf;an', 'akdfjalbjsdfljasdflajls', 'Thursday', '2019-02-07 19:20:43'),
(10, 'kkkjkjj', 'kkk', 'Thursday', '2019-02-07 19:20:43');

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

--
-- Table structure for table `tuesday_menu_tb`
--

CREATE TABLE `tuesday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tuesday_menu_tb`
--

INSERT INTO `tuesday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(6, 'werjafjdkkfdakf', ',llkl', 'Tuesday', '2019-02-07 19:20:21'),
(7, 'tryt', 'sddf', 'Tuesday', '2019-02-11 23:01:23');

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

--
-- Table structure for table `wednesday_menu_tb`
--

CREATE TABLE `wednesday_menu_tb` (
  `id` int(11) NOT NULL,
  `meal1` text NOT NULL,
  `meal2` text NOT NULL,
  `day` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wednesday_menu_tb`
--

INSERT INTO `wednesday_menu_tb` (`id`, `meal1`, `meal2`, `day`, `timestamp`) VALUES
(4, 'fdadfkaskdfkl', 'asdfkalfsdlf', 'Wednesday', '2019-02-07 19:20:32');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

