createtables.sql

来自「《SVG开发实践》源代码」· SQL 代码 · 共 42 行

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CityData]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CityData](
	[name] [nchar](10) NULL,
	[lat] [float] NULL,
	[lon] [float] NULL,
	[weather] [nchar](10) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[rtData]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[rtData](
	[Second] [int] NULL,
	[x] [int] NULL,
	[y] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[nonRtData]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[nonRtData](
	[ID] [nchar](10) NULL,
	[name] [nchar](20) NULL,
	[URL] [nchar](20) NULL,
	[x] [int] NULL,
	[y] [int] NULL
) ON [PRIMARY]
END