Project

General

Profile

Download (339 Bytes) Statistics
| Revision:

root/inputs/VegBank/observation_/postprocess.sql @ 11231

1 10674 aaronmk 
SELECT util.search_path_append('util');
2 

      

      

        3
        
            10943
        
        
            aaronmk
        
        
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("eventID")$$); -- runtime: ~0 ("Time: 1.838 ms") @starscream


      

      

        4
        
            11231
        
        
            aaronmk
        
        

      

      

        5
        
        
        
        
        
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("locationID")$$); -- runtime: ~0 ("158.792 ms") @starscream