dm-v2.com/Mysql/ewm_company.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50617
Source Host           : localhost:3306
Source Database       : dm_7in6_com

Target Server Type    : MYSQL
Target Server Version : 50617
File Encoding         : 65001

Date: 2018-07-28 12:40:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `ewm_company`
-- ----------------------------
DROP TABLE IF EXISTS `ewm_company`;
CREATE TABLE `ewm_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(20) DEFAULT NULL COMMENT '生产厂商名称',
  `postcode` tinyint(6) DEFAULT NULL COMMENT '邮政编码',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `company_addres` varchar(40) DEFAULT NULL COMMENT '生产厂商地址',
  `stauts` tinyint(1) DEFAULT NULL COMMENT '生产厂商状态（1:正常；2：异常）',
  `addtime` int(11) DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ewm_company
-- ----------------------------