-use base qw(SL::DB::Object);
-
-__PACKAGE__->meta->setup(
- table => 'clients',
-
- columns => [
- id => { type => 'serial', not_null => 1 },
- name => { type => 'text', not_null => 1 },
- dbhost => { type => 'text', not_null => 1 },
- dbport => { type => 'integer', default => 5432, not_null => 1 },
- dbname => { type => 'text', not_null => 1 },
- dbuser => { type => 'text', not_null => 1 },
- dbpasswd => { type => 'text', not_null => 1 },
- is_default => { type => 'boolean', default => 'false', not_null => 1 },
- ],
-
- primary_key_columns => [ 'id' ],
-
- unique_keys => [
- [ 'dbhost', 'dbport', 'dbname' ],
- [ 'name' ],
- ],
+use parent qw(SL::DB::Object);
+
+__PACKAGE__->meta->table('clients');
+__PACKAGE__->meta->schema('auth');
+
+__PACKAGE__->meta->columns(
+ dbhost => { type => 'text', not_null => 1 },
+ dbname => { type => 'text', not_null => 1 },
+ dbpasswd => { type => 'text', not_null => 1 },
+ dbport => { type => 'integer', default => 5432, not_null => 1 },
+ dbuser => { type => 'text', not_null => 1 },
+ id => { type => 'serial', not_null => 1 },
+ is_default => { type => 'boolean', default => 'false', not_null => 1 },
+ name => { type => 'text', not_null => 1 },
+ task_server_user_id => { type => 'integer' },
+);
+
+__PACKAGE__->meta->primary_key_columns([ 'id' ]);
+
+__PACKAGE__->meta->unique_keys(
+ [ 'dbhost', 'dbport', 'dbname' ],
+ [ 'name' ],
+);
+
+__PACKAGE__->meta->foreign_keys(
+ task_server_user => {
+ class => 'SL::DB::AuthUser',
+ key_columns => { task_server_user_id => 'id' },
+ },