[DiscordArchive] In the case of the `RealmID` what do we do?
[DiscordArchive] In the case of the `RealmID` what do we do?
Original source
```
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------------|--------------|------------|-----|------|-------------------|----------------|------------|
| [id][1] | int(10) | unsigned | PRI | NO | | auto_increment | Identifier |
| [username][2] | varchar(32) | | UNI | NO | | | |
| [sha_pass_hash][3] | varchar(40) | | | NO | | | |
| [sessionkey][4] | varchar(80) | | | NO | | | |
| [v][5] | varchar(64) | | | NO | | | |
| [s][6] | varchar(64) | | | NO | | | |
| [token_key][7] | varchar(100) | | | NO | | | |
| [email][8] | varchar(255) | | | NO | | | |
| [reg_mail][9] | varchar(255) | | | NO | | | |
| [joindate][10] | timestamp | | | NO | CURRENT_TIMESTAMP | | |
| [last_ip][11] | varchar(15) | | | NO | 127.0.0.1 | | |
| [last_attempt_ip][12] | varchar(15) | | | NO | 127.0.0.1 | | |
| [failed_logins][13] | int(10) | unsigned | | NO | 0 | | |
```
rektbyfaith
01-10-2021, 08:04 PM #21Archived author: stevej • Posted: 2021-01-10T20:04:50.659000+00:00
Original source
```
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------------|--------------|------------|-----|------|-------------------|----------------|------------|
| [id][1] | int(10) | unsigned | PRI | NO | | auto_increment | Identifier |
| [username][2] | varchar(32) | | UNI | NO | | | |
| [sha_pass_hash][3] | varchar(40) | | | NO | | | |
| [sessionkey][4] | varchar(80) | | | NO | | | |
| [v][5] | varchar(64) | | | NO | | | |
| [s][6] | varchar(64) | | | NO | | | |
| [token_key][7] | varchar(100) | | | NO | | | |
| [email][8] | varchar(255) | | | NO | | | |
| [reg_mail][9] | varchar(255) | | | NO | | | |
| [joindate][10] | timestamp | | | NO | CURRENT_TIMESTAMP | | |
| [last_ip][11] | varchar(15) | | | NO | 127.0.0.1 | | |
| [last_attempt_ip][12] | varchar(15) | | | NO | 127.0.0.1 | | |
| [failed_logins][13] | int(10) | unsigned | | NO | 0 | | |
```
Original source
```
| [locked][14] | tinyint(3) | unsigned | | NO | 0 | | |
| [lock_country][15] | varchar(2) | | | NO | 0 | | |
| [last_login][16] | timestamp | | | YES | NULL | | |
| [online][17] | int(10) | unsigned | | NO | 0 | | |
| [expansion][18] | tinyint(3) | unsigned | | NO | 2 | | |
| [mutetime][19] | bigint(20) | | | NO | 0 | | |
| [mutereason][20] | varchar(255) | | | NO | | | |
| [muteby][21] | varchar(50) | | | NO | | | |
| [locale][22] | tinyint(3) | unsigned | | NO | 0 | | |
| [os][23] | varchar(3) | | | NO | | | |
| [recruiter][24] | int(10) | unsigned | | NO | 0 | | |
| [totaltime][25] | int(10) | unsigned | | NO | 0 | | |
```
rektbyfaith
01-10-2021, 08:05 PM #22Archived author: stevej • Posted: 2021-01-10T20:05:00.281000+00:00
Original source
```
| [locked][14] | tinyint(3) | unsigned | | NO | 0 | | |
| [lock_country][15] | varchar(2) | | | NO | 0 | | |
| [last_login][16] | timestamp | | | YES | NULL | | |
| [online][17] | int(10) | unsigned | | NO | 0 | | |
| [expansion][18] | tinyint(3) | unsigned | | NO | 2 | | |
| [mutetime][19] | bigint(20) | | | NO | 0 | | |
| [mutereason][20] | varchar(255) | | | NO | | | |
| [muteby][21] | varchar(50) | | | NO | | | |
| [locale][22] | tinyint(3) | unsigned | | NO | 0 | | |
| [os][23] | varchar(3) | | | NO | | | |
| [recruiter][24] | int(10) | unsigned | | NO | 0 | | |
| [totaltime][25] | int(10) | unsigned | | NO | 0 | | |
```
Original source
Is it okay that way?
rektbyfaith
01-10-2021, 08:05 PM #23Archived author: stevej • Posted: 2021-01-10T20:05:23.234000+00:00
Original source
Is it okay that way?
Original source
I don't know because sometimes it adds the word NULL, where can I generate the structure based on SQL? I tried to use HeidiSQL and SQLyog, but they don't give me that structure.
rektbyfaith
01-10-2021, 08:08 PM #24Archived author: stevej • Posted: 2021-01-10T20:08:48.408000+00:00
Original source
I don't know because sometimes it adds the word NULL, where can I generate the structure based on SQL? I tried to use HeidiSQL and SQLyog, but they don't give me that structure.
Original source
This is the structure that I used on SQLyog
rektbyfaith
01-10-2021, 08:12 PM #25Archived author: stevej • Posted: 2021-01-10T20:12:12.378000+00:00
Original source
This is the structure that I used on SQLyog
Original source
```
/*Column Information*/
----------------------
Field Type Collation Null Key Default Extra Privileges Comment
------- ------------------- --------------- ------ ------ ------- ------ ------------------------------- ---------
id int(10) unsigned (NULL) NO PRI (NULL) select,insert,update,references
gmlevel tinyint(3) unsigned (NULL) NO (NULL) select,insert,update,references
RealmID int(11) (NULL) NO PRI -1 select,insert,update,references
comment varchar(255) utf8_general_ci YES select,insert,update,references
```
rektbyfaith
01-10-2021, 08:12 PM #26Archived author: stevej • Posted: 2021-01-10T20:12:27.186000+00:00
Original source
```
/*Column Information*/
----------------------
Field Type Collation Null Key Default Extra Privileges Comment
------- ------------------- --------------- ------ ------ ------- ------ ------------------------------- ---------
id int(10) unsigned (NULL) NO PRI (NULL) select,insert,update,references
gmlevel tinyint(3) unsigned (NULL) NO (NULL) select,insert,update,references
RealmID int(11) (NULL) NO PRI -1 select,insert,update,references
comment varchar(255) utf8_general_ci YES select,insert,update,references
```
Original source
That's why, at first, I wrote it that way.
rektbyfaith
01-10-2021, 08:12 PM #27Archived author: stevej • Posted: 2021-01-10T20:12:48.226000+00:00
Original source
That's why, at first, I wrote it that way.
Original source
Unless, when I put it in parentheses, it means it doesn't go, and what I was doing wrong was deleting the parentheses.
rektbyfaith
01-10-2021, 08:13 PM #28Archived author: stevej • Posted: 2021-01-10T20:13:45.493000+00:00
Original source
Unless, when I put it in parentheses, it means it doesn't go, and what I was doing wrong was deleting the parentheses.
Original source
rektbyfaith
01-10-2021, 08:13 PM #29Archived author: stevej • Posted: 2021-01-10T20:13:48.377000+00:00
Original source
Original source
auto_increment is the default, so the `extra` column can be removed
rektbyfaith
01-10-2021, 08:18 PM #30Archived author: Kitzunu • Posted: 2021-01-10T20:18:30.207000+00:00
Original source
auto_increment is the default, so the `extra` column can be removed
1 Guest(s)
1 Guest(s)