Contents

ActiveRecord::Schema.define do
  create_table(:admin_people, :force => true) do |t|
    t.string :name
    t.timestamps
  end

  create_table(:animals, :force => true) do |t|
    t.string :name
    t.string :type
  end

  create_table(:articles, :force => true) do |t|
    t.string  :title
    t.text    :content
    t.boolean :published
    t.integer :user_id
    t.timestamps
  end

  create_table(:books, :force => true) do |t|
    t.string  :title
    t.string  :author
    t.integer :year
    t.string  :blurb_file
    t.boolean :delta, :default => true, :null => false
    t.timestamps
  end

  create_table(:books_genres, :force => true, :id => false) do |t|
    t.integer :book_id
    t.integer :genre_id
  end

  create_table(:cities, :force => true) do |t|
    t.string :name
    t.float  :lat
    t.float  :lng
  end

  create_table(:colours, :force => true) do |t|
    t.string :name
    t.timestamps
  end

  create_table(:genres, :force => true) do |t|
    t.string :name
  end

  create_table(:products, :force => true) do |t|
    t.string :name
  end

  create_table(:taggings, :force => true) do |t|
    t.integer :tag_id
    t.integer :article_id
    t.timestamps
  end

  create_table(:tags, :force => true) do |t|
    t.string :name
    t.timestamps
  end

  create_table(:tees, :force => true) do |t|
    t.integer :colour_id
    t.timestamps
  end

  create_table(:tweets, :force => true, :id => false) do |t|
    t.column :id, :bigint, :null => false
    t.string :text
    t.timestamps
  end

  create_table(:users, :force => true) do |t|
    t.string :name
    t.timestamps
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
thinking-sphinx-3.0.0	spec/internal/db/schema.rb
thinking-sphinx-3.0.0.rc	spec/internal/db/schema.rb