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

(-)a/installer/data/mysql/kohastructure.sql (+12 lines)
Lines 3313-3318 ALTER TABLE `patron_list_patrons` Link Here
3313
  ADD CONSTRAINT patron_list_patrons_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE;
3313
  ADD CONSTRAINT patron_list_patrons_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE;
3314
3314
3315
3315
3316
--
3317
-- Table structure for table 'po_sequence'
3318
--
3319
3320
DROP TABLE IF EXISTS po_sequence
3321
CREATE TABLE IF NOT EXISTS po_sequence (
3322
  seqid varchar(10) PRIMARY KEY,
3323
  seq_value bigint(20) unsigned NOT NULL,
3324
  PRIMARY KEY (seqid)
3325
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3326
3327
3316
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3328
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3317
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3329
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3318
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3330
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +2 lines)
Lines 419-423 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
419
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
419
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
420
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
420
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
421
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
421
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
422
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
422
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
423
('EnablePONumber',0,'Enable purchase order number',NULL,'YesNo')
423
;
424
;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7595-7600 if ( CheckVersion($DBversion) ) { Link Here
7595
    SetVersion($DBversion);
7595
    SetVersion($DBversion);
7596
}
7596
}
7597
7597
7598
$DBversion = "3.13.00.XXX";
7599
if ( CheckVersion($DBversion) ) {
7600
    $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('EnablePONumber',0,'Enable purchase order number',NULL,'YesNo')");
7601
    $dbh->do("CREATE TABLE IF NOT EXISTS po_sequence (seqid varchar(10) PRIMARY KEY, seq_value bigint(20) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
7602
    $dbh->do(q{INSERT INTO po_sequence values('POSEQ', 1)});
7603
    print "Upgrade to $DBversion done (Bug 4456 - Add systempreferences to enabling purchaseordernumber and create new table po_sequence)\n";
7604
    SetVersion ($DBversion);
7605
}
7598
7606
7599
=head1 FUNCTIONS
7607
=head1 FUNCTIONS
7600
7608
7601
- 

Return to bug 4456