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
124
125
126
127
128
129
130
131
132
133
134
135
|
# Wallet schema for object 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::ObjectHistory;
use strict;
use warnings;
use base 'DBIx::Class::Core';
__PACKAGE__->load_components("InflateColumn::DateTime");
=head1 NAME
Wallet::Schema::Result::ObjectHistory - Wallet schema for object history
=head1 DESCRIPTION
=cut
__PACKAGE__->table("object_history");
=head1 ACCESSORS
=head2 oh_id
data_type: 'integer'
is_auto_increment: 1
is_nullable: 0
=head2 oh_type
data_type: 'varchar'
is_nullable: 0
size: 16
=head2 oh_name
data_type: 'varchar'
is_nullable: 0
size: 255
=head2 oh_action
data_type: 'varchar'
is_nullable: 0
size: 16
=head2 oh_field
data_type: 'varchar'
is_nullable: 1
size: 16
=head2 oh_type_field
data_type: 'varchar'
is_nullable: 1
size: 255
=head2 oh_old
data_type: 'varchar'
is_nullable: 1
size: 255
=head2 oh_new
data_type: 'varchar'
is_nullable: 1
size: 255
=head2 oh_by
data_type: 'varchar'
is_nullable: 0
size: 255
=head2 oh_from
data_type: 'varchar'
is_nullable: 0
size: 255
=head2 oh_on
data_type: 'datetime'
datetime_undef_if_invalid: 1
is_nullable: 0
=cut
__PACKAGE__->add_columns(
"oh_id",
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
"oh_type",
{ data_type => "varchar", is_nullable => 0, size => 16 },
"oh_name",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"oh_action",
{ data_type => "varchar", is_nullable => 0, size => 16 },
"oh_field",
{ data_type => "varchar", is_nullable => 1, size => 16 },
"oh_type_field",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"oh_old",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"oh_new",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"oh_by",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"oh_from",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"oh_on",
{
data_type => "datetime",
datetime_undef_if_invalid => 1,
is_nullable => 0,
},
);
__PACKAGE__->set_primary_key("oh_id");
# Add an index on object type and object name.
sub sqlt_deploy_hook {
my ($self, $sqlt_table) = @_;
my $name = 'object_history_idx_oh_type_oh_name';
$sqlt_table->add_index (name => $name, fields => [qw(oh_type oh_name)]);
}
1;
|
