diff options
| author | Haru <haru@dotalux.com> | 2018-02-06 20:18:07 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-02-06 20:18:07 +0100 |
| commit | 19c94017a31d86f7848085162ffb741770975128 (patch) | |
| tree | 33a5cf4b2a580a07f1b3868153123fe4dce49f2f /sql-files/main.sql | |
| parent | a928f009f5a7bad77eda090ec7af551c2f647d5b (diff) | |
| parent | 587dd19c0269b3c8089838a5442260a185b19ead (diff) | |
| download | hercules-19c94017a31d86f7848085162ffb741770975128.tar.gz hercules-19c94017a31d86f7848085162ffb741770975128.tar.bz2 hercules-19c94017a31d86f7848085162ffb741770975128.tar.xz hercules-19c94017a31d86f7848085162ffb741770975128.zip | |
Merge pull request #1718 from Murilo-BiO/clan_system
Implementation of Official Clan System
Diffstat (limited to 'sql-files/main.sql')
| -rw-r--r-- | sql-files/main.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index feda8a4cd..12607531b 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -183,6 +183,7 @@ CREATE TABLE IF NOT EXISTS `char` ( `manner` SMALLINT(6) NOT NULL DEFAULT '0', `party_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `clan_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `pet_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `homun_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `elemental_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', @@ -196,6 +197,7 @@ CREATE TABLE IF NOT EXISTS `char` ( `head_mid` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', `head_bottom` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', + `last_login` BIGINT(20) NULL DEFAULT '0', `last_map` VARCHAR(11) NOT NULL DEFAULT '', `last_x` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '53', `last_y` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '111', @@ -884,6 +886,8 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1477434595); -- 2016-10-2 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1488454834); -- 2017-03-02--11-40.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1488744559); -- 2017-03-05--08-09.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1489588190); -- 2017-03-15--14-29.sql +INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1496588640); -- 2017-06-04--15-04.sql +INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1496588700); -- 2017-06-04--15-05.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1509835214); -- 2017-11-04--10-39.sql -- -- Table structure for table `storage` |