Login   Register  
PHP Classes
elePHPant
Icontem

File: pgsql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Marcelo Costa  >  Mafia Session  >  pgsql.sql  >  Download  
File: pgsql.sql
Role: Auxiliary data
Content type: text/plain
Description: postgres database script
Class: Mafia Session
Secure user authentication encrypting password
Author: By
Last change:
Date: 7 years ago
Size: 395 bytes
 

Contents

Class file image Download
-- PGSQL
CREATE TABLE _session
(
  id_session serial NOT NULL,
  remote_addr integer NOT NULL,
  request_uri character varying(128) NOT NULL,
  keytime bigint NOT NULL,
  keepalive integer
) 
WITH OIDS;
CREATE TABLE "login"
(
  id_login serial NOT NULL,
  "login" character varying(20) NOT NULL,
  senhamd5 character varying(32) NOT NULL,
  senhasha1 character varying(40) NOT NULL
) 
WITH OIDS;