Mercurial > sci
diff sql/init.sql @ 62:eaebcc612a0d
misc: add header in SQL files
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 18 Aug 2022 12:18:12 +0200 |
parents | 081e1c258e64 |
children | 71cd8447e3a4 |
line wrap: on
line diff
--- a/sql/init.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/init.sql Thu Aug 18 12:18:12 2022 +0200 @@ -16,7 +16,7 @@ -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. -- -CREATE TABLE IF NOT EXISTS project( +CREATE TABLE IF NOT EXISTS `project`( `name` TEXT NOT NULL PRIMARY KEY, `desc` TEXT NOT NULL, `url` TEXT NOT NULL, @@ -24,28 +24,28 @@ `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS worker( +CREATE TABLE IF NOT EXISTS `worker`( `name` TEXT NOT NULL PRIMARY KEY, `desc` TEXT NOT NULL, `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS job( +CREATE TABLE IF NOT EXISTS `job`( `tag` TEXT NOT NULL, - `project_name` INTEGER NOT NULL REFERENCES project (name), + `project_name` INTEGER NOT NULL REFERENCES `project` (name), `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS jobresult( - `job_id` INTEGER NOT NULL REFERENCES job (rowid), - `worker_name` INTEGER NOT NULL REFERENCES worker (name), +CREATE TABLE IF NOT EXISTS `jobresult`( + `job_id` INTEGER NOT NULL REFERENCES `job` (rowid), + `worker_name` INTEGER NOT NULL REFERENCES `worker` (name), `console` TEXT DEFAULT NULL, `exitcode` INTEGER DEFAULT 0, `sigcode` INTEGER DEFAULT 0, `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS property( +CREATE TABLE IF NOT EXISTS `property`( `key` TEXT PRIMARY KEY NOT NULL, `value` TEXT );