Attachment #23222 for bug #3445

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

Lines 2735-2741 CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +6 lines)
2735	`object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc)	2735	`object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
2736	`info` text, -- information about the action (usually includes SQL statement)	2736	`info` text, -- information about the action (usually includes SQL statement)
2737	PRIMARY KEY (`action_id`),	2737	PRIMARY KEY (`action_id`),
2738	KEY (`timestamp`,`user`)	2738	KEY `timestamp_idx` (`timestamp`),
		2739	KEY `user_idx` (`user`),
		2740	KEY `module_idx` (`module`(255)),
		2741	KEY `action_idx` (`action`(255)),
		2742	KEY `object_idx` (`object`),
		2743	KEY `info_idx` (`info`(255))
2739	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	2744	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2740		2745
2741	--	2746	--




    SetVersion($DBversion);
}

$DBversion = "3.15.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        ALTER TABLE `action_logs`
            DROP KEY timestamp,
            ADD KEY `timestamp_idx` (`timestamp`),
            ADD KEY `user_idx` (`user`),
            ADD KEY `module_idx` (`module`(255)),
            ADD KEY `action_idx` (`action`(255)),
            ADD KEY `object_idx` (`object`),
            ADD KEY `info_idx` (`info`(255))
    });
    print "Upgrade to $DBversion done (Bug 3445 - action_logs table needs some thought)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 3445

Lines 7778-7783 if(CheckVersion($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +16 lines)
7778	SetVersion($DBversion);	7778	SetVersion($DBversion);
7779	}	7779	}
7780		7780
		7781	$DBversion = "3.15.00.XXX";
		7782	if(CheckVersion($DBversion)) {
		7783	$dbh->do(q{
		7784	ALTER TABLE `action_logs`
		7785	DROP KEY timestamp,
		7786	ADD KEY `timestamp_idx` (`timestamp`),
		7787	ADD KEY `user_idx` (`user`),
		7788	ADD KEY `module_idx` (`module`(255)),
		7789	ADD KEY `action_idx` (`action`(255)),
		7790	ADD KEY `object_idx` (`object`),
		7791	ADD KEY `info_idx` (`info`(255))
		7792	});
		7793	print "Upgrade to $DBversion done (Bug 3445 - action_logs table needs some thought)\n";
		7794	SetVersion($DBversion);
		7795	}
		7796
7781	=head1 FUNCTIONS	7797	=head1 FUNCTIONS
7782		7798
7783	=head2 TableExists($table)	7799	=head2 TableExists($table)
7784	-