/* 以下的SQL用来在dotnetnuke中添加中文本地化的内容，
货币-支付设置中可以选择人民币--可是现在还没有人民币的支付处理器有钱也不能花/谁和银行的比较熟？？
地区设置-用来在用户注册时当选择China之后，提供一个下拉选择列表 */
/* 添加中文货币 人民币 到dotnetnuke的SQL 语句 */
/*
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Currency','RMB', '人民币(RMB) ', 0, 0, 0, 0, 0)
此语句会产生重复的Currency条目，修改红色的数字为-1，2005-03-19
*/
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Currency','RMB', '人民币(RMB) ', 0, 0, 0, -1 0)
/* 添加中国 省/直辖市(含拼音码) 到dotnetnuke的SQL 语句 */
/* 数据来源于 卫生部网站 */
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','BJ', '北京市', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','TJ', '天津市', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HE', '河北省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','SX', '山西省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','NM', '内蒙古自治区', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','LN', '辽宁省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','JL', '吉林省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HL', '黑龙江省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','SH', '上海市', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','JS', '江苏省 ', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','ZJ', '浙江省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','AH', '安徽省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','FJ', '福建省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','JX', '江西省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','SD', '山东省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HA', '河南省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HB', '湖北省 ', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HN', '湖南省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','GD', '广东省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','GX', '广西壮族自治区', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HI', '海南省 ', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','CQ', '重庆市', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','SC', '四川省 ', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','FZ', '贵州省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','YN', '云南省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','XZ', '西藏自治区', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','SN', '陕西省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','GS', '甘肃省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','QH', '青海省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','NX', '宁夏回族自治区', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','XJ', '新疆维吾尔族自治区', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','TW', '台湾省', 45, 1, 0, 0, 0)
insert into lists (listname,value,[text],ParentId,[LEVEL],SortOrder,DefinitionID,[Description]) values('Region','HK', '香港特别行政区', 45, 1, 0, 0, 0)