Jump to content

Syntax

Members
  • Content count

    23
  • Joined

  • Last visited

  • Days Won

    6

Everything posted by Syntax

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

    Looking any website developer

    @Awatawa I can develop pkosite, you can contact me Here
  17. Syntax

    Monster Item

    local dead_id = GetChaID(dead) local mob = {} mob[111] = {ItemDrop = 3457, Quantity = 1, Quality = 4, Rate = 0.1} --10% drop mob[112] = {ItemDrop = 3457, Quantity = 1, Quality = 4, Rate = 0.2} --20% drop if mob[dead_id] ~= nil then if Percentage_Random(mob[dead_id].Rate) == 1 then GiveItem ( atk, 0, mob[dead_id].ItemDrop, mob[dead_id].Quantity , mob[dead_id].Quality) end end
  18. Syntax

    Anti-Dupe problem

    print("*Loading Hook Library by MaTT"); if (Hook ~= nil) then Hook:ClearAllHooks() end Hook = { hookList = {}, enabled = true } function Hook:AddReplacementHook(originalFctName, newFct) local hookDef = self.hookList[originalFctName] if (hookDef == nil) then hookDef = Hook:InitHook(originalFctName) end hookDef.replacement = newFct end function Hook:RemoveReplacementHook(originalFct) local hookDef = self.hookList[originalFctName] if (hookDef ~= nil) then hookDef.replacement = nil end end -- PRIVATE function Hook:GenericHook(originalFctName, ...) local hookDef = self.hookList[originalFctName] if (hookDef ~= nil) then if (self.enabled == true and hookDef.enabled == true) then -- Execute pre filters local pre_filter_count = table.getn(hookDef.pre) for i=1, pre_filter_count do local returnedValue = hookDef.pre[i].fct(unpack(arg)) if (returnedValue == false) then return; end end -- Execute key function (either original or replacement) local returnedValues = nil if (hookDef.replacement ~= nil) then returnedValues = { hookDef.replacement(unpack(arg)) } else returnedValues = { hookDef.original(unpack(arg)) } end -- Execute post filters local post_filter_count = table.getn(hookDef.post) for i=1, post_filter_count do newReturnedValues = { hookDef.post[i].fct(returnedValues, unpack(arg)) } if (newReturnedValues ~= nil and table.getn(newReturnedValues) > 0 ) then returnedValues = newReturnedValues end end local a, b, c = unpack(returnedValues) return unpack(returnedValues) else return hookDef.original(unpack(arg)) end end end -- PRIVATE function Hook:InitHook(originalFctName) local hookDef = { pre={} , post={} , original=nil, replacement=nil, enabled=true } self.hookList[originalFctName] = hookDef hookDef.original = _G[originalFctName] _G[originalFctName] = function (...) return Hook:GenericHook(originalFctName, unpack(arg) ) end return hookDef end function Hook:AddPreHook(originalFctName, hookFct, priorityOrder) local hookDef = self.hookList[originalFctName] if (hookDef == nil) then hookDef = Hook:InitHook(originalFctName) end -- Avoid undefined priorityOrder if (priorityOrder == nil) then priorityOrder = 999999 end -- Check if the hook is already recorded local hookCount = table.getn(hookDef.pre) local found = false for i=1, hookCount do if (hookDef.pre[i].fct == hookFct) then found = true hookDef.pre[i].order = priorityOrder end end if (found == false) then table.insert(hookDef.pre, {fct = hookFct, order = priorityOrder} ) end -- Force a re-sorting of hooks to handle execution order Hook:SortHooks(hookDef.pre) end -- TODO function Hook:RemovePreHook(originalFctName, hookFct, priorityOrder) print("ERROR >> Hook:RemovePreHook() is not yet implemented !!") end function Hook:AddPostHook(originalFctName, hookFct, priorityOrder) local hookDef = self.hookList[originalFctName] if (hookDef == nil) then hookDef = Hook:InitHook(originalFctName) end -- Avoid undefined priorityOrder if (priorityOrder == nil) then priorityOrder = 999999 end -- Check if the hook is already recorded local hookCount = table.getn(hookDef.post) local found = false for i=1, hookCount do if (hookDef.post[i].fct == hookFct) then found = true hookDef.post[i].order = priorityOrder end end if (found == false) then table.insert(hookDef.post, {fct = hookFct, order = priorityOrder} ) end -- Force a re-sorting of hooks to handle execution order Hook:SortHooks(hookDef.post) end -- TODO function Hook:RemovePostHook(originalFctName, hookFct, priorityOrder) print("ERROR >> Hook:RemovePostHook() is not yet implemented !!") end function Hook:DisableHooks(originalFctName) local hookDef = self.hookList[originalFctName] if (hookDef ~= nil) then hookDef.enabled = false end end function Hook:EnableHooks(originalFctName) local hookDef = self.hookList[originalFctName] if (hookDef ~= nil) then hookDef.enabled = true end end function Hook:ClearHooks(originalFctName) local hookDef = self.hookList[originalFctName] if (hookDef ~= nil) then hookDef.enabled = true end _G[originalFctName] = hookDef.original self.hookList[originalFctName] = nil end -- TODO function Hook:ClearAllHooks() --print("ERROR >> Hook:ClearAllHooks() is not yet implemented !!") for i,v in pairs(self.hookList) do Hook:ClearHooks(i) end end function Hook:DisableAllHooks() self.enabled = false end function Hook:EnableAllHooks() self.enabled = true end function Hook:LoadHookFile(filename) local split = function (str, delim, maxNb) -- Eliminate bad cases... if string.find(str, delim) == nil then return { str } end if maxNb == nil or maxNb < 1 then maxNb = 0 -- No limit end local result = {} local pat = "(.-)" .. delim .. "()" local nb = 0 local lastPos for part, pos in string.gfind(str, pat) do nb = nb + 1 result[nb] = part lastPos = pos if nb == maxNb then break end end -- Handle the last field if nb ~= maxNb then result[nb + 1] = string.sub(str, lastPos) end return result end file = assert(io.open(filename, "r")) for line in file:lines() do lineData = split(line, "|",3) -- Make sure original function is defined if (_G[lineData[2]] ~= nil) then -- Make sure target function is defined if (_G[lineData[3]] ~= nil) then if (lineData[1] == "REPLACE") then Hook:AddReplacementHook(lineData[2], _G[lineData[3]]) elseif (lineData[1] == "PRE") then Hook:AddPreHook(lineData[2], _G[lineData[3]], lineData[4]) elseif (lineData[1] == "POST") then Hook:AddPostHook(lineData[2], _G[lineData[3]], lineData[4]) else print("ERROR >> Hook:LoadHookFile() : Unrecongized type of hook ["..lineData[1].."] !!") end else print("ERROR >> Hook:LoadHookFile() : Function ["..lineData[3].."] is not defined !!") end else print("ERROR >> Hook:LoadHookFile() : Function ["..lineData[2].."] is not defined !!") end end io.close(file) end function Hook:SetHookPattern(pattern, hookType, hookFct, priority) -- make sure hook fct is defined if (hookFct == nil) then print("ERROR >> Hook:SetHookPattern() : Hook function is not defined ["..hookFct.."] !!") return end -- Browse global def list for key, value in pairs(_G) do -- Filter to retrieve only functions if (type(value) == "function") then -- Check the global function toward the provided pattern if (string.find(key, pattern) ~= nil) then if (hookType == "REPLACE") then Hook:AddReplacementHook(key, hookFct) elseif (hookType == "PRE") then Hook:AddPreHook(key, hookFct, priority) elseif (hookType == "POST") then Hook:AddPostHook(key, hookFct, priority) else print("ERROR >> Hook:SetHookPattern() : Unrecongized type of hook ["..hookType.."] !!") end end end end end -- PRIVATE function Hook:SortHooks(hookList) local compareFct = function (a,b) return a.order < b.order end table.sort(hookList, compareFct) end -Save it as hook.lua and put the file in "script/extension" if dont have folder "extension" then create one. -Load this code BEFORE the antidupe script dofile(GetResPath("script/extension/hook.lua"))
  19. Syntax

    Please wait teleporting

    the idea of teleport delay is to make dupe work a little bit harder, is not giving a fix for dupe. you can find function MoveCity or GoTo and replace it with original. and for anti-dupe there are many server files have it and they are public released that you can search.
  20. Syntax

    DC after got killed on ca or any map

    Ana did you check the player's map_x, map_y, map in dbo.character ? did you change/edit something on database? skill or look column ?
  21. Syntax

    DC after got killed on ca or any map

    -Where his spawn record? make sure the city where he is re-spawned available in birth.lua -If player re-spawned in sea it also having disconnect, check the coordinate of his last and then you can check where is he.
  22. Syntax

    Client no loading

    don't run directly from system folder, write this into txt file start system\Game.exe startgame save as .bat
  23. oh ok bro lets proof it, can you find any backdoor from this file? https://files.fm/u/v3dk6n22
  24. oh c'mon zizo or new zizo or w.e rofl you wont get even single penny by leeching or even hacking people work, you know what? you can't even create your own stuff you can't lie, people don't change bro!
  25. Syntax

    Looking for a partner

    @Simon I just joined the d e v a few mins ago and checking guide, release and such useful thing, everytime i saw your comment to other people post you're always reply the topics like asshole and i didn't see your post about guide or post that helping people, stop being a bitch! how you talk and comment like zizo or murad or one of them is you? anyway she mentioned 50% of the server benefit, good day and sorry if i hurt your feeling
×