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

$db << ALL_DONE
USE sso;
 
create table PC_Skills (
    pc_id           integer     not null,
    skill_id        integer     not null,
 
    index (pc_id),
    index (skill_id)
);
 
show columns from PC_Skills;
show index from PC_Skills;
 
 
create table PC (
    pc_id           integer     not null,
    base_mana       integer     not null,
    cur_mana        integer     not null,
    heal_rate       integer     not null,
    mana_rate       integer     not null,
    size            integer     not null,
 
    index (pc_id)
);
 
show columns from PC;
show index from PC;
 
 
create table PC_NaturalWeapons (
    pc_id           integer     not null,
    weapon_id       integer     not null,
 
    index (pc_id),
    index (weapon_id)
);
 
show columns from PC_NaturalWeapons;
show index from PC_NaturalWeapons;
 
 
create table Group_PCs (
    group_id        integer     not null,
    pc_id           integer     not null,
 
    index (group_id),
    index (pc_id)
);  
show columns from Group_PCs;
show index from Group_PCs; 
ALL_DONE