系统db初始化sql.sql

进销存进销存进销存进销存进销存进销存进销存进销存进销存进销存

	//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