diff options
| author | Haru <haru@dotalux.com> | 2019-10-18 16:53:38 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-10-18 16:53:38 +0200 |
| commit | 9fb69836caaa3bc46ad1109c3aa9df8ee60cc6fe (patch) | |
| tree | 26c58b5cbadfe5731ef1902b50e1c095b8321a66 /sql-files/main.sql | |
| parent | 29b587ae936fc76828cb3982de8c43caaea5fe86 (diff) | |
| parent | 9e5994866305ef23628020d1605fac43305c2105 (diff) | |
| download | hercules-9fb69836caaa3bc46ad1109c3aa9df8ee60cc6fe.tar.gz hercules-9fb69836caaa3bc46ad1109c3aa9df8ee60cc6fe.tar.bz2 hercules-9fb69836caaa3bc46ad1109c3aa9df8ee60cc6fe.tar.xz hercules-9fb69836caaa3bc46ad1109c3aa9df8ee60cc6fe.zip | |
Merge pull request #2551 from guilherme-gm/201910-fix-sc-times
Fixes status changes effect timer when relogging
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` |