Last change
on this file since 793 was
793,
checked in by ramonb, 11 years ago
|
- job name can have maximum length of 255 by default in Torque
- job queue has maximum length of 32 by default but let's make it 50
|
File size:
896 bytes
|
Rev | Line | |
---|
[59] | 1 | DROP TABLE jobs CASCADE; |
---|
| 2 | DROP TABLE nodes CASCADE; |
---|
| 3 | DROP TABLE job_nodes CASCADE; |
---|
| 4 | |
---|
[83] | 5 | CREATE TABLE jobs ( |
---|
[775] | 6 | job_id VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY, |
---|
[793] | 7 | job_name VARCHAR(255), |
---|
[59] | 8 | job_queue VARCHAR(50), |
---|
[793] | 9 | job_owner VARCHAR(50), |
---|
[59] | 10 | job_requested_time VARCHAR(10), |
---|
| 11 | job_requested_memory VARCHAR(10), |
---|
| 12 | job_ppn INT, |
---|
| 13 | job_status VARCHAR(2), |
---|
| 14 | job_start_timestamp VARCHAR(10), |
---|
| 15 | job_stop_timestamp VARCHAR(10) |
---|
[83] | 16 | ); |
---|
[59] | 17 | |
---|
[83] | 18 | CREATE TABLE nodes ( |
---|
[59] | 19 | node_id SERIAL NOT NULL UNIQUE PRIMARY KEY, |
---|
[131] | 20 | node_hostname VARCHAR(100), |
---|
| 21 | node_location VARCHAR(10) |
---|
[83] | 22 | ); |
---|
[59] | 23 | |
---|
[83] | 24 | CREATE TABLE job_nodes ( |
---|
[775] | 25 | job_id VARCHAR(20) NOT NULL REFERENCES jobs ON DELETE CASCADE, |
---|
[96] | 26 | node_id INT NOT NULL REFERENCES nodes ON DELETE RESTRICT, |
---|
[59] | 27 | PRIMARY KEY ( job_id, node_id ) |
---|
[83] | 28 | ); |
---|
[59] | 29 | |
---|
[775] | 30 | # modify me: set a password |
---|
| 31 | #CREATE 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.