dist/store/migrate_v1_v2.sql

141 -- to test cases will have the test_case_id set to not NULL.
145 -- of properties that map to a single test_program_id or test_case_id.
148     test_case_id INTEGER DEFAULT NULL,
153     UNIQUE (test_program_id, test_case_id, property_name)
156     ON tmp_metadatas (test_case_id);
187     SELECT NULL, test_case_id, interface, default_name, default_value
206         WHERE aux.test_case_id = tmp_metadatas.test_case_id)
207     WHERE test_case_id IS NOT NULL AND property_name = 'timeout'
218             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
219     WHERE test_case_id IS NOT NULL AND property_name = 'description'
224             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
225     WHERE test_case_id IS NOT NULL AND property_name = 'has_cleanup'
230             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
231     WHERE test_case_id IS NOT NULL AND property_name = 'timeout'
236             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
237     WHERE test_case_id IS NOT NULL AND property_name = 'required_memory'
242             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
243     WHERE test_case_id IS NOT NULL AND property_name = 'required_user'
249             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
251     WHERE test_case_id IS NOT NULL AND property_name = 'allowed_architectures'
254                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
260             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
262     WHERE test_case_id IS NOT NULL AND property_name = 'allowed_platforms'
265                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
271             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
273     WHERE test_case_id IS NOT NULL AND property_name = 'required_configs'
276                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
282             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
284     WHERE test_case_id IS NOT NULL AND property_name = 'required_files'
287                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
293             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
295     WHERE test_case_id IS NOT NULL AND property_name = 'required_programs'
298                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
311             WHERE tmp_metadatas.test_case_id = test_cases.test_case_id
325         WHERE s.test_case_id = tmp_metadatas.test_case_id
327     FROM tmp_metadatas WHERE test_case_id IS NOT NULL;