#!/bin/sh
 
db="/usr/local/bin/mysql -u root"
 
$db > /dev/null 2> /dev/null << ALL_DONE
 
use sso;
 
drop table Skill;      
ALL_DONE

$db << ALL_DONE
USE sso;
 
create table Skill (
    skill_id        integer     not null,
    cur_rating      integer     not null,
    base_rating     integer     not null,
    improve_threshold   integer not null,
    learn_chance    integer     not null,
    parent_skill_id integer     not null,
    default_penalty integer     not null,
    pips            integer     not null,
 
    index (skill_id),
    index (parent_skill_id)
);
 
show columns from Skill;
show index from Skill;
ALL_DONE