27,580
社区成员
发帖
与我相关
我的任务
分享设计一个游戏中角色和背包的MySql表结构
想 设计一个游戏中角色和背包的MySql表结构，大概下面5点，不知道sql语句怎么定
1.创建角色
2.删除角色
3.背包获得一个道具
4.道具数量
5.删除道具
1.创建角色
2.删除角色
3.背包获得一个道具
4.道具数量
5.删除道具
...全文
请发表友善的回复…
发表回复
不穿内裤的超人 2015-12-07
- 打赏
- 举报
哦！你都知道还问
yu_1992_11_25 2015-12-05
- 打赏
- 举报
竟然和我们公司一样。。。。。。
不穿内裤的超人 2015-12-03
- 打赏
- 举报
CREATE TABLE [dbo].[TBL_PLAYER_BASE](
[guid] [uniqueidentifier] NOT NULL,
[Name] [nvarchar](20) NOT NULL,
[Account] [nvarchar](32) NOT NULL,
[Levels] [int] NOT NULL,
[Occupation] [int] NOT NULL,
[Sex] [int] NOT NULL,
[Country] [int] NOT NULL,
[Region] [int] NOT NULL,
[LogoutTime] [int] NOT NULL,
[HEAD] [int] NOT NULL,
[HAIR] [int] NOT NULL,
[FACE] [int] NOT NULL,
[HeadLevel] [int] NOT NULL,
[NECKLACE] [int] NOT NULL,
[NecklaceLevel] [int] NOT NULL,
[WING] [int] NOT NULL,
[WingLevel] [int] NOT NULL,
[BODY] [int] NOT NULL,
[BodyLevel] [int] NOT NULL,
[BACK] [int] NOT NULL,
[BackLevel] [int] NOT NULL,
[GLOVE] [int] NOT NULL,
[GloveLevel] [int] NOT NULL,
[BOOT] [int] NOT NULL,
[BootLevel] [int] NOT NULL,
[HEADGEAR] [int] NOT NULL,
[HeadgearLevel] [int] NOT NULL,
[FROCK] [int] NOT NULL,
[FrockLevel] [int] NOT NULL,
[LRING] [int] NOT NULL,
[LRingLevel] [int] NOT NULL,
[RRING] [int] NOT NULL,
[RRingLevel] [int] NOT NULL,
[MEDAL1] [int] NOT NULL,
[Medal1Level] [int] NOT NULL,
[MEDAL2] [int] NOT NULL,
[Medal2Level] [int] NOT NULL,
[MEDAL3] [int] NOT NULL,
[Medal3Level] [int] NOT NULL,
[FAIRY] [int] NOT NULL,
[FairyLevel] [int] NOT NULL,
[WEAPON] [int] NOT NULL,
[WeaponLevel] [int] NOT NULL,
[CLOAK] [int] NOT NULL,
[CloakLevel] [int] NOT NULL,
[WEAPON2] [int] NOT NULL,
[Weapon2Level] [int] NOT NULL,
[DelDate] [int] NOT NULL,
CONSTRAINT [PK_TBL_PLAYER_BASE] PRIMARY KEY NONCLUSTERED
(
[guid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]CREATE TABLE [dbo].[TBL_PLAYER_DETAIL](
[guid] [uniqueidentifier] NOT NULL,
[Account] [nvarchar](32) NOT NULL,
[Name] [nvarchar](20) NOT NULL,
[Levels] [int] NOT NULL,
[Occupation] [int] NOT NULL,
[Const] [int] NOT NULL,
[byAssOccu] [int] NOT NULL,
[Sex] [int] NOT NULL,
[Country] [int] NOT NULL,
[RegionID] [int] NOT NULL,
[DupRgnID] [uniqueidentifier] NOT NULL,
[PosX] [int] NOT NULL,
[PosY] [int] NOT NULL,
[Dir] [int] NOT NULL,
[HeadPic] [int] NOT NULL,
[FacePic] [int] NOT NULL,
[Hp] [int] NOT NULL,
[Mp] [int] NOT NULL,
[Energy] [int] NOT NULL,
[Stamina] [int] NOT NULL,
[ticket] [int] NOT NULL,
[Exp] [int] NOT NULL,
[ExpMultiple] [int] NOT NULL,
[PresentExp] [int] NOT NULL,
[RankOfNobility] [int] NOT NULL,
[RankOfNobCredit] [int] NOT NULL,
[RankOfMercenary] [int] NOT NULL,
[MercenaryCredit] [int] NOT NULL,
[BatakCredit] [int] NOT NULL,
[MedalScores] [int] NOT NULL,
[CountryContribute] [int] NOT NULL,
[SpouseID] [int] NOT NULL,
[SpouseParam] [int] NOT NULL,
[BusinessLevel] [int] NOT NULL,
[IsBusinessMan] [int] NOT NULL,
[BusinessExp] [int] NOT NULL,
[ArtisanLevel] [int] NOT NULL,
[ArtisanExp] [int] NOT NULL,
[PKCount] [int] NOT NULL,
[PKValue] [int] NOT NULL,
[PVPCount] [int] NOT NULL,
[PVPValue] [int] NOT NULL,
[PKOnOff] [int] NOT NULL,
[LastExitGameTime] [int] NOT NULL,
[TileType] [int] NOT NULL,
[ShowCountry] [int] NOT NULL,
[silence] [int] NOT NULL,
[lState] [int] NOT NULL,
[byShowFashion] [int] NOT NULL,
[ZanDoHunterCredit] [int] NOT NULL,
[ChurchCredit] [int] NOT NULL,
[CurrBaseActive] [int] NOT NULL,
[CurrExActive] [int] NOT NULL,
[ActiveTime] [int] NOT NULL,
[MarriageStep] [int] NOT NULL,
[PHGUID] [uniqueidentifier] NOT NULL,
[HotKey] [image] NULL,
[HotKeyVector] [image] NULL,
[OccuLvl] [image] NULL,
[OccuExp] [image] NULL,
[OccuSP] [image] NULL,
[AntiCheatData] [image] NULL,
[ACWrongTimes] [int] NOT NULL,
[CanHide] [int] NOT NULL,
[HideFlag] [int] NOT NULL,
[CurPKCP] [int] NOT NULL,
[CardPwdThawTime] [int] NOT NULL,
[CardPwd] [nvarchar](16) NOT NULL,
[CountTimerList] [image] NULL,
[SentaiPoints] [int] NOT NULL,
[PenaltyPoints] [int] NOT NULL,
[PersonalCredit] [int] NOT NULL,
[PersonalCreditTotal] [int] NOT NULL,
[PersonalCreditVelue] [int] NOT NULL,
[WorldCreditVelue] [int] NOT NULL,
[LotteryLevel] [int] NOT NULL,
[DepotFrostDate] [int] NOT NULL,
[DepotSubFlag] [int] NOT NULL,
[DepotPwd] [nvarchar](16) NOT NULL,
[GoodsCooldown] [image] NULL,
[ListSkill] [image] NULL,
[ListState] [image] NULL,
[VariableList] [image] NULL,
[AreaCredit] [image] NULL,
[QuestIndex] [image] NULL,
[Lottery] [image] NULL,
[LimitGoodsRecord] [image] NULL,
[IncShopCur10] [image] NULL,
[IncShopBuyList] [image] NULL,
[MedalData] [image] NULL,
[DOccuData] [image] NULL,
[ListQuest] [image] NULL,
[MercenaryQuest] [image] NULL,
[SysMailList] [image] NULL,
CONSTRAINT [PK_TBL_PLAYER_DETAIL] PRIMARY KEY NONCLUSTERED
(
[guid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[TBL_PLAYER_GOODS](
[goodsID] [uniqueidentifier] NOT NULL,
[goodsIndex] [int] NOT NULL,
[PlayerID] [uniqueidentifier] NOT NULL,
[name] [nvarchar](20) NOT NULL,
[amount] [int] NOT NULL,
[price] [int] NOT NULL,
[place] [int] NOT NULL,
[position] [int] NOT NULL,
[holeNum] [int] NOT NULL,
[hole1Idx] [int] NOT NULL,
[hole2Idx] [int] NOT NULL,
[hole3Idx] [int] NOT NULL,
[hole4Idx] [int] NOT NULL,
[hole5Idx] [int] NOT NULL,
[AddonProperty] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
