UPDATE DM_COMMUNICATE_CONFIG SET IS_NEW=0,IS_EDIT=0,IS_DELETE=0,IS_PUBLIC=0 WHERE TABLE_NAME LIKE 'SYS_ID%'
GO
UPDATE SALE_BASE_PRICE_DETAIL SET PR_DETAIL_ID='' WHERE PR_DETAIL_ID IS NULL
GO
ALTER TABLE POS_SHIFT_ITEM DROP CONSTRAINT IX_POS_SHIFT_ITEM
GO
alter table sale_base_price_detail drop constraint FK_SALE_BASE_PRICE_DETAIL_DM_ITEM
GO
alter table dm_unit_CONVERSION drop constraint FK_DM_UNIT_CONVERSION_DM_UNIT
GO
DROP TRIGGER PR_DETAIL_DELETE
GO
DROP TRIGGER PR_DETAIL_UPDATE
GO
DROP TRIGGER ITEM_UPDATE
GO
DROP TRIGGER ITEM_DELETE
GO
DROP TRIGGER ACCOUNT_UPDATE
GO
DROP TRIGGER ACCOUNT_DELETE
GO
ALTER TABLE DM_JOB DROP CONSTRAINT FK_DM_JOB_DM_JOB_CLASS
GO
ALTER TABLE SYS_ID_FILTER DROP CONSTRAINT FK_SYS_ID_FILTER_DM_ORGANIZATION
GO
ALTER TABLE SYS_ID_DEFAULT DROP CONSTRAINT FK_SYS_ID_DEFAULT_DM_ORGANIZATION
GO
alter table sec_user drop constraint FK_SEC_USER_DM_ORGANIZATION
go
INSERT INTO DM_COMMUNICATE_CONFIG VALUES('SEC_PERMISSION',0,0,0,0,GETDATE(),'ADMIN',1)
GO
ALTER TABLE LEDGER DROP CONSTRAINT FK_LEDGER_DM_ACCOUNT
GO
ALTER TABLE BALANCE DROP CONSTRAINT FK_BALANCE_DM_ACCOUNT
GO