GO

CREATE TABLE [dbo].[ZL_MailTemp] (
[ID] [int]  IDENTITY (1, 1)  NOT NULL,
[TempName] [nvarchar]  (255) NULL,
[Pic] [nvarchar]  (255) NULL,
[Type] [int]  NULL,
[AddUser] [nvarchar]  (50) NULL,
[CreateTime] [datetime]  NULL,
[Content] [ntext]  NULL)
GO

ALTER TABLE [ZL_MailTemp] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_MailTemp] PRIMARY KEY  NONCLUSTERED ( [ID] )
SET IDENTITY_INSERT [ZL_MailTemp] ON
INSERT [ZL_MailTemp] ([ID],[TempName],[Pic],[Type],[AddUser],[CreateTime],[Content]) VALUES ( 3,N'测试模板',N'UploadFiles/Nopic.gif',1,N'admin',N'2016-9-17 15:54:55',N'<table border="0" cellpadding="0" style="background: rgb(239, 239, 239); width: 100%;">
<tbody>
<tr>
<td>
<table align="center" border="0" cellpadding="0" cellspacing="0" style="padding: 10px; width: 760px;">
<tbody>
<tr>
<td>
<p align="left">/images/logo_w.svg</p>
</td>
<td><p align="right">The following message was generated before2012/9/15 8:54:21</p></td>
</tr>
</tbody>
</table>
<div style="clear: both;">
&nbsp;</div>
<table align="center" cellpadding="0" cellspacing="0" height="70" style="background: rgb(255, 255, 255); padding: 30px; border: 1px solid rgb(217, 217, 217); width: 700px; font-size: 12px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="color: rgb(136, 136, 155);" width="100%">
<tbody>
<tr>
<td><h1>[ERR:未定义的系统标签(Title)请检查标签名是否正确]</h1></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td>
<div align="center">
<hr align="center" size="2" width="100%" />
</div>
<p>Dear&nbsp;&nbsp;Zoomla,</p>
<p>I&#39;m interested in your product(s)</p>
<p align="left">&nbsp;</p>
<table cellpadding="0" cellspacing="0" style="border: 1px solid rgb(217, 217, 217);">
<tbody>
<tr><td>
<p>内容区</p>
</td>
</tr>
</tbody>
</table>
<p align="left">&nbsp;</p>
<table cellpadding="0" cellspacing="0" style="border: 1px solid rgb(217, 217, 217); width: 100%;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="width: 100%;">
<tbody>
<tr>
<td style="width: 42px;">
[ERR:未定义的系统标签(UserFace)请检查标签名是否正确]</td>
<td style="width: 500px;">
<h4><a href="[ERR:未定义的系统标签(SiteUrl)请检查标签名是否正确]/User/Login">Mr.[ERR:未定义的系统标签(HoneyName)请检查标签名是否正确]</a></h4>
</td>
<td>
&nbsp;</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td style="width: 148px;">
<strong>Company: </strong></td>
<td style="width: 430px;">
&nbsp;[ERR:未定义的系统标签(Company)请检查标签名是否正确]</td>
</tr>
<tr>
<td>
<strong>Country/Region: </strong></td>
<td style="width: 430px;">
&nbsp;[ERR:未定义的系统标签(Country)请检查标签名是否正确]/[ERR:未定义的系统标签(Province)请检查标签名是否正确][ERR:未定义的系统标签(City)请检查标签名是否正确]</td>
</tr>
<tr>
<td>
<strong>Address: </strong></td>
<td style="width: 430px;">
[ERR:未定义的系统标签(County)请检查标签名是否正确][ERR:未定义的系统标签(Address)请检查标签名是否正确] ([ERR:未定义的系统标签(ZipCode)请检查标签名是否正确])</td>
</tr>
<tr>
<td>
<strong>Email:</strong></td>
<td style="width: 430px;">&nbsp;[ERR:未定义的系统标签(Email)请检查标签名是否正确]</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td></tr>
</tbody>
</table>
</td></tr>
</tbody></table>
<p>&nbsp;</p>')
SET IDENTITY_INSERT [ZL_MailTemp] OFF