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

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

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

