   KEY `news_items_text_index` (`text`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-CREATE TABLE `non_member_results` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `visible` tinyint(1) DEFAULT '1',
-  `person_id` int(11) DEFAULT NULL,
-  `size` int(11) DEFAULT '0',
-  `recent_result_on` date DEFAULT NULL,
-  `created_at` datetime DEFAULT NULL,
-  `updated_at` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
-CREATE TABLE `non_member_results_people` (
-  `non_member_result_id` int(11) DEFAULT NULL,
-  `person_id` int(11) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
 CREATE TABLE `number_issuers` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `name` varchar(255) NOT NULL DEFAULT '',

  `cat4_womens_race_series_end_date` date DEFAULT NULL,
  `unregistered_teams_in_results` tinyint(1) NOT NULL DEFAULT '1',
  `next_year_start_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `refunds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `created_by_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


  KEY `idx_mailing_list_id` (`mailing_list_id`),
  KEY `idx_date_list` (`date`,`mailing_list_id`),
  KEY `index_posts_on_position` (`position`),
  CONSTRAINT `posts_mailing_list_id_fk` FOREIGN KEY (`mailing_list_id`) REFERENCES `mailing_lists` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `promoters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
