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