WebRoot/FusionChartsFree/Code/PHP/DB/MS_SQL_Script.sql

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

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

SET NOCOUNT ON
-- Restricts volume of output to errors and
-- messages that use the PRINT function

USE [master]

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'FactoryDB')
	DROP DATABASE [FactoryDB]
GO

CREATE DATABASE [FactoryDB]
GO

USE [FactoryDB]

PRINT 'CREATING TABLE Factory_Master'
CREATE TABLE [Factory_Master] (
	[FactoryId] [int] NOT NULL ,
	[FactoryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_Factory_Master] PRIMARY KEY  CLUSTERED 
	(
		[FactoryId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




PRINT 'CREATING TABLE Factory_Output'
CREATE TABLE [Factory_Output] (
	[FactoryID] [int] NULL ,
	[DatePro] [smalldatetime] NULL ,
	[Quantity] [float] NULL ,
	CONSTRAINT [FK_Factory_Output_Factory_Master] FOREIGN KEY 
	(
		[FactoryID]
	) REFERENCES [Factory_Master] (
		[FactoryId]
	)
) ON [PRIMARY]
GO


PRINT 'INSERTING DATA INTO TABLE Factory_Master'
ALTER TABLE [Factory_Master] NOCHECK CONSTRAINT ALL
INSERT INTO [Factory_Master] ([FactoryId],[FactoryName]) VALUES (1,'Factory 1')
INSERT INTO [Factory_Master] ([FactoryId],[FactoryName]) VALUES (2,'Factory 2')
INSERT INTO [Factory_Master] ([FactoryId],[FactoryName]) VALUES (3,'Factory 3')
ALTER TABLE [Factory_Master] CHECK CONSTRAINT ALL

PRINT 'INSERTING DATA INTO TABLE Factory_Output'
ALTER TABLE [Factory_Output] NOCHECK CONSTRAINT ALL
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/01 05:53:00 PM',21)
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/02 05:54:00 PM',23)
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/03 05:54:00 PM',22)
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/04 05:54:00 PM',24)
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/05 05:54:00 PM',32)
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/06 05:54:00 PM',21)
INSERT INTO [Factory_Output] ([FactoryID],[DatePro],[Quantity]) VALUES (1,'2003/01/07 05:54:00 PM',34)