Sha256: 4546fe4d4d79874c22e88466db3df4c908fd275d5c8e7992d1982a988e405e89

Contents?: true

Size: 1.1 KB

Versions: 7

Compression:

Stored size: 1.1 KB

Contents

ActiveRecord::Schema.define do
 
  create_table :test_myisam, :options=>'ENGINE=MyISAM', :force=>true do |t|
    t.column :my_name, :string, :null=>false
    t.column :description, :string
  end
  
  create_table :test_innodb, :options=>'ENGINE=InnoDb', :force=>true do |t|
    t.column :my_name, :string, :null=>false
    t.column :description, :string
  end

  create_table :test_memory, :options=>'ENGINE=Memory', :force=>true do |t|
    t.column :my_name, :string, :null=>false
    t.column :description, :string
  end
  
  create_table :books, :options=>'ENGINE=MyISAM', :force=>true do |t|
    t.column :title, :string, :null=>false
    t.column :publisher, :string, :null=>false, :default => 'Default Publisher'
    t.column :author_name, :string, :null=>false
    t.column :created_at, :datetime
    t.column :created_on, :datetime
    t.column :updated_at, :datetime
    t.column :updated_on, :datetime
    t.column :publish_date, :date
    t.column :topic_id, :integer
    t.column :for_sale, :boolean, :default => true
  end
  execute "ALTER TABLE books ADD FULLTEXT( `title`, `publisher`, `author_name` )"

end

Version data entries

7 entries across 7 versions & 3 rubygems

Version Path
ar-extensions-0.9.5 db/migrate/mysql_schema.rb
ar-extensions-0.9.4 db/migrate/mysql_schema.rb
ghazel-ar-extensions-0.9.3.2 db/migrate/mysql_schema.rb
ghazel-ar-extensions-0.9.3.1 db/migrate/mysql_schema.rb
ghazel-ar-extensions-0.9.3 db/migrate/mysql_schema.rb
ar-extensions-0.9.3 db/migrate/mysql_schema.rb
Empact-ar-extensions-0.9.2 db/migrate/mysql_schema.rb