if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbSliceInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbSliceInfo]
GO
CREATE TABLE [dbo].[tbSliceInfo] (
[SliceID] [int] IDENTITY (1, 1) NOT NULL ,
[sZoomLevel] [int] NOT NULL ,
[sLon] [numeric](18, 15) NOT NULL ,
[sLat] [numeric](18, 15) NOT NULL ,
[sImgAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sImgX] [int] NOT NULL ,
[sImgY] [int] NOT NULL ,
[sALon] [numeric](18, 15) NOT NULL ,
[sALat] [numeric](18, 15) NOT NULL ,
[sBLon] [numeric](18, 15) NOT NULL ,
[sBLat] [numeric](18, 15) NOT NULL ,
[sCLon] [numeric](18, 15) NOT NULL ,
[sCLat] [numeric](18, 15) NOT NULL ,
[sDLon] [numeric](18, 15) NOT NULL ,
[sDLat] [numeric](18, 15) NOT NULL ,
[sEstate] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sAppendTime] [datetime] NOT NULL ,
[sUpDateTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tbSliceInfo] ADD
CONSTRAINT [DF_tbSliceInfo_sAppendTime] DEFAULT (getdate()) FOR [sAppendTime],
CONSTRAINT [DF_tbSliceInfo_sUpDateTime] DEFAULT (getdate()) FOR [sUpDateTime]
GO
Mapx+Delphi做的地图切割工具
3星 · 超过75%的资源 需积分: 50 77 浏览量
2006-01-13
09:51:35
上传
评论
收藏 756KB RAR 举报
普通网友
- 粉丝: 882
- 资源: 2万+