No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, May 18, 1:51 PM

View Options

	diff --git a/app/controllers/domains_controller.rb b/app/controllers/domains_controller.rb
	index 694661e..3918570 100644
	--- a/app/controllers/domains_controller.rb
	+++ b/app/controllers/domains_controller.rb
	@@ -1,89 +1,90 @@
	class DomainsController < ApplicationController
	before_action :authenticate_user!

	before_action :domain, only: [:show, :edit, :edit_dnssec, :update, :destroy]
	before_action :group, only: [:show, :edit, :edit_dnssec, :update, :destroy]

	helper_method :edit_group_scope

	# GET /domains
	def index
	@domains = show_domain_scope.includes(:group, :soa).all
	end

	# GET /domains/1
	def show
	@record = Record.new(domain_id: @domain.id)
	end

	# GET /domains/new
	def new
	@domain = Domain.new(new_domain_params)
	end

	# GET /domains/1/edit
	def edit
	end

	# GET /domains/1/edit_dnssec
	def edit_dnssec
	end

	# POST /domains
	def create
	@domain = Domain.new(domain_params)

	if @domain.save
	notify_domain(@domain, :create)
	redirect_to @domain, notice: "#{@domain.name} was successfully created."
	else
	render :new
	end
	end

	# PATCH/PUT /domains/1
	def update
	if @domain.update(domain_params)
	notify_domain(@domain, :update)
	redirect_to @domain, notice: "#{@domain.name} was successfully updated."
	else
	if domain_params[:dnssec] # DNSSEC form
	render :edit_dnssec
	else
	render :edit
	end
	end
	end

	# DELETE /domains/1
	def destroy
	if @domain.remove
	notify_domain(@domain, :destroy)
	redirect_to domains_url, notice: "#{@domain.name} is scheduled for removal."
	else
	redirect_to domains_url, alert: "#{@domain.name} cannot be deleted! (state '#{@domain.state}')"
	end
	end

	private

	def group
	domain.group
	end

	def new_domain_params
	params.permit(:group_id)
	end

	def domain_params
	params.require(:domain).tap { \|d\|
	# Make sure group id is permitted (belongs to edit_group_scope)
	d[:group_id] = edit_group_scope.find_by_id(d[:group_id]).try(:id)
	- }.permit(:name, :type, :master, :group_id, :dnssec, :dnssec_parent, :dnssec_parent_authority)
	+ }.permit(:name, :type, :master, :group_id,
	+ :dnssec, :dnssec_parent, :dnssec_parent_authority, :dnssec_policy_id)
	end

	def notify_domain(*args)
	notification.notify_domain(current_user, *args) if WebDNS.settings[:notifications]
	end

	end
	diff --git a/app/models/dnssec_policy.rb b/app/models/dnssec_policy.rb
	new file mode 100644
	index 0000000..a3730c1
	--- /dev/null
	+++ b/app/models/dnssec_policy.rb
	@@ -0,0 +1,2 @@
	+class DnssecPolicy < ActiveRecord::Base
	+end
	diff --git a/app/models/domain.rb b/app/models/domain.rb
	index 96b8562..349e5aa 100644
	--- a/app/models/domain.rb
	+++ b/app/models/domain.rb
	@@ -1,284 +1,286 @@
	class Domain < ActiveRecord::Base
	class NotAChild < StandardError; end
	self.inheritance_column = :nx

	# List all supported domain types.
	def self.domain_types
	[
	'NATIVE',
	'MASTER',
	'SLAVE',
	]
	end

	# List domain types that can be created.
	def self.allowed_domain_types
	domain_types - WebDNS.settings[:prohibit_domain_types]
	end

	# List parent authorities
	def self.dnssec_parent_authorities
	WebDNS.settings[:dnssec_parent_authorities]
	end

	# Fire event after transaction commmit
	# Changing state inside a hook messes things up,
	# this trick handles that
	attr_accessor :fire_event

	belongs_to :group
	has_many :jobs
	has_many :records
	# BUG in bump_serial_trigger
	has_one :soa, -> { unscope(where: :type).where(type: 'soa') }, class_name: SOA
	+ belongs_to :dnssec_policy

	validates :group_id, presence: true
	validates :name, uniqueness: true, presence: true
	validates :type, presence: true, inclusion: { in: domain_types }
	validates :master, presence: true, ipv4: true, if: :slave?

	validates :dnssec, inclusion: { in: [false] }, unless: :dnssec_elegible?
	validates :dnssec_parent_authority, inclusion: { in: dnssec_parent_authorities }, if: :dnssec?
	validates :dnssec_parent, hostname: true, if: :dnssec?
	+ validates :dnssec_policy_id, presence: true, if: :dnssec?

	after_create :generate_soa
	after_create :generate_ns

	after_create :install
	before_save :check_convert
	after_commit :after_commit_event

	attr_writer :serial_strategy

	def self.dnssec_progress(current_state)
	progress = [
	:pending_signing, # 1/3
	:wait_for_ready, # 2/3
	:pending_ds] # 3/3
	idx = progress.index(current_state.to_sym)
	return if idx.nil?

	[idx+1, progress.size].join('/')
	end

	state_machine initial: :initial do
	after_transition(any => :pending_install) { \|domain, _t\| Job.add_domain(domain) }
	after_transition(any => :pending_remove) { \|domain, _t\| Job.shutdown_domain(domain) }
	after_transition(any => :pending_signing) { \|domain, _t\| Job.dnssec_sign(domain) }
	after_transition(any => :wait_for_ready) { \|domain, _t\| Job.wait_for_ready(domain) }
	after_transition(any => :pending_ds) { \|domain, t\| Job.dnssec_push_ds(domain, *t.args) }
	after_transition(any => :pending_ds_rollover) { \|domain, t\| Job.dnssec_rollover_ds(domain, *t.args) }
	after_transition(any => :pending_plain) { \|domain, _t\| Job.convert_to_plain(domain) }
	after_transition(any => :destroy) { \|domain, _t\| domain.destroy }

	# User events
	event :install do
	transition initial: :pending_install
	end

	event :dnssec_sign do
	transition operational: :pending_signing
	end

	event :signed do
	transition pending_signing: :wait_for_ready
	end

	event :push_ds do
	transition wait_for_ready: :pending_ds, operational: :pending_ds_rollover
	end

	event :plain_convert do
	transition operational: :pending_plain
	end

	event :remove do
	transition operational: :pending_remove
	end

	# Machine events
	event :installed do
	transition pending_install: :operational
	end

	event :converted do
	transition [:pending_ds, :pending_plain] => :operational
	end

	event :complete_rollover do
	transition pending_ds_rollover: :operational
	end

	event :cleaned_up do
	transition pending_remove: :destroy
	end

	event :ksk_rollover_detected do
	transition operational: :ksk_rollover
	end
	end

	# Returns true if this domain is elegigble for DNSSEC
	def dnssec_elegible?
	return false if slave?

	true
	end

	# Get the zone's serial strategy.
	#
	# Returns one of the supported serial strategies.
	def serial_strategy
	@serial_strategy \|\|= WebDNS.settings[:serial_strategy]
	end

	# Returns true if this a reverse zone.
	def reverse?
	name.end_with?('.in-addr.arpa') \|\| name.end_with?('.ip6.arpa')
	end

	# Returns true if this a ENUM zone.
	def enum?
	name.end_with?('.e164.arpa')
	end

	# Returns true if this is a slave zone.
	def slave?
	type == 'SLAVE'
	end

	# Compute subnet for reverse records
	def subnet
	return if not reverse?

	if name.end_with?('.in-addr.arpa')
	subnet_v4
	elsif name.end_with?('.ip6.arpa')
	subnet_v6
	end
	end

	def self.replace_ds(parent, child, records)
	parent = find_by_name!(parent)
	fail NotAChild if not child.end_with?(parent.name)

	existing = parent.records.where(name: child, type: 'DS')
	recs = records.map { \|rec\| DS.new(domain: parent, name: child, content: rec) }

	ActiveRecord::Base.transaction do
	existing.destroy_all
	recs.map(&:save!)
	end
	end

	# Apply bulk to operations to the zones
	#
	# 1) Deletions
	# 2) Changes
	# 3) Additions
	def bulk(opts)
	deletes = opts[:deletes] \|\| []
	changes = opts[:changes] \|\| {}
	additions = opts[:additions] \|\| {}
	errors = Hash.new { \|h, k\| h[k] = {} }

	ActiveRecord::Base.transaction do
	# Deletes
	to_delete = records.where(id: deletes).index_by(&:id)
	deletes.each { \|rec_id\|
	if rec = to_delete[Integer(rec_id)]
	rec.destroy
	next
	end

	errors[:deletes][rec_id] = 'Deleted record not found'
	}

	# Changes
	to_change = records.where(id: changes.keys).index_by(&:id)
	changes.each {\|rec_id, changes\|
	binding
	if rec = to_change[Integer(rec_id)]
	errors[:changes][rec_id] = rec.errors.full_messages.join(', ') if !rec.update(changes)
	next
	end

	errors[:changes][rec_id] = 'Changed record not found'
	}

	# Additions
	additions.each { \|inc, attrs\|
	rec = records.new(attrs)
	errors[:additions][inc] = rec.errors.full_messages.join(', ') if !rec.save
	}

	raise ActiveRecord::Rollback if errors.any?
	end

	errors
	end

	private

	def subnet_v4
	# get ip octets (remove .in-addr.arpa)
	octets = name.split('.')[0...-2].reverse
	return if octets.any? { \|_\| false }

	mask = 8 * octets.size
	octets += [0, 0, 0, 0]

	ip = IPAddr.new octets[0, 4].join('.')

	[ip, mask].join('/')
	end

	def subnet_v6
	nibbles = name.split('.')[0...-2].reverse
	return if nibbles.any? { \|_\| false }

	mask = 4 * nibbles.size
	nibbles += [0] * 32

	ip = IPAddr.new nibbles[0, 32].in_groups_of(4).map(&:join).join(':')

	[ip, mask].join('/')
	end

	# Hooks

	def generate_soa
	soa_record = SOA.new(domain: self)

	soa_record.save!
	end

	def generate_ns
	return if slave?
	return if WebDNS.settings[:default_ns].empty?

	WebDNS.settings[:default_ns].each { \|ns\|
	Record.find_or_create_by!(domain: self, type: 'NS', name: '', content: ns)
	}
	end

	def check_convert
	return if !dnssec_changed?

	event = dnssec ? :dnssec_sign : :plain_convert
	if state_events.include?(event)
	self.fire_event = event # Schedule event for after commit
	return true
	end

	errors.add(:dnssec, 'You cannot modify dnssec settings in this state!')
	false
	end

	def after_commit_event
	return if !fire_event

	fire_state_event(fire_event)
	self.fire_event = nil
	end
	end
	diff --git a/app/models/job.rb b/app/models/job.rb
	index 74ba54e..3b3a33b 100644
	--- a/app/models/job.rb
	+++ b/app/models/job.rb
	@@ -1,101 +1,100 @@
	class Job < ActiveRecord::Base
	belongs_to :domain

	scope :pending, -> { where(status: 0) }
	scope :completed, -> { where(status: [1, 2]) }

	def failed?
	status == 2
	end

	def arguments
	JSON.parse(args)
	end

	class << self
	def add_domain(domain)
	ActiveRecord::Base.transaction do
	jobs_for_domain(domain, :add_domain)

	trigger_event(domain, :installed)
	end
	end

	def shutdown_domain(domain)
	ActiveRecord::Base.transaction do
	job_for_domain(domain, :remove_domain)
	job_for_domain(domain, :opendnssec_remove) if domain.dnssec?

	trigger_event(domain, :cleaned_up)
	end
	end

	def dnssec_sign(domain)
	ActiveRecord::Base.transaction do
	- jobs_for_domain(domain,
	- :opendnssec_add,
	- :bind_convert_to_dnssec)
	+ job_for_domain(domain, :opendnssec_add, policy: domain.dnssec_policy.name)
	+ job_for_domain(domain, :bind_convert_to_dnssec)

	trigger_event(domain, :signed)
	end
	end

	def wait_for_ready(domain)
	jobs_for_domain(domain,
	:wait_for_ready_to_push_ds)
	end

	def dnssec_push_ds(domain, dss)
	opts = Hash[:dnssec_parent, domain.dnssec_parent,
	:dnssec_parent_authority, domain.dnssec_parent_authority,
	:dss, dss]
	ActiveRecord::Base.transaction do
	job_for_domain(domain, :publish_ds, opts)
	job_for_domain(domain, :wait_for_active)

	trigger_event(domain, :converted)
	end
	end

	def dnssec_rollover_ds(domain, dss)
	opts = Hash[:dnssec_parent, domain.dnssec_parent,
	:dnssec_parent_authority, domain.dnssec_parent_authority,
	:dss, dss]
	ActiveRecord::Base.transaction do
	job_for_domain(domain, :publish_ds, opts)
	job_for_domain(domain, :wait_for_active)

	trigger_event(domain, :complete_rollover)
	end
	end

	def convert_to_plain(domain)
	ActiveRecord::Base.transaction do
	jobs_for_domain(domain,
	:remove_domain,
	:add_domain,
	:opendnssec_remove)

	trigger_event(domain, :converted)
	end
	end

	private

	def trigger_event(domain, event)
	job_for_domain(domain, :trigger_event, event: event)
	end

	def jobs_for_domain(domain, *job_names)
	job_names.each { \|job_name\| job_for_domain(domain, job_name) }
	end

	def job_for_domain(domain, job_name, args = {})
	args = { zone: domain.name }.merge!(args)

	create!(domain: domain, job_type: job_name, args: args.to_json)
	end

	end

	end
	diff --git a/app/views/domains/_dnssec_form.html.erb b/app/views/domains/_dnssec_form.html.erb
	index 534fdb1..03270ce 100644
	--- a/app/views/domains/_dnssec_form.html.erb
	+++ b/app/views/domains/_dnssec_form.html.erb
	@@ -1,12 +1,13 @@
	<%= bootstrap_form_for(@domain, layout: :horizontal, label_col: 'col-sm-2', control_col: 'col-sm-4') do \|f\| %>
	<%= f.hidden_field :group_id %>
	<%= f.static_control :name %>
	<%= f.select :dnssec, [['Enable', true], ['Disable', false]] %>

	<fieldset id="dnssec_fieldset" <%= 'disabled' if !@domain.dnssec %>>
	+ <%= f.collection_select :dnssec_policy_id, DnssecPolicy.all, :id, :name %>
	<%= f.select :dnssec_parent_authority, Domain.dnssec_parent_authorities, include_blank: true,
	label: 'Parent authority', help: 'WebDNS will manage DS records automatically, handling initial setup and key rollovers.' %>
	<%= f.text_field :dnssec_parent, label: 'Parent zone', help: 'The parent zone to publish the DS records.' %>
	</fieldset>
	<%= f.submit 'Save', class: 'btn btn-primary col-sm-offset-2' %>
	<% end %>
	diff --git a/db/migrate/20160206083933_create_dnssec_policies.rb b/db/migrate/20160206083933_create_dnssec_policies.rb
	new file mode 100644
	index 0000000..7dbf418
	--- /dev/null
	+++ b/db/migrate/20160206083933_create_dnssec_policies.rb
	@@ -0,0 +1,15 @@
	+class CreateDnssecPolicies < ActiveRecord::Migration
	+ def change
	+ create_table :dnssec_policies do \|t\|
	+ t.string :name
	+ t.boolean :active
	+ t.text :policy
	+
	+ t.datetime :created_at, null: false
	+ t.datetime :updated_at, null: false
	+
	+ end
	+
	+ add_column :domains, :dnssec_policy_id, :integer, default: nil
	+ end
	+end
	diff --git a/db/structure.sql b/db/structure.sql
	index d240b30..32e0f15 100644
	--- a/db/structure.sql
	+++ b/db/structure.sql
	@@ -1,288 +1,310 @@
	-- MySQL dump 10.15 Distrib 10.0.20-MariaDB, for debian-linux-gnu (x86_64)
	--
	-- Host: localhost Database: webns
	-- ------------------------------------------------------
	-- Server version 10.0.20-MariaDB-3

	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
	/!40101 SET NAMES utf8 /;
	/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
	/!40103 SET TIME_ZONE='+00:00' /;
	/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
	/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
	/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
	/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;

	--
	-- Table structure for table `comments`
	--

	DROP TABLE IF EXISTS `comments`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `comments` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`domain_id` int(11) NOT NULL,
	`name` varchar(255) NOT NULL,
	`type` varchar(10) NOT NULL,
	`modified_at` int(11) NOT NULL,
	`account` varchar(40) NOT NULL,
	`comment` mediumtext NOT NULL,
	PRIMARY KEY (`id`),
	KEY `comments_domain_id_idx` (`domain_id`),
	KEY `comments_name_type_idx` (`name`,`type`),
	KEY `comments_order_idx` (`domain_id`,`modified_at`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `cryptokeys`
	--

	DROP TABLE IF EXISTS `cryptokeys`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `cryptokeys` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`domain_id` int(11) NOT NULL,
	`flags` int(11) NOT NULL,
	`active` tinyint(1) DEFAULT NULL,
	`content` text,
	PRIMARY KEY (`id`),
	KEY `domainidindex` (`domain_id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	+-- Table structure for table `dnssec_policies`
	+--
	+
	+DROP TABLE IF EXISTS `dnssec_policies`;
	+/!40101 SET @saved_cs_client = @@character_set_client /;
	+/!40101 SET character_set_client = utf8 /;
	+CREATE TABLE `dnssec_policies` (
	+ `id` int(11) NOT NULL AUTO_INCREMENT,
	+ `name` varchar(255) DEFAULT NULL,
	+ `active` tinyint(1) DEFAULT NULL,
	+ `policy` text,
	+ `created_at` datetime NOT NULL,
	+ `updated_at` datetime NOT NULL,
	+ PRIMARY KEY (`id`)
	+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	+/!40101 SET character_set_client = @saved_cs_client /;
	+
	+--
	-- Table structure for table `domainmetadata`
	--

	DROP TABLE IF EXISTS `domainmetadata`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `domainmetadata` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`domain_id` int(11) NOT NULL,
	`kind` varchar(32) DEFAULT NULL,
	`content` text,
	PRIMARY KEY (`id`),
	KEY `domainmetadata_idx` (`domain_id`,`kind`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `domains`
	--

	DROP TABLE IF EXISTS `domains`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `domains` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(255) NOT NULL,
	`master` varchar(128) DEFAULT NULL,
	`last_check` int(11) DEFAULT NULL,
	`type` varchar(6) NOT NULL,
	`notified_serial` int(11) DEFAULT NULL,
	`account` varchar(40) DEFAULT NULL,
	`group_id` int(11) DEFAULT NULL,
	`created_at` datetime NOT NULL,
	`updated_at` datetime NOT NULL,
	`state` varchar(255) NOT NULL DEFAULT 'initial',
	`dnssec` tinyint(1) NOT NULL DEFAULT '0',
	`dnssec_parent` varchar(255) NOT NULL DEFAULT '',
	`dnssec_parent_authority` varchar(255) NOT NULL DEFAULT '',
	+ `dnssec_policy_id` int(11) DEFAULT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `name_index` (`name`),
	KEY `index_domains_on_group_id` (`group_id`)
	) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `groups`
	--

	DROP TABLE IF EXISTS `groups`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `groups` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(255) DEFAULT NULL,
	`disabled` tinyint(1) DEFAULT '0',
	`created_at` datetime DEFAULT NULL,
	`updated_at` datetime DEFAULT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `index_groups_on_name` (`name`)
	) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `jobs`
	--

	DROP TABLE IF EXISTS `jobs`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `jobs` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`job_type` varchar(255) NOT NULL,
	`domain_id` int(11) DEFAULT NULL,
	`args` varchar(255) NOT NULL,
	`status` int(11) NOT NULL DEFAULT '0',
	`retries` int(11) NOT NULL DEFAULT '0',
	`created_at` datetime DEFAULT NULL,
	`updated_at` datetime DEFAULT NULL,
	PRIMARY KEY (`id`),
	KEY `index_jobs_on_domain_id` (`domain_id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `memberships`
	--

	DROP TABLE IF EXISTS `memberships`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `memberships` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`group_id` int(11) DEFAULT NULL,
	`user_id` int(11) DEFAULT NULL,
	`created_at` datetime DEFAULT NULL,
	`updated_at` datetime DEFAULT NULL,
	PRIMARY KEY (`id`),
	KEY `index_memberships_on_group_id` (`group_id`),
	KEY `index_memberships_on_user_id` (`user_id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `records`
	--

	DROP TABLE IF EXISTS `records`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `records` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`domain_id` int(11) DEFAULT NULL,
	`name` varchar(255) DEFAULT NULL,
	`type` varchar(10) DEFAULT NULL,
	`content` mediumtext,
	`ttl` int(11) DEFAULT NULL,
	`prio` int(11) DEFAULT NULL,
	`change_date` int(11) DEFAULT NULL,
	`disabled` tinyint(1) DEFAULT '0',
	`ordername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
	`auth` tinyint(1) DEFAULT '1',
	`created_at` datetime NOT NULL,
	`updated_at` datetime NOT NULL,
	PRIMARY KEY (`id`),
	KEY `nametype_index` (`name`,`type`),
	KEY `domain_id` (`domain_id`),
	KEY `recordorder` (`domain_id`,`ordername`),
	CONSTRAINT `records_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE
	) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `schema_migrations`
	--

	DROP TABLE IF EXISTS `schema_migrations`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `schema_migrations` (
	`version` varchar(255) NOT NULL,
	UNIQUE KEY `unique_schema_migrations` (`version`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `supermasters`
	--

	DROP TABLE IF EXISTS `supermasters`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `supermasters` (
	`ip` varchar(64) NOT NULL,
	`nameserver` varchar(255) NOT NULL,
	`account` varchar(40) NOT NULL,
	PRIMARY KEY (`ip`,`nameserver`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `tsigkeys`
	--

	DROP TABLE IF EXISTS `tsigkeys`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `tsigkeys` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(255) DEFAULT NULL,
	`algorithm` varchar(50) DEFAULT NULL,
	`secret` varchar(255) DEFAULT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `namealgoindex` (`name`,`algorithm`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;

	--
	-- Table structure for table `users`
	--

	DROP TABLE IF EXISTS `users`;
	/!40101 SET @saved_cs_client = @@character_set_client /;
	/!40101 SET character_set_client = utf8 /;
	CREATE TABLE `users` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`email` varchar(255) NOT NULL DEFAULT '',
	`encrypted_password` varchar(255) NOT NULL DEFAULT '',
	`reset_password_token` varchar(255) DEFAULT NULL,
	`reset_password_sent_at` datetime DEFAULT NULL,
	`remember_created_at` datetime DEFAULT NULL,
	`sign_in_count` int(11) NOT NULL DEFAULT '0',
	`current_sign_in_at` datetime DEFAULT NULL,
	`last_sign_in_at` datetime DEFAULT NULL,
	`current_sign_in_ip` varchar(255) DEFAULT NULL,
	`last_sign_in_ip` varchar(255) DEFAULT NULL,
	`created_at` datetime NOT NULL,
	`updated_at` datetime NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `index_users_on_email` (`email`),
	UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	/!40101 SET character_set_client = @saved_cs_client /;
	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;

	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;

	-- Dump completed on 2015-11-08 12:57:51
	INSERT INTO schema_migrations (version) VALUES ('20151028123326');

	INSERT INTO schema_migrations (version) VALUES ('20151028123327');

	INSERT INTO schema_migrations (version) VALUES ('20151031184819');

	INSERT INTO schema_migrations (version) VALUES ('20151107182656');

	INSERT INTO schema_migrations (version) VALUES ('20151108093333');

	INSERT INTO schema_migrations (version) VALUES ('20151108105701');

	INSERT INTO schema_migrations (version) VALUES ('20151207054417');

	INSERT INTO schema_migrations (version) VALUES ('20151207194729');

	INSERT INTO schema_migrations (version) VALUES ('20151213102322');
	+
	+INSERT INTO schema_migrations (version) VALUES ('20160206083933');
	+

No OneTemporaryActions

File Metadata

View Options

Event Timeline

No OneTemporary
Actions