Project

General

Profile

Download (304 Bytes) Statistics
| Revision:

root/trunk/inputs/CVS/observation_/postprocess.sql @ 14588

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

      

      

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


      

      

        4
        
            11720
        
        
            aaronmk
        
        

      

      

        5
        
            11749
        
        
            aaronmk
        
        
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'_parent'||$$ ON $$||:table_str||$$ ("locationID")$$); -- runtime: ~0 @starscream