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
 );