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

(-)a/installer/data/mysql/atomicupdate/bug_11622.sql (+7 lines)
Line 0 Link Here
1
INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES
2
( 'EnablePayPalOpacPayments',  '0', NULL ,  'Enables the ability to pay fees and fines from  the OPAC via PayPal',  'YesNo' ),
3
( 'PayPalChargeDescription',  'Koha fee payment', NULL ,  'This preference defines what the user will see the charge listed as in PayPal',  'Free' ),
4
( 'PayPalPwd',  '', NULL ,  'Your PayPal API password',  'Free' ),
5
( 'PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo' ),
6
( 'PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free' ),
7
( 'PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free' );
(-)a/installer/data/mysql/sysprefs.sql (+6 lines)
Lines 338-343 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
338
('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'),
338
('PatronSelfRegistrationExpireTemporaryAccountsDelay','0',NULL,'If PatronSelfRegistrationDefaultCategory is enabled, this system preference controls how long a patron can have a temporary status before the account is deleted automatically. It is an integer value representing a number of days to wait before deleting a temporary patron account. Setting it to 0 disables the deleting of temporary accounts.','Integer'),
339
('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate his or her account.','YesNo'),
339
('PatronSelfRegistrationVerifyByEmail','0',NULL,'If enabled, any patron attempting to register themselves via the OPAC will be required to verify themselves via email to activate his or her account.','YesNo'),
340
('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
340
('PatronsPerPage','20','20','Number of Patrons Per Page displayed by default','Integer'),
341
('EnablePayPalOpacPayments',  '0', NULL ,  'Enables the ability to pay fees and fines from  the OPAC via PayPal',  'YesNo' ),
342
('PayPalChargeDescription',  'Koha fee payment', NULL ,  'This preference defines what the user will see the charge listed as in PayPal',  'Free'),
343
('PayPalPwd',  '', NULL ,  'Your PayPal API password',  'Free'),
344
('PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo'),
345
('PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free'),
346
('PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free'),
341
('Persona','0','','Use Mozilla Persona for login','YesNo'),
347
('Persona','0','','Use Mozilla Persona for login','YesNo'),
342
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
348
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
343
('previousIssuesDefaultSortOrder','asc','asc|desc','Specify the sort order of Previous Issues on the circulation page','Choice'),
349
('previousIssuesDefaultSortOrder','asc','asc|desc','Specify the sort order of Previous Issues on the circulation page','Choice'),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +17 lines)
Lines 10623-10628 foreach my $file ( sort readdir $dirh ) { Link Here
10623
    }
10623
    }
10624
}
10624
}
10625
10625
10626
$DBversion = "3.15.00.XXX";
10627
if ( CheckVersion($DBversion) ) {
10628
    $dbh->do(q{
10629
        INSERT INTO  systempreferences (variable, value, options, explanation, type )
10630
        VALUES 
10631
        ( 'EnablePayPalOpacPayments',  '0', NULL ,  'Enables the ability to pay fees and fines from  the OPAC via PayPal',  'YesNo' ),
10632
        ( 'PayPalChargeDescription',  'Koha fee payment', NULL ,  'This preference defines what the user will see the charge listed as in PayPal',  'Free' ),
10633
        ( 'PayPalPwd',  '', NULL ,  'Your PayPal API password',  'Free' ),
10634
        ( 'PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo' ),
10635
        ( 'PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free' ),
10636
        ( 'PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free' )
10637
    });
10638
10639
    print "Upgrade to $DBversion done (Bug 11622 - Add ability to pay fees and fines from OPAC via PayPal)\n";
10640
    SetVersion($DBversion);
10641
}
10642
10626
=head1 FUNCTIONS
10643
=head1 FUNCTIONS
10627
10644
10628
=head2 TableExists($table)
10645
=head2 TableExists($table)
10629
- 

Return to bug 11622