Project

General

Profile

« Previous | Next » 

Revision 5978

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/SALVIAS/verify/plots.ref.sql: Use project_name instead of project_id as the ID to list for each project, since the SALVIAS projects table is now mapped to the DB and the project_name is used as project.projectname

View differences:

plots.ref.sql
2 2 
SELECT count(*) AS count FROM projects;
3 3 

  		




  4
  4
  
    
SELECT 'projects' AS ___;


  		




  5
  
  
    
SELECT CAST(project_id AS text) AS project FROM projects ORDER BY project;


  		




  
  5
  
    
SELECT CAST(project_name AS text) AS project FROM projects ORDER BY project;


  		




  6
  6
  
    

  		




  7
  7
  
    
SELECT 'each project''s # locations' AS ___;


  		




  8
  8
  
    
SELECT


  		












Also available in:  Unified diff