---------------------------------------------------------------------

-- 会员卡类型

USE [QPTreasureDB]

GO

TRUNCATE TABLE GlobalLivcard

GO

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('水晶月卡',10,100000,1,30,512,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('黄金半年卡',60,600000,2,180,512,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('白金年卡',120,1200000,3,360,512,0);

--INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('在线充值类型',10,180000,0,0,0,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('在线充值类型',1,18000,0,0,0,0);

GO

-- 充值服务

TRUNCATE TABLE GlobalShareInfo

GO

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(1,'实卡充值','SK','实卡充值服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(2,'快钱充值','KQ','充值服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(3,'易宝充值','YB','易宝充值服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(4,'神州行充值','SZX','神州行服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(5,'联通卡充值','LT','联通卡服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(6,'电信卡充值','DX','电信卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(7,'盛大卡充值','SD','盛大卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(8,'征途卡充值','ZT','征途卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(9,'网易卡充值','WY','网易卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(10,'搜狐卡充值','SH','搜狐卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(11,'完美卡充值','WM','完美卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(12,'声讯充值','SX','声讯充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(13,'骏网卡充值','JW','骏网卡充值');

--新增的 2016-12-09 光明

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(14,'久游一卡通','JY','久游一卡通');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(15,'天宏一卡通','TH','天宏一卡通');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(16,'纵游一卡通','ZY','纵游一卡通');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(17,'天下通一卡通','TX','天下通一卡通');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(18,'Q币卡','QQ','Q币卡');

GO