2 Jul
2009
2 Jul
'09
9:12 a.m.
On 02-07 16:04, Juha Heinanen wrote:
Jan Janak writes:
This is a generic flags column which we added to most tables that store AVPs
and to some other tables too. Individual flags can be used to mark a row as
disabled -- this allows us to disable a particular attribute without deleting
it from the database. A disabled attribute will be ignored by SER. Another
flag can be used to mark a row as deleted. Such row/attribute will be again
ignored by SER. Rows with the deleted flag set are deleted by a cron job. And
so on.
And there are other flags defined, they are all listed in
sip-router/lib/srdb2/db.h
Jan.
mysql> describe domain;
+--------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+-------+
| did | varchar(64) | NO | MUL | NULL | |
| domain | varchar(128) | NO | PRI | NULL | |
| flags | int(10) unsigned | NO | | 0 | |
+--------+------------------+------+-----+---------+-------+
mysql> describe domain_attrs;
+-------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| did | varchar(64) | YES | MUL | NULL | |
| name | varchar(32) | NO | | NULL | |
| type | int(11) | NO | | 0 | |
| value | varchar(255) | YES | | NULL | |
| flags | int(10) unsigned | NO | | 0 | |
+-------+------------------+------+-----+---------+-------+
what is the meaning of "flags" column?