From 2ce755870486262f8d147565f8df70ec608a3974 Mon Sep 17 00:00:00 2001
From: Guilherme Menaldo <guilherme.menaldo@outlook.com>
Date: Sat, 5 Oct 2019 18:59:25 -0300
Subject: Updates status changes to also keep their total time - This allows
 clients to continue the "timer" display after you login again

---
 sql-files/main.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'sql-files/main.sql')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index 27839afa3..4627799aa 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -685,6 +685,7 @@ CREATE TABLE IF NOT EXISTS `sc_data` (
   `char_id` INT(11) UNSIGNED NOT NULL,
   `type` SMALLINT(11) UNSIGNED NOT NULL,
   `tick` INT(11) NOT NULL,
+  `total_tick` INT(11) NOT NULL,
   `val1` INT(11) NOT NULL DEFAULT '0',
   `val2` INT(11) NOT NULL DEFAULT '0',
   `val3` INT(11) NOT NULL DEFAULT '0',
@@ -931,6 +932,7 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1554760320); -- 2019-04-0
 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1556147483); -- 2019-04-25--02-12.sql
 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1557414445); -- 2019-05-09--18-07.sql
 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1565293394); -- 2019-08-08--19-43.sql
+INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1570309293); -- 2019-10-05--19-01.sql
 
 --
 -- Table structure for table `storage`
-- 
cgit v1.2.3-70-g09d2

