Jump to content

Syntax

Members
  • Content count

    23
  • Joined

  • Last visited

  • Days Won

    6

Syntax last won the day on November 27 2017

Syntax had the most liked content!

Community Reputation

28 Neutral

1 Follower

About Syntax

  • Rank
    Cabin Boy

Recent Profile Visitors

408 profile views
  1. Syntax

    Computer Science vs Software Engineering

    Engineering always and will be the top choice. computer science is related/nearby to hardware engangement, it's upgradable while the engineering required a brain's storm in it, this will lead the developer to release a new hardware system.
  2. Syntax

    Free VM/VPS

    WAW!! What's the motive of giving away free VPS ?
  3. Syntax

    Contabo vps

    Hi @Adrian you may need to add $20-25 into your budget, its for (Windows OS).
  4. Syntax

    Attaching error

    Hello @Graf It's looks like you're using newest database, You can't attach database which been used by SQL2K8 or next version for SQL2K. In this case you have to run new database query instead. Here I attach the query for AccountServer and GameDB: AccountServer USE [AccountServer] GO /****** Object: Table [dbo].[user_log] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[user_log]( [log_id] [int] IDENTITY(1,1) NOT NULL, [user_id] [int] NOT NULL, [user_name] [varchar](50) NOT NULL, [login_time] [datetime] NULL, [logout_time] [datetime] NULL, [login_ip] [varchar](20) NULL, CONSTRAINT [PK_user_log] PRIMARY KEY CLUSTERED ( [log_id] 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 /****** Object: Table [dbo].[TradeRecord] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TradeRecord]( [record_id] [bigint] NOT NULL, [record_message] [int] NOT NULL, [record_section] [int] NOT NULL, [record_info] [nvarchar](4000) NOT NULL, [record_time] [datetime] NOT NULL, [ret_info] [nvarchar](4000) NOT NULL, [ret_time] [datetime] NOT NULL, [state] [int] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[safety] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[safety]( [aid] [bigint] IDENTITY(1,1) NOT NULL, [allowIP] [varchar](32) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[LogRandomAccount] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[LogRandomAccount]( [accountName] [varchar](50) NOT NULL, [addDate] [datetime] NULL, [expireDate] [datetime] NULL, [ip] [varchar](15) NULL, [plainPassword] [varchar](32) NULL, CONSTRAINT [PK_LogRandomAccount] PRIMARY KEY CLUSTERED ( [accountName] 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 /****** Object: Table [dbo].[login_count] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[login_count]( [id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [total] [int] NOT NULL, [server] [int] NOT NULL, [log_date] [datetime] NULL, CONSTRAINT [PK_login_count] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[GameDBServerList] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[GameDBServerList]( [server_section] [int] NOT NULL, [server_ip] [varchar](30) NOT NULL, [server_uid] [varchar](20) NOT NULL, [server_pwd] [varchar](50) NOT NULL, [server_db] [varchar](20) NOT NULL, CONSTRAINT [PK_GameDBServerList] PRIMARY KEY CLUSTERED ( [server_section] 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 /****** Object: Table [dbo].[dtproperties] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[dtproperties]( [id] [int] IDENTITY(1,1) NOT NULL, [objectid] [int] NULL, [property] [varchar](64) NOT NULL, [value] [varchar](255) NULL, [uvalue] [nvarchar](255) NULL, [lvalue] [image] NULL, [version] [int] NOT NULL, CONSTRAINT [pk_dtproperties] PRIMARY KEY CLUSTERED ( [id] ASC, [property] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[account_pending] Script Date: 11/27/2017 05:23:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[account_pending]( [acc_id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NOT NULL, [password] [varchar](50) NOT NULL, [squestion] [varchar](100) NOT NULL, [answer] [varchar](100) NOT NULL, [email] [varchar](100) NOT NULL, [gender] [int] NOT NULL, [credit] [int] NULL, [truename] [varchar](100) NOT NULL, [birthday] [datetime] NOT NULL, [contact] [varchar](50) NOT NULL, [country] [varchar](50) NOT NULL, [ipaddr] [varchar](50) NOT NULL, [ip2country] [varchar](50) NOT NULL, [actcode] [varchar](50) NULL, [invtcode] [varchar](50) NULL, [create_time] [varchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[account_login] Script Date: 11/27/2017 05:23:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[account_login]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [password] [varchar](50) NULL, [originalPassword] [varchar](50) NULL, [sid] [int] NOT NULL, [login_status] [int] NULL, [enable_login_tick] [bigint] NULL, [login_group] [varchar](50) NULL, [last_login_time] [datetime] NULL, [last_logout_time] [datetime] NULL, [last_login_ip] [varchar](50) NULL, [enable_login_time] [datetime] NULL, [total_live_time] [bigint] NOT NULL, [last_login_mac] [varchar](50) NULL, [ban] [bit] NULL, [email] [varchar](50) NULL, [squestion] [varchar](100) NULL, [answer] [varchar](100) NULL, [register_ip] [varchar](50) NULL, [refered_by] [int] NULL, [last_ip_detected] [varchar](50) NULL, [refer_points] [int] NULL, [vip] [varchar](50) NULL, CONSTRAINT [PK_account_login] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_account_login] UNIQUE NONCLUSTERED ( [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_account_login_name] UNIQUE NONCLUSTERED ( [name] 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 /****** Object: Table [dbo].[account_invt] Script Date: 11/27/2017 05:23:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[account_invt]( [inv_id] [int] IDENTITY(1,1) NOT NULL, [invt_code] [varchar](50) NOT NULL, [assignto] [varchar](50) NULL, [used] [int] NOT NULL, CONSTRAINT [PK_account_invt] PRIMARY KEY CLUSTERED ( [inv_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [invt_code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [invt_code] 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 /****** Object: Table [dbo].[account_charge] Script Date: 11/27/2017 05:23:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[account_charge]( [id] [int] NOT NULL, [charge_flag] [int] NULL, [charge_begin_tick] [int] NULL, [charge_end_tick] [int] NULL, [saves] [int] NULL, CONSTRAINT [PK_account_charge] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Default [DF_account_invt_used] Script Date: 11/27/2017 05:23:12 ******/ ALTER TABLE [dbo].[account_invt] ADD CONSTRAINT [DF_account_invt_used] DEFAULT (0) FOR [used] GO /****** Object: Default [DF_account_login_sid] Script Date: 11/27/2017 05:23:12 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_sid] DEFAULT (0) FOR [sid] GO /****** Object: Default [DF_account_login_login_status] Script Date: 11/27/2017 05:23:12 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_login_status] DEFAULT (0) FOR [login_status] GO /****** Object: Default [DF_account_login_enable_login_tick] Script Date: 11/27/2017 05:23:12 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_enable_login_tick] DEFAULT (0) FOR [enable_login_tick] GO /****** Object: Default [DF_account_login_last_login_time] Script Date: 11/27/2017 05:23:12 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_last_login_time] DEFAULT (getdate()) FOR [last_login_time] GO /****** Object: Default [DF_account_login_last_logout_time] Script Date: 11/27/2017 05:23:12 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_last_logout_time] DEFAULT (getdate()) FOR [last_logout_time] GO /****** Object: Default [DF_account_login_enable_login_time] Script Date: 11/27/2017 05:23:13 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_enable_login_time] DEFAULT ('2001-1-1 1:1:1') FOR [enable_login_time] GO /****** Object: Default [DF_account_login_total_live_time] Script Date: 11/27/2017 05:23:13 ******/ ALTER TABLE [dbo].[account_login] ADD CONSTRAINT [DF_account_login_total_live_time] DEFAULT (0) FOR [total_live_time] GO /****** Object: Default [DF_account_pending_gender] Script Date: 11/27/2017 05:23:13 ******/ ALTER TABLE [dbo].[account_pending] ADD CONSTRAINT [DF_account_pending_gender] DEFAULT (0) FOR [gender] GO /****** Object: Default [DF__dtpropert__versi__060DEAE8] Script Date: 11/27/2017 05:23:13 ******/ ALTER TABLE [dbo].[dtproperties] ADD CONSTRAINT [DF__dtpropert__versi__060DEAE8] DEFAULT (0) FOR [version] GO /****** Object: Default [DF_login_count_log_date] Script Date: 11/27/2017 05:23:13 ******/ ALTER TABLE [dbo].[login_count] ADD CONSTRAINT [DF_login_count_log_date] DEFAULT (getdate()) FOR [log_date] GO GameDB USE [GameDB] GO /****** Object: Table [dbo].[WinTicket] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WinTicket]( [issue] [smallint] NOT NULL, [itemno] [nvarchar](10) NOT NULL, [grade] [smallint] NOT NULL, [createdate] [datetime] NOT NULL, [num] [smallint] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[weekreport] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[weekreport]( [act_name] [varchar](50) NULL, [cha_name] [varchar](50) NULL, [degree] [int] NULL, [ip] [varchar](20) NULL, [createdate] [datetime] NULL, [logouttime] [datetime] NULL, [playtime] [int] NULL, [Guild_Name] [varchar](16) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Trade_Log] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Trade_Log]( [ID] [int] IDENTITY(1,1) NOT NULL, [ExecuteTime] [datetime] NOT NULL, [GameServer] [nvarchar](50) NOT NULL, [Action] [nvarchar](50) NOT NULL, [From] [nvarchar](50) NOT NULL, [To] [nvarchar](50) NULL, [Memo] [nvarchar](1000) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Ticket] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Ticket]( [id] [int] IDENTITY(1,1) NOT NULL, [cha_id] [int] NOT NULL, [issue] [int] NOT NULL, [itemno] [nvarchar](50) NOT NULL, [real] [bit] NOT NULL, [buydate] [datetime] NOT NULL, CONSTRAINT [PK_Ticket] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[StatMap] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[StatMap]( [statDate] [datetime] NOT NULL, [map] [varchar](50) NOT NULL, [playCount] [bigint] NULL, CONSTRAINT [PK_StatMap] PRIMARY KEY CLUSTERED ( [statDate] ASC, [map] 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 /****** Object: Table [dbo].[StatLogin] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[StatLogin]( [statDate] [datetime] NOT NULL, [loginCount] [bigint] NULL, CONSTRAINT [PK_StatLogin] PRIMARY KEY CLUSTERED ( [statDate] 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 /****** Object: Table [dbo].[StatJob] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[StatJob]( [statDate] [datetime] NOT NULL, [job] [varchar](50) NOT NULL, [characterCount] [bigint] NULL, CONSTRAINT [PK_StatJob] PRIMARY KEY CLUSTERED ( [statDate] ASC, [job] 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 /****** Object: Table [dbo].[StatGender] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[StatGender]( [statDate] [datetime] NOT NULL, [gender] [varchar](8) NOT NULL, [genderCount] [bigint] NULL, CONSTRAINT [PK_StatGender] PRIMARY KEY CLUSTERED ( [statDate] ASC, [gender] 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 /****** Object: Table [dbo].[StatDegree] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[StatDegree]( [statDate] [datetime] NOT NULL, [degree] [smallint] NOT NULL, [characterCount] [bigint] NULL, CONSTRAINT [PK_StatDegree] PRIMARY KEY CLUSTERED ( [statDate] ASC, [degree] 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 /****** Object: Table [dbo].[stat_log_hh] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[stat_log_hh]( [track_date] [datetime] NOT NULL, [login_num] [int] NOT NULL, [play_num] [int] NOT NULL, [wgplay_num] [int] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[stat_log] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[stat_log]( [track_date] [datetime] NOT NULL, [login_num] [int] NOT NULL, [play_num] [int] NOT NULL, [wgplay_num] [int] NULL, CONSTRAINT [PK_stat_log] PRIMARY KEY CLUSTERED ( [track_date] 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 /****** Object: Table [dbo].[Resource] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Resource]( [id] [int] IDENTITY(1,1) NOT NULL, [cha_id] [int] NOT NULL, [type_id] [smallint] NOT NULL, [content] [char](8000) NOT NULL, CONSTRAINT [PK_Resource] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[property] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[property]( [id] [bigint] NOT NULL, [cha_id] [bigint] NOT NULL, [context] [nvarchar](255) NOT NULL, [sum] [bigint] NOT NULL, [time] [datetime] NOT NULL, CONSTRAINT [PK_property] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[personinfo] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[personinfo]( [cha_id] [int] NOT NULL, [motto] [nvarchar](40) NULL, [showmotto] [bit] NULL, [sex] [nvarchar](50) NULL, [age] [int] NULL, [name] [nvarchar](50) NULL, [animal_zodiac] [nvarchar](50) NULL, [blood_type] [nvarchar](50) NULL, [birthday] [int] NULL, [state] [nvarchar](50) NULL, [city] [nvarchar](50) NULL, [constellation] [nvarchar](50) NULL, [career] [nvarchar](50) NULL, [avatarsize] [int] NULL, [prevent] [bit] NULL, [support] [int] NULL, [oppose] [int] NULL, CONSTRAINT [PK_personinfo] PRIMARY KEY CLUSTERED ( [cha_id] 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 /****** Object: Table [dbo].[personavatar] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[personavatar]( [cha_id] [int] NOT NULL, [avatar] [image] NULL, CONSTRAINT [PK_psersonavatar] PRIMARY KEY CLUSTERED ( [cha_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[param] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[param]( [id] [int] IDENTITY(1,1) NOT NULL, [param1] [int] NULL, [param2] [int] NULL, [param3] [int] NULL, [param4] [int] NULL, [param5] [int] NULL, [param6] [int] NULL, [param7] [int] NULL, [param8] [int] NULL, [param9] [int] NULL, [param10] [int] NULL, CONSTRAINT [PK_param] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[master] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[master]( [cha_id1] [int] NOT NULL, [cha_id2] [int] NOT NULL, [finish] [int] NOT NULL, [relation] [varchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[map_mask] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[map_mask]( [id] [int] IDENTITY(1,1) NOT NULL, [cha_id] [int] NOT NULL, [content1] [char](600) NOT NULL, [content2] [char](600) NOT NULL, [content3] [char](600) NOT NULL, [content4] [char](600) NOT NULL, [content5] [char](600) NOT NULL, CONSTRAINT [PK_map_mask] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_map_mask] UNIQUE NONCLUSTERED ( [id] 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 /****** Object: Table [dbo].[LotterySetting] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LotterySetting]( [section] [smallint] NOT NULL, [issue] [smallint] NOT NULL, [state] [smallint] NOT NULL, [createdate] [datetime] NOT NULL, [updatetime] [datetime] NULL, [itemno] [nvarchar](50) NULL, CONSTRAINT [PK_LotterySetting] PRIMARY KEY CLUSTERED ( [section] ASC, [issue] 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 /****** Object: Table [dbo].[Kop_MonthReport] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Kop_MonthReport]( [act_name] [varchar](50) NULL, [degree] [int] NULL, [ip] [varchar](20) NULL, [createdate] [datetime] NULL, [logouttime] [datetime] NULL, [playtime] [int] NULL, [Guild_Name] [varchar](16) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ChaGD] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ChaGD]( [Date] [datetime] NULL, [AllGd] [bigint] NULL, [Name] [varchar](32) NULL, [ChaGd] [int] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[boat] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[boat]( [boat_id] [int] IDENTITY(1,1) NOT NULL, [boat_berth] [smallint] NOT NULL, [boat_name] [char](17) NOT NULL, [boat_boatid] [int] NOT NULL, [boat_header] [int] NOT NULL, [boat_body] [int] NOT NULL, [boat_engine] [int] NOT NULL, [boat_cannon] [int] NOT NULL, [boat_equipment] [int] NOT NULL, [boat_bagsize] [smallint] NOT NULL, [boat_bag] [char](7000) NOT NULL, [boat_diecount] [smallint] NOT NULL, [boat_isdead] [char](1) NOT NULL, [cur_endure] [int] NOT NULL, [mx_endure] [int] NOT NULL, [cur_supply] [int] NOT NULL, [mx_supply] [int] NOT NULL, [skill_state] [char](400) NOT NULL, [boat_ownerid] [int] NOT NULL, [boat_createtime] [char](50) NOT NULL, [boat_isdeleted] [char](1) NOT NULL, [map] [char](50) NOT NULL, [map_x] [int] NOT NULL, [map_y] [int] NOT NULL, [angle] [int] NOT NULL, [degree] [smallint] NOT NULL, [exp] [int] NOT NULL, [version] [smallint] NOT NULL, CONSTRAINT [PK_boat] PRIMARY KEY CLUSTERED ( [boat_id] 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 /****** Object: Table [dbo].[birth_tab] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[birth_tab]( [birth_name] [varchar](50) NOT NULL, CONSTRAINT [PK_birth_tab] PRIMARY KEY CLUSTERED ( [birth_name] 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 /****** Object: Table [dbo].[AmphitheaterTeam] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AmphitheaterTeam]( [id] [int] NOT NULL, [captain] [int] NULL, [member] [nvarchar](50) NULL, [matchno] [int] NOT NULL, [state] [smallint] NOT NULL, [map] [smallint] NULL, [mapflag] [int] NULL, [winnum] [smallint] NOT NULL, [losenum] [smallint] NOT NULL, [relivenum] [smallint] NOT NULL, [createdate] [datetime] NULL, [updatetime] [datetime] NOT NULL, CONSTRAINT [PK_AmphitheaterTeam] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[AmphitheaterSetting] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AmphitheaterSetting]( [section] [smallint] NOT NULL, [season] [smallint] NOT NULL, [round] [smallint] NOT NULL, [state] [smallint] NOT NULL, [createdate] [datetime] NOT NULL, [updatetime] [datetime] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[account] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[account]( [act_id] [int] NOT NULL, [act_name] [varchar](50) NOT NULL, [gm] [tinyint] NOT NULL, [cha_ids] [varchar](80) NOT NULL, [last_ip] [varchar](16) NOT NULL, [disc_reason] [varchar](128) NOT NULL, [last_leave] [datetime] NOT NULL, [password] [varchar](50) NULL, [merge_state] [int] NOT NULL, [mall_points] [int] NULL, [credits] [int] NULL, [vote_time] [varchar](50) NULL, [vote_time1] [varchar](50) NULL, [vote_time2] [varchar](50) NULL, [total_votes] [int] NULL, CONSTRAINT [PK_account] PRIMARY KEY CLUSTERED ( [act_id] 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 /****** Object: Table [dbo].[IPAddress] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IPAddress]( [ip1] [float] NOT NULL, [ip2] [float] NOT NULL, [country] [nvarchar](70) NULL, [city] [nvarchar](70) NULL, CONSTRAINT [PK_IPAddress] PRIMARY KEY CLUSTERED ( [ip1] ASC, [ip2] 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 /****** Object: Table [dbo].[guild] Script Date: 11/27/2017 05:28:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[guild]( [guild_id] [int] NOT NULL, [guild_name] [varchar](16) NOT NULL, [motto] [varchar](50) NOT NULL, [passwd] [varchar](20) NOT NULL, [leader_id] [int] NOT NULL, [type] [tinyint] NOT NULL, [stat] [tinyint] NOT NULL, [money] [bigint] NOT NULL, [exp] [bigint] NOT NULL, [member_total] [smallint] NOT NULL, [try_total] [smallint] NOT NULL, [disband_date] [datetime] NOT NULL, [challlevel] [smallint] NOT NULL, [challid] [int] NOT NULL, [challmoney] [bigint] NOT NULL, [challstart] [smallint] NOT NULL, CONSTRAINT [PK_guild] PRIMARY KEY CLUSTERED ( [guild_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_guild_name] UNIQUE NONCLUSTERED ( [guild_name] 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 INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (0, N'Navy HQ', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978B0 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (1, N'Navy Division 1', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978BE AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (2, N'Navy Division 2', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978BE AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (3, N'Navy Division 3', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978BE AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (4, N'Navy Division 4', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978BE AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (5, N'Navy Division 5', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978BE AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (6, N'Navy Division 6', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978BE AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (7, N'Navy Division 7', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (8, N'Navy Division 8', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (9, N'Navy Division 9', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (10, N'Navy Division 10', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (11, N'Navy Division 11', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (12, N'Navy Division 12', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (13, N'Navy Division 13', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (14, N'Navy Division 14', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (15, N'Navy Division 15', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (16, N'Navy Division 16', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (17, N'Navy Division 17', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (18, N'Navy Division 18', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (19, N'Navy Division 19', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (20, N'Navy Division 20', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (21, N'Navy Division 21', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (22, N'Navy Division 22', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (23, N'Navy Division 23', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (24, N'Navy Division 24', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (25, N'Navy Division 25', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (26, N'Navy Division 26', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (27, N'Navy Division 27', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (28, N'Navy Division 28', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (29, N'Navy Division 29', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (30, N'Navy Division 30', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (31, N'Navy Division 31', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (32, N'Navy Division 32', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (33, N'Navy Division 33', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (34, N'Navy Division 34', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (35, N'Navy Division 35', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (36, N'Navy Division 36', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (37, N'Navy Division 37', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (38, N'Navy Division 38', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (39, N'Navy Division 39', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (40, N'Navy Division 40', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (41, N'Navy Division 41', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (42, N'Navy Division 42', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (43, N'Navy Division 43', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (44, N'Navy Division 44', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (45, N'Navy Division 45', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C3 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (46, N'Navy Division 46', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (47, N'Navy Division 47', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (48, N'Navy Division 48', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (49, N'Navy Division 49', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (50, N'Navy Division 50', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (51, N'Navy Division 51', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (52, N'Navy Division 52', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (53, N'Navy Division 53', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (54, N'Navy Division 54', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (55, N'Navy Division 55', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (56, N'Navy Division 56', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (57, N'Navy Division 57', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (58, N'Navy Division 58', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (59, N'Navy Division 59', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (60, N'Navy Division 60', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (61, N'Navy Division 61', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (62, N'Navy Division 62', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (63, N'Navy Division 63', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (64, N'Navy Division 64', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (65, N'Navy Division 65', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (66, N'Navy Division 66', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (67, N'Navy Division 67', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (68, N'Navy Division 68', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (69, N'Navy Division 69', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (70, N'Navy Division 70', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (71, N'Navy Division 71', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (72, N'Navy Division 72', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (73, N'Navy Division 73', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (74, N'Navy Division 74', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (75, N'Navy Division 75', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (76, N'Navy Division 76', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (77, N'Navy Division 77', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (78, N'Navy Division 78', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (79, N'Navy Division 79', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (80, N'Navy Division 80', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (81, N'Navy Division 81', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (82, N'Navy Division 82', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (83, N'Navy Division 83', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (84, N'Navy Division 84', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (85, N'Navy Division 85', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (86, N'Navy Division 86', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (87, N'Navy Division 87', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978C8 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (88, N'Navy Division 88', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (89, N'Navy Division 89', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (90, N'Navy Division 90', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (91, N'Navy Division 91', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (92, N'Navy Division 92', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (93, N'Navy Division 93', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (94, N'Navy Division 94', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (95, N'Navy Division 95', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (96, N'Navy Division 96', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (97, N'Navy Division 97', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (98, N'Navy Division 98', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (99, N'Navy Division 99', N'', N'', 0, 0, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (101, N'Pirate Guild 1', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) GO print 'Processed 100 total records' INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (102, N'Pirate Guild 2', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (103, N'Pirate Guild 3', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (104, N'Pirate Guild 4', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (105, N'Pirate Guild 5', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (106, N'Pirate Guild 6', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (107, N'Pirate Guild 7', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (108, N'Pirate Guild 8', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (109, N'Pirate Guild 9', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (110, N'Pirate Guild 10', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (111, N'Pirate Guild 11', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (112, N'Pirate Guild 12', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (113, N'Pirate Guild 13', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (114, N'Pirate Guild 14', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (115, N'Pirate Guild 15', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (116, N'Pirate Guild 16', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (117, N'Pirate Guild 17', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (118, N'Pirate Guild 18', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (119, N'Pirate Guild 19', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (120, N'Pirate Guild 20', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (121, N'Pirate Guild 21', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (122, N'Pirate Guild 22', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (123, N'Pirate Guild 23', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (124, N'Pirate Guild 24', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (125, N'Pirate Guild 25', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (126, N'Pirate Guild 26', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (127, N'Pirate Guild 27', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (128, N'Pirate Guild 28', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (129, N'Pirate Guild 29', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (130, N'Pirate Guild 30', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (131, N'Pirate Guild 31', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978CC AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (132, N'Pirate Guild 32', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (133, N'Pirate Guild 33', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (134, N'Pirate Guild 34', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (135, N'Pirate Guild 35', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (136, N'Pirate Guild 36', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (137, N'Pirate Guild 37', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (138, N'Pirate Guild 38', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (139, N'Pirate Guild 39', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (140, N'Pirate Guild 40', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (141, N'Pirate Guild 41', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (142, N'Pirate Guild 42', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (143, N'Pirate Guild 43', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (144, N'Pirate Guild 44', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (145, N'Pirate Guild 45', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (146, N'Pirate Guild 46', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (147, N'Pirate Guild 47', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (148, N'Pirate Guild 48', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (149, N'Pirate Guild 49', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (150, N'Pirate Guild 50', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (151, N'Pirate Guild 51', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (152, N'Pirate Guild 52', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (153, N'Pirate Guild 53', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (154, N'Pirate Guild 54', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (155, N'Pirate Guild 55', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (156, N'Pirate Guild 56', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (157, N'Pirate Guild 57', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (158, N'Pirate Guild 58', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (159, N'Pirate Guild 59', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (160, N'Pirate Guild 60', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (161, N'Pirate Guild 61', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (162, N'Pirate Guild 62', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (163, N'Pirate Guild 63', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (164, N'Pirate Guild 64', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (165, N'Pirate Guild 65', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (166, N'Pirate Guild 66', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (167, N'Pirate Guild 67', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (168, N'Pirate Guild 68', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (169, N'Pirate Guild 69', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (170, N'Pirate Guild 70', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (171, N'Pirate Guild 71', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (172, N'Pirate Guild 72', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (173, N'Pirate Guild 73', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D1 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (174, N'Pirate Guild 74', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (175, N'Pirate Guild 75', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (176, N'Pirate Guild 76', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (177, N'Pirate Guild 77', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (178, N'Pirate Guild 78', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (179, N'Pirate Guild 79', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (180, N'Pirate Guild 80', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (181, N'Pirate Guild 81', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (182, N'Pirate Guild 82', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (183, N'Pirate Guild 83', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (184, N'Pirate Guild 84', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (185, N'Pirate Guild 85', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (186, N'Pirate Guild 86', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (187, N'Pirate Guild 87', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (188, N'Pirate Guild 88', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (189, N'Pirate Guild 89', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (190, N'Pirate Guild 90', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (191, N'Pirate Guild 91', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (192, N'Pirate Guild 92', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (193, N'Pirate Guild 93', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (194, N'Pirate Guild 94', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (195, N'Pirate Guild 95', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (196, N'Pirate Guild 96', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (197, N'Pirate Guild 97', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (198, N'Pirate Guild 98', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) INSERT [dbo].[guild] ([guild_id], [guild_name], [motto], [passwd], [leader_id], [type], [stat], [money], [exp], [member_total], [try_total], [disband_date], [challlevel], [challid], [challmoney], [challstart]) VALUES (199, N'Pirate Guild 99', N'', N'', 0, 1, 0, 0, 0, 0, 0, CAST(0x0000A2F900F978D5 AS DateTime), 0, 0, 0, 0) /****** Object: Default [DF_guild_guild_name] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_guild_name] DEFAULT ('') FOR [guild_name] GO /****** Object: Default [DF_guild_motto] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_motto] DEFAULT ('') FOR [motto] GO /****** Object: Default [DF_guild_passwd] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_passwd] DEFAULT ('') FOR [passwd] GO /****** Object: Default [DF_guild_leader_id] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_leader_id] DEFAULT (0) FOR [leader_id] GO /****** Object: Default [DF_guild_type] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_type] DEFAULT (0) FOR [type] GO /****** Object: Default [DF_guild_stat] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_stat] DEFAULT (0) FOR [stat] GO /****** Object: Default [DF_guild_money] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_money] DEFAULT (0) FOR [money] GO /****** Object: Default [DF_guild_exp] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_exp] DEFAULT (0) FOR [exp] GO /****** Object: Default [DF_guild_total] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_total] DEFAULT (0) FOR [member_total] GO /****** Object: Default [DF_guild_pending_total] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_pending_total] DEFAULT (0) FOR [try_total] GO /****** Object: Default [DF_guild_disband_date] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_disband_date] DEFAULT (getdate()) FOR [disband_date] GO /****** Object: Default [DF_guild_challlevel] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challlevel] DEFAULT (0) FOR [challlevel] GO /****** Object: Default [DF_guild_challid] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challid] DEFAULT (0) FOR [challid] GO /****** Object: Default [DF_guild_challmoney] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challmoney] DEFAULT (0) FOR [challmoney] GO /****** Object: Default [DF_guild_challstart] Script Date: 11/27/2017 05:28:02 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challstart] DEFAULT (0) FOR [challstart] GO /****** Object: Table [dbo].[friends] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[friends]( [cha_id1] [int] NOT NULL, [cha_id2] [int] NOT NULL, [relation] [varchar](50) NOT NULL, [createtime] [datetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[dtproperties] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[dtproperties]( [id] [int] IDENTITY(1,1) NOT NULL, [objectid] [int] NULL, [property] [varchar](64) NOT NULL, [value] [varchar](255) NULL, [uvalue] [nvarchar](255) NULL, [lvalue] [image] NULL, [version] [int] NOT NULL, CONSTRAINT [pk_dtproperties] PRIMARY KEY CLUSTERED ( [id] ASC, [property] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[character_log] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[character_log]( [cha_id] [int] NOT NULL, [cha_name] [varchar](50) NOT NULL, [act_id] [int] NOT NULL, [guild_id] [int] NOT NULL, [job] [varchar](50) NOT NULL, [degree] [smallint] NOT NULL, [exp] [int] NOT NULL, [hp] [int] NOT NULL, [sp] [int] NOT NULL, [ap] [int] NOT NULL, [tp] [int] NOT NULL, [gd] [int] NOT NULL, [str] [int] NOT NULL, [dex] [int] NOT NULL, [agi] [int] NOT NULL, [con] [int] NOT NULL, [sta] [int] NOT NULL, [luk] [int] NOT NULL, [map] [varchar](50) NOT NULL, [map_x] [int] NOT NULL, [map_y] [int] NOT NULL, [radius] [int] NOT NULL, [look] [varchar](80) NOT NULL, [del_date] [datetime] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[character] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[character]( [cha_id] [int] IDENTITY(1,1) NOT NULL, [cha_name] [varchar](50) NOT NULL, [motto] [varchar](50) NOT NULL, [icon] [smallint] NOT NULL, [version] [smallint] NOT NULL, [pk_ctrl] [tinyint] NOT NULL, [mem_addr] [int] NOT NULL, [act_id] [int] NOT NULL, [guild_id] [int] NOT NULL, [guild_stat] [tinyint] NOT NULL, [guild_permission] [smallint] NOT NULL, [job] [varchar](50) NOT NULL, [degree] [smallint] NOT NULL, [exp] [bigint] NOT NULL, [hp] [int] NOT NULL, [sp] [int] NOT NULL, [ap] [int] NOT NULL, [tp] [int] NOT NULL, [gd] [int] NOT NULL, [str] [int] NOT NULL, [dex] [int] NOT NULL, [agi] [int] NOT NULL, [con] [int] NOT NULL, [sta] [int] NOT NULL, [luk] [int] NOT NULL, [sail_lv] [int] NOT NULL, [sail_exp] [int] NOT NULL, [sail_left_exp] [int] NOT NULL, [live_lv] [int] NOT NULL, [live_exp] [int] NOT NULL, [map] [varchar](50) NOT NULL, [map_x] [int] NOT NULL, [map_y] [int] NOT NULL, [radius] [int] NOT NULL, [angle] [int] NOT NULL, [look] [varchar](2000) NOT NULL, [kb_capacity] [int] NOT NULL, [kitbag] [varchar](7000) NOT NULL, [skillbag] [varchar](1200) NOT NULL, [shortcut] [varchar](1200) NOT NULL, [mission] [varchar](2048) NOT NULL, [misrecord] [varchar](2048) NOT NULL, [mistrigger] [varchar](2048) NOT NULL, [miscount] [varchar](512) NOT NULL, [birth] [varchar](50) NOT NULL, [login_cha] [varchar](50) NOT NULL, [live_tp] [int] NOT NULL, [map_mask] [varchar](8000) NOT NULL, [delflag] [tinyint] NOT NULL, [operdate] [datetime] NOT NULL, [deldate] [datetime] NULL, [main_map] [varchar](50) NOT NULL, [skill_state] [varchar](1024) NOT NULL, [bank] [varchar](50) NOT NULL, [estop] [datetime] NOT NULL, [estoptime] [int] NOT NULL, [kb_locked] [int] NOT NULL, [kitbag_tmp] [int] NOT NULL, [credit] [int] NOT NULL, [store_item] [int] NOT NULL, [extend] [varchar](512) NULL, CONSTRAINT [PK_character] PRIMARY KEY CLUSTERED ( [cha_id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_character] UNIQUE NONCLUSTERED ( [cha_name] 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 /****** Object: Table [dbo].[item] Script Date: 11/27/2017 05:29:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[item]( [db_id] [int] IDENTITY(1,1) NOT NULL, [cha_id] [int] NOT NULL, [type] [smallint] NOT NULL, [item_type_id] [smallint] NOT NULL, [attr] [varchar](255) NOT NULL, CONSTRAINT [PK_item] PRIMARY KEY CLUSTERED ( [db_id] 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 /****** Object: Default [DF_account_act_name] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_act_name] DEFAULT ('') FOR [act_name] GO /****** Object: Default [DF_account_gm] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_gm] DEFAULT (0) FOR [gm] GO /****** Object: Default [DF_account_cha_ids] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_cha_ids] DEFAULT ('') FOR [cha_ids] GO /****** Object: Default [DF_account_last_ip] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_last_ip] DEFAULT ('') FOR [last_ip] GO /****** Object: Default [DF_account_disc_reson] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_disc_reson] DEFAULT ('') FOR [disc_reason] GO /****** Object: Default [DF_account_last_leave] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_last_leave] DEFAULT ('2001-01-01') FOR [last_leave] GO /****** Object: Default [DF_account_merge_state] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_merge_state] DEFAULT (0) FOR [merge_state] GO /****** Object: Default [DF_account_mall_points] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_mall_points] DEFAULT (0) FOR [mall_points] GO /****** Object: Default [DF_account_credits] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[account] ADD CONSTRAINT [DF_account_credits] DEFAULT (0) FOR [credits] GO /****** Object: Default [DF_AmphitheaterTeam_matchno] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[AmphitheaterTeam] ADD CONSTRAINT [DF_AmphitheaterTeam_matchno] DEFAULT (0) FOR [matchno] GO /****** Object: Default [DF_AmphitheaterTeam_state] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[AmphitheaterTeam] ADD CONSTRAINT [DF_AmphitheaterTeam_state] DEFAULT (0) FOR [state] GO /****** Object: Default [DF_AmphitheaterTeam_winnum] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[AmphitheaterTeam] ADD CONSTRAINT [DF_AmphitheaterTeam_winnum] DEFAULT (0) FOR [winnum] GO /****** Object: Default [DF_AmphitheaterTeam_losenum] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[AmphitheaterTeam] ADD CONSTRAINT [DF_AmphitheaterTeam_losenum] DEFAULT (0) FOR [losenum] GO /****** Object: Default [DF_AmphitheaterTeam_relivenum] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[AmphitheaterTeam] ADD CONSTRAINT [DF_AmphitheaterTeam_relivenum] DEFAULT (0) FOR [relivenum] GO /****** Object: Default [DF_boat_boat_berth] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_berth] DEFAULT (0) FOR [boat_berth] GO /****** Object: Default [DF_boat_boat_name] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_name] DEFAULT ('') FOR [boat_name] GO /****** Object: Default [DF_boat_boat_boat] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_boat] DEFAULT (0) FOR [boat_boatid] GO /****** Object: Default [DF_boat_boat_header] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_header] DEFAULT (0) FOR [boat_header] GO /****** Object: Default [DF_boat_boat_body] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_body] DEFAULT (0) FOR [boat_body] GO /****** Object: Default [DF_boat_boat_engine] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_engine] DEFAULT (0) FOR [boat_engine] GO /****** Object: Default [DF_boat_boat_cannon] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_cannon] DEFAULT (0) FOR [boat_cannon] GO /****** Object: Default [DF_boat_boat_part] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_part] DEFAULT (0) FOR [boat_equipment] GO /****** Object: Default [DF_boat_boat_bagsize] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_bagsize] DEFAULT (0) FOR [boat_bagsize] GO /****** Object: Default [DF_boat_boat_bag] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_bag] DEFAULT ('') FOR [boat_bag] GO /****** Object: Default [DF_boat_boat_diecount] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_diecount] DEFAULT (0) FOR [boat_diecount] GO /****** Object: Default [DF_boat_boat_isdie] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_isdie] DEFAULT (0) FOR [boat_isdead] GO /****** Object: Default [DF_boat_cur_endure] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_cur_endure] DEFAULT (0) FOR [cur_endure] GO /****** Object: Default [DF_boat_mx_endure] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_mx_endure] DEFAULT (0) FOR [mx_endure] GO /****** Object: Default [DF_boat_cur_supply] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_cur_supply] DEFAULT (0) FOR [cur_supply] GO /****** Object: Default [DF_boat_mx_supply] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_mx_supply] DEFAULT (0) FOR [mx_supply] GO /****** Object: Default [DF_boat_skill_state] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_skill_state] DEFAULT ('') FOR [skill_state] GO /****** Object: Default [DF_boat_boat_ownerid] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_ownerid] DEFAULT (0) FOR [boat_ownerid] GO /****** Object: Default [DF_boat_boat_createtime] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_createtime] DEFAULT ('') FOR [boat_createtime] GO /****** Object: Default [DF_boat_boat_isdeleted] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_boat_isdeleted] DEFAULT (0) FOR [boat_isdeleted] GO /****** Object: Default [DF_boat_map] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_map] DEFAULT ('') FOR [map] GO /****** Object: Default [DF_boat_map_x] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_map_x] DEFAULT ((-1)) FOR [map_x] GO /****** Object: Default [DF_boat_map_y] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_map_y] DEFAULT ((-1)) FOR [map_y] GO /****** Object: Default [DF_boat_angle] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_angle] DEFAULT (0) FOR [angle] GO /****** Object: Default [DF_boat_degree] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_degree] DEFAULT (1) FOR [degree] GO /****** Object: Default [DF_boat_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_exp] DEFAULT (0) FOR [exp] GO /****** Object: Default [DF_boat_version] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[boat] ADD CONSTRAINT [DF_boat_version] DEFAULT (1) FOR [version] GO /****** Object: Default [DF_character_motto] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_motto] DEFAULT ('') FOR [motto] GO /****** Object: Default [DF_character_icon] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_icon] DEFAULT (1) FOR [icon] GO /****** Object: Default [DF_character_version] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_version] DEFAULT (1) FOR [version] GO /****** Object: Default [DF_character_pk_ctrl_1] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_pk_ctrl_1] DEFAULT (0) FOR [pk_ctrl] GO /****** Object: Default [DF_character_mem_addr] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_mem_addr] DEFAULT (0) FOR [mem_addr] GO /****** Object: Default [DF_character_guild_id] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_guild_id] DEFAULT (0) FOR [guild_id] GO /****** Object: Default [DF_character_guild_stat] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_guild_stat] DEFAULT (0) FOR [guild_stat] GO /****** Object: Default [DF_character_guild_permission] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_guild_permission] DEFAULT (0) FOR [guild_permission] GO /****** Object: Default [DF_character_job] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_job] DEFAULT ('??') FOR [job] GO /****** Object: Default [DF_character_degree] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_degree] DEFAULT (0) FOR [degree] GO /****** Object: Default [DF_character_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_exp] DEFAULT (0) FOR [exp] GO /****** Object: Default [DF_character_hp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_hp] DEFAULT ((-1)) FOR [hp] GO /****** Object: Default [DF_character_sp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_sp] DEFAULT ((-1)) FOR [sp] GO /****** Object: Default [DF_character_ap] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_ap] DEFAULT (0) FOR [ap] GO /****** Object: Default [DF_character_tp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_tp] DEFAULT (0) FOR [tp] GO /****** Object: Default [DF_character_gd] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_gd] DEFAULT (10000) FOR [gd] GO /****** Object: Default [DF_character_str] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_str] DEFAULT (0) FOR [str] GO /****** Object: Default [DF_character_dex] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_dex] DEFAULT (0) FOR [dex] GO /****** Object: Default [DF_character_agi] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_agi] DEFAULT (0) FOR [agi] GO /****** Object: Default [DF_character_con] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_con] DEFAULT (0) FOR [con] GO /****** Object: Default [DF_character_sta] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_sta] DEFAULT (0) FOR [sta] GO /****** Object: Default [DF_character_luk] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_luk] DEFAULT (0) FOR [luk] GO /****** Object: Default [DF_character_sail_lv] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_sail_lv] DEFAULT (1) FOR [sail_lv] GO /****** Object: Default [DF_character_sail_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_sail_exp] DEFAULT (0) FOR [sail_exp] GO /****** Object: Default [DF_character_sail_left_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_sail_left_exp] DEFAULT (0) FOR [sail_left_exp] GO /****** Object: Default [DF_character_live_lv] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_live_lv] DEFAULT (1) FOR [live_lv] GO /****** Object: Default [DF_character_live_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_live_exp] DEFAULT (0) FOR [live_exp] GO /****** Object: Default [DF_character_map] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_map] DEFAULT ('') FOR [map] GO /****** Object: Default [DF_character_map_x] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_map_x] DEFAULT ((-1)) FOR [map_x] GO /****** Object: Default [DF_character_map_y] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_map_y] DEFAULT ((-1)) FOR [map_y] GO /****** Object: Default [DF_character_radius] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_radius] DEFAULT (0) FOR [radius] GO /****** Object: Default [DF_character_angle] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_angle] DEFAULT (0) FOR [angle] GO /****** Object: Default [DF_character_look] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_look] DEFAULT ('') FOR [look] GO /****** Object: Default [DF_character_kb_capacity] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_kb_capacity] DEFAULT (24) FOR [kb_capacity] GO /****** Object: Default [DF_character_kitbag] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_kitbag] DEFAULT ('') FOR [kitbag] GO /****** Object: Default [DF_character_skillbag] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_skillbag] DEFAULT ('') FOR [skillbag] GO /****** Object: Default [DF_character_shortcut_1] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_shortcut_1] DEFAULT ('') FOR [shortcut] GO /****** Object: Default [DF_character_mission] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_mission] DEFAULT ('') FOR [mission] GO /****** Object: Default [DF_character_misrecord] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_misrecord] DEFAULT ('') FOR [misrecord] GO /****** Object: Default [DF_character_trigger] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_trigger] DEFAULT ('') FOR [mistrigger] GO /****** Object: Default [DF_character_miscount] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_miscount] DEFAULT ('') FOR [miscount] GO /****** Object: Default [DF_character_birth] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_birth] DEFAULT ('???') FOR [birth] GO /****** Object: Default [DF_character_login_cha] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_login_cha] DEFAULT (0) FOR [login_cha] GO /****** Object: Default [DF_character_live_tp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_live_tp] DEFAULT (0) FOR [live_tp] GO /****** Object: Default [DF_character_map_mask] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_map_mask] DEFAULT (0) FOR [map_mask] GO /****** Object: Default [DF_character_delflag] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_delflag] DEFAULT (0) FOR [delflag] GO /****** Object: Default [DF_character_operdate] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_operdate] DEFAULT (getdate()) FOR [operdate] GO /****** Object: Default [DF_character_main_map] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_main_map] DEFAULT ('') FOR [main_map] GO /****** Object: Default [DF_character_skill_state] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_skill_state] DEFAULT ('') FOR [skill_state] GO /****** Object: Default [DF_character_bank] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_bank] DEFAULT ('') FOR [bank] GO /****** Object: Default [DF_character_estop] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_estop] DEFAULT (getdate()) FOR [estop] GO /****** Object: Default [DF_character_estoptime] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_estoptime] DEFAULT (0) FOR [estoptime] GO /****** Object: Default [DF_character_kb_locked] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_kb_locked] DEFAULT (0) FOR [kb_locked] GO /****** Object: Default [DF_character_kitbag_tmp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_kitbag_tmp] DEFAULT (0) FOR [kitbag_tmp] GO /****** Object: Default [DF_character_credit] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_credit] DEFAULT (0) FOR [credit] GO /****** Object: Default [DF_character_store_item] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] ADD CONSTRAINT [DF_character_store_item] DEFAULT (0) FOR [store_item] GO /****** Object: Default [DF_character_log_guild_id] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_guild_id] DEFAULT (0) FOR [guild_id] GO /****** Object: Default [DF_character_log_job] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_job] DEFAULT (0) FOR [job] GO /****** Object: Default [DF_character_log_degree] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_degree] DEFAULT (1) FOR [degree] GO /****** Object: Default [DF_character_log_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_exp] DEFAULT (0) FOR [exp] GO /****** Object: Default [DF_character_log_hp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_hp] DEFAULT ((-1)) FOR [hp] GO /****** Object: Default [DF_character_log_sp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_sp] DEFAULT ((-1)) FOR [sp] GO /****** Object: Default [DF_character_log_ap] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_ap] DEFAULT (0) FOR [ap] GO /****** Object: Default [DF_character_log_tp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_tp] DEFAULT (0) FOR [tp] GO /****** Object: Default [DF_character_log_gd] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_gd] DEFAULT (0) FOR [gd] GO /****** Object: Default [DF_character_log_str] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_str] DEFAULT (0) FOR [str] GO /****** Object: Default [DF_character_log_dex] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_dex] DEFAULT (0) FOR [dex] GO /****** Object: Default [DF_character_log_agi] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_agi] DEFAULT (0) FOR [agi] GO /****** Object: Default [DF_character_log_con] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_con] DEFAULT (0) FOR [con] GO /****** Object: Default [DF_character_log_sta] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_sta] DEFAULT (0) FOR [sta] GO /****** Object: Default [DF_character_log_luk] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_luk] DEFAULT (0) FOR [luk] GO /****** Object: Default [DF_character_log_map] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_map] DEFAULT ('') FOR [map] GO /****** Object: Default [DF_character_log_map_x] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_map_x] DEFAULT ((-1)) FOR [map_x] GO /****** Object: Default [DF_character_log_map_y] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_map_y] DEFAULT ((-1)) FOR [map_y] GO /****** Object: Default [DF_character_log_radius] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_radius] DEFAULT (0) FOR [radius] GO /****** Object: Default [DF_character_log_look] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_look] DEFAULT ('') FOR [look] GO /****** Object: Default [DF_character_log_del_date] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character_log] ADD CONSTRAINT [DF_character_log_del_date] DEFAULT (getdate()) FOR [del_date] GO /****** Object: Default [DF__dtpropert__versi__4A8310C6] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[dtproperties] ADD CONSTRAINT [DF__dtpropert__versi__4A8310C6] DEFAULT (0) FOR [version] GO /****** Object: Default [DF_guild_guild_name] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_guild_name] DEFAULT ('') FOR [guild_name] GO /****** Object: Default [DF_guild_motto] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_motto] DEFAULT ('') FOR [motto] GO /****** Object: Default [DF_guild_passwd] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_passwd] DEFAULT ('') FOR [passwd] GO /****** Object: Default [DF_guild_leader_id] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_leader_id] DEFAULT (0) FOR [leader_id] GO /****** Object: Default [DF_guild_type] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_type] DEFAULT (0) FOR [type] GO /****** Object: Default [DF_guild_stat] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_stat] DEFAULT (0) FOR [stat] GO /****** Object: Default [DF_guild_money] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_money] DEFAULT (0) FOR [money] GO /****** Object: Default [DF_guild_exp] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_exp] DEFAULT (0) FOR [exp] GO /****** Object: Default [DF_guild_total] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_total] DEFAULT (0) FOR [member_total] GO /****** Object: Default [DF_guild_pending_total] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_pending_total] DEFAULT (0) FOR [try_total] GO /****** Object: Default [DF_guild_disband_date] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_disband_date] DEFAULT (getdate()) FOR [disband_date] GO /****** Object: Default [DF_guild_challlevel] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challlevel] DEFAULT (0) FOR [challlevel] GO /****** Object: Default [DF_guild_challid] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challid] DEFAULT (0) FOR [challid] GO /****** Object: Default [DF_guild_challmoney] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challmoney] DEFAULT (0) FOR [challmoney] GO /****** Object: Default [DF_guild_challstart] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[guild] ADD CONSTRAINT [DF_guild_challstart] DEFAULT (0) FOR [challstart] GO /****** Object: Default [DF_map_mask_content] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[map_mask] ADD CONSTRAINT [DF_map_mask_content] DEFAULT (0) FOR [content1] GO /****** Object: Default [DF_map_mask_content4] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[map_mask] ADD CONSTRAINT [DF_map_mask_content4] DEFAULT (0) FOR [content2] GO /****** Object: Default [DF_map_mask_content3] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[map_mask] ADD CONSTRAINT [DF_map_mask_content3] DEFAULT (0) FOR [content3] GO /****** Object: Default [DF_map_mask_content2] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[map_mask] ADD CONSTRAINT [DF_map_mask_content2] DEFAULT (0) FOR [content4] GO /****** Object: Default [DF_map_mask_content1] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[map_mask] ADD CONSTRAINT [DF_map_mask_content1] DEFAULT (0) FOR [content5] GO /****** Object: Default [DF_master_cha_id1] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[master] ADD CONSTRAINT [DF_master_cha_id1] DEFAULT (0) FOR [cha_id1] GO /****** Object: Default [DF_master_cha_id2] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[master] ADD CONSTRAINT [DF_master_cha_id2] DEFAULT (0) FOR [cha_id2] GO /****** Object: Default [DF_master_finish] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[master] ADD CONSTRAINT [DF_master_finish] DEFAULT (0) FOR [finish] GO /****** Object: Default [DF_master_relation] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[master] ADD CONSTRAINT [DF_master_relation] DEFAULT ('teacher') FOR [relation] GO /****** Object: Default [DF_param_param1] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param1] DEFAULT (0) FOR [param1] GO /****** Object: Default [DF_param_param2] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param2] DEFAULT (0) FOR [param2] GO /****** Object: Default [DF_param_param3] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param3] DEFAULT (0) FOR [param3] GO /****** Object: Default [DF_param_param4] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param4] DEFAULT (0) FOR [param4] GO /****** Object: Default [DF_param_param5] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param5] DEFAULT (0) FOR [param5] GO /****** Object: Default [DF_param_param6] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param6] DEFAULT (0) FOR [param6] GO /****** Object: Default [DF_param_param7] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param7] DEFAULT (0) FOR [param7] GO /****** Object: Default [DF_param_param8] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param8] DEFAULT (0) FOR [param8] GO /****** Object: Default [DF_param_param9] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param9] DEFAULT (0) FOR [param9] GO /****** Object: Default [DF_param_param10] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[param] ADD CONSTRAINT [DF_param_param10] DEFAULT (0) FOR [param10] GO /****** Object: Default [DF_Recource_type_id] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[Resource] ADD CONSTRAINT [DF_Recource_type_id] DEFAULT (1) FOR [type_id] GO /****** Object: Default [DF_Recource_content] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[Resource] ADD CONSTRAINT [DF_Recource_content] DEFAULT ('') FOR [content] GO /****** Object: Default [DF_stat_log_track_date] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[stat_log] ADD CONSTRAINT [DF_stat_log_track_date] DEFAULT (getdate()) FOR [track_date] GO /****** Object: Default [DF_stat_log_login_num] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[stat_log] ADD CONSTRAINT [DF_stat_log_login_num] DEFAULT (0) FOR [login_num] GO /****** Object: Default [DF_stat_log_play_num] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[stat_log] ADD CONSTRAINT [DF_stat_log_play_num] DEFAULT (0) FOR [play_num] GO /****** Object: Default [DF_Ticket_num] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[WinTicket] ADD CONSTRAINT [DF_Ticket_num] DEFAULT (0) FOR [num] GO /****** Object: ForeignKey [FK_character_account] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[character] WITH CHECK ADD CONSTRAINT [FK_character_account] FOREIGN KEY([act_id]) REFERENCES [dbo].[account] ([act_id]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[character] CHECK CONSTRAINT [FK_character_account] GO /****** Object: ForeignKey [FK_item_character] Script Date: 11/27/2017 05:29:25 ******/ ALTER TABLE [dbo].[item] WITH CHECK ADD CONSTRAINT [FK_item_character] FOREIGN KEY([cha_id]) REFERENCES [dbo].[character] ([cha_id]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[item] CHECK CONSTRAINT [FK_item_character] GO
  5. Syntax

    attach database problem

    Hi.. if you still having the problem, may i have your teamviewer details?
  6. Syntax

    attach database problem

    Your database may looks like this choose one, right click -> properties -> tab security ->edit the permission setting.
  7. Syntax

    attach database problem

    Hello, have you check the permission of the database?
  8. Syntax

    Quest require x hours online

    SQL = {} SQL.Host = "hostname" SQL.User = "username" SQL.Pass = "password" function GetOnlineTime(role) local PlayerID = GetCharID(role) local String = "SELECT total_live_time FROM AccountServer.dbo.account_login WHERE id IN (SELECT act_id FROM GameDB.dbo.character WHERE cha_id = "..PlayerID..")" local Connect, ConnectID = LuaSQL("connect", SQL.Host, SQL.User, SQL.Pass) if Connect == 1 then local Success, Query = LuaSQL("query", ConnectID, String) if Success == 1 then local Data = LuaSQL("fetch", ConnectID, Query) Data = tonumber(Data["total_live_time"]) LuaSQL("freehandle", ConnectID, Query) LuaSQL("close", ConnectID) return Data end end end function HasOnlineTime(role,value) local OnlineTime = GetOnlineTime(role) if OnlineTime >= value then return LUA_TRUE end return LUA_FALSE end --MissionSdk.lua (ConditionsTest) elseif conditions[i].func == HasOnlineTime then local ret = HasOnlineTime( character, conditions[i].p1 ) if ret ~= LUA_TRUE then return LUA_FALSE end --Quest Scripts MisResultCondition(HasOnlineTime,3600) P.S: required LuaSQL
  9. Syntax

    Quest require x hours online

    @NabSlayer Is this quest asking player to stay online for x hours ? or The quest can be activated after x hours stay online?
  10. Syntax

    Player Logout/Login Check

    The only way can be done using lua is from: -Logged Out -> before_leave_map(role) -Logged In -> after_enter_map(role,map_copy) but those function is also called every time player teleporting
  11. Syntax

    Quick Question Regarding Dupe

    @Faller by running all maps in 1 gamesv soon or later you will encountered with "low memory" issue. the x64 compiled have bigger memory, and regarding about dupes..you can make a clone even you using 1 gamesv for all map, just don't put any "Ex-changer" such like reputation or money or any currency that stored in your character for redeem something outside gamesv (ex: web).
  12. Syntax

    Hours of fail, fail, fail..

    Do you have team viewer?
  13. Syntax

    Costs of running a server.

    *If you're good in Lua programing you will spend like 1-2 Months to build a server to what you like, if you don't then it takes 3-6 months or longer (reverse engineering didn't count) *Building website takes 1-2 weeks however you can buy an exclusive site for 100-300 USD (depends on what feature and who sell it) *Hosting : there are several hoster you can choose (server4u, ovh, etc) price may vary from 50-150 USD per month (depends on the spec of the dedicated server you choose) *Maintenance fee maybe around 50-100 USD per month (this including buy this and that from other developer, example: vector protection?) *Required good management skill and plans *Required million of friends if you want your server success If you can completes all of those stuff above then you need 1 more item, which is "Lucky Charm" Good Luck !!
  14. Syntax

    Manufacturing, crafting, cooking materials

    for this case is it better if you make custom bp, i'll post here later
  15. Syntax

    Manufacturing, crafting, cooking materials

    This codes below is easy to understand, hope you can use it as well Variable.lua
×