修仙笔记

修复.zip

drop index ICStockBillEntry20020328 on ICStockBillEntry
drop index idx_ICStockBillEntry_FSourceTranTypeNFSourceInterId on ICStockBillEntry
drop index idx_Flex on ICStockBillEntry
drop index IX_ICStockBillEntry_FSourceInterId on ICStockBillEntry

/****** Object: Index [ICStockBillEntry20020328] Script Date: 09/20/2017 15:31:07 ******/
CREATE NONCLUSTERED INDEX [ICStockBillEntry20020328] ON [dbo].[ICStockBillEntry]
(
[FItemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object: Index [idx_ICStockBillEntry_FSourceTranTypeNFSourceInterId] Script Date: 09/20/2017 15:31:18 ******/
CREATE NONCLUSTERED INDEX [idx_ICStockBillEntry_FSourceTranTypeNFSourceInterId] ON [dbo].[ICStockBillEntry]
(
[FSourceTranType] ASC,
[FSourceInterId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object: Index [idx_Flex] Script Date: 09/20/2017 15:31:28 ******/
CREATE NONCLUSTERED INDEX [idx_Flex] ON [dbo].[ICStockBillEntry]
(
[FItemID] ASC,
[FDCStockID] ASC,
[FSCStockID] ASC,
[FBatchNo] ASC,
[FMTONo] ASC,
[FDCSPID] ASC,
[FKFDate] ASC,
[FKFPeriod] ASC,
[FAuxPropID] ASC,
[FQty] ASC,
[FSecQty] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object: Index [IX_ICStockBillEntry_FSourceInterId] Script Date: 09/20/2017 15:54:46 ******/
CREATE NONCLUSTERED INDEX [IX_ICStockBillEntry_FSourceInterId] ON [dbo].[ICStockBillEntry]
(
[FSourceInterId] ASC,
[FSourceEntryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

---

delete from icinventory where fitemid =21615 and fstockid = 1036 and fqty = -12775
update icinventory set fqty = 12775 where fitemid =21615 and fstockid = 1036

ALTER TABLE ICInventory DROP CONSTRAINT PK_ICInventory
DROP index idx_ICInventory_FItemID on ICInventory
DROP index idx_ICInventory_FMTONo on ICInventory
DROP index idx_ICInventory_FStockID on ICInventory

/****** Object: Index [idx_ICInventory_FItemID] Script Date: 09/20/2017 16:07:07 ******/
CREATE CLUSTERED INDEX [idx_ICInventory_FItemID] ON [dbo].[ICInventory]
(
[FItemID] ASC,
[FStockID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object: Index [idx_ICInventory_FMTONo] Script Date: 09/20/2017 16:07:01 ******/
CREATE NONCLUSTERED INDEX [idx_ICInventory_FMTONo] ON [dbo].[ICInventory]
(
[FMTONo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object: Index [idx_ICInventory_FStockID] Script Date: 09/20/2017 16:06:55 ******/
CREATE NONCLUSTERED INDEX [idx_ICInventory_FStockID] ON [dbo].[ICInventory]
(
[FItemID] ASC,
[FStockID] ASC,
[FQty] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object: Index [PK_ICInventory] Script Date: 09/20/2017 16:06:44 ******/
ALTER TABLE [dbo].[ICInventory] ADD CONSTRAINT [PK_ICInventory] PRIMARY KEY NONCLUSTERED
(
[FItemID] ASC,
[FStockID] ASC,
[FAuxPropID] ASC,
[FBatchNo] ASC,
[FStockPlaceID] ASC,
[FKFPeriod] ASC,
[FKFDate] ASC,
[FBrNo] ASC,
[FMTONo] ASC,
[FSupplyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO