Advertisement
Guest User

Untitled

a guest
Dec 18th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. insert into galaxy (galaxy_id, galaxy_name) values (1, 'Cyclobenzaprine Hydrochloride');
  2. insert into galaxy (galaxy_id, galaxy_name) values (2, 'Amoxicillin');
  3. insert into galaxy (galaxy_id, galaxy_name) values (3, 'NITROGEN');
  4.  
  5. insert into planet_system (planet_system_id, galaxy_id, planet_system_name) values (1, 2, 'Grady and Sons');
  6. insert into planet_system (planet_system_id, galaxy_id, planet_system_name) values (2, 2, 'Homenick LLC');
  7. insert into planet_system (planet_system_id, galaxy_id, planet_system_name) values (3, 1, 'Fay-Larkin');
  8.  
  9. insert into planet (planet_id, planet_system_id, planet_name) values (1, 3, 'Bubbletube');
  10. insert into planet (planet_id, planet_system_id, planet_name) values (2, 3, 'Realbuzz');
  11. insert into planet (planet_id, planet_system_id, planet_name) values (3, 2, 'Snaptags');
  12.  
  13. insert into star (star_id, planet_system_id, star_name) values (1, 1, 'Tin');
  14. insert into star (star_id, planet_system_id, star_name) values (2, 3, 'Namfix');
  15. insert into star (star_id, planet_system_id, star_name) values (3, 1, 'Opela');
  16.  
  17. insert into space_station (space_station_id, planet_id, space_station_name) values (1, 1, 'Martin Marietta Materials, Inc.');
  18. insert into space_station (space_station_id, planet_id, space_station_name) values (2, 2, 'Gray Television, Inc.');
  19. insert into space_station (space_station_id, planet_id, space_station_name) values (3, 2, 'Webster Financial Corporation');
  20.  
  21.  
  22. insert into spaceship (spaceship_id, spaceship_station_id, spaceship_name, member_capacity) values (1, 2, 'BCE, Inc.', 881);
  23. insert into spaceship (spaceship_id, spaceship_station_id, spaceship_name, member_capacity) values (2, 3, 'Alon USA Energy, Inc.', 357);
  24. insert into spaceship (spaceship_id, spaceship_station_id, spaceship_name, member_capacity) values (3, 2, 'Ashland Global Holdings Inc.', 390);
  25.  
  26. insert into abduction (abduction_id, spaceship_id, date, location) values (1, 3, '2017-05-06 00:00:12', '(1,2)');
  27. insert into abduction (abduction_id, spaceship_id, date, location) values (2, 3, '2017-05-06 00:00:12', '(100,143)');
  28. insert into abduction (abduction_id, spaceship_id, date, location) values (3, 3, '2017-05-06 00:00:12', '(421,123)');
  29.  
  30. insert into species (species_id, planet_id, species_name, is_intelligent) values (1, 3, 'Zosterops pallidus', true);
  31. insert into species (species_id, planet_id, species_name, is_intelligent) values (2, 2, 'Amblyrhynchus cristatus', true);
  32. insert into species (species_id, planet_id, species_name, is_intelligent) values (3, 3, 'Hystrix indica', true);
  33.  
  34.  
  35. insert into subject (subject_id, abduction_id, species_id, subject_name) values (1, 1, 3, 'Rutger');
  36. insert into subject (subject_id, abduction_id, species_id, subject_name) values (2, 3, 3, 'Constantino');
  37. insert into subject (subject_id, abduction_id, species_id, subject_name) values (3, 3, 2, 'Yuma');
  38.  
  39. insert into experiment (experiment_id, experiment_name, description) values (1, 'Wart Lichen', '');
  40. insert into experiment (experiment_id, experiment_name, description) values (2, 'Suksdorf''s Monkeyflower', '');
  41. insert into experiment (experiment_id, experiment_name, description) values (3, 'Squareflower', '');
  42.  
  43. insert into subject_experiment (experiment_id, subject_id, is_successfully) values (2, 3, true);
  44. insert into subject_experiment (experiment_id, subject_id, is_successfully) values (3, 2, true);
  45. insert into subject_experiment (experiment_id, subject_id, is_successfully) values (2, 2, false);
  46.  
  47. insert into spaceship_member (spaceship_member_id, spaceship_id, species_id, spaceship_member_name) values (3, 2, 1, 'De Witt');
  48. insert into spaceship_member (spaceship_member_id, spaceship_id, species_id, spaceship_member_name) values (2, 2, 2, 'Bartholomaus');
  49. insert into spaceship_member (spaceship_member_id, spaceship_id, species_id, spaceship_member_name) values (1, 3, 2, 'Joye');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement