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
--
|
