Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1

    Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    if you want Open Quest Only Quest lv 56 you can use this Triger

    i create this for RF Grest 2.2.3.2 RF Grest

    Code:
    USE [RF_WORLD]
    GO
    
    /**Script Date: 04/30/2013 02:17:48 Warung Data Team**/
    
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    
    
    
    CREATE TRIGGER [dbo].[AutoOpenLimitMaxLevel]
       ON  [dbo].[tbl_general]
       FOR UPDATE
    AS 
    BEGIN
        SET NOCOUNT ON;
    	
    	DECLARE @LimitLv int;
    	DECLARE @TSerial int;
    	
    	if update(MaxLevel)
    	begin
    		SELECT @TSerial = Serial, @LimitLv = MaxLevel
    		from Inserted
    		if (@LimitLv = 66)
    		begin
    		update RF_WORLD.dbo.tbl_general SET MaxLevel = '75' where Serial = @TSerial
    			end
    		end
    		end
    
    
    
    
    
    GO
    Change this to your Max Level MaxLevel = '75'

    Exsample if your max Level 80 Change '75' to 80


  2. #2
    Enthusiast regi is offline
    MemberRank
    Aug 2011 Join Date
    MedanLocation
    46Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    finally you share it brother

    now we wait you share for actived cash shop , wkwkwkk

    kidding

  3. #3
    Pokemon Tamer dpman is offline
    MemberRank
    Feb 2010 Join Date
    Pokemon WorldLocation
    592Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    you just need to hex your zoneserver to increase the limit level, you dont need this kind of query..

  4. #4

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by dpman View Post
    you just need to hex your zoneserver to increase the limit level, you dont need this kind of query..
    yes you can Hex Zone server to Open MaxLevel. but how you disable Quest Lv 50 just Open Lv 56 with no Edit Quest.dat ?

    i create that's Query Triger if you want Open Only Quest Lv 56.

    Set Default MaxLevel value to 56 and if Quest Lv 56 Finis Triger Automatic update to Max Lv Limit
    Last edited by letjen; 30-04-13 at 02:47 AM.

  5. #5
    iam still Noob novanakal is offline
    MemberRank
    Nov 2009 Join Date
    Jaka, IndonesiaLocation
    1,164Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    for a simple way
    open Quest.dat
    look at the maxlevel for quest 50..

    change 56 to 0
    no need trigger for that

  6. #6
    Account Upgraded | Title Enabled! leonara is offline
    MemberRank
    Dec 2010 Join Date
    IndonesiaLocation
    540Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by novanakal View Post
    for a simple way
    open Quest.dat
    look at the maxlevel for quest 50..

    change 56 to 0
    no need trigger for that
    Dont Forget Edit Client And Server

  7. #7
    Pokemon Tamer dpman is offline
    MemberRank
    Feb 2010 Join Date
    Pokemon WorldLocation
    592Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    you dont need to edit client side, just server side is enough

  8. #8
    Enthusiast second2nd is offline
    MemberRank
    Feb 2010 Join Date
    Di depan kompiLocation
    45Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    how about maxlevel 66 ?
    is that just modify maxlevel to 56 for enable quest 56 ?

  9. #9

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    i will release soon Auto Premium Cafe Event
    Last edited by letjen; 04-05-13 at 07:13 PM.

  10. #10
    Valued Member Chyz is offline
    MemberRank
    May 2013 Join Date
    In Your DreamLocation
    108Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by regi View Post
    finally you share it brother

    now we wait you share for actived cash shop , wkwkwkk

    kidding
    activated cash shop?
    huh roslaw already make a sql query for activated cash shop ;)

  11. #11
    Enthusiast powerup is offline
    MemberRank
    May 2012 Join Date
    Daerah Khusus ILocation
    47Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by letjen View Post
    if you want Open Quest Only Quest lv 56 you can use this Triger

    i create this for RF Grest 2.2.3.2 RF Grest

    Code:
    USE [RF_WORLD]
    GO
    
    /**Script Date: 04/30/2013 02:17:48 Warung Data Team**/
    
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    
    
    
    CREATE TRIGGER [dbo].[AutoOpenLimitMaxLevel]
       ON  [dbo].[tbl_general]
       FOR UPDATE
    AS 
    BEGIN
        SET NOCOUNT ON;
    	
    	DECLARE @LimitLv int;
    	DECLARE @TSerial int;
    	
    	if update(MaxLevel)
    	begin
    		SELECT @TSerial = Serial, @LimitLv = MaxLevel
    		from Inserted
    		if (@LimitLv = 66)
    		begin
    		update RF_WORLD.dbo.tbl_general SET MaxLevel = '75' where Serial = @TSerial
    			end
    		end
    		end
    
    
    
    
    
    GO
    Change this to your Max Level MaxLevel = '75'

    Exsample if your max Level 80 Change '75' to 80
    soory need ask someting about this .. how to combain Max lv 85 ,all skill and PT GM,SKip quest and Bag 5 in first play ?

    Check this pleas


    Quote Originally Posted by agoenk View Post
    Code:
    USE [RF_WORLD]
    GO
    
    /****** Object:  Table [dbo].[tbl_general]    Script Date: 01/21/2012 12:35:29 ******/
    -- =============================================
    -- Author:            novanakal@rf-reborn.com
    -- Create date:     01/21/2012 12:35:29
    -- Description:      PT-GM, MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill
    -- Source:            http://rf-dev.net  
    -- =============================================
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    SET ANSI_PADDING ON
    GO
    
    CREATE TABLE [dbo].[tbl_general](
        [Serial] [int] NOT NULL,
        [DCK] [bit] NOT NULL,
        [TotalPlayMin] [int] NOT NULL,
        [Exp] [float] NOT NULL,
        [LossExp] [float] NOT NULL,
        [HP] [int] NOT NULL,
        [FP] [int] NOT NULL,
        [SP] [int] NOT NULL,
        [DP] [int] NOT NULL,
        [Map] [int] NOT NULL,
        [X] [float] NOT NULL,
        [Y] [float] NOT NULL,
        [Z] [float] NOT NULL,
        [BagNum] [int] NOT NULL,
        [EK0] [int] NOT NULL,
        [ED0] [smallint] NOT NULL,
        [EK1] [int] NOT NULL,
        [ED1] [smallint] NOT NULL,
        [EK2] [int] NOT NULL,
        [ED2] [smallint] NOT NULL,
        [EK3] [int] NOT NULL,
        [ED3] [smallint] NOT NULL,
        [EK4] [int] NOT NULL,
        [ED4] [smallint] NOT NULL,
        [EK5] [int] NOT NULL,
        [ED5] [smallint] NOT NULL,
        [F0] [int] NOT NULL,
        [F1] [int] NOT NULL,
        [F2] [int] NOT NULL,
        [F3] [int] NOT NULL,
        [F4] [int] NOT NULL,
        [F5] [int] NOT NULL,
        [F6] [int] NOT NULL,
        [F7] [int] NOT NULL,
        [F8] [int] NOT NULL,
        [F9] [int] NOT NULL,
        [F10] [int] NOT NULL,
        [F11] [int] NOT NULL,
        [F12] [int] NOT NULL,
        [F13] [int] NOT NULL,
        [F14] [int] NOT NULL,
        [F15] [int] NOT NULL,
        [F16] [int] NOT NULL,
        [F17] [int] NOT NULL,
        [F18] [int] NOT NULL,
        [F19] [int] NOT NULL,
        [F20] [int] NOT NULL,
        [F21] [int] NOT NULL,
        [F22] [int] NOT NULL,
        [F23] [int] NOT NULL,
        [F24] [int] NOT NULL,
        [F25] [int] NOT NULL,
        [F26] [int] NOT NULL,
        [F27] [int] NOT NULL,
        [F28] [int] NOT NULL,
        [F29] [int] NOT NULL,
        [F30] [int] NOT NULL,
        [F31] [int] NOT NULL,
        [F32] [int] NOT NULL,
        [F33] [int] NOT NULL,
        [F34] [int] NOT NULL,
        [F35] [int] NOT NULL,
        [F36] [int] NOT NULL,
        [F37] [int] NOT NULL,
        [F38] [int] NOT NULL,
        [F39] [int] NOT NULL,
        [F40] [int] NOT NULL,
        [F41] [int] NOT NULL,
        [F42] [int] NOT NULL,
        [F43] [int] NOT NULL,
        [F44] [int] NOT NULL,
        [F45] [int] NOT NULL,
        [F46] [int] NOT NULL,
        [F47] [int] NOT NULL,
        [F48] [int] NOT NULL,
        [F49] [int] NOT NULL,
        [F50] [int] NOT NULL,
        [F51] [int] NOT NULL,
        [F52] [int] NOT NULL,
        [F53] [int] NOT NULL,
        [F54] [int] NOT NULL,
        [F55] [int] NOT NULL,
        [F56] [int] NOT NULL,
        [F57] [int] NOT NULL,
        [F58] [int] NOT NULL,
        [F59] [int] NOT NULL,
        [F60] [int] NOT NULL,
        [F61] [int] NOT NULL,
        [F62] [int] NOT NULL,
        [F63] [int] NOT NULL,
        [F64] [int] NOT NULL,
        [F65] [int] NOT NULL,
        [F66] [int] NOT NULL,
        [F67] [int] NOT NULL,
        [F68] [int] NOT NULL,
        [F69] [int] NOT NULL,
        [F70] [int] NOT NULL,
        [F71] [int] NOT NULL,
        [F72] [int] NOT NULL,
        [F73] [int] NOT NULL,
        [F74] [int] NOT NULL,
        [F75] [int] NOT NULL,
        [F76] [int] NOT NULL,
        [F77] [int] NOT NULL,
        [F78] [int] NOT NULL,
        [F79] [int] NOT NULL,
        [F80] [int] NOT NULL,
        [F81] [int] NOT NULL,
        [F82] [int] NOT NULL,
        [F83] [int] NOT NULL,
        [F84] [int] NOT NULL,
        [F85] [int] NOT NULL,
        [F86] [int] NOT NULL,
        [F87] [int] NOT NULL,
        [F88] [int] NOT NULL,
        [F89] [int] NOT NULL,
        [F90] [int] NOT NULL,
        [F91] [int] NOT NULL,
        [F92] [int] NOT NULL,
        [F93] [int] NOT NULL,
        [F94] [int] NOT NULL,
        [F95] [int] NOT NULL,
        [F96] [int] NOT NULL,
        [F97] [int] NOT NULL,
        [F98] [int] NOT NULL,
        [F99] [int] NOT NULL,
        [AK0] [tinyint] NOT NULL,
        [AD0] [bigint] NOT NULL,
        [AP0] [int] NOT NULL,
        [AK1] [tinyint] NOT NULL,
        [AD1] [bigint] NOT NULL,
        [AP1] [int] NOT NULL,
        [AK2] [tinyint] NOT NULL,
        [AD2] [bigint] NOT NULL,
        [AP2] [int] NOT NULL,
        [AK3] [tinyint] NOT NULL,
        [AD3] [bigint] NOT NULL,
        [AP3] [int] NOT NULL,
        [WM0] [int] NOT NULL,
        [WM1] [int] NOT NULL,
        [DM] [int] NOT NULL,
        [PM] [int] NOT NULL,
        [MI0] [int] NOT NULL,
        [MI1] [int] NOT NULL,
        [MI2] [int] NOT NULL,
        [SR] [int] NOT NULL,
        [FM0] [int] NOT NULL,
        [FM1] [int] NOT NULL,
        [FM2] [int] NOT NULL,
        [FM3] [int] NOT NULL,
        [FM4] [int] NOT NULL,
        [FM5] [int] NOT NULL,
        [FM6] [int] NOT NULL,
        [FM7] [int] NOT NULL,
        [FM8] [int] NOT NULL,
        [FM9] [int] NOT NULL,
        [FM10] [int] NOT NULL,
        [FM11] [int] NOT NULL,
        [FM12] [int] NOT NULL,
        [FM13] [int] NOT NULL,
        [FM14] [int] NOT NULL,
        [FM15] [int] NOT NULL,
        [FM16] [int] NOT NULL,
        [FM17] [int] NOT NULL,
        [FM18] [int] NOT NULL,
        [FM19] [int] NOT NULL,
        [FM20] [int] NOT NULL,
        [FM21] [int] NOT NULL,
        [FM22] [int] NOT NULL,
        [FM23] [int] NOT NULL,
        [SM0] [int] NOT NULL,
        [SM1] [int] NOT NULL,
        [SM2] [int] NOT NULL,
        [SM3] [int] NOT NULL,
        [SM4] [int] NOT NULL,
        [SM5] [int] NOT NULL,
        [SM6] [int] NOT NULL,
        [SM7] [int] NOT NULL,
        [SM8] [int] NOT NULL,
        [SM9] [int] NOT NULL,
        [SM10] [int] NOT NULL,
        [SM11] [int] NOT NULL,
        [SM12] [int] NOT NULL,
        [SM13] [int] NOT NULL,
        [SM14] [int] NOT NULL,
        [SM15] [int] NOT NULL,
        [SM16] [int] NOT NULL,
        [SM17] [int] NOT NULL,
        [SM18] [int] NOT NULL,
        [SM19] [int] NOT NULL,
        [SM20] [int] NOT NULL,
        [SM21] [int] NOT NULL,
        [SM22] [int] NOT NULL,
        [SM23] [int] NOT NULL,
        [SM24] [int] NOT NULL,
        [SM25] [int] NOT NULL,
        [SM26] [int] NOT NULL,
        [SM27] [int] NOT NULL,
        [SM28] [int] NOT NULL,
        [SM29] [int] NOT NULL,
        [SM30] [int] NOT NULL,
        [SM31] [int] NOT NULL,
        [SM32] [int] NOT NULL,
        [SM33] [int] NOT NULL,
        [SM34] [int] NOT NULL,
        [SM35] [int] NOT NULL,
        [SM36] [int] NOT NULL,
        [SM37] [int] NOT NULL,
        [SM38] [int] NOT NULL,
        [SM39] [int] NOT NULL,
        [SM40] [int] NOT NULL,
        [SM41] [int] NOT NULL,
        [SM42] [int] NOT NULL,
        [SM43] [int] NOT NULL,
        [SM44] [int] NOT NULL,
        [SM45] [int] NOT NULL,
        [SM46] [int] NOT NULL,
        [SM47] [int] NOT NULL,
        [SM48] [int] NOT NULL,
        [SM49] [int] NOT NULL,
        [LeftResList] [varchar](160) NOT NULL,
        [Class0] [smallint] NOT NULL,
        [Class1] [smallint] NOT NULL,
        [Class2] [smallint] NOT NULL,
        [ClassInitCnt] [int] NOT NULL,
        [LastClassGrade] [tinyint] NOT NULL,
        [PvpPoint] [float] NOT NULL,
        [PvpCashBag] [float] NOT NULL,
        [BindMapCode] [varchar](12) NOT NULL,
        [BindDummy] [varchar](12) NOT NULL,
        [GuildSerial] [int] NULL,
        [GuildGrade] [tinyint] NULL,
        [GuildRank] [smallint] NULL,
        [PvP_0] [float] NOT NULL,
        [PK_0] [int] NOT NULL,
        [PvP_1] [float] NOT NULL,
        [PK_1] [int] NOT NULL,
        [PvP_2] [float] NOT NULL,
        [PK_2] [int] NOT NULL,
        [CharacterGrade] [int] NOT NULL,
        [Die_0] [int] NOT NULL,
        [Die_1] [int] NOT NULL,
        [Die_2] [int] NOT NULL,
        [tmRaceBossVote] [datetime] NOT NULL,
        [TakeLastMentalTicket] [int] NOT NULL,
        [TakeLastCriTicket] [int] NOT NULL,
        [RDDelay] [int] NOT NULL,
        [ES0] [bigint] NOT NULL,
        [ET0] [int] NOT NULL,
        [ES1] [bigint] NOT NULL,
        [ET1] [int] NOT NULL,
        [ES2] [bigint] NOT NULL,
        [ET2] [int] NOT NULL,
        [ES3] [bigint] NOT NULL,
        [ET3] [int] NOT NULL,
        [ES4] [bigint] NOT NULL,
        [ET4] [int] NOT NULL,
        [ES5] [bigint] NOT NULL,
        [ET5] [int] NOT NULL,
        [AS0] [bigint] NOT NULL,
        [AS1] [bigint] NOT NULL,
        [AS2] [bigint] NOT NULL,
        [AS3] [bigint] NOT NULL,
        [FS0] [bigint] NOT NULL,
        [FS1] [bigint] NOT NULL,
        [FS2] [bigint] NOT NULL,
        [FS3] [bigint] NOT NULL,
        [FS4] [bigint] NOT NULL,
        [FS5] [bigint] NOT NULL,
        [FS6] [bigint] NOT NULL,
        [FS7] [bigint] NOT NULL,
        [FS8] [bigint] NOT NULL,
        [FS9] [bigint] NOT NULL,
        [FS10] [bigint] NOT NULL,
        [FS11] [bigint] NOT NULL,
        [FS12] [bigint] NOT NULL,
        [FS13] [bigint] NOT NULL,
        [FS14] [bigint] NOT NULL,
        [FS15] [bigint] NOT NULL,
        [FS16] [bigint] NOT NULL,
        [FS17] [bigint] NOT NULL,
        [FS18] [bigint] NOT NULL,
        [FS19] [bigint] NOT NULL,
        [FS20] [bigint] NOT NULL,
        [FS21] [bigint] NOT NULL,
        [FS22] [bigint] NOT NULL,
        [FS23] [bigint] NOT NULL,
        [FS24] [bigint] NOT NULL,
        [FS25] [bigint] NOT NULL,
        [FS26] [bigint] NOT NULL,
        [FS27] [bigint] NOT NULL,
        [FS28] [bigint] NOT NULL,
        [FS29] [bigint] NOT NULL,
        [FS30] [bigint] NOT NULL,
        [FS31] [bigint] NOT NULL,
        [FS32] [bigint] NOT NULL,
        [FS33] [bigint] NOT NULL,
        [FS34] [bigint] NOT NULL,
        [FS35] [bigint] NOT NULL,
        [FS36] [bigint] NOT NULL,
        [FS37] [bigint] NOT NULL,
        [FS38] [bigint] NOT NULL,
        [FS39] [bigint] NOT NULL,
        [FS40] [bigint] NOT NULL,
        [FS41] [bigint] NOT NULL,
        [FS42] [bigint] NOT NULL,
        [FS43] [bigint] NOT NULL,
        [FS44] [bigint] NOT NULL,
        [FS45] [bigint] NOT NULL,
        [FS46] [bigint] NOT NULL,
        [FS47] [bigint] NOT NULL,
        [FS48] [bigint] NOT NULL,
        [FS49] [bigint] NOT NULL,
        [FS50] [bigint] NOT NULL,
        [FS51] [bigint] NOT NULL,
        [FS52] [bigint] NOT NULL,
        [FS53] [bigint] NOT NULL,
        [FS54] [bigint] NOT NULL,
        [FS55] [bigint] NOT NULL,
        [FS56] [bigint] NOT NULL,
        [FS57] [bigint] NOT NULL,
        [FS58] [bigint] NOT NULL,
        [FS59] [bigint] NOT NULL,
        [FS60] [bigint] NOT NULL,
        [FS61] [bigint] NOT NULL,
        [FS62] [bigint] NOT NULL,
        [FS63] [bigint] NOT NULL,
        [FS64] [bigint] NOT NULL,
        [FS65] [bigint] NOT NULL,
        [FS66] [bigint] NOT NULL,
        [FS67] [bigint] NOT NULL,
        [FS68] [bigint] NOT NULL,
        [FS69] [bigint] NOT NULL,
        [FS70] [bigint] NOT NULL,
        [FS71] [bigint] NOT NULL,
        [FS72] [bigint] NOT NULL,
        [FS73] [bigint] NOT NULL,
        [FS74] [bigint] NOT NULL,
        [FS75] [bigint] NOT NULL,
        [FS76] [bigint] NOT NULL,
        [FS77] [bigint] NOT NULL,
        [FS78] [bigint] NOT NULL,
        [FS79] [bigint] NOT NULL,
        [FS80] [bigint] NOT NULL,
        [FS81] [bigint] NOT NULL,
        [FS82] [bigint] NOT NULL,
        [FS83] [bigint] NOT NULL,
        [FS84] [bigint] NOT NULL,
        [FS85] [bigint] NOT NULL,
        [FS86] [bigint] NOT NULL,
        [FS87] [bigint] NOT NULL,
        [FS88] [bigint] NOT NULL,
        [FS89] [bigint] NOT NULL,
        [FS90] [bigint] NOT NULL,
        [FS91] [bigint] NOT NULL,
        [FS92] [bigint] NOT NULL,
        [FS93] [bigint] NOT NULL,
        [FS94] [bigint] NOT NULL,
        [FS95] [bigint] NOT NULL,
        [FS96] [bigint] NOT NULL,
        [FS97] [bigint] NOT NULL,
        [FS98] [bigint] NOT NULL,
        [FS99] [bigint] NOT NULL,
        [MaxLevel] [int] NOT NULL,
        [GuildStatus] [tinyint] NOT NULL,
     CONSTRAINT [PK_tbl_general] PRIMARY KEY CLUSTERED 
    (
        [Serial] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    
    SET ANSI_PADDING OFF
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Serial]  DEFAULT ((-1)) FOR [Serial]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_DCK]  DEFAULT ((0)) FOR [DCK]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_TotalPlayMin]  DEFAULT ((0)) FOR [TotalPlayMin]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Exp]  DEFAULT ((0)) FOR [Exp]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_LossExp]  DEFAULT ((0)) FOR [LossExp]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_HP]  DEFAULT ((1000)) FOR [HP]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FP]  DEFAULT ((1000)) FOR [FP]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SP]  DEFAULT ((1000)) FOR [SP]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_DP]  DEFAULT ((0)) FOR [DP]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Map]  DEFAULT ((0)) FOR [Map]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_X]  DEFAULT ((0)) FOR [X]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Y]  DEFAULT ((65535)) FOR [Y]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Z]  DEFAULT ((0)) FOR [Z]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_BagNum]  DEFAULT ((5)) FOR [BagNum]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_EK0]  DEFAULT (0xFFFFFFFF) FOR [EK0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ED0]  DEFAULT ((0)) FOR [ED0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_EK1]  DEFAULT (0xFFFFFFFF) FOR [EK1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ED1]  DEFAULT ((0)) FOR [ED1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_EK2]  DEFAULT (0xFFFFFFFF) FOR [EK2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ED2]  DEFAULT ((0)) FOR [ED2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_EK3]  DEFAULT (0xFFFFFFFF) FOR [EK3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ED3]  DEFAULT ((0)) FOR [ED3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_EK4]  DEFAULT (0xFFFFFFFF) FOR [EK4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ED4]  DEFAULT ((0)) FOR [ED4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_EK5]  DEFAULT (0xFFFFFFFF) FOR [EK5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ED5]  DEFAULT ((0)) FOR [ED5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F0]  DEFAULT ((16777215)) FOR [F0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F1]  DEFAULT ((33554431)) FOR [F1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F2]  DEFAULT ((50331647)) FOR [F2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F3]  DEFAULT ((67108863)) FOR [F3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F4]  DEFAULT ((83886079)) FOR [F4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F5]  DEFAULT ((100663295)) FOR [F5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F6]  DEFAULT ((117440511)) FOR [F6]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F7]  DEFAULT ((134217727)) FOR [F7]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F8]  DEFAULT ((150994943)) FOR [F8]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F9]  DEFAULT ((167772159)) FOR [F9]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F10]  DEFAULT ((184549375)) FOR [F10]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F11]  DEFAULT ((201326591)) FOR [F11]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F12]  DEFAULT ((218103807)) FOR [F12]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F13]  DEFAULT ((-1)) FOR [F13]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F14]  DEFAULT ((-1)) FOR [F14]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F15]  DEFAULT ((-1)) FOR [F15]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F16]  DEFAULT ((285212671)) FOR [F16]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F17]  DEFAULT ((301989887)) FOR [F17]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F18]  DEFAULT ((318767103)) FOR [F18]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F19]  DEFAULT ((335544319)) FOR [F19]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F20]  DEFAULT ((352321535)) FOR [F20]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F21]  DEFAULT ((369098751)) FOR [F21]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F22]  DEFAULT ((385875967)) FOR [F22]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F23]  DEFAULT ((402653183)) FOR [F23]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F24]  DEFAULT ((419430399)) FOR [F24]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F25]  DEFAULT ((-1)) FOR [F25]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F26]  DEFAULT ((-1)) FOR [F26]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F27]  DEFAULT ((-1)) FOR [F27]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F28]  DEFAULT ((503316479)) FOR [F28]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F29]  DEFAULT ((520093695)) FOR [F29]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F30]  DEFAULT ((536870911)) FOR [F30]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F31]  DEFAULT ((553648127)) FOR [F31]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F32]  DEFAULT ((570425343)) FOR [F32]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F33]  DEFAULT ((587202559)) FOR [F33]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F34]  DEFAULT ((603979775)) FOR [F34]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F35]  DEFAULT ((620756991)) FOR [F35]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F36]  DEFAULT ((637534207)) FOR [F36]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F37]  DEFAULT ((654311423)) FOR [F37]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F38]  DEFAULT ((671088639)) FOR [F38]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F39]  DEFAULT ((-1)) FOR [F39]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F40]  DEFAULT ((-1)) FOR [F40]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F41]  DEFAULT ((-1)) FOR [F41]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F42]  DEFAULT ((-1)) FOR [F42]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F43]  DEFAULT ((771751935)) FOR [F43]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F44]  DEFAULT ((788529151)) FOR [F44]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F45]  DEFAULT ((805306367)) FOR [F45]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F46]  DEFAULT ((822083583)) FOR [F46]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F47]  DEFAULT ((838860799)) FOR [F47]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F48]  DEFAULT ((855638015)) FOR [F48]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F49]  DEFAULT ((872415231)) FOR [F49]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F50]  DEFAULT ((889192447)) FOR [F50]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F51]  DEFAULT ((905969663)) FOR [F51]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F52]  DEFAULT ((922746879)) FOR [F52]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F53]  DEFAULT ((939524095)) FOR [F53]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F54]  DEFAULT ((-1)) FOR [F54]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F55]  DEFAULT ((-1)) FOR [F55]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F56]  DEFAULT ((-1)) FOR [F56]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F57]  DEFAULT ((-1)) FOR [F57]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F58]  DEFAULT ((1040187391)) FOR [F58]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F59]  DEFAULT ((1056964607)) FOR [F59]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F60]  DEFAULT ((1073741823)) FOR [F60]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F61]  DEFAULT ((1090519039)) FOR [F61]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F62]  DEFAULT ((1107296255)) FOR [F62]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F63]  DEFAULT ((1124073471)) FOR [F63]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F64]  DEFAULT ((1140850687)) FOR [F64]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F65]  DEFAULT ((1157627903)) FOR [F65]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F66]  DEFAULT ((1174405119)) FOR [F66]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F67]  DEFAULT ((1191182335)) FOR [F67]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F68]  DEFAULT ((1207959551)) FOR [F68]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F69]  DEFAULT ((-1)) FOR [F69]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F70]  DEFAULT ((-1)) FOR [F70]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F71]  DEFAULT ((-1)) FOR [F71]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F72]  DEFAULT ((-1)) FOR [F72]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F73]  DEFAULT ((1308622847)) FOR [F73]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F74]  DEFAULT ((1325400063)) FOR [F74]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F75]  DEFAULT ((1342177279)) FOR [F75]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F76]  DEFAULT ((1358954495)) FOR [F76]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F77]  DEFAULT ((1375731711)) FOR [F77]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F78]  DEFAULT ((1392508927)) FOR [F78]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F79]  DEFAULT ((1409286143)) FOR [F79]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F80]  DEFAULT ((1426063359)) FOR [F80]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F81]  DEFAULT ((1442840575)) FOR [F81]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F82]  DEFAULT ((1459617791)) FOR [F82]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F83]  DEFAULT ((1476395007)) FOR [F83]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F84]  DEFAULT ((-1)) FOR [F84]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F85]  DEFAULT ((-1)) FOR [F85]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F86]  DEFAULT ((-1)) FOR [F86]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F87]  DEFAULT ((-1)) FOR [F87]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F88]  DEFAULT (0xFFFFFFFF) FOR [F88]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F89]  DEFAULT (0xFFFFFFFF) FOR [F89]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F90]  DEFAULT (0xFFFFFFFF) FOR [F90]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F91]  DEFAULT (0xFFFFFFFF) FOR [F91]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F92]  DEFAULT (0xFFFFFFFF) FOR [F92]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F93]  DEFAULT (0xFFFFFFFF) FOR [F93]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F94]  DEFAULT (0xFFFFFFFF) FOR [F94]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F95]  DEFAULT (0xFFFFFFFF) FOR [F95]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F96]  DEFAULT (0xFFFFFFFF) FOR [F96]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F97]  DEFAULT (0xFFFFFFFF) FOR [F97]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F98]  DEFAULT (0xFFFFFFFF) FOR [F98]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_F99]  DEFAULT (0xFFFFFFFF) FOR [F99]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AK0]  DEFAULT (0xFF) FOR [AK0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AD0]  DEFAULT ((0)) FOR [AD0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AP]  DEFAULT ((0)) FOR [AP0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AK01]  DEFAULT (0xFF) FOR [AK1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AD1]  DEFAULT ((0)) FOR [AD1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AP1]  DEFAULT ((0)) FOR [AP1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AK01_1]  DEFAULT (0xFF) FOR [AK2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AD2]  DEFAULT ((0)) FOR [AD2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AP2]  DEFAULT ((0)) FOR [AP2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AK01_2]  DEFAULT (0xFF) FOR [AK3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AD3]  DEFAULT ((0)) FOR [AD3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_AP3]  DEFAULT ((0)) FOR [AP3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_WM0]  DEFAULT ((2147483647)) FOR [WM0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_WM1]  DEFAULT ((2147483647)) FOR [WM1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_DM]  DEFAULT ((2147483647)) FOR [DM]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PM]  DEFAULT ((2147483647)) FOR [PM]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_MI]  DEFAULT ((2147483647)) FOR [MI0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_MI1]  DEFAULT ((2147483647)) FOR [MI1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_MI2]  DEFAULT ((2147483647)) FOR [MI2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SR]  DEFAULT ((2147483647)) FOR [SR]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM0]  DEFAULT ((2147483647)) FOR [FM0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM1]  DEFAULT ((2147483647)) FOR [FM1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM2]  DEFAULT ((2147483647)) FOR [FM2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM3]  DEFAULT ((0)) FOR [FM3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM4]  DEFAULT ((2147483647)) FOR [FM4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM5]  DEFAULT ((2147483647)) FOR [FM5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM6]  DEFAULT ((2147483647)) FOR [FM6]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM7]  DEFAULT ((0)) FOR [FM7]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM8]  DEFAULT ((2147483647)) FOR [FM8]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM9]  DEFAULT ((2147483647)) FOR [FM9]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM10]  DEFAULT ((2147483647)) FOR [FM10]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM11]  DEFAULT ((0)) FOR [FM11]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM12]  DEFAULT ((2147483647)) FOR [FM12]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM13]  DEFAULT ((2147483647)) FOR [FM13]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM14]  DEFAULT ((2147483647)) FOR [FM14]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM15]  DEFAULT ((0)) FOR [FM15]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM16]  DEFAULT ((2147483647)) FOR [FM16]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM17]  DEFAULT ((2147483647)) FOR [FM17]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM18]  DEFAULT ((2147483647)) FOR [FM18]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM19]  DEFAULT ((0)) FOR [FM19]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM20]  DEFAULT ((2147483647)) FOR [FM20]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM21]  DEFAULT ((2147483647)) FOR [FM21]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM22]  DEFAULT ((2147483647)) FOR [FM22]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_FM23]  DEFAULT ((0)) FOR [FM23]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM0]  DEFAULT ((357913952)) FOR [SM0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM1]  DEFAULT ((357913952)) FOR [SM1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM2]  DEFAULT ((357913952)) FOR [SM2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM3]  DEFAULT ((357913952)) FOR [SM3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM4]  DEFAULT ((357913952)) FOR [SM4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM5]  DEFAULT ((357913952)) FOR [SM5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM6]  DEFAULT ((357913952)) FOR [SM6]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM7]  DEFAULT ((357913952)) FOR [SM7]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM8]  DEFAULT ((357913952)) FOR [SM8]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM9]  DEFAULT ((357913952)) FOR [SM9]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM10]  DEFAULT ((357913952)) FOR [SM10]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM11]  DEFAULT ((357913952)) FOR [SM11]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM12]  DEFAULT ((429496736)) FOR [SM12]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM13]  DEFAULT ((429496736)) FOR [SM13]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM14]  DEFAULT ((429496736)) FOR [SM14]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM15]  DEFAULT ((429496736)) FOR [SM15]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM16]  DEFAULT ((429496736)) FOR [SM16]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM17]  DEFAULT ((0)) FOR [SM17]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM18]  DEFAULT ((0)) FOR [SM18]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM19]  DEFAULT ((0)) FOR [SM19]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM20]  DEFAULT ((0)) FOR [SM20]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM21]  DEFAULT ((0)) FOR [SM21]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM22]  DEFAULT ((0)) FOR [SM22]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM23]  DEFAULT ((0)) FOR [SM23]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM01]  DEFAULT ((715827904)) FOR [SM24]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM02]  DEFAULT ((0)) FOR [SM25]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM03]  DEFAULT ((0)) FOR [SM26]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM04]  DEFAULT ((715827904)) FOR [SM27]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM05]  DEFAULT ((715827904)) FOR [SM28]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM06]  DEFAULT ((0)) FOR [SM29]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM01_1]  DEFAULT ((536870912)) FOR [SM30]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM211]  DEFAULT ((536870912)) FOR [SM31]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM221]  DEFAULT ((0)) FOR [SM32]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM231]  DEFAULT ((536870912)) FOR [SM33]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM241]  DEFAULT ((536870912)) FOR [SM34]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM251]  DEFAULT ((0)) FOR [SM35]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM261]  DEFAULT ((715827904)) FOR [SM36]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM271]  DEFAULT ((715827904)) FOR [SM37]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM281]  DEFAULT ((0)) FOR [SM38]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM291]  DEFAULT ((715827904)) FOR [SM39]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM40]  DEFAULT ((0)) FOR [SM40]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM401]  DEFAULT ((0)) FOR [SM41]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM402]  DEFAULT ((0)) FOR [SM42]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM403]  DEFAULT ((0)) FOR [SM43]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM404]  DEFAULT ((0)) FOR [SM44]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM405]  DEFAULT ((0)) FOR [SM45]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM406]  DEFAULT ((0)) FOR [SM46]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM407]  DEFAULT ((0)) FOR [SM47]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM408]  DEFAULT ((0)) FOR [SM48]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_SM409]  DEFAULT ((0)) FOR [SM49]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_LeftResList]  DEFAULT ('*') FOR [LeftResList]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Class0]  DEFAULT ((-1)) FOR [Class0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Class1]  DEFAULT ((-1)) FOR [Class1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Class2]  DEFAULT ((-1)) FOR [Class2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_ClassInitCnt]  DEFAULT ((0)) FOR [ClassInitCnt]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_LastClassGrade]  DEFAULT ((0)) FOR [LastClassGrade]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PvPPoint]  DEFAULT ((0)) FOR [PvpPoint]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PvPCashBag]  DEFAULT ((0)) FOR [PvpCashBag]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_BindMapCode]  DEFAULT ('0') FOR [BindMapCode]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_BindDummy]  DEFAULT ('0') FOR [BindDummy]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_General_GuildSerial]  DEFAULT (0xFFFFFFFF) FOR [GuildSerial]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_General_GuildGrade]  DEFAULT (0xFF) FOR [GuildGrade]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_GuildRank]  DEFAULT (0xFFFF) FOR [GuildRank]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PvP_0]  DEFAULT ((0)) FOR [PvP_0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PK_0]  DEFAULT ((0)) FOR [PK_0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PvP_1]  DEFAULT ((0)) FOR [PvP_1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PK_1]  DEFAULT ((0)) FOR [PK_1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PvP_2]  DEFAULT ((0)) FOR [PvP_2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_PK_2]  DEFAULT ((0)) FOR [PK_2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general__CharacterGrade]  DEFAULT ((0)) FOR [CharacterGrade]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Die_0]  DEFAULT ((0)) FOR [Die_0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Die_1]  DEFAULT ((0)) FOR [Die_1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_Die_2]  DEFAULT ((0)) FOR [Die_2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_tmracebossvote]  DEFAULT ('1990-01-01') FOR [tmRaceBossVote]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_gener__TakeL__2D73677A]  DEFAULT ((0)) FOR [TakeLastMentalTicket]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_gener__TakeL__304FD425]  DEFAULT ((0)) FOR [TakeLastCriTicket]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_gener__RDDel__332C40D0]  DEFAULT ((0)) FOR [RDDelay]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ES0__7442102D]  DEFAULT ((0)) FOR [ES0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ET0__75363466]  DEFAULT (0xFFFFFFFF) FOR [ET0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ES1__762A589F]  DEFAULT ((0)) FOR [ES1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ET1__771E7CD8]  DEFAULT (0xFFFFFFFF) FOR [ET1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ES2__7812A111]  DEFAULT ((0)) FOR [ES2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ET2__7906C54A]  DEFAULT (0xFFFFFFFF) FOR [ET2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ES3__79FAE983]  DEFAULT ((0)) FOR [ES3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ET3__7AEF0DBC]  DEFAULT (0xFFFFFFFF) FOR [ET3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ES4__7BE331F5]  DEFAULT ((0)) FOR [ES4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ET4__7CD7562E]  DEFAULT (0xFFFFFFFF) FOR [ET4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ES5__7DCB7A67]  DEFAULT ((0)) FOR [ES5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__ET5__7EBF9EA0]  DEFAULT (0xFFFFFFFF) FOR [ET5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__AS0__7FB3C2D9]  DEFAULT ((0)) FOR [AS0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__AS1__00A7E712]  DEFAULT ((0)) FOR [AS1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__AS2__019C0B4B]  DEFAULT ((0)) FOR [AS2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__AS3__02902F84]  DEFAULT ((0)) FOR [AS3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS0__038453BD]  DEFAULT ((80350831968256.)) FOR [FS0]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS1__047877F6]  DEFAULT ((80350831968256.)) FOR [FS1]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS2__056C9C2F]  DEFAULT ((80350831968256.)) FOR [FS2]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS3__0660C068]  DEFAULT ((80350831968256.)) FOR [FS3]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS4__0754E4A1]  DEFAULT ((80350831968256.)) FOR [FS4]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS5__084908DA]  DEFAULT ((80350831968256.)) FOR [FS5]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS6__093D2D13]  DEFAULT ((80350831968256.)) FOR [FS6]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS7__0A31514C]  DEFAULT ((80350831968256.)) FOR [FS7]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS8__0B257585]  DEFAULT ((80350831968256.)) FOR [FS8]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_general__FS9__0C1999BE]  DEFAULT ((80350831968256.)) FOR [FS9]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS10__0D0DBDF7]  DEFAULT ((80350831968256.)) FOR [FS10]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS11__0E01E230]  DEFAULT ((80350831968256.)) FOR [FS11]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS12__0EF60669]  DEFAULT ((80350831968256.)) FOR [FS12]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS13__0FEA2AA2]  DEFAULT ((80350831968256.)) FOR [FS13]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS14__10DE4EDB]  DEFAULT ((80350831968256.)) FOR [FS14]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS15__11D27314]  DEFAULT ((80350831968256.)) FOR [FS15]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS16__12C6974D]  DEFAULT ((80350831968256.)) FOR [FS16]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS17__13BABB86]  DEFAULT ((80350831968256.)) FOR [FS17]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS18__14AEDFBF]  DEFAULT ((80350831968256.)) FOR [FS18]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS19__15A303F8]  DEFAULT ((80350831968256.)) FOR [FS19]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS20__16972831]  DEFAULT ((80350831968256.)) FOR [FS20]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS21__178B4C6A]  DEFAULT ((80350831968256.)) FOR [FS21]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS22__187F70A3]  DEFAULT ((80350831968256.)) FOR [FS22]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS23__197394DC]  DEFAULT ((80350831968256.)) FOR [FS23]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS24__1A67B915]  DEFAULT ((80350831968256.)) FOR [FS24]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS25__1B5BDD4E]  DEFAULT ((80350831968256.)) FOR [FS25]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS26__1C500187]  DEFAULT ((80350831968256.)) FOR [FS26]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS27__1D4425C0]  DEFAULT ((80350831968256.)) FOR [FS27]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS28__1E3849F9]  DEFAULT ((80350831968256.)) FOR [FS28]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS29__1F2C6E32]  DEFAULT ((80350831968256.)) FOR [FS29]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS30__2020926B]  DEFAULT ((80350831968256.)) FOR [FS30]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS31__2114B6A4]  DEFAULT ((80350831968256.)) FOR [FS31]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS32__2208DADD]  DEFAULT ((80350831968256.)) FOR [FS32]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS33__22FCFF16]  DEFAULT ((80350831968256.)) FOR [FS33]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS34__23F1234F]  DEFAULT ((80350831968256.)) FOR [FS34]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS35__24E54788]  DEFAULT ((80350831968256.)) FOR [FS35]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS36__25D96BC1]  DEFAULT ((80350831968256.)) FOR [FS36]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS37__26CD8FFA]  DEFAULT ((80350831968256.)) FOR [FS37]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS38__27C1B433]  DEFAULT ((80350831968256.)) FOR [FS38]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS39__28B5D86C]  DEFAULT ((80350831968256.)) FOR [FS39]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS40__29A9FCA5]  DEFAULT ((80350831968256.)) FOR [FS40]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS41__2A9E20DE]  DEFAULT ((80350831968256.)) FOR [FS41]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS42__2B924517]  DEFAULT ((80350831968256.)) FOR [FS42]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS43__2C866950]  DEFAULT ((80350831968256.)) FOR [FS43]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS44__2D7A8D89]  DEFAULT ((80350831968256.)) FOR [FS44]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS45__2E6EB1C2]  DEFAULT ((80350831968256.)) FOR [FS45]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS46__2F62D5FB]  DEFAULT ((80350831968256.)) FOR [FS46]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS47__3056FA34]  DEFAULT ((80350831968256.)) FOR [FS47]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS48__314B1E6D]  DEFAULT ((80350831968256.)) FOR [FS48]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS49__323F42A6]  DEFAULT ((80350831968256.)) FOR [FS49]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS50__333366DF]  DEFAULT ((80350831968256.)) FOR [FS50]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS51__34278B18]  DEFAULT ((80350831968256.)) FOR [FS51]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS52__351BAF51]  DEFAULT ((80350831968256.)) FOR [FS52]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS53__360FD38A]  DEFAULT ((80350831968256.)) FOR [FS53]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS54__3703F7C3]  DEFAULT ((80350831968256.)) FOR [FS54]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS55__37F81BFC]  DEFAULT ((80350831968256.)) FOR [FS55]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS56__38EC4035]  DEFAULT ((80350831968256.)) FOR [FS56]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS57__39E0646E]  DEFAULT ((80350831968256.)) FOR [FS57]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS58__3AD488A7]  DEFAULT ((80350831968256.)) FOR [FS58]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS59__3BC8ACE0]  DEFAULT ((80350831968256.)) FOR [FS59]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS60__3CBCD119]  DEFAULT ((80350831968256.)) FOR [FS60]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS61__3DB0F552]  DEFAULT ((80350831968256.)) FOR [FS61]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS62__3EA5198B]  DEFAULT ((80350831968256.)) FOR [FS62]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS63__3F993DC4]  DEFAULT ((80350831968256.)) FOR [FS63]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS64__408D61FD]  DEFAULT ((80350831968256.)) FOR [FS64]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS65__41818636]  DEFAULT ((80350831968256.)) FOR [FS65]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS66__4275AA6F]  DEFAULT ((80350831968256.)) FOR [FS66]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS67__4369CEA8]  DEFAULT ((80350831968256.)) FOR [FS67]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS68__445DF2E1]  DEFAULT ((80350831968256.)) FOR [FS68]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS69__4552171A]  DEFAULT ((80350831968256.)) FOR [FS69]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS70__46463B53]  DEFAULT ((80350831968256.)) FOR [FS70]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS71__473A5F8C]  DEFAULT ((80350831968256.)) FOR [FS71]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS72__482E83C5]  DEFAULT ((80350831968256.)) FOR [FS72]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS73__4922A7FE]  DEFAULT ((80350831968256.)) FOR [FS73]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS74__4A16CC37]  DEFAULT ((80350831968256.)) FOR [FS74]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS75__4B0AF070]  DEFAULT ((80350831968256.)) FOR [FS75]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS76__4BFF14A9]  DEFAULT ((80350831968256.)) FOR [FS76]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS77__4CF338E2]  DEFAULT ((80350831968256.)) FOR [FS77]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS78__4DE75D1B]  DEFAULT ((80350831968256.)) FOR [FS78]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS79__4EDB8154]  DEFAULT ((80350831968256.)) FOR [FS79]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS80__4FCFA58D]  DEFAULT ((80350831968256.)) FOR [FS80]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS81__50C3C9C6]  DEFAULT ((80350831968256.)) FOR [FS81]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS82__51B7EDFF]  DEFAULT ((80350831968256.)) FOR [FS82]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS83__52AC1238]  DEFAULT ((80350831968256.)) FOR [FS83]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS84__53A03671]  DEFAULT ((80350831968256.)) FOR [FS84]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS85__54945AAA]  DEFAULT ((80350831968256.)) FOR [FS85]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS86__55887EE3]  DEFAULT ((80350831968256.)) FOR [FS86]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS87__567CA31C]  DEFAULT ((80350831968256.)) FOR [FS87]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS88__5770C755]  DEFAULT ((0)) FOR [FS88]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS89__5864EB8E]  DEFAULT ((0)) FOR [FS89]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS90__59590FC7]  DEFAULT ((0)) FOR [FS90]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS91__5A4D3400]  DEFAULT ((0)) FOR [FS91]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS92__5B415839]  DEFAULT ((0)) FOR [FS92]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS93__5C357C72]  DEFAULT ((0)) FOR [FS93]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS94__5D29A0AB]  DEFAULT ((0)) FOR [FS94]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS95__5E1DC4E4]  DEFAULT ((0)) FOR [FS95]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS96__5F11E91D]  DEFAULT ((0)) FOR [FS96]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS97__60060D56]  DEFAULT ((0)) FOR [FS97]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS98__60FA318F]  DEFAULT ((0)) FOR [FS98]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_genera__FS99__61EE55C8]  DEFAULT ((0)) FOR [FS99]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF__tbl_gener__MaxLe__75D7B4E9]  DEFAULT ((85)) FOR [MaxLevel]
    GO
    
    ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_GuildStatus]  DEFAULT ((0)) FOR [GuildStatus]
    GO
    ALTER TABLE [dbo].[tbl_general] ADD CONSTRAINT [DF__tbl_gener__MaxLe__75D7B4E9] DEFAULT ((85)) FOR [MaxLevel]
    GO

    this corret ? im cange the lasast potion be 85
    Last edited by powerup; 26-07-13 at 10:20 PM.

  12. #12
    Novice luzarus001 is offline
    MemberRank
    Sep 2017 Join Date
    3Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by novanakal View Post
    for a simple way
    open Quest.dat
    look at the maxlevel for quest 50..

    change 56 to 0
    no need trigger for that
    I Have same problem. Can you tell me where Quest.dat Location and how to change from maxlevel for quest 50 to 0?

    Many Thanks

  13. #13
    Apprentice kyzryu is offline
    MemberRank
    Feb 2017 Join Date
    5Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    why if i'm create new character still stuck in lvl 50 , how to auto disable quest lvl 50 and 56 ?

    - - - Updated - - -

    Quote Originally Posted by novanakal View Post
    for a simple way
    open Quest.dat
    look at the maxlevel for quest 50..

    change 56 to 0
    no need trigger for that
    i'm already change it but still not work , can u give me more qlue ? , and i'm already change Lock Level By Quest from ZoneServer

  14. #14
    Member Dev Crime is offline
    MemberRank
    Jun 2015 Join Date
    99Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by kyzryu View Post
    why if i'm create new character still stuck in lvl 50 , how to auto disable quest lvl 50 and 56 ?

    - - - Updated - - -



    i'm already change it but still not work , can u give me more qlue ? , and i'm already change Lock Level By Quest from ZoneServer
    There is an easy way to remove the quests tho, If you are planning to remove both 50 and 56 quests,

    Open Questlevellimit.dat on your Script folder using Hex Editor and make the first byte to 00

    Example first - 02 to 00

    Save it.

    and try run, so that no more quests

    Test if that works out for you.

  15. #15
    Apprentice kyzryu is offline
    MemberRank
    Feb 2017 Join Date
    5Posts

    Re: Triger Auto Open Limit Max Level For Only Open Quest 56 (Skip Quest 50)

    Quote Originally Posted by Dev Crime View Post
    There is an easy way to remove the quests tho, If you are planning to remove both 50 and 56 quests,

    Open Questlevellimit.dat on your Script folder using Hex Editor and make the first byte to 00

    Example first - 02 to 00

    Save it.

    and try run, so that no more quests

    Test if that works out for you.
    nah its work ,, tanks you sir



Page 1 of 2 12 LastLast

Advertisement