Changeset 905 for branches/1.0/jobarchived/job_dbase.sql
- Timestamp:
- 05/22/13 15:30:27 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/1.0/jobarchived/job_dbase.sql
r860 r905 1 DROP TABLE jobs CASCADE;2 DROP TABLE nodes CASCADE;3 DROP TABLE job_nodes CASCADE;4 5 1 CREATE TABLE jobs ( 6 2 job_id VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY, … … 28 24 ); 29 25 26 CREATE USER jobarchive; 27 30 28 -- modify me: set a password 31 -- CREATEUSER jobarchive WITH PASSWORD '';29 -- ALTER USER jobarchive WITH PASSWORD ''; 32 30 33 31 GRANT ALL ON jobs,nodes,job_nodes TO "jobarchive";
Note: See TracChangeset
for help on using the changeset viewer.