1-- SPDX-FileCopyrightText: Amolith <amolith@secluded.site>
 2--
 3-- SPDX-License-Identifier: CC0-1.0
 4
 5CREATE TABLE users
 6(
 7    username   TEXT      NOT NULL PRIMARY KEY,
 8    hash       TEXT      NOT NULL,
 9    salt       TEXT      NOT NULL,
10    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
11);
12
13CREATE TABLE sessions
14(
15    token      TEXT      NOT NULL PRIMARY KEY,
16    username   TEXT      NOT NULL,
17    expires    TIMESTAMP NOT NULL,
18    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
19);
20
21CREATE TABLE projects
22(
23    url        TEXT      NOT NULL PRIMARY KEY,
24    name       TEXT      NOT NULL,
25    forge      TEXT      NOT NULL,
26    version    TEXT      NOT NULL,
27    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
28);
29
30CREATE TABLE releases
31(
32    id          TEXT      NOT NULL PRIMARY KEY,
33    project_url TEXT      NOT NULL,
34    release_url TEXT      NOT NULL,
35    tag         TEXT      NOT NULL,
36    content     TEXT      NOT NULL,
37    date        TIMESTAMP NOT NULL,
38    created_at  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
39);