Print view - phpMyAdmin 4.9.7

nuke_authors

Column	Type	Null	Default
aid (Primary)	varchar(25)	No
name	varchar(50)	Yes	NULL
url	varchar(255)	No
email	varchar(255)	No
pwd	varchar(40)	Yes	NULL
counter	int(11)	No	0
radminarticle	tinyint(2)	No	0
radmintopic	tinyint(2)	No	0
radminuser	tinyint(2)	No	0
radminsurvey	tinyint(2)	No	0
radminsection	tinyint(2)	No	0
radminlink	tinyint(2)	No	0
radminephem	tinyint(2)	No	0
radminfaq	tinyint(2)	No	0
radmindownload	tinyint(2)	No	0
radminreviews	tinyint(2)	No	0
radminnewsletter	tinyint(2)	No	0
radminforum	tinyint(2)	No	0
radmincontent	tinyint(2)	No	0
radminency	tinyint(2)	No	0
radminsuper	tinyint(2)	No	1
admlanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	aid	3	A	No
aid	BTREE	No	No	aid	3	A	No

nuke_autonews

Column	Type	Null	Default
anid (Primary)	int(11)	No
catid	int(11)	No	0
aid	varchar(30)	No
title	varchar(80)	No
time	varchar(19)	No
hometext	text	No
bodytext	text	No
topic	int(3)	No	1
informant	varchar(20)	No
notes	text	No
ihome	int(1)	No	0
alanguage	varchar(30)	No
acomm	int(1)	No	0
associated	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	anid	0	A	No
anid	BTREE	No	No	anid	0	A	No

nuke_banner

Column	Type	Null	Default
bid (Primary)	int(11)	No
cid	int(11)	No	0
imptotal	int(11)	No	0
impmade	int(11)	No	0
clicks	int(11)	No	0
imageurl	varchar(100)	No
clickurl	varchar(200)	No
alttext	varchar(255)	No
date	datetime	Yes	NULL
dateend	datetime	Yes	NULL
type	tinyint(1)	No	0
active	tinyint(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	bid	A	No
bid	BTREE	No	No	bid	A	No
cid	BTREE	No	No	cid	A	No

nuke_bannerclient

Column	Type	Null
cid (Primary)	int(11)	No
name	varchar(60)	No
contact	varchar(60)	No
email	varchar(60)	No
login	varchar(10)	No
passwd	varchar(10)	No
extrainfo	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	cid	0	A	No
cid	BTREE	No	No	cid	0	A	No

nuke_bbauth_access

Column	Type	Null
group_id	mediumint(8)	No
forum_id	smallint(5)	No
auth_view	tinyint(1)	No
auth_read	tinyint(1)	No
auth_post	tinyint(1)	No
auth_reply	tinyint(1)	No
auth_edit	tinyint(1)	No
auth_delete	tinyint(1)	No
auth_sticky	tinyint(1)	No
auth_announce	tinyint(1)	No
auth_vote	tinyint(1)	No
auth_pollcreate	tinyint(1)	No
auth_attachments	tinyint(1)	No
auth_mod	tinyint(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
group_id	BTREE	No	No	group_id	0	A	No
forum_id	BTREE	No	No	forum_id	0	A	No

nuke_bbbanlist

Column	Type	Null	Default
ban_id (Primary)	mediumint(8)	No
ban_userid	mediumint(8)	No	0
ban_ip	varchar(8)	No
ban_email	varchar(255)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	ban_id	A	No
ban_ip_user_id	BTREE	No	No	ban_ip	A	No
ban_ip_user_id	BTREE	No	No	ban_userid	A	No

nuke_bbcategories

Column	Type	Null	Default
cat_id (Primary)	mediumint(8)	No
cat_title	varchar(100)	Yes	NULL
cat_order	mediumint(8)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	cat_id	0	A	No
cat_order	BTREE	No	No	cat_order	0	A	No

nuke_bbconfig

Column	Type	Null	Default	Links to	Comments	MIME
config_name (Primary)	varchar(255)	No
config_value	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	config_name	61	A	No

nuke_bbdisallow

Column	Type	Null	Default	Links to	Comments	MIME
disallow_id (Primary)	mediumint(8)	No
disallow_username	varchar(25)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	disallow_id	0	A	No

nuke_bbforums

Column	Type	Null	Default
forum_id (Primary)	smallint(5)	No
cat_id	mediumint(8)	No	0
forum_name	varchar(150)	Yes	NULL
forum_desc	text	Yes	NULL
forum_status	tinyint(4)	No	0
forum_order	mediumint(8)	No	1
forum_posts	mediumint(8)	No	0
forum_topics	mediumint(8)	No	0
forum_last_post_id	mediumint(8)	No	0
prune_next	int(11)	Yes	NULL
prune_enable	tinyint(1)	No	1
auth_view	tinyint(2)	No	0
auth_read	tinyint(2)	No	0
auth_post	tinyint(2)	No	0
auth_reply	tinyint(2)	No	0
auth_edit	tinyint(2)	No	0
auth_delete	tinyint(2)	No	0
auth_sticky	tinyint(2)	No	0
auth_announce	tinyint(2)	No	0
auth_vote	tinyint(2)	No	0
auth_pollcreate	tinyint(2)	No	0
auth_attachments	tinyint(2)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	forum_id	A	No
forums_order	BTREE	No	No	forum_order	A	No
cat_id	BTREE	No	No	cat_id	A	No
forum_last_post_id	BTREE	No	No	forum_last_post_id	A	No

nuke_bbforum_prune

Column	Type	Null	Default
prune_id (Primary)	mediumint(8)	No
forum_id	smallint(5)	No	0
prune_days	tinyint(4)	No	0
prune_freq	tinyint(4)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	prune_id	0	A	No
forum_id	BTREE	No	No	forum_id	0	A	No

nuke_bbgroups

Column	Type	Null	Default
group_id (Primary)	mediumint(8)	No
group_type	tinyint(4)	No	1
group_name	varchar(40)	No
group_description	varchar(255)	No
group_moderator	mediumint(8)	No	0
group_single_user	tinyint(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	group_id	2	A	No
group_single_user	BTREE	No	No	group_single_user	2	A	No

nuke_bbposts

Column	Type	Null	Default
post_id (Primary)	mediumint(8)	No
topic_id	mediumint(8)	No	0
forum_id	smallint(5)	No	0
poster_id	mediumint(8)	No	0
post_time	int(11)	No	0
poster_ip	varchar(8)	No
post_username	varchar(25)	Yes	NULL
enable_bbcode	tinyint(1)	No	1
enable_html	tinyint(1)	No	0
enable_smilies	tinyint(1)	No	1
enable_sig	tinyint(1)	No	1
post_edit_time	int(11)	Yes	NULL
post_edit_count	smallint(5)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	post_id	A	No
forum_id	BTREE	No	No	forum_id	A	No
topic_id	BTREE	No	No	topic_id	A	No
poster_id	BTREE	No	No	poster_id	A	No
post_time	BTREE	No	No	post_time	A	No

nuke_bbposts_text

Column	Type	Null	Default
post_id (Primary)	mediumint(8)	No	0
bbcode_uid	varchar(10)	No
post_subject	varchar(60)	Yes	NULL
post_text	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	post_id	0	A	No

nuke_bbprivmsgs

Column	Type	Null	Default
privmsgs_id (Primary)	mediumint(8)	No
privmsgs_type	tinyint(4)	No	0
privmsgs_subject	varchar(255)	No	0
privmsgs_from_userid	mediumint(8)	No	0
privmsgs_to_userid	mediumint(8)	No	0
privmsgs_date	int(11)	No	0
privmsgs_ip	varchar(8)	No
privmsgs_enable_bbcode	tinyint(1)	No	1
privmsgs_enable_html	tinyint(1)	No	0
privmsgs_enable_smilies	tinyint(1)	No	1
privmsgs_attach_sig	tinyint(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	privmsgs_id	A	No
privmsgs_from_userid	BTREE	No	No	privmsgs_from_userid	A	No
privmsgs_to_userid	BTREE	No	No	privmsgs_to_userid	A	No

nuke_bbprivmsgs_text

Column	Type	Null	Default
privmsgs_text_id (Primary)	mediumint(8)	No	0
privmsgs_bbcode_uid	varchar(10)	No	0
privmsgs_text	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	privmsgs_text_id	0	A	No

nuke_bbranks

Column	Type	Null	Default
rank_id (Primary)	smallint(5)	No
rank_title	varchar(50)	No
rank_min	mediumint(8)	No	0
rank_max	mediumint(8)	No	0
rank_special	tinyint(1)	Yes	0
rank_image	varchar(255)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rank_id	2	A	No

nuke_bbsearch_results

Column	Type	Null	Default
search_id (Primary)	int(11)	No	0
session_id	varchar(32)	No
search_array	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	search_id	0	A	No
session_id	BTREE	No	No	session_id	0	A	No

nuke_bbsearch_wordlist

Column	Type	Null	Default
word_text (Primary)	varchar(50)	No
word_id	mediumint(8)	No
word_common	tinyint(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	word_text	0	A	No
word_id	BTREE	No	No	word_id	0	A	No

nuke_bbsearch_wordmatch

Column	Type	Null
post_id	mediumint(8)	No
word_id	mediumint(8)	No
title_match	tinyint(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
word_id	BTREE	No	No	word_id	0	A	No

nuke_bbsessions

Column	Type	Null	Default
session_id (Primary)	char(32)	No
session_user_id	mediumint(8)	No	0
session_start	int(11)	No	0
session_time	int(11)	No	0
session_ip	char(8)	No	0
session_page	int(11)	No	0
session_logged_in	tinyint(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	session_id	300	A	No
session_user_id	BTREE	No	No	session_user_id	1	A	No
session_id_ip_user_id	BTREE	No	No	session_id	300	A	No
				session_ip	300	A	No
				session_user_id	300	A	No

nuke_bbsmilies

Column	Type	Null	Default
smilies_id (Primary)	smallint(5)	No
code	varchar(50)	Yes	NULL
smile_url	varchar(100)	Yes	NULL
emoticon	varchar(75)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	smilies_id	44	A	No

nuke_bbthemes

Column	Type	Null	Default
themes_id (Primary)	mediumint(8)	No
template_name	varchar(30)	No
style_name	varchar(30)	No
head_stylesheet	varchar(100)	Yes	NULL
body_background	varchar(100)	Yes	NULL
body_bgcolor	varchar(6)	Yes	NULL
body_text	varchar(6)	Yes	NULL
body_link	varchar(6)	Yes	NULL
body_vlink	varchar(6)	Yes	NULL
body_alink	varchar(6)	Yes	NULL
body_hlink	varchar(6)	Yes	NULL
tr_color1	varchar(6)	Yes	NULL
tr_color2	varchar(6)	Yes	NULL
tr_color3	varchar(6)	Yes	NULL
tr_class1	varchar(25)	Yes	NULL
tr_class2	varchar(25)	Yes	NULL
tr_class3	varchar(25)	Yes	NULL
th_color1	varchar(6)	Yes	NULL
th_color2	varchar(6)	Yes	NULL
th_color3	varchar(6)	Yes	NULL
th_class1	varchar(25)	Yes	NULL
th_class2	varchar(25)	Yes	NULL
th_class3	varchar(25)	Yes	NULL
td_color1	varchar(6)	Yes	NULL
td_color2	varchar(6)	Yes	NULL
td_color3	varchar(6)	Yes	NULL
td_class1	varchar(25)	Yes	NULL
td_class2	varchar(25)	Yes	NULL
td_class3	varchar(25)	Yes	NULL
fontface1	varchar(50)	Yes	NULL
fontface2	varchar(50)	Yes	NULL
fontface3	varchar(50)	Yes	NULL
fontsize1	tinyint(4)	Yes	NULL
fontsize2	tinyint(4)	Yes	NULL
fontsize3	tinyint(4)	Yes	NULL
fontcolor1	varchar(6)	Yes	NULL
fontcolor2	varchar(6)	Yes	NULL
fontcolor3	varchar(6)	Yes	NULL
span_class1	varchar(25)	Yes	NULL
span_class2	varchar(25)	Yes	NULL
span_class3	varchar(25)	Yes	NULL
img_size_poll	smallint(5)	Yes	NULL
img_size_privmsg	smallint(5)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	themes_id	0	A	No

nuke_bbthemes_name

Column	Type	Null	Default
themes_id (Primary)	smallint(5)	No	0
tr_color1_name	char(50)	Yes	NULL
tr_color2_name	char(50)	Yes	NULL
tr_color3_name	char(50)	Yes	NULL
tr_class1_name	char(50)	Yes	NULL
tr_class2_name	char(50)	Yes	NULL
tr_class3_name	char(50)	Yes	NULL
th_color1_name	char(50)	Yes	NULL
th_color2_name	char(50)	Yes	NULL
th_color3_name	char(50)	Yes	NULL
th_class1_name	char(50)	Yes	NULL
th_class2_name	char(50)	Yes	NULL
th_class3_name	char(50)	Yes	NULL
td_color1_name	char(50)	Yes	NULL
td_color2_name	char(50)	Yes	NULL
td_color3_name	char(50)	Yes	NULL
td_class1_name	char(50)	Yes	NULL
td_class2_name	char(50)	Yes	NULL
td_class3_name	char(50)	Yes	NULL
fontface1_name	char(50)	Yes	NULL
fontface2_name	char(50)	Yes	NULL
fontface3_name	char(50)	Yes	NULL
fontsize1_name	char(50)	Yes	NULL
fontsize2_name	char(50)	Yes	NULL
fontsize3_name	char(50)	Yes	NULL
fontcolor1_name	char(50)	Yes	NULL
fontcolor2_name	char(50)	Yes	NULL
fontcolor3_name	char(50)	Yes	NULL
span_class1_name	char(50)	Yes	NULL
span_class2_name	char(50)	Yes	NULL
span_class3_name	char(50)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	themes_id	0	A	No

nuke_bbtopics

Column	Type	Null	Default
topic_id (Primary)	mediumint(8)	No
forum_id	smallint(8)	No	0
topic_title	char(60)	No
topic_poster	mediumint(8)	No	0
topic_time	int(11)	No	0
topic_views	mediumint(8)	No	0
topic_replies	mediumint(8)	No	0
topic_status	tinyint(3)	No	0
topic_vote	tinyint(1)	No	0
topic_type	tinyint(3)	No	0
topic_last_post_id	mediumint(8)	No	0
topic_first_post_id	mediumint(8)	No	0
topic_moved_id	mediumint(8)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	topic_id	A	No
forum_id	BTREE	No	No	forum_id	A	No
topic_moved_id	BTREE	No	No	topic_moved_id	A	No
topic_status	BTREE	No	No	topic_status	A	No
topic_type	BTREE	No	No	topic_type	A	No

nuke_bbtopics_watch

Column	Type	Null
topic_id	mediumint(8)	No
user_id	mediumint(8)	No
notify_status	tinyint(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
topic_id	BTREE	No	No	topic_id	A	No
user_id	BTREE	No	No	user_id	A	No
notify_status	BTREE	No	No	notify_status	A	No

nuke_bbuser_group

Column	Type	Null	Default
group_id	mediumint(8)	No	0
user_id	mediumint(8)	No	0
user_pending	tinyint(1)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
group_id	BTREE	No	No	group_id	2	A	No
user_id	BTREE	No	No	user_id	2	A	No

nuke_bbvote_desc

Column	Type	Null	Default
vote_id (Primary)	mediumint(8)	No
topic_id	mediumint(8)	No	0
vote_text	text	No
vote_start	int(11)	No	0
vote_length	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	vote_id	0	A	No
topic_id	BTREE	No	No	topic_id	0	A	No

nuke_bbvote_results

Column	Type	Null	Default
vote_id	mediumint(8)	No	0
vote_option_id	tinyint(4)	No	0
vote_option_text	varchar(255)	No
vote_result	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
vote_option_id	BTREE	No	No	vote_option_id	0	A	No
vote_id	BTREE	No	No	vote_id	0	A	No

nuke_bbvote_voters

Column	Type	Null	Default
vote_id	mediumint(8)	No	0
vote_user_id	mediumint(8)	No	0
vote_user_ip	char(8)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
vote_id	BTREE	No	No	vote_id	A	No
vote_user_id	BTREE	No	No	vote_user_id	A	No
vote_user_ip	BTREE	No	No	vote_user_ip	A	No

nuke_bbwords

Column	Type	Null
word_id (Primary)	mediumint(8)	No
word	char(100)	No
replacement	char(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	word_id	0	A	No

nuke_blocks

Column	Type	Null	Default
bid (Primary)	int(10)	No
bkey	varchar(15)	No
title	varchar(60)	No
content	text	No
url	varchar(200)	No
bposition	char(1)	No
weight	int(10)	No	1
active	int(1)	No	1
refresh	int(10)	No	0
time	varchar(14)	No	0
blanguage	varchar(30)	No
blockfile	varchar(255)	No
view	int(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	bid	42	A	No
bid	BTREE	No	No	bid	42	A	No
title	BTREE	No	No	title	42	A	No

nuke_comments

Column	Type	Null	Default
tid (Primary)	int(11)	No
pid	int(11)	No	0
sid	int(11)	No	0
date	datetime	Yes	NULL
name	varchar(60)	No
email	varchar(60)	Yes	NULL
url	varchar(60)	Yes	NULL
host_name	varchar(60)	Yes	NULL
subject	varchar(85)	No
comment	text	No
score	tinyint(4)	No	0
reason	tinyint(4)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	tid	A	No
tid	BTREE	No	No	tid	A	No
pid	BTREE	No	No	pid	A	No
sid	BTREE	No	No	sid	A	No

nuke_config

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

nuke_contactbook

Column	Type	Null	Default
uid	int(11)	No	0
contactid (Primary)	int(11)	No
firstname	varchar(50)	Yes	NULL
lastname	varchar(50)	Yes	NULL
email	varchar(255)	Yes	NULL
company	varchar(255)	Yes	NULL
homeaddress	varchar(255)	Yes	NULL
city	varchar(80)	Yes	NULL
homephone	varchar(255)	Yes	NULL
workphone	varchar(255)	Yes	NULL
homepage	varchar(255)	Yes	NULL
IM	varchar(255)	Yes	NULL
events	text	Yes	NULL
reminders	int(11)	Yes	NULL
notes	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	contactid	A	No
uid	BTREE	No	No	uid	A	No
contactid	BTREE	No	No	contactid	A	No

nuke_counter

Column	Type	Null	Default
type	varchar(80)	No
var	varchar(80)	No
count	int(10)	No	0

nuke_dis_er

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

nuke_downloads_categories

Column	Type	Null	Default
cid (Primary)	int(11)	No
title	varchar(50)	No
cdescription	text	No
parentid	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	cid	A	No
cid	BTREE	No	No	cid	A	No
title	BTREE	No	No	title	A	No

nuke_downloads_downloads

Column	Type	Null	Default
lid (Primary)	int(11)	No
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
date	datetime	Yes	NULL
name	varchar(100)	No
email	varchar(100)	No
hits	int(11)	No	0
submitter	varchar(60)	No
downloadratingsummary	double(6,4)	No	0.0000
totalvotes	int(11)	No	0
totalcomments	int(11)	No	0
filesize	int(11)	No	0
version	varchar(10)	No
homepage	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	lid	A	No
lid	BTREE	No	No	lid	A	No
cid	BTREE	No	No	cid	A	No
sid	BTREE	No	No	sid	A	No
title	BTREE	No	No	title	A	No

nuke_downloads_editorials

Column	Type	Null	Default
downloadid (Primary)	int(11)	No	0
adminid	varchar(60)	No
editorialtimestamp	datetime	No	0000-00-00 00:00:00
editorialtext	text	No
editorialtitle	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	downloadid	0	A	No
downloadid	BTREE	No	No	downloadid	0	A	No

nuke_downloads_modrequest

Column	Type	Null	Default
requestid (Primary)	int(11)	No
lid	int(11)	No	0
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
modifysubmitter	varchar(60)	No
brokendownload	int(3)	No	0
name	varchar(100)	No
email	varchar(100)	No
filesize	int(11)	No	0
version	varchar(10)	No
homepage	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	requestid	0	A	No
requestid	BTREE	Yes	No	requestid	0	A	No

nuke_downloads_newdownload

Column	Type	Null	Default
lid (Primary)	int(11)	No
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
name	varchar(100)	No
email	varchar(100)	No
submitter	varchar(60)	No
filesize	int(11)	No	0
version	varchar(10)	No
homepage	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	lid	A	No
lid	BTREE	No	No	lid	A	No
cid	BTREE	No	No	cid	A	No
sid	BTREE	No	No	sid	A	No
title	BTREE	No	No	title	A	No

nuke_downloads_votedata

Column	Type	Null	Default
ratingdbid (Primary)	int(11)	No
ratinglid	int(11)	No	0
ratinguser	varchar(60)	No
rating	int(11)	No	0
ratinghostname	varchar(60)	No
ratingcomments	text	No
ratingtimestamp	datetime	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ratingdbid	0	A	No
ratingdbid	BTREE	No	No	ratingdbid	0	A	No

nuke_encyclopedia

Column	Type	Null	Default
eid (Primary)	int(10)	No
title	varchar(255)	No
description	text	No
elanguage	varchar(30)	No
active	int(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	eid	0	A	No
eid	BTREE	No	No	eid	0	A	No

nuke_encyclopedia_text

Column	Type	Null	Default
tid (Primary)	int(10)	No
eid	int(10)	No	0
title	varchar(255)	No
text	text	No
counter	int(10)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	tid	A	No
tid	BTREE	No	No	tid	A	No
eid	BTREE	No	No	eid	A	No
title	BTREE	No	No	title	A	No

nuke_ephem

Column	Type	Null	Default
eid (Primary)	int(11)	No
did	int(2)	No	0
mid	int(2)	No	0
yid	int(4)	No	0
content	text	No
elanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	eid	0	A	No
eid	BTREE	No	No	eid	0	A	No

nuke_events

Column	Type	Null	Default
eid (Primary)	int(10)	No
aid	varchar(25)	No
title	varchar(150)	No
posteddate	datetime	No	0000-00-00 00:00:00
hometext	text	Yes	NULL
topic	int(3)	No	1
informant	varchar(25)	No
startDate	date	No	0000-00-00
endDate	date	No	0000-00-00
startTime	time	No	00:00:00
endTime	time	No	00:00:00
alldayevent	int(1)	No	0
categorie	char(2)	No
activ	tinyint(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	eid	15	A	No
topic	BTREE	No	No	topic	1	A	No
categorie	BTREE	No	No	categorie	8	A	No
title	BTREE	No	No	title	14	A	No
activ	BTREE	No	No	activ	1	A	No
evbegin	BTREE	No	No	startDate	14	A	No
evbegin	BTREE	No	No	startTime	14	A	No
evtime	BTREE	No	No	startTime	6	A	No
evtime	BTREE	No	No	endTime	6	A	No

nuke_faqanswer

Column	Type	Null	Default
id (Primary)	tinyint(4)	No
id_cat	tinyint(4)	No	0
question	varchar(255)	Yes	NULL
answer	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
id	BTREE	No	No	id	A	No
id_cat	BTREE	No	No	id_cat	A	No

nuke_faqcategories

Column	Type	Null	Default
id_cat (Primary)	tinyint(3)	No
categories	varchar(255)	Yes	NULL
flanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id_cat	0	A	No
id_cat	BTREE	No	No	id_cat	0	A	No

nuke_headlines

Column	Type	Null
hid (Primary)	int(11)	No
sitename	varchar(30)	No
headlinesurl	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	hid	29	A	No
hid	BTREE	No	No	hid	29	A	No

nuke_hobby_categories

Column	Type	Null	Default
cid (Primary)	int(11)	No
title	varchar(50)	No
cdescription	text	No
parentid	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	cid	3	A	No
cid	BTREE	No	No	cid	3	A	No
title	BTREE	No	No	title	3	A	No

nuke_hobby_editorials

Column	Type	Null	Default
downloadid (Primary)	int(11)	No	0
adminid	varchar(60)	No
editorialtimestamp	datetime	No	0000-00-00 00:00:00
editorialtext	text	No
editorialtitle	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	downloadid	0	A	No
downloadid	BTREE	No	No	downloadid	0	A	No

nuke_hobby_hobby

Column	Type	Null	Default
lid (Primary)	int(11)	No
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
date	datetime	Yes	NULL
name	varchar(100)	No
email	varchar(100)	No
hits	int(11)	No	0
submitter	varchar(60)	No
downloadratingsummary	double(6,4)	No	0.0000
totalvotes	int(11)	No	0
totalcomments	int(11)	No	0
filesize	int(11)	No	0
version	varchar(10)	No
homepage	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	lid	16	A	No
lid	BTREE	No	No	lid	16	A	No
cid	BTREE	No	No	cid	3	A	No
sid	BTREE	No	No	sid	1	A	No
title	BTREE	No	No	title	16	A	No

nuke_hobby_modrequest

Column	Type	Null	Default
requestid (Primary)	int(11)	No
lid	int(11)	No	0
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
modifysubmitter	varchar(60)	No
brokendownload	int(3)	No	0
name	varchar(100)	No
email	varchar(100)	No
filesize	int(11)	No	0
version	varchar(10)	No
homepage	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	requestid	0	A	No
requestid	BTREE	Yes	No	requestid	0	A	No

nuke_hobby_newdownload

Column	Type	Null	Default
lid (Primary)	int(11)	No
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
name	varchar(100)	No
email	varchar(100)	No
submitter	varchar(60)	No
filesize	int(11)	No	0
version	varchar(10)	No
homepage	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	lid	A	No
lid	BTREE	No	No	lid	A	No
cid	BTREE	No	No	cid	A	No
sid	BTREE	No	No	sid	A	No
title	BTREE	No	No	title	A	No

nuke_hobby_votedata

Column	Type	Null	Default
ratingdbid (Primary)	int(11)	No
ratinglid	int(11)	No	0
ratinguser	varchar(60)	No
rating	int(11)	No	0
ratinghostname	varchar(60)	No
ratingcomments	text	No
ratingtimestamp	datetime	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ratingdbid	0	A	No
ratingdbid	BTREE	No	No	ratingdbid	0	A	No

nuke_journal

Column	Type	Null	Default
jid (Primary)	int(11)	No
aid	varchar(30)	No
title	varchar(80)	Yes	NULL
bodytext	text	No
mood	varchar(48)	No
pdate	varchar(48)	No
ptime	varchar(48)	No
status	varchar(48)	No
mtime	varchar(48)	No
mdate	varchar(48)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	jid	A	No
jid	BTREE	No	No	jid	A	No
aid	BTREE	No	No	aid	A	No

nuke_journal_comments

Column	Type	Null
cid (Primary)	int(11)	No
rid	varchar(48)	No
aid	varchar(30)	No
comment	text	No
pdate	varchar(48)	No
ptime	varchar(48)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	cid	A	No
cid	BTREE	No	No	cid	A	No
rid	BTREE	No	No	rid	A	No
aid	BTREE	No	No	aid	A	No

nuke_journal_stats

Column	Type	Null
id (Primary)	int(11)	No
joid	varchar(48)	No
nop	varchar(48)	No
ldp	varchar(24)	No
ltp	varchar(24)	No
micro	varchar(128)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
id	BTREE	No	No	id	0	A	No

nuke_links_categories

Column	Type	Null	Default
cid (Primary)	int(11)	No
title	varchar(50)	No
cdescription	text	No
parentid	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	cid	8	A	No
cid	BTREE	No	No	cid	8	A	No

nuke_links_editorials

Column	Type	Null	Default
linkid (Primary)	int(11)	No	0
adminid	varchar(60)	No
editorialtimestamp	datetime	No	0000-00-00 00:00:00
editorialtext	text	No
editorialtitle	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	linkid	0	A	No
linkid	BTREE	No	No	linkid	0	A	No

nuke_links_links

Column	Type	Null	Default
lid (Primary)	int(11)	No
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
date	datetime	Yes	NULL
name	varchar(100)	No
email	varchar(100)	No
hits	int(11)	No	0
submitter	varchar(60)	No
linkratingsummary	double(6,4)	No	0.0000
totalvotes	int(11)	No	0
totalcomments	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	lid	A	No
lid	BTREE	No	No	lid	A	No
cid	BTREE	No	No	cid	A	No
sid	BTREE	No	No	sid	A	No

nuke_links_modrequest

Column	Type	Null	Default
requestid (Primary)	int(11)	No
lid	int(11)	No	0
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
modifysubmitter	varchar(60)	No
brokenlink	int(3)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	requestid	0	A	No
requestid	BTREE	Yes	No	requestid	0	A	No

nuke_links_newlink

Column	Type	Null	Default
lid (Primary)	int(11)	No
cid	int(11)	No	0
sid	int(11)	No	0
title	varchar(100)	No
url	varchar(100)	No
description	text	No
name	varchar(100)	No
email	varchar(100)	No
submitter	varchar(60)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	lid	A	No
lid	BTREE	No	No	lid	A	No
cid	BTREE	No	No	cid	A	No
sid	BTREE	No	No	sid	A	No

nuke_links_votedata

Column	Type	Null	Default
ratingdbid (Primary)	int(11)	No
ratinglid	int(11)	No	0
ratinguser	varchar(60)	No
rating	int(11)	No	0
ratinghostname	varchar(60)	No
ratingcomments	text	No
ratingtimestamp	datetime	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ratingdbid	0	A	No
ratingdbid	BTREE	No	No	ratingdbid	0	A	No

nuke_main

Column	Type	Null	Default	Links to	Comments	MIME
main_module	varchar(255)	No

nuke_message

Column	Type	Null	Default
mid (Primary)	int(11)	No
title	varchar(100)	No
content	text	No
date	varchar(14)	No
expire	int(7)	No	0
active	int(1)	No	1
view	int(1)	No	1
mlanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	mid	0	A	No
mid	BTREE	Yes	No	mid	0	A	No

nuke_modules

Column	Type	Null	Default
mid (Primary)	int(10)	No
title	varchar(255)	No
custom_title	varchar(255)	No
active	int(1)	No	0
view	int(1)	No	0
inmenu	tinyint(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	mid	45	A	No
mid	BTREE	No	No	mid	45	A	No
title	BTREE	No	No	title	45	A	No
custom_title	BTREE	No	No	custom_title	45	A	No

nuke_nfs_buyers

Column	Type	Null	Default
Name	varchar(100)	No
Address1	varchar(100)	No
Address2	varchar(100)	No
City	varchar(100)	No
State	char(2)	No
Zip	varchar(20)	No
Email	varchar(100)	No
DayPhone	varchar(100)	No
EvePhone	varchar(100)	No
Contact	int(1)	No	0
PayMethod	varchar(100)	No
CCType	varchar(100)	No
CCNum	varchar(100)	No
CCExpire	varchar(100)	No
OrderTotal	decimal(8,2)	No	0.00
Date	varchar(100)	No
OrderNumber	bigint(20)	No	0
UserID	varchar(100)	No
BuyerID (Primary)	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	BuyerID	0	A	No

nuke_nfs_cartitems

Column	Type	Null	Default
UserID	varchar(100)	No
ItemID	varchar(25)	No
ItemQuantity	int(4)	No	0
Date	varchar(100)	No
CartItemsID (Primary)	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	CartItemsID	0	A	No

nuke_nfs_category

Column	Type	Null	Default
catprinc	bigint(20)	No	1
Category	varchar(100)	No
CategoryID (Primary)	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	CategoryID	0	A	No

nuke_nfs_catprinc

Column	Type	Null	Default	Links to	Comments	MIME
catprinc	varchar(100)	No
catprincID (Primary)	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	catprincID	0	A	No

nuke_nfs_critique

Column	Type	Null	Default
critique_id (Primary)	int(5)	No
produit_id	int(5)	No	0
critique_text	text	No
critique_vote	int(1)	Yes	NULL
critique_nom	text	No
critique_date	int(8)	No	0
critique_vu	int(9)	No	0
produit_nom	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	critique_id	0	A	No

nuke_nfs_devises

Column	Type	Null	Default
cles (Primary)	int(4)	No
dev_nom	varchar(20)	No
dev_g	varchar(10)	No
dev_d	varchar(10)	No
dev_act	int(1)	No	0
dev_maitre	int(1)	No	0
dev_taux	longtext	No
dev_infos	longtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	cles	8	A	No

nuke_nfs_items

Column	Type	Null	Default
ItemSKU	varchar(25)	No
ItemName	varchar(100)	No
ItemDescription	mediumtext	No
ItemCost	decimal(7,2)	No	0.00
Category	bigint(20)	No	0
ShippingCost	decimal(6,2)	No	0.00
dateajout	int(8)	No	0
ItemID (Primary)	bigint(20)	No
produit_vu	int(9)	No	0
promo	int(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ItemID	0	A	No

nuke_nfs_orders

Column	Type	Null	Default
BuyerID	bigint(20)	No	0
UserID	varchar(100)	No
Date	varchar(100)	No
OrderTotal	decimal(8,2)	No	0.00
OrderNumber (Primary)	bigint(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	OrderNumber	0	A	No

nuke_nfs_promo

Column	Type	Null	Default
promo_id (Primary)	int(5)	No
produit_id	int(5)	No	0
ancien_prix	int(20)	No	0
nouveau_prix	int(20)	No	0
superpromo	int(1)	No	0
petit_txt	varchar(50)	Yes	NULL
auto	int(1)	No	0
debut_date	int(8)	No	0
debut_fin	int(8)	No	99999999
fin_ok	int(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	promo_id	0	A	No

nuke_nfs_receipts

Column	Type	Null	Default
BuyerID	bigint(20)	No	0
UserID	varchar(100)	No
OrderNumber	bigint(20)	No	0
Date	varchar(100)	No
ItemID	bigint(20)	No	0
ItemSKU	varchar(25)	No
ItemName	varchar(100)	No
ItemCost	decimal(7,2)	No	0.00
ShippingCost	decimal(6,2)	No	0.00
ItemQuantity	int(11)	No	0
TotalCost	decimal(8,2)	No	0.00
itemtaxe	text	No

nuke_nfs_users

Column	Type	Null	Default	Links to	Comments	MIME
User	varchar(100)	No
Date	int(4)	No	0

nuke_nukebook

Column	Type	Null	Default
id (Primary)	int(9)	No
name	varchar(50)	No
email	varchar(60)	No
url	varchar(70)	No
date	int(11)	No	0
host	varchar(60)	No
comment	text	No
nukeuser	smallint(1)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	194	A	No

nuke_nukebook_queue

Column	Type	Null	Default
id (Primary)	int(9)	No
name	varchar(50)	No
email	varchar(60)	No
url	varchar(70)	No
date	int(11)	No	0
host	varchar(60)	No
comment	text	No
nukeuser	smallint(1)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

nuke_optimize_gain

Column	Type	Null	Default	Links to	Comments	MIME
gain	decimal(10,3)	Yes	NULL

nuke_pages

Column	Type	Null	Default
pid (Primary)	int(10)	No
cid	int(10)	No	0
title	varchar(255)	No
subtitle	varchar(255)	No
active	int(1)	No	0
page_header	text	No
text	text	No
page_footer	text	No
signature	text	No
date	datetime	No	0000-00-00 00:00:00
counter	int(10)	No	0
clanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	pid	1807	A	No
pid	BTREE	No	No	pid	1735	A	No
cid	BTREE	No	No	cid	4	A	No

nuke_pages_categories

Column	Type	Null
cid (Primary)	int(10)	No
title	varchar(255)	No
description	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	cid	4	A	No
cid	BTREE	No	No	cid	4	A	No

nuke_pollcomments

Column	Type	Null	Default
tid (Primary)	int(11)	No
pid	int(11)	No	0
pollID	int(11)	No	0
date	datetime	Yes	NULL
name	varchar(60)	No
email	varchar(60)	Yes	NULL
url	varchar(60)	Yes	NULL
host_name	varchar(60)	Yes	NULL
subject	varchar(60)	No
comment	text	No
score	tinyint(4)	No	0
reason	tinyint(4)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	tid	A	No
tid	BTREE	No	No	tid	A	No
pid	BTREE	No	No	pid	A	No
pollID	BTREE	No	No	pollID	A	No

nuke_poll_check

Column	Type	Null	Default
ip	varchar(20)	No
time	varchar(14)	No
pollID	int(10)	No	0

nuke_poll_data

Column	Type	Null	Default
pollID	int(11)	No	0
optionText	char(50)	No
optionCount	int(11)	No	0
voteID	int(11)	No	0

nuke_poll_desc

Column	Type	Null	Default
pollID (Primary)	int(11)	No
pollTitle	varchar(100)	No
timeStamp	int(11)	No	0
voters	mediumint(9)	No	0
planguage	varchar(30)	No
artid	int(10)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	pollID	0	A	No
pollID	BTREE	No	No	pollID	0	A	No

nuke_popsettings

Column	Type	Null	Default
id (Primary)	int(11)	No
uid	int(11)	No	0
account	varchar(50)	Yes	NULL
popserver	varchar(255)	Yes	NULL
port	int(5)	Yes	0
uname	varchar(100)	Yes	NULL
passwd	varchar(20)	Yes	NULL
numshow	int(11)	Yes	0
deletefromserver	char(1)	Yes	NULL
refresh	int(11)	Yes	0
timeout	int(11)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	5	A	No
id	BTREE	No	No	id	5	A	No
uid	BTREE	No	No	uid	3	A	No

nuke_priv_msgs

Column	Type	Null	Default
msg_id (Primary)	int(10)	No
msg_image	varchar(100)	Yes	NULL
subject	varchar(100)	Yes	NULL
from_userid	int(10)	No	0
to_userid	int(10)	No	0
msg_time	varchar(20)	Yes	NULL
msg_text	text	Yes	NULL
read_msg	tinyint(10)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	msg_id	A	No
msg_id	BTREE	No	No	msg_id	A	No
to_userid	BTREE	No	No	to_userid	A	No
from_userid	BTREE	No	No	from_userid	A	No

nuke_public_messages

Column	Type	Null	Default
mid (Primary)	int(10)	No
content	varchar(255)	No
date	varchar(14)	Yes	NULL
who	varchar(25)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	mid	0	A	No
mid	BTREE	No	No	mid	0	A	No

nuke_queue

Column	Type	Null	Default
qid (Primary)	smallint(5)	No
uid	mediumint(9)	No	0
uname	varchar(40)	No
subject	varchar(100)	No
story	text	Yes	NULL
storyext	text	No
timestamp	datetime	No	0000-00-00 00:00:00
topic	varchar(20)	No
alanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	qid	A	No
qid	BTREE	No	No	qid	A	No
uid	BTREE	No	No	uid	A	No
uname	BTREE	No	No	uname	A	No

nuke_quotes

Column	Type	Null	Default	Links to	Comments	MIME
qid (Primary)	int(10)	No
quote	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	qid	0	A	No
qid	BTREE	No	No	qid	0	A	No

nuke_referer

Column	Type	Null	Default	Links to	Comments	MIME
rid (Primary)	int(11)	No
url	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	rid	366	A	No
rid	BTREE	No	No	rid	366	A	No

nuke_related

Column	Type	Null	Default
rid (Primary)	int(11)	No
tid	int(11)	No	0
name	varchar(30)	No
url	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	rid	A	No
rid	BTREE	No	No	rid	A	No
tid	BTREE	No	No	tid	A	No

nuke_reviews

Column	Type	Null	Default
id (Primary)	int(10)	No
date	date	No	0000-00-00
title	varchar(150)	No
text	text	No
reviewer	varchar(20)	Yes	NULL
email	varchar(60)	Yes	NULL
score	int(10)	No	0
cover	varchar(100)	No
url	varchar(100)	No
url_title	varchar(50)	No
hits	int(10)	No	0
rlanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
id	BTREE	No	No	id	0	A	No

nuke_reviews_add

Column	Type	Null	Default
id (Primary)	int(10)	No
date	date	Yes	NULL
title	varchar(150)	No
text	text	No
reviewer	varchar(20)	No
email	varchar(60)	Yes	NULL
score	int(10)	No	0
url	varchar(100)	No
url_title	varchar(50)	No
rlanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
id	BTREE	No	No	id	0	A	No

nuke_reviews_comments

Column	Type	Null	Default
cid (Primary)	int(10)	No
rid	int(10)	No	0
userid	varchar(25)	No
date	datetime	Yes	NULL
comments	text	Yes	NULL
score	int(10)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	cid	A	No
cid	BTREE	No	No	cid	A	No
rid	BTREE	No	No	rid	A	No
userid	BTREE	No	No	userid	A	No

nuke_reviews_main

Column	Type	Null	Default	Links to	Comments	MIME
title	varchar(100)	Yes	NULL
description	text	Yes	NULL

nuke_seccont

Column	Type	Null	Default
artid (Primary)	int(11)	No
secid	int(11)	No	0
title	text	No
content	text	No
counter	int(11)	No	0
slanguage	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	artid	A	No
artid	BTREE	No	No	artid	A	No
secid	BTREE	No	No	secid	A	No

nuke_sections

Column	Type	Null
secid (Primary)	int(11)	No
secname	varchar(40)	No
image	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	secid	0	A	No
secid	BTREE	No	No	secid	0	A	No

nuke_session

Column	Type	Null	Default
uname	varchar(25)	No
time	varchar(14)	No
host_addr	varchar(48)	No
guest	int(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
time	BTREE	No	No	time	0	A	No
guest	BTREE	No	No	guest	0	A	No

nuke_stats_date

Column	Type	Null
year	smallint(6)	No
month	tinyint(4)	No
date	tinyint(4)	No
hits	bigint(20)	No

nuke_stats_hour

Column	Type	Null
year	smallint(6)	No
month	tinyint(4)	No
date	tinyint(4)	No
hour	tinyint(4)	No
hits	int(11)	No

nuke_stats_month

Column	Type	Null
year	smallint(6)	No
month	tinyint(4)	No
hits	bigint(20)	No

nuke_stats_year

Column	Type	Null	Default	Links to	Comments	MIME
year	smallint(6)	No	0
hits	bigint(20)	No	0

nuke_stories

Column	Type	Null	Default
sid (Primary)	int(11)	No
catid	int(11)	No	0
aid	varchar(30)	No
title	varchar(80)	Yes	NULL
time	datetime	Yes	NULL
hometext	text	Yes	NULL
bodytext	text	No
comments	int(11)	Yes	0
counter	mediumint(8)	No	0
topic	int(3)	No	1
informant	varchar(20)	No
notes	text	No
ihome	int(1)	No	0
alanguage	varchar(30)	No
acomm	int(1)	No	0
haspoll	int(1)	No	0
pollID	int(10)	No	0
score	int(10)	No	0
ratings	int(10)	No	0
associated	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	sid	12	A	No
sid	BTREE	No	No	sid	12	A	No
catid	BTREE	No	No	catid	1	A	No
counter	BTREE	No	No	counter	12	A	No
topic	BTREE	No	No	topic	2	A	No

nuke_stories_cat

Column	Type	Null	Default
catid (Primary)	int(11)	No
title	varchar(20)	No
counter	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	catid	6	A	No
catid	BTREE	No	No	catid	6	A	No

nuke_topics

Column	Type	Null	Default
topicid (Primary)	int(3)	No
topicname	varchar(20)	Yes	NULL
topicimage	varchar(20)	Yes	NULL
topictext	varchar(40)	Yes	NULL
counter	int(11)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	topicid	10	A	No
topicid	BTREE	No	No	topicid	10	A	No

nuke_users

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	user_id	36	A	No
uid	BTREE	No	No	user_id	36	A	No
uname	BTREE	No	No	username	36	A	No
user_session_time	BTREE	No	No	user_session_time	3	A	No

nuke_users_config

Column	Type	Null	Default
ucid (Primary)	int(2)	No
allowuserreg	int(1)	No	0
sendaddmail	int(1)	No	0
allowuserdelete	int(1)	No	0
senddeletemail	int(1)	No	0
allowusertheme	int(1)	No	0
allowmailchange	int(1)	No	0
requireadmin	int(1)	No	0
servermail	int(1)	No	0
useactivate	int(1)	No	0
usegfxcheck	int(1)	No	0
autosuspend	int(11)	No	0
perpage	int(4)	No	100

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	ucid	4	A	No

nuke_users_temp

Column	Type	Null
user_id (Primary)	int(10)	No
username	varchar(25)	No
user_email	varchar(255)	No
user_password	varchar(40)	No
user_regdate	varchar(20)	No
check_num	varchar(50)	No
time	varchar(14)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	user_id	0	A	No

pma__bookmark

Table comments: Bookmarks

Column	Type	Null
id (Primary)	int(10)	No
dbase	varchar(255)	No
user	varchar(255)	No
label	varchar(255)	No
query	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

pma__central_columns

Table comments: Central list of columns

Column	Type	Null	Default
db_name (Primary)	varchar(64)	No
col_name (Primary)	varchar(64)	No
col_type	varchar(64)	No
col_length	text	Yes	NULL
col_collation	varchar(64)	No
col_isNull	tinyint(1)	No
col_extra	varchar(255)	Yes
col_default	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
PRIMARY	BTREE	Yes	No	col_name	0	A	No

pma__column_info

Table comments: Column information for phpMyAdmin

Column	Type	Null
id (Primary)	int(5)	No
db_name	varchar(64)	No
table_name	varchar(64)	No
column_name	varchar(64)	No
comment	varchar(255)	No
mimetype	varchar(255)	No
transformation	varchar(255)	No
transformation_options	varchar(255)	No
input_transformation	varchar(255)	No
input_transformation_options	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
db_name	BTREE	Yes	No	db_name	A	No
				table_name	A	No
				column_name	A	No

pma__designer_settings

Table comments: Settings related to Designer

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
settings_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__export_templates

Table comments: Saved export templates

Column	Type	Null
id (Primary)	int(5)	No
username	varchar(64)	No
export_type	varchar(10)	No
template_name	varchar(64)	No
template_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
u_user_type_template	BTREE	Yes	No	username	A	No
				export_type	A	No
				template_name	A	No

pma__favorite

Table comments: Favorite tables

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
tables	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__history

Table comments: SQL history for phpMyAdmin

Column	Type	Null	Default
id (Primary)	bigint(20)	No
username	varchar(64)	No
db	varchar(64)	No
table	varchar(64)	No
timevalue	timestamp	No	CURRENT_TIMESTAMP
sqlquery	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
username	BTREE	No	No	username	A	No
				db	A	No
				table	A	No
				timevalue	A	No

pma__navigationhiding

Table comments: Hidden items of navigation tree

Column	Type	Null
username (Primary)	varchar(64)	No
item_name (Primary)	varchar(64)	No
item_type (Primary)	varchar(64)	No
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	username	A	No
				item_name	A	No
				item_type	A	No
				db_name	A	No
				table_name	A	No

pma__pdf_pages

Table comments: PDF relation pages for phpMyAdmin

Column	Type	Null
db_name	varchar(64)	No
page_nr (Primary)	int(10)	No
page_descr	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	page_nr	0	A	No
db_name	BTREE	No	No	db_name	0	A	No

pma__recent

Table comments: Recently accessed tables

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
tables	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__relation

Table comments: Relation table

Column	Type	Null
master_db (Primary)	varchar(64)	No
master_table (Primary)	varchar(64)	No
master_field (Primary)	varchar(64)	No
foreign_db	varchar(64)	No
foreign_table	varchar(64)	No
foreign_field	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	master_db	A	No
				master_table	A	No
				master_field	A	No
foreign_field	BTREE	No	No	foreign_db	A	No
foreign_field	BTREE	No	No	foreign_table	A	No

pma__savedsearches

Table comments: Saved searches

Column	Type	Null
id (Primary)	int(5)	No
username	varchar(64)	No
db_name	varchar(64)	No
search_name	varchar(64)	No
search_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
u_savedsearches_username_dbname	BTREE	Yes	No	username	A	No
				db_name	A	No
				search_name	A	No

pma__table_coords

Table comments: Table coordinates for phpMyAdmin PDF output

Column	Type	Null	Default
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
pdf_page_number (Primary)	int(11)	No	0
x	float	No	0
y	float	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	db_name	A	No
				table_name	A	No
				pdf_page_number	A	No

pma__table_info

Table comments: Table information for phpMyAdmin

Column	Type	Null
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
display_field	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db_name	0	A	No
PRIMARY	BTREE	Yes	No	table_name	0	A	No

pma__table_uiprefs

Table comments: Tables' UI preferences

Column	Type	Null	Default
username (Primary)	varchar(64)	No
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
prefs	text	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	username	A	No
				db_name	A	No
				table_name	A	No

pma__tracking

Table comments: Database changes tracking for phpMyAdmin

Column	Type	Null	Default
db_name (Primary)	varchar(64)	No
table_name (Primary)	varchar(64)	No
version (Primary)	int(10)	No
date_created	datetime	No
date_updated	datetime	No
schema_snapshot	text	No
schema_sql	text	Yes	NULL
data_sql	longtext	Yes	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')	Yes	NULL
tracking_active	int(1)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	db_name	A	No
				table_name	A	No
				version	A	No

pma__userconfig

Table comments: User preferences storage for phpMyAdmin

Column	Type	Null	Default
username (Primary)	varchar(64)	No
timevalue	timestamp	No	CURRENT_TIMESTAMP
config_data	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No

pma__usergroups

Table comments: User groups with configured menu items

Column	Type	Null	Default
usergroup (Primary)	varchar(64)	No
tab (Primary)	varchar(64)	No
allowed (Primary)	enum('Y', 'N')	No	N

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	usergroup	A	No
				tab	A	No
				allowed	A	No

pma__users

Table comments: Users and their assignments to user groups

Column	Type	Null	Default	Links to	Comments	MIME
username (Primary)	varchar(64)	No
usergroup (Primary)	varchar(64)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	username	0	A	No
PRIMARY	BTREE	Yes	No	usergroup	0	A	No