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 |