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

$db << ALL_DONE
USE sso;
 
#create table GroupObject (
#   group_id        integer     not null,
#   gameobject_id   integer     not null,
#
#   index (group_id),
#   index (gameobject_id)
#);
#
#show columns from GroupObject;
#show index from GroupObject;
 
 
create table Thing (
    thing_id        integer     not null,
    weight          integer     not null,
    base_value      integer     not null,
    capacity        integer     not null,
    base_rating     integer     not null,
    cur_rating      integer     not null,
    key_id          integer     not null,
 
    index (thing_id)
);
 
show columns from Thing;
show index from Thing;
ALL_DONE