diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-10-02 21:28:11 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-10-02 21:28:11 +0200 |
| commit | 11762273c68b24b332238aa89a73b9ed9ac1d249 (patch) | |
| tree | adff35fd1a30acb4b1985d0996c172a3cf743dc8 /sql/base | |
| parent | 1440586be841fef21af03a602d8e198a4ab4193a (diff) | |
Core/Players: Store player creation timestamp and type (normal/npe)
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index e1ea55f1a03..637cfc8c1b0 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1806,6 +1806,8 @@ CREATE TABLE `characters` ( `orientation` float NOT NULL DEFAULT '0', `taximask` text NOT NULL, `online` tinyint(3) unsigned NOT NULL DEFAULT '0', + `createTime` bigint(20) NOT NULL DEFAULT '0', + `createMode` tinyint(4) NOT NULL DEFAULT '0', `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0', `totaltime` int(10) unsigned NOT NULL DEFAULT '0', `leveltime` int(10) unsigned NOT NULL DEFAULT '0', @@ -3718,7 +3720,8 @@ INSERT INTO `updates` VALUES ('2021_05_11_00_characters.sql','C3F0337CE8363F970AB4FDB9D23BBB7C650A0B0E','ARCHIVED','2021-05-11 15:39:26',0), ('2021_07_04_00_characters.sql','E0E7AD664DDB553E96B457DD9ED8976665E94007','ARCHIVED','2021-07-04 22:23:24',0), ('2021_08_11_00_characters.sql','2137A52A45B045104B97D39626CE3C0214625B17','ARCHIVED','2021-08-11 21:48:57',0), -('2021_08_18_00_characters.sql','5BA1326EE8EC907CDE82E6E8BCB38EA2E661F10A','ARCHIVED','2021-08-18 15:14:17',0); +('2021_08_18_00_characters.sql','5BA1326EE8EC907CDE82E6E8BCB38EA2E661F10A','ARCHIVED','2021-08-18 15:14:17',0), +('2021_10_02_00_characters.sql','C6831D3ED03F6BD390A5E5E403FA402D6DC0E95D','RELEASED','2021-10-02 21:21:37',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |