INSERT INTO domains ('id', 'name', 'master', 'last_check', 'type', 'notified_serial', 'account') \
VALUES (, 'line5.tv', NULL, NULL, , NULL, NULL);
... und dann die SOA, NS, A und MX Records:
// SOA
INSERT INTO records SET domain_id='1', name='line5.tv', type='SOA', content=concat \
('ns1.line5.tv. registrar.line-5.de. ',UNIX_TIMESTAMP(),' 12000 1800 604800 86400'), \
ttl='3600';
// 3 Nameserver
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', 'line5.tv', 'NS', 'ns1.line5.tv', '3600', NULL , NULL );
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', 'line5.tv', 'NS', 'ns2.line5.tv', '3600', NULL , NULL );
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', 'line5.tv', 'NS', 'ns3.line5.tv', '3600', NULL , NULL );
// 2 A-Records
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', 'line5.tv', 'A', '81.169.153.104', '3600', NULL , NULL );
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', '*.line5.tv', 'A', '81.169.153.104', '3600', NULL , NULL );
// 2 MX-Records
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', 'line5.tv', 'MX', 'mail.line5.tv', '3600', '10' , NULL );
INSERT INTO `records` ( `id` , `domain_id` , `name` , `type` , `content` , `ttl` , `prio` , `change_date` ) \
VALUES (``, '1', 'line5.tv', 'MX', 'mail2.line5.tv', '3600', '20' , NULL );