广告模块的设计

CREATE TABLE `adposition` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`classname` varchar(255) NOT NULL,
`height` int(10) NOT NULL,
`width` int(10) NOT NULL,
`type` int(2) NOT NULL COMMENT '1代表矩形横幅,2代表固定位置,3代表,4代表漂浮移动,5代表图片轮换广告,6代表列表广告,7代表文字广告,8代表代码广告',
`descripe` varchar(255) DEFAULT NULL,
`addtime` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='广告管理板块';

 

CREATE TABLE `admanage` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`pid` int(10) NOT NULL,
`name` varchar(255) NOT NULL,
`startdate` int(10) NOT NULL,
`endate` int(10) NOT NULL,
`link` varchar(255) NOT NULL,
`addtime` int(10) DEFAULT '0',
`description` char(100) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='广告管理内容';

广告表一般为两个表，一张是广告版位表，一张是广告管理表

下边的是phpcms中的表

CREATE TABLE `v9_poster_201505` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` smallint(5) unsigned NOT NULL DEFAULT '0',
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`spaceid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` char(20) NOT NULL,
`area` char(40) NOT NULL,
`ip` char(15) NOT NULL,
`referer` char(120) NOT NULL,
`clicktime` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `pid` (`pid`,`type`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

这个是版位表

CREATE TABLE `v9_poster_space` (
`spaceid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` char(50) NOT NULL,
`type` char(30) NOT NULL,
`path` char(40) NOT NULL,
`width` smallint(4) unsigned NOT NULL DEFAULT '0',
`height` smallint(4) unsigned NOT NULL DEFAULT '0',
`setting` char(100) NOT NULL,
`description` char(100) NOT NULL,
`items` tinyint(3) unsigned NOT NULL DEFAULT '0',
`disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`spaceid`),
KEY `disabled` (`disabled`,`siteid`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

 

CREATE TABLE `v9_poster` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`siteid` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(40) NOT NULL,
`spaceid` smallint(5) unsigned NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL,
`setting` text NOT NULL,
`startdate` int(10) unsigned NOT NULL DEFAULT '0',
`enddate` int(10) unsigned NOT NULL DEFAULT '0',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
`clicks` smallint(5) unsigned NOT NULL DEFAULT '0',
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `spaceid` (`spaceid`,`siteid`,`disabled`,`listorder`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;