wangchuanli
25b72bad5d
- 从环境变量读取密钥，未设置时随机生成 - 自动初始化数据库并显式使用 UTF-8 读取 schema - 移除默认管理员账号，更新页面署名与链接 - 新增 .gitignore、LICENSE 和 README
83 行
1.8 KiB
SQL
83 行
1.8 KiB
SQL
DROP TABLE IF EXISTS user;
|
|
CREATE TABLE user
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
username VARCHAR not null,
|
|
password VARCHAR not null,
|
|
status INTEGER default 1,
|
|
type INTEGER not null default 0
|
|
);
|
|
|
|
-- 默认管理员账号请自行通过初始化脚本创建，例如：
|
|
-- insert into user (username, password, status, type) values ('admin', '请修改为强密码', 1, 1);
|
|
|
|
DROP TABLE IF EXISTS search;
|
|
CREATE TABLE search
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
user_id INTEGER not null,
|
|
name VARCHAR not null,
|
|
icon VARCHAR,
|
|
url VARCHAR not null,
|
|
sort INTEGER not null default 0,
|
|
status INTEGER not null default 1
|
|
);
|
|
|
|
DROP TABLE IF EXISTS quick;
|
|
CREATE TABLE quick
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
user_id INTEGER not null,
|
|
name VARCHAR not null,
|
|
icon VARCHAR,
|
|
img VARCHAR,
|
|
color VARCHAR,
|
|
url VARCHAR not null,
|
|
type INTEGER not null default 0,
|
|
summary VARCHAR,
|
|
cate VARCHAR,
|
|
tags VARCHAR,
|
|
sort INTEGER not null default 0,
|
|
status INTEGER not null default 1
|
|
);
|
|
|
|
|
|
DROP TABLE IF EXISTS cate;
|
|
CREATE TABLE cate
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name VARCHAR not null,
|
|
sort INTEGER,
|
|
status INTEGER
|
|
);
|
|
|
|
DROP TABLE IF EXISTS library;
|
|
CREATE TABLE library
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name VARCHAR not null,
|
|
icon VARCHAR,
|
|
img VARCHAR,
|
|
color VARCHAR,
|
|
url VARCHAR not null,
|
|
type INTEGER not null default 0,
|
|
summary VARCHAR,
|
|
cate INTEGER,
|
|
tags VARCHAR,
|
|
sort INTEGER DEFAULT 0 NOT NULL,
|
|
status INTEGER DEFAULT 1 NOT NULL
|
|
);
|
|
|
|
|
|
DROP TABLE IF EXISTS site;
|
|
CREATE TABLE site
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name VARCHAR not null,
|
|
value VARCHAR,
|
|
sort INTEGER,
|
|
status INTEGER
|
|
);
|
|
|
|
|