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

$db << ALL_DONE
USE sso;
 
create table Arms (
    arms_id       	integer     not null,
	critical_hit	integer		not null,
	fumble_roll		integer		not null,
	attack_type		integer		not null,
	damage_dice		integer		not null,
	damage_faces	integer		not null,
	min_range		integer		not null,
	short_range		integer		not null,
	med_range		integer		not null,
	long_range		integer		not null,
	extreme_range	integer		not null,
	short_r_pen		integer		not null,
	med_r_pen		integer		not null,
	long_r_pen		integer		not null,
	extreme_r_pen	integer		not null,
	throw_skill		varchar(255)	not null,
	weapon_skill	varchar(255)	not null,
	opp_skill		varchar(255),
	damage_bonus	integer		not null,
 
    index (arms_id)
);
 
show columns from Arms;
show index from Arms;
 
ALL_DONE