drop database if exists Activity_5_1 ;
create database if Not exists Activity_5_1;
use Activity_5_1;

## First, the table definitions.  

create table heros_table(
	hero_ID int(5) primary key auto_increment not null,
	hero_name char(30),
	firstname char(30),
	lastname char(40),
	city char(35),
	planet char(35),
	spouse char(35),
	species char(35)
);

#################### Adding records: 
insert into heros_table
	(hero_ID, hero_name, firstname, lastname, city, planet, spouse, species)
   values
	(NULL, "Superman", "Clark", "Kent", "Metropolis", "Earth", "Lois", "alien"),
	(NULL, "Captain Marvel", "William", "Batson", "Fawcett City", "Earth", NULL, "mortal"),
	(NULL, "Storm", "Ororo", "Munro", "New York City", "Earth", NULL, "mutant"),	
	(NULL, "Judge Dredd", "Joseph", "Dredd", "Mega City 1", "Earth", NULL, "human"),
	(NULL, "Spider-man", "Peter", "Parker", "New York City", "Earth", "Mary Jane","human"),
	(NULL, "Captain Marvel", NULL, "Mar-vell", "Cape Kennedy", "Earth", NULL, "Kree"),
	(NULL, "Nexus", "Horatio", "Hellpop", "Ylum", "Ylum", "Sondra", "human"),
	(NULL, "Cyclops", "Scott", "Summers", "New York City", "Earth", NULL, "mutant"),	
	(NULL, "Captain Marvel", "Monica", "Rambeau", "New Orleans", "Earth", NULL, "human"),
	(NULL, "Angel", "Warren", "Worthington", "Los Angeles", "Earth", NULL, "mutant"),	
	(NULL, "Promethea", "Sophie", "Bangs", "New York City", "Earth", NULL, "avatar");


############# display records...

select * from heros_table;

######## ADD ONE STATEMENT BELOW FOR EACH OF THE FOLLOWING, IN THIS ORDER:
#1. Change the table name spelling to "heroes_table": 

#2. Add an 'Identity Status' column to the table that allows only the values 'public' or 'secret': 

#3. Make the 'Identity Status' values become "secret" for all records: 

#4. Update all "Captain Marvel" hero names to the hero name "Major Marvel":

#5. Update spouse fields that have NULL values to the value "none" instead:

#6. Add a Phone Number column before the City column. Use a numeric datatype: 

#7. Change all Phone Number fields to say 412-555-1212 for heros whose ID number is 6 or higher:

#8. Change Identity Status to "public" for all mutants in New York City:

#9. Update info so all heroes get the last name "Estlack" and the planet "Terra": 

#10. Add 3 new hero records to the table (effort counts!):  

# Show all databases, tables, columns, and records: