class GluttonbergMigration < ActiveRecord::Migration
  def self.up

    create_table :gb_plain_text_content_localizations do |t|
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :page_localization_id, :integer
      t.column :text, :string, :limit => 255
      t.column :plain_text_content_id, :integer
      t.column :version, :integer
    end

    create_table :gb_html_contents do |t|
      t.column :orphaned, :boolean, :default => false
      t.column :section_name, :string, :limit => 50
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :page_id, :integer
    end

    create_table :gb_html_content_localizations do |t|
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :text, :text
      t.column :html_content_id, :integer
      t.column :page_localization_id, :integer
      t.column :version, :integer
    end

    create_table :gb_image_contents do |t|
      t.column :orphaned, :boolean, :default => false
      t.column :section_name, :string, :limit => 50
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :asset_id, :integer
      t.column :page_id, :integer
      t.column :version, :integer
    end

    create_table :gb_locales do |t|
      t.column :name, :string, :limit => 70, :null => false
      t.column :slug, :string, :limit => 70, :null => false
      t.column :slug_type, :string, :limit => 70, :null => false # prefix , subdomain
      t.column :default, :boolean, :default => false
    end

    create_table :gb_settings do |t|
      t.column :name, :string, :limit => 50, :null => false
      t.column :value, :text
      t.column :category, :integer, :default => 1
      t.column :row, :integer
      t.column :delete_able, :boolean, :default => true
      t.column :enabled, :boolean, :default => true
      t.column :help, :text
      t.column :values_list, :text
    end

    create_table :gb_page_localizations do |t|
      t.column :name, :string, :limit => 150
      t.column :navigation_label, :string, :limit => 100
      t.column :slug, :string, :limit => 50
      t.column :path, :string, :limit => 255
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :locale_id, :integer
      t.column :page_id, :integer
      t.column :seo_title , :string , :limit => 255
      t.column :seo_keywords , :text
      t.column :seo_description , :text
      t.column :fb_icon_id , :integer
      t.column :previous_path , :string
    end

    create_table :gb_pages do |t|
      t.column :parent_id, :integer
      t.column :name, :string, :limit => 100
      t.column :navigation_label, :string, :limit => 100
      t.column :slug, :string, :limit => 100
      t.column :description_name, :string, :limit => 100
      t.column :home, :boolean, :default => false
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :position, :integer
      t.column :user_id, :integer
      t.column :state, :string
      t.column :hide_in_nav, :boolean
      t.datetime :published_at
    end

    create_table :gb_plain_text_contents do |t|
      t.column :orphaned, :boolean, :default => false
      t.column :section_name, :string, :limit => 50
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :page_id, :integer
    end

    create_table :gb_asset_categories do |t|
      t.column :name, :string, :null => false
      t.column :unknown, :boolean
    end

    create_table :gb_asset_types do |t|
      t.column :name, :string, :null => false
      t.column :asset_category_id, :integer, :default => 0
    end

    create_table :gb_asset_mime_types do |t|
      t.column :mime_type, :string, :null => false
      t.column :asset_type_id, :integer, :default => 0
    end

    create_table :gb_asset_collections do |t|
      t.column :name, :string, :null => false
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
      t.column :created_by, :integer
      t.column :updated_by, :integer
      t.column :user_id, :integer
    end

    create_table :gb_assets do |t|
      t.column :mime_type, :string
      t.column :asset_type_id, :integer
      t.column :name, :string, :null => false
      t.column :description, :text
      t.column :file_name, :string
      t.column :asset_hash, :string
      t.column :size, :integer
      t.column :custom_thumbnail, :boolean
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
      t.column :synopsis, :text
      t.column :copyrights, :text
      t.column :year_of_production, :integer
      t.column :created_by, :integer
      t.column :updated_by, :integer
      t.column :duration, :string
      t.column :user_id, :integer
      t.column :width, :integer
      t.column :height, :integer
      t.column :alt, :string
      t.column :processed , :boolean
      t.column :copied_to_s3 , :boolean
    end

    create_table :gb_audio_asset_attributes do |t|
      t.integer :asset_id , :null => false
      t.float   :length
      t.string  :title
      t.string  :artist
      t.string  :album
      t.string  :tracknum
      t.string  :genre
      t.timestamps
    end

    create_table :gb_asset_collections_assets , :id => false do |t|
      t.column :asset_collection_id, :integer, :null => false
      t.column :asset_id, :integer, :null => false
    end

    create_table :gb_users do |t|
      t.string :first_name, :null => false
      t.string :last_name
      t.string :email, :null => false
      t.string :crypted_password, :null => false
      t.string :password_salt, :null => false
      t.string :persistence_token, :null => false
      t.string :single_access_token, :null => false
      t.string :perishable_token, :null => false
      t.integer :login_count, :null => false, :default => 0
      t.string :role, :null => false
      t.text :bio
      t.integer :image_id
      t.integer :position
      t.timestamps
    end


    begin
      Gluttonberg::PlainTextContentLocalization.create_versioned_table
    rescue => e
      puts e
    end
    begin
      Gluttonberg::HtmlContentLocalization.create_versioned_table
    rescue => e
      puts e
    end

    begin
      Gluttonberg::ImageContent.create_versioned_table
    rescue => e
      puts e
    end

    create_table :tags do |t|
      t.string :name
      t.string :slug
    end

    create_table :taggings do |t|
      t.references :tag

      # You should make sure that the column created is
      # long enough to store the required class names.
      t.references :taggable, :polymorphic => true
      t.references :tagger, :polymorphic => true

      t.string :context

      t.datetime :created_at
    end

    add_index :taggings, :tag_id
    add_index :taggings, [:taggable_id, :taggable_type, :context]

    create_table :delayed_jobs, :force => true do |table|
      table.integer  :priority, :default => 0
      table.integer  :attempts, :default => 0
      table.text     :handler
      table.text     :last_error
      table.datetime :run_at
      table.datetime :locked_at
      table.datetime :failed_at
      table.string   :locked_by
      table.timestamps
    end
    add_index :delayed_jobs, [:priority, :run_at], :name => 'delayed_jobs_priority'

    create_table :flags, :force => true do |t|
      t.integer :user_id
      t.integer :flaggable_id
      t.string  :flaggable_type
      t.integer :flaggable_user_id
      t.string  :reason
      t.string  :url
      t.text    :description
      t.boolean :approved
      t.boolean :moderation_required
      t.timestamps
    end

    create_table :gb_asset_thumbnails do |t|
      t.column :asset_id, :integer
      t.column :thumbnail_type, :string, :limit => 100
      t.column :user_generated , :boolean
      t.column :created_at, :datetime
      t.column :updated_at, :datetime
    end

    create_table :gb_stylesheets do |t|
      t.column :name , :string , :limit => 255
      t.column :slug , :string , :limit => 255
      t.column :value, :text
      t.column :css_prefix , :string , :limit => 255
      t.column :css_postfix , :string , :limit => 255
      t.column :position , :integer
      t.timestamps
    end

    begin
      Gluttonberg::Stylesheet.create_versioned_table
    rescue => e
      puts e
    end

    create_table :gb_members do |t|
      t.string :first_name, :null => false
      t.string :last_name
      t.string :email, :null => false
      t.string :crypted_password, :null => false
      t.string :password_salt, :null => false
      t.string :persistence_token, :null => false
      t.string :single_access_token, :null => false
      t.string :perishable_token, :null => false
      t.integer :login_count, :null => false, :default => 0
      t.text :bio
      t.string :image_file_name
      t.string :image_content_type
      t.integer :image_file_size
      t.boolean :profile_confirmed,  :default => false
      t.boolean :welcome_email_sent,  :default => false
      t.string :confirmation_key
      t.boolean :can_login , :default => true
      t.timestamps
    end

    create_table :gb_groups do |t|
      t.string :name, :null => false
      t.string :description
      t.integer :position
      t.boolean :default,  :default => false
      t.timestamps
    end

    create_table :gb_groups_members , :id => false do |t|
      t.integer :member_id, :null => false
      t.integer :group_id , :null => false
    end

    create_table :gb_groups_pages , :id => false do |t|
      t.integer :page_id, :null => false
      t.integer :group_id , :null => false
    end

    create_table :gb_galleries do |t|
      t.column :title , :string , :limit => 255
      t.column :description, :text
      t.integer :user_id, :null => false
      t.column :slug , :string
      t.column :state , :string
      t.datetime :published_at
      t.boolean :collection_imported , :default => false
      t.timestamps
    end

    create_table :gb_gallery_images do |t|
      t.integer :gallery_id, :null => false
      t.integer :asset_id, :null => false
      t.integer :position, :null => false
      t.timestamps
    end

    create_table :gb_feeds do |t|
      t.integer :feedable_id
      t.string  :feedable_type
      t.string  :title
      t.string  :action_type
      t.integer :user_id
      t.timestamps
    end

  end

  def self.down
    drop_table :gb_plain_text_content_localizations
    drop_table :gb_html_contents
    drop_table :gb_html_content_localizations
    drop_table :gb_image_contents
    drop_table :gb_users
    drop_table :gb_locales
    drop_table :gb_settings
    drop_table :gb_page_localizations
    drop_table :gb_pages
    drop_table :gb_plain_text_contents
    drop_table :gb_asset_categories
    drop_table :gb_asset_types
    drop_table :gb_asset_mime_types
    drop_table :gb_asset_collections
    drop_table :gb_assets
    drop_table :gb_asset_collections_assets
    drop_table :gb_audio_asset_attributes
    drop_table :taggings
    drop_table :tags
    drop_table :delayed_jobs
    drop_table :flags
    drop_table :gb_asset_thumbnails
    drop_table :gb_stylesheets
    drop_table :gb_groups
    drop_table :gb_groups_members
    drop_table :gb_groups_pages
    drop_table :gb_galleries
    drop_table :gb_gallery_images
    drop_table :gb_feeds
  end
end