Project

General

Profile

« Previous | Next » 

Revision 1743

Added by Jing Tao over 20 years ago

Fix somebugs for the script.

View differences:

src/xmltables-sqlserver.sql
40 40 
  [perm_order]		[varchar] (50) NULL ,
41 41 
  [begin_time]		[datetime] NULL ,
42 42 
  [end_time]		[datetime] NULL ,
43 
  [ticket_count]	[int] NULL
43 
  [ticket_count]	[int] NULL ,
44 44 
  [subtreeid]  [varchar] (250) NULL ,
45 45 
  [startnodeid]  [bigint] NULL ,
46 46 
  [endnodeid]  [bigint] NULL
......
113 113 
  [nodeindex]		[int] NULL ,
114 114 
  [nodetype]		[varchar] (20) NULL ,
115 115 
  [nodename]		[varchar] (250) NULL ,
116 
  [nodeprefix]	        [varchar] (50) NULL ,
116 117 
  [nodedata]		[varchar] (4000) NULL ,
117 118 
  [parentnodeid]	[bigint] NULL ,
118 119 
  [rootnodeid]		[bigint] NULL ,
......
144 145 
  [serverid]		[bigint] IDENTITY (1, 1) NOT NULL ,
145 146 
  [server]		[varchar] (512) NULL ,
146 147 
  [last_checked]	[datetime] NULL ,
147 
  [replicate]  [bit] NULL
148 
  [datareplicate]  [bit] NULL
148 
  [replicate]  [bit] NULL ,
149 
  [datareplicate]  [bit] NULL ,
149 150 
  [hub]  [bit] NULL
150 151 
) ON [PRIMARY]
151 152 
GO

Also available in: Unified diff