From 7379daad1c73bd3610ed296436250b417ac3673d Mon Sep 17 00:00:00 2001 From: hukl Date: Thu, 10 Feb 2011 14:19:00 +0100 Subject: removed thinking_sphinx plugin and replaced it with gem. also tuned dependencies --- .../thinking-sphinx/spec/fixtures/structure.sql | 95 ---------------------- 1 file changed, 95 deletions(-) delete mode 100644 vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql (limited to 'vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql') diff --git a/vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql b/vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql deleted file mode 100644 index 4ab390d..0000000 --- a/vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql +++ /dev/null @@ -1,95 +0,0 @@ -DROP TABLE IF EXISTS `people`; - -CREATE TABLE `people` ( - `id` int(11) NOT NULL auto_increment, - `first_name` varchar(50) NULL, - `middle_initial` varchar(10) NULL, - `last_name` varchar(50) NULL, - `gender` varchar(10) NULL, - `street_address` varchar(200) NULL, - `city` varchar(100) NULL, - `state` varchar(100) NULL, - `postcode` varchar(10) NULL, - `email` varchar(100) NULL, - `birthday` datetime NULL, - `team_id` int(11) NULL, - `team_type` varchar(50) NULL, - `type` varchar(50) NULL, - `parent_id` varchar(50) NULL, - `delta` tinyint(1) NOT NULL DEFAULT 0, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `friendships`; - -CREATE TABLE `friendships` ( - `id` int(11) NOT NULL auto_increment, - `person_id` int(11) NOT NULL, - `friend_id` int(11) NOT NULL, - `created_at` datetime NOT NULL, - `updated_at` datetime NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `football_teams`; - -CREATE TABLE `football_teams` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(50) NOT NULL, - `state` varchar(50) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `cricket_teams`; - -CREATE TABLE `cricket_teams` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(50) NOT NULL, - `state` varchar(50) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `contacts`; - -CREATE TABLE `contacts` ( - `id` int(11) NOT NULL auto_increment, - `phone_number` varchar(50) NOT NULL, - `person_id` int(11) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `alphas`; - -CREATE TABLE `alphas` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(50) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `betas`; - -CREATE TABLE `betas` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(50) NOT NULL, - `delta` tinyint(1) NOT NULL DEFAULT 0, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `searches`; - -CREATE TABLE `searches` ( - `id` int(11) NOT NULL auto_increment, - `name` varchar(50) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `tags`; - -CREATE TABLE `tags` ( - `id` int(11) NOT NULL auto_increment, - `person_id` int(11) NOT NULL, - `football_team_id` int(11) NOT NULL, - `cricket_team_id` int(11) NOT NULL, - `name` varchar(50) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- cgit v1.3