NG大舞台

gjl_about

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
title	varchar(200)	Yes	NULL
typeid	int(11)	Yes	0
litpic	varchar(255)	Yes	NULL
litpic2	varchar(255)	Yes	NULL
content	text	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
cityid	int(11)	Yes	0

Indexes

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

gjl_about_album

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_about_other

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_admin_action

Column	Type	Null	Default	Links to	Comments	MIME
action_id (Primary)	tinyint(3)	No
parent_id	tinyint(3)	No	0
action_code	varchar(100)	No
relevance	varchar(20)	No
sortrank	int(11)	Yes	100

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	action_id	56	A	No
parent_id	BTREE	No	No	parent_id		A	No

gjl_admin_log

Column	Type	Null	Default	Links to	Comments	MIME
log_id (Primary)	int(10)	No
log_time	int(10)	No	0
user_id	tinyint(3)	No	0
log_info	varchar(255)	No
ip_address	varchar(15)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	log_id	31113	A	No
log_time	BTREE	No	No	log_time	31113	A	No
user_id	BTREE	No	No	user_id	2	A	No

gjl_admin_user

Column	Type	Null	Default	Links to	Comments	MIME
user_id (Primary)	smallint(5)	No
user_name	varchar(60)	No
email	varchar(60)	Yes
password	varchar(32)	No
add_time	int(11)	Yes	0
last_login	int(11)	Yes	0
last_ip	varchar(15)	Yes
action_list	text	Yes	NULL
nav_list	text	Yes	NULL
lang_type	varchar(50)	Yes
agency_id	smallint(5)	Yes	NULL
suppliers_id	smallint(5)	Yes	0
todolist	longtext	Yes	NULL
role_id	smallint(5)	Yes	NULL
admin_purview	int(11)	Yes	NULL
admin_quanxian	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	user_id	2	A	No
user_name	BTREE	No	No	user_name	2	A	No
agency_id	BTREE	No	No	agency_id	2	A	Yes

gjl_case

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_city

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
city_name	varchar(80)	Yes	NULL
sortrank	int(11)	Yes	100
adminid	int(11)	Yes	0
siteurl	varchar(255)	Yes	NULL

Indexes

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

gjl_config

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	smallint(5)	No
parent_id	smallint(5)	No	0
code	varchar(30)	No
type	varchar(10)	No
store_range	varchar(255)	No
store_dir	varchar(255)	No
value	text	No
sort_order	tinyint(3)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	16	A	No
code	BTREE	Yes	No	code	16	A	No
parent_id	BTREE	No	No	parent_id	1	A	No

gjl_contact

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_download

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0
classid	text	Yes	NULL
product_id	text	Yes	NULL
product_attr_id	text	Yes	NULL
product_attr2_id	text	Yes	NULL

Indexes

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

gjl_home

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_jobs

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_keywords

Column	Type	Null	Default	Links to	Comments	MIME
date (Primary)	date	No	0000-00-00
searchengine (Primary)	varchar(20)	No
keyword (Primary)	varchar(90)	No
count	mediumint(8)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	date	2540	A	No
				searchengine	7371	A	No
				keyword	1348895	A	No

gjl_link

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
typeid	int(11)	Yes	0
names	varchar(255)	Yes	NULL
links	varchar(255)	Yes	NULL
logos	varchar(255)	Yes	NULL
display	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
adminid	int(11)	Yes	0
sortrank	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_mess

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
pid	int(11)	Yes	NULL
uid	int(11)	Yes	0
qq	int(13)	Yes	NULL
username	varchar(20)	Yes	NULL
companyname	varchar(200)	Yes	NULL
telphone	varchar(20)	Yes	NULL
mobilephone	varchar(20)	Yes	NULL
email	varchar(50)	Yes	NULL
mess	text	Yes	NULL
address	varchar(255)	Yes	NULL
xingzhi	varchar(200)	Yes	NULL
zhiwu	varchar(200)	Yes	NULL
contact	varchar(200)	Yes	NULL
zipcode	varchar(20)	Yes	NULL
qishu_0	int(11)	Yes	1
qishu_1	int(11)	Yes	1
ip	varchar(20)	Yes	NULL
addtime	varchar(20)	Yes	NULL
display	int(11)	No
order_id	varchar(20)	Yes	NULL
typeid	int(11)	Yes	0
code	longtext	Yes	NULL
adminid	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	727	A	No
id	BTREE	No	No	id	727	A	No
				pid	727	A	Yes
				qq	727	A	Yes
display	BTREE	No	No	display	4	A	No

gjl_network

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_news

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_product

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_searchengine

Column	Type	Null	Default	Links to	Comments	MIME
date (Primary)	date	No	0000-00-00
searchengine (Primary)	varchar(20)	No
count	mediumint(8)	No	0

Indexes

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

gjl_service_faq

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_service_query

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_sessions

Column	Type	Null	Default	Links to	Comments	MIME
sesskey (Primary)	char(32)	No
expiry	int(10)	No	0
userid	mediumint(8)	No	0
adminid	mediumint(8)	No	0
ip	char(15)	No
user_name	varchar(60)	No
user_rank	tinyint(3)	No
discount	decimal(3,2)	No
email	varchar(60)	No
data	char(255)	No

Indexes

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

gjl_sessions_data

Column	Type	Null	Default	Links to	Comments	MIME
sesskey (Primary)	varchar(32)	No
expiry	int(10)	No	0
data	longtext	No

Indexes

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

gjl_solution

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
uid	int(11)	Yes	0
title	varchar(255)	Yes	NULL
typeid	int(11)	Yes	0
litpic	text	Yes	NULL
litpic_thumb	varchar(255)	Yes	NULL
imgalt	varchar(255)	Yes	NULL
brief	varchar(255)	Yes	NULL
content	text	Yes	NULL
color	varchar(255)	Yes	NULL
flags	varchar(255)	Yes	NULL
source	varchar(255)	Yes	NULL
writer	varchar(255)	Yes	NULL
click	int(11)	Yes	0
sortrank	int(11)	Yes	0
addtime	varchar(50)	Yes	NULL
arcrank	int(11)	Yes	0
iscover	int(11)	Yes	0
tuijian	int(11)	Yes	0
display	int(11)	Yes	0
adminid	int(11)	Yes	0
otherkey	text	Yes	NULL
tags	text	Yes	NULL
tagsid	text	Yes	NULL
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
jumpurl	varchar(200)	Yes	NULL
isstop	int(11)	Yes	0
cityid	int(11)	Yes	0

Indexes

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

gjl_stats

Table comments: Table '.\onboncloud\gjl_stats' is marked as crashed and last (automatic?) repair failed

Column	Type	Null	Default	Comments	MIME

gjl_type

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
type_name	varchar(255)	No
type_name_en	varchar(255)	Yes	NULL
reid	int(11)	No	0
topid	int(11)	No	0
sortrank	int(11)	No	50
typelx	int(11)	No	0
num_ber	int(11)	No	0
sitepath	varchar(255)	Yes	NULL
siteurl	varchar(255)	Yes	NULL
weblink	varchar(255)	Yes	NULL
brief	text	Yes	NULL
content	text	Yes	NULL
description	varchar(200)	Yes	NULL		一句话简述
litpic	text	Yes	NULL
litpic_thumb	varchar(200)	Yes	NULL		缩略图
banner	varchar(255)	Yes	NULL
logo	varchar(100)	Yes	NULL		Logo
display	int(11)	No	0
redirecturl	varchar(255)	Yes	NULL
defaultname	varchar(255)	Yes	NULL
ispart	int(11)	Yes	0
issend	int(11)	Yes	0
adminid	int(11)	Yes	0
title_seo	varchar(255)	Yes	NULL
keywords_seo	text	Yes	NULL
description_seo	text	Yes	NULL
addtime	varchar(50)	Yes	time()
currency	varchar(50)	Yes	NULL
exrate	decimal(5,4)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	255	A	No
id	BTREE	No	No	id	255	A	No
reid	BTREE	No	No	reid	63	A	No
topid	BTREE	No	No	topid	4	A	No
typelx	BTREE	No	No	typelx	2	A	No
display	BTREE	No	No	display	2	A	No
type_name	BTREE	No	No	type_name	255	A	No
type_name_en	BTREE	No	No	type_name_en	1	A	Yes
siteurl	BTREE	No	No	siteurl	255	A	Yes
logo	BTREE	No	No	logo	255	A	Yes
banner	BTREE	No	No	banner	63	A	Yes
ispart	BTREE	No	No	ispart	1	A	Yes
issend	BTREE	No	No	issend	2	A	Yes