[Helpmeict-cvs] Helpdesk/install DB-PostgreSQL.sql,1.5,1.6

[Scott P. <wht...@us...>]

Update of /cvsroot/helpmeict/Helpdesk/install
In directory sc8-pr-cvs17:/tmp/cvs-serv11320/install

Modified Files:
	DB-PostgreSQL.sql 
Log Message:
Add back in worktimer
Fix PostgreSQL create script for tbl_wrktimer


Index: DB-PostgreSQL.sql
===================================================================
RCS file: /cvsroot/helpmeict/Helpdesk/install/DB-PostgreSQL.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** DB-PostgreSQL.sql	16 Sep 2007 23:21:07 -0000	1.5
--- DB-PostgreSQL.sql	30 Sep 2007 19:11:33 -0000	1.6
***************
*** 4,33 ****
  
  SET client_encoding = 'SQL_ASCII';
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  
  --
! -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
  --
  
  
[...2853 lines suppressed...]
+ 
+ --
+ -- Name: tbl_wrktimer_userid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+ --
+ 
+ ALTER TABLE ONLY tbl_wrktimer
+     ADD CONSTRAINT tbl_wrktimer_userid_fkey FOREIGN KEY (userid) REFERENCES tbl_users(id) ON DELETE CASCADE;
+ 
+ 
+ --
+ -- Name: public; Type: ACL; Schema: -; Owner: -
+ --
+ 
+ REVOKE ALL ON SCHEMA public FROM PUBLIC;
+ GRANT ALL ON SCHEMA public TO PUBLIC;
+ 
+ 
+ --
  -- PostgreSQL database dump complete
  --