Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

Database: (partly) duplicate Indexes

I installed osticket today and found some (partly) duplicate Indexes in Database:

--  ########################################################################
--  osticket.ost_filter_rule                                               
--  ########################################################################

--  filter_id is a left-prefix of filter
--  Key definitions:
--    KEY `filter_id` (`filter_id`)
--    UNIQUE KEY `filter` (`filter_id`,`what`,`how`,`val`),
--  Column types:
--        `filter_id` int(10) unsigned not null default '0'
--        `what` varchar(32) not null
--        `how` enum('equal','not_equal','contains','dn_contain','starts','ends','match','not_match') not null
--        `val` varchar(255) not null
--  To remove this duplicate index, execute:
ALTER TABLE `osticket`.`ost_filter_rule` DROP INDEX `filter_id`;

--  ########################################################################
--  osticket.ost_staff                                                     
--  ########################################################################

--  Key group_id ends with a prefix of the clustered index
--  Key definitions:
--    KEY `group_id` (`group_id`,`staff_id`)
--    PRIMARY KEY (`staff_id`),
--  Column types:
--        `group_id` int(10) unsigned not null default '0'
--        `staff_id` int(11) unsigned not null auto_increment
--  To shorten this duplicate clustered index, execute:
ALTER TABLE `osticket`.`ost_staff` DROP INDEX `group_id`, ADD INDEX `group_id` (`group_id`);

--  ########################################################################
--  osticket.ost_ticket                                                    
--  ########################################################################

--  staff_id is a duplicate of team_id
--  Key definitions:
--    KEY `staff_id` (`staff_id`),
--    KEY `team_id` (`staff_id`),
--  Column types:
--        `staff_id` int(10) unsigned not null default '0'
--  To remove this duplicate index, execute:
ALTER TABLE `osticket`.`ost_ticket` DROP INDEX `staff_id`;


Regards, Florian
Sign In or Register to comment.