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

$db << ALL_DONE
USE sso;
 
create table Graphic (
    graphic_id      integer     not null,
    width           integer     not null,
    length          integer     not null,
    height          integer     not null,
 
    index (graphic_id)
);
 
show columns from Graphic;
show index from Graphic;
 
insert into Graphic set graphic_id=-2, width=0, length=0, height=0;
 
 
create table Graphic_URIs (
    graphic_id      integer     not null,
    mode            integer     not null,
    uri             varchar(255),
 
    index (graphic_id)
);
 
show columns from Graphic_URIs;
show index from Graphic_URIs;
ALL_DONE