oregoncore/sql/create/create_mysql.sql

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

GRANT USAGE ON * . * TO 'oregon'@'localhost' IDENTIFIED BY 'oregon' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON `world` . * TO 'oregon'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `characters` . * TO 'oregon'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `realmd` . * TO 'oregon'@'localhost' WITH GRANT OPTION;
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 Create 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			`GRANT USAGE ON * . * TO 'oregon'@'localhost' IDENTIFIED BY 'oregon' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;`
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
			CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
			CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
			CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Fix sql creation queries 2010-08-11 13:22:28 +02:00			GRANT ALL PRIVILEGES ON `world` . * TO 'oregon'@'localhost' WITH GRANT OPTION;
			GRANT ALL PRIVILEGES ON `characters` . * TO 'oregon'@'localhost' WITH GRANT OPTION;
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			GRANT ALL PRIVILEGES ON `realmd` . * TO 'oregon'@'localhost' WITH GRANT OPTION;