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

(-)a/installer/data/mysql/kohastructure.sql (+12 lines)
Lines 3276-3281 ALTER TABLE `patron_list_patrons` Link Here
3276
  ADD CONSTRAINT patron_list_patrons_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE;
3276
  ADD CONSTRAINT patron_list_patrons_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE;
3277
3277
3278
3278
3279
--
3280
-- Table structure for table 'po_sequence'
3281
--
3282
3283
DROP TABLE IF EXISTS po_sequence
3284
CREATE TABLE IF NOT EXISTS po_sequence (
3285
  seqid varchar(10) PRIMARY KEY,
3286
  seq_value bigint(20) unsigned NOT NULL,
3287
  PRIMARY KEY (seqid)
3288
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3289
3290
3279
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3291
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3280
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3292
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3281
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3293
/*!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 / +9 lines)
Lines 7306-7311 if ( CheckVersion($DBversion) ) { Link Here
7306
    SetVersion($DBversion);
7306
    SetVersion($DBversion);
7307
}
7307
}
7308
7308
7309
$DBversion = "3.13.00.XXX";
7310
if ( CheckVersion($DBversion) ) {
7311
    $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('EnablePONumber',0,'Enable purchase order number',NULL,'YesNo')");
7312
    $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;");
7313
    $dbh->do(q{INSERT INTO po_sequence values('POSEQ', 1)});
7314
    print "Upgrade to $DBversion done (Bug 4456 - Add systempreferences to enabling purchaseordernumber and create new table po_sequence)\n";
7315
    SetVersion ($DBversion);
7316
}
7317
7309
=head1 FUNCTIONS
7318
=head1 FUNCTIONS
7310
7319
7311
=head2 TableExists($table)
7320
=head2 TableExists($table)
7312
- 

Return to bug 4456