WebRoot/FusionChartsFree/Code/VBNET/App_Data/MySQL_Script.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

# MySQL dump
#
#--------------------------------------------------------
# Program Version 2.0.46

CREATE DATABASE IF NOT EXISTS `factorydb`;
USE `factorydb`;

#
# Table structure for table 'Factory_Master'
#

DROP TABLE IF EXISTS `Factory_Master`;

CREATE TABLE `Factory_Master` (
  `FactoryId` INTEGER NOT NULL AUTO_INCREMENT, 
  `FactoryName` VARCHAR(50), 
  INDEX (`FactoryName`), 
  PRIMARY KEY (`FactoryId`)
) TYPE=MyISAM;

#
# Dumping data for table 'Factory_Master'
#

INSERT INTO `Factory_Master` VALUES (1, 'Factory 1');
INSERT INTO `Factory_Master` VALUES (2, 'Factory 2');
INSERT INTO `Factory_Master` VALUES (3, 'Factory 3');
# 3 records

#
# Table structure for table 'Factory_Output'
#

DROP TABLE IF EXISTS `Factory_Output`;

CREATE TABLE `Factory_Output` (
  `FactoryID` INTEGER DEFAULT 0, 
  `DatePro` DATETIME DEFAULT 'Now()', 
  `Quantity` DOUBLE NULL, 
  INDEX (`FactoryID`)
) TYPE=MyISAM;

#
# Dumping data for table 'Factory_Output'
#

INSERT INTO `Factory_Output` VALUES (1, '2003-01-01 17:53:26', 21);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-02 17:54:13', 23);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-03 17:54:14', 22);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-04 17:54:21', 24);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-05 17:54:45', 32);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-06 17:54:53', 21);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-07 17:54:58', 34);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-08 17:55:04', 32);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-09 17:55:15', 32);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-10 17:55:20', 23);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-11 17:55:26', 23);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-12 17:55:35', 32);
INSERT INTO `Factory_Output` VALUES (1, '2003-01-13 17:55:40', 53);