CREATE TABLE IF NOT EXISTS `pw_ext_activity` (
  `aid` mediumint(8) NOT NULL AUTO_INCREMENT COMMENT '',
  `classid` smallint(5) NOT NULL DEFAULT '0' COMMENT '',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
  `logo` varchar(50) NOT NULL DEFAULT '' COMMENT 'logo',
  `start_month` int(10) NOT NULL DEFAULT '0' COMMENT 'ʱֵ',
  `start_time` int(10) NOT NULL DEFAULT '0' COMMENT 'ʼʱ',
  `end_time` int(10) NOT NULL DEFAULT '0' COMMENT 'ʱ',
  `address` varchar(20) NOT NULL DEFAULT '' COMMENT 'ص',
  `founder` varchar(20) NOT NULL DEFAULT '' COMMENT '',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='ۺݱ' AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pw_ext_activity_class` (
  `class_id` smallint(5) NOT NULL AUTO_INCREMENT COMMENT '',
  `class_name` varchar(20) NOT NULL DEFAULT '' COMMENT '',
  `if_open` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ƿ',
  `activity_num` mediumint(8) NOT NULL DEFAULT '0' COMMENT '',
  PRIMARY KEY (`class_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk COMMENT='ۺϷ' AUTO_INCREMENT=1 ;