diff options
author | Louie S <louie@example.com> | 2024-06-07 15:10:52 -0400 |
---|---|---|
committer | Louie S <louie@example.com> | 2024-06-07 15:10:52 -0400 |
commit | 603d3105cb16470e502f0e3d20f95d2243771e33 (patch) | |
tree | 2d775cf0fd4df3e745ff1649d5e1119e13416113 /src/scripts/create_table.sh | |
parent | a9413e16e8a8d160acb760a0971f25ef23d71e8c (diff) |
Replace placeholders with wildcard rules
Diffstat (limited to 'src/scripts/create_table.sh')
-rw-r--r-- | src/scripts/create_table.sh | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/scripts/create_table.sh b/src/scripts/create_table.sh new file mode 100644 index 0000000..a783c50 --- /dev/null +++ b/src/scripts/create_table.sh @@ -0,0 +1,7 @@ +create_table() { + DB_PATH="$1" + + sqlite3 "$DB_PATH" "CREATE TABLE IF NOT EXISTS searchIndex(id INTEGER PRIMARY KEY, name TEXT, type TEXT, path TEXT);" + sqlite3 "$DB_PATH" "CREATE UNIQUE INDEX IF NOT EXISTS anchor ON searchIndex (name, type, path);" +} + |