Drupal Internals

Most people are content with operating a software system like a car. They use the door to get in, the key to start it, and the steering wheel to make it go where they want to go. Most software system documentation is designed for those folks, and god bless writers who attempt the task of making it easy for them. Making things easy is a hard job.

It's a different story, though, when you are trying to modify the software system and bend it to your will. The documentation for this kind of manipulation is harder to find, in large part because once you've changed things, the first kind of documentation diverges from your modified system, support is harder to find, and you are on your own in many ways. That said, though, the end-results can be spectacular and are the only way that an existing system can evolve.

This guide is written for my own use as I explore, troubleshoot, and extend Drupal 4.6.3, but if it can be of use to others, you are welcome to use it.

core

This section addresses the SQL tables and workflow in Drupal 4.6.3 core modules. The formal Drupal function API is available on the DrupalDocs site.

core tables

access table

Field name Type Allow nulls? Key Default value Extras
aid tinyint(10) No Primary   auto_increment 
mask varchar(255) No None    
type varchar(255) No None    
status tinyint(2) No None 0   

accesslog table

Field name Type Allow nulls? Key Default value Extras
aid int(10) No Primary   auto_increment 
title varchar(255) Yes None    
path varchar(255) Yes None    
url varchar(255) Yes None    
hostname varchar(128) Yes None    
uid int(10) unsigned Yes None 0   
timestamp int(11) unsigned No Indexed 0   

authmap table

Field name Type Allow nulls? Key Default value Extras
aid int(10) unsigned No Primary   auto_increment 
uid int(10) No None 0   
authname varchar(128) No None    
module varchar(128) No None    

boxes table

Field name Type Allow nulls? Key Default value Extras
bid tinyint(4) No Primary   auto_increment 
title varchar(64) No None    
body longtext Yes None    
info varchar(128) No None    
format int(4) No None 0   

cache table

Field name Type Allow nulls? Key Default value Extras
cid varchar(255) No Primary    
data longtext Yes None    
expire int(11) No Indexed 0   
created int(11) No None 0   
headers text Yes None    

directory table

Field name Type Allow nulls? Key Default value Extras
link varchar(255) No Primary    
name varchar(128) No None    
mail varchar(128) No None    
slogan longtext No None    
mission longtext No None    
timestamp int(11) No None 0   

file table

Field name Type Allow nulls? Key Default value Extras
fid int(10) unsigned No Primary 0   
area varchar(255) No None    
directory tinyint(3) No None 0   
filename varchar(255) No None    
mimetype varchar(255) No None    
size int(12) No None 0   
active char(1) No None    
working char(1) No None    
private char(1) No None    

files table

Field name Type Allow nulls? Key Default value Extras
fid int(10) unsigned No Primary 0   
nid int(10) unsigned No None 0   
filename varchar(255) No None    
filepath varchar(255) No None    
filemime varchar(255) No None    
filesize int(10) unsigned No None 0   
list tinyint(1) unsigned No None 0   

flood table

Field name Type Allow nulls? Key Default value Extras
event varchar(64) No None    
hostname varchar(128) No None    
timestamp int(11) No None 0   

history table

Field name Type Allow nulls? Key Default value Extras
uid int(10) No Primary 0   
nid int(10) No Primary 0   
timestamp int(11) No None 0   

moderation_filters table

Field name Type Allow nulls? Key Default value Extras
fid int(10) unsigned No Primary   auto_increment 
filter varchar(255) No None    
minimum smallint(6) No None 0   

moderation_roles table

Field name Type Allow nulls? Key Default value Extras
rid int(10) unsigned No Indexed 0   
mid int(10) unsigned No Indexed 0   
value tinyint(4) No None 0   

moderation_votes table

Field name Type Allow nulls? Key Default value Extras
mid int(10) unsigned No Primary   auto_increment 
vote varchar(255) Yes None    
weight tinyint(4) No None 0   

permission table

Field name Type Allow nulls? Key Default value Extras
rid int(10) unsigned No Indexed 0   
perm longtext Yes None    
tid int(10) unsigned No None 0   

role table

Field name Type Allow nulls? Key Default value Extras
rid int(10) unsigned No Primary   auto_increment 
name varchar(32) No None    

sequences table

Field name Type Allow nulls? Key Default value Extras
name varchar(255) No Primary    
id int(10) unsigned No None 0   

sessions table

Field name Type Allow nulls? Key Default value Extras
uid int(10) unsigned No Indexed 0   
sid varchar(32) No Primary    
hostname varchar(128) No None    
timestamp int(11) No Indexed 0   
session longtext Yes None    

system table

Field name Type Allow nulls? Key Default value Extras
filename varchar(255) No Primary    
name varchar(255) No None    
type varchar(255) No None    
description varchar(255) No None    
status int(2) No None 0   
throttle tinyint(1) No None 0   
bootstrap int(2) No None 0   

term_data table

Field name Type Allow nulls? Key Default value Extras
tid int(10) unsigned No Primary   auto_increment 
vid int(10) unsigned No Indexed 0   
name varchar(255) No None    
description longtext Yes None    
weight tinyint(4) No None 0   

term_hierarchy table

Field name Type Allow nulls? Key Default value Extras
tid int(10) unsigned No Indexed 0   
parent int(10) unsigned No Indexed 0   

term_node table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
tid int(10) unsigned No Primary 0   

term_relation table

Field name Type Allow nulls? Key Default value Extras
tid1 int(10) unsigned No Indexed 0   
tid2 int(10) unsigned No Indexed 0   

term_synonym table

Field name Type Allow nulls? Key Default value Extras
tid int(10) unsigned No Indexed 0   
name varchar(255) No Indexed    

url_alias table

Field name Type Allow nulls? Key Default value Extras
pid int(10) unsigned No Primary   auto_increment 
src varchar(128) No None    
dst varchar(128) No None    

users table

Field name Type Allow nulls? Key Default value Extras
uid int(10) unsigned No Primary 0   
name varchar(60) No None    
pass varchar(32) No None    
mail varchar(64) Yes None    
mode tinyint(1) No None 0   
sort tinyint(1) Yes None 0   
threshold tinyint(1) Yes None 0   
theme varchar(255) No None    
signature varchar(255) No None    
created int(11) No None 0   
changed int(11) No Indexed 0   
status tinyint(4) No None 0   
timezone varchar(8) Yes None    
language varchar(12) No None    
picture varchar(255) No None    
init varchar(64) Yes None    
data longtext Yes None    

users_roles table

Field name Type Allow nulls? Key Default value Extras
uid int(10) unsigned No Primary 0   
rid int(10) unsigned No Primary 0   

variable table

Field name Type Allow nulls? Key Default value Extras
name varchar(48) No Primary    
value longtext No None    

vocabulary table

Field name Type Allow nulls? Key Default value Extras
vid int(10) unsigned No Primary   auto_increment 
name varchar(255) No None    
description longtext Yes None    
help varchar(255) No None    
relations tinyint(3) unsigned No None 0   
hierarchy tinyint(3) unsigned No None 0   
multiple tinyint(3) unsigned No None 0   
required tinyint(3) unsigned No None 0   
module varchar(255) No None    
weight tinyint(4) No None 0   

vocabulary_node_types table

Field name Type Allow nulls? Key Default value Extras
vid int(10) unsigned No Primary 0   
type varchar(16) No Primary    

aggregator module

aggregator_category

Field name Type Allow nulls? Key Default value Extras
cid int(10) No Primary   auto_increment 
title varchar(255) No None    
description longtext No None    
block tinyint(2) No None 0   

aggregator_category_feed

Field name Type Allow nulls? Key Default value Extras
fid int(10) No Primary 0   
cid int(10) No Primary 0   

aggregator_category_item

Field name Type Allow nulls? Key Default value Extras
iid int(10) No Primary 0   
cid int(10) No Primary 0   

aggregator_feed

Field name Type Allow nulls? Key Default value Extras
fid int(10) No Primary   auto_increment 
title varchar(255) No None    
url varchar(255) No None    
refresh int(10) No None 0   
checked int(10) No None 0   
link varchar(255) No None    
description longtext No None    
image longtext No None    
etag varchar(255) No None    
modified int(10) No None 0   
block tinyint(2) No None 0   

aggregator_item

Field name Type Allow nulls? Key Default value Extras
iid int(10) No Primary   auto_increment 
fid int(10) No None 0   
title varchar(255) No None    
link varchar(255) No None    
author varchar(255) No None    
description longtext No None    
timestamp int(11) Yes None    

block module

blocks table

Field name Type Allow nulls? Key Default value Extras
module varchar(64) No None    
delta varchar(32) No None 0   
status tinyint(2) No None 0   
weight tinyint(1) No None 0   
region tinyint(1) No None 0   
custom tinyint(2) No None 0   
throttle tinyint(1) No None 0   
visibility tinyint(1) No None 0   
pages text No None    
types text No None    

book module

book table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
parent int(10) No Indexed 0   
weight tinyint(3) No None 0   
log longtext Yes None    

comment module

comments table

Field name Type Allow nulls? Key Default value Extras
cid int(10) No Primary   auto_increment 
pid int(10) No None 0   
nid int(10) No Indexed 0   
uid int(10) No None 0   
subject varchar(64) No None    
comment longtext No None    
hostname varchar(128) No None    
timestamp int(11) No None 0   
score mediumint(9) No None 0   
status tinyint(3) unsigned No None 0   
format int(4) No None 0   
thread varchar(255) No None    
users longtext Yes None    
name varchar(60) Yes None    
mail varchar(64) Yes None    
homepage varchar(255) Yes None    

filter module

filters table

Field name Type Allow nulls? Key Default value Extras
format int(4) No None 0   
module varchar(64) No None    
delta tinyint(2) No None 0   
weight tinyint(2) No Indexed 0   

filter_formats table

Field name Type Allow nulls? Key Default value Extras
format int(4) No Primary   auto_increment 
name varchar(255) No None    
roles varchar(255) No None    
cache tinyint(2) No None 0   

forum module

forum table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
tid int(10) unsigned No Indexed 0   

locale module

locales_meta table

Field name Type Allow nulls? Key Default value Extras
locale varchar(12) No Primary    
name varchar(64) No None    
enabled int(2) No None 0   
isdefault int(2) No None 0   
plurals int(1) No None 0   
formula varchar(128) No None    

locales_source table

Field name Type Allow nulls? Key Default value Extras
lid int(11) No Primary   auto_increment 
location varchar(255) No None    
source blob No None    

locales_target table

Field name Type Allow nulls? Key Default value Extras
lid int(11) No Indexed 0   
translation blob No None    
locale varchar(12) No Indexed    
plid int(11) No Indexed 0   
plural int(1) No Indexed 0   

menu module

menu table

Field name Type Allow nulls? Key Default value Extras
mid int(10) unsigned No Primary 0   
pid int(10) unsigned No None 0   
path varchar(255) No None    
title varchar(255) No None    
description varchar(255) No None    
weight tinyint(4) No None 0   
type int(2) unsigned No None 0   

node module

node table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary   auto_increment 
type varchar(16) No Indexed    
title varchar(128) No Indexed    
uid int(10) No Indexed 0   
status int(4) No Indexed 1   
created int(11) No Indexed 0   
changed int(11) No Indexed 0   
comment int(2) No None 0   
promote int(2) No Indexed 0   
moderate int(2) No Indexed 0   
teaser longtext No None    
body longtext No None    
revisions longtext No None    
sticky int(2) No None 0   
format int(4) No None 0   

node_access table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
gid int(10) unsigned No Primary 0   
realm varchar(255) No Primary    
grant_view tinyint(1) unsigned No None 0   
grant_update tinyint(1) unsigned No None 0   
grant_delete tinyint(1) unsigned No None 0   

node_comment_statistics table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary   auto_increment 
last_comment_timestamp int(11) No Indexed 0   
last_comment_name varchar(60) Yes None    
last_comment_uid int(10) No None 0   
comment_count int(10) unsigned No None 0   

node_counter table

Field name Type Allow nulls? Key Default value Extras
nid int(11) No Primary 0   
totalcount bigint(20) unsigned No Indexed 0   
daycount mediumint(8) unsigned No Indexed 0   
timestamp int(11) unsigned No Indexed 0   

node_revisions table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
vid int(10) unsigned No Primary 0   
uid int(10) No Indexed 0   
title varchar(128) No None    
body longtext No None    
teaser longtext No None    
log longtext No None    
timestamp int(11) No None 0   
format int(4) No None 0   

poll module

poll table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
runtime int(10) No None 0   
polled longtext No None    
active int(2) unsigned No None 0   

poll_choices table

Field name Type Allow nulls? Key Default value Extras
chid int(10) unsigned No Primary   auto_increment 
nid int(10) unsigned No Indexed 0   
chtext varchar(128) No None    
chvotes int(6) No None 0   
chorder int(2) No None 0   

profile module

profile_fields table

Field name Type Allow nulls? Key Default value Extras
fid int(10) No Primary   auto_increment 
title varchar(255) Yes None    
name varchar(128) Yes Indexed    
explanation text Yes None    
category varchar(255) Yes Indexed    
page varchar(255) Yes None    
type varchar(128) Yes None    
weight tinyint(1) No None 0   
required tinyint(1) No None 0   
register tinyint(1) No None 0   
visibility tinyint(1) No None 0   
options text Yes None    

profile_values table

Field name Type Allow nulls? Key Default value Extras
fid int(10) unsigned Yes Indexed 0   
uid int(10) unsigned Yes Indexed 0   
value text Yes None    

queue module

queue table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
uid int(10) unsigned No Primary 0   
vote int(3) No None 0   

search module

search_index table

Field name Type Allow nulls? Key Default value Extras
word varchar(50) No Indexed    
sid int(10) unsigned No Indexed 0   
type varchar(16) Yes None    
fromsid int(10) unsigned No Indexed 0   
fromtype varchar(16) Yes None    
score int(10) unsigned Yes None    

search_total table

Field name Type Allow nulls? Key Default value Extras
word varchar(50) No Primary    
count int(10) unsigned Yes None    

watchdog module

watchdog table

Field name Type Allow nulls? Key Default value Extras
wid int(5) No Primary   auto_increment 
uid int(10) No None 0   
type varchar(16) No None    
message longtext No None    
severity tinyint(3) unsigned No None 0   
link varchar(255) No None    
location varchar(128) No None    
hostname varchar(128) No None    
timestamp int(11) No None 0   

contributed modules

This section addresses the SQL tables and functions making up Drupal contributed modules.

attachment module

This module is an alternative to Drupal's included upload module. It uses the filemanager module to allow a unique namespace per node and support large number of files. In addition this module allows you to give each attachment a title and description.

attachment table

Field name Type Allow nulls? Key Default value Extras
aid int(10) unsigned No Primary 0   
nid int(10) unsigned No None 0   
fid int(10) unsigned No None 0   
filename varchar(255) No None    
title varchar(255) No None    
description varchar(255) No None    
size int(12) No None 0   
hidden char(1) No None    

chatbox module

This is a simple chatbox module. It allows your site's visitors to chat in an HTML interface.

chatevents table

Field name Type Allow nulls? Key Default value Extras
id int(11) No Primary   auto_increment 
body varchar(255) No None    
timestamp int(11) No None 0   

chatmembers table

Field name Type Allow nulls? Key Default value Extras
id int(11) No Primary   auto_increment 
nick varchar(32) No None    
timestamp int(11) No None 0   

filestore2 module

a completely rewritten version of filestore which stores the files on the filesystem instead of in the database.

filestore2 table

Field name Type Allow nulls? Key Default value Extras
fid int(11) unsigned No Primary 0   
nid int(11) No Indexed 0   
fsid int(11) No None 0   
author text No None    
version text No None    
url text No None    
downloads int(11) No None 0   

folksonomy module

An API for module developers for enabling simple non hierarchical classification. This module enables tag based applications like Flickr [1] and Delicio.us [2]. This module doesn't actually do anything on its own. It will be used within photo gallery modules, bookmark modules, song modules, and more. Don't bother installing this module unless some other module instructs you to so.

folksonomy table

Field name Type Allow nulls? Key Default value Extras
id int(11) No Primary 0   
realm varchar(100) No Primary    
name varchar(255) No Primary    
weight int(11) No None 0   

fscache module

a file system cache which allows storing of files on the filesystem of your web site. This module is used by filestore2 to ease the maintenace of files uploaded to the website.

fscache table

Field name Type Allow nulls? Key Default value Extras
fsid int(10) unsigned No Primary 0   
filename text No None    
cachename varchar(255) No Indexed    
mimetype varchar(255) No None application/octet-stream   
md5 varchar(255) No Indexed    
size int(11) No None 0   
type varchar(255) No None    
status varchar(10) No None    
created int(11) No None 0   

gsitemap module

The Google Sitemap module creates a XML sitemap in accordance with the Google specification.

gsitemap table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
last_changed int(11) Yes None    
previously_changed int(11) Yes None    
last_comment int(11) Yes None    
previous_comment int(11) Yes None    
priority_override decimal(2,1) Yes None    

img_assist module

This module allows users to upload and insert images into posts. It automatically generates an image icon next to the textarea fields of you choice. Clicking the icon opens an image browsing window, displaying all images that have been uploaded through image module, upload module or img_assist. Images can be filtered by ownership or taxonomic terms (categories).

img_assist_map table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
iid int(10) unsigned No Primary 0   

libdb module

libdb_annotations

Field name Type Allow nulls? Key Default value Extras
id varchar(20) No None    
referer_table varchar(50) No None    
referer_id varchar(20) No None    
annotation_type_id varchar(20) No None    
annotation text No None    
referent_table varchar(50) No None    
referent_id varchar(20) No None    

listhandler module

Listhandler is a module that aims at inserting mailing list discussions in Drupal forum and vice versa.

listhandler table

Field name Type Allow nulls? Key Default value Extras
lid int(10) unsigned No Primary   auto_increment 
msgid varchar(255) No None    
nid int(10) No None 0   
cid int(10) No None 0   
pid int(10) No None 0   
uid int(10) No None 0   
mid int(10) No None 0   
tid int(10) No None 0   

mailhandler module

The Mailhandler module allows registered users to create or edit nodes and comments via email. Authentication is usually based on the From: email address. Users may post taxonomy terms, teasers, and other node parameters using the Commands capability.

mailhandler table

Field name Type Allow nulls? Key Default value Extras
mid int(10) unsigned No Primary   auto_increment 
mail varchar(255) No Indexed    
domain varchar(255) No None    
port int(5) unsigned No None 0   
name varchar(255) No None    
pass varchar(255) No None    
security tinyint(3) unsigned No None 0   
mime varchar(128) Yes None    
replies tinyint(3) unsigned No None 1   
fromheader varchar(128) Yes None    
commands text Yes None    
sigseparator text No None    
enabled tinyint(4) Yes None    
folder varchar(255) No None    
imap tinyint(3) unsigned No None 0   
mailto varchar(255) No None    
delete_after_read tinyint(3) unsigned No None 1   
extraimap varchar(255) No None    
format int(4) No None 0   
prefix varchar(255) No None    

og module

og table

Field name Type Allow nulls? Key Default value Extras
nid int(11) No Primary 0   
selective int(11) No None 0   
description varchar(255) Yes None    
image varchar(255) Yes None    
theme varchar(255) Yes None    
register int(1) No None 0   
directory int(11) No None 1   

og_uid table

Field name Type Allow nulls? Key Default value Extras
nid int(11) No Primary 0   
uid int(11) No Primary 0   
mail_type int(11) Yes None    

privatemsg module

This module allows your site's visitors to send private messages to each other.

privatemsg table

Field name Type Allow nulls? Key Default value Extras
id int(10) unsigned No Primary   auto_increment 
author int(10) unsigned No None 0   
recipient int(10) unsigned No Indexed 0   
subject varchar(64) No None    
message text Yes None    
timestamp int(11) unsigned No None 0   
newmsg tinyint(3) unsigned No None 0   
hostname varchar(255) No None    
folder int(10) unsigned No Indexed 0   
author_del tinyint(3) unsigned No None 0   
recipient_del tinyint(3) unsigned No None 0   
format int(4) No None 0   

privatemsg_archive table

Field name Type Allow nulls? Key Default value Extras
id int(10) unsigned No Primary   auto_increment 
author int(10) unsigned No None 0   
recipient int(10) unsigned No Indexed 0   
subject varchar(64) No None    
message text No None    
timestamp int(11) unsigned No None 0   
hostname varchar(255) No None    
folder int(10) unsigned No None 0   
format int(4) No None 0   

privatemsg_folder table

Field name Type Allow nulls? Key Default value Extras
fid int(10) unsigned No Primary   auto_increment 
uid int(10) unsigned No None 0   
name varchar(255) No None    

project module

This module enables teams to track outstanding items which need resolution. It provides e-mail notifications to members about updates to items. Similar to many issue tracking systems.

project_comments table

Field name Type Allow nulls? Key Default value Extras
cid int(10) unsigned No Primary 0   
nid int(10) unsigned No Indexed 0   
uid int(10) unsigned No None 0   
name varchar(255) No None    
created int(10) unsigned No None 0   
changed int(10) unsigned No None 0   
body blob Yes None    
data blob Yes None    
file_path varchar(255) No None    
file_mime varchar(255) No None    
file_size int(11) No None 0   

project_issues table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
pid int(10) unsigned No Indexed 0   
category varchar(255) No None    
component varchar(255) No None    
priority tinyint(3) unsigned No None 0   
rid int(10) unsigned No None 0   
assigned int(10) unsigned No None 0   
sid int(10) unsigned No None 0   
file_path varchar(255) No None    
file_mime varchar(255) No None    
file_size int(11) No None 0   

project_issue_state table

Field name Type Allow nulls? Key Default value Extras
sid int(10) unsigned No Primary   auto_increment 
name varchar(32) No None    
weight tinyint(2) No None 0   
author_has tinyint(2) No None 0   

project_projects table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
uri varchar(50) No Indexed    
homepage varchar(255) No None    
changelog varchar(255) No None    
cvs varchar(255) No None    
demo varchar(255) No None    
release_directory varchar(255) No None    
issues tinyint(4) No None 0   
components text Yes None    
version int(10) unsigned No None 0   
mail varchar(255) No None    
mail_digest varchar(255) No None    
mail_copy varchar(255) No None    
mail_copy_filter varchar(255) No None    
mail_reminder tinyint(4) No None 0   
help text Yes None    
screenshots varchar(255) No None    
mail_copy_filter_state varchar(255) No None    
documentation varchar(255) No None    
license varchar(255) No None    

project_releases table

Field name Type Allow nulls? Key Default value Extras
rid int(10) unsigned No Primary 0   
nid int(10) unsigned No Indexed 0   
fid int(10) unsigned No None 0   
path varchar(255) No None    
created int(10) unsigned No None 0   
version varchar(255) No None    
changes text Yes None    
weight tinyint(3) unsigned No None 0   
changed int(10) unsigned No None 0   
status tinyint(1) unsigned No None 1   

project_subscriptions table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Indexed 0   
uid int(10) unsigned No None 0   
level tinyint(3) unsigned No None 0   

quotes module

quotes table

Field name Type Allow nulls? Key Default value Extras
nid int(11) No Primary 0   
author varchar(255) No None    
promote int(11) No None 0   

quotes_blocks table

Field name Type Allow nulls? Key Default value Extras
bid int(11) No Primary 0   
name varchar(255) No None    
title varchar(255) No None    
block_type int(11) No None 0   
nid_filter text No None    
rid_filter text No None    
uid_filter text No None    
tid_filter text No None    

trackback module

Adds TrackBack support to Drupal. Sending and retrieval of TrackBacks are supported either using POST or GET.

trackback_node table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
awaiting_cron tinyint(1) No None 0   
can_receive tinyint(1) No None 0   

trackback_received table

Field name Type Allow nulls? Key Default value Extras
trid int(10) unsigned No Primary 0   
nid int(10) unsigned No Indexed 0   
created int(11) No None 0   
site varchar(255) No None    
name varchar(60) Yes None    
subject varchar(64) No None    
url varchar(255) No None    
excerpt varchar(255) No None    
status tinyint(1) unsigned Yes None 0   

trackback_sent table

Field name Type Allow nulls? Key Default value Extras
nid int(10) unsigned No Primary 0   
url varchar(255) No Primary    
successful tinyint(1) No None 0   

wghtml module

wgHTML imports and incorporates static HTML pages into Drupal.

You can find out more about this module at http://www.webg8.com/h/wghtml where support for this module is quicker than on drupal.org

wghtml_pages table

Field name Type Allow nulls? Key Default value Extras
pageId int(8) unsigned No Primary   auto_increment 
identity varchar(32) No Indexed    
current int(8) No None 0   

wghtml_versions table

Field name Type Allow nulls? Key Default value Extras
pageId int(8) unsigned No Primary 0   
version int(8) No Primary 0   
node int(8) unsigned No None 0   
perm_area varchar(32) Yes None    
raw text Yes None    
title text Yes None    
head text Yes None    
body text Yes None    
bodyattrib text Yes None    
linkto text Yes None    
signature int(10) unsigned Yes None    
cachetime int(10) unsigned Yes None