Sha256: 1594796254668806cb7c77ce7c40da7f67033a6132e7a081917823bbaf117927

Contents?: true

Size: 1.49 KB

Versions: 12

Compression:

Stored size: 1.49 KB

Contents

## define schema for words

begin 
  ActiveRecord::Schema.define do
  
    create_table "whowish_words", :force => false do |t|
      t.string "word_id", :null => false
      t.text  "content", :null => false
    end
    
  end

  ActiveRecord::Base.connection.execute("ALTER TABLE `whowish_words` ADD UNIQUE (`word_id`)")
  
  add_index :whowish_word_emails, :word_id

rescue Exception=>e
  puts "Create whowish_words failed: #{e}"
end

## define schema for emails
begin
  ActiveRecord::Schema.define do

    create_table "whowish_word_emails", :force => false do |t|
      t.string "word_id", :null => false
      t.text  "content", :null => false
    end

end

  ActiveRecord::Base.connection.execute("ALTER TABLE `whowish_word_emails` ADD UNIQUE (`word_id`)")

  add_index :whowish_word_emails, :word_id

rescue Exception=>e
  puts "Create whowish_words failed: #{e}"
end

## define schema for facebooks
begin
  ActiveRecord::Schema.define do

    create_table "whowish_word_facebooks", :force => false do |t|
      t.string "publish_id",     :null => false
      t.string  "message", :null => false
      t.string  "name", :null => false
      t.string  "caption", :null => false
      t.text  "description", :null => false
    end

  end

  ActiveRecord::Base.connection.execute("ALTER TABLE `whowish_word_facebooks` ADD UNIQUE (`publish_id`)")

  add_index :whowish_word_facebooks, :publish_id

rescue Exception=>e
  puts "Create whowish_words failed: #{e}"
end

Version data entries

12 entries across 12 versions & 1 rubygems

Version Path
whowish_word-0.2.1 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.2.0 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.9 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.8 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.7 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.6 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.5 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.4 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.3 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.2 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.1 lib/legacy/whowish_word/lib/db_migration/mysql.rb
whowish_word-0.1.0 lib/legacy/whowish_word/lib/db_migration/mysql.rb