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
325 B
SQL
8 lines
325 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`
|
|
DROP INDEX `realm_realmGUID_name`,
|
|
ADD UNIQUE INDEX `realm_realmGUID` (`realm`, `realmGUID`);
|