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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1766-1771 DROP TABLE IF EXISTS sessions; Link Here
1766
CREATE TABLE sessions (
1766
CREATE TABLE sessions (
1767
  `id` varchar(32) NOT NULL,
1767
  `id` varchar(32) NOT NULL,
1768
  `a_session` text NOT NULL,
1768
  `a_session` text NOT NULL,
1769
  PRIMARY KEY (`id`),
1769
  UNIQUE KEY id (id)
1770
  UNIQUE KEY id (id)
1770
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1771
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1771
1772
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 4994-4999 if ( C4::Context->preference("Version") lt TransformToNum($DBversion) ) { Link Here
4994
    SetVersion($DBversion);
4994
    SetVersion($DBversion);
4995
}
4995
}
4996
4996
4997
$DBversion = "XXX";
4998
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4999
    $dbh->do("ALTER TABLE sessions ADD PRIMARY KEY (id);");
5000
    print "Upgrade to $DBversion done (redefine the field id as PRIMARY KEY of sessions)\n";
5001
    SetVersion ($DBversion);
5002
}
5003
4997
=head1 FUNCTIONS
5004
=head1 FUNCTIONS
4998
5005
4999
=head2 DropAllForeignKeys($table)
5006
=head2 DropAllForeignKeys($table)
5000
- 

Return to bug 7794