From 709c6685a90bb819696566cc9e42e587546d72dc Mon Sep 17 00:00:00 2001 From: Eugen Rochko Date: Mon, 22 Feb 2016 16:00:20 +0100 Subject: Made some progress --- db/migrate/20160221003140_create_users.rb | 12 ++++++++++++ db/migrate/20160221003621_create_follows.rb | 12 ++++++++++++ db/migrate/20160222122600_create_stream_entries.rb | 11 +++++++++++ db/migrate/20160222143943_add_profile_fields_to_accounts.rb | 7 +++++++ 4 files changed, 42 insertions(+) create mode 100644 db/migrate/20160221003140_create_users.rb create mode 100644 db/migrate/20160221003621_create_follows.rb create mode 100644 db/migrate/20160222122600_create_stream_entries.rb create mode 100644 db/migrate/20160222143943_add_profile_fields_to_accounts.rb (limited to 'db/migrate') diff --git a/db/migrate/20160221003140_create_users.rb b/db/migrate/20160221003140_create_users.rb new file mode 100644 index 000000000..c9750c623 --- /dev/null +++ b/db/migrate/20160221003140_create_users.rb @@ -0,0 +1,12 @@ +class CreateUsers < ActiveRecord::Migration + def change + create_table :users do |t| + t.string :email, null: false, default: '' + t.integer :account_id, null: false + + t.timestamps null: false + end + + add_index :users, :email, unique: true + end +end diff --git a/db/migrate/20160221003621_create_follows.rb b/db/migrate/20160221003621_create_follows.rb new file mode 100644 index 000000000..afec3dee0 --- /dev/null +++ b/db/migrate/20160221003621_create_follows.rb @@ -0,0 +1,12 @@ +class CreateFollows < ActiveRecord::Migration + def change + create_table :follows do |t| + t.integer :account_id, null: false + t.integer :target_account_id, null: false + + t.timestamps null: false + end + + add_index :follows, [:account_id, :target_account_id], unique: true + end +end diff --git a/db/migrate/20160222122600_create_stream_entries.rb b/db/migrate/20160222122600_create_stream_entries.rb new file mode 100644 index 000000000..10a6862d9 --- /dev/null +++ b/db/migrate/20160222122600_create_stream_entries.rb @@ -0,0 +1,11 @@ +class CreateStreamEntries < ActiveRecord::Migration + def change + create_table :stream_entries do |t| + t.integer :account_id + t.integer :activity_id + t.string :activity_type + + t.timestamps null: false + end + end +end diff --git a/db/migrate/20160222143943_add_profile_fields_to_accounts.rb b/db/migrate/20160222143943_add_profile_fields_to_accounts.rb new file mode 100644 index 000000000..221142bdd --- /dev/null +++ b/db/migrate/20160222143943_add_profile_fields_to_accounts.rb @@ -0,0 +1,7 @@ +class AddProfileFieldsToAccounts < ActiveRecord::Migration + def change + add_column :accounts, :note, :text, null: false, default: '' + add_column :accounts, :display_name, :string, null: false, default: '' + add_column :accounts, :uri, :string, null: false, default: '' + end +end -- cgit