From 83307ff3b226d6f0aeefc6026ac4450700c5dc57 Mon Sep 17 00:00:00 2001 From: 陈炜 <5856420@qq.com> Date: 星期四, 25 二月 2021 17:33:12 +0800 Subject: [PATCH] 删除部分文件 --- /dev/null | 90 --------------------------------------------- 1 files changed, 0 insertions(+), 90 deletions(-) diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2561.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2561.sql" deleted file mode 100644 index 1c909f0..0000000 --- "a/\345\210\240\351\231\244\346\225\260\346\215\2561.sql" +++ /dev/null @@ -1,21 +0,0 @@ ---销售合同 -truncate table t_RPContract -truncate table t_RPContractDetail -truncate table t_rpContractEntry --- 订单 -truncate table dbo.SEOrder -truncate table dbo.SEOrderEntry ---发货通知,退货通知 -truncate table dbo.SEOutStock -truncate table dbo.SEOutStockEntry ---销售发票 -truncate table dbo.ICSale -truncate table dbo.ICSaleEntry -DELETE FROM dbo.t_RP_Contact WHERE FType =3 ---销售出库，库存类的单据都在一张表，删除所有库存单据后，需要删除存货核算余额表和即时库存表 -ALTER TABLE ICStockBill DISABLE TRIGGER ALL -DELETE FROM dbo.ICStockBill WHERE FTranType IN (21) -DELETE FROM dbo.ICStockBillEntry WHERE FInterID NOT IN (SELECT FInterID FROM dbo.ICStockBill) -ALTER TABLE ICStockBill ENABLE TRIGGER ALL ---收款单，与应收系统相关，需确认后再删除，删除后需要删除余额，建议应收应付一起处理 ---需全部删除后，需更新启用期间后账套才能开始使用 \ No newline at end of file diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2562.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2562.sql" deleted file mode 100644 index 4e6652c..0000000 --- "a/\345\210\240\351\231\244\346\225\260\346\215\2562.sql" +++ /dev/null @@ -1,26 +0,0 @@ --- 订单 -truncate table POOrder -truncate table dbo.POOrderEntry -truncate table dbo.ICSubContract -truncate table dbo.ICSubContractEntry -truncate table dbo.POInStock -truncate table dbo.POInStockEntry ---付款申请单 -TRUNCATE TABLE t_rp_PayApplyBillEntry -TRUNCATE TABLE t_rp_PayApplyBill ---采购发票 -truncate table dbo.ICPurchase -truncate table dbo.ICPurchaseEntry -DELETE FROM dbo.t_RP_Contact WHERE FType =4 ---库存类的单据都在一张表，删除所有库存单据后，需要删除存货核算余额表和即时库存表 -ALTER TABLE ICStockBill DISABLE TRIGGER ALL -DELETE FROM dbo.ICStockBill -DELETE FROM dbo.ICStockBillEntry -ALTER TABLE ICStockBill ENABLE TRIGGER ALL -TRUNCATE TABLE dbo.ICBal -TRUNCATE TABLE dbo.ICInvBal -TRUNCATE TABLE dbo.ICInventory -TRUNCATE TABLE ICInvInitial -TRUNCATE TABLE POInvBal -TRUNCATE TABLE dbo.POInventory ---需全部删除后，需更新启用期间后账套才能开始使用 \ No newline at end of file diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.14-\345\205\250\050\346\205\216\347\224\250\051.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.14-\345\205\250\050\346\205\216\347\224\250\051.sql" deleted file mode 100644 index 3b6df87..0000000 --- "a/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.14-\345\205\250\050\346\205\216\347\224\250\051.sql" +++ /dev/null @@ -1,281 +0,0 @@ ---单据 -truncate table QMSaleCkRequest -truncate table QMSaleCkRequestEntry -truncate table QMINQCReq -truncate table QMINQCReqEntry -truncate table ICQCBill -truncate table QMSourceInfo -truncate table PPOrder -truncate table PPOrderEntry -truncate table ICExpenses -truncate table ICExpensesEntry -truncate table ICInvBackup -truncate table ICQCScheme -truncate table ICQCSchemeEntry ---固定资产 -truncate table T_FACard -truncate table T_FACardItem -truncate table T_FADevice -truncate table T_FAOrgFor -truncate table T_FADept -truncate table T_FAExpense -truncate table t_FAPurchase -truncate table T_FAbalCard -truncate table T_FAbalCardItem -truncate table T_FAbalDevice -truncate table T_FAbalOrgFor -truncate table T_FAbalDept -truncate table T_FAbalExpense -truncate table t_FAbalPurchase -truncate table t_FAVoucher -truncate table t_FAClear -DELETE FROM T_FAAlter -DELETE FROM t_FAbalance -truncate table t_RP_NewReceiveBill -truncate table t_RP_Contact -truncate table t_rp_ARBillOfSH -truncate table t_rp_AdjustAccount -truncate table t_rp_AdjustRate -truncate table t_rp_AdjustRateEntry -truncate table t_rp_ARBillOfSH -truncate table t_RP_ARPBill -truncate table t_rp_arpbillEntry -truncate table t_rp_BegData -truncate table t_rp_BegDataEntry -truncate table t_RP_Bill -truncate table t_rp_bill_discount -truncate table t_RP_Bill_Endorse -truncate table t_RP_Bill_Settle -truncate table t_Rp_CheckDetail -truncate table t_rp_CheckDetail20120517134445300 -truncate table t_rp_CheckEntry -truncate table t_RP_Contact -truncate table t_RP_ContactBal -truncate table t_rp_ContractPlanReceive -truncate table t_RP_NewReceiveBill -truncate table t_rp_PayApplyBill -truncate table t_rp_PayApplyBillEntry -truncate table t_RP_Plan_Ap -truncate table t_RP_Plan_Ar -truncate table t_RPContract -truncate table t_rpContractEntry -truncate table t_RPContractScheme -truncate table t_RPVoucherAndBill -truncate table t_RP_NewCheckInfo -DELETE FROM t_Item_3003 -DELETE FROM t_Item_3004 -DELETE FROM t_Item_3005 -DELETE FROM t_Item_3006 -DELETE FROM t_Item_3009 -truncate table ICStockBill -truncate table ICPlanAdjPrice -truncate table POrequest -truncate table POOrder -truncate table POInstock -truncate table POInstock -truncate table ICPurchase -truncate table ICSale -truncate table SEOrder -truncate table SEOutStock -truncate table PORFQ -truncate table ICMO -truncate table ICSale -truncate table t_Voucher -truncate table t_Voucherentry -truncate table ICStockBill -truncate table ICStockBillEntry -truncate table ICPlanAdjPriEntry -truncate table POrequestEntry -truncate table POOrderEntry -truncate table POInstockEntry -truncate table ICPurchaseEntry -truncate table ICSaleEntry -truncate table SEOrderEntry -truncate table SEOutStockEntry -truncate table PORFQEntry -truncate table ppbom -truncate table ICSTJGBill -truncate table ICSTJGBillEntry -truncate table POInventory -truncate table ICChange -truncate table ICChangeEntry -truncate table ICMOChange -truncate table ICMOChangeEntry -truncate table PPBomChange -truncate table PPBomChangeEntry -truncate table PPBOMEntry -truncate table ICitemScrap -truncate table ICitemScrapEntry -truncate table ICMORpt -truncate table ICMORptEntry -truncate table QMReject -truncate table QMRejectEntry -truncate table ICMOConvertBill -truncate table ICMOConvertBillEntry -truncate table icinventory -truncate table icbal -truncate table icinvbal -truncate table ICInvInitial -truncate table ICShop_ItemConsumeEntry -truncate table CBStdStdPrice -truncate table ICQCBillEntry -truncate table cbMaterielInfo_History -truncate table ICMnbomChild -truncate table POInvBal -truncate table ICClassCheckRecords1001000 -truncate table icstockbillentry2019011501 -truncate table icstockbillentry20181120 -truncate table ICQuotePriceMtrl -truncate table CRM_SVTrace -truncate table t_msgList -truncate table cbCalinfoDetail -truncate table ICBOMChild -truncate table ICPrintCountEntry -truncate table ICClassCheckStatus1001000 -truncate table ICPrintCount -truncate table t_CashFlowBal -truncate table ICMrpResult -truncate table t_MakeVouchTemp -truncate table t_BaseProperty -truncate table ICClassMCRecord1000040 -truncate table ICClassMCStatus1000040 -truncate table t_ProfitAndLoss -truncate table t_ICItemCore -truncate table t_ICItemPlan -truncate table t_ICItemQuality -truncate table t_ICItemCustom -truncate table t_ICItemMaterial -truncate table t_ICItemBase -truncate table t_ICItemDesign -truncate table t_ICItemStandard -truncate table t_LowestBomCode -truncate table CRM_SVAssign -truncate table CRM_ServiceRequest -truncate table CRM_Satisfaction -truncate table CRM_SVProcess -truncate table cbCostObjDetail -truncate table ICVouchBillTranType -truncate table ICClassCheckRecords1001001 -truncate table t_SupplyEntry -truncate table t_Supply -truncate table cbExpenseDistributeInfo_History -truncate table ICShop_ItemConsume -truncate table ICClassTableInfo_bak20080418194131 -truncate table seorderentry20190624 -truncate table seorderentry20190516 -truncate table SEOutStockEntry20190624 -truncate table ICClassCheckStatus1001001 -truncate table CRM_Fittings -truncate table cbProductCalInfo -truncate table cbCalInfo -truncate table CRM_Contact -truncate table t_ItemDetailV -truncate table t_ItemDetail -truncate table ICMrpInfo -truncate table t_Balance -delete icstockcheckprocess -delete icinvbackup -DELETE FROM t_Item WHERE FItemID >=135 -DELETE FROM t_Base_Emp WHERE FItemID >0 -truncate table cb_CostObj_Product -truncate table cb_ICStockBill -truncate table cb_ICStockBillEntry -truncate table cbBalance -truncate table CBCalInfo_CurData -truncate table CBCalInfoDetail_CurData -truncate table cbCompleteQty -DELETE cbCostObj WHERE FItemID NOT IN (55,56) -truncate table CBCostObjAdjustDetailbak -truncate table cbExpenseDistributeInfo -truncate table cbInQty -truncate table cbMaterielInfo -truncate table cbProductQty -truncate table cn_Bill -truncate table ICbal_sean2 -truncate table ICBOM -truncate table ICClientVer -truncate table ICPlan_PMCDetail -truncate table ICPlanOrderRel -DELETE FROM t_Account -truncate table t_Department -truncate table t_dev_AZ -truncate table t_dev_AZEntry2 -truncate table t_dev_AZSQ -truncate table t_dev_AZSQEntry2 -truncate table t_dev_AZZF -truncate table t_dev_AZZFEntry2 -truncate table t_dev_freight -truncate table t_dev_freightEntry2 -truncate table t_dev_TC -truncate table t_dev_TCEntry2 -truncate table t_dev_TCPay -truncate table t_dev_TCPayEntry2 -truncate table t_dev_ZX -truncate table t_dev_ZXEntry2 -truncate table t_dev_ZXSQ -truncate table t_dev_ZXSQEntry2 -truncate table t_dev_ZXZF -truncate table t_dev_ZXZFEntry2 -truncate table t_LockStock -truncate table t_Organization -truncate table t_Stock -truncate table t_Supplier -DELETE FROM ICHookRelations -DELETE FROM cbWMaterielInfo -DELETE FROM cbWCalinfoDetail -DELETE FROM cbCostObjCheck -DELETE FROM ICQuotePrice -DELETE FROM cbWasterCostObjInfo -DELETE FROM cbCostVoucher -DELETE FROM CBCostExpenseInfo -DELETE FROM ICSubContract -DELETE FROM dbo.ICSubContractEntry -DELETE FROM ICSerialFlow ---设置 启用期间，当前期间,这里几月份开始用就设置为几月份 -update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='currentyear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FAPCurPeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FAPCurYear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FAPUsePeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FAPUseYear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FARCurPeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FARCurYear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FARUsePeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FARUseYear' ---重建索引 -DECLARE @DBCCString NVARCHAR(1000) -DECLARE @TableName VARCHAR(100) -DECLARE Cur_Index CURSOR FOR -SELECT Name AS TblName FROM sysobjects WHERE xType='U' ORDER BY TblName FOR READ ONLY -OPEN Cur_Index -FETCH NEXT FROM Cur_Index INTO @TableName - -WHILE @@FETCH_STATUS=0 -BEGIN -PRINT '重建表' + @TableName +'的索引........Start!' -SET @DBCCString = 'DBCC DBREINDEX(@TblName,'''')WITH NO_INFOMSGS' -EXEC SP_EXECUTESQL @DBCCString, N'@TblName VARCHAR(100)', @TableName -PRINT '重建表' + @TableName +'的索引........END!' -FETCH NEXT FROM Cur_Index INTO @TableName -END -CLOSE Cur_Index -DEALLOCATE Cur_Index -PRINT '操作完成！' ---收缩数据库 -DELETE FROM t_SuspendWorkPushMain -DELETE FROM t_SuspendWorkPushDetail -DELETE FROM ICClassMCTaskCenter \ No newline at end of file diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.17.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.17.sql" deleted file mode 100644 index 1c909f0..0000000 --- "a/\345\210\240\351\231\244\346\225\260\346\215\2562020.09.17.sql" +++ /dev/null @@ -1,21 +0,0 @@ ---销售合同 -truncate table t_RPContract -truncate table t_RPContractDetail -truncate table t_rpContractEntry --- 订单 -truncate table dbo.SEOrder -truncate table dbo.SEOrderEntry ---发货通知,退货通知 -truncate table dbo.SEOutStock -truncate table dbo.SEOutStockEntry ---销售发票 -truncate table dbo.ICSale -truncate table dbo.ICSaleEntry -DELETE FROM dbo.t_RP_Contact WHERE FType =3 ---销售出库，库存类的单据都在一张表，删除所有库存单据后，需要删除存货核算余额表和即时库存表 -ALTER TABLE ICStockBill DISABLE TRIGGER ALL -DELETE FROM dbo.ICStockBill WHERE FTranType IN (21) -DELETE FROM dbo.ICStockBillEntry WHERE FInterID NOT IN (SELECT FInterID FROM dbo.ICStockBill) -ALTER TABLE ICStockBill ENABLE TRIGGER ALL ---收款单，与应收系统相关，需确认后再删除，删除后需要删除余额，建议应收应付一起处理 ---需全部删除后，需更新启用期间后账套才能开始使用 \ No newline at end of file diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2563.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2563.sql" deleted file mode 100644 index 3c62319..0000000 --- "a/\345\210\240\351\231\244\346\225\260\346\215\2563.sql" +++ /dev/null @@ -1,63 +0,0 @@ ---质量管理 -TRUNCATE TABLE ICQCBill -TRUNCATE TABLE ICQCBillEntry -truncate table dbo.QMReject -truncate table dbo.QMRejectEntry -truncate table QMSaleCkRequest -truncate table QMSaleCkRequestEntry -truncate table QMINQCReq -truncate table QMINQCReqEntry -truncate table QMOtCkRequest -truncate table QMOtCkRequestEntry - ---物料需求计划 -truncate table ICMrpInfo -truncate table ICMrpResult -truncate table ICMrpDestBills - ---生产管理 -DELETE FROM ICSerialFlow -truncate table ICClientVer -truncate table ICPlan_PMCDetail -truncate table ICPlanOrderRel -truncate table ICShop_ItemConsumeEntry -truncate table ICMOConvertBill -truncate table ICMOConvertBillEntry -truncate table PPBomChange -truncate table PPBomChangeEntry -truncate table PPBOMEntry -truncate table ICitemScrap -truncate table ICitemScrapEntry -truncate table ICMORpt -truncate table ICMORptEntry -truncate table ppbom -truncate table dbo.PPBOMEntry -truncate table ICChange -truncate table ICChangeEntry -truncate table ICMOChange -truncate table ICMOChangeEntry -truncate table ICMO - ---采购管理 -truncate table dbo.PORequest -truncate table dbo.PORequestEntry -truncate table dbo.POInStock -truncate table dbo.POInStockEntry -truncate table dbo.ICExpenses -truncate table dbo.ICExpensesEntry - ---委外加工 - ---销售管理 -truncate table t_dev_freight -truncate table t_dev_freightEntry2 - ---仓库管理 -truncate table ICSTJGBill -truncate table ICSTJGBillEntry - ---需全部删除后，需更新启用期间后账套才能开始使用 -update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear' \ No newline at end of file diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2564.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2564.sql" deleted file mode 100644 index 28d7fd7..0000000 --- "a/\345\210\240\351\231\244\346\225\260\346\215\2564.sql" +++ /dev/null @@ -1,90 +0,0 @@ ---固定资产 -truncate table T_FACard -truncate table T_FACardItem -truncate table T_FADevice -truncate table T_FAOrgFor -truncate table T_FADept -truncate table T_FAExpense -truncate table t_FAPurchase -truncate table T_FAbalCard -truncate table T_FAbalCardItem -truncate table T_FAbalDevice -truncate table T_FAbalOrgFor -truncate table T_FAbalDept -truncate table T_FAbalExpense -truncate table t_FAbalPurchase -truncate table t_FAVoucher -truncate table t_FAClear -DELETE FROM T_FAAlter -DELETE FROM t_FAbalance - ---应收应付 -truncate table t_RP_NewReceiveBill -truncate table t_rp_ARBillOfSH -truncate table t_rp_AdjustAccount -truncate table t_rp_AdjustRate -truncate table t_rp_AdjustRateEntry -truncate table t_rp_ARBillOfSH -truncate table t_RP_ARPBill -truncate table t_rp_arpbillEntry -truncate table t_rp_BegData -truncate table t_rp_BegDataEntry -truncate table t_RP_Bill -truncate table t_rp_bill_discount -truncate table t_RP_Bill_Endorse -truncate table t_RP_Bill_Settle -truncate table t_Rp_CheckDetail -truncate table t_rp_CheckEntry -truncate table t_RP_Contact -truncate table t_RP_ContactBal -truncate table t_rp_ContractPlanReceive -truncate table t_RP_NewReceiveBill -truncate table t_rp_PayApplyBill -truncate table t_rp_PayApplyBillEntry -truncate table t_RP_Plan_Ap -truncate table t_RP_Plan_Ar -truncate table t_RPContractScheme -truncate table t_RPVoucherAndBill -truncate table t_RP_NewCheckInfo - ---总账 -truncate table t_ProfitAndLoss -truncate table t_Voucher -truncate table t_Voucherentry -truncate table t_Balance -truncate table t_ProfitAndLoss -truncate table icbal -truncate table icinvbal -truncate table ICInvInitial -truncate table POInvBal -truncate table cbBalance -truncate table cbCalInfo - ---报表 -delete FROM dbo.t_Rpt_Content WHERE FRptType =1 AND FRptName NOT LIKE '%2020%' - ---设置 启用期间，当前期间,这里几月份开始用就设置为几月份 -update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='startperiod' -update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='startyear' -update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='ic' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='ic' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='CB' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='CB' and FKey='currentyear' -update t_SystemProfile set FValue=9 where FCategory='FA' and FKey='currentperiod' -update t_SystemProfile set FValue=2020 where FCategory='FA' and FKey='currentyear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FAPCurPeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FAPCurYear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FAPUsePeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FAPUseYear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FARCurPeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FARCurYear' -UPDATE dbo.t_RP_SystemProfile set FValue=9 WHERE FKey ='FARUsePeriod' -UPDATE dbo.t_RP_SystemProfile set FValue=2020 WHERE FKey ='FARUseYear' \ No newline at end of file -- Gitblit v1.10.0