Database Installation Order: ====================== Run the following SQL files in order in your database to successfully set up this section of the OregonCore project. 1. sql/create/create_mysql.sql 2. sql/base/world.sql 3. sql/base/characters.sql 4. sql/base/realmd.sql 5. [OregonDatabase.zip](https://github.com/OregonCore/OregonCore/releases) (should be extracted first) Contributing SQL: ====================== In order for us to keep track of SQL fixes we prefix our SQL files with a date format YYYY_MM_DD followed by the table the update is most likely to affect. In some cases, where an update fixes a quest or zone, it is okay to put that instead. - **A query must always end in a semi-colon( ; )** - **Supply names where applicable** - **DELETE before INSERT & Use exact fields** - **If you're referencing a value more than 3 times, use a variable** - **Comments and Author references must be provided where applicable** - If the last line of the file is a comment - add a new line after it (because when concatenating files the first statement after your file will not be execued) Wrong: INSERT INTO spell_group VALUES (1, 1239) Correct: -- Add spell 1239 (Example Spell) to spell group 1 DELETE FROM `spell_group` WHERE `id` = 1 AND `spell_id` = 1239; INSERT INTO spell_group (`id`,`spell_id`) VALUES (1, 1239); -- (Example Spell)