174 lines
9.5 KiB
Transact-SQL
174 lines
9.5 KiB
Transact-SQL
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ('229BFA1B-377C-464A-BE25-A7CE5DAADEB4','데貫보꼼욋<EFBFBD>零','HJGL/MaterialManage/UnitStore.aspx',1,'0A4F9FAA-3FA1-4CCC-A084-3A26E4B9344D','Menu_HJGL',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('37361B2C-CB2B-4457-B820-AE0F153A947A','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('EC436B28-0599-47BA-BE39-09B9ACF665D2','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('A9E6F576-EC4C-4DF1-B5B8-B767C2E18E27','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('4F3C9925-3E4B-403D-BBB9-4B9098641829','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','괏닸',4)
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Weld_UnitStore](
|
||
[UnitStoreId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[UnitStoreCode] [nvarchar](50) NULL,
|
||
[UnitStoreName] [nvarchar](50) NULL,
|
||
[StorePosition] [nvarchar](150) NULL,
|
||
[IsUse] [bit] NULL,
|
||
CONSTRAINT [PK_Weld_UnitStore] PRIMARY KEY CLUSTERED
|
||
(
|
||
[UnitStoreId] 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
|
||
|
||
ALTER TABLE [dbo].[Weld_UnitStore] WITH CHECK ADD CONSTRAINT [FK_Weld_UnitStore_Base_Unit] FOREIGN KEY([UnitId])
|
||
REFERENCES [dbo].[Base_Unit] ([UnitId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_UnitStore] CHECK CONSTRAINT [FK_Weld_UnitStore_Base_Unit]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UnitStore', @level2type=N'COLUMN',@level2name=N'UnitStoreId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'데貫ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UnitStore', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꾑욋덜쯤' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UnitStore', @level2type=N'COLUMN',@level2name=N'UnitStoreCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꾑욋츰냔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UnitStore', @level2type=N'COLUMN',@level2name=N'UnitStoreName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꾑욋뒈듐' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UnitStore', @level2type=N'COLUMN',@level2name=N'StorePosition'
|
||
GO
|
||
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ('EBF89AED-12B1-438A-8477-007720C1A74E','욋닸놓迦뺏','HJGL/MaterialManage/StockInit.aspx',11,'0A4F9FAA-3FA1-4CCC-A084-3A26E4B9344D','Menu_HJGL',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('708DA32F-0994-4C6A-B44F-DB3D5F25B1C1','EBF89AED-12B1-438A-8477-007720C1A74E','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('385776DA-EE86-4705-8BF8-E0CAD7A95612','EBF89AED-12B1-438A-8477-007720C1A74E','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('1E9A4A97-45C1-4D07-91F0-CF7A36989B8F','EBF89AED-12B1-438A-8477-007720C1A74E','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('5334D98D-90B5-45E7-AC95-28979B56B1EE','EBF89AED-12B1-438A-8477-007720C1A74E','괏닸',4)
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[Weld_StockIn](
|
||
[StockInId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[WeldId] [nvarchar](50) NULL,
|
||
[Amount] [decimal](9, 3) NULL,
|
||
[Weight] [decimal](9, 3) NULL,
|
||
[UsingAmount] [decimal](9, 3) NULL,
|
||
[Materialman] [nvarchar](50) NULL,
|
||
[InStockDate] [datetime] NULL,
|
||
[IsReview] [bit] NULL,
|
||
[ReviewMan] [nvarchar](50) NULL,
|
||
[ReviewDate] [datetime] NULL,
|
||
[ReviewResult] [char](1) NULL,
|
||
[Warrantybook] [nvarchar](50) NULL,
|
||
[AttachUrl] [nvarchar](500) NULL,
|
||
[SupplierId] [nvarchar](50) NULL,
|
||
[Flag] [char](1) NULL,
|
||
[HeartNo] [nvarchar](50) NULL,
|
||
[Number] [nvarchar](50) NULL,
|
||
[UnitStoreId] [nvarchar](50) NULL,
|
||
[RecycleAmount] [decimal](9, 3) NULL,
|
||
[RecycleWeight] [decimal](9, 3) NULL,
|
||
[MoveInStoreId] [nvarchar](50) NULL,
|
||
[MoveInManId] [nvarchar](50) NULL,
|
||
[MoveInDate] [datetime] NULL,
|
||
CONSTRAINT [PK_Weld_StockIn] PRIMARY KEY CLUSTERED
|
||
(
|
||
[StockInId] 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
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'StockInId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'WeldId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鑒좆' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'Amount'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'路좆' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'Weight'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'綠쥴痰鑒앴' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'UsingAmount'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꼼죕逃' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'Materialman'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'흙욋珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'InStockDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角뤠矜릿駱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'IsReview'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'릿駱훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'ReviewMan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'릿駱휑퍅' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'ReviewDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'릿駱써벎（0-꼇북목，1-북목）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'ReviewResult'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'醴괏蝎뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'Warrantybook'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'醴괏蝎맒숭쨌쓺（冷옵닸AttachFile깊櫓）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'AttachUrl'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'묩壇<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'SupplierId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'깃羚（0-놓迦뺏，1-흙욋，2-藁쀼흙욋）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'Flag'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'짱툽뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'HeartNo'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'직彊뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'Number'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'盧흙꾑욋돨ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'MoveInStoreId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'盧흙돨꾸鱗훙逃' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'MoveInManId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'盧흙珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn', @level2type=N'COLUMN',@level2name=N'MoveInDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼흙욋斤口깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_StockIn'
|
||
GO
|
||
|
||
|
||
alter table Base_Consumables add WeldUnit nvarchar(50) null
|
||
alter table Base_Consumables add ConvertValue decimal(9,4) null
|
||
alter table Base_Consumables add WarnAmount decimal(9,3) null
|
||
GO
|
||
|