Add a country column to users

diff --git a/db.sql b/db.sql
index f5f988b4a329c6aae2ae135ef1a6a298fd89f049..2ef5105b4c56f4ce8a32331a490082d8a950e98d 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -8,6 +8,7 @@ CREATE TABLE users (
        town       TEXT,  -- NOT NULL,
        university TEXT,  -- NOT NULL,
        level      TEXT,  -- NOT NULL,
+       country    TEXT,
        lastjob    BIGINT
 );
 

diff --git a/lib/Gruntmaster/Data.pm b/lib/Gruntmaster/Data.pm
index 296549b8a3d6c4ce61981cff8dba3a0e7d7c498d..fd61a21ad8e63a7631e3547796cf7ef29118182d 100644 (file)
--- a/lib/Gruntmaster/Data.pm
+++ b/lib/Gruntmaster/Data.pm
@@ -26,7 +26,7 @@ use PerlX::Maybe qw/maybe/;
 use Sub::Name qw/subname/;
 
 use constant PROBLEM_PUBLIC_COLUMNS => [qw/id author writer level name owner private timeout olimit value/];
-use constant USER_PUBLIC_COLUMNS => [qw/id admin name town university level/];
+use constant USER_PUBLIC_COLUMNS => [qw/id admin name town university country level/];
 use constant JOBS_PER_PAGE => 10;
 
 sub dynsub{

diff --git a/lib/Gruntmaster/Data/Result/User.pm b/lib/Gruntmaster/Data/Result/User.pm
index 73fe6abae0088e7d0c7229e875139fff209110c6..4922354cfb4061aaade9c0725f3e235b34427ec7 100644 (file)
--- a/lib/Gruntmaster/Data/Result/User.pm
+++ b/lib/Gruntmaster/Data/Result/User.pm
@@ -75,6 +75,11 @@ Full name of user
 
 Highschool, Undergraduate, Master, Doctorate or Other
 
+=head2 country
+
+  data_type: 'text'
+  is_nullable: 1
+
 =head2 lastjob
 
   data_type: 'bigint'
@@ -103,6 +108,8 @@ __PACKAGE__->add_columns(
   { data_type => "text", is_nullable => 1 },
   "level",
   { data_type => "text", is_nullable => 1 },
+  "country",
+  { data_type => "text", is_nullable => 1 },
   "lastjob",
   { data_type => "bigint", is_nullable => 1 },
 );
@@ -212,8 +219,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-19 16:54:00
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LiA2+ZpTTelwZJtFpZRsbw
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-01-29 18:45:35
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rpx697B3St+ICCSbOn4cbQ
 
 use Class::Method::Modifiers qw/after/;