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

 

email

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