oregoncore/sql/create/drop_mysql.sql

-- --------------------------------------------- --
-- Oregon Script to Remove MySQL User and Tables --
-- --------------------------------------------- --

REVOKE ALL PRIVILEGES ON * . * FROM 'oregon'@'localhost';

REVOKE ALL PRIVILEGES ON `world` . * FROM 'oregon'@'localhost';
REVOKE GRANT OPTION ON `world` . * FROM 'oregon'@'localhost';

REVOKE ALL PRIVILEGES ON `characters` . * FROM 'oregon'@'localhost';
REVOKE GRANT OPTION ON `characters` . * FROM 'oregon'@'localhost';

REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'oregon'@'localhost';
REVOKE GRANT OPTION ON `realmd` . * FROM 'oregon'@'localhost';

DROP USER 'oregon'@'localhost';

DROP DATABASE IF EXISTS `world` ;
DROP DATABASE IF EXISTS `characters` ;
DROP DATABASE IF EXISTS `realmd` ;
Fix SQL Comment formating 2012-05-29 09:55:41 +02:00			`-- --------------------------------------------- --`
Oregon Project Structure Update for SQL Part Merge old Database Repos into the Main Core Repo Traceback missing changes douring the last OregonDatabase Updates and Provide Correct Update files for older Revs. Split sql/updates folder to 3 Subfolders (characters, realmd, world) to make it more easy use patch scripts cleanup and rebase the base SQL Files for the actual rev 1600 *new readme file for sql subfolder 2012-03-13 18:56:30 +01:00			`-- Oregon Script to Remove MySQL User and Tables --`
Fix SQL Comment formating 2012-05-29 09:55:41 +02:00			`-- --------------------------------------------- --`
Oregon Project Structure Update for SQL Part Merge old Database Repos into the Main Core Repo Traceback missing changes douring the last OregonDatabase Updates and Provide Correct Update files for older Revs. Split sql/updates folder to 3 Subfolders (characters, realmd, world) to make it more easy use patch scripts cleanup and rebase the base SQL Files for the actual rev 1600 *new readme file for sql subfolder 2012-03-13 18:56:30 +01:00
Fix sql creation queries 2010-08-11 13:22:28 +02:00			`REVOKE ALL PRIVILEGES ON * . * FROM 'oregon'@'localhost';`
Initial commit OregonCore based on rev 1828 of TrinityCore1, thx to the trinitycore team and the MaNGOS team as without them this project would never been possible 2009-12-30 18:04:27 +01:00
Fix sql creation queries 2010-08-11 13:22:28 +02:00			REVOKE ALL PRIVILEGES ON `world` . * FROM 'oregon'@'localhost';
			REVOKE GRANT OPTION ON `world` . * FROM 'oregon'@'localhost';
Initial commit OregonCore based on rev 1828 of TrinityCore1, thx to the trinitycore team and the MaNGOS team as without them this project would never been possible 2009-12-30 18:04:27 +01:00
Fix sql creation queries 2010-08-11 13:22:28 +02:00			REVOKE ALL PRIVILEGES ON `characters` . * FROM 'oregon'@'localhost';
			REVOKE GRANT OPTION ON `characters` . * FROM 'oregon'@'localhost';
Initial commit OregonCore based on rev 1828 of TrinityCore1, thx to the trinitycore team and the MaNGOS team as without them this project would never been possible 2009-12-30 18:04:27 +01:00
Fix sql creation queries 2010-08-11 13:22:28 +02:00			REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'oregon'@'localhost';
			REVOKE GRANT OPTION ON `realmd` . * FROM 'oregon'@'localhost';
Initial commit OregonCore based on rev 1828 of TrinityCore1, thx to the trinitycore team and the MaNGOS team as without them this project would never been possible 2009-12-30 18:04:27 +01:00
Fix sql creation queries 2010-08-11 13:22:28 +02:00			`DROP USER 'oregon'@'localhost';`
Initial commit OregonCore based on rev 1828 of TrinityCore1, thx to the trinitycore team and the MaNGOS team as without them this project would never been possible 2009-12-30 18:04:27 +01:00
			DROP DATABASE IF EXISTS `world` ;
			DROP DATABASE IF EXISTS `characters` ;
Oregon Project Structure Update for SQL Part Merge old Database Repos into the Main Core Repo Traceback missing changes douring the last OregonDatabase Updates and Provide Correct Update files for older Revs. Split sql/updates folder to 3 Subfolders (characters, realmd, world) to make it more easy use patch scripts cleanup and rebase the base SQL Files for the actual rev 1600 *new readme file for sql subfolder 2012-03-13 18:56:30 +01:00			DROP DATABASE IF EXISTS `realmd` ;