--会员等级类型
delete [PPFOR_TZB_DegreeType]
PPFOR_GO;

insert into [PPFOR_TZB_DegreeType] (DegreeTypeName,DegreeNeedPoints)
	values ('普通会员',1)
PPFOR_GO;
insert into [PPFOR_TZB_DegreeType] (DegreeTypeName,DegreeNeedPoints)
	values ('批发会员',0)
PPFOR_GO;

--添加模块
delete [PPFOR_TZB_Model]
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('新闻模块','/Admin/ContentArea/News/NewsMenu.aspx','News')
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('产品模块','/Admin/ContentArea/Product/ProductMenu.aspx','Products')
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('图片模块','/Admin/ContentArea/Picture/PicMenu.aspx','Pictures')
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('页面模块','/Admin/ContentArea/Page/PageMenu.aspx','Pages')
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('下载模块','/Admin/ContentArea/Download/FileMenu.aspx','Downloads')
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('评论模块','/Admin/ContentArea/Comment/CommentMenu.aspx','Comments')
PPFOR_GO;
insert into [PPFOR_TZB_Model] (modelName,modelUrl,modelFile)
	values ('招聘模块','/Admin/ContentArea/Job/JobMenu.aspx','Jobs')
PPFOR_GO;
--添加物流公司
delete [PPFOR_TZB_Logistics]
PPFOR_GO;
declare @id int
exec PPFOR_TZB_Logistics_Add @id out,'中国邮政EMS',	'http://www.ems.com.cn/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'申通快递',		'http://www.sto.cn/'		,0
exec PPFOR_TZB_Logistics_Add @id out,'天天快递',		'http://www.ttkd.cn/'		,0
exec PPFOR_TZB_Logistics_Add @id out,'圆通速递',		'http://www.yto.net.cn/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'顺丰速运',		'http://www.sf-express.com/',0
exec PPFOR_TZB_Logistics_Add @id out,'韵达快递',		'http://www.yundaex.com/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'中通速递',		'http://www.zto.cn/'		,0
exec PPFOR_TZB_Logistics_Add @id out,'龙邦物流',		'http://www.lbex.com.cn/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'宅急送',		'http://www.zjs.com.cn/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'全一快递',		'http://www.apex100.com/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'汇通速递',		'http://www.htky365.com/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'民航快递',		'http://www.cae.com.cn/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'亚风速递',		'http://www.broad-asia.net/',0
exec PPFOR_TZB_Logistics_Add @id out,'快捷速递',	'http://www.fastexpress.com.cn/',0
exec PPFOR_TZB_Logistics_Add @id out,'华宇物流',		'http://www.hoau.net/'		,0
exec PPFOR_TZB_Logistics_Add @id out,'中铁快运',		'http://www.cre.cn/'		,0
exec PPFOR_TZB_Logistics_Add @id out,'FedEx',		'http://www.fedex.com/cn/'	,0
exec PPFOR_TZB_Logistics_Add @id out,'UPS',			'http://www.ups.com/'		,0
exec PPFOR_TZB_Logistics_Add @id out,'DHL',			'http://www.cn.dhl.com/'	,0
PPFOR_GO;

--会员注册项
delete [PPFOR_TZB_MemberField]
PPFOR_GO;
declare @id int
declare @sex varchar(100)
set @sex='男|0'+char(13)+ '女|1'
declare @prov varchar(1000)
set @prov='北京|北京'+char(13)+'上海|上海'+char(13)+'天津|天津'+char(13)+'重庆|重庆'+char(13)+'香港|香港'+char(13)+'澳门|澳门'+char(13)+'辽宁|辽宁'+char(13)+'吉林|吉林'+char(13)+'黑龙江|黑龙江'+char(13)+'河北|河北'+char(13)+'山西|山西'+char(13)+'陕西|陕西'+char(13)+'甘肃|甘肃'+char(13)+'青海|青海'+char(13)+'山东|山东'+char(13)+'安徽|安徽'+char(13)+'江苏|江苏'+char(13)+'浙江|浙江'+char(13)+'河南|河南'+char(13)+'湖北|湖北'+char(13)+'湖南|湖南'+char(13)+'江西|江西'+char(13)+'台湾|台湾'+char(13)+'福建|福建'+char(13)+'云南|云南'+char(13)+'海南|海南'+char(13)+'四川|四川'+char(13)+'贵州|贵州'+char(13)+'广东|广东'+char(13)+'内蒙古|内蒙古'+char(13)+'新疆|新疆'+char(13)+'广西|广西'+char(13)+'西藏|西藏'+char(13)+'宁夏|宁夏'
exec PPFOR_TZB_MemberField_Add '真实姓名',	'MemberRealName',1,1,1,0,'nvarchar(255)','',8,20,9,'真实姓名只能填写汉字','^[\u4e00-\u9fa5]+$','请填写您的真实姓名','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '性别',	'MemberSex',2,1,1,7,'nvarchar(255)','0',0,0,0,'',@sex,'','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '出生日期',	'MemberBirthday',3,1,1,4,'datetime','',0,0,0,'','','格式：年-月-日 时:分:秒','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '地区',	'MemberArea',4,1,1,9,'nvarchar(255)','',0,0,0,'',@prov,'','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '联系地址',	'MemberAddress',5,1,1,0,'nvarchar(255)','',255,20,0,'','','','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '邮政编码',	'MemberCode',6,1,1,0,'nvarchar(255)','',20,20,6,'请填写6位数字的邮政编码','^\d{6}$','','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '移动电话',	'MemberMobile',7,1,1,0,'nvarchar(255)','',20,20,5,'请填写11位数字的移动号码，以13或15或18开头，可以加前缀0','^0?1[358][0-9]{9}$','','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '固定电话',	'MemberTelephone',8,1,1,0,'nvarchar(255)','',20,20,4,'','^(\(\d{3,4}\)|\d{3,4}-?)?\d{7,8}(-\d{1,5})?$','如：0755-87654321','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '安全问题',	'MemberQuestion',9,1,1,0,'nvarchar(255)','',50,20,0,'','','','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '安全回答',	'MemberAnswer',10,1,1,0,'nvarchar(255)','',50,20,0,'','','','2010-3-15 18:00:00',@id output
exec PPFOR_TZB_MemberField_Add '备注',	'MemberDetail',11,1,0,2,'ntext','',400,200,0,'','','','2010-3-15 18:00:00',@id output
update PPFOR_TZB_MemberField set [fieldIsSystem]=1
PPFOR_GO;

delete [PPFOR_TZB_PaymentType] 
PPFOR_GO;
insert into [PPFOR_TZB_PaymentType] values ('预存款支付','PreDeposit',0,'-',null,'预存款支付') 
insert into [PPFOR_TZB_PaymentType] values ('线下支付','OffLine',1,'*',null,'线下支付') 
insert into [PPFOR_TZB_PaymentType] values ('支付宝','Alipay',2,'CNY',null,'支付宝') 	
insert into [PPFOR_TZB_PaymentType] values ('PayPal','PayPal',3,'USD,CAD,EUR,GBP,JPY,AUD,NZD,CHF,HKD,SGD,SEK,DKK,PLZ,NOK,HUF,CSK',null,'PayPal')
insert into [PPFOR_TZB_PaymentType] values ('快钱网上支付','99Bill',4,'CNY','ICBC,CMB,ABC,CCB,BOC,SPDB,BCOM,CMBC,SDB,GDB,CITIC,HXB,CIB,GZRCC,GZCB,SHRCC,POST,BOB,CBHB,BJRCB,NJCB,CEB,BEA,NBCB,HZB,PAB,HSB,CZB,SHB','快钱网上支付')
PPFOR_GO;