text: #begin
  -- Create Table
  create table new_t  (like t1);
  create table log_table(row varchar(512));
  create table ships(name varchar(255), class_id int, id int);
  create table ships_guns(guns_id int, ship_id int);
  create table guns(id int, power decimal(7,2), callibr decimal(10,3));
  create table ship_class(id int, class_name varchar(100), tonange decimal(10,2), max_length decimal(10,2), start_build year, max_guns_size int);
  create table `some table $$`(id int auto_increment key, class varchar(10), data binary) engine=MYISAM;
  create table `parent_table`(id int primary key, column1 varchar(30), index parent_table_i1(column1(20)), check(char_length(column1)>10)) engine InnoDB;
  create table child_table(id int unsigned auto_increment primary key, id_parent int references parent_table(id) match full on update cascade on delete set null) engine=InnoDB;
  create table `another some table $$` like `some table $$`;
  #end
  #begin
  -- Rename table
  -- http://dev.mysql.com/doc/refman/5.6/en/rename-table.html
  RENAME TABLE old_table TO tmp_table, new_table TO old_table, tmp_table TO new_table;
  RENAME TABLE table_b TO table_a;
  RENAME TABLE current_db.tbl_name TO other_db.tbl_name;
  #end
  #begin
  -- Truncate table
  truncate table t1;
  truncate parent_table;
  truncate `#`;
  truncate `#!^%$`;
  #end
  #begin
  -- Create database
  create database somedb;
  create schema if not exists myschema;
  create schema `select` default character set = utf8;
  create database if not exists `current_date` character set cp1251;
  create database super default character set utf8 collate = utf8_bin character set utf8 collate utf8_bin;
  #end
  #begin
  -- Create event 1
  -- delimiter //
  create definer = current_user event if not exists someevent on schedule at current_timestamp + interval 30 minute
  on completion preserve do begin insert into test.t1 values (33), (111);select * from test.t1; end; -- //
  #end
  #begin
  -- Create event 2
  create definer = 'ivan'@'%' event testevent1 on schedule every 1 hour ends '2016-11-05 23:59:00'
  do begin select * from test.t2; end; -- //
  #end
  #begin
  -- Create event 3
  create definer = current_user() event testevent2 on schedule at '2016-11-03 23:59:00'
  do begin update test.t2 set 1c = 1c + 1; end; -- //
  -- delimiter ;
  #end
  #begin
  -- Create index
  create index index1 on t1(col1) comment 'test index' comment 'some test' using btree;
  create unique index index2 using btree on t2(1c desc, `_` asc);
  create index index3 using hash on antlr_tokens(token(30) asc);
  #end
  #begin
  -- Create logfile group
  -- http://dev.mysql.com/doc/refman/5.6/en/create-logfile-group.html
  CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo.dat' INITIAL_SIZE = 10M ENGINE = InnoDB;
  -- CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo.dat' INITIAL_SIZE = 10M;
  CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo.dat' INITIAL_SIZE = 10000000 ENGINE = NDB;
  #end
  #begin
  -- Create server
  -- http://dev.mysql.com/doc/refman/5.6/en/create-server.html
  CREATE SERVER s
  FOREIGN DATA WRAPPER mysql
  OPTIONS (USER 'Remote', HOST '192.168.1.106', DATABASE 'test');
  #end
  #begin
  -- Create tablespace
  create tablespace tblsp1 add datafile 'tblsp_work1' use logfile group lg_1 initial_size = 4G engine MYISAM;
  create tablespace tblsp2 add datafile 'tblsp_proj1' use logfile group lg_6 autoextend_size = 4294 max_size = 2294967296 engine NDB;
  #end
  #begin
  -- Create trigger 1
  -- delimiter //
  create trigger trg_my1 before delete on test.t1 for each row begin insert into log_table values ("delete row from test.t1"); insert into t4 values (old.col1, old.col1 + 5, old.col1 + 7); end; -- //-- delimiter ;
  #end
  #begin
  -- Create trigger 2
  create definer = current_user() trigger trg_my2 after insert on test.t2 for each row insert into log_table values (concat("inserted into table test.t2 values: (1c, _) = (", cast(NEW.col1 as char(100)), ", ", convert(new.`_`, char(100)), ")"));
  #end
  #begin
  -- Create view
  create or replace view my_view1 as select 1 union select 2 limit 0,5;
  create algorithm = merge view my_view2(col1, col2) as select * from t2 with check option;
  create or replace definer = 'ivan'@'%' view my_view3 as select count(*) from t3;
  create or replace definer = current_user sql security invoker view my_view4(c1, 1c, _, c1_2) 
  	as select * from  (t1 as tt1, t2 as tt2) inner join t1 on t1.col1 = tt1.col1;
  
  #end
  