modified schema to support chat rooms

[chaz/chatty] / lib / Chatty / Schema / Result / Message.pm

diff --git a/lib/Chatty/Schema/Result/Message.pm b/lib/Chatty/Schema/Result/Message.pm
index 796a7978a69e447da07fb6307c6556b5da01e57e..792713dc545dc3f8c2b0994f17e066a0bb332bc9 100644 (file)
--- a/lib/Chatty/Schema/Result/Message.pm
+++ b/lib/Chatty/Schema/Result/Message.pm
@@ -32,6 +32,7 @@ __PACKAGE__->table("message");
 =head2 posted
 
   data_type: 'timestamp'
+  default_value: NOW
   is_nullable: 1
 
 =head2 author
@@ -40,6 +41,12 @@ __PACKAGE__->table("message");
   is_foreign_key: 1
   is_nullable: 1
 
+=head2 room
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
 =head2 content
 
   data_type: 'text'
@@ -51,9 +58,11 @@ __PACKAGE__->add_columns(
   "id",
   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
   "posted",
-  { data_type => "timestamp", is_nullable => 1 },
+  { data_type => "timestamp", default_value => \"NOW", is_nullable => 1 },
   "author",
   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+  "room",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
   "content",
   { data_type => "text", is_nullable => 1 },
 );
@@ -61,6 +70,26 @@ __PACKAGE__->set_primary_key("id");
 
 =head1 RELATIONS
 
+=head2 room
+
+Type: belongs_to
+
+Related object: L<Chatty::Schema::Result::Room>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "room",
+  "Chatty::Schema::Result::Room",
+  { id => "room" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "CASCADE",
+    on_update     => "CASCADE",
+  },
+);
+
 =head2 author
 
 Type: belongs_to
@@ -82,8 +111,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-10-13 16:46:39
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dgMXiWuIhmCQeExkpcxorA
+# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-10-13 18:47:53
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q1cq2bWftQPoo8huOftzMQ
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration