class CreatePlatformTables
Public Class Methods
down()
click to toggle source
# File lib/generators/platform/templates/db/create_platform_tables.rb, line 233 def self.down drop_table :platform_developers drop_table :platform_applications drop_table :platform_application_logs drop_table :platform_application_metrics drop_table :platform_rollup_logs drop_table :platform_application_developers drop_table :platform_oauth_tokens drop_table :platform_ratings drop_table :platform_categories drop_table :platform_category_items drop_table :platform_forum_topics drop_table :platform_forum_messages drop_table :platform_permissions drop_table :platform_application_permissions drop_table :platform_application_users drop_table :platform_logged_exceptions end
up()
click to toggle source
# File lib/generators/platform/templates/db/create_platform_tables.rb, line 2 def self.up create_table :platform_developers do |t| t.integer :user_id, :limit => 8, :null => false t.string :name, :null => false t.text :about t.string :url t.string :email t.string :phone t.timestamps end add_index :platform_developers, :user_id, :name => 'platform_pd_u' add_index :platform_developers, :created_at, :name => 'platform_pd_c' create_table :platform_applications do |t| t.integer :developer_id t.string :name t.text :description t.string :state, :default => "new" t.string :locale t.string :url t.string :site_domain t.string :support_url t.string :callback_url t.string :contact_email t.string :privacy_policy_url t.string :terms_of_service_url t.string :permissions t.string :key t.string :secret t.integer :icon_id t.integer :logo_id t.string :canvas_name t.string :canvas_url t.boolean :auto_resize t.boolean :auto_login t.string :mobile_application_type t.string :ios_bundle_id t.string :itunes_app_store_id t.string :android_key_hash t.integer :rank t.boolean :auto_signin t.string :deauthorize_callback_url t.string :version t.string :api_version t.integer :parent_id t.timestamps end add_index :platform_applications, :developer_id, :name => 'platform_pa_d' add_index :platform_applications, :key, {:unique => true, :name => 'platform_pa_k'} add_index :platform_applications, :parent_id, :name => 'platform_pa_p' add_index :platform_applications, :created_at, :name => 'platform_pa_c' create_table :platform_application_logs do |t| t.integer :application_id t.integer :user_id t.string :event t.string :controller t.string :action t.string :request_method t.text :data t.string :user_agent t.integer :duration t.string :host t.string :country t.string :ip t.timestamps end add_index :platform_applications, :created_at, :name => 'platform_pal_c' add_index :platform_application_logs, [:application_id, :created_at], :name => 'platform_pal_ac' create_table :platform_application_metrics do |t| t.string :type t.timestamp :interval t.integer :application_id t.integer :active_user_count t.integer :new_user_count t.timestamps end add_index :platform_application_metrics, [:application_id, :interval], :name => "platform_pam_ai" add_index :platform_application_metrics, [:created_at], :name => "platform_pam_c" create_table :platform_application_usage_metrics do |t| t.string :type t.timestamp :interval t.integer :application_id t.string :event t.integer :count t.integer :avg_response_time t.integer :error_count t.timestamps end add_index :platform_application_usage_metrics, [:application_id, :interval], :name => "platform_paum_ai" add_index :platform_application_usage_metrics, [:created_at], :name => "platform_paum_c" create_table :platform_rollup_logs do |t| t.timestamp :interval t.timestamp :started_at t.timestamp :finished_at t.timestamps end add_index :platform_rollup_logs, :interval, :name => "platform_prl_i" add_index :platform_rollup_logs, [:created_at], :name => "platform_prl_c" create_table :platform_media do |t| t.string :type t.string :file_location t.string :content_type t.string :file_name t.timestamps end add_index :platform_media, [:type], :name => "platform_pm_t" add_index :platform_media, [:created_at], :name => "platform_pm_c" create_table :platform_application_developers do |t| t.integer :application_id t.integer :developer_id t.timestamps end add_index :platform_application_developers, :application_id, :name => "platform_pad_a" add_index :platform_application_developers, :developer_id, :name => "platform_pad_d" create_table :platform_oauth_tokens do |t| t.string :type t.integer :user_id, :limit=>8 t.integer :application_id t.string :token, :limit => 50 t.string :secret, :limit => 50 t.string :verifier, :limit => 20 t.string :callback_url t.string :scope t.timestamp :valid_to t.timestamp :authorized_at, :invalidated_at t.timestamps end add_index :platform_oauth_tokens, [:application_id, :type], :name => "platform_pot_at" add_index :platform_oauth_tokens, :token, {:unique => true, :name => "platform_pot_tu"} add_index :platform_oauth_tokens, :created_at, :name => "platform_pot_c" create_table :platform_ratings do |t| t.integer :user_id, :limit => 8, :null => false t.string :object_type t.integer :object_id t.integer :value t.text :comment t.timestamps end add_index :platform_ratings, :user_id, :name => "platform_pr_u" add_index :platform_ratings, [:object_type, :object_id], :name => "platform_pr_oo" create_table :platform_categories do |t| t.string :type t.string :name t.string :keyword t.integer :position t.date :enable_on t.date :disable_on t.integer :parent_id t.timestamps end add_index :platform_categories, :parent_id, :name => "platform_pc_p" create_table :platform_application_categories do |t| t.integer :category_id, :null => false t.integer :application_id, :null => false t.integer :position t.boolean :featured t.timestamps end add_index :platform_application_categories, :category_id, :name => "platform_pac_c" add_index :platform_application_categories, [:category_id, :application_id], :name => "platform_pac_ca" create_table :platform_forum_topics do |t| t.string :subject_type t.integer :subject_id t.integer :user_id, :null => false t.text :topic, :null => false t.timestamps end add_index :platform_forum_topics, [:subject_type, :subject_id], :name => "platform_pft_ss" add_index :platform_forum_topics, [:user_id], :name => "pftu", :name => "platform_pft_u" create_table :platform_forum_messages do |t| t.integer :forum_topic_id, :null => false t.integer :user_id, :null => false t.text :message, :null => false t.timestamps end add_index :platform_forum_messages, [:forum_topic_id], :name => "platform_pfm_f" add_index :platform_forum_messages, [:user_id], :name => "platform_pfm_u" create_table :platform_permissions do |t| t.string :keyword, :null => false t.text :description, :null => false t.timestamps end add_index :platform_permissions, [:keyword], :name => "platform_pp_k" create_table :platform_application_permissions do |t| t.integer :application_id t.integer :permission_id t.timestamps end add_index :platform_application_permissions, :application_id, :name => "platform_pap_a" create_table :platform_application_users do |t| t.integer :application_id, :null => false t.integer :user_id, :null => false t.text :data t.timestamps end add_index :platform_application_users, [:application_id], :name => "platform_pau_a" add_index :platform_application_users, [:user_id], :name => "platform_pau_u" create_table :platform_logged_exceptions do |t| t.column :exception_class, :string t.column :controller_name, :string t.column :action_name, :string t.column :server, :string t.column :message, :text t.column :backtrace, :text t.column :environment, :text t.column :request, :text t.column :session, :text t.column :cause, :binary t.column :user_id, :integer t.column :application_id, :integer t.timestamps end add_index :platform_logged_exceptions, [:created_at], :name => "platform_ple_c" end