DROP TABLE jobs CASCADE; DROP TABLE nodes CASCADE; DROP TABLE job_nodes CASCADE; CREATE TABLE jobs ( job_id INT NOT NULL UNIQUE PRIMARY KEY, job_name VARCHAR(100), job_queue VARCHAR(50), job_owner VARCHAR(30), job_requested_time VARCHAR(10), job_requested_memory VARCHAR(10), job_ppn INT, job_status VARCHAR(2), job_start_timestamp VARCHAR(10), job_stop_timestamp VARCHAR(10) ); CREATE TABLE nodes ( node_id SERIAL NOT NULL UNIQUE PRIMARY KEY, node_hostname VARCHAR(100), node_location VARCHAR(10) ); CREATE TABLE job_nodes ( job_id INT 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"; GRANT ALL ON jobs,nodes,job_nodes TO root,"www-data"; GRANT ALL ON nodes_node_id_seq TO root,"www-data";