drop index date_value_idx on key_value;
drop index integer_value_idx on key_value;
drop index double_value_idx on key_value;
drop index string_value_idx on key_value;
drop index idx_004_uuid on key_value;
drop index idx_005_string_value on key_value;
drop index idx_006_integer_value on key_value;
drop index idx_007_double_value on key_value;
drop index idx_008_date_value on key_value;
alter table key_value drop foreign key FK_GPNXUSER;
drop index FK_GPNXUSER on key_value;
optimize table key_value;
ALTER TABLE key_value ADD unique INDEX idx_004_uuid(uuid), ADD INDEX idx_005_string_value (upkey,string_value), ADD INDEX idx_006_integer_value (upkey,integer_value), ADD INDEX idx_007_double_value (upkey,double_value), ADD INDEX idx_008_date_value (upkey,date_value), ADD CONSTRAINT FK_GPNXUSER FOREIGN KEY (user_id) REFERENCES gpnxuser(id);