/*
Navicat MySQL Data Transfer

Source Server         : MySQL
Source Server Version : 50720
Source Host           : localhost:3306
Source Database       : market

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

Date: 2018-11-07 10:00:25
*/


-- ----------------------------
-- Table structure for goods
-- ----------------------------
CREATE TABLE `goods` (
  `G_name` char(10) NOT NULL,
  `G_storage` int(255) DEFAULT NULL,
  `G_supplier` varchar(255) DEFAULT NULL,
  `G_money` decimal(30,2) DEFAULT NULL,
  PRIMARY KEY (`G_name`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('book', '900', '光明家俱厂', '25.60');
INSERT INTO `goods` VALUES ('desk', '80', '易居家俱', '200.00');
INSERT INTO `goods` VALUES ('hat', '200', '上海服饰公司', '35.80');
INSERT INTO `goods` VALUES ('P9_PLUS', '1300', '华为通讯', '3980.00');
INSERT INTO `goods` VALUES ('pen', '100', null, '15.60');
INSERT INTO `goods` VALUES ('shoes', '75', '蓝带体育公司', '280.00');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
CREATE TABLE `orders` (
  `O_id` char(10) NOT NULL,
  `G_name` char(10) DEFAULT NULL,
  `C_id` char(10) DEFAULT NULL,
  `O_quantity` int(255) DEFAULT NULL,
  `O_money` decimal(30,2) DEFAULT NULL,
  `O_date` date DEFAULT NULL,
  PRIMARY KEY (`O_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('95001', 'pen', '2', '10', '156.00', '2009-06-17');
INSERT INTO `orders` VALUES ('95002', 'pen', '4', '70', '1092.00', '2009-05-20');
INSERT INTO `orders` VALUES ('95003', 'pen', '2', '10', '2000.00', '2010-05-17');
INSERT INTO `orders` VALUES ('95004', 'desk', '1', '20', '4000.00', '2011-04-07');
INSERT INTO `orders` VALUES ('95005', 'book', '2', '5', null, '2010-08-10');
INSERT INTO `orders` VALUES ('95006', 'book', '3', '10', '256.00', '2009-03-02');
INSERT INTO `orders` VALUES ('95007', 'shoes', '5', '20', '3000.00', '2018-05-10');
INSERT INTO `orders` VALUES ('95008', 'P9_PLUS', '5', '70', null, '2015-02-10');
