DROP DATABASE IF EXISTS Activity3_1;

CREATE DATABASE IF NOT EXISTS Activity3_1;
USE Activity3_1;

############################################
## TYPE YOUR STATEMENTS BELOW: ##
######################################
## 1. Create a TV show table that only has 3 columns for show name, network, and catch phrase. Each column should allow 25 characters maximum. 


######### Then add separate statements: ###########
## 2. Add a column called 'Number of Seasons'.


## 3. Delete the Catch Phrase column.


## 4. Change the name of the network column to 'nw_1'.


## 5. Add a primary key column called 'Show ID'. 


## 6. Change the Show Name column to allow 75 characters maximum.


## 7. Give the Show Name column index status.


## 8. Add a column of your choice so that it comes first.


## 9. Change the name of the table to "Totally Awesome Shows". 


## 10. Display the column information for the table.