-- A script for creating two tables for itec325 hw05
--   https://php.radford.edu/~itec325/2012fall-ibarland/Homeworks/hw05/hw05.html
-- You may need to tweak this file, if you want different column widths or names.
-- Works in both Oracle SQL and MySQL (php.radford.edu >... phpMyAdmin >... 'SQL' tab).

drop   table Skills;
create table Skills(
   skillName varchar(20)
  ,minLevel int
  ,skillDescr varchar(200)
  ,username varchar(50)
  ,ability varchar(10)  -- should really be a FK into a known-abilities table.
  );

drop   table Availabilities;
create table Availabilities( 
   skillName varchar(20)
  ,className varchar(30)  -- should really be FK into a known-classes table.
  );

  
  
insert into Skills(skillName,minLevel,skillDescr,username,ability)
values('Ventriloquism',42,'Ventriloquism allows blah blah blah','ventra99','Wisdom');

insert into Availabilities(skillName,className)
values('Ventriloquism','Mage');

insert into Availabilities(skillName,className)
values('Ventriloquism','Rogue');