diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-08-05 03:39:51 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-08-08 12:11:36 -0300 |
| commit | 20ca1cf66123c110cc14aa452a840e5f62cd74ff (patch) | |
| tree | 5ce43bf569d54e04b5d0fab3dc9ec0708d061529 /sql/schema.sql | |
| parent | 634554a0df8dfd35630f17b5fee44c54b7af73a5 (diff) | |
| download | querymanager-20ca1cf66123c110cc14aa452a840e5f62cd74ff.tar.gz querymanager-20ca1cf66123c110cc14aa452a840e5f62cd74ff.zip | |
store world hostname and resolve at runtime
Diffstat (limited to 'sql/schema.sql')
| -rw-r--r-- | sql/schema.sql | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index 90f59a8..18fabd9 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -5,10 +5,7 @@ CREATE TABLE IF NOT EXISTS Worlds ( Name TEXT NOT NULL COLLATE NOCASE, Type INTEGER NOT NULL, RebootTime INTEGER NOT NULL, - IPAddress INTEGER NOT NULL, - -- TODO(fusion): Have some hostname resolution cache and send the resolved - -- addresses instead of hardcoding them into the database. - --Host TEXT NOT NULL, + Host TEXT NOT NULL, Port INTEGER NOT NULL, MaxPlayers INTEGER NOT NULL, PremiumPlayerBuffer INTEGER NOT NULL, @@ -268,9 +265,9 @@ CREATE TABLE IF NOT EXISTS OnlineCharacters ( -- REMOVE(fusion): Testing Data. --============================================================================== -INSERT INTO Worlds (WorldID, Name, Type, RebootTime, IPAddress, Port, MaxPlayers, +INSERT INTO Worlds (WorldID, Name, Type, RebootTime, Host, Port, MaxPlayers, PremiumPlayerBuffer, MaxNewbies, PremiumNewbieBuffer) - VALUES (1, 'Zanera', 0, 5, 0x7F000001, 7172, 1000, 100, 300, 100); + VALUES (1, 'Zanera', 0, 5, 'localhost', 7172, 1000, 100, 300, 100); -- 111111/tibia INSERT INTO Accounts (AccountID, Email, Auth) |