-- phpMyAdmin SQL Dump -- version 4.8.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 31, 2019 at 04:36 PM -- Server version: 10.1.37-MariaDB -- PHP Version: 7.3.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `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 `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `password` text NOT NULL, `email` varchar(100) NOT NULL, `role` varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`, `email`, `role`) VALUES (19, 'ericfianu', 'e10adc3949ba59abbe56e057f20f883e', 'ericfianu@yahoo.com', ''), (20, '1234', 'b0baee9d279d34fa1dfd71aadb908c3f', '1234@yahoo.com', 'User'), (21, 'season', '3f1b0333a44fd5f611d3429887eba4a8', 'season@yahoo.com', ''), (31, 's', 'f1290186a5d0b1ceab27f4e77c0c5d68', 's', ''), (32, 'ajdjfaljfd', '8d9553410bdb9e5684ed544c0373152c', 'asfkjdkas@kdsafk.com', 'Admin'), (33, 'eric444', '827ccb0eea8a706c4c34a16891f84e7b', '12345', 'User'), (34, 'eruce', '8ba97607a1485ccdbe19745ed80cd52d', 'rer', 'User'), (35, 'titi', '31ddc655f9288e5502f3a36e83fb431f', '1234', 'User'), (36, 'titioop', '31ddc655f9288e5502f3a36e83fb431f', '1234@gmail.com', 'Admin'), (37, 'vf', '22a8dc42ff1026051367f4a76bf896d0', 'ericakdkaflskdflakldfkladlfaldflaldflalfaslkfdlal@yahoo.com', 'Admin'), (38, 'time', '07cc694b9b3fc636710fa08b6922c42b', 'time', 'Admin'), (45, 'shoto', '5bee2381b3d2afc1f087fc5bdb6435ea', 'shoto', 'Admin'), (46, 'mimi', 'dde6ecd6406700aa000b213c843a3091', 'mimi', 'Admin'), (47, 'shoto1', '5bee2381b3d2afc1f087fc5bdb6435ea', 'shoto1', 'User'), (48, 'muka', '122307131166a722a1aa0f3003f579d1', 'muka', 'User'); -- -------------------------------------------------------- -- -- 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 `users` -- ALTER TABLE `users` 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 `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49; -- -- AUTO_INCREMENT for table `wednesday_menu_tb` -- ALTER TABLE `wednesday_menu_tb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; 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 */;