suppliers holds four rows. Do not create the table again: change it, and keep the rows.
- Add a column
active. It is required, and it is true for every supplier, the four that exist and the new ones. - The column
sinceis unclear. Rename it topartner_since. - Nobody uses the
faxcolumn. Remove it. - Add supplier 5:
Northern Monster Plush Ltd, fromGB. The INSERT fails. Change the table so that names of up to 40 characters fit, then add supplier 5. - The team calls suppliers "vendors" now. Rename the table to
vendors.