From d0b9510cf0d7a47e53aa341462a1175326dfc09d Mon Sep 17 00:00:00 2001 From: shennetsind Date: Wed, 19 Feb 2014 15:16:46 -0300 Subject: Follow up 9132878d911cfe720eaad94ad3d4a5dd11958f99 Fixed issue (8023) with sc rows (only those of tick = -1, aka permanent scs) duplicating due to lack of primary index. Special Thanks to Flash, Haru. Note that the upgrade script will clear the permanent statuses from your sc_data table (e.g. lex aeterna, carts) to ensure no issues are left. Signed-off-by: shennetsind --- sql-files/upgrades/2014-02-19--17-57.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql-files/upgrades/2014-02-19--17-57.sql (limited to 'sql-files/upgrades/2014-02-19--17-57.sql') 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..ebebe6665 --- /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); \ No newline at end of file -- cgit v1.2.3-60-g2f50