-- Starter Digital Asset categories for tenant 1 (ABOS V1) — the 6 categories the Digital Assets
-- screen already hardcoded, plus the 8 new compliance/legal categories requested.
-- DATA ONLY — see add_asset_categories_master.sql for the table structure.
-- Idempotent — INSERT IGNORE against the (tenant_id, name) unique key, safe to re-run.
-- Deploy (local): mysql -u root -p db_abos_v0.1 < db/seed_asset_categories.sql

USE db_abos_v0.1;

INSERT IGNORE INTO dim_asset_categories (tenant_id, name, is_active, created_at, updated_at) VALUES
    (1, 'Software',        1, NOW(), NOW()),
    (1, 'SaaS',             1, NOW(), NOW()),
    (1, 'Server',           1, NOW(), NOW()),
    (1, 'License',          1, NOW(), NOW()),
    (1, 'Domain',           1, NOW(), NOW()),
    (1, 'Insurance',        1, NOW(), NOW()),
    (1, 'State Reports',    1, NOW(), NOW()),
    (1, 'Trademarks IP',    1, NOW(), NOW()),
    (1, 'SaaS-Tech',        1, NOW(), NOW()),
    (1, 'Federal License',  1, NOW(), NOW()),
    (1, 'Compliance',       1, NOW(), NOW()),
    (1, 'Dept of Labor',    1, NOW(), NOW()),
    (1, 'Reports',          1, NOW(), NOW()),
    (1, 'Other',            1, NOW(), NOW());