2023-08-12 19:13:48 +03:00
|
|
|
CREATE TABLE packages (
|
2023-08-12 21:10:39 +03:00
|
|
|
id TEXT PRIMARY KEY NOT NULL
|
|
|
|
, attr_path TEXT NOT NULL
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_update_attempt DATETIME
|
|
|
|
, last_update_log DATETIME
|
2023-08-12 21:10:39 +03:00
|
|
|
, version_nixpkgs_master TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_nixpkgs_master DATETIME
|
2023-08-12 21:10:39 +03:00
|
|
|
, version_nixpkgs_staging TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_nixpkgs_staging DATETIME
|
2023-08-12 21:10:39 +03:00
|
|
|
, version_nixpkgs_staging_next TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_nixpkgs_staging_next DATETIME
|
2023-08-12 21:10:39 +03:00
|
|
|
, version_repology TEXT
|
|
|
|
, project_repology TEXT
|
|
|
|
, nixpkgs_name_replogy TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_repology DATETIME
|
|
|
|
, version_github TEXT
|
2023-08-12 21:10:39 +03:00
|
|
|
, owner_github TEXT
|
|
|
|
, repo_github TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_github DATETIME
|
|
|
|
, version_gitlab TEXT
|
2023-08-12 21:10:39 +03:00
|
|
|
, owner_gitlab TEXT
|
|
|
|
, repo_gitlab TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_gitlab DATETIME
|
|
|
|
, package_name_pypi TEXT
|
|
|
|
, version_pypi TEXT
|
|
|
|
, last_checked_pypi DATETIME
|
2023-08-12 21:10:39 +03:00
|
|
|
, pending_pr INTEGER
|
|
|
|
, pending_pr_owner TEXT
|
|
|
|
, pending_pr_branch_name TEXT
|
2023-08-12 22:26:16 +03:00
|
|
|
, last_checked_pending_pr DATETIME
|
2023-08-12 19:13:48 +03:00
|
|
|
)
|