   `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 '产品分类',

  UNIQUE KEY `login_name` (`login_name`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `br_admin`
--

LOCK TABLES `br_admin` WRITE;
/*!40000 ALTER TABLE `br_admin` DISABLE KEYS */;
INSERT INTO `br_admin` VALUES (1400638807349600,'admin','141bd81b79e386a109bd5aeea7476805a3ce17ea','swL(','mike05@qq.com',2,'','',0,3,'',1400638807,'',1400638807,'N/A');
/*!40000 ALTER TABLE `br_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `br_article`
--

DROP TABLE IF EXISTS `br_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `br_article` (
  `id` bigint(16) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章分类ID',

  CONSTRAINT `br_product_ibfk_2` FOREIGN KEY (`bid`) REFERENCES `br_brand` (`bid`) ON UPDATE CASCADE,
  CONSTRAINT `br_product_ibfk_3` FOREIGN KEY (`mid`) REFERENCES `br_manufacturer` (`mid`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品表';




