   `type` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
   `position` int(11) NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='lookup表';
-/*!40101 SET character_set_client = @saved_cs_client */;
+) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='lookup表';
 
---
--- Dumping data for table `br_lookup`
---
 
-LOCK TABLES `br_lookup` WRITE;
-/*!40000 ALTER TABLE `br_lookup` DISABLE KEYS */;
-/*!40000 ALTER TABLE `br_lookup` ENABLE KEYS */;
-UNLOCK TABLES;
 
---
--- Table structure for table `br_manufacturer`
---
 
 DROP TABLE IF EXISTS `br_manufacturer`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `br_manufacturer` (
-  `mid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
-  `manufacturer_name` varchar(256) NOT NULL DEFAULT '' COMMENT '分类名',
+  `mid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '供应商ID',
+  `manufacturer_name` varchar(256) NOT NULL DEFAULT '' COMMENT '供应商名',
   PRIMARY KEY (`mid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应商表';
-/*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Dumping data for table `br_manufacturer`
---
 
-LOCK TABLES `br_manufacturer` WRITE;
-/*!40000 ALTER TABLE `br_manufacturer` DISABLE KEYS */;
-/*!40000 ALTER TABLE `br_manufacturer` ENABLE KEYS */;
-UNLOCK TABLES;
 
---
--- Table structure for table `br_order`
---
 
 DROP TABLE IF EXISTS `br_order`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `br_order` (
   `oid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
-  `company_name` int(11) NOT NULL DEFAULT '0' COMMENT '公司名',
+  `company_name` varchar(256) NOT NULL DEFAULT '' COMMENT '公司名',
   `email` varchar(128) NOT NULL DEFAULT '' COMMENT 'email',
   `tel` varchar(32) NOT NULL DEFAULT '' COMMENT '电话',
   `inquiry_content` text COMMENT '询价内容',
   PRIMARY KEY (`oid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';
-/*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Dumping data for table `br_order`
---
 
-LOCK TABLES `br_order` WRITE;
-/*!40000 ALTER TABLE `br_order` DISABLE KEYS */;
-/*!40000 ALTER TABLE `br_order` ENABLE KEYS */;
-UNLOCK TABLES;
 
---
--- Table structure for table `br_order_detail`
---
 
 DROP TABLE IF EXISTS `br_order_detail`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `br_order_detail` (
   `od_id` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '订单详情ID',
   `oid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '订单详情ID',

  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '产品状态0显示1不显示',
  PRIMARY KEY (`od_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单详细表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `br_order_detail`
--

LOCK TABLES `br_order_detail` WRITE;
/*!40000 ALTER TABLE `br_order_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `br_order_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `br_product`
--

DROP TABLE IF EXISTS `br_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `br_product` (
  `pid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  `cid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '产品分类',

  PRIMARY KEY (`cid`),
  KEY `issingle` (`issingle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章分类表';




DROP TABLE IF EXISTS `br_classify`;
CREATE TABLE `br_classify` (
  `cid` bigint(16) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
  `classify_name` varchar(256) NOT NULL DEFAULT '' COMMENT '分类名',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品分类表';




DROP TABLE IF EXISTS `br_lookup`;
CREATE TABLE `br_lookup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
