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

$db << ALL_DONE
USE sso;
 
create table Window (
	window_id		integer		not null,
	lock_id			integer		not null,
	trap_id			integer		not null,
	open			tinyint		not null,
	shuttered		tinyint		not null,
	window_type		integer		not null,

    index (window_id),
	index (trap_id),
	index (lock_id)
);
 
show columns from Window;
show index from Window;
 
ALL_DONE