This script creates 6 tables in the silver schema, dropping the tables if they already exist. This script is used to redefine the structure of the 'bronze' tables.