Old Wiki:Accounts
Accounts
Description of the Accounts table in the EVEmu database.
| Field Name | Field Type | Nullable | Key |
|---|---|---|---|
| 'accountID' | int(10) unsigned | NOT NULL | PRIMARY |
| 'accountName' | varchar(43) | NOT NULL | |
| 'password' | varchar(43) | NOT NULL | |
| 'hash' | tinyblob | NULL | |
| 'role' | bigint(20) unsigned | NOT NULL | |
| 'online' | tinyint(1) | NOT NULL | |
| 'banned' | tinyint(1) | NOT NULL | |
| 'logonCount' | int(10) unsigned | NOT NULL | |
| 'lastLogin' | timestamp | NULL |
Description of the fields
'accountID'
The account number, raises incrementally as more accounts are added. Several tables refer to this.
'accountName'
The login name for the account. Must be unique.
'password'
The password given to this account. This field should be blank after login if the password is put in manually.
'hash'
The password scrambled.
'role'
The account privileges and commands it has access to. For more information go here here.
'online'
Whether the account is connected to the server. 0 is offline, a value of 1 is online.
'banned'
Whether the account is banned to the server. 0 is not banned, a value of 1 is banned.
'logonCount'
The amount of times this account has connected to the server.
'lastLogin'
The last time the account logged in.
-- When starting your server you will need to create a new account.
INSERT INTO account (accountID, accountName, role, password, online, banned) VALUES(NULL, 'your_account_name', 5003499186008621056, 'your_password', 0, 0);