92 lines
2.1 KiB
SQL
92 lines
2.1 KiB
SQL
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')); |