diff options
| author | Olivier Debauche <olivier.debauche@gmail.com> | 2015-11-02 20:46:24 +0100 |
|---|---|---|
| committer | Olivier Debauche <olivier.debauche@gmail.com> | 2015-11-02 20:46:24 +0100 |
| commit | 6501f5721ea868957e5c9ba3ef65d3b4ce46afa1 (patch) | |
| tree | bb658b6dede95854a25bed900360a211b3566374 /database_pgsql.sql | |
| parent | 5de157eaf528e9b135cb78b492d6eb44b96f75f7 (diff) | |
| download | PHPAuth-6501f5721ea868957e5c9ba3ef65d3b4ce46afa1.zip PHPAuth-6501f5721ea868957e5c9ba3ef65d3b4ce46afa1.tar.gz PHPAuth-6501f5721ea868957e5c9ba3ef65d3b4ce46afa1.tar.bz2 | |
Update database_pgsql.sql
bugfix
Diffstat (limited to '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', |