1-- SPDX-FileCopyrightText: Amolith <amolith@secluded.site>
 2--
 3-- SPDX-License-Identifier: CC0-1.0
 4
 5ALTER TABLE projects RENAME TO projects_tmp;
 6
 7CREATE TABLE IF NOT EXISTS projects (
 8    id TEXT NOT NULL PRIMARY KEY,
 9    url TEXT NOT NULL,
10    name TEXT NOT NULL,
11    forge TEXT NOT NULL,
12    version TEXT NOT NULL,
13    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
14);