diff options
author | Guilherme Menaldo <guilherme.menaldo@outlook.com> | 2019-10-05 18:59:25 -0300 |
---|---|---|
committer | Guilherme Menaldo <guilherme.menaldo@outlook.com> | 2019-10-06 21:54:53 -0300 |
commit | 2ce755870486262f8d147565f8df70ec608a3974 (patch) | |
tree | 77e2661d7d3141789722bf13ca3f4c5fd904531a /sql-files/main.sql | |
parent | 6766e7327eae2d37dcd719528fc1155938800fcc (diff) | |
download | hercules-2ce755870486262f8d147565f8df70ec608a3974.tar.gz hercules-2ce755870486262f8d147565f8df70ec608a3974.tar.bz2 hercules-2ce755870486262f8d147565f8df70ec608a3974.tar.xz hercules-2ce755870486262f8d147565f8df70ec608a3974.zip |
Updates status changes to also keep their total time
- This allows clients to continue the "timer" display after you login
again
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r-- | sql-files/main.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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` |