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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1780-1786 DROP TABLE IF EXISTS sessions; Link Here
1780
CREATE TABLE sessions (
1780
CREATE TABLE sessions (
1781
  `id` varchar(32) NOT NULL,
1781
  `id` varchar(32) NOT NULL,
1782
  `a_session` text NOT NULL,
1782
  `a_session` text NOT NULL,
1783
  UNIQUE KEY id (id)
1783
  PRIMARY KEY (`id`)
1784
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1784
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1785
1785
1786
--
1786
--
(-)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 sessions ADD PRIMARY KEY (id);");
5245
    print "Upgrade to $DBversion done (redefine the field id as PRIMARY KEY of sessions)\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 7794