echo "drop table if exists classgrades_additional_user_drop_down_attribute;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_additional_user_drop_down_attribute (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_additional_user_drop_down_attribute on classgrades_additional_user_drop_down_attribute (login_name,drop_down_folder,folder,attribute);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_additional_drop_down_attribute;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_additional_drop_down_attribute (drop_down_folder char (50) not null,folder char (35) not null,attribute char (50) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_additional_drop_down_attribute on classgrades_additional_drop_down_attribute (drop_down_folder,folder,attribute);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_appaserver_sessions;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_appaserver_sessions (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_appaserver_sessions on classgrades_appaserver_sessions (appaserver_session);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_appaserver_user;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_appaserver_user (login_name char (20) not null,person_full_name char (60),password char (15),user_date_format char (15),frameset_menu_horizontal_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_appaserver_user on classgrades_appaserver_user (login_name);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_application;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_application (application char (30) not null,application_title char (30),only_one_primary_yn char (1),database_date_format char (15),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,chart_email_command_line char (255),prepend_http_protocol_yn char (1),max_query_rows_for_drop_downs integer);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_application on classgrades_application (application);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_attribute;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_attribute (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_attribute on classgrades_attribute (attribute);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_attribute_datatype;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_attribute_datatype (attribute_datatype char (16) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_attribute_datatype on classgrades_attribute_datatype (attribute_datatype);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_attribute_exclude;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_attribute_exclude (role char (25) not null,attribute char (50) not null,permission char (10) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_attribute_exclude on classgrades_attribute_exclude (role,attribute,permission);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_date_formats;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_date_formats (date_format char (15) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_date_formats on classgrades_date_formats (date_format);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_drop_down_prompt;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_drop_down_prompt (drop_down_prompt char (50) not null,hint_message text,optional_display char (40));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_drop_down_prompt on classgrades_drop_down_prompt (drop_down_prompt);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_drop_down_prompt_data;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_drop_down_prompt_data (drop_down_prompt char (50) not null,drop_down_prompt_data char (50) not null,display_order integer);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_drop_down_prompt_data on classgrades_drop_down_prompt_data (drop_down_prompt,drop_down_prompt_data);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_folder;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_folder (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),sort_buttons_yn char (1),notepad char (255),post_change_javascript char (50),html_help_file_anchor char (50),post_change_process char (40),row_access_count integer,tablespace char (20),exclude_application_export_yn char (1),lookup_before_drop_down_yn char (1),fix_orphans_process_yn char (1),find_orphans_process_yn char (1),subschema char (30));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_folder on classgrades_folder (folder);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_folder_attribute;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_folder_attribute (folder char (35) not null,attribute char (50) not null,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),lookup_required_yn char (1),display_order integer,primary_key_index integer,insert_required_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_folder_attribute on classgrades_folder_attribute (folder,attribute);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_folder_operation;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_folder_operation (folder char (35) not null,operation char (40) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_folder_operation on classgrades_folder_operation (folder,operation);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_folder_row_level_restrictions;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_folder_row_level_restrictions (folder char (35) not null,row_level_restriction char (30));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_folder_row_level_restrictions on classgrades_folder_row_level_restrictions (folder);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_form;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_form (form char (6) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_form on classgrades_form (form);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_grace_output;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_grace_output (grace_output char (15) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_grace_output on classgrades_grace_output (grace_output);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_javascript_files;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_javascript_files (javascript_filename char (80) not null,relative_source_directory_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_javascript_files on classgrades_javascript_files (javascript_filename);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_javascript_folders;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_javascript_folders (javascript_filename char (80) not null,folder char (35) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_javascript_folders on classgrades_javascript_folders (javascript_filename,folder);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_javascript_processes;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_javascript_processes (javascript_filename char (80) not null,process char (40) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_javascript_processes on classgrades_javascript_processes (javascript_filename,process);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_javascript_process_sets;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_javascript_process_sets (javascript_filename char (80) not null,process_set char (40) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_javascript_process_sets on classgrades_javascript_process_sets (javascript_filename,process_set);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_operation;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_operation (operation char (40) not null,output_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_operation on classgrades_operation (operation);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_permissions;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_permissions (permission char (10) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_permissions on classgrades_permissions (permission);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process (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),appaserver_yn char (1),process_group char (20));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process on classgrades_process (process);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_generic_datatype_folder;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_generic_datatype_folder (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_generic_datatype_folder on classgrades_process_generic_datatype_folder (datatype_folder);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_generic_value_folder;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_generic_value_folder (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_generic_value_folder on classgrades_process_generic_value_folder (value_folder);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_generic_output;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_generic_output (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_generic_output on classgrades_process_generic_output (process,process_set);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_generic_units;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_generic_units (process_generic_unit char (15) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_generic_units on classgrades_process_generic_units (process_generic_unit);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_groups;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_groups (process_group char (20) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_groups on classgrades_process_groups (process_group);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_set;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_set (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_set on classgrades_process_set (process_set);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_set_parameter;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_set_parameter (process_set char (40) not null,folder char (35) not null,prompt char (50) not null,attribute 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));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_set_parameter on classgrades_process_set_parameter (process_set,folder,prompt,attribute,drop_down_prompt);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_process_parameter;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_process_parameter (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));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_process_parameter on classgrades_process_parameter (process,folder,attribute,prompt,drop_down_prompt);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_prompt;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_prompt (prompt char (50) not null,hint_message text,upload_filename_yn char (1),input_width integer,date_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_prompt on classgrades_prompt (prompt);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_relation;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_relation (folder char (35) not null,related_folder char (35) not null,related_attribute char (50) not null,pair_1tom_order integer,omit_mto1_drop_down_yn char (1),omit_mto1_edit_drop_down_yn char (1),pair_1to1_yn char (1),copy_common_attributes_yn char (1),relation_type_isa_yn char (1),omit_1tom_detail_yn char (1),null_1tom_upon_delete_yn char (1),prompt_mto1_recursive_yn char (1),automatic_preselection_yn char (1),no_initial_capital_yn char (1),drop_down_multi_select_yn char (1),hint_message text);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_relation on classgrades_relation (folder,related_folder,related_attribute);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_role;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_role (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 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_role on classgrades_role (role);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_role_folder;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_role_folder (folder char (35) not null,role char (25) not null,permission char (10) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_role_folder on classgrades_role_folder (folder,role,permission);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_role_operation;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_role_operation (folder char (35) not null,role char (25) not null,operation char (40) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_role_operation on classgrades_role_operation (folder,role,operation);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_role_appaserver_user;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_role_appaserver_user (role char (25) not null,login_name char (20) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_role_appaserver_user on classgrades_role_appaserver_user (role,login_name);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_role_process;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_role_process (role char (25) not null,process char (40) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_role_process on classgrades_role_process (role,process);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_role_process_set_member;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_role_process_set_member (process char (40) not null,process_set char (40) not null,role char (25) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_role_process_set_member on classgrades_role_process_set_member (process,process_set,role);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_row_level_restrictions;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_row_level_restrictions (row_level_restriction char (30) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_row_level_restrictions on classgrades_row_level_restrictions (row_level_restriction);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_subschemas;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_subschemas (subschema char (30) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_subschemas on classgrades_subschemas (subschema);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_tablespaces;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_tablespaces (tablespace char (20) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_tablespaces on classgrades_tablespaces (tablespace);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_upgrade_scripts;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_upgrade_scripts (version char (10) not null,upgrade_script char (80) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_upgrade_scripts on classgrades_upgrade_scripts (version,upgrade_script);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper