localhost drupal_head

access

Field	Type	Null	Default	Links to	Comments	MIME
aid	tinyint(10)	Yes	NULL
mask	varchar(255)	Yes
type	varchar(255)	Yes
status	tinyint(2)	Yes	0

accesslog

Field	Type	Null	Default	Links to	Comments	MIME
aid	int(10)	Yes	NULL	accesslog -> aid
sid	varchar(32)	Yes		sessions -> sid
title	varchar(255)	Yes	NULL
path	varchar(255)	Yes	NULL
url	varchar(255)	Yes	NULL
hostname	varchar(128)	Yes	NULL
uid	int(10)	Yes	0	users -> uid
timer	int(10)	Yes	0
timestamp	int(11)	Yes	0

aggregator_category

Field	Type	Null	Default	Links to	Comments	MIME
cid	int(10)	Yes	NULL
title	varchar(255)	Yes
description	longtext	Yes
block	tinyint(2)	Yes	0

aggregator_category_feed

Field	Type	Null	Default	Links to	Comments	MIME
fid	int(10)	Yes	0	aggregator_category_feed -> fid
cid	int(10)	Yes	0	aggregator_category -> cid

aggregator_category_item

Field	Type	Null	Default	Links to	Comments	MIME
iid	int(10)	Yes	0
cid	int(10)	Yes	0

aggregator_feed

Field	Type	Null	Default	Links to	Comments	MIME
fid	int(10)	Yes	NULL	aggregator_item -> iid
title	varchar(255)	Yes
url	varchar(255)	Yes
refresh	int(10)	Yes	0
checked	int(10)	Yes	0
link	varchar(255)	Yes
description	longtext	Yes
image	longtext	Yes
etag	varchar(255)	Yes
modified	int(10)	Yes	0
block	tinyint(2)	Yes	0

aggregator_item

Field	Type	Null	Default	Links to	Comments	MIME
iid	int(10)	Yes	NULL
fid	int(10)	Yes	0
title	varchar(255)	Yes
link	varchar(255)	Yes
author	varchar(255)	Yes
description	longtext	Yes
timestamp	int(11)	Yes	NULL

authmap

Field	Type	Null	Default	Links to	Comments	MIME
aid	int(10)	Yes	NULL
uid	int(10)	Yes	0
authname	varchar(128)	Yes
module	varchar(128)	Yes

blocks

Field	Type	Null	Default	Links to	Comments	MIME
module	varchar(64)	Yes
delta	varchar(32)	Yes	0
theme	varchar(255)	Yes
status	tinyint(2)	Yes	0
weight	tinyint(1)	Yes	0
region	varchar(64)	Yes	left
custom	tinyint(2)	Yes	0
throttle	tinyint(1)	Yes	0
visibility	tinyint(1)	Yes	0
pages	text	Yes

book

Field	Type	Null	Default	Links to	Comments	MIME
vid	int(10)	Yes	0	node_revisions -> vid
nid	int(10)	Yes	0	node -> nid
parent	int(10)	Yes	0
weight	tinyint(3)	Yes	0

boxes

Field	Type	Null	Default	Links to	Comments	MIME
bid	tinyint(4)	Yes	NULL
title	varchar(64)	Yes
body	longtext	Yes	NULL
info	varchar(128)	Yes
format	int(4)	Yes	0	filter_formats -> format

cache

Field	Type	Null	Default	Links to	Comments	MIME
cid	varchar(255)	Yes
data	longtext	Yes	NULL
expire	int(11)	Yes	0
created	int(11)	Yes	0
headers	text	Yes	NULL

comments

Field	Type	Null	Default	Links to	Comments	MIME
cid	int(10)	Yes	NULL	comments -> cid
pid	int(10)	Yes	0	comments -> cid
nid	int(10)	Yes	0	node -> nid
uid	int(10)	Yes	0	users -> uid
subject	varchar(64)	Yes
comment	longtext	Yes
hostname	varchar(128)	Yes
timestamp	int(11)	Yes	0
score	mediumint(9)	Yes	0
status	tinyint(3)	Yes	0
format	int(4)	Yes	0
thread	varchar(255)	Yes
users	longtext	Yes	NULL
name	varchar(60)	Yes	NULL
mail	varchar(64)	Yes	NULL
homepage	varchar(255)	Yes	NULL

contact

Field	Type	Null	Default	Links to	Comments	MIME
cid	int(10)	Yes	NULL
category	varchar(255)	Yes
recipients	longtext	Yes
reply	longtext	Yes
weight	tinyint(3)	Yes	0
selected	tinyint(1)	Yes	0

directory

Field	Type	Null	Default	Links to	Comments	MIME
link	varchar(255)	Yes
name	varchar(128)	Yes
mail	varchar(128)	Yes
slogan	longtext	Yes
mission	longtext	Yes
timestamp	int(11)	Yes	0

files

Field	Type	Null	Default	Links to	Comments	MIME
fid	int(10)	Yes	0	files -> fid
nid	int(10)	Yes	0	node -> nid
vid	int(10)	Yes	0	node_revisions -> vid
filename	varchar(255)	Yes
description	varchar(255)	Yes
filepath	varchar(255)	Yes
filemime	varchar(255)	Yes
filesize	int(10)	Yes	0
list	tinyint(1)	Yes	0

filter_formats

Field	Type	Null	Default	Links to	Comments	MIME
format	int(4)	Yes	NULL
name	varchar(255)	Yes
roles	varchar(255)	Yes		role -> rid
cache	tinyint(2)	Yes	0

filters

Field	Type	Null	Default	Links to	Comments	MIME
format	int(4)	Yes	0
module	varchar(64)	Yes
delta	tinyint(2)	Yes	0
weight	tinyint(2)	Yes	0

flood

Field	Type	Null	Default	Links to	Comments	MIME
event	varchar(64)	Yes
hostname	varchar(128)	Yes
timestamp	int(11)	Yes	0

forum

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes	0	node -> nid
vid	int(10)	Yes	0	node_revisions -> vid
tid	int(10)	Yes	0	term_data -> tid

history

Field	Type	Null	Default	Links to	Comments	MIME
uid	int(10)	Yes	0	users -> uid
nid	int(10)	Yes	0	node_revisions -> nid
timestamp	int(11)	Yes	0

locales_meta

Field	Type	Null	Default	Links to	Comments	MIME
locale	varchar(12)	Yes
name	varchar(64)	Yes
enabled	int(2)	Yes	0
isdefault	int(2)	Yes	0
plurals	int(1)	Yes	0
formula	varchar(128)	Yes

locales_source

Field	Type	Null	Default	Links to	Comments	MIME
lid	int(11)	Yes	NULL
location	varchar(255)	Yes
source	blob	Yes

locales_target

Field	Type	Null	Default	Links to	Comments	MIME
lid	int(11)	Yes	0
translation	blob	Yes
locale	varchar(12)	Yes
plid	int(11)	Yes	0
plural	int(1)	Yes	0

menu

Field	Type	Null	Default	Links to	Comments	MIME
mid	int(10)	Yes	0	menu -> mid
pid	int(10)	Yes	0
path	varchar(255)	Yes
title	varchar(255)	Yes
description	varchar(255)	Yes
weight	tinyint(4)	Yes	0
type	int(2)	Yes	0

moderation_filters

Field	Type	Null	Default	Links to	Comments	MIME
fid	int(10)	Yes	NULL	moderation_filters -> fid
filter	varchar(255)	Yes
minimum	smallint(6)	Yes	0

moderation_roles

Field	Type	Null	Default	Links to	Comments	MIME
rid	int(10)	Yes	0	role -> rid
mid	int(10)	Yes	0	moderation_votes -> mid
value	tinyint(4)	Yes	0

moderation_votes

Field	Type	Null	Default	Links to	Comments	MIME
mid	int(10)	Yes	NULL
vote	varchar(255)	Yes	NULL
weight	tinyint(4)	Yes	0

node

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes	NULL	node -> nid
vid	int(10)	Yes	0	node_revisions -> vid
type	varchar(32)	Yes
title	varchar(128)	Yes
uid	int(10)	Yes	0	users -> uid
status	int(4)	Yes	1
created	int(11)	Yes	0
changed	int(11)	Yes	0
comment	int(2)	Yes	0
promote	int(2)	Yes	0
moderate	int(2)	Yes	0
sticky	int(2)	Yes	0

node_access

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes	0	node -> nid
gid	int(10)	Yes	0
realm	varchar(255)	Yes
grant_view	tinyint(1)	Yes	0
grant_update	tinyint(1)	Yes	0
grant_delete	tinyint(1)	Yes	0

node_comment_statistics

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes	NULL	node -> nid
last_comment_timestamp	int(11)	Yes	0
last_comment_name	varchar(60)	Yes	NULL
last_comment_uid	int(10)	Yes	0	users -> uid
comment_count	int(10)	Yes	0

node_counter

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(11)	Yes	0
totalcount	bigint(20)	Yes	0
daycount	mediumint(8)	Yes	0
timestamp	int(11)	Yes	0

node_revisions

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes		node -> nid
vid	int(10)	Yes		node_revisions -> vid
uid	int(10)	Yes	0	users -> uid
title	varchar(128)	Yes
body	longtext	Yes
teaser	longtext	Yes
log	longtext	Yes
timestamp	int(11)	Yes	0
format	int(4)	Yes	0

permission

Field	Type	Null	Default	Links to	Comments	MIME
rid	int(10)	Yes	0	role -> rid
perm	longtext	Yes	NULL
tid	int(10)	Yes	0

poll

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes	0	node -> nid
runtime	int(10)	Yes	0
polled	longtext	Yes
active	int(2)	Yes	0

poll_choices

Field	Type	Null	Default	Links to	Comments	MIME
chid	int(10)	Yes	NULL
nid	int(10)	Yes	0
chtext	varchar(128)	Yes
chvotes	int(6)	Yes	0
chorder	int(2)	Yes	0

profile_fields

Field	Type	Null	Default	Links to	Comments	MIME
fid	int(10)	Yes	NULL
title	varchar(255)	Yes	NULL
name	varchar(128)	Yes	NULL
explanation	text	Yes	NULL
category	varchar(255)	Yes	NULL
page	varchar(255)	Yes	NULL
type	varchar(128)	Yes	NULL
weight	tinyint(1)	Yes	0
required	tinyint(1)	Yes	0
register	tinyint(1)	Yes	0
visibility	tinyint(1)	Yes	0
options	text	Yes	NULL

profile_values

Field	Type	Null	Default	Links to	Comments	MIME
fid	int(10)	Yes	0
uid	int(10)	Yes	0
value	text	Yes	NULL

role

Field	Type	Null	Default	Links to	Comments	MIME
rid	int(10)	Yes	NULL
name	varchar(32)	Yes

search_dataset

Field	Type	Null	Default	Links to	Comments	MIME
sid	int(10)	Yes	0
type	varchar(16)	Yes	NULL
data	longtext	Yes

search_index

Field	Type	Null	Default	Links to	Comments	MIME
word	varchar(50)	Yes		search_total -> word
sid	int(10)	Yes	0
type	varchar(16)	Yes	NULL
fromsid	int(10)	Yes	0
fromtype	varchar(16)	Yes	NULL
score	float	Yes	NULL

search_total

Field	Type	Null	Default	Links to	Comments	MIME
word	varchar(50)	Yes
count	float	Yes	NULL

sequences

Field	Type	Null	Default	Links to	Comments	MIME
name	varchar(255)	Yes
id	int(10)	Yes	0

sessions

Field	Type	Null	Default	Links to	Comments	MIME
uid	int(10)	Yes
sid	varchar(32)	Yes
hostname	varchar(128)	Yes
timestamp	int(11)	Yes	0
cache	int(11)	Yes	0
session	longtext	Yes	NULL

system

Field	Type	Null	Default	Links to	Comments	MIME
filename	varchar(255)	Yes
name	varchar(255)	Yes
type	varchar(255)	Yes
description	varchar(255)	Yes
status	int(2)	Yes	0
throttle	tinyint(1)	Yes	0
bootstrap	int(2)	Yes	0

term_data

Field	Type	Null	Default	Links to	Comments	MIME
tid	int(10)	Yes	NULL	term_data -> tid
vid	int(10)	Yes	0	vocabulary -> vid
name	varchar(255)	Yes
description	longtext	Yes	NULL
weight	tinyint(4)	Yes	0

term_hierarchy

Field	Type	Null	Default	Links to	Comments	MIME
tid	int(10)	Yes	0	term_data -> tid
parent	int(10)	Yes	0	term_hierarchy -> tid

term_node

Field	Type	Null	Default	Links to	Comments	MIME
nid	int(10)	Yes	0
tid	int(10)	Yes	0

term_relation

Field	Type	Null	Default	Links to	Comments	MIME
tid1	int(10)	Yes	0
tid2	int(10)	Yes	0

term_synonym

Field	Type	Null	Default	Links to	Comments	MIME
tid	int(10)	Yes	0	term_data -> tid
name	varchar(255)	Yes

url_alias

Field	Type	Null	Default	Links to	Comments	MIME
pid	int(10)	Yes	NULL
src	varchar(128)	Yes
dst	varchar(128)	Yes

users

Field	Type	Null	Default	Links to	Comments	MIME
uid	int(10)	Yes	0	users -> uid
name	varchar(60)	Yes
pass	varchar(32)	Yes
mail	varchar(64)	Yes
mode	tinyint(1)	Yes	0
sort	tinyint(1)	Yes	0
threshold	tinyint(1)	Yes	0
theme	varchar(255)	Yes
signature	varchar(255)	Yes
created	int(11)	Yes	0
access	int(11)	Yes	0
login	int(11)	Yes	0
status	tinyint(4)	Yes	0
timezone	varchar(8)	Yes	NULL
language	varchar(12)	Yes
picture	varchar(255)	Yes
init	varchar(64)	Yes
data	longtext	Yes	NULL

users_roles

Field	Type	Null	Default	Links to	Comments	MIME
uid	int(10)	Yes	0	users -> uid
rid	int(10)	Yes	0	users_roles -> rid

variable

Field	Type	Null	Default	Links to	Comments	MIME
name	varchar(48)	Yes
value	longtext	Yes

vocabulary

Field	Type	Null	Default	Links to	Comments	MIME
vid	int(10)	Yes	NULL	vocabulary -> vid
name	varchar(255)	Yes
description	longtext	Yes	NULL
help	varchar(255)	Yes
relations	tinyint(3)	Yes	0
hierarchy	tinyint(3)	Yes	0
multiple	tinyint(3)	Yes	0
required	tinyint(3)	Yes	0
tags	tinyint(3)	Yes	0
module	varchar(255)	Yes
weight	tinyint(4)	Yes	0

vocabulary_node_types

Field	Type	Null	Default	Links to	Comments	MIME
vid	int(10)	Yes	0	vocabulary -> vid
type	varchar(16)	Yes

watchdog

Field	Type	Null	Default	Links to	Comments	MIME
wid	int(5)	Yes	NULL
uid	int(10)	Yes	0	users -> uid
type	varchar(16)	Yes
message	longtext	Yes
severity	tinyint(3)	Yes	0
link	varchar(255)	Yes
location	varchar(128)	Yes
referer	varchar(128)	Yes
hostname	varchar(128)	Yes
timestamp	int(11)	Yes	0