smf11rc2 |
smf_attachments
smf_ban_groups
smf_ban_items
smf_board_permissions
smf_boards
smf_calendar
smf_calendar_holidays
smf_categories
smf_collapsed_categories
smf_log_actions
smf_log_activity
smf_log_banned
smf_log_boards
smf_log_errors
smf_log_floodcontrol
smf_log_karma
smf_log_mark_read
smf_log_notify
smf_log_online
smf_log_polls
smf_log_search_messages
smf_log_search_results
smf_log_search_subjects
smf_log_search_topics
smf_log_topics
smf_membergroups
smf_members
smf_message_icons
smf_messages
smf_moderators
smf_package_servers
smf_permissions
smf_personal_messages
smf_pm_recipients
smf_poll_choices
smf_polls
smf_sessions
smf_settings
smf_smileys
smf_themes
smf_topics
smf_attachments |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_ATTACH |
int(10) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ID_THUMB |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_MSG |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
attachmentType |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
filename |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
size |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
downloads |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
width |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
height |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_attachments |
0 |
PRIMARY |
1 |
ID_ATTACH |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_attachments |
0 |
ID_MEMBER |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_attachments |
0 |
ID_MEMBER |
2 |
ID_ATTACH |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_attachments |
1 |
ID_MSG |
1 |
ID_MSG |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_ban_groups |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_BAN_GROUP |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
varchar(20) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ban_time |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
expire_time |
int(10) unsigned |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
cannot_access |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
cannot_register |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
cannot_post |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
cannot_login |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
reason |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
notes |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_ban_groups |
0 |
PRIMARY |
1 |
ID_BAN_GROUP |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_ban_items |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_BAN |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ID_BAN_GROUP |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ip_low1 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_high1 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_low2 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_high2 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_low3 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_high3 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_low4 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip_high4 |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
hostname |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
email_address |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
hits |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_ban_items |
0 |
PRIMARY |
1 |
ID_BAN |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_ban_items |
1 |
ID_BAN_GROUP |
1 |
ID_BAN_GROUP |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_board_permissions |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_GROUP |
smallint(5) |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
permission |
varchar(30) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
addDeny |
tinyint(4) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_board_permissions |
0 |
PRIMARY |
1 |
ID_GROUP |
A |
4 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_board_permissions |
0 |
PRIMARY |
2 |
ID_BOARD |
A |
4 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_board_permissions |
0 |
PRIMARY |
3 |
permission |
A |
69 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_boards |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ID_CAT |
tinyint(4) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
childLevel |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_PARENT |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
boardOrder |
smallint(5) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_LAST_MSG |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_MSG_UPDATED |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
memberGroups |
varchar(255) |
latin1_swedish_ci |
NO |
MUL |
-1,0 |
|
select,insert,update,references |
|
name |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
description |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
numTopics |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
numPosts |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
countPosts |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_THEME |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
permission_mode |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
override_theme |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_boards |
0 |
PRIMARY |
1 |
ID_BOARD |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_boards |
0 |
categories |
1 |
ID_CAT |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_boards |
0 |
categories |
2 |
ID_BOARD |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_boards |
1 |
ID_PARENT |
1 |
ID_PARENT |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_boards |
1 |
ID_MSG_UPDATED |
1 |
ID_MSG_UPDATED |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_boards |
1 |
memberGroups |
1 |
memberGroups |
A |
1 |
48 |
(NULL) |
|
BTREE |
|
Back
smf_calendar |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_EVENT |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
startDate |
date |
(NULL) |
NO |
MUL |
0001-01-01 |
|
select,insert,update,references |
|
endDate |
date |
(NULL) |
NO |
MUL |
0001-01-01 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
title |
varchar(48) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_calendar |
0 |
PRIMARY |
1 |
ID_EVENT |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_calendar |
1 |
startDate |
1 |
startDate |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_calendar |
1 |
endDate |
1 |
endDate |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_calendar |
1 |
topic |
1 |
ID_TOPIC |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_calendar |
1 |
topic |
2 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_calendar_holidays |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_HOLIDAY |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
eventDate |
date |
(NULL) |
NO |
MUL |
0001-01-01 |
|
select,insert,update,references |
|
title |
varchar(30) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_calendar_holidays |
0 |
PRIMARY |
1 |
ID_HOLIDAY |
A |
167 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_calendar_holidays |
1 |
eventDate |
1 |
eventDate |
A |
167 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_categories |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_CAT |
tinyint(4) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
catOrder |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
name |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
canCollapse |
tinyint(1) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_categories |
0 |
PRIMARY |
1 |
ID_CAT |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_collapsed_categories |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_CAT |
tinyint(4) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_collapsed_categories |
0 |
PRIMARY |
1 |
ID_CAT |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_collapsed_categories |
0 |
PRIMARY |
2 |
ID_MEMBER |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_actions |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_ACTION |
int(10) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
logTime |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ip |
char(16) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
action |
varchar(30) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
extra |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_actions |
0 |
PRIMARY |
1 |
ID_ACTION |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_actions |
1 |
logTime |
1 |
logTime |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_actions |
1 |
ID_MEMBER |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_activity |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
date |
date |
(NULL) |
NO |
PRI |
0001-01-01 |
|
select,insert,update,references |
|
hits |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
topics |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
posts |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
registers |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
mostOn |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_activity |
0 |
PRIMARY |
1 |
date |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_activity |
1 |
hits |
1 |
hits |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_activity |
1 |
mostOn |
1 |
mostOn |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_banned |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_BAN_LOG |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ip |
char(16) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
|
logTime |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_banned |
0 |
PRIMARY |
1 |
ID_BAN_LOG |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_banned |
1 |
logTime |
1 |
logTime |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_boards |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MSG |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_boards |
0 |
PRIMARY |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_boards |
0 |
PRIMARY |
2 |
ID_BOARD |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_errors |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_ERROR |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
logTime |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ip |
char(16) |
latin1_swedish_ci |
NO |
MUL |
|
|
select,insert,update,references |
|
url |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
message |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
session |
char(32) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_errors |
0 |
PRIMARY |
1 |
ID_ERROR |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_errors |
1 |
logTime |
1 |
logTime |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_errors |
1 |
ID_MEMBER |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_errors |
1 |
ip |
1 |
ip |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_floodcontrol |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ip |
char(16) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
logTime |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_floodcontrol |
0 |
PRIMARY |
1 |
ip |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_karma |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_TARGET |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_EXECUTOR |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
logTime |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
action |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_karma |
0 |
PRIMARY |
1 |
ID_TARGET |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_karma |
0 |
PRIMARY |
2 |
ID_EXECUTOR |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_karma |
1 |
logTime |
1 |
logTime |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_mark_read |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MSG |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_mark_read |
0 |
PRIMARY |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_mark_read |
0 |
PRIMARY |
2 |
ID_BOARD |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_notify |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
sent |
tinyint(1) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_notify |
0 |
PRIMARY |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_notify |
0 |
PRIMARY |
2 |
ID_TOPIC |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_notify |
0 |
PRIMARY |
3 |
ID_BOARD |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_online |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
session |
varchar(32) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
logTime |
timestamp |
(NULL) |
YES |
MUL |
CURRENT_TIMESTAMP |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ip |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
url |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_online |
0 |
PRIMARY |
1 |
session |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_online |
1 |
logTime |
1 |
logTime |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_online |
1 |
ID_MEMBER |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_polls |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_POLL |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_CHOICE |
tinyint(3) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_polls |
0 |
PRIMARY |
1 |
ID_POLL |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_polls |
0 |
PRIMARY |
2 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_polls |
0 |
PRIMARY |
3 |
ID_CHOICE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_search_messages |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_SEARCH |
tinyint(3) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MSG |
mediumint(9) |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_search_messages |
0 |
PRIMARY |
1 |
ID_SEARCH |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_search_messages |
0 |
PRIMARY |
2 |
ID_MSG |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_search_results |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_SEARCH |
tinyint(3) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MSG |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
relevance |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
num_matches |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_search_results |
0 |
PRIMARY |
1 |
ID_SEARCH |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_search_results |
0 |
PRIMARY |
2 |
ID_TOPIC |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_search_subjects |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
word |
varchar(20) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_search_subjects |
0 |
PRIMARY |
1 |
word |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_search_subjects |
0 |
PRIMARY |
2 |
ID_TOPIC |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_search_subjects |
1 |
ID_TOPIC |
1 |
ID_TOPIC |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_search_topics |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_SEARCH |
tinyint(3) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_TOPIC |
mediumint(9) |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_search_topics |
0 |
PRIMARY |
1 |
ID_SEARCH |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_search_topics |
0 |
PRIMARY |
2 |
ID_TOPIC |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_log_topics |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MSG |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_log_topics |
0 |
PRIMARY |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_log_topics |
0 |
PRIMARY |
2 |
ID_TOPIC |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_membergroups |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_GROUP |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
groupName |
varchar(80) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
onlineColor |
varchar(20) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
minPosts |
mediumint(9) |
(NULL) |
NO |
MUL |
-1 |
|
select,insert,update,references |
|
maxMessages |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
stars |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_membergroups |
0 |
PRIMARY |
1 |
ID_GROUP |
A |
8 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_membergroups |
1 |
minPosts |
1 |
minPosts |
A |
8 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_members |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
memberName |
varchar(80) |
latin1_swedish_ci |
NO |
MUL |
|
|
select,insert,update,references |
|
dateRegistered |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
posts |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_GROUP |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
lngfile |
tinytext |
latin1_swedish_ci |
NO |
MUL |
|
|
select,insert,update,references |
|
lastLogin |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
realName |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
instantMessages |
smallint(5) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
unreadMessages |
smallint(5) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
buddy_list |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
pm_ignore_list |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
messageLabels |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
passwd |
varchar(64) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
emailAddress |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
personalText |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
gender |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
birthdate |
date |
(NULL) |
NO |
MUL |
0001-01-01 |
|
select,insert,update,references |
|
websiteTitle |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
websiteUrl |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
location |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ICQ |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
AIM |
varchar(16) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
YIM |
varchar(32) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
MSN |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
hideEmail |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
showOnline |
tinyint(4) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
timeFormat |
varchar(80) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
signature |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
timeOffset |
float |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
avatar |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
pm_email_notify |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
karmaBad |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
karmaGood |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
usertitle |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
notifyAnnouncements |
tinyint(4) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
notifyOnce |
tinyint(4) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
notifySendBody |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
notifyTypes |
tinyint(4) |
(NULL) |
NO |
|
2 |
|
select,insert,update,references |
|
memberIP |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
secretQuestion |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
secretAnswer |
varchar(64) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ID_THEME |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
is_activated |
tinyint(3) unsigned |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
validation_code |
varchar(10) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ID_MSG_LAST_VISIT |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
additionalGroups |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
smileySet |
varchar(48) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ID_POST_GROUP |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
totalTimeLoggedIn |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
passwordSalt |
varchar(5) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_members |
0 |
PRIMARY |
1 |
ID_MEMBER |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_members |
1 |
memberName |
1 |
memberName |
A |
3 |
30 |
(NULL) |
|
BTREE |
|
smf_members |
1 |
dateRegistered |
1 |
dateRegistered |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_members |
1 |
ID_GROUP |
1 |
ID_GROUP |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_members |
1 |
birthdate |
1 |
birthdate |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_members |
1 |
posts |
1 |
posts |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_members |
1 |
lastLogin |
1 |
lastLogin |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_members |
1 |
lngfile |
1 |
lngfile |
A |
3 |
30 |
(NULL) |
|
BTREE |
|
smf_members |
1 |
ID_POST_GROUP |
1 |
ID_POST_GROUP |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_message_icons |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_ICON |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
title |
varchar(80) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
filename |
varchar(80) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
ID_BOARD |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
iconOrder |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_message_icons |
0 |
PRIMARY |
1 |
ID_ICON |
A |
12 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_message_icons |
1 |
ID_BOARD |
1 |
ID_BOARD |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_messages |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MSG |
int(10) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
posterTime |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_MSG_MODIFIED |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
subject |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
posterName |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
posterEmail |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
posterIP |
tinytext |
latin1_swedish_ci |
NO |
MUL |
|
|
select,insert,update,references |
|
smileysEnabled |
tinyint(4) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
modifiedTime |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
modifiedName |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
body |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
icon |
varchar(16) |
latin1_swedish_ci |
NO |
|
xx |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_messages |
0 |
PRIMARY |
1 |
ID_MSG |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
0 |
topic |
1 |
ID_TOPIC |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
0 |
topic |
2 |
ID_MSG |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
0 |
ID_BOARD |
1 |
ID_BOARD |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
0 |
ID_BOARD |
2 |
ID_MSG |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
1 |
ipIndex |
1 |
posterIP |
A |
5 |
15 |
(NULL) |
|
BTREE |
|
smf_messages |
1 |
ipIndex |
2 |
ID_TOPIC |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
1 |
participation |
1 |
ID_MEMBER |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
1 |
participation |
2 |
ID_TOPIC |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_messages |
1 |
ID_TOPIC |
1 |
ID_TOPIC |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_moderators |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_moderators |
0 |
PRIMARY |
1 |
ID_BOARD |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_moderators |
0 |
PRIMARY |
2 |
ID_MEMBER |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_package_servers |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_SERVER |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
url |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_package_servers |
0 |
PRIMARY |
1 |
ID_SERVER |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_permissions |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_GROUP |
smallint(5) |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
permission |
varchar(30) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
addDeny |
tinyint(4) |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_permissions |
0 |
PRIMARY |
1 |
ID_GROUP |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_permissions |
0 |
PRIMARY |
2 |
permission |
A |
39 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_personal_messages |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_PM |
int(10) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ID_MEMBER_FROM |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
deletedBySender |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
fromName |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
msgtime |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
subject |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
body |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_personal_messages |
0 |
PRIMARY |
1 |
ID_PM |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_personal_messages |
1 |
ID_MEMBER |
1 |
ID_MEMBER_FROM |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_personal_messages |
1 |
ID_MEMBER |
2 |
deletedBySender |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_personal_messages |
1 |
msgtime |
1 |
msgtime |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_pm_recipients |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_PM |
int(10) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
labels |
varchar(60) |
latin1_swedish_ci |
NO |
|
-1 |
|
select,insert,update,references |
|
bcc |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
is_read |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
deleted |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_pm_recipients |
0 |
PRIMARY |
1 |
ID_PM |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_pm_recipients |
0 |
PRIMARY |
2 |
ID_MEMBER |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_pm_recipients |
0 |
ID_MEMBER |
1 |
ID_MEMBER |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_pm_recipients |
0 |
ID_MEMBER |
2 |
deleted |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_pm_recipients |
0 |
ID_MEMBER |
3 |
ID_PM |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_poll_choices |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_POLL |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_CHOICE |
tinyint(3) unsigned |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
label |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
votes |
smallint(5) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_poll_choices |
0 |
PRIMARY |
1 |
ID_POLL |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
smf_poll_choices |
0 |
PRIMARY |
2 |
ID_CHOICE |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_polls |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_POLL |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
question |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
votingLocked |
tinyint(1) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
maxVotes |
tinyint(3) unsigned |
(NULL) |
NO |
|
1 |
|
select,insert,update,references |
|
expireTime |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
hideResults |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
changeVote |
tinyint(3) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_MEMBER |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
posterName |
tinytext |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_polls |
0 |
PRIMARY |
1 |
ID_POLL |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_sessions |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
session_id |
char(32) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
last_update |
int(10) unsigned |
(NULL) |
NO |
|
|
|
select,insert,update,references |
|
data |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_sessions |
0 |
PRIMARY |
1 |
session_id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_settings |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
variable |
tinytext |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
value |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_settings |
0 |
PRIMARY |
1 |
variable |
A |
162 |
30 |
(NULL) |
|
BTREE |
|
Back
smf_smileys |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_SMILEY |
smallint(5) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
code |
varchar(30) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
filename |
varchar(48) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
description |
varchar(80) |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
smileyRow |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
smileyOrder |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
hidden |
tinyint(4) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_smileys |
0 |
PRIMARY |
1 |
ID_SMILEY |
A |
19 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_themes |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_MEMBER |
mediumint(8) |
(NULL) |
NO |
PRI |
0 |
|
select,insert,update,references |
|
ID_THEME |
tinyint(4) unsigned |
(NULL) |
NO |
PRI |
1 |
|
select,insert,update,references |
|
variable |
tinytext |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
value |
text |
latin1_swedish_ci |
NO |
|
|
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_themes |
0 |
PRIMARY |
1 |
ID_THEME |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_themes |
0 |
PRIMARY |
2 |
ID_MEMBER |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_themes |
0 |
PRIMARY |
3 |
variable |
A |
32 |
30 |
(NULL) |
|
BTREE |
|
smf_themes |
1 |
ID_MEMBER |
1 |
ID_MEMBER |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
smf_topics |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID_TOPIC |
mediumint(8) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
isSticky |
tinyint(4) |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_BOARD |
smallint(5) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_FIRST_MSG |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_LAST_MSG |
int(10) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
ID_MEMBER_STARTED |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_MEMBER_UPDATED |
mediumint(8) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
ID_POLL |
mediumint(8) unsigned |
(NULL) |
NO |
MUL |
0 |
|
select,insert,update,references |
|
numReplies |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
numViews |
int(10) unsigned |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
locked |
tinyint(4) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
smf_topics |
0 |
PRIMARY |
1 |
ID_TOPIC |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
0 |
lastMessage |
1 |
ID_LAST_MSG |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
0 |
lastMessage |
2 |
ID_BOARD |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
0 |
firstMessage |
1 |
ID_FIRST_MSG |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
0 |
firstMessage |
2 |
ID_BOARD |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
0 |
poll |
1 |
ID_POLL |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
0 |
poll |
2 |
ID_TOPIC |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
1 |
isSticky |
1 |
isSticky |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
smf_topics |
1 |
ID_BOARD |
1 |
ID_BOARD |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back