DatabaseCreation: AddNullConstraints.sql

File AddNullConstraints.sql, 9.9 KB (added by 231044, 7 hours ago)
Line 
1ALTER TABLE AdditionalCargo ALTER COLUMN Weight SET NOT NULL;
2ALTER TABLE AdditionalCargo ALTER COLUMN Height SET NOT NULL;
3ALTER TABLE AdditionalCargo ALTER COLUMN Width SET NOT NULL;
4ALTER TABLE AdditionalCargo ALTER COLUMN Length SET NOT NULL;
5ALTER TABLE AdditionalCargo ALTER COLUMN FlightID SET NOT NULL;
6
7ALTER TABLE Airplane ALTER COLUMN ModelID SET NOT NULL;
8ALTER TABLE Airplane ALTER COLUMN RegistrationNumber SET NOT NULL;
9ALTER TABLE Airplane ALTER COLUMN ManufactureDate SET NOT NULL;
10ALTER TABLE Airplane ALTER COLUMN Active SET NOT NULL;
11ALTER TABLE Airplane ALTER COLUMN TotalFlightHours SET NOT NULL;
12ALTER TABLE Airplane ALTER COLUMN LastMaintenanceID SET NOT NULL;
13
14ALTER TABLE AirplaneModel ALTER COLUMN Model SET NOT NULL;
15ALTER TABLE AirplaneModel ALTER COLUMN Manufacturer SET NOT NULL;
16ALTER TABLE AirplaneModel ALTER COLUMN NumberOfSeats SET NOT NULL;
17ALTER TABLE AirplaneModel ALTER COLUMN Width SET NOT NULL;
18ALTER TABLE AirplaneModel ALTER COLUMN Height SET NOT NULL;
19ALTER TABLE AirplaneModel ALTER COLUMN Length SET NOT NULL;
20ALTER TABLE AirplaneModel ALTER COLUMN EmptyWeight SET NOT NULL;
21ALTER TABLE AirplaneModel ALTER COLUMN EmptyWeight SET NOT NULL;
22ALTER TABLE AirplaneModel ALTER COLUMN MaxFlightDistance SET NOT NULL;
23ALTER TABLE AirplaneModel ALTER COLUMN FuelCapacity SET NOT NULL;
24ALTER TABLE AirplaneModel ALTER COLUMN RequiredAttendants SET NOT NULL;
25ALTER TABLE AirplaneModel ALTER COLUMN SeatColumns SET NOT NULL;
26ALTER TABLE AirplaneModel ALTER COLUMN SeatRows SET NOT NULL;
27
28ALTER TABLE Airport ALTER COLUMN Code SET NOT NULL;
29ALTER TABLE Airport ALTER COLUMN Name SET NOT NULL;
30ALTER TABLE Airport ALTER COLUMN CityID SET NOT NULL;
31ALTER TABLE Airport ALTER COLUMN TimezoneID SET NOT NULL;
32
33ALTER TABLE AirportEmployee ALTER COLUMN AirportID SET NOT NULL;
34
35ALTER TABLE Baggage ALTER COLUMN BaggageTypeID SET NOT NULL;
36ALTER TABLE Baggage ALTER COLUMN Weight SET NOT NULL;
37ALTER TABLE Baggage ALTER COLUMN Height SET NOT NULL;
38ALTER TABLE Baggage ALTER COLUMN Length SET NOT NULL;
39ALTER TABLE Baggage ALTER COLUMN Width SET NOT NULL;
40ALTER TABLE Baggage ALTER COLUMN TicketID SET NOT NULL;
41
42ALTER TABLE BaggageHandler ALTER COLUMN ShiftTypeID SET NOT NULL;
43
44ALTER TABLE BaggageStatus ALTER COLUMN BaggageStatusTypeID SET NOT NULL;
45ALTER TABLE BaggageStatus ALTER COLUMN TimeStamp SET NOT NULL;
46ALTER TABLE BaggageStatus ALTER COLUMN AirportID SET NOT NULL;
47
48ALTER TABLE BaggageStatusType ALTER COLUMN Name SET NOT NULL;
49
50ALTER TABLE BaggageType ALTER COLUMN Name SET NOT NULL;
51ALTER TABLE BaggageType ALTER COLUMN MaxWeight SET NOT NULL;
52ALTER TABLE BaggageType ALTER COLUMN MaxHeight SET NOT NULL;
53ALTER TABLE BaggageType ALTER COLUMN MaxWidth SET NOT NULL;
54ALTER TABLE BaggageType ALTER COLUMN MaxLength SET NOT NULL;
55ALTER TABLE BaggageType ALTER COLUMN Price SET NOT NULL;
56
57ALTER TABLE CanceledFlight ALTER COLUMN Reason SET NOT NULL;
58ALTER TABLE CanceledFlight ALTER COLUMN CancellationTime SET NOT NULL;
59
60ALTER TABLE City ALTER COLUMN Name SET NOT NULL;
61ALTER TABLE City ALTER COLUMN CountryID SET NOT NULL;
62ALTER TABLE City ALTER COLUMN TimeZoneID SET NOT NULL;
63
64ALTER TABLE Country ALTER COLUMN Name SET NOT NULL;
65
66ALTER TABLE Employee ALTER COLUMN Name SET NOT NULL;
67ALTER TABLE Employee ALTER COLUMN Surname SET NOT NULL;
68ALTER TABLE Employee ALTER COLUMN SSN SET NOT NULL;
69ALTER TABLE Employee ALTER COLUMN DateOfBirth SET NOT NULL;
70ALTER TABLE Employee ALTER COLUMN DateOfEmployment SET NOT NULL;
71ALTER TABLE Employee ALTER COLUMN Gender SET NOT NULL;
72ALTER TABLE Employee ALTER COLUMN Salary SET NOT NULL;
73ALTER TABLE Employee ALTER COLUMN PhoneNumber SET NOT NULL;
74ALTER TABLE Employee ALTER COLUMN Active SET NOT NULL;
75
76ALTER TABLE Flight ALTER COLUMN FlightNumber SET NOT NULL;
77ALTER TABLE Flight ALTER COLUMN Departure SET NOT NULL;
78ALTER TABLE Flight ALTER COLUMN Arrival SET NOT NULL;
79ALTER TABLE Flight ALTER COLUMN ScheduleID SET NOT NULL;
80ALTER TABLE Flight ALTER COLUMN AirplaneID SET NOT NULL;
81ALTER TABLE Flight ALTER COLUMN StatusID SET NOT NULL;
82ALTER TABLE Flight ALTER COLUMN ActualGateDepartureID SET NOT NULL;
83ALTER TABLE Flight ALTER COLUMN ActualGateArrivalID SET NOT NULL;
84ALTER TABLE Flight ALTER COLUMN ActualDepartureSlot SET NOT NULL;
85ALTER TABLE Flight ALTER COLUMN ActualArrivalSlot SET NOT NULL;
86
87ALTER TABLE FlightAttendant ALTER COLUMN CertificationLevel SET NOT NULL;
88ALTER TABLE FlightAttendant ALTER COLUMN PrimaryLanguage SET NOT NULL;
89ALTER TABLE FlightAttendant ALTER COLUMN SecondaryLanguage SET NOT NULL;
90
91ALTER TABLE FlightCertification ALTER COLUMN AirlineEmployeeID SET NOT NULL;
92ALTER TABLE FlightCertification ALTER COLUMN AirplaneModelID SET NOT NULL;
93ALTER TABLE FlightCertification ALTER COLUMN CertificationType SET NOT NULL;
94ALTER TABLE FlightCertification ALTER COLUMN TestDate SET NOT NULL;
95ALTER TABLE FlightCertification ALTER COLUMN ExpirationDate SET NOT NULL;
96
97ALTER TABLE FlightStatus ALTER COLUMN Name SET NOT NULL;
98
99ALTER TABLE Gate ALTER COLUMN TerminalID SET NOT NULL;
100ALTER TABLE Gate ALTER COLUMN Number SET NOT NULL;
101ALTER TABLE Gate ALTER COLUMN Capacity SET NOT NULL;
102
103ALTER TABLE Item ALTER COLUMN Name SET NOT NULL;
104ALTER TABLE Item ALTER COLUMN Price SET NOT NULL;
105
106ALTER TABLE ItemsSold ALTER COLUMN Quantity SET NOT NULL;
107
108ALTER TABLE Language ALTER COLUMN Name SET NOT NULL;
109
110ALTER TABLE Maintenance ALTER COLUMN AirplaneID SET NOT NULL;
111ALTER TABLE Maintenance ALTER COLUMN Date SET NOT NULL;
112
113ALTER TABLE Meal ALTER COLUMN SeatClassID SET NOT NULL;
114ALTER TABLE Meal ALTER COLUMN MealTypeID SET NOT NULL;
115
116ALTER TABLE MealType ALTER COLUMN Name SET NOT NULL;
117
118ALTER TABLE MedicalCheckup ALTER COLUMN CheckupDate SET NOT NULL;
119ALTER TABLE MedicalCheckup ALTER COLUMN ExpirationDate SET NOT NULL;
120ALTER TABLE MedicalCheckup ALTER COLUMN EmployeeID SET NOT NULL;
121
122ALTER TABLE PartOnAirplane ALTER COLUMN PartTypeID SET NOT NULL;
123ALTER TABLE PartOnAirplane ALTER COLUMN AirplaneID SET NOT NULL;
124ALTER TABLE PartOnAirplane ALTER COLUMN InUse SET NOT NULL;
125
126ALTER TABLE PartType ALTER COLUMN Name SET NOT NULL;
127ALTER TABLE PartType ALTER COLUMN Material SET NOT NULL;
128ALTER TABLE PartType ALTER COLUMN Price SET NOT NULL;
129ALTER TABLE PartType ALTER COLUMN Weight SET NOT NULL;
130
131ALTER TABLE Passenger ALTER COLUMN Name SET NOT NULL;
132ALTER TABLE Passenger ALTER COLUMN Surname SET NOT NULL;
133ALTER TABLE Passenger ALTER COLUMN DateOfBirth SET NOT NULL;
134ALTER TABLE Passenger ALTER COLUMN Gender SET NOT NULL;
135ALTER TABLE Passenger ALTER COLUMN Email SET NOT NULL;
136ALTER TABLE Passenger ALTER COLUMN SSN SET NOT NULL;
137ALTER TABLE Passenger ALTER COLUMN PhoneNumber SET NOT NULL;
138
139ALTER TABLE Passport ALTER COLUMN PassengerID SET NOT NULL;
140ALTER TABLE Passport ALTER COLUMN PassportNumber SET NOT NULL;
141ALTER TABLE Passport ALTER COLUMN Expiration SET NOT NULL;
142ALTER TABLE Passport ALTER COLUMN IssuingCountry SET NOT NULL;
143
144ALTER TABLE Pilot ALTER COLUMN FlightHours SET NOT NULL;
145ALTER TABLE Pilot ALTER COLUMN LicenceNumber SET NOT NULL;
146ALTER TABLE Pilot ALTER COLUMN Rank SET NOT NULL;
147
148ALTER TABLE PilotRank ALTER COLUMN Name SET NOT NULL;
149
150ALTER TABLE Repair ALTER COLUMN PartOnAirplaneID SET NOT NULL;
151ALTER TABLE Repair ALTER COLUMN Price SET NOT NULL;
152
153ALTER TABLE RepairCertification ALTER COLUMN ExpirationDate SET NOT NULL;
154ALTER TABLE RepairCertification ALTER COLUMN TestDate SET NOT NULL;
155ALTER TABLE RepairCertification ALTER COLUMN AirplaneModelID SET NOT NULL;
156ALTER TABLE RepairCertification ALTER COLUMN MechanicID SET NOT NULL;
157
158ALTER TABLE Reservation ALTER COLUMN PassengerID SET NOT NULL;
159ALTER TABLE Reservation ALTER COLUMN CreatedAt SET NOT NULL;
160
161ALTER TABLE Runway ALTER COLUMN AirportID SET NOT NULL;
162ALTER TABLE Runway ALTER COLUMN Number SET NOT NULL;
163ALTER TABLE Runway ALTER COLUMN Length SET NOT NULL;
164ALTER TABLE Runway ALTER COLUMN Width SET NOT NULL;
165ALTER TABLE Runway ALTER COLUMN MaxWeight SET NOT NULL;
166
167ALTER TABLE ScheduledFlight ALTER COLUMN Departure SET NOT NULL;
168ALTER TABLE ScheduledFlight ALTER COLUMN Arrival SET NOT NULL;
169ALTER TABLE ScheduledFlight ALTER COLUMN Distance SET NOT NULL;
170ALTER TABLE ScheduledFlight ALTER COLUMN Active SET NOT NULL;
171
172ALTER TABLE Seat ALTER COLUMN SeatConfigurationID SET NOT NULL;
173ALTER TABLE Seat ALTER COLUMN FlightID SET NOT NULL;
174ALTER TABLE Seat ALTER COLUMN Reserved SET NOT NULL;
175
176ALTER TABLE SeatClass ALTER COLUMN Name SET NOT NULL;
177
178ALTER TABLE SeatConfiguration ALTER COLUMN Number SET NOT NULL;
179ALTER TABLE SeatConfiguration ALTER COLUMN Letter SET NOT NULL;
180ALTER TABLE SeatConfiguration ALTER COLUMN ExitRow SET NOT NULL;
181ALTER TABLE SeatConfiguration ALTER COLUMN SeatClassID SET NOT NULL;
182ALTER TABLE SeatConfiguration ALTER COLUMN AirplaneModelID SET NOT NULL;
183ALTER TABLE SeatConfiguration ALTER COLUMN Price SET NOT NULL;
184
185ALTER TABLE ServedMeals ALTER COLUMN Quantity SET NOT NULL;
186ALTER TABLE ServedMeals ALTER COLUMN Served SET NOT NULL;
187
188ALTER TABLE ShiftType ALTER COLUMN Name SET NOT NULL;
189
190ALTER TABLE Slot ALTER COLUMN GateID SET NOT NULL;
191ALTER TABLE Slot ALTER COLUMN RunwayID SET NOT NULL;
192ALTER TABLE Slot ALTER COLUMN Time SET NOT NULL;
193ALTER TABLE Slot ALTER COLUMN DayOfWeek SET NOT NULL;
194ALTER TABLE Slot ALTER COLUMN Active SET NOT NULL;
195
196ALTER TABLE Terminal ALTER COLUMN AirportID SET NOT NULL;
197ALTER TABLE Terminal ALTER COLUMN Name SET NOT NULL;
198ALTER TABLE Terminal ALTER COLUMN TerminalTypeID SET NOT NULL;
199ALTER TABLE Terminal ALTER COLUMN Capacity SET NOT NULL;
200
201ALTER TABLE TerminalType ALTER COLUMN Name SET NOT NULL;
202
203ALTER TABLE Ticket ALTER COLUMN PassengerID SET NOT NULL;
204ALTER TABLE Ticket ALTER COLUMN BasePrice SET NOT NULL;
205ALTER TABLE Ticket ALTER COLUMN FinalPrice SET NOT NULL;
206ALTER TABLE Ticket ALTER COLUMN SeatClassID SET NOT NULL;
207ALTER TABLE Ticket ALTER COLUMN TicketStatusID SET NOT NULL;
208ALTER TABLE Ticket ALTER COLUMN ReservationID SET NOT NULL;
209ALTER TABLE Ticket ALTER COLUMN FlightID SET NOT NULL;
210ALTER TABLE Ticket ALTER COLUMN PurchaseDate SET NOT NULL;
211
212ALTER TABLE TicketStatus ALTER COLUMN Name SET NOT NULL;
213
214ALTER TABLE TicketingAgent ALTER COLUMN CounterNumber SET NOT NULL;
215
216ALTER TABLE TimeZone ALTER COLUMN Name SET NOT NULL;
217ALTER TABLE TimeZone ALTER COLUMN TimeZoneOffset SET NOT NULL;