SF.net SVN: ledger-smb:[2622] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 2622
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2622&view=rev
Author:   jfkw
Date:     2009-06-04 04:22:46 +0000 (Thu, 04 Jun 2009)

Log Message:
-----------
Pg-database.sql: change session.notify_password type to interval.

Change session.notify pasword to type interval, as used in
users.notify_password. Add type hint ::interval to default expression for both
columns.

psql:sql/Pg-database.sql:85: ERROR: column "notify_pasword" is of type integer
but default expression is of type boolean

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2009-06-04 02:25:56 UTC (rev 2621)
+++ trunk/sql/Pg-database.sql	2009-06-04 04:22:46 UTC (rev 2622)
@@ -65,7 +65,7 @@
 CREATE TABLE users (
     id serial UNIQUE, 
     username varchar(30) primary key,
-    notify_password interval not null default '7 days',
+    notify_password interval not null default '7 days'::interval,
     entity_id int not null references entity(id) on delete cascade
 );
 
@@ -81,7 +81,7 @@
 ttl int default 3600 not null,
 users_id INTEGER NOT NULL references users(id),
 transaction_id INTEGER NOT NULL,
-notify_pasword integer not null default false
+notify_pasword interval not null default '7 days'::interval
 );
 
 CREATE TABLE open_forms (


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