30 lines
841 B
SQL
30 lines
841 B
SQL
CREATE TABLE `jobs` (
|
|
`id` CHAR(36) NOT NULL PRIMARY KEY,
|
|
`command` VARCHAR(255) NOT NULL,
|
|
`args` TEXT NOT NULL,
|
|
`flags` TEXT NOT NULL,
|
|
`user_id` CHAR(36) DEFAULT NULL,
|
|
`state` VARCHAR(20) NOT NULL,
|
|
`created_at` DATETIME DEFAULT NULL,
|
|
`started_at` DATETIME DEFAULT NULL,
|
|
`finished_at` DATETIME DEFAULT NULL
|
|
);
|
|
-- PRAGMA table_info(jobs);
|
|
|
|
CREATE TABLE `sessions` (
|
|
`id` CHAR(36) NOT NULL PRIMARY KEY,
|
|
`user_id` CHAR(36) NOT NULL,
|
|
`created_at` DATETIME NOT NULL,
|
|
`expires_at` DATETIME NOT NULL
|
|
);
|
|
-- PRAGMA table_info(sessions);
|
|
|
|
CREATE TABLE `users` (
|
|
`id` CHAR(36) NOT NULL PRIMARY KEY,
|
|
`github_id` UNSIGNED BIGINT NOT NULL,
|
|
`github_login` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`github_name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`github_picture` VARCHAR(255) NOT NULL DEFAULT ''
|
|
);
|
|
-- PRAGMA table_info(users);
|