INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-88', 'ACCOUNT_SAVED_PAYMENT_MANAGEMENT', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-89', 'ACCOUNT_ADDRESS', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-200', 'RATING_DETAIL', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-210', 'ACCOUNT', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-211', 'ACCOUNT_MEMBER', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-215', 'EXECUTE_DETACHED_CREDIT', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-410', 'ACCOUNT_USERS', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-500', 'ACCOUNT_INVITE', 'N');
INSERT INTO blc_security_scope (id, "name", "open")VALUES('-400', 'CUSTOMER_STORE_CREDIT_ACCOUNT', 'N');
INSERT INTO blc_security_scope (id, "name", "open")VALUES('-505', 'STORE_CREDIT_CREDIT_TRANSACTION', 'N');
INSERT INTO blc_security_scope (id, "name", "open")VALUES('-600', 'STORE_CREDIT_DEBIT_TRANSACTION', 'N');
INSERT INTO blc_security_scope (id, "name", "open") VALUES('-610', 'CREATE_SETUP_INTENT', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-700', 'SEND_CART_REJECTION_EVENT', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-800', 'ACCOUNT_PAYMENT_MANAGEMENT', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-900', 'ACCOUNT_ORDER', 'N');
INSERT INTO blc_security_scope ("id", "name", "open")VALUES ('-1000', 'APPROVE_CART', 'N');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-134', 'ACCOUNT_SAVED_PAYMENT_MANAGEMENT', 'Y', '-88');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-135', 'ACCOUNT_ADDRESS', 'Y', '-89');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-201', 'RATING_DETAIL', 'Y', '-200');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-210', 'ACCOUNT', 'Y', '-210');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-211', 'ACCOUNT_MEMBER', 'Y', '-211');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-215', 'EXECUTE_DETACHED_CREDIT', 'Y', '-215');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-411', 'ACCOUNT_USERS', 'Y', '-410');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-501', 'ACCOUNT_INVITE', 'Y', '-500');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-800', 'CUSTOMER_STORE_CREDIT_ACCOUNT', 'Y', '-400');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-900', 'STORE_CREDIT_CREDIT_TRANSACTION', 'Y', '-505');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-1000', 'STORE_CREDIT_DEBIT_TRANSACTION', 'Y', '-600');
INSERT INTO blc_permission_scope(id, permission, is_permission_root, scope_id)
VALUES('-1010', 'CREATE_SETUP_INTENT', 'Y', '-610');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-1100', 'SEND_CART_REJECTION_EVENT', 'Y', '-700');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-1200', 'ACCOUNT_PAYMENT_MANAGEMENT', 'Y', '-800');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-1300', 'ACCOUNT_ORDER', 'Y', '-900');
INSERT INTO blc_permission_scope ("id", "permission", "is_permission_root", "scope_id")
VALUES ('-1400', 'APPROVE_CART', 'Y', '-1000');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-401', 'ACCOUNT_SAVED_PAYMENT_MANAGEMENT', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-402', 'ACCOUNT_ADDRESS', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-200', 'RATING_DETAIL', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-500', 'ACCOUNT_INVITE', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-410', 'ACCOUNT_USERS', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-412', 'ACCOUNT_MEMBER', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-610', 'CREATE_SETUP_INTENT', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-700', 'ACCOUNT_PAYMENT_MANAGEMENT', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-801', 'ACCOUNT_ORDER', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-901', 'APPROVE_CART', 'Y', '-100');
INSERT INTO blc_permission_scope (id, "permission", is_permission_root, scope_id)
VALUES('-911', 'CUSTOMER_STORE_CREDIT_ACCOUNT', 'Y', '-100');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-300', 'N', '1970-01-01 00:00:00.000', 'READ_RATING_DETAIL', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-301', 'N', '1970-01-01 00:00:00.000', 'ALL_RATING_DETAIL', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-310', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-311', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-312', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_MEMBER', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-313', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_MEMBER', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-314', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_ADDRESS', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-315', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_ADDRESS', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-700', 'N', '1970-01-01 00:00:00.000', 'ALL_CUSTOMER_STORE_CREDIT_ACCOUNT', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-710', 'N', '1970-01-01 00:00:00.000', 'READ_CUSTOMER_STORE_CREDIT_ACCOUNT', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-720', 'N', '1970-01-01 00:00:00.000', 'CREATE_CUSTOMER_STORE_CREDIT_ACCOUNT', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-730', 'N', '1970-01-01 00:00:00.000', 'DELETE_CUSTOMER_STORE_CREDIT_ACCOUNT', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-800', 'N', '1970-01-01 00:00:00.000', 'ALL_STORE_CREDIT_CREDIT_TRANSACTION', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-810', 'N', '1970-01-01 00:00:00.000', 'ALL_STORE_CREDIT_DEBIT_TRANSACTION', 'N');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-820', 'N', '1970-01-01 00:00:00.000', 'ALL_CREATE_SETUP_INTENT', 'N');
-- Account User Permissions
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-410', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_USERS', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-411', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_USERS', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-420', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_ADDRESS', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-421', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_ADDRESS', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-248', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_SAVED_PAYMENT_MANAGEMENT', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-249', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_SAVED_PAYMENT_MANAGEMENT', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-500', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_INVITE', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-501', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_ORDER', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-502', 'N', '1970-01-01 00:00:00.000', 'ALL_APPROVE_CART', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-503', 'N', '1970-01-01 00:00:00.000', 'ALL_ACCOUNT_PAYMENT_MANAGEMENT', 'Y');
INSERT INTO blc_user_permission ("id", "archived", "last_updated", "name", "is_account_perm")
VALUES('-504', 'N', '1970-01-01 00:00:00.000', 'READ_ACCOUNT_PAYMENT_MANAGEMENT', 'Y');
-- Add New Account Roles
-- Account Member Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-1000', 'ROLE_ACCOUNT_MEMBER', '1970-01-01 00:00:00.000', 'Y', 'Member', 'Grants permission to shop as a member of an account including using (but not modifying) account addresses.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-1000', '-421');
-- Account Admin Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8006', 'ACCOUNT_ADMIN', '1970-01-01 00:00:00.000', 'Y', 'Admin', 'Grants permissions to manage account members, addresses, and payment methods.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-500');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-410');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-420');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-503');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-248');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-501');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8006', '-502');
-- Manage Account Users Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8000', 'MANAGE_ACCOUNT_USERS', '1970-01-01 00:00:00.000', 'Y', 'MANAGE_ACCOUNT_USERS', 'Grants permission to read members of an account, manage existing members of an account, and invite new account members.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8000', '-500');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8000', '-410');
-- Read Account Users Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8001', 'READ_ACCOUNT_USERS', '1970-01-01 00:00:00.000', 'Y', 'Read Account Members', 'Grants permission to read members of an account.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8001', '-411');
-- Manage Account Addresses Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8002', 'MANAGE_ACCOUNT_ADDRESSES', '1970-01-01 00:00:00.000', 'Y', 'Manage Account Addresses', 'Grants permission to read, manage, and use account addresses.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8002', '-420');
-- Read Account Addresses Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8003', 'READ_ACCOUNT_ADDRESSES', '1970-01-01 00:00:00.000', 'Y', 'Read Account Addresses', 'Grants permission to read account addresses.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8003', '-421');
-- Manage Account Payments Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8004', 'MANAGE_ACCOUNT_PAYMENTS', '1970-01-01 00:00:00.000', 'Y', 'Manage Account Payments', 'Grants permission to read, manage, and use an account''s payment methods.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8004', '-503');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8004', '-248');
-- Read Account Payments Role
INSERT INTO blc_user_role (id, name, last_updated, is_account_role, friendly_name, description)
VALUES ('-8005', 'READ_ACCOUNT_PAYMENTS', '1970-01-01 00:00:00.000', 'Y', 'Read Account Payments', 'Grants permission to read an account''s payment methods.');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8005', '-504');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-8005', '-249');
-- Add permissions to existing roles
-- Full Access Role
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-301');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-310');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-312');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-314');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-700');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-800');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-2', '-810');
-- Partial Access Role
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-1', '-300');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-1', '-311');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-1', '-313');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-1', '-315');
-- Vendor Merchandiser Role
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-202', '-300');
-- Vendor Admin Role
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-201', '-300');
-- Marketplace Operator Role
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-200', '-300');
-- Application Access Role
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-7', '-301');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-7', '-310');
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-7', '-312');
-- Customer User Role
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-100', '-301');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-100', '-710');
INSERT INTO blc_role_permission_xref (role_id, permission_id) VALUES ('-100', '-820');
-- Anonymous Client
INSERT INTO blc_client_scopes(id, "scope") VALUES('anonymous', 'RATING_DETAIL');
INSERT INTO blc_client_permissions ("id", "permission") VALUES ('anonymous', 'ALL_RATING_DETAIL');
-- OrderOps Client
INSERT INTO blc_client_scopes ("id", "scope") VALUES ('orderopsclient', 'EXECUTE_DETACHED_CREDIT');
INSERT INTO blc_client_permissions ("id", "permission") VALUES ('orderopsclient', 'ALL_EXECUTE_DETACHED_CREDIT');
-- CartOps Client
INSERT INTO blc_client_scopes ("id", "scope") VALUES ('cartopsclient', 'CUSTOMER');
INSERT INTO blc_client_scopes ("id", "scope") VALUES ('cartopsclient', 'ACCOUNT');
INSERT INTO blc_client_scopes ("id", "scope") VALUES ('cartopsclient', 'SEND_CART_REJECTION_EVENT');
INSERT INTO blc_client_scopes ("id", "scope") VALUES ('cartopsclient', 'CUSTOMER_STORE_CREDIT_ACCOUNT');
INSERT INTO blc_client_permissions ("id", "permission") VALUES ('cartopsclient', 'READ_CUSTOMER');
INSERT INTO blc_client_permissions ("id", "permission") VALUES ('cartopsclient', 'READ_ACCOUNT');
INSERT INTO blc_client_permissions ("id", "permission") VALUES ('cartopsclient', 'UPDATE_SEND_CART_REJECTION_EVENT');
INSERT INTO blc_client_permissions ("id", "permission") VALUES ('cartopsclient', 'READ_CUSTOMER_STORE_CREDIT_ACCOUNT');
-- StoreCredit Client
INSERT INTO blc_client (id, attributes, client_id, friendly_name, client_secret, is_admin, auth_server_id, token_timeout_seconds, refresh_token_rot_intrvl_scnds, refresh_token_timeout_seconds)
VALUES ('storecreditclient', '{}', 'storecreditclient', 'Store Credit Service Client', 'TODO MY SECRET', 'N', '2', 300, 60, 7200);
INSERT INTO blc_client_grant_types (id, grant_type) VALUES ('storecreditclient', 'client_credentials');
INSERT INTO blc_client_scopes (id, "scope") VALUES('storecreditclient', 'STORE_CREDIT_DEBIT_TRANSACTION');
INSERT INTO blc_client_scopes (id, "scope") VALUES('storecreditclient', 'STORE_CREDIT_CREDIT_TRANSACTION');
INSERT INTO blc_client_permissions (id, permission) VALUES ('storecreditclient', 'ALL_STORE_CREDIT_DEBIT_TRANSACTION');
INSERT INTO blc_client_permissions (id, permission) VALUES ('storecreditclient', 'ALL_STORE_CREDIT_CREDIT_TRANSACTION');
