| |
|
|
| |
게시판소스
|
|
|
|
|
| 글쓴이 |
정광천 |
조회수 |
2912 |
|
| 이메일 |
|
작성일 |
2005-01-31 10:50:02 |
|
| 파일 |
|
|
| 제목 |
게시판 SQL |
|
<![CDATA[
#
# tb_cyboard_id_code
#
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| seq | int(11) | | PRI | NULL | auto_increment |
| no | int(11) | | PRI | 0 | |
| re_no | varchar(100) | | PRI | | |
| notice_no | int(11) | YES | | NULL | |
| title | varchar(100) | YES | | NULL | |
| content | longtext | YES | | NULL | |
| input_date | datetime | YES | | NULL | |
| cnt | int(10) | YES | | NULL | |
| email | varchar(100) | YES | | NULL | |
| homepage | varchar(100) | YES | | NULL | |
| ip_address | varchar(20) | YES | | NULL | |
| agent | varchar(50) | YES | | NULL | |
| id | varchar(50) | YES | | NULL | |
| name | varchar(50) | YES | | NULL | |
| password | varchar(12) | YES | | NULL | |
| html_kind | int(1) | YES | | 0 | |
| secret_kind | int(1) | YES | | 0 | |
| mail_kind | int(1) | YES | | 0 | |
| file1_name | varchar(50) | YES | | NULL | |
| file1_rename | varchar(50) | YES | | NULL | |
| file1_type | varchar(50) | YES | | NULL | |
| file1_size | int(10) | YES | | NULL | |
| file1_route | varchar(100) | YES | | NULL | |
| file2_name | varchar(50) | YES | | NULL | |
| file2_rename | varchar(50) | YES | | NULL | |
| file2_type | varchar(50) | YES | | NULL | |
| file2_size | int(10) | YES | | NULL | |
| file2_route | varchar(100) | YES | | NULL | |
| file3_name | varchar(50) | YES | | NULL | |
| file3_rename | varchar(50) | YES | | NULL | |
| file3_type | varchar(50) | YES | | NULL | |
| file3_size | int(10) | YES | | NULL | |
| file3_route | varchar(100) | YES | | NULL | |
| file4_name | varchar(50) | YES | | NULL | |
| file4_rename | varchar(50) | YES | | NULL | |
| file4_type | varchar(50) | YES | | NULL | |
| file4_size | int(10) | YES | | NULL | |
| file4_route | varchar(100) | YES | | NULL | |
| file5_name | varchar(50) | YES | | NULL | |
| file5_rename | varchar(50) | YES | | NULL | |
| file5_type | varchar(50) | YES | | NULL | |
| file5_size | int(10) | YES | | NULL | |
| file5_route | varchar(100) | YES | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
alter table tb_cyboard_nig0412_work add id varchar(50) after agent;
alter table tb_cyboard_nig0412_work change file_name file1_name varchar(50);
alter table tb_cyboard_nig0412_work change file_rename file1_rename varchar(50);
alter table tb_cyboard_nig0412_work change file_type file1_type varchar(50);
alter table tb_cyboard_nig0412_work change file_size file1_size int(10);
alter table tb_cyboard_nig0412_work drop file_route;
alter table tb_cyboard_nig0412_work add file2_name varchar(50);
alter table tb_cyboard_nig0412_work add file2_rename varchar(50);
alter table tb_cyboard_nig0412_work add file2_type varchar(50);
alter table tb_cyboard_nig0412_work add file2_size int(10);
alter table tb_cyboard_nig0412_work add file3_name varchar(50);
alter table tb_cyboard_nig0412_work add file3_rename varchar(50);
alter table tb_cyboard_nig0412_work add file3_type varchar(50);
alter table tb_cyboard_nig0412_work add file3_size int(10);
alter table tb_cyboard_nig0412_work add file4_name varchar(50);
alter table tb_cyboard_nig0412_work add file4_rename varchar(50);
alter table tb_cyboard_nig0412_work add file4_type varchar(50);
alter table tb_cyboard_nig0412_work add file4_size int(10);
alter table tb_cyboard_nig0412_work add file5_name varchar(50);
alter table tb_cyboard_nig0412_work add file5_rename varchar(50);
alter table tb_cyboard_nig0412_work add file5_type varchar(50);
alter table tb_cyboard_nig0412_work add file5_size int(10);
]]>
|
| IP Address : 210.118.178.165 |
|
|
|
|
|
|
| |
|
|
