Update DBIC Schema

3 files changed, 111 insertions, 6 deletions

diff --git a/db/rerun_dbic_loader.pl b/db/rerun_dbic_loader.pl
index ed2fd6375..7a3f41503 100755
--- a/db/rerun_dbic_loader.pl
+++ b/db/rerun_dbic_loader.pl
@@ -13,10 +13,20 @@ use DBIx::Class::Schema::Loader qw/ make_schema_at /;
 # create a exclude statement that filters out the table that we are not
 # interested in
 my @tables_to_ignore = (
-    'abuse',         'admin_log',       'alert',        'alert_sent',
-    'alert_type',    'comment',         'contacts',     'contacts_history',
-    'debugdate',     'flickr_imported', 'partial_user', 'problem',
-    'questionnaire', 'secret',          'textmystreet',
+    'abuse',               #
+    'admin_log',           #
+    'alert',               #
+    'alert_sent',          #
+    'alert_type',          #
+    'comment',             #
+    'contacts',            #
+    'contacts_history',    #
+    'debugdate',           #
+    'flickr_imported',     #
+    'partial_user',        #
+    'questionnaire',       #
+    'secret',              #
+    'textmystreet',        #
 );
 my $exclude = '^(?:' . join( '|', @tables_to_ignore ) . ')$';
 
diff --git a/perllib/FixMyStreet/DB/Result/Problem.pm b/perllib/FixMyStreet/DB/Result/Problem.pm
new file mode 100644
index 000000000..a0ac71070
--- /dev/null
+++ b/perllib/FixMyStreet/DB/Result/Problem.pm
@@ -0,0 +1,89 @@
+package FixMyStreet::DB::Result::Problem;
+
+# Created by DBIx::Class::Schema::Loader
+# DO NOT MODIFY THE FIRST PART OF THIS FILE
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class::Core';
+
+__PACKAGE__->table("problem");
+__PACKAGE__->add_columns(
+    "id",
+    {
+        data_type         => "integer",
+        is_auto_increment => 1,
+        is_nullable       => 0,
+        sequence          => "problem_id_seq",
+    },
+    "postcode",
+    { data_type => "text", is_nullable => 0 },
+    "council",
+    { data_type => "text", is_nullable => 1 },
+    "areas",
+    { data_type => "text", is_nullable => 0 },
+    "category",
+    { data_type => "text", default_value => "Other", is_nullable => 0 },
+    "title",
+    { data_type => "text", is_nullable => 0 },
+    "detail",
+    { data_type => "text", is_nullable => 0 },
+    "photo",
+    { data_type => "bytea", is_nullable => 1 },
+    "used_map",
+    { data_type => "boolean", is_nullable => 0 },
+    "name",
+    { data_type => "text", is_nullable => 0 },
+    "phone",
+    { data_type => "text", is_nullable => 0 },
+    "anonymous",
+    { data_type => "boolean", is_nullable => 0 },
+    "created",
+    {
+        data_type     => "timestamp",
+        default_value => \"ms_current_timestamp()",
+        is_nullable   => 0,
+    },
+    "confirmed",
+    { data_type => "timestamp", is_nullable => 1 },
+    "state",
+    { data_type => "text", is_nullable => 0 },
+    "lang",
+    { data_type => "text", default_value => "en-gb", is_nullable => 0 },
+    "service",
+    { data_type => "text", default_value => "", is_nullable => 0 },
+    "cobrand",
+    { data_type => "text", default_value => "", is_nullable => 0 },
+    "cobrand_data",
+    { data_type => "text", default_value => "", is_nullable => 0 },
+    "lastupdate",
+    {
+        data_type     => "timestamp",
+        default_value => \"ms_current_timestamp()",
+        is_nullable   => 0,
+    },
+    "whensent",
+    { data_type => "timestamp", is_nullable => 1 },
+    "send_questionnaire",
+    { data_type => "boolean", default_value => \"true", is_nullable => 0 },
+    "latitude",
+    { data_type => "double precision", is_nullable => 0 },
+    "longitude",
+    { data_type => "double precision", is_nullable => 0 },
+    "user_id",
+    { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+);
+__PACKAGE__->set_primary_key("id");
+__PACKAGE__->belongs_to(
+    "user",
+    "FixMyStreet::DB::Result::User",
+    { id            => "user_id" },
+    { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+);
+
+# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-03-15 17:03:37
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jpuxH2vKnvhlYYjy6Qjbaw
+
+# You can replace this text with custom code or comments, and it will be preserved on regeneration
+1;
diff --git a/perllib/FixMyStreet/DB/Result/User.pm b/perllib/FixMyStreet/DB/Result/User.pm
index bfc82925d..a819f1bba 100644
--- a/perllib/FixMyStreet/DB/Result/User.pm
+++ b/perllib/FixMyStreet/DB/Result/User.pm
@@ -26,8 +26,14 @@ __PACKAGE__->add_columns(
 );
 __PACKAGE__->set_primary_key("id");
 __PACKAGE__->add_unique_constraint( "users_email_key", ["email"] );
+__PACKAGE__->has_many(
+    "problems",
+    "FixMyStreet::DB::Result::Problem",
+    { "foreign.user_id" => "self.id" },
+    { cascade_copy      => 0, cascade_delete => 0 },
+);
 
-# Created by DBIx::Class::Schema::Loader v0.07009 @ 2011-03-04 11:10:43
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G+Jp+96IJFF5o2zR7vi/CQ
+# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-03-15 17:03:37
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LAenO7w6lzCJyPUeosnLTw
 
 1;