/*
Navicat MySQL Data Transfer

Source Server         : root
Source Server Version : 50721
Source Host           : localhost:3306
Source Database       : bilibili

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

Date: 2019-03-04 17:08:49
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bilibili_user
-- ----------------------------
DROP TABLE IF EXISTS `bilibili_user`;
CREATE TABLE `bilibili_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `face` varchar(255) DEFAULT NULL,
  `sign` varchar(255) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `birthday` varchar(255) DEFAULT NULL,
  `coins` varchar(255) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7912 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- View structure for stock_price
-- ----------------------------
DROP VIEW IF EXISTS `stock_price`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `stock_price` AS select `mpfs`.`id` AS `id`,`mpfs`.`inventory_organization` AS `inventory_organization`,`mpfs`.`factory` AS `factory`,`mpfs`.`material_code` AS `material_code`,`mpfs`.`material_name` AS `material_name`,`mpfs`.`specifications` AS `specifications`,`mpfs`.`model` AS `model`,`mpfs`.`grade_info` AS `grade_info`,`mpfs`.`machine_type` AS `machine_type`,`mpfs`.`network_ply` AS `network_ply`,`mpfs`.`grade` AS `grade`,`mpfs`.`twisting` AS `twisting`,`mpfs`.`status` AS `status`,`mpfs`.`can_buy_number` AS `can_buy_number`,`mpfs`.`buy_number` AS `buy_number`,`mpfs`.`send_number` AS `send_number`,`mpfs`.`wait_out_number` AS `wait_out_number`,`mpfs`.`wait_in_number` AS `wait_in_number`,`mpfs`.`stock` AS `stock`,`mpfs`.`stock_box_number` AS `stock_box_number`,`mpfs`.`sort_code` AS `sort_code`,`mpfs`.`sort_name` AS `sort_name`,`mpp`.`cny_1` AS `cny_1`,`mpp`.`cny_2` AS `cny_2`,`mpp`.`usd` AS `usd` from (`mall_product_forward_stock` `mpfs` left join `mall_product_price` `mpp` on((`mpfs`.`material_code` = `mpp`.`material_code`))) where ((`mpfs`.`id` is not null) and (`mpp`.`id` is not null)) ;

-- ----------------------------
-- View structure for view1
-- ----------------------------
DROP VIEW IF EXISTS `view1`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `view1` AS select `mall_auction`.`id` AS `id`,`mall_auction`.`start_time` AS `start_time`,`mall_auction`.`end_time` AS `end_time` from `mall_auction` ;

-- ----------------------------
-- Procedure structure for test
-- ----------------------------
DROP PROCEDURE IF EXISTS `test`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `test`(IN `test` int)
BEGIN
	#Routine body goes here...
	SELECT count(*) 
from sys_user; 
END
;;
DELIMITER ;