//delete from currency //外幣庫（不能刪除）必須保留RMB
	update jxz_test set compname = '',registercode = '',registercode1 = '',istest = 'Y' ;
	delete from sp_ckdict; //倉庫字典
	delete from jxz_sp_ml; //商品總目錄
	delete from jxz_fhbm; //發貨/采購部門字典
	delete from jxz_cedw; //承運單位
	delete from jxz_kjhs; //會計核算月份jxz_kjhs 
	delete from jxz_khgb; //客戶國別，區域，省市，地點
	update jxz_user set last_compcode = '';
	delete from systemjd;  			//集團公司資料
	delete from systemjddetail; //集團下屬公司
	delete from system_key;
	delete from jxz_cashehbal;    //現金或銀行存款結余表
	delete from jxz_cashxxqk; //現金銀行收付詳細情況
	delete from jxz_dh_gh; //訂貨(供貨)合同
	//已經和jxz_cashehbal合并delete from jxz_ehbal; //銀行存款結余表
	//已經廢除現在從jxz_cashxxqk中直接提取delete from jxz_esefdetail; //客戶應收應付詳細情況
	delete from jxz_khbal;  //客戶應收(付)余額表
	/////////////////
	delete from jxz_khdz; //客戶地址資料
	delete from jxz_kheh; //開戶銀行
   delete from jxz_khjp; //客戶基本資料
	delete from jxz_khkheh; //客戶開戶銀行
	delete from jxz_khlxl; //聯系人
	//delete from jxz_user; //操作員字典 (必須保留一個超級用戶)
	delete from jxzht_detail; //合同詳細情況
	//已經廢除現在從sp_lkck中直接提取delete from jxzht_zx;  //合同執行情況
	delete from systemsetup;
//	update sp_kc   //更新商品庫存情況
//		set Out_num = 0,
//			 Out_price = 0,
//			 in_num = 0,
//			 in_price = 0,
//			 bf_num = 0,
//			 bf_price = 0,
//			 em_num = 0,
//			 em_price = 0	;
	delete from sp_kc; //商品庫存情況
	delete from inout_inv; //入/出庫單表頭
	delete from sp_lkck; //商品入/出庫單表體
	delete from sp_ml; //商品目錄
	//delete from jxz_khjp;
	//delete from sp_ml