|
From: <jud...@us...> - 2006-04-13 17:21:15
|
Revision: 273 Author: judith_osdl Date: 2006-04-13 10:20:57 -0700 (Thu, 13 Apr 2006) ViewCVS: http://svn.sourceforge.net/stp/?rev=273&view=rev Log Message: ----------- Get rid of fkey off column that was deleted previously. Add hosttype for 'unassigned'. Modified Paths: -------------- trunk/stp-ror/db/development_structure.sql Modified: trunk/stp-ror/db/development_structure.sql =================================================================== --- trunk/stp-ror/db/development_structure.sql 2006-04-12 18:57:24 UTC (rev 272) +++ trunk/stp-ror/db/development_structure.sql 2006-04-13 17:20:57 UTC (rev 273) @@ -889,14 +889,6 @@ -- --- Name: package_sets_distro_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stp_admin --- - -ALTER TABLE ONLY package_sets - ADD CONSTRAINT package_sets_distro_id_fkey FOREIGN KEY (distro_id) REFERENCES distros(id) ON UPDATE RESTRICT ON DELETE RESTRICT; - - --- -- Name: package_sets_package_set_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stp_admin -- @@ -1040,3 +1032,5 @@ INSERT INTO test_request_states VALUES (10, NOW(), NOW(), 'Uploading Results'); INSERT INTO test_request_states VALUES (11, NOW(), NOW(), 'Installing Operating System'); +INSERT INTO host_types VALUES('0','No host type assigned',NULL,NOW()); + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |