Joomla! 1.5-Beta1 (SVN 6776) dataBase Schema |
| Built: Monday, March 5th 2007 |
| jos_banner | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
bid |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
cid |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
type |
varchar(90) |
utf8_general_ci |
|
|
banner |
|
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
imptotal |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
impmade |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
clicks |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
imageurl |
varchar(100) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
clickurl |
varchar(200) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
date |
datetime |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
showBanner |
tinyint(1) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
checked_out |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
editor |
varchar(150) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
custombannercode |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
catid |
int(10) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
description |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
sticky |
tinyint(1) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
publish_up |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
publish_down |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
tags |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_banner |
0 |
PRIMARY |
1 |
bid |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_banner |
1 |
viewbanner |
1 |
showBanner |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_banner |
1 |
idx_banner_catid |
1 |
catid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_bannerclient | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
cid |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
contact |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
|
extrainfo |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
checked_out |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
time |
NULL |
YES |
|
(NULL) |
|
select,insert,update,references |
|
editor |
varchar(150) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_bannerclient |
0 |
PRIMARY |
1 |
cid |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_bannertrack | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
track_date |
date |
NULL |
|
|
0000-00-00 |
|
select,insert,update,references |
|
track_type |
int(10) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
banner_id |
int(10) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
| Indexes |
Back To Table Index
| jos_categories | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
parent_id |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
image |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
section |
varchar(150) |
utf8_general_ci |
|
MUL |
|
|
select,insert,update,references |
|
image_position |
varchar(90) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
description |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
editor |
varchar(150) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
access |
tinyint(3) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
count |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_categories |
0 |
PRIMARY |
1 |
id |
A |
23 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_categories |
1 |
cat_idx |
1 |
section |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_categories |
1 |
cat_idx |
2 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_categories |
1 |
cat_idx |
3 |
access |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_categories |
1 |
idx_section |
1 |
section |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_categories |
1 |
idx_access |
1 |
access |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_categories |
1 |
idx_checkout |
1 |
checked_out |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_components | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
varchar(150) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
link |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
menuid |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
parent |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
admin_menu_link |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
admin_menu_alt |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
option |
varchar(50) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
admin_menu_img |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
iscore |
tinyint(4) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
enabled |
tinyint(4) |
NULL |
|
|
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 |
jos_components |
0 |
PRIMARY |
1 |
id |
A |
33 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_contact_details | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
con_position |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
address |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
suburb |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
state |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
country |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
postcode |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
telephone |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
fax |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
misc |
mediumtext |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
image |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
imagepos |
varchar(60) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
email_to |
varchar(255) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
default_con |
tinyint(1) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
published |
tinyint(1) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
user_id |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
catid |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
access |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
mobile |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
webpage |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_contact_details |
0 |
PRIMARY |
1 |
id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_content | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) unsigned |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
title_alias |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
introtext |
mediumtext |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
fulltext |
mediumtext |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
state |
tinyint(3) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
sectionid |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
mask |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
catid |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
created |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
created_by |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
created_by_alias |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
modified |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
modified_by |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
publish_up |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
publish_down |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
images |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
urls |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
attribs |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
version |
int(11) unsigned |
NULL |
|
|
1 |
|
select,insert,update,references |
|
parentid |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
metakey |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
metadesc |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
access |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
hits |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
metadata |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_content |
0 |
PRIMARY |
1 |
id |
A |
43 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_content |
1 |
idx_section |
1 |
sectionid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_content |
1 |
idx_access |
1 |
access |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_content |
1 |
idx_checkout |
1 |
checked_out |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_content |
1 |
idx_state |
1 |
state |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_content |
1 |
idx_catid |
1 |
catid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_content |
1 |
idx_mask |
1 |
mask |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_content_frontpage | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
content_id |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
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 |
jos_content_frontpage |
0 |
PRIMARY |
1 |
content_id |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_content_rating | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
content_id |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
rating_sum |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
rating_count |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
lastip |
varchar(150) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_content_rating |
0 |
PRIMARY |
1 |
content_id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_core_acl_aro | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
section_value |
varchar(240) |
utf8_general_ci |
|
MUL |
0 |
|
select,insert,update,references |
|
value |
varchar(240) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
order_value |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
name |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
hidden |
int(11) |
NULL |
|
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 |
jos_core_acl_aro |
0 |
PRIMARY |
1 |
id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro |
0 |
__section_value_value_aro |
1 |
section_value |
A |
(NULL) |
100 |
(NULL) |
|
BTREE |
|
jos_core_acl_aro |
0 |
__section_value_value_aro |
2 |
value |
A |
1 |
100 |
(NULL) |
|
BTREE |
|
jos_core_acl_aro |
1 |
jos_gacl_hidden_aro |
1 |
hidden |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_core_acl_aro_groups | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
parent_id |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
name |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
lft |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
rgt |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
value |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_core_acl_aro_groups |
0 |
PRIMARY |
1 |
id |
A |
11 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_groups |
1 |
jos_gacl_parent_id_aro_groups |
1 |
parent_id |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_groups |
1 |
jos_gacl_lft_rgt_aro_groups |
1 |
lft |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_groups |
1 |
jos_gacl_lft_rgt_aro_groups |
2 |
rgt |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_core_acl_aro_sections | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
section_id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
value |
varchar(230) |
utf8_general_ci |
|
UNI |
|
|
select,insert,update,references |
|
order_value |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
name |
varchar(230) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
hidden |
int(11) |
NULL |
|
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 |
jos_core_acl_aro_sections |
0 |
PRIMARY |
1 |
section_id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_sections |
0 |
value_aro_sections |
1 |
value |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_sections |
0 |
jos_gacl_value_aro_sections |
1 |
value |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_sections |
1 |
hidden_aro_sections |
1 |
hidden |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_aro_sections |
1 |
jos_gacl_hidden_aro_sections |
1 |
hidden |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_core_acl_groups_aro_map | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
group_id |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
section_value |
varchar(240) |
utf8_general_ci |
|
PRI |
|
|
select,insert,update,references |
|
aro_id |
int(11) |
NULL |
|
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 |
jos_core_acl_groups_aro_map |
0 |
group_id_aro_id_groups_aro_map |
1 |
group_id |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_groups_aro_map |
0 |
group_id_aro_id_groups_aro_map |
2 |
section_value |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_core_acl_groups_aro_map |
0 |
group_id_aro_id_groups_aro_map |
3 |
aro_id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_core_log_items | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
time_stamp |
date |
NULL |
|
|
0000-00-00 |
|
select,insert,update,references |
|
item_table |
varchar(50) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
item_id |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
hits |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
| Indexes |
Back To Table Index
| jos_core_log_searches | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
search_term |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
hits |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
| Indexes |
Back To Table Index
| jos_groups | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
tinyint(3) unsigned |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
name |
varchar(150) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_groups |
0 |
PRIMARY |
1 |
id |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_menu | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
menutype |
varchar(225) |
utf8_general_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
name |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
link |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
type |
varchar(150) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
parent |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
componentid |
int(11) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
sublevel |
int(11) |
NULL |
YES |
|
0 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
YES |
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
pollid |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
browserNav |
tinyint(4) |
NULL |
YES |
|
0 |
|
select,insert,update,references |
|
access |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
utaccess |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
lft |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
rgt |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
home |
int(1) unsigned |
NULL |
|
|
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 |
jos_menu |
0 |
PRIMARY |
1 |
id |
A |
27 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_menu |
1 |
componentid |
1 |
componentid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_menu |
1 |
componentid |
2 |
menutype |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
jos_menu |
1 |
componentid |
3 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_menu |
1 |
componentid |
4 |
access |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_menu |
1 |
menutype |
1 |
menutype |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back To Table Index
| jos_menu_types | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(10) unsigned |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
menutype |
varchar(225) |
utf8_general_ci |
|
UNI |
|
|
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
description |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_menu_types |
0 |
PRIMARY |
1 |
id |
A |
6 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_menu_types |
0 |
menutype |
1 |
menutype |
A |
6 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_messages | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
message_id |
int(10) unsigned |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
user_id_from |
int(10) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
user_id_to |
int(10) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
folder_id |
int(10) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
date_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
state |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
priority |
int(1) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
subject |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
message |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_messages |
0 |
PRIMARY |
1 |
message_id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_messages_cfg | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
user_id |
int(10) unsigned |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
cfg_name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
cfg_value |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_messages_cfg |
0 |
idx_user_var_name |
1 |
user_id |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_messages_cfg |
0 |
idx_user_var_name |
2 |
cfg_name |
A |
0 |
100 |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_modules | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
content |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
position |
varchar(150) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
module |
varchar(150) |
utf8_general_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
numnews |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
access |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
showtitle |
tinyint(3) unsigned |
NULL |
|
|
1 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
iscore |
tinyint(4) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
client_id |
tinyint(4) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
control |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_modules |
0 |
PRIMARY |
1 |
id |
A |
41 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_modules |
1 |
published |
1 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_modules |
1 |
published |
2 |
access |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_modules |
1 |
newsfeeds |
1 |
module |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
jos_modules |
1 |
newsfeeds |
2 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_modules_menu | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
moduleid |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
menuid |
int(11) |
NULL |
|
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 |
jos_modules_menu |
0 |
PRIMARY |
1 |
moduleid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_modules_menu |
0 |
PRIMARY |
2 |
menuid |
A |
26 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_newsfeeds | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
catid |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
link |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
filename |
varchar(200) |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
numarticles |
int(11) unsigned |
NULL |
|
|
1 |
|
select,insert,update,references |
|
cache_time |
int(11) unsigned |
NULL |
|
|
3600 |
|
select,insert,update,references |
|
checked_out |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
rtl |
tinyint(4) |
NULL |
|
|
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 |
jos_newsfeeds |
0 |
PRIMARY |
1 |
id |
A |
9 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_newsfeeds |
1 |
published |
1 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_plugins | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
element |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
folder |
varchar(100) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
access |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
published |
tinyint(3) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
iscore |
tinyint(3) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
client_id |
tinyint(3) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_plugins |
0 |
PRIMARY |
1 |
id |
A |
30 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_plugins |
1 |
idx_folder |
1 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_plugins |
1 |
idx_folder |
2 |
client_id |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_plugins |
1 |
idx_folder |
3 |
access |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_plugins |
1 |
idx_folder |
4 |
folder |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_poll_data | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
pollid |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
text |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
hits |
int(11) |
NULL |
|
|
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 |
jos_poll_data |
0 |
PRIMARY |
1 |
id |
A |
12 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_poll_data |
1 |
pollid |
1 |
pollid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_poll_data |
1 |
pollid |
2 |
text |
A |
(NULL) |
1 |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_poll_date | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
bigint(20) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
date |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
vote_id |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
poll_id |
int(11) |
NULL |
|
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 |
jos_poll_date |
0 |
PRIMARY |
1 |
id |
A |
7 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_poll_date |
1 |
poll_id |
1 |
poll_id |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_poll_menu | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
pollid |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
menuid |
int(11) |
NULL |
|
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 |
jos_poll_menu |
0 |
PRIMARY |
1 |
pollid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_poll_menu |
0 |
PRIMARY |
2 |
menuid |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_polls | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) unsigned |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
voters |
int(9) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
access |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
lag |
int(11) |
NULL |
|
|
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 |
jos_polls |
0 |
PRIMARY |
1 |
id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_sections | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
image |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
scope |
varchar(50) |
utf8_general_ci |
|
MUL |
|
|
select,insert,update,references |
|
image_position |
varchar(90) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
description |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
access |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
count |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_sections |
0 |
PRIMARY |
1 |
id |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_sections |
1 |
idx_scope |
1 |
scope |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_session | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
username |
varchar(150) |
utf8_general_ci |
YES |
|
|
|
select,insert,update,references |
|
time |
varchar(14) |
utf8_general_ci |
YES |
|
|
|
select,insert,update,references |
|
session_id |
varchar(200) |
utf8_general_ci |
|
PRI |
0 |
|
select,insert,update,references |
|
guest |
tinyint(4) |
NULL |
YES |
MUL |
1 |
|
select,insert,update,references |
|
userid |
int(11) |
NULL |
YES |
|
0 |
|
select,insert,update,references |
|
usertype |
varchar(150) |
utf8_general_ci |
YES |
|
|
|
select,insert,update,references |
|
gid |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
client_id |
tinyint(3) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
data |
text |
utf8_general_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_session |
0 |
PRIMARY |
1 |
session_id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_session |
1 |
whosonline |
1 |
guest |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
jos_session |
1 |
whosonline |
2 |
usertype |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back To Table Index
| jos_stats_agents | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
agent |
varchar(255) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
type |
tinyint(1) unsigned |
NULL |
|
|
0 |
|
select,insert,update,references |
|
hits |
int(11) unsigned |
NULL |
|
|
1 |
|
select,insert,update,references |
|
| Indexes |
Back To Table Index
| jos_template_positions | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
position |
varchar(150) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
description |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_template_positions |
0 |
PRIMARY |
1 |
id |
A |
34 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_templates_menu | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
template |
text |
utf8_general_ci |
|
PRI |
|
|
select,insert,update,references |
|
menuid |
int(11) |
NULL |
|
PRI |
0 |
|
select,insert,update,references |
|
client_id |
tinyint(4) |
NULL |
|
|
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 |
jos_templates_menu |
0 |
PRIMARY |
1 |
template |
A |
(NULL) |
255 |
(NULL) |
|
BTREE |
|
jos_templates_menu |
0 |
PRIMARY |
2 |
menuid |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_users | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
name |
text |
utf8_general_ci |
|
MUL |
|
|
select,insert,update,references |
|
username |
varchar(150) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
varchar(100) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
|
password |
varchar(100) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
usertype |
varchar(75) |
utf8_general_ci |
|
MUL |
|
|
select,insert,update,references |
|
block |
tinyint(4) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
sendEmail |
tinyint(4) |
NULL |
YES |
|
0 |
|
select,insert,update,references |
|
gid |
tinyint(3) unsigned |
NULL |
|
|
1 |
|
select,insert,update,references |
|
registerDate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
lastvisitDate |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
activation |
varchar(100) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_users |
0 |
PRIMARY |
1 |
id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_users |
1 |
usertype |
1 |
usertype |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_users |
1 |
idx_name |
1 |
name |
A |
(NULL) |
255 |
(NULL) |
|
BTREE |
|
Back To Table Index
| jos_weblinks | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) unsigned |
NULL |
|
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
catid |
int(11) |
NULL |
|
MUL |
0 |
|
select,insert,update,references |
|
sid |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
title |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
url |
varchar(250) |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
description |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
date |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
hits |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
published |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
checked_out_time |
datetime |
NULL |
|
|
0000-00-00 00:00:00 |
|
select,insert,update,references |
|
ordering |
int(11) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
archived |
tinyint(1) |
NULL |
|
|
0 |
|
select,insert,update,references |
|
approved |
tinyint(1) |
NULL |
|
|
1 |
|
select,insert,update,references |
|
params |
text |
utf8_general_ci |
|
|
|
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
jos_weblinks |
0 |
PRIMARY |
1 |
id |
A |
5 |
(NULL) |
(NULL) |
|
BTREE |
|
jos_weblinks |
1 |
catid |
1 |
catid |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_weblinks |
1 |
catid |
2 |
published |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
jos_weblinks |
1 |
catid |
3 |
archived |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back To Table Index