CREATE TABLE `ecs_lottery` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`goods_id` mediumint(8) unsigned NOT NULL,
`shop_price` decimal(10,2) unsigned NOT NULL default '0.00',
`point` mediumint(8) unsigned NOT NULL,
`pro` mediumint(8) unsigned NOT NULL,
`lg` mediumint(8) unsigned NOT NULL,
`status` tinyint(3) unsigned NOT NULL,
`remark` text NOT NULL,
`winnum` mediumint(8) unsigned NOT NULL,
`total` mediumint(8) unsigned NOT NULL,
`outnum` mediumint(8) unsigned NOT NULL,
`click` mediumint(8) unsigned NOT NULL,
`taobaourl` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `ecs_lottery_group` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`lg_name` varchar(255) NOT NULL,
`lg_pro` mediumint(8) NOT NULL,
`lg_remark` text NOT NULL,
`taobao` tinyint(3) unsigned NOT NULL,
`type` int(11) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `ecs_lottery_user` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`lid` mediumint(8) unsigned NOT NULL,
`user_id` mediumint(8) unsigned NOT NULL,
`status` tinyint(3) unsigned NOT NULL,
`remark` text NOT NULL,
`speech` varchar(255) NOT NULL,
`wintime` int(10) unsigned NOT NULL,
`address` varchar(500) NOT NULL,
`applystatus` tinyint(3) unsigned NOT NULL,
`tel` varchar(255) NOT NULL default '',
`gettime` int(10) unsigned NOT NULL,
`order_id` mediumint(8) unsigned NOT NULL,
`ip` varchar(15) NOT NULL default '',
`address1` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `ecs_wj_award` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL,
`type` tinyint(3) unsigned NOT NULL,
`last_time` int(11) unsigned NOT NULL default '0',
`value` varchar(255) default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `ecs_wj_award_type` (