Druckansicht - phpMyAdmin 4.8.3

nuke_authors

Spalte	Typ	Null	Standard
aid (Primärschlüssel)	varchar(25)	Nein
name	varchar(50)	Ja	NULL
url	varchar(255)	Nein
email	varchar(255)	Nein
pwd	varchar(40)	Ja	NULL
counter	int(11)	Nein	0
radminarticle	tinyint(2)	Nein	0
radmintopic	tinyint(2)	Nein	0
radminuser	tinyint(2)	Nein	0
radminsurvey	tinyint(2)	Nein	0
radminsection	tinyint(2)	Nein	0
radminlink	tinyint(2)	Nein	0
radminephem	tinyint(2)	Nein	0
radminfaq	tinyint(2)	Nein	0
radmindownload	tinyint(2)	Nein	0
radminreviews	tinyint(2)	Nein	0
radminnewsletter	tinyint(2)	Nein	0
radminforum	tinyint(2)	Nein	0
radmincontent	tinyint(2)	Nein	0
radminency	tinyint(2)	Nein	0
radminsuper	tinyint(2)	Nein	1
admlanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	aid	3	A	Nein
aid	BTREE	Nein	Nein	aid	3	A	Nein

nuke_autonews

Spalte	Typ	Null	Standard
anid (Primärschlüssel)	int(11)	Nein
catid	int(11)	Nein	0
aid	varchar(30)	Nein
title	varchar(80)	Nein
time	varchar(19)	Nein
hometext	text	Nein
bodytext	text	Nein
topic	int(3)	Nein	1
informant	varchar(20)	Nein
notes	text	Nein
ihome	int(1)	Nein	0
alanguage	varchar(30)	Nein
acomm	int(1)	Nein	0
associated	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	anid	0	A	Nein
anid	BTREE	Nein	Nein	anid	0	A	Nein

nuke_banner

Spalte	Typ	Null	Standard
bid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
imptotal	int(11)	Nein	0
impmade	int(11)	Nein	0
clicks	int(11)	Nein	0
imageurl	varchar(100)	Nein
clickurl	varchar(200)	Nein
alttext	varchar(255)	Nein
date	datetime	Ja	NULL
dateend	datetime	Ja	NULL
type	tinyint(1)	Nein	0
active	tinyint(1)	Nein	1

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	bid	A	Nein
bid	BTREE	Nein	Nein	bid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein

nuke_bannerclient

Spalte	Typ	Null
cid (Primärschlüssel)	int(11)	Nein
name	varchar(60)	Nein
contact	varchar(60)	Nein
email	varchar(60)	Nein
login	varchar(10)	Nein
passwd	varchar(10)	Nein
extrainfo	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	cid	0	A	Nein
cid	BTREE	Nein	Nein	cid	0	A	Nein

nuke_bbauth_access

Spalte	Typ	Null
group_id	mediumint(8)	Nein
forum_id	smallint(5)	Nein
auth_view	tinyint(1)	Nein
auth_read	tinyint(1)	Nein
auth_post	tinyint(1)	Nein
auth_reply	tinyint(1)	Nein
auth_edit	tinyint(1)	Nein
auth_delete	tinyint(1)	Nein
auth_sticky	tinyint(1)	Nein
auth_announce	tinyint(1)	Nein
auth_vote	tinyint(1)	Nein
auth_pollcreate	tinyint(1)	Nein
auth_attachments	tinyint(1)	Nein
auth_mod	tinyint(1)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
group_id	BTREE	Nein	Nein	group_id	0	A	Nein
forum_id	BTREE	Nein	Nein	forum_id	0	A	Nein

nuke_bbbanlist

Spalte	Typ	Null	Standard
ban_id (Primärschlüssel)	mediumint(8)	Nein
ban_userid	mediumint(8)	Nein	0
ban_ip	varchar(8)	Nein
ban_email	varchar(255)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	ban_id	A	Nein
ban_ip_user_id	BTREE	Nein	Nein	ban_ip	A	Nein
ban_ip_user_id	BTREE	Nein	Nein	ban_userid	A	Nein

nuke_bbcategories

Spalte	Typ	Null	Standard
cat_id (Primärschlüssel)	mediumint(8)	Nein
cat_title	varchar(100)	Ja	NULL
cat_order	mediumint(8)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	cat_id	0	A	Nein
cat_order	BTREE	Nein	Nein	cat_order	0	A	Nein

nuke_bbconfig

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
config_name (Primärschlüssel)	varchar(255)	Nein
config_value	varchar(255)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	config_name	61	A	Nein

nuke_bbdisallow

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
disallow_id (Primärschlüssel)	mediumint(8)	Nein
disallow_username	varchar(25)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	disallow_id	0	A	Nein

nuke_bbforums

Spalte	Typ	Null	Standard
forum_id (Primärschlüssel)	smallint(5)	Nein
cat_id	mediumint(8)	Nein	0
forum_name	varchar(150)	Ja	NULL
forum_desc	text	Ja	NULL
forum_status	tinyint(4)	Nein	0
forum_order	mediumint(8)	Nein	1
forum_posts	mediumint(8)	Nein	0
forum_topics	mediumint(8)	Nein	0
forum_last_post_id	mediumint(8)	Nein	0
prune_next	int(11)	Ja	NULL
prune_enable	tinyint(1)	Nein	1
auth_view	tinyint(2)	Nein	0
auth_read	tinyint(2)	Nein	0
auth_post	tinyint(2)	Nein	0
auth_reply	tinyint(2)	Nein	0
auth_edit	tinyint(2)	Nein	0
auth_delete	tinyint(2)	Nein	0
auth_sticky	tinyint(2)	Nein	0
auth_announce	tinyint(2)	Nein	0
auth_vote	tinyint(2)	Nein	0
auth_pollcreate	tinyint(2)	Nein	0
auth_attachments	tinyint(2)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	forum_id	A	Nein
forums_order	BTREE	Nein	Nein	forum_order	A	Nein
cat_id	BTREE	Nein	Nein	cat_id	A	Nein
forum_last_post_id	BTREE	Nein	Nein	forum_last_post_id	A	Nein

nuke_bbforum_prune

Spalte	Typ	Null	Standard
prune_id (Primärschlüssel)	mediumint(8)	Nein
forum_id	smallint(5)	Nein	0
prune_days	tinyint(4)	Nein	0
prune_freq	tinyint(4)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	prune_id	0	A	Nein
forum_id	BTREE	Nein	Nein	forum_id	0	A	Nein

nuke_bbgroups

Spalte	Typ	Null	Standard
group_id (Primärschlüssel)	mediumint(8)	Nein
group_type	tinyint(4)	Nein	1
group_name	varchar(40)	Nein
group_description	varchar(255)	Nein
group_moderator	mediumint(8)	Nein	0
group_single_user	tinyint(1)	Nein	1

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	group_id	2	A	Nein
group_single_user	BTREE	Nein	Nein	group_single_user	2	A	Nein

nuke_bbposts

Spalte	Typ	Null	Standard
post_id (Primärschlüssel)	mediumint(8)	Nein
topic_id	mediumint(8)	Nein	0
forum_id	smallint(5)	Nein	0
poster_id	mediumint(8)	Nein	0
post_time	int(11)	Nein	0
poster_ip	varchar(8)	Nein
post_username	varchar(25)	Ja	NULL
enable_bbcode	tinyint(1)	Nein	1
enable_html	tinyint(1)	Nein	0
enable_smilies	tinyint(1)	Nein	1
enable_sig	tinyint(1)	Nein	1
post_edit_time	int(11)	Ja	NULL
post_edit_count	smallint(5)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	post_id	A	Nein
forum_id	BTREE	Nein	Nein	forum_id	A	Nein
topic_id	BTREE	Nein	Nein	topic_id	A	Nein
poster_id	BTREE	Nein	Nein	poster_id	A	Nein
post_time	BTREE	Nein	Nein	post_time	A	Nein

nuke_bbposts_text

Spalte	Typ	Null	Standard
post_id (Primärschlüssel)	mediumint(8)	Nein	0
bbcode_uid	varchar(10)	Nein
post_subject	varchar(60)	Ja	NULL
post_text	text	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	post_id	0	A	Nein

nuke_bbprivmsgs

Spalte	Typ	Null	Standard
privmsgs_id (Primärschlüssel)	mediumint(8)	Nein
privmsgs_type	tinyint(4)	Nein	0
privmsgs_subject	varchar(255)	Nein	0
privmsgs_from_userid	mediumint(8)	Nein	0
privmsgs_to_userid	mediumint(8)	Nein	0
privmsgs_date	int(11)	Nein	0
privmsgs_ip	varchar(8)	Nein
privmsgs_enable_bbcode	tinyint(1)	Nein	1
privmsgs_enable_html	tinyint(1)	Nein	0
privmsgs_enable_smilies	tinyint(1)	Nein	1
privmsgs_attach_sig	tinyint(1)	Nein	1

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	privmsgs_id	A	Nein
privmsgs_from_userid	BTREE	Nein	Nein	privmsgs_from_userid	A	Nein
privmsgs_to_userid	BTREE	Nein	Nein	privmsgs_to_userid	A	Nein

nuke_bbprivmsgs_text

Spalte	Typ	Null	Standard
privmsgs_text_id (Primärschlüssel)	mediumint(8)	Nein	0
privmsgs_bbcode_uid	varchar(10)	Nein	0
privmsgs_text	text	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	privmsgs_text_id	0	A	Nein

nuke_bbranks

Spalte	Typ	Null	Standard
rank_id (Primärschlüssel)	smallint(5)	Nein
rank_title	varchar(50)	Nein
rank_min	mediumint(8)	Nein	0
rank_max	mediumint(8)	Nein	0
rank_special	tinyint(1)	Ja	0
rank_image	varchar(255)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	rank_id	2	A	Nein

nuke_bbsearch_results

Spalte	Typ	Null	Standard
search_id (Primärschlüssel)	int(11)	Nein	0
session_id	varchar(32)	Nein
search_array	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	search_id	0	A	Nein
session_id	BTREE	Nein	Nein	session_id	0	A	Nein

nuke_bbsearch_wordlist

Spalte	Typ	Null	Standard
word_text (Primärschlüssel)	varchar(50)	Nein
word_id	mediumint(8)	Nein
word_common	tinyint(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	word_text	0	A	Nein
word_id	BTREE	Nein	Nein	word_id	0	A	Nein

nuke_bbsearch_wordmatch

Spalte	Typ	Null
post_id	mediumint(8)	Nein
word_id	mediumint(8)	Nein
title_match	tinyint(1)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
word_id	BTREE	Nein	Nein	word_id	0	A	Nein

nuke_bbsessions

Spalte	Typ	Null	Standard
session_id (Primärschlüssel)	char(32)	Nein
session_user_id	mediumint(8)	Nein	0
session_start	int(11)	Nein	0
session_time	int(11)	Nein	0
session_ip	char(8)	Nein	0
session_page	int(11)	Nein	0
session_logged_in	tinyint(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	session_id	300	A	Nein
session_user_id	BTREE	Nein	Nein	session_user_id	1	A	Nein
session_id_ip_user_id	BTREE	Nein	Nein	session_id	300	A	Nein
				session_ip	300	A	Nein
				session_user_id	300	A	Nein

nuke_bbsmilies

Spalte	Typ	Null	Standard
smilies_id (Primärschlüssel)	smallint(5)	Nein
code	varchar(50)	Ja	NULL
smile_url	varchar(100)	Ja	NULL
emoticon	varchar(75)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	smilies_id	44	A	Nein

nuke_bbthemes

Spalte	Typ	Null	Standard
themes_id (Primärschlüssel)	mediumint(8)	Nein
template_name	varchar(30)	Nein
style_name	varchar(30)	Nein
head_stylesheet	varchar(100)	Ja	NULL
body_background	varchar(100)	Ja	NULL
body_bgcolor	varchar(6)	Ja	NULL
body_text	varchar(6)	Ja	NULL
body_link	varchar(6)	Ja	NULL
body_vlink	varchar(6)	Ja	NULL
body_alink	varchar(6)	Ja	NULL
body_hlink	varchar(6)	Ja	NULL
tr_color1	varchar(6)	Ja	NULL
tr_color2	varchar(6)	Ja	NULL
tr_color3	varchar(6)	Ja	NULL
tr_class1	varchar(25)	Ja	NULL
tr_class2	varchar(25)	Ja	NULL
tr_class3	varchar(25)	Ja	NULL
th_color1	varchar(6)	Ja	NULL
th_color2	varchar(6)	Ja	NULL
th_color3	varchar(6)	Ja	NULL
th_class1	varchar(25)	Ja	NULL
th_class2	varchar(25)	Ja	NULL
th_class3	varchar(25)	Ja	NULL
td_color1	varchar(6)	Ja	NULL
td_color2	varchar(6)	Ja	NULL
td_color3	varchar(6)	Ja	NULL
td_class1	varchar(25)	Ja	NULL
td_class2	varchar(25)	Ja	NULL
td_class3	varchar(25)	Ja	NULL
fontface1	varchar(50)	Ja	NULL
fontface2	varchar(50)	Ja	NULL
fontface3	varchar(50)	Ja	NULL
fontsize1	tinyint(4)	Ja	NULL
fontsize2	tinyint(4)	Ja	NULL
fontsize3	tinyint(4)	Ja	NULL
fontcolor1	varchar(6)	Ja	NULL
fontcolor2	varchar(6)	Ja	NULL
fontcolor3	varchar(6)	Ja	NULL
span_class1	varchar(25)	Ja	NULL
span_class2	varchar(25)	Ja	NULL
span_class3	varchar(25)	Ja	NULL
img_size_poll	smallint(5)	Ja	NULL
img_size_privmsg	smallint(5)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	themes_id	0	A	Nein

nuke_bbthemes_name

Spalte	Typ	Null	Standard
themes_id (Primärschlüssel)	smallint(5)	Nein	0
tr_color1_name	char(50)	Ja	NULL
tr_color2_name	char(50)	Ja	NULL
tr_color3_name	char(50)	Ja	NULL
tr_class1_name	char(50)	Ja	NULL
tr_class2_name	char(50)	Ja	NULL
tr_class3_name	char(50)	Ja	NULL
th_color1_name	char(50)	Ja	NULL
th_color2_name	char(50)	Ja	NULL
th_color3_name	char(50)	Ja	NULL
th_class1_name	char(50)	Ja	NULL
th_class2_name	char(50)	Ja	NULL
th_class3_name	char(50)	Ja	NULL
td_color1_name	char(50)	Ja	NULL
td_color2_name	char(50)	Ja	NULL
td_color3_name	char(50)	Ja	NULL
td_class1_name	char(50)	Ja	NULL
td_class2_name	char(50)	Ja	NULL
td_class3_name	char(50)	Ja	NULL
fontface1_name	char(50)	Ja	NULL
fontface2_name	char(50)	Ja	NULL
fontface3_name	char(50)	Ja	NULL
fontsize1_name	char(50)	Ja	NULL
fontsize2_name	char(50)	Ja	NULL
fontsize3_name	char(50)	Ja	NULL
fontcolor1_name	char(50)	Ja	NULL
fontcolor2_name	char(50)	Ja	NULL
fontcolor3_name	char(50)	Ja	NULL
span_class1_name	char(50)	Ja	NULL
span_class2_name	char(50)	Ja	NULL
span_class3_name	char(50)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	themes_id	0	A	Nein

nuke_bbtopics

Spalte	Typ	Null	Standard
topic_id (Primärschlüssel)	mediumint(8)	Nein
forum_id	smallint(8)	Nein	0
topic_title	char(60)	Nein
topic_poster	mediumint(8)	Nein	0
topic_time	int(11)	Nein	0
topic_views	mediumint(8)	Nein	0
topic_replies	mediumint(8)	Nein	0
topic_status	tinyint(3)	Nein	0
topic_vote	tinyint(1)	Nein	0
topic_type	tinyint(3)	Nein	0
topic_last_post_id	mediumint(8)	Nein	0
topic_first_post_id	mediumint(8)	Nein	0
topic_moved_id	mediumint(8)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	topic_id	A	Nein
forum_id	BTREE	Nein	Nein	forum_id	A	Nein
topic_moved_id	BTREE	Nein	Nein	topic_moved_id	A	Nein
topic_status	BTREE	Nein	Nein	topic_status	A	Nein
topic_type	BTREE	Nein	Nein	topic_type	A	Nein

nuke_bbtopics_watch

Spalte	Typ	Null
topic_id	mediumint(8)	Nein
user_id	mediumint(8)	Nein
notify_status	tinyint(1)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
topic_id	BTREE	Nein	Nein	topic_id	A	Nein
user_id	BTREE	Nein	Nein	user_id	A	Nein
notify_status	BTREE	Nein	Nein	notify_status	A	Nein

nuke_bbuser_group

Spalte	Typ	Null	Standard
group_id	mediumint(8)	Nein	0
user_id	mediumint(8)	Nein	0
user_pending	tinyint(1)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
group_id	BTREE	Nein	Nein	group_id	2	A	Nein
user_id	BTREE	Nein	Nein	user_id	2	A	Nein

nuke_bbvote_desc

Spalte	Typ	Null	Standard
vote_id (Primärschlüssel)	mediumint(8)	Nein
topic_id	mediumint(8)	Nein	0
vote_text	text	Nein
vote_start	int(11)	Nein	0
vote_length	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	vote_id	0	A	Nein
topic_id	BTREE	Nein	Nein	topic_id	0	A	Nein

nuke_bbvote_results

Spalte	Typ	Null	Standard
vote_id	mediumint(8)	Nein	0
vote_option_id	tinyint(4)	Nein	0
vote_option_text	varchar(255)	Nein
vote_result	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
vote_option_id	BTREE	Nein	Nein	vote_option_id	0	A	Nein
vote_id	BTREE	Nein	Nein	vote_id	0	A	Nein

nuke_bbvote_voters

Spalte	Typ	Null	Standard
vote_id	mediumint(8)	Nein	0
vote_user_id	mediumint(8)	Nein	0
vote_user_ip	char(8)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
vote_id	BTREE	Nein	Nein	vote_id	A	Nein
vote_user_id	BTREE	Nein	Nein	vote_user_id	A	Nein
vote_user_ip	BTREE	Nein	Nein	vote_user_ip	A	Nein

nuke_bbwords

Spalte	Typ	Null
word_id (Primärschlüssel)	mediumint(8)	Nein
word	char(100)	Nein
replacement	char(100)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	word_id	0	A	Nein

nuke_blocks

Spalte	Typ	Null	Standard
bid (Primärschlüssel)	int(10)	Nein
bkey	varchar(15)	Nein
title	varchar(60)	Nein
content	text	Nein
url	varchar(200)	Nein
bposition	char(1)	Nein
weight	int(10)	Nein	1
active	int(1)	Nein	1
refresh	int(10)	Nein	0
time	varchar(14)	Nein	0
blanguage	varchar(30)	Nein
blockfile	varchar(255)	Nein
view	int(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	bid	42	A	Nein
bid	BTREE	Nein	Nein	bid	42	A	Nein
title	BTREE	Nein	Nein	title	42	A	Nein

nuke_comments

Spalte	Typ	Null	Standard
tid (Primärschlüssel)	int(11)	Nein
pid	int(11)	Nein	0
sid	int(11)	Nein	0
date	datetime	Ja	NULL
name	varchar(60)	Nein
email	varchar(60)	Ja	NULL
url	varchar(60)	Ja	NULL
host_name	varchar(60)	Ja	NULL
subject	varchar(85)	Nein
comment	text	Nein
score	tinyint(4)	Nein	0
reason	tinyint(4)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	tid	A	Nein
tid	BTREE	Nein	Nein	tid	A	Nein
pid	BTREE	Nein	Nein	pid	A	Nein
sid	BTREE	Nein	Nein	sid	A	Nein

nuke_config

Spalte	Typ	Null	Standard
sitename	varchar(255)	Nein
nukeurl	varchar(255)	Nein
site_logo	varchar(255)	Nein
slogan	varchar(255)	Nein
startdate	varchar(50)	Nein
adminmail	varchar(255)	Nein
anonpost	tinyint(1)	Nein	0
Default_Theme	varchar(255)	Nein
foot1	text	Nein
foot2	text	Nein
foot3	text	Nein
commentlimit	int(9)	Nein	4096
anonymous	varchar(255)	Nein
minpass	tinyint(1)	Nein	5
pollcomm	tinyint(1)	Nein	1
articlecomm	tinyint(1)	Nein	1
broadcast_msg	tinyint(1)	Nein	1
my_headlines	tinyint(1)	Nein	1
top	int(3)	Nein	10
storyhome	int(2)	Nein	10
user_news	tinyint(1)	Nein	1
oldnum	int(2)	Nein	30
ultramode	tinyint(1)	Nein	0
banners	tinyint(1)	Nein	1
backend_title	varchar(255)	Nein
backend_language	varchar(10)	Nein
language	varchar(100)	Nein
locale	varchar(10)	Nein
multilingual	tinyint(1)	Nein	0
useflags	tinyint(1)	Nein	0
notify	tinyint(1)	Nein	0
notify_email	varchar(255)	Nein
notify_subject	varchar(255)	Nein
notify_message	varchar(255)	Nein
notify_from	varchar(255)	Nein
footermsgtxt	text	Nein
email_send	tinyint(1)	Nein	1
attachmentdir	varchar(255)	Nein
attachments	tinyint(1)	Nein	0
attachments_view	tinyint(1)	Nein	0
download_dir	varchar(255)	Nein
defaultpopserver	varchar(255)	Nein
singleaccount	tinyint(1)	Nein	0
singleaccountname	varchar(255)	Nein
numaccounts	tinyint(2)	Nein	-1
imgpath	varchar(255)	Nein
filter_forward	tinyint(1)	Nein	1
moderate	tinyint(1)	Nein	0
admingraphic	tinyint(1)	Nein	1
httpref	tinyint(1)	Nein	1
httprefmax	int(5)	Nein	1000
CensorMode	tinyint(1)	Nein	3
CensorReplace	varchar(10)	Nein
copyright	text	Nein
Version_Num	varchar(10)	Nein

nuke_contactbook

Spalte	Typ	Null	Standard
uid	int(11)	Nein	0
contactid (Primärschlüssel)	int(11)	Nein
firstname	varchar(50)	Ja	NULL
lastname	varchar(50)	Ja	NULL
email	varchar(255)	Ja	NULL
company	varchar(255)	Ja	NULL
homeaddress	varchar(255)	Ja	NULL
city	varchar(80)	Ja	NULL
homephone	varchar(255)	Ja	NULL
workphone	varchar(255)	Ja	NULL
homepage	varchar(255)	Ja	NULL
IM	varchar(255)	Ja	NULL
events	text	Ja	NULL
reminders	int(11)	Ja	NULL
notes	text	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	contactid	A	Nein
uid	BTREE	Nein	Nein	uid	A	Nein
contactid	BTREE	Nein	Nein	contactid	A	Nein

nuke_counter

Spalte	Typ	Null	Standard
type	varchar(80)	Nein
var	varchar(80)	Nein
count	int(10)	Nein	0

nuke_dis_er

Spalte	Typ	Null
dis_er_400	text	Nein
dis_er_400_tit	text	Nein
dis_er_401	text	Nein
dis_er_401_tit	text	Nein
dis_er_403	text	Nein
dis_er_403_tit	text	Nein
dis_er_404	text	Nein
dis_er_404_tit	text	Nein
dis_er_405	text	Nein
dis_er_405_tit	text	Nein
dis_er_406	text	Nein
dis_er_406_tit	text	Nein
dis_er_408	text	Nein
dis_er_408_tit	text	Nein
dis_er_410	text	Nein
dis_er_410_tit	text	Nein
dis_er_411	text	Nein
dis_er_411_tit	text	Nein
dis_er_414	text	Nein
dis_er_414_tit	text	Nein
dis_er_500	text	Nein
dis_er_500_tit	text	Nein
dis_er_503	text	Nein
dis_er_503_tit	text	Nein
dis_error	text	Nein
dis_error_tit	text	Nein

nuke_downloads_categories

Spalte	Typ	Null	Standard
cid (Primärschlüssel)	int(11)	Nein
title	varchar(50)	Nein
cdescription	text	Nein
parentid	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	cid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
title	BTREE	Nein	Nein	title	A	Nein

nuke_downloads_downloads

Spalte	Typ	Null	Standard
lid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
date	datetime	Ja	NULL
name	varchar(100)	Nein
email	varchar(100)	Nein
hits	int(11)	Nein	0
submitter	varchar(60)	Nein
downloadratingsummary	double(6,4)	Nein	0.0000
totalvotes	int(11)	Nein	0
totalcomments	int(11)	Nein	0
filesize	int(11)	Nein	0
version	varchar(10)	Nein
homepage	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	lid	A	Nein
lid	BTREE	Nein	Nein	lid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
sid	BTREE	Nein	Nein	sid	A	Nein
title	BTREE	Nein	Nein	title	A	Nein

nuke_downloads_editorials

Spalte	Typ	Null	Standard
downloadid (Primärschlüssel)	int(11)	Nein	0
adminid	varchar(60)	Nein
editorialtimestamp	datetime	Nein	0000-00-00 00:00:00
editorialtext	text	Nein
editorialtitle	varchar(100)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	downloadid	0	A	Nein
downloadid	BTREE	Nein	Nein	downloadid	0	A	Nein

nuke_downloads_modrequest

Spalte	Typ	Null	Standard
requestid (Primärschlüssel)	int(11)	Nein
lid	int(11)	Nein	0
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
modifysubmitter	varchar(60)	Nein
brokendownload	int(3)	Nein	0
name	varchar(100)	Nein
email	varchar(100)	Nein
filesize	int(11)	Nein	0
version	varchar(10)	Nein
homepage	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	requestid	0	A	Nein
requestid	BTREE	Ja	Nein	requestid	0	A	Nein

nuke_downloads_newdownload

Spalte	Typ	Null	Standard
lid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
name	varchar(100)	Nein
email	varchar(100)	Nein
submitter	varchar(60)	Nein
filesize	int(11)	Nein	0
version	varchar(10)	Nein
homepage	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	lid	A	Nein
lid	BTREE	Nein	Nein	lid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
sid	BTREE	Nein	Nein	sid	A	Nein
title	BTREE	Nein	Nein	title	A	Nein

nuke_downloads_votedata

Spalte	Typ	Null	Standard
ratingdbid (Primärschlüssel)	int(11)	Nein
ratinglid	int(11)	Nein	0
ratinguser	varchar(60)	Nein
rating	int(11)	Nein	0
ratinghostname	varchar(60)	Nein
ratingcomments	text	Nein
ratingtimestamp	datetime	Nein	0000-00-00 00:00:00

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	ratingdbid	0	A	Nein
ratingdbid	BTREE	Nein	Nein	ratingdbid	0	A	Nein

nuke_encyclopedia

Spalte	Typ	Null	Standard
eid (Primärschlüssel)	int(10)	Nein
title	varchar(255)	Nein
description	text	Nein
elanguage	varchar(30)	Nein
active	int(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	eid	0	A	Nein
eid	BTREE	Nein	Nein	eid	0	A	Nein

nuke_encyclopedia_text

Spalte	Typ	Null	Standard
tid (Primärschlüssel)	int(10)	Nein
eid	int(10)	Nein	0
title	varchar(255)	Nein
text	text	Nein
counter	int(10)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	tid	A	Nein
tid	BTREE	Nein	Nein	tid	A	Nein
eid	BTREE	Nein	Nein	eid	A	Nein
title	BTREE	Nein	Nein	title	A	Nein

nuke_ephem

Spalte	Typ	Null	Standard
eid (Primärschlüssel)	int(11)	Nein
did	int(2)	Nein	0
mid	int(2)	Nein	0
yid	int(4)	Nein	0
content	text	Nein
elanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	eid	0	A	Nein
eid	BTREE	Nein	Nein	eid	0	A	Nein

nuke_events

Spalte	Typ	Null	Standard
eid (Primärschlüssel)	int(10)	Nein
aid	varchar(25)	Nein
title	varchar(150)	Nein
posteddate	datetime	Nein	0000-00-00 00:00:00
hometext	text	Ja	NULL
topic	int(3)	Nein	1
informant	varchar(25)	Nein
startDate	date	Nein	0000-00-00
endDate	date	Nein	0000-00-00
startTime	time	Nein	00:00:00
endTime	time	Nein	00:00:00
alldayevent	int(1)	Nein	0
categorie	char(2)	Nein
activ	tinyint(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	eid	15	A	Nein
topic	BTREE	Nein	Nein	topic	1	A	Nein
categorie	BTREE	Nein	Nein	categorie	8	A	Nein
title	BTREE	Nein	Nein	title	14	A	Nein
activ	BTREE	Nein	Nein	activ	1	A	Nein
evbegin	BTREE	Nein	Nein	startDate	14	A	Nein
evbegin	BTREE	Nein	Nein	startTime	14	A	Nein
evtime	BTREE	Nein	Nein	startTime	6	A	Nein
evtime	BTREE	Nein	Nein	endTime	6	A	Nein

nuke_faqanswer

Spalte	Typ	Null	Standard
id (Primärschlüssel)	tinyint(4)	Nein
id_cat	tinyint(4)	Nein	0
question	varchar(255)	Ja	NULL
answer	text	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	id	A	Nein
id	BTREE	Nein	Nein	id	A	Nein
id_cat	BTREE	Nein	Nein	id_cat	A	Nein

nuke_faqcategories

Spalte	Typ	Null	Standard
id_cat (Primärschlüssel)	tinyint(3)	Nein
categories	varchar(255)	Ja	NULL
flanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id_cat	0	A	Nein
id_cat	BTREE	Nein	Nein	id_cat	0	A	Nein

nuke_headlines

Spalte	Typ	Null
hid (Primärschlüssel)	int(11)	Nein
sitename	varchar(30)	Nein
headlinesurl	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	hid	29	A	Nein
hid	BTREE	Nein	Nein	hid	29	A	Nein

nuke_hobby_categories

Spalte	Typ	Null	Standard
cid (Primärschlüssel)	int(11)	Nein
title	varchar(50)	Nein
cdescription	text	Nein
parentid	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	cid	3	A	Nein
cid	BTREE	Nein	Nein	cid	3	A	Nein
title	BTREE	Nein	Nein	title	3	A	Nein

nuke_hobby_editorials

Spalte	Typ	Null	Standard
downloadid (Primärschlüssel)	int(11)	Nein	0
adminid	varchar(60)	Nein
editorialtimestamp	datetime	Nein	0000-00-00 00:00:00
editorialtext	text	Nein
editorialtitle	varchar(100)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	downloadid	0	A	Nein
downloadid	BTREE	Nein	Nein	downloadid	0	A	Nein

nuke_hobby_hobby

Spalte	Typ	Null	Standard
lid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
date	datetime	Ja	NULL
name	varchar(100)	Nein
email	varchar(100)	Nein
hits	int(11)	Nein	0
submitter	varchar(60)	Nein
downloadratingsummary	double(6,4)	Nein	0.0000
totalvotes	int(11)	Nein	0
totalcomments	int(11)	Nein	0
filesize	int(11)	Nein	0
version	varchar(10)	Nein
homepage	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	lid	16	A	Nein
lid	BTREE	Nein	Nein	lid	16	A	Nein
cid	BTREE	Nein	Nein	cid	3	A	Nein
sid	BTREE	Nein	Nein	sid	1	A	Nein
title	BTREE	Nein	Nein	title	16	A	Nein

nuke_hobby_modrequest

Spalte	Typ	Null	Standard
requestid (Primärschlüssel)	int(11)	Nein
lid	int(11)	Nein	0
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
modifysubmitter	varchar(60)	Nein
brokendownload	int(3)	Nein	0
name	varchar(100)	Nein
email	varchar(100)	Nein
filesize	int(11)	Nein	0
version	varchar(10)	Nein
homepage	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	requestid	0	A	Nein
requestid	BTREE	Ja	Nein	requestid	0	A	Nein

nuke_hobby_newdownload

Spalte	Typ	Null	Standard
lid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
name	varchar(100)	Nein
email	varchar(100)	Nein
submitter	varchar(60)	Nein
filesize	int(11)	Nein	0
version	varchar(10)	Nein
homepage	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	lid	A	Nein
lid	BTREE	Nein	Nein	lid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
sid	BTREE	Nein	Nein	sid	A	Nein
title	BTREE	Nein	Nein	title	A	Nein

nuke_hobby_votedata

Spalte	Typ	Null	Standard
ratingdbid (Primärschlüssel)	int(11)	Nein
ratinglid	int(11)	Nein	0
ratinguser	varchar(60)	Nein
rating	int(11)	Nein	0
ratinghostname	varchar(60)	Nein
ratingcomments	text	Nein
ratingtimestamp	datetime	Nein	0000-00-00 00:00:00

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	ratingdbid	0	A	Nein
ratingdbid	BTREE	Nein	Nein	ratingdbid	0	A	Nein

nuke_journal

Spalte	Typ	Null	Standard
jid (Primärschlüssel)	int(11)	Nein
aid	varchar(30)	Nein
title	varchar(80)	Ja	NULL
bodytext	text	Nein
mood	varchar(48)	Nein
pdate	varchar(48)	Nein
ptime	varchar(48)	Nein
status	varchar(48)	Nein
mtime	varchar(48)	Nein
mdate	varchar(48)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	jid	A	Nein
jid	BTREE	Nein	Nein	jid	A	Nein
aid	BTREE	Nein	Nein	aid	A	Nein

nuke_journal_comments

Spalte	Typ	Null
cid (Primärschlüssel)	int(11)	Nein
rid	varchar(48)	Nein
aid	varchar(30)	Nein
comment	text	Nein
pdate	varchar(48)	Nein
ptime	varchar(48)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	cid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
rid	BTREE	Nein	Nein	rid	A	Nein
aid	BTREE	Nein	Nein	aid	A	Nein

nuke_journal_stats

Spalte	Typ	Null
id (Primärschlüssel)	int(11)	Nein
joid	varchar(48)	Nein
nop	varchar(48)	Nein
ldp	varchar(24)	Nein
ltp	varchar(24)	Nein
micro	varchar(128)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id	0	A	Nein
id	BTREE	Nein	Nein	id	0	A	Nein

nuke_links_categories

Spalte	Typ	Null	Standard
cid (Primärschlüssel)	int(11)	Nein
title	varchar(50)	Nein
cdescription	text	Nein
parentid	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	cid	8	A	Nein
cid	BTREE	Nein	Nein	cid	8	A	Nein

nuke_links_editorials

Spalte	Typ	Null	Standard
linkid (Primärschlüssel)	int(11)	Nein	0
adminid	varchar(60)	Nein
editorialtimestamp	datetime	Nein	0000-00-00 00:00:00
editorialtext	text	Nein
editorialtitle	varchar(100)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	linkid	0	A	Nein
linkid	BTREE	Nein	Nein	linkid	0	A	Nein

nuke_links_links

Spalte	Typ	Null	Standard
lid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
date	datetime	Ja	NULL
name	varchar(100)	Nein
email	varchar(100)	Nein
hits	int(11)	Nein	0
submitter	varchar(60)	Nein
linkratingsummary	double(6,4)	Nein	0.0000
totalvotes	int(11)	Nein	0
totalcomments	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	lid	A	Nein
lid	BTREE	Nein	Nein	lid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
sid	BTREE	Nein	Nein	sid	A	Nein

nuke_links_modrequest

Spalte	Typ	Null	Standard
requestid (Primärschlüssel)	int(11)	Nein
lid	int(11)	Nein	0
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
modifysubmitter	varchar(60)	Nein
brokenlink	int(3)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	requestid	0	A	Nein
requestid	BTREE	Ja	Nein	requestid	0	A	Nein

nuke_links_newlink

Spalte	Typ	Null	Standard
lid (Primärschlüssel)	int(11)	Nein
cid	int(11)	Nein	0
sid	int(11)	Nein	0
title	varchar(100)	Nein
url	varchar(100)	Nein
description	text	Nein
name	varchar(100)	Nein
email	varchar(100)	Nein
submitter	varchar(60)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	lid	A	Nein
lid	BTREE	Nein	Nein	lid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
sid	BTREE	Nein	Nein	sid	A	Nein

nuke_links_votedata

Spalte	Typ	Null	Standard
ratingdbid (Primärschlüssel)	int(11)	Nein
ratinglid	int(11)	Nein	0
ratinguser	varchar(60)	Nein
rating	int(11)	Nein	0
ratinghostname	varchar(60)	Nein
ratingcomments	text	Nein
ratingtimestamp	datetime	Nein	0000-00-00 00:00:00

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	ratingdbid	0	A	Nein
ratingdbid	BTREE	Nein	Nein	ratingdbid	0	A	Nein

nuke_main

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
main_module	varchar(255)	Nein

nuke_message

Spalte	Typ	Null	Standard
mid (Primärschlüssel)	int(11)	Nein
title	varchar(100)	Nein
content	text	Nein
date	varchar(14)	Nein
expire	int(7)	Nein	0
active	int(1)	Nein	1
view	int(1)	Nein	1
mlanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	mid	0	A	Nein
mid	BTREE	Ja	Nein	mid	0	A	Nein

nuke_modules

Spalte	Typ	Null	Standard
mid (Primärschlüssel)	int(10)	Nein
title	varchar(255)	Nein
custom_title	varchar(255)	Nein
active	int(1)	Nein	0
view	int(1)	Nein	0
inmenu	tinyint(1)	Nein	1

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	mid	45	A	Nein
mid	BTREE	Nein	Nein	mid	45	A	Nein
title	BTREE	Nein	Nein	title	45	A	Nein
custom_title	BTREE	Nein	Nein	custom_title	45	A	Nein

nuke_nfs_buyers

Spalte	Typ	Null	Standard
Name	varchar(100)	Nein
Address1	varchar(100)	Nein
Address2	varchar(100)	Nein
City	varchar(100)	Nein
State	char(2)	Nein
Zip	varchar(20)	Nein
Email	varchar(100)	Nein
DayPhone	varchar(100)	Nein
EvePhone	varchar(100)	Nein
Contact	int(1)	Nein	0
PayMethod	varchar(100)	Nein
CCType	varchar(100)	Nein
CCNum	varchar(100)	Nein
CCExpire	varchar(100)	Nein
OrderTotal	decimal(8,2)	Nein	0.00
Date	varchar(100)	Nein
OrderNumber	bigint(20)	Nein	0
UserID	varchar(100)	Nein
BuyerID (Primärschlüssel)	bigint(20)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	BuyerID	0	A	Nein

nuke_nfs_cartitems

Spalte	Typ	Null	Standard
UserID	varchar(100)	Nein
ItemID	varchar(25)	Nein
ItemQuantity	int(4)	Nein	0
Date	varchar(100)	Nein
CartItemsID (Primärschlüssel)	bigint(20)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	CartItemsID	0	A	Nein

nuke_nfs_category

Spalte	Typ	Null	Standard
catprinc	bigint(20)	Nein	1
Category	varchar(100)	Nein
CategoryID (Primärschlüssel)	bigint(20)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	CategoryID	0	A	Nein

nuke_nfs_catprinc

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
catprinc	varchar(100)	Nein
catprincID (Primärschlüssel)	bigint(20)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	catprincID	0	A	Nein

nuke_nfs_critique

Spalte	Typ	Null	Standard
critique_id (Primärschlüssel)	int(5)	Nein
produit_id	int(5)	Nein	0
critique_text	text	Nein
critique_vote	int(1)	Ja	NULL
critique_nom	text	Nein
critique_date	int(8)	Nein	0
critique_vu	int(9)	Nein	0
produit_nom	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	critique_id	0	A	Nein

nuke_nfs_devises

Spalte	Typ	Null	Standard
cles (Primärschlüssel)	int(4)	Nein
dev_nom	varchar(20)	Nein
dev_g	varchar(10)	Nein
dev_d	varchar(10)	Nein
dev_act	int(1)	Nein	0
dev_maitre	int(1)	Nein	0
dev_taux	longtext	Nein
dev_infos	longtext	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	cles	8	A	Nein

nuke_nfs_items

Spalte	Typ	Null	Standard
ItemSKU	varchar(25)	Nein
ItemName	varchar(100)	Nein
ItemDescription	mediumtext	Nein
ItemCost	decimal(7,2)	Nein	0.00
Category	bigint(20)	Nein	0
ShippingCost	decimal(6,2)	Nein	0.00
dateajout	int(8)	Nein	0
ItemID (Primärschlüssel)	bigint(20)	Nein
produit_vu	int(9)	Nein	0
promo	int(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	ItemID	0	A	Nein

nuke_nfs_orders

Spalte	Typ	Null	Standard
BuyerID	bigint(20)	Nein	0
UserID	varchar(100)	Nein
Date	varchar(100)	Nein
OrderTotal	decimal(8,2)	Nein	0.00
OrderNumber (Primärschlüssel)	bigint(20)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	OrderNumber	0	A	Nein

nuke_nfs_promo

Spalte	Typ	Null	Standard
promo_id (Primärschlüssel)	int(5)	Nein
produit_id	int(5)	Nein	0
ancien_prix	int(20)	Nein	0
nouveau_prix	int(20)	Nein	0
superpromo	int(1)	Nein	0
petit_txt	varchar(50)	Ja	NULL
auto	int(1)	Nein	0
debut_date	int(8)	Nein	0
debut_fin	int(8)	Nein	99999999
fin_ok	int(1)	Nein	1

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	promo_id	0	A	Nein

nuke_nfs_receipts

Spalte	Typ	Null	Standard
BuyerID	bigint(20)	Nein	0
UserID	varchar(100)	Nein
OrderNumber	bigint(20)	Nein	0
Date	varchar(100)	Nein
ItemID	bigint(20)	Nein	0
ItemSKU	varchar(25)	Nein
ItemName	varchar(100)	Nein
ItemCost	decimal(7,2)	Nein	0.00
ShippingCost	decimal(6,2)	Nein	0.00
ItemQuantity	int(11)	Nein	0
TotalCost	decimal(8,2)	Nein	0.00
itemtaxe	text	Nein

nuke_nfs_users

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
User	varchar(100)	Nein
Date	int(4)	Nein	0

nuke_nukebook

Spalte	Typ	Null	Standard
id (Primärschlüssel)	int(9)	Nein
name	varchar(50)	Nein
email	varchar(60)	Nein
url	varchar(70)	Nein
date	int(11)	Nein	0
host	varchar(60)	Nein
comment	text	Nein
nukeuser	smallint(1)	Ja	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id	194	A	Nein

nuke_nukebook_queue

Spalte	Typ	Null	Standard
id (Primärschlüssel)	int(9)	Nein
name	varchar(50)	Nein
email	varchar(60)	Nein
url	varchar(70)	Nein
date	int(11)	Nein	0
host	varchar(60)	Nein
comment	text	Nein
nukeuser	smallint(1)	Ja	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id	0	A	Nein

nuke_optimize_gain

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
gain	decimal(10,3)	Ja	NULL

nuke_pages

Spalte	Typ	Null	Standard
pid (Primärschlüssel)	int(10)	Nein
cid	int(10)	Nein	0
title	varchar(255)	Nein
subtitle	varchar(255)	Nein
active	int(1)	Nein	0
page_header	text	Nein
text	text	Nein
page_footer	text	Nein
signature	text	Nein
date	datetime	Nein	0000-00-00 00:00:00
counter	int(10)	Nein	0
clanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	pid	1530	A	Nein
pid	BTREE	Nein	Nein	pid	1530	A	Nein
cid	BTREE	Nein	Nein	cid	4	A	Nein

nuke_pages_categories

Spalte	Typ	Null
cid (Primärschlüssel)	int(10)	Nein
title	varchar(255)	Nein
description	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	cid	4	A	Nein
cid	BTREE	Nein	Nein	cid	4	A	Nein

nuke_pollcomments

Spalte	Typ	Null	Standard
tid (Primärschlüssel)	int(11)	Nein
pid	int(11)	Nein	0
pollID	int(11)	Nein	0
date	datetime	Ja	NULL
name	varchar(60)	Nein
email	varchar(60)	Ja	NULL
url	varchar(60)	Ja	NULL
host_name	varchar(60)	Ja	NULL
subject	varchar(60)	Nein
comment	text	Nein
score	tinyint(4)	Nein	0
reason	tinyint(4)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	tid	A	Nein
tid	BTREE	Nein	Nein	tid	A	Nein
pid	BTREE	Nein	Nein	pid	A	Nein
pollID	BTREE	Nein	Nein	pollID	A	Nein

nuke_poll_check

Spalte	Typ	Null	Standard
ip	varchar(20)	Nein
time	varchar(14)	Nein
pollID	int(10)	Nein	0

nuke_poll_data

Spalte	Typ	Null	Standard
pollID	int(11)	Nein	0
optionText	char(50)	Nein
optionCount	int(11)	Nein	0
voteID	int(11)	Nein	0

nuke_poll_desc

Spalte	Typ	Null	Standard
pollID (Primärschlüssel)	int(11)	Nein
pollTitle	varchar(100)	Nein
timeStamp	int(11)	Nein	0
voters	mediumint(9)	Nein	0
planguage	varchar(30)	Nein
artid	int(10)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	pollID	0	A	Nein
pollID	BTREE	Nein	Nein	pollID	0	A	Nein

nuke_popsettings

Spalte	Typ	Null	Standard
id (Primärschlüssel)	int(11)	Nein
uid	int(11)	Nein	0
account	varchar(50)	Ja	NULL
popserver	varchar(255)	Ja	NULL
port	int(5)	Ja	0
uname	varchar(100)	Ja	NULL
passwd	varchar(20)	Ja	NULL
numshow	int(11)	Ja	0
deletefromserver	char(1)	Ja	NULL
refresh	int(11)	Ja	0
timeout	int(11)	Ja	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	id	5	A	Nein
id	BTREE	Nein	Nein	id	5	A	Nein
uid	BTREE	Nein	Nein	uid	3	A	Nein

nuke_priv_msgs

Spalte	Typ	Null	Standard
msg_id (Primärschlüssel)	int(10)	Nein
msg_image	varchar(100)	Ja	NULL
subject	varchar(100)	Ja	NULL
from_userid	int(10)	Nein	0
to_userid	int(10)	Nein	0
msg_time	varchar(20)	Ja	NULL
msg_text	text	Ja	NULL
read_msg	tinyint(10)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	msg_id	A	Nein
msg_id	BTREE	Nein	Nein	msg_id	A	Nein
to_userid	BTREE	Nein	Nein	to_userid	A	Nein
from_userid	BTREE	Nein	Nein	from_userid	A	Nein

nuke_public_messages

Spalte	Typ	Null	Standard
mid (Primärschlüssel)	int(10)	Nein
content	varchar(255)	Nein
date	varchar(14)	Ja	NULL
who	varchar(25)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	mid	0	A	Nein
mid	BTREE	Nein	Nein	mid	0	A	Nein

nuke_queue

Spalte	Typ	Null	Standard
qid (Primärschlüssel)	smallint(5)	Nein
uid	mediumint(9)	Nein	0
uname	varchar(40)	Nein
subject	varchar(100)	Nein
story	text	Ja	NULL
storyext	text	Nein
timestamp	datetime	Nein	0000-00-00 00:00:00
topic	varchar(20)	Nein
alanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	qid	A	Nein
qid	BTREE	Nein	Nein	qid	A	Nein
uid	BTREE	Nein	Nein	uid	A	Nein
uname	BTREE	Nein	Nein	uname	A	Nein

nuke_quotes

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
qid (Primärschlüssel)	int(10)	Nein
quote	text	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	qid	0	A	Nein
qid	BTREE	Nein	Nein	qid	0	A	Nein

nuke_referer

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
rid (Primärschlüssel)	int(11)	Nein
url	varchar(100)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	rid	366	A	Nein
rid	BTREE	Nein	Nein	rid	366	A	Nein

nuke_related

Spalte	Typ	Null	Standard
rid (Primärschlüssel)	int(11)	Nein
tid	int(11)	Nein	0
name	varchar(30)	Nein
url	varchar(200)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	rid	A	Nein
rid	BTREE	Nein	Nein	rid	A	Nein
tid	BTREE	Nein	Nein	tid	A	Nein

nuke_reviews

Spalte	Typ	Null	Standard
id (Primärschlüssel)	int(10)	Nein
date	date	Nein	0000-00-00
title	varchar(150)	Nein
text	text	Nein
reviewer	varchar(20)	Ja	NULL
email	varchar(60)	Ja	NULL
score	int(10)	Nein	0
cover	varchar(100)	Nein
url	varchar(100)	Nein
url_title	varchar(50)	Nein
hits	int(10)	Nein	0
rlanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id	0	A	Nein
id	BTREE	Nein	Nein	id	0	A	Nein

nuke_reviews_add

Spalte	Typ	Null	Standard
id (Primärschlüssel)	int(10)	Nein
date	date	Ja	NULL
title	varchar(150)	Nein
text	text	Nein
reviewer	varchar(20)	Nein
email	varchar(60)	Ja	NULL
score	int(10)	Nein	0
url	varchar(100)	Nein
url_title	varchar(50)	Nein
rlanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id	0	A	Nein
id	BTREE	Nein	Nein	id	0	A	Nein

nuke_reviews_comments

Spalte	Typ	Null	Standard
cid (Primärschlüssel)	int(10)	Nein
rid	int(10)	Nein	0
userid	varchar(25)	Nein
date	datetime	Ja	NULL
comments	text	Ja	NULL
score	int(10)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	cid	A	Nein
cid	BTREE	Nein	Nein	cid	A	Nein
rid	BTREE	Nein	Nein	rid	A	Nein
userid	BTREE	Nein	Nein	userid	A	Nein

nuke_reviews_main

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
title	varchar(100)	Ja	NULL
description	text	Ja	NULL

nuke_seccont

Spalte	Typ	Null	Standard
artid (Primärschlüssel)	int(11)	Nein
secid	int(11)	Nein	0
title	text	Nein
content	text	Nein
counter	int(11)	Nein	0
slanguage	varchar(30)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	artid	A	Nein
artid	BTREE	Nein	Nein	artid	A	Nein
secid	BTREE	Nein	Nein	secid	A	Nein

nuke_sections

Spalte	Typ	Null
secid (Primärschlüssel)	int(11)	Nein
secname	varchar(40)	Nein
image	varchar(50)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	secid	0	A	Nein
secid	BTREE	Nein	Nein	secid	0	A	Nein

nuke_session

Spalte	Typ	Null	Standard
uname	varchar(25)	Nein
time	varchar(14)	Nein
host_addr	varchar(48)	Nein
guest	int(1)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
time	BTREE	Nein	Nein	time	0	A	Nein
guest	BTREE	Nein	Nein	guest	0	A	Nein

nuke_stats_date

Spalte	Typ	Null
year	smallint(6)	Nein
month	tinyint(4)	Nein
date	tinyint(4)	Nein
hits	bigint(20)	Nein

nuke_stats_hour

Spalte	Typ	Null
year	smallint(6)	Nein
month	tinyint(4)	Nein
date	tinyint(4)	Nein
hour	tinyint(4)	Nein
hits	int(11)	Nein

nuke_stats_month

Spalte	Typ	Null
year	smallint(6)	Nein
month	tinyint(4)	Nein
hits	bigint(20)	Nein

nuke_stats_year

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
year	smallint(6)	Nein	0
hits	bigint(20)	Nein	0

nuke_stories

Spalte	Typ	Null	Standard
sid (Primärschlüssel)	int(11)	Nein
catid	int(11)	Nein	0
aid	varchar(30)	Nein
title	varchar(80)	Ja	NULL
time	datetime	Ja	NULL
hometext	text	Ja	NULL
bodytext	text	Nein
comments	int(11)	Ja	0
counter	mediumint(8)	Nein	0
topic	int(3)	Nein	1
informant	varchar(20)	Nein
notes	text	Nein
ihome	int(1)	Nein	0
alanguage	varchar(30)	Nein
acomm	int(1)	Nein	0
haspoll	int(1)	Nein	0
pollID	int(10)	Nein	0
score	int(10)	Nein	0
ratings	int(10)	Nein	0
associated	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	sid	12	A	Nein
sid	BTREE	Nein	Nein	sid	12	A	Nein
catid	BTREE	Nein	Nein	catid	1	A	Nein
counter	BTREE	Nein	Nein	counter	12	A	Nein
topic	BTREE	Nein	Nein	topic	2	A	Nein

nuke_stories_cat

Spalte	Typ	Null	Standard
catid (Primärschlüssel)	int(11)	Nein
title	varchar(20)	Nein
counter	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	catid	6	A	Nein
catid	BTREE	Nein	Nein	catid	6	A	Nein

nuke_topics

Spalte	Typ	Null	Standard
topicid (Primärschlüssel)	int(3)	Nein
topicname	varchar(20)	Ja	NULL
topicimage	varchar(20)	Ja	NULL
topictext	varchar(40)	Ja	NULL
counter	int(11)	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	topicid	10	A	Nein
topicid	BTREE	Nein	Nein	topicid	10	A	Nein

nuke_users

Spalte	Typ	Null	Standard
user_id (Primärschlüssel)	int(11)	Nein
name	varchar(60)	Nein
username	varchar(25)	Nein
user_email	varchar(255)	Nein
femail	varchar(255)	Nein
user_website	varchar(255)	Nein
user_avatar	varchar(255)	Nein
user_regdate	varchar(20)	Nein
user_icq	varchar(15)	Ja	NULL
user_occ	varchar(100)	Ja	NULL
user_from	varchar(100)	Ja	NULL
user_interests	varchar(150)	Nein
user_sig	varchar(255)	Ja	NULL
user_viewemail	tinyint(2)	Ja	NULL
user_theme	int(3)	Ja	NULL
user_aim	varchar(18)	Ja	NULL
user_yim	varchar(25)	Ja	NULL
user_msnm	varchar(25)	Ja	NULL
user_password	varchar(40)	Nein
storynum	tinyint(4)	Nein	10
umode	varchar(10)	Nein
uorder	tinyint(1)	Nein	0
thold	tinyint(1)	Nein	0
noscore	tinyint(1)	Nein	0
bio	tinytext	Nein
ublockon	tinyint(1)	Nein	0
ublock	tinytext	Nein
theme	varchar(255)	Nein
commentmax	int(11)	Nein	4096
counter	int(11)	Nein	0
newsletter	int(1)	Nein	0
user_posts	int(10)	Nein	0
user_attachsig	int(2)	Nein	0
user_rank	int(10)	Nein	0
user_level	int(10)	Nein	1
broadcast	tinyint(1)	Nein	1
popmeson	tinyint(1)	Nein	0
user_active	tinyint(1)	Ja	1
user_session_time	int(11)	Nein	0
user_session_page	smallint(5)	Nein	0
user_lastvisit	int(11)	Nein	0
user_timezone	tinyint(4)	Nein	10
user_style	tinyint(4)	Ja	NULL
user_lang	varchar(255)	Nein	english
user_dateformat	varchar(14)	Nein	D M d, Y g:i a
user_new_privmsg	smallint(5)	Nein	0
user_unread_privmsg	smallint(5)	Nein	0
user_last_privmsg	int(11)	Nein	0
user_emailtime	int(11)	Ja	NULL
user_allowhtml	tinyint(1)	Ja	1
user_allowbbcode	tinyint(1)	Ja	1
user_allowsmile	tinyint(1)	Ja	1
user_allowavatar	tinyint(1)	Nein	1
user_allow_pm	tinyint(1)	Nein	1
user_allow_viewonline	tinyint(1)	Nein	1
user_notify	tinyint(1)	Nein	0
user_notify_pm	tinyint(1)	Nein	0
user_popup_pm	tinyint(1)	Nein	0
user_avatar_type	tinyint(4)	Nein	3
user_sig_bbcode_uid	varchar(10)	Ja	NULL
user_actkey	varchar(32)	Ja	NULL
user_newpasswd	varchar(32)	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null
PRIMARY	BTREE	Ja	Nein	user_id	36	A	Nein
uid	BTREE	Nein	Nein	user_id	36	A	Nein
uname	BTREE	Nein	Nein	username	36	A	Nein
user_session_time	BTREE	Nein	Nein	user_session_time	3	A	Nein

nuke_users_config

Spalte	Typ	Null	Standard
ucid (Primärschlüssel)	int(2)	Nein
allowuserreg	int(1)	Nein	0
sendaddmail	int(1)	Nein	0
allowuserdelete	int(1)	Nein	0
senddeletemail	int(1)	Nein	0
allowusertheme	int(1)	Nein	0
allowmailchange	int(1)	Nein	0
requireadmin	int(1)	Nein	0
servermail	int(1)	Nein	0
useactivate	int(1)	Nein	0
usegfxcheck	int(1)	Nein	0
autosuspend	int(11)	Nein	0
perpage	int(4)	Nein	100

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	ucid	4	A	Nein

nuke_users_temp

Spalte	Typ	Null
user_id (Primärschlüssel)	int(10)	Nein
username	varchar(25)	Nein
user_email	varchar(255)	Nein
user_password	varchar(40)	Nein
user_regdate	varchar(20)	Nein
check_num	varchar(50)	Nein
time	varchar(14)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	user_id	0	A	Nein

pma__bookmark

Tabellenkommentar: Bookmarks

Spalte	Typ	Null
id (Primärschlüssel)	int(10)	Nein
dbase	varchar(255)	Nein
user	varchar(255)	Nein
label	varchar(255)	Nein
query	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	id	0	A	Nein

pma__central_columns

Tabellenkommentar: Central list of columns

Spalte	Typ	Null	Standard
db_name (Primärschlüssel)	varchar(64)	Nein
col_name (Primärschlüssel)	varchar(64)	Nein
col_type	varchar(64)	Nein
col_length	text	Ja	NULL
col_collation	varchar(64)	Nein
col_isNull	tinyint(1)	Nein
col_extra	varchar(255)	Ja
col_default	text	Ja	NULL

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	db_name	0	A	Nein
PRIMARY	BTREE	Ja	Nein	col_name	0	A	Nein

pma__column_info

Tabellenkommentar: Column information for phpMyAdmin

Spalte	Typ	Null
id (Primärschlüssel)	int(5)	Nein
db_name	varchar(64)	Nein
table_name	varchar(64)	Nein
column_name	varchar(64)	Nein
comment	varchar(255)	Nein
mimetype	varchar(255)	Nein
transformation	varchar(255)	Nein
transformation_options	varchar(255)	Nein
input_transformation	varchar(255)	Nein
input_transformation_options	varchar(255)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	id	A	Nein
db_name	BTREE	Ja	Nein	db_name	A	Nein
				table_name	A	Nein
				column_name	A	Nein

pma__designer_settings

Tabellenkommentar: Settings related to Designer

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
username (Primärschlüssel)	varchar(64)	Nein
settings_data	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	username	0	A	Nein

pma__export_templates

Tabellenkommentar: Saved export templates

Spalte	Typ	Null
id (Primärschlüssel)	int(5)	Nein
username	varchar(64)	Nein
export_type	varchar(10)	Nein
template_name	varchar(64)	Nein
template_data	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	id	A	Nein
u_user_type_template	BTREE	Ja	Nein	username	A	Nein
				export_type	A	Nein
				template_name	A	Nein

pma__favorite

Tabellenkommentar: Favorite tables

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
username (Primärschlüssel)	varchar(64)	Nein
tables	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	username	0	A	Nein

pma__history

Tabellenkommentar: SQL history for phpMyAdmin

Spalte	Typ	Null	Standard
id (Primärschlüssel)	bigint(20)	Nein
username	varchar(64)	Nein
db	varchar(64)	Nein
table	varchar(64)	Nein
timevalue	timestamp	Nein	CURRENT_TIMESTAMP
sqlquery	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	id	A	Nein
username	BTREE	Nein	Nein	username	A	Nein
				db	A	Nein
				table	A	Nein
				timevalue	A	Nein

pma__navigationhiding

Tabellenkommentar: Hidden items of navigation tree

Spalte	Typ	Null
username (Primärschlüssel)	varchar(64)	Nein
item_name (Primärschlüssel)	varchar(64)	Nein
item_type (Primärschlüssel)	varchar(64)	Nein
db_name (Primärschlüssel)	varchar(64)	Nein
table_name (Primärschlüssel)	varchar(64)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	username	A	Nein
				item_name	A	Nein
				item_type	A	Nein
				db_name	A	Nein
				table_name	A	Nein

pma__pdf_pages

Tabellenkommentar: PDF relation pages for phpMyAdmin

Spalte	Typ	Null
db_name	varchar(64)	Nein
page_nr (Primärschlüssel)	int(10)	Nein
page_descr	varchar(50)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	page_nr	0	A	Nein
db_name	BTREE	Nein	Nein	db_name	0	A	Nein

pma__recent

Tabellenkommentar: Recently accessed tables

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
username (Primärschlüssel)	varchar(64)	Nein
tables	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	username	0	A	Nein

pma__relation

Tabellenkommentar: Relation table

Spalte	Typ	Null
master_db (Primärschlüssel)	varchar(64)	Nein
master_table (Primärschlüssel)	varchar(64)	Nein
master_field (Primärschlüssel)	varchar(64)	Nein
foreign_db	varchar(64)	Nein
foreign_table	varchar(64)	Nein
foreign_field	varchar(64)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	master_db	A	Nein
				master_table	A	Nein
				master_field	A	Nein
foreign_field	BTREE	Nein	Nein	foreign_db	A	Nein
foreign_field	BTREE	Nein	Nein	foreign_table	A	Nein

pma__savedsearches

Tabellenkommentar: Saved searches

Spalte	Typ	Null
id (Primärschlüssel)	int(5)	Nein
username	varchar(64)	Nein
db_name	varchar(64)	Nein
search_name	varchar(64)	Nein
search_data	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	id	A	Nein
u_savedsearches_username_dbname	BTREE	Ja	Nein	username	A	Nein
				db_name	A	Nein
				search_name	A	Nein

pma__table_coords

Tabellenkommentar: Table coordinates for phpMyAdmin PDF output

Spalte	Typ	Null	Standard
db_name (Primärschlüssel)	varchar(64)	Nein
table_name (Primärschlüssel)	varchar(64)	Nein
pdf_page_number (Primärschlüssel)	int(11)	Nein	0
x	float	Nein	0
y	float	Nein	0

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	db_name	A	Nein
				table_name	A	Nein
				pdf_page_number	A	Nein

pma__table_info

Tabellenkommentar: Table information for phpMyAdmin

Spalte	Typ	Null
db_name (Primärschlüssel)	varchar(64)	Nein
table_name (Primärschlüssel)	varchar(64)	Nein
display_field	varchar(64)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	db_name	0	A	Nein
PRIMARY	BTREE	Ja	Nein	table_name	0	A	Nein

pma__table_uiprefs

Tabellenkommentar: Tables' UI preferences

Spalte	Typ	Null	Standard
username (Primärschlüssel)	varchar(64)	Nein
db_name (Primärschlüssel)	varchar(64)	Nein
table_name (Primärschlüssel)	varchar(64)	Nein
prefs	text	Nein
last_update	timestamp	Nein	CURRENT_TIMESTAMP

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	username	A	Nein
				db_name	A	Nein
				table_name	A	Nein

pma__tracking

Tabellenkommentar: Database changes tracking for phpMyAdmin

Spalte	Typ	Null	Standard
db_name (Primärschlüssel)	varchar(64)	Nein
table_name (Primärschlüssel)	varchar(64)	Nein
version (Primärschlüssel)	int(10)	Nein
date_created	datetime	Nein
date_updated	datetime	Nein
schema_snapshot	text	Nein
schema_sql	text	Ja	NULL
data_sql	longtext	Ja	NULL
tracking	set('UPDATE', 'REPLACE', 'INSERT', 'DELETE', 'TRUNCATE', 'CREATE DATABASE', 'ALTER DATABASE', 'DROP DATABASE', 'CREATE TABLE', 'ALTER TABLE', 'RENAME TABLE', 'DROP TABLE', 'CREATE INDEX', 'DROP INDEX', 'CREATE VIEW', 'ALTER VIEW', 'DROP VIEW')	Ja	NULL
tracking_active	int(1)	Nein	1

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	db_name	A	Nein
				table_name	A	Nein
				version	A	Nein

pma__userconfig

Tabellenkommentar: User preferences storage for phpMyAdmin

Spalte	Typ	Null	Standard
username (Primärschlüssel)	varchar(64)	Nein
timevalue	timestamp	Nein	CURRENT_TIMESTAMP
config_data	text	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	username	0	A	Nein

pma__usergroups

Tabellenkommentar: User groups with configured menu items

Spalte	Typ	Null	Standard
usergroup (Primärschlüssel)	varchar(64)	Nein
tab (Primärschlüssel)	varchar(64)	Nein
allowed (Primärschlüssel)	enum('Y', 'N')	Nein	N

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kollation	Null
PRIMARY	BTREE	Ja	Nein	usergroup	A	Nein
				tab	A	Nein
				allowed	A	Nein

pma__users

Tabellenkommentar: Users and their assignments to user groups

Spalte	Typ	Null	Standard	Verweise	Kommentare	MIME
username (Primärschlüssel)	varchar(64)	Nein
usergroup (Primärschlüssel)	varchar(64)	Nein

Indizes

Schlüsselname	Typ	Unique	Gepackt	Spalte	Kardinalität	Kollation	Null	Kommentar
PRIMARY	BTREE	Ja	Nein	username	0	A	Nein
PRIMARY	BTREE	Ja	Nein	usergroup	0	A	Nein