project test seeds

project-seeds.sql

INSERT INTO projects 
  (type, proj_name, proj_desc, proj_loc, proj_start, proj_duration)
VALUES
  ('project', 'Proj 1', 'project one stuff', 'ruby mountains', '2015-01-01', 3),
  ('project', 'Proj 2', 'project two stuff', 'ruby mountains', '2015-01-01', 2),
  ('project', 'Proj 3', 'project three stuff', 'ruby mountains', '2015-10-01', 4),
  ('stage', 'Proj 1, Stage 1', 'stage 1 proj 1', 'southern ruby', '2015-01-01', 1),
  ('stage', 'Proj 1, Stage 2', 'stage 1 proj 2', 'southern ruby', '2016-01-01', 1),
  ('stage', 'Proj 1, Stage 3', 'stage 1 proj 3', 'southern ruby', '2017-01-01', 1);

INSERT INTO project_stages 
  (proj_id, stage_id)
VALUES
  (1, 4),
  (1, 5),
  (1, 6);

INSERT INTO users (name)
VALUES ('Mike Cox'), ('Peri Wolff'), ('Pat Cummings'), ('Jen Newmark'), ('Jason Williams'), ('USGS'), ('USFS'), 
('BLM'), ('Cody McKee'), ('Cody Schroeder'), ('Matt Jeffress'), ('Caleb McAdoo');

INSERT INTO project_users (type, user_id, project_id)
VALUES 
  ('lead', 1, 1),
  ('lead', 2, 1),
  ('colab', 11, 1),
  ('colab', 12, 1),
  ('colab', 3, 1),
  ('lead', 4, 2),
  ('lead', 5, 2),
  ('colab', 6, 2),
  ('colab', 7, 2),
  ('colab', 8, 2),
  ('lead', 11, 3),
  ('lead', 9, 3);

INSERT INTO species (species)
VALUES ('RBHS'), ('DBHS'), ('CBHS'), ('MULD'), ('RMEL'), ('BBAT'), ('HBAT'), ('MYVO'), ('MYEV'), ('LANO');

INSERT INTO project_species (species_id, project_id)
VALUES
  (1, 1),
  (2, 1),
  (3, 1),
  (6, 2),
  (7, 2),
  (8, 2),
  (9, 2),
  (10, 2),
  (5, 3);