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

$db << ALL_DONE
USE sso;
 
create table Resistance (
    resistance_id   integer     not null,
    resistance_type integer     not null,
    resistance_perc integer     not null,
 
    index (resistance_id),
    index (resistance_type)
);
 
show columns from Resistance;
show index from Resistance;
ALL_DONE