Don't forget to lycansubscribe
mackuba.eu
1class AddQuotesAndPins < ActiveRecord::Migration[7.2]
2 def change
3 create_table :quotes do |t|
4 t.integer "actor_id", null: false
5 t.string "rkey", limit: 13, null: false
6 t.datetime "time", null: false
7 t.text "quote_text", null: false
8 t.bigint "post_id"
9 t.string "post_uri"
10 end
11
12 add_index :quotes, [:actor_id, :time, :id], order: { time: :desc, id: :desc }
13 add_index :quotes, [:actor_id, :rkey], unique: true
14
15 create_table :pins do |t|
16 t.integer "actor_id", null: false
17 t.string "rkey", limit: 13, null: false
18 t.datetime "time", null: false
19 t.text "pin_text", null: false
20 t.bigint "post_id"
21 t.string "post_uri"
22 end
23
24 add_index :pins, [:actor_id, :time, :id], order: { time: :desc, id: :desc }
25 add_index :pins, [:actor_id, :rkey], unique: true
26 end
27end