diff options
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` |