· 8 years ago · Feb 24, 2018, 06:14 PM
1/*
2
3Current billing database name : Billing
4
5If you use other name of Database replace Billing by your name of database on :
6-smp_takeout_commercial_item
7-smp_update_play_time_point
8-smp_update_secroute_info
9-smp_check_purchased_item
10-smp_read_play_time
11-smp_read_purchased_item_list
12
13*/
14
15DROP DATABASE [Telecaster]
16GO
17
18CREATE DATABASE [Telecaster]
19GO
20
21USE [Telecaster]
22GO
23/****** Object: UserDefinedTableType [dbo].[TestTableType] Script Date: 19/02/2018 17:31:52 ******/
24CREATE TYPE [dbo].[TestTableType] AS TABLE(
25 [ObjectID] [int] NULL
26)
27GO
28/****** Object: UserDefinedFunction [dbo].[FUN_Gmtool_V3_STR_TBL] Script Date: 19/02/2018 17:31:52 ******/
29SET ANSI_NULLS OFF
30GO
31SET QUOTED_IDENTIFIER OFF
32GO
33CREATE FUNCTION [dbo].[FUN_Gmtool_V3_STR_TBL]
34( @String nvarchar(2000),
35 @DIV nchar(1)
36)
37RETURNS @Array TABLE
38(
39 Input nvarchar(50)
40)
41AS
42
43BEGIN
44 DECLARE @Str nvarchar(500)
45 IF (CHARINDEX(@DIV, @String) > 0)
46 BEGIN
47 SET @String = @String + @DIV
48 WHILE (LEN(@String) > 0)
49 BEGIN
50 IF (CHARINDEX(@DIV, @String) > 0)
51 BEGIN
52 SET @Str = SUBSTRING(@String, 1, CHARINDEX(@DIV, @String) - 1)
53 SET @String = SUBSTRING(@String, LEN(@Str) + 2, LEN(@String) - LEN(@Str) - 1)
54
55 INSERT INTO @Array VALUES(LTRIM(RTRIM(@Str)))
56 END
57 ELSE
58 BEGIN
59 SET @Str = RTRIM(@String)
60 SET @String = ''
61
62 INSERT INTO @Array VALUES(LTRIM(RTRIM(@Str)))
63 END
64 END
65 END
66 ELSE
67 INSERT INTO @Array VALUES(RTRIM(LTRIM(@String)))
68
69
70 RETURN
71END
72GO
73/****** Object: Table [dbo].[GuildMember] Script Date: 19/02/2018 17:31:52 ******/
74SET ANSI_NULLS ON
75GO
76SET QUOTED_IDENTIFIER ON
77GO
78CREATE TABLE [dbo].[GuildMember](
79 [player_id] [int] NOT NULL,
80 [guild_id] [int] NOT NULL,
81 [prev_guild_id] [int] NOT NULL,
82 [guild_block_time] [datetime] NOT NULL,
83 [permission] [tinyint] NOT NULL,
84 [memo] [nvarchar](128) NOT NULL,
85 CONSTRAINT [PK_IDX_GUILD_MEMBER] PRIMARY KEY CLUSTERED
86(
87 [player_id] ASC
88)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
89) ON [PRIMARY]
90GO
91/****** Object: Table [dbo].[Guild] Script Date: 19/02/2018 17:31:52 ******/
92SET ANSI_NULLS ON
93GO
94SET QUOTED_IDENTIFIER ON
95GO
96CREATE TABLE [dbo].[Guild](
97 [sid] [int] NOT NULL,
98 [name] [nvarchar](128) NOT NULL,
99 [notice] [nvarchar](255) NOT NULL,
100 [url] [nvarchar](128) NOT NULL,
101 [icon] [varchar](255) NOT NULL,
102 [icon_size] [int] NOT NULL,
103 [banner] [varchar](255) NOT NULL,
104 [banner_size] [int] NOT NULL,
105 [advertise_type] [tinyint] NOT NULL,
106 [advertise_end_time] [datetime] NOT NULL,
107 [advertise_comment] [nvarchar](255) NOT NULL,
108 [recruiting] [bit] NOT NULL,
109 [min_recruit_level] [smallint] NOT NULL,
110 [max_recruit_level] [smallint] NOT NULL,
111 [name_changed] [int] NOT NULL,
112 [dungeon_id] [int] NOT NULL,
113 [dungeon_block_time] [bigint] NOT NULL,
114 [gold] [bigint] NOT NULL,
115 [chaos] [int] NOT NULL,
116 [alliance_id] [int] NOT NULL,
117 [alliance_block_time] [bigint] NOT NULL,
118 [donation_point] [int] NOT NULL,
119 [permission_name_1] [nvarchar](32) NOT NULL,
120 [permission_set_1] [int] NOT NULL,
121 [permission_name_2] [nvarchar](32) NOT NULL,
122 [permission_set_2] [int] NOT NULL,
123 [permission_name_3] [nvarchar](32) NOT NULL,
124 [permission_set_3] [int] NOT NULL,
125 [permission_name_4] [nvarchar](32) NOT NULL,
126 [permission_set_4] [int] NOT NULL,
127 [permission_name_5] [nvarchar](32) NOT NULL,
128 [permission_set_5] [int] NOT NULL,
129 [permission_name_6] [nvarchar](32) NOT NULL,
130 [permission_set_6] [int] NOT NULL,
131 CONSTRAINT [PK_Guild_SID] PRIMARY KEY CLUSTERED
132(
133 [sid] ASC
134)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY],
135 CONSTRAINT [UQ_Guild_name] UNIQUE NONCLUSTERED
136(
137 [name] ASC
138)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
139) ON [PRIMARY]
140GO
141/****** Object: View [dbo].[gmtool_view_check_searchType_guild] Script Date: 19/02/2018 17:31:52 ******/
142SET ANSI_NULLS OFF
143GO
144SET QUOTED_IDENTIFIER OFF
145GO
146CREATE VIEW [dbo].[gmtool_view_check_searchType_guild]
147AS
148select [sid],[name], b.player_id as [leader_id],[dungeon_id], [icon],[icon_size]
149from dbo.guild as a with(nolock)
150left join dbo.GuildMember as b with(nolock)
151 on a.sid = b.guild_id and permission = 7
152GO
153/****** Object: Table [dbo].[Item] Script Date: 19/02/2018 17:31:52 ******/
154SET ANSI_NULLS OFF
155GO
156SET QUOTED_IDENTIFIER ON
157GO
158CREATE TABLE [dbo].[Item](
159 [sid] [bigint] NOT NULL,
160 [owner_id] [int] NOT NULL,
161 [account_id] [int] NOT NULL,
162 [summon_id] [int] NOT NULL,
163 [auction_id] [int] NOT NULL,
164 [keeping_id] [int] NOT NULL,
165 [previous_sid] [bigint] NULL,
166 [code] [int] NOT NULL,
167 [cnt] [bigint] NOT NULL,
168 [level] [int] NOT NULL,
169 [enhance] [int] NOT NULL,
170 [ethereal_durability] [int] NOT NULL,
171 [endurance] [int] NOT NULL,
172 [flag] [int] NOT NULL,
173 [gcode] [int] NOT NULL,
174 [wear_info] [int] NULL,
175 [socket_0] [int] NOT NULL,
176 [socket_1] [int] NOT NULL,
177 [socket_2] [int] NOT NULL,
178 [socket_3] [int] NOT NULL,
179 [awaken_sid] [int] NOT NULL,
180 [remain_time] [int] NOT NULL,
181 [elemental_effect_type] [tinyint] NOT NULL,
182 [elemental_effect_expire_time] [datetime] NOT NULL,
183 [elemental_effect_attack_point] [int] NOT NULL,
184 [elemental_effect_magic_point] [int] NOT NULL,
185 [appearance_code] [int] NOT NULL,
186 [create_time] [datetime] NOT NULL,
187 [update_time] [datetime] NOT NULL,
188 [random_option_sid] [int] NOT NULL,
189 [summon_code] [int] NOT NULL,
190 CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED
191(
192 [sid] ASC
193)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 99) ON [PRIMARY]
194) ON [PRIMARY]
195GO
196/****** Object: View [dbo].[gmtool_view_check_searchType_Item] Script Date: 19/02/2018 17:31:52 ******/
197SET ANSI_NULLS OFF
198GO
199SET QUOTED_IDENTIFIER OFF
200GO
201CREATE VIEW [dbo].[gmtool_view_check_searchType_Item]
202AS
203select owner_id - 2009092 as owner_id , account_id - 2002060 as account_id, code, cnt from dbo.Item with(nolock)
204GO
205/****** Object: Table [dbo].[Character] Script Date: 19/02/2018 17:31:52 ******/
206SET ANSI_NULLS ON
207GO
208SET QUOTED_IDENTIFIER ON
209GO
210CREATE TABLE [dbo].[Character](
211 [sid] [int] IDENTITY(1,1) NOT NULL,
212 [name] [nvarchar](61) NOT NULL,
213 [account] [varchar](60) NOT NULL,
214 [account_id] [int] NOT NULL,
215 [party_id] [int] NOT NULL,
216 [slot] [int] NOT NULL,
217 [permission] [int] NOT NULL,
218 [x] [int] NOT NULL,
219 [y] [int] NOT NULL,
220 [z] [int] NOT NULL,
221 [layer] [int] NOT NULL,
222 [race] [int] NOT NULL,
223 [sex] [int] NOT NULL,
224 [lv] [int] NOT NULL,
225 [max_reached_level] [int] NOT NULL,
226 [exp] [bigint] NOT NULL,
227 [last_decreased_exp] [bigint] NOT NULL,
228 [hp] [int] NOT NULL,
229 [mp] [int] NOT NULL,
230 [stamina] [int] NOT NULL,
231 [havoc] [int] NOT NULL,
232 [job] [int] NOT NULL,
233 [job_depth] [tinyint] NOT NULL,
234 [jlv] [int] NOT NULL,
235 [jp] [bigint] NOT NULL,
236 [total_jp] [bigint] NULL,
237 [talent_point] [int] NOT NULL,
238 [job_0] [int] NULL,
239 [job_1] [int] NULL,
240 [job_2] [int] NULL,
241 [jlv_0] [int] NULL,
242 [jlv_1] [int] NULL,
243 [jlv_2] [int] NULL,
244 [immoral_point] [decimal](18, 4) NOT NULL,
245 [cha] [int] NOT NULL,
246 [pkc] [int] NOT NULL,
247 [dkc] [int] NOT NULL,
248 [huntaholic_point] [int] NOT NULL,
249 [huntaholic_enter_count] [int] NOT NULL,
250 [ethereal_stone_durability] [int] NOT NULL,
251 [gold] [bigint] NOT NULL,
252 [chaos] [int] NOT NULL,
253 [skin_color] [int] NOT NULL,
254 [model_00] [int] NOT NULL,
255 [model_01] [int] NOT NULL,
256 [model_02] [int] NOT NULL,
257 [model_03] [int] NOT NULL,
258 [model_04] [int] NOT NULL,
259 [hair_color_index] [int] NOT NULL,
260 [hair_color_rgb] [int] NOT NULL,
261 [hide_equip_flag] [int] NOT NULL,
262 [texture_id] [int] NOT NULL,
263 [belt_00] [bigint] NOT NULL,
264 [belt_01] [bigint] NOT NULL,
265 [belt_02] [bigint] NOT NULL,
266 [belt_03] [bigint] NOT NULL,
267 [belt_04] [bigint] NOT NULL,
268 [belt_05] [bigint] NOT NULL,
269 [summon_0] [int] NOT NULL,
270 [summon_1] [int] NOT NULL,
271 [summon_2] [int] NOT NULL,
272 [summon_3] [int] NOT NULL,
273 [summon_4] [int] NOT NULL,
274 [summon_5] [int] NOT NULL,
275 [main_summon] [int] NOT NULL,
276 [sub_summon] [int] NOT NULL,
277 [remain_summon_time] [int] NOT NULL,
278 [pet] [int] NOT NULL,
279 [main_title] [int] NOT NULL,
280 [sub_title_0] [int] NOT NULL,
281 [sub_title_1] [int] NOT NULL,
282 [sub_title_2] [int] NOT NULL,
283 [sub_title_3] [int] NOT NULL,
284 [sub_title_4] [int] NOT NULL,
285 [remain_title_time] [int] NOT NULL,
286 [arena_point] [int] NOT NULL,
287 [arena_block_time] [datetime] NOT NULL,
288 [arena_penalty_count] [int] NOT NULL,
289 [arena_penalty_dec_time] [datetime] NOT NULL,
290 [arena_mvp_count] [int] NOT NULL,
291 [arena_record_0_0] [int] NOT NULL,
292 [arena_record_0_1] [int] NOT NULL,
293 [arena_record_1_0] [int] NOT NULL,
294 [arena_record_1_1] [int] NOT NULL,
295 [arena_record_2_0] [int] NOT NULL,
296 [arena_record_2_1] [int] NOT NULL,
297 [alias] [nvarchar](61) NOT NULL,
298 [create_time] [datetime] NOT NULL,
299 [delete_time] [datetime] NULL,
300 [login_time] [datetime] NOT NULL,
301 [login_count] [int] NOT NULL,
302 [logout_time] [datetime] NOT NULL,
303 [play_time] [int] NOT NULL,
304 [chat_block_time] [int] NOT NULL,
305 [adv_chat_count] [int] NOT NULL,
306 [name_changed] [int] NOT NULL,
307 [auto_used] [int] NOT NULL,
308 [pkmode] [tinyint] NOT NULL,
309 [otp_value] [int] NULL,
310 [otp_date] [datetime] NULL,
311 [flag_list] [varchar](1000) NOT NULL,
312 CONSTRAINT [PK_IDX_Avatar] PRIMARY KEY CLUSTERED
313(
314 [sid] ASC
315)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
316) ON [PRIMARY]
317GO
318/****** Object: View [dbo].[gmtool_view_check_searchType_main] Script Date: 19/02/2018 17:31:52 ******/
319SET ANSI_NULLS OFF
320GO
321SET QUOTED_IDENTIFIER OFF
322GO
323CREATE VIEW [dbo].[gmtool_view_check_searchType_main]
324AS
325select [sid] - 2009092 as [sid] , [name], account, account_id - 2002060 as account_id,
326 party_id,
327 ISNULL(GuildMember.guild_id, 0) as guild_id,
328 Character.permission,
329 race, sex,
330 lv, exp, last_decreased_exp,
331 job, job_depth, jlv, jp, total_jp,
332 immoral_point, cha, pkc, dkc,
333 Character.gold,
334 Character.chaos,
335 create_time, delete_time, login_time, login_count, logout_time, play_time, pkmode, chat_block_time, adv_chat_count,
336 name_changed,
337 auto_used,
338 huntaholic_point
339 from dbo.Character with (nolock) left join dbo.GuildMember with(nolock)
340 on Character.sid = GuildMember.player_id
341 where [sid] > 0
342GO
343/****** Object: Table [dbo].[Party] Script Date: 19/02/2018 17:31:52 ******/
344SET ANSI_NULLS ON
345GO
346SET QUOTED_IDENTIFIER ON
347GO
348CREATE TABLE [dbo].[Party](
349 [sid] [int] NOT NULL,
350 [name] [nvarchar](128) NOT NULL,
351 [leader_id] [int] NOT NULL,
352 [share_mode] [int] NOT NULL,
353 [party_type] [int] NOT NULL,
354 [lead_party_id] [int] NOT NULL,
355 CONSTRAINT [PK_PARTY_SID] PRIMARY KEY CLUSTERED
356(
357 [sid] ASC
358)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY],
359 CONSTRAINT [UQ_Party_leader_id] UNIQUE NONCLUSTERED
360(
361 [leader_id] ASC
362)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY],
363 CONSTRAINT [UQ_Party_name] UNIQUE NONCLUSTERED
364(
365 [name] ASC
366)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
367) ON [PRIMARY]
368GO
369/****** Object: View [dbo].[gmtool_view_check_searchType_party] Script Date: 19/02/2018 17:31:52 ******/
370SET ANSI_NULLS OFF
371GO
372SET QUOTED_IDENTIFIER OFF
373GO
374CREATE VIEW [dbo].[gmtool_view_check_searchType_party]
375AS
376select [sid], [name] from Party with(nolock)
377GO
378/****** Object: Table [dbo].[AccountFlag] Script Date: 19/02/2018 17:31:52 ******/
379SET ANSI_NULLS ON
380GO
381SET QUOTED_IDENTIFIER ON
382GO
383CREATE TABLE [dbo].[AccountFlag](
384 [account_id] [int] NOT NULL,
385 [flag_list] [varchar](1000) NOT NULL,
386 CONSTRAINT [PK_AccountFlag] PRIMARY KEY CLUSTERED
387(
388 [account_id] ASC
389)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
390) ON [PRIMARY]
391GO
392/****** Object: Table [dbo].[Alliance] Script Date: 19/02/2018 17:31:52 ******/
393SET ANSI_NULLS ON
394GO
395SET QUOTED_IDENTIFIER ON
396GO
397CREATE TABLE [dbo].[Alliance](
398 [sid] [int] NOT NULL,
399 [name] [nvarchar](128) NOT NULL,
400 [lead_guild_id] [int] NOT NULL,
401 [max_alliance_cnt] [int] NOT NULL,
402 [name_changed] [int] NOT NULL,
403 CONSTRAINT [PK_ALLIANCE_SID] PRIMARY KEY CLUSTERED
404(
405 [sid] ASC
406)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY],
407 CONSTRAINT [UQ_Alliance_name] UNIQUE NONCLUSTERED
408(
409 [name] ASC
410)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
411) ON [PRIMARY]
412GO
413/****** Object: Table [dbo].[AllowedCommandsForPermission] Script Date: 19/02/2018 17:31:52 ******/
414SET ANSI_NULLS ON
415GO
416SET QUOTED_IDENTIFIER ON
417GO
418CREATE TABLE [dbo].[AllowedCommandsForPermission](
419 [sid] [int] IDENTITY(1,1) NOT NULL,
420 [permission] [int] NOT NULL,
421 [command] [varchar](32) NOT NULL,
422 [parameter] [varchar](32) NOT NULL,
423PRIMARY KEY CLUSTERED
424(
425 [sid] ASC
426)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
427) ON [PRIMARY]
428GO
429/****** Object: Table [dbo].[Auction] Script Date: 19/02/2018 17:31:52 ******/
430SET ANSI_NULLS ON
431GO
432SET QUOTED_IDENTIFIER ON
433GO
434CREATE TABLE [dbo].[Auction](
435 [sid] [int] NOT NULL,
436 [item_id] [bigint] NOT NULL,
437 [seller_id] [int] NOT NULL,
438 [seller_name] [nvarchar](31) NOT NULL,
439 [is_secroute_only] [char](1) NOT NULL,
440 [end_time] [datetime] NOT NULL,
441 [instant_purchase_price] [bigint] NOT NULL,
442 [registration_tax] [bigint] NOT NULL,
443 [bidder_list] [varchar](1152) NOT NULL,
444 [highest_bidding_price] [bigint] NOT NULL,
445 [highest_bidder_id] [int] NOT NULL,
446 [highest_bidder_name] [nvarchar](31) NOT NULL,
447 CONSTRAINT [PK_Auction_SID] PRIMARY KEY CLUSTERED
448(
449 [sid] ASC
450)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
451) ON [PRIMARY]
452GO
453/****** Object: Table [dbo].[AutoAuctionRegistrationInfo] Script Date: 19/02/2018 17:31:52 ******/
454SET ANSI_NULLS ON
455GO
456SET QUOTED_IDENTIFIER ON
457GO
458CREATE TABLE [dbo].[AutoAuctionRegistrationInfo](
459 [sid] [int] IDENTITY(1,1) NOT NULL,
460 [auto_auction_id] [int] NOT NULL,
461 [scheduled_register_time] [datetime] NOT NULL,
462 [registered_time] [datetime] NOT NULL,
463 CONSTRAINT [PK_AutoAuctionRegistrationInfo_sid] PRIMARY KEY CLUSTERED
464(
465 [sid] ASC
466)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
467) ON [PRIMARY]
468GO
469/****** Object: Table [dbo].[AwakenOption] Script Date: 19/02/2018 17:31:52 ******/
470SET ANSI_NULLS ON
471GO
472SET QUOTED_IDENTIFIER ON
473GO
474CREATE TABLE [dbo].[AwakenOption](
475 [sid] [int] NOT NULL,
476 [owner_id] [int] NOT NULL,
477 [account_id] [int] NOT NULL,
478 [type_01] [int] NOT NULL,
479 [value_01] [int] NOT NULL,
480 [data_01] [int] NOT NULL,
481 [type_02] [int] NOT NULL,
482 [value_02] [int] NOT NULL,
483 [data_02] [int] NOT NULL,
484 [type_03] [int] NOT NULL,
485 [value_03] [int] NOT NULL,
486 [data_03] [int] NOT NULL,
487 [type_04] [int] NOT NULL,
488 [value_04] [int] NOT NULL,
489 [data_04] [int] NOT NULL,
490 [type_05] [int] NOT NULL,
491 [value_05] [int] NOT NULL,
492 [data_05] [int] NOT NULL,
493 CONSTRAINT [PK_IDX_ItemAwakenOption] PRIMARY KEY NONCLUSTERED
494(
495 [sid] ASC
496)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
497) ON [PRIMARY]
498GO
499/****** Object: Table [dbo].[Check_Aplname_Proc] Script Date: 19/02/2018 17:31:52 ******/
500SET ANSI_NULLS ON
501GO
502SET QUOTED_IDENTIFIER ON
503GO
504CREATE TABLE [dbo].[Check_Aplname_Proc](
505 [log_date] [datetime] NOT NULL,
506 [SESSION] [varchar](30) NOT NULL,
507 [SYS_USER] [varchar](30) NOT NULL,
508 [APL_NAME] [varchar](200) NOT NULL,
509 [HOST_NAME] [varchar](50) NOT NULL,
510 [HOST_ID] [varchar](50) NOT NULL,
511 [sid] [bigint] NOT NULL,
512 [gold] [bigint] NOT NULL
513) ON [PRIMARY]
514GO
515/****** Object: Table [dbo].[ClientInfo] Script Date: 19/02/2018 17:31:52 ******/
516SET ANSI_NULLS ON
517GO
518SET QUOTED_IDENTIFIER ON
519GO
520CREATE TABLE [dbo].[ClientInfo](
521 [owner_id] [int] NOT NULL,
522 [client_info] [varchar](4096) NOT NULL,
523 [saved_key] [varchar](4096) NOT NULL,
524 [quick_slot] [varchar](4096) NOT NULL,
525 [current_key] [varchar](4096) NOT NULL,
526 CONSTRAINT [PK_IDX_ClientOwnerInfo] PRIMARY KEY CLUSTERED
527(
528 [owner_id] ASC
529)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
530) ON [PRIMARY]
531GO
532/****** Object: Table [dbo].[Denials] Script Date: 19/02/2018 17:31:52 ******/
533SET ANSI_NULLS ON
534GO
535SET QUOTED_IDENTIFIER ON
536GO
537CREATE TABLE [dbo].[Denials](
538 [sid] [int] IDENTITY(1,1) NOT NULL,
539 [owner_id] [nvarchar](31) NOT NULL,
540 [denial_id] [nvarchar](31) NOT NULL,
541 CONSTRAINT [PK_Denials_sid] PRIMARY KEY CLUSTERED
542(
543 [sid] ASC
544)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
545) ON [PRIMARY]
546GO
547/****** Object: Table [dbo].[Dungeon] Script Date: 19/02/2018 17:31:52 ******/
548SET ANSI_NULLS ON
549GO
550SET QUOTED_IDENTIFIER ON
551GO
552CREATE TABLE [dbo].[Dungeon](
553 [dungeon_id] [int] NOT NULL,
554 [owner_guild_id] [int] NOT NULL,
555 [raid_guild_id] [int] NOT NULL,
556 [best_raid_time] [int] NOT NULL,
557 [last_dungeon_siege_finish_time] [int] NOT NULL,
558 [last_dungeon_raid_wrap_up_time] [int] NOT NULL,
559 [tax_rate] [int] NOT NULL,
560 CONSTRAINT [PK_IDX_DUNGEON] PRIMARY KEY CLUSTERED
561(
562 [dungeon_id] ASC
563)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
564) ON [PRIMARY]
565GO
566/****** Object: Table [dbo].[DungeonRaidRecord] Script Date: 19/02/2018 17:31:52 ******/
567SET ANSI_NULLS ON
568GO
569SET QUOTED_IDENTIFIER ON
570GO
571CREATE TABLE [dbo].[DungeonRaidRecord](
572 [dungeon_id] [int] NOT NULL,
573 [guild_id] [int] NOT NULL,
574 [raid_time] [int] NOT NULL,
575 [record] [int] NOT NULL,
576 CONSTRAINT [PK_IDX_DUNGEON_RAID_RECORD] PRIMARY KEY CLUSTERED
577(
578 [dungeon_id] ASC,
579 [guild_id] ASC
580)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
581) ON [PRIMARY]
582GO
583/****** Object: Table [dbo].[DungeonRaidRecord_Log] Script Date: 19/02/2018 17:31:52 ******/
584SET ANSI_NULLS ON
585GO
586SET QUOTED_IDENTIFIER ON
587GO
588CREATE TABLE [dbo].[DungeonRaidRecord_Log](
589 [log_date] [datetime] NOT NULL,
590 [dungeon_id] [int] NOT NULL,
591 [guild_id] [int] NOT NULL,
592 [raid_time] [int] NOT NULL,
593 [record] [int] NOT NULL
594) ON [PRIMARY]
595GO
596/****** Object: Table [dbo].[EventAreaEnterCount] Script Date: 19/02/2018 17:31:52 ******/
597SET ANSI_NULLS ON
598GO
599SET QUOTED_IDENTIFIER ON
600GO
601CREATE TABLE [dbo].[EventAreaEnterCount](
602 [player_id] [int] NOT NULL,
603 [event_area_id] [int] NOT NULL,
604 [enter_count] [int] NOT NULL,
605 CONSTRAINT [PK_EventAreaEnterCount_player_id_event_area_id] PRIMARY KEY CLUSTERED
606(
607 [player_id] ASC,
608 [event_area_id] ASC
609)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
610) ON [PRIMARY]
611GO
612/****** Object: Table [dbo].[EventDungeonDropRate] Script Date: 19/02/2018 17:31:52 ******/
613SET ANSI_NULLS ON
614GO
615SET QUOTED_IDENTIFIER ON
616GO
617CREATE TABLE [dbo].[EventDungeonDropRate](
618 [dungeon_id] [int] NOT NULL,
619 [drop_rate] [decimal](10, 4) NOT NULL,
620 [end_time] [datetime] NOT NULL,
621 CONSTRAINT [PK_EventDungeonDropRate] PRIMARY KEY CLUSTERED
622(
623 [dungeon_id] ASC
624)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
625) ON [PRIMARY]
626GO
627/****** Object: Table [dbo].[EventItemDropInfo] Script Date: 19/02/2018 17:31:52 ******/
628SET ANSI_NULLS ON
629GO
630SET QUOTED_IDENTIFIER ON
631GO
632CREATE TABLE [dbo].[EventItemDropInfo](
633 [sid] [int] NOT NULL,
634 [code] [int] NOT NULL,
635 [remain_time] [int] NOT NULL,
636 [duration] [int] NOT NULL,
637 [count] [int] NOT NULL,
638 [total_count] [int] NOT NULL,
639 CONSTRAINT [PK_EVENTITEMDROPINFO_SID] PRIMARY KEY CLUSTERED
640(
641 [sid] ASC
642)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
643) ON [PRIMARY]
644GO
645/****** Object: Table [dbo].[EventItemSupplyInfo] Script Date: 19/02/2018 17:31:52 ******/
646SET ANSI_NULLS ON
647GO
648SET QUOTED_IDENTIFIER ON
649GO
650CREATE TABLE [dbo].[EventItemSupplyInfo](
651 [sid] [int] NOT NULL,
652 [code] [int] NOT NULL,
653 [min_count] [int] NOT NULL,
654 [max_count] [int] NOT NULL,
655 [flag] [int] NOT NULL,
656 [start_time] [datetime] NOT NULL,
657 [end_time] [datetime] NOT NULL,
658 [left_count] [int] NOT NULL,
659 [total_count] [int] NOT NULL,
660 CONSTRAINT [PK_EVENTITEMSUPPLYINFO_SID] PRIMARY KEY CLUSTERED
661(
662 [sid] ASC
663)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
664) ON [PRIMARY]
665GO
666/****** Object: Table [dbo].[Farm] Script Date: 19/02/2018 17:31:52 ******/
667SET ANSI_NULLS ON
668GO
669SET QUOTED_IDENTIFIER ON
670GO
671CREATE TABLE [dbo].[Farm](
672 [sid] [int] NOT NULL,
673 [slot] [tinyint] NOT NULL,
674 [item_id] [bigint] NOT NULL,
675 [owner_id] [int] NOT NULL,
676 [max_level] [int] NOT NULL,
677 [is_using_cracker] [char](1) NOT NULL,
678 [is_cash] [char](1) NOT NULL,
679 [registration_time] [datetime] NOT NULL,
680 [duration] [int] NOT NULL,
681 [nursing_time] [datetime] NOT NULL,
682 CONSTRAINT [PK_IDX_Farm] PRIMARY KEY CLUSTERED
683(
684 [sid] ASC
685)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
686) ON [PRIMARY]
687GO
688/****** Object: Table [dbo].[Favor] Script Date: 19/02/2018 17:31:52 ******/
689SET ANSI_NULLS ON
690GO
691SET QUOTED_IDENTIFIER ON
692GO
693CREATE TABLE [dbo].[Favor](
694 [owner_id] [int] NOT NULL,
695 [favor_id] [int] NOT NULL,
696 [favor] [int] NOT NULL,
697 CONSTRAINT [PK_IDX_NPCRelation] PRIMARY KEY CLUSTERED
698(
699 [owner_id] ASC,
700 [favor_id] ASC
701)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
702) ON [PRIMARY]
703GO
704/****** Object: Table [dbo].[Friends] Script Date: 19/02/2018 17:31:52 ******/
705SET ANSI_NULLS ON
706GO
707SET QUOTED_IDENTIFIER ON
708GO
709CREATE TABLE [dbo].[Friends](
710 [sid] [int] IDENTITY(1,1) NOT NULL,
711 [owner_id] [nvarchar](31) NOT NULL,
712 [friend_id] [nvarchar](31) NOT NULL,
713 CONSTRAINT [PK_Friends_sid] PRIMARY KEY CLUSTERED
714(
715 [sid] ASC
716)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
717) ON [PRIMARY]
718GO
719/****** Object: Table [dbo].[GlobalErrorLog] Script Date: 19/02/2018 17:31:52 ******/
720SET ANSI_NULLS ON
721GO
722SET QUOTED_IDENTIFIER ON
723GO
724CREATE TABLE [dbo].[GlobalErrorLog](
725 [name] [nvarchar](128) NULL,
726 [value] [nvarchar](1024) NULL,
727 [date] [datetime] NULL
728) ON [PRIMARY]
729GO
730/****** Object: Table [dbo].[GlobalVariable] Script Date: 19/02/2018 17:31:52 ******/
731SET ANSI_NULLS ON
732GO
733SET QUOTED_IDENTIFIER ON
734GO
735CREATE TABLE [dbo].[GlobalVariable](
736 [name] [nvarchar](128) NOT NULL,
737 [value] [nvarchar](1024) NOT NULL,
738 CONSTRAINT [PK_GlobalVariable_1] PRIMARY KEY CLUSTERED
739(
740 [name] ASC
741)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
742) ON [PRIMARY]
743GO
744/****** Object: Table [dbo].[ItemCoolTime] Script Date: 19/02/2018 17:31:52 ******/
745SET ANSI_NULLS ON
746GO
747SET QUOTED_IDENTIFIER ON
748GO
749CREATE TABLE [dbo].[ItemCoolTime](
750 [owner_id] [int] NOT NULL,
751 [cool_time_00] [int] NOT NULL,
752 [cool_time_01] [int] NOT NULL,
753 [cool_time_02] [int] NOT NULL,
754 [cool_time_03] [int] NOT NULL,
755 [cool_time_04] [int] NOT NULL,
756 [cool_time_05] [int] NOT NULL,
757 [cool_time_06] [int] NOT NULL,
758 [cool_time_07] [int] NOT NULL,
759 [cool_time_08] [int] NOT NULL,
760 [cool_time_09] [int] NOT NULL,
761 [cool_time_10] [int] NOT NULL,
762 [cool_time_11] [int] NOT NULL,
763 [cool_time_12] [int] NOT NULL,
764 [cool_time_13] [int] NOT NULL,
765 [cool_time_14] [int] NOT NULL,
766 [cool_time_15] [int] NOT NULL,
767 [cool_time_16] [int] NOT NULL,
768 [cool_time_17] [int] NOT NULL,
769 [cool_time_18] [int] NOT NULL,
770 [cool_time_19] [int] NOT NULL,
771 [cool_time_20] [int] NOT NULL,
772 [cool_time_21] [int] NOT NULL,
773 [cool_time_22] [int] NOT NULL,
774 [cool_time_23] [int] NOT NULL,
775 [cool_time_24] [int] NOT NULL,
776 [cool_time_25] [int] NOT NULL,
777 [cool_time_26] [int] NOT NULL,
778 [cool_time_27] [int] NOT NULL,
779 [cool_time_28] [int] NOT NULL,
780 [cool_time_29] [int] NOT NULL,
781 [cool_time_30] [int] NOT NULL,
782 [cool_time_31] [int] NOT NULL,
783 [cool_time_32] [int] NOT NULL,
784 [cool_time_33] [int] NOT NULL,
785 [cool_time_34] [int] NOT NULL,
786 [cool_time_35] [int] NOT NULL,
787 [cool_time_36] [int] NOT NULL,
788 [cool_time_37] [int] NOT NULL,
789 [cool_time_38] [int] NOT NULL,
790 [cool_time_39] [int] NOT NULL,
791 CONSTRAINT [PK_IDX_ITEM_COOLTIME] PRIMARY KEY CLUSTERED
792(
793 [owner_id] ASC
794)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
795) ON [PRIMARY]
796GO
797/****** Object: Table [dbo].[ItemKeeping] Script Date: 19/02/2018 17:31:52 ******/
798SET ANSI_NULLS ON
799GO
800SET QUOTED_IDENTIFIER ON
801GO
802CREATE TABLE [dbo].[ItemKeeping](
803 [sid] [int] NOT NULL,
804 [item_id] [bigint] NOT NULL,
805 [owner_id] [int] NOT NULL,
806 [expiration_time] [datetime] NOT NULL,
807 [keeping_type] [int] NOT NULL,
808 [related_auction_id] [int] NOT NULL,
809 [related_item_code] [int] NOT NULL,
810 [related_item_enhance] [int] NOT NULL,
811 [related_item_level] [int] NOT NULL,
812 CONSTRAINT [PK_ItemKeeping_SID] PRIMARY KEY CLUSTERED
813(
814 [sid] ASC
815)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
816) ON [PRIMARY]
817GO
818/****** Object: Table [dbo].[Pet] Script Date: 19/02/2018 17:31:52 ******/
819SET ANSI_NULLS ON
820GO
821SET QUOTED_IDENTIFIER ON
822GO
823CREATE TABLE [dbo].[Pet](
824 [sid] [int] NOT NULL,
825 [account_id] [int] NOT NULL,
826 [owner_id] [int] NOT NULL,
827 [cage_uid] [bigint] NOT NULL,
828 [code] [int] NOT NULL,
829 [name] [nvarchar](18) NOT NULL,
830 [name_changed] [int] NOT NULL,
831 [cool_time_01] [int] NOT NULL,
832 CONSTRAINT [PK_Pet_sid] PRIMARY KEY CLUSTERED
833(
834 [sid] ASC
835)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
836) ON [PRIMARY]
837GO
838/****** Object: Table [dbo].[Quest] Script Date: 19/02/2018 17:31:52 ******/
839SET ANSI_NULLS ON
840GO
841SET QUOTED_IDENTIFIER ON
842GO
843CREATE TABLE [dbo].[Quest](
844 [owner_id] [int] NOT NULL,
845 [id] [int] NOT NULL,
846 [code] [int] NOT NULL,
847 [start_id] [int] NULL,
848 [status1] [int] NOT NULL,
849 [status2] [int] NOT NULL,
850 [status3] [int] NOT NULL,
851 [status4] [int] NOT NULL,
852 [status5] [int] NOT NULL,
853 [status6] [int] NOT NULL,
854 [remain_time] [int] NOT NULL,
855 [progress] [int] NOT NULL,
856 CONSTRAINT [PK_IDX_QUEST] PRIMARY KEY CLUSTERED
857(
858 [owner_id] ASC,
859 [id] ASC
860)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
861) ON [PRIMARY]
862GO
863/****** Object: Table [dbo].[QuestCoolTime] Script Date: 19/02/2018 17:31:52 ******/
864SET ANSI_NULLS ON
865GO
866SET QUOTED_IDENTIFIER ON
867GO
868CREATE TABLE [dbo].[QuestCoolTime](
869 [owner_id] [int] NOT NULL,
870 [code] [int] NOT NULL,
871 [cool_time] [datetime] NOT NULL,
872 [progress] [int] NOT NULL,
873 CONSTRAINT [PK_IDX_QUEST_COOL_TIME] PRIMARY KEY CLUSTERED
874(
875 [owner_id] ASC,
876 [code] ASC
877)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
878) ON [PRIMARY]
879GO
880/****** Object: Table [dbo].[RandomOption] Script Date: 19/02/2018 17:31:52 ******/
881SET ANSI_NULLS ON
882GO
883SET QUOTED_IDENTIFIER ON
884GO
885CREATE TABLE [dbo].[RandomOption](
886 [sid] [int] NOT NULL,
887 [owner_id] [int] NOT NULL,
888 [account_id] [int] NOT NULL,
889 [random_type] [tinyint] NOT NULL,
890 [type_01] [int] NOT NULL,
891 [value1_01] [decimal](10, 1) NOT NULL,
892 [value2_01] [decimal](10, 1) NOT NULL,
893 [type_02] [int] NOT NULL,
894 [value1_02] [decimal](10, 1) NOT NULL,
895 [value2_02] [decimal](10, 1) NOT NULL,
896 [type_03] [int] NOT NULL,
897 [value1_03] [decimal](10, 1) NOT NULL,
898 [value2_03] [decimal](10, 1) NOT NULL,
899 [type_04] [int] NOT NULL,
900 [value1_04] [decimal](10, 1) NOT NULL,
901 [value2_04] [decimal](10, 1) NOT NULL,
902 [type_05] [int] NOT NULL,
903 [value1_05] [decimal](10, 1) NOT NULL,
904 [value2_05] [decimal](10, 1) NOT NULL,
905 [type_06] [int] NOT NULL,
906 [value1_06] [decimal](10, 1) NOT NULL,
907 [value2_06] [decimal](10, 1) NOT NULL,
908 [type_07] [int] NOT NULL,
909 [value1_07] [decimal](10, 1) NOT NULL,
910 [value2_07] [decimal](10, 1) NOT NULL,
911 [type_08] [int] NOT NULL,
912 [value1_08] [decimal](10, 1) NOT NULL,
913 [value2_08] [decimal](10, 1) NOT NULL,
914 [type_09] [int] NOT NULL,
915 [value1_09] [decimal](10, 1) NOT NULL,
916 [value2_09] [decimal](10, 1) NOT NULL,
917 [type_10] [int] NOT NULL,
918 [value1_10] [decimal](10, 1) NOT NULL,
919 [value2_10] [decimal](10, 1) NOT NULL,
920 CONSTRAINT [PK_IDX_ItemRandomOption] PRIMARY KEY NONCLUSTERED
921(
922 [sid] ASC
923)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
924) ON [PRIMARY]
925GO
926/****** Object: Table [dbo].[RandomQuestInfo] Script Date: 19/02/2018 17:31:52 ******/
927SET ANSI_NULLS ON
928GO
929SET QUOTED_IDENTIFIER ON
930GO
931CREATE TABLE [dbo].[RandomQuestInfo](
932 [owner_id] [int] NOT NULL,
933 [code] [int] NOT NULL,
934 [key1] [int] NOT NULL,
935 [key2] [int] NOT NULL,
936 [key3] [int] NOT NULL,
937 [value1] [int] NOT NULL,
938 [value2] [int] NOT NULL,
939 [value3] [int] NOT NULL,
940 [is_dropped] [tinyint] NOT NULL,
941 CONSTRAINT [PK_IDX_RANDOM_QUEST_INFO] PRIMARY KEY CLUSTERED
942(
943 [owner_id] ASC,
944 [code] ASC
945)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
946) ON [PRIMARY]
947GO
948/****** Object: Table [dbo].[RankingInfo] Script Date: 19/02/2018 17:31:52 ******/
949SET ANSI_NULLS ON
950GO
951SET QUOTED_IDENTIFIER ON
952GO
953CREATE TABLE [dbo].[RankingInfo](
954 [ranking_id] [int] NOT NULL,
955 [next_settling_time] [datetime] NOT NULL,
956 CONSTRAINT [PK_RankingInfo_ranking_id] PRIMARY KEY CLUSTERED
957(
958 [ranking_id] ASC
959)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
960) ON [PRIMARY]
961GO
962/****** Object: Table [dbo].[RankingScore] Script Date: 19/02/2018 17:31:52 ******/
963SET ANSI_NULLS ON
964GO
965SET QUOTED_IDENTIFIER ON
966GO
967CREATE TABLE [dbo].[RankingScore](
968 [ranking_id] [int] NOT NULL,
969 [owner_id] [int] NOT NULL,
970 [score] [decimal](18, 4) NOT NULL,
971 [is_valid] [bit] NOT NULL,
972 CONSTRAINT [PK_RankingScore_ranking_id_owner_id] PRIMARY KEY CLUSTERED
973(
974 [ranking_id] ASC,
975 [owner_id] ASC
976)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
977) ON [PRIMARY]
978GO
979/****** Object: Table [dbo].[ScheduledCommand] Script Date: 19/02/2018 17:31:52 ******/
980SET ANSI_NULLS ON
981GO
982SET QUOTED_IDENTIFIER ON
983GO
984CREATE TABLE [dbo].[ScheduledCommand](
985 [sid] [int] NOT NULL,
986 [type] [tinyint] NOT NULL,
987 [begin_time] [datetime] NOT NULL,
988 [end_time] [datetime] NOT NULL,
989 [interval] [int] NOT NULL,
990 [command] [nvarchar](255) NOT NULL,
991 [is_finished] [bit] NOT NULL,
992 [last_launched_time] [datetime] NOT NULL,
993 CONSTRAINT [PK_ScheduledCommand_SID] PRIMARY KEY CLUSTERED
994(
995 [sid] ASC
996)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
997) ON [PRIMARY]
998GO
999/****** Object: Table [dbo].[SecurityNo] Script Date: 19/02/2018 17:31:52 ******/
1000SET ANSI_NULLS ON
1001GO
1002SET QUOTED_IDENTIFIER ON
1003GO
1004CREATE TABLE [dbo].[SecurityNo](
1005 [account_id] [int] NOT NULL,
1006 [security_no] [varchar](31) NOT NULL
1007) ON [PRIMARY]
1008GO
1009/****** Object: Table [dbo].[Skill] Script Date: 19/02/2018 17:31:52 ******/
1010SET ANSI_NULLS ON
1011GO
1012SET QUOTED_IDENTIFIER ON
1013GO
1014CREATE TABLE [dbo].[Skill](
1015 [sid] [int] NOT NULL,
1016 [owner_id] [int] NOT NULL,
1017 [summon_id] [int] NOT NULL,
1018 [skill_id] [int] NOT NULL,
1019 [skill_level] [int] NOT NULL,
1020 [cool_time] [int] NOT NULL,
1021 CONSTRAINT [PK_SKILL_SID] PRIMARY KEY CLUSTERED
1022(
1023 [sid] ASC
1024)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
1025) ON [PRIMARY]
1026GO
1027/****** Object: Table [dbo].[State] Script Date: 19/02/2018 17:31:52 ******/
1028SET ANSI_NULLS ON
1029GO
1030SET QUOTED_IDENTIFIER ON
1031GO
1032CREATE TABLE [dbo].[State](
1033 [sid] [int] NOT NULL,
1034 [owner_id] [int] NOT NULL,
1035 [summon_id] [int] NOT NULL,
1036 [code] [int] NOT NULL,
1037 [level] [bigint] NOT NULL,
1038 [duration] [int] NOT NULL,
1039 [remain_time] [int] NOT NULL,
1040 [base_damage] [int] NOT NULL,
1041 [remain_fire_time] [int] NOT NULL,
1042 [state_value] [int] NOT NULL,
1043 [state_string_value] [nvarchar](32) NOT NULL,
1044 [enable] [int] NOT NULL,
1045 CONSTRAINT [PK_IDX_State] PRIMARY KEY CLUSTERED
1046(
1047 [sid] ASC
1048)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
1049) ON [PRIMARY]
1050GO
1051/****** Object: Table [dbo].[Summon] Script Date: 19/02/2018 17:31:52 ******/
1052SET ANSI_NULLS ON
1053GO
1054SET QUOTED_IDENTIFIER ON
1055GO
1056CREATE TABLE [dbo].[Summon](
1057 [sid] [int] NOT NULL,
1058 [account_id] [int] NOT NULL,
1059 [owner_id] [int] NOT NULL,
1060 [code] [int] NOT NULL,
1061 [card_uid] [bigint] NOT NULL,
1062 [exp] [bigint] NOT NULL,
1063 [jp] [int] NOT NULL,
1064 [last_decreased_exp] [bigint] NOT NULL,
1065 [name] [nvarchar](64) NOT NULL,
1066 [transform] [int] NOT NULL,
1067 [lv] [int] NOT NULL,
1068 [jlv] [int] NOT NULL,
1069 [max_level] [int] NOT NULL,
1070 [fp] [int] NOT NULL,
1071 [prev_level_01] [int] NOT NULL,
1072 [prev_level_02] [int] NOT NULL,
1073 [prev_id_01] [int] NOT NULL,
1074 [prev_id_02] [int] NOT NULL,
1075 [sp] [int] NOT NULL,
1076 [hp] [int] NOT NULL,
1077 [mp] [int] NOT NULL,
1078 CONSTRAINT [PK_SUMMON_SID] PRIMARY KEY CLUSTERED
1079(
1080 [sid] ASC
1081)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
1082) ON [PRIMARY]
1083GO
1084/****** Object: Table [dbo].[tb_Dungeon_Raid] Script Date: 19/02/2018 17:31:52 ******/
1085SET ANSI_NULLS ON
1086GO
1087SET QUOTED_IDENTIFIER ON
1088GO
1089CREATE TABLE [dbo].[tb_Dungeon_Raid](
1090 [ServerName] [nvarchar](10) NOT NULL,
1091 [dungeon_id] [int] NOT NULL,
1092 [dungeon_name] [nvarchar](255) NOT NULL,
1093 [Guild_ID] [int] NOT NULL,
1094 [guild_icon] [varchar](255) NOT NULL,
1095 [guild_icon_size] [int] NOT NULL,
1096 [guild_name] [nvarchar](128) NOT NULL,
1097 [Guild_Reader_ID] [int] NOT NULL,
1098 [Guild_Reader] [nvarchar](61) NOT NULL,
1099 [lv] [int] NOT NULL,
1100 [job] [int] NOT NULL,
1101 [Alliance] [nvarchar](128) NOT NULL,
1102 [ownership duration(Week)] [int] NULL,
1103 [tax_rate] [int] NOT NULL,
1104 [raid_time] [datetime] NULL,
1105 [record] [int] NOT NULL,
1106 [regdate] [datetime] NULL
1107) ON [PRIMARY]
1108GO
1109/****** Object: Table [dbo].[TBLSTATS] Script Date: 19/02/2018 17:31:52 ******/
1110SET ANSI_NULLS ON
1111GO
1112SET QUOTED_IDENTIFIER ON
1113GO
1114CREATE TABLE [dbo].[TBLSTATS](
1115 [OwnerName] [sysname] NOT NULL,
1116 [TableName] [sysname] NOT NULL,
1117 [IndexName] [sysname] NOT NULL,
1118 [CurrentValue] [tinyint] NULL,
1119 [OldValue] [tinyint] NULL,
1120 [LastModDate] [datetime] NULL
1121) ON [PRIMARY]
1122GO
1123/****** Object: Table [dbo].[Title] Script Date: 19/02/2018 17:31:52 ******/
1124SET ANSI_NULLS ON
1125GO
1126SET QUOTED_IDENTIFIER ON
1127GO
1128CREATE TABLE [dbo].[Title](
1129 [sid] [int] NOT NULL,
1130 [owner_id] [int] NOT NULL,
1131 [code] [int] NOT NULL,
1132 [status] [int] NOT NULL,
1133 CONSTRAINT [PK_IDX_Title] PRIMARY KEY NONCLUSTERED
1134(
1135 [sid] ASC
1136)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
1137) ON [PRIMARY]
1138GO
1139/****** Object: Table [dbo].[TitleCondition] Script Date: 19/02/2018 17:31:52 ******/
1140SET ANSI_NULLS ON
1141GO
1142SET QUOTED_IDENTIFIER ON
1143GO
1144CREATE TABLE [dbo].[TitleCondition](
1145 [sid] [int] NOT NULL,
1146 [owner_id] [int] NOT NULL,
1147 [type] [int] NOT NULL,
1148 [count] [bigint] NOT NULL,
1149 CONSTRAINT [PK_IDX_TitleCondition] PRIMARY KEY NONCLUSTERED
1150(
1151 [sid] ASC
1152)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
1153) ON [PRIMARY]
1154GO
1155/****** Object: Table [dbo].[TRIG_Character_BankGold] Script Date: 19/02/2018 17:31:52 ******/
1156SET ANSI_NULLS ON
1157GO
1158SET QUOTED_IDENTIFIER ON
1159GO
1160CREATE TABLE [dbo].[TRIG_Character_BankGold](
1161 [log_date] [datetime] NOT NULL,
1162 [SESSION] [varchar](30) NOT NULL,
1163 [SYS_USER] [varchar](30) NOT NULL,
1164 [APL_NAME] [varchar](50) NOT NULL,
1165 [HOST_NAME] [varchar](100) NOT NULL,
1166 [HOST_ID] [varchar](50) NOT NULL,
1167 [account_id] [int] NOT NULL,
1168 [Prev_Bank_gold] [bigint] NOT NULL,
1169 [Bank_gold] [bigint] NOT NULL,
1170 [IDNUM] [int] IDENTITY(1,1) NOT NULL
1171) ON [PRIMARY]
1172GO
1173/****** Object: Table [dbo].[TRIG_Character_Gold] Script Date: 19/02/2018 17:31:52 ******/
1174SET ANSI_NULLS ON
1175GO
1176SET QUOTED_IDENTIFIER ON
1177GO
1178CREATE TABLE [dbo].[TRIG_Character_Gold](
1179 [log_date] [datetime] NOT NULL,
1180 [SESSION] [varchar](30) NOT NULL,
1181 [SYS_USER] [varchar](30) NOT NULL,
1182 [APL_NAME] [varchar](50) NOT NULL,
1183 [HOST_NAME] [varchar](100) NOT NULL,
1184 [HOST_ID] [varchar](50) NOT NULL,
1185 [account_id] [int] NOT NULL,
1186 [account] [varchar](50) NOT NULL,
1187 [name] [varchar](50) NOT NULL,
1188 [Prev_gold] [bigint] NOT NULL,
1189 [gold] [bigint] NOT NULL,
1190 [Login_time] [datetime] NOT NULL,
1191 [Logout_time] [datetime] NOT NULL,
1192 [IDNUM] [int] IDENTITY(1,1) NOT NULL
1193) ON [PRIMARY]
1194GO
1195/****** Object: Table [dbo].[TRIG_Insert_Item_BankGold] Script Date: 19/02/2018 17:31:52 ******/
1196SET ANSI_NULLS ON
1197GO
1198SET QUOTED_IDENTIFIER ON
1199GO
1200CREATE TABLE [dbo].[TRIG_Insert_Item_BankGold](
1201 [log_date] [datetime] NOT NULL,
1202 [SESSION] [varchar](30) NOT NULL,
1203 [SYS_USER] [varchar](30) NOT NULL,
1204 [APL_NAME] [varchar](50) NOT NULL,
1205 [HOST_NAME] [varchar](100) NOT NULL,
1206 [HOST_ID] [varchar](50) NULL,
1207 [item_sid] [bigint] NOT NULL,
1208 [account_id] [int] NOT NULL,
1209 [code] [int] NOT NULL,
1210 [Bank_gold] [bigint] NOT NULL,
1211 [IDnum] [int] IDENTITY(1,1) NOT NULL
1212) ON [PRIMARY]
1213GO
1214ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_last_decreased_exp] DEFAULT ((0)) FOR [last_decreased_exp]
1215GO
1216ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_dkc] DEFAULT ((0)) FOR [dkc]
1217GO
1218ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_main_summon] DEFAULT ((0)) FOR [main_summon]
1219GO
1220ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_sub_summon] DEFAULT ((0)) FOR [sub_summon]
1221GO
1222ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_remain_summon_time] DEFAULT ((0)) FOR [remain_summon_time]
1223GO
1224ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character_chat_block_time] DEFAULT ((0)) FOR [chat_block_time]
1225GO
1226ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_awaken_sid] DEFAULT ((0)) FOR [awaken_sid]
1227GO
1228ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_appearance_code] DEFAULT ((0)) FOR [appearance_code]
1229GO
1230ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DF_Item_update_time] DEFAULT (getdate()) FOR [update_time]
1231GO
1232ALTER TABLE [dbo].[Item] ADD CONSTRAINT [DEFAULT_RANDOM_OPTION_SID] DEFAULT ((0)) FOR [random_option_sid]
1233GO
1234ALTER TABLE [dbo].[Item] ADD DEFAULT ((0)) FOR [summon_code]
1235GO
1236ALTER TABLE [dbo].[ScheduledCommand] ADD CONSTRAINT [DEFAULT_LAST_LAUNCHED_DATE] DEFAULT ('9999-12-31') FOR [last_launched_time]
1237GO
1238ALTER TABLE [dbo].[Summon] ADD CONSTRAINT [DF_Summon_last_decreased_exp] DEFAULT ((0)) FOR [last_decreased_exp]
1239GO
1240ALTER TABLE [dbo].[Summon] ADD CONSTRAINT [DF_Summon_prev_level_01] DEFAULT ((0)) FOR [prev_level_01]
1241GO
1242ALTER TABLE [dbo].[Summon] ADD CONSTRAINT [DF_Summon_prev_level_02] DEFAULT ((0)) FOR [prev_level_02]
1243GO
1244ALTER TABLE [dbo].[Summon] ADD CONSTRAINT [DF_Summon_prev_id_01] DEFAULT ((0)) FOR [prev_id_01]
1245GO
1246ALTER TABLE [dbo].[Summon] ADD CONSTRAINT [DF_Summon_prev_id_02] DEFAULT ((0)) FOR [prev_id_02]
1247GO
1248ALTER TABLE [dbo].[tb_Dungeon_Raid] ADD CONSTRAINT [DF_tb_Dungeon_Raid_regdate] DEFAULT (getdate()) FOR [regdate]
1249GO
1250ALTER TABLE [dbo].[TBLSTATS] ADD CONSTRAINT [DF__TBLSTATS__IndexN__72D28FF0] DEFAULT ('ALL') FOR [IndexName]
1251GO
1252ALTER TABLE [dbo].[TBLSTATS] ADD CONSTRAINT [DF__TBLSTATS__OldVal__73C6B429] DEFAULT ((0)) FOR [OldValue]
1253GO
1254ALTER TABLE [dbo].[TBLSTATS] ADD CONSTRAINT [DF__TBLSTATS__LastMo__74BAD862] DEFAULT (getdate()) FOR [LastModDate]
1255GO
1256ALTER TABLE [dbo].[GuildMember] WITH NOCHECK ADD CONSTRAINT [FK_GUILDMEMBER_PLAYER_ID] FOREIGN KEY([player_id])
1257REFERENCES [dbo].[Character] ([sid])
1258ON DELETE CASCADE
1259GO
1260ALTER TABLE [dbo].[GuildMember] NOCHECK CONSTRAINT [FK_GUILDMEMBER_PLAYER_ID]
1261GO
1262/****** Object: StoredProcedure [dbo].[on_server_startup] Script Date: 19/02/2018 17:31:52 ******/
1263SET ANSI_NULLS ON
1264GO
1265SET QUOTED_IDENTIFIER ON
1266GO
1267
1268
1269CREATE PROCEDURE [dbo].[on_server_startup]
1270as
1271 exec smp_set_logout_time
1272
1273
1274GO
1275/****** Object: StoredProcedure [dbo].[sm_update_statistics] Script Date: 19/02/2018 17:31:52 ******/
1276SET ANSI_NULLS ON
1277GO
1278SET QUOTED_IDENTIFIER ON
1279GO
1280
1281
1282CREATE PROC [dbo].[sm_update_statistics]
1283 @ownername sysname
1284, @tabname sysname
1285, @indexname sysname = ''
1286, @sample tinyint = 0
1287, @debug bit = 0
1288AS
1289SET NOCOUNT ON
1290
1291--TBLSTATS 抛æžå–‰æž ç»ä¿ƒæ 父电促. æž æŠ›æžå–‰ç¯® 阿 抛æžå–‰/ 牢郸胶狼 基敲 厚啦阑 历厘çªç»Š 包府茄促.
1292if (select object_id('TBLSTATS')) is null
1293begin
1294
1295 create table dbo.TBLSTATS(
1296 OwnerName sysname
1297 , TableName sysname
1298 , IndexName sysname default('ALL')
1299 , CurrentValue tinyint
1300 , OldValue tinyint default(0)
1301 , LastModDate datetime default (getdate())
1302 )
1303end
1304
1305declare @sql varchar(2000)
1306
1307begin tran
1308if @sample <> 0
1309begin
1310 if @indexname <> ''
1311 begin
1312 if not exists(select * from TBLSTATS where TableName = @tabname and IndexName = @indexname) begin
1313 insert TBLSTATS(TableName, IndexName, CurrentValue) values(@tabname, @indexname, @sample) end
1314 else begin
1315 update TBLSTATS set CurrentValue = @sample, OldValue = CurrentValue
1316 where TableName = @tabname and IndexName = @indexname and CurrentValue <> @sample end
1317 set @sql = 'update statistics ' + '['+@ownername+'].['+@tabname+']' + '(['+ @indexname +']) with sample '+ convert(varchar(3), @sample) + ' percent'
1318 end
1319 else begin
1320 if not exists(select * from TBLSTATS where TableName = @tabname and IndexName = 'ALL') begin
1321 insert TBLSTATS(TableName, CurrentValue) values(@tabname, @sample) end
1322 else begin
1323 update TBLSTATS set CurrentValue = @sample, OldValue = CurrentValue where TableName = @tabname and CurrentValue <> @sample end
1324 set @sql = 'update statistics ' + '['+@ownername+'].['+@tabname+']' +' with sample '+ convert(varchar(3), @sample) + ' percent'
1325 end
1326end
1327else begin
1328 if @indexname <> ''
1329 begin
1330 if not exists(select * from TBLSTATS where TableName = @tabname and IndexName = @indexname) begin
1331 set @sql = 'update statistics ' + '['+@ownername+'].['+@tabname+']' +'(['+ @indexname +'])' end
1332 else begin
1333 select @sql = 'update statistics [' +ownername+'].['+ TableName + '] (['+ IndexName +']) with sample '+ convert(varchar(3), CurrentValue) + ' percent'
1334 from TBLSTATS where TableName = @tabname and IndexName = @indexname end
1335 end
1336 else begin
1337 if not exists(select * from TBLSTATS where TableName = @tabname) begin
1338 set @sql = 'update statistics ' + '['+@ownername+'].['+@tabname+']' end
1339 else begin
1340 select @sql = 'update statistics [' +ownername+'].['+ TableName + '] with sample '+ convert(varchar(3), CurrentValue) + ' percent'
1341 from TBLSTATS where TableName = @tabname and IndexName = 'ALL' end
1342 end
1343end
1344commit
1345
1346IF @debug = 1
1347 print @sql
1348ELSE
1349 exec(@sql)
1350
1351GO
1352/****** Object: StoredProcedure [dbo].[sm_update_statistics_all] Script Date: 19/02/2018 17:31:52 ******/
1353SET ANSI_NULLS ON
1354GO
1355SET QUOTED_IDENTIFIER ON
1356GO
1357
1358
1359Create PROC [dbo].[sm_update_statistics_all]
1360AS
1361SET NOCOUNT ON
1362DECLARE @tablename sysname, @ownername sysname
1363
1364-- 目辑 急攫
1365IF (datepart(dw, getdate()) =2)
1366BEGIN
1367 -- å²¿å¤¸è€ ç´¯è¯€ --> 快府 è¤æžé£˜ç»° 岿夸è€æœ 蜡历啊 利霸 甸绢柯促.
1368 DECLARE tbname CURSOR LOCAL READ_ONLY FOR
1369 SELECT object_name(id) AS TableName, USER_NAME(OBJECTPROPERTY(id,'ownerId')) AS UserName FROM sysindexes
1370 WHERE id > 100 and indid < 2 and rowmodctr > 0.02 * rows and rows > = 10000 and rows < 100000 --é’èå•Š 1父~10父 è¤æž : 函版厚啦 3%æžæƒ‘ 抛æžå–‰ 烹拌 诀å•æžé£˜
1371 UNION ALL
1372 SELECT object_name(id) AS TableName, USER_NAME(OBJECTPROPERTY(id,'ownerId')) AS UserName FROM sysindexes
1373 WHERE id > 100 and indid < 2 and rowmodctr > 0.01 * rows and rows > = 100000 and rows < 1000000 --é’èå•Š 10父~100父 è¤æž : 函版厚啦 2%æžæƒ‘ 抛æžå–‰ 烹拌 诀å•æžé£˜
1374 UNION ALL
1375 SELECT object_name(id) AS TableName, USER_NAME(OBJECTPROPERTY(id,'ownerId')) AS UserName FROM sysindexes
1376 WHERE id > 100 and indid < 2 and rowmodctr > 0.005 * rows and rows > = 1000000 --é’èå•Š 100父 æžæƒ‘ : 函版厚啦 0.5%æžæƒ‘ 抛æžå–‰ 烹拌 诀å•æžé£˜
1377END
1378ELSE
1379BEGIN
1380 -- ä¹žè€ ç´¯è¯€
1381 DECLARE tbname CURSOR LOCAL READ_ONLY FOR
1382 SELECT object_name(id) AS TableName, USER_NAME(OBJECTPROPERTY(id,'ownerId')) AS UserName FROM sysindexes
1383 WHERE id > 100 and indid < 2 and rowmodctr > 0.02 * rows and rows > = 10000 and rows < 100000 --é’èå•Š 1父~10父 è¤æž : 函版厚啦 3%æžæƒ‘ 抛æžå–‰ 烹拌 诀å•æžé£˜
1384 UNION ALL
1385 SELECT object_name(id) AS TableName, USER_NAME(OBJECTPROPERTY(id,'ownerId')) AS UserName FROM sysindexes
1386 WHERE id > 100 and indid < 2 and rowmodctr > 0.01 * rows and rows > = 100000 and rows < 1000000 --é’èå•Š 10父~100父 è¤æž : 函版厚啦 2%æžæƒ‘ 抛æžå–‰ 烹拌 诀å•æžé£˜
1387 UNION ALL
1388 SELECT object_name(id) AS TableName, USER_NAME(OBJECTPROPERTY(id,'ownerId')) AS UserName FROM sysindexes
1389 WHERE id > 100 and indid < 2 and rowmodctr > 0.005 * rows and rows > = 1000000 --é’èå•Š 100父 æžæƒ‘ : 函版厚啦 0.5%æžæƒ‘ 抛æžå–‰ 烹拌 诀å•æžé£˜
1390 and dpages < = 6250000
1391END
1392
1393OPEN tbname
1394
1395FETCH NEXT FROM tbname INTO @tablename, @ownername
1396
1397WHILE @@FETCH_STATUS = 0
1398BEGIN
1399 EXEC ('dbo.sm_update_statistics' + ' [' + @ownername + '],[' + @tablename + ']')
1400 FETCH NEXT FROM tbname INTO @tablename, @ownername
1401END
1402
1403CLOSE tbname
1404DEALLOCATE tbname
1405
1406
1407GO
1408/****** Object: StoredProcedure [dbo].[smp_account] Script Date: 19/02/2018 17:31:52 ******/
1409SET ANSI_NULLS ON
1410GO
1411SET QUOTED_IDENTIFIER ON
1412GO
1413
1414-- smp_reset_skill
1415
1416
1417-- start of smp_account
1418CREATE PROCEDURE [dbo].[smp_account]
1419
1420@IN_ACCOUNT VARCHAR(31),
1421@IN_PEERADDR VARCHAR(24),
1422@IN_PASSWORD VARCHAR(24)
1423
1424AS
1425SET NOCOUNT ON
1426
1427-- pcbang éž˜é› æ‰å¤¯ 0æ 肺 固府 çœ å•Šæ²åš¼èªä¿ƒ.
1428select password, account_id, 1 as result, 0 as block, 1 as auth_ok, 20 as age, 0 as pcbang, 0 as event_code, 1 as last_login_server_idx, DATEDIFF(second, GETDATE(), '2000-01-01 00:00') as withdraw_remain_time from Account WITH (NOLOCK) where account = @IN_ACCOUNT;
1429
1430RETURN @@ERROR
1431
1432GO
1433/****** Object: StoredProcedure [dbo].[smp_change_alliance_name] Script Date: 19/02/2018 17:31:52 ******/
1434SET ANSI_NULLS ON
1435GO
1436SET QUOTED_IDENTIFIER ON
1437GO
1438
1439-- start of smp_change_alliance_name
1440CREATE PROCEDURE [dbo].[smp_change_alliance_name]
1441@IN_SID INT,
1442@IN_NAME NVARCHAR(31)
1443AS
1444
1445UPDATE dbo.Alliance SET name = @IN_NAME, name_changed = 1 WHERE sid = @IN_SID
1446-- end of smp_change_alliance_name
1447
1448GO
1449/****** Object: StoredProcedure [dbo].[smp_change_guild_name] Script Date: 19/02/2018 17:31:52 ******/
1450SET ANSI_NULLS ON
1451GO
1452SET QUOTED_IDENTIFIER ON
1453GO
1454-- end of smp_insert_guild
1455
1456-- start of smp_change_guild_name
1457CREATE PROCEDURE [dbo].[smp_change_guild_name]
1458@IN_GUILD_SID INT,
1459@IN_NAME NVARCHAR(31)
1460AS
1461SET NOCOUNT ON
1462
1463UPDATE dbo.Guild SET name = @IN_NAME, name_changed = 1 WHERE sid = @IN_GUILD_SID
1464
1465RETURN @@ERROR
1466
1467
1468GO
1469/****** Object: StoredProcedure [dbo].[smp_change_pet_name] Script Date: 19/02/2018 17:31:52 ******/
1470SET ANSI_NULLS ON
1471GO
1472SET QUOTED_IDENTIFIER ON
1473GO
1474
1475-- start of smp_change_pet_name
1476CREATE PROCEDURE [dbo].[smp_change_pet_name]
1477@IN_SID INT,
1478@IN_NAME NVARCHAR(18)
1479AS
1480SET NOCOUNT ON
1481
1482UPDATE dbo.Pet SET name = @IN_NAME, name_changed = 1 WHERE sid = @IN_SID
1483
1484-- end of smp_change_pet_name
1485
1486GO
1487/****** Object: StoredProcedure [dbo].[smp_change_security_no] Script Date: 19/02/2018 17:31:52 ******/
1488SET ANSI_NULLS ON
1489GO
1490SET QUOTED_IDENTIFIER ON
1491GO
1492
1493-- start of smp_change_security_no
1494CREATE PROCEDURE [dbo].[smp_change_security_no]
1495@IN_ACCOUNT_ID INT,
1496@IN_SECURITY_NO VARCHAR(31)
1497AS
1498SET NOCOUNT ON
1499
1500UPDATE dbo.SecurityNo SET security_no = @IN_SECURITY_NO WHERE account_id = @IN_ACCOUNT_ID
1501SELECT security_no FROM dbo.SecurityNo WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID
1502
1503RETURN @@ERROR
1504-- end of smp_change_security_no
1505GO
1506/****** Object: StoredProcedure [dbo].[smp_check_character_count] Script Date: 19/02/2018 17:31:52 ******/
1507SET ANSI_NULLS ON
1508GO
1509SET QUOTED_IDENTIFIER ON
1510GO
1511
1512
1513-- start of smp_check_character_count
1514CREATE PROCEDURE [dbo].[smp_check_character_count]
1515@IN_ACCOUNT_SID INT,
1516@OUT_COUNT INT OUTPUT
1517
1518AS
1519SET NOCOUNT ON
1520
1521SELECT @OUT_COUNT = COUNT(*)
1522FROM dbo.Character WITH (NOLOCK)
1523WHERE account_id = @IN_ACCOUNT_SID
1524AND GETDATE() < delete_time
1525
1526-- end of smp_check_character_count
1527
1528GO
1529/****** Object: StoredProcedure [dbo].[smp_check_character_name] Script Date: 19/02/2018 17:31:52 ******/
1530SET ANSI_NULLS ON
1531GO
1532SET QUOTED_IDENTIFIER ON
1533GO
1534
1535
1536-- start of smp_check_character_name
1537CREATE PROCEDURE [dbo].[smp_check_character_name]
1538@IN_NAME NVARCHAR(31),
1539@OUT_COUNT INT OUTPUT
1540
1541AS
1542SET NOCOUNT ON
1543
1544SELECT @OUT_COUNT = COUNT(*)
1545FROM dbo.Character WITH (NOLOCK)
1546WHERE name = @IN_NAME
1547
1548-- end of smp_check_character_name
1549
1550GO
1551/****** Object: StoredProcedure [dbo].[smp_check_purchased_item] Script Date: 19/02/2018 17:31:52 ******/
1552SET ANSI_NULLS ON
1553GO
1554SET QUOTED_IDENTIFIER ON
1555GO
1556-- smp_read_purchased_item_list
1557
1558-- start of smp_check_purchased_item æŸæµ†è¢ 芒绊俊 é…’æžè¢ ä¹ç»°ç˜¤ 咯何 å…«è¤
1559CREATE PROCEDURE [dbo].[smp_check_purchased_item]
1560@IN_ACCOUNT_ID INT,
1561@IN_CHARACTER_ID INT,
1562@OUT_TOTAL_ITEM_COUNT INT OUTPUT,
1563@OUT_NEW_ITEM_COUNT INT OUTPUT,
1564@OUT_PREMIUM_TICKET INT OUTPUT,
1565@OUT_PREMIUM_REST_TIME INT OUTPUT,
1566@OUT_STAMINA_REGEN_TIME INT OUTPUT
1567
1568
1569AS
1570SET NOCOUNT ON
1571
1572SET @OUT_PREMIUM_TICKET = 0
1573SET @OUT_PREMIUM_REST_TIME = 0
1574SET @OUT_STAMINA_REGEN_TIME = 0
1575
1576SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM Billing.dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND isCancel = 0
1577
1578IF @OUT_PREMIUM_TICKET < 1
1579BEGIN
1580 SET @OUT_PREMIUM_REST_TIME = 0
1581
1582 DECLARE @LOGOUT_TIME DATETIME
1583 SET @LOGOUT_TIME = GETDATE()
1584
1585 SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
1586 SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM Billing.dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME AND isCancel = 0
1587
1588 IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
1589 BEGIN
1590 SET @OUT_STAMINA_REGEN_TIME = 0
1591 END
1592
1593 --DECLARE @NO_LV INT
1594 --DECLARE @NO_Total_JP INT
1595 --SELECT @NO_LV = MAX(lv), @NO_Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'
1596
1597 --IF @NO_LV < 30 AND @NO_Total_JP < 100000
1598 --BEGIN
1599 --SET @OUT_PREMIUM_TICKET = 1
1600 --SET @OUT_PREMIUM_REST_TIME = 3600 * 5
1601 --END
1602
1603END
1604
1605--IF @OUT_PREMIUM_REST_TIME < 3600 * 5
1606--BEGIN
1607
1608 --DECLARE @LV INT
1609 --DECLARE @Total_JP INT
1610 --SELECT @LV = MAX(lv), @Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'
1611
1612 --IF @LV < 30 AND @Total_JP < 100000
1613 --BEGIN
1614 --SET @OUT_PREMIUM_TICKET = 1
1615 --SET @OUT_PREMIUM_REST_TIME = 3600 * 5
1616 --END
1617--END
1618
1619
1620SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from Billing.dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND valid_time > GETDATE() AND isCancel = 0
1621SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from Billing.dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0
1622
1623RETURN @@ERROR
1624GO
1625/****** Object: StoredProcedure [dbo].[smp_clear_auto_account_list] Script Date: 19/02/2018 17:31:52 ******/
1626SET ANSI_NULLS ON
1627GO
1628SET QUOTED_IDENTIFIER ON
1629GO
1630-- smp_erase_user_from_auto_account_list
1631
1632-- start of smp_clear_auto_account_list
1633CREATE PROCEDURE [dbo].[smp_clear_auto_account_list]
1634
1635AS
1636
1637UPDATE dbo.Character SET auto_used = 0
1638
1639UPDATE dbo.State SET enable = 0 WHERE code = 5997
1640
1641RETURN @@ERROR
1642
1643
1644GO
1645/****** Object: StoredProcedure [dbo].[smp_clear_dungeon_raid_record] Script Date: 19/02/2018 17:31:52 ******/
1646SET ANSI_NULLS ON
1647GO
1648SET QUOTED_IDENTIFIER ON
1649GO
1650
1651-- start of smp_clear_dungeon_raid_record
1652CREATE PROCEDURE [dbo].[smp_clear_dungeon_raid_record]
1653@IN_DUNGEON_ID INT,
1654@IN_GUILD_ID INT
1655AS
1656SET NOCOUNT ON
1657
1658IF @IN_GUILD_ID = 0
1659 DELETE dbo.DungeonRaidRecord WHERE dungeon_id = @IN_DUNGEON_ID AND guild_id NOT IN ( SELECT TOP 1 owner_guild_id FROM dbo.Dungeon WITH (NOLOCK) WHERE dungeon_id = @IN_DUNGEON_ID )
1660ELSE
1661 DELETE dbo.DungeonRaidRecord WHERE dungeon_id = @IN_DUNGEON_ID AND guild_id = @IN_GUILD_ID
1662
1663
1664GO
1665/****** Object: StoredProcedure [dbo].[smp_clear_state_list] Script Date: 19/02/2018 17:31:52 ******/
1666SET ANSI_NULLS ON
1667GO
1668SET QUOTED_IDENTIFIER ON
1669GO
1670
1671CREATE PROCEDURE [dbo].[smp_clear_state_list]
1672
1673@IN_OWNER_ID INT,
1674@IN_SUMMON_ID INT
1675AS
1676SET NOCOUNT ON
1677
1678UPDATE dbo.State SET enable = 0 WHERE owner_id = @IN_OWNER_ID AND summon_id = @IN_SUMMON_ID;
1679
1680RETURN @@ERROR
1681
1682
1683GO
1684/****** Object: StoredProcedure [dbo].[smp_close_authority_info] Script Date: 19/02/2018 17:31:52 ******/
1685SET ANSI_NULLS ON
1686GO
1687SET QUOTED_IDENTIFIER ON
1688GO
1689
1690-- start of smp_close_authority_info
1691CREATE PROCEDURE [dbo].[smp_close_authority_info]
1692@IN_ACCOUNT_ID INT,
1693@IN_AUTHORITY_TYPE INT
1694
1695AS
1696SET NOCOUNT ON
1697
1698UPDATE ArcadiaInfo.dbo.AuthorityInfo
1699SET expire_time = 0
1700WHERE account = @IN_ACCOUNT_ID AND authority_type = @IN_AUTHORITY_TYPE
1701
1702RETURN @@ERROR
1703-- end of smp_close_authority_info
1704
1705GO
1706/****** Object: StoredProcedure [dbo].[smp_create_security_no] Script Date: 19/02/2018 17:31:52 ******/
1707SET ANSI_NULLS ON
1708GO
1709SET QUOTED_IDENTIFIER ON
1710GO
1711
1712-- start of smp_create_security_no
1713CREATE PROCEDURE [dbo].[smp_create_security_no]
1714@IN_ACCOUNT_ID INT,
1715@IN_SECURITY_NO VARCHAR(31)
1716AS
1717SET NOCOUNT ON
1718
1719IF NOT EXISTS ( SELECT * FROM dbo.SecurityNo WHERE account_id = @IN_ACCOUNT_ID )
1720 INSERT dbo.SecurityNo( account_id, security_no ) VALUES( @IN_ACCOUNT_ID, @IN_SECURITY_NO )
1721
1722SELECT security_no FROM dbo.SecurityNo WHERE account_id = @IN_ACCOUNT_ID
1723
1724RETURN @@ERROR
1725-- end of smp_create_security_no
1726
1727GO
1728/****** Object: StoredProcedure [dbo].[smp_delete_alliance] Script Date: 19/02/2018 17:31:52 ******/
1729SET ANSI_NULLS ON
1730GO
1731SET QUOTED_IDENTIFIER ON
1732GO
1733
1734-- start of smp_delete_alliance
1735CREATE PROCEDURE [dbo].[smp_delete_alliance]
1736@IN_SID INT
1737AS
1738
1739DELETE FROM dbo.Alliance WHERE sid = @IN_SID
1740-- end of smp_delete_alliance
1741
1742GO
1743/****** Object: StoredProcedure [dbo].[smp_delete_auction_info] Script Date: 19/02/2018 17:31:52 ******/
1744SET ANSI_NULLS ON
1745GO
1746SET QUOTED_IDENTIFIER ON
1747GO
1748
1749-- start of smp_delete_auction_info
1750CREATE PROCEDURE [dbo].[smp_delete_auction_info]
1751@IN_AUCTION_UID INT
1752AS
1753SET NOCOUNT ON
1754
1755BEGIN TRANSACTION
1756
1757DELETE dbo.Auction WHERE sid = @IN_AUCTION_UID
1758IF @@ROWCOUNT <> 1
1759BEGIN
1760 ROLLBACK TRANSACTION
1761 RETURN @@ERROR
1762END
1763
1764UPDATE dbo.Item SET auction_id = 0 WHERE (account_id = 0 and owner_id = 0 and auction_id = @IN_AUCTION_UID and keeping_id = 0)
1765IF @@ROWCOUNT <> 1
1766BEGIN
1767 ROLLBACK TRANSACTION
1768 RETURN @@ERROR
1769END
1770
1771COMMIT TRANSACTION
1772RETURN @@ERROR
1773
1774-- end of smp_delete_auction_info
1775
1776GO
1777/****** Object: StoredProcedure [dbo].[smp_delete_auction_info_and_insert_item_keeping_info] Script Date: 19/02/2018 17:31:52 ******/
1778SET ANSI_NULLS ON
1779GO
1780SET QUOTED_IDENTIFIER ON
1781GO
1782
1783-- start of smp_delete_auction_info_and_insert_item_keeping_info
1784CREATE PROCEDURE [dbo].[smp_delete_auction_info_and_insert_item_keeping_info]
1785@IN_AUCTION_UID INT,
1786@IN_KEEPING_UID INT,
1787@IN_ITEM_UID BIGINT,
1788@IN_OWNER_UID INT,
1789@IN_EXPERATION_TIME DATETIME,
1790@IN_TYPE INT,
1791@IN_RELATED_AUCTION_ID INT,
1792@IN_RELATED_ITEM_CODE INT,
1793@IN_RELATED_ITEM_ENHANCE INT,
1794@IN_RELATED_ITEM_LEVEL INT
1795AS
1796SET NOCOUNT ON
1797
1798BEGIN TRANSACTION
1799
1800DELETE dbo.Auction WHERE sid = @IN_AUCTION_UID
1801IF @@ROWCOUNT <> 1
1802BEGIN
1803 ROLLBACK TRANSACTION
1804 RETURN @@ERROR
1805END
1806
1807INSERT INTO dbo.ItemKeeping(
1808 sid, -- 1
1809 item_id, -- 2
1810 owner_id, -- 3
1811 expiration_time, -- 4
1812 keeping_type, -- 5
1813 related_auction_id, -- 6
1814 related_item_code, -- 7
1815 related_item_enhance, -- 8
1816 related_item_level ) -- 9
1817 VALUES (
1818 @IN_KEEPING_UID, -- 1
1819 @IN_ITEM_UID, -- 2
1820 @IN_OWNER_UID, -- 3
1821 @IN_EXPERATION_TIME, -- 4
1822 @IN_TYPE, -- 5
1823 @IN_RELATED_AUCTION_ID, -- 6
1824 @IN_RELATED_ITEM_CODE, -- 7
1825 @IN_RELATED_ITEM_ENHANCE, -- 8
1826 @IN_RELATED_ITEM_LEVEL ) -- 9
1827IF @@ROWCOUNT <> 1
1828BEGIN
1829 ROLLBACK TRANSACTION
1830 RETURN @@ERROR
1831END
1832
1833UPDATE dbo.Item SET auction_id = 0, keeping_id = @IN_KEEPING_UID WHERE sid = @IN_ITEM_UID
1834IF @@ROWCOUNT <> 1
1835BEGIN
1836 ROLLBACK TRANSACTION
1837 RETURN @@ERROR
1838END
1839
1840COMMIT TRANSACTION
1841RETURN @@ERROR
1842
1843-- end of smp_delete_auction_info_and_insert_item_keeping_info
1844
1845GO
1846/****** Object: StoredProcedure [dbo].[smp_delete_character] Script Date: 19/02/2018 17:31:52 ******/
1847SET ANSI_NULLS ON
1848GO
1849SET QUOTED_IDENTIFIER ON
1850GO
1851-- smp_read_guild_party_id
1852
1853-- start of smp_delete_character
1854CREATE PROCEDURE [dbo].[smp_delete_character]
1855@IN_NAME NVARCHAR(31),
1856@OUT_SID INT OUTPUT
1857AS
1858SET NOCOUNT ON
1859
1860DECLARE @DELETE_TIME DATETIME;
1861DECLARE @SID INT;
1862
1863-- sid, level, gold 掘绰促
1864SELECT @SID = sid FROM dbo.Character WITH (NOLOCK) where name = @IN_NAME;
1865
1866IF @SID IS NULL
1867BEGIN
1868 SET @SID = 0
1869 GOTO CHARACTER_NOT_FOUND
1870END
1871
1872SET @DELETE_TIME = GETDATE()
1873-- 盔贰 æžå·´æ 肺 汲沥秦具 çªç˜¤çˆ¶ 肺厚 ä¿ºæƒ¯æž ä»£ 场车æ 骨肺 è€çªœ 阜绰促.
1874-- UPDATE dbo.Character SET delete_time = @DELETE_TIME WHERE sid = @SID;
1875
1876UPDATE dbo.Character SET delete_time = @DELETE_TIME, name = '@' + name + ' ' + SUBSTRING( CONVERT( VARCHAR(40), @DELETE_TIME, 21 ), 3, 17 ) WHERE sid = @SID;
1877
1878-- 模备, 瞒窜 æ ¼åºŸ 家èŠ
1879SET ROWCOUNT 1
1880WHILE 1=1
1881BEGIN
1882 DELETE FROM dbo.Friends WHERE sid IN ( SELECT TOP 1 sid FROM dbo.Friends WITH (NOLOCK) WHERE owner_id = @IN_NAME OR friend_id = @IN_NAME )
1883 IF @@ROWCOUNT = 0 BREAK
1884END
1885WHILE 1=1
1886BEGIN
1887
1888 DELETE FROM dbo.Denials WHERE sid IN ( SELECT TOP 1 sid FROM dbo.Denials WITH (NOLOCK) WHERE owner_id = @IN_NAME OR denial_id = @IN_NAME )
1889 IF @@ROWCOUNT = 0 BREAK
1890END
1891SET ROWCOUNT 0
1892
1893CHARACTER_NOT_FOUND:
1894
1895SET @OUT_SID = @SID;
1896
1897
1898GO
1899/****** Object: StoredProcedure [dbo].[smp_delete_denial] Script Date: 19/02/2018 17:31:52 ******/
1900SET ANSI_NULLS ON
1901GO
1902SET QUOTED_IDENTIFIER ON
1903GO
1904
1905-- start of smp_delete_denial
1906CREATE PROCEDURE [dbo].[smp_delete_denial]
1907@IN_OWNER_ID NVARCHAR(31),
1908@IN_DENIAL_ID NVARCHAR(31)
1909AS
1910
1911SET ROWCOUNT 1
1912WHILE 1=1
1913BEGIN
1914 DELETE FROM dbo.Denials WHERE sid IN ( SELECT TOP 1 sid FROM dbo.Denials WITH (NOLOCK) WHERE owner_id = @IN_OWNER_ID AND denial_id = @IN_DENIAL_ID )
1915 IF @@ROWCOUNT = 0 BREAK
1916END
1917SET ROWCOUNT 0
1918
1919RETURN @@ERROR
1920-- end of smp_delete_denial
1921
1922GO
1923/****** Object: StoredProcedure [dbo].[smp_delete_farm_info] Script Date: 19/02/2018 17:31:52 ******/
1924SET ANSI_NULLS ON
1925GO
1926SET QUOTED_IDENTIFIER ON
1927GO
1928
1929-- start of smp_delete_farm_info
1930CREATE PROCEDURE [dbo].[smp_delete_farm_info]
1931@IN_FARM_UID INT
1932AS
1933SET NOCOUNT ON
1934
1935DELETE FROM dbo.Farm WHERE sid = @IN_FARM_UID
1936
1937-- end of smp_delete_farm_info
1938
1939GO
1940/****** Object: StoredProcedure [dbo].[smp_delete_friend] Script Date: 19/02/2018 17:31:52 ******/
1941SET ANSI_NULLS ON
1942GO
1943SET QUOTED_IDENTIFIER ON
1944GO
1945
1946-- start of smp_delete_friend
1947CREATE PROCEDURE [dbo].[smp_delete_friend]
1948@IN_OWNER_ID NVARCHAR(31),
1949@IN_FRIEND_ID NVARCHAR(31)
1950AS
1951
1952SET ROWCOUNT 1
1953WHILE 1=1
1954BEGIN
1955 DELETE FROM dbo.Friends WHERE sid IN ( SELECT TOP 1 sid FROM dbo.Friends WITH (NOLOCK) WHERE owner_id = @IN_OWNER_ID AND friend_id = @IN_FRIEND_ID )
1956 IF @@ROWCOUNT = 0 BREAK
1957END
1958SET ROWCOUNT 0
1959
1960RETURN @@ERROR
1961-- end of smp_delete_friend
1962
1963GO
1964/****** Object: StoredProcedure [dbo].[smp_delete_global_variable] Script Date: 19/02/2018 17:31:52 ******/
1965SET ANSI_NULLS ON
1966GO
1967SET QUOTED_IDENTIFIER ON
1968GO
1969
1970
1971-- start of smp_delete_global_variable
1972CREATE PROCEDURE [dbo].[smp_delete_global_variable]
1973@IN_KEY NVARCHAR(128)
1974
1975AS
1976SET NOCOUNT ON
1977
1978DELETE dbo.GlobalVariable WHERE name = @IN_KEY;
1979
1980
1981GO
1982/****** Object: StoredProcedure [dbo].[smp_delete_guild] Script Date: 19/02/2018 17:31:52 ******/
1983SET ANSI_NULLS ON
1984GO
1985SET QUOTED_IDENTIFIER ON
1986GO
1987
1988-- start of smp_delete_guild
1989CREATE PROCEDURE [dbo].[smp_delete_guild]
1990@IN_SID INT
1991
1992AS
1993SET NOCOUNT ON
1994
1995UPDATE dbo.Dungeon SET owner_guild_id = 0, tax_rate = 5 WHERE owner_guild_id = @IN_SID; -- 带傈 家蜡 æ‰åºŸ æ˜åŠ›
1996UPDATE dbo.Dungeon SET raid_guild_id = 0 WHERE raid_guild_id = @IN_SID; -- é¥æžé› æ‰åºŸ æ˜åŠ›
1997
1998DELETE dbo.DungeonRaidRecord WHERE guild_id = @IN_SID; -- é¥æžé› æ‰åºŸ æ˜åŠ›
1999
2000DELETE dbo.Guild WHERE sid = @IN_SID; -- è¾¨é› DB æ˜åŠ›
2001
2002
2003GO
2004/****** Object: StoredProcedure [dbo].[smp_delete_item_keeping_info] Script Date: 19/02/2018 17:31:52 ******/
2005SET ANSI_NULLS ON
2006GO
2007SET QUOTED_IDENTIFIER ON
2008GO
2009
2010-- start of smp_delete_item_keeping_info
2011CREATE PROCEDURE [dbo].[smp_delete_item_keeping_info]
2012@IN_KEEPING_UID INT,
2013@IN_RETURN_ITEM_TO_OWNER BIT,
2014@IN_PREV_OWNED_ITEM_UID BIGINT
2015AS
2016SET NOCOUNT ON
2017
2018BEGIN TRANSACTION
2019
2020-- DB å•é›é阑 规瘤çªæ‰ 困秦 Item.owner_id 蔼父 掘绢åˆç»Š ItemKeeping é¥å†…é› æ˜åŠ› 饶 Item 抛æžå–‰ä¿Š 诀å•æžé£˜
2021DECLARE @OWNER_UID INT
2022DECLARE @ITEM_UID BIGINT
2023
2024SELECT @ITEM_UID = item_id, @OWNER_UID = owner_id FROM dbo.ItemKeeping WHERE sid = @IN_KEEPING_UID
2025-- 困俊辑 1扒狼 å•æžç£å•Š 八祸登瘤 臼疽促æ DELETE å·©ä¿Š 狼秦 康氢阑 ç½é˜‘ é’狼 èå•Š 厚沥惑利æžæ‰¼ç»° æžå…·æ‰å•Š 登骨肺 贸府 å窜
2026IF @@ROWCOUNT <> 1
2027BEGIN
2028 ROLLBACK TRANSACTION
2029 RETURN @@ERROR
2030END
2031
2032DELETE dbo.ItemKeeping WHERE sid = @IN_KEEPING_UID
2033
2034IF @IN_RETURN_ITEM_TO_OWNER = 1
2035BEGIN
2036 -- 辑滚 肺æµæƒ‘ é…’æžè¢ 内é›å•Š 0 牢 é…’æžè¢(风乔甫 é…’æžè¢ 鸥æ¶æ 肺 DBä¿Š 焊包çªç»° 版快)篮
2037 -- 蜡历俊霸 馆券登绢辑绰 救登骨肺(蜡历 牢亥é…府俊 风乔肺 瘤éž) é…’æžè¢ ç˜¤éž è´¸åºœ 力寇
2038 DECLARE @ITEM_CODE INT
2039 DECLARE @ITEM_COUNT BIGINT
2040 SELECT @ITEM_CODE = code, @ITEM_COUNT = cnt FROM dbo.Item WHERE sid = @ITEM_UID
2041 IF @@ROWCOUNT <> 1
2042 BEGIN
2043 ROLLBACK TRANSACTION
2044 RETURN @@ERROR
2045 END
2046
2047 IF @ITEM_CODE <> 0
2048 BEGIN
2049 -- 牢亥é…府俊 悼è€èŒ„ é…’æžè¢é˜‘ 焊蜡çªç»Šä¹ç»¢ï¿½