-- liquibase formatted sql
-- changeset broadleaf:content-folder-item-root-folder-migration
INSERT INTO BLC_CONTENT_FOLDER_ITEM (ID, CONTEXT_ID, CONTENT_ITEM_CONTEXT_ID, FOLDER_CONTEXT_ID, TRK_ARCHIVED, AUDIT_CREATION_TIME, AUDIT_CREATOR, TRK_CATALOG_CONTEXT_ID, TRK_CATALOG_LEVEL, TRK_CATALOG_LOCALE, TRK_CATALOG_NAME, TRK_COMPOSITE_SORT_LEVEL, TRK_LEVEL, TRK_SANDBOX_ARCHIVED, TRK_TENANT_ID)
SELECT
ci.id,
ci.id,
ci.context_id,
'ROOT',
'N',
CURRENT_TIMESTAMP,
'master@test.com',
'01FVJ73AVTT7RHQMQQ3TN8ZMGN',
1,
'en_US',
'Tenant Profile',
100001.00000,
100000,
'N',
'5DF1363059675161A85F576D'
FROM BLC_CONTENT_ITEM ci
ON CONFLICT DO NOTHING;