Gnuboard4
 

 
g4_auth  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

mb_id

varchar(255)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

au_menu

varchar(20)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

au_auth

set('r','w','d')

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_auth

0

PRIMARY

1

mb_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_auth

0

PRIMARY

2

au_menu

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_board  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

bo_table

varchar(20)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

gr_id

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_subject

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_admin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_list_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_read_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_write_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_reply_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_comment_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_upload_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_download_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_html_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_link_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_trackback_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_count_delete

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_count_modify

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_read_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_write_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_comment_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_download_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_category

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_category_list

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_disable_tags

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_use_sideview

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_file_content

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_secret

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_dhtml_editor

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_rss_view

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_comment

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_good

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_nogood

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_name

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_signature

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_ip_view

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_trackback

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_list_view

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_list_content

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_table_width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_subject_len

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_page_rows

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_new

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_hot

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_image_width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_skin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_image_head

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_image_tail

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_include_head

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_include_tail

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_content_head

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_content_tail

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_insert_content

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_gallery_cols

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_upload_size

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_reply_order

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_search

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_order_search

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_count_write

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_count_comment

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_write_min

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_write_max

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_comment_min

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_comment_max

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_notice

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_upload_count

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_use_email

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bo_sort_field

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_1_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_2_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_3_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_4_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_5_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_6_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_7_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_8_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_9_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_10_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_1

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_2

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_3

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_4

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_5

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_6

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_7

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_8

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_9

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bo_10

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_board

0

PRIMARY

1

bo_table

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_board_file  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

bo_table

varchar(20)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

wr_id

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

bf_no

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

bf_source

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bf_file

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bf_download

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bf_content

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bf_filesize

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bf_width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bf_height

smallint(6)

(NULL)

NO

 

0

 

select,insert,update,references

 

bf_type

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

bf_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_board_file

0

PRIMARY

1

bo_table

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_board_file

0

PRIMARY

2

wr_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_board_file

0

PRIMARY

3

bf_no

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_board_good  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

bg_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

bo_table

varchar(20)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 

wr_id

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_id

varchar(20)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bg_flag

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

bg_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_board_good

0

PRIMARY

1

bg_id

A

0

(NULL)

(NULL)

 

BTREE

 

g4_board_good

0

fkey1

1

bo_table

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_board_good

0

fkey1

2

wr_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_board_good

0

fkey1

3

mb_id

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_board_new  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

bn_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

bo_table

varchar(20)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

wr_id

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

wr_parent

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

bn_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

mb_id

varchar(20)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_board_new

0

PRIMARY

1

bn_id

A

0

(NULL)

(NULL)

 

BTREE

 

g4_board_new

1

mb_id

1

mb_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_config  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cf_title

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_admin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_use_point

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_norobot

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_copy_log

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_email_certify

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_login_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_cut_name

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_nick_modify

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_new_skin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_login_skin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_new_rows

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_search_skin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_connect_skin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_read_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_write_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_comment_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_download_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_search_bgcolor

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_search_color

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_write_pages

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_link_target

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_delay_sec

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_filter

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_possible_ip

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_intercept_ip

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_register_skin

varchar(255)

euckr_korean_ci

NO

 

basic

 

select,insert,update,references

 

cf_member_skin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_use_homepage

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_req_homepage

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_tel

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_req_tel

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_hp

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_req_hp

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_addr

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_req_addr

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_signature

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_req_signature

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_profile

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_req_profile

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_register_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_register_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_icon_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_recommend

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_recommend_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_leave_day

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_search_part

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_use

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_wr_super_admin

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_wr_group_admin

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_wr_board_admin

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_wr_write

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_wr_comment_all

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_mb_super_admin

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_mb_member

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_email_po_super_admin

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_prohibit_id

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_prohibit_email

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_new_del

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_memo_del

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_visit_del

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_popular_del

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_jumin

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_use_member_icon

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_member_icon_size

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_member_icon_width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_member_icon_height

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_login_minutes

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_image_extension

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_flash_extension

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_movie_extension

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_formmail_is_member

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_page_rows

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_visit

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_max_po_id

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_stipulation

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_privacy

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_open_modify

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_memo_send_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

cf_1_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_2_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_3_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_4_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_5_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_6_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_7_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_8_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_9_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_10_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_1

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_2

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_3

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_4

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_5

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_6

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_7

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_8

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_9

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

cf_10

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes

Back

 
g4_group  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

gr_id

varchar(10)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

gr_subject

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_admin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_use_access

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

gr_1_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_2_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_3_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_4_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_5_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_6_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_7_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_8_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_9_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_10_subj

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_1

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_2

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_3

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_4

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_5

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_6

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_7

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_8

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_9

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

gr_10

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_group

0

PRIMARY

1

gr_id

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_group_member  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

gm_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

gr_id

varchar(255)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 

mb_id

varchar(255)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 

gm_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_group_member

0

PRIMARY

1

gm_id

A

0

(NULL)

(NULL)

 

BTREE

 

g4_group_member

1

gr_id

1

gr_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_group_member

1

mb_id

1

mb_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_login  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

lo_ip

varchar(255)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

mb_id

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

lo_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

lo_location

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

lo_url

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_login

0

PRIMARY

1

lo_ip

A

1

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_mail  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ma_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

ma_subject

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

ma_content

mediumtext

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

ma_time

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

ma_ip

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

ma_last_option

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_mail

0

PRIMARY

1

ma_id

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_member  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

mb_no

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

mb_id

varchar(255)

euckr_korean_ci

NO

UNI

 

 

select,insert,update,references

 

mb_password

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_name

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_nick

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_nick_date

date

(NULL)

NO

 

0000-00-00

 

select,insert,update,references

 

mb_email

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_homepage

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_password_q

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_password_a

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_jumin

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_sex

char(1)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_birth

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_tel

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_hp

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_zip1

char(3)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_zip2

char(3)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_addr1

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_addr2

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_signature

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_recommend

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_today_login

datetime

(NULL)

NO

MUL

0000-00-00 00:00:00

 

select,insert,update,references

 

mb_login_ip

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_datetime

datetime

(NULL)

NO

MUL

0000-00-00 00:00:00

 

select,insert,update,references

 

mb_ip

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_leave_date

varchar(8)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_intercept_date

varchar(8)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_email_certify

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

mb_memo

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_mailling

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_sms

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_open

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_open_date

date

(NULL)

NO

 

0000-00-00

 

select,insert,update,references

 

mb_profile

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_memo_call

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_1

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_2

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_3

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_4

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_5

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_6

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_7

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_8

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_9

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_10

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_member

0

PRIMARY

1

mb_no

A

1

(NULL)

(NULL)

 

BTREE

 

g4_member

0

mb_id

1

mb_id

A

1

(NULL)

(NULL)

 

BTREE

 

g4_member

1

mb_today_login

1

mb_today_login

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_member

1

mb_datetime

1

mb_datetime

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_memo  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

me_id

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

me_recv_mb_id

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

me_send_mb_id

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

me_send_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

me_read_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

me_memo

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_memo

0

PRIMARY

1

me_id

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_point  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

po_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

mb_id

varchar(20)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 

po_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 

po_content

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_rel_table

varchar(20)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_rel_id

varchar(20)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_rel_action

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_point

0

PRIMARY

1

po_id

A

0

(NULL)

(NULL)

 

BTREE

 

g4_point

1

index1

1

mb_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_point

1

index1

2

po_rel_table

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_point

1

index1

3

po_rel_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_point

1

index1

4

po_rel_action

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_poll  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

po_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

po_subject

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll1

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll2

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll3

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll4

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll5

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll6

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll7

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll8

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_poll9

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_cnt1

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt2

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt3

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt4

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt5

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt6

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt7

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt8

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_cnt9

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_etc

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

po_level

tinyint(4)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_point

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

po_date

date

(NULL)

NO

 

0000-00-00

 

select,insert,update,references

 

po_ips

mediumtext

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

mb_ids

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_poll

0

PRIMARY

1

po_id

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_poll_etc  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

pc_id

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

po_id

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

mb_id

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

pc_name

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

pc_idea

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

pc_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_poll_etc

0

PRIMARY

1

pc_id

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_popular  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

pp_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

pp_word

varchar(50)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

pp_date

date

(NULL)

NO

MUL

0000-00-00

 

select,insert,update,references

 

pp_ip

varchar(50)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_popular

0

PRIMARY

1

pp_id

A

0

(NULL)

(NULL)

 

BTREE

 

g4_popular

0

index1

1

pp_date

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_popular

0

index1

2

pp_word

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_popular

0

index1

3

pp_ip

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_scrap  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ms_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

mb_id

varchar(255)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 

bo_table

varchar(20)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

wr_id

varchar(15)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

ms_datetime

datetime

(NULL)

NO

 

0000-00-00 00:00:00

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_scrap

0

PRIMARY

1

ms_id

A

0

(NULL)

(NULL)

 

BTREE

 

g4_scrap

1

mb_id

1

mb_id

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_token  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

to_token

varchar(32)

euckr_korean_ci

NO

PRI

 

 

select,insert,update,references

 

to_datetime

datetime

(NULL)

NO

MUL

0000-00-00 00:00:00

 

select,insert,update,references

 

to_ip

varchar(255)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_token

0

PRIMARY

1

to_token

A

0

(NULL)

(NULL)

 

BTREE

 

g4_token

1

to_datetime

1

to_datetime

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_token

1

to_ip

1

to_ip

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_visit  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

vi_id

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

vi_ip

varchar(255)

euckr_korean_ci

NO

MUL

 

 

select,insert,update,references

 

vi_date

date

(NULL)

NO

MUL

0000-00-00

 

select,insert,update,references

 

vi_time

time

(NULL)

NO

 

00:00:00

 

select,insert,update,references

 

vi_referer

text

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 

vi_agent

varchar(255)

euckr_korean_ci

NO

 

 

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_visit

0

PRIMARY

1

vi_id

A

2

(NULL)

(NULL)

 

BTREE

 

g4_visit

0

index1

1

vi_ip

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

g4_visit

0

index1

2

vi_date

A

2

(NULL)

(NULL)

 

BTREE

 

g4_visit

1

index2

1

vi_date

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back

 
g4_visit_sum  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

vs_date

date

(NULL)

NO

PRI

0000-00-00

 

select,insert,update,references

 

vs_count

int(11)

(NULL)

NO

MUL

0

 

select,insert,update,references

 
Indexes
Table Non
unique		 Key
name		 Seq
in
index		 Column
name		 Collation Cardinality Sub
part		 Packed Null Index
type		 Comment

g4_visit_sum

0

PRIMARY

1

vs_date

A

1

(NULL)

(NULL)

 

BTREE

 

g4_visit_sum

1

index1

1

vs_count

A

(NULL)

(NULL)

(NULL)

 

BTREE

 

Back