Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
312 lines (305 sloc) 10.2 KB
/****** Object: Table [dbo].[MAT_SHAPE] Script Date: 2/11/2015 9:47:07 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MAT_SHAPE](
[ID] [int] NOT NULL,
[MSH_ID] [int] NOT NULL,
CONSTRAINT [PK_MAT_SHAPE] PRIMARY KEY CLUSTERED
(
[ID] ASC,
[MSH_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[MATERIAL] Script Date: 2/11/2015 9:47:07 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MATERIAL](
[ID] [int] IDENTITY(1,1) NOT NULL,
[MATERIAL_NAME] [nvarchar](64) NULL,
CONSTRAINT [PK_MATERIAL] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[MSHAPE] Script Date: 2/11/2015 9:47:07 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MSHAPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SHAPE_NAME] [nvarchar](64) NULL,
CONSTRAINT [PK_MSHAPE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 1)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (7, 1)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 1)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (14, 1)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (3, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (4, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (5, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (6, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (8, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (9, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (11, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (13, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (14, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (15, 2)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (5, 3)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (11, 3)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 3)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 4)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 4)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (3, 4)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (7, 4)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 4)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 5)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 5)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (7, 5)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (3, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (5, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (6, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (7, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (14, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (15, 6)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 7)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 7)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (3, 7)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (6, 7)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 7)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (14, 7)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (3, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (4, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (5, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (6, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (7, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (8, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (11, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (13, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (14, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (15, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (18, 8)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (5, 9)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (11, 9)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (12, 9)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (3, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (5, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (6, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (7, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (8, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (11, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (13, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (14, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (16, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (17, 10)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (1, 11)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (2, 11)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (8, 11)
GO
INSERT [dbo].[MAT_SHAPE] ([ID], [MSH_ID]) VALUES (9, 11)
GO
SET IDENTITY_INSERT [dbo].[MATERIAL] ON
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (1, N'PVB')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (2, N'LDPE')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (3, N'MDPE')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (4, N'HDPE')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (5, N'PP')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (6, N'PET')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (7, N'EVA')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (8, N'ABS')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (9, N'PS')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (10, N'PVA')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (11, N'PA')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (12, N'Mixed 睼 (叫爹秆逆爹癘)')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (13, N'PC')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (14, N'LLDPE')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (15, N'HIPS')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (16, N'XLPE')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (17, N'XPE')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (18, N'WPC鹅れ')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (19, N'PMMA')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (20, N'LED5630')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (21, N'PA66')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (22, N'PA6')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (23, N'PVC')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (24, N'EPS')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (25, N'PE+PP吏玂采')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (26, N'溅件')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (27, N'眏て件')
GO
INSERT [dbo].[MATERIAL] ([ID], [MATERIAL_NAME]) VALUES (28, N'阂荒秚')
GO
SET IDENTITY_INSERT [dbo].[MATERIAL] OFF
GO
SET IDENTITY_INSERT [dbo].[MSHAPE] ON
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (1, N'Off-Cut')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (2, N'Flake/Chip ')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (3, N'Silk/Nets 捣/呼')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (4, N'Lump')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (5, N'Powder/Resin')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (6, N'Film/Sheet ')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (7, N'Roll')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (8, N'Pellet')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (9, N'Strip 盿')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (10, N'Bale')
GO
INSERT [dbo].[MSHAPE] ([ID], [SHAPE_NAME]) VALUES (11, N'Other')
GO
SET IDENTITY_INSERT [dbo].[MSHAPE] OFF
GO
/****** Object: Index [MAT_SHAPE_FK] Script Date: 2/11/2015 9:47:07 AM ******/
CREATE NONCLUSTERED INDEX [MAT_SHAPE_FK] ON [dbo].[MAT_SHAPE]
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [MAT_SHAPE2_FK] Script Date: 2/11/2015 9:47:07 AM ******/
CREATE NONCLUSTERED INDEX [MAT_SHAPE2_FK] ON [dbo].[MAT_SHAPE]
(
[MSH_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MAT_SHAPE] WITH CHECK ADD CONSTRAINT [FK_MAT_SHAP_MAT_SHAPE_MATERIAL] FOREIGN KEY([ID])
REFERENCES [dbo].[MATERIAL] ([ID])
GO
ALTER TABLE [dbo].[MAT_SHAPE] CHECK CONSTRAINT [FK_MAT_SHAP_MAT_SHAPE_MATERIAL]
GO
ALTER TABLE [dbo].[MAT_SHAPE] WITH CHECK ADD CONSTRAINT [FK_MAT_SHAP_MAT_SHAPE_MSHAPE] FOREIGN KEY([MSH_ID])
REFERENCES [dbo].[MSHAPE] ([ID])
GO
ALTER TABLE [dbo].[MAT_SHAPE] CHECK CONSTRAINT [FK_MAT_SHAP_MAT_SHAPE_MSHAPE]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'珇' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MATERIAL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MSHAPE', @level2type=N'COLUMN',@level2name=N'SHAPE_NAME'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MSHAPE'
GO
You can’t perform that action at this time.