|
You last visited: Today at 23:38
Advertisement
CHARACTER_STR PROBLEM
Discussion on CHARACTER_STR PROBLEM within the Flyff Private Server forum part of the Flyff category.
10/28/2014, 17:13
|
#1
|
elite*gold: 0 
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
CHARACTER_STR PROBLEM
hi epvpers i got som promblem to my database here is my problem
PHP Code:
2014/10/28 09:08:00
query:{call CHARACTER_STR('U1','0000481','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:40001 error:[Microsoft][SQL Native Client][SQL Server]Transaction (Process ID 240) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2014/10/28 09:09:27
query:{call CHARACTER_STR('U1','0000478','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:40001 error:[Microsoft][SQL Native Client][SQL Server]Transaction (Process ID 238) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2014/10/28 09:10:57
query:{call CHARACTER_STR('U1','0000481','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE:40001 error:[Microsoft][SQL Native Client][SQL Server]Transaction (Process ID 238) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
hope you can help me in my problem.,., thanks in advance
|
|
|
|
10/28/2014, 17:15
|
#2
|
elite*gold: 0
Join Date: Jan 2014
Posts: 773
Received Thanks: 373
|
do you have added a parameter in the source but not in database?
|
|
|
|
|
10/28/2014, 17:19
|
#3
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Did you changed the save time?
SEC_SAVEPLAYER if I'm not wrong
|
|
|
|
|
10/28/2014, 17:46
|
#4
|
elite*gold: 0
Join Date: Jan 2009
Posts: 1,739
Received Thanks: 1,669
|
DEADLOCK - seriouly, use that search function.
|
|
|
|
|
10/28/2014, 17:49
|
#5
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Quote:
Originally Posted by xTwiLightx
DEADLOCK - seriouly, use that !@#$%* function.
|
You should not use any swear words 
Here's something to read: Deadlock - Wikipedia, the free encyclopedia
|
|
|
|
|
10/28/2014, 18:09
|
#6
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
oh thinks limme try
im using sedrika database 
|
|
|
|
|
10/29/2014, 07:39
|
#7
|
elite*gold: 0
Join Date: Jan 2009
Posts: 1,739
Received Thanks: 1,669
|
Since I saw that the release seems to be down, I'll be the nice guy who posts the "fix" for some Deadlocks here:
Code:
USE [CHARACTER_01_DBF]
GO
/****** Object: Index [BANK_EXT_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [BANK_EXT_ID1] ON [dbo].[BANK_EXT_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [BANK_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [BANK_ID1] ON [dbo].[BANK_TBL]
(
[m_idPlayer] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [BASE_VALUE_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [BASE_VALUE_ID1] ON [dbo].[BASE_VALUE_TBL]
(
[g_nSex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [BILING_ITEM_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [BILING_ITEM_ID1] ON [dbo].[BILING_ITEM_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [CARD_CUBE_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [CARD_CUBE_ID1] ON [dbo].[CARD_CUBE_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [CHARACTER_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [CHARACTER_ID1] ON [dbo].[CHARACTER_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [COMPANY_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [COMPANY_ID1] ON [dbo].[COMPANY_TBL]
(
[m_idCompany] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_BANK_EXT_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [GUILD_BANK_EXT_ID1] ON [dbo].[GUILD_BANK_EXT_TBL]
(
[m_idGuild] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_BANK_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [GUILD_BANK_ID1] ON [dbo].[GUILD_BANK_TBL]
(
[m_idGuild] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_QUEST_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [GUILD_QUEST_ID1] ON [dbo].[GUILD_QUEST_TBL]
(
[m_idGuild] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [GUILD_ID1] ON [dbo].[GUILD_TBL]
(
[m_idGuild] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_VOTE_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [GUILD_VOTE_ID1] ON [dbo].[GUILD_VOTE_TBL]
(
[m_idVote] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_WAR_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [GUILD_WAR_ID1] ON [dbo].[GUILD_WAR_TBL]
(
[m_idWar] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [INVENTORY_EXT_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [INVENTORY_EXT_ID1] ON [dbo].[INVENTORY_EXT_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [INVENTORY_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [INVENTORY_ID1] ON [dbo].[INVENTORY_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_NCL_MAIL_TBL_nMail] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [IDX_NCL_MAIL_TBL_nMail] ON [dbo].[MAIL_TBL]
(
[serverindex] ASC,
[nMail] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [PARTY_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [PARTY_ID1] ON [dbo].[PARTY_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [CL_RAINBOWRACE_TBL_nTimes] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [CL_RAINBOWRACE_TBL_nTimes] ON [dbo].[RAINBOWRACE_TBL]
(
[nTimes] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_SECRET_ROOM_MEMBER_TBL_serverindex] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_SECRET_ROOM_MEMBER_TBL_serverindex] ON [dbo].[SECRET_ROOM_MEMBER_TBL]
(
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_SECRET_ROOM_TBL_serverindex] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_SECRET_ROOM_TBL_serverindex] ON [dbo].[SECRET_ROOM_TBL]
(
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [TASKBAR_ITEM_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [TASKBAR_ITEM_ID1] ON [dbo].[TASKBAR_ITEM_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [TASJBAR_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [TASJBAR_ID1] ON [dbo].[TASKBAR_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_TAX_DETAIL_TBL_serverindex] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_TAX_DETAIL_TBL_serverindex] ON [dbo].[TAX_DETAIL_TBL]
(
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_TAX_INFO_TBL_serverindex_nTimes] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_TAX_INFO_TBL_serverindex_nTimes] ON [dbo].[TAX_INFO_TBL]
(
[serverindex] ASC,
[nTimes] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_tblElection_s_week] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblElection_s_week] ON [dbo].[tblElection]
(
[s_week] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_tblHousing] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblHousing] ON [dbo].[tblHousing]
(
[serverindex] ASC,
[m_idPlayer] ASC,
[bSetup] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_CLU_tblHousing_Visit_m_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblHousing_Visit_m_idPlayer] ON [dbo].[tblHousing_Visit]
(
[serverindex] ASC,
[m_idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_tblLord_nServer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblLord_nServer] ON [dbo].[tblLord]
(
[nServer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_tblLordCandidates_nServer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblLordCandidates_nServer] ON [dbo].[tblLordCandidates]
(
[nServer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_tblLordElection_nServer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblLordElection_nServer] ON [dbo].[tblLordElection]
(
[nServer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_tblLordEvent_nServer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblLordEvent_nServer] ON [dbo].[tblLordEvent]
(
[nServer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_tblLordSkill_nServer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_CLU_tblLordSkill_nServer] ON [dbo].[tblLordSkill]
(
[nServer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_tblMaster_all_m_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [IDX_tblMaster_all_m_idPlayer] ON [dbo].[tblMaster_all]
(
[serverindex] ASC,
[m_idPlayer] ASC,
[sec] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_tblPocket_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_tblPocket_idPlayer] ON [dbo].[tblPocket]
(
[idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_tblPocketExt_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE CLUSTERED INDEX [IDX_tblPocketExt_idPlayer] ON [dbo].[tblPocketExt]
(
[idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [tblSkillPoint_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [tblSkillPoint_ID1] ON [dbo].[tblSkillPoint]
(
[PlayerID] ASC,
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [WANTED_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE CLUSTERED INDEX [WANTED_ID1] ON [dbo].[WANTED_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
/****** Object: Index [CHARACTER_ID2] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [CHARACTER_ID2] ON [dbo].[CHARACTER_TBL]
(
[account] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [CHARACTER_ID3] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [CHARACTER_ID3] ON [dbo].[CHARACTER_TBL]
(
[m_szName] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [GUILD_MEMBER_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE NONCLUSTERED INDEX [GUILD_MEMBER_ID1] ON [dbo].[GUILD_MEMBER_TBL]
(
[m_idPlayer] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [ITEM_REMOVE_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [ITEM_REMOVE_ID1] ON [dbo].[ITEM_REMOVE_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [ITEM_REMOVE_ID2] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [ITEM_REMOVE_ID2] ON [dbo].[ITEM_REMOVE_TBL]
(
[Item_Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [ITEM_SEND_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [ITEM_SEND_ID1] ON [dbo].[ITEM_SEND_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [ITEM_SEND_ID2] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [ITEM_SEND_ID2] ON [dbo].[ITEM_SEND_TBL]
(
[Item_Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [MESSENGER_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [MESSENGER_ID1] ON [dbo].[MESSENGER_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [MESSENGER_ID2] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [MESSENGER_ID2] ON [dbo].[MESSENGER_TBL]
(
[f_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [MESSENGER_ID3] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [MESSENGER_ID3] ON [dbo].[MESSENGER_TBL]
(
[State] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [QUEST_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [QUEST_ID1] ON [dbo].[QUEST_TBL]
(
[m_idPlayer] ASC,
[serverindex] ASC,
[m_wId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [NC_RAINBOWRACE_TBL_m_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [NC_RAINBOWRACE_TBL_m_idPlayer] ON [dbo].[RAINBOWRACE_TBL]
(
[m_idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_NCL_SECRET_ROOM_MEMBER_TBL_nTimes_nContinent_m_idGuild] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_SECRET_ROOM_MEMBER_TBL_nTimes_nContinent_m_idGuild] ON [dbo].[SECRET_ROOM_MEMBER_TBL]
(
[nTimes] ASC,
[nContinent] ASC,
[m_idGuild] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_NCL_SECRET_ROOM_TBL_m_idGuild] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_SECRET_ROOM_TBL_m_idGuild] ON [dbo].[SECRET_ROOM_TBL]
(
[m_idGuild] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_NCL_SECRET_ROOM_TBL_nTimes_chState] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_SECRET_ROOM_TBL_nTimes_chState] ON [dbo].[SECRET_ROOM_TBL]
(
[nTimes] ASC,
[chState] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [SKILLINFLUENCE_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE NONCLUSTERED INDEX [SKILLINFLUENCE_ID1] ON [dbo].[SKILLINFLUENCE_TBL]
(
[m_idPlayer] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [TAG_ID1] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [TAG_ID1] ON [dbo].[TAG_TBL]
(
[m_idPlayer] DESC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_TAX_DETAIL_TBL_nTaxKind] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_CLU_TAX_DETAIL_TBL_nTaxKind] ON [dbo].[TAX_DETAIL_TBL]
(
[nTaxKind] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_TAX_DETAIL_TBL_nTimes_nContinent] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_CLU_TAX_DETAIL_TBL_nTimes_nContinent] ON [dbo].[TAX_DETAIL_TBL]
(
[nTimes] ASC,
[nContinent] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_CLU_TAX_INFO_TBL_nContinent] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_CLU_TAX_INFO_TBL_nContinent] ON [dbo].[TAX_INFO_TBL]
(
[nContinent] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [PK_tblCampusMember] Script Date: 04.08.2013 03:07:46 ******/
ALTER TABLE [dbo].[tblCampusMember] ADD CONSTRAINT [PK_tblCampusMember] PRIMARY KEY NONCLUSTERED
(
[m_idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_NCL_UNI_tblHousing_Visit] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE NONCLUSTERED INDEX [IDX_NCL_UNI_tblHousing_Visit] ON [dbo].[tblHousing_Visit]
(
[serverindex] ASC,
[m_idPlayer] ASC,
[f_idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLord_idElection] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLord_idElection] ON [dbo].[tblLord]
(
[idElection] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLordCandidates_idElection_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordCandidates_idElection_idPlayer] ON [dbo].[tblLordCandidates]
(
[idElection] ASC,
[idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_NCL_tblLordCandidates_idElection_IsLeftOut] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordCandidates_idElection_IsLeftOut] ON [dbo].[tblLordCandidates]
(
[idElection] ASC,
[IsLeftOut] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLordCandidates_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordCandidates_idPlayer] ON [dbo].[tblLordCandidates]
(
[idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLordElection_idElection] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordElection_idElection] ON [dbo].[tblLordElection]
(
[idElection] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLordEvent_idPlayer] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordEvent_idPlayer] ON [dbo].[tblLordEvent]
(
[idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLordEvent_nTick] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordEvent_nTick] ON [dbo].[tblLordEvent]
(
[nTick] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
/****** Object: Index [IDX_NCL_tblLordSkill_nSkill] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_NCL_tblLordSkill_nSkill] ON [dbo].[tblLordSkill]
(
[nSkill] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [messenger_idx_1] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [messenger_idx_1] ON [dbo].[tblMessenger]
(
[idPlayer] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [messenger_idx_2] Script Date: 04.08.2013 03:07:46 ******/
CREATE UNIQUE NONCLUSTERED INDEX [messenger_idx_2] ON [dbo].[tblMessenger]
(
[idPlayer] ASC,
[idFriend] ASC,
[serverindex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_tblPocket_idPlayer_nPocket] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_tblPocket_idPlayer_nPocket] ON [dbo].[tblPocket]
(
[idPlayer] ASC,
[nPocket] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IDX_tblPocketExt_idPlayer_nPocket] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [IDX_tblPocketExt_idPlayer_nPocket] ON [dbo].[tblPocketExt]
(
[idPlayer] ASC,
[nPocket] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [NCI_idGuild] Script Date: 04.08.2013 03:07:46 ******/
CREATE NONCLUSTERED INDEX [NCI_idGuild] ON [dbo].[tblRemoveItemFromGuildBank]
(
[idGuild] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object: Index [PK_tblRestPoint] Script Date: 04.08.2013 03:07:46 ******/
ALTER TABLE [dbo].[tblRestPoint] ADD CONSTRAINT [PK_tblRestPoint] PRIMARY KEY NONCLUSTERED
(
[serverindex] ASC,
[m_idPlayer] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
|
|
|
|
 |
Similar Threads
|
CHARACTER_STR PROBLEM HELP
10/08/2014 - Flyff Private Server - 3 Replies
hi epvpers i have some problem and i dont know how to fix this,m this is my problem
2014/08/31 01:21:37
query:{call uspSavePocket( '01', '0000328', ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQLSTATE:40001 error:Transaction (Process ID 246) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2014/08/31 01:42:37
query:{call...
|
Wo ist den Character_STR ?
07/26/2013 - Flyff Private Server - 2 Replies
Hey, ich finde irgendwie in der DB "Character_STR" nicht.
Brauche ich für Dupefixx
|
[SQL] CHARACTER_STR Fehler im S8 Abschnitt
04/22/2013 - Flyff Private Server - 2 Replies
Hi,
Fehler:
2013/04/22 19:42:40
query:CHARACTER_STR 'S8',@im_idPlayer='0000011',@iserverindex='01',@ia ccount='cross'
SQLSTATE:42000 error:Die Prozedur oder Funktion 'CHARACTER_STR' erwartet den '@im_szName'-Parameter, der nicht bereitgestellt wurde.
Wann tritt er auf?
Beim einloggen in den Worldserver.
|
All times are GMT +2. The time now is 23:38.
|
|
