head	1.6;
access;
symbols
	JSBoard-2_0_15:1.5
	JSBoard-2_0_14:1.4
	JSBoard-2_0_13:1.4
	JSBoard-2_0_12:1.4
	JSBoard-2_0_11:1.4
	JSBoard-2_0_10:1.4
	JSBoard-2_0_9:1.4
	JSBoard-2_0_7:1.4
	JSBoard-2_0_6:1.3
	JSBoard-2_0_5:1.3
	JSboard-2:1.3
	branch-release-1-0:1.3.0.2
	JSBoard-2_0_4:1.3
	JSBoard-2_0_3:1.3
	JSBoard-2_0_2:1.3
	JSBoard-2_0_1:1.3
	JSBoard-2_0_0:1.3
	JSBoard-2_0pre4:1.3
	jsboard-2_0pre3:1.2;
locks; strict;
comment	@# @;


1.6
date	2014.03.02.17.11.30;	author oops;	state Exp;
branches;
next	1.5;

1.5
date	2009.11.19.05.29.50;	author oops;	state Exp;
branches;
next	1.4;

1.4
date	2004.03.11.18.57.36;	author oops;	state Exp;
branches;
next	1.3;

1.3
date	2002.02.04.05.42.15;	author oops;	state Exp;
branches;
next	1.2;

1.2
date	2001.12.29.08.07.55;	author oops;	state Exp;
branches;
next	1.1;

1.1
date	2001.12.27.09.35.15;	author oops;	state Exp;
branches;
next	;


desc
@@


1.6
log
@[#301110] change charset to utf-8
@
text
@#!/bin/sh
# $Id: dbconv_to_20,v 1.5 2009/11/19 05:29:50 oops Exp $

# 아래의 정보들은 global.php 의 DB 정보와 동일하게 입력함.
# jsboard 에 접근할 유저이름
DB_USER=

# jsboard 에 접근할 유저 패스워드
DB_PASS=

# jsboard 가 사용할 database 이름
DB_NAME=

# 만약 사용하는 database 에 JSBoard 가 사용하는 table 외의 다른
# 테이블이 존재할 경우에는 JSBoard 가 사용할 table 들을 직접 지
# 정해 줘야 한다.
# ex> TARGET="qna faq freeboard"
#
TARGET=""

# mysql client path
# find /usr -name mysql 로 찾도록 한다.
MPATH=/usr/bin/mysql

if [ "${TARGET}" = "" ]; then
  TARGET=$(mysql -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "show tables" | grep  -v "Tables_in_\|userdb")
fi

for i in ${TARGET}
do
  if [ "${TARGET}" != "userdb" ]; then
    echo "Converting ${i} table ......."
    ${MPATH} -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "ALTER TABLE ${i} ADD rname tinytext"
    ${MPATH} -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "ALTER TABLE ${i} DROP moder"
    ${MPATH} -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "ALTER TABLE ${i} MODIFY passwd varchar(56)"
  fi
done

exit 0
@


1.5
log
@add cvs id
@
text
@d2 1
a2 1
# $Id: $
d4 2
a5 2
# Ʒ  global.php  DB  ϰ Է.
# jsboard   ̸
d8 1
a8 1
# jsboard    н
d11 1
a11 1
# jsboard   database ̸
d14 3
a16 3
#  ϴ database  JSBoard  ϴ table  ٸ
# ̺  쿡 JSBoard   table   
#   Ѵ.
d22 1
a22 1
# find /usr -name mysql  ã Ѵ.
@


1.4
log
@changed file extension .ph to .php
@
text
@d2 1
@


1.3
log
@fixed syntax error of /INSTALLER/script/dbconv_to_20
@
text
@d3 1
a3 1
# Ʒ  global.ph  DB  ϰ Է.
@


1.2
log
@update 20011229170524.diff
@
text
@d24 1
a24 1
if [ ${TARGET} = "" ]; then
d30 1
a30 1
  if [ ${TARGET} != "userdb" ]; then
@


1.1
log
@patched 20011227180615.diff
@
text
@d13 7
d24 3
a26 1
TARGET=$(mysql -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "show tables" | grep  -v "Tables_in_\|userdb")
d30 6
a35 4
  echo "Converting ${i} table ......."
  ${MPATH} -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "ALTER TABLE ${i} CHANGE moder rname tinytext"
  ${MPATH} -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "ALTER TABLE ${i} DROP moder"
  ${MPATH} -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "ALTER TABLE ${i} MODIFY passwd varchar(56)"
@

