Login | Register
Changed address.district to VARCHAR(20).
address.district
VARCHAR(20)
Changed customer.first_name to VARCHAR(45).
customer.first_name
VARCHAR(45)
Changed customer.last_name to VARCHAR(45).
customer.last_name
Changed customer.email to VARCHAR(50).
customer.email
VARCHAR(50)
Added payment.rental_id column (an INT NULL column).
payment.rental_id
INT NULL
Foreign key added for payment.rental_id to rental.rental_id.
rental.rental_id
rental.rental_id added, INT Auto_Increment, made into surrogate primary key, old primary key changed to UNIQUE key.
INT Auto_Increment
UNIQUE
© 2013, Oracle Corporation and/or its affiliates
