创建广告信息表
CREATE TABLE `ad_click`(
`ad_click_id` INT(100) NOT NULL AUTO_INCREMENT COMMENT '点击明细id',
`user_name` VARCHAR(50) NOT NULL COMMENT '用户名',
`ad_click_num` INT(200) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY(`ad_click_id`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
CREATE TABLE `ad_position`(
`ad_position_id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '广告位id',
`ad_position_name` VARCHAR(50) NOT NULL COMMENT '广告位名称',
`ad_position_order` INT(10) NOT NULL COMMENT '广告位顺序(优先级)',
PRIMARY KEY(`ad_position_id`)
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
CREATE TABLE `ad_info`(
`ad_id` INT(255) NOT NULL AUTO_INCREMENT COMMENT '广告id',
`ad_name` VARCHAR(50) NOT NULL COMMENT '广告名称',
`ad_url` VARCHAR(200) NOT NULL COMMENT '广告链接',
`ad_image&