database migration questions
piotr at przybyl.org
Tue Aug 23 16:23:16 CEST 2016
Hello cz.nic Team
I have a few questions related to database migration of FRED if you don't mind.
When trying to download the latest sources from https://fred.nic.cz/page/2904/download/#source I've
realised, that they're not available. E.g. the latest migration scripts are available in
fred-db*deb, but the tarball is not a corresponding one.
Could you please try to release latest sources in tarballs?
I've noticed, that upgrade to 2.19.0 creates a table object_state_backup. However, beside DDL from
2.18.0-2.19.0.sql I don't see this table being used anywhere else. Can it be deleted?
Could you briefly describe what's the purpose of tables:
As far I can tell after analysing the sources, these tables are populated by a functionality called
from MojeID ( =your special NIC registrar to keep domain contacts defined at central level, not each
What are the following tables for? Or: How the checks of contacts are working? Is is something
related to checking if a contact's address fields are valid?
There's a table notification_queue. I can't find any usage of it (maybe because not all tarballs are
up to date). What is it for?
Do you replicate this table using Slony? (Because it has neither primary nor unique key.)
More information about the fred-users