-- LosaDev 2014: src\sql\20120504\lostsaga_tb.sql (UTF-16 original) as UTF-8. 62 tables. 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