

-- This file contains the INSERTIONS lines to run to initialize all the _aud tables (CLIENT or SERVER side)
-- This file is GENERATED by the gmm_migration-script_to_generate_insertions.sql script.
-- To obtain those insertions lines below, please perform the following steps :
--     - Run gmm_migration-script_to_generate_insertions.sql script
-- From the generated lines : 
--     - Remove the id information for all the generated lines of the CROSS tables (because CROSS table has no id column, ie : tm_test_test_steps_aud )
--     - Change "method_id" and "paramater_id" columns by "id" for the tables tm_object_xxx (because the id columns are called 'method_id' or 'parameter_id' in object tables)
--     - Remove profile_content and gazelle_language_id of the attributes (because they are not audited)
--     - Execute : "update tm_test_type_aud set revtype = 0 ;" (if it is not done, because entries were like id=1, rev=1, revtype=1, so it was impossible to create entries id=1, rev=1, revtype=0 because of the constraints)



-- INSERTIONS (tested and OK) :

 insert into tf_actor_integration_profile_aud (rev,revtype, id, last_changed, last_modifier_id, actor_id, integration_profile_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, actor_id, integration_profile_id from tf_actor_integration_profile where id not in  (select ipo.id from tf_actor_integration_profile ipo, tf_actor_integration_profile_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_actor_integration_profile_option_aud (rev,revtype, id, last_changed, last_modifier_id, actor_integration_profile_id, integration_profile_option_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, actor_integration_profile_id, integration_profile_option_id from tf_actor_integration_profile_option where id not in  (select ipo.id from tf_actor_integration_profile_option ipo, tf_actor_integration_profile_option_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_actor_aud (rev,revtype, id, last_changed, last_modifier_id, combined, description, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, combined, description, keyword, name from tf_actor where id not in  (select ipo.id from tf_actor ipo, tf_actor_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_integration_profile_status_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name from tf_integration_profile_status_type where id not in  (select ipo.id from tf_integration_profile_status_type ipo, tf_integration_profile_status_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_integration_profile_option_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name, reference) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name, reference from tf_integration_profile_option where id not in  (select ipo.id from tf_integration_profile_option ipo, tf_integration_profile_option_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_domain_profile_aud (rev,revtype, domain_id, integration_profile_id) SELECT  1 as rev , 0 as revtype, domain_id, integration_profile_id from tf_domain_profile where (domain_id, integration_profile_id) not in  (select domain_id, integration_profile_id from tf_domain_profile_aud where revtype = 0);
 insert into tf_domain_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name from tf_domain where id not in  (select ipo.id from tf_domain ipo, tf_domain_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_integration_profile_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name, integration_profile_status_type_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name, integration_profile_status_type_id from tf_integration_profile where id not in  (select ipo.id from tf_integration_profile ipo, tf_integration_profile_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_hl7_message_profile_aud (rev,revtype, id, last_changed, last_modifier_id, hl7_version, message_order_control_code, message_type, profile_oid, profile_type, actor_id, domain_id, table_id, transaction_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, hl7_version, message_order_control_code, message_type, profile_oid, profile_type, actor_id, domain_id, table_id, transaction_id from tf_hl7_message_profile where id not in  (select ipo.id from tf_hl7_message_profile ipo, tf_hl7_message_profile_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_hl7_message_profile_table_aud (rev,revtype, id, last_changed, last_modifier_id, table_content, table_name, table_version) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, table_content, table_name, table_version from tf_hl7_message_profile_table where id not in  (select ipo.id from tf_hl7_message_profile_table ipo, tf_hl7_message_profile_table_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_integration_profile_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name from tf_integration_profile_type where id not in  (select ipo.id from tf_integration_profile_type ipo, tf_integration_profile_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_transaction_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name, reference, transaction_status_type_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name, reference, transaction_status_type_id from tf_transaction where id not in  (select ipo.id from tf_transaction ipo, tf_transaction_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_transaction_link_aud (rev,revtype, id, last_changed, last_modifier_id, from_actor_id, to_actor_id, transaction_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, from_actor_id, to_actor_id, transaction_id from tf_transaction_link where id not in  (select ipo.id from tf_transaction_link ipo, tf_transaction_link_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_transaction_status_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name from tf_transaction_status_type where id not in  (select ipo.id from tf_transaction_status_type ipo, tf_transaction_status_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_profile_link_aud (rev,revtype, id, last_changed, last_modifier_id, actor_integration_profile_id, transaction_id, transaction_option_type_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, actor_integration_profile_id, transaction_id, transaction_option_type_id from tf_profile_link where id not in  (select ipo.id from tf_profile_link ipo, tf_profile_link_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_profile_inria_hl7_validation_files_aud (rev,revtype, id, profile_xslt_file, profile_table_xslt_file, hl7_message_profile_id) SELECT  1 as rev , 0 as revtype, id, profile_xslt_file, profile_table_xslt_file, hl7_message_profile_id from tf_profile_inria_hl7_validation_files where id not in  (select ipo.id from tf_profile_inria_hl7_validation_files ipo, tf_profile_inria_hl7_validation_files_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_transaction_option_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, name from tf_transaction_option_type where id not in  (select ipo.id from tf_transaction_option_type ipo, tf_transaction_option_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tf_integration_profile_type_link_aud (rev,revtype, integration_profile_type_id, integration_profile_id) SELECT  1 as rev , 0 as revtype, integration_profile_type_id, integration_profile_id from tf_integration_profile_type_link where (integration_profile_id, integration_profile_type_id ) not in  (select integration_profile_id, integration_profile_type_id from tf_integration_profile_type_link_aud where revtype = 0);
 insert into tm_conftype_w_ports_wstype_and_sop_class_aud (rev,revtype, id, port_non_secure, port_secure, configurationtype_id, sop_class_id, web_service_type_id, comment, transport_layer_id) SELECT  1 as rev , 0 as revtype, id, port_non_secure, port_secure, configurationtype_id, sop_class_id, web_service_type_id, comment, transport_layer_id from tm_conftype_w_ports_wstype_and_sop_class where id not in  (select ipo.id from tm_conftype_w_ports_wstype_and_sop_class ipo, tm_conftype_w_ports_wstype_and_sop_class_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_conf_mapping_w_aipo_w_conftypes_aud (rev,revtype, tm_conf_mapped_id, tm_conftypes_id) SELECT  1 as rev , 0 as revtype, tm_conf_mapped_id, tm_conftypes_id from tm_conf_mapping_w_aipo_w_conftypes where (tm_conf_mapped_id, tm_conftypes_id) not in  (select tm_conf_mapped_id, tm_conftypes_id from tm_conf_mapping_w_aipo_w_conftypes_aud where revtype = 0);
 insert into tm_configuration_mapped_with_aipo_aud (rev,revtype, id, last_changed, last_modifier_id, aipo_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, aipo_id from tm_configuration_mapped_with_aipo where id not in  (select ipo.id from tm_configuration_mapped_with_aipo ipo, tm_configuration_mapped_with_aipo_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_configuration_type_aud (rev,revtype, id, last_changed, last_modifier_id, category, class_name, type_name, used_for_proxy) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, category, class_name, type_name, used_for_proxy from tm_configuration_type where id not in  (select ipo.id from tm_configuration_type ipo, tm_configuration_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_contextual_information_aud (rev,revtype, id, last_changed, last_modifier_id, label, path, value) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, label, path, value from tm_contextual_information where id not in  (select ipo.id from tm_contextual_information ipo, tm_contextual_information_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_creator_aud (rev,revtype, id, last_changed, last_modifier_id, description, aipo_id, object_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, aipo_id, object_id from tm_object_creator where id not in  (select ipo.id from tm_object_creator ipo, tm_object_creator_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_class_validator_aud (rev,revtype, validator_class_id, last_changed, last_modifier_id, description, name, value, file_type_id) SELECT  1 as rev , 0 as revtype, validator_class_id, last_changed, last_modifier_id, description, name, value, file_type_id from tm_object_class_validator where validator_class_id not in  (select validator_class_id from tm_object_class_validator_aud where revtype = 0);
 insert into tm_meta_test_aud (rev,revtype, id, last_changed, last_modifier_id, keyword, short_description) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, keyword, short_description from tm_meta_test where id not in  (select ipo.id from tm_meta_test ipo, tm_meta_test_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_meta_test_test_roles_aud (rev,revtype, meta_test_id, test_roles_id) SELECT  1 as rev , 0 as revtype, meta_test_id, test_roles_id from tm_meta_test_test_roles where (meta_test_id, test_roles_id) not in  (select meta_test_id, test_roles_id from tm_meta_test_test_roles_aud where revtype = 0);
 insert into tm_object_attribute_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, object_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, object_id from tm_object_attribute where id not in  (select ipo.id from tm_object_attribute ipo, tm_object_attribute_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_attribute_option_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, attribue_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, attribue_id from tm_object_attribute_option where id not in  (select ipo.id from tm_object_attribute_option ipo, tm_object_attribute_option_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_method_validator_aud (rev,revtype, method_id, last_changed, last_modifier_id, description, name, value, validator_class_id) SELECT  1 as rev , 0 as revtype, method_id, last_changed, last_modifier_id, description, name, value, validator_class_id from tm_object_method_validator where method_id not in  (select method_id from tm_object_method_validator_aud where revtype = 0);
 insert into tm_object_file_aud (rev,revtype, id, last_changed, last_modifier_id, description, object_id, type_id, max, min, uploader) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, object_id, type_id, max, min, uploader from tm_object_file where id not in  (select ipo.id from tm_object_file ipo, tm_object_file_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_file_method_aud (rev,revtype, id, method_id) SELECT  1 as rev , 0 as revtype, id, method_id from tm_object_file_method where id not in  (select ipo.id from tm_object_file_method ipo, tm_object_file_method_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_method_parameter_aud (rev,revtype, method_id, parameter_id) SELECT  1 as rev , 0 as revtype, method_id, parameter_id from tm_object_method_parameter where (method_id, parameter_id) not in  (select method_id, parameter_id from tm_object_method_parameter_aud where revtype = 0);
 insert into tm_object_file_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, extensions) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, extensions from tm_object_file_type where id not in  (select ipo.id from tm_object_file_type ipo, tm_object_file_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_instance_validation_aud (rev,revtype, id, last_changed, last_modifier_id, description, value) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, value from tm_object_instance_validation where id not in  (select ipo.id from tm_object_instance_validation ipo, tm_object_instance_validation_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_parameter_validator_aud (rev,revtype, parameter_id, last_changed, last_modifier_id, description, value) SELECT  1 as rev , 0 as revtype, parameter_id, last_changed, last_modifier_id, description, value from tm_object_parameter_validator where parameter_id not in  (select parameter_id from tm_object_parameter_validator_aud where revtype = 0);
 insert into tm_object_type_aud (rev,revtype, id, last_changed, last_modifier_id, default_desc, description, instructions, keyword, object_type_status_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, default_desc, description, instructions, keyword, object_type_status_id from tm_object_type where id not in  (select ipo.id from tm_object_type ipo, tm_object_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_type_status_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, label_to_display) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, label_to_display from tm_object_type_status where id not in  (select ipo.id from tm_object_type_status ipo, tm_object_type_status_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_object_reader_aud (rev,revtype, id, last_changed, last_modifier_id, description, aipo_id, object_id) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, aipo_id, object_id from tm_object_reader where id not in  (select ipo.id from tm_object_reader ipo, tm_object_reader_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_role_in_test_aud (rev,revtype, id, last_changed, last_modifier_id, keyword, is_role_played_by_a_tool) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, keyword, is_role_played_by_a_tool from tm_role_in_test where id not in  (select ipo.id from tm_role_in_test ipo, tm_role_in_test_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_role_in_test_test_participants_aud (rev,revtype, role_in_test_id, test_participants_id) SELECT  1 as rev , 0 as revtype, role_in_test_id, test_participants_id from tm_role_in_test_test_participants where (role_in_test_id, test_participants_id) not in  (select role_in_test_id, test_participants_id from tm_role_in_test_test_participants_aud where revtype = 0);
 insert into tm_sop_class_aud (rev,revtype, id, keyword, name) SELECT  1 as rev , 0 as revtype, id, keyword, name from tm_sop_class where id not in  (select ipo.id from tm_sop_class ipo, tm_sop_class_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_description_aud (rev,revtype, id, last_changed, last_modifier_id, description ) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description from tm_test_description where id not in  (select ipo.id from tm_test_description ipo, tm_test_description_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, label_to_display) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, label_to_display from tm_test_type where id not in  (select ipo.id from tm_test_type ipo, tm_test_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_aud (rev,revtype, id, last_changed, last_modifier_id, keyword, name, number_of_tests_to_realize, short_description, version, test_status_id, test_type_id, test_peer_type_id, orchestrated) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, keyword, name, number_of_tests_to_realize, short_description, version, test_status_id, test_type_id, test_peer_type_id, orchestrated from tm_test where id not in  (select ipo.id from tm_test ipo, tm_test_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_option_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, label_to_display) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, label_to_display from tm_test_option where id not in  (select ipo.id from tm_test_option ipo, tm_test_option_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_participants_aud (rev,revtype, id, is_tested, actor_integration_profile_option_id) SELECT  1 as rev , 0 as revtype, id, is_tested, actor_integration_profile_option_id from tm_test_participants where id not in  (select ipo.id from tm_test_participants ipo, tm_test_participants_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_peer_type_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, label_to_display) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, label_to_display from tm_test_peer_type where id not in  (select ipo.id from tm_test_peer_type ipo, tm_test_peer_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_roles_aud (rev,revtype, id, last_changed, last_modifier_id, card_max, card_min, url, url_doc, role_in_test_id, test_id, test_option_id, number_of_tests_to_realize) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, card_max, card_min, url, url_doc, role_in_test_id, test_id, test_option_id, number_of_tests_to_realize from tm_test_roles where id not in  (select ipo.id from tm_test_roles ipo, tm_test_roles_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_steps_aud (rev,revtype, id, last_changed, last_modifier_id, description, message_type, step_index, test_roles_initiator_id, test_roles_responder_id, test_steps_option_id, transaction_id, secured) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, message_type, step_index, test_roles_initiator_id, test_roles_responder_id, test_steps_option_id, transaction_id, secured from tm_test_steps where id not in  (select ipo.id from tm_test_steps ipo, tm_test_steps_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_steps_input_ci_aud (rev,revtype, test_steps_id, contextual_information_id) SELECT  1 as rev , 0 as revtype, test_steps_id, contextual_information_id from tm_test_steps_input_ci where (test_steps_id, contextual_information_id) not in  (select test_steps_id, contextual_information_id from tm_test_steps_input_ci_aud where revtype = 0);
 insert into tm_test_status_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, label_to_display) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, label_to_display from tm_test_status where id not in  (select ipo.id from tm_test_status ipo, tm_test_status_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_test_description_aud (rev,revtype, test_id, test_description_id) SELECT  1 as rev , 0 as revtype, test_id, test_description_id from tm_test_test_description where (test_id, test_description_id) not in  (select test_id, test_description_id from tm_test_test_description_aud where revtype = 0);
 insert into tm_test_steps_option_aud (rev,revtype, id, last_changed, last_modifier_id, description, keyword, label_to_display) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, description, keyword, label_to_display from tm_test_steps_option where id not in  (select ipo.id from tm_test_steps_option ipo, tm_test_steps_option_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_steps_output_ci_aud (rev,revtype, test_steps_id, contextual_information_id) SELECT  1 as rev , 0 as revtype, test_steps_id, contextual_information_id from tm_test_steps_output_ci where (test_steps_id, contextual_information_id) not in  (select test_steps_id, contextual_information_id from tm_test_steps_output_ci_aud where revtype = 0);
 insert into tm_transport_layer_for_config_aud (rev,revtype, id, last_changed, last_modifier_id, keyword, name) SELECT  1 as rev , 0 as revtype, id, '2008-04-01 00:00:00.0' as last_changed, '0' as last_modifier_id, keyword, name from tm_transport_layer_for_config where id not in  (select ipo.id from tm_transport_layer_for_config ipo, tm_transport_layer_for_config_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);
 insert into tm_test_test_steps_aud (rev,revtype, test_id, test_steps_id) SELECT  1 as rev , 0 as revtype, test_id, test_steps_id from tm_test_test_steps where (test_id, test_steps_id) not in  (select test_id, test_steps_id from tm_test_test_steps_aud where revtype = 0);
 insert into tm_web_service_type_aud (rev,revtype, id, description, needs_oid, profile_id) SELECT  1 as rev , 0 as revtype, id, description, needs_oid, profile_id from tm_web_service_type where id not in  (select ipo.id from tm_web_service_type ipo, tm_web_service_type_aud ipoa where ipo.id = ipoa.id and ipoa.revtype = 0);








