# aijiacms V5.0 R20130122 http://www.yuanmaa.com
# 2013-01-26 21:00:13
# --------------------------------------------------------
DROP TABLE IF EXISTS `aijiacms_404`;
CREATE TABLE `aijiacms_404` (
`itemid` int(10) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`robot` varchar(20) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
`addtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='404日志';
DROP TABLE IF EXISTS `aijiacms_ad`;
CREATE TABLE `aijiacms_ad` (
`aid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`pid` int(10) unsigned NOT NULL default '0',
`typeid` tinyint(1) unsigned NOT NULL default '0',
`areaid` int(10) unsigned NOT NULL default '0',
`amount` float NOT NULL default '0',
`currency` varchar(20) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`introduce` varchar(255) NOT NULL default '',
`hits` int(10) unsigned NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`addtime` int(10) unsigned NOT NULL default '0',
`editor` varchar(30) NOT NULL default '',
`edittime` int(10) unsigned NOT NULL default '0',
`fromtime` int(10) unsigned NOT NULL default '0',
`totime` int(10) unsigned NOT NULL default '0',
`stat` tinyint(1) unsigned NOT NULL default '0',
`note` text NOT NULL,
`code` text NOT NULL,
`text_name` varchar(100) NOT NULL default '',
`text_url` varchar(255) NOT NULL default '',
`text_title` varchar(100) NOT NULL default '',
`text_style` varchar(50) NOT NULL default '',
`image_src` varchar(255) NOT NULL default '',
`image_url` varchar(255) NOT NULL default '',
`image_alt` varchar(100) NOT NULL default '',
`flash_src` varchar(255) NOT NULL default '',
`flash_url` varchar(255) NOT NULL default '',
`flash_loop` tinyint(1) unsigned NOT NULL default '1',
`key_moduleid` smallint(6) unsigned NOT NULL default '0',
`key_catid` smallint(6) unsigned NOT NULL default '0',
`key_word` varchar(100) NOT NULL default '',
`key_id` bigint(20) unsigned NOT NULL default '0',
`listorder` smallint(4) unsigned NOT NULL default '0',
`status` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`aid`),
KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=gbk COMMENT='广告';
INSERT INTO `aijiacms_ad` VALUES('1','全站横幅468x60','5','3','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','','','','','file/image/banner.gif','http://www.yuanmaa.com','AIJIACMS专用VPS主机','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('2','网站首页图片轮播1','6','5','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','','','','','file/image/player_1.jpg','http://www.yuanmaa.com','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('3','首页旗帜A1','11','3','0','0','','http://www.yuanmaa.com/','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','','','','','file/image/zhaopin980_80.jpg','http://www.yuanmaa.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('4','首页旗帜A2','12','3','0','0','','http://www.yuanmaa.com/','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','','','','','file/image/ad2980X90.gif','http://www.yuanmaa.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('5','首页文字广告左1','13','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','聚焦2012“金九银十”下成都楼市走向高峰论坛','http://www.yuanmaa.com','','','file/image/150x60.gif','http://idc.aijiacms.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('6',' 首页文字广告左2','14','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','爱家房产网招商中','http://www.yuanmaa.com','','#FF0000','file/image/150x60.gif','http://idc.aijiacms.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('7',' 首页文字广告左3','15','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','房产网全国招商','http://www.yuanmaa.com','','#0000FF','file/image/150x60.gif','http://idc.aijiacms.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('8','首页文字广告左4','16','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1306857600','1433174399','0','','','聚焦2012“金九银十”下成都楼市走向高峰论坛 ','http://www.yuanmaa.com','','','file/image/150x60.gif','http://idc.aijiacms.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('9','首页导航下图片广告左1','17','3','0','0','','','','0','taofangqu','1357546477','taofangqu','1357546477','1321977600','1385135999','0','','','本广告位招商中','http://www.yuanmaa.com','','','http://localhost/file/upload/201212/28/13-07-42-10-1.jpg','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('10','首页导航下图片广告中','18','3','0','0','','','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','本广告位招商中','http://www.yuanmaa.com','','#FF0000','http://localhost/file/upload/201212/28/13-08-49-34-1.jpg','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('11','首页导航下图片广告右1','19','3','0','0','','','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','回往过去看民国那些如诗如画的才女','http://www.yuanmaa.com','','','http://localhost/file/upload/201212/28/13-09-26-77-1.jpg','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('12',' 首页文字广告中上2','20','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','存准金率下调楼市影响甚微石家庄高性价比楼盘','http://www.yuanmaa.com','','','','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('13','首页文字广告中上3','21','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','聚焦2012“金九银十”下成都楼市走向高峰论坛','http://www.yuanmaa.com','','','','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('14','首页文字广告中1','22','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1386863999','0','','','首页文字广告中1','http://www.yuanmaa.com','','','file/image/center_68580.jpg','http://www.yuanmaa.com/','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('15','首页文字广告中下1','23','2','0','0','','http://www.yuanmaa.com','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','冬日恋歌——爱上最美雪景美墅','http://www.yuanmaa.com','','','','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('16',' 首页横幅广告1','24','3','0','0','','','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','“20+X”2011年省会成都重点商贸项目最新进度汇报','http://www.yuanmaa.com','','','http://localhost/file/upload/201212/28/13-11-55-87-1.jpg','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('17','首页资讯左广告','25','3','0','0','','','','0','taofangqu','1357546477','taofangqu','1357546477','1323705600','1418399999','0','','','2011年12月成都市最新楼盘推荐 ','http://www.yuanmaa.com','','#FF6600','http://localhost/file/upload/201212/28/13-12-36-82-1.jpg','','','','','1','0','0','','0','0','3');
INSERT INTO `aijiacms_ad` VALUES('1
评论30
最新资源