Both the `soa' table and the `rr' table may contain a column called `active'.
If this column exists, it should contain a boolean value. This could be
0/1 (an integer),
'Active'/'Inactive'. For MySQL databases,
ENUM value is recommended.
active column is present, whenever records are retrieved from
that table, the
active column will be honored. If the row is inactive,
it will be as if the row did not exist at all.
To create an `active' column on your `soa' table, for example, you might issue SQL statements like this:
mysql> ALTER TABLE mydns.soa ADD COLUMN active ENUM('Y','N') NOT NULL; mysql> ALTER TABLE mydns.soa ADD INDEX (active);
mydns=# ALTER TABLE soa ADD COLUMN active INT; mydns=# UPDATE soa SET active=1; mydns=# ALTER TABLE soa ALTER COLUMN active SET NOT NULL; mydns=# ALTER TABLE soa ALTER COLUMN active SET DEFAULT 1;