mirror of
https://github.com/mCaptcha/mCaptcha.git
synced 2025-09-13 20:20:12 +00:00
17 lines
375 B
SQL
17 lines
375 B
SQL
CREATE VIRTUAL TABLE IF NOT EXISTS fts_repositories USING fts4(
|
|
name TEXT NOT NULL,
|
|
description TEXT DEFAULT NULL,
|
|
website TEXT DEFAULT NULL,
|
|
html_url TEXT NOT NULL UNIQUE,
|
|
);
|
|
|
|
|
|
CREATE VIRTUAL TABLE IF NOT EXISTS fts_project_topics USING fts4(
|
|
name VARCHAR(50) NOT NULL UNIQUE
|
|
);
|
|
|
|
|
|
CREATE VIRTUAL TABLE IF NOT EXISTS fts_users USING fts4(
|
|
username TEXT NOT NULL
|
|
);
|