diff options
| author | Liam Jack <cuonic@cuonic.com> | 2015-11-05 01:59:59 +0100 |
|---|---|---|
| committer | Liam Jack <cuonic@cuonic.com> | 2015-11-05 01:59:59 +0100 |
| commit | 09f63d58f74029c3bb7be7999cd084009b459c8f (patch) | |
| tree | bb658b6dede95854a25bed900360a211b3566374 | |
| parent | 5de157eaf528e9b135cb78b492d6eb44b96f75f7 (diff) | |
| parent | 6501f5721ea868957e5c9ba3ef65d3b4ce46afa1 (diff) | |
| download | PHPAuth-09f63d58f74029c3bb7be7999cd084009b459c8f.zip PHPAuth-09f63d58f74029c3bb7be7999cd084009b459c8f.tar.gz PHPAuth-09f63d58f74029c3bb7be7999cd084009b459c8f.tar.bz2 | |
Merge pull request #156 from webot/patch-7v1.0.3
Update database_pgsql.sql
| -rw-r--r-- | database_pgsql.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/database_pgsql.sql b/database_pgsql.sql index 43462b5..9fe33a9 100644 --- a/database_pgsql.sql +++ b/database_pgsql.sql @@ -58,7 +58,7 @@ CREATE TABLE requests ( id serial NOT NULL, uid integer NOT NULL, rkey character varying (20) NOT NULL, - expire character timestamp without time zone NOT NULL, + expire timestamp without time zone NOT NULL, type character varying (20) NOT NULL, PRIMARY KEY (id) ); @@ -69,7 +69,7 @@ CREATE TABLE sessions ( uid integer NOT NULL, hash character varying(40) NOT NULL, expiredate timestamp without time zone NOT NULL, - ip varying(39) NOT NULL, + ip character varying(39) NOT NULL, agent character varying(200) NOT NULL, cookie_crc character varying(40) NOT NULL, PRIMARY KEY (id) @@ -78,7 +78,7 @@ CREATE TABLE sessions ( DROP TABLE IF EXISTS users; CREATE TABLE users ( - id serial NOT NULLL, + id serial NOT NULL, email character varying(100) DEFAULT NULL, password character varying(60) DEFAULT NULL, isactive smallint NOT NULL DEFAULT '0', |