modified schema to support chat rooms

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

diff --git a/lib/Chatty/Schema/Result/Account.pm b/lib/Chatty/Schema/Result/Account.pm
index 8e55393f2f67a0c5bc92729a19bee7cd92d34001..1432ed560cab2cdec1f3783171e62eb546aa989e 100644 (file)
--- a/lib/Chatty/Schema/Result/Account.pm
+++ b/lib/Chatty/Schema/Result/Account.pm
@@ -50,6 +50,12 @@ __PACKAGE__->table("account");
   default_value: 'active'
   is_nullable: 1
 
+=head2 current_room
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -63,12 +69,34 @@ __PACKAGE__->add_columns(
   { data_type => "text", is_nullable => 0 },
   "status",
   { data_type => "text", default_value => "active", is_nullable => 1 },
+  "current_room",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 );
 __PACKAGE__->set_primary_key("id");
 __PACKAGE__->add_unique_constraint("username_unique", ["username"]);
 
 =head1 RELATIONS
 
+=head2 current_room
+
+Type: belongs_to
+
+Related object: L<Chatty::Schema::Result::Room>
+
+=cut
+
+__PACKAGE__->belongs_to(
+  "current_room",
+  "Chatty::Schema::Result::Room",
+  { id => "current_room" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "CASCADE",
+    on_update     => "CASCADE",
+  },
+);
+
 =head2 messages
 
 Type: has_many
@@ -85,8 +113,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-10-13 16:46:39
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pPJdUbHgHvUo4FxblDaJ2g
+# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-10-13 18:47:53
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:l1E3sAYHA5mK6RiNszOTzA
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration