diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/CMakeLists.txt | 7 | ||||
| -rw-r--r-- | sql/characters.sql | 1 | ||||
| -rw-r--r-- | sql/tools/CMakeLists.txt | 4 | ||||
| -rw-r--r-- | sql/updates/871_world.sql | 31 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 40 |
5 files changed, 83 insertions, 0 deletions
diff --git a/sql/CMakeLists.txt b/sql/CMakeLists.txt new file mode 100644 index 00000000000..dfdbfd0cf20 --- /dev/null +++ b/sql/CMakeLists.txt @@ -0,0 +1,7 @@ +add_subdirectory(updates) +add_subdirectory(tools) + + +########### install files ############### + +install(FILES world.sql realmd.sql characters.sql create_mysql.sql world_scripts_full.sql world_scripts_structure.sql drop_mysql.sql DESTINATION share/trinity/sql) diff --git a/sql/characters.sql b/sql/characters.sql index 2e5eedcf6a7..fedb3c66ce2 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -614,6 +614,7 @@ CREATE TABLE `characters` ( `zone` int(11) unsigned NOT NULL default '0', `death_expire_time` bigint(20) unsigned NOT NULL default '0', `taxi_path` text, + `arena_pending_points` int (10) UNSIGNED NOT NULL default '0';, `latency` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guid`), KEY `idx_account` (`account`), diff --git a/sql/tools/CMakeLists.txt b/sql/tools/CMakeLists.txt new file mode 100644 index 00000000000..bcf0c7a8343 --- /dev/null +++ b/sql/tools/CMakeLists.txt @@ -0,0 +1,4 @@ + +########### install files ############### + +install(FILES characters_item_duplicates_remove.sql characters_pet_data_cleanup.sql README DESTINATION share/trinity/sql/tools) diff --git a/sql/updates/871_world.sql b/sql/updates/871_world.sql new file mode 100644 index 00000000000..54922de2a40 --- /dev/null +++ b/sql/updates/871_world.sql @@ -0,0 +1,31 @@ +DELETE FROM `trinity_string` WHERE `entry` BETWEEN '288' AND '295'; +DELETE FROM `trinity_string` WHERE `entry` BETWEEN '2000' AND '2029'; +INSERT INTO trinity_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +(2000, '|cff00ff00New ticket from|r|cffff00ff %s.|r |cff00ff00Ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2001, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00edited his/her ticket:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2002, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00abandoned ticket entry:|r|cffff00ff %d.|r', '', '', '', '', '', '', '', ''), +(2003, '|cff00ff00Closed by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''), +(2004, '|cff00ff00Deleted by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''), +(2005, 'Ticket not found.', '', '', '', '', '', '', '', ''), +(2006, 'Please close ticket before deleting it permanently.', '', '', '', '', '', '', '', ''), +(2007, 'Ticket %d is already assigned.', '', '', '', '', '', '', '', ''), +(2008, '%u Tickets succesfully reloaded from the database.', '', '', '', '', '', '', '', ''), +(2009, 'Showing list of open tickets.', '', '', '', '', '', '', '', ''), +(2010, 'Showing list of open tickets whose creator is online.', '', '', '', '', '', '', '', ''), +(2011, 'Showing list of closed tickets.', '', '', '', '', '', '', '', ''), +(2012, 'Invalid name specified. Name should be that of an online Gamemaster.', '', '', '', '', '', '', '', ''), +(2013, 'This ticket is already assigned to yourself. To unassign use .ticket unassign %d and then reassign.', '', '', '', '', '', '', '', ''), +(2014, 'Ticket %d is not assigned, you cannot unassign it.', '', '', '', '', '', '', '', ''), +(2015, 'You cannot unassign tickets from staffmembers with a higher security level than yourself.', '', '', '', '', '', '', '', ''), +(2016, 'Cannot close ticket %d, it is assigned to another GM.', '', '', '', '', '', '', '', ''), +(2017, '|cff00ff00Ticket|r:|cff00ccff %d.|r ', '', '', '', '', '', '', '', ''), +(2018, '|cff00ff00Created by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''), +(2019, '|cff00ff00Last change|r:|cff00ccff %s ago|r ', '', '', '', '', '', '', '', ''), +(2020, '|cff00ff00Assigned to|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''), +(2021, '|cff00ff00Unassigned by|r:|cff00ccff %s|r ', '', '', '', '', '', '', '', ''), +(2022, '\n|cff00ff00Message|r: \"%s\"|r ', '', '', '', '', '', '', '', ''), +(2023, '\n|cff00ff00Comment|r: \"%s\"|r ', '', '', '', '', '', '', '', ''), +(2024, '\n|cff00ccff%s|r |cff00ff00Added comment|r: \"%s\"|r ', '', '', '', '', '', '', '', ''); + +DELETE FROM `command` WHERE (`name` LIKE '%ticket closedlist%'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES ('.ticket closedlist','1','Displays a list of closed GM tickets.'); diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt new file mode 100644 index 00000000000..53490e0a15e --- /dev/null +++ b/sql/updates/CMakeLists.txt @@ -0,0 +1,40 @@ +install(FILES +11_characters.sql +45_characters.sql +54_world.sql +57_world_scripts.sql +66_world_scripts.sql +68_world.sql +70_world_scripts.sql +78_world.sql +79_characters.sql +79_world.sql +82_world_scripts.sql +83_realmd.sql +84_world.sql +86_world_scripts.sql +90_world.sql +102_world.sql +112_world_scripts.sql +116_world.sql +117_world_scripts.sql +120_world.sql +123_world_scripts.sql +125_world_scripts.sql +133_world_scripts.sql +140_world.sql +145_world_scripts.sql +146_world.sql +147_world.sql +152_world.sql +153_world.sql +171_world.sql +172_world_scripts.sql +175_world_scripts.sql +176_world.sql +182_world.sql +194_world_blacktemple.sql +195_world_serpent_shrine.sql + +#Yes, i sorted them manually, so please be as kind as to add incoming .sql updates in order. +DESTINATION share/trinity/sql/updates)
\ No newline at end of file |