Index: branches/dev/html/admin/mail/index.php
===================================================================
--- branches/dev/html/admin/mail/index.php	(revision 17)
+++ branches/dev/html/admin/mail/index.php	(revision 11611)
@@ -106,6 +106,4 @@
 
 if($_POST['mode'] == 'delete') {
-	$objQuery = new SC_Query();
-	$objQuery->delete("dtb_customer_mail", "email = ?", array($_POST['result_email']));
 }
 
@@ -140,5 +138,5 @@
 		// ¸¡º÷·ë²Ì¤Î¼èÆÀ
 		$objQuery = new SC_Query();
-		$from = "dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
+		$from = "dtb_customer";
 
 		// ¹Ô¿ô¤Î¼èÆÀ
@@ -167,5 +165,5 @@
 			dtb_customer.tel03,
 			dtb_customer.pref,
-			dtb_customer_mail.mail_flag";
+			dtb_customer.mail_flag";
 		$objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
 
Index: branches/dev/data/class/SC_CustomerList.php
===================================================================
--- branches/dev/data/class/SC_CustomerList.php	(revision 11577)
+++ branches/dev/data/class/SC_CustomerList.php	(revision 11611)
@@ -67,5 +67,5 @@
 			*/
 			// ÅÐÏ¿Æü¤ò¼¨¤¹¥«¥é¥à
-			$regdate_col = 'dtb_customer_mail.create_date';
+			$regdate_col = 'dtb_customer.create_date';
 		}
 				
@@ -301,15 +301,4 @@
 	}
 	
-	function getListMailMagazineCount() {
-		$this->select = "SELECT COUNT(*) FROM dtb_customer_mail LEFT OUTER JOIN dtb_customer USING(email)";
-		return $this->getSql(0);	
-	}
-	//¹ØÆþ¾¦ÉÊ¥³¡¼¥É¸¡º÷ÍÑSQL
-	function getBuyList(){
-		$this->select = "SELECT A.customer_id, A.name01, A.name02, A.kana01, A.kana02, A.sex, A.email, A.tel01, A.tel02, A.tel03, A.pref, A.mailmaga_flg, B.order_email, B.order_id, C.product_code 
-						FROM (dtb_customer LEFT OUTER JOIN dtb_customer_mail USING (email)) AS A LEFT OUTER JOIN dtb_order AS B ON 
-						A.email=B.order_email LEFT OUTER JOIN dtb_order_detail AS C ON B.order_id = C.order_id";
-	}
-
 	//¡¡¸¡º÷Áí¿ô¥«¥¦¥ó¥ÈÍÑSQL
 	function getListCount() {
Index: branches/dev/data/lib/slib.php
===================================================================
--- branches/dev/data/lib/slib.php	(revision 11583)
+++ branches/dev/data/lib/slib.php	(revision 11611)
@@ -2283,13 +2283,7 @@
 	$arrRegist["update_date"] = "NOW()";
 	
-	$sqlval["create_date"] = "NOW()";
-	$sqlval["update_date"] = "NOW()";
-	$sqlval['email'] = $array['email'];
-	$sqlval['mail_flag'] = $array['mail_flag'];
 	//-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô
 	$objQuery->begin();
 	$objQuery->update("dtb_customer", $arrRegist, "customer_id = ? ", array($array['customer_id']));
-	$objQuery->delete("dtb_customer_mail", "email = ?", array($array['email']));
-	$objQuery->insert("dtb_customer_mail", $sqlval);
 	$objQuery->commit();
 }