On Wed, Jul 04, 2007 at 01:11:01PM +0100, Jess Robinson wrote: > >Is there a way to get that in all the auto-generated table classes without > >voodoo? With? Better idea? > > > > Why not use a field type of TIMESTAMP, which in older mysqls (and in new > ones if you hit the right config buttons), always auto-fills with current > date/time when you create a new row.
Definitely do not do this before mysql 4.1.2. In those older mysqls, the first TIMESTAMP column is updated to now() whenever you update that row. Since 4.1.2 you have more control over it. http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html Anyway, is there a reason you can't use a DEFAULT? That seems the easiest thing to me, and protects you in case some other ignorant code needs to insert into your DB later. hdp. _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
