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

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +7 lines)
Lines 427-432 __PACKAGE__->table("borrowers"); Link Here
427
  datetime_undef_if_invalid: 1
427
  datetime_undef_if_invalid: 1
428
  is_nullable: 1
428
  is_nullable: 1
429
429
430
=head2 overdrive_auth_token
431
432
  data_type: 'text'
433
  is_nullable: 1
434
430
=cut
435
=cut
431
436
432
__PACKAGE__->add_columns(
437
__PACKAGE__->add_columns(
Lines 1336-1343 Composing rels: L</aqorder_users> -> ordernumber Link Here
1336
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1341
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1337
1342
1338
1343
1339
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-31 10:39:35
1344
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-10 07:30:06
1340
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lc6GQ2E7d+tyzTk3v2sWjQ
1345
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:35WEsGd5LmkZ3bB486M1yA
1341
1346
1342
__PACKAGE__->belongs_to(
1347
__PACKAGE__->belongs_to(
1343
    "guarantor",
1348
    "guarantor",
(-)a/Koha/Schema/Result/Deletedborrower.pm (-2 / +9 lines)
Lines 424-429 __PACKAGE__->table("deletedborrowers"); Link Here
424
  datetime_undef_if_invalid: 1
424
  datetime_undef_if_invalid: 1
425
  is_nullable: 1
425
  is_nullable: 1
426
426
427
=head2 overdrive_auth_token
428
429
  data_type: 'text'
430
  is_nullable: 1
431
427
=cut
432
=cut
428
433
429
__PACKAGE__->add_columns(
434
__PACKAGE__->add_columns(
Lines 601-611 __PACKAGE__->add_columns( Link Here
601
    datetime_undef_if_invalid => 1,
606
    datetime_undef_if_invalid => 1,
602
    is_nullable => 1,
607
    is_nullable => 1,
603
  },
608
  },
609
  "overdrive_auth_token",
610
  { data_type => "text", is_nullable => 1 },
604
);
611
);
605
612
606
613
607
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-13 17:32:29
614
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-10 07:30:06
608
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pcdyzQacTbFDJ9R1k0E8mA
615
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tq4JDUSFKuU5K69TTVSkVg
609
616
610
617
611
# You can replace this text with custom code or comments, and it will be preserved on regeneration
618
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 630-635 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
630
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
630
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
631
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
631
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
632
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
632
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
633
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
633
  KEY borrowernumber (borrowernumber),
634
  KEY borrowernumber (borrowernumber),
634
  KEY `cardnumber` (`cardnumber`),
635
  KEY `cardnumber` (`cardnumber`),
635
  KEY `sms_provider_id` (`sms_provider_id`)
636
  KEY `sms_provider_id` (`sms_provider_id`)
Lines 1655-1661 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1655
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
1656
  `checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
1656
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
1657
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
1657
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
1658
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
1658
  overdrive_auth_token text default NULL, -- persist OverDrive auth token
1659
  `overdrive_auth_token` text default NULL, -- persist OverDrive auth token
1659
  UNIQUE KEY `cardnumber` (`cardnumber`),
1660
  UNIQUE KEY `cardnumber` (`cardnumber`),
1660
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1661
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1661
  KEY `categorycode` (`categorycode`),
1662
  KEY `categorycode` (`categorycode`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +4 lines)
Lines 13914-13919 if( CheckVersion( $DBversion ) ) { Link Here
13914
    });
13914
    });
13915
13915
13916
    $dbh->do(q{
13916
    $dbh->do(q{
13917
        ALTER TABLE deletedborrowers ADD overdrive_auth_token text default NULL AFTER lastseen;
13918
    });
13919
13920
    $dbh->do(q{
13917
        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
13921
        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
13918
        VALUES ('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo');
13922
        VALUES ('OverDriveCirculation','0','Enable client to see their OverDrive account','','YesNo');
13919
    });
13923
    });
13920
- 

Return to bug 16034