Fix #274

Does Postgres allow a setting a time stamp implicitly, perhaps as a trigger?

Testing isn't that bad, and daylight savings is a minor concern IMO
On Sep 19, 2014 6:07 PM, "Antonio Gonzalez" <notifications@github.com>
wrote:

> In qiita_db/support_files/populate_test_db.sql:
>
> > @@ -336,7 +336,7 @@ INSERT INTO qiita.filepath (filepath, filepath_type_id, checksum, checksum_algor
> >  INSERT INTO qiita.job (data_type_id, job_status_id, command_id, options) VALUES (2, 1, 1, '{"--otu_table_fp":1}'), (2, 3, 2, '{"--mapping_fp":1,"--otu_table_fp":1}'), (2, 1, 2, '{"--mapping_fp":1,"--otu_table_fp":1}');
> >
> >  -- Insert Analysis
> > -INSERT INTO qiita.analysis (email, name, description, analysis_status_id, pmid) VALUES ('test@foo.bar', 'SomeAnalysis', 'A test analysis', 1, '121112'), ('test@foo.bar', 'SomeSecondAnalysis', 'Another test analysis', 1, '22221112');
> > +INSERT INTO qiita.analysis (email, name, description, analysis_status_id, pmid, timestamp) VALUES ('test@foo.bar', 'SomeAnalysis', 'A test analysis', 1, '121112', now()), ('test@foo.bar', 'SomeSecondAnalysis', 'Another test analysis', 1, '22221112', now());
>
> Fixed that.
>
> —
> Reply to this email directly or view it on GitHub
> <https://github.com/biocore/qiita/pull/310/files#r17812335>.
>