[jboss-user] [jBPM Users] - Duplicate KEYs/Indexes on JBPM tables

[jeckles933]

JBPM 3.2.6 SP 1
MYSQL 5.0.51a-log

Most of the tables have duplicate keys, this is just one example

CREATE TABLE `jbpm_token` (                                                                                   
              `ID_` BIGINT(20) NOT NULL AUTO_INCREMENT,                                                                   
              `VERSION_` INT(11) NOT NULL,                                                                                
              `NAME_` VARCHAR(255) DEFAULT NULL,                                                                          
              `START_` DATETIME DEFAULT NULL,                                                                             
              `END_` DATETIME DEFAULT NULL,                                                                               
              `NODEENTER_` DATETIME DEFAULT NULL,                                                                         
              `NEXTLOGINDEX_` INT(11) DEFAULT NULL,                                                                       
              `ISABLETOREACTIVATEPARENT_` BIT(1) DEFAULT NULL,                                                            
              `ISTERMINATIONIMPLICIT_` BIT(1) DEFAULT NULL,                                                               
              `ISSUSPENDED_` BIT(1) DEFAULT NULL,                                                                         
              `LOCK_` VARCHAR(255) DEFAULT NULL,                                                                          
              `NODE_` BIGINT(20) DEFAULT NULL,                                                                            
              `PROCESSINSTANCE_` BIGINT(20) DEFAULT NULL,                                                                 
              `PARENT_` BIGINT(20) DEFAULT NULL,                                                                          
              `SUBPROCESSINSTANCE_` BIGINT(20) DEFAULT NULL,                                                              
              PRIMARY KEY  (`ID_`),                                                                                       
              KEY `IDX_TOKEN_PARENT` (`PARENT_`),                                                                         
              KEY `IDX_TOKEN_PROCIN` (`PROCESSINSTANCE_`),                                                                
              KEY `IDX_TOKEN_NODE` (`NODE_`),                                                                             
              KEY `IDX_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`),                                                              
              KEY `FK_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`),                                                               
              KEY `FK_TOKEN_PROCINST` (`PROCESSINSTANCE_`),                                                               
              KEY `FK_TOKEN_NODE` (`NODE_`),                                                                              
              KEY `FK_TOKEN_PARENT` (`PARENT_`),                                                                          
              CONSTRAINT `FK_TOKEN_NODE` FOREIGN KEY (`NODE_`) REFERENCES `jbpm_node` (`ID_`),                            
              CONSTRAINT `FK_TOKEN_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm_token` (`ID_`),                       
              CONSTRAINT `FK_TOKEN_PROCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`),  
              CONSTRAINT `FK_TOKEN_SUBPI` FOREIGN KEY (`SUBPROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`)   
            ) ENGINE=INNODB DEFAULT CHARSET=latin1     

Note these Keys:

KEY `IDX_TOKEN_PARENT` (`PARENT_`),                  
KEY `FK_TOKEN_PARENT` (`PARENT_`),            

This is just one example, there are duplicate keys on almost all the tables.
This table was created using the script that came with 3.2.6 SP1.

Is there a reason for these duplicate keys??
Or is this a bug in the DB create script?


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4261117#4261117

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4261117