Changeset 83 for trunk

Timestamp:

04/18/05 11:55:36 (19 years ago)

Author:

bastiaans

Message:

daemon/make_dbase.sh:

• Shell script for creating dbase

daemon/job_dbase.sql:

• Typo in syntax

Location:

trunk/daemon

Files:

• job_dbase.sql (modified) (2 diffs)
• make_dbase.sh (added)

trunk/daemon/job_dbase.sql

@@ -3 +3 @@
 DROP TABLE job_nodes CASCADE;
 
-CREATE TABLE jobs {
+CREATE TABLE jobs (
         job_id                  INT NOT NULL UNIQUE PRIMARY KEY,
         job_name                VARCHAR(100),
@@ -14 +14 @@
         job_start_timestamp     VARCHAR(10),
         job_stop_timestamp      VARCHAR(10)
-};
+);
 
-CREATE TABLE nodes {
+CREATE TABLE nodes (
         node_id                 SERIAL NOT NULL UNIQUE PRIMARY KEY,
         node_hostname           VARCHAR(100)
-};
+);
 
-CREATE TABLE job_nodes {
+CREATE TABLE job_nodes (
         job_id                  INT NOT NULL REFERENCES jobs ON DELETE RESTRICT,
         node_id                 INT NOT NULL REFERENCES nodes ON DELETE RESTRICT,
         PRIMARY KEY ( job_id, node_id )
-};
+);
+
+CREATE USER root;
+CREATE USER ramon;
 
 GRANT ALL ON jobs,nodes,job_nodes TO root,ramon;