
-- default roles
INSERT INTO role ( role_id, role ) VALUES ( "019aeef4-bb5b-7f2e-abd5-89a8eb4be2d6", "admin" );
INSERT INTO role ( role_id, role ) VALUES ( "019b3615-3620-789b-84fa-a3611d1da9d3", "superuser" );
INSERT INTO role ( role_id, role ) VALUES ( "019aeef4-c7b6-7fe1-afb9-edec8dc5e9fe", "user" );

-- the different verification states
INSERT INTO user_state ( user_state_id, user_state ) VALUES ( "019afcea-4650-7598-907e-de32fb2a2e97", "pending" );
INSERT INTO user_state ( user_state_id, user_state ) VALUES ( "019afcea-80fe-7ce9-b2dd-17c425d2fdbf", "verified" );

-- add some settings
INSERT INTO setting ( setting_id, setting_name, setting ) VALUES ( "019afce0-9488-739b-ae15-4880b5aecb65", "brevo-key", "");
INSERT INTO setting ( setting_id, setting_name, setting ) VALUES ( "019b22b4-ff42-71eb-a661-ee9babe07416", "cookie-options", "");


-- add admin user (verified)
INSERT INTO user 
  ( 
    user_id,
    email, 
    password_hash, 
    user_state_id ,
    role_id
  ) 
VALUES 
  ( 
    "019afcef-b0e7-7d9e-9f1b-ac772b3c5913", 
    "invalid@invalid.invalid", 
    "$argon2id$v=19$m=19456,t=2,p=1$yO1a6uRYo9tMi4zf4oJHRQ$3pGTwmuEuMl+fM0Qh24KGhEVmIUO2qVd9M+pCzVR17M", 
    "019afcea-80fe-7ce9-b2dd-17c425d2fdbf",
    "019aeef4-bb5b-7f2e-abd5-89a8eb4be2d6"
  );

