Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Player_DATA:
1. Missing PlayerMorality in case it's used in the future
Player_LOGIN:
1. PlayerUID can be NULL
2. CharacterID can be NULL
3. Datestamp can be NULL
Character_DATA:
1. PlayerUID 16 chars instead of 20 like in Player_DATA
3. InstanceID is a VARCHAR(4) what ?!
4. All the datetime typed fields are timestamp type for some reason, and some of them can be NULL when they shouldn't
5. Inventory and Backpack are varchar(2048) instead of longtext (IMPORTANT !!!)
6. Worldspace is TOO SHORT (at least 128) (IMPORTANT !!!)
7. Medical is TOO SHORT (at least 300) (IMPORTANT !!!)
8. CurrentState is TOO SHORT (at least 200) (IMPORTANT !!!)
9. Humanity has NULL as default and can be NULL
10. Missing keys on PlayerUID, Alive
+------------------------+-----------------------+
| MAX(LENGTH(Inventory)) | MAX(LENGTH(Backpack)) |
+------------------------+-----------------------+
| 1929 | 763 |
+------------------------+-----------------------+
I attempted to match the public hive layout. I will revert it back and replace the old data with the new. Sorry for causing all the problems. QQThanks for causing me problems Pwnzor
Well I can't just throw away the error, I need to fix it...Ignore them Pwnoz0r - thanks for the effort you put in =]