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

START TRANSACTION;



--
-- 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;

