Something

CREATE TABLE "content_content" (    "id" integer NOT NULL PRIMARY KEY,    "signature" varchar(1024) NOT NULL,    "name" varchar(200) NULL,    "autoname" bool NULL,    "location" varchar(1024) NULL,    "url" varchar(1024) NULL,    "added_date" datetime NOT NULL);CREATE TABLE "content_content_tags" (    "id" integer NOT NULL PRIMARY KEY,    "content_id" integer NOT NULL REFERENCES "content_content" ("id"),    "tag_id" integer NOT NULL REFERENCES "content_tag" ("id"),    UNIQUE ("content_id", "tag_id"));CREATE TABLE "content_filename" (    "id" integer NOT NULL PRIMARY KEY,    "path" varchar(1024) NOT NULL,    "content_id" integer NOT NULL REFERENCES "content_content" ("id"));CREATE TABLE "content_filename_users_seen" (    "id" integer NOT NULL PRIMARY KEY,    "filename_id" integer NOT NULL REFERENCES "content_filename" ("id"),    "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),    UNIQUE ("filename_id", "user_id"));CREATE TABLE "content_tag" (    "id" integer NOT NULL PRIMARY KEY,    "name" varchar(20) NOT NULL,    "autotag" bool NOT NULL);