33 lines
799 B
SQL
33 lines
799 B
SQL
BEGIN TRANSACTION;
|
|
CREATE TABLE IF NOT EXISTS "tags" (
|
|
"id" INTEGER,
|
|
"label" TEXT,
|
|
PRIMARY KEY("id" AUTOINCREMENT)
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "files" (
|
|
"id" INTEGER,
|
|
"filename" TEXT NOT NULL,
|
|
"path" TEXT,
|
|
PRIMARY KEY("id" AUTOINCREMENT)
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "metadata" (
|
|
"fid" INTEGER NOT NULL,
|
|
"name" TEXT,
|
|
PRIMARY KEY("fid"),
|
|
FOREIGN KEY("fid") REFERENCES "files"("id")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "tags_ties" (
|
|
"fid" INTEGER NOT NULL,
|
|
"tid" INTEGER NOT NULL,
|
|
PRIMARY KEY("fid", "tid"),
|
|
FOREIGN KEY("fid") REFERENCES "files"("id"),
|
|
FOREIGN KEY("tid") REFERENCES "tags"("id")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "hashes" (
|
|
"id" INTEGER,
|
|
"md5" TEXT NOT NULL,
|
|
"fid" INTEGER NOT NULL,
|
|
PRIMARY KEY("id" AUTOINCREMENT),
|
|
FOREIGN KEY("fid") REFERENCES "files"("id")
|
|
);
|
|
COMMIT; |