Skip to content

Latest commit

 

History

History
30 lines (21 loc) · 576 Bytes

changeLog.md

File metadata and controls

30 lines (21 loc) · 576 Bytes

V1.1.0

Added new field to students table

ALTER TABLE students
 ADD in_car_inst_id INT NOT NULL
 DEFAULT (1),
ADD CONSTRAINT FOREIGN KEY(in_car_inst_id) REFERENCES in_car_inst(id);

made home phone number nullable in students table

ALTER TABLE students MODIFY home_phone_number VARCHAR(20) NULL;

V1.2.0

made in car instructor nullable in students table

ALTER TABLE students MODIFY in_car_inst_id  INT NULL;

made address_state nullable in students table

ALTER TABLE students MODIFY address_state  VARCHAR(10) NULL;