Field Name

```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);