表名:ZL_Shop_PrintTlp












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2Aliasnvarchar500    别名
3Contentnvarchar10000    模板内容
4Remindnvarchar500    备注
5AdminIDint40    管理员ID
6CDatedatetime83    添加时间

简要说明:

飞印打印模板表

GO
CREATE TABLE [dbo].[ZL_Shop_PrintTlp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Alias] [nvarchar](50) NULL,
[Content] [nvarchar](1000) NULL,
[Remind] [nvarchar](50) NULL,
[AdminID] [int] NULL,
[CDate] [datetime] NULL,
CONSTRAINT [PK_ZL_Shop_PrintTlp] PRIMARY KEY CLUSTERED
([ID] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY]

GO
SET IDENTITY_INSERT [ZL_Shop_PrintTlp] ON
INSERT [ZL_Shop_PrintTlp] ([ID],[Alias],[Content],[Remind],[AdminID],[CDate]) VALUES ( 2,N'订购模板',N'逐浪CMS帮助中心欢迎订购!
订单编号:{OrderNo}
订购时间:{AddTime}
客户姓名:{Reuser}
来电号码:{MobileNum}
送货地址:{Shengfen} {Jiedao}
商品名称    单价    数量    小计
----------------
[ERR:("获取购物车商品")标签不存在]

备注:{Ordermessage}
----------------
合计:{Ordersamount}元',N'adfasdf',0,N'2016/5/4 16:47:29')
SET IDENTITY_INSERT [ZL_Shop_PrintTlp] OFF

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

detele from ZL_Shop_PrintTlp

--注意:将删除整个表

drop table ZL_Shop_PrintTlp

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

TRUNCATE table ZL_Shop_PrintTlp