1-- SPDX-FileCopyrightText: Amolith <amolith@secluded.site>
 2--
 3-- SPDX-License-Identifier: CC0-1.0
 4
 5--ALTER TABLE projects RENAME TO projects_tmp; -- noqa
 6
 7ALTER TABLE projects RENAME TO projects_tmp;
 8
 9CREATE TABLE IF NOT EXISTS projects (
10    url TEXT NOT NULL PRIMARY KEY,
11    name TEXT NOT NULL,
12    forge TEXT NOT NULL,
13    version TEXT NOT NULL,
14    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
15);
16
17INSERT INTO projects (url, name, forge, version, created_at)
18SELECT
19    url,
20    name,
21    forge,
22    version,
23    created_at
24FROM projects_tmp;
25
26DROP TABLE projects_tmp;