Menu
▾
▴
stp-svn
|
From: <jud...@us...> - 2006-04-12 18:57:30
|
Revision: 272 Author: judith_osdl Date: 2006-04-12 11:57:24 -0700 (Wed, 12 Apr 2006) ViewCVS: http://svn.sourceforge.net/stp/?rev=272&view=rev Log Message: ----------- Add the states to the test_request_states table. 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-06 22:17:52 UTC (rev 271) +++ trunk/stp-ror/db/development_structure.sql 2006-04-12 18:57:24 UTC (rev 272) @@ -1028,3 +1028,15 @@ -- PostgreSQL database dump complete -- +INSERT INTO test_request_states VALUES (1, NOW(), NOW(), 'Queued'); +INSERT INTO test_request_states VALUES (2, NOW(), NOW(), 'Running'); +INSERT INTO test_request_states VALUES (3, NOW(), NOW(), 'Completed'); +INSERT INTO test_request_states VALUES (4, NOW(), NOW(), 'Failed'); +INSERT INTO test_request_states VALUES (5, NOW(), NOW(), 'Canceled'); +INSERT INTO test_request_states VALUES (6, NOW(), NOW(), 'Recovering'); +INSERT INTO test_request_states VALUES (7, NOW(), NOW(), 'Inserting'); +INSERT INTO test_request_states VALUES (8, NOW(), NOW(), 'Adding Additional Software'); +INSERT INTO test_request_states VALUES (9, NOW(), NOW(), 'Rebooting After Kernel Install'); +INSERT INTO test_request_states VALUES (10, NOW(), NOW(), 'Uploading Results'); +INSERT INTO test_request_states VALUES (11, NOW(), NOW(), 'Installing Operating System'); + This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
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. |
|
From: <jud...@us...> - 2006-05-04 21:26:32
|
Revision: 274 Author: judith_osdl Date: 2006-05-04 14:26:28 -0700 (Thu, 04 May 2006) ViewCVS: http://svn.sourceforge.net/stp/?rev=274&view=rev Log Message: ----------- Add a software types table. Make column names match in softwares and softwares_test_requests. 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-13 17:20:57 UTC (rev 273) +++ trunk/stp-ror/db/development_structure.sql 2006-05-04 21:26:28 UTC (rev 274) @@ -332,20 +332,25 @@ id bigserial NOT NULL, created_on timestamp without time zone DEFAULT now(), updated_on timestamp without time zone DEFAULT now(), + patch_name text NOT NULL, + software_type_id integer NOT NULL +); + +CREATE TABLE software_types ( + id serial NOT NULL, name text NOT NULL ); - SET default_with_oids = true; -- --- Name: softwares_test_cases; Type: TABLE; Schema: public; Owner: stp_admin; Tablespace: +-- Name: software_types_test_cases; Type: TABLE; Schema: public; Owner: stp_admin; Tablespace: -- -CREATE TABLE softwares_test_cases ( +CREATE TABLE software_types_test_cases ( test_case_id integer NOT NULL, install_priority integer NOT NULL, - software_id integer NOT NULL + software_type_id integer NOT NULL ); @@ -651,11 +656,11 @@ -- --- Name: softwares_test_cases_pkey; Type: CONSTRAINT; Schema: public; Owner: stp_admin; Tablespace: +-- Name: software_types_test_cases_pkey; Type: CONSTRAINT; Schema: public; Owner: stp_admin; Tablespace: -- -ALTER TABLE ONLY softwares_test_cases - ADD CONSTRAINT softwares_test_cases_pkey PRIMARY KEY (test_case_id, software_id); +ALTER TABLE ONLY software_types_test_cases + ADD CONSTRAINT software_types_test_cases_pkey PRIMARY KEY (test_case_id, software_id); -- @@ -929,19 +934,19 @@ -- --- Name: softwares_test_cases_software_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stp_admin +-- Name: software_types_test_cases_software_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stp_admin -- -ALTER TABLE ONLY softwares_test_cases - ADD CONSTRAINT softwares_test_cases_software_id_fkey FOREIGN KEY (software_id) REFERENCES softwares(id) ON UPDATE RESTRICT ON DELETE RESTRICT; +ALTER TABLE ONLY software_types_test_cases + ADD CONSTRAINT software_types_test_cases_software_type_id_fkey FOREIGN KEY (software_type_id) REFERENCES software_types(id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- --- Name: softwares_test_cases_test_case_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stp_admin +-- Name: software_types_test_cases_test_case_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stp_admin -- -ALTER TABLE ONLY softwares_test_cases - ADD CONSTRAINT softwares_test_cases_test_case_id_fkey FOREIGN KEY (test_case_id) REFERENCES test_cases(id) ON UPDATE RESTRICT ON DELETE RESTRICT; +ALTER TABLE ONLY software_types_test_cases + ADD CONSTRAINT software_types_test_cases_test_case_id_fkey FOREIGN KEY (test_case_id) REFERENCES test_cases(id) ON UPDATE RESTRICT ON DELETE RESTRICT; -- This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
Thanks for helping keep SourceForge clean.
X