Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation on 11/27/2017 in Posts

  1. 1 point
    возможно тут вот выдернул из архива kopupdate
  2. 1 point
    skillinfo здесь вообще не причем. Крылья со статами это полностью как плащи за 1 исключением в skilleff 1 запись и вместо номера эффекта 0. Создается предмет, на нем в интеминфо рисуются статы, в skilleff добавляется строка с State_что-то_Add (добавить) State_что-то_Rem(забрать), далее в skilleffect прописываем теже эффекты что и в интеминфо. Прописываем в variable STATE_что-то = номеру эффекта в skilleff. Далее в function делаем проверку на нахождение крыльев в нужном слоте и добавляем эффект STATE_что-то. Собственно и всё
  3. 1 point
    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
  • Newsletter

    Want to keep up to date with all our latest news and information?
    Sign Up
×
×
  • Create New...