Bukkit

While it is possible to convert McftProfiler tables to MCProfiler tables, it's a little complicated. Editing tables isn't, but adding UUIDs is, especially after namechanges are possible. Full backups of tables are highly recommended, as data may be lost otherwise.

Run this sql query, replacing _table_ with your McftProfiler profiles table, and replacing 'mcprofiler_' with whatever prefix you have. If you don't want to change the prefix, this id efault.

ALTER TABLE `_table_` 
RENAME TO  `MCProfiler_profiles` 
DROP COLUMN `reputation`,
DROP COLUMN `awards`,
CHANGE COLUMN `username` `lastKnownName` VARCHAR(16) NOT NULL COMMENT '' ,
ADD COLUMN `uuid` VARCHAR(36) NOT NULL COMMENT '' AFTER `profileid`,
ADD UNIQUE INDEX `uuid_UNIQUE` (`uuid` ASC)  COMMENT '';

Run this sql query, replacing _table_ with your McftProfiler notes table.

ALTER TABLE `_table_` 
CHANGE COLUMN `username` `lastKnownName` VARCHAR(16) NOT NULL COMMENT '' ,
CHANGE COLUMN `staff` `lastKnownStaffName` VARCHAR(32) NOT NULL COMMENT '' ,
ADD COLUMN `uuid` VARCHAR(36) NOT NULL COMMENT '' AFTER `noteid`, RENAME TO  `mcprofiler_notes` ;

Run this sql query, replacing _table_ with your McftProfiler votelog table.

DROP TABLE `_table_`;

Now this is the tough part of giving UUIDs playernames. There are many ways to do this, but this plugin does not support any converting by itself, you would have to do that manually. My personal suggestion is to have an SQL table that associates UUIDs with original usernames, then just make a query that fills in the data. There is a maintenance command to fix the notes manually, however. It is /MCProfiler maintenance fixnotes <uuid> <previous username of uuid>. So for example, you would run /MCProfiler maintenance fixnotes 6a5d97fb-1062-4636-b6ab-1f67d6a8b28a Shroom_Agent_27 to associate all of the notes with my old name to my UUID.

If you encounter any issues, or would like assistance filling in UUIDs, I am willing to provide support as long as you provide me with enough details, and are willing to work with me. Please create a new issue on my GitHub with the label "McftP to MCP".