# HG changeset patch
# User Bjoern Ricks <bjoern.ricks@intevation.de>
# Date 1345728807 0
# Node ID 10aa92f2eca0322f5d2a4c9fbb589e5447a47d6c
# Parent  e1738650bfcac090755d366face1c68a7da18d0f
Add a account column to the users table


artifacts/trunk@5242 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r e1738650bfca -r 10aa92f2eca0 ChangeLog
--- a/ChangeLog	Sun Jul 29 11:38:40 2012 +0000
+++ b/ChangeLog	Thu Aug 23 13:33:27 2012 +0000
@@ -1,3 +1,9 @@
+2012-08-23	Björn Ricks	<bjoern.ricks@intevation.de>
+
+	* artifact-database/doc/schema-pg.sql,
+	  artifact-database/doc/schema-h2.sql:
+	  Add a account column to the users table.
+
 2012-07-29	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* artifact-database/src/main/java/de/intevation/artifactdatabase/state/FacetActivity.java:
diff -r e1738650bfca -r 10aa92f2eca0 artifact-database/doc/schema-h2.sql
--- a/artifact-database/doc/schema-h2.sql	Sun Jul 29 11:38:40 2012 +0000
+++ b/artifact-database/doc/schema-h2.sql	Thu Aug 23 13:33:27 2012 +0000
@@ -23,7 +23,8 @@
 CREATE TABLE users (
     id   INT PRIMARY KEY NOT NULL,
     gid  UUID            NOT NULL UNIQUE,
-    name VARCHAR(256)    NOT NULL UNIQUE,
+    name VARCHAR(256)    NOT NULL,
+    account VARCHAR(256) NOT NULL UNIQUE,
     role BINARY
 );
 
diff -r e1738650bfca -r 10aa92f2eca0 artifact-database/doc/schema-pg.sql
--- a/artifact-database/doc/schema-pg.sql	Sun Jul 29 11:38:40 2012 +0000
+++ b/artifact-database/doc/schema-pg.sql	Thu Aug 23 13:33:27 2012 +0000
@@ -23,7 +23,8 @@
 CREATE TABLE users (
     id   int PRIMARY KEY NOT NULL,
     gid  uuid            NOT NULL UNIQUE,
-    name VARCHAR(256)    NOT NULL UNIQUE,
+    name VARCHAR(256)    NOT NULL,
+    account VARCHAR(256) NOT NULL UNIQUE,
     role bytea
 );