CREATE TABLE `t1` (
	`a` VARCHAR(10) NULL DEFAULT '' COMMENT '???						' COLLATE 'utf8_bin',
	`b` VARCHAR(20) NULL DEFAULT '' COMMENT '?????				' COLLATE 'utf8_bin',
	`c` VARCHAR(10) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`d` VARCHAR(20) NULL DEFAULT '' COMMENT '?????				' COLLATE 'utf8_bin',
	`e` VARCHAR(10) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`f` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '?????				    ',
	`g` VARCHAR(20) NULL DEFAULT '' COMMENT '?????				' COLLATE 'utf8_bin',
	`h` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '?????				    ',
	`i` VARCHAR(20) NULL DEFAULT '' COMMENT '?????' COLLATE 'utf8_bin',
	`j` TIMESTAMP NULL DEFAULT NULL COMMENT '?????',
	`k` VARCHAR(20) NULL DEFAULT '' COMMENT '?????' COLLATE 'utf8_bin',
	`l` TIMESTAMP NULL DEFAULT NULL COMMENT '?????',
	`m` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`n` DATE NULL DEFAULT NULL COMMENT '????				    ',
	`o` VARCHAR(10) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`p` VARCHAR(80) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`q` VARCHAR(10) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`r` VARCHAR(80) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`s` VARCHAR(10) NULL DEFAULT '' COMMENT '????????		' COLLATE 'utf8_bin',
	`t` VARCHAR(80) NULL DEFAULT '' COMMENT '??????????	' COLLATE 'utf8_bin',
	`u` VARCHAR(20) NULL DEFAULT '' COMMENT '???					' COLLATE 'utf8_bin',
	`v` VARCHAR(80) NULL DEFAULT '' COMMENT '?????				' COLLATE 'utf8_bin',
	`w` VARCHAR(10) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`x` VARCHAR(80) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`y` VARCHAR(1) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`z` VARCHAR(10) NULL DEFAULT '' COMMENT '??					' COLLATE 'utf8_bin',
	`aa` VARCHAR(80) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`ab` VARCHAR(1) NULL DEFAULT '' COMMENT '??					' COLLATE 'utf8_bin',
	`ac` DECIMAL(5,2) NULL DEFAULT NULL COMMENT '??					    ',
	`ad` VARCHAR(10) NULL DEFAULT '' COMMENT '??					' COLLATE 'utf8_bin',
	`ae` VARCHAR(80) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`af` DECIMAL(20,10) NULL DEFAULT NULL COMMENT '??					    ',
	`ag` VARCHAR(10) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`ah` VARCHAR(80) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`ai` VARCHAR(1) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`aj` VARCHAR(2) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`ak` VARCHAR(12) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`al` VARCHAR(80) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`am` DATE NULL DEFAULT NULL COMMENT '????				    ',
	`an` CHAR(1) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`ao` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '???????			    ',
	`ap` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '???????			    ',
	`aq` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '????????		    ',
	`ar` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '???????			    ',
	`as` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '???????			    ',
	`at` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '????????		    ',
	`au` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '?????',
	`av` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '?????',
	`aw` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '??????',
	`ax` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '??????',
	`ay` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '??????			    ',
	`az` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '????				    ',
	`ba` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '??????			    ',
	`bb` DECIMAL(20,6) NULL DEFAULT NULL COMMENT '???					    ',
	`bc` VARCHAR(24) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bd` VARCHAR(80) NULL DEFAULT '' COMMENT '????????		' COLLATE 'utf8_bin',
	`be` VARCHAR(24) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bf` VARCHAR(80) NULL DEFAULT '' COMMENT '????????		' COLLATE 'utf8_bin',
	`bg` VARCHAR(24) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bh` VARCHAR(80) NULL DEFAULT '' COMMENT '????????		' COLLATE 'utf8_bin',
	`bi` VARCHAR(24) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bj` VARCHAR(80) NULL DEFAULT '' COMMENT '????????		' COLLATE 'utf8_bin',
	`bk` VARCHAR(10) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`bl` VARCHAR(80) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`bm` VARCHAR(20) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`bn` VARCHAR(80) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`bo` VARCHAR(10) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bp` VARCHAR(80) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bq` VARCHAR(10) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`br` VARCHAR(80) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`bs` VARCHAR(10) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`bt` VARCHAR(80) NULL DEFAULT '' COMMENT '????				' COLLATE 'utf8_bin',
	`bu` VARCHAR(10) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bv` VARCHAR(80) NULL DEFAULT '' COMMENT '??????			' COLLATE 'utf8_bin',
	`bw` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '1' COMMENT '??????',
	`bx` VARCHAR(10) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`by` VARCHAR(10) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`bz` VARCHAR(80) NULL DEFAULT '' COMMENT '????????' COLLATE 'utf8_bin',
	`ca` VARCHAR(10) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`cb` VARCHAR(80) NULL DEFAULT '' COMMENT '????????' COLLATE 'utf8_bin',
	`cc` VARCHAR(10) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cd` VARCHAR(80) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`ce` VARCHAR(10) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cf` VARCHAR(80) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cg` VARCHAR(24) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`ch` VARCHAR(80) NULL DEFAULT '' COMMENT '????????' COLLATE 'utf8_bin',
	`ci` VARCHAR(30) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`cj` VARCHAR(255) NULL DEFAULT '' COMMENT '??' COLLATE 'utf8_bin',
	`ck` VARCHAR(10) NULL DEFAULT '' COMMENT '???????' COLLATE 'utf8_bin',
	`cl` VARCHAR(80) NULL DEFAULT '' COMMENT '???????' COLLATE 'utf8_bin',
	`cm` VARCHAR(10) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`cn` VARCHAR(80) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`co` VARCHAR(1) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cp` VARCHAR(30) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cq` VARCHAR(3000) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cr` VARCHAR(255) NULL DEFAULT '' COMMENT '????' COLLATE 'utf8_bin',
	`cs` VARCHAR(1) NULL DEFAULT '' COMMENT '?????' COLLATE 'utf8_bin',
	`ct` DECIMAL(20,6) NULL DEFAULT '0.000000' COMMENT '???????',
	`cu` VARCHAR(30) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`cv` VARCHAR(10) NULL DEFAULT '' COMMENT '??????' COLLATE 'utf8_bin',
	`cw` VARCHAR(80) NULL DEFAULT '' COMMENT '????????' COLLATE 'utf8_bin',
	`cx` VARCHAR(1) NULL DEFAULT 'N' COMMENT '?????' COLLATE 'utf8_bin',
	`cy` VARCHAR(10) NULL DEFAULT '' COMMENT '???????' COLLATE 'utf8_bin',
	PRIMARY KEY (`m`),
	INDEX `idx_a` (`n`),
	INDEX `idx_b` (`q`)
)
COMMENT='?????????'
COLLATE='utf8_bin'
ENGINE=InnoDB
;

ALTER TABLE t1 ADD COLUMN cz VARCHAR(10)   NOT NULL  DEFAULT 'Y'  COMMENT '????????? ???�B????';