get rid of _id in database

[debbugs.git] / Debbugs / DB / Result / CorrespondentFullName.pm

diff --git a/Debbugs/DB/Result/CorrespondentFullName.pm b/Debbugs/DB/Result/CorrespondentFullName.pm
index c137ee5cf54a55adfc366c1a60a89ad243b8fc06..cce140a982e095e900b167e7bcc6e86293848440 100644 (file)
--- a/Debbugs/DB/Result/CorrespondentFullName.pm
+++ b/Debbugs/DB/Result/CorrespondentFullName.pm
@@ -57,6 +57,13 @@ Correspondent full name id
 
 Correspondent full name (includes e-mail address)
 
+=head2 last_seen
+
+  data_type: 'timestamp'
+  default_value: current_timestamp
+  is_nullable: 0
+  original: {default_value => \"now()"}
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -71,6 +78,13 @@ __PACKAGE__->add_columns(
   { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
   "full_name",
   { data_type => "text", is_nullable => 0 },
+  "last_seen",
+  {
+    data_type     => "timestamp",
+    default_value => \"current_timestamp",
+    is_nullable   => 0,
+    original      => { default_value => \"now()" },
+  },
 );
 
 =head1 PRIMARY KEY
@@ -87,17 +101,22 @@ __PACKAGE__->set_primary_key("id");
 
 =head1 UNIQUE CONSTRAINTS
 
-=head2 C<correspondent_full_name_full_name_key>
+=head2 C<correspondent_full_name_correspondent_full_name_idx>
 
 =over 4
 
+=item * L</correspondent>
+
 =item * L</full_name>
 
 =back
 
 =cut
 
-__PACKAGE__->add_unique_constraint("correspondent_full_name_full_name_key", ["full_name"]);
+__PACKAGE__->add_unique_constraint(
+  "correspondent_full_name_correspondent_full_name_idx",
+  ["correspondent", "full_name"],
+);
 
 =head1 RELATIONS
 
@@ -113,12 +132,12 @@ __PACKAGE__->belongs_to(
   "correspondent",
   "Debbugs::DB::Result::Correspondent",
   { id => "correspondent" },
-  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+  { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-03-25 18:43:53
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U7mn1zcYHvgfaD4arcYAeA
+# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-11-21 20:33:17
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cvA70xYSRFfzSAXK1z1QzQ
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration