ls-2019-source/sql/20120504/lostsaga_tb.sql

USE [LosaGame]
GO
/****** 개체:  Table [dbo].[userRecordBattleDB]    스크립트 날짜: 05/04/2012 14:01:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRecordBattleDB](
	[accountIDX] [int] NOT NULL,
	[type1_win] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type1_win]  DEFAULT ((0)),
	[type1_lose] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type1_lose]  DEFAULT ((0)),
	[type1_kill] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type1_kill]  DEFAULT ((0)),
	[type1_death] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type1_death]  DEFAULT ((0)),
	[type2_win] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type2_win]  DEFAULT ((0)),
	[type2_lose] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type2_lose]  DEFAULT ((0)),
	[type2_kill] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type2_kill]  DEFAULT ((0)),
	[type2_death] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type2_death]  DEFAULT ((0)),
	[type3_win] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type3_win]  DEFAULT ((0)),
	[type3_lose] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type3_lose]  DEFAULT ((0)),
	[type3_kill] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type3_kill]  DEFAULT ((0)),
	[type3_death] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type3_death]  DEFAULT ((0)),
	[type4_win] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type4_win]  DEFAULT ((0)),
	[type4_lose] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type4_lose]  DEFAULT ((0)),
	[type4_kill] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type4_kill]  DEFAULT ((0)),
	[type4_death] [int] NOT NULL CONSTRAINT [DF_userRecordBattleDB_type4_death]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRecordBattleDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userRecordGuildDB]    스크립트 날짜: 05/04/2012 14:01:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRecordGuildDB](
	[guildIDX] [int] NOT NULL,
	[type1_win] [int] NOT NULL CONSTRAINT [DF_userRecordGuildDB_type1_win]  DEFAULT ((0)),
	[type1_lose] [int] NOT NULL CONSTRAINT [DF_userRecordGuildDB_type1_lose]  DEFAULT ((0)),
	[type1_kill] [int] NOT NULL CONSTRAINT [DF_userRecordGuildDB_type1_kill]  DEFAULT ((0)),
	[type1_death] [int] NOT NULL CONSTRAINT [DF_userRecordGuildDB_type1_death]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRecordGuildDB_regDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_userRecordGuildDB] PRIMARY KEY CLUSTERED 
(
	[guildIDX] 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
/****** 개체:  Table [dbo].[z_nouse_userRankingDB_class]    스크립트 날짜: 05/04/2012 14:03:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userRankingDB_class](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[class1] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_iron]  DEFAULT ((0)),
	[class2] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_hook]  DEFAULT ((0)),
	[class3] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_western]  DEFAULT ((0)),
	[class4] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_fire]  DEFAULT ((0)),
	[class5] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_cyber]  DEFAULT ((0)),
	[class6] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_berserker]  DEFAULT ((0)),
	[class7] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_robinhood]  DEFAULT ((0)),
	[class8] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_crazy]  DEFAULT ((0)),
	[class9] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_ice]  DEFAULT ((0)),
	[class10] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_army]  DEFAULT ((0)),
	[class11] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_spaces]  DEFAULT ((0)),
	[class12] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_shadow]  DEFAULT ((0)),
	[class13] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_victory]  DEFAULT ((0)),
	[class14] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_guanyu]  DEFAULT ((0)),
	[class15] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_class15]  DEFAULT ((0)),
	[class16] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_class16]  DEFAULT ((0)),
	[class17] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_class17]  DEFAULT ((0)),
	[class18] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_class18]  DEFAULT ((0)),
	[class19] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_class19]  DEFAULT ((0)),
	[class20] [int] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_class20]  DEFAULT ((0)),
	[regDate] [smalldatetime] NOT NULL CONSTRAINT [DF_userRankingDB_class_each_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_Log_play_web]    스크립트 날짜: 05/04/2012 14:01:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_Log_play_web](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[userID] [varchar](12) NULL,
	[userIP] [varchar](15) NOT NULL,
	[logType] [tinyint] NOT NULL,
	[note] [varchar](200) NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_Log_play_web_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[define_game_server]    스크립트 날짜: 05/04/2012 13:56:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[define_game_server](
	[idx] [int] NOT NULL,
	[serverID] [bigint] NOT NULL CONSTRAINT [DF__define_ga__serve__22AA2996]  DEFAULT ((0)),
	[serverIP] [varchar](15) NOT NULL,
	[serverPort] [int] NOT NULL,
	[serverName] [varchar](50) NULL,
	[clientPort] [int] NOT NULL,
	[connNumber] [int] NOT NULL CONSTRAINT [DF__define_ga__connN__239E4DCF]  DEFAULT ((0)),
	[status] [tinyint] NOT NULL CONSTRAINT [DF_define_gameserverDB_status]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF__define_ga__regDa__24927208]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userNameDB]    스크립트 날짜: 05/04/2012 14:00:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userNameDB](
	[accountIDX] [int] NOT NULL,
	[userName] [varchar](10) NOT NULL,
	[userBirthday] [char](6) NOT NULL,
	[userJumin1] [char](12) NULL,
	[userJumin2] [char](14) NULL,
	[userEnCode] [varchar](64) NOT NULL,
	[userNumber] [tinyint] NOT NULL,
	[userGender] [tinyint] NOT NULL,
	[returnValue] [tinyint] NOT NULL,
	[userIP] [varchar](15) NULL,
	[realType] [tinyint] NOT NULL CONSTRAINT [DF_userNameDB_realType]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userNameDB_regDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_userNameDB] PRIMARY KEY CLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[userItemDB]    스크립트 날짜: 05/04/2012 13:58:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userItemDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[item1_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__0E6E26BF]  DEFAULT (0),
	[item1_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__0D7A0286]  DEFAULT (0),
	[item2_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item2__114A936A]  DEFAULT (0),
	[item2_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item2__10566F31]  DEFAULT (0),
	[item3_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item3__14270015]  DEFAULT (0),
	[item3_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item3__1332DBDC]  DEFAULT (0),
	[item4_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item4__17036CC0]  DEFAULT (0),
	[item4_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item4__160F4887]  DEFAULT (0),
	[item5_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item5__19DFD96B]  DEFAULT (0),
	[item5_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item5__18EBB532]  DEFAULT (0),
	[item6_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item6__1CBC4616]  DEFAULT (0),
	[item6_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item6__1BC821DD]  DEFAULT (0),
	[item7_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item7__1F98B2C1]  DEFAULT (0),
	[item7_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item7__1EA48E88]  DEFAULT (0),
	[item8_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item8__22751F6C]  DEFAULT (0),
	[item8_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item8__2180FB33]  DEFAULT (0),
	[item9_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item9__25518C17]  DEFAULT (0),
	[item9_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item9__245D67DE]  DEFAULT (0),
	[item10_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__282DF8C2]  DEFAULT (0),
	[item10_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__2739D489]  DEFAULT (0),
	[item11_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__2B0A656D]  DEFAULT (0),
	[item11_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__2A164134]  DEFAULT (0),
	[item12_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__2DE6D218]  DEFAULT (0),
	[item12_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__2CF2ADDF]  DEFAULT (0),
	[item13_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__30C33EC3]  DEFAULT (0),
	[item13_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__2FCF1A8A]  DEFAULT (0),
	[item14_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__339FAB6E]  DEFAULT (0),
	[item14_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__32AB8735]  DEFAULT (0),
	[item15_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__367C1819]  DEFAULT (0),
	[item15_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__3587F3E0]  DEFAULT (0),
	[item16_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__395884C4]  DEFAULT (0),
	[item16_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__3864608B]  DEFAULT (0),
	[item17_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__3C34F16F]  DEFAULT (0),
	[item17_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__3B40CD36]  DEFAULT (0),
	[item18_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__3F115E1A]  DEFAULT (0),
	[item18_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__3E1D39E1]  DEFAULT (0),
	[item19_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__41EDCAC5]  DEFAULT (0),
	[item19_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item1__40F9A68C]  DEFAULT (0),
	[item20_type] [int] NOT NULL CONSTRAINT [DF__userItemD__item2__44CA3770]  DEFAULT (0),
	[item20_code] [int] NOT NULL CONSTRAINT [DF__userItemD__item2__43D61337]  DEFAULT (0)
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_define_medal]    스크립트 날짜: 05/04/2012 14:01:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_define_medal](
	[idx] [int] NOT NULL,
	[medalCode] [int] NOT NULL,
	[eng_name] [varchar](8) NOT NULL,
	[point] [int] NOT NULL,
	[title] [varchar](32) NOT NULL,
	[content1] [varchar](200) NOT NULL,
	[content2] [varchar](200) NOT NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_define_medal_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userMedalDB_receive]    스크립트 날짜: 05/04/2012 13:59:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userMedalDB_receive](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[medalIDX] [int] NOT NULL,
	[flag] [tinyint] NOT NULL CONSTRAINT [DF_userMedalDB_receive_flag]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userMedalDB_receive_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userGameDB]    스크립트 날짜: 05/04/2012 13:58:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userGameDB](
	[accountIDX] [int] NOT NULL,
	[userState] [int] NOT NULL CONSTRAINT [DF__userGameD__userS__01142BA1]  DEFAULT ((0)),
	[gameMoney] [bigint] NOT NULL CONSTRAINT [DF__userGameD__gameM__02084FDA]  DEFAULT ((0)),
	[playTime] [int] NOT NULL CONSTRAINT [DF_userGameDB_playedTime]  DEFAULT ((0)),
	[conn_count] [int] NOT NULL CONSTRAINT [DF__userGameD__cnt_c__02FC7413]  DEFAULT ((0)),
	[userLevel] [int] NOT NULL CONSTRAINT [DF_userGameDB_userLevel]  DEFAULT ((0)),
	[userEXP] [int] NOT NULL CONSTRAINT [DF_userGameDB_userEXP]  DEFAULT ((0)),
	[userFishingLevel] [int] NOT NULL CONSTRAINT [DF_userGameDB_userFishingLevel]  DEFAULT ((0)),
	[userFishingEXP] [int] NOT NULL CONSTRAINT [DF_userGameDB_userFishingEXP]  DEFAULT ((0)),
	[userExcavationLevel] [int] NOT NULL CONSTRAINT [DF_userGameDB_userExcavationLevel]  DEFAULT ((0)),
	[userExcavationEXP] [int] NOT NULL CONSTRAINT [DF_userGameDB_userExcavationEXP]  DEFAULT ((0)),
	[userHerocEXP] [int] NOT NULL CONSTRAINT [DF_userGameDB_userHerocEXP]  DEFAULT ((0)),
	[userHerosEXP] [int] NOT NULL CONSTRAINT [DF_userGameDB_userHerosEXP]  DEFAULT ((0)),
	[rencpoint] [int] NOT NULL CONSTRAINT [DF_userGameDB_ladderpoint]  DEFAULT ((0)),
	[renspoint] [int] NOT NULL CONSTRAINT [DF_userGameDB_renspoint]  DEFAULT ((0)),
	[relateLevel] [int] NOT NULL CONSTRAINT [DF_userGameDB_relateLevel]  DEFAULT ((0)),
	[regionType] [int] NOT NULL CONSTRAINT [DF_userGameDB_regionType]  DEFAULT ((0)),
	[refillData] [int] NOT NULL CONSTRAINT [DF_userGameDB_pcroomDate]  DEFAULT ((19990101)),
	[connDate] [datetime] NOT NULL CONSTRAINT [DF__userGameD__connD__09A971A2]  DEFAULT (getdate()),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF__userGameD__regDa__0A9D95DB]  DEFAULT (getdate()),
 CONSTRAINT [PK_userGameDB_1] PRIMARY KEY CLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[define_encode_key]    스크립트 날짜: 05/04/2012 13:56:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[define_encode_key](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[encodeKey] [char](15) NOT NULL,
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[z_nouse_userRankingDB_training]    스크립트 날짜: 05/04/2012 14:03:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userRankingDB_training](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[win_fix] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_win_fix]  DEFAULT ((0)),
	[tie_fix] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_tie_fix]  DEFAULT ((0)),
	[lose_fix] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_lose_fix]  DEFAULT ((0)),
	[win_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_win_prev]  DEFAULT ((0)),
	[tie_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_tie_prev]  DEFAULT ((0)),
	[lose_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_lose_prev]  DEFAULT ((0)),
	[rank_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_rank_prev]  DEFAULT ((0)),
	[rank_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_rank_now]  DEFAULT ((0)),
	[rank_total] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_rank_total]  DEFAULT ((0)),
	[rank_training] [int] NOT NULL CONSTRAINT [DF_userRankingDB_training_rank_battle]  DEFAULT ((0)),
	[regDate] [smalldatetime] NOT NULL CONSTRAINT [DF_userRankingDB_training_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[gameAnnounce]    스크립트 날짜: 05/04/2012 13:56:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gameAnnounce](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[content] [text] NOT NULL,
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[define_site_config]    스크립트 날짜: 05/04/2012 13:56:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[define_site_config](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[objName] [varchar](32) NOT NULL,
	[content] [varchar](32) NOT NULL,
	[note] [varchar](300) NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_define_site_config_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[define_config]    스크립트 날짜: 05/04/2012 13:56:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[define_config](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[objName] [varchar](32) NOT NULL,
	[value1] [varchar](200) NOT NULL,
	[value2] [varchar](200) NULL,
	[value3] [varchar](200) NULL,
	[value4] [varchar](200) NULL,
	[value5] [varchar](200) NULL,
	[note] [varchar](200) NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_define_config_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[event_chuchun]    스크립트 날짜: 05/04/2012 13:56:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[event_chuchun](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[friendIDX] [int] NOT NULL,
	[flag] [tinyint] NOT NULL CONSTRAINT [DF_event_chuchun_flag]  DEFAULT ((0)),
	[userIP] [varchar](15) NOT NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_event_chuchun_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userGuildDB]    스크립트 날짜: 05/04/2012 13:58:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userGuildDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[guildName] [varchar](20) NOT NULL,
	[aboutguild] [varchar](110) NOT NULL,
	[guildmark] [int] NOT NULL,
	[ranking] [int] NOT NULL CONSTRAINT [DF_userGuildDB_ranking]  DEFAULT ((0)),
	[point] [int] NOT NULL CONSTRAINT [DF_userGuildDB_point]  DEFAULT ((0)),
	[todaypoint] [int] NOT NULL CONSTRAINT [DF_userGuildDB_todaypoint]  DEFAULT ((0)),
	[guildLevel] [int] NOT NULL CONSTRAINT [DF_userGuildDB_guildLevel]  DEFAULT ((0)),
	[maxcount] [int] NOT NULL CONSTRAINT [DF_userGuildDB_maxcount]  DEFAULT ((0)),
	[membercount] [int] NOT NULL CONSTRAINT [DF_userGuildDB_membercount]  DEFAULT ((0)),
	[regionType] [int] NOT NULL CONSTRAINT [DF_userGuildDB_regionType]  DEFAULT ((0)),
	[today_vc] [int] NOT NULL CONSTRAINT [DF_userGuildDB_today_vc]  DEFAULT ((0)),
	[total_vc] [int] NOT NULL CONSTRAINT [DF_userGuildDB_total_vc]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userGuildDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userQuestCompleteDB]    스크립트 날짜: 05/04/2012 14:00:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userQuestCompleteDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[quest1_type] [int] NOT NULL DEFAULT ((0)),
	[quest1_time] [int] NOT NULL DEFAULT ((0)),
	[quest2_type] [int] NOT NULL DEFAULT ((0)),
	[quest2_time] [int] NOT NULL DEFAULT ((0)),
	[quest3_type] [int] NOT NULL DEFAULT ((0)),
	[quest3_time] [int] NOT NULL DEFAULT ((0)),
	[quest4_type] [int] NOT NULL DEFAULT ((0)),
	[quest4_time] [int] NOT NULL DEFAULT ((0)),
	[quest5_type] [int] NOT NULL DEFAULT ((0)),
	[quest5_time] [int] NOT NULL DEFAULT ((0)),
	[quest6_type] [int] NOT NULL DEFAULT ((0)),
	[quest6_time] [int] NOT NULL DEFAULT ((0)),
	[quest7_type] [int] NOT NULL DEFAULT ((0)),
	[quest7_time] [int] NOT NULL DEFAULT ((0)),
	[quest8_type] [int] NOT NULL DEFAULT ((0)),
	[quest8_time] [int] NOT NULL DEFAULT ((0)),
	[quest9_type] [int] NOT NULL DEFAULT ((0)),
	[quest9_time] [int] NOT NULL DEFAULT ((0)),
	[quest10_type] [int] NOT NULL DEFAULT ((0)),
	[quest10_time] [int] NOT NULL DEFAULT ((0)),
	[quest11_type] [int] NOT NULL DEFAULT ((0)),
	[quest11_time] [int] NOT NULL DEFAULT ((0)),
	[quest12_type] [int] NOT NULL DEFAULT ((0)),
	[quest12_time] [int] NOT NULL DEFAULT ((0)),
	[quest13_type] [int] NOT NULL DEFAULT ((0)),
	[quest13_time] [int] NOT NULL DEFAULT ((0)),
	[quest14_type] [int] NOT NULL DEFAULT ((0)),
	[quest14_time] [int] NOT NULL DEFAULT ((0)),
	[quest15_type] [int] NOT NULL DEFAULT ((0)),
	[quest15_time] [int] NOT NULL DEFAULT ((0)),
	[quest16_type] [int] NOT NULL DEFAULT ((0)),
	[quest16_time] [int] NOT NULL DEFAULT ((0)),
	[quest17_type] [int] NOT NULL DEFAULT ((0)),
	[quest17_time] [int] NOT NULL DEFAULT ((0)),
	[quest18_type] [int] NOT NULL DEFAULT ((0)),
	[quest18_time] [int] NOT NULL DEFAULT ((0)),
	[quest19_type] [int] NOT NULL DEFAULT ((0)),
	[quest19_time] [int] NOT NULL DEFAULT ((0)),
	[quest20_type] [int] NOT NULL DEFAULT ((0)),
	[quest20_time] [int] NOT NULL DEFAULT ((0)),
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userItemMedalExtendDB]    스크립트 날짜: 05/04/2012 13:59:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userItemMedalExtendDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[medal1_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal1_class]  DEFAULT ((0)),
	[medal1_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal1_slot]  DEFAULT ((0)),
	[medal1_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal1_period]  DEFAULT ((0)),
	[medal2_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal2_class]  DEFAULT ((0)),
	[medal2_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal2_slot]  DEFAULT ((0)),
	[medal2_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal2_period]  DEFAULT ((0)),
	[medal3_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal3_class]  DEFAULT ((0)),
	[medal3_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal3_slot]  DEFAULT ((0)),
	[medal3_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal3_period]  DEFAULT ((0)),
	[medal4_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal4_class]  DEFAULT ((0)),
	[medal4_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal4_slot]  DEFAULT ((0)),
	[medal4_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal4_period]  DEFAULT ((0)),
	[medal5_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal5_class]  DEFAULT ((0)),
	[medal5_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal5_slot]  DEFAULT ((0)),
	[medal5_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal5_period]  DEFAULT ((0)),
	[medal6_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal6_class]  DEFAULT ((0)),
	[medal6_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal6_slot]  DEFAULT ((0)),
	[medal6_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal6_period]  DEFAULT ((0)),
	[medal7_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal7_class]  DEFAULT ((0)),
	[medal7_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal7_slot]  DEFAULT ((0)),
	[medal7_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal7_period]  DEFAULT ((0)),
	[medal8_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal8_class]  DEFAULT ((0)),
	[medal8_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal8_slot]  DEFAULT ((0)),
	[medal8_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal8_period]  DEFAULT ((0)),
	[medal9_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal9_class]  DEFAULT ((0)),
	[medal9_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal9_slot]  DEFAULT ((0)),
	[medal9_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal9_period]  DEFAULT ((0)),
	[medal10_class] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal10_class]  DEFAULT ((0)),
	[medal10_slot] [tinyint] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal10_slot]  DEFAULT ((0)),
	[medal10_period] [int] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_medal10_period]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userItemMedalExtendDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userTradeDB]    스크립트 날짜: 05/04/2012 14:01:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userTradeDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[itemType] [int] NOT NULL CONSTRAINT [DF__userTrade__itemT__35F2D38B]  DEFAULT ((0)),
	[value1] [int] NOT NULL CONSTRAINT [DF__userTrade__value__36E6F7C4]  DEFAULT ((0)),
	[value2] [int] NOT NULL CONSTRAINT [DF__userTrade__value__37DB1BFD]  DEFAULT ((0)),
	[price] [bigint] NOT NULL CONSTRAINT [DF__userTrade__price__38CF4036]  DEFAULT ((0)),
	[mcustom] [int] NOT NULL CONSTRAINT [DF_userTradeDB_mcustom]  DEFAULT ((0)),
	[fcustom] [int] NOT NULL CONSTRAINT [DF_userTradeDB_fcustom]  DEFAULT ((0)),
	[userIP] [varchar](16) NULL,
	[periodDate] [int] NOT NULL CONSTRAINT [DF__userTrade__perio__39C3646F]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF__userTrade__regDa__3AB788A8]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[z_nouse_userCashDB]    스크립트 날짜: 05/04/2012 14:01:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userCashDB](
	[accountIDX] [int] NOT NULL,
	[amtCash] [int] NOT NULL,
	[amtBonus] [int] NOT NULL,
	[amtLimit] [int] NOT NULL,
	[amtSum] [int] NOT NULL,
	[chgDate] [datetime] NOT NULL,
	[regDate] [datetime] NOT NULL,
 CONSTRAINT [PK_userCashDB] PRIMARY KEY CLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[userFishDB]    스크립트 날짜: 05/04/2012 13:58:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userFishDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[fish1_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish1_type]  DEFAULT ((0)),
	[fish1_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish1_an]  DEFAULT ((0)),
	[fish2_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish2_type]  DEFAULT ((0)),
	[fish2_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish2_an]  DEFAULT ((0)),
	[fish3_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish3_type]  DEFAULT ((0)),
	[fish3_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish3_an]  DEFAULT ((0)),
	[fish4_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish4_type]  DEFAULT ((0)),
	[fish4_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish4_an]  DEFAULT ((0)),
	[fish5_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish5_type]  DEFAULT ((0)),
	[fish5_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish5_an]  DEFAULT ((0)),
	[fish6_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish6_type]  DEFAULT ((0)),
	[fish6_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish6_an]  DEFAULT ((0)),
	[fish7_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish7_type]  DEFAULT ((0)),
	[fish7_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish7_an]  DEFAULT ((0)),
	[fish8_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish8_type]  DEFAULT ((0)),
	[fish8_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish8_an]  DEFAULT ((0)),
	[fish9_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish9_type]  DEFAULT ((0)),
	[fish9_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish9_an]  DEFAULT ((0)),
	[fish10_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish10_type]  DEFAULT ((0)),
	[fish10_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish10_an]  DEFAULT ((0)),
	[fish11_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish11_type]  DEFAULT ((0)),
	[fish11_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish11_an]  DEFAULT ((0)),
	[fish12_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish12_type]  DEFAULT ((0)),
	[fish12_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish12_an]  DEFAULT ((0)),
	[fish13_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish13_type]  DEFAULT ((0)),
	[fish13_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish13_an]  DEFAULT ((0)),
	[fish14_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish14_type]  DEFAULT ((0)),
	[fish14_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish14_an]  DEFAULT ((0)),
	[fish15_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish15_type]  DEFAULT ((0)),
	[fish15_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish15_an]  DEFAULT ((0)),
	[fish16_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish16_type]  DEFAULT ((0)),
	[fish16_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish16_an]  DEFAULT ((0)),
	[fish17_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish17_type]  DEFAULT ((0)),
	[fish17_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish17_an]  DEFAULT ((0)),
	[fish18_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish18_type]  DEFAULT ((0)),
	[fish18_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish18_an]  DEFAULT ((0)),
	[fish19_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish19_type]  DEFAULT ((0)),
	[fish19_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish19_an]  DEFAULT ((0)),
	[fish20_type] [tinyint] NOT NULL CONSTRAINT [DF_userFishDB_fish20_type]  DEFAULT ((0)),
	[fish20_an] [int] NOT NULL CONSTRAINT [DF_userFishDB_fish20_an]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userFishDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userCooperationDB]    스크립트 날짜: 05/04/2012 13:57:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userCooperationDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[userID] [varchar](12) NOT NULL,
	[cpIDX] [int] NULL,
	[cpID] [varchar](32) NOT NULL,
	[cpType] [smallint] NOT NULL,
	[note] [varchar](100) NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userCooperationDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userRankingDB_medal]    스크립트 날짜: 05/04/2012 14:01:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRankingDB_medal](
	[accountIDX] [int] NOT NULL,
	[medalLevel] [int] NOT NULL CONSTRAINT [DF_userRankingDB_medal_medalLevel]  DEFAULT ((0)),
	[expert] [int] NOT NULL CONSTRAINT [DF_userRankingDB_medal_expert]  DEFAULT ((0)),
	[ranking_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_medal_ranking_prev]  DEFAULT ((0)),
	[ranking_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_medal_ranking_now]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRankingDB_medal_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userPresentDB]    스크립트 날짜: 05/04/2012 14:00:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userPresentDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[sendIDX] [int] NOT NULL,
	[receiveIDX] [int] NOT NULL,
	[presentType] [smallint] NOT NULL CONSTRAINT [DF_userPresentDB_presentType]  DEFAULT ((0)),
	[value1] [int] NOT NULL CONSTRAINT [DF_userPresentDB_value1]  DEFAULT ((0)),
	[value2] [int] NOT NULL CONSTRAINT [DF_userPresentDB_value2]  DEFAULT ((0)),
	[value3] [int] NOT NULL CONSTRAINT [DF_userPresentDB_value3]  DEFAULT ((0)),
	[value4] [int] NOT NULL CONSTRAINT [DF_userPresentDB_value4]  DEFAULT ((0)),
	[msgType] [smallint] NOT NULL,
	[flag] [smallint] NOT NULL CONSTRAINT [DF_userPresentDB_flag]  DEFAULT ((0)),
	[limitDate] [datetime] NOT NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userPresentDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userConfigDB]    스크립트 날짜: 05/04/2012 13:57:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userConfigDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[keyvalue] [varchar](200) NOT NULL,
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userConfigDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[z_nouse_userRankingDB_tmp]    스크립트 날짜: 05/04/2012 14:03:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_userRankingDB_tmp](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[userID] [varchar](12) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[z_nouse_userItemIdentityDB]    스크립트 날짜: 05/04/2012 14:02:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userItemIdentityDB](
	[idx] [bigint] NOT NULL
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userRankingDB_hero]    스크립트 날짜: 05/04/2012 14:01:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRankingDB_hero](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[title] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_title]  DEFAULT ((0)),
	[daily] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_daily]  DEFAULT ((0)),
	[dailyB] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_dailyB]  DEFAULT ((0)),
	[season1] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_season1]  DEFAULT ((0)),
	[season2] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_season2]  DEFAULT ((0)),
	[season3] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_season3]  DEFAULT ((0)),
	[season4] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_season4]  DEFAULT ((0)),
	[season5] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_season5]  DEFAULT ((0)),
	[season6] [int] NOT NULL CONSTRAINT [DF_userRankingDB_hero_season6]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRankingDB_hero_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userAwardDB]    스크립트 날짜: 05/04/2012 13:57:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userAwardDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL DEFAULT (0),
	[award1_type] [int] NOT NULL DEFAULT (0),
	[award1_number] [int] NOT NULL DEFAULT (0),
	[award1_point] [int] NOT NULL DEFAULT (0),
	[award2_type] [int] NOT NULL DEFAULT (0),
	[award2_number] [int] NOT NULL DEFAULT (0),
	[award2_point] [int] NOT NULL DEFAULT (0),
	[award3_type] [int] NOT NULL DEFAULT (0),
	[award3_number] [int] NOT NULL DEFAULT (0),
	[award3_point] [int] NOT NULL DEFAULT (0),
	[award4_type] [int] NOT NULL DEFAULT (0),
	[award4_number] [int] NOT NULL DEFAULT (0),
	[award4_point] [int] NOT NULL DEFAULT (0),
	[award5_type] [int] NOT NULL DEFAULT (0),
	[award5_number] [int] NOT NULL DEFAULT (0),
	[award5_point] [int] NOT NULL DEFAULT (0),
	[award6_type] [int] NOT NULL DEFAULT (0),
	[award6_number] [int] NOT NULL DEFAULT (0),
	[award6_point] [int] NOT NULL DEFAULT (0),
	[award7_type] [int] NOT NULL DEFAULT (0),
	[award7_number] [int] NOT NULL DEFAULT (0),
	[award7_point] [int] NOT NULL DEFAULT (0),
	[award8_type] [int] NOT NULL DEFAULT (0),
	[award8_number] [int] NOT NULL DEFAULT (0),
	[award8_point] [int] NOT NULL DEFAULT (0),
	[award9_type] [int] NOT NULL DEFAULT (0),
	[award9_number] [int] NOT NULL DEFAULT (0),
	[award9_point] [int] NOT NULL DEFAULT (0),
	[award10_type] [int] NOT NULL DEFAULT (0),
	[award10_number] [int] NOT NULL DEFAULT (0),
	[award10_point] [int] NOT NULL DEFAULT (0),
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userItemMedalDB]    스크립트 날짜: 05/04/2012 13:59:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userItemMedalDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[item1_type] [int] NOT NULL DEFAULT ((0)),
	[item1_class] [int] NOT NULL DEFAULT ((0)),
	[item1_limitType] [int] NOT NULL DEFAULT ((0)),
	[item1_limitDate] [datetime] NOT NULL,
	[item2_type] [int] NOT NULL DEFAULT ((0)),
	[item2_class] [int] NOT NULL DEFAULT ((0)),
	[item2_limitType] [int] NOT NULL DEFAULT ((0)),
	[item2_limitDate] [datetime] NOT NULL,
	[item3_type] [int] NOT NULL DEFAULT ((0)),
	[item3_class] [int] NOT NULL DEFAULT ((0)),
	[item3_limitType] [int] NOT NULL DEFAULT ((0)),
	[item3_limitDate] [datetime] NOT NULL,
	[item4_type] [int] NOT NULL DEFAULT ((0)),
	[item4_class] [int] NOT NULL DEFAULT ((0)),
	[item4_limitType] [int] NOT NULL DEFAULT ((0)),
	[item4_limitDate] [datetime] NOT NULL,
	[item5_type] [int] NOT NULL DEFAULT ((0)),
	[item5_class] [int] NOT NULL DEFAULT ((0)),
	[item5_limitType] [int] NOT NULL DEFAULT ((0)),
	[item5_limitDate] [datetime] NOT NULL,
	[item6_type] [int] NOT NULL DEFAULT ((0)),
	[item6_class] [int] NOT NULL DEFAULT ((0)),
	[item6_limitType] [int] NOT NULL DEFAULT ((0)),
	[item6_limitDate] [datetime] NOT NULL,
	[item7_type] [int] NOT NULL DEFAULT ((0)),
	[item7_class] [int] NOT NULL DEFAULT ((0)),
	[item7_limitType] [int] NOT NULL DEFAULT ((0)),
	[item7_limitDate] [datetime] NOT NULL,
	[item8_type] [int] NOT NULL DEFAULT ((0)),
	[item8_class] [int] NOT NULL DEFAULT ((0)),
	[item8_limitType] [int] NOT NULL DEFAULT ((0)),
	[item8_limitDate] [datetime] NOT NULL,
	[item9_type] [int] NOT NULL DEFAULT ((0)),
	[item9_class] [int] NOT NULL DEFAULT ((0)),
	[item9_limitType] [int] NOT NULL DEFAULT ((0)),
	[item9_limitDate] [datetime] NOT NULL,
	[item10_type] [int] NOT NULL DEFAULT ((0)),
	[item10_class] [int] NOT NULL DEFAULT ((0)),
	[item10_limitType] [int] NOT NULL DEFAULT ((0)),
	[item10_limitDate] [datetime] NOT NULL,
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_userRankingDB_award_tmp]    스크립트 날짜: 05/04/2012 14:03:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_userRankingDB_award_tmp](
	[userID] [varchar](12) NOT NULL,
	[expert] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userFriendBestDB]    스크립트 날짜: 05/04/2012 13:58:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userFriendBestDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[friendIDX] [int] NOT NULL,
	[flag] [int] NOT NULL CONSTRAINT [DF_userFriendBestDB_flag]  DEFAULT ((0)),
	[flagTime] [int] NOT NULL CONSTRAINT [DF_userFriendBestDB_flagTime]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userFriendBestDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_userQuestDB]    스크립트 날짜: 05/04/2012 14:03:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userQuestDB](
	[accountIDX] [int] NOT NULL,
	[quest1_idx] [int] NOT NULL DEFAULT (0),
	[quest1_val1] [int] NOT NULL DEFAULT (0),
	[quest1_val2] [int] NOT NULL DEFAULT (0),
	[quest1_val3] [int] NOT NULL DEFAULT (0),
	[quest1_val4] [int] NOT NULL DEFAULT (0),
	[quest2_idx] [int] NOT NULL DEFAULT (0),
	[quest2_val1] [int] NOT NULL DEFAULT (0),
	[quest2_val2] [int] NOT NULL DEFAULT (0),
	[quest2_val3] [int] NOT NULL DEFAULT (0),
	[quest2_val4] [int] NOT NULL DEFAULT (0),
	[quest3_idx] [int] NOT NULL DEFAULT (0),
	[quest3_val1] [int] NOT NULL DEFAULT (0),
	[quest3_val2] [int] NOT NULL DEFAULT (0),
	[quest3_val3] [int] NOT NULL DEFAULT (0),
	[quest3_val4] [int] NOT NULL DEFAULT (0),
	[quest4_idx] [int] NOT NULL DEFAULT (0),
	[quest4_val1] [int] NOT NULL DEFAULT (0),
	[quest4_val2] [int] NOT NULL DEFAULT (0),
	[quest4_val3] [int] NOT NULL DEFAULT (0),
	[quest4_val4] [int] NOT NULL DEFAULT (0),
	[quest5_idx] [int] NOT NULL DEFAULT (0),
	[quest5_val1] [int] NOT NULL DEFAULT (0),
	[quest5_val2] [int] NOT NULL DEFAULT (0),
	[quest5_val3] [int] NOT NULL DEFAULT (0),
	[quest5_val4] [int] NOT NULL DEFAULT (0),
	[quest6_idx] [int] NOT NULL DEFAULT (0),
	[quest6_val1] [int] NOT NULL DEFAULT (0),
	[quest6_val2] [int] NOT NULL DEFAULT (0),
	[quest6_val3] [int] NOT NULL DEFAULT (0),
	[quest6_val4] [int] NOT NULL DEFAULT (0),
	[quest7_idx] [int] NOT NULL DEFAULT (0),
	[quest7_val1] [int] NOT NULL DEFAULT (0),
	[quest7_val2] [int] NOT NULL DEFAULT (0),
	[quest7_val3] [int] NOT NULL DEFAULT (0),
	[quest7_val4] [int] NOT NULL DEFAULT (0),
	[quest8_idx] [int] NOT NULL DEFAULT (0),
	[quest8_val1] [int] NOT NULL DEFAULT (0),
	[quest8_val2] [int] NOT NULL DEFAULT (0),
	[quest8_val3] [int] NOT NULL DEFAULT (0),
	[quest8_val4] [int] NOT NULL DEFAULT (0),
	[quest9_idx] [int] NOT NULL DEFAULT (0),
	[quest9_val1] [int] NOT NULL DEFAULT (0),
	[quest9_val2] [int] NOT NULL DEFAULT (0),
	[quest9_val3] [int] NOT NULL DEFAULT (0),
	[quest9_val4] [int] NOT NULL DEFAULT (0),
	[quest10_idx] [int] NOT NULL DEFAULT (0),
	[quest10_val1] [int] NOT NULL DEFAULT (0),
	[quest10_val2] [int] NOT NULL DEFAULT (0),
	[quest10_val3] [int] NOT NULL DEFAULT (0),
	[quest10_val4] [int] NOT NULL DEFAULT (0),
	[quest11_idx] [int] NOT NULL DEFAULT (0),
	[quest11_val1] [int] NOT NULL DEFAULT (0),
	[quest11_val2] [int] NOT NULL DEFAULT (0),
	[quest11_val3] [int] NOT NULL DEFAULT (0),
	[quest11_val4] [int] NOT NULL DEFAULT (0),
	[quest12_idx] [int] NOT NULL DEFAULT (0),
	[quest12_val1] [int] NOT NULL DEFAULT (0),
	[quest12_val2] [int] NOT NULL DEFAULT (0),
	[quest12_val3] [int] NOT NULL DEFAULT (0),
	[quest12_val4] [int] NOT NULL DEFAULT (0),
	[quest13_idx] [int] NOT NULL DEFAULT (0),
	[quest13_val1] [int] NOT NULL DEFAULT (0),
	[quest13_val2] [int] NOT NULL DEFAULT (0),
	[quest13_val3] [int] NOT NULL DEFAULT (0),
	[quest13_val4] [int] NOT NULL DEFAULT (0),
	[quest14_idx] [int] NOT NULL DEFAULT (0),
	[quest14_val1] [int] NOT NULL DEFAULT (0),
	[quest14_val2] [int] NOT NULL DEFAULT (0),
	[quest14_val3] [int] NOT NULL DEFAULT (0),
	[quest14_val4] [int] NOT NULL DEFAULT (0),
	[quest15_idx] [int] NOT NULL DEFAULT (0),
	[quest15_val1] [int] NOT NULL DEFAULT (0),
	[quest15_val2] [int] NOT NULL DEFAULT (0),
	[quest15_val3] [int] NOT NULL DEFAULT (0),
	[quest15_val4] [int] NOT NULL DEFAULT (0),
	[quest16_idx] [int] NOT NULL DEFAULT (0),
	[quest16_val1] [int] NOT NULL DEFAULT (0),
	[quest16_val2] [int] NOT NULL DEFAULT (0),
	[quest16_val3] [int] NOT NULL DEFAULT (0),
	[quest16_val4] [int] NOT NULL DEFAULT (0),
	[quest17_idx] [int] NOT NULL DEFAULT (0),
	[quest17_val1] [int] NOT NULL DEFAULT (0),
	[quest17_val2] [int] NOT NULL DEFAULT (0),
	[quest17_val3] [int] NOT NULL DEFAULT (0),
	[quest17_val4] [int] NOT NULL DEFAULT (0),
	[quest18_idx] [int] NOT NULL DEFAULT (0),
	[quest18_val1] [int] NOT NULL DEFAULT (0),
	[quest18_val2] [int] NOT NULL DEFAULT (0),
	[quest18_val3] [int] NOT NULL DEFAULT (0),
	[quest18_val4] [int] NOT NULL DEFAULT (0),
	[quest19_idx] [int] NOT NULL DEFAULT (0),
	[quest19_val1] [int] NOT NULL DEFAULT (0),
	[quest19_val2] [int] NOT NULL DEFAULT (0),
	[quest19_val3] [int] NOT NULL DEFAULT (0),
	[quest19_val4] [int] NOT NULL DEFAULT (0),
	[quest20_idx] [int] NOT NULL DEFAULT (0),
	[quest20_val1] [int] NOT NULL DEFAULT (0),
	[quest20_val2] [int] NOT NULL DEFAULT (0),
	[quest20_val3] [int] NOT NULL DEFAULT (0),
	[quest20_val4] [int] NOT NULL DEFAULT (0),
	[quest21_idx] [int] NOT NULL DEFAULT (0),
	[quest21_val1] [int] NOT NULL DEFAULT (0),
	[quest21_val2] [int] NOT NULL DEFAULT (0),
	[quest21_val3] [int] NOT NULL DEFAULT (0),
	[quest21_val4] [int] NOT NULL DEFAULT (0),
	[quest22_idx] [int] NOT NULL DEFAULT (0),
	[quest22_val1] [int] NOT NULL DEFAULT (0),
	[quest22_val2] [int] NOT NULL DEFAULT (0),
	[quest22_val3] [int] NOT NULL DEFAULT (0),
	[quest22_val4] [int] NOT NULL DEFAULT (0),
	[quest23_idx] [int] NOT NULL DEFAULT (0),
	[quest23_val1] [int] NOT NULL DEFAULT (0),
	[quest23_val2] [int] NOT NULL DEFAULT (0),
	[quest23_val3] [int] NOT NULL DEFAULT (0),
	[quest23_val4] [int] NOT NULL DEFAULT (0),
	[quest24_idx] [int] NOT NULL DEFAULT (0),
	[quest24_val1] [int] NOT NULL DEFAULT (0),
	[quest24_val2] [int] NOT NULL DEFAULT (0),
	[quest24_val3] [int] NOT NULL DEFAULT (0),
	[quest24_val4] [int] NOT NULL DEFAULT (0),
	[quest25_idx] [int] NOT NULL DEFAULT (0),
	[quest25_val1] [int] NOT NULL DEFAULT (0),
	[quest25_val2] [int] NOT NULL DEFAULT (0),
	[quest25_val3] [int] NOT NULL DEFAULT (0),
	[quest25_val4] [int] NOT NULL DEFAULT (0),
	[quest26_idx] [int] NOT NULL DEFAULT (0),
	[quest26_val1] [int] NOT NULL DEFAULT (0),
	[quest26_val2] [int] NOT NULL DEFAULT (0),
	[quest26_val3] [int] NOT NULL DEFAULT (0),
	[quest26_val4] [int] NOT NULL DEFAULT (0),
	[quest27_idx] [int] NOT NULL DEFAULT (0),
	[quest27_val1] [int] NOT NULL DEFAULT (0),
	[quest27_val2] [int] NOT NULL DEFAULT (0),
	[quest27_val3] [int] NOT NULL DEFAULT (0),
	[quest27_val4] [int] NOT NULL DEFAULT (0),
	[quest28_idx] [int] NOT NULL DEFAULT (0),
	[quest28_val1] [int] NOT NULL DEFAULT (0),
	[quest28_val2] [int] NOT NULL DEFAULT (0),
	[quest28_val3] [int] NOT NULL DEFAULT (0),
	[quest28_val4] [int] NOT NULL DEFAULT (0),
	[quest29_idx] [int] NOT NULL DEFAULT (0),
	[quest29_val1] [int] NOT NULL DEFAULT (0),
	[quest29_val2] [int] NOT NULL DEFAULT (0),
	[quest29_val3] [int] NOT NULL DEFAULT (0),
	[quest29_val4] [int] NOT NULL DEFAULT (0),
	[quest30_idx] [int] NOT NULL DEFAULT (0),
	[quest30_val1] [int] NOT NULL DEFAULT (0),
	[quest30_val2] [int] NOT NULL DEFAULT (0),
	[quest30_val3] [int] NOT NULL DEFAULT (0),
	[quest30_val4] [int] NOT NULL DEFAULT (0),
	[regDate] [datetime] NOT NULL DEFAULT (getdate()),
 CONSTRAINT [PK_userQuestDB] PRIMARY KEY CLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[userCharacterDB]    스크립트 날짜: 05/04/2012 13:57:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userCharacterDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[ClassType] [int] NOT NULL CONSTRAINT [DF__userChara__Class__286302EC]  DEFAULT ((0)),
	[CI_type] [int] NOT NULL CONSTRAINT [DF__userChara__CI_ty__29572725]  DEFAULT ((0)),
	[CI_gender] [int] NOT NULL CONSTRAINT [DF__userChara__CI_ge__2A4B4B5E]  DEFAULT ((0)),
	[CI_beard] [int] NOT NULL CONSTRAINT [DF__userChara__CI_be__2B3F6F97]  DEFAULT ((0)),
	[CI_face] [int] NOT NULL CONSTRAINT [DF__userChara__CI_fa__2C3393D0]  DEFAULT ((0)),
	[CI_hair] [int] NOT NULL CONSTRAINT [DF__userChara__CI_ha__2D27B809]  DEFAULT ((0)),
	[CI_skinColor] [int] NOT NULL CONSTRAINT [DF__userChara__CI_sk__2E1BDC42]  DEFAULT ((0)),
	[CI_hairColor] [int] NOT NULL CONSTRAINT [DF__userChara__CI_ha__2F10007B]  DEFAULT ((0)),
	[CI_trinket] [int] NOT NULL CONSTRAINT [DF__userChara__CI_tr__300424B4]  DEFAULT ((0)),
	[CI_position] [int] NOT NULL CONSTRAINT [DF_userCharacterDB_CI_position]  DEFAULT ((-1)),
	[CI_underwear] [int] NOT NULL CONSTRAINT [DF_userCharacterDB_CI_underwear]  DEFAULT ((0)),
	[EI1_type] [int] NOT NULL CONSTRAINT [DF__userChara__EI1_t__31EC6D26]  DEFAULT ((0)),
	[EI2_type] [int] NOT NULL CONSTRAINT [DF__userChara__EI2_t__34C8D9D1]  DEFAULT ((0)),
	[EI3_type] [int] NOT NULL CONSTRAINT [DF__userChara__EI3_t__37A5467C]  DEFAULT ((0)),
	[EI4_type] [int] NOT NULL CONSTRAINT [DF__userChara__EI4_t__3A81B327]  DEFAULT ((0)),
	[limitTime] [int] NOT NULL CONSTRAINT [DF_userCharacterDB_limitTime]  DEFAULT ((0)),
	[limitType] [int] NOT NULL CONSTRAINT [DF_userCharacterDB_limitType]  DEFAULT ((0)),
	[leaderType] [smallint] NOT NULL CONSTRAINT [DF_userCharacterDB_leaderType]  DEFAULT ((0)),
	[rentalType] [smallint] NOT NULL CONSTRAINT [DF_userCharacterDB_rentalType]  DEFAULT ((0)),
	[rentalTime] [int] NOT NULL CONSTRAINT [DF_userCharacterDB_rentalTime]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userCharacterDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_userNameDB]    스크립트 날짜: 05/04/2012 14:02:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_userNameDB](
	[accountIDX] [int] NOT NULL,
	[userName] [varchar](50) NOT NULL,
	[userBirthday] [char](6) NOT NULL,
	[userEnCode] [varchar](64) NOT NULL,
	[userNumber] [tinyint] NOT NULL,
	[userGender] [tinyint] NOT NULL,
	[returnValue] [tinyint] NOT NULL,
	[userIP] [varchar](15) NULL,
	[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[z_nouse_userEmblemDB]    스크립트 날짜: 05/04/2012 14:02:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userEmblemDB](
	[accountIDX] [int] NOT NULL,
	[emblem1_1] [int] NOT NULL DEFAULT (0),
	[emblem1_2] [int] NOT NULL DEFAULT (0),
	[emblem1_3] [int] NOT NULL DEFAULT (0),
	[emblem1_4] [int] NOT NULL DEFAULT (0),
	[emblem2_1] [int] NOT NULL DEFAULT (0),
	[emblem2_2] [int] NOT NULL DEFAULT (0),
	[emblem2_3] [int] NOT NULL DEFAULT (0),
	[emblem2_4] [int] NOT NULL DEFAULT (0),
	[emblem3_1] [int] NOT NULL DEFAULT (0),
	[emblem3_2] [int] NOT NULL DEFAULT (0),
	[emblem3_3] [int] NOT NULL DEFAULT (0),
	[emblem3_4] [int] NOT NULL DEFAULT (0),
	[emblem4_1] [int] NOT NULL DEFAULT (0),
	[emblem4_2] [int] NOT NULL DEFAULT (0),
	[emblem4_3] [int] NOT NULL DEFAULT (0),
	[emblem4_4] [int] NOT NULL DEFAULT (0),
	[emblem5_1] [int] NOT NULL DEFAULT (0),
	[emblem5_2] [int] NOT NULL DEFAULT (0),
	[emblem5_3] [int] NOT NULL DEFAULT (0),
	[emblem5_4] [int] NOT NULL DEFAULT (0),
	[emblem6_1] [int] NOT NULL DEFAULT (0),
	[emblem6_2] [int] NOT NULL DEFAULT (0),
	[emblem6_3] [int] NOT NULL DEFAULT (0),
	[emblem6_4] [int] NOT NULL DEFAULT (0),
	[emblem7_1] [int] NOT NULL DEFAULT (0),
	[emblem7_2] [int] NOT NULL DEFAULT (0),
	[emblem7_3] [int] NOT NULL DEFAULT (0),
	[emblem7_4] [int] NOT NULL DEFAULT (0),
	[emblem8_1] [int] NOT NULL DEFAULT (0),
	[emblem8_2] [int] NOT NULL DEFAULT (0),
	[emblem8_3] [int] NOT NULL DEFAULT (0),
	[emblem8_4] [int] NOT NULL DEFAULT (0),
	[emblem9_1] [int] NOT NULL DEFAULT (0),
	[emblem9_2] [int] NOT NULL DEFAULT (0),
	[emblem9_3] [int] NOT NULL DEFAULT (0),
	[emblem9_4] [int] NOT NULL DEFAULT (0),
	[regDate] [datetime] NOT NULL DEFAULT (getdate()),
 CONSTRAINT [PK_userEmblemDB] PRIMARY KEY CLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[z_nouse_userInfoDB]    스크립트 날짜: 05/04/2012 14:02:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_userInfoDB](
	[accountIDX] [int] NOT NULL,
	[visit_count] [int] NOT NULL,
	[rec_index] [int] NOT NULL,
	[rec_inc] [int] NOT NULL,
	[rec_dec] [int] NOT NULL,
	[checkDate] [datetime] NOT NULL,
	[cnnDate] [datetime] NULL,
	[myimg] [varchar](100) NULL,
	[regDate] [datetime] NOT NULL,
 CONSTRAINT [PK_userInfoDB] PRIMARY KEY CLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[userClassDB]    스크립트 날짜: 05/04/2012 13:57:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userClassDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[class1_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class1_type]  DEFAULT ((0)),
	[class1_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class1_level]  DEFAULT ((0)),
	[class1_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class1_expert]  DEFAULT ((0)),
	[class2_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class2_type]  DEFAULT ((0)),
	[class2_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class2_level]  DEFAULT ((0)),
	[class2_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class2_expert]  DEFAULT ((0)),
	[class3_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class3_type]  DEFAULT ((0)),
	[class3_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class3_level]  DEFAULT ((0)),
	[class3_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class3_expert]  DEFAULT ((0)),
	[class4_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class4_type]  DEFAULT ((0)),
	[class4_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class4_level]  DEFAULT ((0)),
	[class4_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class4_expert]  DEFAULT ((0)),
	[class5_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class5_type]  DEFAULT ((0)),
	[class5_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class5_level]  DEFAULT ((0)),
	[class5_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class5_expert]  DEFAULT ((0)),
	[class6_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class6_type]  DEFAULT ((0)),
	[class6_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class6_level]  DEFAULT ((0)),
	[class6_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class6_expert]  DEFAULT ((0)),
	[class7_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class7_type]  DEFAULT ((0)),
	[class7_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class7_level]  DEFAULT ((0)),
	[class7_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class7_expert]  DEFAULT ((0)),
	[class8_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class8_type]  DEFAULT ((0)),
	[class8_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class8_level]  DEFAULT ((0)),
	[class8_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class8_expert]  DEFAULT ((0)),
	[class9_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class9_type]  DEFAULT ((0)),
	[class9_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class9_level]  DEFAULT ((0)),
	[class9_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class9_expert]  DEFAULT ((0)),
	[class10_type] [int] NOT NULL CONSTRAINT [DF_userClassDB_class10_type]  DEFAULT ((0)),
	[class10_level] [int] NOT NULL CONSTRAINT [DF_userClassDB_class10_level]  DEFAULT ((0)),
	[class10_expert] [int] NOT NULL CONSTRAINT [DF_userClassDB_class10_expert]  DEFAULT ((0))
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'userClassDB', @level2type=N'COLUMN',@level2name=N'class4_expert'
GO
/****** 개체:  Table [dbo].[z_nouse_userQuestDB_complete]    스크립트 날짜: 05/04/2012 14:03:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userQuestDB_complete](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[questIDX1] [int] NOT NULL DEFAULT (0),
	[questIDX2] [int] NOT NULL DEFAULT (0),
	[questIDX3] [int] NOT NULL DEFAULT (0),
	[questIDX4] [int] NOT NULL DEFAULT (0),
	[questIDX5] [int] NOT NULL DEFAULT (0),
	[questIDX6] [int] NOT NULL DEFAULT (0),
	[questIDX7] [int] NOT NULL DEFAULT (0),
	[questIDX8] [int] NOT NULL DEFAULT (0),
	[questIDX9] [int] NOT NULL DEFAULT (0),
	[questIDX10] [int] NOT NULL DEFAULT (0),
	[questIDX11] [int] NOT NULL DEFAULT (0),
	[questIDX12] [int] NOT NULL DEFAULT (0),
	[questIDX13] [int] NOT NULL DEFAULT (0),
	[questIDX14] [int] NOT NULL DEFAULT (0),
	[questIDX15] [int] NOT NULL DEFAULT (0),
	[questIDX16] [int] NOT NULL DEFAULT (0),
	[questIDX17] [int] NOT NULL DEFAULT (0),
	[questIDX18] [int] NOT NULL DEFAULT (0),
	[questIDX19] [int] NOT NULL DEFAULT (0),
	[questIDX20] [int] NOT NULL DEFAULT (0),
	[questIDX21] [int] NOT NULL DEFAULT (0),
	[questIDX22] [int] NOT NULL DEFAULT (0),
	[questIDX23] [int] NOT NULL DEFAULT (0),
	[questIDX24] [int] NOT NULL DEFAULT (0),
	[questIDX25] [int] NOT NULL DEFAULT (0),
	[questIDX26] [int] NOT NULL DEFAULT (0),
	[questIDX27] [int] NOT NULL DEFAULT (0),
	[questIDX28] [int] NOT NULL DEFAULT (0),
	[questIDX29] [int] NOT NULL DEFAULT (0),
	[questIDX30] [int] NOT NULL DEFAULT (0),
	[questIDX31] [int] NOT NULL DEFAULT (0),
	[questIDX32] [int] NOT NULL DEFAULT (0),
	[questIDX33] [int] NOT NULL DEFAULT (0),
	[questIDX34] [int] NOT NULL DEFAULT (0),
	[questIDX35] [int] NOT NULL DEFAULT (0),
	[questIDX36] [int] NOT NULL DEFAULT (0),
	[questIDX37] [int] NOT NULL DEFAULT (0),
	[questIDX38] [int] NOT NULL DEFAULT (0),
	[questIDX39] [int] NOT NULL DEFAULT (0),
	[questIDX40] [int] NOT NULL DEFAULT (0),
	[questIDX41] [int] NOT NULL DEFAULT (0),
	[questIDX42] [int] NOT NULL DEFAULT (0),
	[questIDX43] [int] NOT NULL DEFAULT (0),
	[questIDX44] [int] NOT NULL DEFAULT (0),
	[questIDX45] [int] NOT NULL DEFAULT (0),
	[questIDX46] [int] NOT NULL DEFAULT (0),
	[questIDX47] [int] NOT NULL DEFAULT (0),
	[questIDX48] [int] NOT NULL DEFAULT (0),
	[questIDX49] [int] NOT NULL DEFAULT (0),
	[questIDX50] [int] NOT NULL DEFAULT (0),
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userLoginDB]    스크립트 날짜: 05/04/2012 13:59:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userLoginDB](
	[accountIDX] [int] NOT NULL,
	[encodeKey] [char](15) NOT NULL CONSTRAINT [DF__userLogin__encod__489AC854]  DEFAULT ((111111111111111.)),
	[gameServerID] [bigint] NOT NULL CONSTRAINT [DF__userLogin__gameS__498EEC8D]  DEFAULT ((0)),
	[userIP] [varchar](15) NULL,
	[connDate] [datetime] NOT NULL CONSTRAINT [DF__userLogin__connD__4A8310C6]  DEFAULT (getdate()),
 CONSTRAINT [PK_userLoginDB] PRIMARY KEY NONCLUSTERED 
(
	[accountIDX] 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
/****** 개체:  Table [dbo].[userMedalDB]    스크립트 날짜: 05/04/2012 13:59:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userMedalDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[medal1_type] [int] NOT NULL,
	[medal2_type] [int] NOT NULL,
	[medal3_type] [int] NOT NULL,
	[medal4_type] [int] NOT NULL,
	[medal5_type] [int] NOT NULL,
	[medal6_type] [int] NOT NULL,
	[medal7_type] [int] NOT NULL,
	[medal8_type] [int] NOT NULL,
	[medal9_type] [int] NOT NULL,
	[medal10_type] [int] NOT NULL,
	[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userEventDB]    스크립트 날짜: 05/04/2012 13:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userEventDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[value1] [int] NOT NULL CONSTRAINT [DF_userEventDB_value1]  DEFAULT ((0)),
	[value2] [int] NOT NULL CONSTRAINT [DF_userEventDB_value2]  DEFAULT ((0)),
	[eventType] [int] NOT NULL CONSTRAINT [DF_userEventDB_eventType]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userEventDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userQuestDB]    스크립트 날짜: 05/04/2012 14:00:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userQuestDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[quest1_type] [int] NOT NULL DEFAULT ((0)),
	[quest1_value1] [int] NOT NULL DEFAULT ((0)),
	[quest1_value2] [int] NOT NULL DEFAULT ((0)),
	[quest1_time] [int] NOT NULL DEFAULT ((0)),
	[quest2_type] [int] NOT NULL DEFAULT ((0)),
	[quest2_value1] [int] NOT NULL DEFAULT ((0)),
	[quest2_value2] [int] NOT NULL DEFAULT ((0)),
	[quest2_time] [int] NOT NULL DEFAULT ((0)),
	[quest3_type] [int] NOT NULL DEFAULT ((0)),
	[quest3_value1] [int] NOT NULL DEFAULT ((0)),
	[quest3_value2] [int] NOT NULL DEFAULT ((0)),
	[quest3_time] [int] NOT NULL DEFAULT ((0)),
	[quest4_type] [int] NOT NULL DEFAULT ((0)),
	[quest4_value1] [int] NOT NULL DEFAULT ((0)),
	[quest4_value2] [int] NOT NULL DEFAULT ((0)),
	[quest4_time] [int] NOT NULL DEFAULT ((0)),
	[quest5_type] [int] NOT NULL DEFAULT ((0)),
	[quest5_value1] [int] NOT NULL DEFAULT ((0)),
	[quest5_value2] [int] NOT NULL DEFAULT ((0)),
	[quest5_time] [int] NOT NULL DEFAULT ((0)),
	[quest6_type] [int] NOT NULL DEFAULT ((0)),
	[quest6_value1] [int] NOT NULL DEFAULT ((0)),
	[quest6_value2] [int] NOT NULL DEFAULT ((0)),
	[quest6_time] [int] NOT NULL DEFAULT ((0)),
	[quest7_type] [int] NOT NULL DEFAULT ((0)),
	[quest7_value1] [int] NOT NULL DEFAULT ((0)),
	[quest7_value2] [int] NOT NULL DEFAULT ((0)),
	[quest7_time] [int] NOT NULL DEFAULT ((0)),
	[quest8_type] [int] NOT NULL DEFAULT ((0)),
	[quest8_value1] [int] NOT NULL DEFAULT ((0)),
	[quest8_value2] [int] NOT NULL DEFAULT ((0)),
	[quest8_time] [int] NOT NULL DEFAULT ((0)),
	[quest9_type] [int] NOT NULL DEFAULT ((0)),
	[quest9_value1] [int] NOT NULL DEFAULT ((0)),
	[quest9_value2] [int] NOT NULL DEFAULT ((0)),
	[quest9_time] [int] NOT NULL DEFAULT ((0)),
	[quest10_type] [int] NOT NULL DEFAULT ((0)),
	[quest10_value1] [int] NOT NULL DEFAULT ((0)),
	[quest10_value2] [int] NOT NULL DEFAULT ((0)),
	[quest10_time] [int] NOT NULL DEFAULT ((0)),
	[quest11_type] [int] NOT NULL DEFAULT ((0)),
	[quest11_value1] [int] NOT NULL DEFAULT ((0)),
	[quest11_value2] [int] NOT NULL DEFAULT ((0)),
	[quest11_time] [int] NOT NULL DEFAULT ((0)),
	[quest12_type] [int] NOT NULL DEFAULT ((0)),
	[quest12_value1] [int] NOT NULL DEFAULT ((0)),
	[quest12_value2] [int] NOT NULL DEFAULT ((0)),
	[quest12_time] [int] NOT NULL DEFAULT ((0)),
	[quest13_type] [int] NOT NULL DEFAULT ((0)),
	[quest13_value1] [int] NOT NULL DEFAULT ((0)),
	[quest13_value2] [int] NOT NULL DEFAULT ((0)),
	[quest13_time] [int] NOT NULL DEFAULT ((0)),
	[quest14_type] [int] NOT NULL DEFAULT ((0)),
	[quest14_value1] [int] NOT NULL DEFAULT ((0)),
	[quest14_value2] [int] NOT NULL DEFAULT ((0)),
	[quest14_time] [int] NOT NULL DEFAULT ((0)),
	[quest15_type] [int] NOT NULL DEFAULT ((0)),
	[quest15_value1] [int] NOT NULL DEFAULT ((0)),
	[quest15_value2] [int] NOT NULL DEFAULT ((0)),
	[quest15_time] [int] NOT NULL DEFAULT ((0)),
	[quest16_type] [int] NOT NULL DEFAULT ((0)),
	[quest16_value1] [int] NOT NULL DEFAULT ((0)),
	[quest16_value2] [int] NOT NULL DEFAULT ((0)),
	[quest16_time] [int] NOT NULL DEFAULT ((0)),
	[quest17_type] [int] NOT NULL DEFAULT ((0)),
	[quest17_value1] [int] NOT NULL DEFAULT ((0)),
	[quest17_value2] [int] NOT NULL DEFAULT ((0)),
	[quest17_time] [int] NOT NULL DEFAULT ((0)),
	[quest18_type] [int] NOT NULL DEFAULT ((0)),
	[quest18_value1] [int] NOT NULL DEFAULT ((0)),
	[quest18_value2] [int] NOT NULL DEFAULT ((0)),
	[quest18_time] [int] NOT NULL DEFAULT ((0)),
	[quest19_type] [int] NOT NULL DEFAULT ((0)),
	[quest19_value1] [int] NOT NULL DEFAULT ((0)),
	[quest19_value2] [int] NOT NULL DEFAULT ((0)),
	[quest19_time] [int] NOT NULL DEFAULT ((0)),
	[quest20_type] [int] NOT NULL DEFAULT ((0)),
	[quest20_value1] [int] NOT NULL DEFAULT ((0)),
	[quest20_value2] [int] NOT NULL DEFAULT ((0)),
	[quest20_time] [int] NOT NULL DEFAULT ((0)),
	[regDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userHqDB]    스크립트 날짜: 05/04/2012 13:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userHqDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[class1_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class1_type]  DEFAULT ((0)),
	[class1_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class1_posx]  DEFAULT ((0)),
	[class1_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class1_posy]  DEFAULT ((0)),
	[class2_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class2_type]  DEFAULT ((0)),
	[class2_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class2_posx]  DEFAULT ((0)),
	[class2_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class2_posy]  DEFAULT ((0)),
	[class3_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class3_type]  DEFAULT ((0)),
	[class3_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class3_posx]  DEFAULT ((0)),
	[class3_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class3_posy]  DEFAULT ((0)),
	[class4_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class4_type]  DEFAULT ((0)),
	[class4_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class4_posx]  DEFAULT ((0)),
	[class4_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class4_posy]  DEFAULT ((0)),
	[class5_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class5_type]  DEFAULT ((0)),
	[class5_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class5_posx]  DEFAULT ((0)),
	[class5_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class5_posy]  DEFAULT ((0)),
	[class6_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class6_type]  DEFAULT ((0)),
	[class6_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class6_posx]  DEFAULT ((0)),
	[class6_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class6_posy]  DEFAULT ((0)),
	[class7_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class7_type]  DEFAULT ((0)),
	[class7_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class7_posx]  DEFAULT ((0)),
	[class7_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class7_posy]  DEFAULT ((0)),
	[class8_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class8_type]  DEFAULT ((0)),
	[class8_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class8_posx]  DEFAULT ((0)),
	[class8_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class8_posy]  DEFAULT ((0)),
	[class9_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class9_type]  DEFAULT ((0)),
	[class9_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class9_posx]  DEFAULT ((0)),
	[class9_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class9_posy]  DEFAULT ((0)),
	[class10_type] [int] NOT NULL CONSTRAINT [DF_userHqDB_class10_type]  DEFAULT ((0)),
	[class10_posx] [int] NOT NULL CONSTRAINT [DF_userHqDB_class10_posx]  DEFAULT ((0)),
	[class10_posy] [int] NOT NULL CONSTRAINT [DF_userHqDB_class10_posy]  DEFAULT ((0)),
	[lockType] [smallint] NOT NULL CONSTRAINT [DF_userHqDB_lockType]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userHqDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userRegionDB_history]    스크립트 날짜: 05/04/2012 14:01:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRegionDB_history](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[point] [int] NOT NULL CONSTRAINT [DF_userRegionDB_point]  DEFAULT ((0)),
	[point_bonus] [int] NOT NULL CONSTRAINT [DF_userRegionDB_history_point_bonus]  DEFAULT ((0)),
	[membercount] [int] NOT NULL CONSTRAINT [DF_userRegionDB_membercount]  DEFAULT ((0)),
	[regionType] [tinyint] NOT NULL CONSTRAINT [DF_userRegionDB_regionType]  DEFAULT ((0)),
	[season] [int] NOT NULL CONSTRAINT [DF_userRegionDB_season]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRegionDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userRankingDB_award]    스크립트 날짜: 05/04/2012 14:01:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRankingDB_award](
	[accountIDX] [int] NOT NULL,
	[awardLevel] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_awardLevel]  DEFAULT ((0)),
	[expert] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_expert]  DEFAULT ((0)),
	[award1_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award1]  DEFAULT ((0)),
	[award1_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award1_now]  DEFAULT ((0)),
	[award1_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award1_point]  DEFAULT ((0)),
	[award2_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award2]  DEFAULT ((0)),
	[award2_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award2_now]  DEFAULT ((0)),
	[award2_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award2_point]  DEFAULT ((0)),
	[award3_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award3]  DEFAULT ((0)),
	[award3_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award3_now]  DEFAULT ((0)),
	[award3_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award3_point]  DEFAULT ((0)),
	[award4_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award4]  DEFAULT ((0)),
	[award4_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award4_now]  DEFAULT ((0)),
	[award4_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award4_point]  DEFAULT ((0)),
	[award5_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award5]  DEFAULT ((0)),
	[award5_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award5_now]  DEFAULT ((0)),
	[award5_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award5_point]  DEFAULT ((0)),
	[award6_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award6]  DEFAULT ((0)),
	[award6_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award6_now]  DEFAULT ((0)),
	[award6_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award6_point]  DEFAULT ((0)),
	[award7_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award7]  DEFAULT ((0)),
	[award7_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award7_now]  DEFAULT ((0)),
	[award7_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award7_point]  DEFAULT ((0)),
	[award8_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award8]  DEFAULT ((0)),
	[award8_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award8_now]  DEFAULT ((0)),
	[award8_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award8_point]  DEFAULT ((0)),
	[award9_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award9]  DEFAULT ((0)),
	[award9_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award9_now]  DEFAULT ((0)),
	[award9_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award9_point]  DEFAULT ((0)),
	[award10_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award10]  DEFAULT ((0)),
	[award10_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award10_now]  DEFAULT ((0)),
	[award10_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award10_point]  DEFAULT ((0)),
	[award11_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award11]  DEFAULT ((0)),
	[award11_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award11_now]  DEFAULT ((0)),
	[award11_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award11_point]  DEFAULT ((0)),
	[award12_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award12]  DEFAULT ((0)),
	[award12_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award12_now]  DEFAULT ((0)),
	[award12_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award12_point]  DEFAULT ((0)),
	[award13_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award13]  DEFAULT ((0)),
	[award13_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award13_now]  DEFAULT ((0)),
	[award13_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award13_point]  DEFAULT ((0)),
	[award14_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award14]  DEFAULT ((0)),
	[award14_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award14_now]  DEFAULT ((0)),
	[award14_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award14_point]  DEFAULT ((0)),
	[award15_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award15]  DEFAULT ((0)),
	[award15_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award15_now]  DEFAULT ((0)),
	[award15_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award15_point]  DEFAULT ((0)),
	[award16_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award16]  DEFAULT ((0)),
	[award16_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award16_now]  DEFAULT ((0)),
	[award16_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award16_point]  DEFAULT ((0)),
	[award17_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award17]  DEFAULT ((0)),
	[award17_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award17_now]  DEFAULT ((0)),
	[award17_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award17_point]  DEFAULT ((0)),
	[award18_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award18]  DEFAULT ((0)),
	[award18_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award18_now]  DEFAULT ((0)),
	[award18_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award18_point]  DEFAULT ((0)),
	[award19_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award19]  DEFAULT ((0)),
	[award19_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award19_now]  DEFAULT ((0)),
	[award19_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award19_point]  DEFAULT ((0)),
	[award20_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award20]  DEFAULT ((0)),
	[award20_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award20_now]  DEFAULT ((0)),
	[award20_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award20_point]  DEFAULT ((0)),
	[award21_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award21]  DEFAULT ((0)),
	[award21_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award21_now]  DEFAULT ((0)),
	[award21_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award21_point]  DEFAULT ((0)),
	[award22_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award22]  DEFAULT ((0)),
	[award22_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award22_now]  DEFAULT ((0)),
	[award22_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award22_point]  DEFAULT ((0)),
	[award23_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award23]  DEFAULT ((0)),
	[award23_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award23_now]  DEFAULT ((0)),
	[award23_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award23_point]  DEFAULT ((0)),
	[award24_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award24]  DEFAULT ((0)),
	[award24_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award24_now]  DEFAULT ((0)),
	[award24_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award24_point]  DEFAULT ((0)),
	[award25_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award25]  DEFAULT ((0)),
	[award25_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award25_now]  DEFAULT ((0)),
	[award25_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award25_point]  DEFAULT ((0)),
	[award26_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award26]  DEFAULT ((0)),
	[award26_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award26_now]  DEFAULT ((0)),
	[award26_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award26_point]  DEFAULT ((0)),
	[award27_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award27]  DEFAULT ((0)),
	[award27_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award27_now]  DEFAULT ((0)),
	[award27_point] [int] NOT NULL CONSTRAINT [DF_userRankingDB_award_award27_point]  DEFAULT ((0)),
	[regDate] [smalldatetime] NOT NULL CONSTRAINT [DF_userRankingDB_award_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_userGuildBDB]    스크립트 날짜: 05/04/2012 14:02:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[z_nouse_userGuildBDB](
	[accountIDX] [int] NOT NULL,
	[guildIDX] [int] NOT NULL,
	[guildName] [varchar](12) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[z_nouse_userGameTLDB]    스크립트 날짜: 05/04/2012 14:02:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userGameTLDB](
	[accountIDX] [int] NOT NULL,
	[killdeathLevel] [int] NOT NULL
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[define_class_price]    스크립트 날짜: 05/04/2012 13:56:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[define_class_price](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[class1_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__77BFCB91]  DEFAULT ((0)),
	[class2_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__7A9C383C]  DEFAULT ((0)),
	[class3_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__7D78A4E7]  DEFAULT ((0)),
	[class4_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__00551192]  DEFAULT ((0)),
	[class5_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__03317E3D]  DEFAULT ((0)),
	[class6_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__060DEAE8]  DEFAULT ((0)),
	[class7_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__08EA5793]  DEFAULT ((0)),
	[class8_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__0BC6C43E]  DEFAULT ((0)),
	[class9_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__0EA330E9]  DEFAULT ((0)),
	[class10_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__117F9D94]  DEFAULT ((0)),
	[class11_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__145C0A3F]  DEFAULT ((0)),
	[class12_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__173876EA]  DEFAULT ((0)),
	[class13_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__1A14E395]  DEFAULT ((0)),
	[class14_price] [int] NOT NULL CONSTRAINT [DF__define_cl__class__1CF15040]  DEFAULT ((0)),
	[class15_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class15_price]  DEFAULT ((0)),
	[class16_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class16_price]  DEFAULT ((0)),
	[class17_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class17_price]  DEFAULT ((0)),
	[class18_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class18_price]  DEFAULT ((0)),
	[class19_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class19_price]  DEFAULT ((0)),
	[class20_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class20_price]  DEFAULT ((0)),
	[class21_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class21_price]  DEFAULT ((0)),
	[class22_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class22_price]  DEFAULT ((0)),
	[class23_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class23_price]  DEFAULT ((0)),
	[class24_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class24_price]  DEFAULT ((0)),
	[class25_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class25_price]  DEFAULT ((0)),
	[class26_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class26_price]  DEFAULT ((0)),
	[class27_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class27_price]  DEFAULT ((0)),
	[class28_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class28_price]  DEFAULT ((0)),
	[class29_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class29_price]  DEFAULT ((0)),
	[class30_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class30_price]  DEFAULT ((0)),
	[class31_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class31_price]  DEFAULT ((0)),
	[class32_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class32_price]  DEFAULT ((0)),
	[class33_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class33_price]  DEFAULT ((0)),
	[class34_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class34_price]  DEFAULT ((0)),
	[class35_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class35_price]  DEFAULT ((0)),
	[class36_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class36_price]  DEFAULT ((0)),
	[class37_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class37_price]  DEFAULT ((0)),
	[class38_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class38_price]  DEFAULT ((0)),
	[class39_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class39_price]  DEFAULT ((0)),
	[class40_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class40_price]  DEFAULT ((0)),
	[class41_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class41_price]  DEFAULT ((0)),
	[class42_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class42_price]  DEFAULT ((0)),
	[class43_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class43_price]  DEFAULT ((0)),
	[class44_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class44_price]  DEFAULT ((0)),
	[class45_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class45_price]  DEFAULT ((0)),
	[class46_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class46_price]  DEFAULT ((0)),
	[class47_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class47_price]  DEFAULT ((0)),
	[class48_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class48_price]  DEFAULT ((0)),
	[class49_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class49_price]  DEFAULT ((0)),
	[class50_price] [int] NOT NULL CONSTRAINT [DF_define_classpriceDB_class50_price]  DEFAULT ((0)),
	[class51_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class51_price]  DEFAULT ((0)),
	[class52_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class52_price]  DEFAULT ((0)),
	[class53_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class53_price]  DEFAULT ((0)),
	[class54_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class54_price]  DEFAULT ((0)),
	[class55_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class55_price]  DEFAULT ((0)),
	[class56_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class56_price]  DEFAULT ((0)),
	[class57_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class57_price]  DEFAULT ((0)),
	[class58_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class58_price]  DEFAULT ((0)),
	[class59_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class59_price]  DEFAULT ((0)),
	[class60_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class60_price]  DEFAULT ((0)),
	[class61_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class61_price]  DEFAULT ((0)),
	[class62_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class62_price]  DEFAULT ((0)),
	[class63_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class63_price]  DEFAULT ((0)),
	[class64_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class64_price]  DEFAULT ((0)),
	[class65_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class65_price]  DEFAULT ((0)),
	[class66_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class66_price]  DEFAULT ((0)),
	[class67_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class67_price]  DEFAULT ((0)),
	[class68_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class68_price]  DEFAULT ((0)),
	[class69_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class69_price]  DEFAULT ((0)),
	[class70_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class70_price]  DEFAULT ((0)),
	[class71_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class71_price]  DEFAULT ((0)),
	[class72_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class72_price]  DEFAULT ((0)),
	[class73_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class73_price]  DEFAULT ((0)),
	[class74_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class74_price]  DEFAULT ((0)),
	[class75_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class75_price]  DEFAULT ((0)),
	[class76_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class76_price]  DEFAULT ((0)),
	[class77_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class77_price]  DEFAULT ((0)),
	[class78_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class78_price]  DEFAULT ((0)),
	[class79_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class79_price]  DEFAULT ((0)),
	[class80_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class80_price]  DEFAULT ((0)),
	[class81_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class81_price]  DEFAULT ((0)),
	[class82_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class82_price]  DEFAULT ((0)),
	[class83_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class83_price]  DEFAULT ((0)),
	[class84_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class84_price]  DEFAULT ((0)),
	[class85_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class85_price]  DEFAULT ((0)),
	[class86_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class86_price]  DEFAULT ((0)),
	[class87_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class87_price]  DEFAULT ((0)),
	[class88_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class88_price]  DEFAULT ((0)),
	[class89_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class89_price]  DEFAULT ((0)),
	[class90_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class90_price]  DEFAULT ((0)),
	[class91_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class91_price]  DEFAULT ((0)),
	[class92_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class92_price]  DEFAULT ((0)),
	[class93_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class93_price]  DEFAULT ((0)),
	[class94_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class94_price]  DEFAULT ((0)),
	[class95_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class95_price]  DEFAULT ((0)),
	[class96_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class96_price]  DEFAULT ((0)),
	[class97_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class97_price]  DEFAULT ((0)),
	[class98_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class98_price]  DEFAULT ((0)),
	[class99_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class99_price]  DEFAULT ((0)),
	[class100_price] [int] NOT NULL CONSTRAINT [DF_define_class_price_class100_price]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF__define_cl__regDa__1ED998B2]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[manage_memberDB]    스크립트 날짜: 05/04/2012 13:56:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[manage_memberDB](
	[accountIDX] [int] NOT NULL,
	[userID] [varchar](12) NOT NULL,
	[userPWD] [varchar](32) NOT NULL,
	[userName] [varchar](12) NOT NULL,
	[adminType] [smallint] NOT NULL,
	[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userGuildInfoDB]    스크립트 날짜: 05/04/2012 13:58:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userGuildInfoDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[guildIDX] [int] NOT NULL,
	[guildPosition] [varchar](20) NULL,
	[guildJoinType] [int] NOT NULL CONSTRAINT [DF_userGuildInfoDB_guildJoinType]  DEFAULT ((0)),
	[msg] [int] NOT NULL CONSTRAINT [DF_userGuildInfoDB_msg]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userGuildInfoDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** 개체:  Table [dbo].[userItemEtcDB]    스크립트 날짜: 05/04/2012 13:59:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userItemEtcDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[item1_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item1_type]  DEFAULT ((0)),
	[item1_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item1_value1]  DEFAULT ((0)),
	[item1_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item1_value2]  DEFAULT ((0)),
	[item2_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item2_type]  DEFAULT ((0)),
	[item2_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item2_value1]  DEFAULT ((0)),
	[item2_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item2_value2]  DEFAULT ((0)),
	[item3_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item3_type]  DEFAULT ((0)),
	[item3_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item3_value1]  DEFAULT ((0)),
	[item3_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item3_value2]  DEFAULT ((0)),
	[item4_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item4_type]  DEFAULT ((0)),
	[item4_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item4_value1]  DEFAULT ((0)),
	[item4_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item4_value2]  DEFAULT ((0)),
	[item5_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item5_type]  DEFAULT ((0)),
	[item5_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item5_value1]  DEFAULT ((0)),
	[item5_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item5_value2]  DEFAULT ((0)),
	[item6_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item6_type]  DEFAULT ((0)),
	[item6_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item6_value1]  DEFAULT ((0)),
	[item6_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item6_value2]  DEFAULT ((0)),
	[item7_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item7_type]  DEFAULT ((0)),
	[item7_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item7_value1]  DEFAULT ((0)),
	[item7_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item7_value2]  DEFAULT ((0)),
	[item8_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item8_type]  DEFAULT ((0)),
	[item8_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item8_value1]  DEFAULT ((0)),
	[item8_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item8_value2]  DEFAULT ((0)),
	[item9_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item9_type]  DEFAULT ((0)),
	[item9_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item9_value1]  DEFAULT ((0)),
	[item9_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item9_value2]  DEFAULT ((0)),
	[item10_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item10_type]  DEFAULT ((0)),
	[item10_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item10_value1]  DEFAULT ((0)),
	[item10_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item10_value2]  DEFAULT ((0)),
	[item11_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item11_type]  DEFAULT ((0)),
	[item11_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item11_value1]  DEFAULT ((0)),
	[item11_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item11_value2]  DEFAULT ((0)),
	[item12_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item12_type]  DEFAULT ((0)),
	[item12_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item12_value1]  DEFAULT ((0)),
	[item12_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item12_value2]  DEFAULT ((0)),
	[item13_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item13_type]  DEFAULT ((0)),
	[item13_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item13_value1]  DEFAULT ((0)),
	[item13_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item13_value2]  DEFAULT ((0)),
	[item14_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item14_type]  DEFAULT ((0)),
	[item14_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item14_value1]  DEFAULT ((0)),
	[item14_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item14_value2]  DEFAULT ((0)),
	[item15_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item15_type]  DEFAULT ((0)),
	[item15_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item15_value1]  DEFAULT ((0)),
	[item15_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item15_value2]  DEFAULT ((0)),
	[item16_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item16_type]  DEFAULT ((0)),
	[item16_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item16_value1]  DEFAULT ((0)),
	[item16_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item16_value2]  DEFAULT ((0)),
	[item17_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item17_type]  DEFAULT ((0)),
	[item17_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item17_value1]  DEFAULT ((0)),
	[item17_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item17_value2]  DEFAULT ((0)),
	[item18_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item18_type]  DEFAULT ((0)),
	[item18_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item18_value1]  DEFAULT ((0)),
	[item18_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item18_value2]  DEFAULT ((0)),
	[item19_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item19_type]  DEFAULT ((0)),
	[item19_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item19_value1]  DEFAULT ((0)),
	[item19_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item19_value2]  DEFAULT ((0)),
	[item20_type] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item20_type]  DEFAULT ((0)),
	[item20_value1] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item20_value1]  DEFAULT ((0)),
	[item20_value2] [int] NOT NULL CONSTRAINT [DF_userItemEtcDB_item20_value2]  DEFAULT ((0))
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userRegionDB]    스크립트 날짜: 05/04/2012 14:01:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRegionDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[rt1point] [int] NOT NULL CONSTRAINT [DF_userRegionDB_rt1point]  DEFAULT ((0)),
	[rt1point_bonus] [int] NOT NULL CONSTRAINT [DF_userRegionDB_rt1point_bonus]  DEFAULT ((0)),
	[rt1point_today] [int] NOT NULL CONSTRAINT [DF_userRegionDB_rt1point_today]  DEFAULT ((0)),
	[rt2point] [int] NOT NULL CONSTRAINT [DF_userRegionDB_rt2point]  DEFAULT ((0)),
	[rt2point_bonus] [int] NOT NULL CONSTRAINT [DF_userRegionDB_rt2point_bonus]  DEFAULT ((0)),
	[rt2point_today] [int] NOT NULL CONSTRAINT [DF_userRegionDB_rt2point_today]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRegionDB_regDate_1]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[define_gear_customidx]    스크립트 날짜: 05/04/2012 13:56:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[define_gear_customidx](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL DEFAULT ((0))
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userItemExtraDB]    스크립트 날짜: 05/04/2012 13:59:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userItemExtraDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[item1_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_type]  DEFAULT ((0)),
	[item1_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_reinforce]  DEFAULT ((0)),
	[item1_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_slotindex]  DEFAULT ((0)),
	[item1_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_tradetype]  DEFAULT ((0)),
	[item1_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_mcustom]  DEFAULT ((0)),
	[item1_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_fcustom]  DEFAULT ((0)),
	[item1_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item1_limitType]  DEFAULT ((0)),
	[item1_limitDate] [datetime] NOT NULL,
	[item2_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_type]  DEFAULT ((0)),
	[item2_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_reinforce]  DEFAULT ((0)),
	[item2_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_slotindex]  DEFAULT ((0)),
	[item2_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_tradetype]  DEFAULT ((0)),
	[item2_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_mcustom]  DEFAULT ((0)),
	[item2_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_fcustom]  DEFAULT ((0)),
	[item2_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item2_limitType]  DEFAULT ((0)),
	[item2_limitDate] [datetime] NOT NULL,
	[item3_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_type]  DEFAULT ((0)),
	[item3_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_reinforce]  DEFAULT ((0)),
	[item3_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_slotindex]  DEFAULT ((0)),
	[item3_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_tradetype]  DEFAULT ((0)),
	[item3_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_mcustom]  DEFAULT ((0)),
	[item3_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_fcustom]  DEFAULT ((0)),
	[item3_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item3_limitType]  DEFAULT ((0)),
	[item3_limitDate] [datetime] NOT NULL,
	[item4_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_type]  DEFAULT ((0)),
	[item4_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_reinforce]  DEFAULT ((0)),
	[item4_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_slotindex]  DEFAULT ((0)),
	[item4_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_tradetype]  DEFAULT ((0)),
	[item4_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_mcustom]  DEFAULT ((0)),
	[item4_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_fcustom]  DEFAULT ((0)),
	[item4_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item4_limitType]  DEFAULT ((0)),
	[item4_limitDate] [datetime] NOT NULL,
	[item5_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_type]  DEFAULT ((0)),
	[item5_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_reinforce]  DEFAULT ((0)),
	[item5_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_slotindex]  DEFAULT ((0)),
	[item5_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_tradetype]  DEFAULT ((0)),
	[item5_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_mcustom]  DEFAULT ((0)),
	[item5_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_fcustom]  DEFAULT ((0)),
	[item5_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item5_limitType]  DEFAULT ((0)),
	[item5_limitDate] [datetime] NOT NULL,
	[item6_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_type]  DEFAULT ((0)),
	[item6_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_reinforce]  DEFAULT ((0)),
	[item6_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_slotindex]  DEFAULT ((0)),
	[item6_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_tradetype]  DEFAULT ((0)),
	[item6_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_mcustom]  DEFAULT ((0)),
	[item6_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_fcustom]  DEFAULT ((0)),
	[item6_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item6_limitType]  DEFAULT ((0)),
	[item6_limitDate] [datetime] NOT NULL,
	[item7_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_type]  DEFAULT ((0)),
	[item7_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_reinforce]  DEFAULT ((0)),
	[item7_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_slotindex]  DEFAULT ((0)),
	[item7_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_tradetype]  DEFAULT ((0)),
	[item7_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_mcustom]  DEFAULT ((0)),
	[item7_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_fcustom]  DEFAULT ((0)),
	[item7_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item7_limitType]  DEFAULT ((0)),
	[item7_limitDate] [datetime] NOT NULL,
	[item8_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_type]  DEFAULT ((0)),
	[item8_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_reinforce]  DEFAULT ((0)),
	[item8_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_slotindex]  DEFAULT ((0)),
	[item8_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_tradetype]  DEFAULT ((0)),
	[item8_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_mcustom]  DEFAULT ((0)),
	[item8_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_fcustom]  DEFAULT ((0)),
	[item8_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item8_limitType]  DEFAULT ((0)),
	[item8_limitDate] [datetime] NOT NULL,
	[item9_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_type]  DEFAULT ((0)),
	[item9_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_reinforce]  DEFAULT ((0)),
	[item9_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_slotindex]  DEFAULT ((0)),
	[item9_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_tradetype]  DEFAULT ((0)),
	[item9_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_mcustom]  DEFAULT ((0)),
	[item9_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_fcustom]  DEFAULT ((0)),
	[item9_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item9_limitType]  DEFAULT ((0)),
	[item9_limitDate] [datetime] NOT NULL,
	[item10_type] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_type]  DEFAULT ((0)),
	[item10_reinforce] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_reinforce]  DEFAULT ((0)),
	[item10_slotindex] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_slotindex]  DEFAULT ((0)),
	[item10_tradetype] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_tradetype]  DEFAULT ((0)),
	[item10_mcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_mcustom]  DEFAULT ((0)),
	[item10_fcustom] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_fcustom]  DEFAULT ((0)),
	[item10_limitType] [int] NOT NULL CONSTRAINT [DF_userItemExtraDB_item10_limitType]  DEFAULT ((0)),
	[item10_limitDate] [datetime] NOT NULL,
	[regDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userFriendDB]    스크립트 날짜: 05/04/2012 13:58:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userFriendDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[userAccIDX] [int] NOT NULL,
	[friendAccIDX] [int] NOT NULL,
	[flag] [tinyint] NOT NULL CONSTRAINT [DF_userFriendDB_flag]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userFriendDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[z_nouse_userRankingDB_battle]    스크립트 날짜: 05/04/2012 14:03:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[z_nouse_userRankingDB_battle](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[win_fix] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_win_fix]  DEFAULT ((0)),
	[tie_fix] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_tie_fix]  DEFAULT ((0)),
	[lose_fix] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_lose_fix]  DEFAULT ((0)),
	[win_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_win_prev]  DEFAULT ((0)),
	[tie_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_tie_prev]  DEFAULT ((0)),
	[lose_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_lose_prev]  DEFAULT ((0)),
	[rank_prev] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_rank_prev]  DEFAULT ((0)),
	[rank_now] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_rank_now]  DEFAULT ((0)),
	[rank_total] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_rank_total]  DEFAULT ((0)),
	[rank_battle] [int] NOT NULL CONSTRAINT [DF_userRankingDB_battle_rank_battle]  DEFAULT ((0)),
	[regDate] [smalldatetime] NOT NULL CONSTRAINT [DF_userRankingDB_battle_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userRegionDB_compen]    스크립트 날짜: 05/04/2012 14:01:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRegionDB_compen](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[rt1point] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_rt1point]  DEFAULT ((0)),
	[rt1point_bonus] [int] NOT NULL CONSTRAINT [DF_userRegionDB_compen_rt1point_bonus]  DEFAULT ((0)),
	[rt1count] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_rt1count]  DEFAULT ((0)),
	[rt2point] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_rt2point]  DEFAULT ((0)),
	[rt2point_bonus] [int] NOT NULL CONSTRAINT [DF_userRegionDB_compen_rt2point_bonus]  DEFAULT ((0)),
	[rt2count] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_rt2count]  DEFAULT ((0)),
	[regionType] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_regionType]  DEFAULT ((0)),
	[renspoint] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_renspoint]  DEFAULT ((0)),
	[regionRanking] [int] NOT NULL CONSTRAINT [DF_userRegionDB_result_regionRanking]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userRegionDB_result_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userMemberDB]    스크립트 날짜: 05/04/2012 14:00:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[userMemberDB](
	[accountIDX] [int] IDENTITY(1,1) NOT NULL,
	[userID] [varchar](12) NOT NULL,
	[nickName] [varchar](20) NOT NULL,
	[userPWD] [varchar](24) NOT NULL,
	[EMail] [varchar](50) NOT NULL,
	[mailling] [tinyint] NOT NULL,
	[userType] [smallint] NOT NULL,
	[joinType] [smallint] NOT NULL,
	[eventType] [int] NOT NULL CONSTRAINT [DF_userMemberDB_eventType]  DEFAULT ((0)),
	[cpType] [int] NOT NULL CONSTRAINT [DF_userMemberDB_cpType]  DEFAULT ((0)),
	[limitType] [smallint] NOT NULL CONSTRAINT [DF_userMemberDB_limitType]  DEFAULT ((0)),
	[limitDate] [datetime] NOT NULL CONSTRAINT [DF_userMemberDB_limitDate]  DEFAULT ((0)),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userMemberDB_regDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_userMemberDB] PRIMARY KEY CLUSTERED 
(
	[userID] ASC,
	[nickName] 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
/****** 개체:  Table [dbo].[userRankingDB]    스크립트 날짜: 05/04/2012 14:00:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userRankingDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[class] [int] NOT NULL CONSTRAINT [DF_userRankingDB_general_class]  DEFAULT ((0)),
	[battle] [int] NOT NULL CONSTRAINT [DF_userRankingDB_general_battle]  DEFAULT ((0)),
	[training] [int] NOT NULL CONSTRAINT [DF_userRankingDB_general_training]  DEFAULT ((0)),
	[award] [int] NOT NULL CONSTRAINT [DF_userRankingDB_general_award]  DEFAULT ((0)),
	[medal] [int] NOT NULL CONSTRAINT [DF_userRankingDB_general_medal]  DEFAULT ((0)),
	[tester] [int] NOT NULL CONSTRAINT [DF_userRankingDB_general_tester]  DEFAULT ((0)),
	[region] [int] NOT NULL CONSTRAINT [DF_userRankingDB_region]  DEFAULT ((0)),
	[regDate] [smalldatetime] NOT NULL CONSTRAINT [DF_userRankingDB_general_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO
/****** 개체:  Table [dbo].[userAbilityDB]    스크립트 날짜: 05/04/2012 13:57:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[userAbilityDB](
	[idx] [int] IDENTITY(1,1) NOT NULL,
	[accountIDX] [int] NOT NULL,
	[class1_type] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_type]  DEFAULT ((0)),
	[class1_basic01] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_basic01]  DEFAULT ((0)),
	[class1_basic02] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_basic02]  DEFAULT ((0)),
	[class1_basic03] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_basic03]  DEFAULT ((0)),
	[class1_basic04] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_basic04]  DEFAULT ((0)),
	[class1_skill1_sd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_skill1_sd]  DEFAULT ((0)),
	[class1_skill1_asd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_skill1_asd]  DEFAULT ((0)),
	[class1_skill1_ad] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_skill1_ad]  DEFAULT ((0)),
	[class1_skill1_as] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_skill1_as]  DEFAULT ((0)),
	[class1_timeslot] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_timeslot]  DEFAULT ((0)),
	[class1_limitdate] [datetime] NOT NULL CONSTRAINT [DF_userAbilityDB_class1_limitdate]  DEFAULT (getdate()),
	[class2_type] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_type]  DEFAULT ((0)),
	[class2_basic01] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_basic01]  DEFAULT ((0)),
	[class2_basic02] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_basic02]  DEFAULT ((0)),
	[class2_basic03] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_basic03]  DEFAULT ((0)),
	[class2_basic04] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_basic04]  DEFAULT ((0)),
	[class2_skill1_sd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_skill1_sd]  DEFAULT ((0)),
	[class2_skill1_asd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_skill1_asd]  DEFAULT ((0)),
	[class2_skill1_ad] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_skill1_ad]  DEFAULT ((0)),
	[class2_skill1_as] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_skill1_as]  DEFAULT ((0)),
	[class2_timeslot] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_timeslot]  DEFAULT ((0)),
	[class2_limitdate] [datetime] NOT NULL CONSTRAINT [DF_userAbilityDB_class2_limitdate]  DEFAULT (getdate()),
	[class3_type] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_type]  DEFAULT ((0)),
	[class3_basic01] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_basic01]  DEFAULT ((0)),
	[class3_basic02] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_basic02]  DEFAULT ((0)),
	[class3_basic03] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_basic03]  DEFAULT ((0)),
	[class3_basic04] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_basic04]  DEFAULT ((0)),
	[class3_skill1_sd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_skill1_sd]  DEFAULT ((0)),
	[class3_skill1_asd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_skill1_asd]  DEFAULT ((0)),
	[class3_skill1_ad] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_skill1_ad]  DEFAULT ((0)),
	[class3_skill1_as] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_skill1_as]  DEFAULT ((0)),
	[class3_timeslot] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_timeslot]  DEFAULT ((0)),
	[class3_limitdate] [datetime] NOT NULL CONSTRAINT [DF_userAbilityDB_class3_limitdate]  DEFAULT (getdate()),
	[class4_type] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_type]  DEFAULT ((0)),
	[class4_basic01] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_basic01]  DEFAULT ((0)),
	[class4_basic02] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_basic02]  DEFAULT ((0)),
	[class4_basic03] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_basic03]  DEFAULT ((0)),
	[class4_basic04] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_basic04]  DEFAULT ((0)),
	[class4_skill1_sd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_skill1_sd]  DEFAULT ((0)),
	[class4_skill1_asd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_skill1_asd]  DEFAULT ((0)),
	[class4_skill1_ad] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_skill1_ad]  DEFAULT ((0)),
	[class4_skill1_as] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_skill1_as]  DEFAULT ((0)),
	[class4_timeslot] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_timeslot]  DEFAULT ((0)),
	[class4_limitdate] [datetime] NOT NULL CONSTRAINT [DF_userAbilityDB_class4_limitdate]  DEFAULT (getdate()),
	[class5_type] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_type]  DEFAULT ((0)),
	[class5_basic01] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_basic01]  DEFAULT ((0)),
	[class5_basic02] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_basic02]  DEFAULT ((0)),
	[class5_basic03] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_basic03]  DEFAULT ((0)),
	[class5_basic04] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_basic04]  DEFAULT ((0)),
	[class5_skill1_sd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_skill1_sd]  DEFAULT ((0)),
	[class5_skill1_asd] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_skill1_asd]  DEFAULT ((0)),
	[class5_skill1_ad] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_skill1_ad]  DEFAULT ((0)),
	[class5_skill1_as] [tinyint] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_skill1_as]  DEFAULT ((0)),
	[class5_timeslot] [int] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_timeslot]  DEFAULT ((0)),
	[class5_limitdate] [datetime] NOT NULL CONSTRAINT [DF_userAbilityDB_class5_limitdate]  DEFAULT (getdate()),
	[regDate] [datetime] NOT NULL CONSTRAINT [DF_userAbilityDB_regDate]  DEFAULT (getdate())
) ON [PRIMARY]
GO