Changeset 905 for branches/1.0/jobarchived

Timestamp:

05/22/13 15:30:27 (11 years ago)

Author:

ramonb

Message:

jobarchived/job_dbase.sql:

• changed to CREATE user and ALTER password: so that create may fail (if user exists) and password upate still succeeds

pkg/rpm/jobmonarch.spec.in, debian/jobmonarch.postinst:

• changed CREATE to ALTER

File:

• branches/1.0/jobarchived/job_dbase.sql (modified) (2 diffs)

branches/1.0/jobarchived/job_dbase.sql

@@ -1 @@
-DROP TABLE jobs CASCADE;
-DROP TABLE nodes CASCADE;
-DROP TABLE job_nodes CASCADE;
-
 CREATE TABLE jobs (
         job_id                  VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY,
@@ -28 +24 @@
 );
 
+CREATE USER jobarchive;
+
 -- modify me: set a password
--- CREATE USER jobarchive WITH PASSWORD '';
+-- ALTER USER jobarchive WITH PASSWORD '';
 
 GRANT ALL ON jobs,nodes,job_nodes TO "jobarchive";