root/inputs/CVS/observation_/postprocess.sql @ 11777
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 |