| \r\n \r\n \r\n | \r\n 激活{siteTitle}账户\r\n | \r\n \r\n | \r\n 亲爱的 {userName} ：\r\n | \r\n | \r\n 感谢您注册{siteTitle},请点击下方按钮完成账户激活。\r\n | \r\n | \r\n 激活账户\r\n | \r\n | \r\n 感谢您选择{siteTitle}。\r\n | \r\n
| \r\n
| \r\n | \r\n
\r\n\r\n', 'mail_template');
INSERT INTO `sd_options` VALUES (31, 'forget_captcha', '0', 'login');
INSERT INTO `sd_options` VALUES (32, 'mail_reset_pwd_template', ' \r\n\r\n\r\n | \r\n \r\n \r\n | \r\n 重设{siteTitle}密码\r\n | \r\n \r\n | \r\n 亲爱的 {userName} ：\r\n | \r\n | \r\n 请点击下方按钮完成密码重设。如果非你本人操作，请忽略此邮件。\r\n | \r\n | \r\n 重设密码\r\n | \r\n | \r\n 感谢您选择{siteTitle}。\r\n | \r\n
| \r\n
| \r\n | \r\n
\r\n\r\n', 'mail_template');
INSERT INTO `sd_options` VALUES (49, 'database_version', '3', 'version');
INSERT INTO `sd_options` VALUES (43, 'hot_share_num', '10', 'share');
INSERT INTO `sd_options` VALUES (44, 'gravatar_server', 'https://v2ex.assets.uxengine.net/gravatar/', 'avatar');
INSERT INTO `sd_options` VALUES (45, 'admin_color_body', 'fixed-nav sticky-footer bg-light', 'admin');
INSERT INTO `sd_options` VALUES (46, 'admin_color_nav', 'navbar navbar-expand-lg fixed-top navbar-light bg-light', 'admin');
INSERT INTO `sd_options` VALUES (47, 'js_code', '', 'basic');
INSERT INTO `sd_options` VALUES (50, 'sendfile', '0', 'download');
INSERT INTO `sd_options` VALUES (51, 'header', 'X-Sendfile', 'download');
INSERT INTO `sd_options` VALUES (52, 'aria2_tmppath', '/path/to/public/download', 'aria2');
INSERT INTO `sd_options` VALUES (53, 'aria2_token', 'your token', 'aria2');
INSERT INTO `sd_options` VALUES (54, 'aria2_rpcurl', 'http://127.0.0.1:6800/', 'aria2');
INSERT INTO `sd_options` VALUES (55, 'aria2_options', '{\"max-tries\":5}', 'aria2');
INSERT INTO `sd_options` VALUES (56, 'task_queue_token', '', 'task');
INSERT INTO `sd_options` VALUES (57, 'imagePolicy', '3', 'policy');
INSERT INTO `sd_options` VALUES (58, 'illustrationPolicy', '2', 'policy');
-- ----------------------------
-- Table structure for sd_order
-- ----------------------------
DROP TABLE IF EXISTS `sd_order`;
CREATE TABLE `sd_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NULL DEFAULT NULL,
`app_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`out_trade_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`trade_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`total_amount` float(255, 0) NULL DEFAULT NULL,
`buyer_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`trade_type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`trade_status` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
`pay_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sd_policy
-- ----------------------------
DROP TABLE IF EXISTS `sd_policy`;
CREATE TABLE `sd_policy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`policy_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`policy_type` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`server` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`bucketname` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`bucket_private` tinyint(1) NOT NULL,
`url` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`ak` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sk` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`op_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`op_pwd` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`filetype` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`mimetype` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`max_size` bigint(20) NOT NULL,
`autoname` tinyint(1) NOT NULL,
`dirrule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`namerule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`origin_link` tinyint(1) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sd_policy
-- ----------------------------
INSERT INTO `sd_policy` VALUES (1, '默认上传策略', 'local', '/Upload', '0', 0, 'http://cloudreve.org/public/uploads/', '0', '0', '0', '0', '[]', '0', 10485760, 1, '{date}/{uid}', '{uid}_{randomkey8}_{originname}', 0);
-- ----------------------------
-- Table structure for sd_shares
-- ----------------------------
DROP TABLE IF EXISTS `sd_shares`;
CREATE TABLE `sd_shares` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`share_time` datetime(0) NULL DEFAULT NULL,
`owner` int(11) NOT NULL,
`source_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`origin_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`download_num` int(11) NOT NULL,
`view_num` int(11) NOT NULL,
`source_type` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`share_key` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`share_pwd` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sd_storage_pack
-- ----------------------------
DROP TABLE IF EXISTS `sd_storage_pack`;
CREATE TABLE `sd_storage_pack` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`p_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`uid` int(11) NOT NULL,
`act_time` bigint(20) NOT NULL,
`dlay_time` bigint(20) NOT NULL,
`pack_size` bigint(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sd_task
-- ----------------------------
DROP TABLE IF EXISTS `sd_task`;
CREATE TABLE `sd_task` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`task_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`attr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`uid` int(11) NOT NULL,
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sd_template
-- ----------------------------
DROP TABLE IF EXISTS `sd_template`;
CREATE TABLE `sd_template` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`class_id` int(11) NOT NULL,
`template` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`thumb` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`libs` varchar(140) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 155 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sd_template
-- ----------------------------
INSERT INTO `sd_template` VALUES (1, 'accd', 1, '