SF.net SVN: ledger-smb: [255] trunk/sql/Pg-tables.sql

[..hidden..]

Revision: 255
          http://svn.sourceforge.net/ledger-smb/?rev=255&view=rev
Author:   linuxpoet
Date:     2006-10-21 10:09:24 -0700 (Sat, 21 Oct 2006)

Log Message:
-----------
session.token now uses a varchar(32) with length check constraint. session_id now uses a proper serial as we don't support version < 8.x this should be fine

Modified Paths:
--------------
    trunk/sql/Pg-tables.sql

Modified: trunk/sql/Pg-tables.sql
===================================================================
--- trunk/sql/Pg-tables.sql	2006-10-21 16:53:27 UTC (rev 254)
+++ trunk/sql/Pg-tables.sql	2006-10-21 17:09:24 UTC (rev 255)
@@ -564,12 +564,10 @@
 -- Session tracking table
 
 
-CREATE SEQUENCE session_session_id_seq;
-
 CREATE TABLE session(
-session_id INTEGER PRIMARY KEY DEFAULT nextval('session_session_id_seq'),
+session_id serial PRIMARY KEY,
 sl_login VARCHAR(50),
-token CHAR(32),
+token VARCHAR(32) CHECK(length(token) = 32),
 last_used TIMESTAMP default now()
 );
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.