|
Mr Anderson- you use an enum to indicate your DNSrecordtype as in this MySQL example CREATE TABLE dns_updates | Field |Type | Null | Key | Default | Extra || id | int(11) | NO | PRI | NULL | auto_increment | | bd_order_id | int(11) | YES | | NULL | | domain | varchar(70) | NO | | | | dns_entry_type | enum('MX','TXT') | YES | | NULL | | dns_entry_value | varchar(255) | YES | | | | created_timestamp | datetime | NO | MUL | 0000-00-00 00:00:00 | for Postgres sub in text[] columns dns_entry_type forthe specified enum datatype and insert in '{"MX", "TXT"}' for dns_entry_type values Anyone else? Martin > Date: Thu, 14 Aug 2008 16:20:14 -0700 > From: raanders@xxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] [Q] DNS(bind) ER model > > Anyone aware of an ER model for holding name server records? > > Working on the zone file data and I am getting close but keep running > into the differences between MX records (with a priority) and the others > that can hold either a domain/sub-domain/host name or an IP address > depending on whether is an A, TXT, PTR, etc. or a CNAME. > > Much of the database will be populated and changed automagically so the > controller for the application will do the right thing but humans will > get involved every so often. I hope I can get the database to make the > right thing easy and the wrong thing "impossible" for them. > > Any suggestions? > > > Rod > -- > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Get Windows Live and get whatever you need, wherever you are. Start here. |
