[Benson-commit] CVS: benson3/scripts postgresql.sql,1.11,1.12

[Bob T. <bt...@us...>]

Update of /cvsroot/benson/benson3/scripts
In directory sc8-pr-cvs1:/tmp/cvs-serv24273/scripts

Modified Files:
	postgresql.sql 
Log Message:
A few fixes to the network code.

Index: postgresql.sql
===================================================================
RCS file: /cvsroot/benson/benson3/scripts/postgresql.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** postgresql.sql	11 Nov 2002 05:23:56 -0000	1.11
--- postgresql.sql	16 Dec 2003 16:17:46 -0000	1.12
***************
*** 75,83 ****
  	suppress_id INTEGER,
  	agent VARCHAR(256),
! 	STARTTIME TIMESTAMP,
! 	ENDTIME TIMESTAMP,
! 	REASON VARCHAR(256),
! 	REMOVE VARCHAR(1)
  );
  
  DROP TABLE agents;
--- 75,86 ----
  	suppress_id INTEGER,
  	agent VARCHAR(256),
! 	starttime TIMESTAMP,
! 	endtime TIMESTAMP,
! 	reason VARCHAR(256),
! 	remove VARCHAR(1),
! 	override VARCHAR (1)
  );
+ 
+ ALTER TABLE suppress ALTER COLUMN override set default 'N';
  
  DROP TABLE agents;