-
Benjamin Neff a rédigé
closes #7580
Benjamin Neff a rédigécloses #7580
0000_create_schema.rb 29,72 Kio
class CreateSchema < ActiveRecord::Migration[4.2]
# rubocop:disable Metrics/AbcSize, Metrics/MethodLength, Metrics/LineLength, Layout/ExtraSpacing
def up
create_table :account_deletions do |t|
t.string :diaspora_handle
t.integer :person_id
t.datetime :completed_at
end
create_table :aspect_memberships do |t|
t.integer :aspect_id, null: false
t.integer :contact_id, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :aspect_memberships, %i[aspect_id contact_id], name: :index_aspect_memberships_on_aspect_id_and_contact_id, unique: true
add_index :aspect_memberships, :aspect_id, name: :index_aspect_memberships_on_aspect_id
add_index :aspect_memberships, :contact_id, name: :index_aspect_memberships_on_contact_id
create_table :aspect_visibilities do |t|
t.integer :shareable_id, null: false
t.integer :aspect_id, null: false
t.string :shareable_type, default: "Post", null: false
end
add_index :aspect_visibilities, :aspect_id, name: :index_aspect_visibilities_on_aspect_id
add_index :aspect_visibilities, %i[shareable_id shareable_type aspect_id], name: :shareable_and_aspect_id, length: {shareable_type: 189}
add_index :aspect_visibilities, %i[shareable_id shareable_type], name: :index_aspect_visibilities_on_shareable_id_and_shareable_type, length: {shareable_type: 190}
create_table :aspects do |t|
t.string :name, null: false
t.integer :user_id, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.boolean :contacts_visible, default: true, null: false
t.integer :order_id
t.boolean :chat_enabled, default: false
end
add_index :aspects, %i[user_id contacts_visible], name: :index_aspects_on_user_id_and_contacts_visible
add_index :aspects, :user_id, name: :index_aspects_on_user_id
create_table :authorizations do |t|
t.integer :user_id
t.integer :o_auth_application_id
t.string :refresh_token
t.string :code
t.string :redirect_uri
t.string :nonce
t.string :scopes
t.boolean :code_used, default: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :authorizations, :user_id, name: :index_authorizations_on_user_id
add_index :authorizations, :o_auth_application_id, name: :index_authorizations_on_o_auth_application_id
create_table :blocks do |t|
t.integer :user_id
t.integer :person_id
end
create_table :chat_contacts do |t|
t.integer :user_id, null: false
## JID <= 3071 bytes http://tools.ietf.org/html/rfc6122
t.string :jid, null: false
t.string :name, limit: 255, null: true
t.string :ask, limit: 128, null: true t.string :subscription, limit: 128, null: false
end
add_index :chat_contacts, %i[user_id jid], name: :index_chat_contacts_on_user_id_and_jid, length: {jid: 190}, unique: true
create_table :chat_fragments do |t|
t.integer :user_id, null: false
t.string :root, limit: 256, null: false
t.string :namespace, limit: 256, null: false
t.text :xml, null: false
end
add_index :chat_fragments, :user_id, name: :index_chat_fragments_on_user_id, unique: true
create_table :chat_offline_messages do |t|
t.string :from, null: false
t.string :to, null: false
t.text :message, null: false
t.datetime :created_at, null: false
end
create_table :comment_signatures, id: false do |t|
t.integer :comment_id, null: false
t.text :author_signature, null: false
t.integer :signature_order_id, null: false
t.text :additional_data
end
add_index :comment_signatures, :comment_id, name: :index_comment_signatures_on_comment_id, unique: true
create_table :comments do |t|
t.text :text, null: false
t.integer :commentable_id, null: false
t.integer :author_id, null: false
t.string :guid, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.integer :likes_count, default: 0, null: false
t.string :commentable_type, limit: 60, default: "Post", null: false
end
add_index :comments, :author_id, name: :index_comments_on_person_id
add_index :comments, %i[commentable_id commentable_type], name: :index_comments_on_commentable_id_and_commentable_type
add_index :comments, :guid, name: :index_comments_on_guid, length: {guid: 191}, unique: true
create_table :contacts do |t|
t.integer :user_id, null: false
t.integer :person_id, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.boolean :sharing, default: false, null: false
t.boolean :receiving, default: false, null: false
end
add_index :contacts, :person_id, name: :index_contacts_on_person_id
add_index :contacts, %i[user_id person_id], name: :index_contacts_on_user_id_and_person_id, unique: true
create_table :conversation_visibilities do |t|
t.integer :conversation_id, null: false
t.integer :person_id, null: false
t.integer :unread, default: 0, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :conversation_visibilities, %i[conversation_id person_id], name: :index_conversation_visibilities_usefully, unique: true
add_index :conversation_visibilities, :conversation_id, name: :index_conversation_visibilities_on_conversation_id
add_index :conversation_visibilities, :person_id, name: :index_conversation_visibilities_on_person_id
create_table :conversations do |t| t.string :subject
t.string :guid, null: false
t.integer :author_id, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :conversations, :guid, name: :index_conversations_on_guid, length: 191, unique: true
add_index :conversations, :author_id, name: :conversations_author_id_fk
create_table :invitation_codes do |t|
t.string :token
t.integer :user_id
t.integer :count
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
create_table :like_signatures, id: false do |t|
t.integer :like_id, null: false
t.text :author_signature, null: false
t.integer :signature_order_id, null: false
t.text :additional_data
end
add_index :like_signatures, :like_id, name: :index_like_signatures_on_like_id, unique: true
create_table :likes do |t|
t.boolean :positive, default: true
t.integer :target_id
t.integer :author_id
t.string :guid
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.string :target_type, limit: 60, null: false
end
add_index :likes, :author_id, name: :likes_author_id_fk
add_index :likes, :guid, name: :index_likes_on_guid, length: {guid: 191}, unique: true
add_index :likes, %i[target_id author_id target_type], name: :index_likes_on_target_id_and_author_id_and_target_type, unique: true
add_index :likes, :target_id, name: :index_likes_on_post_id
create_table :locations do |t|
t.string :address
t.string :lat
t.string :lng
t.integer :status_message_id
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
create_table :mentions do |t|
t.integer :post_id, null: false
t.integer :person_id, null: false
end
add_index :mentions, %i[person_id post_id], name: :index_mentions_on_person_id_and_post_id, unique: true
add_index :mentions, :person_id, name: :index_mentions_on_person_id
add_index :mentions, :post_id, name: :index_mentions_on_post_id
create_table :messages do |t|
t.integer :conversation_id, null: false
t.integer :author_id, null: false
t.string :guid, null: false
t.text :text, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.text :author_signature
end
add_index :messages, :guid, name: :index_messages_on_guid, length: 191, unique: true
add_index :messages, :author_id, name: :index_messages_on_author_id
add_index :messages, :conversation_id, name: :messages_conversation_id_fk
create_table :notification_actors do |t|
t.integer :notification_id
t.integer :person_id
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :notification_actors, %i[notification_id person_id], name: :index_notification_actors_on_notification_id_and_person_id, unique: true
add_index :notification_actors, :notification_id, name: :index_notification_actors_on_notification_id
add_index :notification_actors, :person_id, name: :index_notification_actors_on_person_id
create_table :notifications do |t|
t.string :target_type
t.integer :target_id
t.integer :recipient_id, null: false
t.boolean :unread, default: true, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.string :type
end
add_index :notifications, :recipient_id, name: :index_notifications_on_recipient_id
add_index :notifications, :target_id, name: :index_notifications_on_target_id
add_index :notifications, %i[target_type target_id], name: :index_notifications_on_target_type_and_target_id, length: {target_type: 190}
create_table :o_auth_access_tokens do |t|
t.integer :authorization_id
t.string :token
t.datetime :expires_at
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :o_auth_access_tokens, :authorization_id, name: :index_o_auth_access_tokens_on_authorization_id
add_index :o_auth_access_tokens, :token, name: :index_o_auth_access_tokens_on_token, length: {token: 191}, unique: true
create_table :o_auth_applications do |t|
t.integer :user_id
t.string :client_id
t.string :client_secret
t.string :client_name
t.text :redirect_uris
t.string :response_types
t.string :grant_types
t.string :application_type, default: "web"
t.string :contacts
t.string :logo_uri
t.string :client_uri
t.string :policy_uri
t.string :tos_uri
t.string :sector_identifier_uri
t.string :token_endpoint_auth_method
t.text :jwks
t.string :jwks_uri
t.boolean :ppid, default: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :o_auth_applications, :user_id, name: :index_o_auth_applications_on_user_id
add_index :o_auth_applications, :client_id, name: :index_o_auth_applications_on_client_id, length: {client_id: 191}, unique: true
create_table :open_graph_caches do |t|
t.string :title
t.string :ob_type
t.text :image t.text :url
t.text :description
end
create_table :o_embed_caches do |t|
t.string :url, limit: 1024, null: false
t.text :data, null: false
end
add_index :o_embed_caches, :url, name: :index_o_embed_caches_on_url, length: {url: 191}
create_table :participations do |t|
t.string :guid
t.integer :target_id
t.string :target_type, limit: 60, null: false
t.integer :author_id
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.integer :count, default: 1, null: false
end
add_index :participations, :guid, name: :index_participations_on_guid, length: {guid: 191}
add_index :participations, :author_id, name: :index_participations_on_author_id
add_index :participations, %i[target_id target_type author_id], name: :index_participations_on_target_id_and_target_type_and_author_id, unique: true
create_table :people do |t|
t.string :guid, null: false
t.string :diaspora_handle, null: false
t.text :serialized_public_key, null: false
t.integer :owner_id
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.boolean :closed_account, default: false
t.integer :fetch_status, default: 0
t.integer :pod_id
end
add_index :people, :diaspora_handle, name: :index_people_on_diaspora_handle, unique: true, length: {diaspora_handle: 191}
add_index :people, :guid, name: :index_people_on_guid, length: {guid: 191}, unique: true
add_index :people, :owner_id, name: :index_people_on_owner_id, unique: true
create_table :photos do |t|
t.integer :author_id, null: false
t.boolean :public, default: false, null: false
t.string :guid, null: false
t.boolean :pending, default: false, null: false
t.text :text
t.text :remote_photo_path
t.string :remote_photo_name
t.string :random_string
t.string :processed_image
t.datetime :created_at
t.datetime :updated_at
t.string :unprocessed_image
t.string :status_message_guid
t.integer :comments_count
t.integer :height
t.integer :width
end
add_index :photos, :guid, name: :index_photos_on_guid, length: 191, unique: true
add_index :photos, :status_message_guid, name: :index_photos_on_status_message_guid, length: {status_message_guid: 191}
create_table :pods do |t|
t.string :host
t.boolean :ssl
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.integer :status, default: 0
t.datetime :checked_at, default: Time.zone.at(0) t.datetime :offline_since, default: nil
t.integer :response_time, default: -1
t.string :software
t.string :error
t.integer :port
t.boolean :blocked, default: false
end
add_index :pods, :status, name: :index_pods_on_status
add_index :pods, :checked_at, name: :index_pods_on_checked_at
add_index :pods, :offline_since, name: :index_pods_on_offline_since
add_index :pods, %i[host port], name: :index_pods_on_host_and_port, length: {host: 190}, unique: true
create_table :poll_answers do |t|
t.string :answer, null: false
t.integer :poll_id, null: false
t.string :guid
t.integer :vote_count, default: 0
end
add_index :poll_answers, :guid, name: :index_poll_answers_on_guid, length: 191, unique: true
add_index :poll_answers, :poll_id, name: :index_poll_answers_on_poll_id
create_table :poll_participation_signatures, id: false do |t|
t.integer :poll_participation_id, null: false
t.text :author_signature, null: false
t.integer :signature_order_id, null: false
t.text :additional_data
end
add_index :poll_participation_signatures, :poll_participation_id, name: :index_poll_participation_signatures_on_poll_participation_id, unique: true
create_table :poll_participations do |t|
t.integer :poll_answer_id, null: false
t.integer :author_id, null: false
t.integer :poll_id, null: false
t.string :guid
t.timestamps
end
add_index :poll_participations, :guid, name: :index_poll_participations_on_guid, length: 191, unique: true
add_index :poll_participations, :poll_id, name: :index_poll_participations_on_poll_id
create_table :polls do |t|
t.string :question, null: false
t.integer :status_message_id, null: false
t.boolean :status
t.string :guid
t.timestamps
end
add_index :polls, :guid, name: :index_polls_on_guid, length: 191, unique: true
add_index :polls, :status_message_id, name: :index_polls_on_status_message_id
create_table :posts do |t|
t.integer :author_id, null: false
t.boolean :public, default: false, null: false
t.string :guid, null: false
t.string :type, limit: 40, null: false
t.text :text
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.string :provider_display_name
t.string :root_guid
t.integer :likes_count, default: 0
t.integer :comments_count, default: 0
t.integer :o_embed_cache_id
t.integer :reshares_count, default: 0
t.datetime :interacted_at
t.string :facebook_id t.string :tweet_id
t.integer :open_graph_cache_id
t.text :tumblr_ids
end
add_index :posts, %i[id type], name: :index_posts_on_id_and_type
add_index :posts, %i[author_id root_guid], name: :index_posts_on_author_id_and_root_guid, length: {root_guid: 190}, unique: true
add_index :posts, :author_id, name: :index_posts_on_person_id
add_index :posts, :guid, name: :index_posts_on_guid, length: {guid: 191}, unique: true
add_index :posts, %i[id type created_at], name: :index_posts_on_id_and_type_and_created_at
add_index :posts, :root_guid, name: :index_posts_on_root_guid, length: {root_guid: 191}
add_index :posts, :tweet_id, name: :index_posts_on_tweet_id, length: {tweet_id: 191}
create_table :ppid do |t|
t.integer :o_auth_application_id
t.integer :user_id
t.string :guid, limit: 32
t.string :string, limit: 32
t.string :identifier
end
add_index :ppid, :o_auth_application_id, name: :index_ppid_on_o_auth_application_id
add_index :ppid, :user_id, name: :index_ppid_on_user_id
create_table :profiles do |t|
t.string :diaspora_handle
t.string :first_name, limit: 127
t.string :last_name, limit: 127
t.string :image_url
t.string :image_url_small
t.string :image_url_medium
t.date :birthday
t.string :gender
t.text :bio
t.boolean :searchable, default: true, null: false
t.integer :person_id, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.string :location
t.string :full_name, limit: 70
t.boolean :nsfw, default: false
t.boolean :public_details, default: false
end
add_index :profiles, %i[full_name searchable], name: :index_profiles_on_full_name_and_searchable
add_index :profiles, :full_name, name: :index_profiles_on_full_name
add_index :profiles, :person_id, name: :index_profiles_on_person_id
create_table :rails_admin_histories do |t|
t.text :message
t.string :username
t.integer :item
t.string :table
t.integer :month, limit: 2
t.integer :year, limit: 8
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :rails_admin_histories, %i[item table month year], name: :index_rails_admin_histories, length: {table: 188}
create_table :reports do |t|
t.integer :item_id, null: false
t.string :item_type, null: false
t.boolean :reviewed, default: false
t.text :text
t.timestamps
t.integer :user_id, null: false
end
add_index :reports, :item_id, name: :index_reports_on_item_id
create_table :roles do |t|
t.integer :person_id
t.string :name
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
create_table :services do |t|
t.string :type, limit: 127, null: false
t.integer :user_id, null: false
t.string :uid, limit: 127
t.string :access_token
t.string :access_secret
t.string :nickname
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :services, %i[type uid], name: :index_services_on_type_and_uid, length: {type: 64, uid: 127}
add_index :services, :user_id, name: :index_services_on_user_id
create_table :share_visibilities do |t|
t.integer :shareable_id, null: false
t.boolean :hidden, default: false, null: false
t.string :shareable_type, limit: 60, default: "Post", null: false
t.integer :user_id, null: false
end
add_index :share_visibilities, :user_id, name: :index_share_visibilities_on_user_id
add_index :share_visibilities, %i[shareable_id shareable_type user_id], name: :shareable_and_user_id
add_index :share_visibilities, %i[shareable_id shareable_type hidden user_id], name: :shareable_and_hidden_and_user_id
add_index :share_visibilities, :shareable_id, name: :index_post_visibilities_on_post_id
create_table :signature_orders do |t|
t.string :order, null: false
end
add_index :signature_orders, :order, name: :index_signature_orders_on_order, length: 191, unique: true
create_table :simple_captcha_data do |t|
t.string :key, limit: 40
t.string :value, limit: 12
t.timestamps
end
add_index :simple_captcha_data, :key, name: :idx_key
create_table :tag_followings do |t|
t.integer :tag_id, null: false
t.integer :user_id, null: false
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
add_index :tag_followings, %i[tag_id user_id], name: :index_tag_followings_on_tag_id_and_user_id, unique: true
add_index :tag_followings, :tag_id, name: :index_tag_followings_on_tag_id
add_index :tag_followings, :user_id, name: :index_tag_followings_on_user_id
create_table :taggings do |t|
t.integer :tag_id
t.integer :taggable_id
t.string :taggable_type, limit: 127
t.integer :tagger_id
t.string :tagger_type, limit: 127
t.string :context, limit: 127
t.datetime :created_at
end
add_index :taggings, :created_at, name: :index_taggings_on_created_at
add_index :taggings, :tag_id, name: :index_taggings_on_tag_id
add_index :taggings, %i[taggable_id taggable_type context], name: :index_taggings_on_taggable_id_and_taggable_type_and_context, length: {taggable_type: 95, context: 95}
add_index :taggings, %i[taggable_id taggable_type tag_id], name: :index_taggings_uniquely, unique: true
create_table :tags do |t|
t.string :name
t.integer :taggings_count, default: 0
end
add_index :tags, :name, name: :index_tags_on_name, unique: true, length: {name: 191}
create_table :user_preferences do |t|
t.string :email_type
t.integer :user_id
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
end
create_table :users do |t|
t.string :username, null: false
t.text :serialized_private_key
t.boolean :getting_started, default: true, null: false
t.boolean :disable_mail, default: false, null: false
t.string :language
t.string :email, default: "", null: false
t.string :encrypted_password, default: "", null: false
t.string :reset_password_token
t.datetime :remember_created_at
t.integer :sign_in_count, default: 0
t.datetime :current_sign_in_at
t.datetime :last_sign_in_at
t.string :current_sign_in_ip
t.string :last_sign_in_ip
t.datetime :created_at, null: false
t.datetime :updated_at, null: false
t.integer :invited_by_id
t.string :authentication_token, limit: 30
t.string :unconfirmed_email
t.string :confirm_email_token, limit: 30
t.datetime :locked_at
t.boolean :show_community_spotlight_in_stream, default: true, null: false
t.boolean :auto_follow_back, default: false
t.integer :auto_follow_back_aspect_id
t.text :hidden_shareables
t.datetime :reset_password_sent_at
t.datetime :last_seen
t.datetime :remove_after
t.string :export
t.datetime :exported_at
t.boolean :exporting, default: false
t.boolean :strip_exif, default: true
t.string :exported_photos_file
t.datetime :exported_photos_at
t.boolean :exporting_photos, default: false
t.string :color_theme
end
add_index :users, :authentication_token, name: :index_users_on_authentication_token, unique: true
add_index :users, :username, name: :index_users_on_username, length: {username: 191}, unique: true
add_index :users, :email, name: :index_users_on_email, length: {email: 191}, unique: true
add_foreign_key :aspect_memberships, :aspects, name: :aspect_memberships_aspect_id_fk, on_delete: :cascade
add_foreign_key :aspect_memberships, :contacts, name: :aspect_memberships_contact_id_fk, on_delete: :cascade
add_foreign_key :aspect_visibilities, :aspects, name: :aspect_visibilities_aspect_id_fk, on_delete: :cascade
add_foreign_key :authorizations, :users
add_foreign_key :authorizations, :o_auth_applications
add_foreign_key :comment_signatures, :comments, name: :comment_signatures_comment_id_fk, on_delete: :cascade
add_foreign_key :comment_signatures, :signature_orders, name: :comment_signatures_signature_orders_id_fk
add_foreign_key :comments, :people, name: :comments_author_id_fk, column: :author_id, on_delete: :cascade
add_foreign_key :contacts, :people, name: :contacts_person_id_fk, on_delete: :cascade
add_foreign_key :conversation_visibilities, :conversations, name: :conversation_visibilities_conversation_id_fk, on_delete: :cascade
add_foreign_key :conversation_visibilities, :people, name: :conversation_visibilities_person_id_fk, on_delete: :cascade
add_foreign_key :conversations, :people, name: :conversations_author_id_fk, column: :author_id, on_delete: :cascade
add_foreign_key :like_signatures, :likes, name: :like_signatures_like_id_fk, on_delete: :cascade
add_foreign_key :like_signatures, :signature_orders, name: :like_signatures_signature_orders_id_fk
add_foreign_key :likes, :people, name: :likes_author_id_fk, column: :author_id, on_delete: :cascade
add_foreign_key :messages, :conversations, name: :messages_conversation_id_fk, on_delete: :cascade
add_foreign_key :messages, :people, name: :messages_author_id_fk, column: :author_id, on_delete: :cascade
add_foreign_key :notification_actors, :notifications, name: :notification_actors_notification_id_fk, on_delete: :cascade
add_foreign_key :o_auth_access_tokens, :authorizations
add_foreign_key :o_auth_applications, :users
add_foreign_key :people, :pods, name: :people_pod_id_fk, on_delete: :cascade
add_foreign_key :poll_participation_signatures, :poll_participations, name: :poll_participation_signatures_poll_participation_id_fk, on_delete: :cascade
add_foreign_key :poll_participation_signatures, :signature_orders, name: :poll_participation_signatures_signature_orders_id_fk
add_foreign_key :posts, :people, name: :posts_author_id_fk, column: :author_id, on_delete: :cascade
add_foreign_key :ppid, :o_auth_applications
add_foreign_key :ppid, :users
add_foreign_key :profiles, :people, name: :profiles_person_id_fk, on_delete: :cascade
add_foreign_key :services, :users, name: :services_user_id_fk, on_delete: :cascade
add_foreign_key :share_visibilities, :users, name: :share_visibilities_user_id_fk, on_delete: :cascade
end
# rubocop:enable Metrics/AbcSize, Metrics/MethodLength, Metrics/LineLength, Layout/ExtraSpacing
end