Project

General

Profile

« Previous | Next » 

Revision 14092

Added by Aaron Marcuse-Kubitza over 10 years ago

bin/make_analytical_db: removed unused code to create views in the analytical_db schema

View differences:

make_analytical_db
30 30 
mk_analytical_table()
31 31 
{
32 32 
    local table="$1"
33 
    local public_table="\"$public\".$table" analyt_table="analytical_db.$table"
33 
    local public_table="\"$public\".$table"
34 34 
    cat <<EOF
35 35 
$(mk_table "$@")
36 

  		




  37
  
  
    
-- Create $analyt_table view pointing to table in $public


  		




  38
  
  
    
DROP VIEW IF EXISTS $analyt_table;


  		




  39
  
  
    
CREATE VIEW $analyt_table AS


  		




  40
  
  
    
SELECT * FROM $public_table;


  		




  41
  
  
    
GRANT SELECT ON TABLE $analyt_table TO bien_read;


  		




  42
  36
  
    
EOF


  		




  43
  37
  
    
}


  		




  44
  38
  
    

  		












Also available in:  Unified diff