use test;
drop table if exists test;
create table test (
  test_set set( 'val1', 'val2', 'val3' ) not null default '',
  name char(20) default 'O''Brien'
  ) comment = 'it\'s a table' ;
@r/shw000001.result show create table test ;