Database Model plugin_tmp.xml

access
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
aid TINYINT(10) PK NN        
mask VARCHAR(255)   NN        
type VARCHAR(255)   NN        
status TINYINT(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY aid


accesslog
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
aid INTEGER(10) PK NN        
sid VARCHAR(32)   NN        
title VARCHAR(255)            
path VARCHAR(255)            
url VARCHAR(255)            
hostname VARCHAR(128)            
uid INTEGER(10)     UNSIGNED      
timer INTEGER(10)   NN UNSIGNED      
timestamp INTEGER(11)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY aid
accesslog_timestamp Index timestamp


aggregator_category
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(10) PK NN        
title VARCHAR(255)   NN        
description LONGTEXT   NN        
block TINYINT(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY cid
title Index title


aggregator_category_feed
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
fid INTEGER(10) PK NN        
cid INTEGER(10) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY fid
cid


aggregator_category_item
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
iid INTEGER(10) PK NN        
cid INTEGER(10) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY iid
cid


aggregator_feed
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
fid INTEGER(10) PK NN        
title VARCHAR(255)   NN        
url VARCHAR(255)   NN        
refresh INTEGER(10)   NN        
checked INTEGER(10)   NN        
link VARCHAR(255)   NN        
description LONGTEXT   NN        
image LONGTEXT   NN        
etag VARCHAR(255)   NN        
modified INTEGER(10)   NN        
block TINYINT(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY fid
link Index url
title Index title


aggregator_item
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
iid INTEGER(10) PK NN        
fid INTEGER(10)   NN        
title VARCHAR(255)   NN        
link VARCHAR(255)   NN        
author VARCHAR(255)   NN        
description LONGTEXT   NN        
timestamp INTEGER(11)            
IndexName IndexType Columns
PRIMARY PRIMARY iid


authmap
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
aid INTEGER(10) PK NN UNSIGNED      
uid INTEGER(10)   NN        
authname VARCHAR(128)   NN        
module VARCHAR(128)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY aid
authname Index authname


blocks
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
module VARCHAR(64)   NN        
delta VARCHAR(32)   NN        
theme VARCHAR(255)   NN        
status TINYINT(2)   NN        
weight TINYINT(1)   NN        
region VARCHAR(64)   NN   left    
custom TINYINT(2)   NN        
throttle TINYINT(1)   NN        
visibility TINYINT(1)   NN        
pages TEXT   NN        


book
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
vid INTEGER(10) PK NN UNSIGNED      
nid INTEGER(10)   NN UNSIGNED      
parent INTEGER(10)   NN        
weight TINYINT(3)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY vid
nid Index nid
parent Index parent


boxes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
bid TINYINT(4) PK NN        
title VARCHAR(64)   NN        
body LONGTEXT            
info VARCHAR(128)   NN        
format INTEGER(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY bid
info Index info


cache
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid VARCHAR(255) PK NN        
data LONGBLOB            
expire INTEGER(11)   NN        
created INTEGER(11)   NN        
headers TEXT            
IndexName IndexType Columns
PRIMARY PRIMARY cid
expire Index expire


client
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(10) PK NN UNSIGNED      
link VARCHAR(255)   NN        
name VARCHAR(128)   NN        
mail VARCHAR(128)   NN        
slogan LONGTEXT   NN        
mission LONGTEXT   NN        
users INTEGER(10)   NN        
nodes INTEGER(10)   NN        
version VARCHAR(35)   NN        
created INTEGER(11)   NN        
changed INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY cid


client_system
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(10) PK NN        
name VARCHAR(255) PK NN        
type VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY cid
name


comments
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(10) PK NN        
pid INTEGER(10)   NN        
nid INTEGER(10)   NN        
uid INTEGER(10)   NN        
subject VARCHAR(64)   NN        
comment LONGTEXT   NN        
hostname VARCHAR(128)   NN        
timestamp INTEGER(11)   NN        
score MEDIUMINT(9)   NN        
status TINYINT(3)   NN UNSIGNED      
format INTEGER(4)   NN        
thread VARCHAR(255)   NN        
users LONGTEXT            
name VARCHAR(60)            
mail VARCHAR(64)            
homepage VARCHAR(255)            
IndexName IndexType Columns
PRIMARY PRIMARY cid
lid Index nid


contact
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
cid INTEGER(10) PK NN UNSIGNED      
category VARCHAR(255)   NN        
recipients LONGTEXT   NN        
reply LONGTEXT   NN        
weight TINYINT(3)   NN        
selected TINYINT(1)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY cid
category Index category


file_revisions
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
fid INTEGER(10) PK NN UNSIGNED      
vid INTEGER(10) PK NN UNSIGNED      
description VARCHAR(255)   NN        
list TINYINT(1)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY fid
vid


files
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
fid INTEGER(10) PK NN UNSIGNED      
nid INTEGER(10)   NN UNSIGNED      
filename VARCHAR(255)   NN        
filepath VARCHAR(255)   NN        
filemime VARCHAR(255)   NN        
filesize INTEGER(10)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY fid


filter_formats
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
format INTEGER(4) PK NN        
name VARCHAR(255)   NN        
roles VARCHAR(255)   NN        
cache TINYINT(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY format
name Index name


filters
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
format INTEGER(4)   NN        
module VARCHAR(64)   NN        
delta TINYINT(2)   NN        
weight TINYINT(2)   NN        
IndexName IndexType Columns
weight Index weight


flood
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
event VARCHAR(64)   NN        
hostname VARCHAR(128)   NN        
timestamp INTEGER(11)   NN        


forum
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10)   NN UNSIGNED      
vid INTEGER(10) PK NN UNSIGNED      
tid INTEGER(10)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY vid
nid Index nid
tid Index tid


history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
uid INTEGER(10) PK NN        
nid INTEGER(10) PK NN        
timestamp INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY uid
nid


locales_meta
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
locale VARCHAR(12) PK NN        
name VARCHAR(64)   NN        
enabled INTEGER(2)   NN        
isdefault INTEGER(2)   NN        
plurals INTEGER(1)   NN        
formula VARCHAR(128)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY locale


locales_source
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
lid INTEGER(11) PK NN        
location VARCHAR(255)   NN        
source BLOB   NN        
IndexName IndexType Columns
PRIMARY PRIMARY lid


locales_target
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
lid INTEGER(11)   NN        
translation BLOB   NN        
locale VARCHAR(12)   NN        
plid INTEGER(11)   NN        
plural INTEGER(1)   NN        
IndexName IndexType Columns
lid Index lid
lang Index locale
plid Index plid
plural Index plural


menu
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
mid INTEGER(10) PK NN UNSIGNED      
pid INTEGER(10)   NN UNSIGNED      
path VARCHAR(255)   NN        
title VARCHAR(255)   NN        
description VARCHAR(255)   NN        
weight TINYINT(4)   NN        
type INTEGER(2)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY mid


node
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10) PK NN UNSIGNED      
vid INTEGER(10)   NN UNSIGNED      
type VARCHAR(32)   NN        
title VARCHAR(128)   NN        
uid INTEGER(10)   NN        
status INTEGER(4)   NN   1    
created INTEGER(11)   NN        
changed INTEGER(11)   NN        
comment INTEGER(2)   NN        
promote INTEGER(2)   NN        
moderate INTEGER(2)   NN        
sticky INTEGER(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY nid
node_type Index type
node_title_type Index title
type
status Index status
uid Index uid
vid Index vid
node_moderate Index moderate
node_promote_status Index promote
status
node_created Index created
node_changed Index changed
node_status_type Index status
type
nid


node_access
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10) PK NN UNSIGNED      
gid INTEGER(10) PK NN UNSIGNED      
realm VARCHAR(255) PK NN        
grant_view TINYINT(1)   NN UNSIGNED      
grant_update TINYINT(1)   NN UNSIGNED      
grant_delete TINYINT(1)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY nid
gid
realm


node_comment_statistics
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10) PK NN UNSIGNED      
last_comment_timestamp INTEGER(11)   NN        
last_comment_name VARCHAR(60)            
last_comment_uid INTEGER(10)   NN        
comment_count INTEGER(10)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY nid
node_comment_timestamp Index last_comment_timestamp


node_counter
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(11) PK NN        
totalcount BIGINT(20)   NN UNSIGNED      
daycount MEDIUMINT(8)   NN UNSIGNED      
timestamp INTEGER(11)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY nid
totalcount Index totalcount
daycount Index daycount
timestamp Index timestamp


node_revisions
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10)   NN UNSIGNED      
vid INTEGER(10) PK NN UNSIGNED      
uid INTEGER(10)   NN        
title VARCHAR(128)   NN        
body LONGTEXT   NN        
teaser LONGTEXT   NN        
log LONGTEXT   NN        
timestamp INTEGER(11)   NN        
format INTEGER(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY vid
nid Index nid
uid Index uid


permission
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
rid INTEGER(10)   NN UNSIGNED      
perm LONGTEXT            
tid INTEGER(10)   NN UNSIGNED      
IndexName IndexType Columns
rid Index rid


poll
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10) PK NN UNSIGNED      
runtime INTEGER(10)   NN        
active INTEGER(2)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY nid


poll_choices
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
chid INTEGER(10) PK NN UNSIGNED      
nid INTEGER(10)   NN UNSIGNED      
chtext VARCHAR(128)   NN        
chvotes INTEGER(6)   NN        
chorder INTEGER(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY chid
nid Index nid


poll_votes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10)   NN UNSIGNED      
uid INTEGER(10)   NN UNSIGNED      
hostname VARCHAR(128)   NN        
IndexName IndexType Columns
nid Index nid
uid Index uid
hostname Index hostname


profile_fields
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
fid INTEGER(10) PK NN        
title VARCHAR(255)            
name VARCHAR(128)            
explanation TEXT            
category VARCHAR(255)            
page VARCHAR(255)            
type VARCHAR(128)            
weight TINYINT(1)   NN        
required TINYINT(1)   NN        
register TINYINT(1)   NN        
visibility TINYINT(1)   NN        
options TEXT            
IndexName IndexType Columns
PRIMARY PRIMARY fid
name Index name
category Index category


profile_values
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
fid INTEGER(10)     UNSIGNED      
uid INTEGER(10)     UNSIGNED      
value TEXT            
IndexName IndexType Columns
uid Index uid
fid Index fid


role
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
rid INTEGER(10) PK NN UNSIGNED      
name VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY rid
name Index name


search_dataset
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
sid INTEGER(10)   NN UNSIGNED      
type VARCHAR(16)            
data LONGTEXT   NN        
IndexName IndexType Columns
sid_type Index sid
type


search_index
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
word VARCHAR(50)   NN        
sid INTEGER(10)   NN UNSIGNED      
type VARCHAR(16)            
fromsid INTEGER(10)   NN UNSIGNED      
fromtype VARCHAR(16)            
score FLOAT            
IndexName IndexType Columns
sid_type Index sid
type
from_sid_type Index fromsid
fromtype
word Index word


search_total
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
word VARCHAR(50) PK NN        
count FLOAT            
IndexName IndexType Columns
PRIMARY PRIMARY word


sequences
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
name VARCHAR(255) PK NN        
id INTEGER(10)   NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY name


sessions
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
uid INTEGER(10)   NN UNSIGNED      
sid VARCHAR(32) PK NN        
hostname VARCHAR(128)   NN        
timestamp INTEGER(11)   NN        
cache INTEGER(11)   NN        
session LONGTEXT            
IndexName IndexType Columns
PRIMARY PRIMARY sid
uid Index uid
timestamp Index timestamp


system
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
filename VARCHAR(255) PK NN        
name VARCHAR(255)   NN        
type VARCHAR(255)   NN        
description VARCHAR(255)   NN        
status INTEGER(2)   NN        
throttle TINYINT(1)   NN        
bootstrap INTEGER(2)   NN        
schema_version SMALLINT(3)   NN   -1    
weight INTEGER(2)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY filename
weight Index weight


term_data
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
tid INTEGER(10) PK NN UNSIGNED      
vid INTEGER(10)   NN UNSIGNED      
name VARCHAR(255)   NN        
description LONGTEXT            
weight TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY tid
vid Index vid


term_hierarchy
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
tid INTEGER(10) PK NN UNSIGNED      
parent INTEGER(10) PK NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY tid
parent
tid Index tid
parent Index parent


term_node
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
nid INTEGER(10) PK NN UNSIGNED      
tid INTEGER(10) PK NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY tid
nid
nid Index nid
tid Index tid


term_relation
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
tid1 INTEGER(10)   NN UNSIGNED      
tid2 INTEGER(10)   NN UNSIGNED      
IndexName IndexType Columns
tid1 Index tid1
tid2 Index tid2


term_synonym
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
tid INTEGER(10)   NN UNSIGNED      
name VARCHAR(255)   NN        
IndexName IndexType Columns
tid Index tid
name Index name


url_alias
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
pid INTEGER(10) PK NN UNSIGNED      
src VARCHAR(128)   NN        
dst VARCHAR(128)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY pid
dst Index dst
src Index src


users
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
uid INTEGER(10) PK NN UNSIGNED      
name VARCHAR(60)   NN        
pass VARCHAR(32)   NN        
mail VARCHAR(64)            
mode TINYINT(1)   NN        
sort TINYINT(1)            
threshold TINYINT(1)            
theme VARCHAR(255)   NN        
signature VARCHAR(255)   NN        
created INTEGER(11)   NN        
access INTEGER(11)   NN        
login INTEGER(11)   NN        
status TINYINT(4)   NN        
timezone VARCHAR(8)            
language VARCHAR(12)   NN        
picture VARCHAR(255)   NN        
init VARCHAR(64)            
data LONGTEXT            
IndexName IndexType Columns
PRIMARY PRIMARY uid
name Index name
access Index access


users_roles
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
uid INTEGER(10) PK NN UNSIGNED      
rid INTEGER(10) PK NN UNSIGNED      
IndexName IndexType Columns
PRIMARY PRIMARY uid
rid


variable
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
name VARCHAR(48) PK NN        
value LONGTEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY name


vocabulary
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
vid INTEGER(10) PK NN UNSIGNED      
name VARCHAR(255)   NN        
description LONGTEXT            
help VARCHAR(255)   NN        
relations TINYINT(3)   NN UNSIGNED      
hierarchy TINYINT(3)   NN UNSIGNED      
multiple TINYINT(3)   NN UNSIGNED      
required TINYINT(3)   NN UNSIGNED      
tags TINYINT(3)   NN UNSIGNED      
module VARCHAR(255)   NN        
weight TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY vid


vocabulary_node_types
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
vid INTEGER(10) PK NN UNSIGNED      
type VARCHAR(32) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY vid
type


watchdog
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
wid INTEGER(5) PK NN        
uid INTEGER(10)   NN        
type VARCHAR(16)   NN        
message LONGTEXT   NN        
severity TINYINT(3)   NN UNSIGNED      
link VARCHAR(255)   NN        
location VARCHAR(128)   NN        
referer VARCHAR(128)   NN        
hostname VARCHAR(128)   NN        
timestamp INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY wid