ATER TABLE `changeitem` ADD
	CONSTRAINT `PK_changeitem` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `fieldlayoutscheme` ADD
	CONSTRAINT `PK_fieldlayoutscheme` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `genericconfiguration` ADD
	CONSTRAINT `PK_genericconfiguration` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `notificationscheme` ADD
	CONSTRAINT `PK_notificationscheme` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `permissionscheme` ADD
	CONSTRAINT `PK_permissionscheme` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `propertystring` ADD
	CONSTRAINT `PK_propertystring` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `qrtz_simple_triggers` ADD
	CONSTRAINT `PK_qrtz_simple_triggers` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `searchrequest` ADD
	CONSTRAINT `PK_searchrequest` PRIMARY KEY
	(
		`ID`
	)
;
ALTER TABLE `workflowscheme` ADD
	CONSTRAINT `PK_workflowscheme` PRIMARY KEY
	(
		`ID`
	)
;


***********************************
Script line: 13	BLOB/TEXT column 'UPGRADECLASS' used in key specification without a key length"


ALTER TABLE `upgradehistory` ADD
	CONSTRAINT `PK_upgradehistory` PRIMARY KEY
	(
		`UPGRADECLASS`
	)
;

Script line: 11	BLOB/TEXT column 'FIELD' used in key specification without a key length

 CREATE  INDEX `chgitem_field` ON `changeitem`(`FIELD`)

Script line: 1	BLOB/TEXT column 'customfield' used in key specification without a key length

 CREATE  INDEX `confcontext` ON `configurationcontext`(`PROJECTCATEGORY`, `PROJECT`, `customfield`)
;

Script line: 7	BLOB/TEXT column 'ISSUETYPE' used in key specification without a key length
 CREATE  INDEX `fcs_issuetype` ON `fieldconfigschemeissuetype`(`ISSUETYPE`) 
;

Script line: 5	BLOB/TEXT column 'ISSUETYPE' used in key specification without a key length
 CREATE  INDEX `fl_scheme_assoc` ON `fieldlayoutschemeassociation`(`PROJECT`, `ISSUETYPE`)
;

Script line: 7	BLOB/TEXT column 'FIELDIDENTIFIER' used in key specification without a key length
 CREATE  INDEX `fieldscreen_field` ON `fieldscreenlayoutitem`(`FIELDIDENTIFIER`)
;

Script line: 13	BLOB/TEXT column 'groupname' used in key specification without a key length
 CREATE  INDEX `osgroup_name` ON `groupbase`(`groupname`)

Script line: 8	BLOB/TEXT column 'LINKNAME' used in key specification without a key length
 CREATE  INDEX `linktypename` ON `issuelinktype`(`LINKNAME`)
;

Script line: 5	BLOB/TEXT column 'actiontype' used in key specification without a key length
 CREATE  INDEX `action_issue` ON `jiraaction`(`issueid`, `actiontype`)

Script line: 1	BLOB/TEXT column 'pkey' used in key specification without a key length
 CREATE  INDEX `issue_key` ON `jiraissue`(`pkey`)
;

Script line: 1	BLOB/TEXT column 'issuestatus' used in key specification without a key length
 CREATE  INDEX `issue_proj_status` ON `jiraissue`(`PROJECT`, `issuestatus`)
;

Script line: 1	BLOB/TEXT column 'ASSIGNEE' used in key specification without a key length
 CREATE  INDEX `issue_assignee` ON `jiraissue`(`ASSIGNEE`)
;

Script line: 1	BLOB/TEXT column 'USER_NAME' used in key specification without a key length
 CREATE  INDEX `mshipbase_user` ON `membershipbase`(`USER_NAME`)
;

Script line: 1	BLOB/TEXT column 'GROUP_NAME' used in key specification without a key length
 CREATE  INDEX `mshipbase_group` ON `membershipbase`(`GROUP_NAME`)
;

Script line: 21	BLOB/TEXT column 'authorname' used in key specification without a key length
 CREATE  INDEX `sr_author` ON `searchrequest`(`authorname`)
;

Script line: 1	BLOB/TEXT column 'groupname' used in key specification without a key length
 CREATE  INDEX `sr_group` ON `searchrequest`(`groupname`)

Script line: 5	BLOB/TEXT column 'username' used in key specification without a key length
 CREATE  INDEX `osuser_name` ON `userbase`(`username`)
;
;

;
;