- database compare
- deploy Folder table
- migrate Folder table script tiers.sql
- add FolderId on Format Manually
- migrate Format FolderId  - Phase3_Preload.sql
- delete MainBankSeachId in Format table 
- database compare again

- fix GroupUser Manually - Phase3_Preload.sql
- fix OrganizationGroup Manually - Phase3_Preload.sql
- fix playlib,playlibrary,playlistitem data
- fix format data table
update format
set deleted = 1
from format where format = 'data' and isnull([filename],'') = ''


- added imagedocument table
-migrate imagedocument
- populate the Display name and put an index


MAKE FORMAT NULLABLE EXCEPT PK and FK
REMOVE TRIGGER
REMOVE UNRELEVANT INDEXES

delete OrganizationGroup where GroupDetailId not in (select GroupID from GroupDetail)

delete  OrganizationGroup where OrganizationId not in (select Id from Organization)



Migrate GroupClients

-- DELETE GroupClients where GroupID not in ( select GroupId from GroupDetail)

INSERT INTO FolderGroup(FolderId,GroupId)
SELECT 
	FolderId = (SELECT TOP 1 Id FROM Folder WHERE Name = B.Client AND Tier = 1),
	A.GroupID
FROM GroupClients AS A
LEFT JOIN MainBankClientLookup AS B ON A.ClientID = B.ClientTypeID 
WHERE A.ProdID = 0 AND ISNULL(B.IsDeleted,0) = 0 AND Client IS NOT NULL
GO


INSERT INTO FolderGroup(FolderId,GroupId)
SELECT 
	FolderId = (SELECT TOP 1 Id FROM Folder WHERE Name = B.Product AND Tier = 2),
	A.GroupID
FROM GroupClients AS A
LEFT JOIN MainBankProductLookup AS B ON A.ProdID = B.ProductTypeID
WHERE A.ProdID > 0 AND ISNULL(B.IsDeleted,0) = 0 AND Product IS NOT NULL

--



--

delete FROM GroupClients where ClientID = 233 and ProdID = 583 and GroupID = 235
go
SELECT 
A.ClientId,
a.ProdID,
	FolderId = (SELECT TOP 1 Id FROM Folder WHERE Name = B.Product AND Tier = 2),
	A.GroupID
FROM GroupClients AS A
LEFT JOIN MainBankProductLookup AS B ON A.ProdID = B.ProductTypeID
WHERE A.ProdID > 0 AND ISNULL(B.IsDeleted,0) = 0 AND B.Product NOT IN (Select NAME FROM Folder WHERE TIER =2 )
go



TRANSFER DOCUMENT IMAGE TO DIFFERENT TABLE


---------------------------------------------