mirror of
https://github.com/1f349/gomvn.git
synced 2024-10-18 09:21:48 +01:00
27 lines
551 B
SQL
27 lines
551 B
SQL
CREATE TABLE artifacts
|
|
(
|
|
mvn_group TEXT NOT NULL,
|
|
artifact TEXT NOT NULL,
|
|
version TEXT NOT NULL,
|
|
modified DATETIME NOT NULL
|
|
);
|
|
|
|
CREATE TABLE paths
|
|
(
|
|
user_id INTEGER UNIQUE,
|
|
path TEXT PRIMARY KEY,
|
|
deploy TINYINT,
|
|
created_at DATETIME,
|
|
updated_at DATETIME,
|
|
|
|
FOREIGN KEY (user_id) REFERENCES users (id)
|
|
);
|
|
|
|
CREATE TABLE users
|
|
(
|
|
id INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT,
|
|
name TEXT NOT NULL,
|
|
admin BOOLEAN NOT NULL,
|
|
token_hash TEXT NOT NULL
|
|
);
|