Jump to content

Useful Queries For RF Online


Recommended Posts

  • Replies 50
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

So, has been long time for me to keep this SQL Queries for myself  i hope this useful for all of you test SQL Queries To Move Character to Another Account : /***********************

DB Upgrade from 2.1.6 to 2.2.3 Created By: Lenin (From Equilibrium Gaming  I suppose) AccountServer 3 Steps GameServer  9 steps   AccountServer.rar GameServer.rar

Update Guild Honour Manual  I did it for the 1st time so don't blame me that much Ron,, I'm still learning.. hehe

Posted Images

Don't forget to give disclaimer : USE AT YOUR OWN RISK

Some little mistake in query will give permanent error in database. especially for newbie.
Example :

  • Changing the Race requires Class changes too. It cannot be separated.
  • if you want to change or add new Archon / Council without removed old data. just increase eSerial value for new data.

Capture.thumb.PNG.d711dff5a5c7097cf7b7ab775a8ceebb.PNG

And some information in your --comment is wrong :D

Edited by Roslaw
Link to post
Share on other sites
1 hour ago, Roslaw said:

Don't forget to give disclaimer : USE AT YOUR OWN RISK

Some little mistake in query will give permanent error in database. especially for newbie.
Example :

  • Changing the Race requires Class changes too. It cannot be separated.
  • if you want to change or add new Archon / Council without removed old data. just increase eSerial value for new data.

Capture.thumb.PNG.d711dff5a5c7097cf7b7ab775a8ceebb.PNG

And some information in your --comment is wrong :D

which comment ?

feel free to ask anything, but everything has a price

W W W . H E A V E N - G A M I N G . O R G

everything has a price to be paid, but not always in terms of money

 

Link to post
Share on other sites
Just now, Roslaw said:
    [+]Status Information
        1 - For Assign Him To Next Council Election
        2 - To Revoke His Status From Current Council
        3 - To Make Him Current Council

aah, i will fix it

feel free to ask anything, but everything has a price

W W W . H E A V E N - G A M I N G . O R G

everything has a price to be paid, but not always in terms of money

 

Link to post
Share on other sites
  • 1 month later...
On 9/23/2018 at 8:01 PM, kaiz said:

in Prevent Char Deletion. Is it possible in opposite way like lv1-40 you cant delete ?

you can play in logical check, currently level 1~40 can't delete. ;)

feel free to ask anything, but everything has a price

W W W . H E A V E N - G A M I N G . O R G

everything has a price to be paid, but not always in terms of money

 

Link to post
Share on other sites
  • 4 weeks later...
On ‎11‎/‎08‎/‎2017 at 10:43 AM, PelusoBHxClan said:

tbl_general(PT-GM,MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill)

 

  Hide contents

 

USE [RF_WORLD]
GO

/****** Object:  Table [dbo].[tbl_general]    Script Date: 01/21/2012 12:35:29 ******/
-- =============================================
-- Author:            [email protected]
-- 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 ((66)) FOR [MaxLevel]
GO

ALTER TABLE [dbo].[tbl_general] ADD  CONSTRAINT [DF_tbl_general_GuildStatus]  DEFAULT ((0)) FOR [GuildStatus]
GO

 

 

I use this and all the character got error when Login in to the game how to revert it or fix?

KickAZZ

Link to post
Share on other sites
  • 1 month later...
On 8/9/2017 at 7:19 AM, PrinceRay said:
use rf_user
declare @ID varchar(25) ;
declare @NewPass varchar(25);
declare @NewName varchar(25);
set @ID ='!prince'; -- Current GM ID
set @Newpass ='testSQLModules'; -- New Password
update tbl_StaffAccount set PW=convert(binary,@NewPass) where id=convert(binary,@ID)
where id=convert(binary,@ID)

select convert(varchar, ID), Realname, convert(varchar, PW)
From tbl_StaffAccount where id= convert (binary,@ID)

 

 

I use this syntax, he can't change the GM password.

 

 

 

 

 

On 8/9/2017 at 7:19 AM, PrinceRay said:

Q

 

Link to post
Share on other sites
  • 4 months later...
On 8/11/2017 at 8:29 AM, PrinceRay said:

nice share, but can upload archive for query like this ?

sorry before, but i try to make this thread not too long with query like this,

i know u want sharing too, but please if u think ur query is too long like this :(, jst upload as archive

and if query already public like this, upload all in to 1 archive :(

Feature : 

- tbl_general(PT-GM,MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill).sql
- Find Bank Pass.sql
- Disable Mail.sql
- Disable Auction.sql
- Create GM ID.sql
- Copy Character.sql
- Bank 7slot.sql

 

SQL Query Pack.7z 12.41 kB · 112 downloads

uhmm.. how about 55 cap can i still use the tbl_general(PT-GM,MaxLvl 66, Bag 5, Loss Quest, Disable Master Skill).sql?

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...