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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 365-371 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
365
  `branchprinter` varchar(100) default NULL, -- unused in Koha
365
  `branchprinter` varchar(100) default NULL, -- unused in Koha
366
  `branchnotes` mediumtext, -- notes related to your library or branch
366
  `branchnotes` mediumtext, -- notes related to your library or branch
367
  opac_info text, -- HTML that displays in OPAC
367
  opac_info text, -- HTML that displays in OPAC
368
  UNIQUE KEY `branchcode` (`branchcode`)
368
  PRIMARY KEY (`branchcode`)
369
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
369
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
370
370
371
--
371
--
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 5239-5244 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5239
    SetVersion($DBversion);
5239
    SetVersion($DBversion);
5240
}
5240
}
5241
5241
5242
$DBversion = "XXX";
5243
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
5244
    $dbh->do("ALTER TABLE branches ADD PRIMARY KEY (branchcode);");
5245
    print "Upgrade to $DBversion done (redefine the field branchcode as PRIMARY KEY of branches)\n";
5246
    SetVersion ($DBversion);
5247
}
5248
5242
=head1 FUNCTIONS
5249
=head1 FUNCTIONS
5243
5250
5244
=head2 TableExists($table)
5251
=head2 TableExists($table)
5245
- 

Return to bug 7792