-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 26, 2022 at 04:21 PM -- Server version: 5.7.36 -- PHP Version: 7.3.30 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: `papemusc_flights` -- -- -------------------------------------------------------- -- -- Table structure for table `budgets` -- CREATE TABLE `budgets` ( `id` int(11) NOT NULL, `currency` varchar(100) NOT NULL, `class` int(11) NOT NULL, `cost` int(11) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `session` varchar(110) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `flight_records` -- CREATE TABLE `flight_records` ( `id` int(11) NOT NULL, `flight_from` varchar(111) NOT NULL, `flight_to` varchar(100) NOT NULL, `firstclass_cost` int(100) NOT NULL, `businessclass_cost` int(100) NOT NULL, `economyclass_cost` int(101) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `session` varchar(100) NOT NULL, `status` varchar(100) NOT NULL DEFAULT 'ACTIVE' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `flight_records` -- INSERT INTO `flight_records` (`id`, `flight_from`, `flight_to`, `firstclass_cost`, `businessclass_cost`, `economyclass_cost`, `time`, `session`, `status`) VALUES (1, 'NAIROBI', 'MOMBASA', 60000, 45000, 30000, '2022-09-18 12:23:48', 'joskin', 'ACTIVE'), (2, 'NAIROBI', 'KIGALI', 100000, 78000, 67000, '2022-09-18 12:35:19', 'joskin', 'DELETED'), (3, 'NAIROBI', 'MAASAI MARA', 40000, 32500, 12800, '2022-09-18 12:46:20', 'joskin', 'ACTIVE'), (4, 'MOMBASA', 'DUBAI-1', 300000, 240000, 180000, '2022-09-18 12:47:37', 'joskin', 'ACTIVE'), (5, 'MOMBASA', 'MOGADISHU', 70000, 56000, 45000, '2022-09-18 13:37:50', 'joskin', 'DELETED'); -- -------------------------------------------------------- -- -- Table structure for table `planes` -- CREATE TABLE `planes` ( `id` int(11) NOT NULL, `image` varchar(111) NOT NULL, `plane_codes` varchar(100) NOT NULL, `plane_name` varchar(100) NOT NULL, `firstclass_seats` int(11) NOT NULL, `businessclass_seats` int(11) NOT NULL, `economyclass_seats` int(11) NOT NULL, `session` varchar(110) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` varchar(100) NOT NULL DEFAULT 'ACTIVE' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `planes` -- INSERT INTO `planes` (`id`, `image`, `plane_codes`, `plane_name`, `firstclass_seats`, `businessclass_seats`, `economyclass_seats`, `session`, `time`, `status`) VALUES (1, 'plane-1.jpg', 'PLANE-A', 'PEF-001', 30, 50, 120, 'john', '2022-09-18 08:02:23', 'NON-ACTIVE'), (2, 'tim-gouw-OwD1ON8O-O4-unsplash (1).jpg', 'PLANE-B', 'PEF-002', 40, 70, 78, 'joskin', '2022-09-18 08:05:15', 'ACTIVE'), (3, 'gary-lopater-dOOGrK3zcUc-unsplash.jpg', 'PLANE-C', 'PEQ-004', 74, 83, 202, 'joskin', '2022-09-18 08:33:09', 'ACTIVE'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `role` varchar(100) NOT NULL DEFAULT 'customer', `fname` text NOT NULL, `lname` text NOT NULL, `gender` varchar(100) NOT NULL, `idno` varchar(19) NOT NULL, `phone1` varchar(100) NOT NULL, `phone2` varchar(110) NOT NULL, `email` varchar(100) NOT NULL, `address` varchar(100) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `username` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `session` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `role`, `fname`, `lname`, `gender`, `idno`, `phone1`, `phone2`, `email`, `address`, `time`, `username`, `password`, `session`) VALUES (26, 'ADMIN', 'JOSEPH', 'KINUTHIA', 'MALE', '36578655', '0797327555', '997544433', 'KINUTHIAJOSE105@GMAIL.COM', 'THIKA', '2022-09-15 20:09:39', 'joskin', 'c4ca4238a0b923820dcc509a6f75849b', 'Joskin'), (27, 'customer', 'JOSE', 'JOSE', 'MALE', '8980087666', '89797', '787877', 'KINUTHIAJOSE105@GMAIL.COM', '56799', '2022-09-15 20:12:28', 'JOE', '8ff32489f92f33416694be8fdc2d4c22', 'Joskin'), (28, 'customer', 'JOSE', 'JOSE', 'MALE', '89800876', '89797', '787877', 'KINUTHIAJOSE105@GMAIL.COM', '56799', '2022-09-15 20:13:43', 'JOEs', '8ff32489f92f33416694be8fdc2d4c22', 'Joskin'), (29, 'Admin', 'JOSE', 'JOSE', 'MALE', '898008766', '89797', '787877', 'KINUTHIAJOSE105@GMAIL.COM', '56799', '2022-09-15 20:15:26', 'joskin', '123ae7b27e350955d4822a16cc76245d', 'Joskin'), (30, 'admin', 'steve', 'john', 'MALE', '6797666', '+254708448164', '+254797545677', 'johnsteve@gmail.com', 'utawala', '2022-09-17 20:05:45', 'steve', 'd69403e2673e611d4cbd3fad6fd1788e', 'joskin'), (31, 'Staff', 'john', 'john', 'MALE', '45986645', '+254708448166', '+25479754670', 'johnsteve@gmail.com', 'john', '2022-09-17 20:07:26', 'john', 'c4ca4238a0b923820dcc509a6f75849b', 'steve'), (32, 'customer', 'CATHERINE', 'CATHY', 'FEMALE', '76899888', '0797456785', '0789567876', 'cathy@gmail.com', 'KILIMANI ', '2022-09-18 19:35:15', 'cathy', 'a598944ed55803c970b9d2519783e43b', 'cathy'), (33, 'customer', 'demo', 'demo', 'MALE', '35433233', '07765436', '0717654325', 'demo@itechempires.com', 'juja', '2022-09-26 12:18:34', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin'); -- -- Indexes for dumped tables -- -- -- Indexes for table `budgets` -- ALTER TABLE `budgets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `flight_records` -- ALTER TABLE `flight_records` ADD PRIMARY KEY (`id`); -- -- Indexes for table `planes` -- ALTER TABLE `planes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `budgets` -- ALTER TABLE `budgets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `flight_records` -- ALTER TABLE `flight_records` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `planes` -- ALTER TABLE `planes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; 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 */;