truncate table animal_coats cascade;

truncate table permissions cascade;

truncate table groups cascade;

truncate table users cascade;

truncate table user_accounts cascade;

insert into
    animal_coats (code)
values
    ('NEGRO'),
    ('NARANJA'),
    ('BLANCO'),
    ('CHOCOLATE');

insert into
    animal_coats (code, description)
values
    ('CAREY', 'Mezcla irregular de negro y rojo'),
    ('AZUL', 'Gris diluido'),
    ('CANELA', 'Marrón claro con toque dorado'),
    ('LILA', 'Crema con tono lavanda'),
    ('CREMA', 'Naranja pálido'),
    ('CALICO', 'Combina blanco, negro y naranja'),
    ('ATIGRADO', 'Con rayas o espirales definidas'),
    (
        'COLORPOINT',
        'Cuerpo claro con extremidades oscuras'
    ),
    (
        'AHUMADO',
        'Pelaje blanco en la base con puntas de color'
    );

insert into
    permissions (code)
values
    ('LOGIN'),
    ('USERS_ADMINISTRATE'),
    ('USERS_CREATE'),
    ('USERS_EDIT'),
    ('USERS_DISABLE'),
    ('USERS_FORCE_RESET_PASSWORD'),
    ('ANIMALS_ADMINISTRATE'),
    ('ANIMALS_CREATE'),
    ('ANIMALS_EDIT'),
    ('ANIMALS_DISABLE'),
    ('ANIMALS_SET_PUBLIC'),
    ('ANIMAL_IMAGES_ADMINISTRATE'),
    ('ANIMAL_IMAGES_UPLOAD'),
    ('ANIMAL_IMAGES_EDIT'),
    ('ANIMAL_IMAGES_DISABLE'),
    ('ANIMAL_IMAGES_SET_PUBLIC'),
    ('ANIMAL_COMMENTS_ADMINISTRATE'),
    ('ANIMAL_COMMENTS_CREATE'),
    ('ANIMAL_COMMENTS_EDIT'),
    ('ANIMAL_COMMENTS_DISABLE'),
    ('ANIMAL_COMMENTS_SET_PUBLIC'),
    ('ANIMAL_ALERTS_ADMINISTRATE'),
    ('ANIMAL_ALERTS_CREATE'),
    ('ANIMAL_ALERTS_EDIT'),
    ('ANIMAL_ALERTS_DISABLE'),
    ('SETTLEMENTS_ADMINISTRATE'),
    ('SETTLEMENTS_CREATE'),
    ('SETTLEMENTS_EDIT'),
    ('SETTLEMENTS_DISABLE');

insert into
    groups (code)
values
    ('ADMINISTRATORS'),
    ('WORKERS'),
    ('VOLUNTEERS'),
    ('ADOPTERS');

insert into
    users (id, name, surnames, email)
values
    (
        1,
        'Albert',
        'Gutiérrez Muñoz',
        'albertgmu@gmail.com'
    );

insert into
    user_accounts (user_id, username, password)
values
    (1, 'devadmin', encode (sha256 (''), 'hex'));