CREATE TABLE `pw_happylottery_set` (
 `lottery_id` smallint(6) NOT NULL AUTO_INCREMENT,
 `time_start` int(10) unsigned NOT NULL DEFAULT '0',
 `time_limit` int(3) unsigned NOT NULL DEFAULT '0',
 `status` tinyint(1) NOT NULL DEFAULT '0',
 `probability` int(3) unsigned NOT NULL DEFAULT '0',
 `winner_allow` int(3) unsigned NOT NULL DEFAULT '0',
 `winner_count` int(3) unsigned NOT NULL DEFAULT '0',
 `draw_numallow` int(3) unsigned NOT NULL DEFAULT '0',
 `participant_count` int(3) unsigned NOT NULL DEFAULT '0',
 `credit_decrease` varchar(255) NOT NULL,
 `credit_increase` varchar(255) NOT NULL,
 `groupid_allow` varchar(255) NOT NULL,
 `creator` varchar(15) NOT NULL DEFAULT '0',
 `awards` mediumtext NOT NULL,
 `intro` mediumtext NOT NULL,
 PRIMARY KEY (`lottery_id`)
) ENGINE=MyISAM;

CREATE TABLE `pw_happylottery_participant` (
 `lottery_id` smallint(6) unsigned NOT NULL,
 `user_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `draw_count` int(3) unsigned NOT NULL DEFAULT '0',
 KEY `lottery_id` (`lottery_id`,`user_uid`)
) ENGINE=MyISAM;

CREATE TABLE `pw_happylottery_winner` (
 `win_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `lottery_id` smallint(6) NOT NULL DEFAULT '0',
 `win_time` int(10) unsigned NOT NULL DEFAULT '0',
 `user_uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `user_name` varchar(15) NOT NULL,
 `award_content` text NOT NULL,
 PRIMARY KEY (`win_id`),
 KEY `lottery_id` (`lottery_id`),
 KEY `user_uid` (`user_uid`)
) ENGINE=MyISAM;