#!/bin/sh
#create additional_user_drop_down_attribute

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

table_name=`get_table_name $application additional_user_drop_down_attribute`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (login_name char (20) not null,drop_down_folder char (50) not null,folder char (35) not null,attribute char (50) not null,prepend_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (login_name,drop_down_folder,folder,attribute);" | sql.e '^' mysql


#!/bin/sh
#create additional_drop_down_attribute

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

table_name=`get_table_name $application additional_drop_down_attribute`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (drop_down_folder char (50) not null,folder char (35) not null,attribute char (50) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (drop_down_folder,folder,attribute);" | sql.e '^' mysql


#!/bin/sh
#create appaserver_sessions

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

table_name=`get_table_name $application appaserver_sessions`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (login_name char (20),appaserver_session char (10) not null,http_user_agent char (80),last_access_date date,last_access_time char (4),remote_ip_address char (15),login_date date,login_time char (4));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (appaserver_session);" | sql.e '^' mysql


#!/bin/sh
#create appaserver_user

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

table_name=`get_table_name $application appaserver_user`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (login_name char (20) not null,person_full_name char (60),password char (45),frameset_menu_horizontal_yn char (1),user_date_format char (15));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (login_name);" | sql.e '^' mysql


#!/bin/sh
#create application_constants

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

table_name=`get_table_name $application application_constants`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (application_constant char (80) not null,application_constant_value text);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (application_constant);" | sql.e '^' mysql


#!/bin/sh
#create attribute

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

table_name=`get_table_name $application attribute`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (attribute char (50) not null,post_change_javascript char (50),hint_message text,appaserver_yn char (1),on_focus_javascript_function char (50),lookup_histogram_output_yn char (1),lookup_time_chart_output_yn char (1),width integer,attribute_datatype char (16),float_decimal_places integer);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (attribute);" | sql.e '^' mysql


#!/bin/sh
#create attribute_datatype

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

table_name=`get_table_name $application attribute_datatype`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (attribute_datatype char (16) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (attribute_datatype);" | sql.e '^' mysql


#!/bin/sh
#create attribute_exclude

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

table_name=`get_table_name $application attribute_exclude`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (role char (25) not null,attribute char (50) not null,permission char (10) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (role,attribute,permission);" | sql.e '^' mysql


#!/bin/sh
#create date_formats

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

table_name=`get_table_name $application date_formats`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (date_format char (15) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (date_format);" | sql.e '^' mysql


#!/bin/sh
#create drop_down_prompt

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

table_name=`get_table_name $application drop_down_prompt`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (drop_down_prompt char (50) not null,hint_message text,optional_display char (40));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (drop_down_prompt);" | sql.e '^' mysql


#!/bin/sh
#create drop_down_prompt_data

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

table_name=`get_table_name $application drop_down_prompt_data`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (drop_down_prompt char (50) not null,drop_down_prompt_data char (50) not null,display_order integer);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (drop_down_prompt,drop_down_prompt_data);" | sql.e '^' mysql


#!/bin/sh
#create folder

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

table_name=`get_table_name $application folder`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,form char (6),insert_rows_number integer,appaserver_yn char (1),populate_drop_down_process char (40),lookup_email_output_yn char (1),lookup_transmit_output_yn char (1),notepad char (255),sort_buttons_yn char (1),post_change_process char (40),html_help_file_anchor char (50),post_change_javascript char (50),no_initial_capital_yn char (1),tablespace char (20),row_access_count integer,exclude_application_export_yn char (1),lookup_before_drop_down_yn char (1),fix_orphans_process_yn char (1),subschema char (30),find_orphans_process_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder);" | sql.e '^' mysql


#!/bin/sh
#create folder_attribute

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

table_name=`get_table_name $application folder_attribute`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,attribute char (50) not null,primary_key_index integer,display_order integer,omit_insert_yn char (1),omit_insert_prompt_yn char (1),additional_unique_index_yn char (1),optional_primary_key_yn char (1),additional_index_yn char (1),insert_required_yn char (1),lookup_required_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder,attribute);" | sql.e '^' mysql


#!/bin/sh
#create folder_operation

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

table_name=`get_table_name $application folder_operation`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,operation char (40) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder,operation);" | sql.e '^' mysql


#!/bin/sh
#create folder_row_level_restrictions

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

table_name=`get_table_name $application folder_row_level_restrictions`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,row_level_restriction char (30));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder);" | sql.e '^' mysql


#!/bin/sh
#create form

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

table_name=`get_table_name $application form`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (form char (6) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (form);" | sql.e '^' mysql


#!/bin/sh
#create grace_output

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

table_name=`get_table_name $application grace_output`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (grace_output char (15) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (grace_output);" | sql.e '^' mysql


#!/bin/sh
#create javascript_files

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

table_name=`get_table_name $application javascript_files`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (javascript_filename char (80) not null,relative_source_directory_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (javascript_filename);" | sql.e '^' mysql


#!/bin/sh
#create javascript_folders

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

table_name=`get_table_name $application javascript_folders`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (javascript_filename char (80) not null,folder char (35) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (javascript_filename,folder);" | sql.e '^' mysql


#!/bin/sh
#create javascript_processes

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

table_name=`get_table_name $application javascript_processes`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (javascript_filename char (80) not null,process char (40) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (javascript_filename,process);" | sql.e '^' mysql


#!/bin/sh
#create javascript_process_sets

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

table_name=`get_table_name $application javascript_process_sets`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (javascript_filename char (80) not null,process_set char (40) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (javascript_filename,process_set);" | sql.e '^' mysql


#!/bin/sh
#create operation

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

table_name=`get_table_name $application operation`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (operation char (40) not null,output_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (operation);" | sql.e '^' mysql


#!/bin/sh
#create permissions

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

table_name=`get_table_name $application permissions`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (permission char (10) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (permission);" | sql.e '^' mysql


#!/bin/sh
#create process

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

table_name=`get_table_name $application process`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process char (40) not null,command_line char (255),notepad char (255),html_help_file_anchor char (50),execution_count integer,post_change_javascript char (50),process_set_display char (40),process_display char (40),process_group char (20),appaserver_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process);" | sql.e '^' mysql


#!/bin/sh
#create process_generic_datatype_folder

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

table_name=`get_table_name $application process_generic_datatype_folder`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (datatype_folder char (50) not null,datatype_attribute char (50),datatype_aggregation_sum_yn char (1),datatype_bar_graph_yn char (1),datatype_scale_graph_zero_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (datatype_folder);" | sql.e '^' mysql


#!/bin/sh
#create process_generic_value_folder

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

table_name=`get_table_name $application process_generic_value_folder`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (value_folder char (50) not null,date_attribute char (50),time_attribute char (50),value_attribute char (50),datatype_folder char (50),process_generic_unit char (15),foreign_folder char (50));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (value_folder);" | sql.e '^' mysql


#!/bin/sh
#create process_generic_output

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

table_name=`get_table_name $application process_generic_output`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process char (40) not null,process_set char (40) not null,value_folder char (50),date_attribute char (50),time_attribute char (50),value_attribute char (50),datatype_folder char (50),datatype_attribute char (50),datatype_entity_attribute char (50));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process,process_set);" | sql.e '^' mysql


#!/bin/sh
#create process_generic_units

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

table_name=`get_table_name $application process_generic_units`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process_generic_unit char (15) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process_generic_unit);" | sql.e '^' mysql


#!/bin/sh
#create process_groups

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

table_name=`get_table_name $application process_groups`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process_group char (20) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process_group);" | sql.e '^' mysql


#!/bin/sh
#create process_set

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

table_name=`get_table_name $application process_set`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process_set char (40) not null,notepad char (255),html_help_file_anchor char (50),post_change_javascript char (50),prompt_display_text char (25),prompt_display_bottom_yn char (1),process_group char (20));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process_set);" | sql.e '^' mysql


#!/bin/sh
#create process_set_parameter

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

table_name=`get_table_name $application process_set_parameter`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process_set char (40) not null,folder char (35) not null,attribute char (50) not null,prompt char (50) not null,drop_down_prompt char (50) not null,display_order integer,drop_down_multi_select_yn char (1),preprompt_yn char (1),populate_drop_down_process char (40),populate_helper_process char (40));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process_set,folder,attribute,prompt,drop_down_prompt);" | sql.e '^' mysql


#!/bin/sh
#create process_parameter

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

table_name=`get_table_name $application process_parameter`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process char (40) not null,folder char (35) not null,attribute char (50) not null,prompt char (50) not null,drop_down_prompt char (50) not null,display_order integer,drop_down_multi_select_yn char (1),preprompt_yn char (1),populate_drop_down_process char (40),populate_helper_process char (40));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process,folder,attribute,prompt,drop_down_prompt);" | sql.e '^' mysql


#!/bin/sh
#create prompt

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

table_name=`get_table_name $application prompt`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (prompt char (50) not null,hint_message text,input_width integer,upload_filename_yn char (1),date_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (prompt);" | sql.e '^' mysql


#!/bin/sh
#create relation

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

table_name=`get_table_name $application relation`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,related_folder char (35) not null,related_attribute char (50) not null,pair_1tom_order integer,omit_mto1_edit_drop_down_yn char (1),omit_mto1_drop_down_yn char (1),pair_1to1_yn char (1),copy_common_attributes_yn char (1),relation_type_isa_yn char (1),prompt_mto1_recursive_yn char (1),null_1tom_upon_delete_yn char (1),omit_1tom_detail_yn char (1),automatic_preselection_yn char (1),drop_down_multi_select_yn char (1),hint_message text);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder,related_folder,related_attribute);" | sql.e '^' mysql


#!/bin/sh
#create role

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

table_name=`get_table_name $application role`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (role char (25) not null,folder_count_yn char (1),override_row_restrictions_yn char (1),grace_no_cycle_colors_yn char (1));" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (role);" | sql.e '^' mysql


#!/bin/sh
#create role_folder

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

table_name=`get_table_name $application role_folder`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,role char (25) not null,permission char (10) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder,role,permission);" | sql.e '^' mysql


#!/bin/sh
#create role_operation

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

table_name=`get_table_name $application role_operation`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (folder char (35) not null,role char (25) not null,operation char (40) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (folder,role,operation);" | sql.e '^' mysql


#!/bin/sh
#create role_appaserver_user

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

table_name=`get_table_name $application role_appaserver_user`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (role char (25) not null,login_name char (20) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (role,login_name);" | sql.e '^' mysql


#!/bin/sh
#create role_process

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

table_name=`get_table_name $application role_process`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (role char (25) not null,process char (40) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (role,process);" | sql.e '^' mysql


#!/bin/sh
#create role_process_set_member

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

table_name=`get_table_name $application role_process_set_member`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (process char (40) not null,process_set char (40) not null,role char (25) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (process,process_set,role);" | sql.e '^' mysql


#!/bin/sh
#create row_level_restrictions

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

table_name=`get_table_name $application row_level_restrictions`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (row_level_restriction char (30) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (row_level_restriction);" | sql.e '^' mysql


#!/bin/sh
#create subschemas

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

table_name=`get_table_name $application subschemas`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (subschema char (30) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (subschema);" | sql.e '^' mysql


#!/bin/sh
#create tablespaces

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

table_name=`get_table_name $application tablespaces`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (tablespace char (20) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (tablespace);" | sql.e '^' mysql


#!/bin/sh
#create upgrade_scripts

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

table_name=`get_table_name $application upgrade_scripts`
echo "drop table if exists $table_name;" | sql.e '^' mysql
echo "create table $table_name (version char (10) not null,upgrade_script char (80) not null);" | sql.e '^' mysql
echo "create unique index $table_name on $table_name (version,upgrade_script);" | sql.e '^' mysql