From: Rafael Kitover Date: Thu, 13 May 2010 12:57:20 +0000 (+0000) Subject: change created/updated columns to type "timestamp" X-Git-Tag: v5.8005~10 X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=catagits%2FCatalyst-Manual.git;a=commitdiff_plain;h=33f1d5d0f724ce2cc6e8d5da5ea36735ecd069d0 change created/updated columns to type "timestamp" --- diff --git a/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod b/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod index 490eb74..a4c321d 100644 --- a/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod +++ b/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod @@ -938,8 +938,8 @@ Let's add two columns to our existing C table to track when each book was added and when each book is updated: $ sqlite3 myapp.db - sqlite> ALTER TABLE book ADD created INTEGER; - sqlite> ALTER TABLE book ADD updated INTEGER; + sqlite> ALTER TABLE book ADD created TIMESTAMP; + sqlite> ALTER TABLE book ADD updated TIMESTAMP; sqlite> UPDATE book SET created = DATETIME('NOW'), updated = DATETIME('NOW'); sqlite> SELECT * FROM book; 1|CCSP SNRS Exam Certification Guide|5|2010-02-16 04:15:45|2010-02-16 04:15:45 @@ -990,9 +990,9 @@ B the C<1;> on the last line): # __PACKAGE__->add_columns( "created", - { data_type => 'datetime', set_on_create => 1 }, + { data_type => 'timestamp', set_on_create => 1 }, "updated", - { data_type => 'datetime', set_on_create => 1, set_on_update => 1 }, + { data_type => 'timestamp', set_on_create => 1, set_on_update => 1 }, ); This will override the definition for these fields that Schema::Loader