#!/bin/sh
 
db="/usr/local/bin/mysql -u root"
 
$db > /dev/null 2> /dev/null << ALL_DONE
 
use sso;
 
drop table Equipment;
ALL_DONE
 
$db << ALL_DONE
USE sso;
 
create table Equipment (
    equipment_id    integer     not null,
    equip_location  integer     not null,
    equipped        tinyint     not null,
    equip_size      integer     not null,
    lootable        tinyint     not null,
    repair_diff     integer     not null,
    repair_skill    varchar(255)    not null,
 
    index (equipment_id)
);
 
show columns from Equipment;
show index from Equipment;
 
ALL_DONE