-- =============================================
-- NIIC MIGRATION: Backstage → untitled
-- Generated: 2026-09-28 11:43:04
-- User ID: 6
-- Email: info@niicmusic.com
-- Name: NIIC
-- =============================================

-- 1. ARTIST ACCOUNT
-- =============================================

-- Account already exists (ID: 3), updating...
SET @artist_email = 'info@niicmusic.com';
SET @artist_name = 'NIIC';
SET @artist_id = (SELECT id FROM artist_accounts WHERE email = @artist_email);

INSERT INTO artist_accounts (
    email, password_hash, display_name, status, 
    last_login_at, created_at, updated_at
) VALUES (
    @artist_email,
    '$2y$12$amkt9zi5PUZiW3jsF0pMW.PKJqXTD9Z6SubAT/l2exgQUhesKCTVO',
    @artist_name,
    'active',
    NULL,
    '2026-07-26 13:16:17',
    NOW()
)
ON DUPLICATE KEY UPDATE
    password_hash = VALUES(password_hash),
    display_name = VALUES(display_name),
    status = 'active',
    last_login_at = VALUES(last_login_at),
    updated_at = NOW();

SET @artist_id = COALESCE(@artist_id, (SELECT id FROM artist_accounts WHERE email = @artist_email));

-- Link to artists table (NIIC is ID 1)
UPDATE artist_accounts SET artist_id = 1 WHERE id = @artist_id;

-- 2. RELEASES (12 found)
-- =============================================

-- Release: Sheptember (ID: 649226)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'single',
    'Sheptember',
    'Video Version',
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/9045a22d51f34467b93418660928e9e1.jpg',
    'en',
    '2025-02-16 00:00:00',
    'Prism Records',
    'NIIC Music under exclusive license to Prism Records',
    'NIIC Music under exclusive license to Prism Records',
    '0693887782260',
    'live',
    '2025-02-15 00:00:00',
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '0693887782260' LIMIT 1));

-- Tracks for: Sheptember
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'Sheptember',
    'Video Version',
    '0ee3666489bf4a979bc2e5c48c1723e1/bbde1260438345158d54eed6fe2d7755.flac',
    'QZPEW2599881',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'instrumentalist, lyricist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Oh Yeah Baby! (ID: 657497)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'single',
    'Oh Yeah Baby!',
    'Radio Edit',
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/1670c5136b3e4a7abc68273c8d4df1e1.jpg',
    'en',
    '2025-03-03 00:00:00',
    'Prism Records',
    'NIIC Music under exclusive license to Prism Records',
    'NIIC Music under exclusive license to Prism Records',
    '0693887831463',
    'live',
    '2025-02-28 00:00:00',
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '0693887831463' LIMIT 1));

-- Tracks for: Oh Yeah Baby!
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'Oh Yeah Baby!',
    'Radio Edit',
    '2d9b118376e3488298f5b689e430b5e1/26afbb8343964e418367b489e908660e.flac',
    'USHM21380047',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Paws Up! (ID: 808203)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'single',
    'Paws Up!',
    NULL,
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/cd7a79192c3b488983bce90a5a05b981.jpg',
    'en',
    '2025-06-14 00:00:00',
    'Prism Records',
    'Prism Records',
    'Prism Records',
    '0692788713120',
    'draft',
    '2025-06-12 00:00:00',
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '0692788713120' LIMIT 1));

-- Tracks for: Paws Up!
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'Paws Up!',
    NULL,
    '71685e8dd2d4434c9a803e013e5a0e29/0b86b6dc766e4120b53e9d2be901677b.flac',
    'QT4K52526555',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Hixbi Fox',
    'instrumentalist, lyricist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Take That (ID: 820421)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'single',
    'Take That',
    'Original',
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/QEJVBXT11xR4rkfwBdzO-edited.jpg',
    'en',
    '2024-07-05 00:00:00',
    'Hixbi Fox',
    'Prism Records',
    'Prism Records',
    '088455747763',
    'taken_down',
    NULL,
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '088455747763' LIMIT 1));

-- Tracks for: Take That
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'Take That',
    NULL,
    'de583f752f0c42e588fb9c07e0cc5aaa/bb9241d608c64bf7b0b6b133609aa8a4.flac',
    'QZX882416413',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Hixbi Fox',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Broke on Christmas (ID: 849613)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'single',
    'Broke on Christmas',
    'Original',
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/IbKivOBWSZxjkbtaRivp-edited.jpg',
    'en',
    '2018-12-25 00:00:00',
    'Niic the Singing Dog',
    'Kyle J McCarthy',
    'Niic the Singing Dog',
    '193428468924',
    'live',
    NULL,
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '193428468924' LIMIT 1));

-- Tracks for: Broke on Christmas
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'Broke on Christmas',
    NULL,
    'a289b881d7d449b7ae146f322ca3f28c/5eb74484bfc14872bf6524b60e54c583.flac',
    'USCGH1905758',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Dog House Tracks (ID: 849615)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'album',
    'Dog House Tracks',
    'Original',
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/g0wd6b1PPxLRDYesNPHt-edited.jpg',
    'en',
    '2018-12-15 00:00:00',
    'Niic the Singing Dog',
    'Kyle J McCarthy',
    'Niic the Singing Dog',
    '195079691430',
    'live',
    NULL,
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '195079691430' LIMIT 1));

-- Tracks for: Dog House Tracks
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'We All Need (Somebody to Love)',
    NULL,
    'd1b7abd9b1ff4dff80202abce411807f/da9dd40cc4d34921b3997b301d1094a7.flac',
    'USHM82000575',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    2,
    'Ballad to the Stars',
    NULL,
    'd26191b5cb624ec08ba223d3f6391f6e/5efe13a974d944d288d0067f25480ddb.flac',
    'USHM82000576',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    3,
    'Animal Party',
    NULL,
    '4df8be93fe3644679da4f65f98e06d85/c9cdaa02605b46ffbc41e0a53972ed12.flac',
    'USHM82000577',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    4,
    'On the Same Train',
    NULL,
    '56d0962795384c26ba236204826df25b/22f5fce1d2c84aac98d0d8d46c2d1766.flac',
    'USHM82000578',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    5,
    'Calendar',
    NULL,
    'eaaa6be4ffec4b46bf1f3411e9d642ac/7e717761d1954b11a47859b1ecc9a088.flac',
    'USHM82000579',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    6,
    'Run with Me',
    NULL,
    '46e99cce956c47aabbc21a56bf9d55b9/b2d820e8f3e942818cede3103949057d.flac',
    'USHM82000580',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    7,
    'Forever',
    NULL,
    'a084efb6b24a4db592378523d4ce60b7/c065e5e3941643f6a22aae09e358d3b4.flac',
    'USHM82000581',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    8,
    'In My Heart',
    NULL,
    '3d93aee0763f4e88983684568a9f0648/2371ed51b7524e90b57a2c8488714ec8.flac',
    'USHM82000582',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    9,
    'My Only Love',
    NULL,
    '9c58e5c12aa04ed586051bd23a1d47d6/fc45c8fd0b82422fb0d7b04a0a473dc6.flac',
    'USHM82000583',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    10,
    'Love (Is Our Own Land)',
    NULL,
    '93a49744b4374f11a78c65942e1f20a4/3287c58b5a804394aa2055d2fea83b15.flac',
    'USHM82000584',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    11,
    'Without You',
    NULL,
    'aac0235712794ce4b92a9a088a00d9dd/cdc690c0e81f4474be3d4b309ed83920.flac',
    'USHM82000585',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    12,
    'We''re Together Now',
    NULL,
    'afae6ef54fd9482f810d3046413d7606/ec40bdfcfcad4e579ec7d79b66dad231.flac',
    'USHM82000586',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    13,
    'Temple of the Sun',
    NULL,
    '57c9eca6e29b43379021230c83d38d98/eab6597770fa43ebb0fc45cec5f9f836.flac',
    'USHM82000587',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    14,
    'The Last Time',
    NULL,
    '8bb3a4b5bf7a4c589d9a3f10af96d6a0/a9044ad0c05842eeb7f7b64fc4dcf999.flac',
    'USHM82000588',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle  McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Deck The Dogs (ID: 855223)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'ep',
    'Deck The Dogs',
    NULL,
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/e87ec3306bde4047a16747b6e56d2131.jpg',
    'en',
    '2025-08-28 00:00:00',
    'Prism Records',
    'Prism Records',
    'Prism Records',
    '0692788935911',
    'live',
    '2025-08-13 00:00:00',
    '2026-07-17 09:36:26',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND upc = '0692788935911' LIMIT 1));

-- Tracks for: Deck The Dogs
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'My Wish',
    NULL,
    '6e8a67b2e5e54440a71d974a93f3671a/6841ee10ab6c466fa7ad27cec11d25ac.flac',
    'USL4Q1769064',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    2,
    'The List',
    'Remastered',
    'fffe52b222314c8a9516523e51da4696/233503d65ee8435da03bb0160ffe1735.flac',
    'USL4Q1769065',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    3,
    'All I Want for Christmas',
    'Remastered',
    '3b1cb73105be4a978b4d127d1137e696/9269e93b6e7447f891dc04fba18821e8.flac',
    'USL4Q1769066',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    4,
    'Once Upon a Holiday',
    NULL,
    '5adddbc1ad3849afbae284163d953ae4/17f413eebddf4bf1ad1f8ddf0123606d.flac',
    'USL4Q1769067',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    5,
    'Brand New Year',
    NULL,
    'b77c9919e2f742a98302e6fed0b51120/b201a32569f74e4dad7ae55ee065fb08.flac',
    'USL4Q1769068',
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- Release: Paws Up (ID: 1270792)
INSERT INTO releases (
    artist_account_id, release_type, title, version_line, cover_path,
    language, original_release_date, label_name, copyright_line, phono_line,
    upc, status, submitted_at, created_at, updated_at
) SELECT
    @artist_id,
    'single',
    'Paws Up',
    'Extended Mix',
    'https://toolost.s3.us-east-2.amazonaws.com/artworks/8df11afc9b5e446eb51f6967c1ebdf76.jpg',
    'en',
    '2026-07-26 00:00:00',
    'Prism Records',
    'NIIC Music under exclusive license to Prism Records',
    'NIIC Music under exclusive license to Prism Records',
    NULL,
    'in_review',
    '2026-07-24 00:00:00',
    '2026-07-28 08:54:25',
    NOW()
ON DUPLICATE KEY UPDATE
    release_type = VALUES(release_type),
    version_line = VALUES(version_line),
    cover_path = VALUES(cover_path),
    language = VALUES(language),
    original_release_date = VALUES(original_release_date),
    label_name = VALUES(label_name),
    copyright_line = VALUES(copyright_line),
    phono_line = VALUES(phono_line),
    upc = VALUES(upc),
    status = VALUES(status),
    updated_at = NOW();

SET @release_id = LAST_INSERT_ID();
SET @release_id = COALESCE(@release_id, (SELECT id FROM releases WHERE artist_account_id = @artist_id AND title = 'Paws Up' ORDER BY id DESC LIMIT 1));

-- Tracks for: Paws Up
INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    1,
    'Paws Up [Extended Mix]',
    NULL,
    'a5cbfadf31604a19a734d2d0b68a6e9e/761723e73816466d930606ae47df2b66.flac',
    NULL,
    'en',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle James McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Morgan Taylor',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle James McCarthy',
    'Producer, Album Art Direction, Mixing Engineer, Sound Design, Additional Vocals, Background Vocals, Vocals',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Morgan Taylor',
    'Producer, Mixing Engineer, Sound Design, Additional Vocals, Background Vocals, Vocals',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Alfie Frackelton',
    'Producer, Mixing Engineer, Beat Maker',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'NIIC & Hixbi Fox',
    'Special Thanks',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO release_tracks (
    release_id, track_number, title, version_line, audio_path,
    isrc, language, explicit, created_at, updated_at
) VALUES (
    @release_id,
    2,
    'Paws Up [Extended Mix]',
    'Instrumental',
    '2ca635c5d9124cfdbcec5140cfb63517/887536c9a7324b8bbf8777038a2c61d8.flac',
    NULL,
    'no linguistic content',
    0,
    NOW(),
    NOW()
);

SET @track_id = LAST_INSERT_ID();
INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle James McCarthy',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Morgan Taylor',
    'lyricist, instrumentalist',
    'writer',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Kyle James McCarthy',
    'Producer, Album Art Direction, Mixing Engineer, Sound Design',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Morgan Taylor',
    'Producer, Mixing Engineer, Sound Design',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'Alfie Frackelton',
    'Mixing Engineer, Beat Maker',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);

INSERT INTO track_credits (track_id, credit_name, role, role_type, created_at)
VALUES (
    @track_id,
    'NIIC & Hixbi Fox',
    'Special Thanks',
    'other',
    NOW()
) ON DUPLICATE KEY UPDATE role = VALUES(role);



-- 3. ROYALTY ENTRIES (from sales)
-- =============================================

-- No sales found for user 6

-- 4. PAYOUTS
-- =============================================

-- No payouts found for user 6

-- 5. VIDEOS
-- =============================================

INSERT INTO videos (
    artist_account_id, artist_name, title, description, video_path, thumbnail_path,
    featured_artists, status, review_notes, reviewed_by, reviewed_at, submitted_at, created_at
) VALUES (
    @artist_id,
    'NIIC',
    'Paws To The Walls (Album Version) [Official Visualiser]',
    'Visualiser For Niic''s Paws To The Walls.

Pre-Order the Paws To The Walls Vinyl: https://prsm.click/niic-vinyl

Stream UNLEASHED: https://ffm.to/prsm-unleashed',
    NULL,
    NULL,
    '',
    'approved',
    NULL,
    1,
    '2026-07-28 09:44:57',
    '2026-07-28 09:52:21',
    '2026-07-28 09:52:21'
);


-- 6. CHANNELS (information only - not imported)
-- =============================================

-- No channels found for user 6

-- =============================================
-- MIGRATION COMPLETE
-- =============================================
-- 
-- To run: mysql -u username -p jobo_untitled < migration.sql
-- 
-- Next steps:
-- 1. Run the generated SQL on untitled database
-- 2. Verify: SELECT * FROM artist_accounts WHERE email = @artist_email;
-- 3. Check releases: SELECT COUNT(*) FROM releases WHERE artist_account_id = @artist_id;
-- 4. Kyle can log in with his existing password from backstage
-- 
-- If password doesn't work, generate a reset token:
-- UPDATE artist_accounts SET reset_token = SHA2(RAND(), 256), reset_expires_at = DATE_ADD(NOW(), INTERVAL 7 DAY) WHERE id = @artist_id;
-- =============================================