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(
 9    id         TEXT      NOT NULL PRIMARY KEY,
10    project_id TEXT      NOT NULL,
11    url        TEXT      NOT NULL,
12    tag        TEXT      NOT NULL,
13    content    TEXT      NOT NULL,
14    date       TIMESTAMP NOT NULL,
15    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
16);
17
18INSERT INTO releases (id, project_id, url, tag, content, date)
19SELECT
20    r.id,
21    p.id,
22    r.release_url,
23    r.tag,
24    r.content,
25    r.date
26FROM releases_tmp r
27JOIN projects p ON r.project_url = p.url;
28
29DROP TABLE releases_tmp;