Mercurial > dive4elements > framework
comparison artifact-database/doc/schema-h2.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 | b8067c6f67f6 |
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 BINARY | 28 role BINARY |
28 ); | 29 ); |
29 | 30 |
30 CREATE SEQUENCE COLLECTIONS_ID_SEQ; | 31 CREATE SEQUENCE COLLECTIONS_ID_SEQ; |
31 | 32 |