query_init: CREATE DATABASE IF NOT EXISTS db1;

query:
      create_table |
       sql_mode ; character_set;

create_table:
       CREATE TABLE IF NOT EXISTS table_name (table_cols) ENGINE = storage_engine ;

storage_engine:  Myisam | Innodb ;

table_cols: one_col | two_col | three_col ;

one_col: column_definition ;

two_col: column_definition,
         column_definition ;

three_col: column_definition,
           column_definition,
           column_definition ;

column_definition: new_column data_type column_option ;

new_column: c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9 | c10 ;

data_type: INT | CHAR(255) ;

column_option: NULL | NOT NULL ;

table_name:
            t1 | t2 | t3 | t4 | t5 | t6 | t7 | t8 | t9 | t10 ;

sql_mode:
        SET SQL_MODE=' ' | SET SQL_MODE='TRADITIONAL' | SET SQL_MODE='PIPES_AS_CONCAT' | SET SQL_MODE='ANSI_QUOTES' ;

character_set:
        SET CHARACTER_SET_CLIENT=cset | SET CHARACTER_SET_CONNECTION=cset | SET CHARACTER_SET_DATABASE=cset | SET CHARACTER_SET_FILESYSTEM=cset | SET CHARACTER_SET_RESULTS=cset | SET CHARACTER_SET_SERVER=cset | SET COLLATION_CONNECTION=coll | SET COLLATION_DATABASE=coll | SET COLLATION_SERVER=coll ;

cset: LATIN1 | LATIN2 | LATIN5 | LATIN7 | SWE7 | BIG5 | EUCJPMS | GB2312 | ARMSCII8 | CP932 | UTF8 ;

coll: LATIN1_SWEDISH_CI | LATIN2_GENERAL_CI | LATIN5_TURKISH_CI | LATIN7_GENERAL_CI | SWE7_SWEDISH_CI | BIG5_CHINESE_CI | EUCJPMS_JAPANESE_CI | GB2312_CHINESE_CI | ARMSCII8_GENERAL_CI | CP932_JAPANESE_CI | UTF8_SPANISH_CI ;