表名：ZL_3DShop












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否 主键
2ShopNamenvarchar500   是 店铺名称
3ShopImgnvarchar1000   是 店铺图片
4UserIDint40   是 用户ID
5UserNamenvarchar500   是 用户名
6posXnvarchar500   是 X轴坐标
7posYnvarchar500   是 Y轴坐标
8ShopStatusint40   是 店铺状态
9Remindnvarchar500   是 备注

简要说明：

3D模块店铺表

CREATE TABLE [dbo].[ZL_3DShop] (

[ID] [int]  IDENTITY (1, 1)  NOT NULL,

[ShopName] [nvarchar]  (50) NULL,

[ShopImg] [nvarchar]  (100) NULL,

[UserID] [int]  NULL,

[UserName] [nvarchar]  (50) NULL,

[posX] [nvarchar]  (50) NULL,

[posY] [nvarchar]  (50) NULL,

[ShopStatus] [int]  NULL,

[Remind] [nvarchar]  (50) NULL)

ALTER TABLE [ZL_3DShop] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_3DShop] PRIMARY KEY  NONCLUSTERED ( [ID] )


SET IDENTITY_INSERT [ZL_3DShop] ON

INSERT [ZL_3DShop] ([ID],[ShopName],[ShopImg],[UserID],[UserName],[posX],[posY]) VALUES ( 1,N'日用百货',N'/Images/Style3D/c1.png',1,N'admin',N'600',N'210')

INSERT [ZL_3DShop] ([ID],[ShopName],[ShopImg],[UserID],[UserName],[posX],[posY]) VALUES ( 2,N'家居杂货',N'/Images/Style3D/node.gif',1,N'admin',N'500',N'300')

INSERT [ZL_3DShop] ([ID],[ShopName],[ShopImg],[UserID],[UserName],[posX],[posY]) VALUES ( 3,N'小靓服饰',N'/Images/Style3D/node.gif',1,N'admin',N'500',N'400')

INSERT [ZL_3DShop] ([ID],[ShopName],[ShopImg],[UserID],[UserName],[posX],[posY]) VALUES ( 4,N'华毅装修',N'/Images/Style3D/c1.png',1,N'admin',N'400',N'450')

SET IDENTITY_INSERT [ZL_3DShop] OFF




--注意：将清空全表数据

detele from ZL_3DShop

--注意：将删除整个表

drop table ZL_3DShop

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_3DShop