Breaking News: Grepper is joining You.com. Read the official announcement!

database code in sql For flight reservations

Alert Armadillo answered on May 20, 2023 Popularity 1/10 Helpfulness 8/10

answer database code in sql For flight reservations

database code in sql For flight reservations

Comment

-- Indexes for table `airlines`
ALTER TABLE `airlines` ADD PRIMARY KEY (`airlines_id`);

-- Indexes for table `airlines_type`
ALTER TABLE `airlines_type` ADD PRIMARY KEY (`at_id`);

-- Indexes for table `booking`
ALTER TABLE `booking` ADD PRIMARY KEY (`booking_id`);

-- Indexes for table `city`
ALTER TABLE `city`  ADD PRIMARY KEY (`city_id`);

-- Indexes for table `latest_booking`
ALTER TABLE `latest_booking` ADD PRIMARY KEY (`lb_id`);

-- Indexes for table `passengar`
ALTER TABLE `passengar`  ADD PRIMARY KEY (`passengar_id`);

-- Indexes for table `route`
ALTER TABLE `route`  ADD PRIMARY KEY (`route_id`);

-- AUTO_INCREMENT for dumped tables
ALTER TABLE `airlines`
  MODIFY `airlines_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

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

-- AUTO_INCREMENT for table `booking`
ALTER TABLE `booking`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

-- AUTO_INCREMENT for table `city`
ALTER TABLE `city`
  MODIFY `city_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

-- AUTO_INCREMENT for table `latest_booking`
ALTER TABLE `latest_booking`
  MODIFY `lb_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- AUTO_INCREMENT for table `passengar`
ALTER TABLE `passengar`
  MODIFY `passengar_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

-- AUTO_INCREMENT for table `route`
ALTER TABLE `route`
  MODIFY `route_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

Popularity 1/10 Helpfulness 8/10 Language sql

Source: www.freeprojectz.com

Tags: database sql

Link to this answer
Share Copy Link

Contributed on May 20 2023

Alert Armadillo

0 Answers Avg Quality 2/10

database code in sql For flight reservations

Contents

More Related Answers

database code in sql For flight reservations

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.