/* 스니펫 경로에 오류 발생: The specified path was not found */
/* 구분자를 ";" 으(로) 변경 */
/* 175.126.232.177 에 MySQL (TCP/IP) 을(를) 통해 연결 중, 사용자 이름 "lions", 암호 사용: Yes… */
SELECT CONNECTION_ID();
/* 연결됨. 스레드-ID: 1990156 */
/* Unknown character set: 'utf8mb4' */
/* 문자 집합: utf8 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `lions`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`club_notice`;
SHOW COLLATION;
SHOW ENGINES;
SHOW CREATE TABLE `lions`.`admin_member`;
SELECT * FROM `lions`.`admin_member` LIMIT 1000;
SHOW CREATE TABLE `lions`.`admin_member`;
SHOW CREATE TABLE `lions`.`club_notice`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`club_notice` LIMIT 1000;
SHOW CREATE TABLE `lions`.`club_notice`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`club_notice` LIMIT 1000;
SHOW CREATE TABLE `lions`.`club_notice`;
SHOW DATABASES;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW DATABASES;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`notice00` LIMIT 1000;
SHOW CREATE TABLE `lions`.`notice00`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`notice00` ORDER BY `uid` ASC LIMIT 1000;
SHOW CREATE TABLE `lions`.`notice00`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`notice00` ORDER BY `uid` DESC LIMIT 1000;
SHOW CREATE TABLE `lions`.`notice00`;
insert into notice00 (uid,gid,adm_ck,category,userid,name,email,passwd,subject,article,is_html,is_secret,is_notice,writedate,refnum)values ('',471,'N','','총무','지구관리자','cnsn0714@gmail.com','chdan','리뉴얼 테스트 중입니다.','내용','1','0','1',1596612016,0);
/* SQL 오류 (1054): Unknown column 'is_notice' in 'field list' */
/* 영향 받은 행: 0  찾은 행: 0  경고: 0  지속 시간 0 of 1 쿼리: 0.000 sec. */
SHOW CREATE TABLE `lions`.`qna`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_notice`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`qna` ORDER BY `uid` DESC LIMIT 1000;
SHOW CREATE TABLE `lions`.`qna`;
SHOW CHARSET;
SELECT 'lions' AS `Database`, 'qna' AS `Table`, 83 AS `Rows`, 0 AS `Duration`;
/*!40101 SET @OLD_LOCAL_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
SELECT 'lions' AS `Database`, 'qna' AS `Table`, 83 AS `Rows`, 0 AS `Duration`;
/*!40101 SET @OLD_LOCAL_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
SELECT 'lions' AS `Database`, 'qna' AS `Table`, 83 AS `Rows`, 0 AS `Duration`;
/*!40101 SET @OLD_LOCAL_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
SHOW CREATE DATABASE `lions`;
SHOW CREATE TABLE `lions`.`qna`;
SELECT * FROM `lions`.`qna` LIMIT 285716;
/*!40101 SET SQL_MODE=IFNULL(@OLD_LOCAL_SQL_MODE, '') */;
SHOW CREATE TABLE `lions`.`notice00`;
SHOW CREATE TABLE `lions`.`notice00`;
ALTER TABLE `notice00`
	CHANGE COLUMN `depth` `depth` VARCHAR(255) NULL DEFAULT 'A' COMMENT '깊이' COLLATE 'utf8_general_ci' AFTER `gid`,
	CHANGE COLUMN `is_html` `is_html` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '에디터여부' AFTER `data03`,
	ADD COLUMN `is_notice` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '공지사항' AFTER `is_html`,
	CHANGE COLUMN `is_secret` `is_secret` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '비밀글' AFTER `is_notice`,
	CHANGE COLUMN `writedate` `writedate` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '작성일' COLLATE 'utf8_general_ci' AFTER `is_secret`,
	CHANGE COLUMN `refnum` `refnum` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '답변넘버' AFTER `writedate`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
ALTER TABLE `notice00`
	ADD COLUMN `ext_1` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `refnum`,
	ADD COLUMN `ext_2` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_1`,
	ADD COLUMN `ext_3` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_2`,
	ADD COLUMN `ext_4` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_3`,
	ADD COLUMN `ext_5` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_4`,
	ADD COLUMN `ext_6` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_5`,
	ADD COLUMN `ext_7` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_6`,
	ADD COLUMN `ext_8` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_7`,
	ADD COLUMN `ext_9` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_8`,
	ADD COLUMN `ext_10` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_9`;
/* SQL 오류 (1101): BLOB/TEXT column 'ext_1' can't have a default value */
ALTER TABLE `notice00`
	CHANGE COLUMN `refnum` `refnum` INT(10) UNSIGNED NOT NULL DEFAULT '' COMMENT '답변넘버' AFTER `writedate`,
	ADD COLUMN `ext_1` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `refnum`,
	ADD COLUMN `ext_2` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_1`,
	ADD COLUMN `ext_3` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_2`,
	ADD COLUMN `ext_4` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_3`,
	ADD COLUMN `ext_5` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_4`,
	ADD COLUMN `ext_6` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_5`,
	ADD COLUMN `ext_7` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_6`,
	ADD COLUMN `ext_8` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_7`,
	ADD COLUMN `ext_9` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_8`,
	ADD COLUMN `ext_10` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_9`;
/* SQL 오류 (1067): Invalid default value for 'refnum' */
ALTER TABLE `notice00`
	CHANGE COLUMN `refnum` `refnum` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '답변넘버' AFTER `writedate`,
	ADD COLUMN `ext_1` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `refnum`,
	ADD COLUMN `ext_2` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_1`,
	ADD COLUMN `ext_3` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_2`,
	ADD COLUMN `ext_4` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_3`,
	ADD COLUMN `ext_5` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_4`,
	ADD COLUMN `ext_6` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_5`,
	ADD COLUMN `ext_7` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_6`,
	ADD COLUMN `ext_8` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_7`,
	ADD COLUMN `ext_9` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_8`,
	ADD COLUMN `ext_10` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_9`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SHOW CREATE TABLE `lions`.`notice00`;







/* 스니펫 경로에 오류 발생: The specified path was not found */
/* 구분자를 ";" 으(로) 변경 */
/* 175.126.232.177 에 MySQL (TCP/IP) 을(를) 통해 연결 중, 사용자 이름 "lions", 암호 사용: Yes… */
SELECT CONNECTION_ID();
/* 연결됨. 스레드-ID: 1990156 */
/* Unknown character set: 'utf8mb4' */
/* 문자 집합: utf8 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `lions`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`club_notice`;
SHOW COLLATION;
SHOW ENGINES;
SHOW CREATE TABLE `lions`.`admin_member`;
SELECT * FROM `lions`.`admin_member` LIMIT 1000;
SHOW CREATE TABLE `lions`.`admin_member`;
SHOW CREATE TABLE `lions`.`club_notice`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`club_notice` LIMIT 1000;
SHOW CREATE TABLE `lions`.`club_notice`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`club_notice` LIMIT 1000;
SHOW CREATE TABLE `lions`.`club_notice`;
SHOW DATABASES;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW DATABASES;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`notice00` LIMIT 1000;
SHOW CREATE TABLE `lions`.`notice00`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`notice00` ORDER BY `uid` ASC LIMIT 1000;
SHOW CREATE TABLE `lions`.`notice00`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`notice00` ORDER BY `uid` DESC LIMIT 1000;
SHOW CREATE TABLE `lions`.`notice00`;
insert into notice00 (uid,gid,adm_ck,category,userid,name,email,passwd,subject,article,is_html,is_secret,is_notice,writedate,refnum)values ('',471,'N','','총무','지구관리자','cnsn0714@gmail.com','chdan','리뉴얼 테스트 중입니다.','내용','1','0','1',1596612016,0);
/* SQL 오류 (1054): Unknown column 'is_notice' in 'field list' */
/* 영향 받은 행: 0  찾은 행: 0  경고: 0  지속 시간 0 of 1 쿼리: 0.000 sec. */
SHOW CREATE TABLE `lions`.`qna`;
SELECT  `uid`,  `gid`,  `depth`,  `adm_ck`,  `category`,  `userid`,  `name`,  `email`,  `passwd`,  `subject`,  LEFT(`article`, 256),  `data01`,  `data02`,  `data03`,  `is_html`,  `is_notice`,  `is_secret`,  `writedate`,  `refnum` FROM `lions`.`qna` ORDER BY `uid` DESC LIMIT 1000;
SHOW CREATE TABLE `lions`.`qna`;
SHOW CHARSET;
SELECT 'lions' AS `Database`, 'qna' AS `Table`, 83 AS `Rows`, 0 AS `Duration`;
/*!40101 SET @OLD_LOCAL_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
SELECT 'lions' AS `Database`, 'qna' AS `Table`, 83 AS `Rows`, 0 AS `Duration`;
/*!40101 SET @OLD_LOCAL_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
SELECT 'lions' AS `Database`, 'qna' AS `Table`, 83 AS `Rows`, 0 AS `Duration`;
/*!40101 SET @OLD_LOCAL_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
SHOW CREATE DATABASE `lions`;
SHOW CREATE TABLE `lions`.`qna`;
SELECT * FROM `lions`.`qna` LIMIT 285716;
/*!40101 SET SQL_MODE=IFNULL(@OLD_LOCAL_SQL_MODE, '') */;
SHOW CREATE TABLE `lions`.`notice00`;
SHOW CREATE TABLE `lions`.`notice00`;
ALTER TABLE `notice00`
	CHANGE COLUMN `depth` `depth` VARCHAR(255) NULL DEFAULT 'A' COMMENT '깊이' COLLATE 'utf8_general_ci' AFTER `gid`,
	CHANGE COLUMN `is_html` `is_html` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '에디터여부' AFTER `data03`,
	ADD COLUMN `is_notice` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '공지사항' AFTER `is_html`,
	CHANGE COLUMN `is_secret` `is_secret` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '비밀글' AFTER `is_notice`,
	CHANGE COLUMN `writedate` `writedate` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '작성일' COLLATE 'utf8_general_ci' AFTER `is_secret`,
	CHANGE COLUMN `refnum` `refnum` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT '답변넘버' AFTER `writedate`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
ALTER TABLE `notice00`
	ADD COLUMN `ext_1` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `refnum`,
	ADD COLUMN `ext_2` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_1`,
	ADD COLUMN `ext_3` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_2`,
	ADD COLUMN `ext_4` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_3`,
	ADD COLUMN `ext_5` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_4`,
	ADD COLUMN `ext_6` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_5`,
	ADD COLUMN `ext_7` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_6`,
	ADD COLUMN `ext_8` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_7`,
	ADD COLUMN `ext_9` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_8`,
	ADD COLUMN `ext_10` TEXT NULL DEFAULT '0' COMMENT '여유필드' AFTER `ext_9`;
/* SQL 오류 (1101): BLOB/TEXT column 'ext_1' can't have a default value */
ALTER TABLE `notice00`
	CHANGE COLUMN `refnum` `refnum` INT(10) UNSIGNED NOT NULL DEFAULT '' COMMENT '답변넘버' AFTER `writedate`,
	ADD COLUMN `ext_1` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `refnum`,
	ADD COLUMN `ext_2` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_1`,
	ADD COLUMN `ext_3` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_2`,
	ADD COLUMN `ext_4` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_3`,
	ADD COLUMN `ext_5` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_4`,
	ADD COLUMN `ext_6` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_5`,
	ADD COLUMN `ext_7` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_6`,
	ADD COLUMN `ext_8` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_7`,
	ADD COLUMN `ext_9` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_8`,
	ADD COLUMN `ext_10` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_9`;
/* SQL 오류 (1067): Invalid default value for 'refnum' */
ALTER TABLE `notice00`
	CHANGE COLUMN `refnum` `refnum` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '답변넘버' AFTER `writedate`,
	ADD COLUMN `ext_1` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `refnum`,
	ADD COLUMN `ext_2` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_1`,
	ADD COLUMN `ext_3` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_2`,
	ADD COLUMN `ext_4` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_3`,
	ADD COLUMN `ext_5` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_4`,
	ADD COLUMN `ext_6` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_5`,
	ADD COLUMN `ext_7` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_6`,
	ADD COLUMN `ext_8` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_7`,
	ADD COLUMN `ext_9` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_8`,
	ADD COLUMN `ext_10` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' AFTER `ext_9`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SHOW CREATE TABLE `lions`.`notice00`;
ALTER TABLE `notice00`
	CHANGE COLUMN `ext_1` `ext_1` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `refnum`,
	CHANGE COLUMN `ext_2` `ext_2` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_1`,
	CHANGE COLUMN `ext_3` `ext_3` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_2`,
	CHANGE COLUMN `ext_4` `ext_4` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_3`,
	CHANGE COLUMN `ext_5` `ext_5` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_4`,
	CHANGE COLUMN `ext_6` `ext_6` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_5`,
	CHANGE COLUMN `ext_7` `ext_7` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_6`,
	CHANGE COLUMN `ext_8` `ext_8` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_7`,
	CHANGE COLUMN `ext_9` `ext_9` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_8`,
	CHANGE COLUMN `ext_10` `ext_10` TEXT NOT NULL DEFAULT '' COMMENT '여유필드' COLLATE 'utf8_bin' AFTER `ext_9`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='lions';
SHOW TABLE STATUS FROM `lions`;
SHOW FUNCTION STATUS WHERE `Db`='lions';
SHOW PROCEDURE STATUS WHERE `Db`='lions';
SHOW TRIGGERS FROM `lions`;
SHOW CREATE TABLE `lions`.`notice00`;
/* "크몽\인피니티\라이온지/ lionslions" 세션 시작 */
SHOW CREATE TABLE `lions`.`notice00`;