From 7c439c72550223c6fe6c0dfc85d18baa881da5c3 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 30 Oct 2007 19:16:48 -0500 Subject: [PATCH] correct to prior action_logs patch Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- updater/updatedatabase | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/updater/updatedatabase b/updater/updatedatabase index 599e0c6874..98f7b5153a 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -510,8 +510,8 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE action_logs ADD KEY timestamp (timestamp,user)"); $dbh->do("ALTER TABLE action_logs ADD action_id INT(11) NOT NULL FIRST"); $dbh->do("UPDATE action_logs SET action_id = if (@a, @a:=@a+1, @a:=1)"); - $dbh->do("ALTER TABLE action_logs MODIFY action_id AUTO_INCREMENT PRIMARY KEY"); - print "Upgrade to $DBversion done (added column to action_logs)\n"; + $dbh->do("ALTER TABLE action_logs MODIFY action_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY"); + print "Upgrade to $DBversion done (added column to action_logs)\n"; SetVersion ($DBversion); } -- 2.39.5