Index: /temp/trunk/html/mypage/history.php
===================================================================
--- /temp/trunk/html/mypage/history.php	(revision 3346)
+++ /temp/trunk/html/mypage/history.php	(revision 4608)
@@ -23,5 +23,5 @@
 //ÉÔÀµ¥¢¥¯¥»¥¹È½Äê
 $from = "dtb_order";
-$where = "delete = 0 AND customer_id = ? AND order_id = ? ";
+$where = "del_flg = 0 AND customer_id = ? AND order_id = ? ";
 $arrval = array($objCustomer->getValue('customer_id'), $_POST['order_id']);
 //DB¤Ë¾ðÊ󤬤¢¤ë¤«È½Äê
Index: /temp/trunk/html/mypage/refusal.php
===================================================================
--- /temp/trunk/html/mypage/refusal.php	(revision 3346)
+++ /temp/trunk/html/mypage/refusal.php	(revision 4608)
@@ -42,5 +42,5 @@
 	case 'complete':
 	//²ñ°÷ºï½ü
-	$objQuery->exec("UPDATE dtb_customer SET delete=1 WHERE customer_id=?", array($objCustomer->getValue('customer_id')));
+	$objQuery->exec("UPDATE dtb_customer SET del_flg=1 WHERE customer_id=?", array($objCustomer->getValue('customer_id')));
 	$objQuery->delete("dtb_customer_mail", "email ILIKE ?", array($objCustomer->getValue('email')));
 	$objCustomer->EndSession();
Index: /temp/trunk/html/mypage/change.php
===================================================================
--- /temp/trunk/html/mypage/change.php	(revision 3531)
+++ /temp/trunk/html/mypage/change.php	(revision 4608)
@@ -96,5 +96,5 @@
 		//¥á¡¼¥ë¥¢¥É¥ì¥¹¤òÊѹ¹¤·¤Æ¤¤¤ë¾ì¹ç¡¢¥á¡¼¥ë¥¢¥É¥ì¥¹¤Î½ÅÊ£¥Á¥§¥Ã¥¯
 		if ($objPage->arrForm['email'] != $objCustomer->getValue('email')){
-			$email_cnt = $objQuery->count("dtb_customer","delete=0 AND email=?", array($objPage->arrForm['email']));
+			$email_cnt = $objQuery->count("dtb_customer","del_flg=0 AND email=?", array($objPage->arrForm['email']));
 			if ($email_cnt > 0){
 				$email_flag = false;
Index: /temp/trunk/html/mypage/login_check.php
===================================================================
--- /temp/trunk/html/mypage/login_check.php	(revision 1328)
+++ /temp/trunk/html/mypage/login_check.php	(revision 4608)
@@ -31,5 +31,5 @@
 		} else {
 			$objQuery = new SC_Query;
-			$where = "email = ? AND status = 1 AND delete = 0";
+			$where = "email = ? AND status = 1 AND del_flg = 0";
 			$ret = $objQuery->count("dtb_customer", $where, array($arrForm['mypage_login_email']));
 			
Index: /temp/trunk/html/mypage/index.php
===================================================================
--- /temp/trunk/html/mypage/index.php	(revision 3346)
+++ /temp/trunk/html/mypage/index.php	(revision 4608)
@@ -37,5 +37,5 @@
 $col = "order_id, create_date, payment_id, payment_total";
 $from = "dtb_order";
-$where = "delete = 0 AND customer_id=?";
+$where = "del_flg = 0 AND customer_id=?";
 $arrval = array($objCustomer->getvalue('customer_id'));
 $order = "order_id DESC";
Index: /temp/trunk/html/regist/index.php
===================================================================
--- /temp/trunk/html/regist/index.php	(revision 2812)
+++ /temp/trunk/html/regist/index.php	(revision 4608)
@@ -143,5 +143,5 @@
 	if (! $objErr->arrErr["id"]) {
 
-		$sql = "SELECT customer_id FROM dtb_customer WHERE secret_key = ? AND status = 1 AND delete = 0";
+		$sql = "SELECT customer_id FROM dtb_customer WHERE secret_key = ? AND status = 1 AND del_flg = 0";
 		$result = $objConn->getOne($sql, array($array["id"]));
 
Index: /temp/trunk/html/frontparts/bloc/news.php
===================================================================
--- /temp/trunk/html/frontparts/bloc/news.php	(revision 1328)
+++ /temp/trunk/html/frontparts/bloc/news.php	(revision 4608)
@@ -19,5 +19,5 @@
 function lfGetNews(){
 	$conn = new SC_DBConn();
-	$sql = "SELECT *, to_char(news_date, 'YYYY/MM/DD') as news_date_disp FROM dtb_news WHERE delete = '0' ORDER BY rank DESC";
+	$sql = "SELECT *, to_char(news_date, 'YYYY/MM/DD') as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
 	$list_data = $conn->getAll($sql);
 	return $list_data;	
Index: /temp/trunk/html/frontparts/bloc/category.php
===================================================================
--- /temp/trunk/html/frontparts/bloc/category.php	(revision 1347)
+++ /temp/trunk/html/frontparts/bloc/category.php	(revision 4608)
@@ -28,7 +28,7 @@
 	// ÅÐÏ¿¾¦ÉÊ¿ô¤Î¥Á¥§¥Ã¥¯
 	if($count_check) {
-		$where = "delete = 0 AND product_count > 0";
+		$where = "del_flg = 0 AND product_count > 0";
 	} else {
-		$where = "delete = 0";
+		$where = "del_flg = 0";
 	}
 	$objQuery->setoption("ORDER BY rank DESC");
Index: /temp/trunk/html/frontparts/login_check.php
===================================================================
--- /temp/trunk/html/frontparts/login_check.php	(revision 2689)
+++ /temp/trunk/html/frontparts/login_check.php	(revision 4608)
@@ -32,5 +32,5 @@
 		} else {
 			$objQuery = new SC_Query;
-			$where = "email ILIKE ? AND status = 1 AND delete = 0";
+			$where = "email ILIKE ? AND status = 1 AND del_flg = 0";
 			$ret = $objQuery->count("dtb_customer", $where, array($arrForm['login_email']));
 			
Index: /temp/trunk/html/js/layout_design.js
===================================================================
--- /temp/trunk/html/js/layout_design.js	(revision 4598)
+++ /temp/trunk/html/js/layout_design.js	(revision 4608)
@@ -107,10 +107,10 @@
 // Ãͤò¼èÆÀ
 function getAttrValue ( elm, attrname ) {
-/*
+
 	if (typeof(elm.attributes[ attrname ]) != 'undefined') {
 	    return elm.attributes[ attrname ].nodeValue;
 	}
-*/	
-
+
+/*
 //	if (typeof(elm.attributes.getNamedItem(attrname)) != 'object'){
 		val = "";
@@ -134,4 +134,5 @@
 		return val.value;
 //	}
+*/
 }
 
Index: /temp/trunk/html/shopping/payment.php
===================================================================
--- /temp/trunk/html/shopping/payment.php	(revision 2812)
+++ /temp/trunk/html/shopping/payment.php	(revision 4608)
@@ -122,5 +122,5 @@
 	$objQuery->setorder("fix,rank DESC");
 	//ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤»ÙʧÊýË¡¤ò¼èÆÀ
-	$arrRet = $objQuery->select("payment_id, payment_method, rule, upper_rule, note, payment_image", "dtb_payment", "delete = 0 AND deliv_id IN (SELECT deliv_id FROM dtb_deliv WHERE delete = 0) ");
+	$arrRet = $objQuery->select("payment_id, payment_method, rule, upper_rule, note, payment_image", "dtb_payment", "del_flg = 0 AND deliv_id IN (SELECT deliv_id FROM dtb_deliv WHERE del_flg = 0) ");
 	//ÍøÍѾò·ï¤«¤é»Ùʧ²ÄǽÊýË¡¤òȽÄê
 	foreach($arrRet as $data) {
Index: /temp/trunk/html/shopping/deliv.php
===================================================================
--- /temp/trunk/html/shopping/deliv.php	(revision 2192)
+++ /temp/trunk/html/shopping/deliv.php	(revision 4608)
@@ -68,5 +68,5 @@
 			// ²¾ÅÐÏ¿¤ÎȽÄê
 			$objQuery = new SC_Query;
-			$where = "email = ? AND status = 1 AND delete = 0";
+			$where = "email = ? AND status = 1 AND del_flg = 0";
 			$ret = $objQuery->count("dtb_customer", $where, array($arrForm['login_email']));
 			
Index: /temp/trunk/html/shopping/complete.php
===================================================================
--- /temp/trunk/html/shopping/complete.php	(revision 3448)
+++ /temp/trunk/html/shopping/complete.php	(revision 4608)
@@ -368,5 +368,5 @@
 function lfDeleteTempOrder($objQuery, $uniqid) {
 	$where = "order_temp_id = ?";
-	$sqlval['delete'] = 1;
+	$sqlval['del_flg'] = 1;
 	$objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid));
 	// $objQuery->delete("dtb_order_temp", $where, array($uniqid));
Index: /temp/trunk/html/admin/home.php
===================================================================
--- /temp/trunk/html/admin/home.php	(revision 1328)
+++ /temp/trunk/html/admin/home.php	(revision 4608)
@@ -58,5 +58,5 @@
 function lfGetCustomerCnt($conn){
 	
-	$sql = "SELECT COUNT(customer_id) FROM dtb_customer WHERE delete = 0 AND status = 2";
+	$sql = "SELECT COUNT(customer_id) FROM dtb_customer WHERE del_flg = 0 AND status = 2";
 	$return = $conn->getOne($sql);
 	return $return;
@@ -67,5 +67,5 @@
 	if ( $method == 'SUM' or $method == 'COUNT'){
 		$sql = "SELECT ".$method."(total) FROM dtb_order
-				 WHERE delete = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
+				 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')";
 		$return = $conn->getOne($sql);
 	}
@@ -79,5 +79,5 @@
 	if ( $method == 'SUM' or $method == 'COUNT'){
 		$sql = "SELECT ".$method."(total) FROM dtb_order
-				 WHERE delete = 0 AND to_char(create_date,'YYYY/MM') = ? 
+				 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM') = ? 
 				 AND to_char(create_date,'YYYY/MM/DD') <> to_char(now(),'YYYY/MM/DD')";
 		$return = $conn->getOne($sql, array($month));
@@ -89,5 +89,5 @@
 	$objQuery = new SC_Query();
 	$col = "SUM(point)";
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$from = "dtb_customer";
 	$ret = $objQuery->get($from, $col, $where);
@@ -97,5 +97,5 @@
 function lfGetReviewYesterday($conn){
 	$sql = "SELECT COUNT (*) FROM dtb_review 
-			 WHERE delete=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
+			 WHERE del_flg=0 AND to_char(create_date, 'YYYY/MM/DD') = to_char(now() - interval '1 days','YYYY/MM/DD')
 			 AND to_char(create_date,'YYYY/MM/DD') != to_char(now(),'YYYY/MM/DD')";
 	$return = $conn->getOne($sql);
@@ -104,5 +104,5 @@
 
 function lfGetReviewNonDisp($conn){
-	$sql = "SELECT COUNT (*) FROM dtb_review WHERE delete=0 AND status=2";
+	$sql = "SELECT COUNT (*) FROM dtb_review WHERE del_flg=0 AND status=2";
 	$return = $conn->getOne($sql);
 	return $return;
@@ -125,5 +125,5 @@
 	$col.= "to_char(create_date, 'YYYY/MM/DD HH24:MI') AS create_date";
 	$from = "dtb_order AS ord";
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$objQuery->setoption("ORDER BY create_date DESC LIMIT 10 OFFSET 0");
 	$arrRet = $objQuery->select($col, $from, $where);
Index: /temp/trunk/html/admin/batch/daily.php
===================================================================
--- /temp/trunk/html/admin/batch/daily.php	(revision 3625)
+++ /temp/trunk/html/admin/batch/daily.php	(revision 4608)
@@ -36,5 +36,5 @@
 	// ºï½ü¤µ¤ì¤¿¼õÃí¥Ç¡¼¥¿¤Î¼õÃí¾ÜºÙ¾ðÊó¤Îºï½ü
 	$objQuery = new SC_Query();
-	$where = "order_id IN (SELECT order_id FROM dtb_order WHERE delete = 1)";
+	$where = "order_id IN (SELECT order_id FROM dtb_order WHERE del_flg = 1)";
 	$objQuery->delete("dtb_order_detail", $where);
 	
@@ -112,5 +112,5 @@
 	$sql.= "int8(AVG(total)) AS total_average ";
 	$sql.= "FROM dtb_order AS T1 LEFT JOIN dtb_customer AS T2 USING ( customer_id ) ";
-	$sql.= "WHERE T1.delete = 0 AND T1.create_date BETWEEN ? AND ?";		// ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
+	$sql.= "WHERE T1.del_flg = 0 AND T1.create_date BETWEEN ? AND ?";		// ¼õÃíºîÀ®Æü¤Ç¸¡º÷¤¹¤ë
 	return $sql;
 }
@@ -204,5 +204,5 @@
 	/* ²ñ°÷½¸·× */
 	
-	$base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND delete = 0 ";
+	$base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id <> 0 AND del_flg = 0 ";
 	$where = $base_where . " AND (to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) BETWEEN ? AND ?) ";
 	
@@ -223,5 +223,5 @@
 	/* Èó²ñ°÷½¸·× */
 	
-	$base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id = 0 AND delete = 0";
+	$base_where = "WHERE (create_date BETWEEN ? AND ?) AND customer_id = 0 AND del_flg = 0";
 	$where = $base_where . " AND (to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) BETWEEN ? AND ?) ";
 	
@@ -237,5 +237,5 @@
 	
 	// ÃÂÀ¸ÆüÆþÎϤʤ·
-	$where = $base_where . " AND order_birth IS NULL AND delete = 0";
+	$where = $base_where . " AND order_birth IS NULL AND del_flg = 0";
 	lfBatOrderAgeSub($sql . $where, $start, $end, NULL, NULL, 0);	
 }
Index: /temp/trunk/html/admin/mail/template.php
===================================================================
--- /temp/trunk/html/admin/mail/template.php	(revision 1328)
+++ /temp/trunk/html/admin/mail/template.php	(revision 4608)
@@ -35,5 +35,5 @@
 	
 	// ÅÐÏ¿ºï½ü
-	$sql = "UPDATE dtb_mailmaga_template SET delete = 1 WHERE template_id = ?";
+	$sql = "UPDATE dtb_mailmaga_template SET del_flg = 1 WHERE template_id = ?";
 	$conn->query($sql, array($_GET['id']));
 	sfReload();
@@ -41,5 +41,5 @@
 
 
-$sql = "SELECT *, to_char(create_date, 'YYYY/MM/DD HH24:MI') as disp_date FROM dtb_mailmaga_template WHERE delete = 0 ORDER BY create_date DESC";
+$sql = "SELECT *, to_char(create_date, 'YYYY/MM/DD HH24:MI') as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC";
 $objPage->list_data = $list_data = $conn->getAll($sql);
 $objPage->arrMagazineType = $arrMagazineTypeAll;
Index: /temp/trunk/html/admin/mail/sendmail.php
===================================================================
--- /temp/trunk/html/admin/mail/sendmail.php	(revision 2143)
+++ /temp/trunk/html/admin/mail/sendmail.php	(revision 4608)
@@ -7,8 +7,8 @@
 if($_GET['mode'] == 'now') {
 	//----¡¡Ì¤Á÷¿®¥Ç¡¼¥¿¤ò¼èÆÀ¤¹¤ë
-	$time_data = $conn->getAll( "SELECT send_id FROM dtb_send_history  WHERE complete_count = 0 AND delete = 0 ORDER BY send_id ASC, start_date ASC" );
+	$time_data = $conn->getAll( "SELECT send_id FROM dtb_send_history  WHERE complete_count = 0 AND del_flg = 0 ORDER BY send_id ASC, start_date ASC" );
 } else {
 	$sql = "SELECT send_id FROM dtb_send_history  ";
-	$sql.= "WHERE start_date  BETWEEN current_timestamp + '- 5 minutes' AND current_timestamp + '5 minutes' AND delete = 0 ORDER BY send_id ASC, start_date ASC";
+	$sql.= "WHERE start_date  BETWEEN current_timestamp + '- 5 minutes' AND current_timestamp + '5 minutes' AND del_flg = 0 ORDER BY send_id ASC, start_date ASC";
 	//----¡¡30ʬËè¤ËCron¤¬Á÷¿®»þ´Ö¥Ç¡¼¥¿³Îǧ
 	$time_data = $conn->getAll($sql);
Index: /temp/trunk/html/admin/mail/history.php
===================================================================
--- /temp/trunk/html/admin/mail/history.php	(revision 1328)
+++ /temp/trunk/html/admin/mail/history.php	(revision 4608)
@@ -27,5 +27,5 @@
 if ( sfCheckNumLength($_GET['send_id']) && ($_GET['mode']=='delete') ){
 	
-	$sql = "UPDATE dtb_send_history SET delete = 1 WHERE send_id = ?";
+	$sql = "UPDATE dtb_send_history SET del_flg = 1 WHERE send_id = ?";
 	$conn->query($sql, array($_GET['send_id']) );
 	sfReload();
@@ -35,5 +35,5 @@
 	$from = "dtb_send_history";
 	
-	$where .= " delete = ?";
+	$where .= " del_flg = ?";
 	$arrval[] = 0;
 	
Index: /temp/trunk/html/admin/mail/htmlmail_select.php
===================================================================
--- /temp/trunk/html/admin/mail/htmlmail_select.php	(revision 1328)
+++ /temp/trunk/html/admin/mail/htmlmail_select.php	(revision 4608)
@@ -29,5 +29,5 @@
 	
 	// ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¡£¸ø³«¾¦ÉʤǤ¢¤ë¡£
-	$where = "delete = 0 AND status = 1";
+	$where = "del_flg = 0 AND status = 1";
 	
 	/* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
Index: /temp/trunk/html/admin/mail/htmlmail.php
===================================================================
--- /temp/trunk/html/admin/mail/htmlmail.php	(revision 1328)
+++ /temp/trunk/html/admin/mail/htmlmail.php	(revision 4608)
@@ -247,5 +247,5 @@
 
 	// DBÅÐÏ¿¾ðÊó
-	$sql = "SELECT * FROM dtb_mailmaga_template WHERE template_id = ? AND delete = 0";
+	$sql = "SELECT * FROM dtb_mailmaga_template WHERE template_id = ? AND del_flg = 0";
 	$result = $conn->getAll($sql, array($id));
 
Index: /temp/trunk/html/admin/mail/inc_mailmagazine.php
===================================================================
--- /temp/trunk/html/admin/mail/inc_mailmagazine.php	(revision 2732)
+++ /temp/trunk/html/admin/mail/inc_mailmagazine.php	(revision 4608)
@@ -228,5 +228,5 @@
 	global $arrMagazineTypeAll;
 	
-	$sql = "SELECT template_id, subject, mail_method FROM dtb_mailmaga_template WHERE delete = 0 ";
+	$sql = "SELECT template_id, subject, mail_method FROM dtb_mailmaga_template WHERE del_flg = 0 ";
 	if ($_POST["htmlmail"] == 2) {
 		$sql .= " AND mail_method = 2 ";	//TEXT´õ˾¼Ô¤Ø¤ÎTEST¥á¡¼¥ë¥Æ¥ó¥×¥ì¡¼¥È¥ê¥¹¥È
Index: /temp/trunk/html/admin/mail/index.php
===================================================================
--- /temp/trunk/html/admin/mail/index.php	(revision 3648)
+++ /temp/trunk/html/admin/mail/index.php	(revision 4608)
@@ -278,5 +278,5 @@
 		$col = "customer_id, order_id";
 		$from = "dtb_order LEFT JOIN dtb_order_detail USING(order_id)";
-		$where = "product_code LIKE ? AND delete = 0";
+		$where = "product_code LIKE ? AND del_flg = 0";
 		$val = sfManualEscape($keyword);
 		$arrVal[] = "%$val%";
Index: /temp/trunk/html/admin/mail/template_input.php
===================================================================
--- /temp/trunk/html/admin/mail/template_input.php	(revision 2708)
+++ /temp/trunk/html/admin/mail/template_input.php	(revision 4608)
@@ -43,5 +43,5 @@
 	
 	// ÊÔ½¸
-	$sql = "SELECT * FROM dtb_mailmaga_template WHERE template_id = ? AND delete = 0";
+	$sql = "SELECT * FROM dtb_mailmaga_template WHERE template_id = ? AND del_flg = 0";
 	$result = $conn->getAll($sql, array($_GET['template_id']));
 	$objPage->arrForm = $result[0];
Index: /temp/trunk/html/admin/total/index.php
===================================================================
--- /temp/trunk/html/admin/total/index.php	(revision 3626)
+++ /temp/trunk/html/admin/total/index.php	(revision 4608)
@@ -548,5 +548,5 @@
 	$objQuery->setGroupBy("order_sex");
 	
-	$tmp_where = $where . " AND customer_id <> 0 AND delete = 0 ";
+	$tmp_where = $where . " AND customer_id <> 0 AND del_flg = 0 ";
 	$arrRet = $objQuery->select($col, $from, $tmp_where, $arrval);
 	
@@ -559,5 +559,5 @@
 	
 	// Èó²ñ°÷½¸·×¤Î¼èÆÀ
-	$tmp_where = $where . " AND customer_id = 0 AND delete = 0 ";
+	$tmp_where = $where . " AND customer_id = 0 AND del_flg = 0 ";
 	$arrRet = $objQuery->select($col, $from, $tmp_where, $arrval);
 	// Èó²ñ°÷¹ØÆþ¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤¹¤ë¡£
@@ -616,5 +616,5 @@
 	
 	$sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average ";
-	$sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.delete = 0";
+	$sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0";
 	$sql.= "GROUP BY job ORDER BY total DESC";
 	
Index: /temp/trunk/html/admin/system/index.php
===================================================================
--- /temp/trunk/html/admin/system/index.php	(revision 3582)
+++ /temp/trunk/html/admin/system/index.php	(revision 4608)
@@ -35,13 +35,13 @@
 $objSql->setSelect("SELECT member_id,name,department,login_id,authority,rank,work FROM dtb_member");
 $objSql->setOrder("rank DESC");
-$objSql->setWhere("delete <> 1 AND member_id <> ". ADMIN_ID);
+$objSql->setWhere("del_flg <> 1 AND member_id <> ". ADMIN_ID);
 
 //´Ê°×¥¯¥¨¥ê¼Â¹Ô¥ª¥Ö¥¸¥§¥¯¥È
 $oquery = new SC_Query();
 // ¹Ô¿ô¤Î¼èÆÀ
-$linemax = $oquery->count("dtb_member", "delete <> 1 AND member_id <>".ADMIN_ID);
+$linemax = $oquery->count("dtb_member", "del_flg <> 1 AND member_id <>".ADMIN_ID);
 
 // ²ÔÆ°Ãæ¤Î·ï¿ô¤ò¼èÆÀ
-$workmax = $oquery->count("dtb_member", "work = 1 AND delete <> 1 AND member_id <>".ADMIN_ID);
+$workmax = $oquery->count("dtb_member", "work = 1 AND del_flg <> 1 AND member_id <>".ADMIN_ID);
 $objPage->workmax= $workmax;
 
Index: /temp/trunk/html/admin/system/input.php
===================================================================
--- /temp/trunk/html/admin/system/input.php	(revision 1328)
+++ /temp/trunk/html/admin/system/input.php	(revision 4608)
@@ -112,5 +112,5 @@
 	// ÊÔ½¸¥â¡¼¥É¤Ç¤Ê¤¤¾ì¹ç¤Ï¡¢½ÅÊ£¥Á¥§¥Ã¥¯
 	if (!isset($objErr->arrErr['name']) && $_POST['mode'] != 'edit') {
-		$sql = "SELECT name FROM dtb_member WHERE delete <> 1 AND name = ?";
+		$sql = "SELECT name FROM dtb_member WHERE del_flg <> 1 AND name = ?";
 		$result = $conn->getOne($sql, array($_POST['name'])); 
 		if ( $result ) {
@@ -125,5 +125,5 @@
 	// ¿·µ¬¥â¡¼¥É¤â¤·¤¯¤Ï¡¢ÊÔ½¸¥â¡¼¥É¤Ç¥í¥°¥¤¥óID¤¬Êѹ¹¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¥Á¥§¥Ã¥¯¤¹¤ë¡£
 	if (!isset($objErr->arrErr['login_id']) && $_POST['mode'] != 'edit' || ($_POST['mode'] == 'edit' && $_POST['login_id'] != $_POST['old_login_id'])) {
-		$sql = "SELECT login_id FROM dtb_member WHERE delete <> 1 AND login_id = ?";
+		$sql = "SELECT login_id FROM dtb_member WHERE del_flg <> 1 AND login_id = ?";
 		$result = $conn->getOne($sql, array($_POST['login_id'])); 
 		if ( $result != "" ) {
@@ -158,5 +158,5 @@
 	$sqlval['rank']=  $oquery->max("dtb_member", "rank") + 1;
 	$sqlval['work'] = "1"; // ²ÔƯ¤ËÀßÄê
-	$sqlval['delete'] = "0";	// ºï½ü¥Õ¥é¥°¤òOFF¤ËÀßÄê
+	$sqlval['del_flg'] = "0";	// ºï½ü¥Õ¥é¥°¤òOFF¤ËÀßÄê
 	$sqlval['creator_id'] = $_SESSION['member_id'];
 	// INSERT¤Î¼Â¹Ô
Index: /temp/trunk/html/admin/system/delete.php
===================================================================
--- /temp/trunk/html/admin/system/delete.php	(revision 1328)
+++ /temp/trunk/html/admin/system/delete.php	(revision 4608)
@@ -31,5 +31,5 @@
 	$rank = $oquery->get("dtb_member", "rank", $where);
 	// ºï½ü¤·¤¿¥ì¥³¡¼¥É¤è¤ê¾å¤Î¥é¥ó¥­¥ó¥°¤ò²¼¤²¤ÆRANK¤Î¶õ¤­¤òËä¤á¤ë¡£
-	$sqlup = "UPDATE dtb_member SET rank = (rank - 1) WHERE rank > $rank AND delete <> 1";
+	$sqlup = "UPDATE dtb_member SET rank = (rank - 1) WHERE rank > $rank AND del_flg <> 1";
 	// UPDATE¤Î¼Â¹Ô
 	$ret = $conn->query($sqlup);
@@ -40,5 +40,5 @@
 function fnDeleteRecord($conn, $id) {
 	// ¥é¥ó¥¯¤òºÇ²¼°Ì¤Ë¤¹¤ë¡¢DEL¥Õ¥é¥°ON
-	$sqlup = "UPDATE dtb_member SET rank = 0, delete = 1 WHERE member_id = $id";
+	$sqlup = "UPDATE dtb_member SET rank = 0, del_flg = 1 WHERE member_id = $id";
 	// UPDATE¤Î¼Â¹Ô
 	$ret = $conn->query($sqlup);
Index: /temp/trunk/html/admin/system/member_csv.php
===================================================================
--- /temp/trunk/html/admin/system/member_csv.php	(revision 1328)
+++ /temp/trunk/html/admin/system/member_csv.php	(revision 4608)
@@ -16,5 +16,5 @@
 	$oquery = new SC_Query();
 	$cols = "authority,name,department,login_id,work";
-	$oquery->setwhere("delete <> 1");
+	$oquery->setwhere("del_flg <> 1");
 	$oquery->andwhere("member_id <> ".ADMIN_ID);
 	$oquery->setoption("ORDER BY rank DESC");
Index: /temp/trunk/html/admin/system/update.php
===================================================================
--- /temp/trunk/html/admin/system/update.php	(revision 3677)
+++ /temp/trunk/html/admin/system/update.php	(revision 4608)
@@ -145,5 +145,5 @@
 				$sqlval['uninstall_sql'] = $arrCSV[8];				
 				$sqlval['other_files'] = $arrCSV[9];
-				$sqlval['delete'] = $arrCSV[10];
+				$sqlval['del_flg'] = $arrCSV[10];
 				$sqlval['update_date'] = "now()";
 				$sqlval['release_date'] = $arrCSV[12];
Index: /temp/trunk/html/admin/contents/inquiry.php
===================================================================
--- /temp/trunk/html/admin/contents/inquiry.php	(revision 1328)
+++ /temp/trunk/html/admin/contents/inquiry.php	(revision 4608)
@@ -76,5 +76,5 @@
 
 
-$sql = "SELECT *, to_char( create_date, 'YYYY/MM/DD' ) as disp_date FROM dtb_question WHERE delete = 0 ORDER BY question_id";
+$sql = "SELECT *, to_char( create_date, 'YYYY/MM/DD' ) as disp_date FROM dtb_question WHERE del_flg = 0 ORDER BY question_id";
 $result = $conn->getAll($sql);
 $objPage->list_data = $result;
@@ -122,5 +122,5 @@
 } elseif ( ( $_GET['mode'] == 'delete' ) && ( sfCheckNumLength($_GET['question_id']) )  ){
 
-	$sql = "UPDATE dtb_question SET delete = 1 WHERE question_id = ?";
+	$sql = "UPDATE dtb_question SET del_flg = 1 WHERE question_id = ?";
 	$conn->query( $sql, array( $_GET['question_id'] ) );
 	sfReload();
@@ -129,5 +129,5 @@
 
 			$head = sfGetCSVList($arrCVSTITLE);
-			$list_data = $conn->getAll("SELECT result_id,question_id,question_date,question_name,name01,name02,kana01,kana02,zip01,zip02,pref,addr01,addr02,tel01,tel02,tel03,mail01,question01,question02,question03,question04,question05,question06 FROM dtb_question_result WHERE delete = 0 ORDER BY result_id ASC");
+			$list_data = $conn->getAll("SELECT result_id,question_id,question_date,question_name,name01,name02,kana01,kana02,zip01,zip02,pref,addr01,addr02,tel01,tel02,tel03,mail01,question01,question02,question03,question04,question05,question06 FROM dtb_question_result WHERE del_flg = 0 ORDER BY result_id ASC");
 			$data = "";
 			for($i = 0; $i < count($list_data); $i++) {
Index: /temp/trunk/html/admin/contents/index.php
===================================================================
--- /temp/trunk/html/admin/contents/index.php	(revision 2736)
+++ /temp/trunk/html/admin/contents/index.php	(revision 4608)
@@ -104,8 +104,8 @@
 	//-- ºï½ü¤¹¤ë¿·Ãå¾ðÊó°Ê¹ß¤Îrank¤ò1¤Ä·«¤ê¾å¤²¤Æ¤ª¤¯
 	$conn->query("BEGIN");
-	$sql = "UPDATE dtb_news SET rank = rank - 1, update_date = NOW() WHERE delete = 0 AND rank > ( SELECT rank FROM dtb_news WHERE delete = 0 AND news_id = ? )";
+	$sql = "UPDATE dtb_news SET rank = rank - 1, update_date = NOW() WHERE del_flg = 0 AND rank > ( SELECT rank FROM dtb_news WHERE del_flg = 0 AND news_id = ? )";
 	$conn->query( $sql, array( $_POST['news_id']  ) );
 
-	$sql = "UPDATE dtb_news SET rank = 0, delete = 1, update_date = NOW() WHERE news_id = ?";
+	$sql = "UPDATE dtb_news SET rank = 0, del_flg = 1, update_date = NOW() WHERE news_id = ?";
 	$conn->query( $sql, array( $_POST['news_id'] ) );
 	$conn->query("COMMIT");
@@ -138,8 +138,8 @@
 
 //---- Á´¥Ç¡¼¥¿¼èÆÀ
-$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) as news_date_unix FROM dtb_news WHERE delete = '0' ORDER BY rank DESC";
+$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) as news_date_unix FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
 $objPage->list_data = $conn->getAll($sql);
 $objPage->line_max = count($objPage->list_data);
-$sql = "SELECT MAX(rank) FROM dtb_news WHERE delete = '0'";		// rank¤ÎºÇÂçÃͤò¼èÆÀ
+$sql = "SELECT MAX(rank) FROM dtb_news WHERE del_flg = '0'";		// rank¤ÎºÇÂçÃͤò¼èÆÀ
 $objPage->max_rank = $conn->getOne($sql);
 
@@ -187,10 +187,10 @@
 
 	//--¡¡»ØÄꤷ¤¿½ç°Ì¤Î¾¦Éʤ«¤é°ÜÆ°¤µ¤»¤ë¾¦ÉʤޤǤÎrank¤ò£±¤Ä¤º¤é¤¹
-	$sql = "UPDATE $tableName SET rank = rank $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND delete = 0";
+	$sql = "UPDATE $tableName SET rank = rank $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND del_flg = 0";
 	if( $position > $rank ) $conn->query( $sql, array( $rank + 1, $position ) );
 	if( $position < $rank ) $conn->query( $sql, array( $position, $rank - 1 ) );
 
 	//-- »ØÄꤷ¤¿½ç°Ì¤Ørank¤ò½ñ¤­´¹¤¨¤ë¡£
-	$sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND delete = 0 ";
+	$sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND del_flg = 0 ";
 	$conn->query( $sql, array( $position, $keyId ) );
 	$conn->query("COMMIT");
@@ -209,5 +209,5 @@
 	// rank¤ÎºÇÂçÃͰʾå¤ÎÆþÎϤòµöÍƤ·¤Ê¤¤											 
 	if( ! $objErr->arrErr["position"] ) {								 
-		$sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE delete = 0";
+		$sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE del_flg = 0";
 		$result = $conn->getOne($sql);
 		if( $position > $result ) $objErr->arrErr["moveposition"] .= "¢¨ ÆþÎϤµ¤ì¤¿½ç°Ì¤Ï¡¢ÅÐÏ¿¿ô¤ÎºÇÂçÃͤòĶ¤¨¤Æ¤¤¤Þ¤¹¡£";
@@ -243,5 +243,5 @@
 
 	$sql = "INSERT INTO dtb_news (news_date, news_title, creator_id, news_url, link_method, news_comment, rank)
-			VALUES ( ?,?,?,?,?,? , (SELECT MAX(rank) + 1 FROM dtb_news WHERE delete = '0'))";
+			VALUES ( ?,?,?,?,?,? , (SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'))";
 	$arrRegist = array($registDate, $_POST["news_title"], $_SESSION['member_id'],  $_POST["news_url"], $_POST["link_method"], $_POST["news_comment"]);
 
@@ -249,5 +249,5 @@
 	
 	// ºÇ½é¤Î1·ïÌܤÎÅÐÏ¿¤Ïrank¤ËNULL¤¬Æþ¤ë¤Î¤ÇÂкö
-	$sql = "UPDATE dtb_news SET rank = 1 WHERE delete = 0 AND rank IS NULL";
+	$sql = "UPDATE dtb_news SET rank = 1 WHERE del_flg = 0 AND rank IS NULL";
 	$conn->query($sql);
 }
Index: /temp/trunk/html/admin/contents/recommend.php
===================================================================
--- /temp/trunk/html/admin/contents/recommend.php	(revision 1328)
+++ /temp/trunk/html/admin/contents/recommend.php	(revision 4608)
@@ -70,5 +70,5 @@
 // ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
 $sql = "SELECT B.name, B.main_list_image, A.* FROM dtb_best_products as A INNER JOIN dtb_products as B USING (product_id)
-		 WHERE A.category_id = ? AND A.delete = 0 ORDER BY rank";
+		 WHERE A.category_id = ? AND A.del_flg = 0 ORDER BY rank";
 $arrItems = $conn->getAll($sql, array($objPage->category_id));
 foreach( $arrItems as $data ){
@@ -78,5 +78,5 @@
 // ¾¦ÉÊÊѹ¹»þ¤Ï¡¢ÁªÂò¤µ¤ì¤¿¾¦Éʤ˰ì»þŪ¤ËÃÖ¤­´¹¤¨¤ë
 if ( $_POST['mode'] == 'set_item'){
-	$sql = "SELECT product_id, name, main_list_image FROM dtb_products WHERE product_id = ? AND delete = 0";
+	$sql = "SELECT product_id, name, main_list_image FROM dtb_products WHERE product_id = ? AND del_flg = 0";
 	$result = $conn->getAll($sql, array($_POST['product_id']));
 	if ( $result ){
Index: /temp/trunk/html/admin/develop/csv.php
===================================================================
--- /temp/trunk/html/admin/develop/csv.php	(revision 2706)
+++ /temp/trunk/html/admin/develop/csv.php	(revision 4608)
@@ -121,5 +121,5 @@
 	}
 		
-	$sqlval['rank'] = $objQuery->max("dtb_products", "rank", "delete = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
+	$sqlval['rank'] = $objQuery->max("dtb_products", "rank", "del_flg = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
 	
 	// µ¬³ÊÅÐÏ¿
Index: /temp/trunk/html/admin/develop/upload_csv.php
===================================================================
--- /temp/trunk/html/admin/develop/upload_csv.php	(revision 2706)
+++ /temp/trunk/html/admin/develop/upload_csv.php	(revision 4608)
@@ -213,5 +213,5 @@
 	$sqlval['update_date'] = "Now()";
 	$sqlval['creator_id'] = $_SESSION['member_id'];
-	$sqlval['rank'] = $objQuery->max("dtb_products", "rank", "delete = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
+	$sqlval['rank'] = $objQuery->max("dtb_products", "rank", "del_flg = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
 	
 	// µ¬³ÊÅÐÏ¿
Index: /temp/trunk/html/admin/login.php
===================================================================
--- /temp/trunk/html/admin/login.php	(revision 1328)
+++ /temp/trunk/html/admin/login.php	(revision 4608)
@@ -25,5 +25,5 @@
 /* ǧ¾Ú¥Ñ¥¹¥ï¡¼¥É¤ÎȽÄê */
 function fnCheckPassword($conn) {
-	$sql = "SELECT member_id, password, authority, login_date, name FROM dtb_member WHERE login_id = ? AND delete <> 1 AND work = 1";
+	$sql = "SELECT member_id, password, authority, login_date, name FROM dtb_member WHERE login_id = ? AND del_flg <> 1 AND work = 1";
 	$arrcol = array ($_POST['login_id']);
 	// DB¤«¤é°Å¹æ²½¥Ñ¥¹¥ï¡¼¥É¤ò¼èÆÀ¤¹¤ë¡£
Index: /temp/trunk/html/admin/basis/delivery.php
===================================================================
--- /temp/trunk/html/admin/basis/delivery.php	(revision 1328)
+++ /temp/trunk/html/admin/basis/delivery.php	(revision 4608)
@@ -52,5 +52,5 @@
 // ÇÛÁ÷¶È¼Ô°ìÍ÷¤Î¼èÆÀ
 $col = "deliv_id, name, service_name";
-$where = "delete = 0";
+$where = "del_flg = 0";
 $table = "dtb_deliv";
 $objQuery->setorder("rank DESC");
Index: /temp/trunk/html/admin/basis/kiyaku.php
===================================================================
--- /temp/trunk/html/admin/basis/kiyaku.php	(revision 2762)
+++ /temp/trunk/html/admin/basis/kiyaku.php	(revision 4608)
@@ -137,5 +137,5 @@
 	if(!isset($objErr->arrErr['name'])) {
 		$objQuery = new SC_Query();
-		$arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "delete = 0 AND kiyaku_title = ?", array($_POST['kiyaku_title']));
+		$arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($_POST['kiyaku_title']));
 		// ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç		
 		if ($arrRet[0]['kiyaku_id'] != $_POST['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $_POST['kiyaku_title']) {
Index: /temp/trunk/html/admin/basis/payment.php
===================================================================
--- /temp/trunk/html/admin/basis/payment.php	(revision 1328)
+++ /temp/trunk/html/admin/basis/payment.php	(revision 4608)
@@ -53,5 +53,5 @@
 	// ÇÛÁ÷¶È¼Ô°ìÍ÷¤Î¼èÆÀ
 	$col = "payment_id, payment_method, charge, rule, upper_rule, note, deliv_id";
-	$where = "delete = 0 AND fix = ?";
+	$where = "del_flg = 0 AND fix = ?";
 	$table = "dtb_payment";
 	$objQuery->setorder("rank DESC");
Index: /temp/trunk/html/admin/customer/index.php
===================================================================
--- /temp/trunk/html/admin/customer/index.php	(revision 2166)
+++ /temp/trunk/html/admin/customer/index.php	(revision 4608)
@@ -118,9 +118,9 @@
 // ¸ÜµÒºï½ü
 if ($_POST['mode'] == "delete") {
-	$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+	$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
 	$result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
 
 	if ($result_customer[0]["status"] == 2) {			//Ëܲñ°÷ºï½ü
-		$arrDel = array("delete" => 1, "update_date" => "NOW()"); 
+		$arrDel = array("del_flg" => 1, "update_date" => "NOW()"); 
 		$objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
 	} elseif ($result_customer[0]["status"] == 1) {		//²¾²ñ°÷ºï½ü
@@ -138,5 +138,5 @@
 	$objPage->arrErr = lfCheckError($objPage->arrForm);
 
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 
 	/* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
@@ -197,12 +197,12 @@
 			// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
 			$where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
-			$sqlval['delete'] = 1;
+			$sqlval['del_flg'] = 1;
 			$objQuery->update("dtb_products", $sqlval, $where, $arrval);
 
-			$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+			$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
 			$result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"]));
 
 			if ($result_customer[0]["status"] == 2) {			//Ëܲñ°÷ºï½ü
-				$arrDel = array("delete" => 1, "update_date" => "NOW()");
+				$arrDel = array("del_flg" => 1, "update_date" => "NOW()");
 				$objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
 			} elseif ($result_customer[0]["status"] == 1) {		//²¾²ñ°÷ºï½ü
Index: /temp/trunk/html/admin/customer/edit.php
===================================================================
--- /temp/trunk/html/admin/customer/edit.php	(revision 4481)
+++ /temp/trunk/html/admin/customer/edit.php	(revision 4608)
@@ -103,5 +103,5 @@
 	//--¡¡¸ÜµÒ¥Ç¡¼¥¿¼èÆÀ
 	$sql = "SELECT A.*, EXTRACT(EPOCH FROM A.birth) AS birth_unix, B.mail_flag FROM dtb_customer AS A LEFT OUTER JOIN dtb_customer_mail AS B USING(email)
-			 WHERE A.delete = 0 AND A.customer_id = ?";
+			 WHERE A.del_flg = 0 AND A.customer_id = ?";
 	$result = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
 	$objPage->list_data = $result[0];
@@ -257,5 +257,5 @@
 	//¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä
 	if (strlen($array["email"]) > 0) {
-		$sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND delete = 0 AND customer_id <> ?";
+		$sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? escape '#' AND (status = 1 OR status = 2) AND del_flg = 0 AND customer_id <> ?";
 		$checkMail = ereg_replace( "_", "#_", $array["email"]);
 		$result = $objConn->getAll($sql, array($checkMail, $array["customer_id"]));
Index: /temp/trunk/html/admin/products/product_rank.php
===================================================================
--- /temp/trunk/html/admin/products/product_rank.php	(revision 1328)
+++ /temp/trunk/html/admin/products/product_rank.php	(revision 4608)
@@ -65,5 +65,5 @@
 	$col = "product_id, name, main_list_image, rank, product_code";
 	$table = "vw_products_nonclass";
-	$where = "delete = 0 AND category_id = ?";
+	$where = "del_flg = 0 AND category_id = ?";
 	
 	// ¹Ô¿ô¤Î¼èÆÀ
Index: /temp/trunk/html/admin/products/review.php
===================================================================
--- /temp/trunk/html/admin/products/review.php	(revision 1328)
+++ /temp/trunk/html/admin/products/review.php	(revision 4608)
@@ -71,5 +71,5 @@
 if ($_POST['mode'] == "delete"){
 	//¥ì¥Ó¥å¡¼¤Îºï½ü
-	$objQuery->exec("UPDATE dtb_review SET delete=1 WHERE review_id=?", array($_POST['review_id']));
+	$objQuery->exec("UPDATE dtb_review SET del_flg=1 WHERE review_id=?", array($_POST['review_id']));
 }
 	
@@ -77,5 +77,5 @@
 	
 	//ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¾¦Éʤò¸¡º÷
-	$where="A.delete = 0 AND B.delete = 0";
+	$where="A.del_flg = 0 AND B.del_flg = 0";
 	$objPage->arrForm = $_POST;
 	if (!is_array($_POST['search_sex'])){
Index: /temp/trunk/html/admin/products/classcategory.php
===================================================================
--- /temp/trunk/html/admin/products/classcategory.php	(revision 1328)
+++ /temp/trunk/html/admin/products/classcategory.php	(revision 4608)
@@ -98,5 +98,5 @@
 
 // µ¬³ÊʬÎà¤ÎÆɹþ
-$where = "delete <> 1 AND class_id = ?";
+$where = "del_flg <> 1 AND class_id = ?";
 $objQuery->setorder("rank DESC");
 $objPage->arrClassCat = $objQuery->select("name, classcategory_id", "dtb_classcategory", $where, array($_GET['class_id']));
@@ -112,5 +112,5 @@
 	$objQuery->begin();
 	// ¿Æµ¬³ÊID¤Î¸ºß¥Á¥§¥Ã¥¯
-	$where = "delete <> 1 AND class_id = ?";
+	$where = "del_flg <> 1 AND class_id = ?";
 	$ret = 	$objQuery->get("dtb_class", "class_id", $where, array($_POST['class_id']));
 	if($ret != "") {	
Index: /temp/trunk/html/admin/products/class.php
===================================================================
--- /temp/trunk/html/admin/products/class.php	(revision 2105)
+++ /temp/trunk/html/admin/products/class.php	(revision 4608)
@@ -79,5 +79,5 @@
 
 // µ¬³Ê¤ÎÆɹþ
-$where = "delete <> 1";
+$where = "del_flg <> 1";
 $objQuery->setorder("rank DESC");
 $objPage->arrClass = $objQuery->select("name, class_id", "dtb_class", $where);
@@ -134,5 +134,5 @@
 	if(!isset($objErr->arrErr['name'])) {
 		$objQuery = new SC_Query();
-		$arrRet = $objQuery->select("class_id, name", "dtb_class", "delete = 0 AND name = ?", array($_POST['name']));
+		$arrRet = $objQuery->select("class_id, name", "dtb_class", "del_flg = 0 AND name = ?", array($_POST['name']));
 		// ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç		
 		if ($arrRet[0]['class_id'] != $_POST['class_id'] && $arrRet[0]['name'] == $_POST['name']) {
Index: /temp/trunk/html/admin/products/review_edit.php
===================================================================
--- /temp/trunk/html/admin/products/review_edit.php	(revision 1328)
+++ /temp/trunk/html/admin/products/review_edit.php	(revision 4608)
@@ -45,5 +45,5 @@
 $objPage->tpl_pre_status = $objPage->arrReview['status'];
 //¾¦Éʤ´¤È¤Î¥ì¥Ó¥å¡¼É½¼¨¿ô¼èÆÀ
-$count = $objQuery->count("dtb_review", "delete=0 AND status=1 AND product_id=?", array($objPage->arrReview['product_id']));
+$count = $objQuery->count("dtb_review", "del_flg=0 AND status=1 AND product_id=?", array($objPage->arrReview['product_id']));
 //¥ì¥Ó¥å¡¼É½¼¨¿ô¤¬ÀßÄêÃͰʾå¤Î¾ì¹ç
 if ($count >= REVIEW_REGIST_MAX){
@@ -125,5 +125,5 @@
 	$select.="reviewer_url, title, comment, A.status, A.create_date, A.update_date, name";
 	$from = "dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ";
-	$where = "A.delete = 0 AND B.delete = 0 AND review_id = ? ";
+	$where = "A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? ";
 	$arrReview = $objQuery->select($select, $from, $where, array($review_id));
 	if(!empty($arrReview)) {
Index: /temp/trunk/html/admin/products/index.php
===================================================================
--- /temp/trunk/html/admin/products/index.php	(revision 3641)
+++ /temp/trunk/html/admin/products/index.php	(revision 4608)
@@ -117,5 +117,5 @@
 	$objPage->arrErr = lfCheckError();
 
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 
 	// ÆþÎÏ¥¨¥é¡¼¤Ê¤·
@@ -224,5 +224,5 @@
 			// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
 			$where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
-			$sqlval['delete'] = 1;
+			$sqlval['del_flg'] = 1;
 			$objQuery->update("dtb_products", $sqlval, $where, $arrval);
 			break;
Index: /temp/trunk/html/admin/products/bak_upload_csv.php
===================================================================
--- /temp/trunk/html/admin/products/bak_upload_csv.php	(revision 2706)
+++ /temp/trunk/html/admin/products/bak_upload_csv.php	(revision 4608)
@@ -200,5 +200,5 @@
 	$sqlval['update_date'] = "Now()";
 	$sqlval['creator_id'] = $_SESSION['member_id'];
-	$sqlval['rank'] = $objQuery->max("dtb_products", "rank", "delete = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
+	$sqlval['rank'] = $objQuery->max("dtb_products", "rank", "del_flg = 0 AND category_id = ?", array($sqlval['category_id'])) + 1;
 	
 	// µ¬³ÊÅÐÏ¿
Index: /temp/trunk/html/admin/products/category.php
===================================================================
--- /temp/trunk/html/admin/products/category.php	(revision 1328)
+++ /temp/trunk/html/admin/products/category.php	(revision 4608)
@@ -68,5 +68,5 @@
 	$objQuery = new SC_Query();
 	// »Ò¥«¥Æ¥´¥ê¤Î¥Á¥§¥Ã¥¯
-	$where = "parent_category_id = ? AND delete = 0";
+	$where = "parent_category_id = ? AND del_flg = 0";
 	$count = $objQuery->count("dtb_category", $where, array($_POST['category_id']));
 	if($count != 0) {
@@ -74,5 +74,5 @@
 	}
 	// ÅÐÏ¿¾¦ÉʤΥÁ¥§¥Ã¥¯
-	$where = "category_id = ? AND delete = 0";
+	$where = "category_id = ? AND del_flg = 0";
 	$count = $objQuery->count("dtb_products", $where, array($_POST['category_id']));
 	if($count != 0) {
@@ -190,5 +190,5 @@
 	$objQuery = new SC_Query();
 	$col = "category_id, category_name, level, rank";
-	$where = "delete = 0 AND parent_category_id = ?";
+	$where = "del_flg = 0 AND parent_category_id = ?";
 	$objQuery->setoption("ORDER BY rank DESC");
 	$arrRet = $objQuery->select($col, "dtb_category", $where, array($parent_category_id));
@@ -241,5 +241,5 @@
 	// ¤¹¤Ù¤Æ¤Î»Ò¤ò¼èÆÀ¤¹¤ë¡£
 	$col = "$id_name";
-	$where = "delete = 0 AND $pid_name = ? ORDER BY rank DESC";
+	$where = "del_flg = 0 AND $pid_name = ? ORDER BY rank DESC";
 	$arrRet = $objQuery->select($col, $table, $where, array($pid));
 	$max = count($arrRet);
@@ -262,5 +262,5 @@
 	// ¤¹¤Ù¤Æ¤Î»Ò¤ò¼èÆÀ¤¹¤ë¡£
 	$col = "$id_name";
-	$where = "delete = 0 AND $pid_name = ? ORDER BY rank DESC";
+	$where = "del_flg = 0 AND $pid_name = ? ORDER BY rank DESC";
 	$arrRet = $objQuery->select($col, $table, $where, array($pid));
 	$max = count($arrRet);
@@ -286,5 +286,5 @@
 	$line = sfGetCommaList($arrRet);
 	$sql = "UPDATE $table SET rank = (rank + $count) WHERE $id_name IN ($line) ";
-	$sql.= "AND delete = 0";
+	$sql.= "AND del_flg = 0";
 	$ret = $objQuery->exec($sql);
 	return $ret;
@@ -296,5 +296,5 @@
 	$line = sfGetCommaList($arrRet);
 	$sql = "UPDATE $table SET rank = (rank - $count) WHERE $id_name IN ($line) ";
-	$sql.= "AND delete = 0";
+	$sql.= "AND del_flg = 0";
 	$ret = $objQuery->exec($sql);
 	return $ret;
Index: /temp/trunk/html/admin/products/product_select.php
===================================================================
--- /temp/trunk/html/admin/products/product_select.php	(revision 1328)
+++ /temp/trunk/html/admin/products/product_select.php	(revision 4608)
@@ -31,5 +31,5 @@
 	lfConvertParam();
 	
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	
 	/* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
Index: /temp/trunk/html/admin/order/status.php
===================================================================
--- /temp/trunk/html/admin/order/status.php	(revision 2685)
+++ /temp/trunk/html/admin/order/status.php	(revision 4608)
@@ -98,8 +98,8 @@
 	$select ="*";
 	$from = "dtb_order";
-	$where="delete=0 AND status=?";
+	$where="del_flg=0 AND status=?";
 	$order = "order_id DESC";
 	
-	$linemax = $objQuery->count("dtb_order", "delete = 0 AND status=?", array($status));
+	$linemax = $objQuery->count("dtb_order", "del_flg = 0 AND status=?", array($status));
 	$objPage->tpl_linemax = $linemax;
 	
@@ -132,5 +132,5 @@
 	
 	if ($status_id == 'delete'){
-		$sql="UPDATE dtb_order SET delete=1";
+		$sql="UPDATE dtb_order SET del_flg=1";
 	}elseif ($status_id == 5){
 		$sql="UPDATE dtb_order SET status=".$status_id.",commit_date=now() ";
Index: /temp/trunk/html/admin/order/index.php
===================================================================
--- /temp/trunk/html/admin/order/index.php	(revision 1448)
+++ /temp/trunk/html/admin/order/index.php	(revision 4608)
@@ -76,5 +76,5 @@
 	// ÆþÎϤʤ·
 	if (count($objPage->arrErr) == 0) {
-		$where = "delete = 0";
+		$where = "del_flg = 0";
 		foreach ($arrRet as $key => $val) {
 			if($val == "") {
@@ -207,5 +207,5 @@
 		case 'delete_all':
 			// ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
-			$sqlval['delete'] = 1;
+			$sqlval['del_flg'] = 1;
 			$objQuery = new SC_Query();
 			$objQuery->update("dtb_order", $sqlval, $where, $arrval);
Index: /temp/trunk/html/forgot/index.php
===================================================================
--- /temp/trunk/html/forgot/index.php	(revision 3634)
+++ /temp/trunk/html/forgot/index.php	(revision 4608)
@@ -25,5 +25,5 @@
 	//¥á¥¢¥ÉÆþÎÏ»þ
 	$_POST['email'] = strtolower($_POST['email']);
-	$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND delete = 0";
+	$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND del_flg = 0";
 	$result = $conn->getAll($sql, array($_POST['email']) );
 	
@@ -36,5 +36,5 @@
 		$objPage->tpl_mainpage = 'forgot/secret.tpl';
 	} else {
-		$sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND delete = 0";	//²¾ÅÐÏ¿Ãæ¤Î³Îǧ
+		$sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND del_flg = 0";	//²¾ÅÐÏ¿Ãæ¤Î³Îǧ
 		$result = $conn->getAll($sql, array($_POST['email']) );
 		if ($result) {
@@ -51,5 +51,5 @@
 		// ¥Ò¥ß¥Ä¤ÎÅú¤¨¤Î²óÅú¤¬Àµ¤·¤¤¤«¥Á¥§¥Ã¥¯
 		
-		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0";
+		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0";
 		$result = $conn->getAll($sql, array($_SESSION['forgot']['email']) );
 		$data = $result[0];
Index: /temp/trunk/html/entry/kiyaku.php
===================================================================
--- /temp/trunk/html/entry/kiyaku.php	(revision 1328)
+++ /temp/trunk/html/entry/kiyaku.php	(revision 4608)
@@ -19,5 +19,5 @@
 $objQuery = new SC_Query();
 $objQuery->setorder("rank DESC");
-$arrRet = $objQuery->select("kiyaku_title, kiyaku_text", "dtb_kiyaku", "delete <> 1");
+$arrRet = $objQuery->select("kiyaku_title, kiyaku_text", "dtb_kiyaku", "del_flg <> 1");
 
 $max = count($arrRet);
Index: /temp/trunk/html/entry/index.php
===================================================================
--- /temp/trunk/html/entry/index.php	(revision 1953)
+++ /temp/trunk/html/entry/index.php	(revision 4608)
@@ -263,8 +263,8 @@
 	if (strlen($array["email"]) > 0) {
 		$objQuery = new SC_Query();
-		$arrRet = $objQuery->select("email, update_date, delete", "dtb_customer","email ILIKE ? ORDER BY delete", array($array["email"]));
+		$arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? ORDER BY del_flg", array($array["email"]));
 				
 		if(count($arrRet) > 0) {
-			if($arrRet[0]['delete'] != '1') {
+			if($arrRet[0]['del_flg'] != '1') {
 				// ²ñ°÷¤Ç¤¢¤ë¾ì¹ç
 				$objErr->arrErr["email"] .= "¢¨ ¤¹¤Ç¤Ë²ñ°÷ÅÐÏ¿¤Ç»ÈÍѤµ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤Ç¤¹¡£<br />";
Index: /temp/trunk/html/products/batch_relate.php
===================================================================
--- /temp/trunk/html/products/batch_relate.php	(revision 1328)
+++ /temp/trunk/html/products/batch_relate.php	(revision 4608)
@@ -13,5 +13,5 @@
 $objQuery->begin();
 $objQuery->delete("dtb_bat_relate_products");
-$arrCID = $objQuery->select("customer_id", "dtb_order", "delete = 0");
+$arrCID = $objQuery->select("customer_id", "dtb_order", "del_flg = 0");
 foreach($arrCID as $cdata) {
 	$where = "order_id IN (SELECT order_id FROM dtb_order WHERE customer_id = ? )";
Index: /temp/trunk/html/products/review.php
===================================================================
--- /temp/trunk/html/products/review.php	(revision 1328)
+++ /temp/trunk/html/products/review.php	(revision 4608)
@@ -93,5 +93,5 @@
 	if(sfIsInt($_GET['product_id'])) {
 		//¾¦ÉʾðÊó¤Î¼èÆÀ
-		$arrForm = $objQuery->select("product_id, name", "dtb_products", "delete = 0 AND status = 1 AND product_id=?", array($_GET['product_id']));
+		$arrForm = $objQuery->select("product_id, name", "dtb_products", "del_flg = 0 AND status = 1 AND product_id=?", array($_GET['product_id']));
 		if(empty($arrForm)) {
 			sfDispSiteError(PAGE_ERROR);
Index: /temp/trunk/html/products/detail.php
===================================================================
--- /temp/trunk/html/products/detail.php	(revision 2189)
+++ /temp/trunk/html/products/detail.php	(revision 4608)
@@ -59,7 +59,7 @@
 // ´ÉÍý¥Ú¡¼¥¸¤«¤é¤Î³Îǧ¤Î¾ì¹ç¤Ï¡¢Èó¸ø³«¤Î¾¦Éʤâɽ¼¨¤¹¤ë¡£
 if($_GET['admin'] == 'on') {
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 } else {
-	$where = "delete = 0 AND status = 1";
+	$where = "del_flg = 0 AND status = 1";
 }
 
@@ -342,5 +342,5 @@
 	$no = 0;
 	for($i = 0; $i < $max; $i++) {
-		$where = "delete = 0 AND product_id = ? AND status = 1";
+		$where = "del_flg = 0 AND product_id = ? AND status = 1";
 		$arrProductInfo = $objQuery->select("main_list_image, price02_min, price02_max, price01_min, price01_max, name, point_rate", "vw_products_allclass", $where, array($arrRet[$i]['recommend_product_id'])); 
 				
@@ -394,5 +394,5 @@
 	$col = "name, main_list_image, price01_min, price02_min, price01_max, price02_max, point_rate";
 	$from = "vw_products_allclass AS V ";
-	$where = "delete = 0 AND status = 1 AND (stock_max <> 0 OR stock_max IS NULL) AND product_id = ? ";
+	$where = "del_flg = 0 AND status = 1 AND (stock_max <> 0 OR stock_max IS NULL) AND product_id = ? ";
 	$arrval[] = $tmp_id;
 	//·ë²Ì¤Î¼èÆÀ
@@ -408,5 +408,5 @@
 	$col = "create_date, reviewer_url, reviewer_name, recommend_level, title, comment";
 	$from = "dtb_review";
-	$where = "delete = 0 AND status = 1 AND product_id = ? ";
+	$where = "del_flg = 0 AND status = 1 AND product_id = ? ";
 	$arrval[] = $id;
 	$arrReview = $objQuery->select($col, $from, $where, $arrval);
@@ -420,5 +420,5 @@
 	$col = "payment_id, rule, payment_method";
 	$from = "dtb_payment";
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$order = "payment_id";
 	$objQuery->setorder($order);
Index: /temp/trunk/html/products/detail_image.php
===================================================================
--- /temp/trunk/html/products/detail_image.php	(revision 1328)
+++ /temp/trunk/html/products/detail_image.php	(revision 4608)
@@ -15,7 +15,7 @@
 // ´ÉÍý¥Ú¡¼¥¸¤«¤é¤Î³Îǧ¤Î¾ì¹ç¤Ï¡¢Èó¸ø³«¤Î¾¦Éʤâɽ¼¨¤¹¤ë¡£
 if($_GET['admin'] == 'on') {
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 } else {
-	$where = "delete = 0 AND status = 1";
+	$where = "del_flg = 0 AND status = 1";
 }
 
Index: /temp/trunk/html/products/list.php
===================================================================
--- /temp/trunk/html/products/list.php	(revision 2787)
+++ /temp/trunk/html/products/list.php	(revision 4608)
@@ -104,5 +104,5 @@
 if($_POST['mode'] == "cart" && $_POST['product_id'] != "") {
 	// ÃͤÎÀµÅöÀ­¥Á¥§¥Ã¥¯
-	if(!sfIsInt($_POST['product_id']) || !sfIsRecord("dtb_products", "product_id", $_POST['product_id'], "delete = 0 AND status = 1")) {
+	if(!sfIsInt($_POST['product_id']) || !sfIsRecord("dtb_products", "product_id", $_POST['product_id'], "del_flg = 0 AND status = 1")) {
 		sfDispSiteError(PRODUCT_NOT_FOUND);
 	} else {
@@ -179,5 +179,5 @@
 	
 	// ¾¦Éʸ¡º÷¾ò·ï¤ÎºîÀ®¡Ê̤ºï½ü¡¢É½¼¨¡Ë
-	$where = "delete = 0 AND status = 1 ";
+	$where = "del_flg = 0 AND status = 1 ";
 	// ¥«¥Æ¥´¥ê¤«¤é¤ÎWHEREʸ»úÎó¼èÆÀ
 	if ( $category_id ) {
@@ -401,5 +401,5 @@
 	$col = "payment_id, rule, payment_method";
 	$from = "dtb_payment";
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$order = "payment_id";
 	$objQuery->setorder($order);
Index: /temp/trunk/html/rss/index.php
===================================================================
--- /temp/trunk/html/rss/index.php	(revision 3535)
+++ /temp/trunk/html/rss/index.php	(revision 4608)
@@ -68,5 +68,5 @@
 	$col .= "     ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email ";			//ÂåɽEmail¥¢¥É¥ì¥¹
 	$from = "dtb_news";
-	$where = "delete = '0'";
+	$where = "del_flg = '0'";
 	$order = "rank DESC";
 	$objQuery->setorder($order);
Index: /temp/trunk/data/class/SC_CustomerList.php
===================================================================
--- /temp/trunk/data/class/SC_CustomerList.php	(revision 2702)
+++ /temp/trunk/data/class/SC_CustomerList.php	(revision 4608)
@@ -13,5 +13,5 @@
 		if($mode == "") {
 			// ²ñ°÷ËÜÅÐÏ¿²ñ°÷¤Çºï½ü¤·¤Æ¤¤¤Ê¤¤²ñ°÷
-			$this->setWhere("status = 2 AND delete = 0 ");		
+			$this->setWhere("status = 2 AND del_flg = 0 ");		
 			// ÅÐÏ¿Æü¤ò¼¨¤¹¥«¥é¥à
 			$regdate_col = 'dtb_customer.update_date';
@@ -20,5 +20,5 @@
 		if($mode == "customer") {
 			// ´ÉÍý¼Ô¥Ú¡¼¥¸¸ÜµÒ¸¡º÷¤Î¾ì¹ç²¾ÅÐÏ¿²ñ°÷¤â¸¡º÷
-			$this->setWhere( "(status = 1 OR status = 2) AND delete = 0 ");		
+			$this->setWhere( "(status = 1 OR status = 2) AND del_flg = 0 ");		
 			// ÅÐÏ¿Æü¤ò¼¨¤¹¥«¥é¥à
 			$regdate_col = 'dtb_customer.update_date';
@@ -27,5 +27,5 @@
 		// ¥á¡¼¥ë¥Þ¥¬¥¸¥ó¤Î¾ì¹ç		
 		if($mode == "magazine") {
-			$this->setWhere("(delete = 0 OR delete IS NULL)");
+			$this->setWhere("(del_flg = 0 OR del_flg IS NULL)");
 			$this->setWhere("status = 2");
 			
Index: /temp/trunk/data/class/SC_Customer.php
===================================================================
--- /temp/trunk/data/class/SC_Customer.php	(revision 1328)
+++ /temp/trunk/data/class/SC_Customer.php	(revision 4608)
@@ -46,5 +46,5 @@
 	function getCustomerDataFromEmailPass( $pass, $email ) {
 		// ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß
-		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0 AND status = 2";
+		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
 		$result = $this->conn->getAll($sql, array($email));
 		$data = $result[0];
@@ -62,5 +62,5 @@
 	function setLogin($email) {
 		// ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß
-		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0 AND status = 2";
+		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
 		$result = $this->conn->getAll($sql, array($email));
 		$data = $result[0];
@@ -71,5 +71,5 @@
 	// ¥»¥Ã¥·¥ç¥ó¾ðÊó¤òºÇ¿·¤Î¾ðÊó¤Ë¹¹¿·¤¹¤ë
 	function updateSession() {
-		$sql = "SELECT * FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+		$sql = "SELECT * FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
 		$customer_id = $this->getValue('customer_id');
 		$arrRet = $this->conn->getAll($sql, array($customer_id));
Index: /temp/trunk/data/lib/slib.php
===================================================================
--- /temp/trunk/data/lib/slib.php	(revision 4599)
+++ /temp/trunk/data/lib/slib.php	(revision 4608)
@@ -430,5 +430,5 @@
 
 	//--¡¡»ØÄꤷ¤¿½ç°Ì¤Î¾¦Éʤ«¤é°ÜÆ°¤µ¤»¤ë¾¦ÉʤޤǤÎrank¤ò£±¤Ä¤º¤é¤¹
-	$sql = "UPDATE $tableName SET rank = $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND delete = 0";
+	$sql = "UPDATE $tableName SET rank = $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND del_flg = 0";
 	if($where != "") {
 		$sql.= " AND $where";
@@ -439,5 +439,5 @@
 
 	//-- »ØÄꤷ¤¿½ç°Ì¤Ørank¤ò½ñ¤­´¹¤¨¤ë¡£
-	$sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND delete = 0 ";
+	$sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND del_flg = 0 ";
 	if($where != "") {
 		$sql.= " AND $where";
@@ -462,5 +462,5 @@
 	if(!$delete) {
 		// ¥é¥ó¥¯¤òºÇ²¼°Ì¤Ë¤¹¤ë¡¢DEL¥Õ¥é¥°ON
-		$sqlup = "UPDATE $table SET rank = 0, delete = 1, update_date = Now() ";
+		$sqlup = "UPDATE $table SET rank = 0, del_flg = 1, update_date = Now() ";
 		$sqlup.= "WHERE $colname = ?";
 		// UPDATE¤Î¼Â¹Ô
@@ -485,5 +485,5 @@
 	$arrCol = split("[, ]", $col);
 		
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	
 	if($addwhere != "") {
@@ -774,5 +774,5 @@
 function sfGetCategoryList($addwhere = "", $products_check = false, $head = CATEGORY_HEAD) {
 	$objQuery = new SC_Query();
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	
 	if($addwhere != "") {
@@ -815,5 +815,5 @@
 	$objQuery = new SC_Query();
 	$col = "category_id, category_name, level";
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$objQuery->setoption("ORDER BY rank DESC");
 	$arrRet = $objQuery->select($col, "dtb_category", $where);
@@ -871,5 +871,5 @@
 	$objQuery = new SC_Query();
 	$col = "$keyname, $valname";
-	$objQuery->setwhere("delete = 0");
+	$objQuery->setwhere("del_flg = 0");
 	$objQuery->setorder("rank DESC");
 	$arrList = $objQuery->select($col, $table);
@@ -1000,5 +1000,5 @@
 		$where = "to_char(now(),'YYYY/MM/DD/HH24') >= to_char(start_date,'YYYY/MM/DD/HH24') AND ";
 		$where .= "to_char(now(),'YYYY/MM/DD/HH24') < to_char(end_date,'YYYY/MM/DD/HH24') AND ";
-		$where .= "delete = 0 AND campaign_id IN (SELECT campaign_id FROM dtb_campaign_detail where product_id = ? )";
+		$where .= "del_flg = 0 AND campaign_id IN (SELECT campaign_id FROM dtb_campaign_detail where product_id = ? )";
 		//ÅÐÏ¿(¹¹¿·)ÆüÉÕ½ç
 		$objQuery->setorder('update_date DESC');
@@ -1043,5 +1043,5 @@
 	$sql = "select count(dtb_class.class_id), dtb_class.class_id ";
 	$sql.= "from dtb_class inner join dtb_classcategory on dtb_class.class_id = dtb_classcategory.class_id ";
-	$sql.= "where dtb_class.delete = 0 AND dtb_classcategory.delete = 0 ";
+	$sql.= "where dtb_class.del_flg = 0 AND dtb_classcategory.del_flg = 0 ";
 	$sql.= "group by dtb_class.class_id, dtb_class.name;";
 	$objQuery = new SC_Query();
@@ -1288,5 +1288,5 @@
 	
 	if($payment_id != "") {
-		$where = "delete = 0 AND payment_id = ?";
+		$where = "del_flg = 0 AND payment_id = ?";
 		$arrRet = $objQuery->select("deliv_id", "dtb_payment", $where, array($payment_id));
 		$deliv_id = $arrRet[0]['deliv_id'];
@@ -1310,10 +1310,10 @@
 	// »Ùʧ¤¤ÊýË¡¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢Âбþ¤·¤¿ÇÛÁ÷¶È¼Ô¤ò¼èÆÀ¤¹¤ë
 	if($payment_id != "") {
-		$where = "delete = 0 AND payment_id = ?";
+		$where = "del_flg = 0 AND payment_id = ?";
 		$arrRet = $objQuery->select("deliv_id", "dtb_payment", $where, array($payment_id));
 		$deliv_id = $arrRet[0]['deliv_id'];
 	// »Ùʧ¤¤ÊýË¡¤¬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤Ï¡¢ÀèƬ¤ÎÇÛÁ÷¶È¼Ô¤ò¼èÆÀ¤¹¤ë
 	} else {
-		$where = "delete = 0";
+		$where = "del_flg = 0";
 		$objQuery->setOrder("rank DESC");
 		$objQuery->setLimitOffset(1);
@@ -1341,5 +1341,5 @@
 	$objQuery = new SC_Query();
 	// ¹ØÆþ¶â³Û¤¬¾ò·ï³Û°Ê²¼¤Î¹àÌܤò¼èÆÀ
-	$where = "delete = 0";
+	$where = "del_flg = 0";
 	$objQuery->setorder("fix, rank DESC");
 	$arrRet = $objQuery->select("payment_id, payment_method, rule", "dtb_payment", $where);
@@ -1736,5 +1736,5 @@
 	$sql = "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate,
 			 A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass as B 
-			USING (product_id) WHERE A.category_id = ? AND A.delete = 0 AND status = 1 ORDER BY A.rank";
+			USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank";
 	$arrItems = $conn->getAll($sql, array($category_id));
 	return $arrItems;
@@ -2116,5 +2116,5 @@
 	$sql .= " SELECT T1.category_id, count(T2.category_id) FROM dtb_category AS T1 LEFT JOIN dtb_products AS T2 ";
 	$sql .= " ON T1.category_id = T2.category_id  ";
-	$sql .= " WHERE T2.delete = 0 AND T2.status = 1 ";
+	$sql .= " WHERE T2.del_flg = 0 AND T2.status = 1 ";
 	$sql .= " GROUP BY T1.category_id, T2.category_id ";
 	$objQuery->query($sql);
@@ -2273,7 +2273,7 @@
 	// ÅÐÏ¿¾¦ÉÊ¿ô¤Î¥Á¥§¥Ã¥¯
 	if($count_check) {
-		$where = "delete = 0 AND product_count > 0";
-	} else {
-		$where = "delete = 0";
+		$where = "del_flg = 0 AND product_count > 0";
+	} else {
+		$where = "del_flg = 0";
 	}
 	$objQuery->setoption("ORDER BY rank DESC");