Project

General

Profile

« Previous | Next » 

Revision 14332

inputs/.TNRS/schema.sql: taxon_match: COMMENT: added steps to port derived column changes to vegbiendev

View differences:

trunk/inputs/.TNRS/schema.sql
552 552
whenever columns are renamed:
553 553
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
554 554

  
555
to port derived column changes to vegbiendev:
556
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
557
# run the returned SQL on vegbiendev
558

  
555 559
to remove columns or add columns at the end:
556 560
$ rm=1 inputs/.TNRS/data.sql.run
557 561
$ make schemas/remake
trunk/schemas/vegbien.sql
19656 19656
whenever columns are renamed:
19657 19657
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
19658 19658

  
19659
to port derived column changes to vegbiendev:
19660
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
19661
# run the returned SQL on vegbiendev
19662

  
19659 19663
to remove columns or add columns at the end:
19660 19664
$ rm=1 inputs/.TNRS/data.sql.run
19661 19665
$ make schemas/remake

Also available in: Unified diff