API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 19th, 2020
175
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.75 KB | None | 0 0
raw download clone embed print report
  1. # Tables with no dependencies
  2. INSERT INTO adonis.expat_statuses (name) VALUES ("In progress.");
  3. INSERT INTO adonis.expat_statuses (name) VALUES ("Almost done.");
  4. INSERT INTO adonis.expat_statuses (name) VALUES ("Now its almost done.");
  5. INSERT INTO adonis.expat_statuses (name) VALUES ("On arrival.");
  6. INSERT INTO adonis.expat_statuses (name) VALUES ("Waiting Visa.");
  7. INSERT INTO adonis.expat_statuses (name) VALUES ("On the airport.");
  8. -- INSERT INTO adonis.languages (name,src) VALUES ("pt","imagem");
  9. -- INSERT INTO adonis.languages (name,src) VALUES ("en","imagem");
  10. -- INSERT INTO adonis.languages (name,src) VALUES ("es","imagem");
  11. -- INSERT INTO adonis.languages (name,src) VALUES ("de","imagem");
  12. -- INSERT INTO adonis.languages (name,src) VALUES ("ch","imagem");
  13. -- INSERT INTO adonis.languages (name,src) VALUES ("fr","imagem");
  14. -- -- INSERT INTO adonis.languages (name,src) VALUES ("pl","imagem");
  15. -- INSERT INTO adonis.language_proficiencies (name) VALUES ("A1");
  16. -- INSERT INTO adonis.language_proficiencies (name) VALUES ("A2");
  17. -- INSERT INTO adonis.language_proficiencies (name) VALUES ("B1");
  18. -- INSERT INTO adonis.language_proficiencies (name) VALUES ("B2");
  19. -- INSERT INTO adonis.language_proficiencies (name) VALUES ("C1");
  20. -- INSERT INTO adonis.language_proficiencies (name) VALUES ("C2");
  21. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng0");
  22. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng1");
  23. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng10");
  24. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng2");
  25. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng3");
  26. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng4");
  27. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng5");
  28. -- INSERT INTO adonis.ncrs (name) VALUES ("Eng6");
  29. -- INSERT INTO adonis.profiles (name) VALUES ("TUM");
  30. -- INSERT INTO adonis.profiles (name) VALUES ("TL");
  31. -- INSERT INTO adonis.profiles (name) VALUES ("Admin");
  32. -- INSERT INTO adonis.profiles (name) VALUES ("TM");
  33. -- INSERT INTO adonis.profiles (name) VALUES ("TUD");
  34. INSERT INTO adonis.roles (name) VALUES ("Junior Consultant Engineer");
  35. INSERT INTO adonis.roles (name) VALUES ("Advanced Consultant Engineer");
  36. INSERT INTO adonis.roles (name) VALUES ("CEO");
  37. INSERT INTO adonis.roles (name) VALUES ("Expert");
  38. INSERT INTO adonis.roles (name) VALUES ("Architect");
  39. INSERT INTO adonis.roles (name) VALUES ("Consultant Engineer");
  40. INSERT INTO adonis.roles (name) VALUES ("Senior Consultant Engineer");
  41. -- INSERT INTO adonis.sites (name) VALUES ("Fundao");
  42. -- INSERT INTO adonis.sites (name) VALUES ("Lisboa");
  43. -- INSERT INTO adonis.sites (name) VALUES ("Porto");
  44. -- INSERT INTO adonis.sites (name) VALUES ("Zurich");
  45. -- INSERT INTO adonis.sites (name) VALUES ("Bern");
  46. INSERT INTO adonis.technologies (name) VALUES ("Java");
  47. INSERT INTO adonis.technologies (name) VALUES ("C#");
  48. INSERT INTO adonis.technologies (name) VALUES ("JS");
  49. INSERT INTO adonis.technologies (name) VALUES ("React");
  50. INSERT INTO adonis.technologies (name) VALUES ("C++");
  51. INSERT INTO adonis.technologies (name) VALUES ("Go");
  52. INSERT INTO adonis.technologies (name) VALUES ("Python");
  53. INSERT INTO adonis.technologies (name) VALUES ("Android");
  54. INSERT INTO adonis.technologies (name) VALUES ("Kotlin");
  55. INSERT INTO adonis.technologies (name) VALUES ("JavaFX");
  56. INSERT INTO adonis.technologies (name) VALUES ("iOS");
  57. INSERT INTO adonis.techunits (name) VALUES ("Digital");
  58. INSERT INTO adonis.techunits (name) VALUES ("ISY");
  59. INSERT INTO adonis.techunits (name) VALUES ("Embeded Systems");
  60. INSERT INTO adonis.techunits (name) VALUES ("Software");
  61. INSERT INTO adonis.techunits (name) VALUES ("Tests");
  62. INSERT INTO adonis.users (name,email,password) VALUES ("Pedro Antunes","eu@aqui.pt","1234");
  63. INSERT INTO adonis.users (name,email,password) VALUES ("Nuno Rebeca","nos@aqui.pt","1234");
  64. # User for login, password is Qwertyuiop1!
  65. INSERT INTO adonis.users (name,email,password) VALUES ("Admin", "admin@admin.com", '$2a$10$v1eS0KyFoGjrF2q8aI869OykALkrEmvxbWVqoeEPANGt9SiZTkdE6');
  66. INSERT INTO adonis.users (name,email,password) VALUES ("Eurico Nuno","eurnun@aqui.pt","1234");
  67. INSERT INTO adonis.users (name,email,password) VALUES ("Francisca Raquel","francisca@aqui.pt","1234");
  68. INSERT INTO adonis.users (name,email,password) VALUES ("Mariana Paula","marpau@aqui.pt","1234");
  69. INSERT INTO adonis.users (name,email,password) VALUES ("Kevin Goncalves","kevgon@aqui.pt","1234");
  70. INSERT INTO adonis.users (name,email,password) VALUES ("Johnny Bravo","johnbra@aqui.pt","1234");
  71. INSERT INTO adonis.users (name,email,password) VALUES ("Andre Andrade","andand@aqui.pt","1234");
  72. INSERT INTO adonis.users (name,email,password) VALUES ("Maria Floriana","marflo@aqui.pt","1234");
  73.  
  74. # Table with some dependencies
  75. INSERT INTO adonis.departments (name,techunit_id) VALUES ("Dig/Java",1);
  76. INSERT INTO adonis.departments (name,techunit_id) VALUES ("Dig/TMT",1);
  77. INSERT INTO adonis.departments (name,techunit_id) VALUES ("Dig/FrontEnd",1);
  78. INSERT INTO adonis.departments (name,techunit_id) VALUES ("ISY/Mobile",2);
  79. INSERT INTO adonis.departments (name,techunit_id) VALUES ("ESCS/Hardware",3);
  80. INSERT INTO adonis.departments (name,techunit_id) VALUES ("ESCS/Testing",3);
  81. INSERT INTO adonis.departments (name,techunit_id) VALUES ("Soft/Management",4);
  82. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Joao",1,1,2,2);
  83. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Pipo",2,2,2,2);
  84. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Luis",2,1,2,1);
  85. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Admin",3,3,1,1);
  86. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Pipo Loiro Madaleno",2,2,2,2);
  87. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Luis Almirante Otorrinolaringologista",2,1,2,1);
  88. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Daniel Saxe-Coburgo-Gotha",2,1,2,1);
  89. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Admin",3,3,7,1);
  90. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Belmiro Joao",1,2,3,1);
  91. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Adelaide Afonso",4,2,6,1);
  92. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Antonio Delaila",5,2,6,1);
  93. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Josefa Miquelina",6,2,4,1);
  94. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Barbra Streisand",2,2,4,1);
  95. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id) VALUES ("Maria Nascimento Falecimento",1,2,3,1);
  96. # Extra expats
  97. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id,isExpat) VALUES ("Ze Falecimento para Depois",1,2,1,1,true);
  98. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id,isExpat) VALUES ("Ze",1,2,1,1,true);
  99. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id,isExpat) VALUES ("Joao Magalhes Eurico dos Cravos",1,1,2,2,true);
  100. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id,isExpat) VALUES ("Herminio Expat",1,1,1,1,true);
  101. INSERT INTO adonis.employees (name,role_id,ncr_id,department_id,site_id,isExpat) VALUES ("Jeronimo Expat",2,2,2,2,true);
  102.  
  103. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (1,"Team Management Tool",1, "2001-06-15", "2021-06-15");
  104. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (5,"Hermes",2, "2002-06-15", "2022-06-15");
  105. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (2,"Projeto Simples",1, "2006-06-15", "2020-06-15");
  106. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (4,"Projeto para Abrir",1, "2005-06-15", "2014-06-15");
  107. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (3,"GPS Integration",4, "2007-06-15", "2016-06-15");
  108. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (8,"Android Improvement",4, "2008-06-15", "2017-06-15");
  109. INSERT INTO adonis.projects (manager_id,name,department_id,startDate, endDate) VALUES (6,"Server Management",7, "2009-06-15", "2018-06-15");
  110.  
  111.  
  112.  
  113. # Relation tables
  114. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (1,1,1);
  115. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (2,9,2);
  116. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (1,5,3);
  117. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (3,7,2);
  118. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (4,6,4);
  119. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (5,8,5);
  120. INSERT INTO adonis.department_user_profiles (`department_id`,`user_id`,`profile_id`) VALUES (7,3,2);
  121. INSERT INTO adonis.employee_expats (employee_id, expat_status_id, availability) VALUES (15,1, "2020-01-20");
  122. INSERT INTO adonis.employee_expats (employee_id, expat_status_id, availability) VALUES (16,2, "2020-02-20");
  123. INSERT INTO adonis.employee_expats (employee_id, expat_status_id, availability) VALUES (17,3, "2020-03-20");
  124. INSERT INTO adonis.employee_expats (employee_id, expat_status_id) VALUES (18,4);
  125. INSERT INTO adonis.employee_expats (employee_id, expat_status_id) VALUES (19,5);
  126. INSERT INTO adonis.employee_languages (employee_id, language_id, proficiency_id) VALUES (1,2,2);
  127. INSERT INTO adonis.employee_languages (employee_id, language_id, proficiency_id) VALUES (1,1,1);
  128. INSERT INTO adonis.employee_languages (employee_id, language_id, proficiency_id) VALUES (2,1,3);
  129. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (2,1);
  130. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (3,2);
  131. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (3,3);
  132. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (4,3);
  133. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (5,1);
  134. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (8,1);
  135. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (9,1);
  136. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (9,4);
  137. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (10,4);
  138. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (11,4);
  139. INSERT INTO adonis.employee_projects (employee_id, project_id) VALUES (11,5);
  140. INSERT INTO adonis.employee_technologies (employee_id, technology_id, isMainSkill) VALUES (1,1,1);
  141. INSERT INTO adonis.employee_technologies (employee_id, technology_id) VALUES (1,2);
  142. INSERT INTO adonis.employee_technologies (employee_id, technology_id, isMainSkill) VALUES (3,3,1);
  143. INSERT INTO adonis.employee_technologies (employee_id, technology_id) VALUES (3,2);
  144. INSERT INTO adonis.employee_technologies (employee_id, technology_id) VALUES (4,2);
  145. INSERT INTO adonis.employee_technologies (employee_id, technology_id) VALUES (2,4);
  146. INSERT INTO adonis.employee_users (employee_id, user_id) VALUES (5,3);
  147. INSERT INTO adonis.employee_users (employee_id, user_id) VALUES (3,1);
  148. INSERT INTO adonis.techunit_user_profiles (`techunit_id`,`user_id`,`profile_id`) VALUES (1,1,1);
  149. INSERT INTO adonis.techunit_user_profiles (`techunit_id`,`user_id`,`profile_id`) VALUES (2,2,2);
  150. INSERT INTO adonis.techunit_user_profiles (`techunit_id`,`user_id`,`profile_id`) VALUES (1,4,3);
  151. INSERT INTO adonis.techunit_user_profiles (`techunit_id`,`user_id`,`profile_id`) VALUES (3,4,3);
  152. INSERT INTO adonis.techunit_user_profiles (`techunit_id`,`user_id`,`profile_id`) VALUES (4,5,2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!