Database Model plugin_tmp.xml

mos_banner
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid INTEGER(11) PK NN        
cid INTEGER(11)   NN        
type VARCHAR(10)   NN   banner    
name VARCHAR(50)   NN        
imptotal INTEGER(11)   NN        
impmade INTEGER(11)   NN        
clicks INTEGER(11)   NN        
imageurl VARCHAR(100)   NN        
clickurl VARCHAR(200)   NN        
date DATETIME            
showBanner TINYINT(1)   NN        
checked_out TINYINT(1)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
editor VARCHAR(50)            
custombannercode TEXT            
IndexName IndexType Columns
PRIMARY PRIMARY bid
viewbanner Index showBanner


mos_banner
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid INTEGER(11) PK NN        
cid INTEGER(11)   NN        
type VARCHAR(10)   NN   banner    
name VARCHAR(50)   NN        
imptotal INTEGER(11)   NN        
impmade INTEGER(11)   NN        
clicks INTEGER(11)   NN        
imageurl VARCHAR(100)   NN        
clickurl VARCHAR(200)   NN        
date DATETIME            
showBanner TINYINT(1)   NN        
checked_out TINYINT(1)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
editor VARCHAR(50)            
custombannercode TEXT            
IndexName IndexType Columns
PRIMARY PRIMARY bid
viewbanner Index showBanner


mos_banner
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid INTEGER(11) PK NN        
cid INTEGER(11)   NN        
type VARCHAR(10)   NN   banner    
name VARCHAR(50)   NN        
imptotal INTEGER(11)   NN        
impmade INTEGER(11)   NN        
clicks INTEGER(11)   NN        
imageurl VARCHAR(100)   NN        
clickurl VARCHAR(200)   NN        
date DATETIME            
showBanner TINYINT(1)   NN        
checked_out TINYINT(1)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
editor VARCHAR(50)            
custombannercode TEXT            
IndexName IndexType Columns
PRIMARY PRIMARY bid
viewbanner Index showBanner


mos_bannerclient
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(11) PK NN        
name VARCHAR(60)   NN        
contact VARCHAR(60)   NN        
email VARCHAR(60)   NN        
extrainfo TEXT   NN        
checked_out TINYINT(1)   NN        
checked_out_time TIME            
editor VARCHAR(50)            
IndexName IndexType Columns
PRIMARY PRIMARY cid


mos_bannerclient
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(11) PK NN        
name VARCHAR(60)   NN        
contact VARCHAR(60)   NN        
email VARCHAR(60)   NN        
extrainfo TEXT   NN        
checked_out TINYINT(1)   NN        
checked_out_time TIME            
editor VARCHAR(50)            
IndexName IndexType Columns
PRIMARY PRIMARY cid


mos_bannerclient
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(11) PK NN        
name VARCHAR(60)   NN        
contact VARCHAR(60)   NN        
email VARCHAR(60)   NN        
extrainfo TEXT   NN        
checked_out TINYINT(1)   NN        
checked_out_time TIME            
editor VARCHAR(50)            
IndexName IndexType Columns
PRIMARY PRIMARY cid


mos_bannerfinish
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid INTEGER(11) PK NN        
cid INTEGER(11)   NN        
type VARCHAR(10)   NN        
name VARCHAR(50)   NN        
impressions INTEGER(11)   NN        
clicks INTEGER(11)   NN        
imageurl VARCHAR(50)   NN        
datestart DATETIME            
dateend DATETIME            
IndexName IndexType Columns
PRIMARY PRIMARY bid


mos_bannerfinish
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid INTEGER(11) PK NN        
cid INTEGER(11)   NN        
type VARCHAR(10)   NN        
name VARCHAR(50)   NN        
impressions INTEGER(11)   NN        
clicks INTEGER(11)   NN        
imageurl VARCHAR(50)   NN        
datestart DATETIME            
dateend DATETIME            
IndexName IndexType Columns
PRIMARY PRIMARY bid


mos_bannerfinish
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid INTEGER(11) PK NN        
cid INTEGER(11)   NN        
type VARCHAR(10)   NN        
name VARCHAR(50)   NN        
impressions INTEGER(11)   NN        
clicks INTEGER(11)   NN        
imageurl VARCHAR(50)   NN        
datestart DATETIME            
dateend DATETIME            
IndexName IndexType Columns
PRIMARY PRIMARY bid


mos_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
parent_id INTEGER(11)   NN        
title VARCHAR(50)   NN        
name VARCHAR(255)   NN        
image VARCHAR(100)   NN        
section VARCHAR(50)   NN        
image_position VARCHAR(10)   NN        
description TEXT   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
editor VARCHAR(50)            
ordering INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
count INTEGER(11)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
cat_idx Index section
published
access
idx_section Index section
idx_access Index access
idx_checkout Index checked_out


mos_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
parent_id INTEGER(11)   NN        
title VARCHAR(50)   NN        
name VARCHAR(255)   NN        
image VARCHAR(100)   NN        
section VARCHAR(50)   NN        
image_position VARCHAR(10)   NN        
description TEXT   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
editor VARCHAR(50)            
ordering INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
count INTEGER(11)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
cat_idx Index section
published
access
idx_section Index section
idx_access Index access
idx_checkout Index checked_out


mos_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
parent_id INTEGER(11)   NN        
title VARCHAR(50)   NN        
name VARCHAR(255)   NN        
image VARCHAR(100)   NN        
section VARCHAR(50)   NN        
image_position VARCHAR(10)   NN        
description TEXT   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
editor VARCHAR(50)            
ordering INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
count INTEGER(11)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
cat_idx Index section
published
access
idx_section Index section
idx_access Index access
idx_checkout Index checked_out


mos_components
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(50)   NN        
link VARCHAR(255)   NN        
menuid INTEGER(11)   NN UNSIGNED      
parent INTEGER(11)   NN UNSIGNED      
admin_menu_link VARCHAR(255)   NN        
admin_menu_alt VARCHAR(255)   NN        
option VARCHAR(50)   NN        
ordering INTEGER(11)   NN        
admin_menu_img VARCHAR(255)   NN        
iscore TINYINT(4)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_components
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(50)   NN        
link VARCHAR(255)   NN        
menuid INTEGER(11)   NN UNSIGNED      
parent INTEGER(11)   NN UNSIGNED      
admin_menu_link VARCHAR(255)   NN        
admin_menu_alt VARCHAR(255)   NN        
option VARCHAR(50)   NN        
ordering INTEGER(11)   NN        
admin_menu_img VARCHAR(255)   NN        
iscore TINYINT(4)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_components
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(50)   NN        
link VARCHAR(255)   NN        
menuid INTEGER(11)   NN UNSIGNED      
parent INTEGER(11)   NN UNSIGNED      
admin_menu_link VARCHAR(255)   NN        
admin_menu_alt VARCHAR(255)   NN        
option VARCHAR(50)   NN        
ordering INTEGER(11)   NN        
admin_menu_img VARCHAR(255)   NN        
iscore TINYINT(4)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_contact_details
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(100)   NN        
con_position VARCHAR(50)            
address TEXT            
suburb VARCHAR(50)            
state VARCHAR(20)            
country VARCHAR(50)            
postcode VARCHAR(10)            
telephone VARCHAR(25)            
fax VARCHAR(25)            
misc MEDIUMTEXT            
image VARCHAR(100)            
imagepos VARCHAR(20)            
email_to VARCHAR(100)            
default_con TINYINT(1)   NN UNSIGNED      
published TINYINT(1)   NN UNSIGNED      
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
params TEXT   NN        
user_id INTEGER(11)   NN        
catid INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_contact_details
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(100)   NN        
con_position VARCHAR(50)            
address TEXT            
suburb VARCHAR(50)            
state VARCHAR(20)            
country VARCHAR(50)            
postcode VARCHAR(10)            
telephone VARCHAR(25)            
fax VARCHAR(25)            
misc MEDIUMTEXT            
image VARCHAR(100)            
imagepos VARCHAR(20)            
email_to VARCHAR(100)            
default_con TINYINT(1)   NN UNSIGNED      
published TINYINT(1)   NN UNSIGNED      
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
params TEXT   NN        
user_id INTEGER(11)   NN        
catid INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_contact_details
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(100)   NN        
con_position VARCHAR(50)            
address TEXT            
suburb VARCHAR(50)            
state VARCHAR(20)            
country VARCHAR(50)            
postcode VARCHAR(10)            
telephone VARCHAR(25)            
fax VARCHAR(25)            
misc MEDIUMTEXT            
image VARCHAR(100)            
imagepos VARCHAR(20)            
email_to VARCHAR(100)            
default_con TINYINT(1)   NN UNSIGNED      
published TINYINT(1)   NN UNSIGNED      
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
params TEXT   NN        
user_id INTEGER(11)   NN        
catid INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_content
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
title VARCHAR(100)   NN        
title_alias VARCHAR(100)   NN        
introtext MEDIUMTEXT   NN        
fulltext MEDIUMTEXT   NN        
state TINYINT(3)   NN        
sectionid INTEGER(11)   NN UNSIGNED      
mask INTEGER(11)   NN UNSIGNED      
catid INTEGER(11)   NN UNSIGNED      
created DATETIME   NN   0000-00-00 00:00:00    
created_by INTEGER(11)   NN UNSIGNED      
created_by_alias VARCHAR(100)   NN        
modified DATETIME   NN   0000-00-00 00:00:00    
modified_by INTEGER(11)   NN UNSIGNED      
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
publish_up DATETIME   NN   0000-00-00 00:00:00    
publish_down DATETIME   NN   0000-00-00 00:00:00    
images TEXT   NN        
urls TEXT   NN        
attribs TEXT   NN        
version INTEGER(11)   NN UNSIGNED 1    
parentid INTEGER(11)   NN UNSIGNED      
ordering INTEGER(11)   NN        
metakey TEXT   NN        
metadesc TEXT   NN        
access INTEGER(11)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_section Index sectionid
idx_access Index access
idx_checkout Index checked_out
idx_state Index state
idx_catid Index catid
idx_mask Index mask


mos_content
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
title VARCHAR(100)   NN        
title_alias VARCHAR(100)   NN        
introtext MEDIUMTEXT   NN        
fulltext MEDIUMTEXT   NN        
state TINYINT(3)   NN        
sectionid INTEGER(11)   NN UNSIGNED      
mask INTEGER(11)   NN UNSIGNED      
catid INTEGER(11)   NN UNSIGNED      
created DATETIME   NN   0000-00-00 00:00:00    
created_by INTEGER(11)   NN UNSIGNED      
created_by_alias VARCHAR(100)   NN        
modified DATETIME   NN   0000-00-00 00:00:00    
modified_by INTEGER(11)   NN UNSIGNED      
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
publish_up DATETIME   NN   0000-00-00 00:00:00    
publish_down DATETIME   NN   0000-00-00 00:00:00    
images TEXT   NN        
urls TEXT   NN        
attribs TEXT   NN        
version INTEGER(11)   NN UNSIGNED 1    
parentid INTEGER(11)   NN UNSIGNED      
ordering INTEGER(11)   NN        
metakey TEXT   NN        
metadesc TEXT   NN        
access INTEGER(11)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_section Index sectionid
idx_access Index access
idx_checkout Index checked_out
idx_state Index state
idx_catid Index catid
idx_mask Index mask


mos_content
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
title VARCHAR(100)   NN        
title_alias VARCHAR(100)   NN        
introtext MEDIUMTEXT   NN        
fulltext MEDIUMTEXT   NN        
state TINYINT(3)   NN        
sectionid INTEGER(11)   NN UNSIGNED      
mask INTEGER(11)   NN UNSIGNED      
catid INTEGER(11)   NN UNSIGNED      
created DATETIME   NN   0000-00-00 00:00:00    
created_by INTEGER(11)   NN UNSIGNED      
created_by_alias VARCHAR(100)   NN        
modified DATETIME   NN   0000-00-00 00:00:00    
modified_by INTEGER(11)   NN UNSIGNED      
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
publish_up DATETIME   NN   0000-00-00 00:00:00    
publish_down DATETIME   NN   0000-00-00 00:00:00    
images TEXT   NN        
urls TEXT   NN        
attribs TEXT   NN        
version INTEGER(11)   NN UNSIGNED 1    
parentid INTEGER(11)   NN UNSIGNED      
ordering INTEGER(11)   NN        
metakey TEXT   NN        
metadesc TEXT   NN        
access INTEGER(11)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_section Index sectionid
idx_access Index access
idx_checkout Index checked_out
idx_state Index state
idx_catid Index catid
idx_mask Index mask


mos_content_frontpage
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
content_id INTEGER(11) PK NN        
ordering INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY content_id


mos_content_frontpage
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
content_id INTEGER(11) PK NN        
ordering INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY content_id


mos_content_frontpage
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
content_id INTEGER(11) PK NN        
ordering INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY content_id


mos_content_rating
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
content_id INTEGER(11) PK NN        
rating_sum INTEGER(11)   NN UNSIGNED      
rating_count INTEGER(11)   NN UNSIGNED      
lastip VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY content_id


mos_content_rating
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
content_id INTEGER(11) PK NN        
rating_sum INTEGER(11)   NN UNSIGNED      
rating_count INTEGER(11)   NN UNSIGNED      
lastip VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY content_id


mos_content_rating
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
content_id INTEGER(11) PK NN        
rating_sum INTEGER(11)   NN UNSIGNED      
rating_count INTEGER(11)   NN UNSIGNED      
lastip VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY content_id


mos_core_acl_aro
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
aro_id INTEGER(11) PK NN        
section_value VARCHAR(240)   NN        
value VARCHAR(240)   NN        
order_value INTEGER(11)   NN        
name VARCHAR(255)   NN        
hidden INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY aro_id
section_value_value_aro Index section_value
value
mos_gacl_section_value_value_aro Index section_value
value
hidden_aro Index hidden
mos_gacl_hidden_aro Index hidden


mos_core_acl_aro
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
aro_id INTEGER(11) PK NN        
section_value VARCHAR(240)   NN        
value VARCHAR(240)   NN        
order_value INTEGER(11)   NN        
name VARCHAR(255)   NN        
hidden INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY aro_id
section_value_value_aro Index section_value
value
mos_gacl_section_value_value_aro Index section_value
value
hidden_aro Index hidden
mos_gacl_hidden_aro Index hidden


mos_core_acl_aro
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
aro_id INTEGER(11) PK NN        
section_value VARCHAR(240)   NN        
value VARCHAR(240)   NN        
order_value INTEGER(11)   NN        
name VARCHAR(255)   NN        
hidden INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY aro_id
section_value_value_aro Index section_value
value
mos_gacl_section_value_value_aro Index section_value
value
hidden_aro Index hidden
mos_gacl_hidden_aro Index hidden


mos_core_acl_aro_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
group_id INTEGER(11) PK NN        
parent_id INTEGER(11)   NN        
name VARCHAR(255)   NN        
lft INTEGER(11)   NN        
rgt INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY group_id
parent_id_aro_groups Index parent_id
mos_gacl_parent_id_aro_groups Index parent_id
mos_gacl_lft_rgt_aro_groups Index lft
rgt


mos_core_acl_aro_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
group_id INTEGER(11) PK NN        
parent_id INTEGER(11)   NN        
name VARCHAR(255)   NN        
lft INTEGER(11)   NN        
rgt INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY group_id
parent_id_aro_groups Index parent_id
mos_gacl_parent_id_aro_groups Index parent_id
mos_gacl_lft_rgt_aro_groups Index lft
rgt


mos_core_acl_aro_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
group_id INTEGER(11) PK NN        
parent_id INTEGER(11)   NN        
name VARCHAR(255)   NN        
lft INTEGER(11)   NN        
rgt INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY group_id
parent_id_aro_groups Index parent_id
mos_gacl_parent_id_aro_groups Index parent_id
mos_gacl_lft_rgt_aro_groups Index lft
rgt


mos_core_acl_aro_sections
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
section_id INTEGER(11) PK NN        
value VARCHAR(230)   NN        
order_value INTEGER(11)   NN        
name VARCHAR(230)   NN        
hidden INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY section_id
value_aro_sections Index value
mos_gacl_value_aro_sections Index value
hidden_aro_sections Index hidden
mos_gacl_hidden_aro_sections Index hidden


mos_core_acl_aro_sections
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
section_id INTEGER(11) PK NN        
value VARCHAR(230)   NN        
order_value INTEGER(11)   NN        
name VARCHAR(230)   NN        
hidden INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY section_id
value_aro_sections Index value
mos_gacl_value_aro_sections Index value
hidden_aro_sections Index hidden
mos_gacl_hidden_aro_sections Index hidden


mos_core_acl_aro_sections
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
section_id INTEGER(11) PK NN        
value VARCHAR(230)   NN        
order_value INTEGER(11)   NN        
name VARCHAR(230)   NN        
hidden INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY section_id
value_aro_sections Index value
mos_gacl_value_aro_sections Index value
hidden_aro_sections Index hidden
mos_gacl_hidden_aro_sections Index hidden


mos_core_acl_groups_aro_map
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
group_id INTEGER(11) PK NN        
section_value VARCHAR(240) PK NN        
aro_id INTEGER(11) PK NN        
IndexName IndexType Columns
group_id_aro_id_groups_aro_map Index group_id
section_value
aro_id


mos_core_acl_groups_aro_map
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
group_id INTEGER(11) PK NN        
section_value VARCHAR(240) PK NN        
aro_id INTEGER(11) PK NN        
IndexName IndexType Columns
group_id_aro_id_groups_aro_map Index group_id
section_value
aro_id


mos_core_acl_groups_aro_map
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
group_id INTEGER(11) PK NN        
section_value VARCHAR(240) PK NN        
aro_id INTEGER(11) PK NN        
IndexName IndexType Columns
group_id_aro_id_groups_aro_map Index group_id
section_value
aro_id


mos_core_log_items
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
time_stamp DATE   NN   0000-00-00    
item_table VARCHAR(50)   NN        
item_id INTEGER(11)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED      


mos_core_log_items
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
time_stamp DATE   NN   0000-00-00    
item_table VARCHAR(50)   NN        
item_id INTEGER(11)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED      


mos_core_log_items
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
time_stamp DATE   NN   0000-00-00    
item_table VARCHAR(50)   NN        
item_id INTEGER(11)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED      


mos_core_log_searches
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
search_term VARCHAR(128)   NN        
hits INTEGER(11)   NN UNSIGNED      


mos_core_log_searches
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
search_term VARCHAR(128)   NN        
hits INTEGER(11)   NN UNSIGNED      


mos_core_log_searches
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
search_term VARCHAR(128)   NN        
hits INTEGER(11)   NN UNSIGNED      


mos_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id TINYINT(3) PK NN UNSIGNED      
name VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id TINYINT(3) PK NN UNSIGNED      
name VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id TINYINT(3) PK NN UNSIGNED      
name VARCHAR(50)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_mambots
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(100)   NN        
element VARCHAR(100)   NN        
folder VARCHAR(100)   NN        
access TINYINT(3)   NN UNSIGNED      
ordering INTEGER(11)   NN        
published TINYINT(3)   NN        
iscore TINYINT(3)   NN        
client_id TINYINT(3)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_folder Index published
client_id
access
folder


mos_mambots
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(100)   NN        
element VARCHAR(100)   NN        
folder VARCHAR(100)   NN        
access TINYINT(3)   NN UNSIGNED      
ordering INTEGER(11)   NN        
published TINYINT(3)   NN        
iscore TINYINT(3)   NN        
client_id TINYINT(3)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_folder Index published
client_id
access
folder


mos_mambots
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(100)   NN        
element VARCHAR(100)   NN        
folder VARCHAR(100)   NN        
access TINYINT(3)   NN UNSIGNED      
ordering INTEGER(11)   NN        
published TINYINT(3)   NN        
iscore TINYINT(3)   NN        
client_id TINYINT(3)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_folder Index published
client_id
access
folder


mos_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
menutype VARCHAR(25)            
name VARCHAR(100)            
link TEXT            
type VARCHAR(50)   NN        
published TINYINT(1)   NN        
parent INTEGER(11)   NN UNSIGNED      
componentid INTEGER(11)   NN UNSIGNED      
sublevel INTEGER(11)            
ordering INTEGER(11)            
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
pollid INTEGER(11)   NN        
browserNav TINYINT(4)            
access TINYINT(3)   NN UNSIGNED      
utaccess TINYINT(3)   NN UNSIGNED      
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
componentid Index componentid
menutype
published
access
menutype Index menutype


mos_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
menutype VARCHAR(25)            
name VARCHAR(100)            
link TEXT            
type VARCHAR(50)   NN        
published TINYINT(1)   NN        
parent INTEGER(11)   NN UNSIGNED      
componentid INTEGER(11)   NN UNSIGNED      
sublevel INTEGER(11)            
ordering INTEGER(11)            
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
pollid INTEGER(11)   NN        
browserNav TINYINT(4)            
access TINYINT(3)   NN UNSIGNED      
utaccess TINYINT(3)   NN UNSIGNED      
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
componentid Index componentid
menutype
published
access
menutype Index menutype


mos_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
menutype VARCHAR(25)            
name VARCHAR(100)            
link TEXT            
type VARCHAR(50)   NN        
published TINYINT(1)   NN        
parent INTEGER(11)   NN UNSIGNED      
componentid INTEGER(11)   NN UNSIGNED      
sublevel INTEGER(11)            
ordering INTEGER(11)            
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
pollid INTEGER(11)   NN        
browserNav TINYINT(4)            
access TINYINT(3)   NN UNSIGNED      
utaccess TINYINT(3)   NN UNSIGNED      
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
componentid Index componentid
menutype
published
access
menutype Index menutype


mos_messages
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
message_id INTEGER(10) PK NN UNSIGNED      
user_id_from INTEGER(10)   NN UNSIGNED      
user_id_to INTEGER(10)   NN UNSIGNED      
folder_id INTEGER(10)   NN UNSIGNED      
date_time DATETIME   NN   0000-00-00 00:00:00    
state INTEGER(11)   NN        
priority INTEGER(1)   NN UNSIGNED      
subject VARCHAR(230)   NN        
message TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY message_id


mos_messages
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
message_id INTEGER(10) PK NN UNSIGNED      
user_id_from INTEGER(10)   NN UNSIGNED      
user_id_to INTEGER(10)   NN UNSIGNED      
folder_id INTEGER(10)   NN UNSIGNED      
date_time DATETIME   NN   0000-00-00 00:00:00    
state INTEGER(11)   NN        
priority INTEGER(1)   NN UNSIGNED      
subject VARCHAR(230)   NN        
message TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY message_id


mos_messages
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
message_id INTEGER(10) PK NN UNSIGNED      
user_id_from INTEGER(10)   NN UNSIGNED      
user_id_to INTEGER(10)   NN UNSIGNED      
folder_id INTEGER(10)   NN UNSIGNED      
date_time DATETIME   NN   0000-00-00 00:00:00    
state INTEGER(11)   NN        
priority INTEGER(1)   NN UNSIGNED      
subject VARCHAR(230)   NN        
message TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY message_id


mos_messages_cfg
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
user_id INTEGER(10) PK NN UNSIGNED      
cfg_name VARCHAR(100) PK NN        
cfg_value VARCHAR(255)   NN        
IndexName IndexType Columns
idx_user_var_name Index user_id
cfg_name


mos_messages_cfg
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
user_id INTEGER(10) PK NN UNSIGNED      
cfg_name VARCHAR(100) PK NN        
cfg_value VARCHAR(255)   NN        
IndexName IndexType Columns
idx_user_var_name Index user_id
cfg_name


mos_messages_cfg
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
user_id INTEGER(10) PK NN UNSIGNED      
cfg_name VARCHAR(100) PK NN        
cfg_value VARCHAR(255)   NN        
IndexName IndexType Columns
idx_user_var_name Index user_id
cfg_name


mos_modules
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
title TEXT   NN        
content TEXT   NN        
ordering INTEGER(11)   NN        
position VARCHAR(10)            
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
published TINYINT(1)   NN        
module VARCHAR(50)            
numnews INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
showtitle TINYINT(3)   NN UNSIGNED 1    
params TEXT   NN        
iscore TINYINT(4)   NN        
client_id TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
published Index published
access
newsfeeds Index module
published


mos_modules
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
title TEXT   NN        
content TEXT   NN        
ordering INTEGER(11)   NN        
position VARCHAR(10)            
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
published TINYINT(1)   NN        
module VARCHAR(50)            
numnews INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
showtitle TINYINT(3)   NN UNSIGNED 1    
params TEXT   NN        
iscore TINYINT(4)   NN        
client_id TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
published Index published
access
newsfeeds Index module
published


mos_modules
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
title TEXT   NN        
content TEXT   NN        
ordering INTEGER(11)   NN        
position VARCHAR(10)            
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
published TINYINT(1)   NN        
module VARCHAR(50)            
numnews INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
showtitle TINYINT(3)   NN UNSIGNED 1    
params TEXT   NN        
iscore TINYINT(4)   NN        
client_id TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
published Index published
access
newsfeeds Index module
published


mos_modules_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
moduleid INTEGER(11) PK NN        
menuid INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY moduleid
menuid


mos_modules_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
moduleid INTEGER(11) PK NN        
menuid INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY moduleid
menuid


mos_modules_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
moduleid INTEGER(11) PK NN        
menuid INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY moduleid
menuid


mos_newsfeeds
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
catid INTEGER(11)   NN        
id INTEGER(11) PK NN        
name TEXT   NN        
link TEXT   NN        
filename VARCHAR(200)            
published TINYINT(1)   NN        
numarticles INTEGER(11)   NN UNSIGNED 1    
cache_time INTEGER(11)   NN UNSIGNED 3600    
checked_out TINYINT(3)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
published Index published


mos_newsfeeds
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
catid INTEGER(11)   NN        
id INTEGER(11) PK NN        
name TEXT   NN        
link TEXT   NN        
filename VARCHAR(200)            
published TINYINT(1)   NN        
numarticles INTEGER(11)   NN UNSIGNED 1    
cache_time INTEGER(11)   NN UNSIGNED 3600    
checked_out TINYINT(3)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
published Index published


mos_newsfeeds
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
catid INTEGER(11)   NN        
id INTEGER(11) PK NN        
name TEXT   NN        
link TEXT   NN        
filename VARCHAR(200)            
published TINYINT(1)   NN        
numarticles INTEGER(11)   NN UNSIGNED 1    
cache_time INTEGER(11)   NN UNSIGNED 3600    
checked_out TINYINT(3)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
published Index published


mos_poll_data
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
pollid INTEGER(4)   NN        
text TEXT   NN        
hits INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
pollid Index pollid
text


mos_poll_data
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
pollid INTEGER(4)   NN        
text TEXT   NN        
hits INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
pollid Index pollid
text


mos_poll_data
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
pollid INTEGER(4)   NN        
text TEXT   NN        
hits INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
pollid Index pollid
text


mos_poll_date
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id BIGINT(20) PK NN        
date DATETIME   NN   0000-00-00 00:00:00    
vote_id INTEGER(11)   NN        
poll_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
poll_id Index poll_id


mos_poll_date
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id BIGINT(20) PK NN        
date DATETIME   NN   0000-00-00 00:00:00    
vote_id INTEGER(11)   NN        
poll_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
poll_id Index poll_id


mos_poll_date
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id BIGINT(20) PK NN        
date DATETIME   NN   0000-00-00 00:00:00    
vote_id INTEGER(11)   NN        
poll_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
poll_id Index poll_id


mos_poll_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
pollid INTEGER(11) PK NN        
menuid INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY pollid
menuid


mos_poll_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
pollid INTEGER(11) PK NN        
menuid INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY pollid
menuid


mos_poll_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
pollid INTEGER(11) PK NN        
menuid INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY pollid
menuid


mos_polls
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
title VARCHAR(100)   NN        
voters INTEGER(9)   NN        
checked_out INTEGER(11)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
published TINYINT(1)   NN        
access INTEGER(11)   NN        
lag INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_polls
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
title VARCHAR(100)   NN        
voters INTEGER(9)   NN        
checked_out INTEGER(11)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
published TINYINT(1)   NN        
access INTEGER(11)   NN        
lag INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_polls
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
title VARCHAR(100)   NN        
voters INTEGER(9)   NN        
checked_out INTEGER(11)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
published TINYINT(1)   NN        
access INTEGER(11)   NN        
lag INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_sections
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
title VARCHAR(50)   NN        
name VARCHAR(255)   NN        
image VARCHAR(100)   NN        
scope VARCHAR(50)   NN        
image_position VARCHAR(10)   NN        
description TEXT   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
count INTEGER(11)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_scope Index scope


mos_sections
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
title VARCHAR(50)   NN        
name VARCHAR(255)   NN        
image VARCHAR(100)   NN        
scope VARCHAR(50)   NN        
image_position VARCHAR(10)   NN        
description TEXT   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
count INTEGER(11)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_scope Index scope


mos_sections
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
title VARCHAR(50)   NN        
name VARCHAR(255)   NN        
image VARCHAR(100)   NN        
scope VARCHAR(50)   NN        
image_position VARCHAR(10)   NN        
description TEXT   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN UNSIGNED      
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
access TINYINT(3)   NN UNSIGNED      
count INTEGER(11)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
idx_scope Index scope


mos_session
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
username VARCHAR(50)            
time VARCHAR(14)            
session_id VARCHAR(200) PK NN        
guest TINYINT(4)       1    
userid INTEGER(11)            
usertype VARCHAR(50)            
gid TINYINT(3)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY session_id
whosonline Index guest
usertype


mos_session
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
username VARCHAR(50)            
time VARCHAR(14)            
session_id VARCHAR(200) PK NN        
guest TINYINT(4)       1    
userid INTEGER(11)            
usertype VARCHAR(50)            
gid TINYINT(3)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY session_id
whosonline Index guest
usertype


mos_session
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
username VARCHAR(50)            
time VARCHAR(14)            
session_id VARCHAR(200) PK NN        
guest TINYINT(4)       1    
userid INTEGER(11)            
usertype VARCHAR(50)            
gid TINYINT(3)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY session_id
whosonline Index guest
usertype


mos_stats_agents
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
agent VARCHAR(255)   NN        
type TINYINT(1)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED 1    


mos_stats_agents
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
agent VARCHAR(255)   NN        
type TINYINT(1)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED 1    


mos_stats_agents
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
agent VARCHAR(255)   NN        
type TINYINT(1)   NN UNSIGNED      
hits INTEGER(11)   NN UNSIGNED 1    


mos_template_positions
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
position VARCHAR(10)   NN        
description VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_template_positions
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
position VARCHAR(10)   NN        
description VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_template_positions
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
position VARCHAR(10)   NN        
description VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_templates_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
template VARCHAR(50) PK NN        
menuid INTEGER(11) PK NN        
client_id TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY template
menuid


mos_templates_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
template VARCHAR(50) PK NN        
menuid INTEGER(11) PK NN        
client_id TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY template
menuid


mos_templates_menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
template VARCHAR(50) PK NN        
menuid INTEGER(11) PK NN        
client_id TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY template
menuid


mos_users
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(50)   NN        
username VARCHAR(25)   NN        
email VARCHAR(100)   NN        
password VARCHAR(100)   NN        
usertype VARCHAR(25)   NN        
block TINYINT(4)   NN        
sendEmail TINYINT(4)            
gid TINYINT(3)   NN UNSIGNED 1    
registerDate DATETIME   NN   0000-00-00 00:00:00    
lastvisitDate DATETIME   NN   0000-00-00 00:00:00    
activation VARCHAR(100)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
usertype Index usertype
idx_name Index name


mos_users
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(50)   NN        
username VARCHAR(25)   NN        
email VARCHAR(100)   NN        
password VARCHAR(100)   NN        
usertype VARCHAR(25)   NN        
block TINYINT(4)   NN        
sendEmail TINYINT(4)            
gid TINYINT(3)   NN UNSIGNED 1    
registerDate DATETIME   NN   0000-00-00 00:00:00    
lastvisitDate DATETIME   NN   0000-00-00 00:00:00    
activation VARCHAR(100)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
usertype Index usertype
idx_name Index name


mos_users
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN        
name VARCHAR(50)   NN        
username VARCHAR(25)   NN        
email VARCHAR(100)   NN        
password VARCHAR(100)   NN        
usertype VARCHAR(25)   NN        
block TINYINT(4)   NN        
sendEmail TINYINT(4)            
gid TINYINT(3)   NN UNSIGNED 1    
registerDate DATETIME   NN   0000-00-00 00:00:00    
lastvisitDate DATETIME   NN   0000-00-00 00:00:00    
activation VARCHAR(100)   NN        
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
usertype Index usertype
idx_name Index name


mos_usertypes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id TINYINT(3) PK NN UNSIGNED      
name VARCHAR(50)   NN        
mask VARCHAR(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_usertypes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id TINYINT(3) PK NN UNSIGNED      
name VARCHAR(50)   NN        
mask VARCHAR(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_usertypes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id TINYINT(3) PK NN UNSIGNED      
name VARCHAR(50)   NN        
mask VARCHAR(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id


mos_weblinks
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
catid INTEGER(11)   NN        
sid INTEGER(11)   NN        
title VARCHAR(250)   NN        
url VARCHAR(250)   NN        
description VARCHAR(250)   NN        
date DATETIME   NN   0000-00-00 00:00:00    
hits INTEGER(11)   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
archived TINYINT(1)   NN        
approved TINYINT(1)   NN   1    
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
catid Index catid
published
archived


mos_weblinks
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
catid INTEGER(11)   NN        
sid INTEGER(11)   NN        
title VARCHAR(250)   NN        
url VARCHAR(250)   NN        
description VARCHAR(250)   NN        
date DATETIME   NN   0000-00-00 00:00:00    
hits INTEGER(11)   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
archived TINYINT(1)   NN        
approved TINYINT(1)   NN   1    
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
catid Index catid
published
archived


mos_weblinks
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
id INTEGER(11) PK NN UNSIGNED      
catid INTEGER(11)   NN        
sid INTEGER(11)   NN        
title VARCHAR(250)   NN        
url VARCHAR(250)   NN        
description VARCHAR(250)   NN        
date DATETIME   NN   0000-00-00 00:00:00    
hits INTEGER(11)   NN        
published TINYINT(1)   NN        
checked_out INTEGER(11)   NN        
checked_out_time DATETIME   NN   0000-00-00 00:00:00    
ordering INTEGER(11)   NN        
archived TINYINT(1)   NN        
approved TINYINT(1)   NN   1    
params TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY id
catid Index catid
published
archived