1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
# Wallet schema for ACL history.
#
# Written by Jon Robertson <jonrober@stanford.edu>
# Copyright 2012, 2013, 2014
# The Board of Trustees of the Leland Stanford Junior University
#
# See LICENSE for licensing terms.
package Wallet::Schema::Result::AclHistory;
use strict;
use warnings;
use base 'DBIx::Class::Core';
__PACKAGE__->load_components("InflateColumn::DateTime");
=for stopwords
ACL
=head1 NAME
Wallet::Schema::Result::AclHistory - Wallet schema for ACL history
=head1 DESCRIPTION
=cut
__PACKAGE__->table("acl_history");
=head1 ACCESSORS
=head2 ah_id
data_type: 'integer'
is_auto_increment: 1
is_nullable: 0
=head2 ah_acl
data_type: 'integer'
is_nullable: 0
=head2 ah_name
data_type: 'varchar'
is_nullable: 1
size: 255
=head2 ah_action
data_type: 'varchar'
is_nullable: 0
size: 16
=head2 ah_scheme
data_type: 'varchar'
is_nullable: 1
size: 32
=head2 ah_identifier
data_type: 'varchar'
is_nullable: 1
size: 255
=head2 ah_by
data_type: 'varchar'
is_nullable: 0
size: 255
=head2 ah_from
data_type: 'varchar'
is_nullable: 0
size: 255
=head2 ah_on
data_type: 'datetime'
datetime_undef_if_invalid: 1
is_nullable: 0
=cut
__PACKAGE__->add_columns(
"ah_id",
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
"ah_acl",
{ data_type => "integer", is_nullable => 0 },
"ah_name",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"ah_action",
{ data_type => "varchar", is_nullable => 0, size => 16 },
"ah_scheme",
{ data_type => "varchar", is_nullable => 1, size => 32 },
"ah_identifier",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"ah_by",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"ah_from",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"ah_on",
{
data_type => "datetime",
datetime_undef_if_invalid => 1,
is_nullable => 0,
},
);
__PACKAGE__->set_primary_key("ah_id");
# Add an index on the ACL.
sub sqlt_deploy_hook {
my ($self, $sqlt_table) = @_;
my $name = 'acl_history_idx_ah_acl';
$sqlt_table->add_index (name => $name, fields => [qw(ah_acl)]);
$name = 'acl_history_idx_ah_name';
$sqlt_table->add_index (name => $name, fields => [qw(ah_name)]);
}
1;
|
