174 lines
9.5 KiB
MySQL
174 lines
9.5 KiB
MySQL
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|||
|
|
VALUES ('229BFA1B-377C-464A-BE25-A7CE5DAADEB4','<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><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','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
|||
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES('EC436B28-0599-47BA-BE39-09B9ACF665D2','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','<EFBFBD><EFBFBD>',2)
|
|||
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES('A9E6F576-EC4C-4DF1-B5B8-B767C2E18E27','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','ɾ<EFBFBD><EFBFBD>',3)
|
|||
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES('4F3C9925-3E4B-403D-BBB9-4B9098641829','229BFA1B-377C-464A-BE25-A7CE5DAADEB4','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD>λ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'<EFBFBD>ֿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD>ֿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD>ֿ<EFBFBD><EFBFBD>ص<EFBFBD>' , @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','<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʼ<EFBFBD><EFBFBD>','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','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
|||
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES('385776DA-EE86-4705-8BF8-E0CAD7A95612','EBF89AED-12B1-438A-8477-007720C1A74E','<EFBFBD><EFBFBD>',2)
|
|||
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES('1E9A4A97-45C1-4D07-91F0-CF7A36989B8F','EBF89AED-12B1-438A-8477-007720C1A74E','ɾ<EFBFBD><EFBFBD>',3)
|
|||
|
|
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES('5334D98D-90B5-45E7-AC95-28979B56B1EE','EBF89AED-12B1-438A-8477-007720C1A74E','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @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'<EFBFBD>Ƿ<EFBFBD><EFBFBD>踴<EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>0-<2D><><EFBFBD>ϸ<EFBFBD><CFB8><EFBFBD>1-<2D>ϸ<EFBFBD><CFB8><EFBFBD>' , @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'<EFBFBD>ʱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD>ʱ<EFBFBD><EFBFBD>鸽<EFBFBD><EFBFBD>·<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҳ<EFBFBD>ɴ<EFBFBD>AttachFile<EFBFBD><EFBFBD><EFBFBD>У<EFBFBD>' , @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><EFBFBD>Ӧ<EFBFBD><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'<EFBFBD><EFBFBD>־<EFBFBD><EFBFBD>0-<2D><>ʼ<EFBFBD><CABC><EFBFBD><EFBFBD>1-<2D><><EFBFBD>⣬2-<2D>˻<EFBFBD><CBBB><EFBFBD><EFBFBD>⣩' , @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'¯<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD>ˮ<EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֿ<EFBFBD><EFBFBD><EFBFBD>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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>IJ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD>' , @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
|
|||
|
|
|