Code/*
alter database NC default character set 'utf8'
SHOW VARIABLES LIKE 'character_set_%'
alter table NC_JOKE_CLASS default character set 'utf8'
*/
delete from NC_JOKE_CLASS
CREATE TABLE `NC_JOKE_CLASS` (
`id` bigint(20) NOT NULL auto_increment,
`class_id` varchar(255) character set utf8 default NULL,
`class_name` varchar(255) character set utf8 default NULL,
`sort_id` bigint(20) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `NC_JOKE` (
`id` bigint(20) NOT NULL auto_increment,
`joke_id` varchar(255) character set utf8 default '',
`title` varchar(255) character set utf8 default '',
`content` varchar(255) character set utf8 default '',
`class_name` varchar(255) character set utf8 default '',
`class_id` varchar(255) character set utf8 default '',
`hits` bigint(20) default '0',
`sort_id` bigint(20) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
