SHOW VARIABLES LIKE "%CHAR%";
CREATE DATABASE IF NOT EXISTS test;
USE test;

CREATE TABLE table_coupon_varchar (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo varchar(30) DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO table_coupon_varchar VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300);
SELECT * FROM table_coupon_varchar;

CREATE TABLE table_coupon_text (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo text DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO table_coupon_text VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300);
SELECT * FROM table_coupon_text;

CREATE TABLE table_coupon_mediumtext (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo mediumtext DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO table_coupon_mediumtext VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300);
SELECT * FROM table_coupon_mediumtext;

GRANT ALL ON test.* TO 'root'@'10.0.1.33';
