B2Bbuilder B2B网站系统

-- phpMyAdmin SQL Dump -- version 2.10.2 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2011 年 04 月 18 日 04:51 -- 服务器版本: 5.0.45 -- PHP 版本: 5.2.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `b2bbuilder_demo` -- -- -------------------------------------------------------- -- -- 表的结构 `hy_admin` -- CREATE TABLE `hy_admin` ( `id` int(3) NOT NULL auto_increment, `user` char(20) NOT NULL, `password` char(35) NOT NULL, `group_id` smallint(5) NOT NULL default '0', `desc` text, `logonums` int(5) default '0', `logoip` varchar(30) default NULL, `lastlogotime` int(11) default '0', `province` varchar(60) default NULL, `city` varchar(60) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ; -- -- 导出表中的数据 `hy_admin` -- INSERT INTO `hy_admin` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 0, NULL, 360, '127.0.0.1', 1303047011, NULL, NULL); -- -------------------------------------------------------- -- -- 表的结构 `hy_advs` -- CREATE TABLE `hy_advs` ( `ID` int(4) NOT NULL auto_increment, `width` varchar(10) default NULL, `height` varchar(10) default NULL, `ad_type` tinyint(1) NOT NULL default '1', `name` varchar(50) NOT NULL default '', `con` mediumtext NOT NULL, `date` datetime default NULL, `price` varchar(50) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ; -- -- 导出表中的数据 `hy_advs` -- INSERT INTO `hy_advs` VALUES (1, NULL, NULL, 1, '全部页面头部', '全部页面头部', '2008-12-17 05:49:53', NULL); INSERT INTO `hy_advs` VALUES (2, '400', '220', 2, '产品类别页', '产品类别页', '2008-12-17 05:50:44', NULL); INSERT INTO `hy_advs` VALUES (3, '478', '168', 2, '首页头部中间', '首页头部中间', '2010-12-18 18:25:28', ''); INSERT INTO `hy_advs` VALUES (4, '', '', 1, '首页促销', '首页促销', '2010-12-18 18:41:53', ''); INSERT INTO `hy_advs` VALUES (5, '', '', 1, '首页类别上', '首页类别上', '2010-12-18 19:28:54', ''); INSERT INTO `hy_advs` VALUES (6, '', '', 1, '首页类别下1', '首页类别下1', '2010-12-18 19:30:54', ''); INSERT INTO `hy_advs` VALUES (7, '', '', 1, '首页类别下2', '首页类别下2', '2010-12-18 19:32:43', ''); INSERT INTO `hy_advs` VALUES (8, NULL, NULL, 1, '首页右三', '首页右一', '2008-12-17 07:48:54', NULL); INSERT INTO `hy_advs` VALUES (9, NULL, NULL, 1, '产品类别左一', '产品类别左一', '2008-12-17 07:49:04', NULL); INSERT INTO `hy_advs` VALUES (10, NULL, NULL, 1, '产品类别右一', '产品类别右一', '2008-12-17 07:48:12', NULL); INSERT INTO `hy_advs` VALUES (11, NULL, NULL, 1, '产品类别右二', '产品类别右二', '2008-12-17 07:49:13', NULL); INSERT INTO `hy_advs` VALUES (12, NULL, NULL, 1, '产品列表左一', '产品列表左一', '2008-12-17 07:49:21', NULL); INSERT INTO `hy_advs` VALUES (13, NULL, NULL, 1, '产品列表左二', '产品列表左二', '2008-12-17 07:49:31', NULL); INSERT INTO `hy_advs` VALUES (14, NULL, NULL, 1, '产品列表右一', '产品列表右一', '2008-12-17 07:49:39', NULL); INSERT INTO `hy_advs` VALUES (15, NULL, NULL, 1, '商情类别左一', '商情类别左一', '2008-12-17 07:49:49', NULL); INSERT INTO `hy_advs` VALUES (16, NULL, NULL, 1, '商情类别右一', '商情类别右一', '2008-12-17 07:49:58', NULL); -- -------------------------------------------------------- -- -- 表的结构 `hy_advs_con` -- CREATE TABLE `hy_advs_con` ( `ID` int(4) NOT NULL auto_increment, `group_id` int(5) default NULL, `name` varchar(50) NOT NULL default '', `type` varchar(20) default NULL, `url` varchar(200) default NULL, `con` mediumtext NOT NULL, `picName` varchar(50) NOT NULL default '', `isopen` int(1) default '0', `stime` date default NULL, `etime` date default NULL, `province` varchar(15) NOT NULL, `city` varchar(15) NOT NULL, `width` char(4) default NULL, `height` char(4) default NULL, `catid` int(8) default NULL, `sname` varchar(30) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ; -- -- 导出表中的数据 `hy_advs_con` -- INSERT INTO `hy_advs_con` VALUES (1, 1, '全部页面头部', '2', '', '<script type="text/javascript">\r\n google_ad_client = "pub-4124985563260650";\r\n google_ad_width = 468;\r\n google_ad_height = 60;\r\n google_ad_format = "468x60_as";\r\n google_ad_type = "image";\r\n google_ad_channel = "3720216085";\r\n </script>\r\n <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>', '', 1, '2008-02-12', '2012-02-12', '', '', '', '', NULL, NULL); INSERT INTO `hy_advs_con` VALUES (50, 3, '', '3', '', '', '1292668044.jpg', 1, '2010-12-16', '2012-12-14', '', '', '', '', 0, ''); INSERT INTO `hy_advs_con` VALUES (51, 4, '', '1', '', '<li>首页促销，可以放任何广告内容</li>', '', 1, '2010-12-18', '2013-12-19', '', '', '', '', 0, ''); INSERT INTO `hy_advs_con` VALUES (52, 5, '', '3', '', '', '1292671791.jpg', 1, '2010-12-18', '2014-12-18', '', '', '', '', 0, ''); INSERT INTO `hy_advs_con` VALUES (53, 6, '', '3', '', '', '1292671913.jpg', 1, '2010-12-18', '2014-12-18', '', '', '', '', 0, ''); INSERT INTO `hy_advs_con` VALUES (54, 7, '', '3', '', '', '1292671984.jpg', 1, '2010-12-18', '2013-12-19', '', '', '', '', 0, ''); INSERT INTO `hy_advs_con` VALUES (8, 8, '首页右三', '2', '', '<script type="text/JavaScript"> \r\nalimama_pid="mm_10052249_145361_2713382"; \r\nalimama_titlecolor="0000FF"; \r\nalimama_descolor ="000000"; \r\nalimama_bgcolor="FFFFFF"; \r\nalimama_bordercolor="E6E6E6"; \r\nalimama_linkcolor="008000"; \r\nalimama_bottomcolor="FFFFFF"; \r\nalimama_anglesize="0"; \r\nalimama_bgpic="0"; \r\nalimama_icon="0"; \r\nalimama_sizecode="13"; \r\nalimama_width=250; \r\nalimama_height=60; \r\nalimama_type=2; \r\n</script> \r\n<script src="http://a.alimama.cn/inf.js" type=text/javascript> \r\n</script>\r\n', '', 1, '0000-00-00', '0000-00-00', '', '', '', '', NULL, NULL); INSERT INTO `hy_advs_con` VALUES (9, 9, '产品类别左一', '2', '', '<script type="text/javascript">\r\n google_ad_client = "pub-4124985563260650";\r\n google_ad_width = 468;\r\n google_ad_height = 60;\r\n google_ad_format = "468x60_as";\r\n google_ad_type = "image";\r\n google_ad_channel = "3720216085";\r\n </script>\r\n <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>', '', 1, '0000-00-00', '0000-00-00', '', '', NULL, NULL, NULL, NULL); INSERT INTO `hy_advs_con` VALUES (10, 10, '产品类别右一', '2', '', '<script type="text/javascript"><!--\r\n google_ad_client = "pub-4124985563260650";\r\n /* 200x200, 创建于 08-7-2 */\r\n google_ad_slot = "8212406579";\r\n google_ad_width = 200;\r\n google_ad_height = 200;\r\n //-->\r\n </script>\r\n <script type="text/javascript"\r\n src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r\n </script>\r\n', '', 1, '0000-00-00', '0000-00-00', '', '', NULL, NULL, NULL, NULL); INSERT INTO `hy_advs_con` VALUES (11, 11, '产品类别右二', '2', '', '<script type="text/JavaScript"> \r\n alimama_pid="mm_10052249_145361_2673601"; \r\n alimama_titlecolor="0000FF"; \r\n alimama_descolor ="000000"; \r\n alimama_bgcolor="FFFFFF"; \r\n alimama_bordercolor="E6E6E6"; \r\n alimama_linkcolor="008000"; \r\n alimama_bottomcolor="FFFFFF"; \r\n alimama_anglesize="0"; \r\n alimama_bgpic="0"; \r\n alimama_icon="0"; \r\n alimama_sizecode="35"; \r\n alimama_width=200; \r\n alimama_height=200; \r\n alimama_type=2; \r\n </script> \r\n <script src="http://a.alimama.cn/inf.js" type=text/javascript> \r\n </script>\r\n', '', 1, '0000-00-00', '0000-00-00', '', '', NULL, NULL, NULL, NULL); INSERT INTO `hy_advs_con` VALUES (12, 12, '产品列表左一', '2', '', '<script type="text/javascript"><!-