is_foreign_key: 1
is_nullable: 0
+=head2 daterequested
+
+ data_type: 'timestamp'
+ datetime_undef_if_invalid: 1
+ default_value: current_timestamp
+ is_nullable: 0
+
=head2 datesent
data_type: 'datetime'
is_foreign_key => 1,
is_nullable => 0,
},
+ "daterequested",
+ {
+ data_type => "timestamp",
+ datetime_undef_if_invalid => 1,
+ default_value => \"current_timestamp",
+ is_nullable => 0,
+ },
"datesent",
{
data_type => "datetime",
);
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-20 11:24:33
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:50FpCj6vWH5O8MThCy/1hA
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-20 12:30:59
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G5GZTxF8X/mcIKXmuGVWIQ
sub koha_object_class {
'Koha::Item::Transfer';
--- /dev/null
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+
+ unless ( column_exists('branchtransfers', 'daterequested') ) {
+ $dbh->do(
+ qq{
+ ALTER TABLE branchtransfers
+ ADD
+ `daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP
+ AFTER
+ `itemnumber`
+ }
+ );
+ }
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 23092 - Add 'daterequested' field to transfers table)\n";
+}
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
`branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key
`itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
+ `daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date the transfer was requested
`datesent` datetime default NULL, -- the date the transfer was initialized
`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
`datearrived` datetime default NULL, -- the date the transfer arrived at its destination