diff options
| author | Andrei Karas <akaras@inbox.ru> | 2014-11-04 20:23:22 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2014-11-04 22:56:41 +0300 |
| commit | d6b5551bff867250edcdc36455ef32844ee2b935 (patch) | |
| tree | 16acaf1c9a81b58ceb21bc4524a087c14f23735f /sql-files/upgrades/2014-02-19--17-57.sql | |
| parent | 905dada713af49bb610177c4842685628a1c0a97 (diff) | |
| download | serverdata-d6b5551bff867250edcdc36455ef32844ee2b935.tar.gz serverdata-d6b5551bff867250edcdc36455ef32844ee2b935.tar.bz2 serverdata-d6b5551bff867250edcdc36455ef32844ee2b935.tar.xz serverdata-d6b5551bff867250edcdc36455ef32844ee2b935.zip | |
convert server data for using with hercules.
Diffstat (limited to 'sql-files/upgrades/2014-02-19--17-57.sql')
| -rw-r--r-- | sql-files/upgrades/2014-02-19--17-57.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql-files/upgrades/2014-02-19--17-57.sql b/sql-files/upgrades/2014-02-19--17-57.sql new file mode 100644 index 000000000..63abc335f --- /dev/null +++ b/sql-files/upgrades/2014-02-19--17-57.sql @@ -0,0 +1,4 @@ +#1392832626 +DELETE FROM `sc_data` WHERE `tick` = '-1'; +ALTER TABLE `sc_data` ADD PRIMARY KEY (`account_id`,`char_id`,`type`); +INSERT INTO `sql_updates` (`timestamp`) VALUES (1392832626); |