Создание таблицы в БД в MySQL средствами bash (Ubuntu Linux)

Код на bash для создания таблицы в БД MySQL с заданной структурой:


#!/bin/sh
user=mysql_db_username
host=localhost
password=yourpasswordhere
db=name_of_the_db
tbl="table_name"
QUERY_CREATE_RU_TABLE=$(mysql -u$user --local-infile -h$host -p$password -e "use $db; create table $tbl ( index_number INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(index_number), simpl CHAR(16) CHARACTER SET utf16 COLLATE utf16_general_ci COMMENT 'comment here', name_2 CHAR(48) CHARACTER SET utf16 COLLATE utf16_general_ci COMMENT 'comment here', ru_trans TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'translation into russian language', eng_trans TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'translation into english language', exmpl TEXT CHARACTER SET utf16 COLLATE utf16_general_ci COMMENT 'example', trad CHAR(16) CHARACTER SET utf16 COLLATE utf16_general_ci COMMENT 'comment here', level INT COMMENT 'level', reserved_fld CHAR(60) CHARACTER SET utf16 COLLATE utf16_general_ci COMMENT 'reserved field for future use', is_noun BOOL, is_adjective BOOL, is_pronoun BOOL, is_verb BOOL,is_preposition BOOL, is_conjunction BOOL, is_adverb BOOL )")
echo $QUERY_CREATE_RU_TABLE