31 lines
1.4 KiB
MySQL
31 lines
1.4 KiB
MySQL
|
--<EFBFBD><EFBFBD>ҵƱ<EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
|
|||
|
|
/****** Object: Index [NonClusteredIndex-20220527-102848] Script Date: 2022/5/27 10:29:15 ******/
|
|||
|
|
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20220527-102848] ON [dbo].[License_LicenseItem]
|
|||
|
|
(
|
|||
|
|
[DataId] ASC,
|
|||
|
|
[SortIndex] 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
|
|||
|
|
|
|||
|
|
--<EFBFBD><EFBFBD>ҵƱ<EFBFBD><EFBFBD><EFBFBD>˱<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
/****** Object: Index [NonClusteredIndex-20220527-103009] Script Date: 2022/5/27 10:30:36 ******/
|
|||
|
|
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20220527-103009] ON [dbo].[License_FlowOperate]
|
|||
|
|
(
|
|||
|
|
[DataId] ASC,
|
|||
|
|
[SortIndex] 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].[CostGoods_GoodsManageFlowOperate] DROP CONSTRAINT [FK_CostGoods_GoodsManageFlowOperate_CostGoods_CostManage]
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
ALTER TABLE [dbo].[CostGoods_GoodsManageFlowOperate] WITH CHECK ADD CONSTRAINT [FK_CostGoods_GoodsManageFlowOperate_CostGoods_GoodsManage] FOREIGN KEY([GoodsManageId])
|
|||
|
|
REFERENCES [dbo].[CostGoods_GoodsManage] ([GoodsManageId])
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
ALTER TABLE [dbo].[CostGoods_GoodsManageFlowOperate] CHECK CONSTRAINT [FK_CostGoods_GoodsManageFlowOperate_CostGoods_GoodsManage]
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
ALTER TABLE CostGoods_GoodsManage ALTER COLUMN States VARCHAR(10) NULL
|
|||
|
|
GO
|