Jump to content

Useful Queries For RF Online


Recommended 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 :

/**********************************************************
Copyright © 2012 - Heaven Network
Website  : https://www.heaven-gaming.org
Facebook : https://www.facebook.com/princerayz
Category : SQL Modules - Move Character To Another Account

Table Inject : [RF_WORLD].[tbl_base]

Object:  RF_USER, RF_WORLD
************************************************************/

DECLARE @ID varchar(16)
DECLARE @SAccount int
DECLARE @Nick varchar(20)
DECLARE @slot int

set @Nick = 'PrinceRay' -- Nick Which you want to move
set @ID = '!prince' -- Destination ID


select @SAccount = serial from [RF_USER].dbo.tbl_UserAccount where id = CONVERT(binary,@ID)
IF (@SAccount IS NULL) -- If ID Not Found In Normal Account, Check Is GM Or Not
    select @SAccount = serial from [RF_User].dbo.tbl_StaffAccount where ID = CONVERT(binary,@ID)
IF 
((SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Account = @ID and DCK=0) = 3 OR @SAccount IS NULL) -- If Slot Full / ID Not Found
PRINT 'Cant Move Character Because Destination AccountID Slot is full / ID Not Found !'
ELSE
    BEGIN
        IF(SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Slot = 0 AND Account = @ID AND DCK=0) = 0
            BEGIN
            UPDATE [RF_WORLD].dbo.tbl_base set Account = @ID, slot='0' ,AccountSerial=@SAccount where Name= @Nick
            print 'Character : "' + @Nick + '", Moved To Account : "' + @ID + '" Slot : 0'
            END
        ELSE
            IF(SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Slot = 1 AND Account = @ID AND DCK=0) = 0            
            BEGIN
            UPDATE [RF_WORLD].dbo.tbl_base set Account = @ID, slot='1' ,AccountSerial=@SAccount  where Name= @Nick
            print 'Character : "' + @Nick + '", Moved To Account : "' + @ID + '" Slot : 1'
            END
        ELSE            
            IF(SELECT COUNT(*) FROM [RF_WORLD].dbo.tbl_base WHERE Slot = 2 AND Account = @ID AND DCK=0) = 0
            BEGIN
            UPDATE [RF_WORLD].dbo.tbl_base set Account = @ID, slot='2' ,AccountSerial=@SAccount  where Name= @Nick
            print 'Character : "' + @Nick + '", Moved To Account : "' + @ID + '" Slot : 2'
            END        
    --SELECT Serial,Name,Account,Slot,Race,AccountSerial FROM [RF_WORLD].dbo.tbl_base where Account = @ID and DCK=0
END


SQL Queries To Changes Council :

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - Changes Council

Database Inject : [RF_World]
Object:  Table [dbo].[tbl_patriarch_candidate]   
Notice : If Player Are Not In Ranking System, He Can't Promoted
********************************************************************/
USE RF_World
DECLARE @eserial int
DECLARE @race    tinyint
DECLARE @lv    tinyint
DECLARE @rank    int
DECLARE @pvppnt    float
DECLARE @aserial    int
DECLARE @aname    varchar(17)
DECLARE @gserial    int
DECLARE @gname    varchar(17)
DECLARE @class    tinyint
DECLARE @status    tinyint

/*    [+]Class Information:
        0 "Archon";
        1 "Left - Consul";
        2 "Left - Strike Team";
        3 "Left - Deffense Team";
        4 "Left - Support Team";
        5 "Right - Consul";
        7 "Right - Deffense Team";
        6 "Right - Strike Team";
        8 "Right - Support Team";

    [+]eSerial Information
        It's Generated Automatically, It's Take Latest Council Period

    [+]Status Information
        1 - For Assign To Next Council Election
        2 - For Assign To Left Council
        3 - For Assign To Right Council
*/

SET @aname    = 'PrinceRay' -- Player Nickname which u want grant to Council
SET @class    = 0 -- See Class Information
SET @eserial = (select top 1 eSerial from [RF_World].dbo.tbl_patriarch_candidate order by eSerial desc)
SET @race    = (select race from tbl_PvpRankToday where name=@aname)
SET @lv    = (select lv from tbl_PvpRankToday where name=@aname)
SET @rank    =(select rank from tbl_PvpRankToday where name=@aname)
SET @pvppnt    =(select PvpPoint from tbl_PvpRankToday where name=@aname)
SET @aserial    =(select serial from tbl_PvpRankToday where name=@aname)
SET @gserial    =(select GuildSerial from tbl_PvpRankToday where name=@aname)
SET @gname    =(select GuildName from tbl_PvpRankToday where name=@aname)
SET @status    = 3  -- See Status Information


Insert into [dbo].[tbl_patriarch_candidate] (eSerial, Race, Lv, Rank, PvpPoint, ASerial, AName, GSerial, GName, ClassType, State, dtUpScore)
Values (@eserial, @race, @lv, @rank, @pvppnt, @aserial, @aname, @gserial, @gname, @class, @status, getdate() )

print 'Current Archon Period : ' + CAST(@eserial as varchar)
print 'Nickname : ' + @aname 
print 'Race : ' + CAST(@race as varchar)
print 'Level : ' + CAST(@lv as varchar)
print 'Ranking : ' + CAST(@rank as varchar)
print 'PvP Point : ' + CAST(@pvppnt as varchar)
print 'Account : ' + CAST(@aserial as varchar)
print 'Guild Name : ' + @gname 
print 'Guild Serial :' + CAST(@gserial as varchar)
print 'Promoted To : ' + CAST(@class as varchar)
print 'Status : ' + CAST(@status as varchar)


SQL Queries To View Staff / GM Account :

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - View Staff Account

Database Inject : [RF_User]
Object:  Table [dbo].[tbl_StaffAccount]   

********************************************************************/

USE RF_User
select convert(varchar, ID), Realname, convert(varchar, PW)
From tbl_StaffAccount

 

SQL Queries To Changes GM Account Password : 

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - Changes GM Password

Database Inject : [RF_User]
Object:  Table [dbo].[tbl_StaffAccount]   

********************************************************************/

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)

 

SQL Queries To Changes Race :

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - Changes Race

Database Inject : [RF_World]
Object:  Table [dbo].[tbl_base]   

********************************************************************/

/*    [+]Code Race Information:
        00 = Bells Female
        01 = Bells Male
        02 = Cora Female
        03 = Cora Male
        04 = Accrectian
*/

use RF_World
declare @nick varchar(25);
declare @race varchar(2);
set @nick ='PrinceRay'; -- Put Nick Here
set @race ='03'; -- See Table Race
update tbl_base set race=(@race) where name=(@nick)


SQL Queries To Changes Job :

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - Changes Job

Database Inject : [RF_World]
Object:  Table [dbo].[tbl_base]   
********************************************************************/

/*    [+]Code Job Information:
        CW= CORA WARIOR 
        B0= DEFAULT JOB
        A,B,C = ACC, BELLS, CORA
        Warrior [A/B/C]WB0
        FORCE  = [B/C]FB0 
        RANGER = [A/B/C/]RB0 FOR LAUNCHER USE THIS TOO
        SPECIALIST = [A/B/C]SB0
        
    [+] Note : Please Use Reset Job Potion Before Changes Job
*/

use RF_World
declare @nick varchar(25);
declare @class varchar(4);
set @nick ='PrinceRay'; -- Nickname
set @class ='AWB0'; -- See Code Job
update tbl_base set class=(@class) where name=(@nick)

 

SQL Queries To Ban User :

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - Ban User

Database Inject : [RF_User]
Object:  Table [dbo].[tbl_UserBan]   

********************************************************************/

USE [RF_User]
DECLARE 
@Nick VARCHAR(13),
@Aserial int,
@nSerial int,
@nPeriod int,
@nKind int,
@szReason varchar(32),
@GMReason varchar(32),
@GMWriter varchar(32),
@ReasonType tinyint


/** Nick Which you want to ban **/
SET @Nick = 'PrinceRay'

set @Aserial = (Select AccountSerial from RF_World.dbo.tbl_base where Name = @Nick)
SELECT @nSerial = @Aserial

/** 24 = 1 day, 999 = banned permanen ***/
SET @nPeriod = '999'

/**Reason Ban**/
SET @szReason = 'fly and blink'

/**Banned By **/
SET @GMWriter = 'PrinceRay'

/** JANGAN DI GANGGU GUGAT **/
SET @GMReason = @szReason
SET @ReasonType = '1'
SET @nKind = '0'

INSERT INTO [RF_User].[dbo].[tbl_UserBan]
(
[nAccountSerial],[dtStartDate],[nPeriod],[nKind],[szReason],[GMWriter],[reasontype])
VALUES(@nSerial,CONVERT(datetime,GETDATE()),@nPeriod,@nKind,@szReason,@GMWriter,@ReasonType)    

 

Queries For WIPE  Database :

USE [RF_USER]
GO
delete from tbl_rfaccount;
delete from tbl_UserBan;
delete from tbl_userAccount;
delete from tbl_StaffAccount;
delete from tbl_RFAdmin;
delete from tbl_RFTestAccount;
delete from tbl_StaffAccount;
delete from tbl_UserBan;

USE [RF_WORLD]
GO
delete from tbl_general;
delete from tbl_base;
delete from tbl_AccountTrunk;
delete from tbl_AccountTrunk_Extend;
delete from tbl_AccountTrunkCharge;
delete from tbl_aminepersonal_inven;
delete from tbl_animuslog; 
delete from tbl_battletournament;
delete from tbl_Buddy;
delete from tbl_Guild;
delete from tbl_GuildBattleRank;
delete from tbl_history_electraceboss_0;
delete from tbl_history_electraceboss_1;
delete from tbl_history_electraceboss_2;
delete from tbl_history_electraceboss_candidacy_0;
delete from tbl_history_electraceboss_candidacy_1;
delete from tbl_history_electraceboss_candidacy_2;
delete from tbl_history_electraceboss_winner_0;
delete from tbl_history_electraceboss_winner_1;
delete from tbl_history_electraceboss_winner_2;
delete from tbl_honor_guild;
delete from tbl_inven;
delete from tbl_Macro;
delete from tbl_patriarch_candidate;
delete from tbl_patriarch_comm;
delete from tbl_patriarch_elect;
delete from tbl_Punishment;
delete from tbl_pvporderview;
delete from tbl_pvppointlimitinfo;
delete from tbl_PvpRankToday;

Queries For Prevent Delete Character By Specific Level

/****************************************************************
Copyright © 2018 - Heaven Network
Website  : https://www.heaven-gaming.org
Facebook : https://www.facebook.com/princerayz
Category : SQL Modules - Anti Delete Character

Table Inject :	[RF_WORLD].[tbl_base]

Object	     :	- StoredProcedure [dbo].[pDelete_Base]
		- StoredProcedure [dbo].[pUpdate_DeleteName_Step1]
		- StoredProcedure [dbo].[pUpdate_DeleteName_Step2]

Description  :	This query will prevent Character Deletion 
		for specific Level Rule, @LevelReq>0 Mean if player
		create character for first time, and not login yet,
		player can delete the character, but after he login,
		he can't delete it any more.
			
****************************************************************/

USE [RF_World]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[pDelete_Base]
@serial int
AS
BEGIN
	SET XACT_ABORT ON
	SET NOCOUNT ON
	-- Atur Disini Level nya, < artinya lebih kecil > artinya lebih besar,
	-- Contoh : <= 40, lebih kecil 40 dan level 40
	-- >= 40, diatas level 40 dan level 40

	BEGIN TRY
			DECLARE @LevelReq INT;
			SELECT @LevelReq = Lv FROM [dbo].[tbl_base] Where Serial = @serial
			BEGIN TRANSACTION
				IF (@LevelReq >0 AND @LevelReq < 40 )
					RETURN 0
				ELSE
					UPDATE [dbo].[tbl_base] SET DCK = 1,  Arrange = 1, DeleteTime = getdate()  WHERE Serial = @serial
			COMMIT
	END TRY
	BEGIN CATCH	
		IF @@TRANCOUNT>0
			ROLLBACK TRANSACTION
	END CATCH
END
GO
----------------- 2nd STEP -----------------
ALTER PROCEDURE [dbo].[pUpdate_DeleteName_Step1]
@serial int
AS
BEGIN
	SET XACT_ABORT ON
	SET NOCOUNT ON
	-- Atur Disini Level nya, < artinya lebih kecil > artinya lebih besar,
	-- Contoh : <= 40, lebih kecil 40 dan level 40
	-- >= 40, diatas level 40 dan level 40

	BEGIN TRY
			DECLARE @LevelReq INT;
			SELECT @LevelReq = Lv FROM [dbo].[tbl_base] Where Serial = @serial
			BEGIN TRANSACTION
				IF (@LevelReq >0 AND @LevelReq < 40 )
						RETURN 0
				ELSE
					UPDATE [dbo].[tbl_base] SET deletename=name  WHERE serial = @serial
			COMMIT
	END TRY
	BEGIN CATCH
		IF @@TRANCOUNT>0
			ROLLBACK TRANSACTION
	END CATCH
END
GO
----------------- FINAL STEP -----------------
ALTER PROCEDURE [dbo].[pUpdate_DeleteName_Step2]
@serial int
AS
BEGIN
	SET XACT_ABORT ON
	SET NOCOUNT ON
	-- Atur Disini Level nya, < artinya lebih kecil > artinya lebih besar,
	-- Contoh : <= 40, lebih kecil 40 dan level 40
	-- >= 40, diatas level 40 dan level 40

	BEGIN TRY
			DECLARE @LevelReq INT;
			SELECT @LevelReq = Lv FROM [dbo].[tbl_base] Where Serial = @serial
			BEGIN TRANSACTION
				IF (@LevelReq >0 AND @LevelReq < 40 )
					RETURN 0
				ELSE
					UPDATE [dbo].[tbl_base] SET name='*'+cast(serial as varchar)  WHERE serial = @serial
			COMMIT
	END TRY
	BEGIN CATCH
		IF @@TRANCOUNT>0
			ROLLBACK TRANSACTION
	END CATCH
END
GO

Deleting character have 3 step in zone system, so i make 3 prevention, normally if step 1 executed, the 2 more step not proceed, but for bug prevention, i will leave it for 3.
This query prevent character level 1 ~ 39 to not be deleted (Level 0 mean player never login the character, only create. still can delete, but if player login, he can't delete it anymore until lvl 40)

 

Note : USE AT YOUR OWN RISK

 

If You have question about the queries, feel free to ask (But try the query and explore first before you ask >:().

Tell me if you found Any Bugs.


Feel free to share your own sql queries ;)

Edited by PrinceRay

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
  • Ron pinned this topic
  • 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

Insert Premium and Cash

/****** Insert Premium and Cash   ******  by : Hanry Roslaw Saputra ******/

/****** Script Owner : Hanry Roslaw Saputra ******/

/****** Created by : Hanry Roslaw Saputra ******/

DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @birth smalldatetime
DECLARE @email varchar(255)
DECLARE @status int
DECLARE @cash int
DECLARE @lama int

/****** Your Name ******/
SET @name = 'roslaw'

/****** Your Password ******/
SET @pw = '123456789'

/****** Birthday ******/
SET @birth = '07-22-1988'

/****** Your Email ******/
SET @email = '[email protected]'

/****** Set 2 for turn on Premium or Set 1 for turn off Premium  ******/
SET @status = '2'

/****** How long players get premium service (in days) exemple : 1 for 1 days, 2 for 2 days, 3 for 3days. ******/
SET @lama = '5'

/****** Cashpoint amount ******/
SET @cash = '100000'

/************************************************************************************************************************************************/

INSERT INTO [RF_USER].[dbo].[tbl_rfaccount] 
    (
        [id],
        [password],
        [birthdate],
        
    )
    VALUES
    (
        CONVERT(BINARY(13),@name),
        CONVERT(BINARY(13),@pw),
        @birth,
        @email
    )

INSERT INTO [BILLING].[dbo].[tbl_UserStatus] 
   
        [id],
        [Status],
        [DTStartPrem],
        [DTEndPrem],
        [Cash]
    )
    VALUES
    (
        @name,
        @status,
        CONVERT(datetime,GETDATE()),
        CONVERT(datetime,GETDATE()[email protected]),
        @cash
    )

/***********************************************************************************************************************************************/

Link to post
Share on other sites

Update Guild Honour Manual 

USE [RF_WORLD_NOVUS]
GO

DECLARE    @return_value int
declare @serial int
select @serial = (select serial from tbl_Guild where id = '™-TIMNAS-CORA-™')

EXEC    @return_value = [dbo].[pInsert_HonorGuild]
        @race = 1,
        @gserial = @serial,
        @tax = 10,
        @isnext = 1

SELECT    'Return Value' = @return_value

GO
Update Guild Honour Manual 

I did it for the 1st time so don't blame me that much Ron,, I'm still learning.. hehe
Link to post
Share on other sites

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

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

Link to post
Share on other sites
1 hour ago, PelusoBHxClan said:

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

 

  Reveal hidden contents

 

USE [RF_WORLD]
GO

/****** Object:  Table [dbo].[tbl_general]    Script Date: 01/21/2012 12:35:29 ******/
-- =============================================
-- Author:            n[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

 

 

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

Edited by PrinceRay

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
  • Administrator
3 minutes ago, 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

Maybe I should make a RF-Dev git repository? 

Link to post
Share on other sites
  • Ron unpinned this topic

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...