-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 5.5.28 - MySQL Community Server (GPL)
-- 服务器操作系统: Win64
-- HeidiSQL 版本: 12.0.0.6468
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
-- 导出 infocomb2b 的数据库结构
DROP DATABASE IF EXISTS `infocomb2b`;
CREATE DATABASE IF NOT EXISTS `infocomb2b` /*!40100 DEFAULT CHARACTER SET gb2312 */;
USE `infocomb2b`;
-- 导出 表 infocomb2b.ad 结构
DROP TABLE IF EXISTS `ad`;
CREATE TABLE IF NOT EXISTS `ad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(50) DEFAULT NULL,
`pic` varchar(50) DEFAULT NULL,
`remark` longtext,
`url` varchar(255) DEFAULT NULL,
`inputdatetime` datetime DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- 正在导出表 infocomb2b.ad 的数据:~3 rows (大约)
DELETE FROM `ad`;
INSERT INTO `ad` (`id`, `title`, `pic`, `remark`, `url`, `inputdatetime`) VALUES
(7, '首页广告招商', 'upload/images/1677666653115.gif', '<p>\r\n 首页广告招商200元/月</p>', 'ad/index.jsp', '2023-03-01 18:35:36'),
(8, '江西省抚州市信通网络科技有限公司', 'upload/images/1677669410912.gif', '<p>\r\n 江西省抚州市信通网络科技有限公司主营:域名注册、虚拟主机、网站建设、网站推广!</p>', 'http://localhost:8080/jxfzicnet/', '2023-03-01 19:18:05'),
(9, '网上谈生意,首选信通商务网', 'upload/images/1677670014964.gif', '<p>\r\n 网上谈生意,首选信通商务网</p>', 'index.jsp', '2023-03-01 19:27:17');
-- 导出 表 infocomb2b.admin 结构
DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`managername` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- 正在导出表 infocomb2b.admin 的数据:~2 rows (大约)
DELETE FROM `admin`;
INSERT INTO `admin` (`Id`, `managername`, `password`) VALUES
(1, 'sglg1983', 'aa51888888888'),
(2, 'admin', '1234567890');
-- 导出 表 infocomb2b.archives 结构
DROP TABLE IF EXISTS `archives`;
CREATE TABLE IF NOT EXISTS `archives` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` char(50) NOT NULL DEFAULT '0',
`number of people` char(50) NOT NULL DEFAULT '0',
` business volume` char(50) NOT NULL DEFAULT '0',
`foundtime` year(4) NOT NULL DEFAULT '2000',
`brand` char(50) NOT NULL DEFAULT '0',
`corporate representative` char(50) DEFAULT NULL,
`yearinportamount` char(50) DEFAULT NULL,
`manage system identification` char(50) DEFAULT NULL,
`bank` char(50) DEFAULT NULL,
`account number` char(50) DEFAULT NULL,
`registered capital` char(50) DEFAULT NULL,
`mainclients` char(50) DEFAULT NULL,
`yearexportamount` int(11) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- 正在导出表 infocomb2b.archives 的数据:~0 rows (大约)
DELETE FROM `archives`;
-- 导出 表 infocomb2b.b2border 结构
DROP TABLE IF EXISTS `b2border`;
CREATE TABLE IF NOT EXISTS `b2border` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`orderid` varchar(255) DEFAULT NULL,
`username` varchar(50) DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL,
`totalprice` int(11) DEFAULT NULL,
`payment` varchar(255) DEFAULT NULL,
`postway` varchar(255) DEFAULT NULL,
`order_check` enum('0','1') DEFAULT NULL,
`member` varchar(50) DEFAULT NULL,
`orderdate` datetime DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;
-- 正在导出表 infocomb2b.b2border 的数据:~1 rows (大约)
DELETE FROM `b2border`;
INSERT INTO `b2border` (`Id`, `orderid`, `username`, `product_id`, `count`, `totalprice`, `payment`, `postway`, `order_check`, `member`, `orderdate`) VALUES
(1, '2022081701042699', 'jxfzicnet', 1, 1, 800, '银行柜台支付', '邮政包裹/平邮', NULL, 'infocomnet', NULL);
-- 导出 表 infocomb2b.city 结构
DROP TABLE IF EXISTS `city`;
CREATE TABLE IF NOT EXISTS `city` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`provinceid` int(11) DEFAULT NULL,
`cityname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `Id` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=364 DEFAULT CHARSET=gb2312;
-- 正在导出表 infocomb2b.city 的数据:~338 rows (大约)
DELETE FROM `city`;
INSERT INTO `city` (`Id`, `provinceid`, `cityname`) VALUES
(1, 1, '广州市'),
(4, 5, '南昌市'),
(5, 1, '佛山市'),
(6, 5, '抚州市'),
(7, 29, '北京市'),
(8, 29, '上海市'),
(9, 10, '杭州市'),
(10, 5, '鹰潭市'),
(11, 1, '东莞市'),
(13, 5, '吉安市'),
(15, 5, '赣州市'),
(16, 9, '合肥市'),
(17, 11, '南京市'),
(19, 4, '福州市'),
(20, 5, '九江市'),
(21, 20, '长春市'),
(22, 7, '成都市'),
(23, 6, '长沙市'),
(24, 18, '石家庄市'),
(25, 4, '三明市'),
(26, 14, '西安市'),
(27, 13, '武汉市'),
(29, 29, '重庆市'),
(30, 30, '深圳市'),
(31, 30, '珠海市'),
(32, 30, '厦门市'),
(33, 30, '汕头市'),
(34, 30, '海南省'),
(35, 30, '喀什市'),
(36, 31, '香港'),
(37, 31, '澳门'),
(40, 11, '苏州市'),
(41, 6, '株洲市'),
(42, 19, '沈阳市'),
(43, 29, '天津市'),
(44, 19, '大连市'),
(47, 1, '惠州市'),
(49, 2, '南宁市'),
(50, 16, '太原市'),
(51, 17, '郑州市'),
(52, 2, '柳州市'),
(53, 12, '济南市'),
(54, 2, '桂林市'),
(56, 5, '萍乡市'),
(57, 5, '新余市'),
(58, 5, '上饶市'),
(59, 10, '金华市'),
(60, 1, '肇庆市'),
(61, 1, '揭阳市'),
(62, 1, '茂名市'),
(63, 1, '湛江市'),
(64, 12, '青岛市'),
(65, 16, '大同市'),
(66, 14, '宝鸡市'),
(67, 16, '运城市'),
(68, 16, '晋城市'),
(69, 16, '临汾市'),
(70, 1, '中山市'),
(72, 24, '呼和浩特市'),
(73, 24, '包头市'),
(74, 26, '乌鲁木齐市'),
(75, 25, '拉萨市'),
(76, 25, '昌都市'),
(77, 3, '贵阳市'),
(81, 10, '宁波市'),
(82, 10, '台州市'),
(83, 10, '衢州市'),
(84, 10, '温州市'),
(85, 7, '绵阳市'),
(86, 11, '南通市'),
(87, 11, '连云巷市'),
(88, 11, '常州市'),
(89, 11, '扬州市'),
(90, 8, '昆明市'),
(91, 8, '丽江市'),
(94, 11, '无锡市'),
(95, 21, '哈尔滨市'),
(97, 15, '兰州市'),
(98, 22, '银川市'),
(99, 23, '西宁市'),
(101, 7, '南充市'),
(102, 19, '抚顺市'),
(103, 19, '锦州市'),
(104, 5, '宜春市'),
(105, 4, '蒲田市'),
(106, 10, '嘉兴市'),
(107, 5, '景德镇市'),
(108, 1, '江门市'),
(110, 1, '梅州市'),
(111, 1, '河源市'),
(112, 1, '韶关市'),
(113, 3, '遵义市'),
(114, 3, '六盘水市'),
(115, 2, '梧州市'),
(116, 2, '北海市'),
(117, 2, '防城港市'),
(118, 2, '钦州市'),
(119, 2, '贵港市'),
(120, 2, '玉林市'),
(121, 2, '贺州市'),
(122, 2, '百色市'),
(123, 10, '绍兴市'),
(124, 10, '舟山市'),
(125, 10, '丽水市'),
(126, 9, '芜湖市'),
(127, 9, '蚌埠市'),
(128, 4, '泉州市'),
(129, 4, '漳州市'),
(130, 4, '龙岩市'),
(131, 4, '南平市'),
(132, 20, '吉林市'),
(133, 6, '张家界市'),
(134, 6, '郴州市'),
(135, 13, '黄石市'),
(136, 13, '宜昌市'),
(137, 13, '鄂州市'),
(138, 13,