TWyWrd3h

1SET ANSI_NULLS ON
2GO
3SET QUOTED_IDENTIFIER ON
4GO
5IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[AItemCode]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
6BEGIN
7CREATE TABLE [dbo].[AItemCode](
8	[ItemCode] [nvarchar](25) NOT NULL,
9	[KorName] [nvarchar](50) NOT NULL,
10	[EngName] [nvarchar](50) NULL
11) ON [PRIMARY]
12END
13GO
14SET ANSI_NULLS ON
15GO
16SET QUOTED_IDENTIFIER ON
17GO
18IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ITEMCODE]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
19BEGIN
20CREATE TABLE [dbo].[ITEMCODE](
21	[ITEMNo] [int] NOT NULL,
22	[Category] [varchar](50) NULL,
23	[CodeHName] [varchar](50) NULL,
24	[CodeEName] [varchar](50) NULL,
25	[Code] [int] NULL
26) ON [PRIMARY]
27END
28GO
29SET ANSI_NULLS ON
30GO
31SET QUOTED_IDENTIFIER ON
32GO
33IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[IL]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
34BEGIN
35CREATE TABLE [dbo].[IL](
36	[ITEMNo] [int] IDENTITY(1,1) NOT NULL,
37	[UserID] [varchar](50) NULL,
38	[CharName] [varchar](50) NULL,
39	[IP] [varchar](50) NULL,
40	[Flag] [int] NULL,
41	[TUserID] [varchar](50) NULL,
42	[TCharName] [varchar](50) NULL,
43	[TMoney] [int] NULL,
44	[TIP] [varchar](50) NULL,
45	[ItemCount] [int] NULL,
46	[ItemCode] [int] NULL,
47	[ItemINo] [int] NULL,
48	[ItemINo_1] [int] NULL,
49	[RegistDay] [datetime] NULL
50) ON [PRIMARY]
51END