瑞宝通java版B2B电子商务网站系统V1.0

/* SQLyog Enterprise - MySQL GUI v8.14 MySQL - 5.0.41-log : Database - rbt_v1 ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `aboutus` */ USE ${dbname}; DROP TABLE IF EXISTS `aboutus`; CREATE TABLE `aboutus` ( `info_id` int(11) NOT NULL auto_increment, `title` varchar(20) NOT NULL, `content` text, `ch_id` int(11) NOT NULL COMMENT '见系统参数表', `user_id` mediumint(9) NOT NULL, `in_date` datetime NOT NULL, PRIMARY KEY (`info_id`), KEY `ch_id` (`ch_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='记录运营商网站信息'; /*Data for the table `aboutus` */ insert into `aboutus`(`info_id`,`title`,`content`,`ch_id`,`user_id`,`in_date`) values (10,'联系我们','<p>\r\n <span style=\"font-size: medium\">联系电话：0592-6036010</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">传真：0592-<!--StartFragment -->6012583</span></p>\r\n<p>\r\n <span style=\"font-size: medium\"><span style=\"font-size: medium\">客服IM</span>： </span><a href=\"http://wpa.qq.com/msgrd?v=3&amp;uin=2585108896&amp;site=qq&amp;menu=yes\" target=\"_blank\"><span style=\"font-size: medium\"><img alt=\"\" border=\"0\" src=\"http://wpa.qq.com/pa?p=1:2585108896:16\" /></span></a><span style=\"font-size: medium\"> </span><a href=\"http://wpa.qq.com/msgrd?v=3&amp;uin=1552925034&amp;site=qq&amp;menu=yes\" target=\"_blank\"><span style=\"font-size: medium\"><img alt=\"\" border=\"0\" src=\"http://wpa.qq.com/pa?p=1:1552925034:16\" /></span></a><span style=\"font-size: medium\"> </span><a href=\"http://wpa.qq.com/msgrd?v=3&amp;uin=1790340028&amp;site=qq&amp;menu=yes\" target=\"_blank\"><span style=\"font-size: medium\"><img alt=\"\" border=\"0\" src=\"http://wpa.qq.com/pa?p=1:1790340028:16\" /></span></a></p>\r\n<p>\r\n <span style=\"font-size: medium\">MSN：</span><a href=\"msnim:chat?contact=ruibaotong@hotmail.com\" target=\"_blank\"><span style=\"font-size: medium\">ruibaotong@hotmail.com</span></a></p>\r\n<p>\r\n <span style=\"font-size: medium\">邮箱：</span><a href=\"mailto:info@ruibaotong.com\"><span style=\"font-size: medium\">info@ruibaotong.com</span></a></p>\r\n<p>\r\n <span style=\"font-size: medium\">网址：</span><a href=\"http://www.ruibaotong.net/\"><span style=\"font-size: medium\">www.ruibaotong.net</span></a></p>\r\n<p>\r\n <span style=\"font-size: medium\">公司名称：瑞宝通（厦门）信息科技有限公司</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">公司地址：厦门市湖里区创业园创业大厦319室</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">邮编：361010</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">工作时间：周一至周五 8:30-12:00&nbsp;&nbsp;13:30-18:00 (法定节假日除外)</span></p>\r\n',2,105,'2011-12-07 21:30:42'),(16,'企业介绍','<p>\r\n <span style=\"font-size: medium\"><strong>瑞宝通（厦门）信息科技有限公司</strong>是厦门一家互联网电子商务技术型公司。</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">公司拥有互联网核心产品<strong><a href=\"http://www.ruibaotong.net/product/index.html\">瑞宝通JAVA版B2B电子商务系统</a></strong>，为B2B电子商务行业门户网站提供完善的解决方案和技术支持。</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">公司研发团队拥有多年互联网电子商务开发运营经验，尤其精通JAVA+MySQL下的WEB开发，在WEB标准、用户体验、SEO等领域有独特的研究与经验，并将这些经验与技术融于产品的研发之中。</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">团队成员全部拥有学士或硕士学历，他们对工作充满激情、思维活跃、敢于挑战，勇于创新，在服务客户方面体现了专业的水准和热情。在公司成立之前，我们的团队已经为国内外数百家网站提供了技术支持或咨询，获得了客户的一致好评。</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">瑞宝通公司锐意进取，以领先的技术为依托，优质的服务为保证，为国内外数千万企业提供安全、快捷的电子商务服务。</span></p>\r\n<p>\r\n <span style=\"font-size: medium\">我们对产品追求的终极目标是：做全球最大的电子商务平台提供商。</span></p>\r\n',1,105,'2012-01-18 14:55:40'); /*Table structure for table `advinfo` */ DROP TABLE IF EXISTS `advinfo`; CREATE TABLE `advinfo` ( `adv_id` int(11) NOT NULL auto_increment, `pos_id` int(11) NOT NULL, `adv_name` varchar(100) NOT NULL, `adv_desc` varchar(200) default NULL, `keyword` varchar(100) default NULL, `info_id` mediumint(9) default '0', `cat_attr` varchar(100) default NULL, `adv_code` text, `img_path` varchar(100) default NULL, `flash_url` varchar(100) default NULL, `link_url` varchar(100) default '', `title` varchar(100) default NULL, `content` varchar(200) default NULL, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `remark` varchar(200) default NULL, `cust_id` mediumint(9) default NULL, `adv_state` char(1) NOT NULL COMMENT '0：已审核 1：审核中', `iscount` char(1) NOT NULL COMMENT '0：开启 1：关闭', `addnum` int(11) default NULL, `area_attr` varchar(100) default NULL, PRIMARY KEY (`adv_id`), KEY `pos_id` (`pos_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `advinfo` */ insert into `advinfo`(`adv_id`,`pos_id`,`adv_name`,`adv_desc`,`keyword`,`info_id`,`cat_attr`,`adv_code`,`img_path`,`flash_url`,`link_url`,`title`,`content`,`start_date`,`end_date`,`remark`,`cust_id`,`adv_state`,`iscount`,`addnum`,`area_attr`) values (126,105,'供应列表页关键字广告','12312321321','包包',111,NULL,'',NULL,'','','','','2011-10-27 00:00:00','2011-10-31 00:00:00','',0,'0','1',0,'0'),(128,105,'供应列表页关键字广告','','名牌YSL',110,'2561646623','',NULL,'','http://www.google.cn','盐城市科博液压机械制造有限公司','投资有风险，入市需谨慎投资有风险，入市需谨慎投资有风险，入市需谨慎投资有风险，入市需谨慎投资有风险，入市需谨慎投资有风险，入市需谨慎投资有风险，入市需谨慎投资有风险，入市需谨慎','2011-11-01 00:00:00','2011-11-26 00:00:00','',0,'0','0',0,NULL),(129,107,'供应列表页右侧广告','','',0,'6163271374,8217215237','',NULL,'','http//:www.baidu.com','关键字广告1','12321323','2011-11-03 00:00:00','2011-12-30 00:00:00','',0,'0','1',0,NULL),(130,107,'供应列表页右侧广告','','',0,'2877551637','',NULL,'','http//:www.baidu.com','关键字广告2','21321321','2011-11-03 00:00:00','2011-11-30 00:00:00','',0,'0','1',0,'0'),(135,105,'供应列表页关键字广告','3213213','名牌YSL',108,NULL,'',NULL,'','http://www.baidu.net','瑞宝通c2C','投资有风险，入市需谨慎','2011-11-03 00:00:00','2011-11-26 00:00:00','',0,'0','0',0,NULL),(137,71,'图库列表页-图库排行下方第一张图片广告','','',0,NULL,'','/include/images/adv/250.gif','','http://www.ruibaotong.net','瑞宝通B2B','','2011-10-05 00:00:00','2016-11-24 00:00:00','',0,'0','1',0,NULL),(138,72,'图库列表页-图库排行下方第二张图片广告','','',0,NULL,'','/include/images/adv/250.gif','','http://www.ruibaotong.net','瑞宝通B2B','','2011-10-12 00:00:00','2016-11-24 00:00:00','',0,'0','1',0,NULL),(139,47,'专题栏目页-导航下方大张图片广告','','',0,NULL,'','/include/images/adv/960.gif','','http://www.ruibaotong.net','瑞宝通B2B','','2011-10-08 00:00:00','2014-10-28 00:00:00'