diff --git a/.gitignore b/.gitignore index 0806b51..d2ae378 100644 --- a/.gitignore +++ b/.gitignore @@ -1,25 +1,29 @@ # See https://help.github.com/articles/ignoring-files for more about ignoring files. # # If you find yourself ignoring temporary files generated by your text editor # or operating system, you probably want to add a global ignore instead: # git config --global core.excludesfile '~/.gitignore_global' # Ignore bundler config. /.bundle # Ignore the default SQLite database. /db/*.sqlite3 /db/*.sqlite3-journal /db/*.local /db/database.yml # Ignore all logfiles and tempfiles. /log/*.log /tmp /doc *.swp config/database.yml .ruby-version # Ignore .pyc *.pyc + + +# automatic dump rails does to check migration status +db/structure.sql diff --git a/db/structure.sql b/db/structure.sql deleted file mode 100644 index 073b154..0000000 --- a/db/structure.sql +++ /dev/null @@ -1,343 +0,0 @@ --- 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 `subscriptions` --- - -DROP TABLE IF EXISTS `subscriptions`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `subscriptions` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `domain_id` int(11) NOT NULL, - `user_id` int(11) NOT NULL, - `disabled` tinyint(1) NOT NULL DEFAULT '1', - `created_at` datetime DEFAULT NULL, - `updated_at` datetime DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `index_subscriptions_on_domain_id` (`domain_id`), - KEY `index_subscriptions_on_user_id` (`user_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -/*!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, - `identifier` varchar(255) DEFAULT '', - `token` varchar(255) DEFAULT NULL, - `notifications` tinyint(1) NOT NULL DEFAULT '1', - PRIMARY KEY (`id`), - UNIQUE KEY `index_users_on_email` (`email`), - UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`), - UNIQUE KEY `index_users_on_token` (`token`), - KEY `index_users_on_identifier` (`identifier`) -) 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'); - -INSERT INTO schema_migrations (version) VALUES ('20160214155026'); - -INSERT INTO schema_migrations (version) VALUES ('20160403094641'); - -INSERT INTO schema_migrations (version) VALUES ('20170305083712'); - -INSERT INTO schema_migrations (version) VALUES ('20170308060441'); -