Mercurial > dive4elements > framework
changeset 406:10aa92f2eca0
Add a account column to the users table
artifacts/trunk@5242 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Thu, 23 Aug 2012 13:33:27 +0000 |
| parents | e1738650bfca |
| children | 08731e7403b5 |
| files | ChangeLog artifact-database/doc/schema-h2.sql artifact-database/doc/schema-pg.sql |
| diffstat | 3 files changed, 10 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- 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:
--- 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 );
--- 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 );