| \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'),
(31, 'forget_captcha', '0', 'login'),
(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'),
(49, 'database_version', '5', 'version'),
(43, 'hot_share_num', '10', 'share'),
(44, 'gravatar_server', 'https://gravatar.loli.net/', 'avatar'),
(45, 'admin_color_body', 'fixed-nav sticky-footer bg-light', 'admin'),
(46, 'admin_color_nav', 'navbar navbar-expand-lg fixed-top navbar-light bg-light', 'admin'),
(47, 'js_code', '', 'basic'),
(50, 'sendfile', '0', 'download'),
(51, 'header', 'X-Sendfile', 'download'),
(52, 'aria2_tmppath', '/path/to/public/download', 'aria2'),
(53, 'aria2_token', 'your token', 'aria2'),
(54, 'aria2_rpcurl', 'http://127.0.0.1:6800/', 'aria2'),
(55, 'aria2_options', '{\"max-tries\":5}', 'aria2'),
(56, 'task_queue_token', '', 'task'),
(57, 'defaultTheme', '#3f51b5', 'basic'),
(58, 'themes', '[{\"#3f51b5\":{\"palette\":{\"common\":{\"black\":\"#000\",\"white\":\"#fff\"},\"background\":{\"paper\":\"#fff\",\"default\":\"#fafafa\"},\"primary\":{\"light\":\"#7986cb\",\"main\":\"#3f51b5\",\"dark\":\"#303f9f\",\"contrastText\":\"#fff\"},\"secondary\":{\"light\":\"#ff4081\",\"main\":\"#f50057\",\"dark\":\"#c51162\",\"contrastText\":\"#fff\"},\"error\":{\"light\":\"#e57373\",\"main\":\"#f44336\",\"dark\":\"#d32f2f\",\"contrastText\":\"#fff\"},\"text\":{\"primary\":\"rgba(0, 0, 0, 0.87)\",\"secondary\":\"rgba(0, 0, 0, 0.54)\",\"disabled\":\"rgba(0, 0, 0, 0.38)\",\"hint\":\"rgba(0, 0, 0, 0.38)\"},\"explorer\":{\"filename\":\"#474849\",\"icon\":\"#8f8f8f\",\"bgSelected\":\"#D5DAF0\",\"emptyIcon\":\"#e8e8e8\"}}}}]\r\n', 'basic'),
(59, 'refererCheck', 'true', 'share');
-- -------------------------------------------------------
--
-- 表的结构 `sd_policy`
--
CREATE TABLE `sd_policy` (
`id` int(11) NOT NULL,
`policy_name` text NOT NULL,
`policy_type` text NOT NULL,
`server` text NOT NULL,
`bucketname` text NOT NULL,
`bucket_private` tinyint(1) NOT NULL,
`url` text NOT NULL,
`ak` text NOT NULL,
`sk` text NOT NULL,
`op_name` text NOT NULL,
`op_pwd` text NOT NULL,
`filetype` text NOT NULL,
`mimetype` text NOT NULL,
`max_size` bigint(20) NOT NULL,
`autoname` tinyint(1) NOT NULL,
`dirrule` text NOT NULL,
`namerule` text NOT NULL,
`origin_link` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `sd_policy`
--
INSERT INTO `sd_policy` (`id`, `policy_name`, `policy_type`, `server`, `bucketname`, `bucket_private`, `url`, `ak`, `sk`, `op_name`, `op_pwd`, `filetype`, `mimetype`, `max_size`, `autoname`, `dirrule`, `namerule`, `origin_link`) VALUES
(1, '默认上传策略', 'local', '/Upload', '0', 0, 'http://cloudreve.org/public/uploads/', '0', '0', '0', '0', '[]', '0', 10485760, 1, '{date}/{uid}', '{uid}_{randomkey8}_{originname}', 0);
-- --------------------------------------------------------
--
-- 表的结构 `sd_shares`
--
CREATE TABLE `sd_shares` (
`id` int(11) NOT NULL,
`type` text NOT NULL,
`share_time` datetime NOT NULL,
`owner` int(11) NOT NULL,
`source_name` text NOT NULL,
`origin_name` text NOT NULL,
`download_num` int(11) NOT NULL,
`view_num` int(11) NOT NULL,
`source_type` text NOT NULL,
`share_key` text NOT NULL,
`share_pwd` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `sd_storage_pack`
--
CREATE TABLE `sd_storage_pack` (
`id` int(11) NOT NULL,
`p_name` text 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
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `sd_users`
--
CREATE TABLE `sd_users` (
`id` int(11) NOT NULL,
`user_email` varchar(100) NOT NULL,
`user_nick` varchar(50) NOT NULL,
`user_pass` varchar(255) NOT NULL,
`user_date` timestamp NOT NULL,
`user_status` int(11) NOT NULL,
`user_group` int(11) NOT NULL,
`group_primary` int(11) NOT NULL,
`user_activation_key` varchar(255) NOT NULL,
`used_storage` bigint(20) NOT NULL,
`two_step` text NOT NULL,
`delay_time` bigint(20) NOT NULL,
`avatar` text NOT NULL,
`profile` tinyint(1) NOT NULL,
`webdav_key` text NOT NULL,
`options` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 `sd_users`
--
INSERT INTO `sd_users` (`id`, `user_email`, `user_nick`, `user_pass`, `user_date`, `user_status`, `user_group`, `group_primary`, `user_activation_key`, `used_storage`, `two_step`, `delay_time`, `avatar`, `profile`, `webdav_key`) VALUES
(1, 'admin@cloudreve.org', 'Admin', 'd8446059f8846a2c111a7f53515665fb', '2018-02-04 12:56:38', 0, 1, 0, 'n', 0, '0', 0, 'default', 1, 'd8446059f8846a2c111a7f53515665fb');
CREATE TABLE `sd_download` (
`id` int(11) NOT NULL,
`pid` text NOT NULL,
`path_id` text NOT NULL,
`owner` int(11) NOT NULL,
`save_dir` text NOT NULL,
`status` text NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`msg` text NOT NULL,
`info` text NOT NULL,
`source` text NOT NULL,
`file_index` int(11) NOT NULL,
`is_single` tinyint(1) NOT NULL,
`total_size` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
ALTER TABLE `sd_download`
ADD PRIMARY KEY (`id`);
ALTER TABLE `sd_download`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Indexes for dumped tables
--
--
-- 表的结构 `sd_task`
--
CREATE TABLE `sd_task` (
`id` int(11) NOT NULL,
`task_name` text NOT NULL,
`attr` text NOT NULL,
`type` text NOT NULL,
`status` text NOT NULL,
`uid` int(11) NOT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Indexes for table `sd_callback`
--
ALTER TABLE `sd_callback`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_chunks`
--
ALTER TABLE `sd_chunks`
ADD PRIMARY KEY (`id`);
ALTER TABLE `sd_task`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_corn`
--
ALTER TABLE `sd_corn`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_files`
--
ALTER TABLE `sd_files`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_folders`
--
ALTER TABLE `sd_folders`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_groups`
--
ALTER TABLE `sd_groups`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_options`
--
ALTER TABLE `sd_options`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_policy`
--
ALTER TABLE `sd_policy`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_shares`
--
ALTER TABLE `sd_shares`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_storage_pack`
--
ALTER TABLE `sd_storage_pack`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sd_users`
--
ALTER TABLE `sd_users`
ADD PRIMARY KEY (`id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `sd_callback`
--
ALTER TABLE `sd_callback`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `sd_chunks`
--
ALTER TABLE `sd_chunks`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `sd_corn`
--
ALTER TABLE `sd_corn`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `sd_files`
--
ALTER TABLE `sd_files`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `sd_folders`
--
ALTER TABLE `sd_folders`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `sd_task`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `sd_groups`
--
ALTER TABLE `sd_groups`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 使用表AUTO_INCREMENT `sd_options`
--
ALTER TABLE `sd_options`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
--
-- 使用表AUTO_INCREMENT `sd_policy`
--
ALTER TABLE `sd_policy`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `sd_shares`
--
ALTER TABLE `sd_shares`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `sd_storage_pack`
--
ALTER TABLE `sd_storage_pack`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `sd_users`
--
ALTER TABLE `sd_users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;