[stp-svn] SF.net SVN: stp: [273] trunk/stp-ror/db/development_structure.sql

[<jud...@us...>]

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.