Database/Update/3.3.5/MySql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

DROP TABLE IF EXISTS `PersistKey`;
CREATE TABLE `PersistKey` (
	`ID` VARCHAR(100) CHARACTER SET utf8mb4  NOT NULL,
	`XML` LONGTEXT CHARACTER SET utf8mb4  NULL,
	`CreationDate` DATETIME  NULL,
	`ActivationDate` DATETIME  NULL,
	`ExpirationDate` DATETIME  NULL,
	PRIMARY KEY (`ID`)
);

DROP TABLE IF EXISTS `Subscription`;
CREATE TABLE `Subscription` (
	`ID` INT AUTO_INCREMENT  NOT NULL,
	`Email` VARCHAR(100) CHARACTER SET utf8mb4  NULL,
	`Phone` VARCHAR(100) CHARACTER SET utf8mb4  NULL,
	`Referrer` VARCHAR(500) CHARACTER SET utf8mb4  NULL,
	`IsValidate` TINYINT(1)  NULL,
	`Title` VARCHAR(50) CHARACTER SET utf8mb4  NULL,
	`Description` VARCHAR(500) CHARACTER SET utf8mb4  NULL,
	`Status` INT  NULL,
	`CreateBy` VARCHAR(50) CHARACTER SET utf8mb4  NULL,
	`CreatebyName` VARCHAR(100) CHARACTER SET utf8mb4  NULL,
	`CreateDate` DATETIME  NULL,
	`LastUpdateBy` VARCHAR(50) CHARACTER SET utf8mb4  NULL,
	`LastUpdateByName` VARCHAR(100) CHARACTER SET utf8mb4  NULL,
	`LastUpdateDate` DATETIME  NULL,
	PRIMARY KEY (`ID`)
);

insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Header_Copy','zh-CN','第一时间了解最新动态');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Header_Copy','en-US','Be the first to know');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Body_Copy','zh-CN','通过邮箱订阅我们，您将可以在第一时间收到我们的相关信息');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Body_Copy','en-US','Subscribe by email, you will be able to receive our related information at the first time');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Footer_Copy','zh-CN','我们承诺严格遵守隐私政策处理您的信息。');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Footer_Copy','en-US','We promise to handle your information in line with our privacy policy.');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscribe','zh-CN','订阅');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscribe','en-US','Subscribe');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription','zh-CN','订阅');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription','en-US','Subscription');
insert into `Language` (LanKey,CultureName,LanValue)values('Unsubscribe','zh-CN','取消订阅');
insert into `Language` (LanKey,CultureName,LanValue)values('Unsubscribe','en-US','Unsubscribe');

insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Confirm_Title','zh-CN','确认订阅我们');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Confirm_Title','en-US','Confirm Your Subscription');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Confirm_Button','zh-CN','是的，我想要订阅');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Confirm_Button','en-US','Yes, I want to subscribe');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Confirm_Copy','zh-CN','如果您不点击上方链接，您将不会订阅我们。');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Confirm_Copy','en-US','You will not be subscribed if you don''t click on the link above.');

insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Unscribe_Title','zh-CN','取消订阅我们');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Unscribe_Title','en-US','Unsubscribe confirm');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Unscribe_Button','zh-CN','是的，我想要取消订阅');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Unscribe_Button','en-US','Yes, I want to unsubscribe');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Unscribe_Copy','zh-CN','如果您不点击上方链接，您将不会取消订阅我们。');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Email_Unscribe_Copy','en-US','You will not be unsubscribed if you don''t click on the link above.');

insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Subscribed_Title','zh-CN','您已订阅成功');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Subscribed_Title','en-US','You''ve Been Subscribed');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Unsubscribed_Title','zh-CN','您已取消订阅');
insert into `Language` (LanKey,CultureName,LanValue)values('Subscription_Unsubscribed_Title','en-US','You''ve Been Unsubscribed');