Last change
on this file since 937 was
906,
checked in by ramonb, 11 years ago
|
job_dbase.sql:
- suppress errors due to table/user already exists
|
File size:
876 bytes
|
Rev | Line | |
---|
[906] | 1 | SET client_min_messages TO PANIC; |
---|
| 2 | |
---|
[83] | 3 | CREATE TABLE jobs ( |
---|
[775] | 4 | job_id VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY, |
---|
[793] | 5 | job_name VARCHAR(255), |
---|
[59] | 6 | job_queue VARCHAR(50), |
---|
[793] | 7 | job_owner VARCHAR(50), |
---|
[59] | 8 | job_requested_time VARCHAR(10), |
---|
| 9 | job_requested_memory VARCHAR(10), |
---|
| 10 | job_ppn INT, |
---|
| 11 | job_status VARCHAR(2), |
---|
| 12 | job_start_timestamp VARCHAR(10), |
---|
| 13 | job_stop_timestamp VARCHAR(10) |
---|
[83] | 14 | ); |
---|
[59] | 15 | |
---|
[83] | 16 | CREATE TABLE nodes ( |
---|
[59] | 17 | node_id SERIAL NOT NULL UNIQUE PRIMARY KEY, |
---|
[131] | 18 | node_hostname VARCHAR(100), |
---|
| 19 | node_location VARCHAR(10) |
---|
[83] | 20 | ); |
---|
[59] | 21 | |
---|
[83] | 22 | CREATE TABLE job_nodes ( |
---|
[775] | 23 | job_id VARCHAR(20) NOT NULL REFERENCES jobs ON DELETE CASCADE, |
---|
[96] | 24 | node_id INT NOT NULL REFERENCES nodes ON DELETE RESTRICT, |
---|
[59] | 25 | PRIMARY KEY ( job_id, node_id ) |
---|
[83] | 26 | ); |
---|
[59] | 27 | |
---|
[905] | 28 | CREATE USER jobarchive; |
---|
| 29 | |
---|
[860] | 30 | -- modify me: set a password |
---|
[905] | 31 | -- ALTER USER jobarchive WITH PASSWORD ''; |
---|
[83] | 32 | |
---|
[775] | 33 | GRANT ALL ON jobs,nodes,job_nodes TO "jobarchive"; |
---|
| 34 | GRANT ALL ON nodes_node_id_seq TO "jobarchive"; |
---|
Note: See
TracBrowser
for help on using the repository browser.