resources/schemas/sqlite/sqlite.6.sql
CREATE TABLE IF NOT EXISTS `tags` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`name` VARCHAR(32) NOT NULL,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE UNIQUE INDEX IF NOT EXISTS `tag_name`
ON `tags` (`name`);
CREATE TABLE IF NOT EXISTS `uploads_tags` (
`upload_id` INTEGER,
`tag_id` INTEGER,
PRIMARY KEY (`upload_id`, `tag_id`),
FOREIGN KEY (`upload_id`) REFERENCES `uploads` (`id`)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
ON UPDATE CASCADE
ON DELETE CASCADE
);