#!/bin/sh
#create application

if [ "$#" -ne 1 ]
then
	echo "Usage: $0 application" 1>&2
	exit 1
fi
application=$1

table_name=${application}_application
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (application char (30) not null,application_title char (30),database_date_format char (15),only_one_primary_yn char (1),user_date_format char (15),relative_source_directory char (30),version char (10),next_session_number integer,next_reference_number integer,background_color char (7),ghost_script_directory char (50),distill_directory char (50),grace_home_directory char (50),grace_execution_directory char (50),grace_free_option_yn char (1),grace_output char (15),ssl_support_yn char (1),frameset_menu_horizontal_yn char (1),max_drop_down_size integer,prepend_http_protocol_yn char (1),chart_email_command_line char (255),max_query_rows_for_drop_downs integer);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (application);" | sql.e '^' mysql