FM / migrations

/opt/imunify360/venv/versions/imunify-core-8.12.1-2/defence360agent/migrations/

/opt/imunify360/venv/versions/imunify-core-8.12.1-2/defence360agent/migrations

Name	Size	Mode	Actions
__pycache__/	-	0755	rm
001_initial.py	2296	0644	edit dl rm
002_infected_domain_list.py	1227	0644	edit dl rm
003_import_from_list.py	1319	0644	edit dl rm
004_add_username_to_infected_domain_list.py	1147	0644	edit dl rm
005_timeout_in_iplist.py	1151	0644	edit dl rm
006_comment_in_plist.py	1154	0644	edit dl rm
007_add_country_code_fields.py	1642	0644	edit dl rm
008_fill_countries.py	414	0644	edit dl rm
009_drop_blocklist_history.py	1405	0644	edit dl rm
010_drop_country_entities.py	1291	0644	edit dl rm
011_create_new_country_entities.py	2735	0644	edit dl rm
012_fill_countries_and_subnets.py	252	0644	edit dl rm
013_add_indexes_to_iplist.py	1107	0644	edit dl rm
014_add_malware_hits.py	2375	0644	edit dl rm
015_add_iplist_expiration_index.py	361	0644	edit dl rm
016_fix_autowhitelist_expiration.py	459	0644	edit dl rm
017_remove_sensor_prefix.py	357	0644	edit dl rm
018_license_info.py	584	0644	edit dl rm
019_purge_old_configs.py	301	0644	edit dl rm
020_malware_scan_types.py	1288	0644	edit dl rm
021_add_testing_repo.py	1636	0644	edit dl rm
022_mod_security_vendors_migrations.py	161	0644	edit dl rm
023_add_default_rule_in_modsec_custom_conf.py	1161	0644	edit dl rm
024_ignore_from_graylist.py	471	0644	edit dl rm
025_malware_config_realtime.py	695	0644	edit dl rm
026_remove_old_temporary_file.py	569	0644	edit dl rm
027_disable_comdo_fp_rules.py	232	0644	edit dl rm
028_set_permanent_ttl_for_blacklist.py	350	0644	edit dl rm
029_custom_quarantine.py	111	0644	edit dl rm
030_rename_max_incident_repetition.py	1395	0644	edit dl rm
031_add_mode_field.py	488	0644	edit dl rm
031_modsec_config_for_plesk_include.py	1488	0644	edit dl rm
032_chmod_quarantine.py	111	0644	edit dl rm
033_disable_cphulk.py	637	0644	edit dl rm
034_hits_extras.py	777	0644	edit dl rm
035_add_dos_expiration_field.py	360	0644	edit dl rm
036_add_block_port.py	1478	0644	edit dl rm
037_disabled_rules.py	1148	0644	edit dl rm
038_disabled_rules_import.py	749	0644	edit dl rm
039_fix_malware_hits.py	913	0644	edit dl rm
040_ignore_mod_sec_rule_214920.py	175	0644	edit dl rm
041_fix_invalid_ignore_filed.py	210	0644	edit dl rm
042_rebuildinstalledssldb.py	629	0644	edit dl rm
043_disable_dos_scan_by_default.py	455	0644	edit dl rm
044_ignore_virtfs_on_cpanel.py	448	0644	edit dl rm
045_ignore_vdserver_dir_in_csf.py	339	0644	edit dl rm
046_foreign_key_fix.py	875	0644	edit dl rm
047_license_in_file.py	576	0644	edit dl rm
048_malware_hits_vendor_field.py	436	0644	edit dl rm
049_add_auto_added_field_to_iplist.py	539	0644	edit dl rm
050_fill_auto_whitelisted.py	450	0644	edit dl rm
051_cleanup_vd_license.py	922	0644	edit dl rm
052_whitelisted_crawlers.py	1068	0644	edit dl rm
053_populate_whitelisted_crawlers.py	1355	0644	edit dl rm
054_add_malicious_and_added_date_fileds.py	746	0644	edit dl rm
055_migrate_move_to_quar_option.py	562	0644	edit dl rm
056_populate_malicious_with_quarantined.py	111	0644	edit dl rm
057_filename_is_blob.py	1059	0644	edit dl rm
058_convert_license_last_attempt.py	133	0644	edit dl rm
059_scans_error_field.py	380	0644	edit dl rm
061_migrate_backup_system_conf.py	1349	0644	edit dl rm
062_drop_malware_extra_data.py	309	0644	edit dl rm
062_fix_null_expiration.py	394	0644	edit dl rm
063_fix_graylist_doslist_expiration_discrepancy.py	353	0644	edit dl rm
064_chmod_i360deploy_log.py	288	0644	edit dl rm
065_remove_capture_csf_lock_from_config.py	609	0644	edit dl rm
066_eula_table.py	399	0644	edit dl rm
067_drop_fields_from_modsec_conf.py	572	0644	edit dl rm
068_remove_rules_check_interval_from_config.py	575	0644	edit dl rm
069_incidents_domain_field.py	342	0644	edit dl rm
070_modsec_incident_names.py	1348	0644	edit dl rm
071_malware_hits_hash_size_fields.py	535	0644	edit dl rm
072_add_malware_history_table.py	708	0644	edit dl rm
072_captcha_stat.py	955	0644	edit dl rm
072_extend_last_synclist.py	640	0644	edit dl rm
073_drop_dos_expiration.py	599	0644	edit dl rm
074_ip_as_int.py	1545	0644	edit dl rm
075_ips_as_int.py	1752	0644	edit dl rm
076_hash_model.py	131	0644	edit dl rm
077_alter_malware_scan.py	814	0644	edit dl rm
078_fix_signatures_permissions.py	269	0644	edit dl rm
079_add_uid_gid_fields.py	466	0644	edit dl rm
080_populate_uid_gid_size_hash_fields.py	2315	0644	edit dl rm
081_fix_clamscan_broken_symlink.py	131	0644	edit dl rm
082_add_cl_on_premise_backup_option.py	532	0644	edit dl rm
082_add_manual_flag.py	348	0644	edit dl rm
083_drop_no_captcha_field.py	865	0644	edit dl rm
084_country_subnets_fields.py	650	0644	edit dl rm
085_country_subnets_fields.py	639	0644	edit dl rm
086_ignored_by_port_fields.py	647	0644	edit dl rm
087_ignored_by_port_fields.py	1764	0644	edit dl rm
088_add_malware_i360_clamd_scan_option.py	131	0644	edit dl rm
089_proactive_tables.py	1517	0644	edit dl rm
090_safe_user_config.py	1145	0644	edit dl rm
091_compress_old_logs.py	984	0644	edit dl rm
092_ignore_proc_sys_dirs.py	391	0644	edit dl rm
092_remove_old_disabled_rules.py	335	0644	edit dl rm
093_make_quarantined_files_immutable.py	131	0644	edit dl rm
094_ignore_cagefs_proc.py	377	0644	edit dl rm
095_add_total_malicious_field.py	406	0644	edit dl rm
096_populate_total_malicious_field.py	457	0644	edit dl rm
097_remove_uid_and_gid.py	344	0644	edit dl rm
098_remote_proxy_tables.py	1180	0644	edit dl rm
099_remove_old_disabled_rules.py	1120	0644	edit dl rm
100_remove_captcha_ports_from_csf.py	571	0644	edit dl rm
101_remove_unneeded_acronis_ports_from_csf.py	817	0644	edit dl rm
102_proactive_ignore_list.py	1612	0644	edit dl rm
102_replace_comodo.py	422	0644	edit dl rm
103_remove_vd_license.py	240	0644	edit dl rm
104_add_feature_management_permissions.py	526	0644	edit dl rm
105_populate_default_feature_management_permissions.py	298	0644	edit dl rm
106_add_malware_cleanup_in_config.py	559	0644	edit dl rm
106_malware_hit_status_field_add.py	673	0644	edit dl rm
107_add_bruteforce_rule_33339.py	820	0644	edit dl rm
107_malware_hit_status_field_populate.py	443	0644	edit dl rm
108_feature_management_cleanup_add.py	514	0644	edit dl rm
108_validate_config.py	1229	0644	edit dl rm
109_dos_detector.py	1046	0644	edit dl rm
110_ignore_list_ip_as_int.py	609	0644	edit dl rm
111_ignore_list_ip_as_int.py	1325	0644	edit dl rm
112_hardened_php.py	1884	0644	edit dl rm
113_move_quarantined_files.py	111	0644	edit dl rm
114_disable_auto-quarantine.py	1021	0644	edit dl rm
115_feature_management_fields.py	1358	0644	edit dl rm
116_feature_management_fields.py	402	0644	edit dl rm
117_remove_incorrect_fields.py	761	0644	edit dl rm
118_add_malware_user_infected.py	131	0644	edit dl rm
118_remove_country_subnets.py	272	0644	edit dl rm
119_populate_malware_user_infected.py	131	0644	edit dl rm
120_scheduled_scan.py	1236	0644	edit dl rm
121_drop_captcha_stat.py	178	0644	edit dl rm
122_cagefs_unmount.py	276	0644	edit dl rm
123_add_last_user_scan.py	416	0644	edit dl rm
123_disable_scheduled_scan.py	962	0644	edit dl rm
123_rename_plesk_vendor.py	903	0644	edit dl rm
124_add_hook_management_functionality.py	638	0644	edit dl rm
124_add_infected_domains_vendor.py	425	0644	edit dl rm
125_rescan_scan_type.py	1359	0644	edit dl rm
126_add_malware_scan_modified_files_option.py	754	0644	edit dl rm
126_move_malware_hits_list.py	1082	0644	edit dl rm
127_remove_malware_hit_mode.py	215	0644	edit dl rm
128_move_cleanup_storage_files.py	1786	0644	edit dl rm
129_fixed_cagefs_unmount.py	1388	0644	edit dl rm
130_add_messages_to_send.py	456	0644	edit dl rm
131_incident_timestamp_index.py	305	0644	edit dl rm
132_add_timestamp_field.py	410	0644	edit dl rm
133_add_scope_field_to_iplist.py	583	0644	edit dl rm
134_change_default_of_intensity_ram.py	599	0644	edit dl rm
135_export_proactive.py	1441	0644	edit dl rm
135_make_completed_nullable.py	314	0644	edit dl rm
136_drop_proactive.py	232	0644	edit dl rm
137_swap_initiator_and_cause.py	512	0644	edit dl rm
138_move_rapid_scan_dir.py	1622	0644	edit dl rm
139_generic_modsec_config.py	285	0644	edit dl rm
140_cast_malware_hit_orig_file_as_blob.py	291	0644	edit dl rm
141_drop_last_user_scans.py	227	0644	edit dl rm
143_malware_hit_cascade_delete.py	1531	0644	edit dl rm
144_remove_clamav_config_options.py	821	0644	edit dl rm
144_remove_hash_table.py	177	0644	edit dl rm
145_move_quarantine.py	111	0644	edit dl rm
146_malware_user_infected_cascade_delete.py	131	0644	edit dl rm
147_remove_vendor_field.py	385	0644	edit dl rm
147_user_scan_type.py	711	0644	edit dl rm
148_reconstruct_pickled_scan_queue.py	262	0644	edit dl rm
148_remove_malware_user_infected.py	185	0644	edit dl rm
149_add_captcha_passed_field_to_iplist.py	365	0644	edit dl rm
149_make_config_inactive.py	907	0644	edit dl rm
150_update_captcha_passed_field_for_iplist_entries.py	642	0644	edit dl rm
151_change_constraint_for_iplist.py	484	0644	edit dl rm
152_add_listname_to_primary_key.py	3279	0644	edit dl rm
153_migrate_config_default_action.py	1606	0644	edit dl rm
153_update_incident_name.py	252	0644	edit dl rm
154_migrate_config_user_override_malware_actions.py	797	0644	edit dl rm
155_migrate_config_user_override_proactive_defense.py	801	0644	edit dl rm
156_remove_default_values_from_config.py	601	0644	edit dl rm
157_move_i360_modsec_disable_conf.py	1177	0644	edit dl rm
158_move_i360_modsec_disable_conf_symlink.py	1734	0644	edit dl rm
159_remove_defaults_from_local_config.py	917	0644	edit dl rm
160_remove_quarantine.py	3048	0644	edit dl rm
160_unmount_sigs_v1.py	1502	0644	edit dl rm
161_remove_ea4_main_local_conf.py	1667	0644	edit dl rm
162_add_resource_type.py	1832	0644	edit dl rm
163_drop_malware_scanned_stat.py	255	0644	edit dl rm
164_add_resource_type_to_ignore.py	1147	0644	edit dl rm
165_add_db_fields_to_malware_history.py	1041	0644	edit dl rm
166_add_id_field_to_malware_ignore_path.py	977	0644	edit dl rm
167_remote_iplist.py	1014	0644	edit dl rm
168_add_icontact_throttle.py	880	0644	edit dl rm
169_add_record_to_throttle_scan_not_schedule_events.py	635	0644	edit dl rm
170_add_db_fields_to_malware_history.py	479	0644	edit dl rm
180_move_captcha_configs.py	280	0644	edit dl rm
182_remove_constraints_from_icontact_throttle.py	913	0644	edit dl rm
183_add_user_field_to_malware_scans.py	431	0644	edit dl rm
184_create_a_table_for_secure_site_permissions.py	463	0644	edit dl rm
185_delete_all_secure_site_id.py	527	0644	edit dl rm
186_add_user_field_to_icontact_throttle.py	1598	0644	edit dl rm
187_fix_scan_unserialization.py	1551	0644	edit dl rm
188_add_protection_status_field_myimunify.py	442	0644	edit dl rm
189_add_messages_to_send_nr.py	459	0644	edit dl rm
190_add_analyst_cleanup_request_table.py	1144	0644	edit dl rm
191_create_wordpress_incident_table.py	1334	0644	edit dl rm
192_add_wordpress_incident_unique_index.py	1107	0644	edit dl rm
193_remove_sent_to_server_from_wordpress_incident.py	589	0644	edit dl rm
194_add_wp_disabled_rules.py	956	0644	edit dl rm
194_create_nonprivileged_config.py	796	0644	edit dl rm
195_create_wordpress_site.py	621	0644	edit dl rm
196_add_disabled_rules_sync_ts.py	567	0644	edit dl rm
197_add_wordpress_site_manually_deleted_at.py	677	0644	edit dl rm
198_add_wordpress_site_version.py	649	0644	edit dl rm
199_proactive_log_permission.py	1516	0644	edit dl rm
200_seed_per_user_waf_enabled.py	2151	0644	edit dl rm
201_rerender_nonprivileged_config.py	578	0644	edit dl rm
202_add_wordpress_incident_bucket.py	2138	0644	edit dl rm
203_add_wordpress_incident_unsent_retries.py	1356	0644	edit dl rm
conf.py	116	0644	edit dl rm
__init__.py	0	0644	edit dl rm

Edit: /opt/imunify360/venv/versions/imunify-core-8.12.1-2/defence360agent/migrations/001_initial.py (2296B)

"""Peewee migrations: ::

> Model = migrator.orm['name']

> migrator.sql(sql)
    > migrator.python(func, *args, **kwargs)
    > migrator.create_model(Model)
    > migrator.remove_model(Model, cascade=True)
    > migrator.add_fields(Model, **fields)
    > migrator.change_fields(Model, **fields)
    > migrator.remove_fields(Model, *field_names, cascade=True)
    > migrator.rename_field(Model, old_field_name, new_field_name)
    > migrator.rename_table(Model, new_table_name)
    > migrator.add_index(Model, *col_names, unique=False)
    > migrator.drop_index(Model, *col_names)
    > migrator.add_not_null(Model, *field_names)
    > migrator.drop_not_null(Model, *field_names)
    > migrator.add_default(Model, field_name, default)

"""
import peewee as pw

class Incident(pw.Model):
    id = pw.IntegerField(primary_key=True, null=True)
    plugin = pw.CharField(null=True)
    rule = pw.CharField(null=True)
    timestamp = pw.FloatField(null=True)
    retries = pw.IntegerField(null=True)
    severity = pw.IntegerField(null=True)
    name = pw.CharField(null=True)
    description = pw.CharField(null=True)
    abuser = pw.CharField(null=True)

class Meta:
        db_table = "incident"

class IPList(pw.Model):
    ip = pw.CharField(primary_key=True, null=False)
    listname = pw.CharField(
        null=False,
        constraints=[pw.Check("listname in ('WHITE','BLACK','GRAY')")],
    )
    expiration = pw.IntegerField(default=0, null=True)

class Meta:
        db_table = "iplist"

class BlocklistHistory(pw.Model):
    id = pw.IntegerField(primary_key=True, null=True)
    plugin = pw.CharField(null=True)
    rule = pw.CharField(null=True)
    timestamp = pw.FloatField(null=True)
    ip = pw.CharField(null=True)

class Meta:
        db_table = "blocklist_history"

class LastSynclist(pw.Model):
    timestamp = pw.FloatField(primary_key=True, null=True)

class Meta:
        db_table = "last_synclist"

def migrate(migrator, database, fake=False, **kwargs):
    """In memory of former create_db() (RIP)"""

migrator.create_model(Incident)
    migrator.create_model(IPList)
    migrator.create_model(BlocklistHistory)
    migrator.create_model(LastSynclist)

def rollback(migrator, database, fake=False, **kwargs):
    """Nothing to rollback."""

cmd: