Eli Mesika has uploaded a new change for review. Change subject: db: data files based on 3.3 ......................................................................
db: data files based on 3.3 Generated data files per table by pg_dump utility Change-Id: Ib9d7bbcbc98c18e060a63f96fba89310ea069f7b Signed-off-by: emesika <[email protected]> --- M packaging/dbscripts/data/00000_insert_schema_version.sql M packaging/dbscripts/data/00100_insert_users.sql M packaging/dbscripts/data/00200_insert_ad_groups.sql M packaging/dbscripts/data/00300_insert_storage_pool.sql A packaging/dbscripts/data/00340_insert_policy_units.sql A packaging/dbscripts/data/00350_insert_cluster_policies.sql A packaging/dbscripts/data/00360_insert_cluster_policy_units.sql M packaging/dbscripts/data/00400_insert_vds_groups.sql M packaging/dbscripts/data/00500_insert_roles.sql M packaging/dbscripts/data/00600_insert_permissions.sql M packaging/dbscripts/data/00700_insert_roles_groups.sql M packaging/dbscripts/data/00800_insert_images.sql M packaging/dbscripts/data/00900_insert_network.sql M packaging/dbscripts/data/01000_insert_network_cluster.sql M packaging/dbscripts/data/01100_insert_vm_static.sql M packaging/dbscripts/data/01200_insert_vm_device.sql M packaging/dbscripts/data/01300_insert_vm_ovf_generations.sql M packaging/dbscripts/data/01400_insert_action_version_map.sql M packaging/dbscripts/data/01500_insert_event_map.sql M packaging/dbscripts/data/01600_insert_dwh_history_timekeeping.sql A packaging/dbscripts/data/01700_insert_gluster_service_types.sql A packaging/dbscripts/data/01800_insert_gluster_services.sql A packaging/dbscripts/data/01900_insert_vnic_profiles.sql 23 files changed, 437 insertions(+), 36 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/62/37462/1 diff --git a/packaging/dbscripts/data/00000_insert_schema_version.sql b/packaging/dbscripts/data/00000_insert_schema_version.sql index c90dd97..1340bd9 100644 --- a/packaging/dbscripts/data/00000_insert_schema_version.sql +++ b/packaging/dbscripts/data/00000_insert_schema_version.sql @@ -8,7 +8,7 @@ -- INSERT INTO schema_version(version,script,checksum,installed_by,ended_at,state,current) - values ('03040000','upgrade/03_04_0000_set_version.sql','0','engine',now(),'INSTALLED',true); + values ('03030000','upgrade/03_03_0000_set_version.sql','0','engine',now(),'INSTALLED',true); -- diff --git a/packaging/dbscripts/data/00100_insert_users.sql b/packaging/dbscripts/data/00100_insert_users.sql index 8986586..913a62a 100644 --- a/packaging/dbscripts/data/00100_insert_users.sql +++ b/packaging/dbscripts/data/00100_insert_users.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO users (user_id, name, surname, domain, username, groups, department, role, user_icon_path, desktop_device, email, note, status, session_count, last_admin_check_status, group_ids) VALUES ('fdfc627c-d875-11e0-90f0-83df133b58cc', 'admin', NULL, 'internal', 'admin@internal', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, false, NULL); +INSERT INTO users (user_id, name, surname, domain, username, groups, department, role, email, note, status, last_admin_check_status, group_ids, external_id) VALUES ('fdfc627c-d875-11e0-90f0-83df133b58cc', 'admin', NULL, 'internal', 'admin@internal', '', NULL, NULL, NULL, NULL, 1, false, NULL, '\xfdfc627cd87511e090f083df133b58cc'); -- diff --git a/packaging/dbscripts/data/00200_insert_ad_groups.sql b/packaging/dbscripts/data/00200_insert_ad_groups.sql index bb643eb..aa51f3d 100644 --- a/packaging/dbscripts/data/00200_insert_ad_groups.sql +++ b/packaging/dbscripts/data/00200_insert_ad_groups.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: ad_groups; Type: TABLE DATA; Schema: public; Owner: engine diff --git a/packaging/dbscripts/data/00300_insert_storage_pool.sql b/packaging/dbscripts/data/00300_insert_storage_pool.sql index 3c9d6af..9ea9583 100644 --- a/packaging/dbscripts/data/00300_insert_storage_pool.sql +++ b/packaging/dbscripts/data/00300_insert_storage_pool.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: storage_pool; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO storage_pool (id, name, description, storage_pool_type, storage_pool_format_type, status, master_domain_version, spm_vds_id, compatibility_version, _create_date, _update_date, quota_enforcement_type) VALUES ('00000002-0002-0002-0002-00000000021c', 'Default', 'The default Data Center', 1, NULL, 0, 0, NULL, '3.6', '2015-01-21 15:14:26.872109+02', NULL, NULL); +INSERT INTO storage_pool (id, name, description, storage_pool_type, storage_pool_format_type, status, master_domain_version, spm_vds_id, compatibility_version, _create_date, _update_date, quota_enforcement_type, free_text_comment) VALUES ('00000002-0002-0002-0002-00000000021c', 'Default', 'The default Data Center', 1, NULL, 0, 0, NULL, '3.6', '2015-01-21 15:14:26.872109+02', NULL, NULL, NULL); -- diff --git a/packaging/dbscripts/data/00340_insert_policy_units.sql b/packaging/dbscripts/data/00340_insert_policy_units.sql new file mode 100644 index 0000000..301ba38 --- /dev/null +++ b/packaging/dbscripts/data/00340_insert_policy_units.sql @@ -0,0 +1,41 @@ +-- +-- PostgreSQL database dump +-- + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; + +-- +-- Data for Name: policy_units; Type: TABLE DATA; Schema: public; Owner: engine +-- + +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('12262ab6-9690-4bc3-a2b3-35573b172d54', 'PinToHost', true, NULL, 0, true, 'Filters out all hosts that VM is not pinned to'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('6d636bf6-a35c-4f9d-b68d-0731f720cddc', 'CPU', true, NULL, 0, true, 'Filters out hosts with less CPUs than VM''s CPUs'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('c9ddbb34-0e1d-4061-a8d7-b0893fa80932', 'Memory', true, NULL, 0, true, 'Filters out hosts that have insufficient memory to run the VM'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('72163d1c-9468-4480-99d9-0888664eb143', 'Network', true, NULL, 0, true, 'Filters out hosts that are missing networks required by VM NICs, or missing cluster''s display network'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('38440000-8cf0-14bd-c43e-10b96e4ef00a', 'None', true, NULL, 2, true, 'No load balancing operation'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('38440000-8cf0-14bd-c43e-10b96e4ef00b', 'None', true, NULL, 1, true, 'Follows Even Distribution weight module'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('438b052c-90ab-40e8-9be0-a22560202ea6', 'CPU-Level', true, NULL, 0, true, 'Runs VMs only on hosts with a proper CPU level'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('736999d0-1023-46a4-9a75-1316ed50e151', 'OptimalForPowerSaving', true, '{ + "CpuOverCommitDurationMinutes" : "^([1-9])$", + "HighUtilization" : "^([5-9][0-9])$", + "LowUtilization" : "^([1-4][0-9])$" +}', 2, true, 'Load balancing VMs in cluster according to hosts CPU load, striving cluster''s hosts CPU load to be over ''LowUtilization'' and under ''HighUtilization'''); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('736999d0-1023-46a4-9a75-1316ed50e15b', 'OptimalForPowerSaving', true, NULL, 1, true, 'Gives hosts with higher CPU usage, higher weight (means that hosts with lower CPU usage are more likely to be selected)'); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('7db4ab05-81ab-42e8-868a-aee2df483ed2', 'OptimalForEvenDistribution', true, '{ + "CpuOverCommitDurationMinutes" : "^([1-9])$", + "HighUtilization" : "^([5-9][0-9])$" +}', 2, true, 'Load balancing VMs in cluster according to hosts CPU load, striving cluster''s hosts CPU load to be under ''HighUtilization'''); +INSERT INTO policy_units (id, name, is_internal, custom_properties_regex, type, enabled, description) VALUES ('7db4ab05-81ab-42e8-868a-aee2df483edb', 'OptimalForEvenDistribution', true, NULL, 1, true, 'Gives hosts with lower CPU usage, higher weight (means that hosts with higher CPU usage are more likely to be selected)'); + + +-- +-- PostgreSQL database dump complete +-- + diff --git a/packaging/dbscripts/data/00350_insert_cluster_policies.sql b/packaging/dbscripts/data/00350_insert_cluster_policies.sql new file mode 100644 index 0000000..393d58f --- /dev/null +++ b/packaging/dbscripts/data/00350_insert_cluster_policies.sql @@ -0,0 +1,33 @@ +-- +-- PostgreSQL database dump +-- + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; + +-- +-- Data for Name: cluster_policies; Type: TABLE DATA; Schema: public; Owner: engine +-- + +INSERT INTO cluster_policies (id, name, description, is_locked, is_default, custom_properties) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', 'Evenly_Distributed', '', true, false, '{ + "CpuOverCommitDurationMinutes" : "2", + "HighUtilization" : "80" +}'); +INSERT INTO cluster_policies (id, name, description, is_locked, is_default, custom_properties) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', 'Power_Saving', '', true, false, '{ + "CpuOverCommitDurationMinutes" : "2", + "HighUtilization" : "80", + "LowUtilization" : "20" +}'); +INSERT INTO cluster_policies (id, name, description, is_locked, is_default, custom_properties) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', 'None', '', true, true, NULL); + + +-- +-- PostgreSQL database dump complete +-- + diff --git a/packaging/dbscripts/data/00360_insert_cluster_policy_units.sql b/packaging/dbscripts/data/00360_insert_cluster_policy_units.sql new file mode 100644 index 0000000..3e277bd --- /dev/null +++ b/packaging/dbscripts/data/00360_insert_cluster_policy_units.sql @@ -0,0 +1,44 @@ +-- +-- PostgreSQL database dump +-- + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; + +-- +-- Data for Name: cluster_policy_units; Type: TABLE DATA; Schema: public; Owner: engine +-- + +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', 'c9ddbb34-0e1d-4061-a8d7-b0893fa80932', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', '6d636bf6-a35c-4f9d-b68d-0731f720cddc', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', '12262ab6-9690-4bc3-a2b3-35573b172d54', -1, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', '7db4ab05-81ab-42e8-868a-aee2df483ed2', 0, 1); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', '72163d1c-9468-4480-99d9-0888664eb143', 1, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', 'c9ddbb34-0e1d-4061-a8d7-b0893fa80932', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', '736999d0-1023-46a4-9a75-1316ed50e151', 0, 1); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', '6d636bf6-a35c-4f9d-b68d-0731f720cddc', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', '72163d1c-9468-4480-99d9-0888664eb143', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', '38440000-8cf0-14bd-c43e-10b96e4ef00a', 0, 1); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', 'c9ddbb34-0e1d-4061-a8d7-b0893fa80932', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', '6d636bf6-a35c-4f9d-b68d-0731f720cddc', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', '12262ab6-9690-4bc3-a2b3-35573b172d54', -1, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', '72163d1c-9468-4480-99d9-0888664eb143', 1, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', '38440000-8cf0-14bd-c43e-10b96e4ef00b', 0, 1); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', '736999d0-1023-46a4-9a75-1316ed50e15b', 0, 1); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', '7db4ab05-81ab-42e8-868a-aee2df483edb', 0, 1); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('20d25257-b4bd-4589-92a6-c4c5c5d3fd1a', '438b052c-90ab-40e8-9be0-a22560202ea6', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', '438b052c-90ab-40e8-9be0-a22560202ea6', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('b4ed2332-a7ac-4d5f-9596-99a439cb2812', '438b052c-90ab-40e8-9be0-a22560202ea6', 0, 0); +INSERT INTO cluster_policy_units (cluster_policy_id, policy_unit_id, filter_sequence, factor) VALUES ('5a2b0939-7d46-4b73-a469-e9c2c7fc6a53', '12262ab6-9690-4bc3-a2b3-35573b172d54', -1, 0); + + +-- +-- PostgreSQL database dump complete +-- + diff --git a/packaging/dbscripts/data/00400_insert_vds_groups.sql b/packaging/dbscripts/data/00400_insert_vds_groups.sql index a932d3a..2f98c55 100644 --- a/packaging/dbscripts/data/00400_insert_vds_groups.sql +++ b/packaging/dbscripts/data/00400_insert_vds_groups.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: vds_groups; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO vds_groups (vds_group_id, name, description, cpu_name, _create_date, _update_date, selection_algorithm, high_utilization, low_utilization, cpu_over_commit_duration_minutes, storage_pool_id, max_vds_memory_over_commit, compatibility_version, transparent_hugepages, migrate_on_error, virt_service, gluster_service, count_threads_as_cores) VALUES ('00000001-0001-0001-0001-0000000000d6', 'Default', 'The default server cluster', NULL, '2015-01-21 15:14:26.872109+02', NULL, 0, 75, 0, 2, '00000002-0002-0002-0002-00000000021c', 100, '3.6', true, 1, true, false, false); +INSERT INTO vds_groups (vds_group_id, name, description, cpu_name, _create_date, _update_date, storage_pool_id, max_vds_memory_over_commit, compatibility_version, transparent_hugepages, migrate_on_error, virt_service, gluster_service, count_threads_as_cores, emulated_machine, trusted_service, tunnel_migration, cluster_policy_id, cluster_policy_custom_properties, enable_balloon, free_text_comment, detect_emulated_machine) VALUES ('00000001-0001-0001-0001-0000000000d6', 'Default', 'The default server cluster', NULL, '2015-01-21 15:14:26.872109+02', NULL, '00000002-0002-0002-0002-00000000021c', 100, '3.6', true, 1, true, false, false, NULL, false, false, 'b4ed2332-a7ac-4d5f-9596-99a439cb2812', NULL, false, NULL, true); -- diff --git a/packaging/dbscripts/data/00500_insert_roles.sql b/packaging/dbscripts/data/00500_insert_roles.sql index ade8b7a..2af1b0b 100644 --- a/packaging/dbscripts/data/00500_insert_roles.sql +++ b/packaging/dbscripts/data/00500_insert_roles.sql @@ -2,32 +2,41 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('00000000-0000-0000-0000-000000000001', 'SuperUser', 'Roles management administrator', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('00000000-0000-0000-0001-000000000001', 'UserRole', 'Standard User Role', true, 2, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('00000000-0000-0000-0001-000000000002', 'PowerUserRole', 'User Role, allowed to create VMs, Templates and Disks', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00001-0000-0000-0000-def000000001', 'ClusterAdmin', 'Administrator Role, permission for all the objects underneath a specific Cluster', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00002-0000-0000-0000-def000000002', 'DataCenterAdmin', 'Administrator Role, permission for all the objects underneath a specific Data Center, except Storage', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00003-0000-0000-0000-def000000003', 'StorageAdmin', 'Administrator Role, permission for all operations on a specific Storage Domain', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00004-0000-0000-0000-def000000004', 'HostAdmin', 'Administrator Role, permission for all operations on a specific Host', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00005-0000-0000-0000-def000000005', 'NetworkAdmin', 'Administrator Role, permission for all operations on a specific Logical Network', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00006-0000-0000-0000-def000000006', 'UserVmManager', 'User Role, with permission for any operation on Vms', true, 2, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00007-0000-0000-0000-def000000007', 'VmPoolAdmin', 'Administrator Role, permission for all operations on a specific VM Pool', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00008-0000-0000-0000-def000000008', 'TemplateAdmin', 'Administrator Role, permission for all operations on a specific Template', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def00009-0000-0000-0000-def000000009', 'TemplateUser', 'Template User', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000a', 'QuotaConsumer', 'User Role, permissions to consume the Quota resources', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000b', 'DiskOperator', 'User Role, permissions for all operations on a specific disk', true, 2, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000c', 'DiskCreator', 'User Role, permission to create Disks', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000b-0000-0000-0000-def00000000b', 'GlusterAdmin', 'Administrator Role, permissions for operations on Gluster objects', true, 1, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000d', 'VmCreator', 'User Role, permission to create VMs', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000e', 'TemplateCreator', 'User Role, permission to create Templates', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def00000000f', 'TemplateOwner', 'User Role, permissions for all operations on Templates', true, 2, true); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000a-0000-0000-0000-def000000010', 'NetworkUser', 'Network User', true, 2, false); -INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children) VALUES ('def0000c-0000-0000-0000-def000000000', 'ExternalEventsCreator', 'External Events Creator', true, 2, false); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('00000000-0000-0000-0000-000000000001', 'SuperUser', 'Roles management administrator', true, 1, true, 255); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('00000000-0000-0000-0001-000000000001', 'UserRole', 'Standard User Role', true, 2, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('00000000-0000-0000-0001-000000000002', 'PowerUserRole', 'User Role, allowed to create VMs, Templates and Disks', true, 2, false, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00001-0000-0000-0000-def000000001', 'ClusterAdmin', 'Administrator Role, permission for all the objects underneath a specific Cluster', true, 1, true, 255); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00002-0000-0000-0000-def000000002', 'DataCenterAdmin', 'Administrator Role, permission for all the objects underneath a specific Data Center, except Storage', true, 1, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00003-0000-0000-0000-def000000003', 'StorageAdmin', 'Administrator Role, permission for all operations on a specific Storage Domain', true, 1, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00004-0000-0000-0000-def000000004', 'HostAdmin', 'Administrator Role, permission for all operations on a specific Host', true, 1, true, 255); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00005-0000-0000-0000-def000000005', 'NetworkAdmin', 'Administrator Role, permission for all operations on a specific Logical Network', true, 1, true, 255); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00006-0000-0000-0000-def000000006', 'UserVmManager', 'User Role, with permission for any operation on Vms', true, 2, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00007-0000-0000-0000-def000000007', 'VmPoolAdmin', 'Administrator Role, permission for all operations on a specific VM Pool', true, 1, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00008-0000-0000-0000-def000000008', 'TemplateAdmin', 'Administrator Role, permission for all operations on a specific Template', true, 1, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def00000000a', 'QuotaConsumer', 'User Role, permissions to consume the Quota resources', true, 2, false, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def00000000b', 'DiskOperator', 'User Role, permissions for all operations on a specific disk', true, 2, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def00000000c', 'DiskCreator', 'User Role, permission to create Disks', true, 2, false, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000b-0000-0000-0000-def00000000b', 'GlusterAdmin', 'Administrator Role, permissions for operations on Gluster objects', true, 1, true, 2); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def00000000d', 'VmCreator', 'User Role, permission to create VMs', true, 2, false, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def00000000e', 'TemplateCreator', 'User Role, permission to create Templates', true, 2, false, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def00000000f', 'TemplateOwner', 'User Role, permissions for all operations on Templates', true, 2, true, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000c-0000-0000-0000-def000000000', 'ExternalEventsCreator', 'External Events Creator', true, 2, false, 255); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000d-0000-0000-0000-def000000000', 'ExternalTasksCreator', 'External Tasks Creator', true, 2, false, 255); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def0000a-0000-0000-0000-def000000010', 'VnicProfileUser', 'VM Network Interface Profile User', true, 2, false, 1); +INSERT INTO roles (id, name, description, is_readonly, role_type, allows_viewing_children, app_mode) VALUES ('def00009-0000-0000-0000-def000000009', 'UserTemplateBasedVm', 'Template User', true, 2, false, 1); -- diff --git a/packaging/dbscripts/data/00600_insert_permissions.sql b/packaging/dbscripts/data/00600_insert_permissions.sql index 41ad147..b021c83 100644 --- a/packaging/dbscripts/data/00600_insert_permissions.sql +++ b/packaging/dbscripts/data/00600_insert_permissions.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: engine @@ -9,8 +17,8 @@ INSERT INTO permissions (id, role_id, ad_element_id, object_id, object_type_id) VALUES ('00000003-0003-0003-0003-000000000016', '00000000-0000-0000-0000-000000000001', 'fdfc627c-d875-11e0-90f0-83df133b58cc', 'aaa00000-0000-0000-0000-123456789aaa', 1); INSERT INTO permissions (id, role_id, ad_element_id, object_id, object_type_id) VALUES ('00000004-0004-0004-0004-000000000355', 'def00009-0000-0000-0000-def000000009', 'eee00000-0000-0000-0000-123456789eee', '00000000-0000-0000-0000-000000000000', 4); -INSERT INTO permissions (id, role_id, ad_element_id, object_id, object_type_id) VALUES ('00000005-0005-0005-0005-000000000090', 'def0000a-0000-0000-0000-def000000010', 'eee00000-0000-0000-0000-123456789eee', '00000000-0000-0000-0000-000000000009', 20); INSERT INTO permissions (id, role_id, ad_element_id, object_id, object_type_id) VALUES ('00000006-0006-0006-0006-00000000016d', '00000000-0000-0000-0001-000000000002', 'fdfc627c-d875-11e0-90f0-83df133b58cc', 'aaa00000-0000-0000-0000-123456789aaa', 1); +INSERT INTO permissions (id, role_id, ad_element_id, object_id, object_type_id) VALUES ('0000000b-000b-000b-000b-0000000001d5', 'def0000a-0000-0000-0000-def000000010', 'eee00000-0000-0000-0000-123456789eee', '0000000a-000a-000a-000a-000000000398', 27); -- diff --git a/packaging/dbscripts/data/00700_insert_roles_groups.sql b/packaging/dbscripts/data/00700_insert_roles_groups.sql index b8ae47c..1279a87 100644 --- a/packaging/dbscripts/data/00700_insert_roles_groups.sql +++ b/packaging/dbscripts/data/00700_insert_roles_groups.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: roles_groups; Type: TABLE DATA; Schema: public; Owner: engine @@ -195,8 +203,6 @@ INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000b-0000-0000-0000-def00000000b', 1002); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def00000000d', 1); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def00000000e', 200); -INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 1200); -INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1200); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def00000000f', 201); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def00000000f', 202); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def00000000f', 203); @@ -231,18 +237,44 @@ INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 404); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 404); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 404); -INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 1200); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 703); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 704); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 705); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 9); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 204); -INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def000000010', 9); -INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def000000010', 204); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1500); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000c-0000-0000-0000-def000000000', 1500); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def00000000a', 901); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1003); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000b-0000-0000-0000-def00000000b', 1003); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 15); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00001-0000-0000-0000-def000000001', 15); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 15); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 205); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 205); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00008-0000-0000-0000-def000000008', 205); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1004); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000b-0000-0000-0000-def00000000b', 1004); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 1105); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1105); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000d-0000-0000-0000-def000000000', 1500); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 1203); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1203); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 1203); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 1204); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 1204); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1204); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00005-0000-0000-0000-def000000005', 1205); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00002-0000-0000-0000-def000000002', 1205); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1205); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def000000010', 9); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def000000010', 204); INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def0000a-0000-0000-0000-def000000010', 1300); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0001-000000000001', 1106); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00008-0000-0000-0000-def000000008', 1106); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0000-000000000001', 1106); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('def00003-0000-0000-0000-def000000003', 1106); +INSERT INTO roles_groups (role_id, action_group_id) VALUES ('00000000-0000-0000-0001-000000000002', 1106); -- diff --git a/packaging/dbscripts/data/00800_insert_images.sql b/packaging/dbscripts/data/00800_insert_images.sql index aab0dcd..50d95c4 100644 --- a/packaging/dbscripts/data/00800_insert_images.sql +++ b/packaging/dbscripts/data/00800_insert_images.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: engine diff --git a/packaging/dbscripts/data/00900_insert_network.sql b/packaging/dbscripts/data/00900_insert_network.sql index 131bc42..2a1fbff 100644 --- a/packaging/dbscripts/data/00900_insert_network.sql +++ b/packaging/dbscripts/data/00900_insert_network.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: network; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO network (id, name, description, type, addr, subnet, gateway, vlan_id, stp, storage_pool_id, mtu, vm_network) VALUES ('00000000-0000-0000-0000-000000000009', 'ovirtmgmt', 'Management Network', NULL, NULL, NULL, NULL, NULL, false, '00000002-0002-0002-0002-00000000021c', NULL, true); +INSERT INTO network (id, name, description, type, addr, subnet, gateway, vlan_id, stp, storage_pool_id, mtu, vm_network, provider_network_provider_id, provider_network_external_id, free_text_comment) VALUES ('00000000-0000-0000-0000-000000000009', 'ovirtmgmt', 'Management Network', NULL, NULL, NULL, NULL, NULL, false, '00000002-0002-0002-0002-00000000021c', NULL, true, NULL, NULL, NULL); -- diff --git a/packaging/dbscripts/data/01000_insert_network_cluster.sql b/packaging/dbscripts/data/01000_insert_network_cluster.sql index 7e871d2..b01fa3d 100644 --- a/packaging/dbscripts/data/01000_insert_network_cluster.sql +++ b/packaging/dbscripts/data/01000_insert_network_cluster.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: network_cluster; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO network_cluster (network_id, cluster_id, status, is_display, required) VALUES ('00000000-0000-0000-0000-000000000009', '00000001-0001-0001-0001-0000000000d6', 1, false, true); +INSERT INTO network_cluster (network_id, cluster_id, status, is_display, required, migration) VALUES ('00000000-0000-0000-0000-000000000009', '00000001-0001-0001-0001-0000000000d6', 1, false, true, false); -- diff --git a/packaging/dbscripts/data/01100_insert_vm_static.sql b/packaging/dbscripts/data/01100_insert_vm_static.sql index 5bade17..4e7e1ab 100644 --- a/packaging/dbscripts/data/01100_insert_vm_static.sql +++ b/packaging/dbscripts/data/01100_insert_vm_static.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: vm_static; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO vm_static (vm_guid, vm_name, mem_size_mb, vmt_guid, os, description, vds_group_id, domain, creation_date, num_of_monitors, is_initialized, is_auto_suspend, num_of_sockets, cpu_per_socket, usb_policy, time_zone, is_stateless, fail_back, _create_date, _update_date, dedicated_vm_for_vds, auto_startup, vm_type, nice_level, default_boot_sequence, default_display_type, priority, iso_path, origin, initrd_url, kernel_url, kernel_params, migration_support, userdefined_properties, predefined_properties, min_allocated_mem, entity_type, child_count, template_status, quota_id, allow_console_reconnect, cpu_pinning, is_smartcard_enabled, host_cpu_flags, db_generation, is_delete_protected, is_disabled) VALUES ('00000000-0000-0000-0000-000000000000', 'Blank', 1024, '00000000-0000-0000-0000-000000000000', 0, 'Blank template', '00000001-0001-0001-0001-0000000000d6', '', '2008-04-01 00:00:00+03', 1, NULL, false, 1, 1, 1, NULL, NULL, false, '2013-12-25 15:31:54.367179+02', '2013-12-! 25 15:31:53.239308+02', NULL, NULL, 0, 0, 0, 0, 0, '', 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 'TEMPLATE', 0, 0, NULL, false, NULL, false, false, 1, false, false); +INSERT INTO vm_static (vm_guid, vm_name, mem_size_mb, vmt_guid, os, description, vds_group_id, domain, creation_date, num_of_monitors, is_initialized, is_auto_suspend, num_of_sockets, cpu_per_socket, usb_policy, time_zone, is_stateless, fail_back, _create_date, _update_date, dedicated_vm_for_vds, auto_startup, vm_type, nice_level, default_boot_sequence, default_display_type, priority, iso_path, origin, initrd_url, kernel_url, kernel_params, migration_support, userdefined_properties, predefined_properties, min_allocated_mem, entity_type, child_count, template_status, quota_id, allow_console_reconnect, cpu_pinning, is_smartcard_enabled, host_cpu_flags, db_generation, is_delete_protected, is_disabled, is_run_and_pause, created_by_user_id, tunnel_migration, free_text_comment, single_qxl_pci, cpu_shares, vnc_keyboard_layout) VALUES ('00000000-0000-0000-0000-000000000000', 'Blank', 1024, '00000000-0000-0000-0000-000000000000', 0, 'Blank template', '00000001-0001-0001-0001-0000000! 000d6', '', '2008-04-01 00:00:00+03', 1, NULL, false, 1, 1, 1, NULL, NULL, false, '2013-12-25 15:31:54.367179+02', '2013-12-25 15:31:53.239308+02', NULL, NULL, 0, 0, 0, 1, 0, '', 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 'TEMPLATE', 0, 0, NULL, false, NULL, false, false, 1, false, false, false, NULL, NULL, NULL, false, 0, NULL); -- diff --git a/packaging/dbscripts/data/01200_insert_vm_device.sql b/packaging/dbscripts/data/01200_insert_vm_device.sql index d9dc0d9..cb020d7 100644 --- a/packaging/dbscripts/data/01200_insert_vm_device.sql +++ b/packaging/dbscripts/data/01200_insert_vm_device.sql @@ -2,12 +2,20 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: vm_device; Type: TABLE DATA; Schema: public; Owner: engine -- -INSERT INTO vm_device (device_id, vm_id, type, device, address, boot_order, spec_params, is_managed, is_plugged, is_readonly, _create_date, _update_date, alias) VALUES ('00000006-0006-0006-0006-000000000006', '00000000-0000-0000-0000-000000000000', 'video', 'cirrus', '', NULL, '{ "vram" : "65536" }', true, NULL, false, '2013-12-25 22:54:23.416857+02', NULL, ''); +INSERT INTO vm_device (device_id, vm_id, type, device, address, boot_order, spec_params, is_managed, is_plugged, is_readonly, _create_date, _update_date, alias, custom_properties) VALUES ('00000006-0006-0006-0006-000000000006', '00000000-0000-0000-0000-000000000000', 'video', 'cirrus', '', NULL, '{ "vram" : "65536" }', true, NULL, false, '2013-12-25 22:54:23.416857+02', NULL, '', NULL); -- diff --git a/packaging/dbscripts/data/01300_insert_vm_ovf_generations.sql b/packaging/dbscripts/data/01300_insert_vm_ovf_generations.sql index e301f2b..fb52332 100644 --- a/packaging/dbscripts/data/01300_insert_vm_ovf_generations.sql +++ b/packaging/dbscripts/data/01300_insert_vm_ovf_generations.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: vm_ovf_generations; Type: TABLE DATA; Schema: public; Owner: engine diff --git a/packaging/dbscripts/data/01400_insert_action_version_map.sql b/packaging/dbscripts/data/01400_insert_action_version_map.sql index 45785f8..b24f160 100644 --- a/packaging/dbscripts/data/01400_insert_action_version_map.sql +++ b/packaging/dbscripts/data/01400_insert_action_version_map.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: action_version_map; Type: TABLE DATA; Schema: public; Owner: engine @@ -23,9 +31,14 @@ INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1409, '3.1', '*'); INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1410, '3.2', '*'); INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1411, '3.2', '*'); -INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1412, '3.2', '*'); INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1010, '3.2', '3.2'); INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1011, '3.2', '3.2'); +INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1001, '3.3', '3.3'); +INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1412, '3.1', '*'); +INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (232, '3.3', '*'); +INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1013, '3.3', '3.3'); +INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1014, '3.3', '*'); +INSERT INTO action_version_map (action_type, cluster_minimal_version, storage_pool_minimal_version) VALUES (1015, '3.3', '*'); -- diff --git a/packaging/dbscripts/data/01500_insert_event_map.sql b/packaging/dbscripts/data/01500_insert_event_map.sql index d0e505a..29b6537 100644 --- a/packaging/dbscripts/data/01500_insert_event_map.sql +++ b/packaging/dbscripts/data/01500_insert_event_map.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: event_map; Type: TABLE DATA; Schema: public; Owner: engine @@ -73,6 +81,49 @@ INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VDS_HIGH_SWAP_USE', ''); INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VDS_LOW_SWAP', ''); INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_OPTION_CHANGED_FROM_CLI', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_ENABLE', 'GLUSTER_HOOK_ENABLE_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_ENABLE_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_DISABLE', 'GLUSTER_HOOK_DISABLE_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_DISABLE_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_DETECTED_NEW', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_CONFLICT_DETECTED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_DETECTED_DELETE', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_ADDED', 'GLUSTER_HOOK_ADD_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_ADD_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_REMOVED', 'GLUSTER_HOOK_REMOVE_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_HOOK_REMOVE_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVICE_STARTED', 'GLUSTER_SERVICE_START_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVICE_START_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVICE_STOPPED', 'GLUSTER_SERVICE_STOP_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVICE_STOP_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVICE_RESTARTED', 'GLUSTER_SERVICE_RESTART_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVICE_RESTART_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VDS_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_UPDATE_VM_FROM_TRUSTED_TO_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_UPDATE_VM_FROM_UNTRUSTED_TO_TRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('IMPORTEXPORT_IMPORT_VM_FROM_TRUSTED_TO_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('IMPORTEXPORT_IMPORT_VM_FROM_UNTRUSTED_TO_TRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_ADD_VM_FROM_TRUSTED_TO_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_ADD_VM_FROM_UNTRUSTED_TO_TRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('IMPORTEXPORT_IMPORT_TEMPLATE_FROM_TRUSTED_TO_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('IMPORTEXPORT_IMPORT_TEMPLATE_FROM_UNTRUSTED_TO_TRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_ADD_VM_TEMPLATE_FROM_TRUSTED_TO_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_ADD_VM_TEMPLATE_FROM_UNTRUSTED_TO_TRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_UPDATE_VM_TEMPLATE_FROM_TRUSTED_TO_UNTRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('USER_UPDATE_VM_TEMPLATE_FROM_UNTRUSTED_TO_TRUSTED', ''); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('VM_STATUS_RESTORED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_SERVER_REMOVE', 'GLUSTER_SERVER_REMOVE_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_OPTION_ADDED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_OPTION_MODIFIED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_OPTIONS_RESET_ALL', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_PROFILE_START', 'GLUSTER_VOLUME_PROFILE_START_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_PROFILE_START_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_PROFILE_STOP', 'GLUSTER_VOLUME_PROFILE_STOP_FAILED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_PROFILE_STOP_FAILED', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_REBALANCE_STOP', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('GLUSTER_VOLUME_REBALANCE_STOP_FAILED', 'GLUSTER_VOLUME_REBALANCE_STOP'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('START_REMOVING_GLUSTER_VOLUME_BRICKS', 'UNASSIGNED'); +INSERT INTO event_map (event_up_name, event_down_name) VALUES ('START_REMOVING_GLUSTER_VOLUME_BRICKS_FAILED', 'START_REMOVING_GLUSTER_VOLUME_BRICKS'); -- diff --git a/packaging/dbscripts/data/01600_insert_dwh_history_timekeeping.sql b/packaging/dbscripts/data/01600_insert_dwh_history_timekeeping.sql index cbd1543..5d591b7 100644 --- a/packaging/dbscripts/data/01600_insert_dwh_history_timekeeping.sql +++ b/packaging/dbscripts/data/01600_insert_dwh_history_timekeeping.sql @@ -2,6 +2,14 @@ -- PostgreSQL database dump -- +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; -- -- Data for Name: dwh_history_timekeeping; Type: TABLE DATA; Schema: public; Owner: engine @@ -9,6 +17,8 @@ INSERT INTO dwh_history_timekeeping (var_name, var_value, var_datetime) VALUES ('lastSync', NULL, '2000-01-01 00:00:00+02'); INSERT INTO dwh_history_timekeeping (var_name, var_value, var_datetime) VALUES ('lastFullHostCheck', NULL, '2000-01-01 00:00:00+02'); +INSERT INTO dwh_history_timekeeping (var_name, var_value, var_datetime) VALUES ('lastOsinfoUpdate', NULL, '2000-01-01 00:00:00+02'); +INSERT INTO dwh_history_timekeeping (var_name, var_value, var_datetime) VALUES ('heartBeat', NULL, '2000-01-01 00:00:00+02'); -- diff --git a/packaging/dbscripts/data/01700_insert_gluster_service_types.sql b/packaging/dbscripts/data/01700_insert_gluster_service_types.sql new file mode 100644 index 0000000..b0e4f4f --- /dev/null +++ b/packaging/dbscripts/data/01700_insert_gluster_service_types.sql @@ -0,0 +1,26 @@ +-- +-- PostgreSQL database dump +-- + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; + +-- +-- Data for Name: gluster_service_types; Type: TABLE DATA; Schema: public; Owner: engine +-- + +INSERT INTO gluster_service_types (service_type) VALUES ('GLUSTER'); +INSERT INTO gluster_service_types (service_type) VALUES ('GLUSTER_SWIFT'); +INSERT INTO gluster_service_types (service_type) VALUES ('SMB'); + + +-- +-- PostgreSQL database dump complete +-- + diff --git a/packaging/dbscripts/data/01800_insert_gluster_services.sql b/packaging/dbscripts/data/01800_insert_gluster_services.sql new file mode 100644 index 0000000..33bc89d --- /dev/null +++ b/packaging/dbscripts/data/01800_insert_gluster_services.sql @@ -0,0 +1,30 @@ +-- +-- PostgreSQL database dump +-- + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; + +-- +-- Data for Name: gluster_services; Type: TABLE DATA; Schema: public; Owner: engine +-- + +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000003-0003-0003-0003-00000000004f', 'GLUSTER', 'glusterd'); +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000004-0004-0004-0004-00000000013e', 'GLUSTER_SWIFT', 'gluster-swift-proxy'); +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000005-0005-0005-0005-000000000180', 'GLUSTER_SWIFT', 'gluster-swift-container'); +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000006-0006-0006-0006-00000000017d', 'GLUSTER_SWIFT', 'gluster-swift-object'); +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000007-0007-0007-0007-000000000332', 'GLUSTER_SWIFT', 'gluster-swift-account'); +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000008-0008-0008-0008-0000000001b6', 'GLUSTER_SWIFT', 'memcached'); +INSERT INTO gluster_services (id, service_type, service_name) VALUES ('00000009-0009-0009-0009-0000000002a2', 'SMB', 'smb'); + + +-- +-- PostgreSQL database dump complete +-- + diff --git a/packaging/dbscripts/data/01900_insert_vnic_profiles.sql b/packaging/dbscripts/data/01900_insert_vnic_profiles.sql new file mode 100644 index 0000000..d11316d --- /dev/null +++ b/packaging/dbscripts/data/01900_insert_vnic_profiles.sql @@ -0,0 +1,24 @@ +-- +-- PostgreSQL database dump +-- + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SET check_function_bodies = false; +SET client_min_messages = warning; + +SET search_path = public, pg_catalog; + +-- +-- Data for Name: vnic_profiles; Type: TABLE DATA; Schema: public; Owner: engine +-- + +INSERT INTO vnic_profiles (id, name, network_id, port_mirroring, custom_properties, description, _create_date, _update_date, network_qos_id) VALUES ('0000000a-000a-000a-000a-000000000398', 'ovirtmgmt', '00000000-0000-0000-0000-000000000009', false, NULL, NULL, '2015-02-02 13:47:16.002849+02', NULL, NULL); + + +-- +-- PostgreSQL database dump complete +-- + -- To view, visit http://gerrit.ovirt.org/37462 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ib9d7bbcbc98c18e060a63f96fba89310ea069f7b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
