Mercurial > dive4elements > framework
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 405:e1738650bfca | 406:10aa92f2eca0 |
|---|---|
| 21 CREATE SEQUENCE USERS_ID_SEQ; | 21 CREATE SEQUENCE USERS_ID_SEQ; |
| 22 | 22 |
| 23 CREATE TABLE users ( | 23 CREATE TABLE users ( |
| 24 id int PRIMARY KEY NOT NULL, | 24 id int PRIMARY KEY NOT NULL, |
| 25 gid uuid NOT NULL UNIQUE, | 25 gid uuid NOT NULL UNIQUE, |
| 26 name VARCHAR(256) NOT NULL UNIQUE, | 26 name VARCHAR(256) NOT NULL, |
| 27 account VARCHAR(256) NOT NULL UNIQUE, | |
| 27 role bytea | 28 role bytea |
| 28 ); | 29 ); |
| 29 | 30 |
| 30 CREATE SEQUENCE COLLECTIONS_ID_SEQ; | 31 CREATE SEQUENCE COLLECTIONS_ID_SEQ; |
| 31 | 32 |