File: //erp.tbbprovision.com.sql
-- MySQL dump 10.14 Distrib 5.5.56-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: tbberp
-- ------------------------------------------------------
-- Server version 5.5.56-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 `t_dic_bank_info`
--
DROP TABLE IF EXISTS `t_dic_bank_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_bank_info` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`bankNumber` varchar(100) DEFAULT NULL COMMENT '银行编号',
`intermediaryBank` varchar(100) DEFAULT NULL COMMENT '中间银行',
`intermediaryBankSwift` varchar(100) DEFAULT NULL COMMENT '中间行SWIFT',
`bankName` varchar(100) DEFAULT NULL COMMENT '银行名称',
`swiftCode` varchar(100) DEFAULT NULL COMMENT 'SWIFT号',
`bankAddress` varchar(200) DEFAULT NULL COMMENT '银行地址',
`bankContact` varchar(50) DEFAULT NULL COMMENT '银行联系人',
`bankPhone` varchar(50) DEFAULT NULL COMMENT '银行电话',
`selfCompanyId` smallint(6) DEFAULT '0' COMMENT '我方公司ID',
`bankAccount` varchar(50) DEFAULT NULL COMMENT '银行帐号',
`bankNote` varchar(255) DEFAULT NULL COMMENT '银行备注',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='字典 - 银行资料';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_bank_info`
--
LOCK TABLES `t_dic_bank_info` WRITE;
/*!40000 ALTER TABLE `t_dic_bank_info` DISABLE KEYS */;
INSERT INTO `t_dic_bank_info` VALUES (1,'外币收汇账户','','','中国银行上海浦东开发区支行','BKCHCNBJ300','上海市浦东新区新金桥路1888号40栋','严老师','50308556',1,'457259260499','',0),(2,'人民币账户','','','中国银行上海浦东开发区支行','','上海市浦东新区新金桥路1888号40栋','对公柜台','20512669',1,'448159218164','',0);
/*!40000 ALTER TABLE `t_dic_bank_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_bank_interest_rate`
--
DROP TABLE IF EXISTS `t_dic_bank_interest_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_bank_interest_rate` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`interestRate` decimal(10,5) DEFAULT '0.00000' COMMENT '银行利率',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='字典 - 银行利率';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_bank_interest_rate`
--
LOCK TABLES `t_dic_bank_interest_rate` WRITE;
/*!40000 ALTER TABLE `t_dic_bank_interest_rate` DISABLE KEYS */;
INSERT INTO `t_dic_bank_interest_rate` VALUES (2,0.00580);
/*!40000 ALTER TABLE `t_dic_bank_interest_rate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_container_model`
--
DROP TABLE IF EXISTS `t_dic_container_model`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_container_model` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(30) DEFAULT NULL COMMENT '名称',
`volume` varchar(30) DEFAULT NULL COMMENT '容积',
`maximumWeight` varchar(30) DEFAULT NULL COMMENT '最大装重',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='字典 - 货柜型号';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_container_model`
--
LOCK TABLES `t_dic_container_model` WRITE;
/*!40000 ALTER TABLE `t_dic_container_model` DISABLE KEYS */;
INSERT INTO `t_dic_container_model` VALUES (4,'40GP','0','0',0),(3,'20GP','0','0',0);
/*!40000 ALTER TABLE `t_dic_container_model` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_cooperation_level`
--
DROP TABLE IF EXISTS `t_dic_cooperation_level`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_cooperation_level` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`cooperationLevel` varchar(100) DEFAULT NULL COMMENT '合作等级',
`description` varchar(255) DEFAULT NULL COMMENT '等级说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='字典 - 合作等级';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_cooperation_level`
--
LOCK TABLES `t_dic_cooperation_level` WRITE;
/*!40000 ALTER TABLE `t_dic_cooperation_level` DISABLE KEYS */;
INSERT INTO `t_dic_cooperation_level` VALUES (2,'优秀-年销售额超过USD50W','年销售额超过USD50W',0),(4,'良好-年销售额超过USD20W','年销售额超过USD20W',0),(5,'合格-年销售额超过USD5W','年销售额超过USD5W',0),(6,'不合格-需求难以匹配价格低','需求难以匹配价格低',0);
/*!40000 ALTER TABLE `t_dic_cooperation_level` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_credit_rating`
--
DROP TABLE IF EXISTS `t_dic_credit_rating`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_credit_rating` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`creditRating` varchar(100) DEFAULT NULL COMMENT '信用等级',
`description` varchar(255) DEFAULT 'M' COMMENT '等级说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='字典 - 信用等级';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_credit_rating`
--
LOCK TABLES `t_dic_credit_rating` WRITE;
/*!40000 ALTER TABLE `t_dic_credit_rating` DISABLE KEYS */;
INSERT INTO `t_dic_credit_rating` VALUES (1,'优秀-3年合作以上无逾期付款','合作3年以上无逾期付款',0),(3,'良好-1年合作以上无逾期付款','1年合作以上无逾期付款',0),(4,'合格-1年以上合作个别逾期不超过3天','1年以上合作个别逾期不超过3天',0),(5,'不合格-频繁逾期期限超过1周','频繁逾期期限超过1周',0);
/*!40000 ALTER TABLE `t_dic_credit_rating` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_contact_department`
--
DROP TABLE IF EXISTS `t_dic_customer_contact_department`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_contact_department` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(70) DEFAULT NULL COMMENT '属性',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典 - 客户联系人部门';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_contact_department`
--
LOCK TABLES `t_dic_customer_contact_department` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_contact_department` DISABLE KEYS */;
INSERT INTO `t_dic_customer_contact_department` VALUES (1,'Sales Department',0),(2,'Purchasing Department',0);
/*!40000 ALTER TABLE `t_dic_customer_contact_department` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_contact_position`
--
DROP TABLE IF EXISTS `t_dic_customer_contact_position`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_contact_position` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Id',
`attribute` varchar(150) DEFAULT NULL COMMENT '客户联系人职务',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='字典 - 客户联系人职务';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_contact_position`
--
LOCK TABLES `t_dic_customer_contact_position` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_contact_position` DISABLE KEYS */;
INSERT INTO `t_dic_customer_contact_position` VALUES (1,'Sales',0),(2,'Purchaser',0),(3,'Manager',0),(4,'CEO',0);
/*!40000 ALTER TABLE `t_dic_customer_contact_position` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_contract_code`
--
DROP TABLE IF EXISTS `t_dic_customer_contract_code`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_contract_code` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`code` varchar(50) DEFAULT NULL COMMENT '客户合同代码',
`countryId` varchar(50) DEFAULT NULL COMMENT '国家ID\r\n 关联至国家信息表',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COMMENT='字典 - 客户合同代码码';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_contract_code`
--
LOCK TABLES `t_dic_customer_contract_code` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_contract_code` DISABLE KEYS */;
INSERT INTO `t_dic_customer_contract_code` VALUES (1,'AT','14',0),(2,'AR','62',0),(3,'AU','38',0),(4,'BE','13',0),(5,'BR','12',0),(6,'BD','52',0),(7,'BG','23',0),(8,'BY','34',0),(9,'CA','28',0),(10,'CN','16',0),(11,'CH','45',0),(12,'CL','47',0),(13,'CN','16',0),(14,'CO','60',0),(15,'CS','35',0),(16,'CZ','76',0),(17,'DE','1',0),(18,'DK','11',0),(19,'DM','11',0),(20,'EC','46',0),(21,'EE','77',0),(22,'ES','4',0),(23,'FR','7',0),(24,'FI','30',0),(25,'GB','5',0),(26,'GT','84',0),(27,'HN','85',0),(28,'HU','58',0),(29,'IN','10',0),(30,'IT','3',0),(31,'ID','73',0),(32,'IE','8',0),(33,'IL','32',0),(34,'IQ','94',0),(35,'IR','18',0),(36,'JP','51',0),(37,'KE','65',0),(38,'KR','19',0),(39,'LB','61',0),(40,'LT','68',0),(41,'LU','80',0),(42,'LV','88',0),(43,'LY','74',0),(44,'PL','2',0),(45,'MA','72',0),(46,'MX','40',0),(47,'MY','17',0),(48,'MZ','81',0),(49,'NL','6',0),(50,'OM','59',0),(51,'PA','89',0),(52,'PE','20',0),(53,'PH','27',0),(54,'PK','24',0),(55,'PT','42',0),(56,'PY','63',0),(57,'RU','15',0),(58,'RO','69',0),(59,'SE','37',0),(60,'SG','43',0),(61,'SI','29',0),(62,'SK','26',0),(63,'TH','41',0),(64,'TR','25',0),(65,'TZ','70',0),(66,'US','9',0),(67,'UA','21',0),(68,'UY','66',0),(69,'VE','64',0),(70,'VN','56',0),(71,'ZA','33',0),(72,'ZW','71',0);
/*!40000 ALTER TABLE `t_dic_customer_contract_code` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_demand_brand`
--
DROP TABLE IF EXISTS `t_dic_customer_demand_brand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_demand_brand` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`brandName` varchar(150) DEFAULT NULL COMMENT '品牌名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='字典 - 内销客户需求品牌';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_demand_brand`
--
LOCK TABLES `t_dic_customer_demand_brand` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_demand_brand` DISABLE KEYS */;
INSERT INTO `t_dic_customer_demand_brand` VALUES (4,'NTN',0),(3,'TBB',0),(5,'SKF',0),(6,'INA',0),(7,'FAG',0);
/*!40000 ALTER TABLE `t_dic_customer_demand_brand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_ordering_category`
--
DROP TABLE IF EXISTS `t_dic_customer_ordering_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_ordering_category` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`categoryName` varchar(255) DEFAULT NULL COMMENT '客户常定品类',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='字典 - 客户常定品类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_ordering_category`
--
LOCK TABLES `t_dic_customer_ordering_category` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_ordering_category` DISABLE KEYS */;
INSERT INTO `t_dic_customer_ordering_category` VALUES (6,'Cylindrical roller bearing',0),(5,'Deep groove ball bearing',0),(7,'Tapered roller bearing',0),(8,'Angular contatct ball bearing',0),(9,'Thrust ball bearing',0),(10,'EMQ ball bearing',0),(11,'Needle roller bearing',0),(12,'Insert bearing',0),(13,'Pillow block',0),(14,'Clutch bearing',0),(15,'Water pump bearing',0),(16,'Flanged bearing',0),(17,'Agricultural bearing',0),(18,'Air bearing',0),(19,'Adpater sleeve',0),(20,'Automobile bearing',0),(21,'Ball screw support bearing',0),(22,'High precision bearing',0),(23,'Wheel hub bearing',0),(24,'Linear ball bearing',0),(25,'Oilless bearing',0),(26,'Slewing bearing',0),(27,'Stainless steel bearing',0),(28,'Ceramic bearing',0);
/*!40000 ALTER TABLE `t_dic_customer_ordering_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_source`
--
DROP TABLE IF EXISTS `t_dic_customer_source`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_source` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`customerSource` varchar(150) DEFAULT NULL COMMENT '客户来源',
`description` varchar(255) DEFAULT NULL COMMENT '说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='字典 - 客户来源';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_source`
--
LOCK TABLES `t_dic_customer_source` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_source` DISABLE KEYS */;
INSERT INTO `t_dic_customer_source` VALUES (6,'TBB电商网站','www.tbbbearing.com',0),(5,'Client\'s web info','',0),(7,'Recommendation','',0),(8,'客户主动联系','',0),(9,'已验证','此类别用于管理已经经过验证的数据',0),(10,'2013前Bearingnet','',0),(11,'2013前Hannover Messe','',0),(12,'20130123Bearingnet','',0),(13,'201304世界贸易数据库','',0),(14,'特易资讯','',0),(15,'2013法国巴黎国际工业配件展','',0),(16,'雅虎','',0),(17,'Bearingnet2014','',0),(18,'2014Hannover Messe','',0),(19,'2015土耳其展会','',0),(20,'2015年印度新德里展会','',0),(21,'2013摩洛哥工业配件展','',0),(22,'阿里巴巴','',0),(23,'2016上海轴承展','',0),(24,'AAPEX 2016','',0),(25,'Avention','外贸数据工具',0),(26,'2017 hannover messe','2017年德国汉诺威展商或行业观众',0),(27,'VDMA','德国机械设备制造业联合会',0),(28,'Instragram','',0),(29,'LinkedIn','',0),(30,'Facebook','',0),(31,'2017韩国KOAA & KOMAF展会','展商或观众',0),(32,'2017上海法兰克福汽配展','',0),(33,'INTERMACH 2018','',0),(34,'2018上海轴承展','',0);
/*!40000 ALTER TABLE `t_dic_customer_source` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customer_status`
--
DROP TABLE IF EXISTS `t_dic_customer_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customer_status` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(50) DEFAULT NULL COMMENT '属性',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='客户状态';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customer_status`
--
LOCK TABLES `t_dic_customer_status` WRITE;
/*!40000 ALTER TABLE `t_dic_customer_status` DISABLE KEYS */;
INSERT INTO `t_dic_customer_status` VALUES (1,'线索',0),(2,'意向---有询价',0),(3,'成交',0),(4,'停用',0),(6,'黑名单',0);
/*!40000 ALTER TABLE `t_dic_customer_status` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_customs_code`
--
DROP TABLE IF EXISTS `t_dic_customs_code`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_customs_code` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`customsCode` varchar(50) DEFAULT NULL COMMENT '海关编码',
`productCategoryId` smallint(6) DEFAULT '0' COMMENT '品类ID',
`monitoringCondition` varchar(50) DEFAULT NULL COMMENT '监管条件\r\n 下拉框，\r\n 无/商检',
`customsDeclaration` varchar(50) DEFAULT NULL COMMENT '报关方式,下拉框\r\n 选项：个/套/台/千克',
`taxRebateRate` decimal(10,4) DEFAULT '0.0000' COMMENT '退税率',
`vATRate` decimal(10,4) DEFAULT '0.0000' COMMENT '增值税率',
`importTariffs` decimal(10,4) DEFAULT '0.0000' COMMENT '进口关税',
`declarationElement` varchar(500) DEFAULT NULL COMMENT '申报要素',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='字典 - 海关编码';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_customs_code`
--
LOCK TABLES `t_dic_customs_code` WRITE;
/*!40000 ALTER TABLE `t_dic_customs_code` DISABLE KEYS */;
INSERT INTO `t_dic_customs_code` VALUES (3,'8482102000',7,'商检','套',15.0000,17.0000,0.0000,'品名：轴承\r\n用途：矿山机械或者纺织机械使用',0),(10,'8482102000',8,'无','个',15.0000,17.0000,0.0000,'品名：轴承\r\n用途：矿山机械或者纺织机械使用',0),(11,'8482109000',9,'无','个',15.0000,17.0000,0.0000,'品名：轴承\r\n用途：矿山机械或者纺织机械使用',0);
/*!40000 ALTER TABLE `t_dic_customs_code` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_destination_port`
--
DROP TABLE IF EXISTS `t_dic_destination_port`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_destination_port` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(30) DEFAULT NULL COMMENT '中文名称',
`nameEn` varchar(100) DEFAULT NULL COMMENT '英文名称',
`freightPerTon` decimal(10,4) DEFAULT '0.0000' COMMENT '每吨运费',
`airFreightPerKilogram` decimal(10,4) DEFAULT '0.0000' COMMENT '每公斤空运费',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='字典 - 目的口岸';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_destination_port`
--
LOCK TABLES `t_dic_destination_port` WRITE;
/*!40000 ALTER TABLE `t_dic_destination_port` DISABLE KEYS */;
INSERT INTO `t_dic_destination_port` VALUES (3,'热那亚','GENOVA（Italy）',50.0000,0.0000,0),(4,'勒阿弗尔','LE HAVRE（France)',60.0000,0.0000,0),(5,'鹿特丹','ROTTERDAM(Netherlands）',45.0000,0.0000,0),(6,'金奈','CHENNAI（India）',20.0000,0.0000,0),(7,'奥尔胡斯','AARHUS（Denmark ）',55.0000,0.0000,0),(8,'布埃纳文图拉','BUENAVENTURA（Columbia）',140.0000,0.0000,0),(9,'曼萨尼约','MANZANILLO（Mexico）',160.0000,0.0000,0),(10,'萨尔瓦多','EL SALVADOR（Guatemala ）',0.0000,0.0000,0),(11,'卡亚俄','CALLAO（Peru ）',100.0000,0.0000,0),(12,'特马港','TEMA',120.0000,0.0000,0),(13,'瓦尔帕莱索','VALPARAISO（Chile）',140.0000,0.0000,0),(14,'特古西加尔巴','TEGUCIGALPA（Republic of Hondur',160.0000,0.0000,0),(15,'蒙得维的亚','MONTEVIDEO（Uruguay）',130.0000,0.0000,0),(16,'圣何塞','SAN JOSE（the United States）',170.0000,0.0000,0),(17,'拉瓜伊拉','LA GUAIRA（Venezuela）',240.0000,0.0000,0),(18,'南安普敦','SOUTHAMPTON（England）',60.0000,0.0000,0),(19,'格丁尼亚','GDYNIA（Poland）',60.0000,0.0000,0),(20,'都柏林','DUBLIN（Ireland）',55.0000,0.0000,0),(21,'危地马拉海港','QUETZAL（Guatemala）',140.0000,0.0000,0),(22,'汉堡','HAMBURG(GERMANY)',60.0000,0.0000,0),(23,'格丹斯克','GDNASK(POLAND)',65.0000,0.0000,0),(24,'赫斯顿','HESSTON',0.0000,0.0000,0),(25,'孟买新港','NHAVA SHEVA（India）',50.0000,0.0000,0),(26,'仁川港','INCHEON（KOREA)',10.0000,0.0000,0),(27,'无锡','WUXI (China)',0.0000,0.0000,0),(28,'成都','CHENGDU (China)',0.0000,0.0000,0),(29,'保定','BAODING (China)',0.0000,0.0000,0),(30,'圣保罗','São Paulo(BRASIL)',100.0000,0.0000,0),(31,'DINGE(FRANCE)','DINGE(FRANCE)',0.0000,0.0000,0),(32,'曼谷','BANGKOK(THAILAND)',0.0000,0.0000,0),(33,'胡志明市','HO CHI MINH CITY(VIETNAM)',0.0000,0.0000,0),(34,'阿巴斯','Bandar Abbas(Iran)',0.0000,0.0000,0),(35,'京畿道','Gyeonggi-Do (KOREA)',0.0000,0.0000,0);
/*!40000 ALTER TABLE `t_dic_destination_port` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_detect_outer_diameter`
--
DROP TABLE IF EXISTS `t_dic_detect_outer_diameter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_detect_outer_diameter` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Id',
`outerDiameterStart` decimal(10,2) DEFAULT '0.00' COMMENT '外径开始',
`outerDiameterEnd` decimal(10,2) DEFAULT '0.00' COMMENT '外径结束',
`detectionQuantity` smallint(6) DEFAULT '0' COMMENT '检测数量',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典 - 检测外径';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_detect_outer_diameter`
--
LOCK TABLES `t_dic_detect_outer_diameter` WRITE;
/*!40000 ALTER TABLE `t_dic_detect_outer_diameter` DISABLE KEYS */;
INSERT INTO `t_dic_detect_outer_diameter` VALUES (2,10.00,60.00,3,0);
/*!40000 ALTER TABLE `t_dic_detect_outer_diameter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_domestic_sales_quote`
--
DROP TABLE IF EXISTS `t_dic_domestic_sales_quote`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_domestic_sales_quote` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`quotationCategory` varchar(100) DEFAULT NULL COMMENT '报价类别,下拉选项\r\n 内销报价-进口轴承\r\n 内销报价-内销轴承',
`domesticTax` decimal(10,4) DEFAULT '0.0000' COMMENT '国内税金',
`freightRatio` decimal(10,4) DEFAULT '0.0000' COMMENT '运费比',
`tariff` decimal(10,4) DEFAULT '0.0000' COMMENT '关税',
`myOrder` smallint(6) DEFAULT '0' COMMENT ' 排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='字典 - 内销报价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_domestic_sales_quote`
--
LOCK TABLES `t_dic_domestic_sales_quote` WRITE;
/*!40000 ALTER TABLE `t_dic_domestic_sales_quote` DISABLE KEYS */;
INSERT INTO `t_dic_domestic_sales_quote` VALUES (1,'内销报价-进口轴承',1.1500,0.1000,0.0800,0),(4,'内销报价-内销轴承',1.1500,0.1000,0.0000,0);
/*!40000 ALTER TABLE `t_dic_domestic_sales_quote` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_industry`
--
DROP TABLE IF EXISTS `t_dic_industry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_industry` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(100) DEFAULT NULL COMMENT '属性',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='字典 - 所属行业';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_industry`
--
LOCK TABLES `t_dic_industry` WRITE;
/*!40000 ALTER TABLE `t_dic_industry` DISABLE KEYS */;
INSERT INTO `t_dic_industry` VALUES (1,'重型行业',0),(2,'轻型行业',0),(3,'精密行业',0),(4,'特殊行业',0);
/*!40000 ALTER TABLE `t_dic_industry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_information_reliability`
--
DROP TABLE IF EXISTS `t_dic_information_reliability`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_information_reliability` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`reliability` varchar(100) DEFAULT NULL COMMENT '信息来源可靠性',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='字典 - 供应商信息来源（可靠性）';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_information_reliability`
--
LOCK TABLES `t_dic_information_reliability` WRITE;
/*!40000 ALTER TABLE `t_dic_information_reliability` DISABLE KEYS */;
INSERT INTO `t_dic_information_reliability` VALUES (1,'基本信息表',0),(2,'网络信息',0),(4,'实地参观',0);
/*!40000 ALTER TABLE `t_dic_information_reliability` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_market_positioning`
--
DROP TABLE IF EXISTS `t_dic_market_positioning`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_market_positioning` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(100) DEFAULT NULL COMMENT '市场定位',
`myOrder` smallint(6) DEFAULT '0' COMMENT ' 排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='字典 - 市场定位';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_market_positioning`
--
LOCK TABLES `t_dic_market_positioning` WRITE;
/*!40000 ALTER TABLE `t_dic_market_positioning` DISABLE KEYS */;
INSERT INTO `t_dic_market_positioning` VALUES (2,'不确定',0),(3,'主机',0),(5,'售后',0);
/*!40000 ALTER TABLE `t_dic_market_positioning` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_measurement_unit`
--
DROP TABLE IF EXISTS `t_dic_measurement_unit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_measurement_unit` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`unit` varchar(50) DEFAULT NULL COMMENT '计量单位',
`unitCn` varchar(50) DEFAULT NULL COMMENT '中文名称',
`englishSingular` varchar(50) DEFAULT NULL COMMENT '英文单数',
`englishPlural` varchar(20) DEFAULT NULL COMMENT '英文复数',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='字典 - 计量单位';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_measurement_unit`
--
LOCK TABLES `t_dic_measurement_unit` WRITE;
/*!40000 ALTER TABLE `t_dic_measurement_unit` DISABLE KEYS */;
INSERT INTO `t_dic_measurement_unit` VALUES (7,'MILLION','万粒','','',0),(6,'KG','千克','','',0),(5,'PCS','套','','',0);
/*!40000 ALTER TABLE `t_dic_measurement_unit` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_mode_operation`
--
DROP TABLE IF EXISTS `t_dic_mode_operation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_mode_operation` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(100) DEFAULT NULL COMMENT '经营方式',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典 - 经营方式';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_mode_operation`
--
LOCK TABLES `t_dic_mode_operation` WRITE;
/*!40000 ALTER TABLE `t_dic_mode_operation` DISABLE KEYS */;
INSERT INTO `t_dic_mode_operation` VALUES (1,'轴承生产厂',0),(2,'轴承贸易商',0),(3,'轴承最终用户',0);
/*!40000 ALTER TABLE `t_dic_mode_operation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_packaging_type`
--
DROP TABLE IF EXISTS `t_dic_packaging_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_packaging_type` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(150) DEFAULT NULL COMMENT '包装类型',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='字典 - 包装类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_packaging_type`
--
LOCK TABLES `t_dic_packaging_type` WRITE;
/*!40000 ALTER TABLE `t_dic_packaging_type` DISABLE KEYS */;
INSERT INTO `t_dic_packaging_type` VALUES (2,'TL纸盒',0),(3,'FLT纸盒',0),(4,'GP纸盒',0),(5,'SP纸盒',0),(6,'WELT纸盒',0),(7,'TBB纸盒',0),(8,'中性工业包装',0),(10,'白纸盒',0);
/*!40000 ALTER TABLE `t_dic_packaging_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_packing_method`
--
DROP TABLE IF EXISTS `t_dic_packing_method`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_packing_method` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`nameEn` varchar(150) DEFAULT NULL COMMENT '英文名称',
`name` varchar(50) DEFAULT NULL COMMENT '中文名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='字典 - 包装方式';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_packing_method`
--
LOCK TABLES `t_dic_packing_method` WRITE;
/*!40000 ALTER TABLE `t_dic_packing_method` DISABLE KEYS */;
INSERT INTO `t_dic_packing_method` VALUES (2,'SINGLE FLT NEW DESIGN PAPER BOX','FLT单个纸盒包装',0),(3,'SINGLE NEUTRAL PAPER BOX','单个中性纸盒包装',0),(4,'SINGLE WELT BOX PAPER BOX','单个WELT纸盒包装',0),(5,'SINGLE TL PAPER BOX','单个TL纸盒包装',0);
/*!40000 ALTER TABLE `t_dic_packing_method` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_pricing_term`
--
DROP TABLE IF EXISTS `t_dic_pricing_term`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_pricing_term` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) DEFAULT NULL COMMENT '价格条款',
`description` varchar(255) DEFAULT NULL COMMENT '说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='字典 - 价格条款';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_pricing_term`
--
LOCK TABLES `t_dic_pricing_term` WRITE;
/*!40000 ALTER TABLE `t_dic_pricing_term` DISABLE KEYS */;
INSERT INTO `t_dic_pricing_term` VALUES (1,'FOB','FREE ON BOARD 离岸价格',0),(2,'CIF','COST,INSURANCE AND FREIGHT 到岸价格',0),(3,'CFR','COST AND FREIGHT 离岸加运费',0),(4,'CPT','CARRIAGE PAID TO 运费付至目的地',0),(5,'CIP','CARRIAGE AND INSURANCE PAID TO 运费保险费付至目的地',0),(6,'FCA','FREE CARRIER 到岸价格',0),(7,'DDU','DELIVERED DUTY UNPAID 未完税交货',0),(8,'DDP','DELIVERED DUTY PAID 完税后交货',0),(9,'EXW','Ex Works 离厂价',0),(10,'VAT','内销含增值税含运费',0);
/*!40000 ALTER TABLE `t_dic_pricing_term` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_product_category`
--
DROP TABLE IF EXISTS `t_dic_product_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_product_category` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`categoryEn` varchar(255) DEFAULT NULL COMMENT '英文品名',
`category` varchar(255) DEFAULT NULL COMMENT '中文品名',
`categoryNameEn` varchar(255) DEFAULT NULL COMMENT '英文品名',
`categoryName` varchar(255) DEFAULT NULL COMMENT '中文品名',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COMMENT='字典 - 产品品类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_product_category`
--
LOCK TABLES `t_dic_product_category` WRITE;
/*!40000 ALTER TABLE `t_dic_product_category` DISABLE KEYS */;
INSERT INTO `t_dic_product_category` VALUES (9,'Four row angular contact ball bearing','四列角接触球轴承','Angular contact ball bearing','角接触球轴承',0),(8,'Double row angular contact ball bearing','双列角接触球轴承','Angular contact ball bearing','角接触球轴承',0),(7,'Single row angular contact ball bearing','单列角接触球轴承','Angular contact ball bearing','角接触球轴承',0),(10,'Thrust angular contact ball bearing','推力角接触球轴承','Thrust ball bearing','推力球轴承',0),(11,'Cylindrical roller bearing','圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(12,'Single row cylindrical roller bearing','单列圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(13,'Double row cylindrical roller bearing','双列圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(14,'Four row cylindrical roller bearings','四列圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(15,'Six row cylindrical roller bearing','六列圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(16,'Full complement cylindrical roller bearing','满装圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(17,'High precision cylindrical roller bearing','高精度圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(18,'Crossed cylindrical roller bearing','交叉圆柱滚子轴承','Cylindrical roller bearing','圆柱滚子轴承',0),(19,'Thrust cylindrical roller bearing','推力圆柱滚子轴承','Thrust roller bearing','推力滚子轴承',0),(20,'Tapered roller bearing','圆锥滚子轴承','Tapered roller bearing','圆锥滚子轴承',0),(21,'Double row tapered roller bearing','双列圆锥滚子轴承','Tapered roller bearing','圆锥滚子轴承',0),(22,'Four row tapered roller bearing','四列圆锥滚子轴承','Tapered roller bearing','圆锥滚子轴承',0),(23,'Thrust tapered roller bearing','推力圆锥滚子轴承','Thrust roller bearing','推力滚子轴承',0),(24,'Deep groove ball bearing','深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(25,'Double row deep groove ball bearing','双列深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(26,'Carbon steel deep groove ball bearing','碳钢深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(27,'Inch size deep groove ball bearing','英制深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(28,'Special deep groove ball bearing','非标深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(29,'Stainless steel deep groove ball bearing','不锈钢深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(30,'Thin wall deep groove ball bearing','薄壁深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(31,'Widen deep groove ball bearing','加宽深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(32,'Miniature deep groove ball bearing','微型深沟球轴承','Deep groove ball bearing','深沟球轴承',0),(33,'EMQ ball bearing','电机球轴承','EMQ ball bearing','电机球轴承',0),(34,'EMQ bearing','电机轴承','EMQ bearing','电机轴承',0),(35,'Needle','滚针','Needle','滚针',0),(36,'Needle roller bearing','滚针轴承','Needle roller bearing','滚针轴承',0),(37,'Pillow block','外球面带座轴承','Pillow block','外球面带座轴承',0),(38,'Stainless steel pillow block','不锈钢外球面带座轴承','Pillow block','外球面带座轴承',0),(39,'Spherical roller bearing','调心滚子轴承','Spherical roller bearing','调心滚子轴承',0),(40,'Thrust spherical roller bearing','推力调心滚子轴承','Spherical roller bearing','调心滚子轴承',0),(41,'Thrust ball bearing','推力球轴承','Thrust ball bearing','推力球轴承',0),(42,'Stainless steel thrust ball bearing','不锈钢推力球轴承','Thrust ball bearing','推力球轴承',0),(43,'Insert bearing','外球面轴承','Insert bearing','外球面轴承',0),(44,'Stainless steel insert bearing','不锈钢外球面轴承','Insert bearing','外球面轴承',0),(45,'Adapter sleeve','紧定套','Adapter sleeve','紧定套',0),(46,'Agricultural bearing','农机轴承','Agricultural bearing','农机轴承',0),(47,'Air bearing','空调轴承','Air bearing','空调轴承',0),(48,'Automobile bearing','汽车轴承','Automobile bearing','汽车轴承',0),(49,'Ball screw support bearing','滚珠丝杠支承轴承','Ball screw support bearing','滚珠丝杠支承轴承',0),(50,'Carbon steel ball bearing','碳钢球轴承','Ball bearing','球轴承',0),(51,'Overrunning clutch bearing','超越离合器轴承','Clutch bearing','离合器轴承',0),(52,'Clutch bearing','离合器轴承','Clutch bearing','离合器轴承',0),(53,'Conveyor bearing','输送机轴承','Conveyor bearing','输送机轴承',0),(54,'Extra big size bearing','特大型号轴承','Extra big size bearing','轴承',0),(55,'Flanged bearing','法兰盘轴承','Flanged bearing','轴承',0),(56,'High precision bearing','高精度轴承','High precision bearing','轴承',0),(57,'Wheel hub bearing','轮毂轴承','Wheel hub bearing','轮毂轴承',0),(58,'Linear ball bearing','直线轴承','Linear ball bearing','直线轴承',0),(59,'Miniature bearing','微型轴承','Miniature bearing','微型轴承',0),(60,'Oiless bearing','无油轴承','Oiless bearing','无油轴承',0),(61,'Plastic bearing','包塑轴承','Plastic bearing','轴承',0),(62,'Pulley','滑轮','Pulley','滑轮',0),(63,'Railway bearing','铁路轴承','Railway bearing','轴承',0),(64,'Roller','滚子','Roller','滚子',0),(65,'Self-aligning ball bearing','调心球轴承','Self-aligning ball bearing','调心球轴承',0),(66,'Slewing bearing','回转轴承','Slewing bearing','回转轴承',0),(67,'Sprocket','链轮','Sprocket','链轮',0),(68,'Stainless steel bearing','不锈钢轴承','Stainless steel bearing','不锈钢轴承',0),(69,'Steel ball','钢球','Steel ball','钢球',0),(70,'Universal joint','万向节','Universal joint','万向节',0),(71,'Water pump bearing','水泵轴承','Water pump bearing','水泵轴承',0),(72,'Wind power bearing','风电轴承','Wind power bearing','轴承',0),(73,'Adapter ring','中间环','Adapter ring','紧定套',0),(74,'Lock nut','螺母','Lock nut','紧定套',0),(75,'Thrust washer','推力垫片','Thrust washer','推力垫片',0),(76,'Automobile AC bearing','汽车空调轴承','Automobile AC bearing','汽车空调轴承',0),(77,'Automobile engine parts','汽车发动机零件','Automobile engine parts','汽车零部件',0),(78,'Automobile parts','汽车零部件','Automobile parts','汽车零部件',0),(79,'Automobile steering bearing','汽车方向机轴承','Automobile steering bearing','汽车方向机轴承',0),(80,'Automobile tensioner and idel bearing','汽车涨紧轮轴承','Steering bearing','涨紧轮',0),(81,'Bearing repair kits','轴承修理包','Bearing repair kits','轴承修理包',0),(82,'Bottom roller bearing','下罗拉轴承','Bottom roller bearing','轴承',0),(83,'Bush','轴套','Bush','轴承',0),(84,'Cage','保持架','Cage','保持架',0),(85,'CARB bearing','卡博轴承','CARB bearing','轴承',0),(86,'Ceramic ball bearing','陶瓷球轴承','Ball bearing','球轴承',0),(87,'Chain','链条','Chain','轴承',0),(88,'Stainless steel ball','不锈钢钢球','Stainless steel ball','不锈钢钢球',0),(89,'Coupling','联轴器','Coupling','联轴器',0),(90,'Extra big bearing','大型轴承','Extra big bearing','大型轴承',0),(91,'Forging piece','轴承锻件','Forging piece','轴承锻件',0),(92,'Gear ring','齿环','Gear ring','齿环',0),(93,'High speed spindle bearing','高速主轴轴承','High speed spindle bearing','高速主轴轴承',0),(94,'High temperature bearing','高温轴承','High temperature bearing','轴承',0),(95,'LM shaft','光轴','LM shaft','光轴',0),(96,'Mechanical part','机械零件','Mechanical part','轴承',0),(97,'Magneto bearing','磁电机轴承','Magneto bearing','轴承',0),(98,'Main shaft','主轴','Main shaft','主轴',0),(99,'Rocker arm bearing','摇臂轴承','Rocker arm bearing','摇臂轴承',0),(100,'Rolling mill bearing','轧机轴承','Rolling mill bearing','轧机轴承',0),(101,'Sleeve','轴瓦','Sleeve','轴瓦',0),(102,'Special bearing','非标轴承','Special bearing','非标轴承',0),(103,'Spherical plain bearing','向心关节轴承','Spherical plain bearing','向心关节轴承',0),(104,'Rod end','杆端关节轴承','Rod end','杆端关节轴承',0),(105,'Casting','铸件','Casting','轴承',0),(106,'Truckle bearing','脚轮轴承','Truckle bearing','轴承',0),(107,'Automobile water pump bearing','汽车水泵轴承','Automobile water pump bearing','汽车水泵轴承',0),(108,'Forklift bearing','叉车轴承','Forklift bearing','轴承',0),(109,'Seals','密封件','Seals','密封件',0),(110,'Stainless steel track roller','不锈钢滚轮轴承','Stainless steel track roller','滚轮轴承',0),(111,'Track roller','滚轮轴承','Track roller bearing','滚轮轴承',0),(112,'Universal Ball','万向滚珠','Universal ball','万向滚珠',0),(113,'Bearing housing','轴承座','Bearing housing','轴承座',0),(114,'Plastic housing','塑料轴承座','Plastic housing','塑料轴承座',0),(115,'Ball track roller','球滚轮轴承','Ball track roller','滚轮轴承',0),(116,'Taper track roller','锥滚轮轴承','Taper track roller','滚轮轴承',0),(117,'Needle track roller bearing','滚针滚轮轴承','Needle track roller bearing','滚轮轴承',0),(118,'Rings','套圈','Rings','套圈',0),(119,'Universal Wheel','万向轮','Universal Wheel','轴承',0),(120,'Cover','盖子','Cover','轴承',0),(121,'Bracket','支架','Bracket','轴承',0),(122,'Tractor bearing','拖拉机轴承','Tractor bearing','轴承',0),(123,'Insulated bearing','绝缘轴承','Insulated bearing','绝缘轴承',0),(124,'Seeger ring','卡簧环','Seeger ring','卡簧环',0),(125,'Steering bearing','涨紧轮','Steering bearing','涨紧轮',0),(126,'Conveyor accessory','输送机配件','Conveyor accessory','输送机配件',0),(127,'Lock washer','锁紧垫圈','Adapter sleeve','紧定套',0);
/*!40000 ALTER TABLE `t_dic_product_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_product_material`
--
DROP TABLE IF EXISTS `t_dic_product_material`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_product_material` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`materialName` varchar(100) DEFAULT NULL COMMENT '材质名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT ' 排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='字典 - 产品材质 a';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_product_material`
--
LOCK TABLES `t_dic_product_material` WRITE;
/*!40000 ALTER TABLE `t_dic_product_material` DISABLE KEYS */;
INSERT INTO `t_dic_product_material` VALUES (7,'GCr15-轴承钢',0),(6,'100Cr6-轴承钢',0),(8,'GCr15SiMn',0),(9,'Stainless steel440C-不锈钢440C',0),(10,'Stainless steel420C-不锈钢420C',0),(11,'Stainless steel304-不锈钢304',0),(12,'Stainless steel306-不锈钢306',0),(13,'50Mn',0),(14,'G20CrMo',0),(15,'Carbon steel-碳钢',0),(16,'Carbon steel45#-45号碳钢',0),(17,'Carbon steel20#-20号碳钢',0),(18,'Casting-铸铁',0);
/*!40000 ALTER TABLE `t_dic_product_material` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_province_city`
--
DROP TABLE IF EXISTS `t_dic_province_city`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_province_city` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`province` varchar(50) DEFAULT NULL COMMENT '省份',
`city` varchar(50) DEFAULT NULL COMMENT '城市',
`area` varchar(50) DEFAULT NULL COMMENT '地区',
`zipCode` varchar(50) DEFAULT NULL COMMENT '邮编 ',
`phoneAreaCode` varchar(10) DEFAULT NULL COMMENT '电话区号',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='字典 - 省份城市';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_province_city`
--
LOCK TABLES `t_dic_province_city` WRITE;
/*!40000 ALTER TABLE `t_dic_province_city` DISABLE KEYS */;
INSERT INTO `t_dic_province_city` VALUES (6,'河北','保定','华北','','',0),(5,'浙江','慈溪','华东','','',0),(7,'江苏','常州','华东','','',0),(8,'辽宁','大连','东北','','',0),(9,'浙江','杭州','华东','','',0),(10,'浙江','嘉兴','华东','','',0),(11,'湖北','襄阳','华中','','',0),(12,'浙江','台州','华东','','',0),(13,'浙江','宁波','华东','','',0),(14,'江苏','苏州','华东','','',0),(15,'山东','青岛','华东','','',0),(16,'江苏','南京','华东','','',0),(17,'浙江','绍兴','华东','','',0),(18,'江苏','无锡','华东','','',0);
/*!40000 ALTER TABLE `t_dic_province_city` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_self_company`
--
DROP TABLE IF EXISTS `t_dic_self_company`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_self_company` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`companyName` varchar(255) DEFAULT NULL COMMENT '中文名称',
`companyNameEn` varchar(255) DEFAULT NULL COMMENT '英文名称',
`settlementCategory` varchar(255) DEFAULT NULL COMMENT '结算类别\r\n 2个选项\r\n 自营出口\r\n 代理出口',
`exchangeRate` decimal(10,4) DEFAULT '0.0000' COMMENT '基准汇率',
`customsNumber` varchar(255) DEFAULT NULL COMMENT '海关编号',
`address` varchar(200) DEFAULT NULL COMMENT '公司地址',
`addressEn` varchar(255) DEFAULT NULL COMMENT '公司地址英文',
`phone` varchar(30) DEFAULT NULL COMMENT '电话号码',
`fax` varchar(30) DEFAULT NULL COMMENT '传真号码',
`email` varchar(50) DEFAULT NULL COMMENT '电子邮件',
`webSite` varchar(255) DEFAULT NULL COMMENT '公司主页',
`legalPerson` varchar(100) DEFAULT NULL COMMENT '法人代表',
`bankName` varchar(100) DEFAULT NULL COMMENT '开户银行',
`bankNo` varchar(50) DEFAULT NULL COMMENT '银行帐号',
`bankAddress` varchar(200) DEFAULT NULL COMMENT '银行地址',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典设置我方公司';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_self_company`
--
LOCK TABLES `t_dic_self_company` WRITE;
/*!40000 ALTER TABLE `t_dic_self_company` DISABLE KEYS */;
INSERT INTO `t_dic_self_company` VALUES (1,'上海锑美轴承技术有限公司','TBB BEARING PROVISION','自营出口',6.8260,'3122267683','上海浦东祖冲之路1077号','No.18 New Jinqiao Road,Pudong,Shanghai China PC:201206','0086 21-38726185/38726186','0086 21-38726187','info@tbbbearing.com','www.tbbprovision.com','','中国银行上海浦东开发区支行','457259260499','上海市浦东新区新金桥路1888号');
/*!40000 ALTER TABLE `t_dic_self_company` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_service_category`
--
DROP TABLE IF EXISTS `t_dic_service_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_service_category` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`attribute` varchar(100) DEFAULT NULL COMMENT '属性',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典 - 业务类别';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_service_category`
--
LOCK TABLES `t_dic_service_category` WRITE;
/*!40000 ALTER TABLE `t_dic_service_category` DISABLE KEYS */;
INSERT INTO `t_dic_service_category` VALUES (1,'外销-国产轴承',0),(2,'内销-国产轴承',0),(3,'内销-进口轴承',0);
/*!40000 ALTER TABLE `t_dic_service_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_settlement_currency`
--
DROP TABLE IF EXISTS `t_dic_settlement_currency`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_settlement_currency` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`currency` varchar(30) DEFAULT NULL COMMENT '结算货币\r\n 结算货币',
`symbol` varchar(20) DEFAULT NULL COMMENT '货币符号',
`name` varchar(50) DEFAULT NULL COMMENT '中文名称',
`nameEn` varchar(50) DEFAULT NULL COMMENT '英文名称',
`exchangeRate` decimal(10,6) DEFAULT '0.000000' COMMENT '对人民币汇率',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='字典 - 结算货币';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_settlement_currency`
--
LOCK TABLES `t_dic_settlement_currency` WRITE;
/*!40000 ALTER TABLE `t_dic_settlement_currency` DISABLE KEYS */;
INSERT INTO `t_dic_settlement_currency` VALUES (1,'USD','','','',6.400000,0),(2,'EUR','','','',7.500000,0),(3,'GBP','','','',8.500000,0),(4,'RMB','','','',1.000000,0),(5,'JPY','','','',0.058000,0);
/*!40000 ALTER TABLE `t_dic_settlement_currency` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_settlement_way`
--
DROP TABLE IF EXISTS `t_dic_settlement_way`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_settlement_way` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(150) NOT NULL COMMENT '结汇方式名称',
`description` varchar(255) DEFAULT NULL COMMENT '说明',
`myOrder` smallint(6) DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='字典 - 结汇方式';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_settlement_way`
--
LOCK TABLES `t_dic_settlement_way` WRITE;
/*!40000 ALTER TABLE `t_dic_settlement_way` DISABLE KEYS */;
INSERT INTO `t_dic_settlement_way` VALUES (4,'D/A','付款交单',0),(3,'T/T','电汇',0),(5,'D/P','承兑交单',0),(6,'L/C','信用证',0),(7,'T/T 100% IMMEDIATELY AFTER RECEIVING PER FAX\' COPY OF ON BOARD B/L','',0),(8,'50% by T/T after goods are finished + 50% by T/T 60 days after B/L date','',0),(9,'20% by T/T after order confirmation and proforma invoice + 80% immediately against copy of B/L by TT','',0),(10,'100% by T/T 30 days after B/L date','',0),(11,'100% by T/T after order confirmation and proforma invoice','',0),(12,'自开票日起30天','',0),(13,'50% BY T/T AFTER ORDER CONFIRMATION + 50% IMMEDIATELY AGAINST COPY OF B/L','',0),(14,'30% T/T in advance, 70% at readiness of shipment','',0);
/*!40000 ALTER TABLE `t_dic_settlement_way` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_shipping_port`
--
DROP TABLE IF EXISTS `t_dic_shipping_port`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_shipping_port` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) DEFAULT NULL COMMENT '中文名称',
`nameEn` varchar(100) DEFAULT NULL COMMENT '英文名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='字典 - 出运口岸';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_shipping_port`
--
LOCK TABLES `t_dic_shipping_port` WRITE;
/*!40000 ALTER TABLE `t_dic_shipping_port` DISABLE KEYS */;
INSERT INTO `t_dic_shipping_port` VALUES (2,'上海','SHANGHAI',0);
/*!40000 ALTER TABLE `t_dic_shipping_port` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_size_segment`
--
DROP TABLE IF EXISTS `t_dic_size_segment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_size_segment` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`sizeName` varchar(50) DEFAULT NULL COMMENT '尺寸段',
`innerDiameterSizeRange` varchar(50) DEFAULT NULL COMMENT '内径尺寸范围',
`myOrder` smallint(6) DEFAULT '0' COMMENT ' 排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='字典 - 尺寸段';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_size_segment`
--
LOCK TABLES `t_dic_size_segment` WRITE;
/*!40000 ALTER TABLE `t_dic_size_segment` DISABLE KEYS */;
INSERT INTO `t_dic_size_segment` VALUES (6,'微型','3<d<=10',0),(7,'中小型','10<d<=35',0),(8,'中型','35<d<=80',0),(9,'中大型','80<d<=150',0),(10,'大型','150<d<=500',0),(11,'特大型','d>500',0);
/*!40000 ALTER TABLE `t_dic_size_segment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_supplier_category`
--
DROP TABLE IF EXISTS `t_dic_supplier_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_supplier_category` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`categoryName` varchar(150) DEFAULT NULL COMMENT '类别名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='字典 - 供应商类别';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_supplier_category`
--
LOCK TABLES `t_dic_supplier_category` WRITE;
/*!40000 ALTER TABLE `t_dic_supplier_category` DISABLE KEYS */;
INSERT INTO `t_dic_supplier_category` VALUES (1,'国内',0),(3,'进口',0);
/*!40000 ALTER TABLE `t_dic_supplier_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_supplier_classification`
--
DROP TABLE IF EXISTS `t_dic_supplier_classification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_supplier_classification` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) DEFAULT NULL COMMENT '分类名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT=' 字典 - 供应商分类-产品相关，';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_supplier_classification`
--
LOCK TABLES `t_dic_supplier_classification` WRITE;
/*!40000 ALTER TABLE `t_dic_supplier_classification` DISABLE KEYS */;
INSERT INTO `t_dic_supplier_classification` VALUES (1,'国产轴承',0),(2,'进口轴承',0),(3,'检测机构',0),(4,'油脂',0),(6,'包装物',0);
/*!40000 ALTER TABLE `t_dic_supplier_classification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_supplier_information_source`
--
DROP TABLE IF EXISTS `t_dic_supplier_information_source`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_supplier_information_source` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`sourceName` varchar(50) DEFAULT NULL COMMENT '来源名称',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='字典 - 供应商信息来源';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_supplier_information_source`
--
LOCK TABLES `t_dic_supplier_information_source` WRITE;
/*!40000 ALTER TABLE `t_dic_supplier_information_source` DISABLE KEYS */;
INSERT INTO `t_dic_supplier_information_source` VALUES (1,'X表',0),(2,'网络搜索',0),(3,'基本信息表',0),(4,'2012轴承展',0),(5,'TBB2013年前供应商',0),(6,'2014轴承展',0),(7,'2014宝马展',0),(8,'2014法兰克福',0),(9,'2016轴承展',0),(10,'2016法兰克福展',0),(11,'金蜘蛛',0);
/*!40000 ALTER TABLE `t_dic_supplier_information_source` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_supplier_payment_method`
--
DROP TABLE IF EXISTS `t_dic_supplier_payment_method`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_supplier_payment_method` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`paymentMethod` varchar(50) DEFAULT NULL COMMENT '付款方式',
`description` varbinary(255) DEFAULT NULL COMMENT '说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='字典 - 供应商付款方式';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_supplier_payment_method`
--
LOCK TABLES `t_dic_supplier_payment_method` WRITE;
/*!40000 ALTER TABLE `t_dic_supplier_payment_method` DISABLE KEYS */;
INSERT INTO `t_dic_supplier_payment_method` VALUES (2,'货后电汇','',0),(4,'货前电汇','',0);
/*!40000 ALTER TABLE `t_dic_supplier_payment_method` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_supplier_status`
--
DROP TABLE IF EXISTS `t_dic_supplier_status`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_supplier_status` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`supplierStatus` varchar(150) DEFAULT NULL COMMENT '供应商状态',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='字典 - 供应商状态';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_supplier_status`
--
LOCK TABLES `t_dic_supplier_status` WRITE;
/*!40000 ALTER TABLE `t_dic_supplier_status` DISABLE KEYS */;
INSERT INTO `t_dic_supplier_status` VALUES (2,'线索',0),(3,'意向-经常报价未成交',0),(4,'成交',0),(5,'停用',0),(6,'待处理-信息不全供TBB品牌宣传',0);
/*!40000 ALTER TABLE `t_dic_supplier_status` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_test_items`
--
DROP TABLE IF EXISTS `t_dic_test_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_test_items` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(100) DEFAULT NULL COMMENT '项目名称',
`description` varchar(255) DEFAULT NULL COMMENT '说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='字典 - 检测项目';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_test_items`
--
LOCK TABLES `t_dic_test_items` WRITE;
/*!40000 ALTER TABLE `t_dic_test_items` DISABLE KEYS */;
INSERT INTO `t_dic_test_items` VALUES (4,'尺寸精度','2个项目150元',0),(5,'旋转精度','2个项目150元',0),(6,'装配高','2个项目150元',0),(7,'宽度','2个项目150元',0),(8,'径向游隙','2个项目150元',0),(9,'轴向游隙','2个项目150元',0),(10,'残磁','2个项目150元',0),(11,'外观','2个项目150元',0),(12,'振动速度','2个项目150元',0),(13,'振动加速度','2个项目150元',0),(14,'内圈硬度','2个项目150元',0),(15,'外圈硬度','2个项目150元',0),(16,'金相','每个点50元，默认2个点',0),(17,'圆度','每个点50元，默认2个点',0),(18,'粗糙度','每个点50元，默认2个点',0),(19,'曲率','每个点50元，默认2个点',0),(20,'填脂量','200元每批',0),(21,'清洁度','200元每批',0),(22,'其他','',0);
/*!40000 ALTER TABLE `t_dic_test_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_testing_fee_standard`
--
DROP TABLE IF EXISTS `t_dic_testing_fee_standard`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_testing_fee_standard` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`projectNumber` smallint(6) DEFAULT '0' COMMENT '项目数量',
`projectCost` decimal(10,4) DEFAULT '0.0000' COMMENT '项目费用',
`pointsNumber` smallint(6) DEFAULT '0' COMMENT '点数量',
`pointsCost` decimal(10,4) DEFAULT '0.0000' COMMENT '点费用',
`batch` smallint(6) DEFAULT '0' COMMENT '批量',
`batchCost` decimal(10,4) DEFAULT '0.0000' COMMENT '批量费用',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='检测费用标准';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_testing_fee_standard`
--
LOCK TABLES `t_dic_testing_fee_standard` WRITE;
/*!40000 ALTER TABLE `t_dic_testing_fee_standard` DISABLE KEYS */;
INSERT INTO `t_dic_testing_fee_standard` VALUES (2,5,10.0000,2,60.0000,3,60.0000,0),(5,2,1.0000,3,5.0000,1,6.0000,0);
/*!40000 ALTER TABLE `t_dic_testing_fee_standard` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_trade_country`
--
DROP TABLE IF EXISTS `t_dic_trade_country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_trade_country` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`countryName` varchar(50) DEFAULT NULL COMMENT '中文国名',
`countryNameEn` varchar(100) DEFAULT NULL COMMENT '英文国名',
`continentNameEn` varchar(100) DEFAULT NULL COMMENT '英文洲名',
`continentName` varchar(20) DEFAULT NULL COMMENT '中文洲名',
`phoneAreaCode` varchar(10) DEFAULT NULL COMMENT '电话区号',
`timeEquation` varchar(10) DEFAULT NULL COMMENT '时差',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf8 COMMENT='字典 - 贸易国别';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_trade_country`
--
LOCK TABLES `t_dic_trade_country` WRITE;
/*!40000 ALTER TABLE `t_dic_trade_country` DISABLE KEYS */;
INSERT INTO `t_dic_trade_country` VALUES (1,'德国','Germany','Europe','欧洲','00349','-7',0),(2,'波兰','Poland','Europe','欧洲','0048','-7',0),(3,'意大利','Italy','Europe','欧洲','0039','-7',0),(4,'西班牙','Spain','Europe','欧洲','0034','-8',0),(5,'英国','United Kingdom','Europe','欧洲','0044','-8',0),(6,'荷兰','Netherlands','Europe','欧洲','0031','-7',0),(7,'法国','France','Europe','欧洲','0033','-8',0),(8,'爱尔兰','Ireland','Europe','欧洲','00353','-8',0),(9,'美国','United States of America','North America','北美洲','001','0',0),(10,'印度','India','Asia','亚洲','','0',0),(11,'丹麦','Denmark','Europe','欧洲','','0',0),(12,'巴西','Brazil','South America','南美洲','','0',0),(13,'比利时','Belgium','Europe','欧洲','','0',0),(14,'奥地利','Austria','Europe','欧洲','','0',0),(15,'俄罗斯','Russia','Europe','欧洲','','0',0),(16,'中国','China','Asia','亚洲','','0',0),(17,'马来西亚','Malaysia','Asia','亚洲','','0',0),(18,'伊朗','Iran','Asia','亚洲','','0',0),(19,'韩国','Korea','Asia','亚洲','','0',0),(20,'秘鲁','Peru','South America','南美洲','','0',0),(21,'乌克兰','Ukraine','Europe','欧洲','','0',0),(22,'缅甸','Myanmar','Asia','亚洲','','0',0),(23,'保加利亚','Bulgaria','Europe','欧洲','','0',0),(24,'巴基斯坦','Pakistan','Asia','亚洲','','0',0),(25,'土耳其','Turkey','Europe','欧洲','','0',0),(26,'斯洛伐克','Slovakia','Europe','欧洲','00421','0',0),(27,'菲律宾','Philippines','Asia','亚洲','','0',0),(28,'加拿大','Canada','North America','北美洲','','0',0),(29,'斯洛文尼亚','Slovenia','Europe','欧洲','','0',0),(30,'芬兰','Finland','Europe','欧洲','','0',0),(31,'阿联酋','U.A.E','Asia','亚洲','','0',0),(32,'以色列','Israel','Asia','亚洲','','0',0),(33,'南非','South Africa','Africa','非洲','','0',0),(34,'白俄罗斯','Belarus','Europe','欧洲','','0',0),(35,'捷克','Czech','Europe','欧洲','','0',0),(37,'瑞典','Sweden','Europe','欧洲','','0',0),(38,'澳大利亚','Australia','Oceania','大洋洲','','0',0),(39,'巴林王国','Kingdom Of Bahrain','Asia','亚洲','','0',0),(40,'墨西哥','Mexico','North America','北美洲','','0',0),(41,'泰国','Thailand','Asia','亚洲','','0',0),(42,'葡萄牙','Portugal','Europe','欧洲','','0',0),(43,'新加坡','Singapore','Asia','亚洲','','0',0),(44,'斯里兰卡','Sri－Lanka','Asia','亚洲','','0',0),(45,'瑞士','Switzerland','Europe','欧洲','','0',0),(46,'厄瓜多尔','Ecuador','South America','南美洲','','0',0),(47,'智利','Chile','South America','南美洲','','0',0),(48,'新西兰','New Zealand','Oceania','大洋洲','','0',0),(49,'沙特阿拉伯','Saudi Arabia','Asia','亚洲','','0',0),(50,'萨尔瓦多','El Salvador','Middle America','中美洲','','0',0),(51,'日本','Japan','Asia','亚洲','','0',0),(52,'孟加拉','Bangladesh','Asia','亚洲','','0',0),(53,'哈萨克斯坦','Kazakhstan','Asia','亚洲','','0',0),(54,'台湾','Taiwan','Asia','亚洲','','0',0),(55,'香港','Hong Kong','Asia','亚洲','','0',0),(56,'越南','Vietnam','Asia','亚洲','','0',0),(57,'加纳','Ghana','Africa','非洲','','0',0),(58,'匈牙利','Hungary','Europe','欧洲','','0',0),(59,'阿曼','Oman','Asia','亚洲','','0',0),(60,'哥伦比亚','Colombia','South America','南美洲','','0',0),(61,'黎巴嫩','Lebanon','Asia','亚洲','','0',0),(62,'阿根廷','Argentina','South America','南美洲','','0',0),(63,'巴拉圭','Paraguay','南美洲','South America','','0',0),(64,'委内瑞拉','Venezuela','South America','南美洲','','0',0),(65,'肯尼亚','Kenya','Africa','非洲','','0',0),(66,'乌拉圭','Uruguay','South America','南美洲','','0',0),(67,'哥斯达黎加','Costa Rica','South America','南美洲','','0',0),(68,'立陶宛','Lithuania','Europe','欧洲','','0',0),(69,'罗马尼亚','Romania','Europe','欧洲','','0',0),(70,'坦桑尼亚','Tanzania','Africa','非洲','','0',0),(71,'津巴布韦','Zimbabwe','Africa','非洲','','0',0),(72,'摩洛哥','Morocco','Africa','非洲','','0',0),(73,'印度尼西亚','Indonesia','Asia','亚洲','','0',0),(74,'利比亚','Libya','Africa','非洲','','0',0),(75,'博茨瓦纳','Botswana','Africa','非洲','','0',0),(76,'捷克共和国','Czech Republic','Europe','欧洲','','0',0),(77,'爱沙尼亚','Estonia','Europe','欧洲','','0',0),(78,'格鲁吉亚','Georgia','Europe','欧洲','','0',0),(79,'塞浦路斯','Cyprus','Europe','欧洲','','0',0),(80,'卢森堡','Luxembourg','Europe','欧洲','','0',0),(81,'莫桑比克','Mozambique','Africa','非洲','','0',0),(82,'安哥拉','Angola','Africa','非洲','','0',0),(83,'多米尼加','Dominica','South America','南美洲','','0',0),(84,'危地马拉','Guatemala','South America','南美洲','','0',0),(85,'洪都拉斯','Honduras','North America','南美洲','','0',0),(86,'阿尔及利亚','Algeria','Africa','非洲','','0',0),(87,'玻利维亚','Bolivia','South America','南美洲','','0',0),(88,'拉脱维亚','Latvia','Europe','欧洲','','0',0),(89,'巴拿马','Panama','South America','南美洲','','0',0),(90,'波多黎各','Puerto Rica','North America','北美洲','','0',0),(91,'塞尔维亚','Serbia','Europe','欧洲','','0',0),(92,'克罗地亚','Croatia','Europe','欧洲','','0',0),(93,'波黑','Bosnia Herzegovina','Europe','欧洲','','0',0),(94,'伊拉克','Iraq','Asia','亚洲','','0',0),(95,'希腊','Greece','Europe','欧洲','+30','0',0),(96,'叙利亚','Syria','Asia','亚洲','','0',0),(97,'毛里求斯','Mauritius','Africa','非洲','','0',0),(98,'尼日利亚','Nigeria','Africa','非洲','','0',0),(99,'柬埔寨','Cambodia','Asia','亚洲','','0',0),(100,'文莱','Brunei','Asia','亚洲','','0',0),(101,'赞比亚','Zambia','Africa','非洲','','0',0),(102,'埃及','Egypt','Africa','非洲','','0',0),(103,'巴林','Bahrain','Asia','亚洲','','0',0),(104,'卡塔尔','QATAR','Asia','亚洲','','0',0),(105,'科威特','KUWAIT','Asia','亚洲','','0',0),(106,'突尼斯','Tunisia','Africa','非洲','','0',0),(107,'特立尼达和多巴哥','Trinidad and Tobago','North America','北美洲','','0',0),(108,'阿塞拜疆','Azerbaijan','Asia','亚洲','','0',0),(109,'科特迪瓦','Coate d\'Ivoire','Africa','非洲','','0',0),(110,'巴巴多斯','Barbados','North America','北美洲','','0',0),(111,'马耳他','Malta','Europe','欧洲','','0',0),(112,'乌干达','Uganda','Africa','非洲','','0',0),(113,'约旦','Jordan','Asia','亚洲','','0',0),(114,'巴布亚新几内亚','Papua New Guinea','Oceania','大洋洲','','0',0),(115,'斐济','Fiji','Oceania','大洋洲','','0',0),(116,'挪威','Norway','Europe','欧洲','','0',0);
/*!40000 ALTER TABLE `t_dic_trade_country` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_transport_mode`
--
DROP TABLE IF EXISTS `t_dic_transport_mode`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_transport_mode` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) DEFAULT NULL COMMENT '名称',
`description` varchar(255) DEFAULT NULL COMMENT '说明',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='字典 - 运输方式';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_transport_mode`
--
LOCK TABLES `t_dic_transport_mode` WRITE;
/*!40000 ALTER TABLE `t_dic_transport_mode` DISABLE KEYS */;
INSERT INTO `t_dic_transport_mode` VALUES (5,'By Air','空运',0),(4,'By Sea','海运',0),(6,'By Courier','快递/平邮',0),(7,'By Train','铁路运输',0),(8,'By Truck','卡车运输',0);
/*!40000 ALTER TABLE `t_dic_transport_mode` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_dic_warehouse_information`
--
DROP TABLE IF EXISTS `t_dic_warehouse_information`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dic_warehouse_information` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`warehouseName` varchar(100) DEFAULT NULL COMMENT '仓库名称',
`contactName` varchar(50) DEFAULT NULL COMMENT '联系人',
`warehouseAddress` varchar(255) DEFAULT NULL COMMENT '仓库地址',
`mobile` varchar(50) DEFAULT NULL COMMENT '手机号码',
`phone` varchar(50) DEFAULT NULL COMMENT '电话号码',
`fax` varchar(50) DEFAULT NULL COMMENT '传真号码',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='字典 - 仓库资料';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_dic_warehouse_information`
--
LOCK TABLES `t_dic_warehouse_information` WRITE;
/*!40000 ALTER TABLE `t_dic_warehouse_information` DISABLE KEYS */;
INSERT INTO `t_dic_warehouse_information` VALUES (4,'协德仓库','黄小姐','浦东新区曹路镇人民塘路（钦堂路）1号','','021-68725007','',0),(5,'上海天虹新洋山仓库','','上海临港物流园区秋祥路668号','','021-20956781','',0),(6,'上海浦东兴豪集装箱储运有限公司','陆菊东','上海市奉贤区海杰路363号','','37510968','37510688',0),(7,'上海鼎凯物流有限公司','','上海市浦东新区民夏路168号','13817015832','68689720','',0),(8,'DHL仓库','','上海市浦东新区捷迅路675号','','021-60977926','',0),(9,'TBB仓库','kevin','','','','',0);
/*!40000 ALTER TABLE `t_dic_warehouse_information` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_lida_model`
--
DROP TABLE IF EXISTS `t_lida_model`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_lida_model` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model` varchar(255) DEFAULT NULL,
`contactCount` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_lida_model`
--
LOCK TABLES `t_lida_model` WRITE;
/*!40000 ALTER TABLE `t_lida_model` DISABLE KEYS */;
INSERT INTO `t_lida_model` VALUES (2,'UCF204',500),(3,'UCF205',68),(4,'UCF206',1460),(5,'UCF208',1000),(6,'UCF220',40),(7,'UCFB206',500),(8,'UCFL204',1000),(9,'UCFL206',1514),(10,'UCFL207',1136),(11,'UCP204',2000),(12,'UCP208',328),(13,'UCP212',200),(14,'ucp213',200),(15,'UCT205',300),(16,'UCT206',300),(17,'UCT207',300),(18,'UCT210',200);
/*!40000 ALTER TABLE `t_lida_model` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_lida_model_record`
--
DROP TABLE IF EXISTS `t_lida_model_record`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_lida_model_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mid` int(11) DEFAULT '0',
`ruku` int(11) DEFAULT '0',
`brief` varchar(255) DEFAULT NULL,
`addTime` int(11) DEFAULT '0',
`addTimeDay` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_lida_model_record`
--
LOCK TABLES `t_lida_model_record` WRITE;
/*!40000 ALTER TABLE `t_lida_model_record` DISABLE KEYS */;
INSERT INTO `t_lida_model_record` VALUES (4,3,0,'少58个',1546931512,'2019-01-08'),(3,2,0,'少11个',1546931469,'2019-01-08'),(5,8,0,'少9个',1546931564,'2019-01-08'),(6,10,970,'少166个',1546931620,'2019-01-08'),(7,2,0,'少11个',1546931948,'2019-01-08'),(8,6,0,'轴承座子已经到货，未喷漆。\r\n',1546935335,'2019-01-08');
/*!40000 ALTER TABLE `t_lida_model_record` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_manage`
--
DROP TABLE IF EXISTS `t_manage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_manage` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`accountName` varchar(50) DEFAULT NULL COMMENT '用户名',
`groupIdStr` varchar(255) DEFAULT NULL COMMENT '管理员分组ID',
`pwd` varchar(32) DEFAULT NULL COMMENT '登录密码,MD5',
`userName` varchar(50) DEFAULT NULL COMMENT '姓名',
`face` varchar(255) DEFAULT NULL COMMENT '头像',
`gender` tinyint(1) DEFAULT NULL COMMENT '性别 ',
`phone` varchar(50) DEFAULT NULL COMMENT '电话',
`mobile` varchar(50) DEFAULT NULL COMMENT '手机',
`fax` varchar(50) DEFAULT NULL COMMENT '传真',
`email` varchar(100) DEFAULT NULL COMMENT '邮件',
`isLock` tinyint(1) DEFAULT '0' COMMENT '是否锁定',
`addTime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
`lastLoginTime` int(10) DEFAULT '0' COMMENT '最后登录时间',
`lastLoginIp` varchar(30) DEFAULT NULL COMMENT '最后登录IP',
`loginTime` int(10) DEFAULT '0' COMMENT '本次登录时间',
`loginIp` varchar(30) DEFAULT NULL COMMENT '本次登录IP',
`loginTimes` int(11) DEFAULT '0' COMMENT '总登录次数',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='后台用户列表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_manage`
--
LOCK TABLES `t_manage` WRITE;
/*!40000 ALTER TABLE `t_manage` DISABLE KEYS */;
INSERT INTO `t_manage` VALUES (1,'administrator','1','46e90f1a423da085c133cc3f5797d857','超级管理员','/Public/Admin/img/gender_1.png',0,'','','fffffff','262313204@qq.com',0,1543391148,1546952091,'183.167.229.227',1546952173,'183.167.229.227',75),(8,'yaping','1','e10adc3949ba59abbe56e057f20f883e','亚平','/Public/Admin/img/gender_1.png',1,'','','','262313204@qq.com',0,1544417762,1544435107,'127.0.0.1',1544499627,'127.0.0.1',3);
/*!40000 ALTER TABLE `t_manage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_manage_group`
--
DROP TABLE IF EXISTS `t_manage_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_manage_group` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`groupName` varchar(50) DEFAULT NULL COMMENT '用户角色/分组',
`permissionIds` varchar(1000) DEFAULT NULL COMMENT '权限 ID',
`menuIds` varchar(1000) DEFAULT NULL COMMENT '菜单ID',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
`addTime` int(10) DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='后台用户角色/分组';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_manage_group`
--
LOCK TABLES `t_manage_group` WRITE;
/*!40000 ALTER TABLE `t_manage_group` DISABLE KEYS */;
INSERT INTO `t_manage_group` VALUES (1,'超级管理员','9,10,11,13',NULL,'系统自带，不能删除，不能修改，否则有可能导致系统出错',1544001236);
/*!40000 ALTER TABLE `t_manage_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_manage_permission`
--
DROP TABLE IF EXISTS `t_manage_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_manage_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`moduleId` smallint(6) DEFAULT '0' COMMENT '权限模块ID',
`title` varchar(50) DEFAULT NULL COMMENT '标题',
`url` varchar(255) DEFAULT NULL COMMENT '路径',
`description` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='权限列表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_manage_permission`
--
LOCK TABLES `t_manage_permission` WRITE;
/*!40000 ALTER TABLE `t_manage_permission` DISABLE KEYS */;
INSERT INTO `t_manage_permission` VALUES (1,1,'【管理员分组】列表页面','Manage/group',''),(2,1,'【管理员分组】删除','Manage/groupDel',''),(3,1,'【管理员分组】添加页面','Manage/groupAdd',''),(4,1,'【管理员分组】添加数据','Manage/groupAddPost',''),(5,1,'【管理员分组】修改页面','Manage/groupEdit',''),(6,1,'【管理员分组】修改数据','Manage/groupEditPost',''),(7,1,'【管理员】列表页面','Manage/index',''),(8,1,'【管理员】删除','Manage/manageDel',''),(9,1,'【管理员】添加页面','Manage/manageAdd',''),(10,1,'【管理员】添加数据','Manage/manageAddPost',''),(11,1,'【管理员】修改页面','Manage/manageEdit','');
/*!40000 ALTER TABLE `t_manage_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_manage_permission_module`
--
DROP TABLE IF EXISTS `t_manage_permission_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_manage_permission_module` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`moduleName` varchar(100) DEFAULT NULL COMMENT '模块名称',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='后台权限模块';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_manage_permission_module`
--
LOCK TABLES `t_manage_permission_module` WRITE;
/*!40000 ALTER TABLE `t_manage_permission_module` DISABLE KEYS */;
INSERT INTO `t_manage_permission_module` VALUES (1,'管理员管理模块');
/*!40000 ALTER TABLE `t_manage_permission_module` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_product`
--
DROP TABLE IF EXISTS `t_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_product` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`sizeSegment` varchar(30) DEFAULT NULL COMMENT '尺寸范围值',
`sizeSegmentId` smallint(6) DEFAULT '0' COMMENT '尺寸段ID',
`picture` varchar(500) DEFAULT NULL COMMENT '产品图片',
`proNo` varchar(50) DEFAULT NULL COMMENT '产品编号,系统自动生成',
`model` varchar(50) DEFAULT NULL COMMENT 'TBB产品型号',
`brand` varchar(255) DEFAULT NULL COMMENT '型号对应品牌',
`categoryId` smallint(6) DEFAULT '0' COMMENT '产品品类ID',
`category` varchar(50) DEFAULT NULL COMMENT '产品品类中文',
`categoryName` varchar(50) DEFAULT NULL COMMENT '产品品名中文',
`categoryNameEn` varchar(255) DEFAULT NULL COMMENT '产品品名英文',
`productMaterialId` smallint(6) DEFAULT '0' COMMENT '主要材料ID',
`productMaterial` varchar(100) DEFAULT NULL COMMENT '主要材料名称',
`measurementUnitId` smallint(6) DEFAULT '0' COMMENT '计量单位ID',
`isEmphasisModel` tinyint(4) DEFAULT '0' COMMENT '是否重点型号',
`proDrawing` varchar(10) DEFAULT NULL COMMENT '产品图纸 下拉选项 是/否',
`insideDiameter` decimal(10,0) DEFAULT '0' COMMENT '产品内径',
`outsideDiameter` decimal(10,0) DEFAULT '0' COMMENT '产品外径',
`thickness` decimal(10,0) DEFAULT '0' COMMENT '产品厚度',
`netWeight` decimal(10,0) DEFAULT '0' COMMENT '产品净重',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注',
`addTime` int(11) DEFAULT '0' COMMENT '添加时间',
`updateTime` int(11) DEFAULT '0' COMMENT '最后修改时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='产品资料';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_product`
--
LOCK TABLES `t_product` WRITE;
/*!40000 ALTER TABLE `t_product` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_system_config`
--
DROP TABLE IF EXISTS `t_system_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_system_config` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`keyName` varchar(50) DEFAULT NULL COMMENT '键',
`keyValue` text COMMENT '值',
`description` varchar(255) DEFAULT NULL COMMENT '介绍',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='系统设置';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_system_config`
--
LOCK TABLES `t_system_config` WRITE;
/*!40000 ALTER TABLE `t_system_config` DISABLE KEYS */;
INSERT INTO `t_system_config` VALUES (1,'system_name','锑美企业管理系统','系统名称，登录页面和系统框架左上角'),(2,'system_name_short','TBB','系统系统 框架右上角收缩 模式简写'),(3,'company_name','上海锑美轴承技术有限公司','公司名称。系统登录页面显示'),(4,'suppliers_matching_number','3','【询报价】供应商匹配数量');
/*!40000 ALTER TABLE `t_system_config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `t_system_menu`
--
DROP TABLE IF EXISTS `t_system_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_system_menu` (
`id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`title` varchar(50) DEFAULT NULL COMMENT '标题',
`url` varchar(100) DEFAULT NULL COMMENT '链接',
`parentId` smallint(6) DEFAULT '0' COMMENT '父级ID',
`iconClass` varchar(100) DEFAULT NULL COMMENT '图标类名',
`activeAction` text COMMENT '活动状态的action',
`isClose` tinyint(1) DEFAULT '0' COMMENT '是否关闭',
`myOrder` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='后台菜单设置';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `t_system_menu`
--
LOCK TABLES `t_system_menu` WRITE;
/*!40000 ALTER TABLE `t_system_menu` DISABLE KEYS */;
INSERT INTO `t_system_menu` VALUES (1,'系统管理','#',0,'fa ifont icon-xitongshezhi','',0,0),(12,'字典设置','Dictionary/index',1,'fa fa-circle-o','selfCompanyList#selfCompanyAdd#selfCompanyEdit#serviceCategoryList#serviceCategoryAdd#serviceCategoryEdit#modeOperationList#modeOperationAdd#modeOperationEdit#customerStatusList#customerStatusAdd#customerStatusEdit#tradeCountryList#tradeCountryAdd#tradeCountryEdit#customerContractCodeList#customerContractCodeAdd#customerContractCodeEdit#customerContactDepartmentList#customerContactDepartmentAdd#customerContactDepartmentEdit#customerContactPositionList#customerContactPositionAdd#customerContactPositionEdit#industryList#industryAdd#industryEdit#bankInfoList#bankInfoAdd#bankInfoEdit#pricingTermList#pricingTermAdd#pricingTermEdit#settlementWayList#settlementWayAdd#settlementWayEdit#supplierClassificationList#supplierClassificationAdd#supplierClassificationEdit#supplierCategoryList#supplierCategoryAdd#supplierCategoryEdit#informationReliabilityList#informationReliabilityAdd#informationReliabilityEdit#supplierInformationSourceList#supplierInformationSourceAdd#supplierInformationSourceEdit#supplierPaymentMethodList#supplierPaymentMethodAdd#supplierPaymentMethodEdit#settlementCurrencyList#settlementCurrencyAdd#settlementCurrencyEdit#measurementUnitList#measurementUnitAdd#measurementUnitEdit#customsCodeList#customsCodeAdd#customsCodeEdit#shippingPortList#shippingPortAdd#shippingPortEdit#destinationPortList#destinationPortAdd#destinationPortEdit#provinceCityList#provinceCityAdd#provinceCityEdit#transportModeList#transportModeAdd#transportModeEdit#containerModelList#containerModelAdd#containerModelEdit#packingMethodList#packingMethodAdd#packingMethodEdit#customerSourceList#customerSourceAdd#customerSourceEdit#creditRatingList#creditRatingAdd#creditRatingEdit#cooperationLevelList#cooperationLevelAdd#cooperationLevelEdit#customerOrderingCategoryList#customerOrderingCategoryAdd#customerOrderingCategoryEdit#warehouseInformationList#warehouseInformationAdd#warehouseInformationEdit#productCategoryList#productCategoryAdd#productCategoryEdit#productMaterialList#productMaterialAdd#productMaterialEdit#bankInterestRateList#bankInterestRateAdd#bankInterestRateEdit#marketPositioningList#marketPositioningAdd#marketPositioningEdit#sizeSegmentList#sizeSegmentAdd#sizeSegmentEdit#domesticSalesQuoteList#domesticSalesQuoteAdd#domesticSalesQuoteEdit#packagingTypeList#packagingTypeAdd#packagingTypeEdit#testItemsList#testItemsAdd#testItemsEdit#testingFeeStandardList#testingFeeStandardAdd#testingFeeStandardEdit#detectOuterDiameterList#detectOuterDiameterAdd#detectOuterDiameterEdit#customerDemandBrandList#customerDemandBrandAdd#customerDemandBrandEdit#supplierStatusList#supplierStatusAdd#supplierStatusEdit#',0,0),(3,'系统菜单管理','SystemMenu/index',1,'fa fa-circle-o','menuAdd#menuEdit',0,0),(6,'管理员管理','#',1,'fa fa-circle-o',NULL,0,0),(7,'分组管理','Manage/group',6,'fa fa-circle-o','groupAdd#groupEdit',0,3),(8,'管理员列表','Manage/index',6,'fa fa-circle-o','manageAdd#manageEdit',0,0),(10,'权限设置','ManagePermission/moduleIndex',1,'fa fa-circle-o','',0,4),(13,'系统设置','SystemConfig/index',1,'fa fa-circle-o','',0,0),(14,'外销管理','#',0,'fa ifont icon-duiwaimaoyi-quanguoliuxiang','',0,6),(15,'采购管理','#',0,'fa ifont icon-caigou','',0,5),(16,'产品资料','Product/index',14,'fa fa-circle-o','Product/add#',0,0),(17,'LD生产跟进记录','Lida/index',0,'fa fa-circle-o','',0,0);
/*!40000 ALTER TABLE `t_system_menu` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-01-08 21:33:46