SQLite format 3 @ " " .zq
^ \ f
^ U
1qindexidx_users_usernameusers CREATE INDEX idx_users_username ON users(username)d 3!indexidx_categories_sortcategories
CREATE INDEX idx_categories_sort ON categories(sort_order)f7 indexidx_bookmarks_createdbookmarks CREATE INDEX idx_bookmarks_created ON bookmarks(created_at)l; indexidx_bookmarks_encryptedbookmarksCREATE INDEX idx_bookmarks_encrypted ON bookmarks(is_encrypted)i9 indexidx_bookmarks_categorybookmarksCREATE INDEX idx_bookmarks_category ON bookmarks(category_id)mtableusersusersCREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(100) NOT NULL,
email VARCHAR(100),
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
))= indexsqlite_autoindex_users_1users ]tablebookmarksbookmarksCREATE TABLE bookmarks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
category_id INTEGER NOT NULL,
title VARCHAR(200) NOT NULL,
url VARCHAR(500) NOT NULL,
description TEXT,
is_encrypted INTEGER DEFAULT 0,
password VARCHAR(100),
clicks INTEGER DEFAULT 0,
sort_order INTEGER DEFAULT 0,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (category_id) REFERENCES categories(id) ON DELETE CASCADE
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)!![tablecategoriescategoriesCREATE TABLE categories (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(100) NOT NULL,
description TEXT,
sort_order INTEGER DEFAULT 0,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)
] c D %I3工作相关工作相关的网站和工具2026-01-28 11:18:15A %C3娱乐休闲电影、音乐、游戏等2026-01-28 11:18:15; %73学习资料教育和学习资源2026-01-28 11:18:15; %73工具资源实用工具和资源2026-01-28 11:18:15; %73新闻资讯新闻和信息网站2026-01-28 11:18:158 %13社交网络社交媒体平台2026-01-28 11:18:157 %1 3搜索引擎各种搜索引擎2026-01-28 11:18:15. %3未分类默认分类2026-01-28 11:18:15
bookmarks users!categories
u cy,
r
' | ) x
u M 91
3Indeedhttps://www.indeed.com求职招聘网站2026-01-28 11:18:16Q =1
3LinkedInhttps://www.linkedin.com职业社交平台2026-01-28 11:18:16_ ;7 '3Netflixhttps://www.netflix.com流媒体视频服务entertainment2026-01-28 11:18:16O ;1
3YouTubehttps://www.youtube.com视频分享平台2026-01-28 11:18:16^
%C=
3Khan Academyhttps://www.khanacademy.org可汗学院免费课程2026-01-28 11:18:16Q =1
3Courserahttps://www.coursera.org在线学习平台2026-01-28 11:18:16X )?1
3Stack Overflowhttps://stackoverflow.com编程问答社区2026-01-28 11:18:16O
1=
3GitLabhttps://gitlab.com开源代码托管平台2026-01-28 11:18:16I 11
3GitHubhttps://github.com代码托管平台2026-01-28 11:18:16T ;C
3CNNhttps://edition.cnn.com美国有线电视新闻网2026-01-28 11:18:16b =C 3BBC新闻https://www.bbc.com/newsBBC新闻（加密示例）news1232026-01-28 11:18:16K 31
3Twitterhttps://twitter.com推特社交平台2026-01-28 11:18:16B /%
3微博https://weibo.com新浪微博2026-01-28 11:18:16W !9=
3DuckDuckGohttps://duckduckgo.com隐私保护搜索引擎2026-01-28 11:18:16K 51
3必应https://www.bing.com微软搜索引擎2026-01-28 11:18:16M 91
3谷歌https://www.google.com全球搜索引擎2026-01-28 11:18:15L 71
3百度https://www.baidu.com中文搜索引擎2026-01-28 11:18:15
> M 3admin0192023a7bbd73250516f069df18b5002026-01-28 11:18:15
admin
i qYA)i 32026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:16
32026-01-28 11:18:16 32026-01-28 11:18:16 32026-01-28 11:18:16
32026-01-28 11:18:16 32026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:1632026-01-28 11:18:153 2026-01-28 11:18:15
admin
返回列表
JSON接口: view.php?api=1&id=6833