fixed. change this
CREATE TABLE [dbo].[user_account](
[uid] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](14) NOT NULL,
[pay_stat] [smallint] NOT NULL CONSTRAINT [DF_user_account__pay_stat] DEFAULT ((0)),
[login_flag] [int] NOT NULL CONSTRAINT [DF_user_account__login_flag] DEFAULT ((0)),
[warn_flag] [int] NOT NULL CONSTRAINT [DF_user_account__warn_flag] DEFAULT ((0)),
[block_flag] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag] DEFAULT ((0)),
[block_flag2] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag2] DEFAULT ((0)),
[last_login] [datetime] NULL,
[confirmation] [varchar] (15) NULL,
[last_logout] [datetime] NULL,
[subscription_flag] [int] NOT NULL CONSTRAINT [DF_user_account_subscription_flag] DEFAULT ((0)),
[last_game] [int] NULL,
[last_world] [int] NULL,
[last_ip] [varchar](15) NULL,
[block_end_date] [datetime] NULL,
[forbidden_servers] [binary](16) NULL CONSTRAINT [DF_user_account_forbidden_servers] DEFAULT ((0)),
[email] [varchar] (50) NOT NULL DEFAULT 'invalid@email.com',
[mask] [varchar] (15) NOT NULL DEFAULT '*'
CONSTRAINT [PK_user_account] PRIMARY KEY CLUSTERED
(
[account] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UQ_user_account_uid] UNIQUE NONCLUSTERED
(
[uid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
to this:
CREATE TABLE [dbo].[user_account](
[uid] [int] IDENTITY(1,1) NOT NULL,
[account] varchar(14) COLLATE Korean_Wansung_CI_AS NOT NULL,
[pay_stat] [smallint] NOT NULL CONSTRAINT [DF_user_account__pay_stat] DEFAULT ((0)),
[login_flag] [int] NOT NULL CONSTRAINT [DF_user_account__login_flag] DEFAULT ((0)),
[warn_flag] [int] NOT NULL CONSTRAINT [DF_user_account__warn_flag] DEFAULT ((0)),
[block_flag] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag] DEFAULT ((0)),
[block_flag2] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag2] DEFAULT ((0)),
[last_login] [datetime] NULL,
[confirmation] [varchar] (15) NULL,
[last_logout] [datetime] NULL,
[subscription_flag] [int] NOT NULL CONSTRAINT [DF_user_account_subscription_flag] DEFAULT ((0)),
[last_game] [int] NULL,
[last_world] [int] NULL,
[last_ip] varchar(15) COLLATE Korean_Wansung_CI_AS NULL,
[block_end_date] [datetime] NULL,
[forbidden_servers] [binary](16) NULL CONSTRAINT [DF_user_account_forbidden_servers] DEFAULT ((0)),
[email] [varchar] (50) NOT NULL DEFAULT 'invalid@email.com',
[mask] [varchar] (15) NOT NULL DEFAULT '*'
CONSTRAINT [PK_user_account] PRIMARY KEY CLUSTERED
(
[account] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UQ_user_account_uid] UNIQUE NONCLUSTERED
(
[uid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]