表名:ZL_S_shop












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40    
2picsntext160   ''组图

简要说明:

商城副表

GO
CREATE TABLE [dbo].[ZL_S_shop] (
[ID] [int]  IDENTITY (1, 1)  NOT NULL,
[pics] [ntext]  NULL DEFAULT ('')
)
SET IDENTITY_INSERT [ZL_S_shop] ON
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 1,N'[{"url":"demo/04.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 2,N'[{"url":"Image/20170410/6362744428277491261485607.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 3,N'[{"url":"System/field/images/20170329/20170329Pm6cJf.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 4,N'[{"url":"System/field/images/20170411/20170411aXIXwN.jpg","desc":""},{"url":"System/field/images/20170411/201704114g5jMX.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID]) VALUES ( 5)
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 6,N'[{"url":"System/field/images/20170411/20170411VlzX48.jpg","desc":""},{"url":"System/field/images/20170411/201704119JFTYK.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 7,N'[{"url":"Image/20170411/6362750178443079792077573.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 8,N'[{"url":"Image/20170411/6362750199536030522006647.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 9,N'[{"url":"Image/20170411/6362750217217091872588519.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 10,N'[{"url":"Image/20170411/6362750223499394112027278.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 11,N'[{"url":"System/field/images/20170411/201704114lPDtO.jpg","desc":""},{"url":"System/field/images/20170411/20170411Ynekwy.jpg","desc":""},{"url":"System/field/images/20170411/20170411U8pSzB.jpg","desc":""},{"url":"System/field/images/20170411/20170411g40odM.jpg","desc":""},{"url":"System/field/images/20170411/20170411VtwsG4.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 12,N'[{"url":"System/field/images/20170411/20170411HMfsVF.jpg","desc":""},{"url":"System/field/images/20170411/201704113mMGNn.jpg","desc":""},{"url":"System/field/images/20170411/201704114Q5f0B.jpg","desc":""},{"url":"System/field/images/20170411/201704117J9sgE.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 13,N'[{"url":"System/field/images/20170411/20170411sVgFtj.jpg","desc":""},{"url":"System/field/images/20170411/20170411bclEku.jpg","desc":""},{"url":"System/field/images/20170411/20170411F8FJ7y.jpg","desc":""},{"url":"System/field/images/20170411/20170411aRYUlX.jpg","desc":""},{"url":"System/field/images/20170411/201704118i9IWs.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 14,N'[{"url":"System/field/images/20170411/201704110UvFg1.jpg","desc":""},{"url":"System/field/images/20170411/20170411AyAOq8.jpg","desc":""},{"url":"System/field/images/20170411/2017041156E18J.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 15,N'[{"url":"System/field/images/20170411/20170411PPBVZl.jpg","desc":""},{"url":"System/field/images/20170411/20170411cViZa3.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 16,N'[{"url":"System/field/images/20170411/201704113ONj1G.jpg","desc":""},{"url":"System/field/images/20170411/20170411If6Msb.jpg","desc":""},{"url":"System/field/images/20170411/20170411ZeLh1X.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 17,N'[{"url":"System/field/images/20170411/20170411Py4nOt.jpg","desc":""},{"url":"System/field/images/20170411/20170411fNiJTZ.jpg","desc":""},{"url":"System/field/images/20170411/20170411ASzMH5.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 18,N'[{"url":"System/field/images/20170411/20170411sQbQsE.jpg","desc":""},{"url":"System/field/images/20170411/20170411E3nNJr.jpg","desc":""},{"url":"System/field/images/20170411/20170411AWYw0F.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 19,N'[{"url":"System/field/images/20170411/20170411Jx8MtT.jpg","desc":""},{"url":"System/field/images/20170411/201704114C6ri4.jpg","desc":""},{"url":"System/field/images/20170411/201704112WfMUJ.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 20,N'[{"url":"System/field/images/20170411/20170411FzEuce.jpg","desc":""},{"url":"System/field/images/20170411/20170411wwoZPE.jpg","desc":""},{"url":"System/field/images/20170411/20170411rUgylX.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 21,N'[{"url":"System/field/images/20170411/20170411r392sW.jpg","desc":""},{"url":"System/field/images/20170411/201704110WuddD.jpg","desc":""},{"url":"System/field/images/20170411/20170411Rt0Amk.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 22,N'[{"url":"System/field/images/20170411/20170411G3EkCT.jpg","desc":""},{"url":"System/field/images/20170411/20170411Por8VQ.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 23,N'[{"url":"System/field/images/20170411/201704114da4jC.jpg","desc":""},{"url":"System/field/images/20170411/20170411okAOrI.jpg","desc":""},{"url":"System/field/images/20170411/20170411SpnzFM.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 24,N'[{"url":"System/field/images/20170411/20170411N374D7.jpg","desc":""},{"url":"System/field/images/20170411/20170411eJhAbd.jpg","desc":""},{"url":"System/field/images/20170411/20170411fQotv1.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 25,N'[{"url":"System/field/images/20170411/2017041158Mrd1.jpg","desc":""},{"url":"System/field/images/20170411/20170411DWXnkx.jpg","desc":""},{"url":"System/field/images/20170411/20170411F3M2Jx.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 26,N'[{"url":"System/field/images/20170411/20170411pbbseL.jpg","desc":""},{"url":"System/field/images/20170411/20170411QiURzQ.jpg","desc":""},{"url":"System/field/images/20170411/201704118UpO9J.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 27,N'[{"url":"System/field/images/20170411/20170411Srzy9i.jpg","desc":""},{"url":"System/field/images/20170411/20170411D0KVGL.jpg","desc":""},{"url":"System/field/images/20170411/20170411dW8AXV.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 28,N'[{"url":"System/field/images/20170411/20170411q00vIy.jpg","desc":""},{"url":"System/field/images/20170411/20170411dCnRKz.jpg","desc":""},{"url":"System/field/images/20170411/20170411hPXsSk.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 29,N'[{"url":"System/field/images/20170411/20170411JIziKx.jpg","desc":""},{"url":"System/field/images/20170411/20170411Lpd2UM.jpg","desc":""},{"url":"System/field/images/20170411/20170411fQqL4m.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 30,N'[{"url":"System/field/images/20170411/201704118gZ1uo.jpg","desc":""},{"url":"System/field/images/20170411/20170411VSYRtN.jpg","desc":""},{"url":"System/field/images/20170411/20170411oxC558.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 31,N'[{"url":"System/field/images/20170411/20170411jZ4H01.jpg","desc":""},{"url":"System/field/images/20170411/20170411l3wCaM.jpg","desc":""},{"url":"System/field/images/20170411/201704115p44ub.jpg","desc":""},{"url":"System/field/images/20170411/20170411rq9xmL.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 32,N'[{"url":"System/field/images/20170411/20170411gikV0U.jpg","desc":""},{"url":"System/field/images/20170411/20170411JMbfSB.jpg","desc":""},{"url":"System/field/images/20170411/20170411mqs3vl.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 33,N'[{"url":"Image/20170411/6362750603319926541573848.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 34,N'[{"url":"Image/20170411/6362750609689041513584539.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 35,N'[{"url":"Image/20170411/6362750620030002232792890.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 36,N'[{"url":"Image/20170411/6362750626073241041161313.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 37,N'[{"url":"Image/20170411/6362750648738935244351256.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 38,N'[{"url":"Image/20170411/6362750670678745136587621.jpg","desc":""}]')
INSERT [ZL_S_shop] ([ID],[pics]) VALUES ( 39,N'[{"url":"Image/20170411/6362750677450076567666285.jpg","desc":""}]')
SET IDENTITY_INSERT [ZL_S_shop] OFF

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

detele from ZL_S_shop

--注意:将删除整个表

drop table ZL_S_shop

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

TRUNCATE table ZL_S_shop