echo "drop table if exists classgrades_assignments_and_tests;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_assignments_and_tests (assignment_or_test_name char (50) not null,class_name char (15) not null,section integer not null,season char (15) not null,year integer not null,login_name char (20) not null,type char (15),assignment_or_test_date date,max_points integer,doesnt_count_for_average_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_assignments_and_tests on classgrades_assignments_and_tests (assignment_or_test_name,class_name,section,season,year,login_name);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_classes;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_classes (class_name char (15) not null,section integer not null,season char (15) not null,year integer not null,login_name char (20) not null);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_classes on classgrades_classes (class_name,section,season,year,login_name);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_enrollments;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_enrollments (student_name_last_first_middle char (40) not null,class_name char (15) not null,section integer not null,season char (15) not null,year integer not null,login_name char (20) not null,personal_identification_number integer,dropped_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_enrollments on classgrades_enrollments (student_name_last_first_middle,class_name,section,season,year,login_name);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

echo "drop table if exists classgrades_grades;" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create table classgrades_grades (student_name_last_first_middle char (40) not null,class_name char (15) not null,section integer not null,season char (15) not null,year integer not null,assignment_or_test_name char (50) not null,login_name char (20) not null,points integer,dropped_yn char (1));" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper;echo "create unique index classgrades_grades on classgrades_grades (student_name_last_first_middle,class_name,section,season,year,assignment_or_test_name,login_name);" | sql.e '^' mysql 2>&1 | html_paragraph_wrapper

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

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

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

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