647be4a946
* move sql files into its own folder. * move outdated updates out of the update folder, sorted by github tags * split up the db dump so my editor doesn't try to hang itself if i dare to touch that file
8 lines
327 B
SQL
8 lines
327 B
SQL
-- clear synced chars to prevent conflicts
|
|
DELETE FROM `aowow_profiler_profiles` WHERE `realmGUID` IS NOT NULL;
|
|
-- clear queue
|
|
DELETE FROM `aowow_profiler_sync`;
|
|
-- update unique index
|
|
ALTER TABLE `aowow_profiler_profiles`
|
|
ADD COLUMN `renameItr` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `name`,
|
|
ADD INDEX `name` (`name`);
|