Contents

ActiveRecord::Migration.verbose = false

ActiveRecord::Schema.define do

  create_table :assets, :force => true do |t|
    t.string :caption
    t.string :resource_type
    t.integer :resource_id
    t.integer :position
  end

  create_table :categories, :force => true do |t|
    t.string :name
    t.string :permalink
    t.text :description
    t.integer :position
  end

  create_table :comments, :force => true do |t|
    t.string :email, :name
    t.text :body
    t.integer :post_id
  end

  add_index :comments, :post_id

  create_table :pages, :force => true do |t|
    t.string :title
    t.text :body
    t.boolean :is_published
    t.integer :parent_id
  end

  create_table :posts, :force => true do |t|
    t.string :title
    t.text :body
    t.boolean :status
    t.integer :favorite_comment_id
    t.timestamps
    t.datetime :published_at
    t.integer :typus_user_id
  end

  create_table :typus_users, :force => true do |t|
    t.string :first_name, :default => "", :null => false
    t.string :last_name, :default => "", :null => false
    t.string :role, :null => false
    t.string :email, :null => false
    t.boolean :status, :default => false
    t.string :token, :null => false
    t.string :salt, :null => false
    t.string :crypted_password, :null => false
    t.timestamps
  end

  create_table :categories_posts, :force => true, :id => false do |t|
    t.column :category_id, :integer
    t.column :post_id, :integer
  end

  add_index :categories_posts, :category_id
  add_index :categories_posts, :post_id

end

Version data entries

27 entries across 27 versions & 2 rubygems

Version	Path
fesplugas-typus-0.9.0	test/schema.rb
fesplugas-typus-0.9.1	test/schema.rb
fesplugas-typus-0.9.10	test/schema.rb
fesplugas-typus-0.9.11	test/schema.rb
fesplugas-typus-0.9.12	test/schema.rb
fesplugas-typus-0.9.13	test/schema.rb
fesplugas-typus-0.9.14	test/schema.rb
fesplugas-typus-0.9.15	test/schema.rb
fesplugas-typus-0.9.16	test/schema.rb
fesplugas-typus-0.9.17	test/schema.rb
fesplugas-typus-0.9.2	test/schema.rb
fesplugas-typus-0.9.3	test/schema.rb
fesplugas-typus-0.9.4	test/schema.rb
fesplugas-typus-0.9.5	test/schema.rb
fesplugas-typus-0.9.6	test/schema.rb
fesplugas-typus-0.9.7	test/schema.rb
fesplugas-typus-0.9.8	test/schema.rb
fesplugas-typus-0.9.9	test/schema.rb
typus-0.9.25	test/schema.rb
typus-0.9.24	test/schema.rb