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

$db << ALL_DONE
USE sso;
 
create table Lock (
	lock_id			integer		not null,
	locked			tinyint		not null,
	key_id			integer		not null,
	lock_diff		integer		not null,
	host_id			integer		not null,
	trap_id			integer		not null,

    index (lock_id),
	index (key_id),
	index (host_id),
	index (trap_id)
);
 
show columns from Lock;
show index from Lock;
 
ALL_DONE