Contents

DROP DATABASE IF EXISTS `actsassolr_tests`;
CREATE DATABASE IF NOT EXISTS `actsassolr_tests`;
USE `actsassolr_tests`

CREATE TABLE `books` (
  `id` int(11) NOT NULL auto_increment,
  `category_id` int(11),
  `name` varchar(200) default NULL,
  `author` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `movies` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `electronics` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `manufacturer` varchar(255) default NULL,
  `features` varchar(255) default NULL,
  `category` varchar(255) default NULL, 
  `price` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `authors` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `biography` text default NULL,
  PRIMARY KEY  (`id`)
);

Version data entries

51 entries across 51 versions & 9 rubygems

Version	Path
honkster-acts_as_solr-0.1.0	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.2.0	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.2.1	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.2.2	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.2.3	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.2.4	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.2.5	test/fixtures/db_definitions/mysql.sql
honkster-acts_as_solr-0.3.4	test/fixtures/db_definitions/mysql.sql
jbasdf-acts_as_solr-0.3.3	test/fixtures/db_definitions/mysql.sql
jbasdf-jbasdf-acts_as_solr-0.4.0	test/fixtures/db_definitions/mysql.sql
jbasdf-muck-solr-0.4.0	test/fixtures/db_definitions/mysql.sql
jbasdf-muck-solr-0.4.1	test/fixtures/db_definitions/mysql.sql
jbasdf-muck-solr-0.4.2	test/fixtures/db_definitions/mysql.sql
onemorecloud-websolr-rails-1.1.1	test/fixtures/db_definitions/mysql.sql
onemorecloud-websolr-rails-1.3.3	test/fixtures/db_definitions/mysql.sql
onemorecloud-websolr-rails-1.4.0	test/fixtures/db_definitions/mysql.sql
onemorecloud-websolr-rails-1.4.1	test/fixtures/db_definitions/mysql.sql
acts_as_solr_reloaded-1.6.0	test/fixtures/db_definitions/mysql.sql
muck-solr-3.0.1	test/fixtures/db_definitions/mysql.sql
muck-solr-3.0.0	test/fixtures/db_definitions/mysql.sql