1  -- SPDX-FileCopyrightText: Amolith <amolith@secluded.site>
 2  --
 3  -- SPDX-License-Identifier: CC0-1.0
 4  
 5  ALTER TABLE projects RENAME TO projects_tmp;
 6  
 7  CREATE 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  );