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

$db << ALL_DONE
USE sso;
 
create table Persistant (
    id              integer     not null,
    created_time    bigint,
    checkpoint_time bigint,
 
    index (id),
    unique (id)
);
 
show columns from Persistant;
show index from Persistant;
 
insert into Persistant set id=-2, created_time=0, checkpoint_time=0;
ALL_DONE