CHANGELOG
=========

2.59.1 (2024-10-01)
-------------------

* Add ``domain_keyset_idx`` index on ``domain`` table
* Add ``domain_history_keyset_idx`` index on ``domain_history`` table

2.59.0 (2024-08-19)
-------------------

* Add ``uuid`` attribute into ``domain_auction`` table

2.58.0 (2024-03-12)
-------------------

* Enhance ``domain_blacklist`` to support BSA blocks

2.57.0 (2023-12-20)
-------------------

* Messenger migration
* Upgrade and base schema scripts fixes

2.56.0 (2023-10-13)
-------------------

* Add domain name auctions models and settings

2.55.1 (2023-10-24)
-------------------

* Change `premiumDomain` state flag description

2.55.0 (2023-07-13)
-------------------

* Add schema for *contact representatives*

2.54.0 (2023-04-13)
-------------------

* Add `serverLinkProhibited` object state flag

2.53.0 (2023-01-31)
-------------------

* Add constraints to mandatory attributes of the registrar table
* Add `premiumDomain` object state flag
* Extend `registrar_certification.classification` range from 0-5 to 0-100
  * stars to percentage

2.52.0 (2022-09-20)
-------------------

* Registry objects authinfo password is now stored hashed and has ttl (expiration timestamp)

* Add UUID identifier to registrar certification for external reference and
  file link (keep backward compability with trigger)

* Update registrar acl table

  - Add UUID identifier for external reference
  - Add create time
  - Add certificate data

2.51.1 (2022-08-17)
-------------------

* Fix - Add UUID identifier to files (referenced from trigger on invoice table)

* Fix - Script file name (scripts for creating new empty db)

2.51.0 (2022-07-21)
-------------------

* Add UUID identifier to invoice file links (keep backward compability with
  trigger to fill file and filexml appropriate foreign key ids)

* Add UUID identifier to registrar

2.50.0 (2022-06-08)
-------------------

* Add UUID identifier for public requests

2.49.0 (2022-06-06)
-------------------

* Add table for additional notifications of object state changes

2.48.0 (2022-04-08)
-------------------

* Add object state requests reason enums for external purposes

2.47.1 (2022-04-07)
-------------------

* Add constraint for allowed characters on ``service.name``

  * rename necessary services

2.47.0 (2022-01-31)
-------------------

* Add possibility to mark registrar as internal

  * not in registrar list in public interfaces but still traceable when linked to another object
  * not charged

2.46.0 (2021-11-08)
-------------------

* Add ``contact_identity`` table (to manage history of linkage between registry
  contact and external identity service)

* Add new contact states to inform that some of the contact attributes are locked and cannot be changed

2.45.5 (2021-09-09)
-------------------

* Fix rpm build

2.45.4 (2021-08-24)
-------------------

* Do not require createlang utility

2.45.3 (2021-07-02)
-------------------

* Update template of mojeid PIN1 e-mail

2.45.2 (2021-06-14)
-------------------

* Update template for epp send authinfo e-mail template (new ``registrar_url`` parameter)

2.45.1 (2021-03-16)
-------------------

* Fix partition naming (quoting)

2.45.0 (2021-02-10)
-------------------

* Rework unique constraints on service, request types, result codes and object types

  * Fix case sensitivity

* Change datatype of ``request_object_ref.object_id`` to bigint

2.44.0 (2020-07-02)
-------------------

* Add possibility to change domain lifecycle parameters over time

  * Move from enum_parameters to dedicated table domain_lifecycle_parameters
  * Adjust corresponding procedures and triggers

2.43.0 (2020-06-03)
-------------------

* Add new request type for MojeID (MojeidNiaUpdateAccount)

2.42.0 (2020-06-01)
-------------------

* Add new request types for Ferda service (contact representatives)

2.41.0 (2020-04-30)
-------------------

* Add textual object identifier request_object_ref.object_ident to logger

* Add Ferda service, request types and result codes to logger

2.40.1 (2020-03-17)
-------------------

* Remove unused GiST indexes

2.40.0 (2020-02-19)
-------------------

* Add GIN trigram indexes for similar string search in domain, nsset and keyset history

2.39.0 (2020-01-09)
-------------------

* Add GIN trigram indexes for similar string search in contact history

2.38.2 (2019-11-20)
-------------------

* Add new message type (mojeid_sms_two_factor_reset)

  * Fix changes in older upgrade script after tagging

2.38.1 (2019-11-12)
-------------------

* new logger request type (BulkTransfer)

2.38.0 (2019-09-11)
-------------------

* New charged operation type (MonthlyFee)

* New logger request types (MojeidDeactivateNiaAuthenticators, NiaPairingRequest)

2.37.2 (2019-07-26)
-------------------

* Add new message type (mojeid_sms_password_reset)

2.37.1 (2019-06-10)
-------------------

* Set search_path for unaccent_streets function (fix autoanalyze run for tables with new function indexes)

* New logger request type (MojeidDeactivateFido2)

2.37.0 (2019-04-01)
-------------------

* Add unique constraint for registrar var. symbol

* Fix spec file

2.36.0 (2019-03-08)
-------------------

* Add UUID identifier for every basic registry object (domain, contact, nsset, keyset)
  and every history record

* Add indexes for similar string search (trigrams)

2.35.1 (2019-01-17)
-------------------

* Fix for clean db setup (removed unique constraint)

* Fix e-mail archive migration (2.33.0) and remove cz.nic specific
  templates migration

2.35.0 (2018-08-16)
-------------------

* Bank payments moved to separate project (django-pain, fred-pain)

  * preparations for moving invoices as well

  * FRED will manage only registrar credit transactions through accouting interface (fred-accifd)

* Public request

  * status enum renaming

  * fix personal info template

  * new verification type for requests (government)

2.34.1 (2018-08-08)
-------------------

* Set schema_path for check constraint function (fixing backup restore)

2.34.0 (2018-04-20)
-------------------

* Little rework of mail template version trigger (just check expected version)

* New type of public request (personal info)

* New version of conditional_contact_identification mail template

* New type of poll message (update contact)

2.33.1 (2018-03-27)
-------------------

* Remove no longer needed (not used) indexes

2.33.0 (2018-03-08)
-------------------

* reworked e-mail archive tables

  * drop support for multiple templates (parts) for one e-mail type

  * support template versioning

  * save only template parameters and generate e-mail when sending or rendering

2.32.0 (2017-12-19)
-------------------

* registrar passwords in registraracl table can be in hashed form

2.31.1 (2017-12-11)
-------------------

* fix ``serverBlocked`` status description

* fix 2.21.5-2.21.6.sql upgrade script (remove .cz zone dependency)

2.31.0 (2017-11-15)
-------------------

* add functions to automate logger partitioning dropping

* new logger request types

2.30.0 (2017-09-11)
-------------------

* fix epp poll message table indexes

* fix epp reason messages

2.29.0 (2017-09-11)
-------------------

* contact, nsset, keyset handle format rules (regex) moved to database

2.28.0 (2017-06-21)
-------------------

* automatic keyset management (e-mail templates)

2.27.0 (2017-03-13)
-------------------

* fix domain outzone warning e-mail template

* db constraint for ldh domain name (domains, nameservers)

2.26.2 (2016-03-30)
-------------------

* replace usage of user-defined aggregate function array_accum with built-in array_agg

2.26.1 (2016-03-09)
-------------------

* fix invoice domain renew operation bill item date_from values

2.26.0 (2016-12-19)
-------------------

* configuration for keyset dnskeys algorithm blacklist

* enum domain validation continuation window configuration

* add price list constraints

* add new epp error reasons

2.25.1 (2016-12-19)
-------------------

* new style whois links in e-mail templates

* add MojeidResetPassword request type

2.25.0 (2016-10-09)
-------------------

* configuration for prohibited nsset ip networks

* add ImportOutzoneWarningNotificationEmails request type

2.24.1 (2016-10-14)
-------------------

* mail templates fixes

  * configurable whois registrar list page link

  * fax removed

2.24.0 (2016-09-13)
-------------------

* new status outzoneUnguardedWarning - custom e-mail notification

2.23.0 (2016-06-13)
-------------------

* fix - remove defaults from history tables

* fix - correct defaults for contact disclose[name|organization|address]

* contact create notification e-mail template (with full contact data)

2.22.1 (2016-05-30)
-------------------

* fix length of bank_payment.bank_code column

2.22.0 (2016-04-10)
-------------------

* object event notification made async (notification queue table)

* add additional contact addresses to contact update notification e-mail

* public requests for mojeid transfer with data change

2.21.6 (2016-02-08)
-------------------

* add RDAP service 400 (BadRequest) result code

* registry e-mail templates content fixes

2.21.5 (2015-02-08)
-------------------

* add MojeidDeactivateAutor request type

2.21.4 (2015-11-02)
-------------------

* add OpenIDConnectRefreshRequest request type

2.21.3 (2015-10-13)
-------------------

* add MojeidValidateISIC request type

2.21.2 (2015-08-26)
-------------------

* fix technical test e-mail template

2.21.1 (2015-07-23)
-------------------

* add OpenID Connect request type

2.21.0 (2015-05-19)
-------------------

* add warning letter flag to contact (and contact_history) tables

* add next portion of missing constraints and indexes

* mail template fixes

* new logger request types

* new file types

2.20.0 (2015-01-27)
-------------------

* public request and object state request locking simplified

* logging constraint for discloseaddress flag rules

* contact address type extended with additional 2 shipping addresses

2.19.1 (2014-12-31)
-------------------

* company address change

2.19.0 (2014-10-17)
-------------------

* add table to store additional addreses for contact (with history)

* add public request type for mojeid re-identification

* fix - add index public_request_objects_map.object_id

  * add index object_state.valid_to

  * fix domain.zone constraint

  * add index object_state_request.object_id

2.18.1 (2014-10-24)
------------------------------

* admin. contact verification - new automatic test

2.18.0 (2014-08-01)
-------------------

* mapping table between message type and forwarding service which should be used

* add index contact.name to speed-up contact duplicates search

* logger

  * add domain browser merge contacts request type

  * rdap service, request types and result codes

* public_request_state_request_map removed

2.17.0 (2014-06-13)
-------------------

* data model for admin. contact verification

* e-mail templates minor fixes

2.16.0 (2014-02-13)
-------------------

* add mail default headers by mail type mapping table

* logger - new request type

2.15.0 (2013-11-06)
-------------------

* add table for attach reason for object state request (object_state_request_reason)

* add tables to specify domain name checkers for given zone

* new logger request types for administrative blocking/unblocking of domains

* explicit constraints names (not generated by postgres because it can change between versions)

* removed obsolete functions

2.14.4 (2013-12-20)
-------------------

* add new status for contact manual verification

2.14.3 (2013-10-07)
-------------------

* unused tables removed

2.14.2 (2013-08-15)
-------------------

* object states descriptions - translations changes

2.14.1 (2013-07-30)
-------------------

* new request types for mojeid user management

2.14.0 (2013-06-27)
-------------------

* mail type priority table

* domain browser schema changes

  * new column to enum_object_states table

  * new views for number of domains for keyset/nsset

  * function to get list of object states as parsable string

2.13.0 (2013-04-02)
-------------------

* contact merge auto procedure

  * email templates

  * logger request types

* object update poll messages types

* schema fixes

  * add enumval constraint

    * add enum_object_type table

2.12.2 (2012-11-23)
-------------------

* add new letter type (mojeid_pin3_reminder)

2.12.1 (2012-11-15)
-------------------

* fix setting of mojeidContact in upgrade script

* mojeid pin1 email template changes

2.12.0 (2012-09-06)
-------------------

* mojeid mail templates update (removed demo mode)

* contact verification

  * mail templates

  * sms, letter types

  * public request types

* epp mail notifications - direct whois link added

* public request - enum tables for type and status

* contact identification and validation states are now external

* fix low credit poll message table - credit and creditlimit are now numeric types

* fix differences between new schema and consecutive upgrades

* added object_state.valid_from index for mojeid/cv contact checks speedup

2.11.3 (2012-07-23)
-------------------

* update country codes enumeration

2.11.2 (2012-06-18)
-------------------

* fix update notification mail template (disclose address changes)

2.11.1 (2012-06-11)
-------------------

* fix whois reminder template (removed temporary contact)

2.11.0 (2012-05-11)
-------------------

* bank_payment account.number type to text - was too short for IBAN format

* refactoring of invoice type and invoice prefix tables

* drop epp_info_buffer_content foreign key to object_registry for better performance of epp list commands

2.10.0 (2012-04-27)
-------------------

* epp action removed from fred

2.9.2 (2011-10-26)
------------------

* fix upgrade script

  * price_list.enable_postpaid_operation init

  * unique constraint for (registrar_id, zone_id) in registrar_credit table

* better support for creating logger partitions

2.9.1 (2011-10-24)
------------------

* fix migration of invoice_operation.date_from

* transactions added to upgrade scripts

2.9.0 (2011-10-11)
------------------

* invoicing module rework

* added credit related tables - separation from invoicing

2.8.5 (2011-10-17)
------------------

* whois reminder template fixes

* deleteCandidate status changed to external, description update

* object regular procedure enum_parameters update

  * regular_day_outzone_procedure_period (14)

  * regular_day_procedure_period (0)

  * domain_states view

  * status_update_domain

2.8.4 (2011-08-11)
------------------

* whois reminder template fixes

2.8.3 (2011-07-12)
------------------

* request_fee_parameter table initialization date conv. fix

2.8.2 (2011-07-04)
------------------

* poll_request_fee primary key

2.8.1 (2011-07-04)
------------------

* poll request fee - parameters adjusted

2.8.0 (2011-07-04)
------------------

* poll request fee tables

* enum object states typo fix

2.7.2 (2011-06-14)
------------------

* notify_request primary key fixed

* mail templates format fixes

2.7.1 (2011-05-25)
------------------

* price_vat.koef column type changed to numeric

2.7.0 (2011-05-13)
------------------

* whois contact reminder tables

* public request types added to logger

2.6.3 (2011-03-17)
------------------

* history.request_id index cond. on not null values

2.6.2 (2011-03-16)
------------------

* primary key, unique message_id on notify_request table

* template typo fix

* create_tmp_table with bigint id columnt added to upgrade scripts

2.6.1 (2011-03-02)
------------------

* index for history.request_id

2.6.0 (2011-02-28)
------------------

* Logger reference ids changed in public_request (added resolve_request_id column,
  renamed logd_request_id to create_request_id)

* Datatype of logger id-sequence changed to bigint

* notify_request table

* message_status table dropped, all moved to enum_send_status

* Logger partition indexes

* Logger request_property_name.name attribute expanded to varchar(256) and fixed bad values

2.4.1 (2010-08-10)
------------------

* Logger property renaming - upgrade script

2.4.0 (2010-07-22)
------------------

* New tables for registrar group and certification management

* Notification of expiration letters refactoring

* New enumeration tables for message send status

* Logger procedures fixes

* Schema cleaning (unused tables deleted)

2.3.2 (2010-03-29)
------------------

* banking data migration fixes

2.3.1 (2010-03-22)
------------------

* Banking changes:

  * payment type default value

  * migration fixes

2.3.0 (2010-02-16)
------------------

* Audit (Logger) tables added

* New tables for banking refactoring (constraint changes)

* Registrars

  * 'regex' column added for payment pairing by memo message

    * access to zone limited by 'todate' column in registrarinvoice

* Typo in messages and mail templates fixes

* Separation of upgrade script (schema modification, data modification)

* Dropped constrains to action table (except action_xml table)

2.2.0 (2010-01-08)
------------------

* public request <-> action tables dependency refactoring started

* Enum directory implementation - publish flag

2.1.4 (2009-06-30)
------------------

* fixing minor manager, configure scripts issues

* fixing tables initialization (bank_account, price_list)

* fixing authinfo mail template

* technical test mail template update due to dnssec test

* added new enum parameters:

  * handle_registration_protection_period

  * roid_suffix

2.1.3 (2009-05-05)
------------------

* mail templates update

  * added zone paramater to invoice emails

  * added object handle to subject of notification and expiratjon emails

  * added object changes to notifiaction about epp update command

  * line wrap fixes

* all initial values (except constants) removed

2.1.2 (2009-03-26)
------------------

* Added columns into table history (valid_from, valid_to and next) and corrseponding triggers and update scripts.

2.0.0 (2008-08-14)
------------------

* DNSSEC implementation, new keyset object attached to domain

1.9.0 (2008-05-30)
------------------

* new tables for public request

  * public_request

  * public_request_objects_map

  * public_request_state_request_map

* update default values in object_state_request table

* exdate changed to date from datetime

* new mail template for blocking request

1.8.2 (2008-04-30)
------------------

* fixing fred-dbmanager uninstallation process

* fixing mail_template with notification about delete of contact and nsset

* new indexes (poll)

1.8.1
-----

* better user detection in fred-dbmanager

* new indexes (mail,epp_info)

* new indexes into history tables

* new table for stored filters

2008-03-25
----------

* upgrade deleteCandidate state update procedure for contacts/nssets

2008-03-12
----------

* few indexes added

2008-03-12
----------

* configuration process enhancement

* adding sql comments

1.8.0 (2008-02-09)
------------------

* adding action_elements table

* setting of sequences for tables registrar,registraracl,zone,registrarinvoice

2008-02-01
----------

* new directory with distinct upgrade sql files for every change

* new table with top level domains

* refactoring and fixing state.sql

  * states setting parameters moved to parameters table

  * exdate states dependant on serverRenewProhibited

  * proper handling of shared linked state updates (locking)

* new parameter table with system configuration

2008-01-19
----------

* autotooling package with a lot of structural changes

2007-05-24
----------

* ccreg.sql (domain_contact_map) - Adding role of contact - 1=admin, 2=temp and

* history.sql (domain_contact_map_history) - Adding role of contact - 1=admin, 2=temp and

* reason.sql - Fixing typo

* ChangeLog - Adding this changelog

* UPGRADE - Updating alter script