Ignore:
Timestamp:
04/18/05 11:55:36 (17 years ago)
Author:
bastiaans
Message:

daemon/make_dbase.sh:

  • Shell script for creating dbase

daemon/job_dbase.sql:

  • Typo in syntax
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/daemon/job_dbase.sql

    r59 r83  
    33DROP TABLE job_nodes CASCADE;
    44
    5 CREATE TABLE jobs {
     5CREATE TABLE jobs (
    66        job_id                  INT NOT NULL UNIQUE PRIMARY KEY,
    77        job_name                VARCHAR(100),
     
    1414        job_start_timestamp     VARCHAR(10),
    1515        job_stop_timestamp      VARCHAR(10)
    16 };
     16);
    1717
    18 CREATE TABLE nodes {
     18CREATE TABLE nodes (
    1919        node_id                 SERIAL NOT NULL UNIQUE PRIMARY KEY,
    2020        node_hostname           VARCHAR(100)
    21 };
     21);
    2222
    23 CREATE TABLE job_nodes {
     23CREATE TABLE job_nodes (
    2424        job_id                  INT NOT NULL REFERENCES jobs ON DELETE RESTRICT,
    2525        node_id                 INT NOT NULL REFERENCES nodes ON DELETE RESTRICT,
    2626        PRIMARY KEY ( job_id, node_id )
    27 };
     27);
     28
     29CREATE USER root;
     30CREATE USER ramon;
    2831
    2932GRANT ALL ON jobs,nodes,job_nodes TO root,ramon;
Note: See TracChangeset for help on using the changeset viewer.