Facebook
From aandrieiev, 11 Months ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 111
  1. INSERT INTO public.credentials (id, login, password) VALUES (24, 'uwduser', '$2a$10$lFBogm2j3S9Of8alUrO03OGuVbIVWmq.1IgFIvUQNOVfNWqPUMzpy');
  2. INSERT INTO public.credentials (id, login, password) VALUES (25, 'uwdteacher', '$2a$10$nmgPIz.XyoSHW/Q6qBEOluOIoDWYXHYyGk75lvafCh9CZewqB1bXy');
  3. INSERT INTO public.credentials (id, login, password) VALUES (26, 'uwdadmin', '$2a$10$dkvZgQtT1TAtuF.IU.kIBO82Ta7mzBb6Lh04d6aXlyE3x0D22k9re');
  4.  
  5. INSERT INTO public.accounts (id, credential_id, birth, name, surname, INDEX) VALUES (10, 24, '2018-11-21', 'Mykhailo', 'Morisson', '00000');
  6. INSERT INTO public.accounts (id, credential_id, birth, name, surname, INDEX) VALUES (11, 25, '2018-11-21', 'Andrii', 'Andrieiev', '00001');
  7. INSERT INTO public.accounts (id, credential_id, birth, name, surname, INDEX) VALUES (12, 26, '2018-11-21', 'Dmytro', 'Szewczenko', '00002');
  8.  
  9. INSERT INTO public.groups (id, name, description) VALUES (1, 'STUDENT', 'Student group');
  10. INSERT INTO public.groups (id, name, description) VALUES (2, 'TEACHER', 'Teacher group');
  11. INSERT INTO public.groups (id, name, description) VALUES (3, 'ADMIN', 'Admin');
  12.  
  13. INSERT INTO public.credentials_groups (credential_id, group_id) VALUES (24, 1);
  14. INSERT INTO public.credentials_groups (credential_id, group_id) VALUES (25, 2);
  15. INSERT INTO public.credentials_groups (credential_id, group_id) VALUES (26, 3);