From d0b9510cf0d7a47e53aa341462a1175326dfc09d Mon Sep 17 00:00:00 2001
From: shennetsind <ind@henn.et>
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 <ind@henn.et>
---
 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

