Changeset 1311 for trunk/LATMOS-Accounts/bin

Timestamp:

04/02/15 15:43:23 (9 years ago)

Author:

nanardon

Message:

Add an irev column to SQL log

Location:

trunk/LATMOS-Accounts/bin

Files:

• la-sql-log (modified) (1 diff)
• la-sql-upgrade.in (modified) (1 diff)

trunk/LATMOS-Accounts/bin/la-sql-log

@@ -56 +56 @@
 
 foreach(@logs) {
-    printf("%s %s: %s/%s (%d) %s\n",
+    printf("%s (%d), %s: %s/%s (%d) %s\n",
         $_->{logdate},
+        $_->{irev} || -1,
         $_->{username},
         $_->{otype},

trunk/LATMOS-Accounts/bin/la-sql-upgrade.in

@@ -262 +262 @@
               logkey SERIAL NOT NULL,
               ikey bigint NOT NULL,
+              irev bigint,
               otype text NOT NULL,
               name text NOT NULL,