View | Details | Raw Unified | Return to bug 20813
Collapse All | Expand All

(-)a/Koha/Schema/Result/Borrower.pm (-9 / +2 lines)
Lines 303-313 __PACKAGE__->table("borrowers"); Link Here
303
  is_nullable: 1
303
  is_nullable: 1
304
  size: 60
304
  size: 60
305
305
306
=head2 flags
307
308
  data_type: 'integer'
309
  is_nullable: 1
310
311
=head2 userid
306
=head2 userid
312
307
313
  data_type: 'varchar'
308
  data_type: 'varchar'
Lines 584-591 __PACKAGE__->add_columns( Link Here
584
  { data_type => "varchar", is_nullable => 1, size => 1 },
579
  { data_type => "varchar", is_nullable => 1, size => 1 },
585
  "password",
580
  "password",
586
  { data_type => "varchar", is_nullable => 1, size => 60 },
581
  { data_type => "varchar", is_nullable => 1, size => 60 },
587
  "flags",
588
  { data_type => "integer", is_nullable => 1 },
589
  "userid",
582
  "userid",
590
  { data_type => "varchar", is_nullable => 1, size => 75 },
583
  { data_type => "varchar", is_nullable => 1, size => 75 },
591
  "opacnote",
584
  "opacnote",
Lines 1401-1408 Composing rels: L</aqorder_users> -> ordernumber Link Here
1401
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1394
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1402
1395
1403
1396
1404
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-04-11 19:53:27
1397
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-21 06:16:14
1405
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/vLIMxDv4RcJOqKj6Mfg6w
1398
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nb3lLm1aLSltzLN0OJNsxw
1406
1399
1407
__PACKAGE__->belongs_to(
1400
__PACKAGE__->belongs_to(
1408
    "guarantor",
1401
    "guarantor",
(-)a/Koha/Schema/Result/Permission.pm (-26 / +36 lines)
Lines 23-34 __PACKAGE__->table("permissions"); Link Here
23
23
24
=head1 ACCESSORS
24
=head1 ACCESSORS
25
25
26
=head2 module_bit
26
=head2 parent
27
27
28
  data_type: 'integer'
28
  data_type: 'varchar'
29
  default_value: 0
30
  is_foreign_key: 1
29
  is_foreign_key: 1
31
  is_nullable: 0
30
  is_nullable: 1
31
  size: 64
32
32
33
=head2 code
33
=head2 code
34
34
Lines 46-58 __PACKAGE__->table("permissions"); Link Here
46
=cut
46
=cut
47
47
48
__PACKAGE__->add_columns(
48
__PACKAGE__->add_columns(
49
  "module_bit",
49
  "parent",
50
  {
50
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 64 },
51
    data_type      => "integer",
52
    default_value  => 0,
53
    is_foreign_key => 1,
54
    is_nullable    => 0,
55
  },
56
  "code",
51
  "code",
57
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 64 },
52
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 64 },
58
  "description",
53
  "description",
Lines 63-93 __PACKAGE__->add_columns( Link Here
63
58
64
=over 4
59
=over 4
65
60
66
=item * L</module_bit>
67
68
=item * L</code>
61
=item * L</code>
69
62
70
=back
63
=back
71
64
72
=cut
65
=cut
73
66
74
__PACKAGE__->set_primary_key("module_bit", "code");
67
__PACKAGE__->set_primary_key("code");
75
68
76
=head1 RELATIONS
69
=head1 RELATIONS
77
70
78
=head2 module_bit
71
=head2 parent
79
72
80
Type: belongs_to
73
Type: belongs_to
81
74
82
Related object: L<Koha::Schema::Result::Userflag>
75
Related object: L<Koha::Schema::Result::Permission>
83
76
84
=cut
77
=cut
85
78
86
__PACKAGE__->belongs_to(
79
__PACKAGE__->belongs_to(
87
  "module_bit",
80
  "parent",
88
  "Koha::Schema::Result::Userflag",
81
  "Koha::Schema::Result::Permission",
89
  { bit => "module_bit" },
82
  { code => "parent" },
90
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
83
  {
84
    is_deferrable => 1,
85
    join_type     => "LEFT",
86
    on_delete     => "RESTRICT",
87
    on_update     => "RESTRICT",
88
  },
89
);
90
91
=head2 permissions
92
93
Type: has_many
94
95
Related object: L<Koha::Schema::Result::Permission>
96
97
=cut
98
99
__PACKAGE__->has_many(
100
  "permissions",
101
  "Koha::Schema::Result::Permission",
102
  { "foreign.parent" => "self.code" },
103
  { cascade_copy => 0, cascade_delete => 0 },
91
);
104
);
92
105
93
=head2 user_permissions
106
=head2 user_permissions
Lines 101-116 Related object: L<Koha::Schema::Result::UserPermission> Link Here
101
__PACKAGE__->has_many(
114
__PACKAGE__->has_many(
102
  "user_permissions",
115
  "user_permissions",
103
  "Koha::Schema::Result::UserPermission",
116
  "Koha::Schema::Result::UserPermission",
104
  {
117
  { "foreign.code" => "self.code" },
105
    "foreign.code"       => "self.code",
106
    "foreign.module_bit" => "self.module_bit",
107
  },
108
  { cascade_copy => 0, cascade_delete => 0 },
118
  { cascade_copy => 0, cascade_delete => 0 },
109
);
119
);
110
120
111
121
112
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
122
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-21 06:16:14
113
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ut3lzlxoPPoIIwmhJViV1Q
123
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hazAo1EYPHLRItwCzwP1ww
114
124
115
125
116
# You can replace this text with custom content, and it will be preserved on regeneration
126
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/SearchField.pm (-6 / +4 lines)
Lines 48-54 the human readable name of the field, for display Link Here
48
=head2 type
48
=head2 type
49
49
50
  data_type: 'enum'
50
  data_type: 'enum'
51
  extra: {list => ["","string","date","number","boolean","sum","isbn","stdno"]}
51
  extra: {list => ["","string","date","number","boolean","sum"]}
52
  is_nullable: 0
52
  is_nullable: 0
53
53
54
what type of data this holds, relevant when storing it in the search engine
54
what type of data this holds, relevant when storing it in the search engine
Lines 65-73 __PACKAGE__->add_columns( Link Here
65
  "type",
65
  "type",
66
  {
66
  {
67
    data_type => "enum",
67
    data_type => "enum",
68
    extra => {
68
    extra => { list => ["", "string", "date", "number", "boolean", "sum"] },
69
      list => ["", "string", "date", "number", "boolean", "sum", "isbn", "stdno"],
70
    },
71
    is_nullable => 0,
69
    is_nullable => 0,
72
  },
70
  },
73
);
71
);
Lines 116-123 __PACKAGE__->has_many( Link Here
116
);
114
);
117
115
118
116
119
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-09 12:50:58
117
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-21 06:16:14
120
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NDRiXH19vBOhrMoyJqVTGQ
118
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WIRbD1YaLBYK+neQqE31Pw
121
119
122
__PACKAGE__->many_to_many("search_marc_maps", "search_marc_to_fields", "search_marc_map");
120
__PACKAGE__->many_to_many("search_marc_maps", "search_marc_to_fields", "search_marc_map");
123
121
(-)a/Koha/Schema/Result/UserPermission.pm (-22 / +7 lines)
Lines 30-42 __PACKAGE__->table("user_permissions"); Link Here
30
  is_foreign_key: 1
30
  is_foreign_key: 1
31
  is_nullable: 0
31
  is_nullable: 0
32
32
33
=head2 module_bit
34
35
  data_type: 'integer'
36
  default_value: 0
37
  is_foreign_key: 1
38
  is_nullable: 0
39
40
=head2 code
33
=head2 code
41
34
42
  data_type: 'varchar'
35
  data_type: 'varchar'
Lines 54-66 __PACKAGE__->add_columns( Link Here
54
    is_foreign_key => 1,
47
    is_foreign_key => 1,
55
    is_nullable    => 0,
48
    is_nullable    => 0,
56
  },
49
  },
57
  "module_bit",
58
  {
59
    data_type      => "integer",
60
    default_value  => 0,
61
    is_foreign_key => 1,
62
    is_nullable    => 0,
63
  },
64
  "code",
50
  "code",
65
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 64 },
51
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 64 },
66
);
52
);
Lines 82-88 __PACKAGE__->belongs_to( Link Here
82
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
68
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
83
);
69
);
84
70
85
=head2 permission
71
=head2 code
86
72
87
Type: belongs_to
73
Type: belongs_to
88
74
Lines 91-110 Related object: L<Koha::Schema::Result::Permission> Link Here
91
=cut
77
=cut
92
78
93
__PACKAGE__->belongs_to(
79
__PACKAGE__->belongs_to(
94
  "permission",
80
  "code",
95
  "Koha::Schema::Result::Permission",
81
  "Koha::Schema::Result::Permission",
96
  { code => "code", module_bit => "module_bit" },
82
  { code => "code" },
97
  {
83
  {
98
    is_deferrable => 1,
84
    is_deferrable => 1,
99
    join_type     => "LEFT",
85
    join_type     => "LEFT",
100
    on_delete     => "CASCADE",
86
    on_delete     => "RESTRICT",
101
    on_update     => "CASCADE",
87
    on_update     => "RESTRICT",
102
  },
88
  },
103
);
89
);
104
90
105
91
106
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
92
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-21 06:16:14
107
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9dMAYxSmVQ1cVKxmnMiMkg
93
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/nqR/oeXcpZfNwY6Uk5ZrQ
108
94
109
95
110
# You can replace this text with custom content, and it will be preserved on regeneration
96
# You can replace this text with custom content, and it will be preserved on regeneration
111
- 

Return to bug 20813