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

$db << ALL_DONE
USE sso;
 
create table Effect (
    effect_id       integer     not null,
    effect_ttl      integer     not null,
    effect_type     integer     not null,
 
    index (effect_id),
    index (effect_type)
);
 
show columns from Effect;
show index from Effect;
 
 
create table Effect_Victims (
    effect_id       integer     not null,
    victim_id       integer     not null,
 
    index (effect_id),
    index (victim_id)
);
 
show columns from Effect_Victims;
show index from Effect_Victims;
ALL_DONE