Full Query Analysis by API Call

queries.sql

-- GET
-- /v2/zones
-- /v2/zones?marker=xxx&limit=10
-- v2/zones?name=poo.com
-- v2/zones?name=poo.com*
-- v2/zones?name=*poo.com
-- v2/zones?name=*poo.com*
-- v2/zones?name=*poo*.com*
-- /v2/zones/id/
-- /v2/zones/id/recordsets
-- /v2/zones/id/recordsets/id

-- POST
-- /v2/zones
-- /v2/zones/id/recordsets

-- PATCH
-- /v2/zones

-- PUT
-- /v2/zones/id/recordsets/id
-- /v2/zones/id/recordsets/id (no records chg)

-- DELETE
-- /v2/zones/id/recordsets/id
-- /v2/zones

 --   ____ _____ _____      __      ____     __                        
 --  / ___| ____|_   _|    / /_   _|___ \   / /______  _ __   ___  ___ 
 -- | |  _|  _|   | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __|
 -- | |_| | |___  | |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \
 --  \____|_____| |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.tenant_id = 'noauth-project' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

#v2/zones?marker=ff5dcaaf-e268-4da6-9c57-1617f0a68790&limit=10
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.tenant_id = 'noauth-project' AND domains.deleted = '0' AND (domains.created_at > '2014-10-23 18:46:06' OR domains.created_at = '2014-10-23 18:46:06' AND domains.id > 'ff5dcaafe2684da69c571617f0a68790' OR domains.created_at = '2014-10-23 18:46:06' AND domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.created_at > '2014-10-23 18:46:06') ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC 
 LIMIT 10;

#v2/zones?name=poo.com
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name = 'poo.com' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

#v2/zones?name=poo.com*
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name LIKE 'poo.com%' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

#v2/zones?name=*poo.com
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name LIKE '%poo.com' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

#v2/zones?name=*poo.com*
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name LIKE '%poo.com%' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

#v2/zones?name=*poo*.com*
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name LIKE '%poo%.com%' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;
 --   ____ _____ _____      __      ____     __                           ___     _ 
 --  / ___| ____|_   _|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |
 -- | |  _|  _|   | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` |
 -- | |_| | |___  | |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |
 --  \____|_____| |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_|
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0'

 --   ____ _____ _____      __      ____     __                           ___     _    __                          _          _       
 --  / ___| ____|_   _|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |  / / __ ___  ___ ___  _ __ __| |___  ___| |_ ___ 
 -- | |  _|  _|   | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` | / / '__/ _ \/ __/ _ \| '__/ _` / __|/ _ \ __/ __|
 -- | |_| | |___  | |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |/ /| | |  __/ (_| (_) | | | (_| \__ \  __/ |_\__ \
 --  \____|_____| |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_/_/ |_|  \___|\___\___/|_|  \__,_|___/\___|\__|___/
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '98f5c030487b4e4aa130eeca2f99169a' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;


 --   ____ _____ _____      __      ____     __                           ___     _    __                          _          _          ___     _ 
 --  / ___| ____|_   _|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |  / / __ ___  ___ ___  _ __ __| |___  ___| |_ ___   / (_) __| |
 -- | |  _|  _|   | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` | / / '__/ _ \/ __/ _ \| '__/ _` / __|/ _ \ __/ __| / /| |/ _` |
 -- | |_| | |___  | |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |/ /| | |  __/ (_| (_) | | | (_| \__ \  __/ |_\__ \/ / | | (_| |
 --  \____|_____| |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_/_/ |_|  \___|\___\___/|_|  \__,_|___/\___|\__|___/_/  |_|\__,_|

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;


 --  ____   ___  ____ _____      __      ____     __                           ___     _    __                          _          _          __
 -- |  _ \ / _ \/ ___|_   _|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |  / / __ ___  ___ ___  _ __ __| |___  ___| |_ ___   / /
 -- | |_) | | | \___ \ | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` | / / '__/ _ \/ __/ _ \| '__/ _` / __|/ _ \ __/ __| / / 
 -- |  __/| |_| |___) || |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |/ /| | |  __/ (_| (_) | | | (_| \__ \  __/ |_\__ \/ /  
 -- |_|    \___/|____/ |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_/_/ |_|  \___|\___\___/|_|  \__,_|___/\___|\__|___/_/   
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'foo.poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.parent_domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO recordsets (id, version, created_at, tenant_id, domain_id, name, type, ttl) VALUES ('b743734519d942058ffd0d3b3875810d', 1, '2014-10-23 18:58:22.949007', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', 'foo.poo.com.', 'A', 3600);

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('a980c6d4ed3f46dc8c5a395373b4d4c0', 1, '2014-10-23 18:58:22.954371', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', 'b743734519d942058ffd0d3b3875810d', '10.1.0.1', '85475139590267671bc789b9787912a0', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'a980c6d4ed3f46dc8c5a395373b4d4c0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

UPDATE domains SET updated_at='2014-10-23 18:58:22.960381', serial=1414090702 WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 18:58:22.978985' WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '7b25801e5837403fae03d4f22f2fac31' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = '7b25801e5837403fae03d4f22f2fac31' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '7b25801e5837403fae03d4f22f2fac31';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('84b4b4b0bb1947b6bca37b0ceea284c4', 1, '2014-10-23 18:58:22.991105', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', '6d6f0eb413634a58918cd9d269c50dc6', 'staging-ns1.staging.raqit.com. tim.tim.com. 1414090702 3600 600 86400 3600', 'e9399974ac4737912251e71b44e0ea49', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '84b4b4b0bb1947b6bca37b0ceea284c4';


 --  ____  _   _ _____      __      ____     __                           ___     _    __                          _          _          ___     _ 
 -- |  _ \| | | |_   _|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |  / / __ ___  ___ ___  _ __ __| |___  ___| |_ ___   / (_) __| |
 -- | |_) | | | | | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` | / / '__/ _ \/ __/ _ \| '__/ _` / __|/ _ \ __/ __| / /| |/ _` |
 -- |  __/| |_| | | |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |/ /| | |  __/ (_| (_) | | | (_| \__ \  __/ |_\__ \/ / | | (_| |
 -- |_|    \___/  |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_/_/ |_|  \___|\___\___/|_|  \__,_|___/\___|\__|___/_/  |_|\__,_|
#40 + 4(#records)
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = 'b743734519d942058ffd0d3b3875810d' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'foo.poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.parent_domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 19:08:54.154906' WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = 'b743734519d942058ffd0d3b3875810d' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '6a0f5dcb4d1b4c7780032ab74ce79822' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = '6a0f5dcb4d1b4c7780032ab74ce79822' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '6a0f5dcb4d1b4c7780032ab74ce79822';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'd60379d39e3e4172882ba50b24851ffd' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = 'd60379d39e3e4172882ba50b24851ffd' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'd60379d39e3e4172882ba50b24851ffd';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('bab2c07867144470bbc9f9edda870ba0', 1, '2014-10-23 19:08:54.175084', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', 'b743734519d942058ffd0d3b3875810d', '10.1.0.1', '85475139590267671bc789b9787912a0', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'bab2c07867144470bbc9f9edda870ba0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('54e5da076f234e9f98cfa9f8825abca6', 1, '2014-10-23 19:08:54.182076', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', 'b743734519d942058ffd0d3b3875810d', '10.1.0.3', 'd54ffd19456178fa858fa92d9177949a', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '54e5da076f234e9f98cfa9f8825abca6';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

UPDATE domains SET updated_at='2014-10-23 19:08:54.188566', serial=1414091334 WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 19:08:54.208963' WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '5d080dde08804d7f85e112cb9f7c7edb' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = '5d080dde08804d7f85e112cb9f7c7edb' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '5d080dde08804d7f85e112cb9f7c7edb';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('f308988874ce4adeb530406dd7a1e729', 1, '2014-10-23 19:08:54.222800', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', '6d6f0eb413634a58918cd9d269c50dc6', 'staging-ns1.staging.raqit.com. tim.tim.com. 1414091334 3600 600 86400 3600', '4ae9ff332f6dc56eb33d96264303de7f', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'f308988874ce4adeb530406dd7a1e729';


 --  ____  _____ _     _____ _____ _____      __      ____     __                           ___     _    __                          _          _          ___     _ 
 -- |  _ \| ____| |   | ____|_   _| ____|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |  / / __ ___  ___ ___  _ __ __| |___  ___| |_ ___   / (_) __| |
 -- | | | |  _| | |   |  _|   | | |  _|     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` | / / '__/ _ \/ __/ _ \| '__/ _` / __|/ _ \ __/ __| / /| |/ _` |
 -- | |_| | |___| |___| |___  | | | |___   / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |/ /| | |  __/ (_| (_) | | | (_| \__ \  __/ |_\__ \/ / | | (_| |
 -- |____/|_____|_____|_____| |_| |_____| /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_/_/ |_|  \___|\___\___/|_|  \__,_|___/\___|\__|___/_/  |_|\__,_|

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = 'b743734519d942058ffd0d3b3875810d' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = 'b743734519d942058ffd0d3b3875810d' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM recordsets WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'b743734519d942058ffd0d3b3875810d';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

UPDATE domains SET updated_at='2014-10-23 19:58:12.544383', serial=1414094292 WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 19:58:12.561527' WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '2d7949abb17e4c69bed34cfea9a4f1f1' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = '2d7949abb17e4c69bed34cfea9a4f1f1' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '2d7949abb17e4c69bed34cfea9a4f1f1';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('0ff9f6e7fee44b278df868859ebe7a01', 1, '2014-10-23 19:58:12.573399', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', '6d6f0eb413634a58918cd9d269c50dc6', 'staging-ns1.staging.raqit.com. tim.tim.com. 1414094292 3600 600 86400 3600', '97b086528681f68c52e9eb99bdf2c7c9', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 

 --  ____  _   _ _____      __      ____     __                           ___     _    __                          _          _          ___     _    __                                        _   __  
 -- |  _ \| | | |_   _|    / /_   _|___ \   / /______  _ __   ___  ___   / (_) __| |  / / __ ___  ___ ___  _ __ __| |___  ___| |_ ___   / (_) __| |  / / __   ___    _ __ ___  ___ ___  _ __ __| |__\ \ 
 -- | |_) | | | | | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __| / /| |/ _` | / / '__/ _ \/ __/ _ \| '__/ _` / __|/ _ \ __/ __| / /| |/ _` | | | '_ \ / _ \  | '__/ _ \/ __/ _ \| '__/ _` / __| |
 -- |  __/| |_| | | |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \/ / | | (_| |/ /| | |  __/ (_| (_) | | | (_| \__ \  __/ |_\__ \/ / | | (_| | | | | | | (_) | | | |  __/ (_| (_) | | | (_| \__ \ |
 -- |_|    \___/  |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/_/  |_|\__,_/_/ |_|  \___|\___\___/|_|  \__,_|___/\___|\__|___/_/  |_|\__,_| | |_| |_|\___/  |_|  \___|\___\___/|_|  \__,_|___/ |
 --                                                                                                                                                  \_\                                            /_/ 
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '99964f12756d40359535882221e6b563' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '99964f12756d40359535882221e6b563' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'foo.poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.parent_domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 20:06:48.751949', ttl=3601 WHERE recordsets.id = '99964f12756d40359535882221e6b563' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '99964f12756d40359535882221e6b563';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '99964f12756d40359535882221e6b563' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

UPDATE records SET updated_at='2014-10-23 20:06:48.760107' WHERE records.id = '34f9d2f1f63348919330f132eb575a7e' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '34f9d2f1f63348919330f132eb575a7e';

UPDATE records SET updated_at='2014-10-23 20:06:48.765410' WHERE records.id = '40f9fa2a802941b28ab367452a704962' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '40f9fa2a802941b28ab367452a704962';

UPDATE records SET updated_at='2014-10-23 20:06:48.769878' WHERE records.id = '4445f87b36214fa596b60d61ba1be89f' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '4445f87b36214fa596b60d61ba1be89f';

UPDATE records SET updated_at='2014-10-23 20:06:48.773573' WHERE records.id = '4b14a5a4ac5a4d3eb986df19758df593' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '4b14a5a4ac5a4d3eb986df19758df593';

UPDATE records SET updated_at='2014-10-23 20:06:48.777296' WHERE records.id = '7425dac561df4f5c9a310abe12bff7a3' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '7425dac561df4f5c9a310abe12bff7a3';

UPDATE records SET updated_at='2014-10-23 20:06:48.781037' WHERE records.id = '8640e22d423e40788967ab825d16275e' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '8640e22d423e40788967ab825d16275e';

UPDATE records SET updated_at='2014-10-23 20:06:48.785655' WHERE records.id = '8f67a40cf75642caab7722adbd9411a1' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '8f67a40cf75642caab7722adbd9411a1';

UPDATE records SET updated_at='2014-10-23 20:06:48.789675' WHERE records.id = 'e475b94b952541b0b53e8d0489a7a37d' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'e475b94b952541b0b53e8d0489a7a37d';

UPDATE records SET updated_at='2014-10-23 20:06:48.793393' WHERE records.id = 'f220beb7a369425d801c976718b64a84' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'f220beb7a369425d801c976718b64a84';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

UPDATE domains SET updated_at='2014-10-23 20:06:48.799796', serial=1414094808 WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ff5dcaafe2684da69c571617f0a68790' AND recordsets.name = 'poo.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 20:06:48.818963' WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '6d6f0eb413634a58918cd9d269c50dc6';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '6d6f0eb413634a58918cd9d269c50dc6' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '53309cb1fd3f4d708bae9b84a0e97dfc' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = '53309cb1fd3f4d708bae9b84a0e97dfc' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '53309cb1fd3f4d708bae9b84a0e97dfc';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'ff5dcaafe2684da69c571617f0a68790' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('0e79074506974bf384bd9e34de17643d', 1, '2014-10-23 20:06:48.833037', 'noauth-project', 'ff5dcaafe2684da69c571617f0a68790', '6d6f0eb413634a58918cd9d269c50dc6', 'staging-ns1.staging.raqit.com. tim.tim.com. 1414094808 3600 600 86400 3600', 'df43e7e7706432f4f8cbd319ca2324e7', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '0e79074506974bf384bd9e34de17643d';

 -- ____   ___  ____ _____      __      ____     __                        
 -- |  _ \ / _ \/ ___|_   _|    / /_   _|___ \   / /______  _ __   ___  ___ 
 -- | |_) | | | \___ \ | |     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __|
 -- |  __/| |_| |___) || |    / /  \ V / / __/ / / / / (_) | | | |  __/\__ \
 -- |_|    \___/|____/ |_|   /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/
 
SELECT count(domains.id) AS count_1 
FROM domains 
WHERE domains.tenant_id = 'noauth-project' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT quotas.id, quotas.version, quotas.created_at, quotas.updated_at, quotas.tenant_id, quotas.resource, quotas.hard_limit 
FROM quotas 
WHERE quotas.tenant_id = 'noauth-project' AND quotas.tenant_id = 'noauth-project' ORDER BY quotas.created_at ASC, quotas.id ASC, quotas.created_at ASC;

SELECT tlds.id, tlds.version, tlds.created_at, tlds.updated_at, tlds.name, tlds.description 
FROM tlds 
WHERE tlds.name = 'com' 
 LIMIT 2;

SELECT tlds.id, tlds.version, tlds.created_at, tlds.updated_at, tlds.name, tlds.description 
FROM tlds 
WHERE tlds.name = 'doge.com' 
 LIMIT 2;

SELECT blacklists.id, blacklists.version, blacklists.created_at, blacklists.updated_at, blacklists.pattern, blacklists.description 
FROM blacklists ORDER BY blacklists.created_at ASC, blacklists.id ASC, blacklists.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name = 'com.' AND domains.deleted = '0' 
 LIMIT 2;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name = '' AND domains.deleted = '0' 
 LIMIT 2;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name LIKE '%doge.com.' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC;

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

INSERT INTO domains (id, version, created_at, deleted, tenant_id, name, email, ttl, serial, refresh, retry, expire, minimum, status) VALUES ('c8baadcc25d14549a66caaeab1381ffd', 1, '2014-10-23 20:12:24.064429', '0', 'noauth-project', 'doge.com.', 'tim@tim.com', 3601, 1414095144, 3600, 600, 86400, 3600, 'ACTIVE');

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd';

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' AND recordsets.name = 'doge.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO recordsets (id, version, created_at, tenant_id, domain_id, name, type) VALUES ('5b648bb953b44941b5a7cbdec95c1205', 1, '2014-10-23 20:12:24.082623', 'noauth-project', 'c8baadcc25d14549a66caaeab1381ffd', 'doge.com.', 'SOA');

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '5b648bb953b44941b5a7cbdec95c1205';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('9275bbef8d7b418aae4a767727199f20', 1, '2014-10-23 20:12:24.089355', 'noauth-project', 'c8baadcc25d14549a66caaeab1381ffd', '5b648bb953b44941b5a7cbdec95c1205', 'staging-ns1.staging.raqit.com. tim.tim.com. 1414095144 3600 600 86400 3600', '3717db73edbb2665264b8823ac9ae8d3', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '9275bbef8d7b418aae4a767727199f20';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' AND recordsets.name = 'doge.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO recordsets (id, version, created_at, tenant_id, domain_id, name, type) VALUES ('d07a1879c34047e9bf17a10e73b7c677', 1, '2014-10-23 20:12:24.104337', 'noauth-project', 'c8baadcc25d14549a66caaeab1381ffd', 'doge.com.', 'NS');

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = 'd07a1879c34047e9bf17a10e73b7c677';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('4f1ffac1bcb343f793124189fa949945', 1, '2014-10-23 20:12:24.114996', 'noauth-project', 'c8baadcc25d14549a66caaeab1381ffd', 'd07a1879c34047e9bf17a10e73b7c677', 'staging-ns1.staging.raqit.com.', '8500461f06f840c7320c829cd74a8f76', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = '4f1ffac1bcb343f793124189fa949945';

 --  __  __ ____  _   _ ____  
 -- |  \/  |  _ \| \ | / ___| 
 -- | |\/| | | | |  \| \___ \ 
 -- | |  | | |_| | |\  |___) |
 -- |_|  |_|____/|_| \_|____/ 
                           
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets INNER JOIN domains ON recordsets.domain_id = domains.id 
WHERE domains.deleted = '0' AND recordsets.type = 'SOA' AND recordsets.name = 'doge.com.' 
 LIMIT 2;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name = 'doge.com.' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '5b648bb953b44941b5a7cbdec95c1205' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type != 'SOA' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = 'd07a1879c34047e9bf17a10e73b7c677' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

 --  ____   _  _____ ____ _   _      __      ____     __                        
 -- |  _ \ / \|_   _/ ___| | | |    / /_   _|___ \   / /______  _ __   ___  ___ 
 -- | |_) / _ \ | || |   | |_| |   / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __|
 -- |  __/ ___ \| || |___|  _  |  / /  \ V / / __/ / / / / (_) | | | |  __/\__ \
 -- |_| /_/   \_\_| \____|_| |_| /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT servers.id, servers.version, servers.created_at, servers.updated_at, servers.name 
FROM servers ORDER BY servers.created_at ASC, servers.id ASC, servers.created_at ASC;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' AND recordsets.tenant_id = 'noauth-project' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '5b648bb953b44941b5a7cbdec95c1205' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' AND recordsets.name = 'doge.com.' AND recordsets.tenant_id = 'noauth-project' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;

UPDATE recordsets SET updated_at='2014-10-23 21:08:33.369523' WHERE recordsets.id = '5b648bb953b44941b5a7cbdec95c1205' AND recordsets.tenant_id = 'noauth-project';

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.id = '5b648bb953b44941b5a7cbdec95c1205';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '5b648bb953b44941b5a7cbdec95c1205' AND records.tenant_id = 'noauth-project' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'f43e40803abe4f4986522cb8ecfa2af7' AND records.tenant_id = 'noauth-project' 
 LIMIT 2;

DELETE FROM records WHERE records.id = 'f43e40803abe4f4986522cb8ecfa2af7' AND records.tenant_id = 'noauth-project';

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'f43e40803abe4f4986522cb8ecfa2af7';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('ab51bac4d5ac49878e2855a97aa83e25', 1, '2014-10-23 21:08:33.381832', 'noauth-project', 'c8baadcc25d14549a66caaeab1381ffd', '5b648bb953b44941b5a7cbdec95c1205', 'staging-ns1.staging.raqit.com. tim.tim.com. 1414098513 3600 600 86400 3600', '2506aa9461ba3884c682ab8b1aa26fda', 0, 'ACTIVE');

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.id = 'ab51bac4d5ac49878e2855a97aa83e25';

UPDATE domains SET updated_at='2014-10-23 21:08:33.389594', ttl=3601, serial=1414098513 WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd';

 --  __  __ ____  _   _ ____  
 -- |  \/  |  _ \| \ | / ___| 
 -- | |\/| | | | |  \| \___ \ 
 -- | |  | | |_| | |\  |___) |
 -- |_|  |_|____/|_| \_|____/ 
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets INNER JOIN domains ON recordsets.domain_id = domains.id 
WHERE domains.deleted = '0' AND recordsets.type = 'SOA' AND recordsets.name = 'doge.com.' 
 LIMIT 2;

SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '5b648bb953b44941b5a7cbdec95c1205' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.deleted = '0' 
 LIMIT 2;

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.name = 'doge.com.' AND domains.deleted = '0' 
 LIMIT 2;

SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;


SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = '5b648bb953b44941b5a7cbdec95c1205' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;


SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description 
FROM recordsets 
WHERE recordsets.type != 'SOA' AND recordsets.domain_id = 'c8baadcc25d14549a66caaeab1381ffd' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;


SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status 
FROM records 
WHERE records.recordset_id = 'd07a1879c34047e9bf17a10e73b7c677' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;


 --  ____  _____ _     _____ _____ _____      __      ____     __                        
 -- |  _ \| ____| |   | ____|_   _| ____|    / /_   _|___ \   / /______  _ __   ___  ___ 
 -- | | | |  _| | |   |  _|   | | |  _|     / /\ \ / / __) | / /_  / _ \| '_ \ / _ \/ __|
 -- | |_| | |___| |___| |___  | | | |___   / /  \ V / / __/ / / / / (_) | | | |  __/\__ \
 -- |____/|_____|_____|_____| |_| |_____| /_/    \_/ |_____/_/ /___\___/|_| |_|\___||___/

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

SELECT count(domains.id) AS count_1 
FROM domains 
WHERE domains.parent_domain_id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0' 
 LIMIT 2;

UPDATE domains SET updated_at='2014-10-23 21:19:48.109718', deleted='c8baadcc25d14549a66caaeab1381ffd', deleted_at='2014-10-23 21:19:48.108956' WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd' AND domains.tenant_id = 'noauth-project' AND domains.deleted = '0';

SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id 
FROM domains 
WHERE domains.id = 'c8baadcc25d14549a66caaeab1381ffd';

showcreatetable.sql

#show create table servers\G
*************************** 1. row ***************************
       Table: servers
Create Table: CREATE TABLE `servers` (
  `id` char(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `version` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_server_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

#show create table domains\G
*************************** 1. row ***************************
       Table: domains
Create Table: CREATE TABLE `domains` (
  `id` char(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `version` int(11) NOT NULL,
  `tenant_id` varchar(36) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `ttl` int(11) NOT NULL,
  `refresh` int(11) NOT NULL,
  `retry` int(11) NOT NULL,
  `expire` int(11) NOT NULL,
  `minimum` int(11) NOT NULL,
  `parent_domain_id` char(32) DEFAULT NULL,
  `serial` int(11) NOT NULL DEFAULT '1',
  `deleted` char(32) NOT NULL DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  `description` varchar(160) DEFAULT NULL,
  `status` enum('ACTIVE','PENDING','DELETED') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_domain_name` (`name`,`deleted`),
  KEY `parent_domain_id` (`parent_domain_id`),
  CONSTRAINT `domains_ibfk_1` FOREIGN KEY (`parent_domain_id`) REFERENCES `domains` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

#show create table recordsets\G
*************************** 1. row ***************************
       Table: recordsets
Create Table: CREATE TABLE `recordsets` (
  `id` char(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `version` int(11) NOT NULL,
  `tenant_id` varchar(36) DEFAULT NULL,
  `domain_id` char(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('A','AAAA','CNAME','MX','SRV','TXT','SPF','NS','PTR','SSHFP','SOA') NOT NULL,
  `ttl` int(11) DEFAULT NULL,
  `description` varchar(160) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_recordset` (`domain_id`,`name`,`type`),
  CONSTRAINT `recordsets_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

#show create table records\G
*************************** 1. row ***************************
       Table: records
Create Table: CREATE TABLE `records` (
  `id` char(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `version` int(11) NOT NULL,
  `data` text NOT NULL,
  `priority` int(11) DEFAULT NULL,
  `domain_id` char(32) NOT NULL,
  `managed` tinyint(1) DEFAULT NULL,
  `managed_resource_type` varchar(50) DEFAULT NULL,
  `managed_resource_id` char(32) DEFAULT NULL,
  `managed_plugin_name` varchar(50) DEFAULT NULL,
  `managed_plugin_type` varchar(50) DEFAULT NULL,
  `hash` varchar(32) NOT NULL,
  `description` varchar(160) DEFAULT NULL,
  `status` enum('ACTIVE','PENDING','DELETED') NOT NULL DEFAULT 'ACTIVE',
  `tenant_id` varchar(36) DEFAULT NULL,
  `recordset_id` char(32) NOT NULL,
  `managed_tenant_id` varchar(36) DEFAULT NULL,
  `managed_resource_region` varchar(100) DEFAULT NULL,
  `managed_extra` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_record` (`hash`),
  KEY `fkey_records_domain_id` (`domain_id`),
  KEY `fkey_records_recordset_id` (`recordset_id`),
  CONSTRAINT `fkey_records_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fkey_records_recordset_id` FOREIGN KEY (`recordset_id`) REFERENCES `recordsets` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

#show create table tlds\G
*************************** 1. row ***************************
       Table: tlds
Create Table: CREATE TABLE `tlds` (
  `id` char(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `version` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(160) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_tld_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

#show create table quotas\G
*************************** 1. row ***************************
       Table: quotas
Create Table: CREATE TABLE `quotas` (
  `id` char(32) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `version` int(11) NOT NULL,
  `tenant_id` varchar(36) NOT NULL,
  `resource` varchar(32) NOT NULL,
  `hard_limit` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_quota` (`tenant_id`,`resource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8