fZBSNVdn

1SET ANSI_NULLS ON
2GO
3SET QUOTED_IDENTIFIER ON
4GO
5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanHome]') AND type in (N'U'))
6BEGIN
7CREATE TABLE [dbo].[ClanHome](
8	[IDX] [int] NOT NULL,
9	[MIDX] [int] NOT NULL,
10	[SelServer] [int] NOT NULL,
11	[Intro] [nvarchar](300) NULL,
12	[Image] [nvarchar](50) NULL,
13	[Skin] [int] NULL,
14	[PrivHome] [int] NULL,
15	[PrivMem] [int] NULL,
16	[PrivBoard] [int] NULL
17) ON [PRIMARY]
18END
19GO
20SET ANSI_NULLS ON
21GO
22SET QUOTED_IDENTIFIER ON
23GO
24IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMainCharChangeLog]') AND type in (N'U'))
25BEGIN
26CREATE TABLE [dbo].[ClanMainCharChangeLog](
27	[IDX] [int] NOT NULL,
28	[UserID] [varchar](50) NULL,
29	[BeforeCharName] [varchar](50) NULL,
30	[AfterCharName] [varchar](50) NULL,
31	[CServer] [int] NULL,
32	[RegiDate] [datetime] NULL
33) ON [PRIMARY]
34END
35GO
36SET ANSI_NULLS ON
37GO
38SET QUOTED_IDENTIFIER ON
39GO
40IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMainDeleted]') AND type in (N'U'))
41BEGIN
42CREATE TABLE [dbo].[ClanMainDeleted](
43	[IDX] [int] NOT NULL,
44	[MIDX] [int] NOT NULL,
45	[ClanName] [nvarchar](50) NOT NULL,
46	[Userid] [nvarchar](50) NULL,
47	[ClanZang] [nvarchar](50) NOT NULL,
48	[Flag] [int] NOT NULL,
49	[MemCnt] [int] NOT NULL,
50	[MIConCnt] [int] NOT NULL,
51	[RegiDate] [datetime] NOT NULL,
52	[LimitDate] [datetime] NOT NULL,
53	[DelDate] [datetime] NOT NULL,
54	[DelActive] [char](1) NOT NULL,
55	[PFlag] [int] NOT NULL,
56	[KFlag] [int] NOT NULL,
57	[DelState] [char](1) NOT NULL,
58	[DelCase] [char](10) NOT NULL,
59	[Server] [int] NOT NULL
60) ON [PRIMARY]
61END
62GO
63SET ANSI_NULLS ON
64GO
65SET QUOTED_IDENTIFIER ON
66GO
67IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMainView]') AND type in (N'U'))
68BEGIN
69CREATE TABLE [dbo].[ClanMainView](
70	[IDX] [int] NOT NULL,
71	[ClanName] [nvarchar](50) NOT NULL,
72	[Note] [text] NOT NULL,
73	[NoteCnt] [int] NOT NULL,
74	[UserID] [nvarchar](50) NULL,
75	[ClanZang] [nvarchar](50) NOT NULL,
76	[Flag] [int] NOT NULL,
77	[MemCnt] [int] NOT NULL,
78	[MIconCnt] [int] NOT NULL,
79	[RegiDate] [datetime] NOT NULL,
80	[LimitDate] [datetime] NOT NULL,
81	[DelActive] [char](1) NOT NULL,
82	[PFlag] [int] NOT NULL,
83	[KFlag] [int] NOT NULL,
84	[Cpoint] [int] NULL,
85	[CWin] [int] NULL,
86	[CFail] [int] NULL,
87	[ClanMoney] [bigint] NULL,
88	[CNFlag] [int] NULL,
89	[SiegeMoney] [bigint] NULL,
90	[Server] [varchar](1) NOT NULL
91) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
92END
93GO
94SET ANSI_NULLS ON
95GO
96SET QUOTED_IDENTIFIER ON
97GO
98IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMoneyLog]') AND type in (N'U'))
99BEGIN
100CREATE TABLE [dbo].[ClanMoneyLog](
101	[IDX] [int] NOT NULL,
102	[CIDX] [int] NULL,
103	[UserID] [varchar](50) NULL,
104	[chName] [varchar](50) NULL,
105	[ServerName] [varchar](50) NULL,
106	[Operator] [varchar](50) NULL,
107	[OperCode] [char](10) NULL,
108	[ClanMoney] [bigint] NULL,
109	[RegistDay] [datetime] NULL,
110	[Note] [varchar](50) NULL
111) ON [PRIMARY]
112END
113GO
114SET ANSI_NULLS ON
115GO
116SET QUOTED_IDENTIFIER ON
117GO
118IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanSubCharChangeLog]') AND type in (N'U'))
119BEGIN
120CREATE TABLE [dbo].[ClanSubCharChangeLog](
121	[IDX] [int] NOT NULL,
122	[UserID] [varchar](50) NULL,
123	[BeforeCharName] [varchar](50) NULL,
124	[AfterCharName] [varchar](50) NULL,
125	[CServer] [int] NULL,
126	[RegiDate] [datetime] NULL
127) ON [PRIMARY]
128END
129GO
130SET ANSI_NULLS ON
131GO
132SET QUOTED_IDENTIFIER ON
133GO
134IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanSubDeleted]') AND type in (N'U'))
135BEGIN
136CREATE TABLE [dbo].[ClanSubDeleted](
137	[IDX] [int] NOT NULL,
138	[MIDX] [int] NOT NULL,
139	[userid] [nvarchar](50) NOT NULL,
140	[ChName] [nvarchar](50) NOT NULL,
141	[ChType] [int] NULL,
142	[ChLv] [int] NULL,
143	[ClanName] [nvarchar](50) NULL,
144	[Permi] [char](2) NOT NULL,
145	[JoinDate] [datetime] NOT NULL,
146	[DelActive] [char](1) NOT NULL,
147	[PFlag] [int] NOT NULL,
148	[KFlag] [int] NOT NULL,
149	[DelDate] [datetime] NOT NULL,
150	[DelState] [char](1) NOT NULL,
151	[DelCase] [char](10) NULL,
152	[Server] [int] NOT NULL
153) ON [PRIMARY]
154END
155GO
156SET ANSI_NULLS ON
157GO
158SET QUOTED_IDENTIFIER ON
159GO
160IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanSubView]') AND type in (N'U'))
161BEGIN
162CREATE TABLE [dbo].[ClanSubView](
163	[IDX] [int] NOT NULL,
164	[MIDX] [int] NOT NULL,
165	[userid] [nvarchar](50) NOT NULL,
166	[ChName] [nvarchar](50) NOT NULL,
167	[ChType] [int] NULL,
168	[ChLv] [int] NULL,
169	[ClanName] [nvarchar](50) NULL,
170	[Permi] [char](2) NOT NULL,
171	[JoinDate] [datetime] NOT NULL,
172	[DelActive] [char](1) NOT NULL,
173	[PFlag] [int] NOT NULL,
174	[KFlag] [int] NOT NULL,
175	[Server] [varchar](1) NOT NULL
176) ON [PRIMARY]
177END
178GO
179SET ANSI_NULLS ON
180GO
181SET QUOTED_IDENTIFIER ON
182GO
183IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanTicket]') AND type in (N'U'))
184BEGIN
185CREATE TABLE [dbo].[ClanTicket](
186	[SNo] [int] NULL,
187	[ServerName] [varchar](50) NULL,
188	[MIDX] [int] NULL,
189	[ClanName] [varchar](50) NULL,
190	[ClanJang] [int] NULL,
191	[ClanImage] [varchar](50) NULL,
192	[UserID] [varchar](25) NULL,
193	[ChName] [varchar](50) NULL,
194	[GPCode] [varchar](20) NULL,
195	[LogonTime] [datetime] NULL,
196	[IP] [varchar](20) NULL,
197	[RNo] [int] NULL,
198	[Flag] [int] NULL
199) ON [PRIMARY]
200END
201GO
202SET ANSI_NULLS ON
203GO
204SET QUOTED_IDENTIFIER ON
205GO
206IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GameNotice]') AND type in (N'U'))
207BEGIN
208CREATE TABLE [dbo].[GameNotice](
209	[UserID] [varchar](50) NULL,
210	[ChName] [varchar](50) NULL,
211	[Server] [int] NULL,
212	[PFlag] [int] NULL,
213	[Txt] [varchar](1000) NULL,
214	[Flag] [tinyint] NULL
215) ON [PRIMARY]
216END
217GO
218SET ANSI_NULLS ON
219GO
220SET QUOTED_IDENTIFIER ON
221GO
222IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GameNoticeGroup]') AND type in (N'U'))
223BEGIN
224CREATE TABLE [dbo].[GameNoticeGroup](
225	[IDX] [int] NOT NULL,
226	[GroupCD] [int] NOT NULL,
227	[MainCD] [int] NOT NULL,
228	[DetailCD] [int] NOT NULL,
229	[Title] [varchar](50) NOT NULL,
230	[Content] [text] NOT NULL,
231	[FromDay] [datetime] NOT NULL,
232	[ToDay] [datetime] NOT NULL,
233	[RegistDay] [datetime] NOT NULL,
234	[DelActive] [int] NOT NULL,
235	[Hit] [int] NOT NULL,
236	[Flag] [tinyint] NULL
237) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
238END
239GO
240SET ANSI_NULLS ON
241GO
242SET QUOTED_IDENTIFIER ON
243GO
244IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GameNoticePrivate]') AND type in (N'U'))
245BEGIN
246CREATE TABLE [dbo].[GameNoticePrivate](
247	[IDX] [int] NOT NULL,
248	[Userid] [varchar](50) NOT NULL,
249	[Title] [varchar](50) NOT NULL,
250	[Content] [text] NOT NULL,
251	[FromDay] [datetime] NOT NULL,
252	[ToDay] [datetime] NOT NULL,
253	[RegistDay] [datetime] NOT NULL,
254	[DelActive] [int] NOT NULL,
255	[Hit] [int] NOT NULL,
256	[Flag] [tinyint] NULL
257) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
258END
259GO
260SET ANSI_NULLS ON
261GO
262SET QUOTED_IDENTIFIER ON
263GO
264IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Notice]') AND type in (N'U'))
265BEGIN
266CREATE TABLE [dbo].[Notice](
267	[IDX] [int] NOT NULL,
268	[MIDX] [int] NOT NULL,
269	[Userid] [varchar](25) NOT NULL,
270	[WriteName] [varchar](100) NOT NULL,
271	[Title] [varchar](600) NOT NULL,
272	[Content] [text] NOT NULL,
273	[SelServer] [int] NOT NULL,
274	[RegiDate] [datetime] NOT NULL,
275	[RegiIP] [char](15) NOT NULL,
276	[Hit] [int] NOT NULL
277) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
278END
279GO
280SET ANSI_NULLS ON
281GO
282SET QUOTED_IDENTIFIER ON
283GO
284IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PRBBSMain]') AND type in (N'U'))
285BEGIN
286CREATE TABLE [dbo].[PRBBSMain](
287	[IDX] [int] NOT NULL,
288	[PMNo] [varchar](20) NOT NULL,
289	[Userid] [varchar](25) NOT NULL,
290	[Title] [varchar](600) NOT NULL,
291	[Content] [text] NOT NULL,
292	[UserName] [varchar](100) NOT NULL,
293	[ClanIdx] [int] NOT NULL,
294	[SelServer] [int] NOT NULL,
295	[RegiDate] [datetime] NOT NULL,
296	[RegiIP] [char](15) NOT NULL,
297	[Hit] [int] NOT NULL,
298	[CountCom] [int] NOT NULL
299) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
300END
301GO
302SET ANSI_NULLS ON
303GO
304SET QUOTED_IDENTIFIER ON
305GO
306IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PRBBSSub]') AND type in (N'U'))
307BEGIN
308CREATE TABLE [dbo].[PRBBSSub](
309	[SIDX] [int] NOT NULL,
310	[MINDEX] [int] NOT NULL,
311	[PMNo] [varchar](20) NOT NULL,
312	[userid] [varchar](25) NOT NULL,
313	[writename] [varchar](100) NOT NULL,
314	[Content] [text] NOT NULL,
315	[RegiDate] [datetime] NOT NULL,
316	[RegiIP] [char](15) NOT NULL,
317	[UserName] [varchar](100) NOT NULL
318) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
319END
320GO
321SET ANSI_NULLS ON
322GO
323SET QUOTED_IDENTIFIER ON
324GO
325IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PRBbsFile]') AND type in (N'U'))
326BEGIN
327CREATE TABLE [dbo].[PRBbsFile](
328	[IDX] [int] NOT NULL,
329	[MINDEX] [int] NOT NULL,
330	[FileName] [varchar](255) NOT NULL,
331	[FileSize] [varchar](100) NOT NULL,
332	[RegiDate] [datetime] NOT NULL
333) ON [PRIMARY]
334END
335GO
336SET ANSI_NULLS ON
337GO
338SET QUOTED_IDENTIFIER ON
339GO
340IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeClanList]') AND type in (N'U'))
341BEGIN
342CREATE TABLE [dbo].[SiegeClanList](
343	[IDX] [int] NOT NULL,
344	[UserID] [varchar](50) NOT NULL,
345	[CharName] [varchar](50) NOT NULL,
346	[ClanName] [varchar](50) NOT NULL,
347	[TaxRate] [int] NOT NULL,
348	[ServerName] [varchar](50) NOT NULL,
349	[Server] [tinyint] NOT NULL,
350	[OperFrom] [datetime] NULL,
351	[OperTo] [datetime] NULL,
352	[RegistDay] [datetime] NOT NULL
353) ON [PRIMARY]
354END
355GO
356SET ANSI_NULLS ON
357GO
358SET QUOTED_IDENTIFIER ON
359GO
360IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeCurrentList]') AND type in (N'U'))
361BEGIN
362CREATE TABLE [dbo].[SiegeCurrentList](
363	[IDX] [int] NOT NULL,
364	[CIDX] [int] NULL,
365	[UserID] [varchar](50) NULL,
366	[chName] [varchar](50) NULL,
367	[ServerName] [varchar](50) NULL,
368	[Operator] [varchar](50) NULL,
369	[OperCode] [char](10) NULL,
370	[SiegeMoney] [bigint] NULL,
371	[RegistDay] [datetime] NULL
372) ON [PRIMARY]
373END
374GO
375SET ANSI_NULLS ON
376GO
377SET QUOTED_IDENTIFIER ON
378GO
379IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeMoneyTax]') AND type in (N'U'))
380BEGIN
381CREATE TABLE [dbo].[SiegeMoneyTax](
382	[DNo] [int] IDENTITY(1,1) NOT NULL,
383	[IDX] [int] NULL,
384	[Mixing] [bigint] NULL,
385	[Aging] [bigint] NULL,
386	[Shop] [bigint] NULL,
387	[Poison1] [bigint] NULL,
388	[Poison2] [bigint] NULL,
389	[Poison3] [bigint] NULL,
390	[Force] [bigint] NULL,
391	[Warpgate] [bigint] NULL,
392	[Skill] [bigint] NULL,
393	[Total] [bigint] NULL,
394	[Tax] [bigint] NULL,
395	[ServerName] [varchar](50) NULL,
396	[RegistDay] [datetime] NULL
397) ON [PRIMARY]
398END
399GO
400SET ANSI_NULLS ON
401GO
402SET QUOTED_IDENTIFIER ON
403GO
404IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeMoneyLog]') AND type in (N'U'))
405BEGIN
406CREATE TABLE [dbo].[SiegeMoneyLog](
407	[IDX] [int] IDENTITY(1,1) NOT NULL,
408	[CIDX] [int] NULL,
409	[UserID] [varchar](50) NULL,
410	[chName] [varchar](50) NULL,
411	[ServerName] [varchar](50) NULL,
412	[Operator] [varchar](50) NULL,
413	[OperCode] [char](10) NULL,
414	[SiegeMoney] [bigint] NULL,
415	[RegistDay] [datetime] NULL
416) ON [PRIMARY]
417END
418GO
419SET ANSI_NULLS ON
420GO
421SET QUOTED_IDENTIFIER ON
422GO
423IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UL]') AND type in (N'U'))
424BEGIN
425CREATE TABLE [dbo].[UL](
426	[IDX] [int] NOT NULL,
427	[MIDX] [int] IDENTITY(1,1) NOT NULL,
428	[userid] [nvarchar](50) NOT NULL,
429	[ChName] [nvarchar](50) NOT NULL,
430	[ChType] [int] NULL,
431	[ChLv] [int] NULL,
432	[ClanName] [nvarchar](50) NULL,
433	[Permi] [char](2) NOT NULL,
434	[JoinDate] [datetime] NOT NULL,
435	[DelActive] [char](1) NOT NULL,
436	[PFlag] [int] NOT NULL,
437	[KFlag] [int] NOT NULL,
438	[MIconCnt] [int] NOT NULL
439) ON [PRIMARY]
440END
441GO
442SET ANSI_NULLS ON
443GO
444SET QUOTED_IDENTIFIER ON
445GO
446IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CL]') AND type in (N'U'))
447BEGIN
448CREATE TABLE [dbo].[CL](
449	[IDX] [int] IDENTITY(1,1) NOT NULL,
450	[ClanName] [nvarchar](50) NOT NULL,
451	[Note] [text] NOT NULL,
452	[NoteCnt] [int] NOT NULL,
453	[UserID] [nvarchar](50) NULL,
454	[ClanZang] [nvarchar](50) NOT NULL,
455	[Flag] [int] NOT NULL,
456	[MemCnt] [int] NOT NULL,
457	[MIconCnt] [int] NOT NULL,
458	[RegiDate] [datetime] NOT NULL,
459	[LimitDate] [datetime] NOT NULL,
460	[DelActive] [char](1) NOT NULL,
461	[PFlag] [int] NOT NULL,
462	[KFlag] [int] NOT NULL,
463	[Cpoint] [int] NULL,
464	[CWin] [int] NULL,
465	[CFail] [int] NULL,
466	[ClanMoney] [bigint] NULL,
467	[CNFlag] [int] NULL,
468	[SiegeMoney] [bigint] NULL
469) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
470END
471GO
472SET ANSI_NULLS ON
473GO
474SET QUOTED_IDENTIFIER ON
475GO
476IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CT]') AND type in (N'U'))
477BEGIN
478CREATE TABLE [dbo].[CT](
479	[SNo] [int] NULL,
480	[ServerName] [varchar](50) NULL,
481	[MIDX] [int] NULL,
482	[ClanName] [varchar](50) NULL,
483	[ClanJang] [int] NULL,
484	[ClanImage] [varchar](50) NULL,
485	[UserID] [varchar](25) NULL,
486	[ChName] [varchar](50) NULL,
487	[GPCode] [varchar](20) NULL,
488	[LogonTime] [datetime] NULL,
489	[IP] [varchar](20) NULL,
490	[RNo] [int] NULL,
491	[Flag] [int] NULL
492) ON [PRIMARY]
493END
494GO
495SET ANSI_NULLS ON
496GO
497SET QUOTED_IDENTIFIER ON
498GO
499IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LI]') AND type in (N'U'))
500BEGIN
501CREATE TABLE [dbo].[LI](
502	[IMG] [int] NOT NULL,
503	[ID] [int] NOT NULL
504) ON [PRIMARY]
505END
506GO
507SET ANSI_NULLS ON
508GO
509SET QUOTED_IDENTIFIER ON
510GO
511IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BBSMain]') AND type in (N'U'))
512BEGIN
513CREATE TABLE [dbo].[BBSMain](
514	[IDX] [int] NOT NULL,
515	[MIDX] [int] NOT NULL,
516	[Userid] [varchar](25) NOT NULL,
517	[WriteName] [varchar](100) NOT NULL,
518	[Title] [varchar](600) NOT NULL,
519	[Content] [text] NOT NULL,
520	[SelServer] [int] NOT NULL,
521	[RegiDate] [datetime] NOT NULL,
522	[RegiIP] [char](15) NOT NULL,
523	[Hit] [int] NOT NULL,
524	[CountCom] [int] NOT NULL,
525	[NickName] [varchar](32) NULL
526) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
527END
528GO
529SET ANSI_NULLS ON
530GO
531SET QUOTED_IDENTIFIER ON
532GO
533IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BBSSub]') AND type in (N'U'))
534BEGIN
535CREATE TABLE [dbo].[BBSSub](
536	[SIDX] [int] NOT NULL,
537	[MINDEX] [int] NOT NULL,
538	[Userid] [varchar](25) NOT NULL,
539	[WriteName] [varchar](100) NOT NULL,
540	[Content] [text] NOT NULL,
541	[RegiDate] [datetime] NOT NULL,
542	[RegiIP] [char](15) NOT NULL,
543	[NickName] [varchar](32) NULL
544) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
545END
546GO
547SET ANSI_NULLS ON
548GO
549SET QUOTED_IDENTIFIER ON
550GO
551IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChipLog]') AND type in (N'U'))
552BEGIN
553CREATE TABLE [dbo].[ChipLog](
554	[LgIDX] [int] NOT NULL,
555	[CIDX] [int] NOT NULL,
556	[CServer] [int] NOT NULL,
557	[Userid] [varchar](50) NOT NULL,
558	[Chname] [varchar](50) NOT NULL,
559	[Permi] [char](2) NOT NULL,
560	[RegiDate] [datetime] NOT NULL
561) ON [PRIMARY]
562END