Changeset 775 for branches/0.4/jobarchived/job_dbase.sql

Timestamp:

03/29/13 14:10:23 (11 years ago)

Author:

ramonb

Message:

jobarchived/jobarchived.conf:

• added USER/PASSWORD for SQL

jobarchived/job_dbase.sql:

• changed job primary key to varchar, due to job array ids

File:

• branches/0.4/jobarchived/job_dbase.sql (modified) (2 diffs)

branches/0.4/jobarchived/job_dbase.sql

@@ -4 +4 @@
 
 CREATE TABLE jobs (
-        job_id                  INT NOT NULL UNIQUE PRIMARY KEY,
+        job_id                  VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY,
         job_name                VARCHAR(100),
         job_queue               VARCHAR(50),
@@ -23 +23 @@
 
 CREATE TABLE job_nodes (
-        job_id                  INT NOT NULL REFERENCES jobs ON DELETE CASCADE,
+        job_id                  VARCHAR(20) NOT NULL REFERENCES jobs ON DELETE CASCADE,
         node_id                 INT NOT NULL REFERENCES nodes ON DELETE RESTRICT,
         PRIMARY KEY ( job_id, node_id )
 );
 
-CREATE USER root;
-CREATE USER "www-data";
+# modify me: set a password
+#CREATE USER jobarchive WITH PASSWORD '';
 
-GRANT ALL ON jobs,nodes,job_nodes TO root,"www-data";
-GRANT ALL ON nodes_node_id_seq TO root,"www-data";
+GRANT ALL ON jobs,nodes,job_nodes TO "jobarchive";
+GRANT ALL ON nodes_node_id_seq TO "jobarchive";