1-- SPDX-FileCopyrightText: Amolith <amolith@secluded.site>
 2--
 3-- SPDX-License-Identifier: CC0-1.0
 4
 5ALTER TABLE releases RENAME TO releases_tmp;
 6
 7CREATE TABLE IF NOT EXISTS releases (
 8    id          TEXT      NOT NULL PRIMARY KEY,
 9    project_url TEXT      NOT NULL,
10    release_url TEXT      NOT NULL,
11    tag         TEXT      NOT NULL,
12    content     TEXT      NOT NULL,
13    date        TIMESTAMP NOT NULL,
14    created_at  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
15);
16
17INSERT INTO releases (id, project_url, release_url, tag, content, date)
18SELECT
19    r.id,
20    p.url,
21    r.url,
22    r.tag,
23    r.content,
24    r.date
25FROM releases_tmp r
26JOIN projects p ON r.project_url = p.url;
27
28DROP TABLE releases_tmp;