diff options
Diffstat (limited to 'vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql')
| -rw-r--r-- | vendor/plugins/thinking-sphinx/spec/fixtures/structure.sql | 95 |
1 files changed, 0 insertions, 95 deletions
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 @@ | |||
| 1 | DROP TABLE IF EXISTS `people`; | ||
| 2 | |||
| 3 | CREATE TABLE `people` ( | ||
| 4 | `id` int(11) NOT NULL auto_increment, | ||
| 5 | `first_name` varchar(50) NULL, | ||
| 6 | `middle_initial` varchar(10) NULL, | ||
| 7 | `last_name` varchar(50) NULL, | ||
| 8 | `gender` varchar(10) NULL, | ||
| 9 | `street_address` varchar(200) NULL, | ||
| 10 | `city` varchar(100) NULL, | ||
| 11 | `state` varchar(100) NULL, | ||
| 12 | `postcode` varchar(10) NULL, | ||
| 13 | `email` varchar(100) NULL, | ||
| 14 | `birthday` datetime NULL, | ||
| 15 | `team_id` int(11) NULL, | ||
| 16 | `team_type` varchar(50) NULL, | ||
| 17 | `type` varchar(50) NULL, | ||
| 18 | `parent_id` varchar(50) NULL, | ||
| 19 | `delta` tinyint(1) NOT NULL DEFAULT 0, | ||
| 20 | PRIMARY KEY (`id`) | ||
| 21 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 22 | |||
| 23 | DROP TABLE IF EXISTS `friendships`; | ||
| 24 | |||
| 25 | CREATE TABLE `friendships` ( | ||
| 26 | `id` int(11) NOT NULL auto_increment, | ||
| 27 | `person_id` int(11) NOT NULL, | ||
| 28 | `friend_id` int(11) NOT NULL, | ||
| 29 | `created_at` datetime NOT NULL, | ||
| 30 | `updated_at` datetime NOT NULL, | ||
| 31 | PRIMARY KEY (`id`) | ||
| 32 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 33 | |||
| 34 | DROP TABLE IF EXISTS `football_teams`; | ||
| 35 | |||
| 36 | CREATE TABLE `football_teams` ( | ||
| 37 | `id` int(11) NOT NULL auto_increment, | ||
| 38 | `name` varchar(50) NOT NULL, | ||
| 39 | `state` varchar(50) NOT NULL, | ||
| 40 | PRIMARY KEY (`id`) | ||
| 41 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 42 | |||
| 43 | DROP TABLE IF EXISTS `cricket_teams`; | ||
| 44 | |||
| 45 | CREATE TABLE `cricket_teams` ( | ||
| 46 | `id` int(11) NOT NULL auto_increment, | ||
| 47 | `name` varchar(50) NOT NULL, | ||
| 48 | `state` varchar(50) NOT NULL, | ||
| 49 | PRIMARY KEY (`id`) | ||
| 50 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 51 | |||
| 52 | DROP TABLE IF EXISTS `contacts`; | ||
| 53 | |||
| 54 | CREATE TABLE `contacts` ( | ||
| 55 | `id` int(11) NOT NULL auto_increment, | ||
| 56 | `phone_number` varchar(50) NOT NULL, | ||
| 57 | `person_id` int(11) NOT NULL, | ||
| 58 | PRIMARY KEY (`id`) | ||
| 59 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 60 | |||
| 61 | DROP TABLE IF EXISTS `alphas`; | ||
| 62 | |||
| 63 | CREATE TABLE `alphas` ( | ||
| 64 | `id` int(11) NOT NULL auto_increment, | ||
| 65 | `name` varchar(50) NOT NULL, | ||
| 66 | PRIMARY KEY (`id`) | ||
| 67 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 68 | |||
| 69 | DROP TABLE IF EXISTS `betas`; | ||
| 70 | |||
| 71 | CREATE TABLE `betas` ( | ||
| 72 | `id` int(11) NOT NULL auto_increment, | ||
| 73 | `name` varchar(50) NOT NULL, | ||
| 74 | `delta` tinyint(1) NOT NULL DEFAULT 0, | ||
| 75 | PRIMARY KEY (`id`) | ||
| 76 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 77 | |||
| 78 | DROP TABLE IF EXISTS `searches`; | ||
| 79 | |||
| 80 | CREATE TABLE `searches` ( | ||
| 81 | `id` int(11) NOT NULL auto_increment, | ||
| 82 | `name` varchar(50) NOT NULL, | ||
| 83 | PRIMARY KEY (`id`) | ||
| 84 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
| 85 | |||
| 86 | DROP TABLE IF EXISTS `tags`; | ||
| 87 | |||
| 88 | CREATE TABLE `tags` ( | ||
| 89 | `id` int(11) NOT NULL auto_increment, | ||
| 90 | `person_id` int(11) NOT NULL, | ||
| 91 | `football_team_id` int(11) NOT NULL, | ||
| 92 | `cricket_team_id` int(11) NOT NULL, | ||
| 93 | `name` varchar(50) NOT NULL, | ||
| 94 | PRIMARY KEY (`id`) | ||
| 95 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||