Mercurial > dive4elements > framework
diff artifact-database/doc/schema-pg.sql @ 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 | 92166f7c3842 |
| children |
line wrap: on
line diff
--- 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 );