Contents

drop table if exists contents;
create table contents (
  id int not null auto_increment,
  type varchar(255) not null,
  title varchar(100) not null,
  description text not null,
  special varchar(255) not null,
  primary key (id)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

drop table if exists comments;
create table comments (
  id int not null auto_increment,
  author varchar(100) not null,
  content text not null,
  content_id int,
  primary key (id)
) TYPE=InnoDB DEFAULT CHARSET=utf8;

Version data entries

15 entries across 15 versions & 4 rubygems

Version	Path
cehoffman-acts_as_ferret-0.4.4	doc/demo/db/schema.sql
jkraemer-acts_as_ferret-0.4.4	doc/demo/db/schema.sql
acts_as_ferret-0.5.4	doc/demo/db/schema.sql
acts_as_ferret-0.5.3	doc/demo/db/schema.sql
watson-acts_as_ferret-0.4.8.2	doc/demo/db/schema.sql
acts_as_ferret-0.5.2	doc/demo/db/schema.sql
acts_as_ferret-0.4.8.2	doc/demo/db/schema.sql
acts_as_ferret-0.4.8.1	doc/demo/db/schema.sql
acts_as_ferret-0.5.1	doc/demo/db/schema.sql
acts_as_ferret-0.5	doc/demo/db/schema.sql
acts_as_ferret-0.4.8.rails3	doc/demo/db/schema.sql
acts_as_ferret-0.4.8	doc/demo/db/schema.sql
acts_as_ferret-0.4.7	doc/demo/db/schema.sql
acts_as_ferret-0.4.6	doc/demo/db/schema.sql
acts_as_ferret-0.4.4	doc/demo/db/schema.sql