Stoping the char creation so they have to be removed.
Capitals down the bottom.
USE [Telecaster]
GO
/****** Object: Table [dbo].[Character] Script Date: 04/12/2011 07:23:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[sid] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](61) NOT NULL,
[account] [varchar](60) NOT NULL,
[account_id] [int] NOT NULL,
[slot] [int] NOT NULL,
[x] [int] NOT NULL,
[y] [int] NOT NULL,
[z] [int] NOT NULL,
[layer] [int] NOT NULL,
[race] [int] NOT NULL,
[sex] [int] NOT NULL,
[exp] [bigint] NULL,
[last_decreased_exp] [bigint] NULL,
[lv] [int] NOT NULL,
[max_reached_level] [int] NOT NULL,
[hp] [int] NOT NULL,
[mp] [int] NOT NULL,
[stamina] [int] NOT NULL,
[havoc] [int] NOT NULL,
[jlv] [int] NOT NULL,
[jp] [int] NOT NULL,
[total_jp] [int] NOT NULL,
[job_0] [int] NOT NULL,
[job_1] [int] NOT NULL,
[job_2] [int] NOT NULL,
[jlv_0] [int] NOT NULL,
[jlv_1] [int] NOT NULL,
[jlv_2] [int] NOT NULL,
[immoral_point] [int] NOT NULL,
[cha] [int] NOT NULL,
[pkc] [int] NOT NULL,
[dkc] [int] NOT NULL,
[huntaholic_point] [int] NOT NULL,
[create_time] [datetime] NOT NULL,
[delete_time] [datetime] NOT NULL,
[login_time] [datetime] NOT NULL,
[logout_time] [datetime] NOT NULL,
[login_count] [int] NOT NULL,
[play_time] [int] NOT NULL,
[belt_00] [bigint] NOT NULL,
[belt_01] [bigint] NOT NULL,
[belt_02] [bigint] NOT NULL,
[belt_03] [bigint] NOT NULL,
[belt_04] [bigint] NOT NULL,
[belt_05] [bigint] NOT NULL,
[permission] [int] NOT NULL,
[skin_color] [int] NOT NULL,
[model_00] [int] NOT NULL,
[model_01] [int] NOT NULL,
[model_02] [int] NOT NULL,
[model_03] [int] NOT NULL,
[model_04] [int] NOT NULL,
[job] [int] NOT NULL,
[gold] [bigint] NOT NULL,
[party_id] [int] NOT NULL,
[guild_id] [int] NOT NULL,
[prev_guild_id] [int] NOT NULL,
[flag_list] [varchar](4000) NOT NULL,
[client_info] [varchar](2048) NOT NULL,
[job_depth] [int] NOT NULL,
[summon_0] [int] NOT NULL,
[summon_1] [int] NOT NULL,
[summon_2] [int] NOT NULL,
[summon_3] [int] NOT NULL,
[summon_4] [int] NOT NULL,
[summon_5] [int] NOT NULL,
[main_summon] [int] NOT NULL,
[sub_summon] [int] NOT NULL,
[remain_summon_time] [int] NOT NULL,
[pet] [int] NOT NULL,
[chaos] [int] NOT NULL,
[adv_chat_count] [int] NOT NULL,
[name_changed] [int] NOT NULL,
[auto_used] [int] NOT NULL,
[guild_block_time] [bigint] NOT NULL,
[pkmode] [tinyint] NOT NULL,
[otp_value] [int] NOT NULL,
[otp_date] [datetime] NOT NULL,
[chat_block_time] [int] NOT NULL,
CONSTRAINT [PK_IDX_Avatar] PRIMARY KEY NONCLUSTERED
(
[sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
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